{"id":6135,"date":"2018-12-09T15:35:11","date_gmt":"2018-12-09T23:35:11","guid":{"rendered":"http:\/\/www.couchbase.com\/blog\/?p=6135"},"modified":"2025-06-13T23:43:02","modified_gmt":"2025-06-14T06:43:02","slug":"json-to-insights-nobel-prize-winners-dataset","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/json-to-insights-nobel-prize-winners-dataset\/","title":{"rendered":"De JSON a Insights: Nobel Prize Winners dataset."},"content":{"rendered":"<p>Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (&#8220;It&#8217;s already tomorrow in Australia&#8221;). There is an interesting story of the how <a href=\"https:\/\/en.wikipedia.org\/wiki\/C._V._Raman\">C. V. Raman<\/a> (of <a href=\"https:\/\/en.wikipedia.org\/wiki\/Raman_scattering\">Raman effect<\/a>) booked <a href=\"https:\/\/www.famousscientists.org\/c-v-raman\/\">his ticket to Stockholm<\/a>\u00a0for the December 10th award ceremony even before the announcement because he was confident of winning the prize!<\/p>\n<p>I got this dataset from &#8220;Awesome JSON Datasets&#8221; repo at <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">https:\/\/github.com\/jdorfman\/awesome-json-datasets<\/a><\/p>\n<p>Nobel Prize dataset has three data files:<\/p>\n<ul>\n<li>Laureates\u00a0 &#8212; contains the profile of each laureate.<\/li>\n<\/ul>\n<pre class=\"theme:github tab-size:2 whitespace-before:2 whitespace-after:2 lang:js decode:true\">        {\r\n          \"born\": \"1888-11-07\",\r\n          \"bornCity\": \"Tiruchirappalli\",\r\n          \"bornCountry\": \"India\",\r\n          \"bornCountryCode\": \"IN\",\r\n          \"died\": \"1970-11-21\",\r\n          \"diedCity\": \"Bangalore\",\r\n          \"diedCountry\": \"India\",\r\n          \"diedCountryCode\": \"IN\",\r\n          \"firstname\": \"Sir Chandrasekhara Venkata\",\r\n          \"gender\": \"male\",\r\n          \"id\": \"37\",\r\n          \"prizes\": [\r\n            {\r\n              \"affiliations\": [\r\n                {\r\n                  \"city\": \"Calcutta\",\r\n                  \"country\": \"India\",\r\n                  \"name\": \"Calcutta University\"\r\n                }\r\n              ],\r\n              \"category\": \"physics\",\r\n              \"motivation\": \"\\\"for his work on the scattering of light and for the discovery of the effect named after him\\\"\",\r\n              \"share\": \"1\",\r\n              \"year\": \"1930\"\r\n            }\r\n          ],\r\n          \"surname\": \"Raman\"\r\n        }<\/pre>\n<ul>\n<li>Country &#8212; List of countries and the country code<\/li>\n<\/ul>\n<pre class=\"tab-size:2 whitespace-before:2 whitespace-after:2 lang:js decode:true \">        {\r\n          \"code\": \"AR\",\r\n          \"name\": \"Argentina\"\r\n        },\r\n        {\r\n          \"code\": \"AU\",\r\n          \"name\": \"Australia\"\r\n        },\r\n        {\r\n          \"code\": \"AT\",\r\n          \"name\": \"Austria\"\r\n        },<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Prize &#8212; the list of each prize by year and the winner grouped together.<\/li>\n<\/ul>\n<pre class=\"theme:github whitespace-before:2 whitespace-after:2 lang:default decode:true\">        {\r\n          \"category\": \"physics\",\r\n          \"laureates\": [\r\n            {\r\n              \"firstname\": \"Sin-Itiro\",\r\n              \"id\": \"84\",\r\n              \"motivation\": \"\\\"for their fundamental work in quantum electrodynamics, with deep-ploughing consequences for the physics of elementary particles\\\"\",\r\n              \"share\": \"3\",\r\n              \"surname\": \"Tomonaga\"\r\n            },\r\n            {\r\n              \"firstname\": \"Julian\",\r\n              \"id\": \"85\",\r\n              \"motivation\": \"\\\"for their fundamental work in quantum electrodynamics, with deep-ploughing consequences for the physics of elementary particles\\\"\",\r\n              \"share\": \"3\",\r\n              \"surname\": \"Schwinger\"\r\n            },\r\n            {\r\n              \"firstname\": \"Richard P.\",\r\n              \"id\": \"86\",\r\n              \"motivation\": \"\\\"for their fundamental work in quantum electrodynamics, with deep-ploughing consequences for the physics of elementary particles\\\"\",\r\n              \"share\": \"3\",\r\n              \"surname\": \"Feynman\"\r\n            }\r\n          ],\r\n          \"year\": \"1965\"\r\n        }<\/pre>\n<p>The prize document has an ID that links to the individual winner document in the laureate document.\u00a0<span style=\"font-weight: 400\">Let\u2019s look at Nobel Laureates. \u00a0First, you notice, the prizes information is PLURAL and is stored in an array.\u00a0 One person or an organization can win more than one prize. Let&#8217;s look at who all have won more than one prize.<\/span><\/p>\n<p><b>Task 1. \u00a0How many have won more than one Nobel prizes?<\/b><\/p>\n<p>Query 1: Simply UNNEST the laureates array to get the individual\u00a0prize winners&#8217;\u00a0object and then simply determine and filter by the length of the array.\u00a0 There is one entry per prize.\u00a0 For more on array\u00a0handling and UNNEST operations, see the article: <a href=\"https:\/\/www.couchbase.com\/blog\/working-json-arrays-n1ql\/\">Working with JSON Arrays in N1QL<\/a>.<\/p>\n<pre class=\"\">select\r\n  llist.firstname || \" \" || IFMISSING(llist.surname, \"\"),\r\n  array_length(llist.prizes) numnobel\r\nfrom\r\n  laureate l unnest l.laureates llist\r\nwhere\r\n  array_length(llist.prizes) &gt; 1;<\/pre>\n<pre class=\"lang:js decode:true\">[\r\n  {\r\n    \"$1\": \"Marie Curie, n\u00e9e Sklodowska\",\r\n    \"numnobel\": 2\r\n  },\r\n  {\r\n    \"$1\": \"John Bardeen\",\r\n    \"numnobel\": 2\r\n  },\r\n  {\r\n    \"$1\": \"Linus Carl Pauling\",\r\n    \"numnobel\": 2\r\n  },\r\n  {\r\n    \"$1\": \"Frederick Sanger\",\r\n    \"numnobel\": 2\r\n  },\r\n  {\r\n    \"$1\": \"Comit\u00e9 international de la Croix Rouge (International Committee of the Red Cross) \",\r\n    \"numnobel\": 3\r\n  },\r\n  {\r\n    \"$1\": \"Office of the United Nations High Commissioner for Refugees (UNHCR) \",\r\n    \"numnobel\": 2\r\n  }\r\n]<\/pre>\n<p><strong>Task 2:\u00a0\u00a0Determine which country\u00a0has produced the highest number of Nobel winners.<\/strong><\/p>\n<p>Query 2: Simply unnest laureates and group by the field bornCountry.<\/p>\n<pre class=\"\">select\r\n  llist.bornCountry,\r\n  Count(1) totalPrizes\r\nfrom\r\n  laureate l unnest l.laureates llist\r\ngroup by\r\n  llist.bornCountry\r\norder by\r\n  totalPrizes desc<\/pre>\n<pre class=\"\">[\r\n  {\r\n    \"bornCountry\": \"USA\",\r\n    \"totalPrizes\": 269\r\n  },\r\n  {\r\n    \"bornCountry\": \"United Kingdom\",\r\n    \"totalPrizes\": 84\r\n  },\r\n  {\r\n    \"bornCountry\": \"Germany\",\r\n    \"totalPrizes\": 63\r\n  },\r\n  {\r\n    \"bornCountry\": \"France\",\r\n    \"totalPrizes\": 52\r\n  },\r\n  {\r\n    \"totalPrizes\": 33\r\n  },\r\n  {\r\n    \"bornCountry\": \"Sweden\",\r\n    \"totalPrizes\": 29\r\n  },<\/pre>\n<p>Now, there are 33 winners without a country or origin&#8230; What&#8217;s going on here?<\/p>\n<pre class=\"\">select\r\n  llist.firstname || \" \" || IFMISSING(llist.surname, \"\"),\r\n  llist.gender\r\nfrom\r\n  laureate l unnest l.laureates llist\r\nwhere\r\n  llist.bornCountry is missing;<\/pre>\n<pre class=\"\">  {\r\n    \"$1\": \"Institut de droit international (Institute of International Law) \",\r\n    \"gender\": \"org\"\r\n  },\r\n  {\r\n    \"$1\": \"Bureau international permanent de la Paix (Permanent International Peace Bureau) \",\r\n    \"gender\": \"org\"\r\n  },\r\n  {\r\n    \"$1\": \"Comit\u00e9 international de la Croix Rouge (International Committee of the Red Cross) \",\r\n    \"gender\": \"org\"\r\n  },\r\n...<\/pre>\n<p>These seem\u00a0to be international\u00a0organizations and then a couple of winners whose data is missing bornCountry.<\/p>\n<p><strong>Task 3:\u00a0How many have come from India.<\/strong><\/p>\n<p>Query 3:\u00a0Nobel prizes have been awarded\u00a0since 1901, but India got its independence in 1947. Until 1947, the born country has &#8220;British India&#8221; as the label.\u00a0 \u00a0Let&#8217;s do an extended search.<\/p>\n<pre class=\"\">select\r\n  llist.firstname,\r\n  llist.surname,\r\n  llist.bornCountry as xborncountry,\r\n  llist.diedCountry as ydiedcountry,\r\n  llist.gender as zgender\r\nfrom\r\n  laureate l unnest l.laureates llist\r\nwhere\r\n  llist.bornCountry = \"India\"\r\n  or lower(llist.bornCountry) like \"%india%\"\r\n  or llist.diedCountry = \"India\"<\/pre>\n<pre class=\"\">[\r\n  {\r\n    \"firstname\": \"Sir Chandrasekhara Venkata\",\r\n    \"surname\": \"Raman\",\r\n    \"xborncountry\": \"India\",\r\n    \"ydiedcountry\": \"India\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Abdus\",\r\n    \"surname\": \"Salam\",\r\n    \"xborncountry\": \"India (now Pakistan)\",\r\n    \"ydiedcountry\": \"United Kingdom\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Subramanyan\",\r\n    \"surname\": \"Chandrasekhar\",\r\n    \"xborncountry\": \"India (now Pakistan)\",\r\n    \"ydiedcountry\": \"USA\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Ronald\",\r\n    \"surname\": \"Ross\",\r\n    \"xborncountry\": \"India\",\r\n    \"ydiedcountry\": \"United Kingdom\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Har Gobind\",\r\n    \"surname\": \"Khorana\",\r\n    \"xborncountry\": \"India\",\r\n    \"ydiedcountry\": \"USA\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Mother Teresa\",\r\n    \"xborncountry\": \"Ottoman Empire (now Republic of Macedonia)\",\r\n    \"ydiedcountry\": \"India\",\r\n    \"zgender\": \"female\"\r\n  },\r\n  {\r\n    \"firstname\": \"Rudyard\",\r\n    \"surname\": \"Kipling\",\r\n    \"xborncountry\": \"British India (now India)\",\r\n    \"ydiedcountry\": \"United Kingdom\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Rabindranath\",\r\n    \"surname\": \"Tagore\",\r\n    \"xborncountry\": \"India\",\r\n    \"ydiedcountry\": \"India\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Amartya\",\r\n    \"surname\": \"Sen\",\r\n    \"xborncountry\": \"India\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Muhammad\",\r\n    \"surname\": \"Yunus\",\r\n    \"xborncountry\": \"British India (now Bangladesh)\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Venkatraman\",\r\n    \"surname\": \"Ramakrishnan\",\r\n    \"xborncountry\": \"India\",\r\n    \"zgender\": \"male\"\r\n  },\r\n  {\r\n    \"firstname\": \"Kailash\",\r\n    \"surname\": \"Satyarthi\",\r\n    \"xborncountry\": \"India\",\r\n    \"zgender\": \"male\"\r\n  }\r\n]<\/pre>\n<p>Some surprising results!\u00a0 In addition to the well known Indian Nobel Laureates, a couple of famous UK winners, including Rudyard Kipling, were born in India. There is only one winner who wasn&#8217;t born in India but died there: Mother Theresa.<\/p>\n<p>Let&#8217;s find out the categories.<\/p>\n<pre class=\"\">select\r\n  lp.category,\r\n  COUNT(1) prizecount\r\nfrom\r\n  laureate l unnest l.laureates llist unnest llist.prizes lp\r\nwhere\r\n  llist.bornCountry = \"India\"\r\n  or lower(llist.bornCountry) like \"%india%\"\r\n  or llist.diedCountry = \"India\"\r\n  or lower(llist.diedCountry) like \"%india%\"\r\ngroup by\r\n  lp.category\r\norder by\r\n  prizecount DESC<\/pre>\n<pre class=\"\">category     prizecount\r\npeace          3\r\nphysics        3\r\nliterature     2  \r\nmedicine       2\r\neconomics      1 \r\nchemistry      1<\/pre>\n<p><strong>Task 4: Create a stacked graph of top 7 countries to win Nobel Prizes with categofy<\/strong><\/p>\n<pre class=\"\">select\r\n  llist.bornCountry as xborncountry,\r\n  lp.category ycategory,\r\n  COUNT(1) zprizecount,\r\n  SUM(COUNT(1)) OVER(partition by llist.bornCountry) z1countrytot,\r\n  SUM(COUNT(1)) OVER(\r\n    partition by llist.bornCountry\r\n    order by\r\n      lp.category\r\n  ) z1ctrycatcount\r\nfrom\r\n  laureate l unnest l.laureates llist unnest llist.prizes lp\r\ngroup by\r\n  llist.bornCountry,\r\n  lp.category\r\norder by\r\n  z1countrytot desc,\r\n  ycategory<\/pre>\n<p>Results (Subset for brevity)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-6139 alignleft\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-300x100.png\" alt=\"\" width=\"495\" height=\"165\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-300x100.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-1024x341.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-768x256.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-20x7.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM-1320x440.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.23.31-AM.png 1506w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>From this, let&#8217;s create a stacked-column graph of top-7 countries and show the prizes by category.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-6142 alignleft\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-300x182.png\" alt=\"\" width=\"658\" height=\"399\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-300x182.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-1024x622.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-768x466.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-1536x932.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-20x12.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM-1320x801.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/Screen-Shot-2018-12-10-at-12.30.50-AM.png 1766w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>All these data manipulations are for fun and learning. But, the progress and peace these winners have made sans borders.<\/p>\n<p>You can download the <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">dataset<\/a> and <a href=\"https:\/\/www.couchbase.com\">Couchbase<\/a>. Then ask your own interesting questions and answer them!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (&#8220;It&#8217;s already tomorrow in Australia&#8221;). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to [&hellip;]<\/p>\n","protected":false},"author":55,"featured_media":6136,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[2317,1261,1725],"ppma_author":[8929],"class_list":["post-6135","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query","tag-insights","tag-json","tag-nosql-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>JSON to Insights: Nobel Prize Winners dataset. - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/json-to-insights-nobel-prize-winners-dataset\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JSON to Insights: Nobel Prize Winners dataset.\" \/>\n<meta property=\"og:description\" content=\"Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (&#8220;It&#8217;s already tomorrow in Australia&#8221;). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/json-to-insights-nobel-prize-winners-dataset\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-09T23:35:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T06:43:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/c261644262bf98e146372fe647682636\"},\"headline\":\"JSON to Insights: Nobel Prize Winners dataset.\",\"datePublished\":\"2018-12-09T23:35:11+00:00\",\"dateModified\":\"2025-06-14T06:43:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/\"},\"wordCount\":458,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2018\\\/12\\\/nobel2018.jpg\",\"keywords\":[\"insights\",\"JSON\",\"NoSQL Database\"],\"articleSection\":[\"SQL++ \\\/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/\",\"name\":\"JSON to Insights: Nobel Prize Winners dataset. - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2018\\\/12\\\/nobel2018.jpg\",\"datePublished\":\"2018-12-09T23:35:11+00:00\",\"dateModified\":\"2025-06-14T06:43:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2018\\\/12\\\/nobel2018.jpg\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2018\\\/12\\\/nobel2018.jpg\",\"width\":900,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/json-to-insights-nobel-prize-winners-dataset\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JSON to Insights: Nobel Prize Winners dataset.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, and has received twenty four US patents.\",\"sameAs\":[\"https:\\\/\\\/blog.planetnosql.com\\\/\",\"https:\\\/\\\/x.com\\\/rkeshavmurthy\"],\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/es\\\/author\\\/keshav-murthy\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JSON to Insights: Nobel Prize Winners dataset. - The Couchbase Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/es\/json-to-insights-nobel-prize-winners-dataset\/","og_locale":"es_MX","og_type":"article","og_title":"JSON to Insights: Nobel Prize Winners dataset.","og_description":"Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (&#8220;It&#8217;s already tomorrow in Australia&#8221;). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/es\/json-to-insights-nobel-prize-winners-dataset\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-12-09T23:35:11+00:00","article_modified_time":"2025-06-14T06:43:02+00:00","og_image":[{"width":900,"height":530,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg","type":"image\/jpeg"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"JSON to Insights: Nobel Prize Winners dataset.","datePublished":"2018-12-09T23:35:11+00:00","dateModified":"2025-06-14T06:43:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/"},"wordCount":458,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg","keywords":["insights","JSON","NoSQL Database"],"articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/","url":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/","name":"JSON to Insights: Nobel Prize Winners dataset. - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg","datePublished":"2018-12-09T23:35:11+00:00","dateModified":"2025-06-14T06:43:02+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/12\/nobel2018.jpg","width":900,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JSON to Insights: Nobel Prize Winners dataset."}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636","name":"Keshav Murthy","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"Keshav Murthy es Vicepresidente de Couchbase R&amp;D. Anteriormente, estuvo en MapR, IBM, Informix, Sybase, con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o y desarrollo de bases de datos. Dirigi\u00f3 el equipo de I+D de SQL y NoSQL en IBM Informix. Ha recibido dos premios President's Club en Couchbase y dos premios Outstanding Technical Achievement en IBM. Keshav es licenciado en Inform\u00e1tica e Ingenier\u00eda por la Universidad de Mysore, India, y ha recibido veinticuatro patentes estadounidenses.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/keshav-murthy\/"}]}},"acf":[],"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/6135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=6135"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/6135\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/6136"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=6135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=6135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=6135"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=6135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}