Metros that Cross State Lines

Hi Derek,

Counties are the underlying units of Metropolitan Statistical Areas (MSAs), so the remainder of the population of the Providence-Warwick MSA would reside outside of those two cities but inside the counties comprising the MSA.  

To find the counties comprising each MSA, you'll want to take a look at the Census Bureau's "Delineation Files".  The latest of these is available at: https://www.census.gov/geographies/reference-files/time-series/demo/metro-micro/delineation-files.html.  There you will find a spreadsheet linked under the title of Core based statistical areas (CBSAs), metropolitan divisions, and combined statistical areas (CSAs). 

According to that spreadsheet, the Providence-Warwick MSA is comprised of Bristol, Kent, Newport, Providence, and Washington County in RI and Bristol County in MA.

To be able to find out which core cities are in which counties, I suggest using Glenn Rice's fabulous Geocorr 2022: Geographic Correspondence Engine at https://mcdc.missouri.edu/applications/geocorr2022.html .  I think of it as the ultimate crosswalk-maker because it has saved me days of work over the years.  

Hopefully this clarifies some of the mystery.

Kathryn

Thank you for the comment re Geocorr. I'm glad so many people find it useful. 

I want to clarify that this application was originally created by John Blodgett, my predecessor and former colleague, who deserves 99% of the credit for Geocorr. 

Thanks, Kathryn DuBois! This is a very neat tool too, Glenn Rice.

I did come across ACS 5-year table B01003, which happens to show each state's share of the metro area population! For example:

Massachusetts (part); Providence-Warwick = 576,070 (35%)
Rhode Island (part); Providence-Warwick = 1,091,949 (65%)
Total = 1,668,019

All hail Gecorr!
A lovely piece of work, not to mention the ongoing effort to keep it current.
Thank you!