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)
- License
- NY open data terms
https://data.transitlab.nyc/v1/subway_terminal_on_time.parquetRows and size from catalog.json, 2026-10-08.
What a row is
Section titled “What a row is”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.
Query it
Section titled “Query it”-- On-time share by line, weekdays, 2025SELECT line, round(sum(num_on_time_trips) / sum(num_sched_trips), 3) AS on_timeFROM transitlab.subway_terminal_on_timeWHERE day_type = 'weekday' AND year(month) = 2025GROUP BY lineORDER BY on_time;Columns
Section titled “Columns”monthdateFirst day of the month.
divisionvarcharA DIVISION (numbered lines and the 42nd St shuttle) or B DIVISION (lettered lines).
linevarcharSubway 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_typevarcharweekday or weekend.
num_on_time_tripsbigintTrains that reached their last stop on time.
num_sched_tripsbigintTrains scheduled.
terminal_on_time_performancedoublenum_on_time_trips over num_sched_trips, from 0 to 1.
Good to know
Section titled “Good to know”- To combine rows, add the counts, then divide. Averaging
terminal_on_time_performancegives 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:
JandJZ, the shuttlesFS,GSandH, and theW. List eachlinewith its first and lastmonthbefore 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.