Home

Welcome to the SitegeistHealth wiki!

Data Sources:

http://www.census.gov/developers/

Tips for using census data from last year's Code Across America can be found at https://www.census.gov/developers/NDoCH_Support_Slides.pdf Codes for each available datapoint are defined here: https://ask.census.gov/faq.php?id=5000&faqId=1687

A substantial amount of the data that we want to use from the American Community Study is available at Census Block Group level which is one step higher resolution than the Census Tract.

This document shows the various data available and if you scroll to Appendix E at the end there the fourth column has a Yes if the data is available at the Block Group Level. This data is from the ACS Summary file that is available via FTP I am not sure how this changes with using the Census API.

http://www2.census.gov/acs2012_5yr/summaryfile/ACS_2008-2012_SF_Tech_Doc.pdf

There is also a video that talks about all of this here:

http://www.youtube.com/watch?v=v4w0KRo06_U&list=PLewV-zKXDZkieOyOGWNS0NpUpQE7e20mw&index=1

Oklahoma Voting by Precinct for 2012 http://www.ok.gov/elections/Candidates_&_Elections/General_Election_-_November_6,_2012.html Goal is to obtain Possible Voters, Registered Voters, and Actual Voters per Precinct and use that data to indicate Civic Engagement per precinct

USDA Data: The variable Access to Healthy Foods can be represented by the column PCT_LACCESS_POP10 taken from this file: http://www.ers.usda.gov/datafiles/Food_Environment_Atlas/Data_Access_and_Documentation_Downloads/Current_Version/DataDownload.xls which was taken from this page:http://www.ers.usda.gov/data-products/food-environment-atlas/data-access-and-documentation-downloads.aspx#.Uw63G_ldU2Q with this documentation http://www.ers.usda.gov/datafiles/Food_Environment_Atlas/Data_Access_and_Documentation_Downloads/Current_Version/documentation.pdf

Food Desert Data: http://apps.ams.usda.gov/fooddeserts/foodDeserts.aspx Farmers Market: http://search.ams.usda.gov/farmersmarkets/

Interesting approach to higher resolution data: Use prescription drug data to infer occurences http://www.ncbi.nlm.nih.gov/pubmed/20613655 http://www.propublica.org/article/using-prescriber-checkup-a-quick-guide http://blogs.denverpost.com/health/2013/01/22/mapping-medication-reveals-disturbing-bands-potential-misuse/2549/ http://insights.som.yale.edu/insights/study-maps-mental-health-medication-use-us

Shapefile Sources:

Census/Tiger Shapefiles - http://www.census.gov/cgi-bin/geo/shapefiles2013/main