Hello, I am searching data on the evolution of the number of vehicle by states, and other variables if availables, to see the evolution since years. Where can we find time series data of the ACS ?
Rémy
Rémy,
ACS Table B25046 is "Aggregate Number of Vehicles Available by Tenure", which is available at the state level for 2023 at this link: https://data.census.gov/table?q=b25046&g=010XX00US$0400000&d=ACS+1-Year+Estimates+Detailed+Tables.
To get other years, at the top of the table to the right of the table title is a series of "buttons". The sixth one over is "Year". Click on that to get other years.
To download the data, click on the "Excel", "CSV", or "ZIP" buttons farther to the right.
Thanks, Dave Raglin
Thank you very much Dave this is really interesting. Just to be sure, the years data available for the ACS are only from 2010 to 2023 ?
Thank you for your detailed answer
The data.census.gov site only has data from 2010 on. However, previous years are available from a couple of other sources.
Data from the API are available for 2005 to 2009. For those estimates, here is the URL for 2005: api.census.gov/.../acs1 . This creates a CSV file that is downloaded to your computer and can be opened in Excel, providing the estimates and MOEs. (For 2006 to 2009, just change the year in the URL.)
Data for 2000 (the first year ACS was conducted nationally) to 2004 can be found at the ACS's FTP site. For 2004, you can go to https://www2.census.gov/programs-surveys/acs/data/archive/2004/BaseTables0402004.csv . That will download a CSV file that is downloaded to your computer and can be opened in Excel. That includes all of the base tables for all state--you will have to go down to find table B25046. (For 2000 to 2003, just change the year in the URL, and for those years, it is Table H043.)
Once again, thank you for your detailed reply, which was very helpful. Is there a place where I could find a list of all the arrays (with their number like: B25046) because potentially other variables could be interesting for me?
Thank you very much for your help
Rémy Molinié, HEC Montréal