San Francisco Data

Close
Author
San Francisco Ethics Commission
Description
Under San Francisco Campaign & Governmental Conduct Code Section 1.125, any committee controlled by a City elective officer or candidate for City elective office that receives contributions totaling $5,000 or more that have been bundled by a single individual shall file Form 125 at the same time that they are required to file semi-annual or pre-election campaign statements until the committee is terminated. Committees shall be required to provide this information following the receipt of the final contribution that makes the cumulative total $5,000 or more. For more information visit www.sfethics.org. Each row on this table represents the contents of a Form 125 filed with the Ethics Commission. There are two sub-tables of information on "Officers" and "Contributions". The sub-tables are parsed into separate datasets: "SFEC Form 125 - Bundled Contributions Disclosure Report - Officers" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/x9je-gi3q and "SFEC Form 125 - Bundled Contributions Disclosure Report - Contributions" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/dzp4-4my5. Join this dataset with the sub-table using the DocuSignID.
Category
City Management and Ethics
Rating
Current value: 0 out of 5
Data Provided By
San Francisco Ethics Commission
Source Link
https://www.sfethics.org
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:

DocuSign ID
docusignid
Filing URL
filing
Filing Type
filingtype
Original Filing Date
originalfilingdate
Amendment Description
amendmentdescription
Statement Period Start Date
startdate
Statement Period End Date
enddate
Bundler Name
bundlername
Bundler Street
bundlerstreet
Bundler Zip Code
bundlerzip
Bundler City
bundlercity
Bundler State
bundlerstate
Bundler Occupation
bundleroccupation
Bundler Employer
bundleremployer
FPPC ID
fppcid
Committee Name
committeename
Controlling Candidate Officer Name
controllingcandidateofficername
Member Board Commission
memberboardcommission
Board Commission Name
boardcommissionname
Date Signed
datesigned
Signer Name
signername
Officers Sub-table Query URL
officerssubtablequery
Additional Contributors Checkbox
additionalcontributorscheckbox
Contributors Sub-table Query URL
contributorssubtablequery

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.