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…

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")…

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…

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

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…

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…

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

Alan

Hi all,

I am working with the microdata of 2020 5-year ACS data. 

I am trying to calculate the percentage of people in New York city that received public assistance income in the past 12 months. So I used pap variable (a person record), conditioning on…

Hello,

I'm a new ACS user seeking to create custom tables for race/ethnicity breakdown of educational attainment in all NY PUMAs for ACS 5-year estimates for vintages 2013 and 2018. I've created this easily for 2018 but having trouble with 2013.…