Campaign Finance - FPPC Form 460 - Schedule B2 - Loan Guarantors

data.sfgov.org | Last Updated 24 Feb 2020

This dataset includes all itemized guarantors of loans ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "B2" Loan Guarantors 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, loan, guarantors, fppc, form, 460

This dataset has the following 64 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
Lndr_NamLlndr_namltext
Lndr_NamFlndr_namftext
Lndr_NamTlndr_namttext
Lndr_NamSlndr_namstext
Loan_Adr1loan_adr1text
Loan_Adr2loan_adr2text
Loan_Cityloan_citytext
Loan_STloan_sttext
Loan_Zip4loan_zip4text
Loan_Date1loan_date1calendar_date
Loan_Date2loan_date2calendar_date
Loan_Amt1loan_amt1number
Loan_Amt2loan_amt2number
Loan_Amt3loan_amt3number
Loan_Amt4loan_amt4number
Loan_Rateloan_ratetext
Loan_EMPloan_emptext
Loan_OCCloan_occtext
Loan_Selfloan_selftext
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
B2Lender_Name_Inter_nameb2lender_name_inter_nametext
Intr_NamFintr_namftext
Intr_NamTintr_namttext
Intr_NamSintr_namstext
Intr_Adr1intr_adr1text
Intr_Adr2intr_adr2text
Intr_Cityintr_citytext
Intr_STintr_sttext
Intr_ZIP4intr_zip4text
Memo_Codememo_codetext
Memo_RefNomemo_refnotext
BakRef_TIDbakref_tidtext
XRef_SchNmxref_schnmtext
XRef_Matchxref_matchtext
Loan_Amt5loan_amt5number
Loan_Amt6loan_amt6number
Loan_Amt7loan_amt7number
Loan_Amt8loan_amt8number
Loan_Locationloan_locationpoint
Tres_Locationtres_locationpoint
Intr_Locationintr_locationpoint