The 2025 ACS Data Users Conference will now be a one-day conference—held virtually—on May 29, 2025

  • Availability of 2009 and earlier Data Profile (DP) tables through FTP & API

    I desire to download the DP tables from 2009. I want to confirm that they are not available through the FTP and only available through the API. I do not see any documentation on the Census Bureau website that says this explicitly. I want to confirm with…

  • Annual DP Tables: Column Name - Label Changes

    I'm working on analyzing tables DP02, DP03, DP04, and DP05 from 2007 to 2022 and am searching for a comprehensive legend that tracks changes in variable codes over time.

    For instance, the field “Estimate!!ANCESTRY!!Total population!!Greek” uses the…

  • RE: Small Area Estimation R Package

    Dear DUG,

    I have updated the Windows installer 31 March 2024 (see  https://dorerfoundation.org/software)

    You can now compute replicate weights that take into account the Margin of Error for the adjusting target marginal tables.

    These new functions need…

  • RE: Question of Using API: Variable Postfix

    I think the "E" suffix is for the numeric estimate, the "M" is for the margin of error, and the "PE" is for the percent estimate. So DP02_0059E would refer to the estimate from line 59 of table DP02. Pull some values through the API and compare it to…

  • RE: Question of Using API: Variable Postfix

    Hi Gan,

    The characters DP02_0059 are the variable identifier or name. The one with 'E' on the end gives you the estimate itself for that variable. The one with 'M' at the end gives you the margin of error for that estimate. I don't know what the …

  • RE: 5-Yr PUMA Geography

    That's great to hear, I'm excited to use the new PUMAs in the 2022 5yr survey for the older data for a question I'm working on. I have a tangential question.

    In my work I've been using the tidycensus, survey, and srvyr packages in R and calling…

  • RE: Data Suppression Question

    If you download the table using the API you will find numeric codes in the cells that are suppressed.  The codes are here.

    https://www.census.gov/data/developers/data-sets/acs-1year/notes-on-acs-estimate-and-annotation-values.html

    There are other rules…

  • RE: Percent Change Between two estimates from non-overlapping ACS 5 Year Surveys

    C = Current estimate, M_C = Margin of error on Current Estimate,

    P = Previous estimate, M_P = Margin of error on Previous Estimate,

    % change = (C-P) / P = (C/P) - 1

    Margin of error on % change = sqrt( M_C^2 + (C/P)^2 * M_P^2 ) / P

  • Estimates of non-Hispanic Black/African-American Adults

    It's straightforward to get estimates of the total number of adults in a geography and the total number of Black, non-Hispanic persons in a geography, but I can't see any way to get the combination of these things (the number of Black, non-Hispanic…

  • ACS-5 fields data pull (seeking feedback on webpage)

    OK, this is a few weeks away from being finished and its in Dev mode and you need to input a field ( B19083_001E ) etc. to make it work, but it should work, I hope? For those who know or have a field name it might help give a quick overview. But for…

For more information about the American Community Survey Census Bureau Website