Massachusetts State Employee Payroll with Position and Department Details

Commonwealth Of Massachusetts Payrollv3 is a production dataset from the Statewide Payroll site. It contains payroll information for state employees, as indicated by columns such as NAME_FIRST, NAME_LAST, POSITION_TITLE, DEPARTMENT_DIVISION, and various pay-related fields. The data is hosted by cthru.data.socrata.com and was last updated on 2026-03-17.

Use Cases

• Analyzing pay distribution and disparities using PAY_TOTAL_ACTUAL, ANNUAL_RATE, and BARGAINING_GROUP_TITLE from 28 available columns.
• Tracking employee tenure and turnover by examining SERVICE_END_DATE, DEPARTMENT_CODE, and POSITION_TYPE.
• Modeling total compensation by aggregating PAY_BASE_ACTUAL, PAY_OVERTIME_ACTUAL, and PAY_BUYOUT_ACTUAL for individual employees.
• Mapping departmental payroll costs by joining DEPARTMENT_DIVISION with PAY_YEAR_TO_DATE and DEPARTMENT_LOCATION_ZIP_CODE.

Strengths

• Dataset includes 28 distinct columns covering employee identity, position, department, and multiple pay components.
• Data is provided in multiple machine-readable formats including CSV, JSON, XML, and RDF.
• Last updated timestamp of 2026-03-17 16:03:59 is explicitly provided.

Limitations

• Row count and total dataset size are unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.
• License and author information are unknown, which may affect usage rights.

Provenance

Source

cthru.data.socrata.com

Collection Method

Likely extracted from the production systems of the Commonwealth of Massachusetts Statewide Payroll site.

Time Range

Temporal coverage is suggested by the YEAR column but specific range is unknown.

Freshness

Last updated 2026-03-17 16:03:59; freshness should be verified.

Geography

Spatial coverage is focused on the Commonwealth of Massachusetts, as indicated by DEPARTMENT_LOCATION_ZIP_CODE.