• RE: 2020 ACS 1-Year Experimental Estimates

    The Census Bureau announced today that the 2020 ACS 1-year experimental data will be released on Tuesday, November 30. This release will also include the 1-year PUMS with experimental weights, a technical working paper, and a blog. The Census Bureau will…

  • RE: Locating and downloading labor force participation data for mothers in ACS data

    Hi Georgia, 

    My guess is that they used the Public Use Microdata Sample (PUMS) file to construct that variable.  I think the closest table for you would be B23008: Age of own children under 18 years in families & subfamilies by living arrangements by employment…

  • RE: Median annual earnings

    Good morning -

    Here are a couple of thoughts:

    First, yes, you do need to weight cases using PWGTP.

    Second, when troubleshooting, it might make sense to first try and replicate the results in an existing table (such as number of workers in each income…
  • RE: Microdata questions

    Hi Sarah, yes, I agree with Stas. The best way to answer this question is working with the actual dataset. I know ipums is great, but I have more familiarity with the regular PUMS dataset from census.gov (https://www.census.gov/programs-surveys/acs/microdata…

  • RE: County level estimates

    Bernie, thank you for your suggestions and it's very helpful. Do you know how use the Counties in PUMS data? I have to compute the count of these veterans who would be eligible for VA healthcare using their income and disability fields in the PUMS data…
  • RE: workers in their POWPUMA

    Also if you are looking at employed persons that will most likely be where they live, not where they work. I believe there are a limited number of tables in the ACS that have workers as the universe and geography is by place of work. I am not as familiar…
  • Distribution of Occupied Housing Units by number of persons in household

    Can someone help me understand what's going on here?

    I created the table below from the PUMS 2018 1yr housing file showing the number of Occupied Housing Units by number of persons in the household (variable NP).

    I would expect to get the total population…

  • RE: Complete ACS data series

    Hi Julio. The PUMS microdata provides detailed linguistic and ancestry data. www.census.gov/.../pums.html. The spatial resolution is lower than the tabular ACS data, but you can gain a great deal in terms of detail. I hope this might be of some help to…
  • Using ACS for Complex Data Dives

    Hello,

    I'm trying to determine the best way to do more complex queries using ACS. It may be that my better answer is PUMS or another method, in which case, please let me know! My current director is leaving, and she's not familiar with the changes…

  • Census 2020-based PUMAs are apparently finalized

    The Census 2020-based Public Use Microdata Areas (PUMAs) are apparently finalized. I found a Census Bureau page that provides a link to ALL of the new PUMAs, in PDF format.

    https://www.census.gov/geographies/reference-maps/2020/geo/2020-pumas.html

    My…