Nobel Table

yrsubjectwinner

1960

Chemistry

Willard F. Libby

1960

Literature

Saint-John Perse

1960

Medicine

Sir Frank Macfarlane Burnet

1960

Medicine

Peter Medawar

1960

Physics

Donald A. Glaser

1960

Peace

Albert Lutuli

...

(For Database version scroll to the end of the page: Nobel Table - PostgreSQL)

  1. Change the query shown so that it displays Nobel prizes for 1950.

SELECT * FROM nobel WHERE yr = 1950

  1. Show who won the 1962 prize for literature.

SELECT winner FROM nobel WHERE yr = 1962 AND subject = 'Literature'

  1. Show the year and subject that won 'Albert Einstein' his prize.

SELECT yr FROM nobel WHERE winner = 'Albert Einstein'

  1. Give the name of the 'peace' winners since the year 2000, including 2000.

SELECT winner 
FROM nobel 
WHERE LOWER(subject) = 'peace' AND yr >= 2000

  1. Show all details (yr, subject, winner) of the literature prize winners for 1980 to 1989 inclusive. 

SELECT yr, subject, winner 
FROM nobel 
WHERE LOWER(subject) = 'literature' 
AND yr BETWEEN 1980 AND 1989

  1. Show all details of the presidential winners:

  • Theodore Roosevelt

  • Thomas Woodrow Wilson

  • Jimmy Carter

  • Barack Obama

SELECT *
FROM nobel 
WHERE winner IN ('Theodore Roosevelt','Thomas Woodrow Wilson',
'Jimmy Carter','Barack Obama')

  1. Show the winners with first name John

SELECT *
FROM nobel 
WHERE winner LIKE 'John%'

  1. Show the year, subject, and name of physics winners for 1980 together with the chemistry winners for 1984.

SELECT yr, subject, winner 
FROM nobel 
WHERE (LOWER(subject) = 'physics' AND yr = 1980)
OR (LOWER(subject) = 'chemistry' AND yr = 1984)

  1. Show the year, subject, and name of winners for 1980 excluding chemistry and medicine

SELECT yr, subject, winner 
FROM nobel 
WHERE yr = 1980 
AND LOWER(subject) NOT IN ('chemistry', 'medicine')

  1. Show year, subject, and name of people who won a 'Medicine' prize in an early year (before 1910, not including 1910) together with winners of a 'Literature' prize in a later year (after 2004, including 2004)

SELECT yr, subject, winner 
FROM nobel 
WHERE (yr < 1910 AND subject = 'Medicine') 
OR (yr >= 2004 AND subject = 'Literature')

  1. Find all details of the prize won by PETER GRÜNBERG The u in his name has an umlaut. You may find this link useful https://en.wikipedia.org/wiki/%C3%9C#Keyboarding

SELECT yr, subject, winner 
FROM nobel 
WHERE winner LIKE 'PETER GR_NBERG'

  1. Find all details of the prize won by EUGENE O'NEILL

SELECT yr, subject, winner 
FROM nobel 
WHERE winner = 'EUGENE O''NEILL'

  1. Knights in order. List the winners, year and subject where the winner starts with Sir. Show the the most recent first, then by name order.

SELECT winner, yr, subject  
FROM nobel 
WHERE winner LIKE 'Sir%'
ORDER BY yr DESC, winner

  1. The expression subject IN ('chemistry','physics') can be used as a value - it will be 0 or 1. Show the 1984 winners and subject ordered by and winner name; but list chemistry and physics last.

SELECT winner, subject
FROM nobel
WHERE yr = 1984 
ORDER BY subject IN ('Chemistry', 'Physics') ASC, subject, winner

Nobel Table - PostgreSQL

1901 - 2019 (sqlzoo.net version ends in 2017)

CREATE TABLE IF NOT EXISTS nobel (
    yr INTEGER, 
    subject VARCHAR(255), 
    winner TEXT );

INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Chemistry', 'Jacobus H. van ''t Hoff');
INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Literature', 'Sully Prudhomme');
INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Peace', 'Frédéric Passy');
INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Medicine', 'Emil von Behring');
INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Physics', 'Wilhelm Conrad Röntgen');
INSERT INTO nobel (yr, subject, winner) VALUES (1901, 'Peace', 'Henry Dunant');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Peace', 'Albert Gobat');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Physics', 'Pieter Zeeman');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Chemistry', 'Emil Fischer');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Literature', 'Theodor Mommsen');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Physics', 'Hendrik A. Lorentz');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Medicine', 'Ronald Ross');
INSERT INTO nobel (yr, subject, winner) VALUES (1902, 'Peace', 'Élie Ducommun');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Literature', 'Bjørnstjerne Bjørnson');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Physics', 'Marie Curie');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Chemistry', 'Svante Arrhenius');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Physics', 'Henri Becquerel');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Medicine', 'Niels Ryberg Finsen');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Peace', 'Randal Cremer');
INSERT INTO nobel (yr, subject, winner) VALUES (1903, 'Physics', 'Pierre Curie');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Literature', 'José Echegaray');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Literature', 'Frédéric Mistral');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Medicine', 'Ivan Pavlov');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Chemistry', 'Sir William Ramsay');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Physics', 'Lord Rayleigh');
INSERT INTO nobel (yr, subject, winner) VALUES (1904, 'Peace', 'Institute of International Law');
INSERT INTO nobel (yr, subject, winner) VALUES (1905, 'Physics', 'Philipp Lenard');
INSERT INTO nobel (yr, subject, winner) VALUES (1905, 'Peace', 'Bertha von Suttner');
INSERT INTO nobel (yr, subject, winner) VALUES (1905, 'Literature', 'Henryk Sienkiewicz');
INSERT INTO nobel (yr, subject, winner) VALUES (1905, 'Chemistry', 'Adolf von Baeyer');
INSERT INTO nobel (yr, subject, winner) VALUES (1905, 'Medicine', 'Robert Koch');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Medicine', 'Santiago Ramón y Cajal');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Physics', 'J.J. Thomson');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Peace', 'Theodore Roosevelt');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Chemistry', 'Henri Moissan');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Medicine', 'Camillo Golgi');
INSERT INTO nobel (yr, subject, winner) VALUES (1906, 'Literature', 'Giosuè Carducci');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Literature', 'Rudyard Kipling');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Physics', 'Albert A. Michelson');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Medicine', 'Alphonse Laveran');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Peace', 'Ernesto Teodoro Moneta');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Peace', 'Louis Renault');
INSERT INTO nobel (yr, subject, winner) VALUES (1907, 'Chemistry', 'Eduard Buchner');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Medicine', 'Paul Ehrlich');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Medicine', 'Ilya Mechnikov');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Peace', 'Klas Pontus Arnoldson');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Literature', 'Rudolf Eucken');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Physics', 'Gabriel Lippmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Peace', 'Fredrik Bajer');
INSERT INTO nobel (yr, subject, winner) VALUES (1908, 'Chemistry', 'Ernest Rutherford');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Peace', 'Paul Henri d''Estournelles de Constant');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Literature', 'Selma Lagerlöf');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Chemistry', 'Wilhelm Ostwald');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Physics', 'Guglielmo Marconi');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Medicine', 'Theodor Kocher');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Physics', 'Ferdinand Braun');
INSERT INTO nobel (yr, subject, winner) VALUES (1909, 'Peace', 'Auguste Beernaert');
INSERT INTO nobel (yr, subject, winner) VALUES (1910, 'Physics', 'Johannes Diderik van der Waals');
INSERT INTO nobel (yr, subject, winner) VALUES (1910, 'Medicine', 'Albrecht Kossel');
INSERT INTO nobel (yr, subject, winner) VALUES (1910, 'Chemistry', 'Otto Wallach');
INSERT INTO nobel (yr, subject, winner) VALUES (1910, 'Peace', 'Permanent International Peace Bureau');
INSERT INTO nobel (yr, subject, winner) VALUES (1910, 'Literature', 'Paul Heyse');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Physics', 'Wilhelm Wien');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Literature', 'Maurice Maeterlinck');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Medicine', 'Allvar Gullstrand');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Peace', 'Tobias Asser');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Chemistry', 'Marie Curie');
INSERT INTO nobel (yr, subject, winner) VALUES (1911, 'Peace', 'Alfred Fried');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Chemistry', 'Victor Grignard');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Peace', 'Elihu Root');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Chemistry', 'Paul Sabatier');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Physics', 'Gustaf Dalén');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Medicine', 'Alexis Carrel');
INSERT INTO nobel (yr, subject, winner) VALUES (1912, 'Literature', 'Gerhart Hauptmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1913, 'Peace', 'Henri La Fontaine');
INSERT INTO nobel (yr, subject, winner) VALUES (1913, 'Literature', 'Rabindranath Tagore');
INSERT INTO nobel (yr, subject, winner) VALUES (1913, 'Physics', 'Heike Kamerlingh Onnes');
INSERT INTO nobel (yr, subject, winner) VALUES (1913, 'Medicine', 'Charles Richet');
INSERT INTO nobel (yr, subject, winner) VALUES (1913, 'Chemistry', 'Alfred Werner');
INSERT INTO nobel (yr, subject, winner) VALUES (1914, 'Chemistry', 'Theodore W. Richards');
INSERT INTO nobel (yr, subject, winner) VALUES (1914, 'Medicine', 'Robert Bárány');
INSERT INTO nobel (yr, subject, winner) VALUES (1914, 'Physics', 'Max von Laue');
INSERT INTO nobel (yr, subject, winner) VALUES (1915, 'Physics', 'Lawrence Bragg');
INSERT INTO nobel (yr, subject, winner) VALUES (1915, 'Literature', 'Romain Rolland');
INSERT INTO nobel (yr, subject, winner) VALUES (1915, 'Physics', 'William Bragg');
INSERT INTO nobel (yr, subject, winner) VALUES (1915, 'Chemistry', 'Richard Willstätter');
INSERT INTO nobel (yr, subject, winner) VALUES (1916, 'Literature', 'Verner von Heidenstam');
INSERT INTO nobel (yr, subject, winner) VALUES (1917, 'Physics', 'Charles Glover Barkla');
INSERT INTO nobel (yr, subject, winner) VALUES (1917, 'Peace', 'International Committee of the Red Cross');
INSERT INTO nobel (yr, subject, winner) VALUES (1917, 'Literature', 'Henrik Pontoppidan');
INSERT INTO nobel (yr, subject, winner) VALUES (1917, 'Literature', 'Karl Gjellerup');
INSERT INTO nobel (yr, subject, winner) VALUES (1918, 'Chemistry', 'Fritz Haber');
INSERT INTO nobel (yr, subject, winner) VALUES (1918, 'Physics', 'Max Planck');
INSERT INTO nobel (yr, subject, winner) VALUES (1919, 'Physics', 'Johannes Stark');
INSERT INTO nobel (yr, subject, winner) VALUES (1919, 'Literature', 'Carl Spitteler');
INSERT INTO nobel (yr, subject, winner) VALUES (1919, 'Peace', 'Woodrow Wilson');
INSERT INTO nobel (yr, subject, winner) VALUES (1919, 'Medicine', 'Jules Bordet');
INSERT INTO nobel (yr, subject, winner) VALUES (1920, 'Physics', 'Charles Edouard Guillaume');
INSERT INTO nobel (yr, subject, winner) VALUES (1920, 'Medicine', 'August Krogh');
INSERT INTO nobel (yr, subject, winner) VALUES (1920, 'Peace', 'Léon Bourgeois');
INSERT INTO nobel (yr, subject, winner) VALUES (1920, 'Literature', 'Knut Hamsun');
INSERT INTO nobel (yr, subject, winner) VALUES (1920, 'Chemistry', 'Walther Nernst');
INSERT INTO nobel (yr, subject, winner) VALUES (1921, 'Peace', 'Hjalmar Branting');
INSERT INTO nobel (yr, subject, winner) VALUES (1921, 'Chemistry', 'Frederick Soddy');
INSERT INTO nobel (yr, subject, winner) VALUES (1921, 'Physics', 'Albert Einstein');
INSERT INTO nobel (yr, subject, winner) VALUES (1921, 'Literature', 'Anatole France');
INSERT INTO nobel (yr, subject, winner) VALUES (1921, 'Peace', 'Christian Lange');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Medicine', 'Archibald V. Hill');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Medicine', 'Otto Meyerhof');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Literature', 'Jacinto Benavente');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Chemistry', 'Francis W. Aston');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Physics', 'Niels Bohr');
INSERT INTO nobel (yr, subject, winner) VALUES (1922, 'Peace', 'Fridtjof Nansen');
INSERT INTO nobel (yr, subject, winner) VALUES (1923, 'Literature', 'William Butler Yeats');
INSERT INTO nobel (yr, subject, winner) VALUES (1923, 'Chemistry', 'Fritz Pregl');
INSERT INTO nobel (yr, subject, winner) VALUES (1923, 'Medicine', 'Frederick G. Banting');
INSERT INTO nobel (yr, subject, winner) VALUES (1923, 'Medicine', 'John Macleod');
INSERT INTO nobel (yr, subject, winner) VALUES (1923, 'Physics', 'Robert A. Millikan');
INSERT INTO nobel (yr, subject, winner) VALUES (1924, 'Literature', 'Wladyslaw Reymont');
INSERT INTO nobel (yr, subject, winner) VALUES (1924, 'Physics', 'Manne Siegbahn');
INSERT INTO nobel (yr, subject, winner) VALUES (1924, 'Medicine', 'Willem Einthoven');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Peace', 'Charles G. Dawes');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Physics', 'James Franck');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Chemistry', 'Richard Zsigmondy');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Literature', 'George Bernard Shaw');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Physics', 'Gustav Hertz');
INSERT INTO nobel (yr, subject, winner) VALUES (1925, 'Peace', 'Sir Austen Chamberlain');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Peace', 'Gustav Stresemann');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Chemistry', 'The Svedberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Medicine', 'Johannes Fibiger');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Peace', 'Aristide Briand');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Literature', 'Grazia Deledda');
INSERT INTO nobel (yr, subject, winner) VALUES (1926, 'Physics', 'Jean Baptiste Perrin');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Chemistry', 'Heinrich Wieland');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Peace', 'Ludwig Quidde');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Medicine', 'Julius Wagner-Jauregg');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Physics', 'Arthur H. Compton');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Physics', 'C.T.R. Wilson');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Literature', 'Henri Bergson');
INSERT INTO nobel (yr, subject, winner) VALUES (1927, 'Peace', 'Ferdinand Buisson');
INSERT INTO nobel (yr, subject, winner) VALUES (1928, 'Chemistry', 'Adolf Windaus');
INSERT INTO nobel (yr, subject, winner) VALUES (1928, 'Medicine', 'Charles Nicolle');
INSERT INTO nobel (yr, subject, winner) VALUES (1928, 'Literature', 'Sigrid Undset');
INSERT INTO nobel (yr, subject, winner) VALUES (1928, 'Physics', 'Owen Willans Richardson');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Medicine', 'Christiaan Eijkman');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Chemistry', 'Hans von Euler-Chelpin');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Medicine', 'Sir Frederick Hopkins');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Peace', 'Frank B. Kellogg');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Physics', 'Louis de Broglie');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Chemistry', 'Arthur Harden');
INSERT INTO nobel (yr, subject, winner) VALUES (1929, 'Literature', 'Thomas Mann');
INSERT INTO nobel (yr, subject, winner) VALUES (1930, 'Medicine', 'Karl Landsteiner');
INSERT INTO nobel (yr, subject, winner) VALUES (1930, 'Peace', 'Nathan Söderblom');
INSERT INTO nobel (yr, subject, winner) VALUES (1930, 'Chemistry', 'Hans Fischer');
INSERT INTO nobel (yr, subject, winner) VALUES (1930, 'Physics', 'Sir Chandrasekhara Venkata Raman');
INSERT INTO nobel (yr, subject, winner) VALUES (1930, 'Literature', 'Sinclair Lewis');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Chemistry', 'Carl Bosch');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Peace', 'Jane Addams');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Chemistry', 'Friedrich Bergius');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Peace', 'Nicholas Murray Butler');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Literature', 'Erik Axel Karlfeldt');
INSERT INTO nobel (yr, subject, winner) VALUES (1931, 'Medicine', 'Otto Warburg');
INSERT INTO nobel (yr, subject, winner) VALUES (1932, 'Medicine', 'Edgar Adrian');
INSERT INTO nobel (yr, subject, winner) VALUES (1932, 'Medicine', 'Sir Charles Sherrington');
INSERT INTO nobel (yr, subject, winner) VALUES (1932, 'Chemistry', 'Irving Langmuir');
INSERT INTO nobel (yr, subject, winner) VALUES (1932, 'Physics', 'Werner Heisenberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1932, 'Literature', 'John Galsworthy');
INSERT INTO nobel (yr, subject, winner) VALUES (1933, 'Medicine', 'Thomas H. Morgan');
INSERT INTO nobel (yr, subject, winner) VALUES (1933, 'Physics', 'Paul A.M. Dirac');
INSERT INTO nobel (yr, subject, winner) VALUES (1933, 'Peace', 'Sir Norman Angell');
INSERT INTO nobel (yr, subject, winner) VALUES (1933, 'Literature', 'Ivan Bunin');
INSERT INTO nobel (yr, subject, winner) VALUES (1933, 'Physics', 'Erwin Schrödinger');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Peace', 'Arthur Henderson');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Medicine', 'William P. Murphy');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Chemistry', 'Harold C. Urey');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Medicine', 'George H. Whipple');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Literature', 'Luigi Pirandello');
INSERT INTO nobel (yr, subject, winner) VALUES (1934, 'Medicine', 'George R. Minot');
INSERT INTO nobel (yr, subject, winner) VALUES (1935, 'Chemistry', 'Frédéric Joliot');
INSERT INTO nobel (yr, subject, winner) VALUES (1935, 'Peace', 'Carl von Ossietzky');
INSERT INTO nobel (yr, subject, winner) VALUES (1935, 'Physics', 'James Chadwick');
INSERT INTO nobel (yr, subject, winner) VALUES (1935, 'Chemistry', 'Irène Joliot-Curie');
INSERT INTO nobel (yr, subject, winner) VALUES (1935, 'Medicine', 'Hans Spemann');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Literature', 'Eugene O''Neill');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Physics', 'Victor F. Hess');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Medicine', 'Sir Henry Dale');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Chemistry', 'Peter Debye');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Physics', 'Carl D. Anderson');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Medicine', 'Otto Loewi');
INSERT INTO nobel (yr, subject, winner) VALUES (1936, 'Peace', 'Carlos Saavedra Lamas');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Chemistry', 'Norman Haworth');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Peace', 'Robert Cecil, Viscount Cecil of Chelwood');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Literature', 'Roger Martin du Gard');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Physics', 'Clinton Davisson');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Chemistry', 'Paul Karrer');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Medicine', 'Albert Szent-Györgyi');
INSERT INTO nobel (yr, subject, winner) VALUES (1937, 'Physics', 'George Paget Thomson');
INSERT INTO nobel (yr, subject, winner) VALUES (1938, 'Peace', 'Nansen International Office for Refugees');
INSERT INTO nobel (yr, subject, winner) VALUES (1938, 'Literature', 'Pearl Buck');
INSERT INTO nobel (yr, subject, winner) VALUES (1938, 'Chemistry', 'Richard Kuhn');
INSERT INTO nobel (yr, subject, winner) VALUES (1938, 'Physics', 'Enrico Fermi');
INSERT INTO nobel (yr, subject, winner) VALUES (1938, 'Medicine', 'Corneille Heymans');
INSERT INTO nobel (yr, subject, winner) VALUES (1939, 'Physics', 'Ernest Lawrence');
INSERT INTO nobel (yr, subject, winner) VALUES (1939, 'Medicine', 'Gerhard Domagk');
INSERT INTO nobel (yr, subject, winner) VALUES (1939, 'Chemistry', 'Leopold Ruzicka');
INSERT INTO nobel (yr, subject, winner) VALUES (1939, 'Chemistry', 'Adolf Butenandt');
INSERT INTO nobel (yr, subject, winner) VALUES (1939, 'Literature', 'Frans Eemil Sillanpää');
INSERT INTO nobel (yr, subject, winner) VALUES (1943, 'Medicine', 'Henrik Dam');
INSERT INTO nobel (yr, subject, winner) VALUES (1943, 'Physics', 'Otto Stern');
INSERT INTO nobel (yr, subject, winner) VALUES (1943, 'Chemistry', 'George de Hevesy');
INSERT INTO nobel (yr, subject, winner) VALUES (1943, 'Medicine', 'Edward A. Doisy');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Medicine', 'Joseph Erlanger');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Physics', 'Isidor Isaac Rabi');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Chemistry', 'Otto Hahn');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Medicine', 'Herbert S. Gasser');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Literature', 'Johannes V. Jensen');
INSERT INTO nobel (yr, subject, winner) VALUES (1944, 'Peace', 'International Committee of the Red Cross');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Chemistry', 'Artturi Virtanen');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Literature', 'Gabriela Mistral');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Peace', 'Cordell Hull');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Medicine', 'Ernst B. Chain');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Medicine', 'Sir Alexander Fleming');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Physics', 'Wolfgang Pauli');
INSERT INTO nobel (yr, subject, winner) VALUES (1945, 'Medicine', 'Sir Howard Florey');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Chemistry', 'James B. Sumner');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Physics', 'Percy W. Bridgman');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Medicine', 'Hermann J. Muller');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Peace', 'John R. Mott');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Chemistry', 'John H. Northrop');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Chemistry', 'Wendell M. Stanley');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Peace', 'Emily Greene Balch');
INSERT INTO nobel (yr, subject, winner) VALUES (1946, 'Literature', 'Hermann Hesse');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Peace', 'Friends Service Council');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Literature', 'André Gide');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Chemistry', 'Sir Robert Robinson');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Medicine', 'Bernardo Houssay');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Medicine', 'Gerty Cori');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Medicine', 'Carl Cori');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Peace', 'American Friends Service Committee');
INSERT INTO nobel (yr, subject, winner) VALUES (1947, 'Physics', 'Edward V. Appleton');
INSERT INTO nobel (yr, subject, winner) VALUES (1948, 'Medicine', 'Paul Müller');
INSERT INTO nobel (yr, subject, winner) VALUES (1948, 'Literature', 'T.S. Eliot');
INSERT INTO nobel (yr, subject, winner) VALUES (1948, 'Chemistry', 'Arne Tiselius');
INSERT INTO nobel (yr, subject, winner) VALUES (1948, 'Physics', 'Patrick M.S. Blackett');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Medicine', 'Walter Hess');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Literature', 'William Faulkner');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Physics', 'Hideki Yukawa');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Chemistry', 'William F. Giauque');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Peace', 'Lord Boyd Orr');
INSERT INTO nobel (yr, subject, winner) VALUES (1949, 'Medicine', 'Egas Moniz');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Literature', 'Bertrand Russell');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Peace', 'Ralph Bunche');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Medicine', 'Philip S. Hench');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Physics', 'Cecil Powell');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Chemistry', 'Kurt Alder');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Medicine', 'Tadeus Reichstein');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Medicine', 'Edward C. Kendall');
INSERT INTO nobel (yr, subject, winner) VALUES (1950, 'Chemistry', 'Otto Diels');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Physics', 'John Cockcroft');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Peace', 'Léon Jouhaux');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Chemistry', 'Glenn T. Seaborg');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Chemistry', 'Edwin M. McMillan');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Literature', 'Pär Lagerkvist');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Medicine', 'Max Theiler');
INSERT INTO nobel (yr, subject, winner) VALUES (1951, 'Physics', 'Ernest T.S. Walton');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Literature', 'François Mauriac');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Chemistry', 'Richard L.M. Synge');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Physics', 'Felix Bloch');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Peace', 'Albert Schweitzer');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Medicine', 'Selman A. Waksman');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Chemistry', 'Archer J.P. Martin');
INSERT INTO nobel (yr, subject, winner) VALUES (1952, 'Physics', 'E. M. Purcell');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Peace', 'George C. Marshall');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Medicine', 'Hans Krebs');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Physics', 'Frits Zernike');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Medicine', 'Fritz Lipmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Literature', 'Winston Churchill');
INSERT INTO nobel (yr, subject, winner) VALUES (1953, 'Chemistry', 'Hermann Staudinger');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Chemistry', 'Linus Pauling');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Medicine', 'Thomas H. Weller');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Medicine', 'John F. Enders');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Physics', 'Walther Bothe');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Peace', 'Office of the United Nations High Commissioner for Refugees');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Physics', 'Max Born');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Medicine', 'Frederick C. Robbins');
INSERT INTO nobel (yr, subject, winner) VALUES (1954, 'Literature', 'Ernest Hemingway');
INSERT INTO nobel (yr, subject, winner) VALUES (1955, 'Physics', 'Willis E. Lamb');
INSERT INTO nobel (yr, subject, winner) VALUES (1955, 'Literature', 'Halldór Laxness');
INSERT INTO nobel (yr, subject, winner) VALUES (1955, 'Physics', 'Polykarp Kusch');
INSERT INTO nobel (yr, subject, winner) VALUES (1955, 'Chemistry', 'Vincent du Vigneaud');
INSERT INTO nobel (yr, subject, winner) VALUES (1955, 'Medicine', 'Hugo Theorell');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Physics', 'William B. Shockley');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Medicine', 'Werner Forssmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Medicine', 'Dickinson W. Richards');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Physics', 'Walter H. Brattain');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Chemistry', 'Nikolay Semenov');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Chemistry', 'Sir Cyril Hinshelwood');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Literature', 'Juan Ramón Jiménez');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Physics', 'John Bardeen');
INSERT INTO nobel (yr, subject, winner) VALUES (1956, 'Medicine', 'André F. Cournand');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Physics', 'Chen Ning Yang');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Chemistry', 'Lord Todd');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Medicine', 'Daniel Bovet');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Literature', 'Albert Camus');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Peace', 'Lester Bowles Pearson');
INSERT INTO nobel (yr, subject, winner) VALUES (1957, 'Physics', 'Tsung-Dao Lee');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Physics', 'Pavel A. Cherenkov');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Medicine', 'Joshua Lederberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Medicine', 'Edward Tatum');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Literature', 'Boris Pasternak');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Peace', 'Georges Pire');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Physics', 'Il´ja M. Frank');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Chemistry', 'Frederick Sanger');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Physics', 'Igor Y. Tamm');
INSERT INTO nobel (yr, subject, winner) VALUES (1958, 'Medicine', 'George Beadle');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Medicine', 'Severo Ochoa');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Medicine', 'Arthur Kornberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Literature', 'Salvatore Quasimodo');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Peace', 'Philip Noel-Baker');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Physics', 'Owen Chamberlain');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Physics', 'Emilio Segrè');
INSERT INTO nobel (yr, subject, winner) VALUES (1959, 'Chemistry', 'Jaroslav Heyrovsky');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Physics', 'Donald A. Glaser');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Literature', 'Saint-John Perse');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Medicine', 'Sir Frank Macfarlane Burnet');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Medicine', 'Peter Medawar');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Peace', 'Albert Luthuli');
INSERT INTO nobel (yr, subject, winner) VALUES (1960, 'Chemistry', 'Willard F. Libby');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Physics', 'Rudolf Mössbauer');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Physics', 'Robert Hofstadter');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Literature', 'Ivo Andric');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Chemistry', 'Melvin Calvin');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Medicine', 'Georg von Békésy');
INSERT INTO nobel (yr, subject, winner) VALUES (1961, 'Peace', 'Dag Hammarskjöld');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Medicine', 'Francis Crick');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Peace', 'Linus Pauling');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Medicine', 'James Watson');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Medicine', 'Maurice Wilkins');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Physics', 'Lev Landau');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Chemistry', 'Max F. Perutz');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Literature', 'John Steinbeck');
INSERT INTO nobel (yr, subject, winner) VALUES (1962, 'Chemistry', 'John C. Kendrew');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Peace', 'League of Red Cross Societies');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Chemistry', 'Karl Ziegler');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Physics', 'J. Hans D. Jensen');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Medicine', 'Sir John Eccles');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Physics', 'Maria Goeppert Mayer');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Peace', 'International Committee of the Red Cross');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Medicine', 'Andrew Huxley');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Physics', 'Eugene Wigner');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Medicine', 'Alan Hodgkin');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Literature', 'Giorgos Seferis');
INSERT INTO nobel (yr, subject, winner) VALUES (1963, 'Chemistry', 'Giulio Natta');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Physics', 'Charles H. Townes');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Literature', 'Jean-Paul Sartre');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Medicine', 'Feodor Lynen');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Peace', 'Martin Luther King Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Chemistry', 'Dorothy Crowfoot Hodgkin');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Physics', 'Aleksandr M. Prokhorov');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Medicine', 'Konrad Bloch');
INSERT INTO nobel (yr, subject, winner) VALUES (1964, 'Physics', 'Nicolay G. Basov');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Medicine', 'André Lwoff');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Peace', 'United Nations Children''s Fund');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Chemistry', 'Robert B. Woodward');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Medicine', 'Jacques Monod');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Physics', 'Richard P. Feynman');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Physics', 'Sin-Itiro Tomonaga');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Medicine', 'François Jacob');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Literature', 'Mikhail Sholokhov');
INSERT INTO nobel (yr, subject, winner) VALUES (1965, 'Physics', 'Julian Schwinger');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Physics', 'Alfred Kastler');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Medicine', 'Charles B. Huggins');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Literature', 'Nelly Sachs');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Chemistry', 'Robert S. Mulliken');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Literature', 'Shmuel Agnon');
INSERT INTO nobel (yr, subject, winner) VALUES (1966, 'Medicine', 'Peyton Rous');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Chemistry', 'Manfred Eigen');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Literature', 'Miguel Angel Asturias');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Medicine', 'Keffer Hartline');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Chemistry', 'Ronald G.W. Norrish');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Chemistry', 'George Porter');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Medicine', 'George Wald');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Physics', 'Hans Bethe');
INSERT INTO nobel (yr, subject, winner) VALUES (1967, 'Medicine', 'Ragnar Granit');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Physics', 'Luis Alvarez');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Medicine', 'Marshall W. Nirenberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Chemistry', 'Lars Onsager');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Literature', 'Yasunari Kawabata');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Peace', 'René Cassin');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Medicine', 'H. Gobind Khorana');
INSERT INTO nobel (yr, subject, winner) VALUES (1968, 'Medicine', 'Robert W. Holley');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Chemistry', 'Derek Barton');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Medicine', 'Max Delbrück');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Literature', 'Samuel Beckett');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Economic Sciences', 'Jan Tinbergen');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Economic Sciences', 'Ragnar Frisch');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Medicine', 'Salvador E. Luria');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Chemistry', 'Odd Hassel');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Medicine', 'Alfred D. Hershey');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Peace', 'International Labour Organization');
INSERT INTO nobel (yr, subject, winner) VALUES (1969, 'Physics', 'Murray Gell-Mann');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Medicine', 'Julius Axelrod');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Physics', 'Louis Néel');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Economic Sciences', 'Paul A. Samuelson');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Peace', 'Norman Borlaug');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Physics', 'Hannes Alfvén');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Medicine', 'Sir Bernard Katz');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Literature', 'Alexandr Solzhenitsyn');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Chemistry', 'Luis Leloir');
INSERT INTO nobel (yr, subject, winner) VALUES (1970, 'Medicine', 'Ulf von Euler');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Literature', 'Pablo Neruda');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Physics', 'Dennis Gabor');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Peace', 'Willy Brandt');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Economic Sciences', 'Simon Kuznets');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Chemistry', 'Gerhard Herzberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1971, 'Medicine', 'Earl W. Sutherland, Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Literature', 'Heinrich Böll');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Economic Sciences', 'John R. Hicks');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Medicine', 'Rodney R. Porter');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Chemistry', 'William H. Stein');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Physics', 'Robert Schrieffer');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Physics', 'Leon N. Cooper');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Economic Sciences', 'Kenneth J. Arrow');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Chemistry', 'Stanford Moore');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Physics', 'John Bardeen');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Medicine', 'Gerald M. Edelman');
INSERT INTO nobel (yr, subject, winner) VALUES (1972, 'Chemistry', 'Christian Anfinsen');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Peace', 'Le Duc Tho ');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Medicine', 'Konrad Lorenz');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Medicine', 'Nikolaas Tinbergen');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Chemistry', 'Ernst Otto Fischer');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Medicine', 'Karl von Frisch');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Physics', 'Leo Esaki');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Peace', 'Henry Kissinger');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Chemistry', 'Geoffrey Wilkinson');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Literature', 'Patrick White');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Economic Sciences', 'Wassily Leontief');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Physics', 'Brian D. Josephson');
INSERT INTO nobel (yr, subject, winner) VALUES (1973, 'Physics', 'Ivar Giaever');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Physics', 'Antony Hewish');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Economic Sciences', 'Gunnar Myrdal');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Literature', 'Eyvind Johnson');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Peace', 'Seán MacBride');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Chemistry', 'Paul J. Flory');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Medicine', 'Christian de Duve');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Literature', 'Harry Martinson');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Medicine', 'Albert Claude');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Economic Sciences', 'Friedrich von Hayek');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Medicine', 'George E. Palade');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Peace', 'Eisaku Sato');
INSERT INTO nobel (yr, subject, winner) VALUES (1974, 'Physics', 'Martin Ryle');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Chemistry', 'John Cornforth');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Chemistry', 'Vladimir Prelog');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Medicine', 'David Baltimore');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Physics', 'Ben R. Mottelson');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Economic Sciences', 'Leonid Vitaliyevich Kantorovich');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Medicine', 'Renato Dulbecco');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Physics', 'Aage N. Bohr');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Literature', 'Eugenio Montale');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Peace', 'Andrei Sakharov');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Physics', 'James Rainwater');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Economic Sciences', 'Tjalling C. Koopmans');
INSERT INTO nobel (yr, subject, winner) VALUES (1975, 'Medicine', 'Howard M. Temin');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Medicine', 'Baruch S. Blumberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Chemistry', 'William Lipscomb');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Physics', 'Samuel C.C. Ting');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Peace', 'Betty Williams');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Peace', 'Mairead Corrigan');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Literature', 'Saul Bellow');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Medicine', 'D. Carleton Gajdusek');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Physics', 'Burton Richter');
INSERT INTO nobel (yr, subject, winner) VALUES (1976, 'Economic Sciences', 'Milton Friedman');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Peace', 'Amnesty International');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Economic Sciences', 'Bertil Ohlin');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Physics', 'Philip W. Anderson');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Economic Sciences', 'James E. Meade');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Physics', 'John H. van Vleck');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Medicine', 'Rosalyn Yalow');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Medicine', 'Andrew V. Schally');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Literature', 'Vicente Aleixandre');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Physics', 'Sir Nevill F. Mott');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Medicine', 'Roger Guillemin');
INSERT INTO nobel (yr, subject, winner) VALUES (1977, 'Chemistry', 'Ilya Prigogine');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Peace', 'Anwar al-Sadat');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Literature', 'Isaac Bashevis Singer');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Physics', 'Arno Penzias');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Physics', 'Pyotr Kapitsa');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Peace', 'Menachem Begin');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Economic Sciences', 'Herbert Simon');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Physics', 'Robert Woodrow Wilson');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Medicine', 'Hamilton O. Smith');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Medicine', 'Daniel Nathans');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Medicine', 'Werner Arber');
INSERT INTO nobel (yr, subject, winner) VALUES (1978, 'Chemistry', 'Peter Mitchell');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Physics', 'Steven Weinberg');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Economic Sciences', 'Theodore W. Schultz');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Medicine', 'Godfrey N. Hounsfield');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Chemistry', 'Herbert C. Brown');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Physics', 'Abdus Salam');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Medicine', 'Allan M. Cormack');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Literature', 'Odysseus Elytis');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Chemistry', 'Georg Wittig');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Peace', 'Mother Teresa ');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Physics', 'Sheldon Glashow');
INSERT INTO nobel (yr, subject, winner) VALUES (1979, 'Economic Sciences', 'Sir Arthur Lewis');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Economic Sciences', 'Lawrence R. Klein');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Physics', 'Val Fitch');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Peace', 'Adolfo Pérez Esquivel');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Physics', 'James Cronin');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Chemistry', 'Frederick Sanger');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Chemistry', 'Walter Gilbert');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Literature', 'Czeslaw Milosz');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Chemistry', 'Paul Berg');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Medicine', 'George D. Snell');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Medicine', 'Baruj Benacerraf');
INSERT INTO nobel (yr, subject, winner) VALUES (1980, 'Medicine', 'Jean Dausset');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Chemistry', 'Roald Hoffmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Medicine', 'David H. Hubel');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Medicine', 'Roger W. Sperry');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Medicine', 'Torsten N. Wiesel');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Physics', 'Nicolaas Bloembergen');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Literature', 'Elias Canetti');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Economic Sciences', 'James Tobin');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Physics', 'Arthur L. Schawlow');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Peace', 'Office of the United Nations High Commissioner for Refugees');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Physics', 'Kai M. Siegbahn');
INSERT INTO nobel (yr, subject, winner) VALUES (1981, 'Chemistry', 'Kenichi Fukui');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Peace', 'Alva Myrdal');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Medicine', 'John R. Vane');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Medicine', 'Sune K. Bergström');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Economic Sciences', 'George J. Stigler');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Medicine', 'Bengt I. Samuelsson');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Physics', 'Kenneth G. Wilson');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Peace', 'Alfonso García Robles');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Chemistry', 'Aaron Klug');
INSERT INTO nobel (yr, subject, winner) VALUES (1982, 'Literature', 'Gabriel García Márquez');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Medicine', 'Barbara McClintock');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Literature', 'William Golding');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Physics', 'William A. Fowler');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Chemistry', 'Henry Taube');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Economic Sciences', 'Gerard Debreu');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Peace', 'Lech Walesa');
INSERT INTO nobel (yr, subject, winner) VALUES (1983, 'Physics', 'Subramanyan Chandrasekhar');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Physics', 'Carlo Rubbia');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Medicine', 'Niels K. Jerne');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Medicine', 'Georges J.F. Köhler');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Medicine', 'César Milstein');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Chemistry', 'Bruce Merrifield');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Literature', 'Jaroslav Seifert');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Economic Sciences', 'Richard Stone');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Physics', 'Simon van der Meer');
INSERT INTO nobel (yr, subject, winner) VALUES (1984, 'Peace', 'Desmond Tutu');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Medicine', 'Joseph L. Goldstein');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Chemistry', 'Jerome Karle');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Physics', 'Klaus von Klitzing');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Medicine', 'Michael S. Brown');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Peace', 'International Physicians for the Prevention of Nuclear War');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Chemistry', 'Herbert A. Hauptman');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Literature', 'Claude Simon');
INSERT INTO nobel (yr, subject, winner) VALUES (1985, 'Economic Sciences', 'Franco Modigliani');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Economic Sciences', 'James M. Buchanan Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Physics', 'Ernst Ruska');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Medicine', 'Stanley Cohen');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Chemistry', 'John C. Polanyi');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Physics', 'Heinrich Rohrer');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Chemistry', 'Yuan T. Lee');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Peace', 'Elie Wiesel');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Literature', 'Wole Soyinka');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Physics', 'Gerd Binnig');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Chemistry', 'Dudley R. Herschbach');
INSERT INTO nobel (yr, subject, winner) VALUES (1986, 'Medicine', 'Rita Levi-Montalcini');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Chemistry', 'Charles J. Pedersen');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Physics', 'K. Alex Müller');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Chemistry', 'Jean-Marie Lehn');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Literature', 'Joseph Brodsky');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Medicine', 'Susumu Tonegawa');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Economic Sciences', 'Robert M. Solow');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Physics', 'J. Georg Bednorz');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Peace', 'Oscar Arias Sánchez');
INSERT INTO nobel (yr, subject, winner) VALUES (1987, 'Chemistry', 'Donald J. Cram');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Literature', 'Naguib Mahfouz');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Physics', 'Melvin Schwartz');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Peace', 'United Nations Peacekeeping Forces');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Chemistry', 'Hartmut Michel');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Chemistry', 'Johann Deisenhofer');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Physics', 'Leon M. Lederman');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Medicine', 'Gertrude B. Elion');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Medicine', 'George H. Hitchings');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Physics', 'Jack Steinberger');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Chemistry', 'Robert Huber');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Economic Sciences', 'Maurice Allais');
INSERT INTO nobel (yr, subject, winner) VALUES (1988, 'Medicine', 'Sir James W. Black');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Physics', 'Norman F. Ramsey');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Economic Sciences', 'Trygve Haavelmo');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Chemistry', 'Thomas R. Cech');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Medicine', 'J. Michael Bishop');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Physics', 'Wolfgang Paul');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Peace', 'The 14th Dalai Lama ');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Chemistry', 'Sidney Altman');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Medicine', 'Harold E. Varmus');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Physics', 'Hans G. Dehmelt');
INSERT INTO nobel (yr, subject, winner) VALUES (1989, 'Literature', 'Camilo José Cela');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Literature', 'Octavio Paz');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Economic Sciences', 'Harry M. Markowitz');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Medicine', 'E. Donnall Thomas');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Physics', 'Jerome I. Friedman');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Physics', 'Richard E. Taylor');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Medicine', 'Joseph E. Murray');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Chemistry', 'Elias James Corey');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Peace', 'Mikhail Gorbachev');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Physics', 'Henry W. Kendall');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Economic Sciences', 'Merton H. Miller');
INSERT INTO nobel (yr, subject, winner) VALUES (1990, 'Economic Sciences', 'William F. Sharpe');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Chemistry', 'Richard R. Ernst');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Physics', 'Pierre-Gilles de Gennes');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Literature', 'Nadine Gordimer');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Economic Sciences', 'Ronald H. Coase');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Peace', 'Aung San Suu Kyi ');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Medicine', 'Bert Sakmann');
INSERT INTO nobel (yr, subject, winner) VALUES (1991, 'Medicine', 'Erwin Neher');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Medicine', 'Edmond H. Fischer');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Physics', 'Georges Charpak');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Peace', 'Rigoberta Menchú Tum');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Medicine', 'Edwin G. Krebs');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Literature', 'Derek Walcott');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Economic Sciences', 'Gary Becker');
INSERT INTO nobel (yr, subject, winner) VALUES (1992, 'Chemistry', 'Rudolph A. Marcus');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Economic Sciences', 'Douglass C. North');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Chemistry', 'Kary B. Mullis');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Economic Sciences', 'Robert W. Fogel');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Chemistry', 'Michael Smith');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Medicine', 'Richard J. Roberts');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Literature', 'Toni Morrison');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Peace', 'F.W. de Klerk');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Peace', 'Nelson Mandela');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Physics', 'Joseph H. Taylor Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Medicine', 'Phillip A. Sharp');
INSERT INTO nobel (yr, subject, winner) VALUES (1993, 'Physics', 'Russell A. Hulse');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Physics', 'Clifford G. Shull');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Peace', 'Yasser Arafat');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Medicine', 'Alfred G. Gilman');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Economic Sciences', 'John C. Harsanyi');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Medicine', 'Martin Rodbell');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Economic Sciences', 'Reinhard Selten');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Economic Sciences', 'John F. Nash Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Peace', 'Yitzhak Rabin');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Peace', 'Shimon Peres');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Physics', 'Bertram N. Brockhouse');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Chemistry', 'George A. Olah');
INSERT INTO nobel (yr, subject, winner) VALUES (1994, 'Literature', 'Kenzaburo Oe');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Medicine', 'Eric F. Wieschaus');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Chemistry', 'Paul J. Crutzen');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Chemistry', 'Mario J. Molina');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Chemistry', 'F. Sherwood Rowland');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Literature', 'Seamus Heaney');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Medicine', 'Christiane Nüsslein-Volhard');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Peace', 'Joseph Rotblat');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Physics', 'Martin L. Perl');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Medicine', 'Edward B. Lewis');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Peace', 'Pugwash Conferences on Science and World Affairs');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Economic Sciences', 'Robert E. Lucas Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1995, 'Physics', 'Frederick Reines');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Medicine', 'Peter C. Doherty');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Chemistry', 'Robert F. Curl Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Physics', 'Robert C. Richardson');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Chemistry', 'Richard E. Smalley');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Physics', 'David M. Lee');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Physics', 'Douglas D. Osheroff');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Peace', 'Carlos Filipe Ximenes Belo');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Peace', 'José Ramos-Horta');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Economic Sciences', 'James A. Mirrlees');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Medicine', 'Rolf M. Zinkernagel');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Literature', 'Wislawa Szymborska');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Chemistry', 'Sir Harold Kroto');
INSERT INTO nobel (yr, subject, winner) VALUES (1996, 'Economic Sciences', 'William Vickrey');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Physics', 'Steven Chu');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Literature', 'Dario Fo');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Physics', 'Claude Cohen-Tannoudji');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Physics', 'William D. Phillips');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Economic Sciences', 'Robert C. Merton');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Economic Sciences', 'Myron Scholes');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Peace', 'Jody Williams');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Peace', 'International Campaign to Ban Landmines');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Chemistry', 'John E. Walker');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Chemistry', 'Jens C. Skou');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Chemistry', 'Paul D. Boyer');
INSERT INTO nobel (yr, subject, winner) VALUES (1997, 'Medicine', 'Stanley B. Prusiner');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Ferid Murad');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Chemistry', 'John Pople');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Robert B. Laughlin');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Peace', 'John Hume');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Economic Sciences', 'Amartya Sen');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Literature', 'José Saramago');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Chemistry', 'Walter Kohn');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Louis J. Ignarro');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Horst L. Störmer');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Peace', 'David Trimble');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Daniel C. Tsui');
INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Robert F. Furchgott');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Physics', 'Gerardus ''t Hooft');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Physics', 'Martinus J.G. Veltman');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Literature', 'Günter Grass');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Medicine', 'Günter Blobel');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Chemistry', 'Ahmed Zewail');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Economic Sciences', 'Robert Mundell');
INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Peace', 'Médecins Sans Frontières');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Peace', 'Kim Dae-jung');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Economic Sciences', 'Daniel L. McFadden');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Arvid Carlsson');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Herbert Kroemer');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Alan MacDiarmid');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Eric Kandel');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Alan Heeger');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Paul Greengard');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Economic Sciences', 'James J. Heckman');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Zhores Alferov');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Hideki Shirakawa');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Jack Kilby');
INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Literature', 'Gao Xingjian');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'Ryoji Noyori');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Wolfgang Ketterle');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Tim Hunt');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Peace', 'United Nations');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Sir Paul Nurse');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'William Knowles');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Literature', 'V. S. Naipaul');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economic Sciences', 'A. Michael Spence');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Eric Cornell');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Leland Hartwell');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'Barry Sharpless');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Peace', 'Kofi Annan');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economic Sciences', 'George A. Akerlof');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economic Sciences', 'Joseph E. Stiglitz');
INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Carl Wieman');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Literature', 'Imre Kertész');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'H. Robert Horvitz');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Economic Sciences', 'Daniel Kahneman');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Physics', 'Masatoshi Koshiba');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Peace', 'Jimmy Carter');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'John B. Fenn');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'John E. Sulston');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Economic Sciences', 'Vernon L. Smith');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Physics', 'Raymond Davis Jr.');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Physics', 'Riccardo Giacconi');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'Koichi Tanaka');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'Kurt Wüthrich');
INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'Sydney Brenner');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Economic Sciences', 'Clive W.J. Granger');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Medicine', 'Sir Peter Mansfield');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Anthony J. Leggett');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Literature', 'J. M. Coetzee');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Alexei Abrikosov');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Chemistry', 'Roderick MacKinnon');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Peace', 'Shirin Ebadi');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Vitaly L. Ginzburg');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Medicine', 'Paul C. Lauterbur');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Economic Sciences', 'Robert F. Engle III');
INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Chemistry', 'Peter Agre');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Economic Sciences', 'Edward C. Prescott');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Avram Hershko');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Literature', 'Elfriede Jelinek');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Medicine', 'Linda B. Buck');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'Frank Wilczek');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'H. David Politzer');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Medicine', 'Richard Axel');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'David J. Gross');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Irwin Rose');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Aaron Ciechanover');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Economic Sciences', 'Finn E. Kydland');
INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Peace', 'Wangari Maathai');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Peace', 'Mohamed ElBaradei');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Richard R. Schrock');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Peace', 'International Atomic Energy Agency');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'John L. Hall');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Robert H. Grubbs');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Literature', 'Harold Pinter');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Economic Sciences', 'Robert J. Aumann');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Yves Chauvin');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'Roy J. Glauber');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Medicine', 'J. Robin Warren');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Economic Sciences', 'Thomas C. Schelling');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'Theodor W. Hänsch');
INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Medicine', 'Barry J. Marshall');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Physics', 'George F. Smoot');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Peace', 'Grameen Bank');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Medicine', 'Craig C. Mello');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Literature', 'Orhan Pamuk');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Medicine', 'Andrew Z. Fire');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Peace', 'Muhammad Yunus');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Chemistry', 'Roger D. Kornberg');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Economic Sciences', 'Edmund S. Phelps');
INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Physics', 'John C. Mather');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Sir Martin J. Evans');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Chemistry', 'Gerhard Ertl');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economic Sciences', 'Eric S. Maskin');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Literature', 'Doris Lessing');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Peace', 'Intergovernmental Panel on Climate Change');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Physics', 'Albert Fert');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Peace', 'Al Gore');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Oliver Smithies');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Mario R. Capecchi');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Physics', 'Peter Grünberg');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economic Sciences', 'Roger B. Myerson');
INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economic Sciences', 'Leonid Hurwicz');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Roger Y. Tsien');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Economic Sciences', 'Paul Krugman');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Physics', 'Yoichiro Nambu');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Osamu Shimomura');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Literature', 'Jean-Marie Gustave Le Clézio');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'Luc Montagnier');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Peace', 'Martti Ahtisaari');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Physics', 'Makoto Kobayashi');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Physics', 'Toshihide Maskawa');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Martin Chalfie');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'Françoise Barré-Sinoussi');
INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'Harald zur Hausen');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Physics', 'George E. Smith');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Medicine', 'Elizabeth H. Blackburn');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Economic Sciences', 'Oliver E. Williamson');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Medicine', 'Carol W. Greider');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Physics', 'Willard S. Boyle');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Physics', 'Charles K. Kao');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Medicine', 'Jack W. Szostak');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Peace', 'Barack H. Obama');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Literature', 'Herta Müller');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Chemistry', 'Venkatraman Ramakrishnan');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Chemistry', 'Thomas A. Steitz');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Economic Sciences', 'Elinor Ostrom');
INSERT INTO nobel (yr, subject, winner) VALUES (2009, 'Chemistry', 'Ada E. Yonath');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Medicine', 'Robert G. Edwards');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Chemistry', 'Akira Suzuki');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Economic Sciences', 'Peter A. Diamond');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Physics', 'Andre Geim');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Physics', 'Konstantin Novoselov');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Chemistry', 'Ei-ichi Negishi');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Economic Sciences', 'Dale T. Mortensen');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Chemistry', 'Richard F. Heck');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Peace', 'Liu Xiaobo');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Economic Sciences', 'Christopher A. Pissarides');
INSERT INTO nobel (yr, subject, winner) VALUES (2010, 'Literature', 'Mario Vargas Llosa');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Peace', 'Leymah Gbowee');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Physics', 'Brian P. Schmidt');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Peace', 'Tawakkol Karman');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Medicine', 'Jules A. Hoffmann');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Physics', 'Saul Perlmutter');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Peace', 'Ellen Johnson Sirleaf');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Medicine', 'Ralph M. Steinman');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Physics', 'Adam G. Riess');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Economic Sciences', 'Christopher A. Sims');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Economic Sciences', 'Thomas J. Sargent');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Literature', 'Tomas Tranströmer');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Medicine', 'Bruce A. Beutler');
INSERT INTO nobel (yr, subject, winner) VALUES (2011, 'Chemistry', 'Dan Shechtman');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Peace', 'European Union (EU)');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Medicine', 'Shinya Yamanaka');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Chemistry', 'Brian Kobilka');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Physics', 'Serge Haroche');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Economic Sciences', 'Lloyd S. Shapley');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Medicine', 'Sir John B. Gurdon');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Literature', 'Mo Yan');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Physics', 'David J. Wineland');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Economic Sciences', 'Alvin E. Roth');
INSERT INTO nobel (yr, subject, winner) VALUES (2012, 'Chemistry', 'Robert J. Lefkowitz');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Economic Sciences', 'Eugene F. Fama');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Chemistry', 'Martin Karplus');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Medicine', 'Randy W. Schekman');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Physics', 'François Englert');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Economic Sciences', 'Robert J. Shiller');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Chemistry', 'Michael Levitt');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Physics', 'Peter Higgs');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Literature', 'Alice Munro');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Economic Sciences', 'Lars Peter Hansen');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Peace', 'Organisation for the Prohibition of Chemical Weapons');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Medicine', 'Thomas C. Südhof');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Chemistry', 'Arieh Warshel');
INSERT INTO nobel (yr, subject, winner) VALUES (2013, 'Medicine', 'James E. Rothman');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Chemistry', 'William E. Moerner');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Medicine', 'Edvard I. Moser');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Chemistry', 'Eric Betzig');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Medicine', 'John O''Keefe');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Physics', 'Shuji Nakamura');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Medicine', 'May-Britt Moser');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Chemistry', 'Stefan W. Hell');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Physics', 'Isamu Akasaki');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Peace', 'Malala Yousafzai');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Physics', 'Hiroshi Amano');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Literature', 'Patrick Modiano');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Economic Sciences', 'Jean Tirole');
INSERT INTO nobel (yr, subject, winner) VALUES (2014, 'Peace', 'Kailash Satyarthi');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Physics', 'Takaaki Kajita');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Chemistry', 'Paul Modrich');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Literature', 'Svetlana Alexievich');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Medicine', 'William C. Campbell');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Peace', 'National Dialogue Quartet ');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Medicine', 'Satoshi &#332;mura');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Chemistry', 'Aziz Sancar');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Chemistry', 'Tomas Lindahl');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Economic Sciences', 'Angus Deaton');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Physics', 'Arthur B. McDonald');
INSERT INTO nobel (yr, subject, winner) VALUES (2015, 'Medicine', 'Tu Youyou');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Economic Sciences', 'Bengt Holmström');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Chemistry', 'Sir J. Fraser Stoddart');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Chemistry', 'Jean-Pierre Sauvage');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Peace', 'Juan Manuel Santos');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Physics', 'David J. Thouless');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Chemistry', 'Bernard L. Feringa');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Economic Sciences', 'Oliver Hart');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Medicine', 'Yoshinori Ohsumi');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Physics', 'F. Duncan M. Haldane');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Physics', 'J. Michael Kosterlitz');
INSERT INTO nobel (yr, subject, winner) VALUES (2016, 'Literature', 'Bob Dylan');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Medicine', 'Michael Rosbash');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Medicine', 'Michael W. Young');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Physics', 'Barry C. Barish');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Physics', 'Rainer Weiss');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Economic Sciences', 'Richard H. Thaler');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Literature', 'Kazuo Ishiguro');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Chemistry', 'Richard Henderson');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Physics', 'Kip S. Thorne');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Peace', 'International Campaign to Abolish Nuclear Weapons (ICAN)');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Chemistry', 'Jacques Dubochet');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Chemistry', 'Joachim Frank');
INSERT INTO nobel (yr, subject, winner) VALUES (2017, 'Medicine', 'Jeffrey C. Hall');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Economic Sciences', 'Paul M. Romer');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Peace', 'Denis Mukwege');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Physics', 'Gérard Mourou');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Medicine', 'Tasuku Honjo');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Medicine', 'James P. Allison');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Peace', 'Nadia Murad');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Chemistry', 'George P. Smith');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Chemistry', 'Sir Gregory P. Winter');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Literature', 'Olga Tokarczuk');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Economic Sciences', 'William D. Nordhaus');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Chemistry', 'Frances H. Arnold');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Physics', 'Arthur Ashkin');
INSERT INTO nobel (yr, subject, winner) VALUES (2018, 'Physics', 'Donna Strickland');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Literature', 'Peter Handke');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Economic Sciences', 'Abhijit Banerjee');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Peace', 'Abiy Ahmed Ali');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Chemistry', 'Akira Yoshino');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Economic Sciences', 'Esther Duflo');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Physics', 'Didier Queloz');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Economic Sciences', 'Michael Kremer');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Medicine', 'Sir Peter J. Ratcliffe');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Physics', 'James Peebles');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Chemistry', 'M. Stanley Whittingham');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Chemistry', 'John B. Goodenough');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Medicine', 'William G. Kaelin Jr');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Medicine', 'Gregg L. Semenza');
INSERT INTO nobel (yr, subject, winner) VALUES (2019, 'Physics', 'Michel Mayor');

Last updated