Public Transportation Fact Book Appendix B - Urbanized Area Transit Totals
Urbanized-area public transportation totals from APTA Fact Book Appendix B. One row is an urbanized area total across modes, with population, small-system flags, vehicles, service miles and hours, passenger miles, unlinked passenger trips, and rankings; the profiled table contains 458 urbanized-area rows.
Get this dataset on your machine
subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier
pip install subsetsiosubsets sync --bundle small # or medium, or largesubsets serve # search + SQL at http://localhost:8080Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →
Query it locally
Full docs →Bash
subsets serve # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
-H "Content-Type: application/json" \
-d '{"sql": "SELECT * FROM \"american-public-transportation-association-factbook-b-uza-totals\" LIMIT 5"}'No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.
