forked from iamsenorespana/us-states
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstates.sql
51 lines (51 loc) · 47.1 KB
/
states.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
TRUNCATE TABLE `states`;
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Alabama", "alabama", "AL", "Yellowhammer State", "http://www.alabama.gov", "1819-12-14", "22", "Montgomery", "http://www.montgomeryal.gov", "4833722", "23", "http://alisondb.legislature.state.al.us/alison/default.aspx", "https://cdn.civil.services/us-states/flags/alabama-large.png", "https://cdn.civil.services/us-states/seals/alabama-large.png", "https://cdn.civil.services/us-states/maps/alabama-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/alabama.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/alabama.jpg", "https://twitter.com/alabamagov", "https://www.facebook.com/alabamagov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Alaska", "alaska", "AK", "The Last Frontier", "http://alaska.gov", "1959-01-03", "49", "Juneau", "http://www.juneau.org", "735132", "47", "http://www.legis.state.ak.us/basis/folioproxy.asp?url=http://wwwjnu01.legis.state.ak.us/cgi-bin/folioisa.dll/acontxt/query=*/doc/{t1}?", "https://cdn.civil.services/us-states/flags/alaska-large.png", "https://cdn.civil.services/us-states/seals/alaska-large.png", "https://cdn.civil.services/us-states/maps/alaska-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/alaska.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/alaska.jpg", "https://twitter.com/alaska", "https://www.facebook.com/AlaskaLocalGovernments");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Arizona", "arizona", "AZ", "The Grand Canyon State", "https://az.gov", "1912-02-14", "48", "Phoenix", "https://www.phoenix.gov", "6626624", "15", "http://www.azleg.gov/Constitution.asp", "https://cdn.civil.services/us-states/flags/arizona-large.png", "https://cdn.civil.services/us-states/seals/arizona-large.png", "https://cdn.civil.services/us-states/maps/arizona-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/arizona.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/arizona.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Arkansas", "arkansas", "AR", "The Natural State", "http://arkansas.gov", "1836-06-15", "25", "Little Rock", "http://www.littlerock.org", "2959373", "32", "http://www.arkleg.state.ar.us/assembly/Summary/ArkansasConstitution1874.pdf", "https://cdn.civil.services/us-states/flags/arkansas-large.png", "https://cdn.civil.services/us-states/seals/arkansas-large.png", "https://cdn.civil.services/us-states/maps/arkansas-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/arkansas.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/arkansas.jpg", "https://twitter.com/arkansasgov", "https://www.facebook.com/Arkansas.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("California", "california", "CA", "Golden State", "http://www.ca.gov", "1850-09-09", "31", "Sacramento", "http://www.cityofsacramento.org", "38332521", "1", "http://www.leginfo.ca.gov/const-toc.html", "https://cdn.civil.services/us-states/flags/california-large.png", "https://cdn.civil.services/us-states/seals/california-large.png", "https://cdn.civil.services/us-states/maps/california-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/california.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/california.jpg", "https://twitter.com/cagovernment", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Colorado", "colorado", "CO", "The Centennial State", "https://www.colorado.gov", "1876-08-01", "38", "Denver", "http://www.denvergov.org", "5268367", "22", "https://www.colorado.gov/pacific/archives/government", "https://cdn.civil.services/us-states/flags/colorado-large.png", "https://cdn.civil.services/us-states/seals/colorado-large.png", "https://cdn.civil.services/us-states/maps/colorado-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/colorado.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/colorado.jpg", "https://twitter.com/coloradogov", "https://www.facebook.com/Colorado.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Connecticut", "connecticut", "CT", "Constitution State", "http://www.ct.gov", "1788-01-09", "5", "Hartford", "http://www.hartford.gov", "3596080", "29", "http://www.ct.gov/sots/cwp/view.asp?a=3188&q=392288", "https://cdn.civil.services/us-states/flags/connecticut-large.png", "https://cdn.civil.services/us-states/seals/connecticut-large.png", "https://cdn.civil.services/us-states/maps/connecticut-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/connecticut.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/connecticut.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Delaware", "delaware", "DE", "The First State / The Diamond State", "http://delaware.gov", "1787-12-07", "1", "Dover", "http://www.cityofdover.com", "925749", "45", "http://www.state.de.us/facts/constit/welcome.htm", "https://cdn.civil.services/us-states/flags/delaware-large.png", "https://cdn.civil.services/us-states/seals/delaware-large.png", "https://cdn.civil.services/us-states/maps/delaware-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/delaware.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/delaware.jpg", "https://twitter.com/delaware_gov", "https://www.facebook.com/delaware.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Florida", "florida", "FL", "Sunshine State", "http://www.myflorida.com", "1845-03-03", "27", "Tallahassee", "https://www.talgov.com/Main/Home.aspx", "19552860", "4", "http://www.leg.state.fl.us/Statutes/index.cfm", "https://cdn.civil.services/us-states/flags/florida-large.png", "https://cdn.civil.services/us-states/seals/florida-large.png", "https://cdn.civil.services/us-states/maps/florida-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/florida.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/florida.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Georgia", "georgia", "GA", "Peach State", "http://georgia.gov", "1788-01-02", "4", "Atlanta", "http://www.atlantaga.gov", "9992167", "8", "http://sos.ga.gov/admin/files/Constitution_2013_Final_Printed.pdf", "https://cdn.civil.services/us-states/flags/georgia-large.png", "https://cdn.civil.services/us-states/seals/georgia-large.png", "https://cdn.civil.services/us-states/maps/georgia-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/georgia.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/georgia.jpg", "http://twitter.com/georgiagov", "http://www.facebook.com/pages/georgiagov/29760668054");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Hawaii", "hawaii", "HI", "Aloha State", "https://www.ehawaii.gov", "1959-08-21", "50", "Honolulu", "http://www.co.honolulu.hi.us", "1404054", "40", "http://lrbhawaii.org/con", "https://cdn.civil.services/us-states/flags/hawaii-large.png", "https://cdn.civil.services/us-states/seals/hawaii-large.png", "https://cdn.civil.services/us-states/maps/hawaii-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/hawaii.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/hawaii.jpg", "https://twitter.com/ehawaiigov", "https://www.facebook.com/ehawaii.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Idaho", "idaho", "ID", "Gem State", "https://www.idaho.gov", "1890-07-03", "43", "Boise", "http://www.cityofboise.org", "1612136", "39", "http://www.legislature.idaho.gov/idstat/IC/Title003.htm", "https://cdn.civil.services/us-states/flags/idaho-large.png", "https://cdn.civil.services/us-states/seals/idaho-large.png", "https://cdn.civil.services/us-states/maps/idaho-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/idaho.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/idaho.jpg", "https://twitter.com/IDAHOgov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Illinois", "illinois", "IL", "Prairie State", "https://www.illinois.gov", "1818-12-03", "21", "Springfield", "http://www.springfield.il.us", "12882135", "5", "http://www.ilga.gov/commission/lrb/conmain.htm", "https://cdn.civil.services/us-states/flags/illinois-large.png", "https://cdn.civil.services/us-states/seals/illinois-large.png", "https://cdn.civil.services/us-states/maps/illinois-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/illinois.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/illinois.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Indiana", "indiana", "IN", "Hoosier State", "http://www.in.gov", "1816-12-11", "19", "Indianapolis", "http://www.indy.gov/Pages/Home.aspx", "6570902", "16", "http://www.law.indiana.edu/uslawdocs/inconst.html", "https://cdn.civil.services/us-states/flags/indiana-large.png", "https://cdn.civil.services/us-states/seals/indiana-large.png", "https://cdn.civil.services/us-states/maps/indiana-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/indiana.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/indiana.jpg", "https://twitter.com/in_gov", "https://www.facebook.com/IndianaGovernment");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Iowa", "iowa", "IA", "Hawkeye State", "https://www.iowa.gov", "1846-12-28", "29", "Des Moines", "http://www.ci.des-moines.ia.us", "3090416", "30", "http://publications.iowa.gov/135/1/history/7-7.html", "https://cdn.civil.services/us-states/flags/iowa-large.png", "https://cdn.civil.services/us-states/seals/iowa-large.png", "https://cdn.civil.services/us-states/maps/iowa-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/iowa.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/iowa.jpg", "https://twitter.com/IAGOVTWEETS", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Kansas", "kansas", "KS", "Sunflower State", "https://www.kansas.gov", "1861-01-29", "34", "Topeka", "http://www.topeka.org", "2893957", "34", "https://kslib.info/405/Kansas-Constitution", "https://cdn.civil.services/us-states/flags/kansas-large.png", "https://cdn.civil.services/us-states/seals/kansas-large.png", "https://cdn.civil.services/us-states/maps/kansas-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/kansas.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/kansas.jpg", "http://www.twitter.com/ksgovernment", "http://www.facebook.com/pages/Topeka-KS/Kansasgov-Kansas-Government-Online/52068474220");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Kentucky", "kentucky", "KY", "Bluegrass State", "http://kentucky.gov", "1792-06-01", "15", "Frankfort", "http://frankfort.ky.gov", "4395295", "26", "http://www.lrc.state.ky.us/Legresou/Constitu/intro.htm", "https://cdn.civil.services/us-states/flags/kentucky-large.png", "https://cdn.civil.services/us-states/seals/kentucky-large.png", "https://cdn.civil.services/us-states/maps/kentucky-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/kentucky.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/kentucky.jpg", "https://twitter.com/kygov", "https://www.facebook.com/kygov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Louisiana", "louisiana", "LA", "Pelican State", "http://louisiana.gov", "1812-04-30", "18", "Baton Rouge", "http://brgov.com", "4625470", "25", "http://senate.legis.state.la.us/Documents/Constitution", "https://cdn.civil.services/us-states/flags/louisiana-large.png", "https://cdn.civil.services/us-states/seals/louisiana-large.png", "https://cdn.civil.services/us-states/maps/louisiana-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/louisiana.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/louisiana.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Maine", "maine", "ME", "Pine Tree State", "http://www.maine.gov", "1820-03-15", "23", "Augusta", "http://www.augustamaine.gov", "1328302", "41", "http://www.maine.gov/legis/const", "https://cdn.civil.services/us-states/flags/maine-large.png", "https://cdn.civil.services/us-states/seals/maine-large.png", "https://cdn.civil.services/us-states/maps/maine-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/maine.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/maine.jpg", "https://twitter.com/mainegov_news", "http://www.facebook.com/pages/Augusta-ME/Mainegov/98519328240");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Maryland", "maryland", "MD", "Old Line State", "http://www.maryland.gov", "1788-04-28", "7", "Annapolis", "http://www.annapolis.gov", "5928814", "19", "http://msa.maryland.gov/msa/mdmanual/43const/html/const.html", "https://cdn.civil.services/us-states/flags/maryland-large.png", "https://cdn.civil.services/us-states/seals/maryland-large.png", "https://cdn.civil.services/us-states/maps/maryland-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/maryland.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/maryland.jpg", "https://twitter.com/statemaryland", "https://www.facebook.com/statemaryland");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Massachusetts", "massachusetts", "MA", "Bay State", "http://www.mass.gov", "1788-02-06", "6", "Boston", "http://www.ci.boston.ma.us", "6692824", "14", "http://www.state.ma.us/legis/const.htm", "https://cdn.civil.services/us-states/flags/massachusetts-large.png", "https://cdn.civil.services/us-states/seals/massachusetts-large.png", "https://cdn.civil.services/us-states/maps/massachusetts-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/massachusetts.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/massachusetts.jpg", "http://twitter.com/massgov", "https://www.facebook.com/massgov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Minnesota", "minnesota", "MN", "North Star State / Land of 10,000 Lakes", "https://mn.gov", "1858-05-11", "32", "Saint Paul", "http://www.stpaul.gov", "5420380", "21", "http://www.house.leg.state.mn.us/cco/rules/mncon/preamble.htm", "https://cdn.civil.services/us-states/flags/minnesota-large.png", "https://cdn.civil.services/us-states/seals/minnesota-large.png", "https://cdn.civil.services/us-states/maps/minnesota-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/minnesota.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/minnesota.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Michigan", "michigan", "MI", "Wolverine State / Great Lakes State", "http://www.michigan.gov", "1837-01-26", "26", "Lansing", "http://cityoflansingmi.com", "9895622", "9", "http://www.legislature.mi.gov/(S(hrowl12tg05hemnnkidim1jb))/mileg.aspx?page=GetObject&objectname=mcl-Constitution", "https://cdn.civil.services/us-states/flags/michigan-large.png", "https://cdn.civil.services/us-states/seals/michigan-large.png", "https://cdn.civil.services/us-states/maps/michigan-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/michigan.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/michigan.jpg", "https://twitter.com/migov", "https://www.facebook.com/MIgovernment");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Mississippi", "mississippi", "MS", "Magnolia State", "http://www.ms.gov", "1817-12-10", "20", "Jackson", "http://www.city.jackson.ms.us", "2991207", "31", "http://law.justia.com/constitution/mississippi", "https://cdn.civil.services/us-states/flags/mississippi-large.png", "https://cdn.civil.services/us-states/seals/mississippi-large.png", "https://cdn.civil.services/us-states/maps/mississippi-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/mississippi.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/mississippi.jpg", "https://twitter.com/msdotgov", "https://www.facebook.com/msdotgov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Missouri", "missouri", "MO", "Show Me State", "https://www.mo.gov", "1821-08-10", "24", "Jefferson City", "http://www.jeffcitymo.org", "6044171", "18", "http://www.moga.mo.gov/mostatutes/moconstn.html", "https://cdn.civil.services/us-states/flags/missouri-large.png", "https://cdn.civil.services/us-states/seals/missouri-large.png", "https://cdn.civil.services/us-states/maps/missouri-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/missouri.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/missouri.jpg", "https://twitter.com/MoGov", "https://www.facebook.com/mogov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Montana", "montana", "MT", "Treasure State", "http://mt.gov", "1889-11-08", "41", "Helena", "http://www.ci.helena.mt.us", "1015165", "44", "http://courts.mt.gov/content/library/docs/72constit.pdf", "https://cdn.civil.services/us-states/flags/montana-large.png", "https://cdn.civil.services/us-states/seals/montana-large.png", "https://cdn.civil.services/us-states/maps/montana-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/montana.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/montana.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Nebraska", "nebraska", "NE", "Cornhusker State", "http://www.nebraska.gov", "1867-03-01", "37", "Lincoln", "http://lincoln.ne.gov", "1868516", "37", "http://www.state.ne.us/legislative/statutes/C", "https://cdn.civil.services/us-states/flags/nebraska-large.png", "https://cdn.civil.services/us-states/seals/nebraska-large.png", "https://cdn.civil.services/us-states/maps/nebraska-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/nebraska.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/nebraska.jpg", "https://twitter.com/Nebraskagov", "https://www.facebook.com/nebraska.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Nevada", "nevada", "NV", "The Silver State", "http://nv.gov", "1864-10-31", "36", "Carson City", "http://www.carson.org", "2790136", "35", "http://www.leg.state.nv.us/Const/NvConst.html", "https://cdn.civil.services/us-states/flags/nevada-large.png", "https://cdn.civil.services/us-states/seals/nevada-large.png", "https://cdn.civil.services/us-states/maps/nevada-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/nevada.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/nevada.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("New Hampshire", "new-hampshire", "NH", "Granite State", "https://www.nh.gov", "1788-06-21", "9", "Concord", "http://www.concordnh.gov", "1323459", "42", "http://www.state.nh.us/constitution/constitution.html", "https://cdn.civil.services/us-states/flags/new-hampshire-large.png", "https://cdn.civil.services/us-states/seals/new-hampshire-large.png", "https://cdn.civil.services/us-states/maps/new-hampshire-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/new-hampshire.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/new-hampshire.jpg", "https://twitter.com/nhgov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("New Jersey", "new-jersey", "NJ", "Garden State", "http://www.state.nj.us", "1787-12-18", "3", "Trenton", "http://www.trentonnj.org", "8899339", "11", "http://www.njleg.state.nj.us/lawsconstitution/consearch.asp", "https://cdn.civil.services/us-states/flags/new-jersey-large.png", "https://cdn.civil.services/us-states/seals/new-jersey-large.png", "https://cdn.civil.services/us-states/maps/new-jersey-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/new-jersey.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/new-jersey.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("New Mexico", "new-mexico", "NM", "Land of Enchantment", "http://www.newmexico.gov", "1912-01-06", "47", "Santa Fe", "http://www.santafenm.gov", "2085287", "36", "http://www.loc.gov/law/guide/us-nm.html", "https://cdn.civil.services/us-states/flags/new-mexico-large.png", "https://cdn.civil.services/us-states/seals/new-mexico-large.png", "https://cdn.civil.services/us-states/maps/new-mexico-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/new-mexico.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/new-mexico.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("New York", "new-york", "NY", "Empire State", "http://www.ny.gov", "1788-07-26", "11", "Albany", "http://www.albanyny.org", "19651127", "3", "https://www.dos.ny.gov/info/constitution.htm", "https://cdn.civil.services/us-states/flags/new-york-large.png", "https://cdn.civil.services/us-states/seals/new-york-large.png", "https://cdn.civil.services/us-states/maps/new-york-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/new-york.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/new-york.jpg", "https://twitter.com/nygov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("North Carolina", "north-carolina", "NC", "Old North State / Tar Heel State", "http://www.nc.gov", "1789-11-21", "12", "Raleigh", "http://www.raleigh-nc.org", "9848060", "10", "http://statelibrary.dcr.state.nc.us/nc/stgovt/preconst.htm", "https://cdn.civil.services/us-states/flags/north-carolina-large.png", "https://cdn.civil.services/us-states/seals/north-carolina-large.png", "https://cdn.civil.services/us-states/maps/north-carolina-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/north-carolina.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/north-carolina.jpg", "https://twitter.com/NCdotGov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("North Dakota", "north-dakota", "ND", "Peace Garden State / Flickertail State / Roughrider State", "http://www.nd.gov", "1889-11-02", "39", "Bismarck", "http://www.bismarck.org", "723393", "48", "http://www.legis.nd.gov/information/statutes/const-laws.html", "https://cdn.civil.services/us-states/flags/north-dakota-large.png", "https://cdn.civil.services/us-states/seals/north-dakota-large.png", "https://cdn.civil.services/us-states/maps/north-dakota-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/north-dakota.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/north-dakota.jpg", "https://twitter.com/ExperienceND", "https://www.facebook.com/ExperienceND");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Ohio", "ohio", "OH", "Buckeye State", "https://ohio.gov", "1803-03-01", "17", "Columbus", "http://ci.columbus.oh.us", "11570808", "7", "http://www.legislature.state.oh.us/constitution.cfm", "https://cdn.civil.services/us-states/flags/ohio-large.png", "https://cdn.civil.services/us-states/seals/ohio-large.png", "https://cdn.civil.services/us-states/maps/ohio-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/ohio.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/ohio.jpg", "https://twitter.com/ohgov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Oklahoma", "oklahoma", "OK", "Sooner State", "https://www.ok.gov", "1907-11-16", "46", "Oklahoma City", "http://www.okc.gov", "3850568", "28", "http://oklegal.onenet.net/okcon", "https://cdn.civil.services/us-states/flags/oklahoma-large.png", "https://cdn.civil.services/us-states/seals/oklahoma-large.png", "https://cdn.civil.services/us-states/maps/oklahoma-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/oklahoma.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/oklahoma.jpg", "https://twitter.com/okgov", "https://www.facebook.com/okgov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Oregon", "oregon", "OR", "Beaver State", "http://www.oregon.gov", "1859-02-14", "33", "Salem", "http://www.cityofsalem.net/Pages/default.aspx", "3930065", "27", "http://bluebook.state.or.us/state/constitution/constitution.htm", "https://cdn.civil.services/us-states/flags/oregon-large.png", "https://cdn.civil.services/us-states/seals/oregon-large.png", "https://cdn.civil.services/us-states/maps/oregon-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/oregon.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/oregon.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Pennsylvania", "pennsylvania", "PA", "Keystone State", "http://www.pa.gov", "1787-12-12", "2", "Harrisburg", "http://harrisburgpa.gov", "12773801", "6", "http://sites.state.pa.us/PA_Constitution.html", "https://cdn.civil.services/us-states/flags/pennsylvania-large.png", "https://cdn.civil.services/us-states/seals/pennsylvania-large.png", "https://cdn.civil.services/us-states/maps/pennsylvania-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/pennsylvania.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/pennsylvania.jpg", "https://www.facebook.com/visitPA", "https://twitter.com/visitPA");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Rhode Island", "rhode-island", "RI", "The Ocean State", "https://www.ri.gov", "1790-05-29", "13", "Providence", "http://www.providenceri.com", "1051511", "43", "http://webserver.rilin.state.ri.us/RiConstitution", "https://cdn.civil.services/us-states/flags/rhode-island-large.png", "https://cdn.civil.services/us-states/seals/rhode-island-large.png", "https://cdn.civil.services/us-states/maps/rhode-island-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/rhode-island.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/rhode-island.jpg", "https://twitter.com/rigov", "https://www.facebook.com/RIgov-Rhode-Island-Government-Online-24056655991");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("South Carolina", "south-carolina", "SC", "Palmetto State", "http://www.sc.gov", "1788-05-23", "8", "Columbia", "http://www.columbiasc.net", "4774839", "24", "http://www.scstatehouse.gov/scconstitution/scconst.php", "https://cdn.civil.services/us-states/flags/south-carolina-large.png", "https://cdn.civil.services/us-states/seals/south-carolina-large.png", "https://cdn.civil.services/us-states/maps/south-carolina-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/south-carolina.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/south-carolina.jpg", "https://twitter.com/scgov", "http://www.facebook.com/pages/SCgov/12752057990");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("South Dakota", "south-dakota", "SD", "Mount Rushmore State", "http://sd.gov", "1889-11-02", "40", "Pierre", "http://ci.pierre.sd.us", "844877", "46", "http://legis.sd.gov/statutes/Constitution", "https://cdn.civil.services/us-states/flags/south-dakota-large.png", "https://cdn.civil.services/us-states/seals/south-dakota-large.png", "https://cdn.civil.services/us-states/maps/south-dakota-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/south-dakota.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/south-dakota.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Tennessee", "tennessee", "TN", "Volunteer State", "https://www.tn.gov", "1796-06-01", "16", "Nashville", "http://www.nashville.gov", "6495978", "17", "http://www.capitol.tn.gov/about/docs/TN-Constitution.pdf", "https://cdn.civil.services/us-states/flags/tennessee-large.png", "https://cdn.civil.services/us-states/seals/tennessee-large.png", "https://cdn.civil.services/us-states/maps/tennessee-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/tennessee.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/tennessee.jpg", "https://twitter.com/TNVacation", "https://www.facebook.com/tnvacation");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Texas", "texas", "TX", "Lone Star State", "https://www.texas.gov", "1845-12-29", "28", "Austin", "http://www.austintexas.gov", "26448193", "2", "http://www.constitution.legis.state.tx.us", "https://cdn.civil.services/us-states/flags/texas-large.png", "https://cdn.civil.services/us-states/seals/texas-large.png", "https://cdn.civil.services/us-states/maps/texas-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/texas.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/texas.jpg", "https://twitter.com/texasgov", "http://www.facebook.com/Texas.gov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Utah", "utah", "UT", "The Beehive State", "https://utah.gov", "1896-01-04", "45", "Salt Lake City", "http://www.slcgov.com", "2900872", "33", "http://le.utah.gov/UtahCode/chapter.jsp?code=Constitution", "https://cdn.civil.services/us-states/flags/utah-large.png", "https://cdn.civil.services/us-states/seals/utah-large.png", "https://cdn.civil.services/us-states/maps/utah-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/utah.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/utah.jpg", "https://twitter.com/UtahGov", "https://www.facebook.com/utahgov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Vermont", "vermont", "VT", "Green Mountain State", "http://vermont.gov", "1791-03-04", "14", "Montpelier", "http://www.montpelier-vt.org", "626630", "49", "http://www.leg.state.vt.us/statutes/const2.htm", "https://cdn.civil.services/us-states/flags/vermont-large.png", "https://cdn.civil.services/us-states/seals/vermont-large.png", "https://cdn.civil.services/us-states/maps/vermont-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/vermont.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/vermont.jpg", "https://twitter.com/vermontgov", "https://www.facebook.com/MyVermont");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Virginia", "virginia", "VA", "Old Dominion State", "https://www.virginia.gov", "1788-06-25", "10", "Richmond", "http://www.richmondgov.com", "8260405", "12", "http://hodcap.state.va.us/publications/Constitution-01-13.pdf", "https://cdn.civil.services/us-states/flags/virginia-large.png", "https://cdn.civil.services/us-states/seals/virginia-large.png", "https://cdn.civil.services/us-states/maps/virginia-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/virginia.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/virginia.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Washington", "washington", "WA", "The Evergreen State", "http://www.wa.gov", "1889-11-11", "42", "Olympia", "http://www.ci.olympia.wa.us", "6971406", "13", "http://www.leg.wa.gov/lawsandagencyrules/pages/constitution.aspx", "https://cdn.civil.services/us-states/flags/washington-large.png", "https://cdn.civil.services/us-states/seals/washington-large.png", "https://cdn.civil.services/us-states/maps/washington-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/washington.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/washington.jpg", "https://twitter.com/wagov", null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("West Virginia", "west-virginia", "WV", "Mountain State", "http://www.wv.gov", "1863-06-20", "35", "Charleston", "http://www.cityofcharleston.org", "1854304", "38", "http://www.legis.state.wv.us/WVCODE/WV_CON.cfm", "https://cdn.civil.services/us-states/flags/west-virginia-large.png", "https://cdn.civil.services/us-states/seals/west-virginia-large.png", "https://cdn.civil.services/us-states/maps/west-virginia-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/west-virginia.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/west-virginia.jpg", "https://twitter.com/wvgov", "https://www.facebook.com/wvgov");
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Wisconsin", "wisconsin", "WI", "Badger State", "https://www.wisconsin.gov", "1848-05-29", "30", "Madison", "http://www.ci.madison.wi.us", "5742713", "20", "http://www.legis.state.wi.us/rsb/2wiscon.html", "https://cdn.civil.services/us-states/flags/wisconsin-large.png", "https://cdn.civil.services/us-states/seals/wisconsin-large.png", "https://cdn.civil.services/us-states/maps/wisconsin-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/wisconsin.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/wisconsin.jpg", null, null);
INSERT INTO `states` (`state`, `slug`, `code`, `nickname`, `website`, `admission_date`, `admission_number`, `capital_city`, `capital_url`, `population`, `population_rank`, `constitution_url`, `state_flag_url`, `state_seal_url`, `map_image_url`, `landscape_background_url`, `skyline_background_url`, `twitter_url`, `facebook_url`) VALUES ("Wyoming", "wyoming", "WY", "Equality State", "http://www.wyo.gov", "1890-07-10", "44", "Cheyenne", "http://www.cheyennecity.org", "582658", "50", "http://legisweb.state.wy.us/statutes/constitution.aspx?file=titles/97Title97.htm", "https://cdn.civil.services/us-states/flags/wyoming-large.png", "https://cdn.civil.services/us-states/seals/wyoming-large.png", "https://cdn.civil.services/us-states/maps/wyoming-large.png", "https://cdn.civil.services/us-states/backgrounds/1280x720/landscape/wyoming.jpg", "https://cdn.civil.services/us-states/backgrounds/1280x720/skyline/wyoming.jpg", null, null);