I have two datasets with columns described below:
A list of all "place" names derived from here (US Census):
And this one, a list of county FIPS codes, also derived from the US Census (here)
I need to match the placefp
codes (shown above in the first able) with the countyfips
codes (shown above in second table), e.g. get the county for every "place." I can't seem to find a mapping of the place FIPS to the county FIPS, and it doesn't appear that the counties are included
Where could I find a mapping of the "place" FIPS codes to the county FIPS codes?