major_donor_ie_statements

FPPC Form 461, Part 5 Expenditure

Data source: F461P5_Expenditures

30 rows where filer_id = 61 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, entity_type, payee_city, zipcode, expenditure_date, expenditure_amt, year_to_date, candidate_last_name, candidate_first_name, candidate_prefix, office_sought, office_jurisdiction, district_number, business_activity, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose memo_reference_number business_info_included business_name business_address_1 business_address_2 business_city business_state business_zipcode business_interest business_activity association_interest
577 577 480189 61 Clorox 495 MDI 2025-01-05 2024-01-01 2024-12-31   EXP1 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-10-25 00:00:00 145000 145000 MON   1.46777e+06 1220                 Citywide Violence Reduction Services NN City of Oakland S EXP1                 Consumer and professional products  
463 463 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14156427 RCP Bill Quirk for Assembly 2020       Sacramento CA 95814 2020-10-01 00:00:00 1000 1000 MON   1414232 698 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
464 464 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14156429 RCP Re-Elect Lynette Gibson-McElhaney for City Council 2020       Oakland CA 94607 2020-10-01 00:00:00 900 900 MON   1421347 863 Gibson-McElhaney Lynette     CCM Oakland   S       S                   Consumer Houshold Products  
465 465 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14171362 RCP Nancy Skinner for Senate 2020       Sacramento CA 95814 2020-10-06 00:00:00 1000 1000 MON   1392359 578 Skinner Nancy CA Sen.   SEN Senate District 9.0 S       S                   Consumer Houshold Products  
466 466 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14171363 RCP Cottie Petrie-Norris for Assembly 2020       Sacramento CA 95814 2020-10-06 00:00:00 1500 1500 MON   1414368 703 Petrie-Norris Cottie CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
467 467 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14176040 RCP Autumn Burke for Assembly 2020       Sacramento CA 95814 2020-10-12 00:00:00 1500 1500 MON   1414347 884 Burke Autumn CA Asm.   ASM Assembly District 62.0 S       S                   Consumer Houshold Products  
468 468 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14192880 RCP Rob Bonta for Assembly 2020       Sacramento CA 95814 2020-10-22 00:00:00 1000 2000 MON   1414291 575 Bonta Rob CA Asm.   ASM Assembly District 18.0 S       S                   Consumer Houshold Products  
469 469 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14200815 RCP OakPAC       Oakland CA 94612 2020-10-30 00:00:00 10000 10000 MON   983545 4               S       S                   Consumer Houshold Products  
470 470 480189 61 The Clorox Company 55 MDI 2021-01-04 2020-10-01 2020-12-31 2020-11-03 14221100 RCP Melissa Melendez for Lt Governor 2022       Sacramento CA 95866 2020-11-23 00:00:00 1500 1500 MON   1427815 885 Melendez Melissa CA Sen.   LTG Lt. Governor 28.0 S       S                   Consumer Houshold Products  
5 5 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8643826 RCP Waldron for Assembly 2014       San Diego CA 92119 2013-07-08 00:00:00 1500 1500 MON   1353821 105 Waldron Marie CA Asm.   ASM Assembly District 075 S       S                   Consumer Houshold Products  
6 6 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8643825 RCP Beth Gaines for Assebly 2014       Sacramento CA 95814 2013-07-08 00:00:00 1500 1500 MON   1354406 106 Gaines Beth CA Asm.   ASM Assembly District 006 S       S                   Consumer Houshold Products  
7 7 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8643824 RCP Patterson for Assembly 2014       Fresno CA 93721 2013-07-08 00:00:00 1500 1500 MON   1353680 107 Patterson Jim CA Asm.   ASM Assembly District 023 S       S                   Consumer Houshold Products  
8 8 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8749359 RCP Friends of Keith Carson       Oakland CA 94604 2013-08-12 00:00:00 1000 1000 MON   890744 108 Carson Keith     BSU Alameda Dis S       S                   Consumer Houshold Products  
9 9 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8750610 RCP Jim Frazier for Assembly 2014       Sacramento CA 95814 2013-08-14 00:00:00 1500 3000 MON   1353671 109 Frazier Jim CA Asm.   ASM Assembly District 011 S       S                   Consumer Houshold Products  
10 10 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8750611 RCP Dr. Ed Hernandez, O.D. Democrat for Senate 2014       Pasadena CA 91107 2013-08-14 00:00:00 1500 1500 MON   1333628 110 Hernandez Ed CA Sen. MD SEN Senate District 024 S       S                   Consumer Houshold Products  
11 11 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8750612 RCP Friends of Jimmy Gomez for Assembly 2014       Sacramento CA 95814 2013-08-14 00:00:00 1000 1000 MON   1354022 111 Gomez Jimmy CA Asm.   ASM Assembly District 051 S       S                   Consumer Houshold Products  
12 12 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8750613 RCP Wagner for Assembly 2014       Huntington Beach CA 92647 2013-08-14 00:00:00 1500 1500 MON   1356022 112 Wagner Donald CA Asm.   ASM Assembly District 068 S       S                   Consumer Houshold Products  
13 13 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780620 RCP Susan Bonilla ofr Assembly 2014       Sacramento CA 95814 2013-08-23 00:00:00 1500 3000 MON   1353590 113 Bonilla Susan CA Asm.   ASM Assembly District 014 S       S                   Consumer Houshold Products  
14 14 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780616 RCP Maienschein for Assembly 2014       Sacramento CA 95814 2013-08-23 00:00:00 1500 3000 MON   1354963 114 Maienschein Brian CA Asm.   ASM Assembly District 077 S       S                   Consumer Houshold Products  
15 15 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780622 RCP Kevin Mullin for Assembly 2014       Sacramento CA 95814 2013-08-23 00:00:00 1500 3000 MON   1354035 115 Mullin Kevin CA Asm.   ASM Assembly District 022 S       S                   Consumer Houshold Products  
16 16 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780617 RCP Melissa Melendez for Assembly 2014       Sacramento CA 95814 2013-08-23 00:00:00 1000 2000 MON   1353839 116 Melendez Melissa CA Asm.   ASM Assembly District 067 S       S                   Consumer Houshold Products  
17 17 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780619 RCP Brain Dahle for Assembly 2014       Willows CA 95988 2013-08-23 00:00:00 1500 1500 MON   1354659 117 Dahle Brian CA Asm.   ASM Assembly District 001 S       S                   Consumer Houshold Products  
18 18 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780621 RCP Katcho Achadjian for Assembly 2014       Sacramento CA 95814 2013-08-23 00:00:00 1500 1500 MON   1353684 118 Achadjian Katcho CA Asm.   ASM Assembly District 035 S       S                   Consumer Houshold Products  
19 19 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780623 RCP Jean Fuller for Senate 2014       Elk Grove CA 95624 2013-09-03 00:00:00 1500 1500 MON   1333812 119 Fuller Jean CA Sen.   SEN Senate District 018 S       S                   Consumer Houshold Products  
20 20 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780624 RCP Eggman for Assembly 2014       Sacramento CA 95814 2013-09-03 00:00:00 1500 3000 MON   1353605 120 Eggman Susan CA Asm.   ASM Assembly District 013 S       S                   Consumer Houshold Products  
21 21 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8780703 RCP Hueso for Senate 2014       Sacramento CA 95814 2013-09-04 00:00:00 1000 1000 MON   1353810 121 Hueso Ben CA Sen.   SEN Senate District 040 S       S                   Consumer Houshold Products  
22 22 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8800864 RCP Alejo for Assembly 2014       Sacramento CA 95814 2013-09-10 00:00:00 1000 2000 MON   1353603 122 Alejo Luis CA Asm.   ASM Assembly District 030 S       S                   Consumer Houshold Products  
23 23 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8817178 RCP Nora Campos for Assembly 2014       Sacramento CA 95814 2013-09-13 00:00:00 1500 3000 MON   1353485 123 Campos Nora CA Asm.   ASM Assembly District 027 S       S                   Consumer Houshold Products  
24 24 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8817175 RCP Kevin de Leon for Senate 2014       Sacramento CA 95814 2013-09-13 00:00:00 1000 2000 MON   1334203 124 De Leon Kevin CA Sen.   SEN Senate District 022 S       S                   Consumer Houshold Products  
25 25 480189 61 The Clorox Company 55 MDI 2013-10-18 2013-07-01 2013-09-30   8817180 RCP Torres for Senate 2014       Sacramento CA 95814 2013-09-13 00:00:00 1250 1250 MON   1350311 125 Torres Norma CA Sen.   SEN Senate District 032 S       S                   Consumer Houshold Products  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "major_donor_ie_statements" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT,
  "business_info_included" TEXT,
  "business_name" INTEGER,
  "business_address_1" TEXT,
  "business_address_2" TEXT,
  "business_city" TEXT,
  "business_state" TEXT,
  "business_zipcode" TEXT,
  "business_interest" TEXT,
  "business_activity" TEXT,
  "association_interest" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("business_name") REFERENCES [businesses](id));
CREATE INDEX ["major_donor_ie_statements_filer_id"] ON [major_donor_ie_statements]("filer_id");
CREATE INDEX ["major_donor_ie_statements_filer_name"] ON [major_donor_ie_statements]("filer_name");
CREATE INDEX ["major_donor_ie_statements_committee_id"] ON [major_donor_ie_statements]("committee_id");
CREATE INDEX ["major_donor_ie_statements_business_name"] ON [major_donor_ie_statements]("business_name");