APTA Infrastructure Database - Rail Lines

Name: APTA Infrastructure Database - Rail Lines
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Rail-line records from the APTA Infrastructure Database. One row is a rail line or guideway entry for a transit organization, with organization identifiers and line-level infrastructure attributes; the profiled table contains 110 rows across North American transit organizations.

american-public-transportation-association-infrastructure-rail-lines·31 columns·22 KB·APTA statistical publication reuse terms / site copyright notice·updated 24d ago

Source: American Public Transportation Association · connector code

Schema

new_2018_data	string
last_data_reported_year	string
organization_name	string
organization_short_name	string
city	string
state	string
country	string
member_id	int64
mode_name	string
connecting_modes	string
lines	int64
year_original_line_opened	int64
miles_elevated	double
miles_on_surface	double
miles_underground	double
miles_single_track	double
miles_double_track	double
miles_triple_track	double
miles_quadruple_track	double
miles_quintuple_track	double
miles_sextuple_track	double
miles_of_mainline_passenger_track	double
miles_of_yard_and_non_mainline_track	double
crossings_with_gates	int64
crossings_without_gates	int64
longest_platform_feet	int64
maximum_speed_m_p_h	int64
average_speed_mph	int64
shortest_headway_min_sec	string
start_of_operations_hours_minutes_military_time	string
end_of_operations_hours_minutes_military_time	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-infrastructure-rail-lines\" 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.