contribution_reports_24_hours

FPPC Form 497

Data source: 497

31 rows where committee_id = 81 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), report_start_date (date), report_end_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
2162 2162 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-11     2025-04-15 INC20 COM SHEET METAL WORKERS LOCAL UNION 104 POLITICAL COMMITTEE       LIVERMORE CA 94551       2025-03-11 00:00:00 5000 850381 81                        
2164 2164 1477668 387 Barbara Lee for Oakland Mayor 2025 526 CTL 2025-03-11     2025-04-15 INC250 COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2025-03-11 00:00:00 1300 850381 81                        
2169 2169 1477604 372 Charlene Wang for Oakland City Council District 2 508   2025-03-11     2025-04-15 gDNmoqqWCrrO COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2025-03-10 00:00:00 1300 850381 81                        
2208 2208 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-06     2025-04-15 INC1 COM SHEET METAL WORKERS LOCAL UNION 104 POLITICAL COMMITTEE       LIVERMORE CA 94551       2025-02-06 00:00:00 5000 850381 81                        
1645 1645 1465871 335 Oakland Citizens for Public Safety, Supporting Zac Unger for City Council 2024, Sponsored by International Association of Firefighters Local 55 456 RCP 2024-11-05     2024-11-05 INC37 COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2024-11-04 00:00:00 1000 850381 81                        
1658 1658 1427826 233 Van Cedric Williams for Oakland Unified School Board Seat 3, 2024 485   2024-10-31       esbStnDmu6w2 COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2024-10-28 00:00:00 1200 850381 81                        
1774 1774 1463441 325 Carroll Fife for City Council 2024 443 CTL 2024-10-22     2024-11-05 INC558 COM Sheet Metal Workers Local Union 104       Livermore CA 94551       2024-10-21 00:00:00 1200 850381 81                        
1859 1859 1469795 360 Patrice Berry for Oakland School Board 2024 494   2024-10-11       bW4FblwRNela SCC Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2024-10-10 00:00:00 1200 850381 81                        
1863 1863 1470433 353 Erin Armstrong for Oakland City Council District 5 2024 483   2024-10-09       dNXWFxdPPHAV COM Sheetmetal Workers Local Union 104 Political Committee       Livermore CA 94551       2024-10-09 00:00:00 1200 850381 81                        
1979 1979 1472382 332 Re-Elect Noel Gallo for Oakland City Council 2024 453 CTL 2024-09-12     2024-11-05 INC31 COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2024-09-11 00:00:00 1200 850381 81                       F497P1.INC31
1982 1982 1468846 357 Rowena Brown at large Oakland City Council 2024 491   2024-09-10       9Ds5bpfOkdcw COM Sheet Metal Workers Local Union 104 PAC       Livermore CA 94551       2024-09-10 00:00:00 1200 850381 81                        
1264 1264 1446325 296 Nick Resnick for Oakland School Board 2022 District 4 384   2022-11-22       MDROHuKH4gNN COM Sheet Metal Workers       Livermore CA 94551       2022-10-05 00:00:00 1800 850381 81                        
1268 1268 1446325 296 Nick Resnick for Oakland School Board 2022 District 4 384   2022-11-22       MDROHuKH4gNN COM Sheet Metal Workers       Livermore CA 94551       2022-10-05 00:00:00 1800 850381 81                        
1271 1271 1448165 274 Kyra Mungia for Oakland School Board 2022 356 CTL 2022-11-09     2022-11-08 INC395 COM Sheet Metal Workers Local Union 104       Livermore CA 94551       2022-11-08 00:00:00 1800 850381 81                        
1382 1382 1443971 276 Kevin Jenkins for Oakland City Council 2022 358 CTL 2022-10-24     2022-11-08 INC69 COM Sheet Metal Workers Local Union 104       Livermore CA 94551       2022-10-22 00:00:00 1800 850381 81                        
1471 1471 1442792 264 Janani Ramachandran for Oakland City Council Disrict 4 2022 342   2022-10-06       Y2Yp73AGIikT COM Sheet Metal Workers Local Union 104 Political Committee       Livermore CA 94551       2022-10-06 00:00:00 1800 850381 81                        
1513 1513 1452920 277 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 359 RCP 2022-09-19       INC6 COM Sheet Metal Workers Local Union 104 PAC       Livermore CA 94551       2022-09-16 00:00:00 25000 850381 81                        
912 912 1429205 213 Re-Elect Noel Gallo for Oakland City Council 2020 270 CTL 2020-11-03       INC332 COM Sheet Metal Workers' International Association Local NO. 140       San Ramon CA 94583       2020-11-03 00:00:00 1000 850381 81                        
948 948 1401958 223 It's Our Time, Supporting Stephanie Dominguez Walton for City Council 2020 282   2020-10-28       kgjiXNNalicZ COM Sheet Metal Workers' International Association Local No. 104       San Ramon CA 94583       2020-10-27 00:00:00 2000 850381 81                        
1016 1016 1428015 220 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 295 RCP 2020-10-16     2020-11-03 F497P1-19 COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee       San Ramon CA 94583       2020-10-16 00:00:00 1500 850381 81                        
1142 1142 1426949 218 Elias Ferran for City Attorney 2020 275 CTL 2020-09-11       INC505 COM Sheet Metal Workers' International Association Local, #140       San Ramon CA 94583       2020-09-10 00:00:00 1700 850381 81                        
1146 1146 1427585 215 Carroll Fife for City Council 2020 272 CTL 2020-09-10       INC92 COM Sheet Metal Workers' International Association Local 104 PAC       San Ramon CA 94583       2020-09-10 00:00:00 1000 850381 81                        
1149 1149 1428015 220 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 295 RCP 2020-09-09     2020-11-03 F497P1-5 COM Sheet Metal Workers Local Union 104 Political Committee       San Ramon CA 94583       2020-09-08 00:00:00 5000 850381 81                        
561 561 1412582 166 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 208   2018-11-02       o18moCYXdKWi COM Sheet Metal Workers Int'l Assoc. Local 104 PAC       San Ramon CA 94583       2018-11-01 00:00:00 1000 850381 81                        
685 685 1405456 169 Sheng Thao for Oakland City Council 2018 211   2018-10-12       5qNrRJCPjkaS COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee       San Ramon CA 94583       2018-10-12 00:00:00 600 850381 81                        
723 723 1395968 148 Libby Schaaf for Mayor 2018 181 CAO 2018-10-05       VNHZWJVJPV7 COM Sheet Metal Workers' International Association Local 104 Political Committee       San Ramon CA 94583-1547       2018-10-02 00:00:00 1600 850381 81                        
813 813 1405456 169 Sheng Thao for Oakland City Council 2018 211   2018-09-09       Th8fox6LhJka COM Sheet Metal Workers' International Association Local No. 104 Political Action Committee       San Ramon CA 94583       2018-09-08 00:00:00 1000 850381 81                        
420 420 960997 57 Friends of Oakland Public Schools Yes on G1 2016 156 BMC 2016-10-07 2016-10-07 2016-10-07 2014-11-04 F497P1-867 COM Sheet Metal Workers' Local Union 104 Issues Account       San Ramon CA 94583       2016-10-07 00:00:00 3500 850381 81                        
95 95 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       INC10 COM Sheet Metal Workers' International Association Local No. 104       San Ramon CA 94583       2014-10-08 00:00:00 1500 850381 81                        
105 105 1365610 77 Annie Campbell Washington for Oakland City Council 2014 88   2014-10-07     2014-01-01 sHhxuC7223jj COM Sheet Metal Workers' International Association Local 104       San Ramon CA 94583       2014-10-01 00:00:00 1000 850381 81                        
191 191 1365384 72 Abel Guillen for Oakland City Council 2014 68 CTL 2014-09-22       INC574 COM Sheet Metal Workers International Association Local 104 PAC       San Ramon CA 94583       2014-09-21 00:00:00 1000 850381 81                        

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