ST_UID      CNTRY_UID      ST_CD      ST_NAME                   ST_FIPS_CD      
--------------------------------------------------------------------------------
1           1              AL         Alabama                   1               
2           1              AK         Alaska                    2               
3           1              AZ         Arizona                   4               
4           1              AR         Arkansas                  5               
5           1              CA         California                6               
6           1              CO         Colorado                  8               
7           1              CT         Connecticut               9               
8           1              DE         Delaware                  10              
9           1              DC         District of Columbia      11              
10          1              FL         Florida                   12              
11          1              GA         Georgia                   13              
12          1              HI         Hawaii                    15              
13          1              ID         Idaho                     16              
14          1              IL         Illinois                  17              
15          1              IN         Indiana                   18              
16          1              IA         Iowa                      19              
17          1              KS         Kansas                    20              
18          1              KY         Kentucky                  21              
19          1              LA         Louisiana                 22              
20          1              ME         Maine                     23              
21          1              MD         Maryland                  24              
22          1              MA         Massachusetts             25              
23          1              MI         Michigan                  26              
24          1              MN         Minnesota                 27              
25          1              MS         Mississippi               28              
26          1              MO         Missouri                  29              
27          1              MT         Montana                   30              
28          1              NE         Nebraska                  31              
29          1              NV         Nevada                    32              
30          1              NH         New Hampshire             33              
31          1              NJ         New Jersey                34              
32          1              NM         New Mexico                35              
33          1              NY         New York                  36              
34          1              NC         North Carolina            37              
35          1              ND         North Dakota              38              
36          1              OH         Ohio                      39              
37          1              OK         Oklahoma                  40              
38          1              OR         Oregon                    41              
39          1              PA         Pennsylvania              42              
40          1              RI         Rhode Island              44              
41          1              SC         South Carolina            45              
42          1              SD         South Dakota              46              
43          1              TN         Tennessee                 47              
44          1              TX         Texas                     48              
45          1              UT         Utah                      49              
46          1              VT         Vermont                   50              
47          1              VA         Virginia                  51              
48          1              WA         Washington                53              
49          1              WV         West Virginia             54              
50          1              WI         Wisconsin                 55              
51          1              WY         Wyoming                   56              
52          1              AS         American Samoa            60              
53          1              FM         Micronesia                64              
54          1              GU         Guam                      66              
55          1              67         Johnston Atoll            67              
56          1              MH         Marshall Islands          68              
57          1              MP         N. Mariana Islands        69              
58          1              PW         Palau                     70              
59          1              71         Midway Islands            71              
60          1              PR         Puerto Rico               72              
61          1              76         Navassa Island            76              
62          1              VI         Virgin Islands            78              
63          1              79         Wake Island               79              
64          1              81         Baker Island              81              
65          1              84         Howland Island            84              
66          1              86         Jarvis Island             86              
67          1              89         Kingman Reef              89              
68          1              95         Palmyra Atoll             95              
69          3              01         Aguascalientes            1               
70          3              02         Baja California           2               
71          3              03         Baja California Sur       3               
72          3              04         Campeche                  4               
73          3              05         Chiapas                   5               
74          3              06         Chihuahua                 6               
75          3              07         Coahuila de Zaragoza      7               
76          3              08         Colima                    8               
77          3              09         Distrito Federal          9               
78          3              10         Durango                   10              
79          3              11         Guanajuato                11              
80          3              12         Guerrero                  12              
81          3              13         Hidalgo                   13              
82          3              14         Jalisco                   14              
83          3              15         Mexico                    15              
84          3              16         Michoacan de Ocampo       16              
85          3              17         Morelos                   17              
86          3              18         Nayarit                   18              
87          3              19         Nuevo Leon                19              
88          3              20         Oaxaca                    20              
89          3              21         Puebla                    21              
90          3              22         Queretaro de Arteaga      22              
91          3              23         Quintana Roo              23              
92          3              24         San Luis Potosi           24              
93          3              25         Sinaloa                   25              
94          3              26         Sonora                    26              
95          3              27         Tabasco                   27              
96          3              28         Tamaulipas                28              
97          3              29         Tlaxcala                  29              
98          3              30         Veracruz-Llave            30              
99          3              31         Yucatan                   31              
100         3              32         Zacatecas                 32              
101         2              AB         Alberta                   1               
102         2              BC         British Columbia          2               
103         2              MB         Manitoba                  3               
104         2              NB         New Brunswick             4               
105         2              NF         Newfoundland              5               
106         2              NT         Northwest Territorie      6               
107         2              NS         Nova Scotia               7               
108         2              ON         Ontario                   8               
109         2              PE         Prince Edward Island      9               
110         2              QC         Quebec                    10              
111         2              SK         Saskatchewan              11              
112         2              YT         Yukon Territory           12