load.sql

-- Initialization
DROP TABLE election;
DROP TABLE ran_in;
DROP TABLE person;
DROP TABLE prior_poll;

CREATE TABLE election (
    PRIMARY KEY (year),
    year int,
    winner varchar(40) references person(name),
    population int,
    num_voted int,
    total_electoral_votes int
);

CREATE TABLE ran_in (
    year int references election(year),
    name varchar(40) references person(name),
    party varchar(40),
    popular_votes int,
    electoral_votes int
);

CREATE TABLE prior_poll (
    year int references election(year),
    name varchar(40) references person(name),
    month varchar(40),
    percent int
);

CREATE TABLE person (
    PRIMARY KEY (name),
    name varchar(40),
    ranking int
);

-- Presidents that need to be hard coded
-- John Tyler
-- Millard Fillmore
-- Andrew Johnson
-- Chester A. Arthur
-- Gerald Ford
INSERT INTO election VALUES (1789, "George Washington", 3804342, 0, 103);
INSERT INTO ran_in VALUES (1789, "George Washington", "Federalist", 0, 69);
INSERT INTO ran_in VALUES (1789, "John Adams", "Federalist", 0, 34);
INSERT INTO election VALUES (1792, "George Washington", 4172906, 0, 259);
INSERT INTO ran_in VALUES (1792, "George Washington", "Federalist", 0, 132);
INSERT INTO ran_in VALUES (1792, "John Adams", "Federalist", 0, 77);
INSERT INTO ran_in VALUES (1792, "George Clinton", "Anti-Federalist", 0, 50);
INSERT INTO election VALUES (1796, "John Adams", 4706570, 0, 228);
INSERT INTO ran_in VALUES (1796, "John Adams", "Federalist", 0, 71);
INSERT INTO ran_in VALUES (1796, "Thomas Jefferson", "Democratic-Republican", 0, 68);
INSERT INTO ran_in VALUES (1796, "Thomas Pinckney", "Federalist", 0, 59);
INSERT INTO ran_in VALUES (1796, "Aaron Burr", "Democratic-Republican", 0, 30);
INSERT INTO election VALUES (1800, "Thomas Jefferson", 5308483, 0, 275);
INSERT INTO ran_in VALUES (1800, "Thomas Jefferson", "Democratic-Republican", 0, 73);
INSERT INTO ran_in VALUES (1800, "Aaron Burr", "Democratic-Republican", 0, 73);
INSERT INTO ran_in VALUES (1800, "John Adams", "Federalist", 0, 65);
INSERT INTO ran_in VALUES (1800, "Charles C. Pinckney", "Federalist", 0, 64);
INSERT INTO election VALUES (1804, "Thomas Jefferson", 6010005, 0, 176);
INSERT INTO ran_in VALUES (1804, "Thomas Jefferson", "Democratic-Republican", 0, 162);
INSERT INTO ran_in VALUES (1804, "Charles C. Pinckney", "Federalist", 0, 14);
INSERT INTO election VALUES (1808, "James Madison", 6804234, 0, 175);
INSERT INTO ran_in VALUES (1808, "James Madison", "Democratic-Republican", 0, 122);
INSERT INTO ran_in VALUES (1808, "Charles C. Pinckney", "Federalist", 0, 47);
INSERT INTO ran_in VALUES (1808, "George Clinton", "Democratic-Republican", 0, 6);
INSERT INTO election VALUES (1812, "James Madison", 7666314, 0, 217);
INSERT INTO ran_in VALUES (1812, "James Madison", "Democratic-Republican", 0, 128);
INSERT INTO ran_in VALUES (1812, "De Witt Clinton", "Federalist", 0, 89);
INSERT INTO election VALUES (1816, "James Monroe", 8596011, 0, 217);
INSERT INTO ran_in VALUES (1816, "James Monroe", "Democratic-Republican", 0, 183);
INSERT INTO ran_in VALUES (1816, "Rufus King", "Federalist", 0, 34);
INSERT INTO election VALUES (1820, "James Monroe", 9638453, 0, 232);
INSERT INTO ran_in VALUES (1820, "James Monroe", "Democratic-Republican", 0, 231);
INSERT INTO ran_in VALUES (1820, "John Quincy Adams", "Independent", 0, 1);
INSERT INTO election VALUES (1824, "John Quincy Adams", 10818875, 350671, 261);
INSERT INTO ran_in VALUES (1824, "Andrew Jackson", "Democratic-Republican", 153544, 99);
INSERT INTO ran_in VALUES (1824, "John Quincy Adams", "Democratic-Republican", 108740, 84);
INSERT INTO ran_in VALUES (1824, "William H. Crawford", "Democratic-Republican", 40856, 41);
INSERT INTO ran_in VALUES (1824, "Henry Clay", "Democratic-Republican", 47531, 37);
INSERT INTO election VALUES (1828, "Andrew Jackson", 12143863, 1155350, 261);
INSERT INTO ran_in VALUES (1828, "Andrew Jackson", "Democratic", 647286, 178);
INSERT INTO ran_in VALUES (1828, "John Quincy Adams", "National Republican", 508064, 83);
INSERT INTO election VALUES (1832, "Andrew Jackson", 13614425, 1318742, 286);
INSERT INTO ran_in VALUES (1832, "Andrew Jackson", "Democratic", 687502, 219);
INSERT INTO ran_in VALUES (1832, "Henry Clay", "National Republican", 530189, 49);
INSERT INTO ran_in VALUES (1832, "John Floyd", "Independent", 0, 11);
INSERT INTO ran_in VALUES (1832, "William Wirt", "Anti-Masonic", 101051, 7);
INSERT INTO election VALUES (1836, "Martin Van Buren", 15244369, 1685637, 294);
INSERT INTO ran_in VALUES (1836, "Martin Van Buren", "Democratic", 762678, 170);
INSERT INTO ran_in VALUES (1836, "William H. Harrison", "Whig", 735651, 73);
INSERT INTO ran_in VALUES (1836, "Hugh L. White", "Whig", 146107, 26);
INSERT INTO ran_in VALUES (1836, "Daniel Webster", "Whig", 41201, 14);
INSERT INTO ran_in VALUES (1836, "W.P. Mangum", "Independent", 0, 11);
INSERT INTO election VALUES (1840, "William H. Harrison", 17069453, 2404118, 294);
INSERT INTO ran_in VALUES (1840, "William H. Harrison", "Whig", 1275016, 234);
INSERT INTO ran_in VALUES (1840, "Martin Van Buren", "Democratic", 1129102, 60);
INSERT INTO election VALUES (1844, "James K. Polk", 19295948, 2636305, 275);
INSERT INTO ran_in VALUES (1844, "James K. Polk", "Democratic", 1337243, 170);
INSERT INTO ran_in VALUES (1844, "Henry Clay", "Whig", 1299062, 105);
INSERT INTO election VALUES (1848, "Zachary Taylor", 21812861, 2872144, 290);
INSERT INTO ran_in VALUES (1848, "Zachary Taylor", "Whig", 1360099, 163);
INSERT INTO ran_in VALUES (1848, "Lewis Cass", "Democratic", 1220544, 127);
INSERT INTO ran_in VALUES (1848, "Martin Van Buren", "Free Soil", 291501, 0);
INSERT INTO election VALUES (1852, "Franklin Pierce", 24647586, 3143064, 296);
INSERT INTO ran_in VALUES (1852, "Franklin Pierce", "Democratic", 1601274, 254);
INSERT INTO ran_in VALUES (1852, "Winfield Scott", "Whig", 1386580, 42);
INSERT INTO ran_in VALUES (1852, "John P. Hale", "Free Soil", 155210, 0);
INSERT INTO election VALUES (1856, "James Buchanan", 27838857, 4052433, 296);
INSERT INTO ran_in VALUES (1856, "James Buchanan", "Democratic", 1838169, 174);
INSERT INTO ran_in VALUES (1856, "John C. Fremont", "Republican", 1341264, 114);
INSERT INTO ran_in VALUES (1856, "Millard Fillmore", "American", 873000, 8);
INSERT INTO election VALUES (1860, "Abraham Lincoln", 31443321, 4690024, 303);
INSERT INTO ran_in VALUES (1860, "Abraham Lincoln", "Republican", 1866452, 180);
INSERT INTO ran_in VALUES (1860, "John C. Breckinridge", "Democratic", 847953, 72);
INSERT INTO ran_in VALUES (1860, "John Bell", "Constitutional Union", 592906, 39);
INSERT INTO ran_in VALUES (1860, "Stephen A. Douglas", "Democratic", 1382713, 12);
INSERT INTO election VALUES (1864, "Abraham Lincoln", 34116504, 4018902, 233);
INSERT INTO ran_in VALUES (1864, "Abraham Lincoln", "Republican", 2213665, 212);
INSERT INTO ran_in VALUES (1864, "George B. McClellan", "Democratic", 1805237, 21);
INSERT INTO election VALUES (1868, "Ulysses S. Grant", 37016949, 5716082, 294);
INSERT INTO ran_in VALUES (1868, "Ulysses S. Grant", "Republican", 3012833, 214);
INSERT INTO ran_in VALUES (1868, "Horatio Seymour", "Democratic", 2703249, 80);
INSERT INTO election VALUES (1872, "Ulysses S. Grant", 40645925, 6431257, 349);
INSERT INTO ran_in VALUES (1872, "Ulysses S. Grant", "Republican", 3597132, 286);
INSERT INTO ran_in VALUES (1872, "Thomas A. Hendricks", "Democratic", 0, 42);
INSERT INTO ran_in VALUES (1872, "B. Gratz Brown", "Democratic", 0, 18);
INSERT INTO ran_in VALUES (1872, "Charles J. Jenkins", "Democratic", 0, 2);
INSERT INTO ran_in VALUES (1872, "David Davis", "Democratic", 0, 1);
INSERT INTO ran_in VALUES (1872, "Horace Greeley", "Democratic", 2834125, 0);
INSERT INTO election VALUES (1876, "Rutherford B. Hayes", 45166214, 8336888, 369);
INSERT INTO ran_in VALUES (1876, "Rutherford B. Hayes", "Republican", 4036298, 185);
INSERT INTO ran_in VALUES (1876, "Samuel J. Tilden", "Democratic", 4300590, 184);
INSERT INTO election VALUES (1880, "James A. Garfield", 50189209, 8899368, 369);
INSERT INTO ran_in VALUES (1880, "James A. Garfield", "Republican", 4454416, 214);
INSERT INTO ran_in VALUES (1880, "Winfield S. Hancock", "Democratic", 4444952, 155);
INSERT INTO election VALUES (1884, "Grover Cleveland", 54959988, 9726967, 401);
INSERT INTO ran_in VALUES (1884, "Grover Cleveland", "Democratic", 4874986, 219);
INSERT INTO ran_in VALUES (1884, "James G. Blaine", "Republican", 4851981, 182);
INSERT INTO election VALUES (1888, "Benjamin Harrison", 60184258, 10980162, 401);
INSERT INTO ran_in VALUES (1888, "Benjamin Harrison", "Republican", 5439853, 233);
INSERT INTO ran_in VALUES (1888, "Grover Cleveland", "Democratic", 5540309, 168);
INSERT INTO election VALUES (1892, "Grover Cleveland", 65408007, 11760355, 444);
INSERT INTO ran_in VALUES (1892, "Grover Cleveland", "Democratic", 5556918, 277);
INSERT INTO ran_in VALUES (1892, "Benjamin Harrison", "Republican", 5176108, 145);
INSERT INTO ran_in VALUES (1892, "James B. Weaver", "People's", 1027329, 22);
INSERT INTO election VALUES (1896, "William McKinley", 70548968, 13607704, 447);
INSERT INTO ran_in VALUES (1896, "William McKinley", "Republican", 7104779, 271);
INSERT INTO ran_in VALUES (1896, "William J. Bryan", "Democrat-Populist", 6502925, 176);
INSERT INTO election VALUES (1900, "William McKinley", 76094000, 13566056, 447);
INSERT INTO ran_in VALUES (1900, "William McKinley", "Republican", 7207923, 292);
INSERT INTO ran_in VALUES (1900, "William J. Bryan", "Democrat-Populist", 6358133, 155);
INSERT INTO election VALUES (1904, "Theodore Roosevelt", 82166000, 12701397, 476);
INSERT INTO ran_in VALUES (1904, "Theodore Roosevelt", "Republican", 7623486, 336);
INSERT INTO ran_in VALUES (1904, "Alton B. Parker", "Democratic", 5077911, 140);
INSERT INTO election VALUES (1908, "William H. Taft", 88710000, 14088012, 483);
INSERT INTO ran_in VALUES (1908, "William H. Taft", "Republican", 7678908, 321);
INSERT INTO ran_in VALUES (1908, "William J. Bryan", "Democratic", 6409104, 162);
INSERT INTO election VALUES (1912, "Woodrow Wilson", 95335000, 14798134, 531);
INSERT INTO ran_in VALUES (1912, "Woodrow Wilson", "Democratic", 6293454, 435);
INSERT INTO ran_in VALUES (1912, "Theodore Roosevelt", "Progressive", 4119207, 88);
INSERT INTO ran_in VALUES (1912, "William H. Taft", "Republican", 3483922, 8);
INSERT INTO ran_in VALUES (1912, "Eugene Debs", "Socialist", 901551, 0);
INSERT INTO election VALUES (1916, "Woodrow Wilson", 101961000, 17667827, 531);
INSERT INTO ran_in VALUES (1916, "Woodrow Wilson", "Democratic", 9129606, 277);
INSERT INTO ran_in VALUES (1916, "Charles E. Hughes", "Republican", 8538221, 254);
INSERT INTO election VALUES (1920, "Warren G. Harding", 106461000, 25299553, 531);
INSERT INTO ran_in VALUES (1920, "Warren G. Harding", "Republican", 16152200, 404);
INSERT INTO ran_in VALUES (1920, "James M. Cox", "Democratic", 9147353, 127);
INSERT INTO election VALUES (1924, "Calvin Coolidge", 114109000, 28934375, 531);
INSERT INTO ran_in VALUES (1924, "Calvin Coolidge", "Republican", 15725016, 382);
INSERT INTO ran_in VALUES (1924, "John W. Davis", "Democratic", 8386503, 136);
INSERT INTO ran_in VALUES (1924, "Robert M. LaFollette", "Progressive", 4822856, 13);
INSERT INTO election VALUES (1928, "Herbert C. Hoover", 120509000, 36407824, 531);
INSERT INTO ran_in VALUES (1928, "Herbert C. Hoover", "Republican", 21391381, 444);
INSERT INTO ran_in VALUES (1928, "Alfred E. Smith", "Democratic", 15016443, 87);
INSERT INTO election VALUES (1932, "Franklin D. Roosevelt", 124840471, 38583698, 531);
INSERT INTO ran_in VALUES (1932, "Franklin D. Roosevelt", "Democratic", 22821857, 472);
INSERT INTO ran_in VALUES (1932, "Herbert C. Hoover", "Republican", 15761841, 59);
INSERT INTO election VALUES (1936, "Franklin D. Roosevelt", 128053180, 44431180, 531);
INSERT INTO ran_in VALUES (1936, "Franklin D. Roosevelt", "Democratic", 27751597, 523);
INSERT INTO ran_in VALUES (1936, "Alfred M. Landon", "Republican", 16679583, 8);
INSERT INTO prior_poll VALUES (1936, "Franklin D. Roosevelt", "August", 49);
INSERT INTO prior_poll VALUES (1936, "Alfred M. Landon", "August", 45);
INSERT INTO prior_poll VALUES (1936, "Alfred M. Landon", "September", 45);
INSERT INTO prior_poll VALUES (1936, "Franklin D. Roosevelt", "October", 51);
INSERT INTO prior_poll VALUES (1936, "Alfred M. Landon", "October", 44);
INSERT INTO prior_poll VALUES (1936, "Franklin D. Roosevelt", "September", 49);
INSERT INTO prior_poll VALUES (1936, "Franklin D. Roosevelt", "July", 49);
INSERT INTO prior_poll VALUES (1936, "Alfred M. Landon", "July", 45);
INSERT INTO election VALUES (1940, "Franklin D. Roosevelt", 132122446, 49549358, 531);
INSERT INTO ran_in VALUES (1940, "Franklin D. Roosevelt", "Democratic", 27244160, 449);
INSERT INTO ran_in VALUES (1940, "Wendell L. Willkie", "Republican", 22305198, 82);
INSERT INTO prior_poll VALUES (1940, "Franklin D. Roosevelt", "October", 50);
INSERT INTO prior_poll VALUES (1940, "Wendell L. Willkie", "October", 40);
INSERT INTO prior_poll VALUES (1940, "Franklin D. Roosevelt", "July", 48);
INSERT INTO prior_poll VALUES (1940, "Wendell L. Willkie", "July", 42);
INSERT INTO prior_poll VALUES (1940, "Franklin D. Roosevelt", "August", 45);
INSERT INTO prior_poll VALUES (1940, "Wendell L. Willkie", "August", 43);
INSERT INTO prior_poll VALUES (1940, "Franklin D. Roosevelt", "September", 49);
INSERT INTO prior_poll VALUES (1940, "Wendell L. Willkie", "September", 40);
INSERT INTO election VALUES (1944, "Franklin D. Roosevelt", 138397345, 47608789, 531);
INSERT INTO ran_in VALUES (1944, "Franklin D. Roosevelt", "Democratic", 25602504, 432);
INSERT INTO ran_in VALUES (1944, "Thomas E. Dewey", "Republican", 22006285, 99);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "March", 55);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "August", 47);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "March", 41);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "August", 42);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "September", 47);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "April", 48);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "September", 42);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "April", 46);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "October", 48);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "May", 48);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "October", 47);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "May", 47);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "November", 51);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "November", 48);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "June", 51);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "June", 45);
INSERT INTO prior_poll VALUES (1944, "Thomas E. Dewey", "July", 45);
INSERT INTO prior_poll VALUES (1944, "Franklin D. Roosevelt", "July", 46);
INSERT INTO election VALUES (1948, "Harry S. Truman", 146631302, 48401214, 531);
INSERT INTO ran_in VALUES (1948, "Harry S. Truman", "Democratic", 24105695, 303);
INSERT INTO ran_in VALUES (1948, "Thomas E. Dewey", "Republican", 21969170, 189);
INSERT INTO ran_in VALUES (1948, "J. Strom Thurmond", "States' Rights Democratic", 1169021, 39);
INSERT INTO ran_in VALUES (1948, "Henry Wallace", "Progressive", 1157328, 0);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "December ", NULL);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "December ", 46);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "December ", 41);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "December ", 7);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "February", NULL);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "February", 39);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "February", 47);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "February", 7);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "April", NULL);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "April", NULL);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "April", NULL);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "April", NULL);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "June", NULL);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "June", 38);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "June", 49);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "June", 6);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "August", 37);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "August", 48);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "August", 4);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "August", 2);
INSERT INTO prior_poll VALUES (1948, "Harry S. Truman", "October", 45);
INSERT INTO prior_poll VALUES (1948, "Thomas E. Dewey", "October", 50);
INSERT INTO prior_poll VALUES (1948, "Henry Wallace", "October", 4);
INSERT INTO prior_poll VALUES (1948, "J. Strom Thurmond", "October", 2);
INSERT INTO election VALUES (1952, "Dwight D. Eisenhower", 157552740, 61093955, 531);
INSERT INTO ran_in VALUES (1952, "Dwight D. Eisenhower", "Republican", 33778963, 442);
INSERT INTO ran_in VALUES (1952, "Adlai Stevenson", "Democratic", 27314992, 89);
INSERT INTO prior_poll VALUES (1952, "Dwight D. Eisenhower", "September", 55);
INSERT INTO prior_poll VALUES (1952, "Adlai Stevenson", "September", 40);
INSERT INTO prior_poll VALUES (1952, "Dwight D. Eisenhower", "October", 53);
INSERT INTO prior_poll VALUES (1952, "Adlai Stevenson", "October", 41);
INSERT INTO prior_poll VALUES (1952, "Dwight D. Eisenhower", "June", 59);
INSERT INTO prior_poll VALUES (1952, "Adlai Stevenson", "June", 31);
INSERT INTO prior_poll VALUES (1952, "Dwight D. Eisenhower", "July", 50);
INSERT INTO prior_poll VALUES (1952, "Adlai Stevenson", "July", 43);
INSERT INTO prior_poll VALUES (1952, "Dwight D. Eisenhower", "August", NULL);
INSERT INTO prior_poll VALUES (1952, "Adlai Stevenson", "August", NULL);
INSERT INTO election VALUES (1956, "Dwight D. Eisenhower", 168903031, 61319768, 530);
INSERT INTO ran_in VALUES (1956, "Dwight D. Eisenhower", "Republican", 35581003, 457);
INSERT INTO ran_in VALUES (1956, "Adlai Stevenson", "Democratic", 25738765, 73);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "August", 52);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "August", 41);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "October", 51);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "October", 41);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "December ", 61);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "December ", 35);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "February", 63);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "February", 33);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "April", 61);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "April", 37);
INSERT INTO prior_poll VALUES (1956, "Dwight D. Eisenhower", "June", 62);
INSERT INTO prior_poll VALUES (1956, "Adlai Stevenson", "June", 35);
INSERT INTO election VALUES (1960, "John F. Kennedy", 180671158, 68450990, 537);
INSERT INTO ran_in VALUES (1960, "John F. Kennedy", "Democratic", 34227096, 303);
INSERT INTO ran_in VALUES (1960, "Richard M. Nixon", "Republican", 34107646, 219);
INSERT INTO ran_in VALUES (1960, "Harry F. Byrd", "Democratic", 116248, 15);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "August", 44);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "August", 50);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "October", 49);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "October", 46);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "December ", 43);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "December ", 48);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "February", 48);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "February", 48);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "April", 51);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "April", 44);
INSERT INTO prior_poll VALUES (1960, "John F. Kennedy", "June", 50);
INSERT INTO prior_poll VALUES (1960, "Richard M. Nixon", "June", 46);
INSERT INTO election VALUES (1964, "Lyndon B. Johnson", 191888791, 69972432, 538);
INSERT INTO ran_in VALUES (1964, "Lyndon B. Johnson", "Democratic", 42825463, 486);
INSERT INTO ran_in VALUES (1964, "Barry M. Goldwater", "Republican", 27146969, 52);
INSERT INTO prior_poll VALUES (1964, "Barry M. Goldwater", "September", 29);
INSERT INTO prior_poll VALUES (1964, "Lyndon B. Johnson", "October", 64);
INSERT INTO prior_poll VALUES (1964, "Barry M. Goldwater", "October", 29);
INSERT INTO prior_poll VALUES (1964, "Lyndon B. Johnson", "June", 77);
INSERT INTO prior_poll VALUES (1964, "Barry M. Goldwater", "June", 18);
INSERT INTO prior_poll VALUES (1964, "Lyndon B. Johnson", "July", 62);
INSERT INTO prior_poll VALUES (1964, "Barry M. Goldwater", "July", 26);
INSERT INTO prior_poll VALUES (1964, "Lyndon B. Johnson", "August", 65);
INSERT INTO prior_poll VALUES (1964, "Barry M. Goldwater", "August", 29);
INSERT INTO prior_poll VALUES (1964, "Lyndon B. Johnson", "September", 65);
INSERT INTO election VALUES (1968, "Richard M. Nixon", 200706052, 72514998, 538);
INSERT INTO ran_in VALUES (1968, "Richard M. Nixon", "Republican", 31710470, 301);
INSERT INTO ran_in VALUES (1968, "Hubert H. Humphrey", "Democratic", 30898055, 191);
INSERT INTO ran_in VALUES (1968, "George C. Wallace", "American Independent", 9906473, 46);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "November", 15);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "April", 43);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "April", 34);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "April", 9);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "May", 39);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "May", 36);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "May", 14);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "June", 37);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "June", 42);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "June", 14);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "July", 35);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "July", 40);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "July", 16);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "August", 45);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "August", 29);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "August", 18);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "September", 43);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "September", 31);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "September", 19);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "November", 42);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "October", 44);
INSERT INTO prior_poll VALUES (1968, "Hubert H. Humphrey", "October", 36);
INSERT INTO prior_poll VALUES (1968, "George C. Wallace", "October", 15);
INSERT INTO prior_poll VALUES (1968, "Richard M. Nixon", "November", 43);
INSERT INTO election VALUES (1972, "Richard M. Nixon", 209896021, 75641921, 537);
INSERT INTO ran_in VALUES (1972, "Richard M. Nixon", "Republican", 46740323, 520);
INSERT INTO ran_in VALUES (1972, "George McGovern", "Democratic", 28901598, 17);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "September", 33);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "October", 60);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "October", 34);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "May", 53);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "November", 62);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "May", 34);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "November", 38);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "June", 53);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "June", 37);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "July", 56);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "July", 37);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "August", 57);
INSERT INTO prior_poll VALUES (1972, "George McGovern", "August", 31);
INSERT INTO prior_poll VALUES (1972, "Richard M. Nixon", "September", 61);
INSERT INTO election VALUES (1976, "Jimmy Carter", 218035164, 79973609, 537);
INSERT INTO ran_in VALUES (1976, "Jimmy Carter", "Democratic", 40825839, 297);
INSERT INTO ran_in VALUES (1976, "Gerald R. Ford", "Republican", 39147770, 240);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "June", 55);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "June", 37);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "July", 62);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "July", 29);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "August", 54);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "March", 47);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "August", 32);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "March", 42);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "September", 51);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "September", 40);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "April", 48);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "April", 43);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "October", 47);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "October", 45);
INSERT INTO prior_poll VALUES (1976, "Jimmy Carter", "May", 52);
INSERT INTO prior_poll VALUES (1976, "Gerald R. Ford", "May", 42);
INSERT INTO election VALUES (1980, "Ronald Reagan", 227224681, 86026610, 538);
INSERT INTO ran_in VALUES (1980, "Ronald Reagan", "Republican", 43901812, 489);
INSERT INTO ran_in VALUES (1980, "Jimmy Carter", "Democratic", 35483820, 49);
INSERT INTO ran_in VALUES (1980, "John Anderson", "Independent", 5719850, 0);
INSERT INTO ran_in VALUES (1980, "Ed Clark", "Libertarian", 921128, 0);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "February", 31);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "October", 40);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "February", 60);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "October", 44);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "October", 9);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "April", 34);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "April", 41);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "April", 18);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "June", 32);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "June", 39);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "December ", NULL);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "June", 21);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "August", 45);
INSERT INTO prior_poll VALUES (1980, "Ronald Reagan", "December ", 33);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "August", 29);
INSERT INTO prior_poll VALUES (1980, "Jimmy Carter", "December ", 62);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "August", 14);
INSERT INTO prior_poll VALUES (1980, "John Anderson", "February", NULL);
INSERT INTO election VALUES (1984, "Ronald Reagan", 235824902, 92032000, 538);
INSERT INTO ran_in VALUES (1984, "Ronald Reagan", "Republican", 54455000, 525);
INSERT INTO ran_in VALUES (1984, "Walter F. Mondale", "Democratic", 37577000, 13);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "October", 58);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "October", 38);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "December ", 48);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "December ", 47);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "February", 52);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "February", 42);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "April", 54);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "April", 41);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "June", 53);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "June", 44);
INSERT INTO prior_poll VALUES (1984, "Ronald Reagan", "August", 52);
INSERT INTO prior_poll VALUES (1984, "Walter F. Mondale", "August", 41);
INSERT INTO election VALUES (1988, "George Bush", 244498982, 88962000, 537);
INSERT INTO ran_in VALUES (1988, "George Bush", "Republican", 47946000, 426);
INSERT INTO ran_in VALUES (1988, "Michael S. Dukakis", "Democratic", 41016000, 111);
INSERT INTO prior_poll VALUES (1988, "George Bush", "July", 41);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "July", 47);
INSERT INTO prior_poll VALUES (1988, "George Bush", "August", 42);
INSERT INTO prior_poll VALUES (1988, "George Bush", "March", 52);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "August", 49);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "March", 40);
INSERT INTO prior_poll VALUES (1988, "George Bush", "September", 49);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "September", 41);
INSERT INTO prior_poll VALUES (1988, "George Bush", "April", 45);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "April", 43);
INSERT INTO prior_poll VALUES (1988, "George Bush", "October", 50);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "October", 40);
INSERT INTO prior_poll VALUES (1988, "George Bush", "May", 38);
INSERT INTO prior_poll VALUES (1988, "George Bush", "November", 56);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "May", 54);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "November", 44);
INSERT INTO prior_poll VALUES (1988, "George Bush", "June", 38);
INSERT INTO prior_poll VALUES (1988, "Michael S. Dukakis", "June", 52);
INSERT INTO election VALUES (1992, "William J. Clinton", 254994517, 103754418, 538);
INSERT INTO ran_in VALUES (1992, "William J. Clinton", "Democratic", 44908254, 370);
INSERT INTO ran_in VALUES (1992, "George Bush", "Republican", 39102343, 168);
INSERT INTO ran_in VALUES (1992, "Ross Perot", "Independent", 19743821, 0);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "August", NULL);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "August", 56);
INSERT INTO prior_poll VALUES (1992, "George Bush", "August", 37);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "September", NULL);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "September", 54);
INSERT INTO prior_poll VALUES (1992, "George Bush", "September", 39);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "October", 47);
INSERT INTO prior_poll VALUES (1992, "George Bush", "October", 35);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "October", 10);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "November", 49);
INSERT INTO prior_poll VALUES (1992, "George Bush", "November", 37);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "November", 14);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "March", 25);
INSERT INTO prior_poll VALUES (1992, "George Bush", "March", 44);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "March", 24);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "April", 26);
INSERT INTO prior_poll VALUES (1992, "George Bush", "April", 41);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "April", 25);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "May", 29);
INSERT INTO prior_poll VALUES (1992, "George Bush", "May", 35);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "May", 30);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "June", 25);
INSERT INTO prior_poll VALUES (1992, "George Bush", "June", 31);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "June", 39);
INSERT INTO prior_poll VALUES (1992, "Ross Perot", "July", NULL);
INSERT INTO prior_poll VALUES (1992, "William J. Clinton", "July", 40);
INSERT INTO prior_poll VALUES (1992, "George Bush", "July", 48);
INSERT INTO election VALUES (1996, "William J. Clinton", 265189794, 91492304, 538);
INSERT INTO ran_in VALUES (1996, "William J. Clinton", "Democratic", 45590703, 379);
INSERT INTO ran_in VALUES (1996, "Robert Dole", "Republican", 37816307, 159);
INSERT INTO ran_in VALUES (1996, "Ross Perot", "Reform", 8085294, 0);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "February", NULL);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "January", 43);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "January", 39);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "January", 16);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "February", NULL);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "February", NULL);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "March", 47);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "March", 34);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "March", 17);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "April", 49);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "April", 35);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "April", 15);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "May", 47);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "May", 32);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "May", 19);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "June", 49);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "June", 33);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "June", 17);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "July", 50);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "July", 33);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "July", 12);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "August", 52);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "August", 30);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "August", 12);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "September", 53);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "September", 36);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "September", 5);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "October", 53);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "October", 36);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "October", 6);
INSERT INTO prior_poll VALUES (1996, "William J. Clinton", "November", 52);
INSERT INTO prior_poll VALUES (1996, "Robert Dole", "November", 41);
INSERT INTO prior_poll VALUES (1996, "Ross Perot", "November", 7);
INSERT INTO election VALUES (2000, "George W. Bush", 282171957, 104335599, 537);
INSERT INTO ran_in VALUES (2000, "George W. Bush", "Republican", 50456062, 271);
INSERT INTO ran_in VALUES (2000, "Albert Gore, Jr.", "Democratic", 50996582, 266);
INSERT INTO ran_in VALUES (2000, "Ralph Nader", "Green", 2882955, 0);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "June", 46);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "June", 41);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "June", 6);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "July", 45);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "July", 43);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "July", 5);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "August", 54);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "August", 37);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "August", 4);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "September", 44);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "September", 47);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "September", 3);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "October", 41);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "October", 49);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "October", 2);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "November", 47);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "November", 43);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "November", 4);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "April", 47);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "April", 41);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "April", 4);
INSERT INTO prior_poll VALUES (2000, "George W. Bush", "May", NULL);
INSERT INTO prior_poll VALUES (2000, "Albert Gore, Jr.", "May", NULL);
INSERT INTO prior_poll VALUES (2000, "Ralph Nader", "May", NULL);
INSERT INTO election VALUES (2004, "George W. Bush", 293045739, 121066551, 537);
INSERT INTO ran_in VALUES (2004, "George W. Bush", "Republican", 62039073, 286);
INSERT INTO ran_in VALUES (2004, "John F. Kerry", "Democratic", 59027478, 251);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "June", 43);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "June", 49);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "July", 45);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "July", 50);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "August", 48);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "March", 44);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "August", 46);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "March", 50);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "September", 52);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "September", 45);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "April", 47);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "April", 43);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "October", 49);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "October", 49);
INSERT INTO prior_poll VALUES (2004, "George W. Bush", "May", 47);
INSERT INTO prior_poll VALUES (2004, "John F. Kerry", "May", 47);
INSERT INTO election VALUES (2008, "Barack H. Obama", 304374846, 129391711, 538);
INSERT INTO ran_in VALUES (2008, "Barack H. Obama", "Democratic", 69456897, 365);
INSERT INTO ran_in VALUES (2008, "John S. McCain", "Republican", 59934814, 173);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "September", 44);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "April", 46);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "April", 43);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "October", 52);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "May", 42);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "October", 41);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "May", 48);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "June", 48);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "June", 41);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "July", 48);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "July", 42);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "September", 49);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "August", 48);
INSERT INTO prior_poll VALUES (2008, "Barack H. Obama", "March", 46);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "August", 42);
INSERT INTO prior_poll VALUES (2008, "John S. McCain", "March", 44);
INSERT INTO election VALUES (2012, "Barack H. Obama", 312780968, 127311087, 538);
INSERT INTO ran_in VALUES (2012, "Barack H. Obama", "Democratic", 65446032, 332);
INSERT INTO ran_in VALUES (2012, "W. Mitt Romney", "Republican", 60589084, 206);
INSERT INTO ran_in VALUES (2012, "Gary Johnson", "Libertarian", 1275971, 0);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "July", 44);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "August", 47);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "August", 45);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "September", 49);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "September", 45);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "April", 45);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "April", 47);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "October", 50);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "October", 45);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "May", 44);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "November", 49);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "May", 50);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "November", 46);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "June", 47);
INSERT INTO prior_poll VALUES (2012, "W. Mitt Romney", "June", 45);
INSERT INTO prior_poll VALUES (2012, "Barack H. Obama", "July", 48);
INSERT INTO election VALUES (2016, "Donald J. Trump", 322761807, 134711696, 538);
INSERT INTO ran_in VALUES (2016, "Donald J. Trump", "Republican", 62788630, 306);
INSERT INTO ran_in VALUES (2016, "Hillary R. Clinton", "Democratic", 65435318, 232);
INSERT INTO ran_in VALUES (2016, "Gary Johnson", "Libertarian", 4453394, 0);
INSERT INTO ran_in VALUES (2016, "Jill Stein", "Green", 1426200, 0);
INSERT INTO ran_in VALUES (2016, "Evan McMullin", "Independent", 608154, 0);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "June", 35);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "June", 40);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "June", 5);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "June", 3);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "July", 37);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "July", 41);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "July", 7);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "July", 4);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "August", 38);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "August", 42);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "August", 7);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "August", 3);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "September", 38);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "September", 41);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "September", 8);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "September", 3);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "October", 39);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "October", 44);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "October", 7);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "October", 2);
INSERT INTO prior_poll VALUES (2016, "Donald J. Trump", "November", 43);
INSERT INTO prior_poll VALUES (2016, "Hillary R. Clinton", "November", 45);
INSERT INTO prior_poll VALUES (2016, "Gary Johnson", "November", 4);
INSERT INTO prior_poll VALUES (2016, "Jill Stein", "November", 2);
INSERT INTO person VALUES ("Harry S. Truman", 56);
INSERT INTO person VALUES ("Abraham Lincoln", 88);
INSERT INTO person VALUES ("Rutherford B. Hayes", 19);
INSERT INTO person VALUES ("Alfred E. Smith", NULL);
INSERT INTO person VALUES ("Thomas Jefferson", 85);
INSERT INTO person VALUES ("James Monroe", 39);
INSERT INTO person VALUES ("Robert Dole", NULL);
INSERT INTO person VALUES ("Hubert H. Humphrey", NULL);
INSERT INTO person VALUES ("James G. Blaine", NULL);
INSERT INTO person VALUES ("Ronald Reagan", 50);
INSERT INTO person VALUES ("Stephen A. Douglas", NULL);
INSERT INTO person VALUES ("William Wirt", NULL);
INSERT INTO person VALUES ("John F. Kennedy", 67);
INSERT INTO person VALUES ("Henry Clay", NULL);
INSERT INTO person VALUES ("John Quincy Adams", 52);
INSERT INTO person VALUES ("James Buchanan", -4);
INSERT INTO person VALUES ("Zachary Taylor", 8);
INSERT INTO person VALUES ("Winfield Scott", NULL);
INSERT INTO person VALUES ("Gerald Ford", 36);
INSERT INTO person VALUES ("W.P. Mangum", NULL);
INSERT INTO person VALUES ("Gerald R. Ford", NULL);
INSERT INTO person VALUES ("Barack H. Obama", NULL);
INSERT INTO person VALUES ("James A. Garfield", 26);
INSERT INTO person VALUES ("Warren G. Harding", -4);
INSERT INTO person VALUES ("Dwight D. Eisenhower", 57);
INSERT INTO person VALUES ("B. Gratz Brown", NULL);
INSERT INTO person VALUES ("Walter F. Mondale", NULL);
INSERT INTO person VALUES ("Charles C. Pinckney", NULL);
INSERT INTO person VALUES ("Theodore Roosevelt", 76);
INSERT INTO person VALUES ("Richard M. Nixon", -28);
INSERT INTO person VALUES ("Adlai Stevenson", NULL);
INSERT INTO person VALUES ("James M. Cox", NULL);
INSERT INTO person VALUES ("John C. Breckinridge", NULL);
INSERT INTO person VALUES ("Ed Clark", NULL);
INSERT INTO person VALUES ("Grover Cleveland", 14);
INSERT INTO person VALUES ("George Bush", 16);
INSERT INTO person VALUES ("Martin Van Buren", 4);
INSERT INTO person VALUES ("Michael S. Dukakis", NULL);
INSERT INTO person VALUES ("George McGovern", NULL);
INSERT INTO person VALUES ("Evan McMullin", NULL);
INSERT INTO person VALUES ("Andrew Jackson", 55);
INSERT INTO person VALUES ("Thomas E. Dewey", NULL);
INSERT INTO person VALUES ("Barry M. Goldwater", NULL);
INSERT INTO person VALUES ("Charles E. Hughes", NULL);
INSERT INTO person VALUES ("Franklin Pierce", -8);
INSERT INTO person VALUES ("James B. Weaver", NULL);
INSERT INTO person VALUES ("J. Strom Thurmond", NULL);
INSERT INTO person VALUES ("Alton B. Parker", NULL);
INSERT INTO person VALUES ("Benjamin Harrison", -5);
INSERT INTO person VALUES ("John C. Fremont", NULL);
INSERT INTO person VALUES ("Alfred M. Landon", NULL);
INSERT INTO person VALUES ("Calvin Coolidge", 7);
INSERT INTO person VALUES ("Lyndon B. Johnson", 3);
INSERT INTO person VALUES ("William J. Bryan", NULL);
INSERT INTO person VALUES ("Albert Gore, Jr.", NULL);
INSERT INTO person VALUES ("Henry Wallace", NULL);
INSERT INTO person VALUES ("Franklin D. Roosevelt", 69);
INSERT INTO person VALUES ("John S. McCain", NULL);
INSERT INTO person VALUES ("Wendell L. Willkie", NULL);
INSERT INTO person VALUES ("Daniel Webster", NULL);
INSERT INTO person VALUES ("George C. Wallace", NULL);
INSERT INTO person VALUES ("Ross Perot", NULL);
INSERT INTO person VALUES ("Herbert C. Hoover", 14);
INSERT INTO person VALUES ("Jimmy Carter", 23);
INSERT INTO person VALUES ("Ralph Nader", NULL);
INSERT INTO person VALUES ("Robert M. LaFollette", NULL);
INSERT INTO person VALUES ("James Madison", 65);
INSERT INTO person VALUES ("Aaron Burr", NULL);
INSERT INTO person VALUES ("George W. Bush", -18);
INSERT INTO person VALUES ("John Adams", 65);
INSERT INTO person VALUES ("Gary Johnson", NULL);
INSERT INTO person VALUES ("John Floyd", NULL);
INSERT INTO person VALUES ("John F. Kerry", NULL);
INSERT INTO person VALUES ("Jill Stein", NULL);
INSERT INTO person VALUES ("Andrew Johnson", 19);
INSERT INTO person VALUES ("John Tyler", -6);
INSERT INTO person VALUES ("William H. Crawford", NULL);
INSERT INTO person VALUES ("Samuel J. Tilden", NULL);
INSERT INTO person VALUES ("William J. Clinton", 14);
INSERT INTO person VALUES ("William H. Taft", 42);
INSERT INTO person VALUES ("George Washington", 92);
INSERT INTO person VALUES ("Horace Greeley", NULL);
INSERT INTO person VALUES ("De Witt Clinton", NULL);
INSERT INTO person VALUES ("John W. Davis", NULL);
INSERT INTO person VALUES ("John Bell", NULL);
INSERT INTO person VALUES ("Horatio Seymour", NULL);
INSERT INTO person VALUES ("Hillary R. Clinton", NULL);
INSERT INTO person VALUES ("W. Mitt Romney", NULL);
INSERT INTO person VALUES ("William H. Harrison", 5);
INSERT INTO person VALUES ("Millard Fillmore", -8);
INSERT INTO person VALUES ("Lewis Cass", NULL);
INSERT INTO person VALUES ("Rufus King", NULL);
INSERT INTO person VALUES ("Eugene Debs", NULL);
INSERT INTO person VALUES ("David Davis", NULL);
INSERT INTO person VALUES ("Hugh L. White", NULL);
INSERT INTO person VALUES ("Donald J. Trump", NULL);
INSERT INTO person VALUES ("Thomas A. Hendricks", NULL);
INSERT INTO person VALUES ("Charles J. Jenkins", NULL);
INSERT INTO person VALUES ("Winfield S. Hancock", NULL);
INSERT INTO person VALUES ("Woodrow Wilson", 37);
INSERT INTO person VALUES ("William McKinley", 18);
INSERT INTO person VALUES ("George B. McClellan", NULL);
INSERT INTO person VALUES ("Thomas Pinckney", NULL);
INSERT INTO person VALUES ("Chester A. Arthur", 26);
INSERT INTO person VALUES ("Harry F. Byrd", NULL);
INSERT INTO person VALUES ("John Anderson", NULL);
INSERT INTO person VALUES ("John P. Hale", NULL);
INSERT INTO person VALUES ("Ulysses S. Grant", 34);
INSERT INTO person VALUES ("James K. Polk", 6);
INSERT INTO person VALUES ("George Clinton", NULL);