Tank Car Data 2017-2021

These are the count data for each type of Class III flammable liquid by each type of tank car, for each year. The data is based on information provided to the USDOT/Bureau of Transportation Statistics for the annual report: Fleet Compostion of Rail Tank Cars carrying Flammable Liquids.

Preferred Citation:

U.S. Department of Transportation, Bureau of Transportation Statistics, Fleet Composition of Rail Tank Cars Carrying Flammable Liquids: 2022 Report (Washington, DC: 2022). https://doi.org/10.21949/1527850

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 \"bts-gov/tank-car-data-20172021-gbe2-48iq\".\"tank_car_data_20172021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.