How is Agriculture / Farm data put together? I put together the general steps for agricultural data: 1) Download ERS data (2006 was ready 08/07) This data is from the ERS web site http://www.ers.usda.gov/Data/FarmIncome/finfidmu.htm Scroll to the Farm Cash Receipts. Force states to sum to US. 2) Adjust for on-farm use (largely affects hay). 3) Distribute sales to county based on 2002 Ag Census. Distributors differ between commodities (cattle count, dairy production, acres in crop, sales, etc.). 4) Update 2005 REIS farm employment to 2006 based on ES202 farm employment between 2005 and 2006. (2007 data will not change number of proprietors, only update wage and salary due to volatility in farm ES202 data). 5) Distribute updated REIS farm to sectoring based on National output per workers and number of farms in sectors (for proprietors). 6) Force states to sum to US and counties to sum to states.
Please sign in to leave a comment.