Changes

Jump to navigation Jump to search
no edit summary
=Notes=
The approach below, using American Fact Finder, seems to be ACS releases datasets in October of the most standardfollowing year. However, it does look like it works if you choose the right data year -- 2012 ACS It has 1-year estimates or 5 year estimates -- seems to . The five year estimates have all of the more information needed. See the [https://factfinder.census.gov/faces/nav/jsf/pages/download_center.xhtml Fact Finder Download Center]. Note that the  The 1 yr estimates are only available for places with populations of 65,000 people or more, the 1yr supplemental estimates cover down to places with 20,000 people or more, and the 5 yr estimates cover a whopping 29,573 places [https://www.census.gov/programs-surveys/acs/geography-acs/areas-published.html], as compared with just 630 for the 1yr and 2,323 or the 1yr supplements.
One can download the PUMS data for 2017 here: https://www2.census.gov/programs-surveys/acs/data/pums/2017/1-Year/ However, PUMS is only available for places in the [https://en.wikipedia.org/wiki/Public_Use_Microdata_Area Public Use Microdata Areas], which have a population 100,000 or more.
For just population, also see: http://census.ire.org/data/bulkdata.html. This seems to be based on the 2000 or 2010 census data only.
=File LocationUsing api.census.gov= The new approach is to use api.census.gov to request information. Each year has an API url For 2019:*The 2019 ACS5 available geographies: https://api.census.gov/data/2019/acs/acs5/geography.html*The 2019 ACS5 available variables: https://api.census.gov/data/2019/acs/acs5/variables.html*Some example URLs for the API: https://api.census.gov/data/2019/acs/acs5/examples.html Example API calls for median income, educational attainment, and race from the 5yr ACS, using the 2019 dataset:*Median Income: https://api.census.gov/data/2019/acs/acs5?get=NAME,B06011_001E&for=zip%20code%20tabulation%20area:**Educational Attainment: https://api.census.gov/data/2019/acs/acs5?get=NAME,group(B06009)&for=zip%20code%20tabulation%20area:**Race: https://api.census.gov/data/2019/acs/acs5?get=NAME,group(B02001)&for=zip%20code%20tabulation%20area:* Other links:The documentation on the ACS5: https://www.census.gov/data/developers/data-sets/acs-5year.htmlA slide deck on how to use the API: https://www.census.gov/content/dam/Census/programs-surveys/acs/guidance/training-presentations/06212017_ACS_Census_API.pdf  =Old Approach using AFF=
=New Files=The approach below, using American FactFinder (AFF), was the old standard. AFF has now been phased out. See the [https://factfinder.census.gov/faces/nav/jsf/pages/download_center.xhtml Fact Finder Download Center].
All of the corrected files and the Load.sql script are in:

Navigation menu