/* insert data */
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Alabama', 'AL', 'Montgomery', 1819, 1);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Alaska', 'AK', 'Juneau', 1959, 2);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('American Samoa', 'AS', 'Pago Pago', 1899, 3);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Arizona', 'AZ', 'Phoenix', 1912, 4);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Arkansas', 'AR', 'Little Rock', 1836, 5);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('California', 'CA', 'Sacramento', 1850, 6);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Colorado', 'CO', 'Denver', 1876, 7);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Connecticut', 'CT', 'Hartford', 1788, 8);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Delaware', 'DE', 'Dover', 1787, 9);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Florida', 'FL', 'Tallahassee', 1845, 10);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Georgia', 'GA', 'Atlanta', 1788, 11);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Guam', 'GU', 'Hagåtña Dededo', 1898, 12);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Hawaii', 'HI', 'Honolulu', 1959, 13);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Idaho', 'ID', 'Boise', 1890, 14);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Illinois', 'IL', 'Springfield', 1818, 15);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Indiana', 'IN', 'Indianapolis', 1816, 16);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Iowa', 'IA', 'Des Moines', 1846, 17);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Kansas', 'KS', 'Topeka', 1861, 18);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Kentucky', 'KY', 'Frankfort', 1792, 19);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Louisiana', 'LA', 'Baton Rouge', 1812, 20);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Maine', 'ME', 'Augusta', 1820, 21);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Maryland', 'MD', 'Annapolis', 1788, 22);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Massachusetts', 'MA', 'Boston', 1788, 23);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Michigan', 'MI', 'Lansing', 1837, 24);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Minnesota', 'MN', 'Saint Paul', 1858, 25);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Mississippi', 'MS', 'Jackson', 1817, 26);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Missouri', 'MO', 'Jefferson City', 1821, 27);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Montana', 'MT', 'Helena', 1889, 28);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Nebraska', 'NE', 'Lincoln', 1867, 29);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Nevada', 'NV', 'Carson City', 1864, 30);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('New Hampshire', 'NH', 'Concord', 1788, 31);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('New Jersey', 'NJ', 'Trenton', 1787, 32);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('New Mexico', 'NM', 'Santa Fe', 1912, 33);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('New York', 'NY', 'Albany', 1788, 34);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('North Carolina', 'NC', 'Raleigh', 1789, 35);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('North Dakota', 'ND', 'Bismarck', 1889, 36);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Northern Mariana Islands', 'MP', 'Saipan', 1947, 37);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Ohio', 'OH', 'Columbus', 1803, 38);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Oklahoma', 'OK', 'Oklahoma City', 1907, 39);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Oregon', 'OR', 'Salem', 1859, 40);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Pennsylvania', 'PA', 'Harrisburg', 1787, 41);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Puerto Rico', 'PR', 'San Juan', 1898, 42);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Rhode Island', 'RI', 'Providence', 1790, 43);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('South Carolina', 'SC', 'Columbia', 1788, 44);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('South Dakota', 'SD', 'Pierre', 1889, 45);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Tennessee', 'TN', 'Nashville', 1796, 46);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Texas', 'TX', 'Austin', 1845, 47);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('U.S. Virgin Islands', 'VI', 'Charlotte Amalie', 1917, 48);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Utah', 'UT', 'Salt Lake City', 1896, 49);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Vermont', 'VT', 'Montpelier', 1791, 50);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Virginia', 'VA', 'Richmond', 1788, 51);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Washington', 'WA', 'Olympia', 1889, 52);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Washington D.C.', 'DC', '', 0, 53);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('West Virginia', 'WV', 'Charleston', 1863, 54);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Wisconsin', 'WI', 'Madison', 1848, 55);
INSERT INTO states (StateName, Abbreviation, Capital, Statehood, ID) VALUES ('Wyoming', 'WY', 'Cheyenne', 1890, 56);