List tables
Every table you can query: name, description, rows, size, number of files and the days it covers.
https://api.transitlab.nyc/v1/tables Key optionalFrom the open data catalog. A key is optional here; without one, requests count per IP address against the same 60-a-minute limit.
Request
Section titled “Request”curl https://api.transitlab.nyc/v1/tablesimport requests
r = requests.get( "https://api.transitlab.nyc/v1/tables", timeout=60,)r.raise_for_status()print(r.json())const res = await fetch("https://api.transitlab.nyc/v1/tables")if (!res.ok) throw new Error(`HTTP ${res.status}`)console.log(await res.json())Authorization
Section titled “Authorization”A key is optional. Without one, requests count against your IP address’s limits. With one, they count against the key’s.
Responses
Section titled “Responses”200 OK
Section titled “200 OK”The tables.
-
updatedstringWhen the catalog was last rebuilt (ISO 8601 UTC).
-
tablesobject[] requiredEvery table.
-
tables[].namestring requiredTable name, as written in SQL.
-
tables[].descriptionstring requiredWhat a row is.
-
tables[].rowsinteger requiredRow count.
-
tables[].bytesinteger requiredTotal size of the table’s Parquet files.
-
tables[].filesinteger requiredNumber of Parquet files.
-
tables[].partitioned_by_year_monthboolean requiredTrue if the table is one file a month or a day, with year and month columns to filter on.
-
tables[].first_daystring (date)First day covered (partitioned tables only).
-
tables[].last_daystring (date)Last day covered (partitioned tables only).
{ "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": "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 } ]}Errors
Section titled “Errors”| Status | When |
|---|---|
401 | Unauthorized. A key was sent but is not valid. |
429 | Too many requests. Too many requests. |
Error responses carry this body:
-
errorstring requiredA short code: unauthorized, rate_limited, daily_queries, daily_compute, concurrency, busy, budget_exhausted, engine_unavailable, bad_sql, not_read_only, sql_error, not_allowed, timeout, out_of_memory, bad_format, bad_limit, bad_date, no_such_table, not_found.
-
messagestring requiredWhat went wrong and what to do, in plain words.
-
get_a_keystring (uri)On 401: where to get a key.
-
docsstring (uri)On 401: the API guide.
{ "error": "unauthorized", "message": "Send an API key: `Authorization: Bearer tl_live_…`. Get a free key at https://transitlab.nyc/api-keys.", "get_a_key": "https://transitlab.nyc/api-keys", "docs": "https://docs.transitlab.nyc/start/sql-api/"}