

INSERT INTO  State VALUES ('Massachusetts',1776);
INSERT INTO  State VALUES ('Pennsylvania',1776);
INSERT INTO  State VALUES ('Virginia',1776);
INSERT INTO  State VALUES ('Connecticut',1776);
INSERT INTO  State VALUES ('South Carolina',1776);
INSERT INTO  State VALUES ('Maryland',1776);
INSERT INTO  State VALUES ('New Jersey',1776);
INSERT INTO  State VALUES ('Georgia',1776);
INSERT INTO  State VALUES ('New Hampshire',1776);
INSERT INTO  State VALUES ('Delawhare',1776);
INSERT INTO  State VALUES ('New York',1776);
INSERT INTO  State VALUES ('North Carolina',1776);
INSERT INTO  State VALUES ('Rhode Island',1776);
INSERT INTO  State VALUES ('Vermont',1791);
INSERT INTO  State VALUES ('Kentucky',1792);
INSERT INTO  State VALUES ('Tennesee',1796);
INSERT INTO  State VALUES ('Ohio',1803);
INSERT INTO  State VALUES ('Louisiana',1812);
INSERT INTO  State VALUES ('Indiana',1816);
INSERT INTO  State VALUES ('Mississippi',1817);
INSERT INTO  State VALUES ('Illinois',1818);
INSERT INTO  State VALUES ('Alabama',1819);
INSERT INTO  State VALUES ('Maine',1820);
INSERT INTO  State VALUES ('Missouri',1821);
INSERT INTO  State VALUES ('Arkansas',1836);
INSERT INTO  State VALUES ('Michigan',1837);
INSERT INTO  State VALUES ('Florida',1845);
INSERT INTO  State VALUES ('Texas',1845);
INSERT INTO  State VALUES ('Iowa',1846);
INSERT INTO  State VALUES ('Wisconsin',1848);
INSERT INTO  State VALUES ('California',1850);
INSERT INTO  State VALUES ('Minnesota',1858);
INSERT INTO  State VALUES ('Oregon',1859);
INSERT INTO  State VALUES ('Kansas',1861);
INSERT INTO  State VALUES ('West Virginia',1863);
INSERT INTO  State VALUES ('Nevada',1864);
INSERT INTO  State VALUES ('Nebraska',1867);
INSERT INTO  State VALUES ('Colorado',1876);
INSERT INTO  State VALUES ('North Dakota',1889);
INSERT INTO  State VALUES ('South Dakota',1889);
INSERT INTO  State VALUES ('Montana',1889);
INSERT INTO  State VALUES ('Washington',1889);
INSERT INTO  State VALUES ('Idaho',1890);
INSERT INTO  State VALUES ('Wyoming',1890);
INSERT INTO  State VALUES ('Utah',1896);
INSERT INTO  State VALUES ('Oklahoma',1907);
INSERT INTO  State VALUES ('New Mexico',1912);
INSERT INTO  State VALUES ('Arizona',1912);
INSERT INTO  State VALUES ('Alaska',1959);
INSERT INTO  State VALUES ('Hawaii',1959);


