San Francisco Data

Close
Author
San Francisco Ethics Commission
Description
Each City elective officer who approves a contract that has a total anticipated or actual value of $100,000 or more must file this form with the Ethics Commission within five business days of approval by: (a) the City elective officer, (b) any board on which the City elective officer serves, or (c) the board of any state agency on which an appointee of the City elective officer serves. For more information, see: https://sfethics.org/compliance/city-officers/city-contracts/contract-approval-by-city-elective-officers. This dataset includes electronic SFEC Form 126 Notification of Contract Approval Filings between mid-October 2018 to December 31, 2018 and electronic SFEC Form 126f4 Notification of Contract Approval Filings beginning January 1, 2019. The Affiliates and Subcontractors dataset (https://data.sfgov.org/d/czjm-dat8/) must be joined with the parent dataset (https://data.sfgov.org/d/ite2-5y3b) using the DocuSignID to connect affiliates and subcontractors to the approved contract.
Category
City Management and Ethics
Rating
Current value: 0 out of 5
Data Provided By
San Francisco Ethics Commission
Source Link
https://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:

ContractDate
contractdate
DocuSignID
docusignid
Filing
filing
FilingType
filingtype
OriginalFilingDate
originalfilingdate
FilerContactName
filercontactname
FilerContactDepartmentName
filercontactdepartmentname
FilerContactEmail
filercontactemail
FilerContactTelephone
filercontacttelephone
DepartmentContactName
departmentcontactname
DepartmentContactDepartmentName
departmentcontactdepartmentname
DepartmentContactEmail
departmentcontactemail
DepartmentContactTelephone
departmentcontacttelephone
ElectiveOfficerName
electiveofficername
ElectiveOfficerOffice
electiveofficeroffice
ContractorName
contractorname
ContractorTelephone
contractortelephone
ContractorAddress
contractoraddress
ContractorEmail
contractoremail
ContractThresholdAffirmation
contractthresholdaffirmation
ContractFileNumber
contractfilenumber
ContractDescription
contractdescription
Comments
comments
ContractApprovalCityElectiveOfficer
contractapprovalcityelectiveofficer
ContractApprovalBoardStateAgency
contractapprovalboardstateagency
BoardStateAgency
boardstateagency
ContractApprovalBoard
contractapprovalboard
BoardName
boardname
PartiesSubTableQuery
partiessubtablequery
SupplementalCheck
supplementalcheck
SignerName
signername
DateSigned
datesigned
AmendmentDescription
amendmentdescription
BidRfpNumber
bidrfpnumber

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.