cbsaxfips

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

1,882 rows

View and edit SQL

Link rowid ▼ cbsacode metrodivisioncode csacode cbsatitle metropolitanmicropolitanstatis metropolitandivisiontitle csatitle countycountyequivalent statename fipsstatecode fipscountycode centraloutlyingcounty fips_code
101 20940     El Centro, CA Metropolitan Statistical Area     Imperial County California 06 025 Central 06025
102 12540     Bakersfield, CA Metropolitan Statistical Area     Kern County California 06 029 Central 06029
103 25260   546 Hanford-Corcoran, CA Metropolitan Statistical Area   Visalia-Porterville-Hanford, CA Kings County California 06 031 Central 06031
104 17340     Clearlake, CA Micropolitan Statistical Area     Lake County California 06 033 Central 06033
105 45000     Susanville, CA Micropolitan Statistical Area     Lassen County California 06 035 Central 06035
106 31080 31084 348 Los Angeles-Long Beach-Anaheim, CA Metropolitan Statistical Area Los Angeles-Long Beach-Glendale, CA Los Angeles-Long Beach, CA Los Angeles County California 06 037 Central 06037
107 31460   260 Madera, CA Metropolitan Statistical Area   Fresno-Madera, CA Madera County California 06 039 Central 06039
108 41860 42034 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area San Rafael, CA San Jose-San Francisco-Oakland, CA Marin County California 06 041 Central 06041
109 46380     Ukiah, CA Micropolitan Statistical Area     Mendocino County California 06 045 Central 06045
110 32900   382 Merced, CA Metropolitan Statistical Area   Modesto-Merced, CA Merced County California 06 047 Central 06047
111 41500     Salinas, CA Metropolitan Statistical Area     Monterey County California 06 053 Central 06053
112 34900   488 Napa, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Napa County California 06 055 Central 06055
113 46020   472 Truckee-Grass Valley, CA Micropolitan Statistical Area   Sacramento-Roseville, CA Nevada County California 06 057 Central 06057
114 31080 11244 348 Los Angeles-Long Beach-Anaheim, CA Metropolitan Statistical Area Anaheim-Santa Ana-Irvine, CA Los Angeles-Long Beach, CA Orange County California 06 059 Central 06059
115 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Placer County California 06 061 Central 06061
116 40140   348 Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA Riverside County California 06 065 Central 06065
117 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Sacramento County California 06 067 Central 06067
118 41940   488 San Jose-Sunnyvale-Santa Clara, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA San Benito County California 06 069 Outlying 06069
119 40140   348 Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA San Bernardino County California 06 071 Central 06071
120 41740     San Diego-Carlsbad, CA Metropolitan Statistical Area     San Diego County California 06 073 Central 06073
121 41860 41884 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area San Francisco-Redwood City-South San Francisco, CA San Jose-San Francisco-Oakland, CA San Francisco County California 06 075 Central 06075
122 44700   488 Stockton-Lodi, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA San Joaquin County California 06 077 Central 06077
123 42020     San Luis Obispo-Paso Robles-Arroyo Grande, CA Metropolitan Statistical Area     San Luis Obispo County California 06 079 Central 06079
124 41860 41884 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area San Francisco-Redwood City-South San Francisco, CA San Jose-San Francisco-Oakland, CA San Mateo County California 06 081 Central 06081
125 42200     Santa Maria-Santa Barbara, CA Metropolitan Statistical Area     Santa Barbara County California 06 083 Central 06083
126 41940   488 San Jose-Sunnyvale-Santa Clara, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Santa Clara County California 06 085 Central 06085
127 42100   488 Santa Cruz-Watsonville, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Santa Cruz County California 06 087 Central 06087
128 39820   454 Redding, CA Metropolitan Statistical Area   Redding-Red Bluff, CA Shasta County California 06 089 Central 06089
129 46700   488 Vallejo-Fairfield, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Solano County California 06 095 Central 06095
130 42220   488 Santa Rosa, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Sonoma County California 06 097 Central 06097
131 33700   382 Modesto, CA Metropolitan Statistical Area   Modesto-Merced, CA Stanislaus County California 06 099 Central 06099
132 49700   472 Yuba City, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Sutter County California 06 101 Central 06101
133 39780   454 Red Bluff, CA Micropolitan Statistical Area   Redding-Red Bluff, CA Tehama County California 06 103 Central 06103
134 47300   546 Visalia-Porterville, CA Metropolitan Statistical Area   Visalia-Porterville-Hanford, CA Tulare County California 06 107 Central 06107
135 43760     Sonora, CA Micropolitan Statistical Area     Tuolumne County California 06 109 Central 06109
136 37100   348 Oxnard-Thousand Oaks-Ventura, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA Ventura County California 06 111 Central 06111
137 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Yolo County California 06 113 Outlying 06113
138 49700   472 Yuba City, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Yuba County California 06 115 Central 06115
139 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Adams County Colorado 08 001 Central 08001
140 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Arapahoe County Colorado 08 005 Central 08005
141 14500   216 Boulder, CO Metropolitan Statistical Area   Denver-Aurora, CO Boulder County Colorado 08 013 Central 08013
142 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Broomfield County Colorado 08 014 Central 08014
143 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Clear Creek County Colorado 08 019 Outlying 08019
144 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Denver County Colorado 08 031 Central 08031
145 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Douglas County Colorado 08 035 Central 08035
146 20780   233 Edwards, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Eagle County Colorado 08 037 Central 08037
147 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Elbert County Colorado 08 039 Outlying 08039
148 17820     Colorado Springs, CO Metropolitan Statistical Area     El Paso County Colorado 08 041 Central 08041
149 15860   444 Cañon City, CO Micropolitan Statistical Area   Pueblo-Cañon City, CO Fremont County Colorado 08 043 Central 08043
150 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Garfield County Colorado 08 045 Central 08045
151 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Gilpin County Colorado 08 047 Outlying 08047
152 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Jefferson County Colorado 08 059 Central 08059
153 20420     Durango, CO Micropolitan Statistical Area     La Plata County Colorado 08 067 Central 08067
154 22660     Fort Collins, CO Metropolitan Statistical Area     Larimer County Colorado 08 069 Central 08069
155 44540     Sterling, CO Micropolitan Statistical Area     Logan County Colorado 08 075 Central 08075
156 24300     Grand Junction, CO Metropolitan Statistical Area     Mesa County Colorado 08 077 Central 08077
157 18780   525 Craig, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Moffat County Colorado 08 081 Central 08081
158 33940     Montrose, CO Micropolitan Statistical Area     Montrose County Colorado 08 085 Central 08085
159 22820     Fort Morgan, CO Micropolitan Statistical Area     Morgan County Colorado 08 087 Central 08087
160 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Park County Colorado 08 093 Outlying 08093
161 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Pitkin County Colorado 08 097 Outlying 08097
162 39380   444 Pueblo, CO Metropolitan Statistical Area   Pueblo-Cañon City, CO Pueblo County Colorado 08 101 Central 08101
163 44460   525 Steamboat Springs, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Routt County Colorado 08 107 Central 08107
164 14720     Breckenridge, CO Micropolitan Statistical Area     Summit County Colorado 08 117 Central 08117
165 17820     Colorado Springs, CO Metropolitan Statistical Area     Teller County Colorado 08 119 Outlying 08119
166 24540   216 Greeley, CO Metropolitan Statistical Area   Denver-Aurora, CO Weld County Colorado 08 123 Central 08123
167 14860   408 Bridgeport-Stamford-Norwalk, CT Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Fairfield County Connecticut 09 001 Central 09001
168 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Hartford County Connecticut 09 003 Central 09003
169 45860   408 Torrington, CT Micropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Litchfield County Connecticut 09 005 Central 09005
170 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Middlesex County Connecticut 09 007 Central 09007
171 35300   408 New Haven-Milford, CT Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA New Haven County Connecticut 09 009 Central 09009
172 35980   278 Norwich-New London, CT Metropolitan Statistical Area   Hartford-West Hartford, CT New London County Connecticut 09 011 Central 09011
173 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Tolland County Connecticut 09 013 Central 09013
174 49340   148 Worcester, MA-CT Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Windham County Connecticut 09 015 Central 09015
175 20100   428 Dover, DE Metropolitan Statistical Area   Philadelphia-Reading-Camden, PA-NJ-DE-MD Kent County Delaware 10 001 Central 10001
176 37980 48864 428 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metropolitan Statistical Area Wilmington, DE-MD-NJ Philadelphia-Reading-Camden, PA-NJ-DE-MD New Castle County Delaware 10 003 Central 10003
177 41540     Salisbury, MD-DE Metropolitan Statistical Area     Sussex County Delaware 10 005 Central 10005
178 47900 47894 548 Washington-Arlington-Alexandria, DC-VA-MD-WV Metropolitan Statistical Area Washington-Arlington-Alexandria, DC-VA-MD-WV Washington-Baltimore-Arlington, DC-MD-VA-WV-PA District of Columbia District of Columbia 11 001 Central 11001
179 23540   264 Gainesville, FL Metropolitan Statistical Area   Gainesville-Lake City, FL Alachua County Florida 12 001 Central 12001
180 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Baker County Florida 12 003 Outlying 12003
181 37460     Panama City, FL Metropolitan Statistical Area     Bay County Florida 12 005 Central 12005
182 37340     Palm Bay-Melbourne-Titusville, FL Metropolitan Statistical Area     Brevard County Florida 12 009 Central 12009
183 33100 22744 370 Miami-Fort Lauderdale-West Palm Beach, FL Metropolitan Statistical Area Fort Lauderdale-Pompano Beach-Deerfield Beach, FL Miami-Fort Lauderdale-Port St. Lucie, FL Broward County Florida 12 011 Central 12011
184 39460   412 Punta Gorda, FL Metropolitan Statistical Area   North Port-Sarasota, FL Charlotte County Florida 12 015 Central 12015
185 26140     Homosassa Springs, FL Metropolitan Statistical Area     Citrus County Florida 12 017 Central 12017
186 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Clay County Florida 12 019 Central 12019
187 34940   162 Naples-Immokalee-Marco Island, FL Metropolitan Statistical Area   Cape Coral-Fort Myers-Naples, FL Collier County Florida 12 021 Central 12021
188 29380   264 Lake City, FL Micropolitan Statistical Area   Gainesville-Lake City, FL Columbia County Florida 12 023 Central 12023
189 11580   412 Arcadia, FL Micropolitan Statistical Area   North Port-Sarasota, FL DeSoto County Florida 12 027 Central 12027
190 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Duval County Florida 12 031 Central 12031
191 37860     Pensacola-Ferry Pass-Brent, FL Metropolitan Statistical Area     Escambia County Florida 12 033 Central 12033
192 19660   422 Deltona-Daytona Beach-Ormond Beach, FL Metropolitan Statistical Area   Orlando-Deltona-Daytona Beach, FL Flagler County Florida 12 035 Central 12035
193 45220   533 Tallahassee, FL Metropolitan Statistical Area   Tallahassee-Bainbridge, FL-GA Gadsden County Florida 12 039 Outlying 12039
194 23540   264 Gainesville, FL Metropolitan Statistical Area   Gainesville-Lake City, FL Gilchrist County Florida 12 041 Outlying 12041
195 37460     Panama City, FL Metropolitan Statistical Area     Gulf County Florida 12 045 Outlying 12045
196 48100     Wauchula, FL Micropolitan Statistical Area     Hardee County Florida 12 049 Central 12049
197 17500     Clewiston, FL Micropolitan Statistical Area     Hendry County Florida 12 051 Central 12051
198 45300     Tampa-St. Petersburg-Clearwater, FL Metropolitan Statistical Area     Hernando County Florida 12 053 Outlying 12053
199 42700     Sebring, FL Metropolitan Statistical Area     Highlands County Florida 12 055 Central 12055
200 45300     Tampa-St. Petersburg-Clearwater, FL Metropolitan Statistical Area     Hillsborough County Florida 12 057 Central 12057

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 5.62ms · Data source: U.S. Department of Health & Human Services