From @rypan :
From Fred:
Because I can't leave well enough alone.... (like I said, I do this for fun....)
I already merged some demographics files from census.gov, grouped by their FIPS info. The combination of the two files below give me population and a bunch of other data grouped by FIPS. This was where I got my populations for the population adjusted numbers, but there's more to be had here.
https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/POP01.xls (several sheets with population data)
https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/Mastdata.xls (header names)
https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/LND01.xls (land areas and other stuff)
Because you triggered me :) I found a file that has CBSA (Core Based Statistical Areas) Code and CSA (Combined Statistical Areas) Title with FIPS. It also has a column that identifies if it's a "Metropolitan" or "Micropolitan" statistical area.
https://www2.census.gov/programs-surveys/metro-micro/geographies/reference-files/2020/delineation-files/list1_2020.xls
Combining all of these allows you to quickly turn the Github/Johns Hopkins data into CBSA-based data, since the JH data is all labeled by FIPS code. You can also readily use the population data to create the top 50 list, although I saw a few CBSA codes without a CSA name. There might be a little manual interaction to fill those in.
I've added it to my database, but haven't made any charts yet.
Enjoy (assuming you guys haven't beat me to this...)
From @rypan : From Fred: Because I can't leave well enough alone.... (like I said, I do this for fun....) I already merged some demographics files from census.gov, grouped by their FIPS info. The combination of the two files below give me population and a bunch of other data grouped by FIPS. This was where I got my populations for the population adjusted numbers, but there's more to be had here. https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/POP01.xls (several sheets with population data) https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/Mastdata.xls (header names) https://www2.census.gov/library/publications/2011/compendia/usa-counties/excel/LND01.xls (land areas and other stuff) Because you triggered me :) I found a file that has CBSA (Core Based Statistical Areas) Code and CSA (Combined Statistical Areas) Title with FIPS. It also has a column that identifies if it's a "Metropolitan" or "Micropolitan" statistical area. https://www2.census.gov/programs-surveys/metro-micro/geographies/reference-files/2020/delineation-files/list1_2020.xls Combining all of these allows you to quickly turn the Github/Johns Hopkins data into CBSA-based data, since the JH data is all labeled by FIPS code. You can also readily use the population data to create the top 50 list, although I saw a few CBSA codes without a CSA name. There might be a little manual interaction to fill those in. I've added it to my database, but haven't made any charts yet. Enjoy (assuming you guys haven't beat me to this...)