• Calculating percentage of individuals in a census tract with high school diploma or equivalent using tidycensus

    Hello everyone,

    New here!

    I am analyzing ACS data for the state of Kentucky. I am trying to figure out how to calculate percentage of individuals in a census tract who have graduated high school using tidycensus. I realize the educational attainment metrics…

  • Percent Change Between two estimates from non-overlapping ACS 5 Year Surveys

    Relative novice as it relates to reviewing/analyzing ACS 5 Year data.

    Timely insight needed to create a formula in MS Excel 2016 worksheet to calculate the percent change between two estimates from non-overlapping ACS 5 Year Surveys (2014 vs 2019) that…

  • Question about 2015-19 ACS

    In the 2015-19 ACS - Table B25026 - one category for mover is "Estimated Total population in occupied housing units - owner occupied moved in 2017 or later"

    If this is an accumulation of ACS data from 2015 to 2019, I don't see how this label…

  • Statistical Testing Tool - does this work for percents?

    Hello, 

    I'm interested in using this Statistical Testing Tool (https://www.census.gov/programs-surveys/acs/guidance/statistical-testing-tool.html) to compare '10-'14 to '15-'19, but for percentages rather than for estimates.  The examples…

  • Values of Zero for Median Year Structure Built

    For the latest 5-year ACS estimates, I noticed a discrepancy in the values for MEDIAN YEAR STRUCTURE BUILT BY TENURE (B25037_001) between the 5-year state summary file records and the matching data on data.census.gov.

     For example, Lincoln County, Kansas…

  • Median Family Income at the tract level: MSA/MD statewide & non-MSA/MD

    I need to produce the MSA/MD statewide & non-MSA/MD Median Family Income at the census tract level (for all tracts in the US) using the ACS 5Y 2010 estimates. 

    More precisely, I need to get the Median Family Income for the MSA/MD in which each tract is…

  • Rationale for making comparisons using non-overlapping periods

    Hi ACS friends, 

    I'm trying to explain to some brilliant but non-ACS-knowledgeable coworkers and others why the recommended approach is to use *non-overlapping* periods when making comparisons over time.  I've looked at the Census doc (https://www…

  • Using 5-year estimates for census block groups

    Hi folks, 

    I am working on a panel regression analysis of crime outcomes at the census block group level, and I am using ACS data as covariates. 

    My study period is 2014 - 2018, with my unit of time as meteorological season (so overall, T = 19).

    Unfortunately…

  • 2019 Population Shapefile

    I am wondering when the 2019 population shapefiles will be ready for downloading (located here). Thank you!

  • Cannot find Workplace Geography data for Texas in FTP files of ACS 5 year estimates

    I wanted to access the workplace geography - occupation 5-year estimates at the census tract or block group level for Texas. Essentially, I am interested in the variables -

    B08524_001 MEANS OF TRANSPORTATION TO WORK BY OCCUPATION FOR WORKPLACE GEOGRAPHY…

  • Forecasting race/ethnicity proportions at city scale

    Hello, first time poster here, interested in forecasting.

    I am working with a city-sized population (~150k residents, ~30 tracts) in the San Francisco Bay Area, for which I can retrieve ACS population estimates by race/ethnicity (from B01003) for a couple…

  • Educational attainment by race/ethnicity and county - can't get totals and subtotals to match

    Good afternoon,

    I am trying to use the latest ACS 5 Year data to document race and gender by educational attainment at the county level for the service region of our community college.   I used to use Factfinder for this, but have a question with the results…

  • 2018-2019 Metro-to-Metro Inflow and Outflow Migration Stats

    Does anyone know if the most current (I am assuming it would be the 2018-2019 or 2015-2019) Metro-to-Metro Migration Inflow and Outflow will be available?  Curious to see how many residents moved and where.  Looking for the County-to-County Migration Inflow…

  • Journey to Work question: are ridehailing apps like uber & lyft considered "taxicab" or "other means" for Table B08301?

    Hello, 

    I've read the 2018 Subject Definitions document on Means of Transportation to Work over and over again, did a search for "uber", "lyft", "ridehailing", "ridesharing", etc. and nothing comes up.  I have…

  • 5 year ACS (and Census) weights using Dorn's CZ crosswalk

    Hello! I am doing research using David Dorn's commuting zone crosswalk files and 1970-2000 5% state samples and a 2011-2015 ACS accessed from IPUMS. The files take PUMAs (or county groups in 1970 and 1980) and apportion them into commuting zones using…

  • Net Mobility MOE

    I'm trying to replicate how the ACS calculates their MOEs for Gross Migration and NetMigration from the latest 2013-2017 County-to-County Migration flow data. I followed their guidance/methodology for approximating a MOE for derived estimates but got…

  • Block Groups with Unweighted Sample of 0 Persons

    We combine 5 year ACS data at the blockgroup level to build neighborhood level statistics for our community - Cambridge, MA. 

    While reviewing the 2013-17 data we found that two blockgroups have an unweighted sample population of 0 in table B00001.  One…

  • Comparing Non-Overlapping 5 year estimates from 2006-2010 and 2011-2015

    Has anyone compared non-overlapping 5-year estimates from 2006 - 2010 and 2011 - 2015 at the tract level?  What has been your experience and how do you feel about the reliability of the results?

    I looked at ‘Drove Alone to Work’ comparing ACS tables B08006…

  • 2015 5-year data in Access Database

    Hello all,

    Just thought I'd let you know that I have once again put the 5-year 2011-2015 ACS summary files into Access database files. This makes it pretty simple to upload into SQL server or other RDBMS, if you need, connect to ArcGIS, or to simply run…

  • Aggregate dollar values suppressed for small geos

    I'm looking at table B19067, "AGGREGATE PUBLIC ASSISTANCE INCOME IN THE PAST 12 MONTHS (IN 2015 INFLATION-ADJUSTED DOLLARS) FOR HOUSEHOLDS". Looking at block groups, last year, for the 2010-2014 ACS, there were 131,952 block groups with data (the rest…

  • 2015 ACS 5-year Appendices

    Does anyone know if they will release the 5-year appendices ahead of the data release next week? I've been checking the documentation page every day. I was thinking they released documentation a little bit ahead for the 1year but now i'm not sure if I…

  • ACS 5-year data in MS Access by state

    Hi all,

    This is a duplicate post from the "Using ACS Summary Files" group, but since many may not also be in that group, I thought I'd post this here as well.

    As I did with the 2013 ACS 5-Year data, I now have the 2014 ACS 5-year data in…

  • 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…

  • Top-coded values

    Has anyone ever attempted to "fill-in" the top-coded values for the 5 year ACS PUMS data? For example, in 2009, all of the house values (variable: valp) greater than 4 million dollars in Hawaii get cutoff and it's impossible to tell if the observation…

  • ACS 2013 5-year data available in MS Access 2007

    Hi all,

    I will be importing the 5year estimate summary files for Oregon, Arizona, and Washington D.C. into an Access database (2007 version). I've set up a macro to run the import routine so it wouldn't be too difficult to do additional states. The files…