Dear ACS DUG,
I'm trying to download C17001 via the API but I can't figure out the call/url.
acs/acs5 does not work
The subject tables are downloaded with
acs/acs5/Subject
The documentation does not give any examples at least that I can find.
Dave
I don't see C17001 listed: Census Data API: /data/2022/acs/acs5/groups
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…
Dear RDavis9,
That is the problem. I think that the ACS handbook indicates that you can download "C" tables but there are no examples on the examples webpage that give a url for "C" tables. I have an email into ACSO (American Community Survey Operations). Hopefully they will have an answer.
If you're just looking for certain variables, you can just add it to your API call like the B variables:api.census.gov/data/2022/acs/acs5?get=NAME,B01001_001E,C17002_001E&for=state:*There might be a way to get the entire table, but I'm not familiar.
The C table has different age categories from the B17001 table. Here is the response from ACSO
Only thing is that you get the E (estimate) fields, M (margins of error) fields, along with the EA and MA fields annotation which are basically like footnotes. (It actually corresponds well to the "notes" pane on data.census.gov). I end up pulling tables like this, and then dropping the EA and MA fields in most cases.
Here is the latest from ACSO Note it gives the url for the C table
I stand corrected on the previous email. Table C17001 is only available through the ACS 1-year estimates and is not provided through ACS 5-year estimates.
Here is an example call through the ACS 1-year dataset: https://api.census.gov/data/2022/acs/acs1?get=group(C17001)&for=state:*
Sorry for the confusion.