cbsa2fips

Data source: U.S. Department of Health & Human Services

1,882 rows

View and edit SQL

Suggested facets: centraloutlyingcounty

metropolitanmicropolitanstatis

Link rowid ▼ cbsacode metrodivisioncode csacode cbsatitle metropolitanmicropolitanstatis metropolitandivisiontitle csatitle countycountyequivalent statename fipsstatecode fipscountycode centraloutlyingcounty
1 33860     Montgomery, AL Metropolitan Statistical Area     Autauga County Alabama 1 1 Central
2 19300   380 Daphne-Fairhope-Foley, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Baldwin County Alabama 1 3 Central
3 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Bibb County Alabama 1 7 Outlying
4 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Blount County Alabama 1 9 Outlying
5 11500     Anniston-Oxford-Jacksonville, AL Metropolitan Statistical Area     Calhoun County Alabama 1 15 Central
6 46740   194 Valley, AL Micropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Chambers County Alabama 1 17 Central
7 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Chilton County Alabama 1 21 Outlying
8 21460   222 Enterprise, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Coffee County Alabama 1 31 Central
9 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Colbert County Alabama 1 33 Central
10 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Coosa County Alabama 1 37 Outlying
11 18980   142 Cullman, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Cullman County Alabama 1 43 Central
12 37120   222 Ozark, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Dale County Alabama 1 45 Central
13 42820     Selma, AL Micropolitan Statistical Area     Dallas County Alabama 1 47 Central
14 33860     Montgomery, AL Metropolitan Statistical Area     Elmore County Alabama 1 51 Central
15 23460     Gadsden, AL Metropolitan Statistical Area     Etowah County Alabama 1 55 Central
16 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Geneva County Alabama 1 61 Outlying
17 46220     Tuscaloosa, AL Metropolitan Statistical Area     Hale County Alabama 1 65 Outlying
18 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Henry County Alabama 1 67 Outlying
19 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Houston County Alabama 1 69 Central
20 42460   174 Scottsboro, AL Micropolitan Statistical Area   Chattanooga-Cleveland-Dalton, TN-GA-AL Jackson County Alabama 1 71 Central
21 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Jefferson County Alabama 1 73 Central
22 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Lauderdale County Alabama 1 77 Central
23 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Lawrence County Alabama 1 79 Outlying
24 12220   194 Auburn-Opelika, AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Lee County Alabama 1 81 Central
25 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Limestone County Alabama 1 83 Outlying
26 33860     Montgomery, AL Metropolitan Statistical Area     Lowndes County Alabama 1 85 Outlying
27 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Madison County Alabama 1 89 Central
28 10700   290 Albertville, AL Micropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Marshall County Alabama 1 95 Central
29 33660   380 Mobile, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Mobile County Alabama 1 97 Central
30 33860     Montgomery, AL Metropolitan Statistical Area     Montgomery County Alabama 1 101 Central
31 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Morgan County Alabama 1 103 Central
32 46220     Tuscaloosa, AL Metropolitan Statistical Area     Pickens County Alabama 1 107 Outlying
33 45980     Troy, AL Micropolitan Statistical Area     Pike County Alabama 1 109 Central
34 17980   194 Columbus, GA-AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Russell County Alabama 1 113 Central
35 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL St. Clair County Alabama 1 115 Outlying
36 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Shelby County Alabama 1 117 Central
37 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Talladega County Alabama 1 121 Central
38 46220     Tuscaloosa, AL Metropolitan Statistical Area     Tuscaloosa County Alabama 1 125 Central
39 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Walker County Alabama 1 127 Outlying
40 11260     Anchorage, AK Metropolitan Statistical Area     Anchorage Municipality Alaska 2 20 Central
41 21820     Fairbanks, AK Metropolitan Statistical Area     Fairbanks North Star Borough Alaska 2 90 Central
42 27940     Juneau, AK Micropolitan Statistical Area     Juneau City and Borough Alaska 2 110 Central
43 28540     Ketchikan, AK Micropolitan Statistical Area     Ketchikan Gateway Borough Alaska 2 130 Central
44 11260     Anchorage, AK Metropolitan Statistical Area     Matanuska-Susitna Borough Alaska 2 170 Outlying
45 43420     Sierra Vista-Douglas, AZ Metropolitan Statistical Area     Cochise County Arizona 4 3 Central
46 22380     Flagstaff, AZ Metropolitan Statistical Area     Coconino County Arizona 4 5 Central
47 37740     Payson, AZ Micropolitan Statistical Area     Gila County Arizona 4 7 Central
48 40940     Safford, AZ Micropolitan Statistical Area     Graham County Arizona 4 9 Central
49 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Maricopa County Arizona 4 13 Central
50 29420   332 Lake Havasu City-Kingman, AZ Metropolitan Statistical Area   Las Vegas-Henderson, NV-AZ Mohave County Arizona 4 15 Central
51 43320     Show Low, AZ Micropolitan Statistical Area     Navajo County Arizona 4 17 Central
52 46060   536 Tucson, AZ Metropolitan Statistical Area   Tucson-Nogales, AZ Pima County Arizona 4 19 Central
53 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Pinal County Arizona 4 21 Central
54 35700   536 Nogales, AZ Micropolitan Statistical Area   Tucson-Nogales, AZ Santa Cruz County Arizona 4 23 Central
55 39140     Prescott, AZ Metropolitan Statistical Area     Yavapai County Arizona 4 25 Central
56 49740     Yuma, AZ Metropolitan Statistical Area     Yuma County Arizona 4 27 Central
57 34260     Mountain Home, AR Micropolitan Statistical Area     Baxter County Arkansas 5 5 Central
58 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Benton County Arkansas 5 7 Central
59 25460     Harrison, AR Micropolitan Statistical Area     Boone County Arkansas 5 9 Central
60 15780     Camden, AR Micropolitan Statistical Area     Calhoun County Arkansas 5 13 Outlying
61 11660     Arkadelphia, AR Micropolitan Statistical Area     Clark County Arkansas 5 19 Central
62 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Cleveland County Arkansas 5 25 Outlying
63 31620     Magnolia, AR Micropolitan Statistical Area     Columbia County Arkansas 5 27 Central
64 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Craighead County Arkansas 5 31 Central
65 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Crawford County Arkansas 5 33 Central
66 32820   368 Memphis, TN-MS-AR Metropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR Crittenden County Arkansas 5 35 Central
67 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Faulkner County Arkansas 5 45 Outlying
68 26300   284 Hot Springs, AR Metropolitan Statistical Area   Hot Springs-Malvern, AR Garland County Arkansas 5 51 Central
69 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Grant County Arkansas 5 53 Outlying
70 37500   308 Paragould, AR Micropolitan Statistical Area   Jonesboro-Paragould, AR Greene County Arkansas 5 55 Central
71 31680   284 Malvern, AR Micropolitan Statistical Area   Hot Springs-Malvern, AR Hot Spring County Arkansas 5 59 Central
72 12900     Batesville, AR Micropolitan Statistical Area     Independence County Arkansas 5 63 Central
73 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Jefferson County Arkansas 5 69 Central
74 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lincoln County Arkansas 5 79 Outlying
75 45500     Texarkana, TX-AR Metropolitan Statistical Area     Little River County Arkansas 5 81 Outlying
76 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lonoke County Arkansas 5 85 Central
77 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Madison County Arkansas 5 87 Outlying
78 45500     Texarkana, TX-AR Metropolitan Statistical Area     Miller County Arkansas 5 91 Central
79 14180     Blytheville, AR Micropolitan Statistical Area     Mississippi County Arkansas 5 93 Central
80 25460     Harrison, AR Micropolitan Statistical Area     Newton County Arkansas 5 101 Outlying
81 15780     Camden, AR Micropolitan Statistical Area     Ouachita County Arkansas 5 103 Central
82 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Perry County Arkansas 5 105 Outlying
83 25760     Helena-West Helena, AR Micropolitan Statistical Area     Phillips County Arkansas 5 107 Central
84 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Poinsett County Arkansas 5 111 Outlying
85 40780     Russellville, AR Micropolitan Statistical Area     Pope County Arkansas 5 115 Central
86 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Pulaski County Arkansas 5 119 Central
87 22620   368 Forrest City, AR Micropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR St. Francis County Arkansas 5 123 Central
88 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Saline County Arkansas 5 125 Central
89 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Sebastian County Arkansas 5 131 Central
90 20980     El Dorado, AR Micropolitan Statistical Area     Union County Arkansas 5 139 Central
91 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Washington County Arkansas 5 143 Central
92 42620   340 Searcy, AR Micropolitan Statistical Area   Little Rock-North Little Rock, AR White County Arkansas 5 145 Central
93 40780     Russellville, AR Micropolitan Statistical Area     Yell County Arkansas 5 149 Outlying
94 41860 36084 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area Oakland-Hayward-Berkeley, CA San Jose-San Francisco-Oakland, CA Alameda County California 6 1 Central
95 17020     Chico, CA Metropolitan Statistical Area     Butte County California 6 7 Central
96 41860 36084 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area Oakland-Hayward-Berkeley, CA San Jose-San Francisco-Oakland, CA Contra Costa County California 6 13 Outlying
97 18860     Crescent City, CA Micropolitan Statistical Area     Del Norte County California 6 15 Central
98 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA El Dorado County California 6 17 Central
99 23420   260 Fresno, CA Metropolitan Statistical Area   Fresno-Madera, CA Fresno County California 6 19 Central
100 21700     Eureka-Arcata-Fortuna, CA Micropolitan Statistical Area     Humboldt County California 6 23 Central

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cbsa2fips" (
"cbsacode" INTEGER,
  "metrodivisioncode" INTEGER,
  "csacode" INTEGER,
  "cbsatitle" TEXT,
  "metropolitanmicropolitanstatis" TEXT,
  "metropolitandivisiontitle" TEXT,
  "csatitle" TEXT,
  "countycountyequivalent" TEXT,
  "statename" TEXT,
  "fipsstatecode" INTEGER,
  "fipscountycode" INTEGER,
  "centraloutlyingcounty" TEXT
);
Powered by Datasette · Queries took 36.035ms · Data source: U.S. Department of Health & Human Services