Skip to content

Instantly share code, notes, and snippets.

@aodin

aodin/us_metro_with_state_fips.csv

Created September 28, 2023 23:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aodin/5583cd21d7e07f6c7c9dbd4bd0b26e64 to your computer and use it in GitHub Desktop.
Save aodin/5583cd21d7e07f6c7c9dbd4bd0b26e64 to your computer and use it in GitHub Desktop.
Download ZIP
US Metro Areas with CBSA and State FIPS codes
Raw
us_metro_with_state_fips.csv
CBSA Metro State Postal State FIPS
10180 Abilene, TX Texas TX 48
10380 Aguadilla, PR Puerto Rico PR 72
10420 Akron, OH Ohio OH 39
10500 Albany, GA Georgia GA 13
10540 Albany, OR Oregon OR 41
10580 Albany-Schenectady-Troy, NY New York NY 36
10740 Albuquerque, NM New Mexico NM 35
10780 Alexandria, LA Louisiana LA 22
10900 Allentown-Bethlehem-Easton, PA-NJ Pennsylvania PA 42
11020 Altoona, PA Pennsylvania PA 42
11100 Amarillo, TX Texas TX 48
11180 Ames, IA Iowa IA 19
11260 Anchorage, AK Alaska AK 02
11460 Ann Arbor, MI Michigan MI 26
11500 Anniston-Oxford, AL Alabama AL 01
11540 Appleton, WI Wisconsin WI 55
11640 Arecibo, PR Puerto Rico PR 72
11700 Asheville, NC North Carolina NC 37
12020 Athens-Clarke County, GA Georgia GA 13
12060 Atlanta-Sandy Springs-Roswell, GA Georgia GA 13
12100 Atlantic City-Hammonton, NJ New Jersey NJ 34
12220 Auburn-Opelika, AL Alabama AL 01
12260 Augusta-Richmond County, GA-SC Georgia GA 13
12420 Austin-Round Rock-San Marcos, TX Texas TX 48
12540 Bakersfield-Delano, CA California CA 06
12580 Baltimore-Columbia-Towson, MD Maryland MD 24
12940 Baton Rouge, LA Louisiana LA 22
12980 Battle Creek, MI Michigan MI 26
13020 Bay City, MI Michigan MI 26
13140 Beaumont-Port Arthur, TX Texas TX 48
13220 Beckley, WV West Virginia WV 54
13380 Bellingham, WA Washington WA 53
13460 Bend, OR Oregon OR 41
13740 Billings, MT Montana MT 30
13780 Binghamton, NY New York NY 36
13820 Birmingham, AL Alabama AL 01
13900 Bismarck, ND North Dakota ND 38
13980 Blacksburg-Christiansburg-Radford, VA Virginia VA 51
14010 Bloomington, IL Illinois IL 17
14020 Bloomington, IN Indiana IN 18
14260 Boise City, ID Idaho ID 16
14500 Boulder, CO Colorado CO 08
14540 Bowling Green, KY Kentucky KY 21
14740 Bremerton-Silverdale-Port Orchard, WA Washington WA 53
15180 Brownsville-Harlingen, TX Texas TX 48
15260 Brunswick-St. Simons, GA Georgia GA 13
15380 Buffalo-Cheektowaga, NY New York NY 36
15500 Burlington, NC North Carolina NC 37
15940 Canton-Massillon, OH Ohio OH 39
15980 Cape Coral-Fort Myers, FL Florida FL 12
16020 Cape Girardeau, MO-IL Missouri MO 29
16180 Carson City, NV Nevada NV 32
16220 Casper, WY Wyoming WY 56
16300 Cedar Rapids, IA Iowa IA 19
16540 Chambersburg, PA Pennsylvania PA 42
16580 Champaign-Urbana, IL Illinois IL 17
16620 Charleston, WV West Virginia WV 54
16700 Charleston-North Charleston, SC South Carolina SC 45
16740 Charlotte-Concord-Gastonia, NC-SC North Carolina NC 37
16820 Charlottesville, VA Virginia VA 51
16860 Chattanooga, TN-GA Tennessee TN 47
16940 Cheyenne, WY Wyoming WY 56
16980 Chicago-Naperville-Elgin, IL-IN Illinois IL 17
17020 Chico, CA California CA 06
17140 Cincinnati, OH-KY-IN Ohio OH 39
17300 Clarksville, TN-KY Tennessee TN 47
17420 Cleveland, TN Tennessee TN 47
17660 Coeur d'Alene, ID Idaho ID 16
17780 College Station-Bryan, TX Texas TX 48
17820 Colorado Springs, CO Colorado CO 08
17860 Columbia, MO Missouri MO 29
17900 Columbia, SC South Carolina SC 45
17980 Columbus, GA-AL Georgia GA 13
18020 Columbus, IN Indiana IN 18
18140 Columbus, OH Ohio OH 39
18580 Corpus Christi, TX Texas TX 48
18700 Corvallis, OR Oregon OR 41
18880 Crestview-Fort Walton Beach-Destin, FL Florida FL 12
19100 Dallas-Fort Worth-Arlington, TX Texas TX 48
19140 Dalton, GA Georgia GA 13
19300 Daphne-Fairhope-Foley, AL Alabama AL 01
19340 Davenport-Moline-Rock Island, IA-IL Illinois IL 17
19460 Decatur, AL Alabama AL 01
19500 Decatur, IL Illinois IL 17
19660 Deltona-Daytona Beach-Ormond Beach, FL Florida FL 12
19740 Denver-Aurora-Centennial, CO Colorado CO 08
19780 Des Moines-West Des Moines, IA Iowa IA 19
19820 Detroit-Warren-Dearborn, MI Michigan MI 26
20020 Dothan, AL Alabama AL 01
20100 Dover, DE Delaware DE 10
20220 Dubuque, IA Iowa IA 19
20260 Duluth, MN-WI Minnesota MN 27
20500 Durham-Chapel Hill, NC North Carolina NC 37
20740 Eau Claire, WI Wisconsin WI 55
20940 El Centro, CA California CA 06
21060 Elizabethtown, KY Kentucky KY 21
21140 Elkhart-Goshen, IN Indiana IN 18
21300 Elmira, NY New York NY 36
21340 El Paso, TX Texas TX 48
21420 Enid, OK Oklahoma OK 40
21500 Erie, PA Pennsylvania PA 42
21660 Eugene-Springfield, OR Oregon OR 41
21780 Evansville, IN Indiana IN 18
21820 Fairbanks-College, AK Alaska AK 02
22020 Fargo, ND-MN North Dakota ND 38
22140 Farmington, NM New Mexico NM 35
22180 Fayetteville, NC North Carolina NC 37
22220 Fayetteville-Springdale-Rogers, AR Arkansas AR 05
22380 Flagstaff, AZ Arizona AZ 04
22420 Flint, MI Michigan MI 26
22500 Florence, SC South Carolina SC 45
22520 Florence-Muscle Shoals, AL Alabama AL 01
22540 Fond du Lac, WI Wisconsin WI 55
22660 Fort Collins-Loveland, CO Colorado CO 08
22900 Fort Smith, AR-OK Arkansas AR 05
23060 Fort Wayne, IN Indiana IN 18
23420 Fresno, CA California CA 06
23460 Gadsden, AL Alabama AL 01
23540 Gainesville, FL Florida FL 12
23580 Gainesville, GA Georgia GA 13
23900 Gettysburg, PA Pennsylvania PA 42
24020 Glens Falls, NY New York NY 36
24140 Goldsboro, NC North Carolina NC 37
24220 Grand Forks, ND-MN North Dakota ND 38
24260 Grand Island, NE Nebraska NE 31
24300 Grand Junction, CO Colorado CO 08
24340 Grand Rapids-Wyoming-Kentwood, MI Michigan MI 26
24420 Grants Pass, OR Oregon OR 41
24500 Great Falls, MT Montana MT 30
24540 Greeley, CO Colorado CO 08
24580 Green Bay, WI Wisconsin WI 55
24660 Greensboro-High Point, NC North Carolina NC 37
24780 Greenville, NC North Carolina NC 37
24860 Greenville-Anderson-Greer, SC South Carolina SC 45
25020 Guayama, PR Puerto Rico PR 72
25060 Gulfport-Biloxi, MS Mississippi MS 28
25180 Hagerstown-Martinsburg, MD-WV Maryland MD 24
25220 Hammond, LA Louisiana LA 22
25260 Hanford-Corcoran, CA California CA 06
25420 Harrisburg-Carlisle, PA Pennsylvania PA 42
25500 Harrisonburg, VA Virginia VA 51
25620 Hattiesburg, MS Mississippi MS 28
25860 Hickory-Lenoir-Morganton, NC North Carolina NC 37
25940 Hilton Head Island-Bluffton-Port Royal, SC South Carolina SC 45
25980 Hinesville, GA Georgia GA 13
26140 Homosassa Springs, FL Florida FL 12
26300 Hot Springs, AR Arkansas AR 05
26380 Houma-Bayou Cane-Thibodaux, LA Louisiana LA 22
26420 Houston-Pasadena-The Woodlands, TX Texas TX 48
26580 Huntington-Ashland, WV-KY-OH West Virginia WV 54
26620 Huntsville, AL Alabama AL 01
26820 Idaho Falls, ID Idaho ID 16
26900 Indianapolis-Carmel-Greenwood, IN Indiana IN 18
26980 Iowa City, IA Iowa IA 19
27060 Ithaca, NY New York NY 36
27100 Jackson, MI Michigan MI 26
27140 Jackson, MS Mississippi MS 28
27180 Jackson, TN Tennessee TN 47
27260 Jacksonville, FL Florida FL 12
27340 Jacksonville, NC North Carolina NC 37
27500 Janesville-Beloit, WI Wisconsin WI 55
27620 Jefferson City, MO Missouri MO 29
27740 Johnson City, TN Tennessee TN 47
27780 Johnstown, PA Pennsylvania PA 42
27860 Jonesboro, AR Arkansas AR 05
27900 Joplin, MO-KS Missouri MO 29
27980 Kahului-Wailuku, HI Hawaii HI 15
28020 Kalamazoo-Portage, MI Michigan MI 26
28100 Kankakee, IL Illinois IL 17
28140 Kansas City, MO-KS Missouri MO 29
28420 Kennewick-Richland, WA Washington WA 53
28660 Killeen-Temple, TX Texas TX 48
28700 Kingsport-Bristol, TN-VA Tennessee TN 47
28740 Kingston, NY New York NY 36
28940 Knoxville, TN Tennessee TN 47
29020 Kokomo, IN Indiana IN 18
29100 La Crosse-Onalaska, WI-MN Wisconsin WI 55
29180 Lafayette, LA Louisiana LA 22
29200 Lafayette-West Lafayette, IN Indiana IN 18
29340 Lake Charles, LA Louisiana LA 22
29420 Lake Havasu City-Kingman, AZ Arizona AZ 04
29460 Lakeland-Winter Haven, FL Florida FL 12
29540 Lancaster, PA Pennsylvania PA 42
29620 Lansing-East Lansing, MI Michigan MI 26
29700 Laredo, TX Texas TX 48
29740 Las Cruces, NM New Mexico NM 35
29820 Las Vegas-Henderson-North Las Vegas, NV Nevada NV 32
29940 Lawrence, KS Kansas KS 20
30020 Lawton, OK Oklahoma OK 40
30140 Lebanon, PA Pennsylvania PA 42
30300 Lewiston, ID-WA Idaho ID 16
30460 Lexington-Fayette, KY Kentucky KY 21
30620 Lima, OH Ohio OH 39
30700 Lincoln, NE Nebraska NE 31
30780 Little Rock-North Little Rock-Conway, AR Arkansas AR 05
30860 Logan, UT-ID Utah UT 49
30980 Longview, TX Texas TX 48
31020 Longview-Kelso, WA Washington WA 53
31080 Los Angeles-Long Beach-Anaheim, CA California CA 06
31140 Louisville/Jefferson County, KY-IN Kentucky KY 21
31180 Lubbock, TX Texas TX 48
31340 Lynchburg, VA Virginia VA 51
31420 Macon-Bibb County, GA Georgia GA 13
31540 Madison, WI Wisconsin WI 55
31740 Manhattan, KS Kansas KS 20
31860 Mankato, MN Minnesota MN 27
31900 Mansfield, OH Ohio OH 39
32420 Mayagüez, PR Puerto Rico PR 72
32580 McAllen-Edinburg-Mission, TX Texas TX 48
32780 Medford, OR Oregon OR 41
32820 Memphis, TN-MS-AR Tennessee TN 47
32900 Merced, CA California CA 06
33100 Miami-Fort Lauderdale-West Palm Beach, FL Florida FL 12
33140 Michigan City-La Porte, IN Indiana IN 18
33220 Midland, MI Michigan MI 26
33260 Midland, TX Texas TX 48
33340 Milwaukee-Waukesha, WI Wisconsin WI 55
33460 Minneapolis-St. Paul-Bloomington, MN-WI Minnesota MN 27
33540 Missoula, MT Montana MT 30
33660 Mobile, AL Alabama AL 01
33700 Modesto, CA California CA 06
33740 Monroe, LA Louisiana LA 22
33780 Monroe, MI Michigan MI 26
33860 Montgomery, AL Alabama AL 01
34060 Morgantown, WV West Virginia WV 54
34100 Morristown, TN Tennessee TN 47
34580 Mount Vernon-Anacortes, WA Washington WA 53
34620 Muncie, IN Indiana IN 18
34740 Muskegon-Norton Shores, MI Michigan MI 26
34820 Myrtle Beach-Conway-North Myrtle Beach, SC South Carolina SC 45
34900 Napa, CA California CA 06
34940 Naples-Marco Island, FL Florida FL 12
34980 Nashville-Davidson--Murfreesboro--Franklin, TN Tennessee TN 47
35380 New Orleans-Metairie, LA Louisiana LA 22
35620 New York-Newark-Jersey City, NY-NJ New York NY 36
35660 Niles, MI Michigan MI 26
35840 North Port-Bradenton-Sarasota, FL Florida FL 12
36100 Ocala, FL Florida FL 12
36220 Odessa, TX Texas TX 48
36260 Ogden, UT Utah UT 49
36420 Oklahoma City, OK Oklahoma OK 40
36500 Olympia-Lacey-Tumwater, WA Washington WA 53
36540 Omaha, NE-IA Nebraska NE 31
36740 Orlando-Kissimmee-Sanford, FL Florida FL 12
36780 Oshkosh-Neenah, WI Wisconsin WI 55
36980 Owensboro, KY Kentucky KY 21
37100 Oxnard-Thousand Oaks-Ventura, CA California CA 06
37340 Palm Bay-Melbourne-Titusville, FL Florida FL 12
37460 Panama City-Panama City Beach, FL Florida FL 12
37620 Parkersburg-Vienna, WV West Virginia WV 54
37860 Pensacola-Ferry Pass-Brent, FL Florida FL 12
37900 Peoria, IL Illinois IL 17
37980 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Pennsylvania PA 42
38060 Phoenix-Mesa-Chandler, AZ Arizona AZ 04
38300 Pittsburgh, PA Pennsylvania PA 42
38540 Pocatello, ID Idaho ID 16
38660 Ponce, PR Puerto Rico PR 72
38900 Portland-Vancouver-Hillsboro, OR-WA Oregon OR 41
38940 Port St. Lucie, FL Florida FL 12
39340 Provo-Orem-Lehi, UT Utah UT 49
39380 Pueblo, CO Colorado CO 08
39460 Punta Gorda, FL Florida FL 12
39540 Racine-Mount Pleasant, WI Wisconsin WI 55
39580 Raleigh-Cary, NC North Carolina NC 37
39660 Rapid City, SD South Dakota SD 46
39740 Reading, PA Pennsylvania PA 42
39820 Redding, CA California CA 06
39900 Reno, NV Nevada NV 32
40060 Richmond, VA Virginia VA 51
40140 Riverside-San Bernardino-Ontario, CA California CA 06
40220 Roanoke, VA Virginia VA 51
40340 Rochester, MN Minnesota MN 27
40380 Rochester, NY New York NY 36
40420 Rockford, IL Illinois IL 17
40580 Rocky Mount, NC North Carolina NC 37
40660 Rome, GA Georgia GA 13
40900 Sacramento-Roseville-Folsom, CA California CA 06
40980 Saginaw, MI Michigan MI 26
41060 St. Cloud, MN Minnesota MN 27
41100 St. George, UT Utah UT 49
41140 St. Joseph, MO-KS Missouri MO 29
41180 St. Louis, MO-IL Missouri MO 29
41420 Salem, OR Oregon OR 41
41500 Salinas, CA California CA 06
41620 Salt Lake City-Murray, UT Utah UT 49
41660 San Angelo, TX Texas TX 48
41700 San Antonio-New Braunfels, TX Texas TX 48
41740 San Diego-Chula Vista-Carlsbad, CA California CA 06
41860 San Francisco-Oakland-Fremont, CA California CA 06
41940 San Jose-Sunnyvale-Santa Clara, CA California CA 06
41980 San Juan-Bayamón-Caguas, PR Puerto Rico PR 72
42020 San Luis Obispo-Paso Robles, CA California CA 06
42100 Santa Cruz-Watsonville, CA California CA 06
42140 Santa Fe, NM New Mexico NM 35
42200 Santa Maria-Santa Barbara, CA California CA 06
42220 Santa Rosa-Petaluma, CA California CA 06
42340 Savannah, GA Georgia GA 13
42540 Scranton--Wilkes-Barre, PA Pennsylvania PA 42
42660 Seattle-Tacoma-Bellevue, WA Washington WA 53
42680 Sebastian-Vero Beach-West Vero Corridor, FL Florida FL 12
42700 Sebring, FL Florida FL 12
43100 Sheboygan, WI Wisconsin WI 55
43300 Sherman-Denison, TX Texas TX 48
43340 Shreveport-Bossier City, LA Louisiana LA 22
43420 Sierra Vista-Douglas, AZ Arizona AZ 04
43580 Sioux City, IA-NE-SD Iowa IA 19
43620 Sioux Falls, SD-MN South Dakota SD 46
43780 South Bend-Mishawaka, IN-MI Indiana IN 18
43900 Spartanburg, SC South Carolina SC 45
44060 Spokane-Spokane Valley, WA Washington WA 53
44100 Springfield, IL Illinois IL 17
44180 Springfield, MO Missouri MO 29
44220 Springfield, OH Ohio OH 39
44300 State College, PA Pennsylvania PA 42
44420 Staunton-Stuarts Draft, VA Virginia VA 51
44700 Stockton-Lodi, CA California CA 06
44940 Sumter, SC South Carolina SC 45
45060 Syracuse, NY New York NY 36
45220 Tallahassee, FL Florida FL 12
45300 Tampa-St. Petersburg-Clearwater, FL Florida FL 12
45460 Terre Haute, IN Indiana IN 18
45500 Texarkana, TX-AR Texas TX 48
45780 Toledo, OH Ohio OH 39
45820 Topeka, KS Kansas KS 20
45940 Trenton-Princeton, NJ New Jersey NJ 34
46060 Tucson, AZ Arizona AZ 04
46140 Tulsa, OK Oklahoma OK 40
46220 Tuscaloosa, AL Alabama AL 01
46300 Twin Falls, ID Idaho ID 16
46340 Tyler, TX Texas TX 48
46520 Urban Honolulu, HI Hawaii HI 15
46540 Utica-Rome, NY New York NY 36
46660 Valdosta, GA Georgia GA 13
46700 Vallejo, CA California CA 06
47020 Victoria, TX Texas TX 48
47220 Vineland, NJ New Jersey NJ 34
47260 Virginia Beach-Chesapeake-Norfolk, VA-NC Virginia VA 51
47300 Visalia, CA California CA 06
47380 Waco, TX Texas TX 48
47460 Walla Walla, WA Washington WA 53
47580 Warner Robins, GA Georgia GA 13
47900 Washington-Arlington-Alexandria, DC-VA-MD-WV District of Columbia DC 11
47940 Waterloo-Cedar Falls, IA Iowa IA 19
48060 Watertown-Fort Drum, NY New York NY 36
48140 Wausau, WI Wisconsin WI 55
48260 Weirton-Steubenville, WV-OH Ohio OH 39
48300 Wenatchee-East Wenatchee, WA Washington WA 53
48540 Wheeling, WV-OH West Virginia WV 54
48620 Wichita, KS Kansas KS 20
48660 Wichita Falls, TX Texas TX 48
48700 Williamsport, PA Pennsylvania PA 42
48900 Wilmington, NC North Carolina NC 37
49020 Winchester, VA-WV Virginia VA 51
49180 Winston-Salem, NC North Carolina NC 37
49420 Yakima, WA Washington WA 53
49620 York-Hanover, PA Pennsylvania PA 42
49660 Youngstown-Warren, OH Ohio OH 39
49700 Yuba City, CA California CA 06
49740 Yuma, AZ Arizona AZ 04
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment