Parse the County Health Rankings into a sane data format
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
counties
excel
json
.gitignore
LICENSE
README.md
extract.js
package.json
parse_xls_files.js

README.md

County Health Rankings

The University of Wisconsin Population Health Institute's annual report of county-by-county health data is a wonderful resource, but the data is locked in Excel files that change format over time and are formatted for humans, not machines. (Death to nested headers!)

##Data The Excel files that live in the excel directory were downloaded from countyhealthrankings.org on April 22, 2015 and were not modified in any way. You are encouraged to redownload the files if you have any reason to suspect they have been modified. The citation for these files is:

University of Wisconsin Population Health Institute. County Health Rankings & Roadmaps 2015. www.countyhealthrankings.org.

##Usage

We've already converted the Excel files into nested JSON files by year, available in the json directory. You can easily recreate this step with the following command:

./parse_xls_files.json

To get data for each county for each year, just pass the name of the dataset and the field you want:

./extract.js --dataset='Adult smoking' --field='% Smokers' > data/smoking.json