Bus ridership by hour
How many people boarded each bus route, each hour, with each fare type, since January 2020. The MTA's own estimate, copied from data.ny.gov.
- Rows
- 610,078,176
- Size
- 215 MB
- Covers
- January 2020 to about a week ago
- Updated
- Nightly (the MTA adds to it weekly)
- Source
- MTA, on data.ny.gov (bus hourly ridership, 2020-2024 and beginning 2025)
- License
- NY open data terms
https://data.transitlab.nyc/v1/bus_hourly_ridership/year=YYYY/month=MM/YYYY-MM.parquetRows and size from catalog.json, 2026-10-08.
What a row is
Section titled “What a row is”The boardings on one bus route in one hour with one fare type. The MTA estimates them from fare payments (MetroCard swipes and OMNY taps).
Every route has a row for every hour and fare type, whether or not anyone boarded, so about four rows in five are zero. Filter on ridership > 0 if you want only the hours with riders.
The table joins two MTA datasets, 2020 to 2024 and 2025 on, which have the same columns, so there is no break at the new year. Each month is its own file and the columns are typed; the values are the MTA’s.
Query it
Section titled “Query it”-- Bus boardings by yearSELECT year(transit_timestamp) AS year, sum(ridership) AS boardingsFROM transitlab.bus_hourly_ridershipGROUP BY yearORDER BY year;Or read one month straight from its file:
-- The ten busiest routes in August 2026SELECT bus_route, sum(ridership) AS boardingsFROM 'https://data.transitlab.nyc/v1/bus_hourly_ridership/year=2026/month=08/2026-08.parquet'GROUP BY ALLORDER BY boardings DESCLIMIT 10;Columns
Section titled “Columns”transit_timestamptimestampThe hour, New York local time. The MTA rounds down: a tap at 1:37 pm is 1 pm.
bus_routevarcharBus route, e.g. M15. A plus sign marks Select Bus Service, e.g. M15+.
payment_methodvarcharmetrocard or omny.
fare_class_categoryvarcharFare type, e.g. OMNY - Full Fare, Metrocard - Unlimited 30-Day, Metrocard - Seniors & Disability.
ridershipbigintRiders who boarded at that hour with that fare type. An estimate from fare payments.
transfersbigintOf ridership, riders who boarded on a free transfer. A subset: already counted in ridership.
Good to know
Section titled “Good to know”- Boardings, not trips. A rider who changes buses is counted on each bus.
transferssays how many boardings were free transfers. - Routes with a plus sign are Select Bus Service, as in
M15+. - Each row is one fare type, so add them up for a total.
- Times are New York local time, with no zone attached. The hour is the start of the hour.
- The MTA adds to it weekly and revises it. The last days of the newest month are not there yet, and late fares change past months slightly. Each night we check the current and previous month, and every month on Sundays, and rebuild a month only if its totals changed.
- Pair it with bus route speeds to see how many riders sit on slow routes.
- Terms: NY open data. Credit the Metropolitan Transportation Authority. Source datasets: 2020 to 2024 and beginning 2025.