{"updated":"2026-10-06T11:38:53Z","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":1646722,"bytes":13062808,"files":67,"partitioned_by_year_month":true,"first_day":"2021-04-01","last_day":"2026-10-31"},{"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":10442,"bytes":254491,"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":249,"bytes":2853,"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":11120,"bytes":120209,"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":4219,"bytes":152710,"files":1,"partitioned_by_year_month":false},{"name":"bus_lane_streets","description":"Bus time lost to traffic, added up by street.","rows":270,"bytes":12952,"files":1,"partitioned_by_year_month":false},{"name":"subway_stop_events","description":"One row per train per station, written when the train leaves, from our own collector of the MTA subway feeds. Daily files.","rows":398192,"bytes":7542622,"files":2,"partitioned_by_year_month":true,"first_day":"2026-10-04","last_day":"2026-10-05"},{"name":"bus_vehicle_positions","description":"Where each bus is, about every 30 seconds, from the MTA bus GTFS-realtime feed. Change events, daily files.","rows":7822245,"bytes":125850855,"files":3,"partitioned_by_year_month":true,"first_day":"2026-10-02","last_day":"2026-10-05"},{"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":47536889,"bytes":529026606,"files":3,"partitioned_by_year_month":true,"first_day":"2026-10-02","last_day":"2026-10-05"},{"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":125174,"bytes":4924127,"files":1,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-10-31"},{"name":"elevator_outages","description":"MTA elevator and escalator outages, one row each time an outage appears, changes or ends. Monthly files.","rows":325,"bytes":15949,"files":1,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-10-31"},{"name":"elevator_equipment","description":"The MTA's list of elevators and escalators. Monthly files.","rows":707,"bytes":77386,"files":1,"partitioned_by_year_month":true,"first_day":"2026-10-01","last_day":"2026-10-31"},{"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":24177583320,"files":64,"partitioned_by_year_month":true,"first_day":"2023-01-01","last_day":"2026-08-31"}]}