Refrigerated Truck Volumes

This data derives from USDA/AMS/Market News/Specialty Crops Program movement data, including only truck and import modes at domestic origins. It includes daily fruit and vegetable refrigerated truck volumes by origin district and commodity (from 2000 to 2010, data is weekly). The Transportation Services Division assigns a broader region to the origins in order to join to refrigerated truck rate and availability data.

The data is collected by AMS market reporters. Truck shipments for all commodities and origins are not available. Those obtainable are reported, but should not be interpreted as representing complete movements of a commodity. Truck shipments are collected at shipping points and include both inter and intrastate movements. They are obtained from various sources, including Federal marketing orders, administrative committees, Federal State inspection service and shippers. Methods used include telephone interviews, faxes, emails, and access to other data sources. The movement data is subject to adjustment as new information becomes available. The latest data will generally be under-reported until revisions are made. Updates to Market News Movement data can happen daily, weekly, monthly, and can happen at any time during the season. The Transportation Services Division updates our data from Market News weekly, including historical revisions.

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/refrigerated-truck-volumes-rfpn-7etz\".\"refrigerated_truck_volumes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.