| Column Name |
Format |
| Initials |
CHAR 2 - Primary key |
| Spelledout |
CHAR 20 NULL |
| |
| Relationships |
|---|
| usstate.code |
c5ad.state |
|
|
|
| Initials |
Spelledout |
| AB |
Alberta |
| AE |
American Forces Europe |
| AK |
Alaska |
| AL |
Alabama |
| AR |
Arkansas |
| AZ |
Arizona |
| BC |
British Columbia |
| CA |
California |
| CO |
Colorado |
| CT |
Connecticut |
| CZ |
Canal Zone |
| DC |
District of Columbia |
| DE |
Delaware |
| FL |
Florida |
| GA |
Georgia |
| GU |
Guam |
| HI |
Hawaii |
| IA |
Iowa |
| ID |
Idaho |
| IL |
Illinois |
| IN |
Indiana |
| KS |
Kansas |
| KY |
Kentucky |
| LA |
Louisiana |
| MA |
Massachusetts |
| MB |
Manitoba |
| MD |
Maryland |
| ME |
Maine |
| MI |
Michigan |
| MN |
Minnesota |
| MO |
Missouri |
| MS |
Mississippi |
| MT |
Montana |
| NB |
New Brunswick |
| NC |
North Carolina |
| ND |
North Dakota |
| NE |
Nebraska |
| NH |
New Hampshire |
| NJ |
New Jersey |
| NL |
Newfoundland and Labrador |
| NM |
New Mexico |
| NS |
Nova Scotia |
| NT |
Northwest Territories |
| NU |
Nunavut |
| NV |
Nevada |
| NY |
New York |
| OH |
Ohio |
| OK |
Oklahoma |
| ON |
Ontario |
| OR |
Oregon |
| PA |
Pennsylvania |
| PE |
Prince Edward Island |
| PR |
Puerto Rico |
| QC |
Quebec |
| RI |
Rhode Island |
| SC |
South Carolina |
| SD |
South Dakota |
| SK |
Saskatchewan |
| TN |
Tennessee |
| TX |
Texas |
| UT |
Utah |
| VA |
Virginia |
| VI |
Virgin Islands |
| VT |
Vermont |
| WA |
Washington |
| WI |
Wisconsin |
| WV |
West Virginia |
| WY |
Wyoming |
| YT |
Yukon |
|