Skip to content
Docs

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)
Fileshttps://data.transitlab.nyc/v1/subway_trains_delayed.parquetOne file. In the database as transitlab.subway_trains_delayed.

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

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.

SQL
-- Delays by cause, by year
SELECT year(month) AS year, reporting_category, sum(delays) AS delays
FROM transitlab.subway_trains_delayed
GROUP BY ALL
ORDER BY year, delays DESC;
SQL
-- Delays per month on the L, weekdays
SELECT month, sum(delays) AS delays
FROM transitlab.subway_trains_delayed
WHERE line = 'L' AND day_type = 'weekday'
GROUP BY month
ORDER BY month;
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.

day_typevarchar

weekday or weekend.

reporting_categoryvarchar

Cause: Crew Availability, External Factors, Infrastructure & Equipment, Operating Conditions, Planned ROW Work or Police & Medical.

delaysbigint

Trains delayed that month on that line, for that cause, on that kind of day.

  • 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.