Campaign Finance - FPPC Form 460 - Summary Totals

data.sfgov.org | Last Updated 29 Jan 2020

This dataset includes all summary totals e-filed on Fair Political Practices Commission (FPPC) Form 460 Summary Page 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, summary, fppc, form, 460

This dataset has the following 16 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Filer_IDfiler_idtextFiler ID (FPPC or Local)
Filer_NamLfiler_namltextFiler Name (Committee Name)
Report_Numreport_numnumberReport Number (Amendment Sequence Order, 000 Original Report, 001-999 Amendment Report #)
Committee_Typecommittee_typetextType of Committee including (CAO - Candidate/Officeholder, CTL - Controlled Committee, RCP - Recipient Committee, SMO - Slate Mailer Organization, BMC - Ballot Measure Committee, MDI - Major Donor/Independent Expenditure
Rpt_Daterpt_datecalendar_dateDate Document is Generated (As Written in CAL Submission)
From_Datefrom_datecalendar_datePeriod Start Date
Thru_Datethru_datecalendar_datePeriod End Date
Elect_Dateelect_datecalendar_dateElection Date
tblCover_Office_Cdtblcover_office_cdtextOffice Sought (Codes in CAL Spec)
tblCover_Offic_Dscrtblcover_offic_dscrtextOffice Sought Description (Required if Office_CD is "OTH" Code for Other)
Rec_Typerec_typetextRecord Type Value (Type of data, IE: Cover Page, Expenditure, etc.)
Form_Typeform_typetextIf a letter then it is a schedule from Form 460; Otherwise indicates FPPC Form number
Line_Itemline_itemtextSummary page line item (If Form Type = FPPC Form # such as 460 then lines from the Summary Page, if Form Type = letters then subtotal lines from each schedule page)
Amount_Aamount_anumberIf Form_Type=F460 then Total this period (From Attached Schedules), if schedule letter value = line item from subtotal on 460 form schedule. If Form Type=other FPPC form, refer to the applicable summary page
Amount_Bamount_bnumberIf Form_Type=F460 then Calendar Year Total to Date, if schedule letter value = line item from subtotal on 460 form schedule. If Form Type=other FPPC form, refer to the applicable summary page
Amount_Camount_cnumberIf Form_Type=F460 then Election Total to Date (No longer in use), if schedule letter value = line item from subtotal on 460 form schedule. If Form Type=other FPPC form, refer to the applicable summary page