contribution_reports_24_hours

FPPC Form 497

Data source: 497

39 rows where filer_id = 16 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, entity_type, entity_city, entity_zipcode, contribution_date, amount, committee_id, candidate_last_name, 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
1466 1466 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2022-10-08     2022-06-07 EXP2389 COM Kevin Jenkins for Oakland City Council 2022       Antelope CA 95843       2022-10-08 00:00:00 1800 1443971 1009 Kevin Jenkins       CCM Oakland 6.0          
1467 1467 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2022-10-08     2022-06-07 EXP2388 COM Nenna Joiner for Oakland City Council D4 2022       Oakland CA 94619       2022-10-08 00:00:00 1800 1450180 1014 Nenna Joiner       CCM Oakland 4.0          
1566 1566 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2022-05-16       EXP2349 COM Rebecca Kaplan for Supervisor 2022       Oakland CA 94612       2022-05-16 00:00:00 1500 1444142 1011 Rebecca Kaplan       CSU Alameda 3.0          
1567 1567 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2022-05-16       EXP2350 COM Surlene Grant for Supervisor 2022       San Leandro CA 94578       2022-05-16 00:00:00 1500 1445116 1025 Surlene Grant       CSU Alameda 3.0          
1219 1219 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2021-08-31       EXP2283 COM Mia Bonta for Assembly 2021       Sacramento CA 95815       2021-08-31 00:00:00 1500 1.43797e+06 930 Mia Bonta       ASM   18.0          
1236 1236 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2021-07-02       EXP2263 COM Mia Bonta for Assembly 2021       Sacramento CA 95815       2021-07-01 00:00:00 1000 1.43797e+06 930 Mia Bonta       ASM   18.0          
1065 1065 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2020-10-07       EXP2123 COM Derreck Johnson for Oakland City Council 2020       Oakland CA 94607       2020-10-07 00:00:00 1700 1426780 861 Derreck Johnson       CCM City of Oakland 8          
1066 1066 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2020-10-07       EXP2124 COM Elias Ferran for City Attorney 2020       Oakland CA 94607       2020-10-07 00:00:00 1700 1426949 862 Eli Ferran       CAT City of Oakland            
1067 1067 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2020-10-07       EXP2120 COM Re-Elect Lynette Gibson McElhaney for City Council 2020       Oakland CA 94607       2020-10-07 00:00:00 1700 1421347 863 Lynette Gibson McElhaney       CCM City of Oakland 3          
1068 1068 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2020-10-07       EXP2121 COM Re-Elect Noel Gallo for Oakland City Council 2020       Oakland CA 94607       2020-10-07 00:00:00 1700 1429205 841 Noel Gallo       CCM City of Oakland 5          
1069 1069 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2020-10-07       EXP2122 COM Treva Reid for Oakland City Council 2020       Oakland CA 94607       2020-10-07 00:00:00 1700 1366759 864 Treva Reid       CCM City of Oakland 7          
875 875 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2019-07-05       INC1960 OTH Argent Materials, Inc.       Oakland CA 94608       2019-07-02 00:00:00 5000                          
876 876 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2019-07-05       INC1961 OTH Foster Interstate Media, Inc. and Affiliated Entities       San Francisco CA 94105   Major Donor   2019-07-02 00:00:00 5000                          
877 877 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2019-07-05       INC1962 OTH Oakland Lofts, LLC       Oakland CA 94607       2019-07-02 00:00:00 5000                          
878 878 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2019-05-21       INC1945 OTH Wilson Meany LP AAF / 11 West Ninth Street Property Owner LP       San Francisco CA 94111       2019-05-20 00:00:00 10000                          
546 546 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-11-07       INC1868 OTH Equity and General Trade Association       Oakland CA 94602       2018-11-05 00:00:00 5000                          
547 547 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-11-07       INC1869 OTH Holiday Inn Express Hotel & Suites - Balaji Enterprises, LLC       Oakland CA 94603       2018-11-05 00:00:00 5000                          
548 548 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-11-07       INC1871 OTH Kiva Sales and Service       Emeryville CA 94608       2018-11-05 00:00:00 2500                          
549 549 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-11-07       INC1870 OTH Lane Partners       Menlo Park CA 94025       2018-11-05 00:00:00 10000                          
568 568 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-11-01       EXP1862 COM Oaklanders for Responsible Leadership, Opposing Desley Brooks for Oakland City Council 2018       Oakland CA 94612       2018-11-01 00:00:00 12500 1410279 615 Desley Brooks       CCM Oakland, CA 6.0         EXP:S497:1862
619 619 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-10-23       EXP1852 COM Abel Guillen for City Council 2018       Oakland CA 94609       2018-10-23 00:00:00 1600 1395580 619 Abel Guillen       CCM Oakland, CA 2.0          
620 620 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-10-23       EXP1851 COM Oaklanders for Responsible Leadership, Opposing Desley Brooks for Oakland City Council 2018       Oakland CA 94612       2018-10-23 00:00:00 7500 1410279 615 Desley Brooks       CCM Oakland, CA 6.0         EXP:S497:1851
846 846 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-05-30       EXP1804 COM Nancy O'Malley for District Attorney 2018       Berkeley CA 94710       2018-05-30 00:00:00 1500 1322240 157 Nancy O'Malley       DAT Alameda County, CA            
848 848 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2018-05-25       EXP1803 COM Dan Kalb for State Assembly 2018       Berkeley CA 94705       2018-05-25 00:00:00 1500 1396544 631 Dan Kalb       ASM   15.0          
440 440 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2016-10-05       EXP1708 COM Re-Elect Larry Reid for Council 2016       San Francisco CA 94618       2016-10-04 00:00:00 1400 1387905 464 Larry Reid       CCM City of Oakland, CA 7.0          
441 441 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2016-10-05       EXP1710 COM Re-Elect McElhaney for City Council 2016       Oakland CA 94618       2016-10-04 00:00:00 1400 1375179 434 Lynette Gibson McElhaney       CCM City of Oakland, CA 3.0          
442 442 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2016-10-05       EXP1709 COM Viola Gonzales for City Council 2016       Oakland CA 94602       2016-10-04 00:00:00 1400 1387192 465 Viola Gonzales       CCM City of Oakland, CA 5.0          
39 39 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-28       EXP1622 COM Neighbors for a Safer Oakland 2014, Yes on Z, sponsored and major funding by International Association of Firefighters Local       Oakland CA 94618       2014-10-28 00:00:00 25000 1.36986e+06 288                 Fund police, fire and violence prevention services Z Oakland, CA  
40 40 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-28       INC1620 OTH Pacific Gas and Electric Company       San Francisco CA 94177       2014-10-27 00:00:00 2500                          
48 48 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-23       EXP1613 COM Better Transportation for Alameda County       Oakland CA 94607       2014-10-23 00:00:00 1000 1.36224e+06 290                 Transportation Sales Tax Measure BB Alameda County, CA  
49 49 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-23       EXP1616 COM Karen L. Monroe for County Superintendent 2014       Oakland CA 94607       2014-10-23 00:00:00 1000 1.35762e+06 291 Karen L. Monroe       OTH Alameda County            
50 50 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-23       EXP1615 COM Neighbors for a Safer Oakland 2014, Yes on Z, sponsored and major funding by International Association of Firefighters Local       Oakland CA 94618       2014-10-23 00:00:00 4700 1.36986e+06 288                 Fund police, fire and violence prevention services Z Oakland, CA  
144 144 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       EXP1601 COM Dana King for City Council 2014       Oakland CA 94606       2014-09-29 00:00:00 1400 1.36403e+06 299 Dana King       CCM Oakland, CA 2.0 S        
145 145 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       EXP1602 COM Jill Broadhurst for Council 2014       Oakland CA 94612       2014-09-29 00:00:00 1400 1.36284e+06 300 Jill Broadhurst       CCM Oakland, CA 4.0 S        
146 146 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       EXP1603 COM Parker for Oakland Mayor 2014       Oakland CA 94618       2014-09-29 00:00:00 1400 1.35761e+06 301 Bryan Parker       MAY Oakland, CA   S        
147 147 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       INC1597 OTH ABC Security Service, Inc.       Oakland CA 94606       2014-09-03 00:00:00 1000                          
148 148 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       INC1599 IND Wasserman Robert Z.     Oakland CA 94607 Wendel, Rosen, Black & Dean 2532 Attorney   2014-09-19 00:00:00 500                          
149 149 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       INC1600 OTH Oakland Metropolitan Chamber of Commerce       Oakland CA 94612       2014-08-30 00:00:00 1205.3                          
150 150 983545 16 OAKPAC, Oakland Metropolitan Chamber of Commerce 16 RCP 2014-10-01       INC1604 OTH Full Court Press       Oakland CA 94612       2014-09-26 00:00:00 750                          

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