San Francisco Data

Close
Author
San Francisco Ethics Commission
Description
[DEPRECATION WARNING] The source pipeline of this dataset has been upgraded. Starting April 2022 this dataset will no longer update and in June 2022 it will be removed. Please instead refer to <a href="https://data.sfgov.org/City-Management-and-Ethics/Campaign-Finance-Transactions/pitq-e56w">Campaign Finance - Transactions</a> This dataset includes all itemized loans received ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "B1" Loans Received 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 Note: Duplicate rows were removed on 6/16/2021.
Category
City Management and Ethics
Tags
ethics, campaign, finance, loans, received, fppc, form, 460
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
Lndr_NamL
lndr_naml
Lndr_NamF
lndr_namf
Lndr_NamT
lndr_namt
Lndr_NamS
lndr_nams
Loan_Adr1
loan_adr1
Loan_Adr2
loan_adr2
Loan_City
loan_city
Loan_ST
loan_st
Loan_Zip4
loan_zip4
Loan_Date1
loan_date1
Loan_Date2
loan_date2
Loan_Amt1
loan_amt1
Loan_Amt2
loan_amt2
Loan_Amt3
loan_amt3
Loan_Amt4
loan_amt4
Loan_Rate
loan_rate
Loan_EMP
loan_emp
Loan_OCC
loan_occ
Loan_Self
loan_self
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
B2Lender_Name_Inter_name
b2lender_name_inter_name
Intr_NamF
intr_namf
Intr_NamT
intr_namt
Intr_NamS
intr_nams
Intr_Adr1
intr_adr1
Intr_Adr2
intr_adr2
Intr_City
intr_city
Intr_ST
intr_st
Intr_ZIP4
intr_zip4
Memo_Code
memo_code
Memo_RefNo
memo_refno
BakRef_TID
bakref_tid
XRef_SchNm
xref_schnm
XRef_Match
xref_match
Loan_Amt5
loan_amt5
Loan_Amt6
loan_amt6
Loan_Amt7
loan_amt7
Loan_Amt8
loan_amt8
Loan_Location
loan_location
Tres_Location
tres_location
Intr_Location
intr_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.