contribution_reports_24_hours

FPPC Form 497

Data source: 497

33 rows where filer_name = 31 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, committee_id, candidate_last_name, candidate_first_name, office_sought, office_jurisdiction, district_number, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, 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
929 929 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-11-02     2020-11-03 F497P2-1826 BNM Friends of Oakland Public Schools       Oakland CA 94607       2020-11-02 00:00:00 6930.5 960997 163                 School Bond Measure Y Oakland Unified School Dist.  
930 930 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-11-02     2020-11-03 F497P2-1827 BNM Home Together Alameda County 2020 Yes on W       Alameda CA 94501       2020-11-02 00:00:00 6930.5 1420738 814                 Sales Tax Measure W Alameda County  
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  
1024 1024 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-15     2020-11-03 F497P2-1694 CAO FIFE FOR CITY COUNCIL 2020       Antelope CA 95843       2020-10-14 00:00:00 507 1427585 781 Fife Carroll     CCM City of Oakland 3          
1025 1025 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-15     2020-11-03 F497P2-1693 CAO Re-elect Rebecca Kaplan for City Council       Sacramento CA 95815       2020-10-14 00:00:00 507 1419466 801 Kaplan Rebecca     CCM City of Oakland            
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  
893 893 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1691 BNM Friends of Oakland Public Schools       Oakland CA 94607       2020-10-09 00:00:00 11818 960997 163                 School Bond Measure Y Oakland Unified School Dist.  
894 894 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1692 BNM Home Together Alameda County 2020 Yes on W       Alameda CA 94501       2020-10-09 00:00:00 11818 1420738 814                 Sales Tax Measure W Alameda County HDR
1051 1051 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1691 BNM Friends of Oakland Public Schools       Oakland CA 94607       2020-10-09 00:00:00 11818 960997 163                 School Bond Measure Y Oakland Unified School Dist.  
1052 1052 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1692 BNM Home Together Alameda County 2020 Yes on W       Alameda CA 94501       2020-10-09 00:00:00 11818 1420738 814                 Sales Tax Measure W Alameda County  
1053 1053 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-09     2020-11-03 F497P2-1690 BNM Schools and Communities First       San Diego CA 92115       2020-10-09 00:00:00 23636 111111 857                 Tax on Commercial and Industrial Properties for Education and Local Government Funding 15 Statewide  
1057 1057 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1645 CAO Amodei & Crader For Hayward City Council 2020       Hayward CA 94541       2020-10-06 00:00:00 1000 1420107 858 Crader Amodei     CCM City of Hayward            
1058 1058 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1654 CAO FIFE FOR CITY COUNCIL 2020       Antelope CA 95843       2020-10-06 00:00:00 1193 1427585 781 Fife Carroll     CCM City of Oakland 3          
1059 1059 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1634 CAO CHERISSE GASH FOR OAKLAND SCHOOL BOARD DISTRICT 3 2020       Piedmont CA 94620       2020-10-06 00:00:00 1700 1428671 859 Gash Cherisse     OTH City of Oakland 3          
1060 1060 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1636 CAO HUTCHINSON FOR OAKLAND SCHOOL BOARD       Oakland CA 94602       2020-10-06 00:00:00 1700 1429072 851 Hutchinson Mike     OTH City of Oakland 5          
1061 1061 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1631 CAO Re-elect Rebecca Kaplan for City Council       Sacramento CA 95815       2020-10-06 00:00:00 1193 1419466 801 Kaplan Rebecca     CCM City of Oakland            
1062 1062 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2020-10-07     2020-11-03 F497P2-1629 CAO RAYA FOR OAKLAND CITY COUNCIL DISTRICT 5 2020       Oakland CA 94602       2020-10-06 00:00:00 1700 1429104 860 Santos Richard     CCM City of Oakland 5          
615 615 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-23     2018-11-06 F497P2-1469 BNM Time's Up Oakland: Yes on Measure Z Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-10-22 00:00:00 5000 1403165 618                 Hotel Worker Protection Measure Z City of Oakland  
652 652 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-18     2018-11-06 F497P2-1449 CAO Bas for Oakland City Council 2018       Roseville CA 95661       2018-10-17 00:00:00 16.52 1400325 621 Bas Nikki Fortunato     CCM City of Oakland 2.0          
653 653 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-18     2018-11-06 F497P2-1448 CAO Bas for Oakland City Council 2018       Roseville CA 95661       2018-10-17 00:00:00 26.43 1400325 621 Bas Nikki Fortunato     CCM City of Oakland 2.0          
654 654 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-18     2018-11-06 F497P2-1447 CAO Doutherd for School Board 2018       Sacramento CA 95815       2018-10-17 00:00:00 26.43 1404085 620 Doutherd Carissa     BED Oakland Unified School District 4.0          
655 655 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-18     2018-11-06 F497P2-1450 CAO Doutherd for School Board 2018       Sacramento CA 95815       2018-10-17 00:00:00 16.52 1404085 620 Doutherd Carissa     BED Oakland Unified School District 4.0          
666 666 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-16     2018-11-06 F497P2-1391 CAO Bas for Oakland City Council 2018       Roseville CA 95661       2018-10-15 00:00:00 1521.92 1400325 621 Bas Nikki Fortunato     CCM City of Oakland 2.0          
667 667 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-16     2018-11-06 F497P2-1392 CAO Doutherd for School Board 2018       Sacramento CA 95815       2018-10-15 00:00:00 1521.92 1404085 620 Doutherd Carissa     BED Oakland Unified School District 4.0          
762 762 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-09-26     2018-11-06 F497P2-1366 CAO Jovanka Beckles for Assembly District 15       Richmond CA 94804       2018-09-25 00:00:00 1600 1396341 624 Beckles Jovanka     ASM   15.0          
763 763 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-09-26     2018-11-06 F497P2-1370 CAO Cat Brooks for Oakland 2018       Oakland CA 94607       2018-09-25 00:00:00 1600 1405474 625 Brooks Cat     MAY Oakland            
764 764 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-09-26     2018-11-06 F497P2-1372 CAO Committee to Re-Elect Desley Brooks 2018       Oakland CA 94605       2018-09-25 00:00:00 1600 1236617 36 Brooks Desley     CCM Oakland 6.0          
765 765 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-09-26     2018-11-06 F497P2-1365 CAO Cindi Reiss for Peralta Board of Trustees 2018       Oakland CA 94610       2018-09-25 00:00:00 1600 1406206 626 Reiss Cindi     OTH Peralta            
766 766 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-09-26     2018-11-06 F497P2-1371 CAO Sheng Thao for Oakland City Council 2018       Oakland CA 94619       2018-09-25 00:00:00 1600 1405456 627 Thao Sheng     CCM Oakland 4.0          
537 537 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-07-27 5018-05-19 5018-05-19 2018-06-05 F497P2-1342 BNM Committee for Alameda County Child Care & Early Education       Oakland CA 94612       2018-05-19 00:00:00 26509 1398097 611                 Alameda County Sales Tax for Childcare and Education A Alameda  
843 843 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-06-04 5018-05-19 5018-05-19 2018-06-05 F497P2-1342 BNM Committee for Alameda County Child Care & Early Education       Oakland CA 94612       2018-05-19 00:00:00 21778 1398097 611                 Alameda County Sales Tax for Childcare and Education A Alameda  
844 844 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-06-04 5018-06-04 5018-06-04 2018-06-05 F497P2-1342 BNM Committee for Alameda County Child Care & Early Education       Oakland CA 94612       2018-06-04 00:00:00 21778 1398097 611                 Alameda County Sales Tax for Childcare and Education A Alameda  
326 326 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2016-10-21 2016-10-21 2016-10-21 2016-11-08 F497P2-1303 BNM Committee to Protect Oakland Renters - Yes on Measure JJ Sponsored by Labor and Community Organizations       Sacramento CA 95814       2016-10-21 00:00:00 24966 1364564 209                 Oakland Rent Control Ordinance JJ City of Oakland  

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