Purchasing Commodity Data
The San Francisco Controller's Office maintains a database of purchasing activity from fiscal year 2007 forward. This data is presented on the Purchasing Commodity Data report in CSV format, and represents detailed commodity-level data by purchase order. Additional lines have been added to this dataset to reconcile some document totals from the City's purchasing system to the totals from the City's accounting system in cases when the two amounts are different, which sometimes occurs due to adjustments entered into the accounting system but not the purchasing system. We have removed sensitive information from this data – this is intended to show payments made to entities providing goods and services to the City and County and to protect individuals. For example, we have removed payments to employees (reimbursements, garnishments) and jury members, revenue refunds, payments for judgments and claims, witnesses, relocation and rehousing, and a variety of human services payments. New data is added on a weekly basis.
Supplier payments represent payments to City contractors and vendors that provide goods and/or services to the City. Certain other non-supplier payee payments, which are made to parties other than traditional City contractors and vendors, are also included in this dataset, These include payments made for tax and fee refunds, rebates, settlements, etc.
Resources
4 resources available
-
Resource 1
APPLICATION/JSON -
Resource 2
APPLICATION/RDF+XML -
Resource 3
APPLICATION/XML -
Resource 4
TEXT/CSV
Find Related Datasets
Search by Tags
Click any tag below to search for similar datasets
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "OpenData",
"@type": "vcard:Contact",
"hasEmail": "mailto:no-reply@data.sfgov.org"
}
|
| description | The San Francisco Controller's Office maintains a database of purchasing activity from fiscal year 2007 forward. This data is presented on the Purchasing Commodity Data report in CSV format, and represents detailed commodity-level data by purchase order. Additional lines have been added to this dataset to reconcile some document totals from the City's purchasing system to the totals from the City's accounting system in cases when the two amounts are different, which sometimes occurs due to adjustments entered into the accounting system but not the purchasing system. We have removed sensitive information from this data – this is intended to show payments made to entities providing goods and services to the City and County and to protect individuals. For example, we have removed payments to employees (reimbursements, garnishments) and jury members, revenue refunds, payments for judgments and claims, witnesses, relocation and rehousing, and a variety of human services payments. New data is added on a weekly basis. Supplier payments represent payments to City contractors and vendors that provide goods and/or services to the City. Certain other non-supplier payee payments, which are made to parties other than traditional City contractors and vendors, are also included in this dataset, These include payments made for tax and fee refunds, rebates, settlements, etc. |
| distribution |
[
{
"@type": "dcat:Distribution",
"mediaType": "application/json",
"describedBy": "https://data.sfgov.org/api/views/ebsh-uavg/columns.json",
"downloadURL": "https://data.sfgov.org/api/views/ebsh-uavg/rows.json?accessType=DOWNLOAD",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/rdf+xml",
"describedBy": "https://data.sfgov.org/api/views/ebsh-uavg/columns.rdf",
"downloadURL": "https://data.sfgov.org/api/views/ebsh-uavg/rows.rdf?accessType=DOWNLOAD",
"describedByType": "application/rdf+xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/xml",
"describedBy": "https://data.sfgov.org/api/views/ebsh-uavg/columns.xml",
"downloadURL": "https://data.sfgov.org/api/views/ebsh-uavg/rows.xml?accessType=DOWNLOAD",
"describedByType": "application/xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "text/csv",
"downloadURL": "https://data.sfgov.org/api/views/ebsh-uavg/rows.csv?accessType=DOWNLOAD"
}
]
|
| identifier | https://data.sfgov.org/api/views/ebsh-uavg |
| issued | 2025-01-27 |
| keyword |
[
"amount",
"commodity",
"procurement",
"purchase order",
"purchasing",
"spending",
"vendor"
]
|
| landingPage | https://data.sfgov.org/d/ebsh-uavg |
| license | http://opendatacommons.org/licenses/pddl/1.0/ |
| modified | 2026-05-04 |
| publisher |
{
"name": "data.sfgov.org",
"@type": "org:Organization"
}
|
| theme |
[
"City Management and Ethics"
]
|
| title | Purchasing Commodity Data |
