{"success":true,"data":{"author":"City of Boston (Office of Human Resources)","bucketAccessType":"public","bucketListable":true,"bucketName":"scigantic-boston-open-data","bucketPrefix":"employee-earnings/","category":"Urban & Civic","cloudProvider":"aws","createdAt":"2026-08-15T00:00:00.000Z","description":"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.","displayTitle":"Boston Employee Earnings Report, 2011 to 2025","dockerImageUrl":"531775725781.dkr.ecr.us-east-1.amazonaws.com/scigantic-notebook-minimal:latest","id":"35e0063f-e57b-57df-ae62-ad4042772e68","license":"Open Data Commons Public Domain Dedication and License (PDDL) 1.0","objectCountEstimate":2,"probeStatus":"ok","referenceUrl":"https://data.boston.gov/dataset/employee-earnings-report","region":"us-east-1","schemaCard":{"accessHints":[{"snippet":"import boto3\nfrom botocore import UNSIGNED\nfrom botocore.client import Config\ns3 = boto3.client('s3', region_name='us-east-1', config=Config(signature_version=UNSIGNED))\ns3.list_objects_v2(Bucket='scigantic-boston-open-data', Prefix='employee-earnings/', Delimiter='/')","language":"python-anonymous"},{"snippet":"open('/mnt/archive/parquet/allemployeescy2019_feb19_20final-all.parquet', 'rb')","language":"python-local"}],"caveats":["Files are binary — use a domain-specific parser (e.g. metpy / pynexrad / pydicom) rather than text I/O."],"format":"binary","generatedAt":"2026-08-31T02:05:01.099Z","layout":{"pattern":"{prefix}/{seg1}/{filename}","example":"employee-earnings/parquet/allemployeescy2019_feb19_20final-all.parquet"},"mountPath":"/mnt/archive","sampleHeaders":[{"encoding":"hex","key":"employee-earnings/parquet/allemployeescy2019_feb19_20final-all.parquet","bytes":"504152311504159ab53a1596ef274c1580eb021500120000cd9a1df06511000000426f74746f6d6c65792c546f72696920410d000000536d6974682c4c696e636f6c6e110000004b657276696e2c54696d6f746879204d2e1000000044616e696c65636b692c4a6f686e2048100000004d6167756972652c4a6f73657068204d0c00000d4ef0695365616e20500a0000004c65652c5761696d616e140000004669747a7061747269636b2c4a616d6573204a2e12000000446f68657274792c4d69636861656c204a2e11000000426172726574742c54686f6d617320452e0e0000005669636b6572732c4d61726b20570e01c1307765656e65792c53746576656e01ad384a6f7365792c57696e64656c6c20430563144d63436f726d01791c4b656c6c6579204a21122043756c6c6974792c500995091518486f636b696e67158e88450e000000416e647265732c416c667265646f0c000000576562622c4b65697468204101101842726f776e2c4a211f004d01862c57616c73682c4461766964200116216d3042756c6d616e2c4572696320570111005301810876616e01d000630168144d63427269650d4800460123095818477265676f7279012304546821101c2c5465727279204a011234436f6f7065722c442e204d61726b017d084d6572216620732c4b69726b20442e012600442d66259e09a338696c736f6e2c43","truncatedAt":512},{"truncatedAt":512,"encoding":"hex","key":"employee-earnings/parquet/city-of-boston-calendar-year-2020-earnings.parquet","bytes":"50415231150415a88b3715d2cb254c15b2d4021500120000d4c51b740c000000536d6974682c5365616e20500a0000004c65652c5761696d616e011e6042726f776e2c4a6f686e204d1000000044616e696c65636b690914f0404811000000426172726574742c54686f6d617320452e120000004d63436f726d69636b2c4b656c6c6579204a10000000436f6e6e6f6c6c792c54696d6f7468790e0181307765656e65792c53746576656e015140486f636b696e672c4d69636861656c204501156843756c6c6974792c5061747269636b204a0e000000487567686573098c04432e01120985442c5465727279204a0f00000050757365792c01b910656c20432e01d62c576562622c4b65697468204101d63c46616365792c4c65696768746f6e20420170184b657276696e2c0da90c204d2e17017054617272696e67746f6e2c4d61726b2057696c6c69616d01443c436963636f6c6f2c526f6265727420572105484b6f7a6d69736b692c54686572657365204d0d01f101ca04766105430063016b4043617373656c6c6975732c4272656e64610126304765726f2c4a6172726f642041014d4443656c6c756363692c436861726c6573204a011618446f6865727479352c004a250621b110736f6e2c52212a0045019f105768616c6505111468617264204c212c284a616d65732c416c6672650d64184d63436172746819"}],"sampleObjects":["employee-earnings/parquet/allemployeescy2019_feb19_20final-all.parquet","employee-earnings/parquet/city-of-boston-calendar-year-2020-earnings.parquet","employee-earnings/parquet/employee-earnings-report-2011.parquet","employee-earnings/parquet/employee-earnings-report-2012.parquet","employee-earnings/parquet/employee-earnings-report-2013.parquet"],"sidecars":[{"truncated":false,"name":"README.md","encoding":"utf8","size":2533,"bytes":"# Employee Earnings Report\n\nVerbatim mirror of City of Boston open data, taken from data.boston.gov.\nUpstream cadence: annual; one file per calendar year, 2011 to 2025.\nLicense: Open Data Commons Public Domain Dedication and License (PDDL). PDDL is a public-domain dedication, so this\nredistribution is explicitly permitted; the city remains the source of record.\n\n- `raw/` is byte-identical to what data.boston.gov serves.\n- `parquet/` holds the same rows as Snappy Parquet, every column a string\n  (zero-padded ids like ward `06` and ZIP `02128` would be destroyed by type\n  inference). Cast explicitly when you need numbers.\n\nSee MANIFEST.json at the bucket root for source URLs, CKAN resource ids,\nsha256 digests and row counts.\n\n| file | format | rows | raw | parquet |\n| --- | --- | --- | --- | --- |\n| employee-earnings-report-2025.csv | CSV | 25,397 | 2.8M | employee-earnings-report-2025.parquet 1.2M |\n| employee_earnings_report_2024.csv | CSV | 25,530 | 2.8M | employee_earnings_report_2024.parquet 1.2M |\n| employee-earnings-report-2023.xlsx | CSV | 25,812 | 2.0M | employee-earnings-report-2023.parquet 1.3M |\n| finalconsolidatedcy22earnings_feb2023.xlsx-sheet1.csv | CSV | 23,204 | 2.5M | finalconsolidatedcy22earnings_feb2023.xlsx-sheet1.parquet 1.1M |\n| employee-earnings-report-2021.csv | CSV | 22,552 | 2.4M | employee-earnings-report-2021.parquet 1.0M |\n| city-of-boston-calendar-year-2020-earnings.csv | CSV | 21,858 | 2.5M | city-of-boston-calendar-year-2020-earnings.parquet 1.0M |\n| allemployeescy2019_feb19_20final-all.csv | CSV | 23,312 | 3.4M | allemployeescy2019_feb19_20final-all.parquet 1.1M |\n| employeeearningscy18full.csv | CSV | 23,605 | 2.6M | employeeearningscy18full.parquet 1.1M |\n| employee-earnings-report-2017.csv | CSV | 22,245 | 2.5M | employee-earnings-report-2017.parquet 1.0M |\n| employee-earnings-report-2016.csv | CSV | 22,046 | 2.4M | employee-earnings-report-2016.parquet 1.0M |\n| employee-earnings-report-2015.csv | CSV | 21,902 | 2.7M | employee-earnings-report-2015.parquet 1.0M |\n| employee-earnings-report-2014.csv | CSV | 22,233 | 2.8M | employee-earnings-report-2014.parquet 1.0M |\n| employee-earnings-report-2013.csv | CSV | 22,469 | 2.9M | employee-earnings-report-2013.parquet 1.1M |\n| employee-earnings-report-2012.csv | CSV | 21,140 | 2.7M | employee-earnings-report-2012.parquet 1.0M |\n| employee-earnings-report-2011.csv | CSV | 20,509 | 2.6M | employee-earnings-report-2011.parquet 1.0M |\n| payroll_categories.xlsx | CSV | 24 | 0.0M | payroll_categories.parquet 0.0M |\n","key":"employee-earnings/README.md"}],"sourceObjectKey":"employee-earnings/parquet/allemployeescy2019_feb19_20final-all.parquet","starterCell":"with open('/mnt/archive/parquet/allemployeescy2019_feb19_20final-all.parquet', 'rb') as fh:\n    head = fh.read(1024)\nprint(len(head), head[:64])","starterSamplePath":"parquet/allemployeescy2019_feb19_20final-all.parquet","totalObjects":"2 top-level prefixes"},"sourceType":"bucket","summary":"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…","title":"Boston Employee Earnings Report, 2011 to 2025","updatedAt":"2026-08-31T02:05:01.099Z","visibility":"public","websiteUrl":"https://www.boston.gov/departments/human-resources","whiteLabel":"boston"}}