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:

PartyType
partytype
PartyLastName
partylastname
PartyFirstName
partyfirstname
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
ContractorAddress
contractoraddress
ContractorEmail
contractoremail
ContractorTelephone
contractortelephone
ContractThresholdAffirmation
contractthresholdaffirmation
ContractDate
contractdate
ContractFileNumber
contractfilenumber
ContractDescription
contractdescription
Comments
comments
ContractApprovalCityElectiveOfficer
contractapprovalcityelectiveofficer
ContractApprovalBoardStateAgency
contractapprovalboardstateagency
BoardStateAgency
boardstateagency
ContractApprovalBoard
contractapprovalboard
BoardName
boardname
SupplementalCheck
supplementalcheck
SignerName
signername
DateSigned
datesigned
AmendmentDescription
amendmentdescription
BidRfpNumber
bidrfpnumber
DescriptionOfAmount
descriptionofamount
DepartmentContactDepartmentCode
departmentcontactdepartmentcode

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:

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/contract-approval-city-officers. This dataset includes the affiliates and subcontractors on efiled SFEC Form 126 Notification of Contract Approval and SFEC 126f4 Notification of Contract Approval Filings. 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

San Francisco Data

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