Hi Claire and Arloc,
(I'm sorry for the weekend email. I just wanted to write this up/send this off now while it was fresh on my mind. And to let Arloc know that I found a solution in case he was going to spend any time looking into this.)
After lots of experimenting and reading through Census API documentation here's what I came up with. I wanted to share with you the details because I think it's pretty powerful, and maybe something that could be incorporated into GetCensus at some point. I think this could be particularly helpful for state groups and civil rights groups that want detailed info on different race and ethnic groups.
I found a solution using "Selected Population Profiles".
Here's the variable list: https://api.census.gov/data/2024/acs/acs1/spp/variables.html
It's pretty powerful because you can choose a population group and get a specific statistic for that group by whatever geography you want.
So to get poverty rates by state for Black AOIC, the url for the Census API would be:
https://api.census.gov/data/2023/acs/acs1/spp?get=NAME,S0201_255E&POPGROUP=005&for=state:*
S0201_255E is the statistic (S0201_255E Estimate!!POVERTY RATES FOR FAMILIES AND PEOPLE FOR WHOM POVERTY STATUS IS DETERMINED!!All people, I found this through the variable list link above.)
POPGROUP=005 is how you choose the population group. Here's the list of possible population groups: https://api.census.gov/data/2024/acs/acs1/spp/variables/POPGROUP.json (There's a ton of them.)
I used the user-created censusapi command to get the data into stata so then I could combine different variables and generate tables:
censusapi, url(https://api.census.gov/data/2023/acs/acs1/spp?get=NAME,S0201_255E&POPGROUP=005&for=state:*)
I hope that's useful to you at some point,
Danilo
