• Standard errors for tract-level school enrollment ratios from ACS tables

    My organization often needs to estimate the net school enrollment ratio of children and youth ages 3-24 (inclusive) for various levels of geography including census tracts. For larger geographies, we estimate this directly from the PUMS and calculate…
  • RE: A Threat to the ACS from the Bureau Itself

    I was surprised to see this topic come up in the City Observatory newsletter this week so I am copying their comment below.  (City Observatory is newsletter that looks at urban planning issues through an economic lens.):

    New Knowledge

    Synthetic microdata…

  • RE: Decile cutpoints - inclusive or not?

    This is a problem I've had to deal with a lot. Whether it's percentile ranges or intervals to be used in a discrete distribution based on dollar amounts or some other "continuous" variable, here's how I proceed:
    1. determine the level…
  • 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")…

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

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

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

  • Cross walks of Census Geographies: MCDs and PUMAs

    I'm looking for a crosswalk between MCDs (Minor Civil Divisions) and PUMAs. 

    Alan