contribution_reports_24_hours

FPPC Form 497

Data source: 497

29 rows where committee_id = 59 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_type, 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
2122 2122 1477437 356 Kara Murray Badal for Oakland City Council 2025 481 CTL 2025-03-21     2025-04-15 INC571 COM International Association of Fire Fighters Local 55       Oakland CA 94612       2025-03-20 00:00:00 1300 892160 59                        
2127 2127 1478689 388 Oaklanders for Safe, Clean Streets, Yes on Measure A 2025 525 BMC 2025-03-19     2025-04-15 INC29 COM IAFF Local 55 PAC       Oakland CA 94612       2025-03-18 00:00:00 55000 892160 59                        
2128 2128 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-03-18     2025-04-15 INC29 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION, SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55       OAKLAND CA 94612       2025-03-18 00:00:00 5000 892160 59                        
2185 2185 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-13     2025-04-15 INC5 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION, SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55       OAKLAND CA 94612       2025-02-13 00:00:00 10555 892160 59                        
1879 1879 1469604 371 Oaklanders Defending Democracy, Oppose the Recall of Mayor Thao (Thao Ballot Measure Committee) 503 BMC 2024-10-09     2024-11-05 INC106 COM International Association of Firefighters Local 55 PAC       Oakland CA 94612       2024-10-09 00:00:00 2500 892160 59                        
1886 1886 1472871 369 Make Oakland Wildfire Safe, Yes on MM 500 BMC 2024-10-08     2024-11-05 INC21 COM International Association of Firefighter Local 55 PAC (IAFF)       Oakland CA 94612       2024-10-08 00:00:00 10000 892160 59                        
1929 1929 1473376 349 Iris Merriouns for Oakland City Council D7 2024 474   2024-10-01       cJ5zZDrMQib4 COM IAFF, Local 55       Oakland CA 94612       2024-09-30 00:00:00 1200 892160 59                        
1960 1960 1463441 322 Carroll Fife for City Council 2024 440 CTL 2024-09-22     2024-11-05 INC455 COM International Association of Firefighters Local 55 PAC       Oakland CA 94612       2024-09-21 00:00:00 1200 892160 59                        
1961 1961 1467592 333 Wang for Oakland City Council At Large 2024 452   2024-09-22       hCt8vvxWeaNT COM International Association of Firefighter Local 55 PAC       Oakland CA 94612       2024-09-21 00:00:00 1200 892160 59                        
1974 1974 1469671 329 LeRonne Armstrong for City Council 2024 448 CTL 2024-09-17     2024-11-05 INC652 COM International Association of Firefighter Local 55 PAC (IAFF)       Oakland CA 94612       2024-09-16 00:00:00 1200 892160 59                       F497P1.INC652
1975 1975 1468846 351 Rowena Brown at large Oakland City Council 2024 476   2024-09-16       slZiDhnQiPjb COM IAFF Local 55 PAC       Oakland CA 94612       2024-09-16 00:00:00 1200 892160 59                        
1976 1976 1470433 373 Erin Armstrong for Oakland City Council District 5 2024 506   2024-09-14       k58gIAb4HKo1 COM IAFF Local 55       Oakland CA 94612       2024-09-13 00:00:00 1200 892160 59                        
2023 2023 1465871 336 Oakland Citizens for Public Safety, Supporting Zac Unger for City Council 2024, Sponsored by International Association of Firefighters Local 55 456 RCP 2024-08-12     2024-11-05 INC11 COM International Association of Fire Fighters Local 55       Oakland CA 94612       2024-08-09 00:00:00 10000 892160 59                        
1378 1378 1443971 285 Kevin Jenkins for Oakland City Council 2022 369 CTL 2022-10-24     2022-11-08 INC65 COM International Association of Firefighters Local 55 PAC       Oakland CA 94612       2022-10-22 00:00:00 1700 892160 59                        
1383 1383 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-10-24     2022-11-08 INC63 COM International Association of Fire Fighters Local 55 PAC       Oakland CA 94612       2022-10-21 00:00:00 10000 892160 59                        
1514 1514 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-09-19       INC7 COM International Association of Fire Fighters Local 55 PAC       Oakland CA 94612       2022-09-16 00:00:00 45000 892160 59                        
1515 1515 1442792 259 Janani Ramachandran for Oakland City Council Disrict 4 2022 334   2022-09-16       tBydcxKpP76O COM IAFF, Local 55 Political Action Committee       Oakland CA 94612       2022-09-16 00:00:00 1700 892160 59                        
1573 1573 1445857 278 Neighbors for the Oakland Library - Yes on C! 360 BMC 2022-05-05     2022-06-07 INC64 COM International Association of Fire Fighters Local 55       Oakland CA 94612       2022-05-04 00:00:00 1000 892160 59                        
1072 1072 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-10-05     2020-11-03 F497P1-16 COM INTERNATIONAL ASSOCIATION OF FIREFIGHTER LOCAL 55 POLITICAL ACTION SPONSORED BY: INT'L ASSOC. OF FIREFIGHTER LOCAL 55       OAKLAND CA 94612       2020-10-05 00:00:00 5000 892160 59                        
1118 1118 1429205 218 Re-Elect Noel Gallo for Oakland City Council 2020 275 CTL 2020-09-21       INC150 COM International Association of Fire Fighters Local 55       Oakland CA 94612       2020-09-19 00:00:00 1700 892160 59                        
1170 1170 1427585 213 Carroll Fife for City Council 2020 269 CTL 2020-08-18       INC29 COM International Association of Fire Fighters Local 55 PAC       Oakland CA 94612       2020-08-17 00:00:00 1700 892160 59                        
1172 1172 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-08-11       INC1009 COM IAFF Local 55       Oakland CA 94612       2020-08-10 00:00:00 1700 892160 59                        
1173 1173 1420085 200 Re-Elect Dan Kalb Oakland City Council 2020 251 CTL 2020-08-11       INC956 COM IAFF Local 55       oakland CA 94612       2020-08-11 00:00:00 1700 892160 59                        
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                        
721 721 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218   2018-10-06       5BYiKdppIr9E COM International Association of Firefighters Local 55 PAC       Oakland CA 94612       2018-10-05 00:00:00 5000 892160 59                        
852 852 1400467 149 Protect Oakland Libraries - Yes on D 2018 206 BMC 2018-05-11       INC412 COM International Association Of Fire Fighters Local 55       Oakland CA 94612       2018-05-10 00:00:00 2500 892160 59                        
140 140 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-02       INC1857 COM International Association of Firefighters, Local 55       Oakland CA 94612       2014-10-01 00:00:00 1400 892160 59                        
170 170 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-09-25       INC3 COM International Association of Firefighters Local 55 PAC       Oakland CA 94612       2014-09-24 00:00:00 10000 892160 59                        
205 205 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-08-28       VN8ZNCXQHH9 OTH International Association of Firefighters, Local 55 PAC       Oakland CA 94612-3303       2014-08-27 00:00:00 1400 892160 59                        

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