Minnesota county FIPS codes
Every Minnesota county FIPS code with name, type, area, centre point and ZIP count, as CSV, Excel or JSON. Updated 19 November 2026.
Minnesota counties and FIPS codes
Minnesota has state FIPS code 27, and this list has 87 counties and county equivalents: 87 counties. Each full FIPS code joins the state code and a three-digit county code, so Aitkin County is 27001: 27 for Minnesota and 001 for the county.
By area the largest is Saint Louis at about 17,352 km² (6,700 sq mi) and the smallest is Ramsey at about 426 km² (164 sq mi); the counties add up to about 218,128 km². Hennepin has the most ZIP codes assigned to it (104).
All 87 counties
| FIPS | Name | Type | Area km² | Latitude | Longitude | ZIP codes |
|---|---|---|---|---|---|---|
| 27001 | Aitkin County | County | 5,168 | 46.606457 | -93.420563 | 8 |
| 27003 | Anoka County | County | 1,156 | 45.269115 | -93.22662 | 12 |
| 27005 | Becker County | County | 3,742 | 46.9332 | -95.674017 | 13 |
| 27007 | Beltrami County | County | 7,911 | 47.956113 | -94.818689 | 14 |
| 27009 | Benton County | County | 1,067 | 45.692027 | -93.998564 | 5 |
| 27011 | Big Stone County | County | 1,355 | 45.442685 | -96.388035 | 7 |
| 27013 | Blue Earth County | County | 2,002 | 44.00531 | -94.067167 | 12 |
| 27015 | Brown County | County | 1,615 | 44.265226 | -94.696631 | 7 |
| 27017 | Carlton County | County | 2,268 | 46.593534 | -92.677005 | 11 |
| 27019 | Carver County | County | 937 | 44.825816 | -93.85723 | 22 |
| 27021 | Cass County | County | 6,249 | 47.11084 | -94.324823 | 12 |
| 27023 | Chippewa County | County | 1,553 | 45.017558 | -95.537847 | 5 |
| 27025 | Chisago County | County | 1,101 | 45.439304 | -92.885408 | 12 |
| 27027 | Clay County | County | 2,736 | 46.890966 | -96.491738 | 14 |
| 27029 | Clearwater County | County | 2,669 | 47.577467 | -95.36778 | 5 |
| 27031 | Cook County | County | 4,065 | 47.892276 | -90.586031 | 6 |
| 27033 | Cottonwood County | County | 1,680 | 43.997368 | -95.201419 | 6 |
| 27035 | Crow Wing County | County | 2,996 | 46.48005 | -94.070779 | 15 |
| 27037 | Dakota County | County | 1,566 | 44.662299 | -93.067604 | 20 |
| 27039 | Dodge County | County | 1,140 | 44.022581 | -92.862153 | 6 |
| 27041 | Douglas County | County | 1,867 | 45.933423 | -95.453384 | 10 |
| 27043 | Faribault County | County | 1,866 | 43.674182 | -93.948082 | 11 |
| 27045 | Fillmore County | County | 2,231 | 43.673936 | -92.09007 | 12 |
| 27047 | Freeborn County | County | 1,866 | 43.674379 | -93.348873 | 12 |
| 27049 | Goodhue County | County | 2,046 | 44.379387 | -92.726849 | 10 |
| 27051 | Grant County | County | 1,490 | 45.933931 | -96.012048 | 7 |
| 27053 | Hennepin County | County | 1,539 | 45.053646 | -93.485087 | 104 |
| 27055 | Houston County | County | 1,481 | 43.673897 | -91.491615 | 7 |
| 27057 | Hubbard County | County | 2,590 | 47.108159 | -94.916965 | 6 |
| 27059 | Isanti County | County | 1,170 | 45.572248 | -93.308455 | 6 |
| 27061 | Itasca County | County | 7,585 | 47.501088 | -93.483245 | 25 |
| 27063 | Jackson County | County | 1,864 | 43.673985 | -95.153998 | 5 |
| 27065 | Kanabec County | County | 1,382 | 45.945027 | -93.288864 | 2 |
| 27067 | Kandiyohi County | County | 2,232 | 45.152123 | -95.001367 | 11 |
| 27069 | Kittson County | County | 2,792 | 48.76801 | -96.779872 | 10 |
| 27071 | Koochiching County | County | 8,181 | 48.207774 | -93.748084 | 11 |
| 27073 | Lac qui Parle County | County | 2,021 | 45.005806 | -96.183313 | 5 |
| 27075 | Lake County | County | 5,843 | 47.652825 | -91.414689 | 6 |
| 27077 | Lake of the Woods County | County | 4,530 | 48.610135 | -94.869798 | 4 |
| 27079 | Le Sueur County | County | 1,262 | 44.383851 | -93.731347 | 9 |
| 27081 | Lincoln County | County | 1,426 | 44.414015 | -96.267773 | 5 |
| 27083 | Lyon County | County | 1,869 | 44.413453 | -95.83897 | 10 |
| 27085 | McLeod County | County | 1,311 | 44.844108 | -94.291933 | 8 |
| 27087 | Mahnomen County | County | 1,511 | 47.324619 | -95.809137 | 4 |
| 27089 | Marshall County | County | 4,675 | 48.359425 | -96.364754 | 11 |
| 27091 | Martin County | County | 1,889 | 43.674129 | -94.551295 | 10 |
| 27093 | Meeker County | County | 1,670 | 45.149703 | -94.544244 | 7 |
| 27095 | Mille Lacs County | County | 1,767 | 45.935048 | -93.645573 | 8 |
| 27097 | Morrison County | County | 2,983 | 45.989783 | -94.267951 | 14 |
| 27099 | Mower County | County | 1,839 | 43.674566 | -92.756433 | 14 |
| 27101 | Murray County | County | 1,864 | 44.021996 | -95.763196 | 8 |
| 27103 | Nicollet County | County | 1,176 | 44.331083 | -94.172978 | 5 |
| 27105 | Nobles County | County | 1,870 | 43.67409 | -95.75339 | 11 |
| 27107 | Norman County | County | 2,286 | 47.325242 | -96.457917 | 9 |
| 27109 | Olmsted County | County | 1,696 | 43.99671 | -92.418043 | 11 |
| 27111 | Otter Tail County | County | 5,759 | 46.411579 | -95.708618 | 20 |
| 27113 | Pennington County | County | 1,600 | 48.067665 | -96.036769 | 3 |
| 27115 | Pine County | County | 3,654 | 46.154977 | -92.777804 | 13 |
| 27117 | Pipestone County | County | 1,207 | 44.023156 | -96.258791 | 7 |
| 27119 | Polk County | County | 5,157 | 47.908275 | -96.739844 | 16 |
| 27121 | Pope County | County | 1,857 | 45.585399 | -95.444598 | 6 |
| 27123 | Ramsey County | County | 426 | 45.035837 | -93.095867 | 32 |
| 27125 | Red Lake County | County | 1,121 | 47.861627 | -96.095269 | 4 |
| 27127 | Redwood County | County | 2,284 | 44.388481 | -95.261168 | 14 |
| 27129 | Renville County | County | 2,558 | 44.704962 | -94.908707 | 10 |
| 27131 | Rice County | County | 1,336 | 44.334242 | -93.280481 | 8 |
| 27133 | Rock County | County | 1,252 | 43.674538 | -96.253399 | 8 |
| 27135 | Roseau County | County | 4,286 | 48.766341 | -95.809889 | 9 |
| 27137 | Saint Louis County | County | 17,352 | 47.598664 | -92.418786 | 53 |
| 27139 | Scott County | County | 1,019 | 44.677267 | -93.50847 | 7 |
| 27141 | Sherburne County | County | 1,166 | 45.428543 | -93.736513 | 6 |
| 27143 | Sibley County | County | 1,503 | 44.590125 | -94.119738 | 7 |
| 27145 | Stearns County | County | 3,604 | 45.550152 | -94.568676 | 34 |
| 27147 | Steele County | County | 1,119 | 44.022418 | -93.226113 | 5 |
| 27149 | Stevens County | County | 1,490 | 45.585772 | -96.000235 | 5 |
| 27151 | Swift County | County | 1,942 | 45.281735 | -95.680855 | 7 |
| 27153 | Todd County | County | 2,534 | 46.071439 | -94.898412 | 10 |
| 27155 | Traverse County | County | 1,544 | 45.74965 | -96.451842 | 4 |
| 27157 | Wabasha County | County | 1,461 | 44.302213 | -92.200264 | 9 |
| 27159 | Wadena County | County | 1,408 | 46.586871 | -94.969287 | 5 |
| 27161 | Waseca County | County | 1,121 | 44.022029 | -93.587225 | 4 |
| 27163 | Washington County | County | 1,064 | 45.039267 | -92.889324 | 18 |
| 27165 | Watonwan County | County | 1,141 | 43.978293 | -94.614206 | 7 |
| 27167 | Wilkin County | County | 1,940 | 46.369237 | -96.445824 | 7 |
| 27169 | Winona County | County | 1,756 | 44.020014 | -91.887592 | 10 |
| 27171 | Wright County | County | 1,853 | 45.18017 | -93.962572 | 17 |
| 27173 | Yellow Medicine County | County | 1,968 | 44.769244 | -95.698069 | 7 |
No row matches. Clear the filter to see all.
File: minnesota-county-fips-codes.csv
Using FIPS codes
FIPS codes are the join key for most US county data, from Census population tables to election results and BLS unemployment files. Store them as five-character text even though Minnesota's codes start with 2: codes in states such as Alabama (01) and California (06) start with 0, and a number column drops that zero as soon as you combine states.
-- add county names to any table that has a 5-digit fips column
SELECT d.*, c.name AS county_name
FROM my_data d
LEFT JOIN county_fips c ON c.fips = d.fips
WHERE c.state = 'MN';In Excel, build the 5-digit code from two parts with =TEXT(A2,"00")&TEXT(B2,"000"), where A2 is the state code (27) and B2 the county code.
Where the data comes from
Names, types, areas and centre points come from Natural Earth's 1:10m admin-2 counties (version 5.1.1, public domain). We checked every FIPS code against the GeoNames admin-2 list: 87 of 87 match. ZIP counts come from the GeoNames postal code file on the Minnesota ZIP code page.
Data dictionary
| Column | Type | Meaning |
|---|---|---|
| fips | text | Five-digit county FIPS code |
| state_fips | text | Two-digit state FIPS code |
| county_fips | text | Three-digit county code within the state |
| name | text | Short name |
| full_name | text | Name with its type, e.g. 'Kent County' |
| type | text | County, Parish, Borough, City, Census Area, Planning Region… |
| state | text | Two-letter state code |
| state_name | text | State name |
| area_sq_km | number | Area in km² (Natural Earth; rounded) |
| latitude | number | Centre point latitude (Natural Earth) |
| longitude | number | Centre point longitude (Natural Earth) |
| zip_codes | number | ZIP codes assigned to it in the GeoNames postal list |
| wikidata_id | text | Wikidata item, for linking to other data |