This dataset includes all itemized contributions of $100 or more e-filed on Fair Political Practices Commission (FPPC) Form 496 "Part 3" Contributions of $100 or More Received from 2009 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
Publishing Department: Ethics Commission
Dataset Link: https://data.sfgov.org/d/p4sp-es3b
Field Name (opt. alias) | Field Definition | API Key |
---|---|---|
BakRef_TID | bakref_tid | |
Bal_Juris | bal_juris | |
Bal_Name | bal_name | |
Bal_Num | bal_num | |
Cand_NamF | cand_namf | |
Cand_NamL | cand_naml | |
Cand_NamS | cand_nams | |
Cand_NamT | cand_namt | |
Cmte_ID | cmte_id | |
Committee_Type | committee_type | |
Dist_No | dist_no | |
Elect_Date | elect_date | |
Entity_Cd | entity_cd | |
Filer_ID | filer_id | |
Filer_NamL | filer_naml | |
Form_Type | form_type | |
From_Date | from_date | |
Int_CmteId | int_cmteid | |
Intr_Adr1 | intr_adr1 | |
Intr_Adr2 | intr_adr2 | |
Intr_City | intr_city | |
Intr_Emp | intr_emp | |
Intr_Location | intr_location | |
Intr_NamF | intr_namf | |
Intr_NamL | intr_naml | |
Intr_NamS | intr_nams | |
Intr_NamT | intr_namt | |
Intr_Occ | intr_occ | |
Intr_Self | intr_self | |
Intr_State | intr_state | |
Intr_Zip4 (Intr ZIP4) | intr_zip4 | |
Juris_Cd | juris_cd | |
Juris_Dscr | juris_dscr | |
Loan_Rate | loan_rate | |
Memo_Code | memo_code | |
Memo_RefNo | memo_refno | |
Off_S_H_Cd | off_s_h_cd | |
Rec_Type | rec_type | |
Report_Num | report_num | |
Rpt_Date | rpt_date | |
Sup_Opp_Cd | sup_opp_cd | |
tblCover_Offic_Dscr | tblcover_offic_dscr | |
tblCover_Office_Cd | tblcover_office_cd | |
tblDetlTran_Offic_Dscr | tbldetltran_offic_dscr | |
tblDetlTran_Office_Cd | tbldetltran_office_cd | |
Thru_Date | thru_date | |
Tran_Adr1 | tran_adr1 | |
Tran_Adr2 | tran_adr2 | |
Tran_Amt1 | tran_amt1 | |
Tran_Amt2 | tran_amt2 | |
Tran_City | tran_city | |
Tran_Date | tran_date | |
Tran_Date1 | tran_date1 | |
Tran_Dscr | tran_dscr | |
Tran_Emp | tran_emp | |
Tran_ID | tran_id | |
Tran_Location | tran_location | |
Tran_NamF | tran_namf | |
Tran_NamL | tran_naml | |
Tran_NamS | tran_nams | |
Tran_NamT | tran_namt | |
Tran_Occ | tran_occ | |
Tran_Self | tran_self | |
Tran_State | tran_state | |
Tran_Type | tran_type | |
Tran_Zip4 (Tran ZIP4) | tran_zip4 | |
Tres_Adr1 | tres_adr1 | |
Tres_Adr2 | tres_adr2 | |
Tres_City | tres_city | |
Tres_Location | tres_location | |
Tres_NamF | tres_namf | |
Tres_NamL | tres_naml | |
Tres_NamS | tres_nams | |
Tres_NamT | tres_namt | |
Tres_State | tres_state | |
Tres_Zip (Tres ZIP) | tres_zip | |
XRef_Match | xref_match | |
XRef_SchNm | xref_schnm |