Query from your own computer
Paste this into DuckDB to attach every table at once. It reads only the parts of the files a query needs.
ATTACH 'https://data.transitlab.nyc/v1/transitlab.duckdb' AS transitlab (READ_ONLY);
Data · CC BY 4.0 · Updated nightly
Every public source on how the city’s trains, buses and taxis run, cleaned into one set of tables you can join, query and reuse. Free to download, with nothing to sign up for.
Counts come from our table catalog and grow each night as we add history.
Read how it’s made, download the files, or query it in your browser.
How each number is made: the sources, the methods and what they miss. Read this before you reuse a figure.
Read the docsEvery table as Parquet files, with a list of what each one holds.
See the tablesQuery every table with SQL, with example queries to start from, and download the answer as CSV. Runs on your computer; nothing to install.
Open the consolePaste this into DuckDB to attach every table at once. It reads only the parts of the files a query needs.
ATTACH 'https://data.transitlab.nyc/v1/transitlab.duckdb' AS transitlab (READ_ONLY);
Send SQL over HTTPS and get rows back as JSON, CSV or Parquet. It runs on our servers, so there is nothing to download.
Get a keyRun uvx transitlab tables to list the tables, then query, describe or download any of them from your terminal.
Read the guideThe files behind each tracker, rebuilt every night.
Good with data, design, writing or organizing? Tell us what you’d like to work on.
Get in touchOur tables and figures are free to use under CC BY 4.0. Credit Transit Lab and link to the page or table you used.
We build them from public data published by the MTA, NYC DOT and the NYC Taxi and Limousine Commission. Their own terms still apply to the source data. Tables we copy as they are published, such as taxi and for-hire trips and the MTA’s ridership and delay counts, stay under the publisher’s terms: credit the publisher.
We don’t republish Citi Bike trips: their license doesn’t allow it. Get them from Citi Bike directly.