contribution_reports_24_hours

FPPC Form 497

Data source: 497

19 rows where committee_id = 37 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_city, 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
2118 2118 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-24     2025-04-15 INC50 COM STEAMFITTERS LOCAL 342 POLITICAL ACTION COMMITTEE       CONCORD CA 94518       2025-03-24 00:00:00 5000 890268 37                        
2151 2151 1477604 363 Charlene Wang for Oakland City Council District 2 488   2025-03-11     2025-04-15 BcWSRkXXHWXk COM U.A. Local 342 P.A.C.       Concord CA 94518       2025-03-10 00:00:00 1300 890268 37                        
2188 2188 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-10     2025-04-15 INC2 COM STEAMFITTERS LOCAL 342 POLITICAL ACTION COMMITTEE       CONCORD CA 94518       2025-02-10 00:00:00 5000 890268 37                        
1884 1884 1463441 322 Carroll Fife for City Council 2024 440 CTL 2024-10-09     2024-11-05 INC523 COM UA Local 342       Concord CA 94518       2024-10-09 00:00:00 1200 890268 37                        
1889 1889 1469514 340 Rachel Latta for Oakland School Board 2024 460   2024-10-08       tMC9LIvIB6Mw SCC U. A. Local 342 PAC Fund       Concord CA 94518       2024-10-07 00:00:00 1200 890268 37                        
1937 1937 1470433 373 Erin Armstrong for Oakland City Council District 5 2024 506   2024-09-24       g1lJdokOZgIm COM U.A. Local 342 PAC Fund       Concord CA 94518       2024-09-24 00:00:00 1200 890268 37                        
1938 1938 1472382 347 Re-Elect Noel Gallo for Oakland City Council 2024 472 CTL 2024-09-24     2024-11-05 INC77 COM UA Local 342 PAC Fund       Concord CA 94518       2024-09-21 00:00:00 1200 890268 37                        
1955 1955 1462429 312 Ryan Richardson for Oakland City Attorney 2024 424 CTL 2024-09-23     2024-11-05 INC453 COM Steamfitters Local 342 PAC       Concord CA 94518       2024-09-21 00:00:00 1200 890268 37                        
1925 1925 1469978 335 Sasha Ritzie-Hernandez for Oakland School Board 2024 455   2024-09-21       iQSkx8aueNpw COM U.A. 342 Local 342 P.A.C Fund       Concord CA 94518       2024-09-21 00:00:00 1200 890268 37                        
1597 1597 1460829 317 Sasha Ritzie Hernandez for Oakland School Board 2023 432   2023-10-19       GebCwQq6q5Gh COM UA Local 342       Concord CA 94518       2023-10-18 00:00:00 1200 890268 37                        
1347 1347 960997 41 Friends of Oakland Public Schools - Yes on Measure H 350 RCP 2022-10-27     2022-11-08 INC1499 COM Plumbers & Steamfitters Local Union 342       Concord CA 94518       2022-10-26 00:00:00 5000 890268 37                        
1508 1508 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-09-20       INC9 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2022-09-19 00:00:00 25000 890268 37                        
1035 1035 1429205 218 Re-Elect Noel Gallo for Oakland City Council 2020 275 CTL 2020-10-13       INC229 COM Steamfitters Local Union #342       Concord CA 94518       2020-10-13 00:00:00 1700 890268 37                        
1039 1039 1401958 240 It's Our Time, Supporting Stephanie Dominguez Walton for City Council 2020 303   2020-10-12       5316d4U6XP1G COM STEAMFITTERS LOCAL 342 POLITICAL ACTION COMMITTEE       Concord CA 94518       2020-10-11 00:00:00 2000 890268 37                        
1156 1156 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-28     2020-11-03 F497P1-2 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2020-08-28 00:00:00 5000 890268 37                        
1169 1169 1426949 222 Elias Ferran for City Attorney 2020 279 CTL 2020-08-18       INC404 COM U.A Local 342 P.A.C. Fund       Concord CA 94518       2020-08-18 00:00:00 1700 890268 37                        
595 595 1405456 177 Sheng Thao for Oakland City Council 2018 226   2018-10-28       sHUvfCpcSeg7 COM U.A. (Steamfitters) Local 342 PAC Fund       Concord CA 94518       2018-10-28 00:00:00 800 890268 37                        
696 696 1410279 169 OAKLANDERS FOR RESPONSIBLE LEADERSHIP, OPPOSING DESLEY BROOKS FOR OAKLAND CITY COUNCIL 2018 213 RCP 2018-10-11       INC61 COM U.A. LOCAL 342 P.A.C. FUND       CONCORD CA 94518       2018-10-10 00:00:00 5000 890268 37                        
88 88 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-10-09       INC20 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2014-10-09 00:00:00 1300 890268 37                        

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