Campaign Finance Disclosure E-Filings: Expenses

data.smgov.net | Last Updated 23 Sep 2014

Contribution, Expenditure, Expense, and Loan filings for FPPC forms 460, 461, 465, 496, and 497.

Tags: fppc, elections, proposition 9

This dataset has the following 34 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
filer_idfiler_idtext
filer_namefiler_nametext
filer_type_codefiler_type_codetext
filer_typefiler_typetext
reporting_yearreporting_yearnumber
reporting_datereporting_datecalendar_date
reporting_period_startreporting_period_startcalendar_date
reporting_period_endreporting_period_endcalendar_date
election_dateelection_datecalendar_date
report_numberreport_numbernumber
report_versionreport_versiontext
record_coderecord_codetext
record_typerecord_typetext
form_codeform_codetext
form_nameform_nametext
form_part_codeform_part_codetext
form_part_nameform_part_nametext
transaction_idtransaction_idtext
transaction_descriptiontransaction_descriptiontext
entity_codeentity_codetext
entity_typeentity_typetext
entity_last_nameentity_last_nametext
entity_first_nameentity_first_nametext
entity_cityentity_citytext
entity_stateentity_statetext
entity_zipentity_ziptext
committee_idcommittee_idnumber
expenditure_codeexpenditure_codetext
expenditure_typeexpenditure_typetext
beginning_expenses_balancebeginning_expenses_balancenumber
expenses_incurredexpenses_incurrednumber
expenses_paidexpenses_paidnumber
ending_expenses_balanceending_expenses_balancenumber
identifieridentifiertexta SHA1 hash of the values for the given record