Skip to content
Docs

List tables

Every table you can query: name, description, rows, size, number of files and the days it covers.

GET https://api.transitlab.nyc/v1/tables Key optional

From the open data catalog. A key is optional here; without one, requests count per IP address against the same 60-a-minute limit.

curl https://api.transitlab.nyc/v1/tables
import 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())

A key is optional. Without one, requests count against your IP address’s limits. With one, they count against the key’s.

The tables.

  • updated string

    When the catalog was last rebuilt (ISO 8601 UTC).

  • tables object[] required

    Every table.

  • tables[].name string required

    Table name, as written in SQL.

  • tables[].description string required

    What a row is.

  • tables[].rows integer required

    Row count.

  • tables[].bytes integer required

    Total size of the table’s Parquet files.

  • tables[].files integer required

    Number of Parquet files.

  • tables[].partitioned_by_year_month boolean required

    True if the table is one file a month or a day, with year and month columns to filter on.

  • tables[].first_day string (date)

    First day covered (partitioned tables only).

  • tables[].last_day string (date)

    Last day covered (partitioned tables only).

Example
{
"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
}
]
}
StatusWhen
401Unauthorized. A key was sent but is not valid.
429Too many requests. Too many requests.

Error responses carry this body:

  • error string required

    A 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.

  • message string required

    What went wrong and what to do, in plain words.

  • get_a_key string (uri)

    On 401: where to get a key.

  • docs string (uri)

    On 401: the API guide.

Example (401)
{
"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/"
}