expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

50 rows where filer_name = 369 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, report_date, report_start_date, report_end_date, entity_type, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, office_jurisdiction, ballot_measure_name, ballot_measure_number, 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
2595 2595 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320926 OTH         Los Angeles CA 90016-3911 2022-10-28 1146.93 33087.59 IKD Text Messaging                   Progressive Business Tax III T City of Oakland S  
2596 2596 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320927 OTH         Los Angeles CA 90016-3911 2022-10-28 1146.93 34549.63 IKD Text Messaging                   Campaign Finance Reform W City of Oakland S  
2597 2597 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320936 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             California     Mobile Sports Betting 27   O  
2598 2598 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320937 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             California     Constitutional Amendment: Abortion 1   S  
2599 2599 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320938 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             California     K-12 Music Education Funding 28   S  
2600 2600 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320939 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             California     Kidney Dialysis 29   S  
2601 2601 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320940 COM         Oakland CA 94612-1082 2022-10-25 216.26 33087.59 IKD Voter Guide Staff Time                   Progressive Business Tax III T City of Oakland S  
2602 2602 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320941 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Reduce Dropout Rates; Prepare Oakland Students For College And 21st Century Careers H   S  
2603 2603 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320942 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Providing Affordable Rental Housing Q   S  
2604 2604 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320943 COM         Oakland CA 94612-1082 2022-10-25 216.26 34549.63 IKD Voter Guide Staff Time                   Campaign Finance Reform W City of Oakland S  
2605 2605 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320944 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Authorize Voting By Non Citizen Residents S   S  
2606 2606 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320945 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Amending Oakland's Housing Business Tax Rates T   S  
2607 2607 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320946 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Measure To Improve Public Safety U   S  
2608 2608 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320947 COM         Oakland CA 94612-1082 2022-10-25 45.53 13733.41 IND Voter Guide Staff Time             Oakland     Amending The Just Cause For Eviction Ordinance V   S  
2609 2609 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320948 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Resident Public Financing W   S  
2610 2610 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320949 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Establish Council Member Term Limits X   S  
2611 2611 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320950 COM         Oakland CA 94612-1082 2022-10-25 45.53 422.78 IND Voter Guide Staff Time             Oakland     Amend Oakland Municipal Code Y   S  
2612 2612 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320951 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             California     Mobile Sports Betting 27   O 500320951.0
2613 2613 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320952 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             California     Constitutional Amendment: Abortion 1   S 500320952.0
2614 2614 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320953 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             California     K-12 Music Education Funding 28   S 500320953.0
2615 2615 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320954 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             California     Kidney Dialysis 29   S 500320954.0
2616 2616 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320955 OTH         San Jose CA 95110-3618 2022-10-25 1791.94 33087.59 IKD Voter Guide Printing & Postage                   Progressive Business Tax III T City of Oakland S 500320955.0
2617 2617 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320956 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Reduce Dropout Rates; Prepare Oakland Students For College And 21st Century Careers H   S 500320956.0
2618 2618 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320957 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Providing Affordable Rental Housing Q   S 500320957.0
2619 2619 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320958 OTH         San Jose CA 95110-3618 2022-10-25 1791.94 34549.63 IKD Voter Guide Printing & Postage                   Campaign Finance Reform W City of Oakland S 500320958.0
2620 2620 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320959 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Authorize Voting By Non Citizen Residents S   S 500320959.0
2621 2621 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320960 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Amending Oakland's Housing Business Tax Rates T   S 500320960.0
2622 2622 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320961 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Measure To Improve Public Safety U   S 500320961.0
2623 2623 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320962 OTH         San Jose CA 95110-3618 2022-10-25 377.25 13733.41 IND Voter Guide Printing & Postage             Oakland     Amending The Just Cause For Eviction Ordinance V   S 500320962.0
2624 2624 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320963 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Resident Public Financing W   S 500320963.0
2625 2625 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320964 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Establish Council Member Term Limits X   S 500320964.0
2626 2626 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320965 OTH         San Jose CA 95110-3618 2022-10-25 377.25 422.78 IND Voter Guide Printing & Postage             Oakland     Amend Oakland Municipal Code Y   S 500320965.0
2627 2627 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320919 OTH         San Francisco CA 94109-2704 2022-11-04 1755.45 13733.41 IND Canvass Salary             Oakland     Amending The Just Cause For Eviction Ordinance V   S  
2628 2628 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320920 OTH         San Francisco CA 94109-2704 2022-11-04 4326.31 33087.59 IKD Canvass Salary                   Progressive Business Tax III T City of Oakland S  
2629 2629 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320921 OTH         San Francisco CA 94109-2704 2022-11-04 4844.12 34549.63 IKD Canvass Salary                   Campaign Finance Reform W City of Oakland S  
2630 2630 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320922 OTH         San Francisco CA 94109-2704 2022-11-04 223.52 13733.41 IND Canvass Program Expenses             Oakland     Amending The Just Cause For Eviction Ordinance V   S  
2631 2631 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320929 OTH         San Francisco CA 94109-2704 2022-11-18 4571.65 13733.41 IND Canvass Salary             Oakland     Amending The Just Cause For Eviction Ordinance V   S  
2632 2632 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320930 OTH         San Francisco CA 94109-2704 2022-11-18 2236.25 33087.59 IKD Canvass Salary                   Progressive Business Tax III T City of Oakland S  
2633 2633 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320931 OTH         San Francisco CA 94109-2704 2022-11-18 2000.49 34549.63 IKD Canvass Salary                   Campaign Finance Reform W City of Oakland S  
2634 2634 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320932 OTH         San Francisco CA 94109-2704 2022-11-18 6760.02 33087.59 IKD Canvass Salary                   Progressive Business Tax III T City of Oakland S  
2635 2635 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320933 OTH         San Francisco CA 94109-2704 2022-11-18 6888.09 34549.63 IKD Canvass Salary                   Campaign Finance Reform W City of Oakland S  
2636 2636 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2023-01-28 2022-10-23 2022-12-31   500320934 OTH         San Francisco CA 94109-2704 2022-11-18 6760.01 13733.41 IND Canvass Salary             Oakland     Amending The Just Cause For Eviction Ordinance V   S  
2771 2771 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-10-26 2022-09-25 2022-10-22 2022-11-08 1250001341 OTH         San Francisco CA 94109-2704 2022-10-21 4816.35 16609.88 IKD Canvass Staff Time                   Progressive Business Tax III T City of Oakland S  
2772 2772 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-10-26 2022-09-25 2022-10-22 2022-11-08 1250001342 OTH         San Francisco CA 94109-2704 2022-10-21 5031.1 17661.8 IKD Canvass Staff Time                   Campaign Finance Reform W City of Oakland S  
2773 2773 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-10-26 2022-09-25 2022-10-22 2022-11-08 500290208 OTH         San Francisco CA 94109-2704 2022-10-07 5872.64 16609.88 IKD Canvass Staff Time                   Progressive Business Tax III T City of Oakland S  
2774 2774 1455486 285 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-10-26 2022-09-25 2022-10-22 2022-11-08 500290210 OTH         San Francisco CA 94109-2704 2022-10-07 6185.05 17661.8 IKD Canvass Staff Time                   Campaign Finance Reform W City of Oakland S  
2824 2824 Pending 22 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-09-27 2022-01-01 2022-09-24 2022-11-08 1250001180 OTH         San Francisco CA 94109-2704 2022-09-06 2500 5920.89 IKD Voter Data and Phone Dialer estimate                   Progressive Business Tax III T City of Oakland S  
2825 2825 Pending 22 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-09-27 2022-01-01 2022-09-24 2022-11-08 1250001181 OTH         San Francisco CA 94109-2704 2022-09-06 2500 6445.65 IKD Voter Data and Phone Dialer estimate                   Campaign Finance Reform W City of Oakland S  
2826 2826 Pending 22 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-09-27 2022-01-01 2022-09-24 2022-11-08 1250001182 OTH         San Francisco CA 94109-2704 2022-09-23 3420.89 5920.89 IKD Canvass Staff Time                   Progressive Business Tax III T City of Oakland S  
2827 2827 Pending 22 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 369 BMC 2022-09-27 2022-01-01 2022-09-24 2022-11-08 1250001183 OTH         San Francisco CA 94109-2704 2022-09-23 3945.65 6445.65 IKD Canvass Staff Time                   Campaign Finance Reform W City of Oakland S  

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