Wiki Home

USStates


Namespace: VFP
Somebody asked in the UT for a list he needed of US States to put in a combobox.

Here's a list ready for cut and paste (not including Puerto Rico):

Well, Puerto Rico isn't a state, so it would not belong in this list!

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky 
Louisiana 
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma 
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming


Could also add a related document here on Canadian Provinces and any other Country people can supply. -- Alex Feldstein
Here are their abbreviations:
ALABAMA AL
ALASKA AK
AMERICAN SAMOA AS 
ARIZONA AZ
ARKANSAS AR
CALIFORNIA CA
COLORADO CO
CONNECTICUT CT
DELAWARE DE
DISTRICT OF COLUMBIA DC
FEDERATED STATES OF MICRONESIA FM
FLORIDA FL
GEORGIA GA
GUAM GU
HAWAII HI
IDAHO ID
ILLINOIS IL
INDIANA IN
IOWA IA
KANSAS KS
KENTUCKY KY
LOUISIANA LA
MAINE ME
MARSHALL ISLANDS MH
MARYLAND MD
MASSACHUSETTS MA
MICHIGAN MI
MINNESOTA MN
MISSISSIPPI MS
MISSOURI MO
MONTANA MT
NEBRASKA NE
NEVADA NV
NEW HAMPSHIRE NH
NEW JERSEY NJ
NEW MEXICO NM
NEW YORK NY
NORTH CAROLINA NC
NORTH DAKOTA ND
NORTHERN MARIANA ISLANDS MP
OHIO OH
OKLAHOMA OK
OREGON OR
PALAU PW
PENNSYLVANIA PA
PUERTO RICO PR
RHODE ISLAND RI
SOUTH CAROLINA SC
SOUTH DAKOTA SD
TENNESSEE TN
TEXAS TX
UTAH UT
VERMONT VT
VIRGIN ISLANDS VI
VIRGINIA VA
WASHINGTON WA
WEST VIRGINIA WV
WISCONSIN WI
WYOMING WY

-- TracyCHolzer

Also see: http://www.usps.com/ncsc/lookups/abbreviations.html#secunitdesig Randy Bosma
And if you want them in CSV format, with the state 2-digit FIPS code as well as the 5-digit code, here they are for the lower 48 + DC:
"Name","State_FIPS","Abbrev","FIPS"
"Minnesota","27","MN","27000"
"Washington","53","WA","53000"
"Idaho","16","ID","16000"
"Montana","30","MT","30000"
"North Dakota","38","ND","38000"
"Michigan","26","MI","26000"
"Maine","23","ME","23000"
"Wisconsin","55","WI","55000"
"Oregon","41","OR","41000"
"South Dakota","46","SD","46000"
"New Hampshire","33","NH","33000"
"New York","36","NY","36000"
"Vermont","50","VT","50000"
"Wyoming","56","WY","56000"
"Iowa","19","IA","19000"
"Nebraska","31","NE","31000"
"Massachusetts","25","MA","25000"
"Illinois","17","IL","17000"
"Pennsylvania","42","PA","42000"
"Connecticut","09","CT","09000"
"Rhode Island","44","RI","44000"
"California","06","CA","06000"
"Nevada","32","NV","32000"
"Utah","49","UT","49000"
"Ohio","39","OH","39000"
"Indiana","18","IN","18000"
"New Jersey","34","NJ","34000"
"Colorado","08","CO","08000"
"West Virginia","54","WV","54000"
"Missouri","29","MO","29000"
"Kansas","20","KS","20000"
"Delaware","10","DE","10000"
"Maryland","24","MD","24000"
"Virginia","51","VA","51000"
"Kentucky","21","KY","21000"
"District of Columbia","11","DC","11000"
"Arizona","04","AZ","04000"
"Oklahoma","40","OK","40000"
"New Mexico","35","NM","35000"
"Tennessee","47","TN","47000"
"North Carolina","37","NC","37000"
"Texas","48","TX","48000"
"Arkansas","05","AR","05000"
"South Carolina","45","SC","45000"
"Alabama","01","AL","01000"
"Georgia","13","GA","13000"
"Mississippi","28","MS","28000"
"Louisiana","22","LA","22000"
"Florida","12","FL","12000"


-- acc
Contributors: Alex Feldstein TracyCHolzer Andrew Coates
Category Text Files
( Topic last updated: 2004.04.22 01:08:10 PM )