{"id":6135,"date":"2018-12-09T15:35:11","date_gmt":"2018-12-09T23:35:11","guid":{"rendered":"https:\/\/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>Los premios Nobel se anuncian durante una semana en octubre y la ceremonia de entrega es hoy, 10 de diciembre (\"en Australia ya es ma\u00f1ana\"). Hay una interesante historia de c\u00f3mo <a href=\"https:\/\/en.wikipedia.org\/wiki\/C._V._Raman\">C. V. Raman<\/a> (de <a href=\"https:\/\/en.wikipedia.org\/wiki\/Raman_scattering\">Efecto Raman<\/a>) reservado <a href=\"https:\/\/www.famousscientists.org\/c-v-raman\/\">su billete a Estocolmo<\/a>\u00a0para la ceremonia de entrega de premios del 10 de diciembre incluso antes del anuncio, porque confiaba en ganar el premio.<\/p>\n<p>Obtuve este conjunto de datos del repositorio \"Awesome JSON Datasets\" en <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">https:\/\/github.com\/jdorfman\/awesome-json-datasets<\/a><\/p>\n<p>El conjunto de datos del Premio Nobel tiene tres archivos de datos:<\/p>\n<ul>\n<li>Laureados - contiene el perfil de cada galardonado.<\/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>Pa\u00eds - Lista de pa\u00edses y c\u00f3digo de pa\u00eds<\/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>Premio - la lista de cada premio por a\u00f1o y el ganador agrupado.<\/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>El documento del premio tiene un ID que enlaza con el documento individual del ganador en el documento del galardonado.\u00a0<span style=\"font-weight: 400\">Veamos los premios Nobel.  En primer lugar, observe que la informaci\u00f3n sobre los premios es PLURAL y se almacena en una matriz.  Una persona o una organizaci\u00f3n puede ganar m\u00e1s de un premio. Veamos qui\u00e9nes han ganado m\u00e1s de un premio.<\/span><\/p>\n<p><b>Tarea 1.  \u00bfCu\u00e1ntos han ganado m\u00e1s de un premio Nobel?<\/b><\/p>\n<p>Consulta 1: Simplemente UNNEST la matriz de laureados para obtener el objeto individual de los ganadores del premio y luego simplemente determinar y filtrar por la longitud de la matriz.  Hay una entrada por premio.  Para m\u00e1s informaci\u00f3n sobre el manejo de matrices y las operaciones UNNEST, consulte el art\u00edculo: <a href=\"https:\/\/www.couchbase.com\/blog\/es\/working-json-arrays-n1ql\/\">Trabajando con Arrays JSON en 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>Tarea 2: Determinar qu\u00e9 pa\u00eds ha producido el mayor n\u00famero de premios Nobel.<\/strong><\/p>\n<p>Consulta 2: simplemente anule los laureados y agr\u00fapelos por el campo 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>Ahora, hay 33 ganadores sin pa\u00eds ni origen... \u00bfQu\u00e9 est\u00e1 pasando aqu\u00ed?<\/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>Parece que se trata de organizaciones internacionales y luego un par de ganadores cuyos datos faltan bornCountry.<\/p>\n<p><strong>Tarea 3: Cu\u00e1ntos han venido de la India.<\/strong><\/p>\n<p>Pregunta 3: Los premios Nobel se conceden desde 1901, pero India obtuvo su independencia en 1947. Hasta 1947, el pa\u00eds de nacimiento tiene como etiqueta \"British India\".   Hagamos una b\u00fasqueda ampliada.<\/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>Resultados sorprendentes  Adem\u00e1s de los conocidos Premios Nobel indios, un par de famosos ganadores brit\u00e1nicos, entre ellos Rudyard Kipling, nacieron en la India. S\u00f3lo hay un ganador que no naci\u00f3 en la India pero muri\u00f3 all\u00ed: La Madre Teresa.<\/p>\n<p>Descubramos las categor\u00edas.<\/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>Tarea 4: Crear un gr\u00e1fico apilado de los 7 pa\u00edses que m\u00e1s premios Nobel han ganado con 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>Resultados (subconjunto para abreviar)<\/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>A partir de aqu\u00ed, vamos a crear un gr\u00e1fico de columnas apiladas de los 7 primeros pa\u00edses y mostrar los premios por categor\u00eda.<\/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>Todas estas manipulaciones de datos son para divertirse y aprender. Pero, el progreso y la paz que estos ganadores han logrado sin fronteras.<\/p>\n<p>Puede descargar el <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">conjunto de datos<\/a> y <a href=\"https:\/\/www.couchbase.com\/blog\/es\/\">Couchbase<\/a>. A continuaci\u00f3n, formula tus propias preguntas interesantes y resp\u00f3ndelas.<\/p>","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>","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"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.0 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\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:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"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, holds eleven US patents and has four US patents pending.\",\"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:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","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), es titular de once patentes estadounidenses y tiene cuatro pendientes.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/keshav-murthy\/"}]}},"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","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","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), es titular de diez patentes estadounidenses y tiene tres pendientes."}],"_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}]}}