Research Data

Here are some public datasets I used:

U.S. Population:

https://www.census.gov/data/tables/time-series/demo/popest/2010s-national-total.html#par_textimage_2011805803

Agricultural Data:

https://quickstats.nass.usda.gov/
It has yield, production, price, etc, agriculture related data.

Water Data:

https://waterdata.usgs.gov/nwis

Protected: Water withdrawal map (state level)

This content is password protected. To view it please enter your password below:

Password:

Finished Data Project: NASS QuickStats

• developed python scripts to download raw data from Nass QuickStats FTP, processed and loaded to SQL:
  ftp://ftp.nass.usda.gov/quickstats/

• SQL views are created based on the “raw” sql tables because it is easier to deal with null, string and symbols using views.

Working Project: American Community Survey (ACS)