Where the Overtime Goes: Massachusetts Mental Health State Hospitals

Publicspending.net has standardised a multi-year payroll record from the Massachusetts Department of Mental Health, breaking overtime expenditure down by facility, by clinical role, and by fiscal quarter. The dataset sits inside a broader archive of state payment records that the project has pulled together from US federal, state and municipal sources, alongside parallel collections from Greece, the United Kingdom and Australia. Researchers who want to understand how a publicly funded psychiatric system absorbs the cost of running inpatient wards round the clock now have the raw numbers at hand.

For readers based in Australia, the Massachusetts figures carry a certain familiarity. Both jurisdictions run state-administered inpatient psychiatric services, both rely on award-style pay structures, and both are dealing with persistent workforce gaps in regional and forensic mental health. The lessons are transferable, even if the dollar amounts and roster rules differ.

How Massachusetts Reports Mental Health Overtime

The Massachusetts Department of Mental Health operates a network of inpatient sites, ranging from large recovery centres on former state hospital grounds to smaller forensic and community-facing units. Each facility publishes payroll through the state's accounting system, and the overtime component is isolated as a separate earnings line. Publicspending.net cleans up these records, links employee identifiers to facility codes, and re-publishes them as tidy CSVs and through a SPARQL endpoint.

For each fiscal year, the visible fields include base salary, overtime gross, shift differentials, on-call allowances and the employee's primary cost centre. The cost centre is effectively the facility, which means a researcher can answer straightforward questions: how much did Taunton State Hospital spend on psychiatric nursing overtime in FY2023? Which site recorded the highest per-full-time-equivalent overtime cost? Where the data is sparsely attributed, the project has flagged the records rather than backfilling them, which keeps the time series clean.

Why Overtime Runs Hot in State Psychiatric Care

Overtime is not a sign that something has gone wrong in a mental health system. It is a structural feature of running inpatient psychiatric services around the clock with credentialed staff. Massachusetts, like most US states, mandates minimum staffing ratios on acute mental health units and in forensic settings, and those ratios cannot be met by a Monday-to-Friday roster.

Three pressures tend to push overtime up: vacancies in core clinical roles, the requirement for one-to-one observation of patients on suicide precaution or seclusion review, and the use of overtime as a retention tool when pay rates lag the local private hospital market. The Massachusetts payroll data captures all three, and the pattern by facility tends to track local labour-market tightness more than the size of the campus. A fourth, quieter pressure is the casualisation of the workforce, where part-time and per-diem staff pick up overtime hours that the permanent roster cannot cover.

The Facilities With the Highest Overtime Bills

Across the most recent three fiscal years, three facilities dominate the overtime column. Worcester Recovery Center and Hospital, the system's flagship site, carries the largest absolute overtime spend because of its size and its mix of civil and forensic beds. Taunton State Hospital, which serves a comparable population in the south of the state, comes second. The third is the Erich Lindemann Mental Health Center, where overtime costs run high relative to bed count because of the complexity of the patient cohort and the cost of Boston-area labour.

Smaller sites such as the Corrigan Mental Health Center and the Solomon Carter Fuller Mental Health Center record lower absolute overtime but a higher share of payroll consumed by overtime premiums. This is the typical shape of small specialised units: a single unfilled post on a quiet day has an outsized impact on the wage bill, and the recovery period after a vacancy can run into months.

Overtime Cost Per Hour Across Sites

The figures vary considerably once you normalise by hours paid. The table below summarises the average overtime premium per paid overtime hour across the main DMH facilities for FY2023, drawn from the publicspending.net consolidated table.

Facility	Average overtime rate (USD/hr)	Premium over base rate	Overtime hours as % of total paid hours
Worcester Recovery Center and Hospital	78.40	1.65×	14.2%
Taunton State Hospital	74.10	1.58×	13.6%
Erich Lindemann Mental Health Center	81.20	1.71×	11.8%
Corrigan Mental Health Center	69.50	1.49×	16.4%
Lemuel Shattuck Hospital psychiatric unit	72.30	1.55×	17.1%
Solomon Carter Fuller Mental Health Center	67.80	1.47×	15.0%

The two forensic-heavy sites show above-average premiums, which is consistent with the requirement for registered nurses authorised to administer involuntary medication and to manage seclusion reviews. Sites with the highest percentage of overtime hours tend to carry the lowest per-hour premium, which is the standard trade-off seen across US state payrolls: when overtime is a chronic feature of the roster rather than a response to a crisis, the rate negotiated by the union settles lower.

What Australian Readers Can Take from This

Mental health staffing is a topic that pops up in news headlines across Australia just as often as it does in Massachusetts. NSW Health and Victoria's Department of Health publish their own hospital payroll summaries, and anyone who has spent time in a public psychiatric unit in Parramatta or Parkville will recognise the reliance on overtime to cover unfilled shifts. The Royal Melbourne Hospital's psychiatric ward and the Westmead adult mental health unit both run tight rosters where one resignation can push twenty hours of overtime onto the next month.

A couple of differences are worth flagging. AHPRA registration for nurses and allied health staff cuts across state borders, so Australian overtime data is shaped by a national regulator where Massachusetts only has a state-level board. The Royal Flying Doctor Service carries the remote mental health load in places like outback South Australia and the Kimberley, which is a category that simply does not exist in the Massachusetts system. Australian nurses, used to calling a 12-hour ward shift an "arvo-to-night run", tend to think of overtime as a roster management problem rather than a clinical one, which is the same framing Boston-area nurses use. This shared perspective is what makes the US numbers useful as a benchmark.

For anyone comparing departmental leadership structures, the way administrative oversight roles translate between Massachusetts and an Australian state health department deserves a closer look, particularly when overtime policy is being set centrally but spent locally.

Querying the Dataset with SPARQL

For researchers who want to slice the data themselves, publicspending.net exposes the underlying records through a SPARQL endpoint. A typical query joins employee records with facility codes and sums overtime earnings by quarter:

SELECT ?facility (SUM(?overtime) AS ?totalOT)
WHERE {
  ?payroll a ex:PayrollRecord ;
           ex:paidTo ?employee ;
           ex:facility ?facility ;
           ex:overtimeEarnings ?overtime ;
           ex:fiscalQuarter "2023-Q3" .
}
GROUP BY ?facility
ORDER BY DESC(?totalOT)

The same endpoint supports searches by occupation code, so registered nurses, mental health workers and forensic counsellors can be pulled out separately. Bulk CSV downloads are also available for anyone who would rather work in a spreadsheet than in RDF, and the ontology documentation on the site explains how the cost-centre codes map back to facility names for the periods where the labels changed.

Reading the Numbers in Context

A few caveats belong with any analysis built on this dataset. The overtime earnings field captures gross pay, before deductions, and before any recoupment for time off in lieu. Employee identifiers are consistent within a fiscal year but reset across years, which means tracking an individual nurse from FY2022 into FY2023 takes a matching step against name and date-of-birth columns. The figures are reported by the employer, not audited by an independent reviewer, although Massachusetts publishes the data through its Office of the Comptroller, which carries its own integrity standards.

Overtime spend is only one dimension of workforce pressure. Vacancy rates, agency locum use, and sick leave taken in lieu are all separate lines in the payroll, and a complete picture needs those alongside the overtime column. Publicspending.net links these where it can, but researchers should treat the overtime numbers as a starting point rather than an endpoint.

The dataset is free to use, the SPARQL endpoint is open, and the bulk downloads cost nothing. Have a look at the facility breakdown on publicspending.net, pick a site that interests you, and see what the overtime column tells you about how that hospital actually runs.