contribution_reports_24_hours

FPPC Form 497

Data source: 497

19 rows where committee_id = 36 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
2137 2137 1478177 392 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 532 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 36                        
2170 2170 1477604 372 Charlene Wang for Oakland City Council District 2 508   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 36                        
2207 2207 1478177 392 SUPPORTERS OF BARBARA LEE FOR OAKLAND MAYOR 2025, A COALITION OF BUSINESS, LABOR AND PUBLIC SAFETY ORGANIZATIONS FOR A BETTER OAKLAND 532 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 36                        
1884 1884 1463441 325 Carroll Fife for City Council 2024 443 CTL 2024-10-09     2024-11-05 INC523 COM UA Local 342       Concord CA 94518       2024-10-09 00:00:00 1200 890268 36                        
1889 1889 1469514 355 Rachel Latta for Oakland School Board 2024 487   2024-10-08       tMC9LIvIB6Mw SCC U. A. Local 342 PAC Fund       Concord CA 94518       2024-10-07 00:00:00 1200 890268 36                        
1937 1937 1470433 353 Erin Armstrong for Oakland City Council District 5 2024 483   2024-09-24       g1lJdokOZgIm COM U.A. Local 342 PAC Fund       Concord CA 94518       2024-09-24 00:00:00 1200 890268 36                        
1938 1938 1472382 332 Re-Elect Noel Gallo for Oakland City Council 2024 453 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 36                        
1955 1955 1462429 313 Ryan Richardson for Oakland City Attorney 2024 425 CTL 2024-09-23     2024-11-05 INC453 COM Steamfitters Local 342 PAC       Concord CA 94518       2024-09-21 00:00:00 1200 890268 36                        
1925 1925 1469978 358 Sasha Ritzie-Hernandez for Oakland School Board 2024 492   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 36                        
1597 1597 1460829 321 Sasha Ritzie Hernandez for Oakland School Board 2023 438   2023-10-19       GebCwQq6q5Gh COM UA Local 342       Concord CA 94518       2023-10-18 00:00:00 1200 890268 36                        
1347 1347 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 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 36                        
1508 1508 1452920 277 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 359 RCP 2022-09-20       INC9 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2022-09-19 00:00:00 25000 890268 36                        
1035 1035 1429205 213 Re-Elect Noel Gallo for Oakland City Council 2020 270 CTL 2020-10-13       INC229 COM Steamfitters Local Union #342       Concord CA 94518       2020-10-13 00:00:00 1700 890268 36                        
1039 1039 1401958 223 It's Our Time, Supporting Stephanie Dominguez Walton for City Council 2020 282   2020-10-12       5316d4U6XP1G COM STEAMFITTERS LOCAL 342 POLITICAL ACTION COMMITTEE       Concord CA 94518       2020-10-11 00:00:00 2000 890268 36                        
1156 1156 1428015 220 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 302 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 36                        
1169 1169 1426949 218 Elias Ferran for City Attorney 2020 275 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 36                        
595 595 1405456 169 Sheng Thao for Oakland City Council 2018 211   2018-10-28       sHUvfCpcSeg7 COM U.A. (Steamfitters) Local 342 PAC Fund       Concord CA 94518       2018-10-28 00:00:00 800 890268 36                        
696 696 1410279 156 OAKLANDERS FOR RESPONSIBLE LEADERSHIP, OPPOSING DESLEY BROOKS FOR OAKLAND CITY COUNCIL 2018 197 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 36                        
88 88 1371631 68 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 64 BMC 2014-10-09       INC20 COM Steamfitters Local 342 Political Action Committee       Concord CA 94518       2014-10-09 00:00:00 1300 890268 36                        

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