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
2143 2143 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-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                        
2145 2145 1477668 386 Barbara Lee for Oakland Mayor 2025 523 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                        
2150 2150 1477604 363 Charlene Wang for Oakland City Council District 2 488   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                        
2189 2189 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-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 336 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 236 Van Cedric Williams for Oakland Unified School Board Seat 3, 2024 471   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 322 Carroll Fife for City Council 2024 440 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 331 Patrice Berry for Oakland School Board 2024 450   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 373 Erin Armstrong for Oakland City Council District 5 2024 506   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 347 Re-Elect Noel Gallo for Oakland City Council 2024 472 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 351 Rowena Brown at large Oakland City Council 2024 476   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 283 Nick Resnick for Oakland School Board 2022 District 4 367   2022-11-22       MDROHuKH4gNN COM Sheet Metal Workers       Livermore CA 94551       2022-10-05 00:00:00 1800 850381 81                        
1268 1268 1446325 283 Nick Resnick for Oakland School Board 2022 District 4 367   2022-11-22       MDROHuKH4gNN COM Sheet Metal Workers       Livermore CA 94551       2022-10-05 00:00:00 1800 850381 81                        
1271 1271 1448165 282 Kyra Mungia for Oakland School Board 2022 365 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 285 Kevin Jenkins for Oakland City Council 2022 369 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 259 Janani Ramachandran for Oakland City Council Disrict 4 2022 334   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 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 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 218 Re-Elect Noel Gallo for Oakland City Council 2020 275 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 240 It's Our Time, Supporting Stephanie Dominguez Walton for City Council 2020 303   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 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-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 222 Elias Ferran for City Attorney 2020 279 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 213 Carroll Fife for City Council 2020 269 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 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-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 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218   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 177 Sheng Thao for Oakland City Council 2018 226   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 185 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 177 Sheng Thao for Oakland City Council 2018 226   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 41 Friends of Oakland Public Schools Yes on G1 2016 166 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 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       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 68 Annie Campbell Washington for Oakland City Council 2014 85   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 87 Abel Guillen for Oakland City Council 2014 87 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");