Loss Data

Link

http://quickstats.nass.usda.gov/results/3831CAE8-6766-3452-BB33-F3DA3856D085

Instructions

1. Go to https://quickstats.nass.usda.gov.
2. Select the following:

Field	Value
Sector	ANIMALS & PROUCTS
Group	LIVESTOCK
Commodity	CATTLE and SHEEP
Category	LOSS, DEATH
Data Item	CATTLE, (EXCL CALVES) - LOSS, DEATH, MEASURED IN HEAD, CATTLE, CALVES - LOSS, DEATH, MEASURED IN HEAD, SHEEP, (EXCL LAMBS) - LOSS, DEATH, MEASURED IN HEAD, and SHEEP, LAMBS - LOSS, DEATH, MEASURED IN HEAD
Domain	TOTAL
Geographic Level	STATE
State	COLORADO, IDAHO, MONTANA, OREGON, WASHINGTON, WYOMING

3. Click Get Data.
4. Click Spreadsheet to download the data.
5. Open the file in Excel.
6. Delete all columns except: Program, Year, Period, State, Commodity, Data Item, Value.
7. Format the value column as a number with no decimal places or thousands separators.
8. Save.
9. Import.

Schema

Column	Type
program	enum('CENSUS', 'SURVEY')
year	year(4)
period	tinytext
state	tinytext
commodity	tinytext
data_item	tinytext
value	int(11)