Skip to content
Docs

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)
Fileshttps://data.transitlab.nyc/v1/bus_hourly_ridership/year=YYYY/month=MM/YYYY-MM.parquetOne file a month, 81 so far. In the database as transitlab.bus_hourly_ridership.

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

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.

SQL
-- Bus boardings by year
SELECT year(transit_timestamp) AS year, sum(ridership) AS boardings
FROM transitlab.bus_hourly_ridership
GROUP BY year
ORDER BY year;

Or read one month straight from its file:

SQL
-- The ten busiest routes in August 2026
SELECT bus_route, sum(ridership) AS boardings
FROM 'https://data.transitlab.nyc/v1/bus_hourly_ridership/year=2026/month=08/2026-08.parquet'
GROUP BY ALL
ORDER BY boardings DESC
LIMIT 10;
transit_timestamptimestamp

The hour, New York local time. The MTA rounds down: a tap at 1:37 pm is 1 pm.

bus_routevarchar

Bus route, e.g. M15. A plus sign marks Select Bus Service, e.g. M15+.

payment_methodvarchar

metrocard or omny.

fare_class_categoryvarchar

Fare type, e.g. OMNY - Full Fare, Metrocard - Unlimited 30-Day, Metrocard - Seniors & Disability.

ridershipbigint

Riders who boarded at that hour with that fare type. An estimate from fare payments.

transfersbigint

Of ridership, riders who boarded on a free transfer. A subset: already counted in ridership.

  • Boardings, not trips. A rider who changes buses is counted on each bus. transfers says 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.