About this Dataset

MTA Annualized Employee Availability: Beginning 2013

This dataset provides a year‑over‑year view of annualized employee availability by department and job group description. Annualized availability is calculated as the ratio of productive time—available hours plus scheduled overtime hours—to total time, which includes available hours, scheduled overtime hours, and paid and unpaid unavailable hours. The result is scaled to a 260.89-day work year and excludes unscheduled overtime.
Organization: State of New York
Last updated: 2025-06-21T17:37:23.097945
Tags: availability, employee, ingen, lirr, long-island-rail-road, metro-north, metro-north-railroad, mnr, mta, mta-bus, mta-bus-company, mta-headquarters, mta-inspector-general, mta-staten-island-railway, mtabc, mtahq, new-york-city-transit, nyct, peoplesoft, sir, timekeeping, trc

Tables

Table 1

@usgov.state_of_new_york_mta_annualized_employee_availability_db4d01ad.table_1

186.54 kB
7,206 rows
8 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "department" VARCHAR,
  "job_group_description" VARCHAR,
  "available_hours" DOUBLE,
  "scheduled_overtime_hours" DOUBLE,
  "paid_unavailable_hours" DOUBLE,
  "unpaid_unavailable_hours" DOUBLE,
  "annualized_availability" DOUBLE
);