Slow zone hours by week

Train-hours and rider-hours lost to subway slow zones across the whole system, each week since January 2022.

Rows: 249
Size: 2.9 KB
Covers: January 2022 to last week
Updated: Nightly
Source: Built from subway slow zones
License: CC BY 4.0

Fileshttps://data.transitlab.nyc/v1/subway_slow_zones_weekly.parquetOne file. In the database as transitlab.subway_slow_zones_weekly.

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

What a row is

One week. For every slow weekday of every zone of kind slow zone in subway slow zones, we take the extra seconds times the trains that ran (train-hours) and times the riders who passed through (rider-hours), and add them up by week. This is the series behind the chart at the top of the slow zones page.

Query it

-- Rider-hours lost each weekday, by year (5 weekdays a week)
SELECT year(week) AS year,
       round(avg(rider_hours) / 5) AS rider_hours_per_weekday
FROM 'https://data.transitlab.nyc/v1/subway_slow_zones_weekly.parquet'
GROUP BY year
ORDER BY year;

Columns

weekdate

Monday of the week. The first and last weeks are partial.

train_hoursdouble

Train-hours lost in slow zones that week, weekdays 6 am to 10 pm.

rider_hoursdouble

Rider-hours lost in slow zones that week.

Good to know

The first and last weeks are partial. Leave them out of averages.
Weekdays 6 am to 10 pm only.