This dataset includes all itemized independent expenditures ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 465 Part 3 Independent Expenditures Made 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/pyxa-3r7p
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| Agent_NamF | agent_namf | |
| Agent_NamL | agent_naml | |
| Agent_NamS | agent_nams | |
| Agent_NamT | agent_namt | |
| Amount | amount | |
| 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 | |
| Cum_YTD | cum_ytd | |
| Dist_No | dist_no | |
| Elect_Date | elect_date | |
| Entity_Cd | entity_cd | |
| Expn_ChkNo | expn_chkno | |
| Expn_Code | expn_code | |
| Expn_Date | expn_date | |
| Expn_Dscr | expn_dscr | |
| Filer_ID | filer_id | |
| Filer_NamL | filer_naml | |
| Form_Type | form_type | |
| From_Date | from_date | |
| G_From_E_F | g_from_e_f | |
| Juris_Cd | juris_cd | |
| Juris_Dscr | juris_dscr | |
| Memo_Code | memo_code | |
| Memo_RefNo | memo_refno | |
| Off_S_H_Cd | off_s_h_cd | |
| Offic_Dscr | offic_dscr | |
| Office_Cd | office_cd | |
| Payee_Adr1 | payee_adr1 | |
| Payee_Adr2 | payee_adr2 | |
| Payee_City | payee_city | |
| Payee_Location | payee_location | |
| Payee_NamF | payee_namf | |
| Payee_NamL | payee_naml | |
| Payee_NamS | payee_nams | |
| Payee_NamT | payee_namt | |
| Payee_State | payee_state | |
| Payee_Zip4 (Payee ZIP4) | payee_zip4 | |
| 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 | |
| Thru_Date | thru_date | |
| Tran_ID | tran_id | |
| 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_ST | tres_st | |
| Tres_ZIP4 (Tres ZIP4) | tres_zip4 | |
| XRef_Match | xref_match | |
| XRef_SchNm | xref_schnm |