state_fips <- tidycensus::fips_codes %>% dplyr::select(state, state_code) %>%unique() %>%# call the columns with the names they have in the respective datasets dplyr::rename(STATEFP = state_code, LocationAbbr = state) counties <- counties %>%left_join(state_fips) %>% dplyr::rename(LocationDesc = NAME)