Itemized Monetary Contributions to Committees Controlled by Candidates for Mayor 2011

data.sfgov.org | Last Updated 6 Sep 2019

This dataset includes all itemized monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "A" Monetary Contributions from 1998 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 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