Skip to content
Docs

MTA daily ridership

How many people rode the subway, buses, LIRR, Metro-North and Access-A-Ride each day, and how many vehicles crossed bridges and tunnels, since March 2020. The MTA's own estimate, copied from data.ny.gov.

Rows
18,145
Size
72.2 KB
Covers
1 March 2020 to about yesterday
Updated
Nightly (the MTA updates it on weekdays)
Source
MTA, on data.ny.gov (daily ridership and traffic, beginning 2020)
Fileshttps://data.transitlab.nyc/v1/mta_daily_ridership.parquetOne file. In the database as transitlab.mta_daily_ridership.

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

One mode on one day: the MTA’s system-wide estimate of riders (or of vehicles, for bridges and tunnels and the congestion relief zone). It is the quickest way to see how many trips the MTA carries and how that has recovered since 2020.

We changed one thing from the MTA’s file: date is a date, not a timestamp. The figures are the MTA’s.

SQL
-- Subway and bus riders by year (2020 starts in March)
SELECT year(date) AS year, mode, sum(count) AS riders
FROM transitlab.mta_daily_ridership
WHERE mode IN ('Subway', 'Bus')
GROUP BY ALL
ORDER BY mode, year;
datedate

Date of travel.

modevarchar

Subway (with the Staten Island Railway), SIR, Bus, LIRR, MNR (Metro-North), AAR (Access-A-Ride), BT (bridges and tunnels), and from 2025-01-05 CBD Entries and CRZ Entries (vehicles into the congestion relief zone).

countbigint

Estimated riders that day, or vehicles for BT, CBD Entries and CRZ Entries. Null where the MTA gives no figure.

  • Subway includes the Staten Island Railway; SIR is that railway alone, so do not add the two. For the subway by station and hour, use subway ridership by hour.
  • Some modes count vehicles. BT, CBD Entries and CRZ Entries are vehicles, not riders.
  • Some days are missing a figure. count is empty where the MTA gives none.
  • Estimates. The MTA revises recent days. Each night we fetch the table again and rewrite the file if it changed.
  • Terms: NY open data. Credit the Metropolitan Transportation Authority. Source dataset: MTA Daily Ridership and Traffic.