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 keyAttach 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.
Request
Section titled “Request”curl https://data.transitlab.nyc/v1/transitlab.duckdb \ -o transitlab.duckdbimport 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())Authorization
Section titled “Authorization”No key needed.
Responses
Section titled “Responses”200 OK
Section titled “200 OK”The DuckDB file.
Headers:
-
Accept-Rangesstring -
ETagstring
Body:
application/octet-stream: The file.