Grain Transportation Report Datasets

The links below contain the data used to create the tables and figures found in the USDA?s Grain Transportation Report. These data series are aggregated from non-confidential and non-copyrighted sources. Below you will find the title of the table or figure. The line below the title gives a brief description for each of the files, followed by the source. These documents are in .xlsx format unless otherwise noted. If you have any questions about any of the files please contact us at GTRContactUs@ams.usda.gov.

• Table 1: Grain Transport Cost Indicators
• Weekly changes in truck, rail, barge, and ocean freight rates using diesel prices, nearby secondary rail market rates, Illinois barge rates, and ocean freight rates from U.S. Gulf and PNW to Japan as proxies. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 2: Market Update: U.S. Origins to Export Position Price Spreads ($/bushel)
• Compares interior prices of corn in Illinois and Nebraska and Gulf, Iowa and Gulf soybean prices, Kansa and Gulf Hard Red Winter wheat, North Dakota and Portland Hard Red Spring wheat. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 3: Rail Deliveries to Port
• Weekly rail deliveries to port for the PNW, Texas Gulf, Mississippi River, and Cross-Border Mexico movements. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 5: Railcar Auction Offerings
• Weekly railcar bids/offers in the primary shuttle and non-shuttle railcar market. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Figure 4, 5, 6: Bids/Offers for Railcars to be Delivered in the Secondary Market
• Weekly railcar bids/offers for the secondary non-shuttle and shuttle railcar Market. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 7: Tariff Rail Rates for Unit and Shuttle Train Shipments
• Monthly tariff rail rates and fuel surcharges for selected U.S. origin and destination pairs. (.xlsx file)
• Sources: www.bnsf.com, www.cpr.ca, www.csx.com, www.uprr.com


• Table 8: Tariff Rail Rates for U.S. Bulk Grain Shipments to Mexico
• Monthly tariff rail rates and fuel surcharges from selected U.S. origin states to selected Mexican regions. (.xlsx file)
• Sources: www.bnsf.com, www.uprr.com, www.kcsouthern.com


• Figure 7: Railroad Fuel Surcharges, North American Weight Average
• Monthly weighted average railroad fuel surcharges. (.xlsx file)
• Sources: www.bnsf.com, www.cn.ca, www.cpr.ca, www.csx.com, www.kcsi.com, www.nscorp.com, www.uprr.com


• Figure 8: Illinois River Barge Freight Rate
• Weekly grain barge rates for the Illinois River - Data also contained in Table 9. (.xlsx file)
• Explanation of Barge Rates (PDF)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 9: Weekly Barge Freight Rates for Southbound Only Shipments
• Weekly barge rates for major grain shipping points on the Mississippi, Ohio, and Arkansas Rivers. (.xlsx files)
• Source: Transportation & Marketing Programs/AMS/USDA


• Table 10: Barge Grain Movements
• Weekly grain barge movements through specific locks and dams by grain type. (.xlsx file)
• Source: U.S. Army Corps of Engineers (www.mvr.usace.armp.mil/mvrimi/omni/webrpts/default.asp)


• Figure 10: Grain. Barge Movements through Mississippi River Locks 27
• Weekly southbound grain barge movements through Lower Mississippi River Locks 27 (.xlsx file)
• Source: U.S. Army Corps of Engineers (www.mvr.usace.armp.mil/mvrimi/omni/webrpts/default.asp)


• Figure 11: Up Bound Empty Barges
• Weekly northbound movements of empty barges through Mississippi River Locks 27, Arkansas River Lock and Dam 1, and Ohio River Locks and Dam 52. (.xlsx file)
• Source: U.S. Army Corps of Engineers


• Figure 12: Grain Barges Unloaded in the New Orleans Port Region
• Weekly southbound grain barge movements through Mississippi River Locks 27, Arkansas River Lock and Dam 1, and Ohio River Locks and Dam 52 compared with the number of grain barges unloaded in the New Orleans Port Region ? Note: does not include barges originated south of Locks 27 near St. Louis, MO. (.xlsx file)
• Sources: U.S. Army Corps of Engineers and GIPSA


• Table 12: U.S. Export Balances and Cumulative Exports
• Unshipped export sales balances and cumulative marketing-year-to-date export sales of wheat, corn, and soybeans. (.xlsx file)
• Source: Foreign Agricultural Service/USDA (www.fas.usda.gov)


• Table 13: Top 5 Importers of U.S. Corn
• Cumulative export sales commitments for the top 5 importing countries of U.S. corn that account for over 70% of U.S. corn exports. (.xlsx file)
• Source: www.fas.usda.gov/export-sales/myfi_rpt.htm


• Table 14: Top 5 Importers of U.S. Soybeans
• Cumulative export sales commitments for the top 5 importing countries of U.S. soybeans that account for over 80% of U.S. soybean exports. (.xlsx file)
• Source: www.fas.usda.gov/export-sales/myfi_rpt.htm


• Table 15: Top 10 Importers of U.S. Wheat
• Cumulative export sales commitments for the top 10 importing countries of U.S. wheat that account for over 60% of U.S. wheat exports. (.xlsx file)
• Source: www.fas.usda.gov/export-sales/myfi_rpt.htm


• Table 16: Grain Inspections for Export by Port Region
• Weekly Inspections of grain for export in the PNW, Mississippi Gulf, Texas Gulf, Great Lakes, and Atlantic. (.xlsx file)
• Source: Grain Inspection, Packers and Stockyards Administration/USDA (www.gipsa.usda.gov)


• Table 17: Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
• Weekly number of grain vessels loaded during the week and expected to be loaded within the next 10 days in the Gulf, PNW, and Vancouver, B.C. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Figure 15: U.S. Grain Inspections: U.S. Gulf and PNW
• Weekly inspections of grain for export in the U.S. Gulf and PNW, compared to the 3-year averages. (.xlsx file)
• Source: Grain Inspection, Packers and Stockyards Administration/USDA (www.gipsa.usda.gov)


• Figure 16: U.S. Gulf Vessel Loading Activity
• Weekly vessel loading activity in the U.S. Gulf compared to same period a year earlier and 4-year average. (.xlsx file)
• Source: Transportation & Marketing Programs/AMS/USDA


• Figure 17: Grain Vessel Rates, U.S. to Japan
• Compares the monthly ocean freight rates for shipping bulk grain and the spread between the U.S. Gulf and PNW to Japan to the same period a year earlier and 4-year average. (.xlsx file)
• Source: O'Neil Commodity Consulting