expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

62 rows where filer_id = 275 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, election_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, 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
3023 3023 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439084 COM         Oakland CA 94612-1941 2024-10-24 20000 20000 MON     Bay Rising Ballot Action Committee                     S  
3024 3024 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500417023 COM         Irvine CA 92612-1001 2024-10-24 20500 20500 MON     Californians United Against Prop 36 Sponsored by Ella Baker Center Action Fund                     S  
3025 3025 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500438809 COM         Oakland CA 94612-3212 2024-10-24 10000 10000 MON     East Bay Action PAC                     S  
3026 3026 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439074 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Oakland     Fund Violence Prevention NN   S  
3027 3027 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439075 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Oakland     Strengthen Public Ethics Oversight OO   S  
3028 3028 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439076 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Education;?Bonds 2   S  
3029 3029 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439078 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Minimum wage 32   S  
3030 3030 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439079 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Housing 33   S  
3031 3031 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439080 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Energy;?Environment;?Water;?Bonds 4   S  
3032 3032 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439082 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Marriage and family;?Constitutional rights 3   S  
3033 3033 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500439083 COM         Oakland CA 94612-1082 2024-10-31 211.33 985.6 IND Voter Guide             Statewide     Constitutional language 6   S  
3034 3034 1455486 275 Oakland Rising Ballot Committee supporting Prop 5 and opposing Prop 36 sponsored by Center for Empowered Politics 489 BMC 2025-01-31 2024-10-20 2024-12-31   500417024 COM         Oakland CA 94607-3510 2024-10-24 8000 8000 MON     Oaklanders Together ? For a Safer Oakland                     S  
3405 3405 1455486 275 Oakland Rising Ballot Committee sponsored by Center for Empowered Politics 425 BMC 2024-07-26 2024-02-18 2024-06-30   1250002141 OTH         San Francisco CA 94109-2704 2024-02-26 75.95 6420.53 IKD MTG                   Recall of Officers Charter Amendment B Alameda County S  
3429 3429 1455486 275 Oakland Rising Ballot Committee sponsored by Center for Empowered Politics 425 BMC 2024-02-21 2024-01-01 2024-02-17 2024-03-05 500368564 COM         Oakland CA 94612-1082 2024-02-09 333.06 6344.58 IND Staff Time                   Recall of Officers Charter Amendment B Alameda County S  
3430 3430 1455486 275 Oakland Rising Ballot Committee sponsored by Center for Empowered Politics 425 BMC 2024-02-21 2024-01-01 2024-02-17 2024-03-05 500368565 COM         Oakland CA 94612-1082 2024-02-09 2580.35 6344.58 IND LIT                   Recall of Officers Charter Amendment B Alameda County S  
3431 3431 1455486 275 Oakland Rising Ballot Committee sponsored by Center for Empowered Politics 425 BMC 2024-02-21 2024-01-01 2024-02-17 2024-03-05 500368566 COM         Oakland CA 94612-1082 2024-02-09 3431.17 6344.58 IND POS                   Recall of Officers Charter Amendment B Alameda County S  
2595 2595 1455486 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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 275 Oakland Rising Ballot Committee Supporting Measure T & W sponsored by Center for Empowered Politics 356 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  

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