Rail Cars Not Moved

Weekly "cars held" data from the Surface Transportation Board's (STB) Rail Service Metrics. As part of their submission to the STB, railroads provide data on the average daily number of loaded and empty cars, operating in normal movement and billed to an origin or destination, which have not moved in more than 48 hours. The data is broken out by service type: intermodal, grain, coal, crude oil, automotive, ethanol, fertilizer, or all other. In order to derive the daily averages for the reporting week, carriers are requested to run a same-time snapshot each day of the reporting week, capturing cars within each category that have not moved in 48 hours or more. The number of cars captured on the daily snapshot for each category should be added, and then divided by the number of days in the reporting week (typically seven days). In deriving this data, carriers should include cars in normal service anywhere on their system, but should not include cars placed at a customer facility; in constructive placement; placed for interchange to another carrier; in bad order status; in storage; or operating in railroad service (e.g., ballast).

Fertilizer is defined by the following 14 Standard Transportation Commodity Codes (STCCs): 2871236, 2871235, 2871238, 2819454, 2812534, 2818426, 2819815, 2818170, 2871315, 2818142, 2818146, 2871244, 2819173, and 2871451. STCC 287 covers agricultural chemicals and STCC 281 covers industrial inorganic or organic chemicals (excluding pesticides).

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-cars-not-moved-fta3-xryx\".\"rail_cars_not_moved\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.