# All states of the U.S.A. with their name, two-character abbreviation, area in
# square miles, population of the year 2009, the capital and the biggest city.
# Data taken from http://en.wikipedia.org/wiki/U.S._state
class USState < ConstantRecord::Base #:nodoc:
  columns :name, :usps, :area, :population, :capital, :biggest_city
  data ['Alabama',        'AL',   52419,  4708708, 'Montgomery',     'Birmingham'    ],
       ['Alaska',         'AK',  663267,   698473, 'Juneau',         'Anchorage'     ],
       ['Arizona',        'AZ',  113998,  6595778, 'Phoenix',        'Phoenix'       ],
       ['Arkansas',       'AR',   52897,  2889450, 'Little Rock',    'Little Rock'   ],
       ['California',     'CA',  163700, 36961664, 'Sacramento',     'Los Angeles'   ],
       ['Colorado',       'CO',  104185,  5024748, 'Denver',         'Denver'        ],
       ['Connecticut',    'CT',    5543,  3518288, 'Hartford',       'Bridgeport'    ],
       ['Delaware',       'DE',    2491,   885122, 'Dover',          'Wilmington'    ],
       ['Florida',        'FL',   65755, 18537969, 'Tallahassee',    'Jacksonville'  ],
       ['Georgia',        'GA',   59425,  9829211, 'Atlanta',        'Atlanta'       ],
       ['Hawaii',         'HI',   10931,  1295178, 'Honolulu',       'Honolulu'      ],
       ['Idaho',          'ID',   83642,  1545801, 'Boise',          'Boise'         ],
       ['Illinois',       'IL',   54440, 12910409, 'Springfield',    'Chicago'       ],
       ['Indiana',        'IN',   36418,  6423113, 'Indianapolis',   'Indianapolis'  ],
       ['Iowa',           'IA',   56272,  3007856, 'Des Moines',     'Des Moines'    ],
       ['Kansas',         'KS',   82277,  2818747, 'Topeka',         'Wichita'       ],
       ['Kentucky',       'KY',   40409,  4314113, 'Frankfort',      'Louisville'    ],
       ['Louisiana',      'LA',   52271,  4492076, 'Baton Rouge',    'New Orleans'   ],
       ['Maine',          'ME',   35385,  1318301, 'Augusta',        'Portland'      ],
       ['Maryland',       'MD',   12407,  5699478, 'Annapolis',      'Baltimore'     ],
       ['Massachusetts',  'MA',   10554,  6593587, 'Boston',         'Boston'        ],
       ['Michigan',       'MI',   97990,  9969727, 'Lansing',        'Detroit'       ],
       ['Minnesota',      'MN',   86943,  5266214, 'Saint Paul',     'Minneapolis'   ],
       ['Mississippi',    'MS',   48434,  2951996, 'Jackson',        'Jackson'       ],
       ['Missouri',       'MO',   69704,  5987580, 'Jefferson City', 'Kansas City'   ],
       ['Montana',        'MT',  147165,   974989, 'Helena',         'Billings'      ],
       ['Nebraska',       'NE',   77420,  1796619, 'Lincoln',        'Omaha'         ],
       ['Nevada',         'NV',  110567,  2643085, 'Carson City',    'Las Vegas'     ],
       ['New Hampshire',  'NH',    9350,  1324575, 'Concord',        'Manchester'    ],
       ['New Jersey',     'NJ',    8729,  8707739, 'Trenton',        'Newark'        ],
       ['New Mexico',     'NM',  121697,  2009671, 'Santa Fe',       'Albuquerque'   ],
       ['New York',       'NY',   54556, 19541453, 'Albany',         'New York City' ],
       ['North Carolina', 'NC',   53865,  9380884, 'Raleigh',        'Charlotte'     ],
       ['North Dakota',   'ND',   70762,   646844, 'Bismarck',       'Fargo'         ],
       ['Ohio',           'OH',   44825, 11542645, 'Columbus',       'Columbus'      ],
       ['Oklahoma',       'OK',   69960,  3687050, 'Oklahoma City',  'Oklahoma City' ],
       ['Oregon',         'OR',   98466,  3825657, 'Salem',          'Portland'      ],
       ['Pennsylvania',   'PA',   46055, 12604767, 'Harrisburg',     'Philadelphia'  ],
       ['Rhode Island',   'RI',    1210,  1053209, 'Providence',     'Providence'    ],
       ['South Carolina', 'SC',   32020,  4561242, 'Columbia',       'Columbia'      ],
       ['South Dakota',   'SD',   77184,   812383, 'Pierre',         'Sioux Falls'   ],
       ['Tennessee',      'TN',   42181,  6296254, 'Nashville',      'Memphis'       ],
       ['Texas',          'TX',  268820, 24782302, 'Austin',         'Houston'       ],
       ['Utah',           'UT',   84899,  2784572, 'Salt Lake City', 'Salt Lake City'],
       ['Vermont',        'VT',    9623,   621760, 'Montpelier',     'Burlington'    ],
       ['Virginia',       'VA',   42774,  7882590, 'Richmond',       'Virginia Beach'],
       ['Washington',     'WA',   71362,  6664195, 'Olympia',        'Seattle'       ],
       ['West Virginia',  'WV',   24230,  1819777, 'Charleston',     'Charleston'    ],
       ['Wisconsin',      'WI',   65498,  5654774, 'Madison',        'Milwaukee'     ],
       ['Wyoming',        'WY',   97818,   544270, 'Cheyenne',       'Cheyenne'      ]
end