INSERT INTO  President VALUES ('Washington G',1732,7,67,'Federalist','Virginia');
INSERT INTO  President VALUES ('Adams J',1735,4,90,'Federalist','Massachusetts');
INSERT INTO  President VALUES ('Jefferson T',1743,8,83,'Demo-Rep','Virginia');
INSERT INTO  President VALUES ('Madison J',1751,8,85,'Demo-Rep','Virginia');
INSERT INTO  President VALUES ('Monroe J',1758,8,73,'Demo-Rep','Virginia');
INSERT INTO  President VALUES ('Adams J Q',1767,4,80,'Demo-Rep','Massachusetts');
INSERT INTO  President VALUES ('Jackson A',1767,8,78,'Democratic','South Carolina');
INSERT INTO  President VALUES ('Van Buren M',1782,4,79,'Democratic','New York');
INSERT INTO  President VALUES ('Harrison W H',1773,0,68,'Whig','Virginia');
INSERT INTO  President VALUES ('Tyler J',1790,3,71,'Whig','Virginia');
INSERT INTO  President VALUES ('Polk J K',1795,4,53,'Democratic','North Carolina');
INSERT INTO  President VALUES ('Taylor Z',1784,1,65,'Whig','Virginia');
INSERT INTO  President VALUES ('Fillmore M',1800,2,74,'Whig','New York');
INSERT INTO  President VALUES ('Pierce F',1801,4,64,'Democratic','New Hampshire');
INSERT INTO  President VALUES ('Buchanan J',1791,4,77,'Democratic','Pennsylvania');
INSERT INTO  President VALUES ('Lincoln A',1809,4,56,'Republican','Kentucky');
INSERT INTO  President VALUES ('Johnson A',1808,4,66,'Democratic','North Carolina');
INSERT INTO  President VALUES ('Grant U S',1822,8,63,'Republican','Ohio');
INSERT INTO  President VALUES ('Hayes R B',1822,4,70,'Republican','Ohio');
INSERT INTO  President VALUES ('Garfield J A',1831,0,49,'Republican','Ohio');
INSERT INTO  President VALUES ('Arthur C A',1830,3,56,'Republican','Vermont');
INSERT INTO  President VALUES ('Cleveland G',1837,8,71,'Democratic','New Jersey');
INSERT INTO  President VALUES ('Harrison B',1833,4,67,'Republican','Ohio');
INSERT INTO  President VALUES ('McKinley W',1843,4,58,'Republican','Ohio');
INSERT INTO  President VALUES ('Roosevelt T',1858,7,60,'Republican','New York');
INSERT INTO  President VALUES ('Taft W H',1857,4,72,'Republican','Ohio');
INSERT INTO  President VALUES ('Wilson W',1856,8,67,'Democratic','Virginia');
INSERT INTO  President VALUES ('Harding W G',1865,2,57,'Republican','Ohio');
INSERT INTO  President VALUES ('Coolidge C',1872,5,60,'Republican','Vermont');
INSERT INTO  President VALUES ('Hoover H C',1871,4,90,'Republican','Iowa');
INSERT INTO  President VALUES ('Roosevelt F D',1882,12,63,'Democratic','New York');
INSERT INTO  President VALUES ('Truman H S',1884,7,88,'Democratic','Missouri');
INSERT INTO  President VALUES ('Eisenhower D D',1890,8,79,'Republican','Texas');
INSERT INTO  President VALUES ('Kennedy J F',1917,2,46,'Democratic','Texas');
INSERT INTO  President VALUES ('Johnson L B',1908,5,65,'Democratic','California');
INSERT INTO  President VALUES ('Nixon R M',1913,5,NULL,'Republican','Nebraska');
INSERT INTO  President VALUES ('Ford G R',1913,5,NULL,'Republican','Georgia');
INSERT INTO  President VALUES ('Carter J E',1924,4,NULL,'Democratic','Georgia');
INSERT INTO  President VALUES ('Reagan R',1911,8,NULL,'Republican','Illinois');
INSERT INTO  President VALUES ('Bush G',1924,4,NULL,'Republican','Massachusetts');
INSERT INTO  President VALUES ('Clinton W J',1946,8,NULL,'Democratic','Arkansas');


