contribution_reports_24_hours

FPPC Form 497

Data source: 497

4 rows where committee_id = 579 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, 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
1393 1393 1442594 258 Sheng Thao for Oakland Mayor 2022 330   2022-10-24       bzzlV96Y4Pd6 COM IBEW 332 Education Fund/All Purpose Acct       San Jose CA 95125       2022-10-24 00:00:00 1800 1298069 579                        
1099 1099 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-25     2020-11-03 F497P1-12 COM IBEW 332 Education Fund sponsored by International Brotherhood of Electrical Workers Local 332       San Jose CA 95125       2020-09-25 00:00:00 1000 1298069 579                        
639 639 1403124 184 Natasha Middleton for Oakland City Council 2018 234 CTL 2018-10-19       INC922 SCC IBEW 332 Education Fund (Sponsored By International Brotherhood of Electrical Workers Local 332)       San Jose CA 95125       2018-10-18 00:00:00 1600 1298069 579                        
641 641 1405456 177 Sheng Thao for Oakland City Council 2018 226   2018-10-18       lJ1rtVWbMbAe COM IBEW 332 Education Fund Sponsored by the International Brotherhood od Electrical Workers Local 332       San Jose CA 95125       2018-10-18 00:00:00 1600 1298069 579                        

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