Public Transportation Fact Book Appendix B - Rural and Tribal Transit by Agency and Mode

Name: Public Transportation Fact Book Appendix B - Rural and Tribal Transit by Agency and Mode
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Agency-level rural and tribal public transportation operating statistics from APTA Fact Book Appendix B. One row is an agency and transit mode, with state and city identifiers plus vehicles, service miles, service hours, and passenger trips; the profile shows 1,599 rows across 1,214 agencies and seven mode codes.

american-public-transportation-association-factbook-b-rural-tribal-by-mode·12 columns·91 KB·APTA statistical publication reuse terms / site copyright notice·updated 2mo ago

Source: American Public Transportation Association · connector code

Schema

state	string
agency	string
city	string
mode	string
voms_amount	int64
voms_rank	string
vehicle_revenue_miles_amount	int64
vehicle_revenue_miles_rank	string
vehicle_revenue_hours_amount	int64
vehicle_revenue_hours_rank	string
upt_amount	int64
upt_rank	string

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 subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free 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-rural-tribal-by-mode\" 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.