contribution_reports_24_hours

FPPC Form 497

Data source: 497

24 rows where filer_id = 17 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, election_date, entity_type, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, committee_id, office_sought, office_jurisdiction, district_number, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, 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
2017 2017 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-08-28     2024-03-05 EXP18833 COM John Bauters for Supervisor 2024       Sacramento CA 95815       2024-08-28 00:00:00 1000 1465352 1146 John Bauters       CSU Alameda 5.0          
2018 2018 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-08-28     2024-03-05 EXP18834 COM Warren Logan for Oakland City Council District 3 2024       Oakland CA 94608       2024-08-28 00:00:00 1200 1463590 1208 Warren Logan       CCM City of Oakland 3.0          
2030 2030 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-02-19     2024-03-05 EXP18791 COM Johnson for Judge 2024       Inglewood CA 90301       2024-02-09 00:00:00 1000 1464521 1209 Michael P. Johnson       SCJ Alameda 12.0          
2031 2031 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-02-19     2024-03-05 EXP18792 COM Nate Miley for Supervisor 2024       Oakland CA 94607       2024-02-09 00:00:00 1000 992285 99 Nate Miley       CSU Alameda 4.0          
2033 2033 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-01-22     2022-11-08 EXP18788 COM Chris Moore for Supervisor 2024       San Marcos CA 92069       2024-01-22 00:00:00 3500 1465334 1211 Chris Moore       CSU Alameda 5.0          
1396 1396 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2022-10-24     2022-11-08 EXP18731 COM Harold Lowe for City Council 2022       Oakland CA 94606       2022-10-23 00:00:00 1800 1453436 954 Harold Lowe       CCM Oakland 2.0          
1397 1397 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2022-10-24     2022-11-08 EXP18730 COM Nenna Joiner for Oakland City Council D4 2022       Oakland CA 94619       2022-10-23 00:00:00 1800 1450180 1014 Nenna Joiner       CCM Oakland 4.0          
1540 1540 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2022-08-31       EXP18720 COM De La Fuente for Mayor 2022       Oakland CA 94606       2022-08-30 00:00:00 1800 1446236 1021 Ignacio De La Fuente       MAY City of Oakland            
943 943 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2020-10-28       EXP17650 COM Committee for an Affordable East Bay, supporting Derreck Johnson and opposing Rebecca Kaplan for Oakland City Council At-Larg       Oakland CA 94607       2020-10-28 00:00:00 1500 1428904 806 Rebecca Kaplan       CCM City of Oakland AL          
944 944 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2020-10-28       EXP17651 COM Committee for an Affordable East Bay, supporting Derreck Johnson and opposing Rebecca Kaplan for Oakland City Council At-Larg       Oakland CA 94607       2020-10-28 00:00:00 1500 1428904 806 Derreck Johnson       CCM City of Oakland AL          
945 945 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2020-10-28       EXP17649 COM Oakland Neighbors United, No On Measure Q       Sacramento CA 95815       2020-10-28 00:00:00 3000 1424633 840                 A Proposed Ordinance to Approve a Parcel Tax to Fund Parks & Recreational Facilities, Services for Unhoused and Unsheltered Persons, and Maintenance of Stormwater Trash Collection Systems. Q City of Oakland  
1201 1201 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2020-02-14       PDT1 COM Oakland Neighbors United, No On Measure Q       Sacramento CA 95815       2020-02-14 00:00:00 27500 1424633 840                 A Proposed Ordinance to Approve a Parcel Tax to Fund Parks & Recreational Facilities, Services for Unhoused and Unsheltered Persons, and Maintenance of Stormwater Trash Collection Systems. Q Oakland, CA  
558 558 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-11-02       EXP13752 COM Committee for Better Choices, No on Measures AA, Y and W       Sacramento CA 95815       2018-11-01 00:00:00 13333.34 1410941 614                 Oakland Children's Initiative AA Oakland, CA  
559 559 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-11-02       EXP13753 COM Committee for Better Choices, No on Measures AA, Y and W       Sacramento CA 95815       2018-11-01 00:00:00 13333.33 1410941 614                 Vacant Property Tax W Oakland, CA  
560 560 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-11-02       EXP13754 COM Committee for Better Choices, No on Measures AA, Y and W       Sacramento CA 95815       2018-11-01 00:00:00 13333.33 1410941 614                 Just Cause Eviction Amendment Y Oakland, CA  
622 622 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-10-23       EXP13743 COM Catharine Baker for Assembly 2018       Dublin CA 94568       2018-10-23 00:00:00 2500 1392518 524 Catharine Baker       ASM   16.0          
623 623 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-10-23       EXP13744 COM Cristina Garcia for Assembly 2018       Long Beach CA 90807       2018-10-23 00:00:00 1000 1393064 518 Cristina Garcia       ASM   58.0          
838 838 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-07-20       EXP13215 COM Californians for Affordable Housing, No on Proposition 10, sponsored by the California Rental Housing Association       Sacramento CA 95814       2018-07-19 00:00:00 50000 1406018 629                 Expands Local Governments Authority to Enact Rent Control on Residential Property 10 State of California  
311 311 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2016-10-25       EXP10453 COM Moore for Oakland City Council At-Large 2016       Oakland CA 94611       2016-10-24 00:00:00 1400 1388168 455 Peggy Moore       CCM City of Oakland, CA            
175 175 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-09-24       EXP6497 COM Dana King for City Council 2014       Oakland CA 94606       2014-09-24 00:00:00 1400 1.36403e+06 299 Dana King       CCM Oakland, CA 2.0 S        
176 176 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-09-24       EXP6494 COM Parker for Oakland Mayor 2014       Oakland CA 94618       2014-09-23 00:00:00 1400 1.35761e+06 301 Bryan Parker       MAY Oakland, CA   S        
177 177 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-09-24       EXP6495 COM Joe Tuman for Mayor 2014       Oakland CA 94612       2014-09-23 00:00:00 1400 1.35902e+06 305 Joe Tuman       MAY Oakland, CA   S        
178 178 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-09-24       EXP6496 COM Courtney Ruby for Oakland Mayor 2014       Oakland CA 94612-3409       2014-09-23 00:00:00 1400 1.36428e+06 306 Courtney Ruby       MAY Oakland, CA   S        
179 179 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-09-24       INC6440 OTH Rowland Property Management       Oakland CA 94611       2014-08-06 00:00:00 100                         INC:A:6440

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