expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

18 rows where filer_id = 192 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, payee_last_name, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description 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 support_or_oppose memo_reference_number
3266 3266 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2025-01-21 2024-10-20 2024-12-31   EXP206 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-10-25 25000 80000 MON                     Public Safety Tax; Measure NN   City of Oakland S  
3267 3267 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2025-01-21 2024-10-20 2024-12-31   EXP207 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-11-01 5000 80000 MON                     Public Safety Tax; Measure NN   City of Oakland S  
3300 3300 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP205 COM Californians United Against Prop 36, sponsored by the Ella Baker Center Action Fund       Irvine CA 92612 2024-10-18 40000 40000 MON                     Allows Felony Charges and Increases Sentences for Certain Drug and Theft Crimes. Initiative Statute. Proposition 36   Statewide O  
3301 3301 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP193 COM Oakland Rising Ballot Committee sponsored by Center for Empowered Politics       Oakland CA 94612 2024-10-04 3000 80000 MON                           S  
3302 3302 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP195 COM Oakland Rising Ballot Committee sponsored by Center for Empowered Politics       Oakland CA 94612 2024-10-04 8000 80000 MON                     Public Safety Measure. Measure NN   City of Oakland S EXP195
3303 3303 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP196 COM Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics       Oakland CA 94612 2024-10-04 19000 80000 MON                     Allows Felony Charges and Increases Sentences for Certain Drug and Theft Crimes. Initiative Statute. Proposition 36   Statewide O EXP196
3304 3304 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP202 COM Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics       Oakland CA 94612 2024-10-18 37500 80000 MON                     Allows Felony Charges and Increases Sentences for Certain Drug and Theft Crimes. Initiative Statute. Proposition 36   Statewide O  
3305 3305 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP203 COM Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics       Oakland CA 94612 2024-10-18 12500 80000 MON                     Allows Local Bonds for Affordable Housing and Public Infrastructure with 55% Voter Approval. Legislative Constitutional Amendment. Proposition 5   Statewide S  
3306 3306 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-10-23 2024-09-22 2024-10-19 2024-11-05 EXP204 COM Oaklanders Together - For A Safer Oakland, Yes on NN       Oakland CA 94607 2024-10-18 50000 50000 MON                     Public Safety Tax; Measure NN   City of Oakland S  
3375 3375 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2024-09-23 2024-07-01 2024-09-21 2024-11-05 EXP189 COM Polluters Pay Sponsored by Asian Pacific Envrionmental Network Action and Service Employees International Union Local 1021       Oakland CA 94612 2024-08-02 30000 30000 MON                     Oil Refining Business License Tax T City of Richmond S  
2926 2926 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP166 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-03-28 -10000 0 MON Void Check                   Progressive Business Tax III T City of Oakland S  
2927 2927 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP147 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-03-28 -10000 0 MON Void Check                   Just Cause Amendment V City of Oakland S  
2928 2928 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP167 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-03-28 -10000 0 MON Void Check                   Article 34 Affordable Housing Authorization Q City of Oakland S  
2929 2929 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP168 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-03-28 -10000 0 MON Void Check                   New Infrastructure Bond Measure U City of Oakland S  
2930 2930 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP148 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-04-07 10000 0 MON                     Just Cause Amendment V City of Oakland S EXP148
2931 2931 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP156 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-04-07 10000 0 MON                     Article 34 Affordable Housing Authorization Q City of Oakland S EXP156
2932 2932 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP169 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-04-07 10000 0 MON                     Progressive Business Tax III T City of Oakland S EXP169
2933 2933 1400908 192 East Bay Community Foundation (nonprofit 501(c)(3)) 243 RCP 2023-07-24 2023-01-01 2023-06-30   EXP157 COM Committee to Save Our Neighborhoods, Sponsored by Alliance of Californians for Community Empowerment Action       Los Angeles CA 90017-5864 2023-04-07 10000 0 MON                     New Infrastructure Bond Measure U City of Oakland S EXP157

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "expenditure_summaries" (
"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,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "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,
  "support_or_oppose" 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));
CREATE INDEX ["expenditure_summaries_filer_id"] ON [expenditure_summaries]("filer_id");
CREATE INDEX ["expenditure_summaries_filer_name"] ON [expenditure_summaries]("filer_name");
CREATE INDEX ["expenditure_summaries_committee_id"] ON [expenditure_summaries]("committee_id");