{"updated":"2026-11-20T07:23:17Z","tables":[{"name":"subway_segment_times","description":"Daily run time of each directional subway segment (two stations in a row), weekday daytime trains, from 2021.","rows":1683390,"bytes":13349196,"files":68,"partitioned_by_year_month":true,"first_day":"2021-04-01","last_day":"2026-11-30"},{"name":"subway_slow_zones","description":"Stretches of subway track that ran well over their usual time for days on end, with the hours lost by trains and riders.","rows":10799,"bytes":260733,"files":1,"partitioned_by_year_month":false},{"name":"subway_slow_zones_weekly","description":"Hours lost to subway slow zones across the whole system, by week.","rows":255,"bytes":2926,"files":1,"partitioned_by_year_month":false},{"name":"bus_route_speeds","description":"Bus speeds by route, direction and New York hour, one set of rows per day, from our live vehicle positions.","rows":565123,"bytes":5546281,"files":1,"partitioned_by_year_month":false},{"name":"bus_lanes","description":"Stretches of bus route between two timepoint stops: speed, time lost to traffic, and how much has a bus lane.","rows":4132,"bytes":150076,"files":1,"partitioned_by_year_month":false},{"name":"bus_lane_streets","description":"Bus time lost to traffic, added up by street.","rows":270,"bytes":13021,"files":1,"partitioned_by_year_month":false},{"name":"subway_stop_events","description":"One row per train per station, written when the train leaves. April 2021 to 3 October 2026 from a public archive of the MTA subway feeds; since 4 October 2026 from our own collector. Daily files.","rows":422688290,"bytes":8420087609,"files":2057,"partitioned_by_year_month":true,"first_day":"2021-04-01","last_day":"2026-11-19"},{"name":"bus_vehicle_positions","description":"Where each bus is, from the MTA bus GTFS-realtime feed. July 2017 to November 2024 from a public archive of the feed (a report per bus about every 2 minutes); since October 2026 from our own collector (about every 30 seconds). Daily files.","rows":3033861130,"bytes":57241312987,"files":2183,"partitioned_by_year_month":true,"first_day":"2017-07-14","last_day":"2026-11-19"},{"name":"bus_predictions","description":"The MTA's predicted arrival of each bus at each stop (what countdown clocks show), stored when a prediction moves by 30 seconds or more. Daily files, large.","rows":914097064,"bytes":23445286916,"files":222,"partitioned_by_year_month":true,"first_day":"2026-10-02","last_day":"2026-11-19"},{"name":"transit_alerts","description":"Service alerts from the MTA bus and subway/rail alert feeds, one row each time an alert appears, changes or ends. Monthly files.","rows":6135160,"bytes":400307942,"files":2,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-11-30"},{"name":"elevator_outages","description":"MTA elevator and escalator outages, one row each time an outage appears, changes or ends. Monthly files.","rows":18392,"bytes":859375,"files":2,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-11-30"},{"name":"elevator_equipment","description":"The MTA's list of elevators and escalators. Monthly files.","rows":31818,"bytes":3730654,"files":2,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-11-30"},{"name":"taxi_yellow_trips","description":"Yellow taxi trips since January 2023, one row per trip, cleaned and with zone names added. Monthly files.","rows":157897041,"bytes":2786284306,"files":44,"partitioned_by_year_month":true,"first_day":"2023-01-01","last_day":"2026-08-31"},{"name":"taxi_green_trips","description":"Green taxi trips since January 2023, one row per trip, cleaned and with zone names added. Monthly files.","rows":2373759,"bytes":49450703,"files":44,"partitioned_by_year_month":true,"first_day":"2023-01-01","last_day":"2026-08-31"},{"name":"fhv_trips","description":"High-volume for-hire vehicle trips (Uber, Lyft, Via, Juno) since January 2023, cleaned and with zone names added. Monthly files, large.","rows":883706522,"bytes":24177431370,"files":88,"partitioned_by_year_month":true,"first_day":"2023-01-01","last_day":"2026-08-31"},{"name":"subway_hourly_ridership","description":"Subway, Staten Island Railway and Roosevelt Island Tram entries by station complex, hour and fare type, 13 January 2017 on. Monthly files, large.","rows":226072331,"bytes":537045915,"files":119,"partitioned_by_year_month":true,"first_day":"2017-01-01","last_day":"2026-11-30"},{"name":"bus_hourly_ridership","description":"Bus boardings by route, hour and fare type, January 2020 on. Monthly files, large. Every route, hour and fare type has a row, so many rows are zero.","rows":618782976,"bytes":217379399,"files":83,"partitioned_by_year_month":true,"first_day":"2020-01-01","last_day":"2026-11-30"},{"name":"mta_daily_ridership","description":"System-wide daily ridership and traffic by MTA mode (subway, bus, LIRR, Metro-North, Access-A-Ride, bridges and tunnels, congestion relief zone), March 2020 on.","rows":18538,"bytes":73601,"files":1,"partitioned_by_year_month":false},{"name":"subway_trains_delayed","description":"Subway trains delayed, by month, line, weekday or weekend, and cause, January 2020 on.","rows":19537,"bytes":35686,"files":1,"partitioned_by_year_month":false},{"name":"subway_terminal_on_time","description":"Share of subway trains that reach their last stop on time, by month, line and weekday or weekend, January 2015 on.","rows":5272,"bytes":64237,"files":1,"partitioned_by_year_month":false},{"name":"subway_wait_assessment","description":"Share of gaps between subway trains that meet the MTA's standard, by month, line, weekday or weekend, and peak or off-peak, January 2015 on.","rows":12996,"bytes":160084,"files":1,"partitioned_by_year_month":false}]}