contribution_reports_24_hours

FPPC Form 497

Data source: 497

29 rows where filer_name = 118 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, committee_id, 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            
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          

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