Survey Data

Combining Northern and Southern High Plains data from the USDA National Agricultural Statistics Service query tool (Access January 2020)

Import

Show keys

Show data items

Show earliest and latest data point for each data item

For which years does survey data exist for all four crops?

Create a dataset containing only the years where data for the four crops exists.

For each year, sum the weight of crops produced (be careful of units!) and the acres planted

Sum weights and areas per year

Add census data for all four crops in 1959, 1964, and corn irrigated acreage in 1974 and 1978

Estimate Texas irrigated corn yields by agricultural district and obtain production estimates

Import Kansas irrigated corn yields from downloaded excel sheet

Import Texas irrigated corn yields from downloaded excel sheet for the two districts

Compare Texas northern and southern districts to Kansas irrigated corn yields

Import corn irrigated acreage for Texas. These are to be multiplied by the estimated yields to obtain production values.