Return to search results
Employee Compensation
A. SUMMARY
The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013.
B. HOW THE DATASET IS CREATED
This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format.
C. UPDATE PROCESS
New data is added on a bi-annual basis when available for each fiscal and calendar year.
D. HOW TO USE THIS DATASET
Before using please first review the following two resources:
Data Dictionary - Can be found in 'About this dataset' section after click 'Show More'
Employee Compensation FAQ
Resources
4 resources available
-
Resource 1
APPLICATION/JSON -
Resource 2
APPLICATION/RDF+XML -
Resource 3
APPLICATION/XML -
Resource 4
TEXT/CSV
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "OpenData",
"@type": "vcard:Contact",
"hasEmail": "mailto:no-reply@data.sfgov.org"
}
|
| description | <strong>A. SUMMARY</strong> The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013. <strong>B. HOW THE DATASET IS CREATED</strong> This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. <strong>C. UPDATE PROCESS</strong> New data is added on a bi-annual basis when available for each fiscal and calendar year. <strong>D. HOW TO USE THIS DATASET</strong> Before using please first review the following two resources: <li>Data Dictionary - Can be found in 'About this dataset' section after click 'Show More' <li><u><a href="https://sfdigitalservices.gitbook.io/dataset-explainers/employee-compensation-faq">Employee Compensation FAQ</a></u> |
| distribution |
[
{
"@type": "dcat:Distribution",
"mediaType": "application/json",
"describedBy": "https://data.sfgov.org/api/views/88g8-5mnd/columns.json",
"downloadURL": "https://data.sfgov.org/api/views/88g8-5mnd/rows.json?accessType=DOWNLOAD",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/rdf+xml",
"describedBy": "https://data.sfgov.org/api/views/88g8-5mnd/columns.rdf",
"downloadURL": "https://data.sfgov.org/api/views/88g8-5mnd/rows.rdf?accessType=DOWNLOAD",
"describedByType": "application/rdf+xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/xml",
"describedBy": "https://data.sfgov.org/api/views/88g8-5mnd/columns.xml",
"downloadURL": "https://data.sfgov.org/api/views/88g8-5mnd/rows.xml?accessType=DOWNLOAD",
"describedByType": "application/xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "text/csv",
"downloadURL": "https://data.sfgov.org/api/views/88g8-5mnd/rows.csv?accessType=DOWNLOAD"
}
]
|
| identifier | https://data.sfgov.org/api/views/88g8-5mnd |
| issued | 2024-05-21 |
| keyword |
[
"benefits",
"compensation",
"employee",
"fte",
"open book",
"openbook",
"salaries",
"salary",
"sfopenbook",
"spending",
"staffing"
]
|
| landingPage | https://data.sfgov.org/d/88g8-5mnd |
| license | http://opendatacommons.org/licenses/pddl/1.0/ |
| modified | 2026-02-16 |
| publisher |
{
"name": "data.sfgov.org",
"@type": "org:Organization"
}
|
| theme |
[
"City Management and Ethics"
]
|
| title | Employee Compensation |
