Year-to-Date Grain Inspections, Compared to Last Year

internal.agtransport.usda.gov | Last Updated 22 May 2019

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.

Tags: exports, grain, ports, inspections

This dataset has the following 10 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Datedatecalendar_dateWeek ending date, ranging from 1983 to the present.
GraingraintextType of grain shipped.
ClassclasstextClass of specific grain, see https://fgisonline.ams.usda.gov/G_APS/G_APS_ComClassHierarchy.aspx?pEM=D.
SubClasssubclasstextSubclass of specific grain.
DestinationdestinationtextCountry receiving the grain.
AMS_Regams_regtextUSDA/AMS Export region.
MTmtnumberGrain volume in metric tons.
WeekweeknumberWeek 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.
MonthmonthnumberMonth 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.
YearyearnumberYear 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 1983 to the present.