Campaign Finance - FPPC Form 460 - Schedule D - Summary of Expenditures Supporting/Opposing Other Candidates, Measures and Committees

data.oaklandca.gov | Last Updated 27 May 2024

This dataset includes all itemized expenditures supporting/opposing other candidates, measures and committees ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "D" Expenditures Supporting/Opposing Other Candidates, Measures and Committees from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76

Tags: ethics, campaign, finance, fppc, form, 460, expenditures, support, oppose, candidates, measures, committees

This dataset has the following 65 columns:

Column NameAPI Column NameData TypeSample Values
Filer_IDfiler_idtext
Filer_NamLfiler_namltext
Report_Numreport_numnumber
Committee_Typecommittee_typetext
Rpt_Daterpt_datecalendar_date
From_Datefrom_datecalendar_date
Thru_Datethru_datecalendar_date
Elect_Dateelect_datecalendar_date
tblCover_Office_Cdtblcover_office_cdtext
tblCover_Offic_Dscrtblcover_offic_dscrtext
Rec_Typerec_typetext
Form_Typeform_typetext
Tran_IDtran_idtext
Entity_Cdentity_cdtext
Payee_NamLpayee_namltext
Payee_NamFpayee_namftext
Payee_NamTpayee_namttext
Payee_NamSpayee_namstext
Payee_Adr1payee_adr1text
Payee_Adr2payee_adr2text
Payee_Citypayee_citytext
Payee_Statepayee_statetext
Payee_Zip4payee_zip4text
Expn_Dateexpn_datecalendar_date
Amountamountnumber
Cum_YTDcum_ytdnumber
Expn_ChkNoexpn_chknotext
Expn_Codeexpn_codetext
Expn_Dscrexpn_dscrtext
Agent_NamLagent_namltext
Agent_NamFagent_namftext
Agent_NamTagent_namttext
Agent_NamSagent_namstext
Cmte_IDcmte_idtext
Tres_NamLtres_namltext
Tres_NamFtres_namftext
Tres_NamTtres_namttext
Tres_NamStres_namstext
Tres_Adr1tres_adr1text
Tres_Adr2tres_adr2text
Tres_Citytres_citytext
Tres_STtres_sttext
Tres_ZIP4tres_zip4text
Cand_NamLcand_namltext
Cand_NamFcand_namftext
Cand_NamTcand_namttext
Cand_NamScand_namstext
Office_Cdoffice_cdtext
Offic_Dscroffic_dscrtext
Juris_Cdjuris_cdtext
Juris_Dscrjuris_dscrtext
Dist_Nodist_notext
Off_S_H_Cdoff_s_h_cdtext
Bal_Namebal_nametext
Bal_Numbal_numtext
Bal_Jurisbal_juristext
Sup_Opp_Cdsup_opp_cdtext
Memo_Codememo_codetext
Memo_RefNomemo_refnotext
BakRef_TIDbakref_tidtext
G_From_E_Fg_from_e_ftext
XRef_SchNmxref_schnmtext
XRef_Matchxref_matchtext
Payee_Locationpayee_locationpoint
Tres_Locationtres_locationpoint