contribution_reports_24_hours

FPPC Form 497

Data source: 497

28 rows where committee_id = 31 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, transaction_id, entity_last_name, entity_city, 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
2071 2071 1474351 353 Fix Our City Oakland, Supporting Murray-Badal for City Council 2025, Sponsored by labor organizations 526 RCP 2025-04-07     2025-04-15 INC213 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2025-04-04 00:00:00 75000 881248 31                        
2162 2162 1477437 356 Kara Murray Badal for Oakland City Council 2025 481 CTL 2025-03-04     2025-04-15 INC413 COM IFPTE Local 21       San Francisco CA 94103       2025-03-03 00:00:00 1300 881248 31                        
2172 2172 1478689 388 Oaklanders for Safe, Clean Streets, Yes on Measure A 2025 525 BMC 2025-02-24     2025-04-15 INC8 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC       San Francisco CA 94103       2025-02-21 00:00:00 70000 881248 31                        
2174 2174 1477668 386 Barbara Lee for Oakland Mayor 2025 523 CTL 2025-02-21     2025-04-15 INC111 COM IFPTE Local 21       San Francisco CA 94103       2025-02-21 00:00:00 1300 881248 31                        
2182 2182 1478177 393 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 531 RCP 2025-02-18     2025-04-15 INC6 COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS- LOCAL 21 TJ ANTHONY PAC FUND       SAN FRANCISCO CA 94103       2025-02-18 00:00:00 50000 881248 31                        
1769 1769 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-22     2024-11-05 INC84 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2024-10-22 00:00:00 60000 881248 31                        
1819 1819 1469604 371 Oaklanders Defending Democracy, Oppose the Recall of Mayor Thao (Thao Ballot Measure Committee) 503 BMC 2024-10-20     2024-11-05 INC113 COM IFPTE Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2024-10-19 00:00:00 20000 881248 31                        
1894 1894 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-07     2024-11-05 INC46 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2024-10-02 00:00:00 15000 881248 31                        
1930 1930 1473376 349 Iris Merriouns for Oakland City Council D7 2024 474   2024-10-01       C2YDd8GQOKxo COM IFPTE LOCAL 21, TJ Anthony PAC Fund       San Francisco CA 94103       2024-09-30 00:00:00 1200 881248 31                        
1971 1971 1463441 322 Carroll Fife for City Council 2024 440 CTL 2024-09-18     2024-11-05 INC408 COM IFPTE Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2024-09-18 00:00:00 1200 881248 31                        
1973 1973 1474351 353 Fix Our City Oakland, Supporting Carroll Fife for City Council 2024 - Sponsored by labor organizations 518 RCP 2024-09-17     2024-11-15 INC1 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2024-09-16 00:00:00 150000 881248 31                        
1379 1379 1443971 285 Kevin Jenkins for Oakland City Council 2022 369 CTL 2022-10-24     2022-11-08 INC70 COM International Federation of Professional and Technical Engineers Local 21       San Francisco CA 94103       2022-10-22 00:00:00 1800 881248 31                        
1412 1412 1442792 259 Janani Ramachandran for Oakland City Council Disrict 4 2022 334   2022-10-19       DOUuIPSZhYkH COM IFPTE Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2022-10-19 00:00:00 1800 881248 31                        
1416 1416 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-10-18     2022-11-08 INC44 COM International Federation of Professional and Technical Engineers (IFPTE) Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2022-10-17 00:00:00 25000 881248 31                        
1523 1523 1444350 271 Yes on T - Invest In Our Oakland 2022, Sponsored by SEIU Local 1021 and IFPTE Local 21 352 BMC 2022-09-13       INC125 COM International Federation of Professional and Technical Engineers Local 21, AFL-CIO       San Francisco CA 94103-1544       2022-09-12 00:00:00 75000 881248 31                        
1524 1524 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-09-13       INC4 COM International Federation of Professional and Technical Engineers (IFPTE) Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2022-09-12 00:00:00 50000 881248 31                        
895 895 1427585 213 Carroll Fife for City Council 2020 269 CTL 2020-10-16       INC196 COM International Federation of Professional and Technical Engineers Local 21       San Francisco CA 94103       2020-10-14 00:00:00 1700 881248 31                        
1031 1031 1427585 213 Carroll Fife for City Council 2020 269 CTL 2020-10-14       INC196 COM International Federation of Professional and Technical Engineers Local 21       San Francisco CA 94103       2020-10-14 00:00:00 1700 881248 31                        
1105 1105 1420085 200 Re-Elect Dan Kalb Oakland City Council 2020 251 CTL 2020-09-22       INC1320 COM IFPTE Local 21       San Francisco CA 94103       2020-09-19 00:00:00 1700 881248 31                        
1119 1119 1429205 218 Re-Elect Noel Gallo for Oakland City Council 2020 275 CTL 2020-09-21       INC151 COM International Federation of Professional and Technical Engineers       San Francisco CA 94103       2020-09-19 00:00:00 1700 881248 31                        
1120 1120 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-18     2020-11-03 F497P1-10 COM INTERNATIONAL FEDERATION OF PROFESSIONAL AND TECHNICAL ENGINEERS- LOCAL 21 TJ ANTHONY PAC FUND       SAN FRANCISCO CA 94103       2020-09-18 00:00:00 50000 881248 31                        
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                        
787 787 1405456 177 Sheng Thao for Oakland City Council 2018 226   2018-09-21       slrn9jiUWMQ8 COM International Federation of Professional and Technical Engineers (IFPTE) Local 21TJ Anthony PAC Fund       San Francisco CA 94103       2018-09-20 00:00:00 1600 881248 31                        
795 795 1406153 176 Joseph Tanios for Oakland City Council 2018 225   2018-09-20       qy7hl9Nrlh1X COM IFPTE Local 21       San Francisco CA 94103       2018-09-19 00:00:00 1600 881248 31                        
284 284 1387905 121 Re-Elect Larry Reid for Council 2016 139 CTL 2016-11-01       INC172 COM International Federation of Professional and Technical Engineers - Local 21 TJ Anthony PAC Fund       San Francisco CA 94103       2016-10-31 00:00:00 1000 881248 31                        
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                        
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                        
204 204 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2014-09-03       INC517 COM International Federation of Professional and Technical Engineers (IFPTE) Local 21 PAC       San Francisco CA 94102       2014-09-02 00:00:00 1400 881248 31                        

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