Campaign Finance - FPPC Form 460 - Schedule C - Non-Monetary Contributions

data.oaklandnet.com | Last Updated 23 Apr 2019

This dataset includes all itemized non-monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "C" Non-Monetary Contributions 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, in-kind, non-monetary, contributions, fppc, form, 460

This dataset has the following 78 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
Tran_NamLtran_namltext
Tran_NamFtran_namftext
Tran_NamTtran_namttext
Tran_NamStran_namstext
Tran_Adr1tran_adr1text
Tran_Adr2tran_adr2text
Tran_Citytran_citytext
Tran_Statetran_statetext
Tran_Zip4tran_zip4text
Tran_Emptran_emptext
Tran_Occtran_occtext
Tran_Selftran_selftext
Tran_Typetran_typetext
Tran_Datetran_datecalendar_date
Tran_Date1tran_date1calendar_date
Tran_Amt1tran_amt1number
Tran_Amt2tran_amt2number
Tran_Dscrtran_dscrtext
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_Statetres_statetext
Tres_Ziptres_ziptext
Intr_NamLintr_namltext
Intr_NamFintr_namftext
Intr_NamTintr_namttext
Intr_NamSintr_namstext
Intr_Adr1intr_adr1text
Intr_Adr2intr_adr2text
Intr_Cityintr_citytext
Intr_Stateintr_statetext
Intr_Zip4intr_zip4text
Intr_Empintr_emptext
Intr_Occintr_occtext
Intr_Selfintr_selftext
Cand_NamLcand_namltext
Cand_NamFcand_namftext
Cand_NamTcand_namttext
Cand_NamScand_namstext
tblDetlTran_Office_Cdtbldetltran_office_cdtext
tblDetlTran_Offic_Dscrtbldetltran_offic_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
XRef_SchNmxref_schnmtext
XRef_Matchxref_matchtext
Loan_Rateloan_ratetext
Int_CmteIdint_cmteidtext
Tran_Locationtran_locationlocation
Tres_Locationtres_locationlocation
Intr_Locationintr_locationlocation