contribution_reports_24_hours

FPPC Form 497

Data source: 497

24 rows where committee_id = 58 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, committee_type, report_date, election_date, entity_type, entity_last_name, entity_zipcode, contribution_date, amount, report_date (date), election_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
1741 1741 1474351 353 Fix Our City Oakland, Supporting Fife for City Council and Richardson for City Attorney 2024 - Sponsored by labor organizations 478 RCP 2024-10-29     2024-11-05 INC96 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2024-10-29 00:00:00 25000 1294190 58                        
1757 1757 1469978 335 Sasha Ritzie-Hernandez for Oakland School Board 2024 455   2024-10-24       dzozcbRS33L2 COM Alameda Labor Council       Oakland CA 94607       2024-10-23 00:00:00 1000 1294190 58                        
1818 1818 1469604 371 Oaklanders Defending Democracy, Oppose the Recall of Mayor Thao (Thao Ballot Measure Committee) 503 BMC 2024-10-20     2024-11-05 INC115 COM Alameda Labor Council AFL-CIO Unity PAC       Oakland CA 94607       2024-10-19 00:00:00 10000 1294190 58                        
1826 1826 1474351 353 Fix Our City Oakland, Supporting Fife for City Council and Richardson for City Attorney 2024 - Sponsored by labor organizations 478 RCP 2024-10-17     2024-11-05 INC55 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2024-10-16 00:00:00 50000 1294190 58                        
1966 1966 1467768 341 Oaklanders Together - For A Safer Oakland, Yes on NN 470 BMC 2024-09-19       INC111 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2024-08-09 00:00:00 5000 1294190 58                        
1970 1970 1463441 322 Carroll Fife for City Council 2024 440 CTL 2024-09-18     2024-11-05 INC409 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2024-09-18 00:00:00 1200 1294190 58                        
1981 1981 1468846 351 Rowena Brown at large Oakland City Council 2024 476   2024-09-10       7buOf4MiizJ8 COM Alameda Labor Council Unity PAC       Oakland CA 94607       2024-09-10 00:00:00 1200 1294190 58                        
1994 1994 1462429 312 Ryan Richardson for Oakland City Attorney 2024 424 CTL 2024-09-04     2024-11-05 INC389 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2024-09-03 00:00:00 1200 1294190 58                        
1339 1339 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-10-27     2022-11-08 INC73 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2022-10-26 00:00:00 25000 1294190 58                        
1494 1494 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-09-26     2022-11-08 INC23 COM Alameda Labor Council, AFL-CIO Unity PAC       Oakland CA 94607       2022-09-24 00:00:00 80000 1294190 58                        
1531 1531 960997 41 Friends of Oakland Public Schools - Yes on Measure H 350 RCP 2022-09-07     2022-11-08 INC1211 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2022-09-06 00:00:00 1000 1294190 58                        
922 922 1429205 218 Re-Elect Noel Gallo for Oakland City Council 2020 275 CTL 2020-11-02       INC326 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2020-11-02 00:00:00 1700 1294190 58                        
926 926 960997 41 Friends of Oakland Public Schools - Yes on Measure Y 271 RCP 2020-11-02       INC1093 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2020-11-02 00:00:00 1000 1294190 58                        
936 936 1430904 221 Ben 'Coach' Tapscott for Oakland School Board 2020 278 CTL 2020-10-31       INC113 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2020-10-30 00:00:00 1700 1294190 58                        
940 940 1420085 200 Re-Elect Dan Kalb Oakland City Council 2020 251 CTL 2020-10-30       INC1613 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2020-10-29 00:00:00 1700 1294190 58                        
950 950 1428755 215 Yes on QQ, Oakland Youth Vote 272 BMC 2020-10-27       INC119 COM Alameda Labor Council Unity PAC       Oakland CA 94621       2020-10-26 00:00:00 1000 1294190 58                        
965 965 1419930 207 Davis For Oakland School Board 2020 263   2020-10-26       fV3CYjRAtrQ9 SCC Unity PAC Alameda Labor Council       Oakland CA 94621       2020-10-26 00:00:00 1700 1294190 58                        
971 971 1429072 229 Mike Hutchinson for Oakland School Board 2020 286 CTL 2020-10-23       INC154 COM Unity PAC Alameda Labor Council       Oakland CA 94621       2020-10-23 00:00:00 1700 1294190 58                        
1127 1127 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 316 RCP 2020-09-17     2020-11-03 F497P1-9 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO       Oakland CA 94621       2020-09-17 00:00:00 50000 1294190 58                        
1166 1166 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 320 RCP 2020-08-21     2020-11-03 F497P1-1 COM Unity PAC a Sponsored Committee of the Alameda Labor Council AFL-CIO       Oakland CA 94621       2020-08-21 00:00:00 25000 1294190 58                        
592 592 1404085 154 Doutherd for School Board 2018 192 CTL 2018-10-30       INC494 COM Unity PAC       Oakland CA 94621       2018-10-29 00:00:00 1500 1294190 58                        
605 605 1403165 152 Time's Up Oakland: Yes on Measure Z Committee for Fair Workplaces & Ending Sexual Assault on the Job 239 BMC 2018-10-25     2018-11-06 F497P1-66 COM Unity PAC       Oakland CA 94621       2018-10-24 00:00:00 25000 1294190 58                        
735 735 1405456 177 Sheng Thao for Oakland City Council 2018 226   2018-10-03       jXcxsPYlxut7 COM UNITY PAC Sponsored by Alameda Labor Council, AFL-CIO       Oakland CA 94621       2018-10-02 00:00:00 1600 1294190 58                        
748 748 1400325 150 Nikki Fortunato Bas for Oakland City Council 2018 187 CTL 2018-10-01       INC541 COM Unity PAC       Oakland CA 94621       2018-09-28 00:00:00 1600 1294190 58                        

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