• ACS 2014 5-year data in MS Access files

    Hi all,

    As I did with the 2013 ACS 5-Year data, I now have the 2014 ACS 5-year data in MS Access files for a handful of states. Most of these are western states as these are ones I'm directly working with, but if you have a need for the data in Access…
  • Here's a "fixed" table shells file for this week's release

    I just spent a couple hours manually stripping all tables that are NOT included in the 2014 5-year release, out of the 2014 table shells file. Here it is!


    [Updated on 11/30/2015 5:01 PM]
  • RE: ACS Table Format (Download One State)

    Hi Doug,

    This seems like an application for the summary files (if you don't want to go the traditional data.census.gov route).  The summary files are table-based, so you could build a list of your desired table names and then loop through the summary…

  • Importing the geography file into Access 2007

    Does anybody have advice or experience importing the 5yr 2012 ACS geography file into an Access 2007 database? I'm running into problems where the fields aren't matching up in the same way as the 2010 5-yr geography file did.

    Any thoughts / advice…
  • RE: Another alternative as the ACS data users group shuts down

    Thanks, Jon. I'd also been planning to recommend Census Bureau Slack as an alternative here.

    Besides that, there's also the IPUMS User Forum.

    IPUMS USA redistributes ACS microdata, and IPUMS NHGIS redistributes ACS data tables (the detailed B and…

  • Group quarters availability by block group for ACS 2023 5Y

    I noticed recently that the ACS 2019 - 2023 5-Year Summary File no longer provides block group-level estimates of population in group quarters via table B09019 (household type by relationship to head of household). However, these estimates remain available…

  • U.S. Census Bureau Releases 2023 ACS 1-year Estimates

    We are pleased to announce the release of the 2023 American Community Survey (ACS) 1-year estimates, the most relied-on source for up-to-date social, economic, and housing information every year. The ACS is the only source of local statistics for most…

  • ZCTA (level 860) total population in 2010 census

    I am looking for 2010 census ZCTA total population data (table P1).  Do any of the summary files (SF1 SF2 etc) have this data.  When I parse  https://www2.census.gov/census_2010/04-Summary_File_1/Massachusetts/ma2010.sf1.zip    file in zip archive  mageo2010…