major_donor_ie_statements

FPPC Form 461, Part 5 Expenditure

Data source: F461P5_Expenditures

261 rows where filer_id = 59 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, election_date, entity_type, payee_city, payee_state, zipcode, expenditure_amt, year_to_date, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, ballot_measure_name, 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
386 386 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12562722 COM Re-Elect Senator Wieckowski for Senate 2018       Sacramento CA 95814 2018-02-05 00:00:00 1300 1300 MON   1374486 346 Wieckowski Bob CA Sen.   SEN Senate District 10.0 S       S                   Consumer Houshold Products  
387 387 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12562727 COM Pat Bates for Senate 2018       Sacramento CA 95814 2018-02-05 00:00:00 1500 1500 MON   1374577 527 Bates Patricia CA Sen.   SEN Senate District 36.0 S       S                   Consumer Houshold Products  
388 388 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12562718 COM Cristina Garcia for Assembly 2018       Sacramento CA 95814 2018-02-06 00:00:00 1500 1500 MON   1393064 518 Garcia Cristina CA Asm.   ASM Assembly District 58.0 S       S                   Consumer Houshold Products  
389 389 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12562717 COM Sabrina Cervantes for Assembly 2018       Sacramento CA 95814 2018-02-06 00:00:00 1000 1000 MON   1392561 523 Cervantes Sabrina CA Asm.   ASM Assembly District 60.0 S       S                   Consumer Houshold Products  
390 390 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12562716 COM Al Muratsuchi for Assembly 2018       Sacramento CA 95814 2018-02-06 00:00:00 1000 1000 MON   1392662 668 Muratsuchi Al CA Asm.   ASM Assembly District 66.0 S       S                   Consumer Houshold Products  
391 391 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12576930 COM Sharon Quirk-Silva for Assembly 2018       Sacramento CA 95814 2018-02-09 00:00:00 1200 1200 MON   1392962 543 Quirk-Silva Sharon CA Asm.   ASM Assembly District 65.0 S       S                   Consumer Houshold Products  
392 392 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12576931 COM Phillip Chen for Assembly 2018       Sacramento CA 95814 2018-02-09 00:00:00 1500 1500 MON   1392379 533 Chen Phillip CA Asm.   ASM Assembly District 55.0 S       S                   Consumer Houshold Products  
393 393 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12576929 COM Jeff Stone for Senate 2018       Riverside CA 92507 2018-02-09 00:00:00 2000 2000 MON   1374274 522 Stone Jeff CA Sen.   SEN Senate District 28.0 S       S                   Consumer Houshold Products  
394 394 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12599667 COM Jim Frazier for Assembly 2018       Sacramento CA 95814 2018-02-13 00:00:00 1300 1300 MON   1392652 525 Frazier Jim CA Asm.   ASM Assembly District 11.0 S       S                   Consumer Houshold Products  
395 395 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12599668 COM Marc Steinorth for Assembly 2018       Sacramento CA 95814 2018-02-13 00:00:00 1500 1500 MON   1392851 537 Steinorth Marc CA Asm.   ASM Assembly District 40.0 S       S                   Consumer Houshold Products  
396 396 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12599666 COM Cecilia Aguiar-Curry for Assembly 2018       Sacramento CA 95814 2018-02-15 00:00:00 1300 1300 MON   1392362 517 Aguiar-Curry Cecilia CA Asm.   ASM Assembly District 4.0 S       S                   Consumer Houshold Products  
397 397 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12600668 COM Friends of Frank Bigelow for Assembly 2018       Sacramento CA 95814 2018-02-20 00:00:00 1500 1500 MON   1392565 535 Bigelow Franklin CA Asm.   ASM Assembly District 5.0 S       S                   Consumer Houshold Products  
398 398 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12600669 COM Janet Nguyen for Senate 2018       Sacramento CA 95814 2018-02-20 00:00:00 1500 1500 MON   1373835 538 Nguyen Janet CA Sen.   SEN Senate District 34.0 S       S                   Consumer Houshold Products  
399 399 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12600681 COM Dr. Richard Pan for Senator 2018       Sacramento CA 95814 2018-02-21 00:00:00 1300 1300 MON   1374058 542 Pan Richard CA Sen.   SEN Senate District 6.0 S       S                   Consumer Houshold Products  
400 400 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12601177 COM Re-Elect Assemblyman Matthew Harper 2018       Sacramento CA 95814 2018-02-23 00:00:00 1500 1500 MON   1393131 531 Harper Matthew CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
401 401 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12606604 COM Chad Mayes for Assembly 2018       Sacramento CA 95814 2018-02-28 00:00:00 1500 1500 MON   1392882 530 Mayes Chad CA Asm.   ASM Assembly District 42.0 S       S                   Consumer Houshold Products  
402 402 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12606603 COM Jay Obernolte for Assembly 2018       Sacramento CA 95814 2018-02-28 00:00:00 1500 1500 MON   1392884 532 Obernolte Jay CA Asm.   ASM Assembly District 33.0 S       S                   Consumer Houshold Products  
403 403 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12606605 COM Melissa Melendez for Assembly 2018       Sacramento CA 95814 2018-02-28 00:00:00 1500 1500 MON   1392806 534 Melendez Melissa CA Asm.   ASM Assembly District 67.0 S       S                   Consumer Houshold Products  
404 404 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12632750 COM Laura Friedman for Assembly 2018       Sacramento CA 95814 2018-03-08 00:00:00 1300 1300 MON   1392556 669 Friedman Laura CA Asm.   ASM Assembly District 43.0 S       S                   Consumer Houshold Products  
405 405 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12633865 COM Bill Quirk for Assembly 2018       Sacramento CA 95814 2018-03-13 00:00:00 1300 1300 MON   1392630 515 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
406 406 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12633863 COM Catharine Baker for Assembly 2018       Sacramento ca 95814 2018-03-13 00:00:00 1500 1500 MON   1392518 524 Baker Catharine CA Asm.   ASM Assembly District 16.0 S       S                   Consumer Houshold Products  
407 407 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   12633867 COM Eggman for Assembly 2018       Sacramento CA 95814 2018-03-13 00:00:00 1500 1500 MON   1393824 670 Eggman Susan CA Asm.   ASM Assembly District 13.0 S       S                   Consumer Houshold Products  
243 243 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   12276062 COM Bill Quirk for Assembly 2018       Sacramento CA 95814 2017-08-29 00:00:00 -1300 2600 MON   1392630 515 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
244 244 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   12276064 COM Bill Quirk for Assembly 2018       Sacramento CA 95814 2017-08-29 00:00:00 1300 2600 MON   1392630 515 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
251 251 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11883492 COM Maienschein for Assembly 2018       Sacramento CA 95814 2017-04-10 00:00:00 2000 4000 MON   1392735 516 Maienschein Brian CA Asm.   ASM Assembly District 77.0 S       S                   Consumer Houshold Products  
252 252 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973723 COM Re-Elect Senator Wieckowski for Senate 2018       Sacramento CA 95814 2017-05-19 00:00:00 1200 1200 MON   1374486 346 Wieckowski Bob CA Sen.   SEN Senate District 10.0 S       S                   Consumer Houshold Products  
253 253 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973724 COM Cecilia Aguiar-Curry for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1300 2600 MON   1392362 517 Aguiar-Curry Cecilia CA Asm.   ASM Assembly District 4.0 S       S                   Consumer Houshold Products  
254 254 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973726 COM Cristina Garcia for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1500 1500 MON   1393064 518 Garcia Cristina CA Asm.   ASM Assembly District 58.0 S       S                   Consumer Houshold Products  
255 255 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973728 COM Blanca Rubio for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1500 1500 MON   1393364 519 Rubio Blanca CA Asm.   ASM Assembly District 48.0 S       S                   Consumer Houshold Products  
256 256 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973729 COM Jim Cooper for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1500 1500 MON   1392388 520 Cooper Jim CA Asm.   ASM Assembly District 9.0 S       S                   Consumer Houshold Products  
257 257 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973725 COM Rodriguez for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1250 1250 MON   1392709 521 Rodriguez Freddie CA Asm.   ASM Assembly District 52.0 S       S                   Consumer Houshold Products  
258 258 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973727 COM Jeff Stone for Senate 2018       Riverside CA 92507 2017-05-19 00:00:00 2000 2000 MON   1374274 522 Stone Jeff CA Sen.   SEN Senate District 28.0 S       S                   Consumer Houshold Products  
259 259 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973730 COM Sabrina Cervantes for Assembly 2018       Sacramento CA 95814 2017-05-19 00:00:00 1000 1000 MON   1392561 523 Cervantes Sabrina CA Asm.   ASM Assembly District 60.0 S       S                   Consumer Houshold Products  
260 260 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11973731 COM Catharine Baker for Assembly 2018       Sacramento ca 95814 2017-05-19 00:00:00 1500 1500 MON   1392518 524 Baker Catharine CA Asm.   ASM Assembly District 16.0 S       S                   Consumer Houshold Products  
261 261 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993489 COM Jim Frazier for Assembly 2018       Sacramento CA 95814 2017-06-01 00:00:00 1300 2600 MON   1392652 525 Frazier Jim CA Asm.   ASM Assembly District 11.0 S       S                   Consumer Houshold Products  
262 262 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993488 COM Bill Quirk for Assembly 2018       Sacramento CA 95814 2017-06-01 00:00:00 1300 2600 MON   1392630 515 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
263 263 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993490 COM Hertzberg for Senate 2018       Sacramento CA 95814 2017-06-01 00:00:00 1000 1000 MON   1373423 526 Hertzberg Robert CA Sen.   SEN Senate District 18.0 S       S                   Consumer Houshold Products  
264 264 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993492 COM Pat Bates for Senate 2018       Sacramento CA 95814 2017-06-01 00:00:00 3000 3000 MON   1374577 527 Bates Patricia CA Sen.   SEN Senate District 36.0 S       S                   Consumer Houshold Products  
265 265 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993491 COM Rocky Chavez for Assembly 2018       Sacramento CA 95814 2017-06-01 00:00:00 1500 1500 MON   1392924 528 Chavez Rocky CA Asm.   ASM Assembly District 76.0 S       S                   Consumer Houshold Products  
266 266 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   11993485 COM Dr. Weber for State Assembly 2018       Sacramento CA 95814 2017-06-01 00:00:00 1300 1300 MON   1393376 529 Weber Shirley CA Asm.   ASM Assembly District 79.0 S       S                   Consumer Houshold Products  
267 267 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019249 COM Chad Mayes for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 3000 MON   1392882 530 Mayes Chad CA Asm.   ASM Assembly District 42.0 S       S                   Consumer Houshold Products  
268 268 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019245 COM Re-Elect Assemblyman Matthew Harper 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 3000 MON   1393131 531 Harper Matthew CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
269 269 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019246 COM Jay Obernolte for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 3000 MON   1392884 532 Obernolte Jay CA Asm.   ASM Assembly District 33.0 S       S                   Consumer Houshold Products  
270 270 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019248 COM Phillip Chen for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 3000 MON   1392379 533 Chen Phillip CA Asm.   ASM Assembly District 55.0 S       S                   Consumer Houshold Products  
271 271 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019247 COM Maienschein for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 2000 4000 MON   1392735 516 Maienschein Brian CA Asm.   ASM Assembly District 77.0 S       S                   Consumer Houshold Products  
272 272 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019348 COM Melissa Melendez for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 1500 MON   1392806 534 Melendez Melissa CA Asm.   ASM Assembly District 67.0 S       S                   Consumer Houshold Products  
273 273 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019349 COM Friends of Frank Bigelow for Assembly 2018       Sacramento CA 9 2017-06-13 00:00:00 1500 1500 MON   1392565 535 Bigelow Franklin CA Asm.   ASM Assembly District 5.0 S       S                   Consumer Houshold Products  
274 274 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019300 COM Mendoza for Senate 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 1500 MON   1373700 536 Mendoza Tony CA Sen.   SEN Senate District 32.0 S       S                   Consumer Houshold Products  
275 275 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019396 COM Marc Steinorth for Assembly 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 1500 MON   1392851 537 Steinorth Marc CA Asm.   ASM Assembly District 40.0 S       S                   Consumer Houshold Products  
276 276 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12019350 COM Janet Nguyen for Senate 2018       Sacramento CA 95814 2017-06-13 00:00:00 1500 1500 MON   1373835 538 Nguyen Janet CA Sen.   SEN Senate District 34.0 S       S                   Consumer Houshold Products  
277 277 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12035134 COM Todd Gloria for Assembly 2018       Encinatas CA 92024 2017-06-20 00:00:00 1200 1200 MON   1392977 539 Gloria Todd CA Asm.   ASM Assembly District 78.0 S       S                   Consumer Houshold Products  
278 278 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12038570 COM Connie Leyva for Senate 2018       Sacramento CA 95814 2017-06-23 00:00:00 1500 1500 MON   1374053 540 Leyva Connie CA Sen.   SEN Senate District 20.0 S       S                   Consumer Houshold Products  
279 279 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   12038569 COM Ash Kalra for California Assembly 2018       Sacramento CA 95814 2017-06-23 00:00:00 1300 1300 MON   1393660 541 Kalra Ash CA Asm.   ASM Assembly District 27.0 S       S                   Consumer Houshold Products  
280 280 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11786801 COM Chad Mayes for Assembly 2018       Sacramento CA 95814 2017-02-21 00:00:00 1500 1500 MON   1392882 530 Mayes Chad CA Asm.   ASM Assembly District 42.0 S       S                   Consumer Houshold Products  
281 281 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11786804 COM Jim Frazier for Assembly 2018       Sacramento CA 95814 2017-02-21 00:00:00 1300 1300 MON   1392652 525 Frazier Jim CA Asm.   ASM Assembly District 11.0 S       S                   Consumer Houshold Products  
282 282 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11786805 COM Cecilia Aguiar-Curry for Assembly 2018       Sacramento CA 95814 2017-02-21 00:00:00 1300 1300 MON   1392362 517 Aguiar-Curry Cecilia CA Asm.   ASM Assembly District 4.0 S       S                   Consumer Houshold Products  
283 283 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11786803 COM Dr. Richard Pan for Senator 2018       Sacramento CA 95814 2017-02-21 00:00:00 1300 1300 MON   1374058 542 Pan Richard CA Sen.   SEN Senate District 6.0 S       S                   Consumer Houshold Products  
284 284 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11786802 COM Re-Elect Assemblyman Matthew Harper 2018       Sacramento CA 95814 2017-02-21 00:00:00 1500 1500 MON   1393131 531 Harper Matthew CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
285 285 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11835660 COM Sharon Quirk-Silva for Assembly 2018       Sacramento CA 95814 2017-03-17 00:00:00 1200 1200 MON   1392962 543 Quirk-Silva Sharon CA Asm.   ASM Assembly District 65.0 S       S                   Consumer Houshold Products  
286 286 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11835661 COM Bill Quirk for Assembly 2018       Sacramento CA 95814 2017-03-17 00:00:00 1300 1300 MON   1392630 515 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
287 287 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11835662 COM Jay Obernolte for Assembly 2018       Sacramento CA 95814 2017-03-17 00:00:00 1500 1500 MON   1392884 532 Obernolte Jay CA Asm.   ASM Assembly District 33.0 S       S                   Consumer Houshold Products  
288 288 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11835663 COM Phillip Chen for Assembly 2018       Sacramento CA 95814 2017-03-17 00:00:00 1500 1500 MON   1392379 533 Chen Phillip CA Asm.   ASM Assembly District 55.0 S       S                   Consumer Houshold Products  
289 289 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   11835673 COM Rob Bonta for Assembly 2018       Sacramento CA 95814 2017-03-17 00:00:00 1300 1300 MON   1392389 544 Bonta Rob CA Asm.   ASM Assembly District 18.0 S       S                   Consumer Houshold Products  
200 200 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11341697 COM Jay Obernolte for Assembly 2016       Sacramento CA 95814 2016-07-26 00:00:00 1500 3000 MON   1.37409e+06 497 Obernolte Jay CA Asm.   ASM Assembly District 33.0 S       S                   Consumer Houshold Products  
201 201 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11341698 COM Chad Mayes for Assembly 2016       Sacramento CA 95814 2016-07-26 00:00:00 1500 3000 MON   1.3741e+06 486 Mayes Chad CA Asm.   ASM Assembly District 42.0 S       S                   Consumer Houshold Products  
202 202 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11408869 COM Rob Bonta for Assembly 2016       Sacramento CA 95814 2016-08-29 00:00:00 1300 2600 MON   1.37343e+06 338 Bonta Rob CA Asm.   ASM Assembly District 18.0 S       S                   Consumer Houshold Products  
203 203 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11408872 COM Garcia for Assembly 2016       Sacramento CA 95814 2016-08-29 00:00:00 1500 3000 MON   1.37356e+06 483 Garcia Cristina CA Asm.   ASM Assembly District 58.0 S       S                   Consumer Houshold Products  
204 204 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11408873 COM Autumn Burke for Assembly 2016       Sacramento CA 95814 2016-08-29 00:00:00 1500 3000 MON   1.37356e+06 483 Burke Autumn CA Asm.   ASM Assembly District 62.0 S       S                   Consumer Houshold Products  
205 205 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11408871 COM Maienschein for Assembly 2016       Sacramento CA 95814 2016-08-29 00:00:00 1500 1500 MON   1.37422e+06 501 Maienschein Brian CA Asm.   ASM Assembly District 77.0 S       S                   Consumer Houshold Products  
206 206 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11408870 COM Catharine Baker for Assembly 2016       Sacramento CA 95814 2016-08-29 00:00:00 1000 2500 MON   1.3738e+06 495 Baker Catharine CA Asm.   ASM Assembly District 16.0 S       S                   Consumer Houshold Products  
207 207 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11463459 COM Adrin Nazarian for Assembly 2016       Sacramento CA 95814 2016-09-19 00:00:00 1000 2000 MON   1.37442e+06 487 Nazarian Adrin CA Asm.   ASM Assembly District 46.0 S       S                   Consumer Houshold Products  
208 208 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   11491183 COM Jim Frazier for Assembly 2016       Fairfield CA 94534 2016-10-05 00:00:00 500 500 MON   1.37343e+06 338 Frazier Jim CA Asm.   ASM Assembly District 11.0 S       S                   Consumer Houshold Products  
167 167 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10899396 COM Eggman for Assembly 2016       Sacramento CA 95814 2016-01-26 00:00:00 1500 1500 MON   1.37378e+06 480 Eggman Susan CA Asm.   ASM Assembly District 13.0 S       S                   Consumer Houshold Products  
168 168 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10899395 COM Re-Elect Assemblyman Matthew Harper 2016       Sacramento CA 95814 2016-01-26 00:00:00 1500 1500 MON   1.37467e+06 481 Harper Matthew CA Asm.   ASM Assembly District 74.0 S       S                   Consumer Houshold Products  
169 169 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10899393 COM Tony Thurmond for Assembly 2016       Sacramento CA 95814 2016-01-26 00:00:00 1500 1500 MON   1.37377e+06 341 Thurmond Tony CA Asm.   ASM Assembly District 15.0 S       S                   Consumer Houshold Products  
170 170 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10899394 COM Gipson for Assembly 2016       Sacramento CA 95814 2016-01-26 00:00:00 1500 1500 MON   1.37383e+06 482 Gipson Mike CA Asm.   ASM Assembly District 64.0 S       S                   Consumer Houshold Products  
171 171 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927857 COM Rob Bonta for Assembly 2016       Sacramento CA 95814 2016-02-01 00:00:00 1300 1300 MON   1.37343e+06 338 Bonta Rob CA Asm.   ASM Assembly District 18.0 S       S                   Consumer Houshold Products  
172 172 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927858 COM Autumn Burke for Assembly 2016       Sacramento CA 95814 2016-02-01 00:00:00 1500 1500 MON   1.37356e+06 483 Burke Autumn CA Asm.   ASM Assembly District 62.0 S       S                   Consumer Houshold Products  
173 173 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927853 COM Young Kim for Assembly 2016       Sacramento CA 95814 2016-02-02 00:00:00 1500 1500 MON   1.37392e+06 484 Kim Young CA Asm.   ASM Assembly District 65.0 S       S                   Consumer Houshold Products  
174 174 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927855 COM Garcia for Assembly 2016       Sacramento CA 95814 2016-02-02 00:00:00 1500 1500 MON   1.37356e+06 483 Garcia Cristina CA Asm.   ASM Assembly District 58.0 S       S                   Consumer Houshold Products  
175 175 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927854 COM Kevin Mullin for Assembly 2016       Sacramento CA 95814 2016-02-02 00:00:00 1500 1500 MON   1.37341e+06 485 Mullin Kevin CA Asm.   ASM Assembly District 22.0 S       S                   Consumer Houshold Products  
176 176 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927856 COM Chad Mayes for Assembly 2016       Sacramento CA 95814 2016-02-02 00:00:00 1500 1500 MON   1.3741e+06 486 Mayes Chad CA Asm.   ASM Assembly District 42.0 S       S                   Consumer Houshold Products  
177 177 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 10927932 COM Adrin Nazarian for Assembly 2016       Sacramento CA 95814 2016-02-04 00:00:00 1000 1000 MON   1.37442e+06 487 Nazarian Adrin CA Asm.   ASM Assembly District 46.0 S       S                   Consumer Houshold Products  
178 178 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11002723 COM Jim Beall for Senate 2016       Sacramento CA 95814 2016-03-03 00:00:00 1200 1200 MON   1.35458e+06 488 Beall Jim CA Sen. Jr. SEN Senate District 15.0 S       S                   Consumer Houshold Products  
179 179 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11002724 COM Marc Steinorth for Assembly 2016       Sacramento CA 95814 2016-03-03 00:00:00 1500 1500 MON   1.37371e+06 489 Steinorth Marc CA Asm.   ASM Assembly District 40.0 S       S                   Consumer Houshold Products  
180 180 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11002725 COM Bill Quirk for Assembly 2016       Sacramento CA 95814 2016-03-03 00:00:00 1300 1300 MON   1.37366e+06 333 Quirk Bill CA Asm.   ASM Assembly District 20.0 S       S                   Consumer Houshold Products  
181 181 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11016737 COM Bill Brough for State Assembly 2016       Sacramento CA 95814 2016-03-08 00:00:00 1500 1500 MON   1.3736e+06 490 Brough Bill CA Asm.   ASM Assembly District 73.0 S       S                   Consumer Houshold Products  
182 182 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11016985 COM Sharon Runner for Senate 2016       Sacramento CA 95814 2016-03-10 00:00:00 1500 0 MON   1.37651e+06 491 Runner Sharon CA Sen.   SEN Senate District 21.0 S       S                   Consumer Houshold Products  
183 183 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11052140 COM California Chamber of Commerce PAC       Sacramento CA 95814 2016-03-18 00:00:00 5000 5000 MON   950352 392                       S                   Consumer Houshold Products  
184 184 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11053901 COM Sharon Runner for Senate 2016       Sacramento CA 95814 2016-03-21 00:00:00 -1500 0 MON   1.37651e+06 491 Runner Sharon CA Sen.   SEN Senate District 21.0 S       S                   Consumer Houshold Products  
185 185 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11139228 COM Cheryl R. Brown for Assembly 2016       Sacramento CA 95814 2016-05-03 00:00:00 1500 1500 MON   1.37399e+06 492 Brown Cheryl CA Asm.   ASM Assembly District 47.0 S       S                   Consumer Houshold Products  
186 186 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11139229 COM Rodriguez for Assembly 2016       Sacramento CA 95814 2016-05-03 00:00:00 1250 1250 MON   1.37332e+06 493 Rodriguez Freddie CA Asm.   ASM Assembly District 52.0 S       S                   Consumer Houshold Products  
187 187 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11161727 COM Jim Cooper for Assembly 2016       Sacramento CA 95814 2016-05-10 00:00:00 1500 1500 MON   1.37347e+06 494 Cooper Jim CA Asm.   ASM Assembly District 9.0 S       S                   Consumer Houshold Products  
188 188 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11162683 COM Catharine Baker for Assembly 2016       Sacramento CA 95814 2016-05-12 00:00:00 1500 1500 MON   1.3738e+06 495 Baker Catharine CA Asm.   ASM Assembly District 16.0 S       S                   Consumer Houshold Products  
189 189 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11177974 COM Bill Monning for Senate 2016       Sacramento CA 95814 2016-05-20 00:00:00 1200 1200 MON   1.35354e+06 496 Monning Bill CA Sen.   SEN Senate District 17.0 S       S                   Consumer Houshold Products  
190 190 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11181938 COM Jay Obernolte for Assembly 2016       Sacramento CA 95814 2016-05-24 00:00:00 1500 1500 MON   1.37409e+06 497 Obernolte Jay CA Asm.   ASM Assembly District 33.0 S       S                   Consumer Houshold Products  
191 191 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11181939 COM Jones-Sawyer for Assembly 2016       Sacramento CA 95814 2016-05-24 00:00:00 1500 1500 MON   1.37357e+06 498 Jones-Sawyer Reginald CA Asm. Sr. ASM Assembly District 59.0 S       S                   Consumer Houshold Products  
192 192 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11181941 COM The Committee to Keep BART Safe & Reliable 2016       Oakland CA 94618 2016-05-24 00:00:00 10000 10000 MON   1.38122e+06 499                 The Committee to Keep BART Safe & Reliable 2016     S                   Consumer Houshold Products  
193 193 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11196967 COM Friends of Frank Bigelow for Assembly 2016       Sacramento CA 95814 2016-06-02 00:00:00 1500 1500 MON   1.37372e+06 500 Bigelow Franklin CA Asm.   ASM Assembly District 5.0 S       S                   Consumer Houshold Products  
194 194 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 11228546 COM Nate Miley for Supervisor       Oakland CA 94604 2016-06-14 00:00:00 500 500 MON   992285 99 Miley Nate     BSU Alameda   S       S                   Consumer Houshold Products  

Next page

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");