San Francisco Data

Close
Author
San Francisco Ethics Commission
Description
This dataset includes all itemized expenditures supporting/opposing other candidates, measures and committees ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "D" Expenditures Supporting/Opposing Other Candidates, Measures and Committees 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
Category
City Management and Ethics
Tags
ethics, campaign, finance, fppc, form, 460, expenditures, support, oppose, candidates, measures, committees
Rating
Current value: 0 out of 5
Data Provided By
San Francisco Ethics Commission
Source Link
http://nf4.netfile.com/pub2?aid=sfo
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Filer_ID
filer_id
Filer_NamL
filer_naml
Report_Num
report_num
Committee_Type
committee_type
Rpt_Date
rpt_date
From_Date
from_date
Thru_Date
thru_date
Elect_Date
elect_date
tblCover_Office_Cd
tblcover_office_cd
tblCover_Offic_Dscr
tblcover_offic_dscr
Rec_Type
rec_type
Form_Type
form_type
Tran_ID
tran_id
Entity_Cd
entity_cd
Payee_NamL
payee_naml
Payee_NamF
payee_namf
Payee_NamT
payee_namt
Payee_NamS
payee_nams
Payee_Adr1
payee_adr1
Payee_Adr2
payee_adr2
Payee_City
payee_city
Payee_State
payee_state
Payee_Zip4
payee_zip4
Expn_Date
expn_date
Amount
amount
Cum_YTD
cum_ytd
Expn_ChkNo
expn_chkno
Expn_Code
expn_code
Expn_Dscr
expn_dscr
Agent_NamL
agent_naml
Agent_NamF
agent_namf
Agent_NamT
agent_namt
Agent_NamS
agent_nams
Cmte_ID
cmte_id
Tres_NamL
tres_naml
Tres_NamF
tres_namf
Tres_NamT
tres_namt
Tres_NamS
tres_nams
Tres_Adr1
tres_adr1
Tres_Adr2
tres_adr2
Tres_City
tres_city
Tres_ST
tres_st
Tres_ZIP4
tres_zip4
Cand_NamL
cand_naml
Cand_NamF
cand_namf
Cand_NamT
cand_namt
Cand_NamS
cand_nams
Office_Cd
office_cd
Offic_Dscr
offic_dscr
Juris_Cd
juris_cd
Juris_Dscr
juris_dscr
Dist_No
dist_no
Off_S_H_Cd
off_s_h_cd
Bal_Name
bal_name
Bal_Num
bal_num
Bal_Juris
bal_juris
Sup_Opp_Cd
sup_opp_cd
Memo_Code
memo_code
Memo_RefNo
memo_refno
BakRef_TID
bakref_tid
G_From_E_F
g_from_e_f
XRef_SchNm
xref_schnm
XRef_Match
xref_match
Payee_Location
payee_location
Tres_Location
tres_location

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.