INSERT INTO  Pres_Hobby VALUES ('Adams J Q','Billards');
INSERT INTO  Pres_Hobby VALUES ('Adams J Q','Swimming');
INSERT INTO  Pres_Hobby VALUES ('Adams J Q','Walking');
INSERT INTO  Pres_Hobby VALUES ('Arthur C A','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Cleveland G','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Coolidge C','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Coolidge C','Golf');
INSERT INTO  Pres_Hobby VALUES ('Coolidge C','Indian Clubs');
INSERT INTO  Pres_Hobby VALUES ('Coolidge C','Mechanical Horse');
INSERT INTO  Pres_Hobby VALUES ('Coolidge C','Pitching Hay');
INSERT INTO  Pres_Hobby VALUES ('Eisenhower D D','Bridge');
INSERT INTO  Pres_Hobby VALUES ('Eisenhower D D','Golf');
INSERT INTO  Pres_Hobby VALUES ('Eisenhower D D','Hunting');
INSERT INTO  Pres_Hobby VALUES ('Eisenhower D D','Painting');
INSERT INTO  Pres_Hobby VALUES ('Eisenhower D D','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Garfield J A','Billards');
INSERT INTO  Pres_Hobby VALUES ('Harding W G','Golf');
INSERT INTO  Pres_Hobby VALUES ('Harding W G','Poker');
INSERT INTO  Pres_Hobby VALUES ('Harding W G','Riding');
INSERT INTO  Pres_Hobby VALUES ('Harrison B','Hunting');
INSERT INTO  Pres_Hobby VALUES ('Hayes R B','Croquet');
INSERT INTO  Pres_Hobby VALUES ('Hayes R B','Driving');
INSERT INTO  Pres_Hobby VALUES ('Hayes R B','Shooting');
INSERT INTO  Pres_Hobby VALUES ('Hoover H C','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Hoover H C','Medicine Ball');
INSERT INTO  Pres_Hobby VALUES ('Jackson A','Riding');
INSERT INTO  Pres_Hobby VALUES ('Jefferson T','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Jefferson T','Riding');
INSERT INTO  Pres_Hobby VALUES ('Johnson L B','Riding');
INSERT INTO  Pres_Hobby VALUES ('Kennedy J F','Sailing');
INSERT INTO  Pres_Hobby VALUES ('Kennedy J F','Swimming');
INSERT INTO  Pres_Hobby VALUES ('Kennedy J F','Touch Football');
INSERT INTO  Pres_Hobby VALUES ('Lincoln A','Walking');
INSERT INTO  Pres_Hobby VALUES ('McKinley W','Riding');
INSERT INTO  Pres_Hobby VALUES ('McKinley W','Swimming');
INSERT INTO  Pres_Hobby VALUES ('McKinley W','Walking');
INSERT INTO  Pres_Hobby VALUES ('Nixon R M','Golf');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt F D','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt F D','Sailing');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt F D','Swimming');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Boxing');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Hunting');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Jujitsu');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Riding');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Shooting');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Tennis');
INSERT INTO  Pres_Hobby VALUES ('Roosevelt T','Wrestling');
INSERT INTO  Pres_Hobby VALUES ('Taft W H','Golf');
INSERT INTO  Pres_Hobby VALUES ('Taft W H','Riding');
INSERT INTO  Pres_Hobby VALUES ('Taylor Z','Riding');
INSERT INTO  Pres_Hobby VALUES ('Truman H S','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Truman H S','Poker');
INSERT INTO  Pres_Hobby VALUES ('Truman H S','Walking');
INSERT INTO  Pres_Hobby VALUES ('Van Buren M','Riding');
INSERT INTO  Pres_Hobby VALUES ('Washington G','Fishing');
INSERT INTO  Pres_Hobby VALUES ('Washington G','Riding');
INSERT INTO  Pres_Hobby VALUES ('Wilson W','Golf');
INSERT INTO  Pres_Hobby VALUES ('Wilson W','Riding');
INSERT INTO  Pres_Hobby VALUES ('Wilson W','Walking');
INSERT INTO  Pres_Hobby VALUES ('Reagan R','Acting');
INSERT INTO  Pres_Hobby VALUES ('Bush G','Sailing');
INSERT INTO  Pres_Hobby VALUES ('Clinton W J','Monica');


