on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

79 rows where filer_id = 57 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, payee_last_name, payee_city, payee_state, payee_zipcode, year_to_date, expenditure_type, expenditure_description, memo_reference_number, 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
5813 5813 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-07-13 2023-01-01 2023-06-30   EDT31 OTH Southwest       Dallas TX 75235 2023-02-21 515.92 515.92 TRS                              
5209 5209 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT27 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-11-04 1219.85 5825.9 POS                              
5210 5210 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT28 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-11-04 854.76 5825.9 LIT                              
5211 5211 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT26 OTH US Postal Service       Oakland CA 94615 2022-11-04 23902 98986.9 POS                              
5212 5212 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT29 OTH US Postal Service       Oakland CA 94615 2022-11-04 19980 98986.9 POS                              
5213 5213 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT23 OTH Department of the Treasury       Atlanta GA 30348 2022-10-31 557.5 1929.38 SAL                              
5214 5214 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT24 OTH Department of the Treasury       Atlanta GA 30348 2022-11-15 846.94 1929.38 SAL                              
5215 5215 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT25 OTH Department of the Treasury       Atlanta GA 30348 2022-12-15 113.44 1929.38 SAL                              
5216 5216 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   PDT36 OTH Tacos La San Marquena       Oakland CA 94612 2022-11-10 1200 1200 MTG                              
5217 5217 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT21 OTH DSPolitical       Washington DC 20005 2022-11-03 1895 18025   Digital ads                            
5218 5218 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT22 OTH DSPolitical       Washington DC 20005 2022-11-04 2120 18025   Digital ads                            
5219 5219 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT30 OTH DSPolitical       Washington DC 20005 2022-11-04 14010 18025   Digital ads                            
5220 5220 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   PDT25 OTH Digidial, LLC       Washington DC 20016 2022-10-30 5062.2 12176.38   Texting Campaign                            
5221 5221 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT19 OTH Digidial, LLC       Washington DC 20016 2022-11-02 2179.8 12176.38   Texting Campaign                            
5222 5222 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT15 OTH KW Call Center Services       Superior WI 54880 2022-10-27 2566.5 26492.77 PHO                              
5223 5223 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   PDT26 OTH KW Call Center Services       Superior WI 54880 2022-10-30 5006.15 26492.77 PHO                              
5224 5224 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT20 OTH KW Call Center Services       Superior WI 54880 2022-11-05 18920.12 26492.77 PHO                              
5225 5225 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   PDT24 OTH Shoutpoint, Inc.       Newport Beach CA 92660 2022-10-24 1629.84 1629.84 PHO                              
5226 5226 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT18 OTH AudioGo       San Mateo CA 94402 2022-11-06 5000 5000 RAD                              
5227 5227 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT16 OTH Meta Platforms       Menlo Park CA 94025 2022-11-06 10000 20000   Digital ads                            
5228 5228 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-25 2022-10-23 2022-12-31   EDT17 OTH Meta Platforms       Menlo Park CA 94025 2022-11-06 10000 20000   Digital ads                            
4500 4500 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 EDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-13 1180.7 1180.7 CMP                              
4501 4501 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 EDT8 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 379 679 MTG                              
4502 4502 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 EDT9 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 300 679 MTG                              
4503 4503 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 EDT6 OTH Oakland Unified School District       Oakland CA 94606 2022-08-23 120.51 1341.56 MTG                             EDT6
4504 4504 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 PDT3 OTH Oakland Unified School District       Oakland CA 94606 2022-09-07 89.57 1341.56 MTG                             PDT3
4505 4505 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 PDT5 OTH Oakland Unified School District       Oakland CA 94606 2022-09-20 444.12 1341.56 MTG                             PDT5
4506 4506 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 PDT6 OTH Oakland Unified School District       Oakland CA 94606 2022-09-21 222.06 1341.56 MTG                             PDT6
4507 4507 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-07-01 2022-09-24 2022-11-08 PDT33 OTH The Orange Market       Oakland CA 94611 2022-09-20 1019.16 1019.16 FND Catering for event                            
4856 4856 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 EDT12 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-06 1291.27 3751.29 LIT                              
4857 4857 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT10 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-07 52.48 3751.29 CMP                              
4858 4858 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 1226.84 3751.29 LIT                              
4859 4859 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 EDT11 OTH US Postal Service       Oakland CA 94615 2022-10-06 27451.45 55003.9 POS                              
4860 4860 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT8 OTH US Postal Service       Oakland CA 94615 2022-10-13 27451.45 55003.9 POS                              
4861 4861 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT19 OTH Oakland Unified School District       Oakland CA 94606 2022-10-10 100.3 3278.92 MTG                             PDT19
4862 4862 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT20 OTH Oakland Unified School District       Oakland CA 94606 2022-10-19 100.3 3278.92 MTG                             PDT20
4863 4863 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2023-01-12 2022-09-25 2022-10-22 2022-11-08 PDT23 OTH Digidial, LLC       Washington DC 20016 2022-10-17 4934.38 4934.38   Texting Campaign                            
4864 4864 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 EDT12 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-06 1291.27 3751.29 LIT                              
4865 4865 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT10 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-07 52.48 3751.29 CMP                              
4866 4866 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 1226.84 3751.29 LIT                              
4867 4867 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 EDT11 OTH US Postal Service       Oakland CA 94615 2022-10-06 27451.45 55003.9 POS                              
4868 4868 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT8 OTH US Postal Service       Oakland CA 94615 2022-10-13 27451.45 55003.9 POS                              
4869 4869 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT19 OTH Oakland Unified School District       Oakland CA 94606 2022-10-10 100.3 3278.92 MTG                             PDT19
4870 4870 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT20 OTH Oakland Unified School District       Oakland CA 94606 2022-10-19 100.3 3278.92 MTG                             PDT20
4871 4871 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT7 OTH Oaktoberfest       Oakland CA 94602 2022-09-26 285 570 MTG                              
4872 4872 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-05 2022-09-25 2022-10-22 2022-11-08 PDT23 OTH Digidial, LLC       Washington DC 20016 2022-10-17 4934.38 4934.38   Texting Campaign                            
4508 4508 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 EDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-13 1180.7 1180.7 CMP                              
4509 4509 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 EDT8 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 379 679 MTG                              
4510 4510 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 EDT9 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 300 679 MTG                              
4511 4511 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 EDT6 OTH Oakland Unified School District       Oakland CA 94606 2022-08-23 120.51 1341.56 MTG                             EDT6
4512 4512 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 PDT3 OTH Oakland Unified School District       Oakland CA 94606 2022-09-07 89.57 1341.56 MTG                             PDT3
4513 4513 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 PDT5 OTH Oakland Unified School District       Oakland CA 94606 2022-09-20 444.12 1341.56 MTG                             PDT5
4514 4514 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-11-01 2022-07-01 2022-09-24 2022-11-08 PDT6 OTH Oakland Unified School District       Oakland CA 94606 2022-09-21 222.06 1341.56 MTG                             PDT6
5395 5395 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 EDT12 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-06 1291.27 3751.29 LIT                              
5396 5396 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT10 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-07 52.48 3751.29 CMP                              
5397 5397 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 1226.84 3751.29 LIT                              
5398 5398 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 EDT11 OTH US Postal Service       Oakland CA 94615 2022-10-06 27451.45 55003.9 POS                              
5399 5399 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT8 OTH US Postal Service       Oakland CA 94615 2022-10-13 27451.45 55003.9 POS                              
5400 5400 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT19 OTH Oakland Unified School District       Oakland CA 94606 2022-10-10 100.3 3278.92 MTG                             PDT19
5401 5401 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT20 OTH Oakland Unified School District       Oakland CA 94606 2022-10-19 100.3 3278.92 MTG                             PDT20
5402 5402 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT7 OTH Oaktoberfest       Oakland CA 94602 2022-09-26 285 570 MTG                              
5403 5403 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PDT23 OTH Digidial, LLC       Washington DC 20016 2022-10-17 4934.38 4934.38   Texting Campaign                            
5587 5587 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-09-25 2022-07-01 2022-09-24 2022-11-08 EDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-13 1180.7 1180.7 CMP                              
5588 5588 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-09-25 2022-07-01 2022-09-24 2022-11-08 EDT8 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 379 679 MTG                              
5589 5589 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-09-25 2022-07-01 2022-09-24 2022-11-08 EDT9 OTH Drake's Dealership       Oakland CA 94612 2022-09-15 300 679 MTG                              
5590 5590 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-09-25 2022-07-01 2022-09-24 2022-11-08 EDT6 OTH Oakland Unified School District       Oakland CA 94606 2022-08-23 120.51 675.38 MTG                             EDT6
5591 5591 960997 57 Friends of Oakland Public Schools - Yes on Measure H 355 RCP 2022-09-25 2022-07-01 2022-09-24 2022-11-08 PDT3 OTH Oakland Unified School District       Oakland CA 94606 2022-09-07 89.57 675.38 MTG                             PDT3
3972 3972 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-21 2020-10-18 2020-12-31   EDT3 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-26 456.37 7631.74 CMP Sales Tax                            
3973 3973 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-21 2020-10-18 2020-12-31   EDT4 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-26 2674.31 7631.74 LIT Sales Tax                            
3974 3974 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-21 2020-10-18 2020-12-31   EDT5 OTH US Postal Service       Oakland CA 94615 2020-10-26 19155.75 19155.75 POS                              
3562 3562 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-19 2020-07-01 2020-09-19 2020-11-03 PDT1 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-14 371.28 1232.47 CMP Sales Tax                            
3563 3563 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-19 2020-07-01 2020-09-19 2020-11-03 PDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-17 861.19 1232.47 CMP Sales Tax                            
3648 3648 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-19 2020-09-20 2020-10-17 2020-11-03 EDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-02 3268.59 4501.06 LIT Sales Tax                            
3649 3649 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2021-01-19 2020-09-20 2020-10-17 2020-11-03 EDT1 OTH Postmaster       Oakland CA 94623- 2020-10-02 25189.63 25189.63 POS                              
4134 4134 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-02 3268.59 4501.06 LIT Sales Tax                            
4135 4135 960997 57 Friends of Oakland Public Schools - Yes on Measure Y 269 RCP 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT1 OTH Postmaster       Oakland CA 94623- 2020-10-02 25189.63 25189.63 POS                              
670 670 960997 57 Friends of Oakland Public Schools for Measure N 79 BMC 2015-01-07 2014-07-01 2014-12-31 2012-11-06 G403-S OTH Office Depot       Oakland CA 94601 2014-10-29 1188.05 0 POS Postage for GOTV Postcards   na na             COLLEGE AND CAREER FOR ALL N City of Oakland S  
671 671 960997 57 Friends of Oakland Public Schools for Measure N 79 BMC 2015-01-07 2014-07-01 2014-12-31 2012-11-06 G404-S OTH Fed Ex Office       Oakland CA 94601 2014-10-29 666.22 0 LIT GOTV Mailer and printing   na na             COLLEGE AND CAREER FOR ALL N City of Oakland S  
672 672 960997 57 Friends of Oakland Public Schools for Measure N 79 BMC 2015-01-07 2014-07-01 2014-12-31 2012-11-06 G405-S OTH Office Depot       Oakland CA 94601 2014-10-29 166.27 0 LIT Labels and envelopes for GOTV mailing   na na             COLLEGE AND CAREER FOR ALL N City of Oakland S  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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 ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");