Basic API question (I watched several videos already)

It looks like to only practical way to get data is the API. I've watched several videos, read pages etc, and am still lost.

All ACS API's start with

For acs-1 its,group(B01001),group(S0101),group(S0201)

Then there is ^&^&^ I don't understand and then to get county level data this goes at the end   &for=county:*  

I want table S0101 for all counties with;

County name

County ID





Long day at work and now its 1am and I'm doing this???

Parents Reply Children
  • Thanks so Much! It works. I was under the assumption the column-meta-data file fields would all have data. So I have to check the download data file, find fields I want and make sure there is data, then create the URL. I think it will take me 30-60 minutes for each download file and I have around 18 tables to download. 

    Add a day to download the URL data into tabs, clean it up and make it into 1 happy table with all the fields together. Then Tableau.

    If I ever do this again, and nothing big changes to the tables it might take me 4-6 hours

    I could use the methodology for ACS-5, although the data and tables might be slightly different.

    Thanks again !