cbsa2fips

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

1,882 rows sorted by fipscountycode

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
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
139 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Adams County Colorado 8 1 Central
167 14860   408 Bridgeport-Stamford-Norwalk, CT Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Fairfield County Connecticut 9 1 Central
175 20100   428 Dover, DE Metropolitan Statistical Area   Philadelphia-Reading-Camden, PA-NJ-DE-MD Kent County Delaware 10 1 Central
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 1 Central
179 23540   264 Gainesville, FL Metropolitan Statistical Area   Gainesville-Lake City, FL Alachua County Florida 12 1 Central
332 25900     Hilo, HI Micropolitan Statistical Area     Hawaii County Hawaii 15 1 Central
337 14260   147 Boise City, ID Metropolitan Statistical Area   Boise City-Mountain Home-Ontario, ID-OR Ada County Idaho 16 1 Central
364 39500   448 Quincy, IL-MO Micropolitan Statistical Area   Quincy-Hannibal, IL-MO Adams County Illinois 17 1 Central
428 19540   258 Decatur, IN Micropolitan Statistical Area   Fort Wayne-Huntington-Auburn, IN Adams County Indiana 18 1 Central
633 29180   318 Lafayette, LA Metropolitan Statistical Area   Lafayette-Opelousas-Morgan City, LA Acadia Parish Louisiana 22 1 Outlying
677 30340   438 Lewiston-Auburn, ME Metropolitan Statistical Area   Portland-Lewiston-South Portland, ME Androscoggin County Maine 23 1 Central
683 19060     Cumberland, MD-WV Metropolitan Statistical Area     Allegany County Maryland 24 1 Central
704 12700   148 Barnstable Town, MA Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Barnstable County Massachusetts 25 1 Central
812 35020     Natchez, MS-LA Micropolitan Statistical Area     Adams County Mississippi 28 1 Central
855 28860     Kirksville, MO Micropolitan Statistical Area     Adair County Missouri 29 1 Central
921 25580     Hastings, NE Micropolitan Statistical Area     Adams County Nebraska 31 1 Central
951 21980     Fallon, NV Micropolitan Statistical Area     Churchill County Nevada 32 1 Central
962 29060   148 Laconia, NH Micropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Belknap County New Hampshire 33 1 Central
971 12100   428 Atlantic City-Hammonton, NJ Metropolitan Statistical Area   Philadelphia-Reading-Camden, PA-NJ-DE-MD Atlantic County New Jersey 34 1 Central
992 10740   106 Albuquerque, NM Metropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Bernalillo County New Mexico 35 1 Central
1013 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Albany County New York 36 1 Central
1065 15500   268 Burlington, NC Metropolitan Statistical Area   Greensboro--Winston-Salem--High Point, NC Alamance County North Carolina 37 1 Central
1285 23900   276 Gettysburg, PA Metropolitan Statistical Area   Harrisburg-York-Lebanon, PA Adams County Pennsylvania 42 1 Central
1338 39300   148 Providence-Warwick, RI-MA Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Bristol County Rhode Island 44 1 Central
1343 24940   273 Greenwood, SC Micropolitan Statistical Area   Greenville-Spartanburg-Anderson, SC Abbeville County South Carolina 45 1 Outlying
1398 28940   314 Knoxville, TN Metropolitan Statistical Area   Knoxville-Morristown-Sevierville, TN Anderson County Tennessee 47 1 Central
1460 37300     Palestine, TX Micropolitan Statistical Area     Anderson County Texas 48 1 Central
1701 36830   393 Othello, WA Micropolitan Statistical Area   Moses Lake-Othello, WA Adams County Washington 53 1 Central
1800 29660     Laramie, WY Micropolitan Statistical Area     Albany County Wyoming 56 1 Central
1809 10260   434 Adjuntas, PR Micropolitan Statistical Area   Ponce-Coamo-Santa Isabel, PR Adjuntas Municipio Puerto Rico 72 1 Central
2 19300   380 Daphne-Fairhope-Foley, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Baldwin County Alabama 1 3 Central
45 43420     Sierra Vista-Douglas, AZ Metropolitan Statistical Area     Cochise County Arizona 4 3 Central
168 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Hartford County Connecticut 9 3 Central
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 3 Central
180 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Baker County Florida 12 3 Outlying
333 46520     Urban Honolulu, HI Metropolitan Statistical Area     Honolulu County Hawaii 15 3 Central
365 16020   164 Cape Girardeau, MO-IL Metropolitan Statistical Area   Cape Girardeau-Sikeston, MO-IL Alexander County Illinois 17 3 Outlying
429 23060   258 Fort Wayne, IN Metropolitan Statistical Area   Fort Wayne-Huntington-Auburn, IN Allen County Indiana 18 3 Central
572 14540   150 Bowling Green, KY Metropolitan Statistical Area   Bowling Green-Glasgow, KY Allen County Kentucky 21 3 Outlying
684 12580   548 Baltimore-Columbia-Towson, MD Metropolitan Statistical Area   Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Anne Arundel County Maryland 24 3 Central
705 38340     Pittsfield, MA Metropolitan Statistical Area     Berkshire County Massachusetts 25 3 Central
768 33460   378 Minneapolis-St. Paul-Bloomington, MN-WI Metropolitan Statistical Area   Minneapolis-St. Paul, MN-WI Anoka County Minnesota 27 3 Central
813 18420     Corinth, MS Micropolitan Statistical Area     Alcorn County Mississippi 28 3 Central
856 41140   312 St. Joseph, MO-KS Metropolitan Statistical Area   Kansas City-Overland Park-Kansas City, MO-KS Andrew County Missouri 29 3 Outlying
952 29820   332 Las Vegas-Henderson-Paradise, NV Metropolitan Statistical Area   Las Vegas-Henderson, NV-AZ Clark County Nevada 32 3 Central
972 35620 35614 408 New York-Newark-Jersey City, NY-NJ-PA Metropolitan Statistical Area New York-Jersey City-White Plains, NY-NJ New York-Newark, NY-NJ-CT-PA Bergen County New Jersey 34 3 Central
1066 25860   280 Hickory-Lenoir-Morganton, NC Metropolitan Statistical Area   Hickory-Lenoir, NC Alexander County North Carolina 37 3 Outlying
1152 30620   338 Lima, OH Metropolitan Statistical Area   Lima-Van Wert-Celina, OH Allen County Ohio 39 3 Central
1259 18700   440 Corvallis, OR Metropolitan Statistical Area   Portland-Vancouver-Salem, OR-WA Benton County Oregon 41 3 Central
1286 38300   430 Pittsburgh, PA Metropolitan Statistical Area   Pittsburgh-New Castle-Weirton, PA-OH-WV Allegheny County Pennsylvania 42 3 Central
1339 39300   148 Providence-Warwick, RI-MA Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Kent County Rhode Island 44 3 Central
1344 12260     Augusta-Richmond County, GA-SC Metropolitan Statistical Area     Aiken County South Carolina 45 3 Central
1399 43180   400 Shelbyville, TN Micropolitan Statistical Area   Nashville-Davidson--Murfreesboro, TN Bedford County Tennessee 47 3 Central
1461 11380     Andrews, TX Micropolitan Statistical Area     Andrews County Texas 48 3 Central
1588 36260   482 Ogden-Clearfield, UT Metropolitan Statistical Area   Salt Lake City-Provo-Orem, UT Box Elder County Utah 49 3 Central
1603 13540     Bennington, VT Micropolitan Statistical Area     Bennington County Vermont 50 3 Central
1612 16820     Charlottesville, VA Metropolitan Statistical Area     Albemarle County Virginia 51 3 Central
1702 30300     Lewiston, ID-WA Metropolitan Statistical Area     Asotin County Washington 53 3 Central
1731 25180   548 Hagerstown-Martinsburg, MD-WV Metropolitan Statistical Area   Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Berkeley County West Virginia 54 3 Central
1810 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Aguada Municipio Puerto Rico 72 3 Central
46 22380     Flagstaff, AZ Metropolitan Statistical Area     Coconino County Arizona 4 5 Central
57 34260     Mountain Home, AR Micropolitan Statistical Area     Baxter County Arkansas 5 5 Central
140 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Arapahoe County Colorado 8 5 Central
169 45860   408 Torrington, CT Micropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Litchfield County Connecticut 9 5 Central
177 41540     Salisbury, MD-DE Metropolitan Statistical Area     Sussex County Delaware 10 5 Central
181 37460     Panama City, FL Metropolitan Statistical Area     Bay County Florida 12 5 Central
334 27980     Kahului-Wailuku-Lahaina, HI Metropolitan Statistical Area     Kalawao County Hawaii 15 5 Outlying
338 38540     Pocatello, ID Metropolitan Statistical Area     Bannock County Idaho 16 5 Central
366 41180   476 St. Louis, MO-IL Metropolitan Statistical Area   St. Louis-St. Charles-Farmington, MO-IL Bond County Illinois 17 5 Outlying
430 18020   294 Columbus, IN Metropolitan Statistical Area   Indianapolis-Carmel-Muncie, IN Bartholomew County Indiana 18 5 Central
535 11860   312 Atchison, KS Micropolitan Statistical Area   Kansas City-Overland Park-Kansas City, MO-KS Atchison County Kansas 20 5 Central
573 23180   336 Frankfort, KY Micropolitan Statistical Area   Lexington-Fayette--Richmond--Frankfort, KY Anderson County Kentucky 21 5 Outlying
634 12940     Baton Rouge, LA Metropolitan Statistical Area     Ascension Parish Louisiana 22 5 Central
678 38860   438 Portland-South Portland, ME Metropolitan Statistical Area   Portland-Lewiston-South Portland, ME Cumberland County Maine 23 5 Central
685 12580   548 Baltimore-Columbia-Towson, MD Metropolitan Statistical Area   Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Baltimore County Maryland 24 5 Central
706 39300   148 Providence-Warwick, RI-MA Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Bristol County Massachusetts 25 5 Central
717 26090   266 Holland, MI Micropolitan Statistical Area   Grand Rapids-Wyoming-Muskegon, MI Allegan County Michigan 26 5 Central
814 32620     McComb, MS Micropolitan Statistical Area     Amite County Mississippi 28 5 Outlying
953 23820   456 Gardnerville Ranchos, NV Micropolitan Statistical Area   Reno-Carson City-Fernley, NV Douglas County Nevada 32 5 Central
963 28300     Keene, NH Micropolitan Statistical Area     Cheshire County New Hampshire 33 5 Central
973 37980 15804 428 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metropolitan Statistical Area Camden, NJ Philadelphia-Reading-Camden, PA-NJ-DE-MD Burlington County New Jersey 34 5 Central
993 40740     Roswell, NM Micropolitan Statistical Area     Chaves County New Mexico 35 5 Central
1014 35620 35614 408 New York-Newark-Jersey City, NY-NJ-PA Metropolitan Statistical Area New York-Jersey City-White Plains, NY-NJ New York-Newark, NY-NJ-CT-PA Bronx County New York 36 5 Central
1153 11740   360 Ashland, OH Micropolitan Statistical Area   Mansfield-Ashland-Bucyrus, OH Ashland County Ohio 39 5 Central
1260 38900   440 Portland-Vancouver-Hillsboro, OR-WA Metropolitan Statistical Area   Portland-Vancouver-Salem, OR-WA Clackamas County Oregon 41 5 Central
1287 38300   430 Pittsburgh, PA Metropolitan Statistical Area   Pittsburgh-New Castle-Weirton, PA-OH-WV Armstrong County Pennsylvania 42 5 Outlying
1340 39300   148 Providence-Warwick, RI-MA Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Newport County Rhode Island 44 5 Central
1377 26700     Huron, SD Micropolitan Statistical Area     Beadle County South Dakota 46 5 Central
1462 31260     Lufkin, TX Micropolitan Statistical Area     Angelina County Texas 48 5 Central
1589 30860     Logan, UT-ID Metropolitan Statistical Area     Cache County Utah 49 5 Central
1703 28420     Kennewick-Richland, WA Metropolitan Statistical Area     Benton County Washington 53 5 Central
1732 16620   170 Charleston, WV Metropolitan Statistical Area   Charleston-Huntington-Ashland, WV-OH-KY Boone County West Virginia 54 5 Outlying
1801 23940     Gillette, WY Micropolitan Statistical Area     Campbell County Wyoming 56 5 Central
1811 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Aguadilla Municipio Puerto Rico 72 5 Central
994 24380   106 Grants, NM Micropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Cibola County New Mexico 35 6 Central
3 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Bibb County Alabama 1 7 Outlying
47 37740     Payson, AZ Micropolitan Statistical Area     Gila County Arizona 4 7 Central
58 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Benton County Arkansas 5 7 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 39.983ms · Data source: U.S. Department of Health & Human Services