• RE: trying to find the population of Van Nuys, CA

    ah, I missed that we already have a tabulation for 318 "LA County Neighborhoods" (original map from UCLA, unfortunately returning a 500 error now)

    censusreporter.org/.../

    It lists the 2020 population of Van Nuys as 109,290 compared to 104,734…

  • RE: Ratio of Income to Poverty by County and Race

    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…

  • RE: Breakdown of types of computers in household by state AND Age Demographic

    Note that if you want to have appropriate standard errors, you need to invoke `library(survey)` or `library(srvyr)` and use replicate weights.

  • RE: (lack of) transportation among older adults

    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…

  • RE: New version of Geocorr available with 2020 geographies

    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…

  • Creating Tables for the Unincorporated Area in a County

    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…

  • Query Error

    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…

  • RE: Advice on use of Blockgroup Data

    Dear All:

    Ah the discussion of so-called MOE's from the Census. As some of you know , the MOE's are computed using a so-called normal approximation. However, the Census also provides a series of tables using Balanced Random Replicates, which correctly…
  • Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

    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…

  • RE: List of Variable Names to Build a Simple State Level Panel using the ACS1 2010-2019

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