Campaign Finance - FPPC Form 465 - Supplemental Independent Expenditure Report - Part 3 - Independent Expenditures Made

data.oaklandnet.com | Last Updated 23 Apr 2019

This dataset includes all itemized independent expenditures ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 465 Part 3 Independent Expenditures Made 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, independent, expenditures, fppc, form, 465

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_locationlocation
Tres_Locationtres_locationlocation