oaklandca-gov/campaign-finance-fppc-form-460-schedule-b2-loan-4fu2-d832

 
External

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

  • 460
  • campaign
  • ethics
  • finance
  • form
  • And 3 more...

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

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Lndr_NamFlndr_namflndr_namfText
Lndr_NamLlndr_namllndr_namlText
Loan_Adr2loan_adr2loan_adr2Text
Loan_STloan_stloan_stText
Committee_Typecommittee_typecommittee_typeText
Filer_IDfiler_idfiler_idText
Tres_ZIP4tres_zip4tres_zip4Text
Intr_NamFintr_namfintr_namfText
Memo_Codememo_codememo_codeText
Thru_Datethru_datethru_dateCalendar date
Tres_Adr1tres_adr1tres_adr1Text
Loan_Rateloan_rateloan_rateText
Loan_Amt7loan_amt7loan_amt7Number
Tres_Citytres_citytres_cityText
Loan_Adr1loan_adr1loan_adr1Text
Intr_NamTintr_namtintr_namtText
Filer_NamLfiler_namlfiler_namlText
Entity_Cdentity_cdentity_cdText
Form_Typeform_typeform_typeText
tblCover_Offic_Dscrtblcover_offic_dscrtblcover_offic_dscrText
Rpt_Daterpt_daterpt_dateCalendar date
Intr_NamSintr_namsintr_namsText
Loan_Zip4loan_zip4loan_zip4Text
BakRef_TIDbakref_tidbakref_tidText
Intr_Adr2intr_adr2intr_adr2Text
Intr_ZIP4intr_zip4intr_zip4Text
Loan_Amt4loan_amt4loan_amt4Number
Loan_Amt1loan_amt1loan_amt1Number
Tran_IDtran_idtran_idText
Intr_STintr_stintr_stText
Loan_Selfloan_selfloan_selfText
Loan_Date1loan_date1loan_date1Calendar date
XRef_Matchxref_matchxref_matchText
tblCover_Office_Cdtblcover_office_cdtblcover_office_cdText
Loan_Amt6loan_amt6loan_amt6Number
Tres_NamTtres_namttres_namtText
Lndr_NamTlndr_namtlndr_namtText
Loan_OCCloan_occloan_occText
B2Lender_Name_Inter_nameb2lender_name_inter_nameb2lender_name_inter_nameText
XRef_SchNmxref_schnmxref_schnmText
Rec_Typerec_typerec_typeText
Loan_Amt3loan_amt3loan_amt3Number
Loan_Date2loan_date2loan_date2Calendar date
Elect_Dateelect_dateelect_dateCalendar date
Loan_Cityloan_cityloan_cityText
Report_Numreport_numreport_numNumber
Lndr_NamSlndr_namslndr_namsText
Tres_NamFtres_namftres_namfText
Loan_Amt2loan_amt2loan_amt2Number
Intr_Locationintr_locationintr_locationPoint
Loan_Amt5loan_amt5loan_amt5Number
Memo_RefNomemo_refnomemo_refnoText
Loan_EMPloan_emploan_empText
Loan_Amt8loan_amt8loan_amt8Number
Tres_STtres_sttres_stText
Cmte_IDcmte_idcmte_idText
Tres_Adr2tres_adr2tres_adr2Text
Intr_Cityintr_cityintr_cityText
Loan_Locationloan_locationloan_locationPoint
From_Datefrom_datefrom_dateCalendar date
Tres_NamStres_namstres_namsText
Tres_NamLtres_namltres_namlText
Tres_Locationtres_locationtres_locationPoint
Intr_Adr1intr_adr1intr_adr1Text

Upstream Metadata