-- -- File generated with SQLiteStudio v3.3.3 on Fri Dec 10 08:45:27 2021 -- -- Text encoding used: System -- PRAGMA foreign_keys = off; BEGIN TRANSACTION; -- Table: nobel DROP TABLE IF EXISTS nobel; CREATE TABLE nobel ( yr INTEGER, subject TEXT, winner TEXT ); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Martin Chalfie'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Osamu Shimomura'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Chemistry', 'Roger Y. Tsien'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Economics', 'Paul Krugman'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Literature', 'Jean-Marie Gustave Le ClAİzio'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'FranA§oise BarrAİ-Sinoussi'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'Luc Montagnier'); INSERT INTO nobel (yr, subject, winner) VALUES (2008, 'Medicine', 'Harald zur Hausen'); 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, 'Physics', 'Yoichiro Nambu'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Chemistry', 'Gerhard Ertl'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economics', 'Leonid Hurwicz'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economics', 'Eric S. Maskin'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Economics', 'Roger B. Myerson'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Literature', 'Doris Lessing'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Mario R. Capecchi'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Sir Martin J. Evans'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Medicine', 'Oliver Smithies'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Peace', 'Intergovernmental Panel on Climate Change'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Peace', 'Al Gore'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Physics', 'Albert Fert'); INSERT INTO nobel (yr, subject, winner) VALUES (2007, 'Physics', 'Peter GrA1nberg'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Chemistry', 'Roger D. Kornberg'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Economics', 'Edmund S. Phelps'); 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, 'Medicine', 'Craig C. Mello'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Peace', 'Grameen Bank'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Peace', 'Muhammad Yunus'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Physics', 'John C. Mather'); INSERT INTO nobel (yr, subject, winner) VALUES (2006, 'Physics', 'George F. Smoot'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Yves Chauvin'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Robert H. Grubbs'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Chemistry', 'Richard R. Schrock'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Economics', 'Robert J. Aumann'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Economics', 'Thomas C. Schelling'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Literature', 'Harold Pinter'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Medicine', 'Barry J. Marshall'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Medicine', 'J. Robin Warren'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Peace', 'International Atomic Energy Agency'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Peace', 'Mohamed ElBaradei'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'Roy J. Glauber'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'John L. Hall'); INSERT INTO nobel (yr, subject, winner) VALUES (2005, 'Physics', 'Theodor W. HA¤nsch'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Aaron Ciechanover'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Avram Hershko'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Chemistry', 'Irwin Rose'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Economics', 'Finn E. Kydland'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Economics', 'Edward C. Prescott'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Literature', 'Elfriede Jelinek'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Medicine', 'Richard Axel'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Medicine', 'Linda B. Buck'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Peace', 'Wangari Maathai'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'David J. Gross'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'H. David Politzer'); INSERT INTO nobel (yr, subject, winner) VALUES (2004, 'Physics', 'Frank Wilczek'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Chemistry', 'Peter Agre'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Chemistry', 'Roderick MacKinnon'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Economics', 'Robert F. Engle III'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Economics', 'Clive W.J. Granger'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Literature', 'J. M. Coetzee'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Medicine', 'Paul C. Lauterbur'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Medicine', 'Sir Peter Mansfield'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Peace', 'Shirin Ebadi'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Alexei A. Abrikosov'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Vitaly L. Ginzburg'); INSERT INTO nobel (yr, subject, winner) VALUES (2003, 'Physics', 'Anthony J. Leggett'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'John B. Fenn'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'Koichi Tanaka'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Chemistry', 'Kurt WA1thrich'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Economics', 'Daniel Kahneman'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Economics', 'Vernon L. Smith'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Literature', 'Imre KertAİsz'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'Sydney Brenner'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'H. Robert Horvitz'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Medicine', 'John E. Sulston'); INSERT INTO nobel (yr, subject, winner) VALUES (2002, 'Peace', 'Jimmy Carter'); 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, 'Physics', 'Masatoshi Koshiba'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'William S. Knowles'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'Ryoji Noyori'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Chemistry', 'K. Barry Sharpless'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economics', 'George A. Akerlof'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economics', 'A. Michael Spence'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Economics', 'Joseph E. Stiglitz'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Literature', 'V. S. Naipaul'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Leland H. Hartwell'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Tim Hunt'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Medicine', 'Sir Paul Nurse'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Peace', 'United Nations'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Peace', 'Kofi Annan'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Eric A. Cornell'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Wolfgang Ketterle'); INSERT INTO nobel (yr, subject, winner) VALUES (2001, 'Physics', 'Carl E. Wieman'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Alan Heeger'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Alan G. MacDiarmid'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Chemistry', 'Hideki Shirakawa'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Economics', 'James J. Heckman'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Economics', 'Daniel L. McFadden'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Literature', 'Gao Xingjian'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Arvid Carlsson'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Paul Greengard'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Medicine', 'Eric R. Kandel'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Peace', 'Kim Dae-jung'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Zhores I. Alferov'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Jack S. Kilby'); INSERT INTO nobel (yr, subject, winner) VALUES (2000, 'Physics', 'Herbert Kroemer'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Chemistry', 'Ahmed Zewail'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Economics', 'Robert A. Mundell'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Literature', 'GA1nter Grass'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Medicine', 'GA1nter Blobel'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Peace', 'MAİdecins Sans FrontiA¨res'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Physics', 'Gerardus Hooft'); INSERT INTO nobel (yr, subject, winner) VALUES (1999, 'Physics', 'Martinus J.G. Veltman'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Chemistry', 'Walter Kohn'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Chemistry', 'John Pople'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Economics', 'Amartya Sen'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Literature', 'JosAİ Saramago'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Robert F. Furchgott'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Louis J. Ignarro'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Medicine', 'Ferid Murad'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Peace', 'John Hume'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Peace', 'David Trimble'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Robert B. Laughlin'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Horst L. StAĥrmer'); INSERT INTO nobel (yr, subject, winner) VALUES (1998, 'Physics', 'Daniel C. Tsui'); COMMIT TRANSACTION; PRAGMA foreign_keys = on;