Nobel Prizes 🏅

Nobel Prize Winners from 1901-Present

@kaggle.davinascimento_nobel_prizes

Table List

1 table(537.04 KB)

Nobel Prize

@kaggle.davinascimento_nobel_prizes.nobel_prize

537.04 KB
1012 rows
21 columns

id Id	firstname Firstname	surname Surname	born Born	died Died	born_country Born Country	born_country_code Born Country Code	born_city Born City	died_country Died Country	died_country_code Died Country Code	died_city Died City	gender Gender	year Year	category Category	overall_motivation Overall Motivation	motivation Motivation	organization_name Organization Name	organization_city Organization City	organization_country Organization Country	geo_shape Geo Shape	geo_point_2d Geo Point 2D
498	Sir Norman	Angell	Thu Dec 26 1872 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 07 1967 00:00:00 GMT+0000 (Coordinated Universal Time)	United Kingdom	GB	Holbeach	United Kingdom	GB	Croydon	male	1933	Peace	nan	"for having exposed by his pen the illusion of war and presented a convincing plea for international cooperation and peace"	nan	nan	nan	nan	nan
518	Philip	Noel-Baker	Fri Nov 01 1889 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 08 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	United Kingdom	GB	London	United Kingdom	GB	London	male	1959	Peace	nan	"for his longstanding contribution to the cause of disarmament and peace"	nan	nan	nan	nan	nan
602	Thomas	Mann	Sun Jun 06 1875 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 12 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	Germany	DE	Lübeck	Switzerland	CH	Zurich	male	1929	Literature	nan	"principally for his great novel <I>Buddenbrooks</I> which has won steadily increased recognition as one of the classic works of contemporary literature"	nan	nan	nan	nan	nan
667	Octavio	Paz	Tue Mar 31 1914 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Mexico	MX	Mexico City	Mexico	MX	Mexico City	male	1990	Literature	nan	"for impassioned writing with wide horizons characterized by sensuous intelligence and humanistic integrity"	nan	nan	nan	nan	nan
670	Toni	Morrison	Wed Feb 18 1931 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	USA	US	Lorain OH	USA	US	New York NY	female	1993	Literature	nan	"who in novels characterized by visionary force and poetic import gives life to an essential aspect of American reality"	nan	nan	nan	nan	nan
709	Robert W.	Fogel	Fri Jul 01 1927 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	USA	US	New York NY	USA	US	Oak Lawn IL	male	1993	Economics	nan	"for having renewed research in economic history by applying economic theory and quantitative methods in order to explain economic and institutional change"	University of Chicago	Chicago IL	USA	{"coordinates":[[[[-155.60651897,20.137955566],[-155.586363309,20.122935923],[-155.527193997,20.126268986],[-155.420714618,20.090185489],[-155.332312779,20.046721443],[-155.168042734,19.946827215],[-155.087141189,19.860379834],[-155.085370906,19.727409311],[-155.0574929,19.728530432],[-155.018544075…	45.68753333949257, -112.49433391594509
1009	Guido	Imbens	Tue Sep 03 1963 00:00:00 GMT+0000 (Coordinated Universal Time)		the Netherlands	NL	Geldrop	nan	nan	nan	male	2021	Economics	nan	"for their methodological contributions to the analysis of causal relationships"	Stanford University	Stanford CA	USA	{"coordinates":[[[[-155.60651897,20.137955566],[-155.586363309,20.122935923],[-155.527193997,20.126268986],[-155.420714618,20.090185489],[-155.332312779,20.046721443],[-155.168042734,19.946827215],[-155.087141189,19.860379834],[-155.085370906,19.727409311],[-155.0574929,19.728530432],[-155.018544075…	45.68753333949257, -112.49433391594509
227	John C.	Kendrew	Sat Mar 24 1917 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Aug 23 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	United Kingdom	GB	Oxford	United Kingdom	GB	Cambridge	male	1962	Chemistry	nan	"for their studies of the structures of globular proteins"	MRC Laboratory of Molecular Biology	Cambridge	United Kingdom	nan	nan
278	Kary B.	Mullis	Thu Dec 28 1944 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Aug 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	USA	US	Lenoir NC	USA	US	Newport Beach CA	male	1993	Chemistry	"for contributions to the developments of methods within DNA-based chemistry"	"for his invention of the polymerase chain reaction (PCR) method"	nan	nan	nan	nan	nan
418	Godfrey N.	Hounsfield	Thu Aug 28 1919 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	United Kingdom	GB	Newark	United Kingdom	GB	Kingston upon Thames	male	1979	Medicine	nan	"for the development of computer assisted tomography"	Central Research Laboratories EMI	London	United Kingdom	nan	nan


CREATE TABLE nobel_prize (
  "id" BIGINT,
  "firstname" VARCHAR,
  "surname" VARCHAR,
  "born" TIMESTAMP,
  "died" TIMESTAMP,
  "born_country" VARCHAR,
  "born_country_code" VARCHAR,
  "born_city" VARCHAR,
  "died_country" VARCHAR,
  "died_country_code" VARCHAR,
  "died_city" VARCHAR,
  "gender" VARCHAR,
  "year" BIGINT,
  "category" VARCHAR,
  "overall_motivation" VARCHAR,
  "motivation" VARCHAR,
  "organization_name" VARCHAR,
  "organization_city" VARCHAR,
  "organization_country" VARCHAR,
  "geo_shape" VARCHAR,
  "geo_point_2d" VARCHAR
);