INSERT INTO  Pres_Marriage VALUES ('Washington G','Custis M D',26,27,0,1759);
INSERT INTO  Pres_Marriage VALUES ('Adams J','Simth A',28,19,5,1764);
INSERT INTO  Pres_Marriage VALUES ('Jefferson T','Skelton M W',28,23,6,1772);
INSERT INTO  Pres_Marriage VALUES ('Madison J','Todd D D P',43,26,0,1794);
INSERT INTO  Pres_Marriage VALUES ('Monroe J','Kortright E',27,17,3,1786);
INSERT INTO  Pres_Marriage VALUES ('Adams J Q','Johnson L C',30,22,4,1797);
INSERT INTO  Pres_Marriage VALUES ('Jackson A','Robards R D',26,26,0,1794);
INSERT INTO  Pres_Marriage VALUES ('Van Buren M','Hoes H',24,23,4,1807);
INSERT INTO  Pres_Marriage VALUES ('Harrison W H','Symmos A T',22,20,10,1795);
INSERT INTO  Pres_Marriage VALUES ('Tyler J','Christian L',23,22,8,1813);
INSERT INTO  Pres_Marriage VALUES ('Tyler J','Gardiner J',54,24,7,1844);
INSERT INTO  Pres_Marriage VALUES ('Polk J K','Chidross S',28,20,0,1824);
INSERT INTO  Pres_Marriage VALUES ('Taylor Z','Smith M M',25,21,6,1810);
INSERT INTO  Pres_Marriage VALUES ('Fillmore M','Powers A',26,27,2,1826);
INSERT INTO  Pres_Marriage VALUES ('Fillmore M','McIntosh C C',58,44,0,1858);
INSERT INTO  Pres_Marriage VALUES ('Pierce F','Appleton J M',29,28,3,1834);
INSERT INTO  Pres_Marriage VALUES ('Lincoln A','Todd M',33,23,4,1842);
INSERT INTO  Pres_Marriage VALUES ('Johnson A','McCardle E',18,16,5,1827);
INSERT INTO  Pres_Marriage VALUES ('Grant U S','Dent J B',26,22,4,1848);
INSERT INTO  Pres_Marriage VALUES ('Hayes R B','Webb L W',30,21,8,1852);
INSERT INTO  Pres_Marriage VALUES ('Garfield J A','Rudolph L',26,26,7,1853);
INSERT INTO  Pres_Marriage VALUES ('Arthur C A','Horndon E L',29,22,3,1859);
INSERT INTO  Pres_Marriage VALUES ('Cleveland G','Folson F',49,21,5,1886);
INSERT INTO  Pres_Marriage VALUES ('Harrison B','Scott C L',20,21,2,1853);
INSERT INTO  Pres_Marriage VALUES ('Harrison B','Dimmick M S L',62,37,1,1896);
INSERT INTO  Pres_Marriage VALUES ('McKinley W','Saxton I',27,23,2,1871);
INSERT INTO  Pres_Marriage VALUES ('Roosevelt T','Lee A H',22,19,1,1880);
INSERT INTO  Pres_Marriage VALUES ('Roosevelt T','Carow E K',28,25,5,1886);
INSERT INTO  Pres_Marriage VALUES ('Taft W H','Horron H',28,25,3,1886);
INSERT INTO  Pres_Marriage VALUES ('Wilson W','Axson E L',28,25,3,1885);
INSERT INTO  Pres_Marriage VALUES ('Wilson W','Galt E B',58,43,0,1915);
INSERT INTO  Pres_Marriage VALUES ('Harding W G','DeWolfe F K',25,30,0,1891);
INSERT INTO  Pres_Marriage VALUES ('Coolidge C','Goodhue G A',33,26,2,1905);
INSERT INTO  Pres_Marriage VALUES ('Hoover H C','Henry L',24,23,2,1899);
INSERT INTO  Pres_Marriage VALUES ('Roosevelt F D','Roosevelt A E',23,20,6,1905);
INSERT INTO  Pres_Marriage VALUES ('Truman H S','Wallace E V',35,34,1,1918);
INSERT INTO  Pres_Marriage VALUES ('Eisenhower D D','Doud G',25,19,2,1916);
INSERT INTO  Pres_Marriage VALUES ('Kennedy J F','Bouvier J L',36,24,3,1953);
INSERT INTO  Pres_Marriage VALUES ('Johnson L B','Taylor C A',26,21,2,1934);
INSERT INTO  Pres_Marriage VALUES ('Nixon R M','Ryan T C',27,28,2,1940);
INSERT INTO  Pres_Marriage VALUES ('Ford G R','Warren E B',35,30,4,1948);
INSERT INTO  Pres_Marriage VALUES ('Carter J E','Smith R',21,18,4,1946);
INSERT INTO  Pres_Marriage VALUES ('Reagan R','Wyman J',28,25,2,1940);
INSERT INTO  Pres_Marriage VALUES ('Reagan R','Davis N',41,28,2,1952);
INSERT INTO  Pres_Marriage VALUES ('Bush G','Pierce B',20,19,5,1945);
INSERT INTO  Pres_Marriage VALUES ('Clinton W J','Rodham H',29,28,1,1975);


