About this Dataset

MTA Employee Availability: Beginning 2013

Employee availability measures the proportion of employee scheduled time that is spent on productive work. Available time refers to the time employees spend on productive tasks during their regular scheduled time or scheduled overtime but does not include unscheduled overtime. Unavailable time refers to time employees spend on leave (holiday, vacation, sick), absent from scheduled work (AWOL, jury duty, unscheduled absence), or on nonproductive time (training, civil service exams); but does not include regularly scheduled days off.
Organization: State of New York
Last updated: 2025-06-21T17:36:23.805234
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_employee_availability_beginning_2013.table_1

34.94 MB
4330093 rows
9 columns


CREATE TABLE table_1 (
  "month" TIMESTAMP,
  "agency" VARCHAR,
  "department" VARCHAR,
  "rc" DOUBLE,
  "rc_name" VARCHAR,
  "job_group_description" VARCHAR,
  "availability_type" VARCHAR,
  "availability_subtype" VARCHAR,
  "total_hours" DOUBLE
);