Public Use Carload Waybill Sample

The Surface Transportation Board's Carload Waybill Sample is perhaps the most comprehensive dataset available on railroad movements and trends. More technically, it is a stratified sample of carload waybills for all U.S. rail traffic submitted by those rail carriers terminating 4,500 or more revenue carloads annually. See 49 C.F.R. §§ 1244.1 to 1244.5.

Waybill data have broad applications and usage in national railroad policy and regulations, such as rate cases, costing systems, productivity studies, exemption decisions, and analyses supporting regulations. Waybill data are used by transportation practitioners, consultants, and law firms in preparing verified statements to be submitted in formal proceedings before the Board or other public agencies. Various federal agencies use the Waybill Sample as part of their informational and decision-making framework, and many states use it as a source of information for developing state transportation plans.

STB creates the Public Use Waybill file from the confidential Waybill Sample file. See the attached documents for more information. The "Reference Guide" document contains additional details on the variables and Standard Transportation Commodity Codes (STCC). In the "Creation of the Public Use Waybill Sample" document, STB provides more detail on the public use sample and how it is created. There is also a map of Bureau of Economic Analysis (BEA) Areas and a document describing the Waybill sampling instructions.

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/public-use-carload-waybill-sample-xve5-xb56\".\"public_use_carload_waybill_sample\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.