INSERT INTO  Election VALUES (1789,'Washington G',69,'W');
INSERT INTO  Election VALUES (1789,'Adams J',34,'L');
INSERT INTO  Election VALUES (1789,'Jay J',9,'L');
INSERT INTO  Election VALUES (1789,'Harrison R H',6,'L');
INSERT INTO  Election VALUES (1789,'Rutledge J',6,'L');
INSERT INTO  Election VALUES (1789,'Hancock J',4,'L');
INSERT INTO  Election VALUES (1789,'Clinton G',3,'L');
INSERT INTO  Election VALUES (1789,'Huntington S',2,'L');
INSERT INTO  Election VALUES (1789,'Milton J',2,'L');
INSERT INTO  Election VALUES (1789,'Armstrong J',1,'L');
INSERT INTO  Election VALUES (1789,'Lincoln B',1,'L');
INSERT INTO  Election VALUES (1789,'Telfair E',1,'L');
INSERT INTO  Election VALUES (1792,'Washington G',132,'W');
INSERT INTO  Election VALUES (1792,'Adams J',77,'L');
INSERT INTO  Election VALUES (1792,'Clinton G',50,'L');
INSERT INTO  Election VALUES (1792,'Jefferson T',4,'L');
INSERT INTO  Election VALUES (1792,'Burr A',1,'L');
INSERT INTO  Election VALUES (1796,'Adams J',71,'W');
INSERT INTO  Election VALUES (1796,'Jefferson T',68,'L');
INSERT INTO  Election VALUES (1796,'Pinckney T',59,'L');
INSERT INTO  Election VALUES (1796,'Burr A',30,'L');
INSERT INTO  Election VALUES (1796,'Adams S',15,'L');
INSERT INTO  Election VALUES (1796,'Ellsworth O',11,'L');
INSERT INTO  Election VALUES (1796,'Clinton G',7,'L');
INSERT INTO  Election VALUES (1796,'Jay J',5,'L');
INSERT INTO  Election VALUES (1796,'Iredell J',3,'L');
INSERT INTO  Election VALUES (1796,'Henry J',2,'L');
INSERT INTO  Election VALUES (1796,'Johnson S',2,'L');
INSERT INTO  Election VALUES (1796,'Washington G',2,'L');
INSERT INTO  Election VALUES (1796,'Pinckney C C',1,'L');
INSERT INTO  Election VALUES (1960,'Bird',15,'L');
INSERT INTO  Election VALUES (1964,'Johnson L B',486,'W');
INSERT INTO  Election VALUES (1964,'Goldwater B',52,'L');
INSERT INTO  Election VALUES (1968,'Nixon R M',302,'W');
INSERT INTO  Election VALUES (1968,'Humphrey H H',191,'L');
INSERT INTO  Election VALUES (1968,'Wallace G C',46,'L');
INSERT INTO  Election VALUES (1972,'Nixon R M',520,'W');
INSERT INTO  Election VALUES (1972,'McGovern G S',17,'L');
INSERT INTO  Election VALUES (1972,'Hospers J',1,'L');
INSERT INTO  Election VALUES (1976,'Carter J E',297,'W');
INSERT INTO  Election VALUES (1976,'Ford G R',240,'L');
INSERT INTO  Election VALUES (1976,'Reagan R',1,'L');
INSERT INTO  Election VALUES (1980,'Reagan R',489,'W');
INSERT INTO  Election VALUES (1980,'Carter J E',49,'L');
INSERT INTO  Election VALUES (1984,'Reagan R',525,'W');
INSERT INTO  Election VALUES (1984,'Mondale W',13,'L');
INSERT INTO  Election VALUES (1988,'Bush G',426,'W');
INSERT INTO  Election VALUES (1988,'Dukakis M',111,'L');
INSERT INTO  Election VALUES (1992,'Clinton W J',370,'W');
INSERT INTO  Election VALUES (1992,'Bush G',168,'L');
INSERT INTO  Election VALUES (1992,'Perot R',0,'L');
INSERT INTO  Election VALUES (1996,'Clinton W J',379,'W');
INSERT INTO  Election VALUES (1996,'Dole B',159,'L');
INSERT INTO  Election VALUES (1996,'Perot R',0,'L');



