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

182.17 KB
7206 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
);