Rail Terminal Dwell Times

Weekly terminal dwell time data from the Surface Transportation Board’s (STB) Rail Service Metrics. The STB began collecting service metrics from railroads in October 2014. As part of their submission to the STB, railroads provide average terminal dwell time, measured in hours, excluding cars on runthrough trains (i.e., cars that arrive at, and depart from, a terminal on the same through train) for the carrier’s system and its 10 largest terminals in terms of railcars processed. (Terminal dwell is the average time a car resides at a specified terminal location expressed in hours.)

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 \"internal-agtransport-usda-gov/rail-terminal-dwell-times-9z94-b4fw\".\"rail_terminal_dwell_times\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.