cbsaxfips

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

1,882 rows

View and edit SQL

Suggested facets: metropolitanmicropolitanstatis, centraloutlyingcounty

Link rowid ▼ cbsacode metrodivisioncode csacode cbsatitle metropolitanmicropolitanstatis metropolitandivisiontitle csatitle countycountyequivalent statename fipsstatecode fipscountycode centraloutlyingcounty fips_code
1 33860     Montgomery, AL Metropolitan Statistical Area     Autauga County Alabama 01 001 Central 01001
2 19300   380 Daphne-Fairhope-Foley, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Baldwin County Alabama 01 003 Central 01003
3 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Bibb County Alabama 01 007 Outlying 01007
4 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Blount County Alabama 01 009 Outlying 01009
5 11500     Anniston-Oxford-Jacksonville, AL Metropolitan Statistical Area     Calhoun County Alabama 01 015 Central 01015
6 46740   194 Valley, AL Micropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Chambers County Alabama 01 017 Central 01017
7 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Chilton County Alabama 01 021 Outlying 01021
8 21460   222 Enterprise, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Coffee County Alabama 01 031 Central 01031
9 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Colbert County Alabama 01 033 Central 01033
10 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Coosa County Alabama 01 037 Outlying 01037
11 18980   142 Cullman, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Cullman County Alabama 01 043 Central 01043
12 37120   222 Ozark, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Dale County Alabama 01 045 Central 01045
13 42820     Selma, AL Micropolitan Statistical Area     Dallas County Alabama 01 047 Central 01047
14 33860     Montgomery, AL Metropolitan Statistical Area     Elmore County Alabama 01 051 Central 01051
15 23460     Gadsden, AL Metropolitan Statistical Area     Etowah County Alabama 01 055 Central 01055
16 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Geneva County Alabama 01 061 Outlying 01061
17 46220     Tuscaloosa, AL Metropolitan Statistical Area     Hale County Alabama 01 065 Outlying 01065
18 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Henry County Alabama 01 067 Outlying 01067
19 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Houston County Alabama 01 069 Central 01069
20 42460   174 Scottsboro, AL Micropolitan Statistical Area   Chattanooga-Cleveland-Dalton, TN-GA-AL Jackson County Alabama 01 071 Central 01071
21 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Jefferson County Alabama 01 073 Central 01073
22 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Lauderdale County Alabama 01 077 Central 01077
23 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Lawrence County Alabama 01 079 Outlying 01079
24 12220   194 Auburn-Opelika, AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Lee County Alabama 01 081 Central 01081
25 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Limestone County Alabama 01 083 Outlying 01083
26 33860     Montgomery, AL Metropolitan Statistical Area     Lowndes County Alabama 01 085 Outlying 01085
27 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Madison County Alabama 01 089 Central 01089
28 10700   290 Albertville, AL Micropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Marshall County Alabama 01 095 Central 01095
29 33660   380 Mobile, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Mobile County Alabama 01 097 Central 01097
30 33860     Montgomery, AL Metropolitan Statistical Area     Montgomery County Alabama 01 101 Central 01101
31 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Morgan County Alabama 01 103 Central 01103
32 46220     Tuscaloosa, AL Metropolitan Statistical Area     Pickens County Alabama 01 107 Outlying 01107
33 45980     Troy, AL Micropolitan Statistical Area     Pike County Alabama 01 109 Central 01109
34 17980   194 Columbus, GA-AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Russell County Alabama 01 113 Central 01113
35 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL St. Clair County Alabama 01 115 Outlying 01115
36 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Shelby County Alabama 01 117 Central 01117
37 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Talladega County Alabama 01 121 Central 01121
38 46220     Tuscaloosa, AL Metropolitan Statistical Area     Tuscaloosa County Alabama 01 125 Central 01125
39 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Walker County Alabama 01 127 Outlying 01127
40 11260     Anchorage, AK Metropolitan Statistical Area     Anchorage Municipality Alaska 02 020 Central 02020
41 21820     Fairbanks, AK Metropolitan Statistical Area     Fairbanks North Star Borough Alaska 02 090 Central 02090
42 27940     Juneau, AK Micropolitan Statistical Area     Juneau City and Borough Alaska 02 110 Central 02110
43 28540     Ketchikan, AK Micropolitan Statistical Area     Ketchikan Gateway Borough Alaska 02 130 Central 02130
44 11260     Anchorage, AK Metropolitan Statistical Area     Matanuska-Susitna Borough Alaska 02 170 Outlying 02170
45 43420     Sierra Vista-Douglas, AZ Metropolitan Statistical Area     Cochise County Arizona 04 003 Central 04003
46 22380     Flagstaff, AZ Metropolitan Statistical Area     Coconino County Arizona 04 005 Central 04005
47 37740     Payson, AZ Micropolitan Statistical Area     Gila County Arizona 04 007 Central 04007
48 40940     Safford, AZ Micropolitan Statistical Area     Graham County Arizona 04 009 Central 04009
49 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Maricopa County Arizona 04 013 Central 04013
50 29420   332 Lake Havasu City-Kingman, AZ Metropolitan Statistical Area   Las Vegas-Henderson, NV-AZ Mohave County Arizona 04 015 Central 04015
51 43320     Show Low, AZ Micropolitan Statistical Area     Navajo County Arizona 04 017 Central 04017
52 46060   536 Tucson, AZ Metropolitan Statistical Area   Tucson-Nogales, AZ Pima County Arizona 04 019 Central 04019
53 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Pinal County Arizona 04 021 Central 04021
54 35700   536 Nogales, AZ Micropolitan Statistical Area   Tucson-Nogales, AZ Santa Cruz County Arizona 04 023 Central 04023
55 39140     Prescott, AZ Metropolitan Statistical Area     Yavapai County Arizona 04 025 Central 04025
56 49740     Yuma, AZ Metropolitan Statistical Area     Yuma County Arizona 04 027 Central 04027
57 34260     Mountain Home, AR Micropolitan Statistical Area     Baxter County Arkansas 05 005 Central 05005
58 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Benton County Arkansas 05 007 Central 05007
59 25460     Harrison, AR Micropolitan Statistical Area     Boone County Arkansas 05 009 Central 05009
60 15780     Camden, AR Micropolitan Statistical Area     Calhoun County Arkansas 05 013 Outlying 05013
61 11660     Arkadelphia, AR Micropolitan Statistical Area     Clark County Arkansas 05 019 Central 05019
62 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Cleveland County Arkansas 05 025 Outlying 05025
63 31620     Magnolia, AR Micropolitan Statistical Area     Columbia County Arkansas 05 027 Central 05027
64 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Craighead County Arkansas 05 031 Central 05031
65 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Crawford County Arkansas 05 033 Central 05033
66 32820   368 Memphis, TN-MS-AR Metropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR Crittenden County Arkansas 05 035 Central 05035
67 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Faulkner County Arkansas 05 045 Outlying 05045
68 26300   284 Hot Springs, AR Metropolitan Statistical Area   Hot Springs-Malvern, AR Garland County Arkansas 05 051 Central 05051
69 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Grant County Arkansas 05 053 Outlying 05053
70 37500   308 Paragould, AR Micropolitan Statistical Area   Jonesboro-Paragould, AR Greene County Arkansas 05 055 Central 05055
71 31680   284 Malvern, AR Micropolitan Statistical Area   Hot Springs-Malvern, AR Hot Spring County Arkansas 05 059 Central 05059
72 12900     Batesville, AR Micropolitan Statistical Area     Independence County Arkansas 05 063 Central 05063
73 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Jefferson County Arkansas 05 069 Central 05069
74 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lincoln County Arkansas 05 079 Outlying 05079
75 45500     Texarkana, TX-AR Metropolitan Statistical Area     Little River County Arkansas 05 081 Outlying 05081
76 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lonoke County Arkansas 05 085 Central 05085
77 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Madison County Arkansas 05 087 Outlying 05087
78 45500     Texarkana, TX-AR Metropolitan Statistical Area     Miller County Arkansas 05 091 Central 05091
79 14180     Blytheville, AR Micropolitan Statistical Area     Mississippi County Arkansas 05 093 Central 05093
80 25460     Harrison, AR Micropolitan Statistical Area     Newton County Arkansas 05 101 Outlying 05101
81 15780     Camden, AR Micropolitan Statistical Area     Ouachita County Arkansas 05 103 Central 05103
82 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Perry County Arkansas 05 105 Outlying 05105
83 25760     Helena-West Helena, AR Micropolitan Statistical Area     Phillips County Arkansas 05 107 Central 05107
84 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Poinsett County Arkansas 05 111 Outlying 05111
85 40780     Russellville, AR Micropolitan Statistical Area     Pope County Arkansas 05 115 Central 05115
86 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Pulaski County Arkansas 05 119 Central 05119
87 22620   368 Forrest City, AR Micropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR St. Francis County Arkansas 05 123 Central 05123
88 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Saline County Arkansas 05 125 Central 05125
89 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Sebastian County Arkansas 05 131 Central 05131
90 20980     El Dorado, AR Micropolitan Statistical Area     Union County Arkansas 05 139 Central 05139
91 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Washington County Arkansas 05 143 Central 05143
92 42620   340 Searcy, AR Micropolitan Statistical Area   Little Rock-North Little Rock, AR White County Arkansas 05 145 Central 05145
93 40780     Russellville, AR Micropolitan Statistical Area     Yell County Arkansas 05 149 Outlying 05149
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 06 001 Central 06001
95 17020     Chico, CA Metropolitan Statistical Area     Butte County California 06 007 Central 06007
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 06 013 Outlying 06013
97 18860     Crescent City, CA Micropolitan Statistical Area     Del Norte County California 06 015 Central 06015
98 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA El Dorado County California 06 017 Central 06017
99 23420   260 Fresno, CA Metropolitan Statistical Area   Fresno-Madera, CA Fresno County California 06 019 Central 06019
100 21700     Eureka-Arcata-Fortuna, CA Micropolitan Statistical Area     Humboldt County California 06 023 Central 06023

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE cbsaxfips(
  "cbsacode" TEXT,
  "metrodivisioncode" TEXT,
  "csacode" TEXT,
  "cbsatitle" TEXT,
  "metropolitanmicropolitanstatis" TEXT,
  "metropolitandivisiontitle" TEXT,
  "csatitle" TEXT,
  "countycountyequivalent" TEXT,
  "statename" TEXT,
  "fipsstatecode" TEXT,
  "fipscountycode" TEXT,
  "centraloutlyingcounty" TEXT
, fips_code text);
CREATE INDEX fipsx on cbsaxfips (fips_code);
Powered by Datasette · Query took 37.905ms · Data source: U.S. Department of Health & Human Services