• RE: Forecasting race/ethnicity proportions at city scale

    Hey David:

    Interesting question! There are a few different techniques you could try -- one would be some sort of linear-based forecast model to predict total population (from pop estimates) and ACS-derived proportions using single-year data (for city…

  • RE: Zip Code Population by County

    Geocorr works by reducing both source and target geographies into collections of blocks -- the "atoms", if you will. We know the population of every block. So we can take all the blocks that are in ZCTA 21771 (say) and add up the populations of all those…

  • advice on accessing place or county subdivision summary files from the 2005 1-Year ACS

    I'm trying to obtain ACS 1-Year tables from 2005. Specifically, I'm looking for table B03002 (Hispanic or Latino origin by race) for either county subdivisions or places. The Census documentation says tables should be available for places with…

  • RE: Statistically comparing estimates

    Here is the response I got from the Census Bureau directly.  Just some food for thought!

    "You are correct that the poverty rate for Cook county is not independent from Illinois.  Depending on what they are using…

  • RE: Same-Sex Couples Data in ACS 2014-18?

    There are not tables (that I can see) that report same-sex married couples directly.
    BUT you could derive an estimate by subtracting two universes:

    Universe for Table B23010 is Married Couple Families
    Universe for B23007 is broader, but the Married Couple…
  • RE: census block group has zero occupied housing units but positive population

    They have set up a separate GQ Count Review for the 2020.  Apparently some of the GQs were put in nearby wrong blocks.  One of the problems, however, is that Differential Privacy was applied to the Block Groups, so in NY State after the prisoner relocations…

  • How to read the ACS data into SAS?

    Greetings! How to read the data from Table DP05 of the 2019 American Community Survey (ACS) 5-year estimates into SAS? When I deleted the second row on variable definition and read it into SAS, errors came (copied below). When I read all lines starting…

  • EEO tabulation vs. ACS tabulation for Race & Ethnicity - Educational Attainment

    Table 1 clearly reports the count Hispanic or Latino as a separate category from Not Hispanic or Latino by race. For that reason, I feel confident that the numbers I am reporting for those categories are accurate. However, citing the source as EEO_2006_2010…

  • Calculating a Median From a Weighted Distribution

    I'm reading through the PDF "Understanding and Using American Community Survey Data - What State and Local Government Users Need to Know" and need help recreating the calculation for the median salary in Case Study #1 as shown in Figure 3.8…

  • RE: Proposed changes to the ACS Summary File format

    As a longtime ACS Summary File user, this is a huge, and welcome change. Perhaps the best improvement is having column headers in the data files. This not only reduces the complexity in using the files, but it lessens the possibility of errors.

    One request…