Subway trains delayed
How many subway trains were delayed each month, by line and cause, since January 2020. The MTA's own count, copied from data.ny.gov.
- Rows
- 19,071
- Size
- 34.9 KB
- Covers
- January 2020 to last month
- Updated
- Nightly (the MTA publishes monthly)
- Source
- MTA, on data.ny.gov (subway trains delayed)
- License
- NY open data terms
https://data.transitlab.nyc/v1/subway_trains_delayed.parquetRows and size from catalog.json, 2026-10-08.
What a row is
Section titled “What a row is”The trains delayed in one month, on one line, for one cause, on weekdays or weekends. The MTA counts a train as delayed if it reaches its last stop more than five minutes late, skips a scheduled stop, or is scheduled and does not run. Each delay is charged to one of six causes, the MTA’s own reporting categories.
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. Everything else is as the MTA published it.
Query it
Section titled “Query it”-- Delays by cause, by yearSELECT year(month) AS year, reporting_category, sum(delays) AS delaysFROM transitlab.subway_trains_delayedGROUP BY ALLORDER BY year, delays DESC;-- Delays per month on the L, weekdaysSELECT month, sum(delays) AS delaysFROM transitlab.subway_trains_delayedWHERE line = 'L' AND day_type = 'weekday'GROUP BY monthORDER BY month;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.
day_typevarcharweekday or weekend.
reporting_categoryvarcharCause: Crew Availability, External Factors, Infrastructure & Equipment, Operating Conditions, Planned ROW Work or Police & Medical.
delaysbigintTrains delayed that month on that line, for that cause, on that kind of day.
Good to know
Section titled “Good to know”- A count, not a rate. A line with more trains has more delays. Compare lines with terminal on-time performance or wait assessment, or with our own slow zones.
- Weekdays and weekends are counted separately and a month has a different number of each. Divide by the days of that type before you compare months.
- A month appears once the MTA publishes it, usually in the next month. Each night we fetch the table again and rewrite the file if the MTA changed it.
- Dispatchers assign causes by hand on most lines. Only the numbered lines and the 42nd St Shuttle are timed by computer, so a cause is a judgment call.
- Terms: NY open data. Credit the Metropolitan Transportation Authority. Source dataset: MTA Subway Trains Delayed.