metro.data is a package that stores commonly used geographic and industry correspondence files and crosswalks.
You can install the version in development of metro.data from Github with:
devtools::install_github("BrookingsInstitution/metro-data-warehouse")
library(metro.data)Source is U.S. Census Bureau's delineation files. We use population data from ACS 5-year 2018 survey and employment data from County Business Patterns (2017).
head(county_cbsa_st)
# A tibble: 6 x 15
stco_code co_name co_pop co_emp co_pcturban co_type st_fips st_name st_emp cbsa_code cbsa_name
<chr> <chr> <dbl> <dbl> <dbl> <fct> <chr> <chr> <dbl> <chr> <chr>
1 01099 Monroe~ 21745 5400 21.0 rural ~ 01 Alabama 1.61e6 NA NA
2 01079 Lawren~ 33288 3138 8.71 small ~ 01 Alabama 1.61e6 19460 Decatur,~
3 01081 Lee Co~ 156597 43945 72.6 small ~ 01 Alabama 1.61e6 12220 Auburn-O~
4 01093 Marion~ 30058 7656 11.2 rural ~ 01 Alabama 1.61e6 NA NA
5 01107 Picken~ 20170 2639 0 small ~ 01 Alabama 1.61e6 46220 Tuscaloo~
6 01119 Sumter~ 13084 2991 0 rural ~ 01 Alabama 1.61e6 NA NA
# ... with 4 more variables: cbsa_type <fct>, cbsa_pop <dbl>, cbsa_emp <dbl>, cbsa_size <fct>Crosswalk is generated using GEOCORR 2018 from Missouri Census Data Center
head(place2county)
stpl_fips stco_fips st_fips st_ab pl_name co_name pl_pop16 afact1 afact2
1 0100100 01017 01 AL Abanda CDP, AL Chambers AL 189.912 1 0.006
2 0100124 01067 01 AL Abbeville city, AL Henry AL 2666.561 1 0.155
3 0100460 01073 01 AL Adamsville city, AL Jefferson AL 4529.245 1 0.007
4 0100484 01133 01 AL Addison town, AL Winston AL 736.979 1 0.031
5 0100676 01065 01 AL Akron town, AL Hale AL 337.748 1 0.023
6 0100820 01117 01 AL Alabaster city, AL Shelby AL 32769.300 1 0.156
FIPS code of top 100 metro by population
cbsa100_code
[1] "13820" "46060" "38060" "30780" "32820" "41860" "41940" "40900" "41740" "31080" "40140" "23420" "12540"
[14] "37100" "44700" "19740" "17820" "35300" "25540" "49340" "14860" "37980" "35840" "27260" "19660" "33100"
[27] "45300" "37340" "36740" "29460" "15980" "47900" "12060" "12260" "46520" "14260" "41180" "16980" "26900"
[40] "17140" "31140" "19780" "36540" "28140" "48620" "35380" "12940" "14460" "39300" "44140" "12580" "24340"
[53] "19820" "33460" "27140" "29820" "35620" "10900" "10740" "10580" "45060" "40380" "15380" "39100" "20500"
[66] "16740" "47260" "49180" "24660" "39580" "49660" "17460" "18140" "19430" "10420" "45780" "36420" "46140"
[79] "38900" "25420" "38300" "42540" "17900" "16700" "24860" "34980" "28940" "19100" "41700" "12420" "26420"
[92] "21340" "32580" "41620" "36260" "39340" "40060" "42660" "33340" "31540"
naics %>%
filter(naics_level == 6 & traded == 1) %>%
distinct(naics_code, naics_name)
# A tibble: 668 x 2
naics_code naics_name
<chr> <chr>
1 113110 Timber Tract Operations
2 113210 Forest Nurseries and Gathering of Forest Products
3 113310 Logging
4 114111 Finfish Fishing
5 114112 Shellfish Fishing
6 114119 Other Marine Fishing
7 114210 Hunting and Trapping
8 115111 Cotton Ginning
9 115112 Soil Preparation, Planting, and Cultivating
10 115113 Crop Harvesting, Primarily by Machine
# ... with 658 more rowsnaics %>%
filter(naics_level == 4 & !is.na(naics4_aitype)) %>%
distinct(naics_code, naics_name)
# A tibble: 50 x 2
naics_code naics_name
<chr> <chr>
1 2111 Oil and Gas Extraction
2 2122 Metal Ore Mining
3 2211 Electric Power Generation, Transmission and Distri~
4 3241 Petroleum and Coal Products Manufacturing
5 3251 Basic Chemical Manufacturing
6 3252 Resin, Synthetic Rubber, and Artificial and Synthe~
7 3253 Pesticide, Fertilizer, and Other Agricultural Chem~
8 3254 Pharmaceutical and Medicine Manufacturing
9 3259 Other Chemical Product and Preparation Manufacturi~
10 3271 Clay Product and Refractory Manufacturing
# ... with 40 more rowsmetro.data::find_cbsa_code("portland")
# A tibble: 2 x 2
cbsa_code cbsa_name
<chr> <chr>
1 38900 Portland-Vancouver-Hillsboro, OR-WA
2 38860 Portland-South Portland, ME
metro.data::find_cbsa_counties("denver")
# A tibble: 10 x 6
stco_code stco_name co_pop co_emp co_pcturban co_type
<chr> <chr> <dbl> <dbl> <dbl> <fct>
1 08031 Denver County, Colorado 693417 444646 100 Urban cores
2 08047 Gilpin County, Colorado 5924 4885 0 Exurbs
3 08059 Jefferson County, Colorado 570427 198024 93.1 Mature suburbs
4 08001 Adams County, Colorado 497115 173553 96.4 Urban cores
5 08019 Clear Creek County, Colorado 9379 2961 0 Exurbs
6 08093 Park County, Colorado 17392 1467 0 Exurbs
7 08005 Arapahoe County, Colorado 636671 293379 98.4 Urban cores
8 08014 Broomfield County, Colorado 66120 46084 99.4 Urban cores
9 08035 Douglas County, Colorado 328614 112808 89.7 Mature suburbs
10 08039 Elbert County, Colorado 25162 2595 0 Exurbs