Wednesday, October 28, 2009

U.S. Census Regions

Tonight I was working on a project for my A.I. class I’m taking at MTSU and had a need to have a table of U.S. regions that I could use to join to some other data to allow me to regionalize the data.  I thought that a quick Bing search would have revealed all that I could handle and the problem would be solved.  Well, it turns out that all I could find were all the maps galore but no where could it be found in tabular form.  So, I had to hand enter it based on this info from the U.S. Census Bureau website.  I decided it might be good to post it here for others searching for it and for that time a year from now when I need it again.  It’s totally denormalized for easy use in Excel.  For database work, you’ll probably want to normalize into states, regions, & divisions tables.  Enjoy!

RegionNum Region DivisionNum Division State
1 Northeast 1 New England CT
1 Northeast 1 New England ME
1 Northeast 1 New England MA
1 Northeast 1 New England NH
1 Northeast 1 New England RI
1 Northeast 1 New England VT
1 Northeast 2 Middle Atlantic NJ
1 Northeast 2 Middle Atlantic NY
1 Northeast 2 Middle Atlantic PA
2 Midwest 3 East North Central WI
2 Midwest 3 East North Central MI
2 Midwest 3 East North Central IL
2 Midwest 3 East North Central IN
2 Midwest 3 East North Central OH
2 Midwest 4 West North Central ND
2 Midwest 4 West North Central SD
2 Midwest 4 West North Central NE
2 Midwest 4 West North Central KS
2 Midwest 4 West North Central MN
2 Midwest 4 West North Central IA
2 Midwest 4 West North Central MO
3 South 5 South Atlantic DE
3 South 5 South Atlantic MD
3 South 5 South Atlantic DC
3 South 5 South Atlantic WV
3 South 5 South Atlantic VA
3 South 5 South Atlantic NC
3 South 5 South Atlantic SC
3 South 5 South Atlantic GA
3 South 5 South Atlantic FL
3 South 6 East South Central AL
3 South 6 East South Central KY
3 South 6 East South Central MS
3 South 6 East South Central TN
3 South 7 West South Central AR
3 South 7 West South Central LA
3 South 7 West South Central OK
3 South 7 West South Central TX
4 West 8 Mountain AZ
4 West 8 Mountain CO
4 West 8 Mountain ID
4 West 8 Mountain NM
4 West 8 Mountain MT
4 West 8 Mountain UT
4 West 8 Mountain NV
4 West 8 Mountain WY
4 West 9 Pacific WA
4 West 9 Pacific OR
4 West 9 Pacific CA
4 West 9 Pacific AK
4 West 9 Pacific HI