Socrata

Close
Author
Kevin Hobson
Description
The intent of this report is to capture salary, compensation and benefit information for every compensated employee in the city. This report is run for employees who received W2's for the indicated calendar years.
Category
Finance
Tags
salary, pay, compensation, benefits
Rating
Current value: 0 out of 5
Data Provided By
Human Resource Department
Source Link
http://www.smgov.net/hr
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:

Calendar Year
calendar_year
Employment Type
employment_type
Job Title
job_description
Division Name
division_name
Regular Pay
regular_pay
Overtime Pay
over_time_pay
Lump Sum Pay
lump_sum_pay
Assignment and Incentive Pay
assignment_and_incentive_pay
Skill Pay
skills_pay
Outside Employer Pay
outside_pay
Other Pay
other_pay
Retirement Contribution
retirement_contribution
City Paid Deferred Compensation
deferred_compensation_plan
Health Benefits Average
health_average
Cash-in-Lieu of Medical Benefits
cash_in_lieu
Total
total

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.