internal-agtransport-usda-gov/train-speeds-2wy9-nmz4
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Train Speeds

Weekly train speeds 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 data on the average speed of their trains (in miles per hour), broken out by commodity/type such as automotive, coal, crude oil, ethanol, grain, intermodal, manifest, etc. Railroads also report a “system average” train speed. According to the STB rulemaking, train speed should be measured for line-haul movements between terminals. The average speed for each train type should be calculated by dividing total train miles by total hours operated.

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/train-speeds-2wy9-nmz4\".\"train_speeds\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • train_speeds
     
     
     
     
     
Upstream Metadata