Hi. I am looking for the ACS 1-year table that shows the share of people by state living in a metro area. I have collected this data before, but cannot seem to locate it. Thanks in advance!
Just a quick note. If all you need is total population B01003 has only one cell with the total population. It is easier to read with a program or on the screen.
Dave
As a note you might look for a relationship file on the census website that has census the tracts and/or county fips codes for the metro areas in the US I think that I may have one on my machine. When…
This would absolutely work, Bernie, but it seems even more tedious. The main impediment here is that data.census.gov does not include an option to select all metro areas within states in the US. TBH, it…
Derek, If you'd like, I can send you my current file of all counties, tagged as metro, micro or non-metro.Then you can do a simple Excel pivot to get the total populations for each, and then calc the percent of the state pop which live in metro, micro or rural (non-metro) counties.bert@bestplaces.net
Bert
Heck, here it is.
State - Metro - Micro - (blank) Grand Total
Thank you, Bert! I will give this a look in a bit.
As a note you might look for a relationship file on the census website that has census the tracts and/or county fips codes for the metro areas in the US I think that I may have one on my machine. When I have a minute tomorrow I'll see if I can find a link in my notes. If you can program using the API, then you loop over the list (I use R) download B01003, take the number from the table and throw it into a dataset. You can then reaggregate any way you want.
PS
GEOCORR has everything so when the mosquitos come out and Glenn comes in from the patio he should be able to find something.
HiBert Sperling This looks pretty good, and the comparison to 2019 data seems right. Can you tell me the source of this data please?
It's the ACS 2021 5yr populations, and the CBSA definitions are from the latest delineation files from the OMB (Mar2020) .I find it easiest and most flexible to download the tables and maintain my own files to slice and dice as needed.Shoot me an email and I'll hook you up.