Table Name |
Field Name |
Definition |
Valid Values |
Description |
county.pat | ||||
COUNTYNAME | 17,17,C | Displays the name of the county. | ||
Aitkin | ||||
Anoka | ||||
Becker | ||||
Beltrami | ||||
Benton | ||||
Big Stone | ||||
Blue Earth | ||||
Brown | ||||
Carlton | ||||
Carver | ||||
Cass | ||||
Chippewa | ||||
Chisago | ||||
Clay | ||||
Clearwater | ||||
Cook | ||||
Cottonwood | ||||
Crow Wing | ||||
Dakota | ||||
Dodge | ||||
Douglas | ||||
Faribault | ||||
Fillmore | ||||
Freeborn | ||||
Goodhue | ||||
Grant | ||||
Hennepin | ||||
Houston | ||||
Hubbard | ||||
Isanti | ||||
Itasca | ||||
Jackson | ||||
Kanabec | ||||
Kandiyohi | ||||
Kittson | ||||
Koochiching | ||||
Lac Qui Parle | ||||
Lake | ||||
Lake of the Woods | ||||
Le Sueur | ||||
Lincoln | ||||
Lyon | ||||
McLeod | ||||
Mahnomen | ||||
Marshall | ||||
Martin | ||||
Meeker | ||||
Mille Lacs | ||||
Morrison | ||||
Mower | ||||
Murray | ||||
Nicollet | ||||
Nobles | ||||
Norman | ||||
Olmsted | ||||
Otter Tail | ||||
Pennington | ||||
Pine | ||||
Pipestone | ||||
Polk | ||||
Pope | ||||
Ramsey | ||||
Red Lake | ||||
Redwood | ||||
Renville | ||||
Rice | ||||
Rock | ||||
Roseau | ||||
Saint Louis | ||||
Scott | ||||
Sherburne | ||||
Sibley | ||||
Stearns | ||||
Steele | ||||
Stevens | ||||
Swift | ||||
Todd | ||||
Traverse | ||||
Wabasha | ||||
Wadena | ||||
Waseca | ||||
Washington | ||||
Watonwan | ||||
Wilkin | ||||
Winona | ||||
Wright | ||||
Yellow Medicine | ||||
COUNTY_NUM | 2,2,I | Displays the alphanumeric, state assigned number of the county. | ||
1 | Aitkin | |||
2 | Anoka | |||
3 | Becker | |||
4 | Beltrami | |||
5 | Benton | |||
6 | Big Stone | |||
7 | Blue Earth | |||
8 | Brown | |||
9 | Carlton | |||
10 | Carver | |||
11 | Cass | |||
12 | Chippewa | |||
13 | Chisago | |||
14 | Clay | |||
15 | Clearwater | |||
16 | Cook | |||
17 | Cottonwood | |||
18 | Crow Wing | |||
19 | Dakota | |||
20 | Dodge | |||
21 | Douglas | |||
22 | Faribault | |||
23 | Fillmore | |||
24 | Freeborn | |||
25 | Goodhue | |||
26 | Grant | |||
27 | Hennepin | |||
28 | Houston | |||
29 | Hubbard | |||
30 | Isanti | |||
31 | Itasca | |||
32 | Jackson | |||
33 | Kanabec | |||
34 | Kandiyohi | |||
35 | Kittson | |||
36 | Koochiching | |||
37 | Lac Qui Parle | |||
38 | Lake | |||
39 | Lake of the Woods | |||
40 | Le Sueur | |||
41 | Lincoln | |||
42 | Lyon | |||
43 | McLeod | |||
44 | Mahnomen | |||
45 | Marshall | |||
46 | Martin | |||
47 | Meeker | |||
48 | Mille Lacs | |||
49 | Morrison | |||
50 | Mower | |||
51 | Murray | |||
52 | Nicollet | |||
53 | Nobles | |||
54 | Norman | |||
55 | Olmsted | |||
56 | Otter Tail | |||
57 | Pennington | |||
58 | Pine | |||
59 | Pipestone | |||
60 | Polk | |||
61 | Pope | |||
62 | Ramsey | |||
63 | Red Lake | |||
64 | Redwood | |||
65 | Renville | |||
66 | Rice | |||
67 | Rock | |||
68 | Roseau | |||
69 | Saint Louis | |||
70 | Scott | |||
71 | Sherburne | |||
72 | Sibley | |||
73 | Stearns | |||
74 | Steele | |||
75 | Stevens | |||
76 | Swift | |||
77 | Todd | |||
78 | Traverse | |||
79 | Wabasha | |||
80 | Wadena | |||
81 | Waseca | |||
82 | Washington | |||
83 | Watonwan | |||
84 | Wilkin | |||
85 | Winona | |||
86 | Wright | |||
87 | Yellow Medicine | |||
COUNTYFIPS | 5,5,C | Displays the FIPS (Federal Information Processing Standard) code of the county. | ||
001 | Aitkin | |||
003 | Anoka | |||
005 | Becker | |||
007 | Beltrami | |||
009 | Benton | |||
011 | Big Stone | |||
013 | Blue Earth | |||
015 | Brown | |||
017 | Carlton | |||
019 | Carver | |||
021 | Cass | |||
023 | Chippewa | |||
025 | Chisago | |||
027 | Clay | |||
029 | Clearwater | |||
031 | Cook | |||
033 | Cottonwood | |||
035 | Crow Wing | |||
037 | Dakota | |||
039 | Dodge | |||
041 | Douglas | |||
043 | Faribault | |||
045 | Fillmore | |||
047 | Freeborn | |||
049 | Goodhue | |||
051 | Grant | |||
053 | Hennepin | |||
055 | Houston | |||
057 | Hubbard | |||
059 | Isanti | |||
061 | Itasca | |||
063 | Jackson | |||
065 | Kanabec | |||
067 | Kandiyohi | |||
069 | Kittson | |||
071 | Koochiching | |||
073 | Lac Qui Parle | |||
075 | Lake | |||
077 | Lake of the Woods | |||
079 | Le Sueur | |||
081 | Lincoln | |||
083 | Lyon | |||
085 | McLeod | |||
087 | Mahnomen | |||
089 | Marshall | |||
091 | Martin | |||
093 | Meeker | |||
095 | Mille Lacs | |||
097 | Morrison | |||
099 | Mower | |||
101 | Murray | |||
103 | Nicollet | |||
105 | Nobles | |||
107 | Norman | |||
109 | Olmsted | |||
111 | Otter Tail | |||
113 | Pennington | |||
115 | Pine | |||
117 | Pipestone | |||
119 | Polk | |||
121 | Pope | |||
123 | Ramsey | |||
125 | Red Lake | |||
127 | Redwood | |||
129 | Renville | |||
131 | Rice | |||
133 | Rock | |||
135 | Roseau | |||
137 | Saint Louis | |||
139 | Scott | |||
141 | Sherburne | |||
143 | Sibley | |||
145 | Stearns | |||
147 | Steele | |||
149 | Stevens | |||
151 | Swift | |||
153 | Todd | |||
155 | Traverse | |||
157 | Wabasha | |||
159 | Wadena | |||
161 | Waseca | |||
163 | Washington | |||
165 | Watonwan | |||
167 | Wilkin | |||
169 | Winona | |||
171 | Wright | |||
173 | Yellow Medicine | |||
FIPS | 5,5,C | Displays the FIPS code of the county. This is the State Number followed by the County FIPS. | ||
27001 | Aitkin | |||
27003 | Anoka | |||
27005 | Becker | |||
27007 | Beltrami | |||
27009 | Benton | |||
27011 | Big Stone | |||
27013 | Blue Earth | |||
27015 | Brown | |||
27017 | Carlton | |||
27019 | Carver | |||
27021 | Cass | |||
27023 | Chippewa | |||
27025 | Chisago | |||
27027 | Clay | |||
27029 | Clearwater | |||
27031 | Cook | |||
27033 | Cottonwood | |||
27035 | Crow Wing | |||
27037 | Dakota | |||
27039 | Dodge | |||
27041 | Douglas | |||
27043 | Faribault | |||
27045 | Fillmore | |||
27047 | Freeborn | |||
27049 | Goodhue | |||
27051 | Grant | |||
27053 | Hennepin | |||
27055 | Houston | |||
27057 | Hubbard | |||
27059 | Isanti | |||
27061 | Itasca | |||
27063 | Jackson | |||
27065 | Kanabec | |||
27067 | Kandiyohi | |||
27069 | Kittson | |||
27071 | Koochiching | |||
27073 | Lac Qui Parle | |||
27075 | Lake | |||
27077 | Lake of the Woods | |||
27079 | Le Sueur | |||
27081 | Lincoln | |||
27083 | Lyon | |||
27085 | McLeod | |||
27087 | Mahnomen | |||
27089 | Marshall | |||
27091 | Martin | |||
27093 | Meeker | |||
27095 | Mille Lacs | |||
27097 | Morrison | |||
27099 | Mower | |||
27101 | Murray | |||
27103 | Nicollet | |||
27105 | Nobles | |||
27107 | Norman | |||
27109 | Olmsted | |||
27111 | Otter Tail | |||
27113 | Pennington | |||
27115 | Pine | |||
27117 | Pipestone | |||
27119 | Polk | |||
27121 | Pope | |||
27123 | Ramsey | |||
27125 | Red Lake | |||
27127 | Redwood | |||
27129 | Renville | |||
27131 | Rice | |||
27133 | Rock | |||
27135 | Roseau | |||
27137 | Saint Louis | |||
27139 | Scott | |||
27141 | Sherburne | |||
27143 | Sibley | |||
27145 | Stearns | |||
27147 | Steele | |||
27149 | Stevens | |||
27151 | Swift | |||
27153 | Todd | |||
27155 | Traverse | |||
27157 | Wabasha | |||
27159 | Wadena | |||
27161 | Waseca | |||
27163 | Washington | |||
27165 | Watonwan | |||
27167 | Wilkin | |||
27169 | Winona | |||
27171 | Wright | |||
27173 | Yellow Medicine |