Skip to content
Docs

Subway terminal on-time performance

The share of subway trains that reach the end of the line on time, by month and line, since January 2015. The MTA's own figure, copied from data.ny.gov.

Rows
5,182
Size
63.2 KB
Covers
January 2015 to last month
Updated
Nightly (the MTA publishes monthly)
Source
MTA, on data.ny.gov (subway terminal on-time performance)
Fileshttps://data.transitlab.nyc/v1/subway_terminal_on_time.parquetOne file. In the database as transitlab.subway_terminal_on_time.

Rows and size from catalog.json, 2026-10-08.

One line in one month, on weekdays or weekends: how many trains were scheduled to reach their last stop, and how many did so on time. A train is late if it reaches its last stop more than five minutes late, skips a scheduled stop, or is scheduled and does not run. All others are on time. The MTA calls this a legacy measure.

We changed two things from the MTA’s file: month is a date and day_type says weekday or weekend instead of 1 or 2. The figures are the MTA’s.

SQL
-- On-time share by line, weekdays, 2025
SELECT line,
round(sum(num_on_time_trips) / sum(num_sched_trips), 3) AS on_time
FROM transitlab.subway_terminal_on_time
WHERE day_type = 'weekday' AND year(month) = 2025
GROUP BY line
ORDER BY on_time;
monthdate

First day of the month.

divisionvarchar

A DIVISION (numbered lines and the 42nd St shuttle) or B DIVISION (lettered lines).

linevarchar

Subway line. J and Z run as one line, JZ. Shuttles are S 42nd, S Fkln and S Rock. Some lines appear under more than one name, or in some years only: J and JZ, the shuttles FS, GS and H, and W.

day_typevarchar

weekday or weekend.

num_on_time_tripsbigint

Trains that reached their last stop on time.

num_sched_tripsbigint

Trains scheduled.

terminal_on_time_performancedouble

num_on_time_trips over num_sched_trips, from 0 to 1.

  • To combine rows, add the counts, then divide. Averaging terminal_on_time_performance gives a busy line and a quiet one the same weight.
  • It measures the end of the trip only. A train that crawls and then makes up time at the end counts as on time, and few riders ride to the end of a line. Wait assessment looks at the gaps between trains instead.
  • Line names are not steady. Some lines appear under more than one name, or in some years only: J and JZ, the shuttles FS, GS and H, and the W. List each line with its first and last month before you add lines up.
  • A month appears once the MTA publishes it, usually in the next month.
  • Terms: NY open data. Credit the Metropolitan Transportation Authority. Source dataset: MTA Subway Terminal On-Time Performance.