ACS Data Users Group

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

Does this page help?

api.census.gov/.../examples.html

Never mind. I misread.

I don't see C17001 listed: Census Data API: /data/2022/acs/acs5/groups

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.

Dave

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

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 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.