The col names in S0201 are different. Usually, they have 3 parts, but in this table, only 2, and the API calls fail. Are there some tables with diff name configurations, or is this just some kind of error? I tried to add a middle part (C01), but that…
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
A colleague was recalculating derived variables from the ACS for a research study and is trying to calculate Margin of Error for population density using guidance here: https://www.census.gov/content/dam/Census/library/publications/2018/acs/acs_general_handbook_2018_ch08…
The thing that's most beguiling about this isn't the differences, but that some states have exactly matching numbers. If margins of error were the culprit, I wouldn't really expect any states to have exactly matching numbers. Note that there are a very…
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…
The microdata is a sub-set of the ACS sample. As a subset, one would expect that it would not produce the same results as shown in the summary tables. However, I would at least expect it to not vary significantly and to be within the margins of error…
Yes, you can get entire tables by using the Group() notation:
https://api.census.gov/data/2022/acs/acs5?get=NAME,group(C17002)&for=state:*
Only thing is that you get the E (estimate) fields, M (margins of error) fields, along with the EA and MA fields…