contribution_reports_24_hours

FPPC Form 497

Data source: 497

10 rows where committee_id = 221 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_last_name, 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
1627 1627 1462377 315 Zac Unger for Oakland City Council 2024 430 CTL 2024-11-02     2024-11-05 INC911 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2024-10-31 00:00:00 1000 1318200 221                        
1652 1652 1462377 315 Zac Unger for Oakland City Council 2024 430 CTL 2024-11-01     2024-11-05 INC911 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2024-10-31 00:00:00 1000 1318200 221                        
1861 1861 1470433 373 Erin Armstrong for Oakland City Council District 5 2024 506   2024-10-09       WAh8SBJzndRD COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2024-10-09 00:00:00 1000 1318200 221                        
1881 1881 1469604 371 Oaklanders Defending Democracy, Oppose the Recall of Mayor Thao (Thao Ballot Measure Committee) 503 BMC 2024-10-09     2024-11-05 INC109 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2024-10-09 00:00:00 1000 1318200 221                        
1887 1887 1469514 340 Rachel Latta for Oakland School Board 2024 460   2024-10-08       7DK67EgtB1Jx COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2024-10-07 00:00:00 1000 1318200 221                        
1063 1063 1427585 213 Carroll Fife for City Council 2020 269 CTL 2020-10-07       INC182 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-10-07 00:00:00 1000 1318200 221                        
1079 1079 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-02     2020-11-03 F497P1-13 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-10-02 00:00:00 7500 1318200 221                        
1080 1080 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-02     2020-11-03 F497P1-14 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-10-02 00:00:00 1000 1318200 221                        
1125 1125 1419466 206 Re-Elect Rebecca Kaplan for City Council 2020 258 CTL 2020-09-18       INC380 COM National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy       Sacramento CA 95815       2020-09-18 00:00:00 1000 1318200 221                        
1174 1174 1420085 200 Re-Elect Dan Kalb Oakland City Council 2020 251 CTL 2020-08-11       INC958 COM National Union Of Healthcare Workers Candidate Committee       Sacramento CA 95815       2020-08-11 00:00:00 1700 1318200 221                        

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