Data · dataset · 2020
Supplier Contracts
Listed in DataSF Open Data Portal
The San Francisco Controller's Office maintains a database of contracts and payments made to Suppliers (vendors, contractors and grantees).
Description
The Supplier Contracts shown here include all fully executed, expenditure-only contracts, including City contracts for commodities, professional and general services, and construction from fiscal year 2018 forward, based upon the contracting departments' inputs. This data set includes both departmental and citywide contracts.
This data is presented on the Supplier Contracts report hosted at openbook.sfgov.org, and is also available in CSV format, which lists summary data by contract. We have removed sensitive contracts and information from this data in order to balance disclosure requirements and protected/confidential data. For example, we have removed contracts related to certain legal proceedings that are exempt from disclosure.
Read the rest (4 more)
New data is added on a weekly basis. Revenue contracts, including concessions and rental income contracts, are not included in this data set; they are tracked in departmental subsystems and currently are not available in SF Open Book. For more information about Revenue Contracts, please contact the respective City Department that awards the contract, e.g. for Airport Concession Contracts, contact the San Francisco Airport Commission which maintains these records.
City Department spending may occur three ways: 1) from Contract to Purchase Order (i.e. a PO with an accounting Encumbrance) to Payment (i.e. an accounting Voucher), AKA On-Contract spending, 2) direct-to-Purchase Order (no contract, only a PO agreement and accounting Encumbrance) to Payment, and 3) Direct Voucher Payment (for limited one-time, non-recurring payments, e.g. a membership or a subscription). Therefore, it is helpful to use both the Supplier Contracts and Supplier Payments reports on SFOpenBook, as well as on DataSF.
The data included in the Supplier Contracts dataset reflects supplier expenditure contracts that were awarded by City Departments after 7/1/2017, the date the City & County of San Francisco implemented the PeopleSoft Financial & Procurement System, as well as the remaining not-to-exceed contract authority for all supplier expenditure contracts that were still active along with their associated purchase order (PO) available, unexpended balances as of 7/1/2017.
For partially used contract authority, the Contract Award Amount only includes the portion that was unutilized and available as of 7/1/2017, unless the Contract Award Amount was updated by the department after July 1, 2017. Contracts that were expired before 7/1/2017 as well as contracts that had no remaining contracting authority from which to issue new purchase orders were not converted or loaded into PeopleSoft. For information requests regarding the latter as well as for the portion of contract of authority used prior to 7/1/2017 for otherwise unexpired contract balances that were converted and still active as of 7/1/2017, please contact the City department(s) that issued the contract.
Links
Get the data
- CSV data.sf.gov/api/views/cqi5-hm2d/rows.csv?accessType=DOWNLOAD ↗
download · from data sf gov
Where it is published
- DataSF Open Data Portal dataset page data.sf.gov/City-Management-and-Ethics/Supplier-Contracts/cqi5-hm2d ↗
landing page · from data sf gov
Catalogue records · 1
- SODA API data.sf.gov/resource/cqi5-hm2d.json ↗
metadata API · from data sf gov
Topics
- Stated by source
- City Management and Ethics
- From keywords
- Economics & Finance
Related
- Possibly the same asSupplier Contracts
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| DataSF Open Data Portal | cqi5-hm2d | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| concepts[field].local:field:economics-finance | mapping · data sf gov | connector:data_sf_gov@1.0.0 | |
| concepts[topic].socrata_category:data_sf_gov:city-management-and-ethics | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| created_date | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| description | source · data sf gov | connector:data_sf_gov@1.0.0 | /resource/description |
| license | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| publication_date | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| title | source · data sf gov | connector:data_sf_gov@1.0.0 | /resource/name |
| updated_date | source · data sf gov | connector:data_sf_gov@1.0.0 |