This data is reported by USDA's Foreign Agricultural Service (FAS). USDA's Export Sales Reporting Program monitors U.S. agricultural export sales on a daily and weekly basis. Export sales reporting provides a constant stream of up-to-date market information for 40 U.S. agricultural commodities sold abroad. A single statistic reveals the significance of the program: in a typical year, the program monitors more than 40 percent of total U.S. agricultural exports. The program also serves as an early alert on the possible impact foreign sales have on U.S. supplies and prices. The weekly U.S. Export Sales report is the most current available source of U.S. export sales data. The data is used to analyze the overall level of export demand, determine where markets exist, and assess the relative position of U.S. commodities in foreign markets.
The date field in export sales is weekly, based on the calendar year. However, the dataset also keeps track of marketing year export sales. Be cautious when aggregating the export sales data over the date variable to properly account for these factors.
The turn of the marketing year often falls on a different day of the week then the weekly calendar year reporting. In this case, FAS adds an additional row (two total) to the dataset for that calendar week. One row represents that week's values which fell in the previous marketing year, while the other row captures that week's values which fell in the new marketing year. The "Marketing Year Start or End" variable labels these rows as "ENDING MY" and "STARTING MY", respectively, and is otherwise empty.
This creates a double counting issue when aggregating some of the variables by calendar week. See our view, https://agtransport.usda.gov/d/885i-uek7, for an example of avoiding double counting to show total outstanding sales over time.
|Name||Socrata field name||Column name in ||Data type||Description|
|Marketing Month||marketingmonth||marketingmonth||Number||Calculated for each commodity by offsetting the calendar year month to match the marketing year.|
|Accumulated Exports CMY||accexportscmy||accexportscmy||Number||Accumulated shipments of reportable commodities from the beginning of the marketing year (for each commodity) to the current week ending date. * Note:Accumulated exports are revised periodically due to adjustments made by reporting exporters.|
|Week||week||week||Number||Week number calculated from the reported week ending date (Date field). Week 1 is the first week of the year with a week ending date falling on or after January 4. In other words, it is the first reported week of data which includes four days in the new year. Values range from 1 to 52 or 53, depending on the year.|
|Marketing Year||myear||myear||Number||Calculated based on date, where corn and soybean marketing years start in September and wheat starts in June.|
|Weekly Exports CMY||wkexportscmy||wkexportscmy||Number||Shipments of reportable commodities exported against sales for a reporting week Friday through Thursday.|
|Net Sales, Total||net_sales_total||net_sales_total||Number||Sum of CMY and NMY net sales.|
|Outstanding Sales NMY||outsalesnmy||outsalesnmy||Number||The total outstanding export sales contracts for the next marketing year.|
|Marketing Year Start or End||my||my||Text||When the calendar year spans the marketing year end, this row designates the values attributable to the previous and next marketing years.|
|Commodity||commodity||commodity||Text||Wheat, Corn, or Soybeans.|
|Date||date||date||Calendar date||Calendar week ending date.|
|Month||month||month||Number||Month number calculated from the reported week ending date (Date field). Week ending dates falling before the fourth day of the month are assigned to the previous month. For example, a week ending date falling on February 1st, 2nd, or 3rd would correspond to “1” (January), since there are less than four days in the reported week that fall in February. Values range from 1 through 12, where 1 refers to January, 2 to February, etc.|
|Year||year||year||Number||Year number calculated from the reported week ending date (Date field). Week ending dates falling on or after January 4 correspond to the calendar year of the reported week. Week ending dates falling on or before January 3 correspond to the previous calendar year. For example, a week ending date falling on January 2, 2018 would be “2017.” Values range from 2000 to the present.|
|Commodity Type||type||type||Text||Subcategory of commodity, if it exists.|
|Outstanding Sales CMY||outsalescmy||outsalescmy||Number||The total outstanding export sales contracts for the current marketing year that have not yet been shipped.|
|Gross Sales CMY||grosalescmy||grosalescmy||Number||Includes increases resulting from new export sales, contract adjustments, loading tolerances, changes in marketing year, change in commodity or sales made against exports for the exporter's own account. Note: Gross new sales will include sales that were unshipped (carryover sales) at the end of the marketing year.|
|Net Sales CMY||netsalescmy||netsalescmy||Number||For the current marketing year, the sum total resulting from new export sales, increases resulting from changes in destination, decreases resulting from changes in destination, decreases resulting from purchases from foreign sellers, and cancellations resulting from contract adjustments, buybacks, loading tolerances, changes in marketing year, or change in commodity.|
|Net Sales NMY||netsalesnmy||netsalesnmy||Number||For the next marketing year, the sum total resulting from new export sales, increases resulting from changes in destination, decreases resulting from changes in destination, decreases resulting from purchases from foreign sellers, and cancellations resulting from contract adjustments, buybacks, loading tolerances, changes in marketing year, or change in commodity.|
|Total Commitments CMY||totcommcmy||totcommcmy||Number||The grand total of outstanding sales plus accumulated exports by country and/or commodity at any given time during the marketing year.|
|Outstanding Sales, Total||outstanding_sales_total||outstanding_sales_total||Number||Sum of CMY and NMY outstanding sales.|