contribution_reports_24_hours

FPPC Form 497

Data source: 497

69 rows where filer_id = 81 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, entity_type, entity_city, entity_state, entity_zipcode, amount, office_sought, office_jurisdiction, district_number, ballot_measure_name, ballot_measure_jurisdiction, report_date (date), contribution_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type entity_last_name entity_first_name entity_prefix entity_suffix entity_city entity_state entity_zipcode contributor_employer contributor_occupation contributor_self_employed contribution_date amount 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 memo_reference_number
954 954 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1104 COM Friends of Oakland Public Schools, Yes on Y       Oakland CA 94607       2020-10-26 00:00:00 1000 960997 163                 School Bond Measure Y   Oakland Unified School District  
955 955 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1103 COM Gallo for Oakland City Council 2020 Re-Elect Noel     Oakland CA 94607       2020-10-26 00:00:00 1700 1429205 841 Noel Gallo       CCM City of Oakland 5          
956 956 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1101 COM Gonzales for New Haven USD School Board, District 3 Michael     Union City CA 94587       2020-10-26 00:00:00 1000 1428099 842 Michael Gonzales       OTH New Haven Unified School District 3          
957 957 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1099 COM Jim Oddie for Alameda City Council 2020       Alameda CA 94501       2020-10-26 00:00:00 5000 1367465 197 Jim Oddie       CCM City of Alameda            
958 958 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1102 COM Kalb for Oakland City Council District 1       Oakland CA 94618       2020-10-26 00:00:00 1700 1420085 843 Dan Kalb       CCM City of Oakland 1          
959 959 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1100 COM Shuen-Mallory for New Haven USD School Board, District 2 Melissa     Union City CA 94587       2020-10-26 00:00:00 1000 1427373 844 Melissa Shuen-Mallory       OTH New Haven Unified School District 24          
960 960 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1098 COM Vella for Alameda City Council 2020 Malia     Alameda CA 94501       2020-10-26 00:00:00 5000 1381924 845 Malia Vella       CCM City of Alameda            
961 961 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-26       EXP1089 COM Yes on Measure Z - Alamedans for Housing Support       Alameda CA 94501       2020-10-26 00:00:00 1000 1433417 846                 City Charter to repeal the prohibition against the building of multi-family housing in Alameda   City of Alameda Measure Z  
990 990 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1086 COM Aney for Alameda USD School Board 2020 Beth     Alameda CA 94501       2020-10-19 00:00:00 1000 1431819 848 Beth Aney       OTH Alameda Unified School District            
991 991 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1087 COM Castro for Alameda Unified School Board 2020       Alameda CA 94501       2020-10-19 00:00:00 1000 1431543 849 Verna Castro       OTH Alameda Unified School District            
992 992 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1092 COM Davis for Oakland School Board 2020 Sam     Oakland CA 94608       2020-10-19 00:00:00 1700 1419930 800 Sam Davis       OTH Oakland Unified School District 1          
993 993 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1091 COM Echols for East Bay Regional Parks Board 2020 Elizabeth     Pleasanton CA 94566       2020-10-19 00:00:00 1000 1428397 850 Elizabeth Echols       OTH East Bay Regional Parks            
994 994 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1094 COM Hutchinson for Oakland School Board 2020 Mike     Oakland CA 94602       2020-10-19 00:00:00 1700 1429072 851 Mike Hutchinson       OTH Oakland Unified School District 5          
995 995 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1088 COM Little for Alameda Board of Education 2020 Heather     Alameda CA 94501       2020-10-19 00:00:00 1000 1429119 852 Heather Little       OTH Alameda Unified School District            
996 996 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1095 COM Tapscott for Oakland School Board 2020 Ben 'Coach'     Oakland CA 94605       2020-10-19 00:00:00 1700 1430904 853 Ben Tapscott       OTH City of Oakland 7          
997 997 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1093 COM Williams for Oakland Unified School Board District Seat 3 2020 Van Cedric     Oakland CA 94611       2020-10-19 00:00:00 1700 1427826 854 Van Cedric Williams       OTH Oakland Unified School District 3          
998 998 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-10-20       EXP1090 COM Yes on QQ, Oakland Youth Vote       Oakland CA 94607       2020-10-19 00:00:00 1000 1428755 855                 A Proposed Charter Amendment Authorizing the City Council to Adopt an Ordinance Allowing Persons Aged 16 and 17 to Vote for the Offices of School Board Director QQ City of Oakland  
1128 1128 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-09-16       EXP1083 COM Gibson McElhaney & Elect Carroll Fife & Rebecca Kaplan to the Oakland City Council,sponsored by Alameda Labor Council AFL-CIO Oakland 2020 Committee to Replace Lynette     Sacramento CA 95814       2020-09-15 00:00:00 50000 1428015 868 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, sponsored by Alameda Labor Council AFL-CIO                      
1167 1167 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-08-18       EXP1080 COM Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council, sponsored by Alameda Labor Council AFL-CIO Oakland 2020 Committee to Replace     Sacramento CA 95814       2020-08-18 00:00:00 25000 1428015 868                        
1178 1178 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-02-28       EXP1066 COM Alameda County Firefighers Yes on Measure F, Sponsored by: International Assocaition of Firefighters Local 55       Okland CA 94612       2020-02-27 00:00:00 4000 1423924 874                 Emeryville Public Safety and Early Childhood Education Funding Measure F   Alameda County  
1191 1191 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-02-19       EXP1064 COM Alameda County Firefighers Yes on Measure F, Sponsored by: International Assocaition of Firefighters Local 55       Okland CA 94612       2020-02-19 00:00:00 4000 1423924 874                 Emeryville Public Safety and Early Childhood Education Funding Measure F   Alameda County  
1194 1194 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2020-02-18       EXP1060 COM Parents, Teachers and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-02-18 00:00:00 2000 1423098 837 Angela Normand       OTH Alameda County Office of Education            
552 552 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-11-06       EXP993 COM No on K - Alamedans for a Stable Community       Alameda CA 94501       2018-11-06 00:00:00 1500 1411765 613                 Alameda Rent Control Charter Amendment. Measure K   Alameda County  
577 577 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-31       INC977 COM D.R.I.V.E. - Democrat, Repulican, Independent Voter Education (The PAC of the International Brotherhood of Teamsters)       Washington DC 20001       2018-10-30 00:00:00 10000 880969 226                        
578 578 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-31       INC976 OTH PG&E Corporation and Affiliated Entities       San Francisco CA 94114       2018-10-30 00:00:00 10000                          
582 582 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-30       INC973 SCC International Brotherhood of Electrical Workers Local 595 PAC       Dublin CA 94568       2018-10-29 00:00:00 10000 1273532 63                        
614 614 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-23       EXP970 COM Yes on Measure Z, Committee for Fair Workplaces & Ending Sexual Assault on the Job Times Up Oakland:     Sacramento CA 95814       2018-10-23 00:00:00 25000 1403165 618                 Hotel Employee Minimum Wage Charter Amendment, Measure Z   City of Oakland  
644 644 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-19       INC968 COM International Federation of Professional and Technical Engineers - Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2018-10-19 00:00:00 5000 881248 31                        
677 677 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-15       EXP955 COM Bonta for Alameda School Board 2018 Mia     Alameda CA 94501       2018-10-15 00:00:00 1500 1402399 623 Mia Bonta       OTH Alameda School Board            
678 678 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-15       EXP956 COM Doutherd for School Board 2018       Sacramento CA 95815       2018-10-15 00:00:00 1500 1404085 620 Clarissa Doutherd       OTH Oakland School Board 4.0          
679 679 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-15       EXP957 COM No on K - Alamedans for a Stable Community       Alameda CA 94501       2018-10-15 00:00:00 1500 1411765 613                 Alameda Rent Control Charter Amendment. Measure K   Alameda County  
703 703 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-10       INC951 COM International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55       Oakland CA 94612       2018-10-09 00:00:00 7000 892160 59                        
720 720 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-08       INC949 COM East Bay Working Families, A Coalition of Unions and Community Groups       Sacramento CA 95814       2018-10-05 00:00:00 15000 1390351 555                        
790 790 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-09-21       EXP946 COM Bas for Oakland City Council 2018 Nikki Fortunado     Roseville CA 95661       2018-09-21 00:00:00 1600 1400325 621 Nikki Fortunato Bas       CCM City of Oakland 2.0          
791 791 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-09-21       EXP948 COM Jim Oddie for Alameda City Council 2018       Alameda CA 94501       2018-09-21 00:00:00 3000 1367465 197 Jim Oddie       CCM City of Alameda            
792 792 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-09-21       EXP945 COM Thao for Oakland City Council 2018 Sheng     Oakland CA 94619       2018-09-21 00:00:00 1600 1405456 627 Sheng Thao       CCM City of Oakland 4.0          
793 793 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-09-21       EXP947 COM Valle for Alameda County Supervisor 2018       Union City CA 94587       2018-09-21 00:00:00 1569 1348120 357 Richard Valle       CSU Alameda County 2.0          
806 806 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-09-14       INC940 COM Thurmond for Superintendent of Public Instruction 2018 Tony     Oakland CA 94618       2018-09-12 00:00:00 1750 1395467 600                        
855 855 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2018-05-11       EXP932 COM La for County Assessor 2018 Phong     Newark CA 94560       2018-05-10 00:00:00 2000 1403905 632         ASR Alameda County            
535 535 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2017-11-16       EXP915 COM Michael Bilbrey for PERS Board 2017       Sacramento CA 95814       2017-11-15 00:00:00 1000 1.3741e+06 486 Michael Bilbrey       OTH CalPERS            
523 523 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-04-25       EXP777 COM McGrath for Hayward City Council 2016       Hayward CA 94541       2016-04-25 00:00:00 1000 1382505 470 Matt McGrath       CCM City of Hayward            
524 524 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-04-07       EXP748 COM Committee to Protect Hayward's Future - Yes on D 2016       Hayward CA 94543       2016-04-07 00:00:00 1000 1364753 471                 Renewal of the Utility User's Tax, Measure D   City of Hayward  
525 525 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-03-22       EXP747 COM Marquez for Hayward City Council 2016 Elisa     Hayward CA 94544       2016-03-22 00:00:00 1295 1376289 472 Elisa Marquez       CCM City of Hayward            
526 526 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-03-17       EXP743 COM Harris for Alameda School Board 2016 Gray     Alameda CA 94501       2016-03-17 00:00:00 4200 1383636 473 Gray Harris       OTH AUSD School Board            
527 527 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-03-17       EXP742 COM Nate Miley for Supervisor 2016       Oakland CA 94618       2016-03-17 00:00:00 10000 992285 99 Nate Miley       CSU Alameda County 4.0          
18 18 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       NON643 COM Dignity CA SEIU- United Long Term Care Workers Local 6434       Los Angeles CA 90057       2014-11-01 00:00:00 14870.08 1.35726e+06 150                        
19 19 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       NON646 COM Service Employees International Union Political Education and Action Fund (SEIU PEA) (MPO)       Washington DC 20036       2014-11-01 00:00:00 20593.44 782200 151                        
28 28 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-30       INC638 COM International Federation of Professional and Technical Engineers - Local 21       San Francisco CA 94102       2014-10-28 00:00:00 5000 881248 31                        
38 38 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-28       NON631 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2014-10-19 00:00:00 7302.58 1.29695e+06 148                       NON:S497:631
41 41 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-27       INC630 COM Service Employees International Union Local 1021 Independent Expenditure PAC       Sacramento CA 95814       2014-10-24 00:00:00 15000 1.29695e+06 148                        
53 53 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-22       EXP629 COM Better Transportation for Alameda County, Yes on BB       Oakland CA 94607       2014-10-22 00:00:00 10000 1.36224e+06 290                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County  
62 62 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-17       INC623 OTH CLC Alameda County AFL-CIO - COPE/Fundraising       Oakland CA 94621       2014-10-16 00:00:00 9000                          
63 63 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-17       INC624 COM International Federation of Professional and Technical Engineers - Local 21       San Francisco CA 94102       2014-10-16 00:00:00 10000 881248 31                        
70 70 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-15       INC621 COM International Brotherhood of Electrical Workers (IBEW) Local Union 1245       Vacaville CA 95687       2014-10-14 00:00:00 3000 742993 56                        
133 133 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-03       INC613 COM Dignity CA SEIU- United Long Term Care Workers Local 6434       Los Angeles CA 90057       2014-10-02 00:00:00 5000 1.35726e+06 150                        
172 172 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-24       NON592 COM California State Council of Service Employees Political Committee       Sacramento CA 95814       2014-09-23 00:00:00 6666.66 1.25832e+06 152                        
173 173 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-24       INC587 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2014-09-24 00:00:00 50000 1.29695e+06 148                        
180 180 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       INC570 OTH CLC Alameda County AFL-CIO - COPE/Fundraising       Oakland CA 94621       2014-09-22 00:00:00 40000                          
182 182 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP572 COM Abel Guillen for Oakland City Council 2014       Oakland CA 94609       2014-09-22 00:00:00 1400 1.36538e+06 294 Abel Guillen       CCM City of Oakland 2.0          
183 183 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP571 COM Annie Campbell Washington for Oakland City Council 2014       Oakland CA 94611       2014-09-22 00:00:00 1400 1.36561e+06 308 Anne Campbell Washington       CCM City of Oakland 4.0          
184 184 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP574 COM Bowser for Pleasanton School Board 2014       Pleasanton CA 94566       2014-09-22 00:00:00 1000 1.36797e+06 309 Jeff Bowser       OTH Pleasanton USD            
185 185 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP576 COM Brenda Roberts for Oakland City Auditor 2014       Oakland CA 94610       2014-09-22 00:00:00 1000 1.36841e+06 307 Brenda Roberts       OTH City of Oakland            
186 186 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP579 COM Gilmore for Mayor 2014       Sacramento CA 95815       2014-09-22 00:00:00 1000 1.32345e+06 310 Marie Gilmore       MAY City of Alameda            
187 187 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP583 COM Gilmore for Mayor 2014       Sacramento CA 95815       2014-09-22 00:00:00 200 1.32345e+06 310 Marie Gilmore       MAY City of Alameda            
188 188 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP573 COM Laursen for School Board 2014       Pleasanton CA 94566       2014-09-22 00:00:00 1000 1.36698e+06 311 Joan Laursen       OTH Pleasanton USD            
189 189 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP575 COM Olivia Sanwong for Pleasanton City Council 2014       Oakland CA 94618       2014-09-22 00:00:00 1000 1.35563e+06 312 Olivia Sanwong       CCM City of Pleasanton            
190 190 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-23       EXP578 COM Solana Henneberry for AUSD School Board 2014       Alameda CA 94501       2014-09-22 00:00:00 1000 1.36746e+06 313 Solana Henneberry       OTH Alameda Unified School Board Election            
193 193 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT33 COM Better Transportation for Alameda County       Oakland CA 94607       2014-09-18 00:00:00 1215 1.36224e+06 290                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County  
194 194 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT32 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 00:00:00 1215 1.36456e+06 283                 Establishing a minimum wage, requiring payment for accrued sick leave, and requiring payment for service charges to hospitality workers. Measure FF.   City of Oakland  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "contribution_reports_24_hours" (
"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,
  "entity_last_name" TEXT,
  "entity_first_name" TEXT,
  "entity_prefix" TEXT,
  "entity_suffix" TEXT,
  "entity_city" TEXT,
  "entity_state" TEXT,
  "entity_zipcode" TEXT,
  "contributor_employer" INTEGER,
  "contributor_occupation" TEXT,
  "contributor_self_employed" TEXT,
  "contribution_date" TEXT,
  "amount" NUMERIC,
  "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,
  "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),
    FOREIGN KEY ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");