contribution_reports_24_hours

FPPC Form 497

Data source: 497

5 rows where committee_id = 838 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_date, transaction_id, entity_last_name, contribution_date, amount, ballot_measure_name, 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
931 931 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-11-02     2020-11-03 F497P2-1825 BNM YES ON 15 - SCHOOLS AND COMMUNITIES FIRST SPONSORED BY A COALITION OF LABOR GROUPS AND SOCIAL JUSTICE ORGANIZATIONS REPRESENTING FAMILIES STUDENTS AND ESSENTIAL WORKERS       Los Angeles CA 90017       2020-11-02 00:00:00 13861 1403098 838                 Tax on Commercial and Industrial Properties for Education and Local Government Funding 15 Statewide  
981 981 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-22     2020-11-03 F497P2-64 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 1231.27 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
982 982 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-22     2020-11-03 F497P2-122 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 356.78 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
1030 1030 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-14     2020-11-03 F497P2-64 BNM Yes on 15 - Schools and Communities First sponsored by a Coalition of Labor Groups and Social Justice Organizations Representing Families Students and Essential Workers       Los Angeles CA 90017       2020-10-13 00:00:00 1231.27 1403098 838                 The California Schools and Local Communities Funding Act of 2020 15 Statewide  
892 892 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1690 BNM YES ON 15 - SCHOOLS AND COMMUNITIES FIRST       Los Angeles CA 90017       2020-10-09 00:00:00 23636 1403098 838                 Tax on Commercial and Industrial Properties for Education and Local Government Funding 15 Statewide  

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