Skip to content
Docs

Datasets

Every table we publish, with its size and what one row means. Rows and sizes come from catalog.json each time the docs are built.

Subway

Subway segment timesDaily run time between every pair of stations in a row, weekdays since April 2021.subway_segment_times1,648,958 rows · 13.1 MBSubway slow zonesEvery stretch where trains ran well over their usual time for 4+ weekdays, since 2022, with the hours it cost.subway_slow_zones10,458 rows · 254 KBSlow zone hours by weekTrain-hours and rider-hours lost to slow zones across the subway, week by week.subway_slow_zones_weekly249 rows · 2.9 KBSubway ridership by hourEntries to every station complex by hour and fare type, since January 2017: the MTA's own ridership estimate.subway_hourly_ridership224,430,037 rows · 533 MBMTA daily ridershipSystem-wide riders a day on the subway, buses, LIRR, Metro-North and Access-A-Ride, and vehicles on bridges and tunnels and into the congestion zone, since March 2020.mta_daily_ridership18,145 rows · 72.2 KBSubway trains delayedHow many trains were delayed each month, by line and cause, since January 2020.subway_trains_delayed19,071 rows · 34.9 KBSubway terminal on-time performanceThe share of trains that reach the end of the line on time, by month and line, since January 2015.subway_terminal_on_time5,182 rows · 63.2 KBSubway wait assessmentThe share of gaps between trains that meet the MTA's standard, by month, line and period, since January 2015.subway_wait_assessment12,812 rows · 158 KB

Feeds archive

Subway departuresOne row per train per station, written as the train leaves. April 2021 to October 2026 from a public archive of the feeds, then our own collector.subway_stop_events409,614,609 rows · 8.2 GBBus positionsEvery bus's reported position. July 2017 to November 2024 from a public archive (about every 2 minutes), then our own collector from October 2026 (every 30 seconds).bus_vehicle_positions2,873,762,201 rows · 54.3 GBBus arrival predictionsThe arrival times the MTA predicted for each bus at each stop: the feed behind countdown clocks.bus_predictions95,264,121 rows · 2.4 GBService alertsMTA bus, subway and rail service alerts, one row each time an alert appears, changes or ends.transit_alerts372,757 rows · 25.3 MBElevator and escalator outagesEvery MTA elevator and escalator outage, one row each time an outage appears, changes or ends.elevator_outages1,007 rows · 60.2 KBElevators and escalatorsThe MTA's list of elevators and escalators, kept as change events.elevator_equipment2,121 rows · 250 KB

Bus

Bus route speedsOur bus speeds by route, direction and hour, one set of rows per day, from bus positions.bus_route_speeds11,120 rows · 120 KBBus delay and bus lanesEach stretch between two timepoint stops: how slow it is, the time buses lose, and how much has a bus lane.bus_lanes4,219 rows · 153 KBBus delay by streetBus time lost added up by street, across routes and directions, with bus lane coverage.bus_lane_streets270 rows · 13.0 KBBus ridership by hourBoardings on every bus route by hour and fare type, since January 2020: the MTA's own ridership estimate.bus_hourly_ridership610,078,176 rows · 215 MB

Trips

Yellow taxi tripsEvery yellow taxi trip since January 2023, cleaned, with zone names and readable codes.taxi_yellow_trips157,897,041 rows · 2.8 GBGreen taxi tripsEvery green cab (street hail livery) trip since January 2023, cleaned, with zone names.taxi_green_trips2,373,759 rows · 49.5 MBUber, Lyft and Via tripsEvery trip by the high-volume for-hire services since January 2023, cleaned, with zone names.fhv_trips883,706,522 rows · 24.2 GB

Ours. Subway, bus and feed archive tables are built by us from the MTA’s feeds and published data. They are CC BY 4.0.

Copied from public sources. Taxi and Uber/Lyft trips are the TLC’s public files, cleaned and with zone names added. Subway and bus ridership, and the subway’s delay, on-time and wait counts, are the MTA’s datasets on data.ny.gov, typed and split by month. We keep them here so you can join them with ours. They stay under the publishers’ terms. We don’t carry Citi Bike trips; here’s why.

LayoutPath
Small tables, one filehttps://data.transitlab.nyc/v1/<table>.parquet
Large tables, one file a monthhttps://data.transitlab.nyc/v1/<table>/year=YYYY/month=MM/YYYY-MM.parquet
A month too big for one file (fhv_trips), two partshttps://data.transitlab.nyc/v1/<table>/year=YYYY/month=MM/YYYY-MM.part-0.parquet (days 1 to 15) and …part-1.parquet (day 16 on)
A day too big for one file (bus_predictions), six parts of four hourshttps://data.transitlab.nyc/v1/<table>/year=YYYY/month=MM/YYYY-MM-DD.part-0.parquet to …part-5.parquet
Feed archives, one file a dayhttps://data.transitlab.nyc/v1/<table>/year=YYYY/month=MM/YYYY-MM-DD.parquet
The catalog, with every file’s URLhttps://data.transitlab.nyc/v1/catalog.json
All tables as one DuckDB databasehttps://data.transitlab.nyc/v1/transitlab.duckdb

Feed times are UTC. Trip times are New York local time, as the TLC publishes them. Columns say which.