contribution_reports_24_hours

FPPC Form 497

Data source: 497

50 rows where filer_id = 22 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, committee_type, election_date, entity_type, entity_first_name, entity_city, entity_zipcode, contributor_employer, contributor_occupation, amount, committee_id, candidate_last_name, office_sought, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, memo_reference_number, 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
1647 1647 Pending 22 Elizabeth Stage 486 MDI 2024-11-04       EXP2 COM Make Oakland Wildfire Safe, Yes on MM       Oakland CA 94607       2024-10-07 00:00:00 20000 1472871 1123                 Wildfire Prevention Zone Ballot Measure parcel tax. MM City of Oakland  
1743 1743 Pending 22 Clorox 489 MDI 2024-10-28       EXP1 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607       2024-10-25 00:00:00 145000 1467768 1130                 Citywide Violence Reduction Services NN City of Oakland F497P2.EXP1
1744 1744 Pending 22 Oakland Metropolitan Chamber of Commerce 490 MDI 2024-10-28       EXP1 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607       2024-10-25 00:00:00 0 1467768 1130                 Citywide Violence Reduction Services NN City of Oakland F497P2.EXP1
2027 2027 Pending 22 East Bay Asian Youth Center 395   2024-05-16       CRFYxJjVAAOG PTY Oaklanders Together - For A Safer Oakland       Oakland CA 94607       2024-04-15 00:00:00 10000 1467768 1130                        
1303 1303 Pending 22 GO Public Schools Advocates 385 MDI 2022-11-01       EXP15 COM FRIENDS OF OAKLAND PUBLIC SCHOOLS - YES ON MEASURE H       OAKLAND CA 94607       2022-10-13 00:00:00 7500 960997 152                 PARCEL TAX RENEWAL, MEASURE: H   OAKLAND UNIFIED SCHOOL DISTRICT  
1402 1402 Pending 22 Jonathan Brooks 391 MDI 2022-10-20       EXP4 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607       2022-10-20 00:00:00 250000 1452451 955 Ignacio de la Fuente       MAY Oakland            
1455 1455 Pending 22 Oakland Bulk & Oversized Terminal LLC 396 MDI 2022-10-11       EXP2 COM Newsom for California Governor 2022       Sacramento CA 95815       2022-10-10 00:00:00 15000 1414018 962 Gavin Newsom       GOV              
1456 1456 Pending 22 Jonathan Brooks 391 MDI 2022-10-11       EXP3 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607       2022-10-11 00:00:00 250000 1452451 955 Ignacio de la Fuente       MAY Oakland            
1458 1458 Pending 22 Boscacci 397 MDI 2022-10-10     2022-11-08 INC4 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022       Oakland CA 94612       2022-09-09 00:00:00 10000 1452451 955                        
1457 1457 Pending 22 Oakland Bulk & Oversized Terminal LLC 396 MDI 2022-10-07     2022-11-08 INC3 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022       Oakland CA 94612       2022-09-07 00:00:00 50000 1452451 955                        
1447 1447 Pending 22 East Bay Asian Youth Center 395   2022-10-05       44iVmhGjGKdX COM Friends of Oakland Public Schools       OAKLAND CA 94607       2022-09-21 00:00:00 20000 960997 152                 Yes on H H OUSD  
1497 1497 Pending 22 Oakland Rising Ballot Committee Supporting Measures T & W sponsored by Center for Empowered Politics 399   2022-09-23       AEAelaMue8Fu COM Yes on T Invest In Our Oakland 2022 Sponsored by SEIU Local 1021 and IFPTE Local 21       Oakland CA 94607       2022-09-23 00:00:00 3420.89 1444350 943                 Progressive Business Tax III T City of Oakland  
1498 1498 Pending 22 Oakland Rising Ballot Committee Supporting Measures T & W sponsored by Center for Empowered Politics 399   2022-09-23       fEe7x4pFFkp7 COM Yes on W Oakland Fair Elections Sponsored by Civic Advocacy Organizations       San Francisco CA 94102       2022-09-23 00:00:00 3945.65 1448942 944                 Campaign Finance Reform W City of Oakland  
1505 1505 Pending 22 Allasor Corporation 400   2022-09-22       gst1XDCZbmBR COM Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations       Oakland CA 94612       2022-09-22 00:00:00 25000 1448942 944                 Oakland Fair Elections, Public Financing W Oakland  
1511 1511 Pending 22 Oakland Rising Ballot Committee Supporting Measures T & W sponsored by Center for Empowered Politics 399   2022-09-20       lgeunnCX4IMz COM Oakland Rising Committee       Oakland CA 94612       2022-09-19 00:00:00 113611.43 1332115 425                        
1526 1526 Pending 22 Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022 357 RCP 2022-09-12       INC4 IND Boscacci Allan     Lafayette CA 94549   Retired   2022-09-09 00:00:00 10000                          
1527 1527 Pending 22 Jonathan Brooks 391 MDI 2022-09-12       EXP1 COM Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland       Oakland CA 94607       2022-09-06 00:00:00 50000 1452451 955 Ignacio de la Fuente       MAY Oakland           F497P2.EXP1
1529 1529 Pending 22 Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022 357 RCP 2022-09-08       INC3 OTH Oakland Bulk & Oversized Terminal LLC(Phil Tagami)       Pleasant Hill CA 94523       2022-09-07 00:00:00 50000                          
1530 1530 Pending 22 Californians for Safer Streets Supporting Ignacio De La Fuente for Mayor of Oakland 2022 357 RCP 2022-09-07       INC1 IND Brooks Jonathan     Los Angeles CA 90036 JMB Partners 11622 General Partner/Founder   2022-09-06 00:00:00 50000                          
1533 1533 Pending 22 Oakland Rising Ballot Committee Supporting Measures T & W sponsored by Center for Empowered Politics 399   2022-09-07       bo7TiUvn44Mq COM Yes on T Invest In Our Oakland 2022 Sponsored by SEIU Local 1021 and IFPTE Local 21       Oakland CA 94607       2022-09-06 00:00:00 2500 1444350 943                 Progressive Business Tax III T City of Oakland  
1534 1534 Pending 22 Oakland Rising Ballot Committee Supporting Measures T & W sponsored by Center for Empowered Politics 399   2022-09-07       SMlwzzOCJaG7 COM Yes on W Oakland Fair Elections Sponsored by Civic Advocacy Organizations       San Francisco CA 94102       2022-09-06 00:00:00 2500 1448942 944                 Campaign Finance Reform W City of Oakland  
1071 1071 Pending 22 Byrens Kim Design Works 298 MDI 2020-10-01       INC799 RCP Friends of Oakland Public Schools - Yes on Measure Y       Oakland CA 94611       2020-08-28 00:00:00 10000 960997 152             0          
1104 1104 Pending 22 LCA Architects Inc. 299   2020-09-23       NUxbyv6e1nbH COM Friends of Phil Kranenburg for 2020 Marin Community College District, Trustee, ID #1428047       San Rafael CA 94903       2020-09-23 00:00:00 1500 1428047 770 Kranenburg Phil     CCB   5          
1135 1135 Pending 22 Michael R. Bloomberg 301   2020-09-14       Irm6QNZoefty COM Power2Families       Sacramento CA 95815       2020-09-11 00:00:00 200000 1431009 773                        
1161 1161 Pending 22 LCA Architects Inc. 299   2020-08-19       tFkAhPPHmKlS COM Friends of Oakland Public Schools       Oakland CA 94611       2020-08-19 00:00:00 20000 960997 152                 School Facilities Bond Measure Y OUSD  
1171 1171 Pending 22 Re-Elect Noel Gallo for Oakland City Council 2020 270 CTL 2020-08-14       INC9 IND Gallo Noel     Oakland CA 94601 City Of Oakland, CA 6388 City Councilmember   2020-08-13 00:00:00 14600                         INC:S497:9
541 541 Pending 22 Village Glen Oakland 2, LLC 221   2018-12-03       6IGEjpfsTWWM COM The Oakland Fund for Measure AA       Oakland CA 94607       2018-12-01 00:00:00 5807 1310647 555                 The Oakland Children's Initiative AA Oakland  
575 575 Pending 22 Village Glen Oakland 2, LLC 221   2018-11-01       fJkQ912kjMbJ COM The Oakland Fund for Measure AA       Oakland CA 94607       2018-11-01 00:00:00 16000 1310647 555                 The Oakland Children's Initiative AA Oakland  
593 593 Pending 22 Eileen Ruby 225   2018-10-29       LWwSNQn1MKJh COM The Oakland Fund for Measure AA       Oakland CA 94607       2018-10-28 00:00:00 5000 1310647 555                 Children's Initiative of 2018 AA Oakland, CA  
635 635 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 2018 222   2018-10-22     2018-11-06 8oZvjN4FfARZ IND Yeary Frank     Berkeley CA 94705 Camberview Partners LLC 6349 Executive Chairman   2018-10-22 00:00:00 1000                          
645 645 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 2018 222   2018-10-19     2018-11-06 fSo4aSuiCmyL IND Spears Ann     Oakland CA 94618 Beckman, Feller & Chang 6350 Attorney   2018-10-19 00:00:00 2500                          
650 650 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 2018 222   2018-10-18     2018-11-06 rSfQTFbscOFi IND Graebner Linda     Oakland CA 94618 Self 226 Business Consultant   2018-10-18 00:00:00 3000                          
651 651 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 2018 222   2018-10-18     2018-11-06 zx5RShSS6WjM IND Shalvoy Charles     Oakland CA 94618 Self 226 Business Consultant   2018-10-18 00:00:00 3000                          
670 670 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-16     2018-11-06 WNQYKM8xZot9 IND Pillon Fred     Oakland CA 946611 Retired 122 Retired   2018-10-16 00:00:00 500                          
539 539 Pending 22 Riaz Taplin 220   2018-10-15       O49mPhEIUd2N OTH The Oakland Fund for Measure AA       Oakland CA 94607       2018-10-12 00:00:00 40000                          
680 680 Pending 22 Riaz Taplin 220   2018-10-15       ICgrekuMg8Ut COM Go Public Schools Oakland Advocates       OAKLAND CA 94602       2018-10-12 00:00:00 40000 Pending 37                        
681 681 Pending 22 Village Glen Oakland 2, LLC 221   2018-10-15       eZmFKN4ELBaE COM The Oakland Fund for Measure AA       Oakland CA 94607       2018-10-01 00:00:00 22993 1310647 555                 The Oakland Children's Initiative AA Oakland  
687 687 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-12     2018-11-06 7d3TY1cYUdGX IND Banks Karen     Oakland CA 94610 Retired. 4785 Retired   2018-10-12 00:00:00 1000                          
693 693 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-12     2018-11-06 Z7EQXFjj3yzl IND Benham Derek     Piedmont CA 94610 Purple Wine 6357 Chief Executive Officer   2018-10-11 00:00:00 4500                          
694 694 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-12     2018-11-06 5FQ3XR4mbaAi IND Freiberg Charles     Oakland CA 94610 Kasowitz, Benson, Torres, and Friedman 6358 Attorney   2018-10-11 00:00:00 4500                          
695 695 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-12     2018-11-06 URnF7zxfZfBQ IND Pezzola Stephen     Oakland CA 94618 Yorkshire Ventures LLC 3195 Business Consulting   2018-10-11 00:00:00 2500                          
710 710 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-09     2018-11-06 xGxGbswm1AEo IND Spears Robert     Oakland CA 94618 Shoreline Venture Management, LLC 3979 Venture Capital   2018-10-09 00:00:00 4500                          
719 719 Pending 22 Citizens for a United Oakland, Opposing Desley Brooks for City Council 228   2018-10-08     2018-11-06 b4UAeMddSuEv OTH Smith LLP       Oakland CA 94612       2018-10-05 00:00:00 100                          
386 386 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC2 OTH 1530 Harrison St. Apartments       Oakland CA 94609       2016-10-11 00:00:00 2000                          
387 387 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC6 OTH 2228 Union Street Investors LP       Oakland CA 94609       2016-10-11 00:00:00 2500                          
388 388 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC5 OTH 2232 Seminary LLC       Oakland CA 94609       2016-10-11 00:00:00 1000                          
389 389 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC1 OTH 66 Fairmount LLC       San Francisco CA 94123       2016-10-11 00:00:00 1000                          
390 390 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC3 OTH 685 Scofield, LLC, Houses       Oakland CA 94609       2016-10-11 00:00:00 2500                          
391 391 Pending 22 Coalition to Improve Oakland Government - NO on Measure KK 162 RCP 2016-10-12       INC4 OTH Morse Management       Oakland CA 94612       2016-10-11 00:00:00 5000                          
220 220 Pending 22 Neighbors for a Safer Oakland 2014 98 BMC 2014-08-15       INC1 OTH International Association of Firefighters Local 55       Oakland CA 94612       2014-08-15 00:00:00 100000                          

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