Skip to content
Docs

DuckDB database with a view per table

A small DuckDB file with one view per table over the Parquet URLs.

GET https://data.transitlab.nyc/v1/transitlab.duckdb No key

Attach it read-only from DuckDB with ATTACH 'https://data.transitlab.nyc/v1/transitlab.duckdb' AS transitlab (READ_ONLY); and query every table without downloading it. Supports HTTP Range requests, so a client such as DuckDB can read only the parts it needs.

curl https://data.transitlab.nyc/v1/transitlab.duckdb \
-o transitlab.duckdb
import requests
r = requests.get(
"https://data.transitlab.nyc/v1/transitlab.duckdb",
stream=True,
timeout=60,
)
r.raise_for_status()
with open("transitlab.duckdb", "wb") as f:
for chunk in r.iter_content(1 << 20):
f.write(chunk)
const res = await fetch("https://data.transitlab.nyc/v1/transitlab.duckdb")
if (!res.ok) throw new Error(`HTTP ${res.status}`)
const bytes = new Uint8Array(await res.arrayBuffer())

No key needed.

The DuckDB file.

Headers:

  • Accept-Ranges string

  • ETag string

Body:

  • application/octet-stream: The file.