Access to Intercity Air, Bus, and Rail Transportation in Rural Areas

Total and percent of rural population with access to scheduled intercity bus, rail, and air transportation. Rural areas are Census block groups with their centroid (center) outside of all Census urban areas. Summarized to county level. Facilities used available at: https://data.transportation.gov/Research-and-Statistics/Intercity-Air-Bus-and-Rail-Transportation-Faciliti/xnub-2sc4.

Interactive map showing access to intercity transportation in rural areas:

https://datahub.transportation.gov/stories/s/Rural-Access-to-Intercity-Transportation/gr9y-9gjq

Methodology:

https://datahub.transportation.gov/stories/s/dbb4-pr2c

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bts-gov/access-to-intercity-air-bus-and-rail-m2bh-93w3\".\"access_to_intercity_air_bus_and_rail\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.