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.