This view is a query from the full refrigerated truck rates and availability dataset. The query calculates average truck rates by week and region, and by binning shipment distances into 0-500 miles, 501-1500 miles, 1501-2500 miles, and 2500+ mile groups.

This filtered view pulls the latest week of data from the Grain Basis dataset.

This table derives from the grain price spreads data. It includes the latest week of data, as well as averages and standard deviations of price spreads over the past year for each commodity, origin, and destination combination. An indicator is calculated as a ratio, where the numerator is the difference between this week's price spread and the associated average price spread, and the denominator is the associated standard deviation.

Query from the Grain Inspections dataset, including only year-to-date records of grain and soybeans inspected by export region and country of destination from the current and previous year.

Query from the full grain inspections data to only include the latest week of data. Volumes are summed for each commodity, port, and destination combination.

This is a query from the export sales data, aggregating total outstanding sales by week, commodity, and country. The query is necessary to avoid double counting in the weeks where the calendar week ending and marketing year ending do not align.

This dataset shows how the rate spread between the U.S. Gulf and Pacific Northwest affects the export share of each region.

Query from rail carloadings data set to show the most recent week of data. It also includes average weekly carloads based on the month to provide a sense of the seasonal expected level. Additionally, it includes a calculation of one standard deviation above and below that average to provide a sense of variation around the expected level.

Query from U.S. vs Brazil transportation costs data to calculate origin-destination pair spreads.

This view is the result of multiple queries from the Secondary Auction Market Bids dataset to get the latest week of data and some historical averages and standard deviations for this month of the year.