contribution_reports_24_hours

FPPC Form 497

Data source: 497

15 rows where committee_id = 63 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, 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
1656 1656 1463441 322 Carroll Fife for City Council 2024 440 CTL 2024-11-01     2024-11-05 INC614 SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2024-11-01 00:00:00 1200 1273532 63                        
1897 1897 1468846 351 Rowena Brown at large Oakland City Council 2024 476   2024-10-07       2R29Cs412al8 SCC International Brothers of Electrical Workers Local 595 PAC SCC       Sacramento CA 95814       2024-10-07 00:00:00 1200 1273532 63                        
1958 1958 1469514 340 Rachel Latta for Oakland School Board 2024 460   2024-09-23       mkmF9W1KGhis SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2024-09-23 00:00:00 1200 1273532 63                        
1963 1963 1469795 331 Patrice Berry for Oakland School Board 2024 450   2024-09-21       k5QtwWbhcTtq SCC IBEW Local 595 PAC Small Contributor Committee       Sacramento CA 95814       2024-09-21 00:00:00 1200 1273532 63                        
1993 1993 1462429 312 Ryan Richardson for Oakland City Attorney 2024 424 CTL 2024-09-04     2024-11-05 INC387 SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2024-09-03 00:00:00 1200 1273532 63                        
1375 1375 1442792 259 Janani Ramachandran for Oakland City Council Disrict 4 2022 334   2022-10-24       CoWMvBRbun6f SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2022-10-21 00:00:00 1800 1273532 63                        
1384 1384 1452920 286 Working Families for a Better Oakland supporting Sheng Thao for Oakland Mayor 2022 370 RCP 2022-10-24     2022-11-08 INC64 SCC International Brotherhood of Electrical Workers Local 595       Sacramento CA 95814       2022-10-21 00:00:00 25000 1273532 63                        
1006 1006 1420085 200 Re-Elect Dan Kalb Oakland City Council 2020 251 CTL 2020-10-19       INC1485 SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2020-10-17 00:00:00 1000 1273532 63                        
1026 1026 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-15     2020-11-03 F497P1-18 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC       DUBLIN CA 94568       2020-10-15 00:00:00 1500 1273532 63                        
1145 1145 1427585 213 Carroll Fife for City Council 2020 269 CTL 2020-09-10       INC93 SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2020-09-10 00:00:00 1000 1273532 63                        
1147 1147 1426949 222 Elias Ferran for City Attorney 2020 279 CTL 2020-09-09       INC498 SCC International Brotherhood of Electrical Workers Local 595 PAC       Sacramento CA 95814       2020-09-08 00:00:00 1700 1273532 63                        
1150 1150 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-04     2020-11-03 F497P1-4 SCC INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC       DUBLIN CA 94568       2020-09-04 00:00:00 5000 1273532 63                        
582 582 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-30       INC973 SCC International Brotherhood of Electrical Workers Local 595 PAC       Dublin CA 94568       2018-10-29 00:00:00 10000 1273532 63                        
780 780 1410279 169 OAKLANDERS FOR RESPONSIBLE LEADERSHIP, OPPOSING DESLEY BROOKS FOR OAKLAND CITY COUNCIL 2018 213 RCP 2018-09-25       INC8 COM INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 595 PAC       DUBLIN CA 94568       2018-09-24 00:00:00 10000 1273532 63                        
773 773 1405456 177 Sheng Thao for Oakland City Council 2018 226   2018-09-22       WNZD48DkHh21 COM International Brotherhood of Electrical Workers Local 595 PAC SCC#1273532       Dublin CA 94568       2018-09-22 00:00:00 1600 1273532 63                        

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