Does anyone know of a resource to find the start dates for one-year and five-year ACS tables? For example, S1502 had its first year with one- and five-year data in 2015, B01001 in 2010. S2801 had its first with one-year data in 2015, and 5-year data in 2017.
I'm looking for a way to find those dates for arbitrary tables in bulk without having to pull them up one at a time in data.census.gov.
Thanks -
Jon
The database is available in html json and xml formats. Here is the link to the html
https://api.census.gov/data.html
The mail web page is:
https://www.census.gov/data/developers/updates/new-discovery-tool.html
You will need a package/program to read the database in one of the above format. As noted earlier the R censusapi package has a function that can download the database as an R "data.frame." you can the save it in a tab delimited file and read it into Excel.
Dave
Thank you, Dave!
What I find in those tables is text like this:
I'm hoping to find data showing individual tables and the period they were first issued, e.g., B28012 first has five-year data in 2020 and one-year data in 2021.
Any thoughts?
Dear Jon,
What I do is use is the R package censusapi. For the ACS vintage and period and table type (B,S,DP,C etc) you can download the metadata for each combination using the R function:
listCensusMetadata(name=name,vintage=vintage,type="variables")
Use the R function that downloads all the apis - see earlier reply - to get the relevant vintage and period then "loop" over all the combinations.
If you work for a non-profit (501(c)(3)) or government entity, I can probably find time to make up a data base for you with each table "group" the starting a ending vintage with 1 row in the spreadsheet for all the ACS tables that existed from 2010 to the latest vintage.
Sorry that I wasn't careful when I read your original post.
info@dorerfoundation.org