• having problems recreating table B09021 "Living Arrangements of Adults 18 Years and Over by Age"

    Hi:

    I'm running these variables

    Where AGEP >17;
    TABLES HHT*RELSHIPP*SPORDER ;
          WEIGHT PWGTP;

    I only get good estimates for  householder living with spouse or spouse of householder,  Child of householder and Lives alone.and total

    the problem is because…

  • Census Bureau Updates on the ACS and 2020 Census

    Tune in to the plenary session at the ACS Conference this morning this morning to hear the latest Census Bureau updates on the ACS and the 2020 Census
     
    Updates on the ACS and 2020 Census: Agility in Action
    Tuesday May 14, 8:30 a.m.-10:00 a.m. (EDT)
     
  • Efficiently create long panel of 1-year estimates

    Hi,

    For research that I am currently conducting, I would like to create a panel data set with 1-year estimate data at the ZCTA level for 2009-2019. The data should have population counts by age, education level, and employment status, as well as median…

  • Pulling ACS 5-Year Median Household Income (Table B19013) by Zip Via API

    I'm pretty new to using API, and have had some success, but am running into challenges grabbing data from Table B19013 by zip code. This is the code I'm using.

    # Install required packages
    if (!require(tidycensus)) install.packages("tidycensus")…

  • Population aggregates at CBG and CT not matching (for ACS and Decennial Year as well)

    Hi,

    I'm using population estimates at census tracts and census block group level for race and ethnicity. Despite coming from the same tables, why don't the aggregate totals not match at census tract and census block group level? I have tried this with…

  • Geography Crosswalk Division to PUMA CBSA to PUMA

    Question for Glenn,

    I'm interested in geo correspondence files for Current Population Survey (CPS) geographies to PUMAs For example the CPS geo variable GTCBSA (also CTCO = county GEDIV = division GESTFIPS = state ) Does geocorr have all of these.…

  • ACS Income Microdata Seems Wrong

    Hey All, 

    I'm working on some ACS microdata and found a very strange response. In Massachusetts PUMA 508 (Malden and Medford), there's a household headed by a 26 year old that reported an income of over $3.5 million, which just seems remarkably unlikely…

  • households vs housing units

    Hello, I am confused by the distinction between households and housing units. I've summed the weights from an ACS housing file data for a particular county, and this equals the housing units estimate given in the summary file for that county. But when…