expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

62 rows where filer_name = 79 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, payee_last_name, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, committee_id, candidate_last_name, office_sought, office_jurisdiction, district_number, ballot_measure_name, ballot_measure_jurisdiction, 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 payee_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
396 396 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT448 COM Abel Guillen (I)             2014-10-19 3651.29 89243.49 IND Staff Time; 10/19/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
397 397 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   PDT50 COM Abel Guillen (I)             2014-10-19 2594.03 89243.49 IND Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
398 398 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   PDT52 COM Abel Guillen (I)             2014-10-19 28479 89243.49 IND Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
399 399 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT449 COM Abel Guillen (I)             2014-11-01 7435.04 89243.49 IND Staff time; 11/1/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
400 400 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT451 COM Abel Guillen (I)             2014-11-01 10296.72 89243.49 IND Staff Time   Abel Guillen       CCM City of Oakland 2.0         S  
401 401 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT454 COM Abel Guillen (I)             2014-11-04 136.9 89243.49 IND Hotel Costs   Abel Guillen       CCM City of Oakland 2.0         S  
402 402 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT447 COM Annie Campbell Washington (I)             2014-10-19 3651.29 89243.48 IND Staff Time; 10/19/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
403 403 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   PDT51 COM Annie Campbell Washington (I)             2014-10-19 2594.03 89243.48 IND Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
404 404 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   PDT53 COM Annie Campbell Washington (I)             2014-10-19 28479 89243.48 IND Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
405 405 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT450 COM Annie Campbell Washington (I)             2014-11-01 7435.04 89243.48 IND Staff time; 11/1/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
406 406 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT453 COM Annie Campbell Washington (I)             2014-11-01 10296.72 89243.48 IND Staff Time   Annie Campbell Washington       CCM City of Oakland 4.0         S  
407 407 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EDT455 COM Annie Campbell Washington (I)             2014-11-04 136.9 89243.48 IND Hotel Costs   Annie Campbell Washington       CCM City of Oakland 4.0         S  
408 408 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EXP629 COM Better Transportation for Alameda County, Yes on BB       Oakland CA 94607 2014-10-22 10000 11218.28 MON   1362240 181                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County S  
409 409 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EXP635 COM Moina Shaiq for Fremont School Board 2014       Fremont CA 94529 2014-10-30 -500 500 MON Void Check 1369073 184 Moina Shaiq       OTH Fremont USD           S  
410 410 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2015-01-28 2014-10-19 2014-12-31   EXP639 COM Moina Shaiq for Fremont School Board 2014       Fremont CA 94529 2014-10-30 500 500 MON   1369073 184 Moina Shaiq       OTH Fremont USD           S  
478 478 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT42 COM Abel Guillen (I)             2014-10-01 59.85 36650.51 IND Office Space for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
479 479 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT45 COM Abel Guillen (I)             2014-10-01 515 36650.51 IND Staff Time & Food for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
480 480 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT46 COM Abel Guillen (I)             2014-10-01 10167.21 36650.51 IND Field Campaign; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
481 481 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT48 COM Abel Guillen (I)             2014-10-01 87 36650.51 IND Auto Dialer for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
482 482 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT43 COM Annie Campbell Washington (I)             2014-10-01 59.85 36650.5 IND Office Space for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
483 483 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT44 COM Annie Campbell Washington (I)             2014-10-01 515 36650.5 IND Staff Time & Food for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
484 484 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT47 COM Annie Campbell Washington (I)             2014-10-01 10167.21 36650.5 IND Field Campaign; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
485 485 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT49 COM Annie Campbell Washington (I)             2014-10-01 87 36650.5 IND Auto Dialer for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
486 486 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 EXP618 COM Dianne Martinez for City Council 2014       Emeryville CA 94662 2014-10-14 250 250 MON   1366707 185 Dianne Martinez       CCM City of Emeryville           S  
487 487 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 EXP620 COM Moina Shaiq for Fremont School Board 2014       Concord CA 94529 2014-10-14 500 500 MON   1369073 184 Moina Shaiq       OTH Fremont USD           S  
488 488 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 EXP619 COM Scott Donahue for City Council 2014       Emeryville CA 94608 2014-10-14 250 250 MON   1366849 186 Scott Donahue       CCM City of Emeryville           S  
584 584 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT435 COM Abel Guillen (I)             2014-09-18 3654.85 25821.45 IND Doorhangers   Abel Guillen       CCM City of Oakland 2.0         S  
585 585 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT34 COM Abel Guillen (I)             2014-09-18 39.9 25821.45 IND Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
586 586 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT36 COM Abel Guillen (I)             2014-09-18 87 25821.45 IND Auto Dialer for Phonebanking; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
587 587 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT38 COM Abel Guillen (I)             2014-09-18 21525 25821.45 IND Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
588 588 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT439 COM Abel Guillen (I)             2014-09-27 337.5 25821.45 IND Room Rent for Phonebanking; 9/27/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
589 589 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT40 COM Abel Guillen (I)             2014-09-27 177.2 25821.45 IND Staff Time & Food for Phonebanking   Abel Guillen       CCM City of Oakland 2.0         S  
590 590 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP572 COM Abel Guillen for Oakland City Council 2014       Oakland CA 94609 2014-09-22 1400 1400 MON   1365384 169 Abel Guillen       CCM City of Oakland 2.0         S  
591 591 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP584 COM Al Nagy for Mayor 2014       Newark CA 94560 2014-09-22 500 500 MON   Pending 38 Al Nagy       MAY City of Newark           S  
592 592 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT436 COM Annie Campbell Washington (I)             2014-09-18 3654.84 25821.44 IND Doorhangers   Annie Campbell Washington       CCM City of Oakland 4.0         S  
593 593 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT35 COM Annie Campbell Washington (I)             2014-09-18 39.9 25821.44 IND Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
594 594 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT37 COM Annie Campbell Washington (I)             2014-09-18 87 25821.44 IND Auto Dialer for Phonebanking; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
595 595 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT39 COM Annie Campbell Washington (I)             2014-09-18 21525 25821.44 IND Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
596 596 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT440 COM Annie Campbell Washington (I)             2014-09-27 337.5 25821.44 IND Room Rent for Phonebanking; 9/27/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
597 597 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT41 COM Annie Campbell Washington (I)             2014-09-27 177.2 25821.44 IND Staff Time & Food for Phonebanking   Annie Campbell Washington       CCM City of Oakland 4.0         S  
598 598 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP571 COM Annie Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 1400 1400 MON   1365610 155 Anne Campbell Washington       CCM City of Oakland 4.0         S  
599 599 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT438 COM Better Transportation for Alameda County       Oakland CA 94607 2014-09-18 1218.28 1218.28 IKD Doorhangers 1362240 181                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County S  
600 600 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP582 COM Bonaccorsi for Fremont City Council 2014       Fremont CA 94538 2014-09-22 570 570 MON   1368328 204 David Paul Bonaccorsi       CCM City of Fremont           S  
601 601 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP574 COM Bowser for Pleasanton School Board 2014       Pleasanton CA 94566 2014-09-22 1000 1000 MON   1367972 205 Jeff Bowser       OTH Pleasanton USD           S  
602 602 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP576 COM Brenda Roberts for Oakland City Auditor 2014       Oakland CA 94610 2014-09-22 1000 1000 MON   1368410 156 Brenda Roberts       OTH City of Oakland           S  
603 603 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP586 COM Bucci for Newark Council 2014       Newark CA 94560 2014-09-22 500 500 MON   137683 206 Mike Bucci       CCM City of Newark           S  
604 604 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP585 COM Francisco Preciado Jr. for Newark City Council 2014       Newark CA 94560 2014-09-22 500 500 MON   1370361 166 Francisco Preciado       CCM City of Newark           S  
605 605 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP579 COM Gilmore for Mayor 2014       Sacramento CA 95815 2014-09-22 1000 1200 MON   1323448 196 Marie Gilmore       MAY City of Alameda           S  
606 606 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP583 COM Gilmore for Mayor 2014       Sacramento CA 95815 2014-09-22 200 1200 MON   1323448 196 Marie Gilmore       MAY City of Alameda           S  
607 607 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP555 COM Jim Oddie for Alameda City Council 2014       Alameda CA 94501 2014-08-19 1000 1000 MON   1367465 197 Jim Oddie       CCM City of Alameda           S  
608 608 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP556 COM Julina Bonilla for Peralta Board of Trustees 2014       Oakland CA 94606 2014-08-19 5000 5000 MON   1366564 207 Julina Bonilla       OTH Peralta Community College District 7.0         S  
609 609 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP573 COM Laursen for School Board 2014       Pleasanton CA 94566 2014-09-22 1000 1000 MON   1366983 208 Joan Laursen       OTH Pleasanton USD           S  
610 610 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT437 COM Lift Up Oakland - Yes on Measure FF - for better wages, healthy families & a healthy economy spons. by labor & community orgs       Sacramento CA 95814 2014-09-18 1218.28 1718.28 IKD Doorhangers 1364564 209                 Establishing a minimum wage, requiring payment for accrued sick leave, and requiring payment for service charges to hospitality workers. Measure FF.   City of Oakland S  
611 611 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP559 COM Nancy O'Malley for District Attorney 2014       Alameda CA 94501 2014-08-19 250 250 MON   1322240 157 Nancy O'Malley       DAT Alameda County           S  
612 612 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP575 COM Olivia Sanwong for Pleasanton City Council 2014       Oakland CA 94618 2014-09-22 1000 1000 MON   1355629 210 Olivia Sanwong       CCM City of Pleasanton           S  
613 613 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP581 COM Raj Salwan for Fremont City Council 2014       Fremont CA 94536 2014-09-22 570 570 MON   1361059 211 Raj Salwan       CCM City of Fremont           S  
614 614 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP558 COM Singh for AC Transit Board 2014       Fremont CA 94538 2014-08-19 1000 1000 MON   1369152 212 Kewal Singh       OTH Alameda-Contra Costa Transit Board 5.0         S  
615 615 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP578 COM Solana Henneberry for AUSD School Board 2014       Alameda CA 94501 2014-09-22 1000 1000 MON   1367459 213 Solana Henneberry       OTH Alameda Unified School Board Election           S  
616 616 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP554 COM Stewart Chen for Alameda City Council 2014       Alameda CA 94501 2014-08-19 1000 1000 MON   1349155 200 Stewart Chen       CCM City of Alameda           S  
617 617 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP553 COM Tam for BART 2014       Alameda CA 94501 2014-08-19 5000 5000 MON   1362183 214 Lena Tam       OTH Bay Area Rapid Transit Board 4.0         S  
618 618 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP580 COM Yes on AA, Supported by Nate Miley, with major funding from Local Hospitals and Heathcare Workers Committee for a Healthy Alameda County     Oakland CA 94611 2014-09-22 500 500 MON   1362028 215                 Healthcare Services Sales Tax, Measure AA   Alameda County S  
619 619 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP593 COM Young for EBMUD Director 2014       Oakland CA 94609 2014-09-25 650 650 MON   1367363 216 Marguerite Young       OTH East Bay Municipal Utility District 3.0         S  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "expenditure_summaries" (
"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,
  "payee_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
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id));
CREATE INDEX ["expenditure_summaries_filer_id"] ON [expenditure_summaries]("filer_id");
CREATE INDEX ["expenditure_summaries_filer_name"] ON [expenditure_summaries]("filer_name");
CREATE INDEX ["expenditure_summaries_committee_id"] ON [expenditure_summaries]("committee_id");