Dear Derek,
The only way I've been able to do this is build a model with age - sex - race -poverty level (above/below/undefined) and poverty200 (above/below 200 FPL) at the PUMA level (large area) using pums data for a PUMA containing the small area…
Note that if you want to have appropriate standard errors, you need to invoke `library(survey)` or `library(srvyr)` and use replicate weights.
Hi,
I have been asked to compare three iterations of Table B19001 (Household Income in the last 12 months), using the 2009-2013, 2014-2018, and 2019-2023 American Community Survey (ACS) 5-year data files.
The project requires reporting the weighted number…
Food Desert data?
The Food Access Research Atlas:
Presents a spatial overview of food access indicators for low-income and other census tracts using different measures of supermarket accessibility; Provides food access data for populations within census…
Just to add that as of yesterday, Geocorr 2022 now includes provisional 118th CDs and 2022 SLDLs and SLDUs.
I wrote "provisional", because I derived these geographies from state redistricting shapefiles and not "official" Census Bureau shapefiles…
Working in RStudio, I am using the censusapi package to access Population Estimates data. Specifically, I am trying to access data on race/ethnicity from 2010-2017 using the Vintage 2017 Population Estimates.
Running this code:
POP_COUNTY10 <-getCensus…
I have an interesting question about generating ACS tables for a county's unincorporated area. Counties in Colorado have to produce housing tables (such as B25032, Housing tenure by units in structure) for these areas.
In my mind, the most straightforward…
OK, some tables ex B25038 have hard-coded field descriptions that change every 2 years. I think the actual column name would stay the same? and it would just be the description would change. Typicially you never have time dimensions like this. It's last…
This is true for most of the ACS tables, they are often broken down by an additional variable and have to be aggregated to create a desired analysis table.
To take your example, searching for "Median Age" led me to table B01002, "Median Age by Sex":…