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

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

State-by-mode summary of rural and tribal public transportation operating statistics from APTA Fact Book Appendix B. One row is a state and transit mode with totals and rankings for vehicles, revenue miles, revenue hours, and passenger trips; the table contains 130 rows across 51 states and seven mode codes.

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

Source: American Public Transportation Association · connector code

Schema

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

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