Database of names of capital cities of the USA?

Question

I was not successful in finding a US metropolis (for example, in the area of ​​San Francisco, South Bay, Berkshire, New York, etc.), which is determined by cities.

Does anyone know if such a thing exists?

Wikipedia has a list of “Interstate Regions” here:

http://en.wikipedia.org/w/index.php?title=List_of_regions_of_the_United_States#Intrastate_regions

In addition, it will be a pain going through every 50 states, and then pulling out an article area to find in which cities the specified area.

Lists MSA and CSA from Feds do not help, because they are based on statistical groupings, and not on common names.

Thank you very much in advance,

- Michael

Answer 1

http://www.census.gov/population/www/metroareas/lists/2008/List2.txt ?

List4.txt and List5.txt list the counties that are associated with each MSA (and Micropolitan SA). In order to map each city to its county, would that be enough?

Answer 2

To add more recent information to this post, here are a couple of links on Wikipedia that provide complete information on metropolitan statistical areas, including city names:

• List of metropolitan statistical areas: https://en.wikipedia.org/wiki/List_of_Metropolitan_Statistical_Areas

• List of US metropolitan areas (this list includes “major cities”) https://en.wikipedia.org/wiki/List_of_metropolitan_areas_of_the_United_States

I hope this helps others who fall into this post!