Boston Employee Earnings Report, 2011 to 2025
- Provider
- City of Boston (Office of Human Resources)
- License
- Open Data Commons Public Domain Dedication and License (PDDL) 1.0
- Format
- Parquet (in sampled files)
- Stored at
- Amazon S3, s3://scigantic-boston-open-data/employee-earnings (us-east-1)
- Access
- Free and public. No account with the data provider is needed.
- Category
- Urban & Civic
- Source
- https://data.boston.gov/dataset/employee-earnings-report
About Boston Employee Earnings Report, 2011 to 2025
The City of Boston's annual payroll disclosure, published for calendar years 2011 through 2025: 343,838 employee-year rows across 15 yearly resources plus a payroll-category data dictionary. One row is one employee in one calendar year. Each carries the employee name, department, job title, residence ZIP code, and gross pay decomposed into six components: regular pay, retroactive pay, other pay, overtime, injured-on-duty pay, paid detail (privately funded police details billed through the city), and Quinn Bill education incentive pay for police officers, summing to total gross. Unusually for a payroll dataset the earnings columns are genuinely typed numeric rather than text, so aggregation works without casting. Because the components are broken out rather than rolled up, this is the dataset behind most reporting on municipal overtime. In calendar year 2023 the five highest total-gross earners in the entire city payroll are all Boston Police Department personnel, led by a police lieutenant at 426,425 dollars of which 221,579 is overtime and 145,775 is regular pay, so overtime alone exceeded base salary. Fifteen years of consistent structure makes it usable for wage growth by department and title, the overtime share of the public safety budget, the geography of the municipal workforce by residence ZIP, and pay dispersion across departments. Three caveats are documented in the schema card. Names are free text with inconsistent formatting between years ('Demesmin,Stanley' with no space) and are not a stable identifier, since employees change name and titles change spelling, so longitudinal tracking by name will both split and merge people. Null in an earnings component means the employee received nothing under that category, not that the value is unknown, so a sum treating null as missing understates total gross. And the column headers drift between years, including a space rather than an underscore in 'TOTAL GROSS' and different capitalisation across files, so a concatenation across years must normalise headers first. This is a lawful public record of public employees' compensation published by the City itself; the schema card notes that the person-level detail should be handled accordingly. Published by the Office of Human Resources under PDDL 1.0. This archive is served from a Scigantic mirror rather than live from the portal: earnings are published once per calendar year and not revised, so s3://scigantic-boston-open-data/employee-earnings/ carries a byte-verbatim copy under raw/ alongside a Snappy Parquet copy under parquet/, FUSE-mounted read-only at ~/archive. The Parquet layer normalises the header drift between years, so the fifteen files concatenate without a rename map.
How to access Boston Employee Earnings Report, 2011 to 2025 in Python
import boto3
from botocore import UNSIGNED
from botocore.client import Config
s3 = boto3.client('s3', region_name='us-east-1', config=Config(signature_version=UNSIGNED))
s3.list_objects_v2(Bucket='scigantic-boston-open-data', Prefix='employee-earnings/', Delimiter='/')Lists the files with anonymous access. Runs on any machine, with no cloud account.
Data structure
File types in sampled files: Parquet
Files
Example file: employee-earnings/parquet/allemployeescy2019_feb19_20final-all.parquet
Sample notebook
Sample notebook for Boston Employee Earnings Report, 2011 to 2025: worked code with the output it printed.
Analyze this dataset without downloading it
On Scigantic, Boston Employee Earnings Report, 2011 to 2025 opens in a hosted JupyterLab notebook with the data already mounted, so you can read files where they are stored instead of copying them first. Each notebook includes an AI assistant that can see the mounted files and write and run analysis code. Open the dataset page to launch a notebook, or browse the full catalog.
This page is also available as Markdown and as JSON.
Related Urban & Civic datasets
- Boston Checkbook Explorer city expenditures, FY2012 to present
- Boston Crime Incident Reports, 2012 to present
- Boston Property Assessment Rolls, FY2004 to FY2026
- Boston Police Field Interrogation and Observation (FIO) records, 2011 to 2025
- Analyze Boston, the City of Boston open data portal (232 datasets)
- Boston 311 Service Requests, 2011 to present
- Philadelphia Zoning Districts
- Boston Fire Incident Reporting, 2012 to 2025