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 |