CDC County Mapping

[USMortality]

CDC County Mapping

[USMortality]

Cool.

I managed to resolve most of it, except Alaska pre 2003, where I some counties were not just split/merged:

# Resolve mapping issues
df |>
    split_row("02261", "02063", "02066") |>
    split_row("02232", "02105", "02230") |>
    split_row("02280", "02275", "02195")
df$fips[df$fips == "02270"] <- "02158"
df$fips[df$fips == "46113"] <- "46102"

split_row is a custom function which simply splices a row into two...

[pdil]

I can't seem to access that CDC data but based on your code it seems like they are also using FIPS codes but they're just lacking some of them? I think you should be able to plot the data on the map but the counties that correspond to the missing FIPS codes will appear blank (whatever the default color of the map is). Is this what is happening or are you trying to do something other than coloring a map with the data?

[USMortality]

Simple example:

The current, CDC dataset linked above, still uses Alaska's 02270 fips, instead of the reassigned 022158.
The fix is to run: df$fips[df$fips == "02270"] <- "02158" on the cdc dataset, there's a handful more of these cases.

I was just wondering, if anyone has already mapped these out ;)
If not, just disregard this, and please close. thx :)

[pdil]

Unfortunately I'm not aware of anyone that's already done that mapping 🙁