internal-agtransport-usda-gov/stb-railroad-service-metrics-axkm-yjzy
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

STB Railroad Service Metrics

The dataset contains weekly rail service metrics from the Surface Transportation Board (STB). The STB began collecting some service metrics from railroads in October 2014 and issued a final rulemaking in March 2017, ultimately collecting data on 11 different categories of rail service (listed below). The STB also collects Chicago-specific metrics that are not included in this dataset. The original STB source data can be found here: https://prod.stb.gov/reports-data/rail-service-data/.

This dataset is a compilation of all 11 categories in a single table. The single-table approach offers a convenient way to access all of the data at once, and it enables the use of the "global filter" feature in the Agricultural Rail Service Metrics dashboard found here: https://internal.agtransport.usda.gov/stories/s/jxpf-zf6y.

For those that wish to work with each category separately (or to view the metadata for each category), the 11 individual tables can be accessed at the following URLs:

Carloadings: https://agtransport.usda.gov/d/tb7q-kn5i.

Train Speeds: https://agtransport.usda.gov/d/2wy9-nmz4.

Origin Dwell Times: https://agtransport.usda.gov/d/34cn-rk65.

Terminal Dwell Times: https://agtransport.usda.gov/d/9z94-b4fw.

Cars On Line: https://agtransport.usda.gov/d/grdc-x6yk.

Manifest Grain Car Order Fulfillment: https://agtransport.usda.gov/d/57pa-stwn.

Railcars Not Moved: https://agtransport.usda.gov/d/fta3-xryx.

Trains Held Short: https://agtransport.usda.gov/d/iacs-9uck.

Grain Cars Loaded and Billed: https://agtransport.usda.gov/d/27k8-utc2.

Grain Shuttle Train Turns: https://agtransport.usda.gov/d/nwye-ushu.

Coal Unit Train Loadings: https://agtransport.usda.gov/d/5pbv-pd4d.

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/stb-railroad-service-metrics-axkm-yjzy\".\"stb_railroad_service_metrics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • stb_railroad_service_metrics
     
     
     
     
     
Upstream Metadata