{"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\/pt\/json-to-insights-nobel-prize-winners-dataset\/","title":{"rendered":"JSON para Insights: Conjunto de dados dos ganhadores do Pr\u00eamio Nobel."},"content":{"rendered":"<p>Os pr\u00eamios Nobel s\u00e3o anunciados durante uma semana em outubro e a cerim\u00f4nia de premia\u00e7\u00e3o \u00e9 hoje, 10 de dezembro (\"J\u00e1 \u00e9 amanh\u00e3 na Austr\u00e1lia\"). H\u00e1 uma hist\u00f3ria interessante sobre como <a href=\"https:\/\/en.wikipedia.org\/wiki\/C._V._Raman\">C. V. Raman<\/a> (de <a href=\"https:\/\/en.wikipedia.org\/wiki\/Raman_scattering\">Efeito Raman<\/a>) reservado <a href=\"https:\/\/www.famousscientists.org\/c-v-raman\/\">sua passagem para Estocolmo<\/a>\u00a0para a cerim\u00f4nia de premia\u00e7\u00e3o de 10 de dezembro, mesmo antes do an\u00fancio, porque ele estava confiante de que ganharia o pr\u00eamio!<\/p>\n<p>Obtive esse conjunto de dados do reposit\u00f3rio \"Awesome JSON Datasets\" em <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">https:\/\/github.com\/jdorfman\/awesome-json-datasets<\/a><\/p>\n<p>O conjunto de dados do Pr\u00eamio Nobel tem tr\u00eas arquivos de dados:<\/p>\n<ul>\n<li>Laureados - cont\u00e9m o perfil de cada laureado.<\/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 e o c\u00f3digo do 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>Pr\u00eamio - a lista de cada pr\u00eamio por ano e o vencedor agrupados.<\/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>O documento do pr\u00eamio tem um ID vinculado ao documento do vencedor individual no documento do laureado.\u00a0<span style=\"font-weight: 400\">Vamos dar uma olhada nos ganhadores do Pr\u00eamio Nobel.  Primeiro, observe que as informa\u00e7\u00f5es sobre os pr\u00eamios s\u00e3o PLURAIS e est\u00e3o armazenadas em uma matriz.  Uma pessoa ou uma organiza\u00e7\u00e3o pode ganhar mais de um pr\u00eamio. Vamos ver quem ganhou mais de um pr\u00eamio.<\/span><\/p>\n<p><b>Tarefa 1.  Quantos ganharam mais de um pr\u00eamio Nobel?<\/b><\/p>\n<p>Consulta 1: Basta UNNESTar a matriz de laureados para obter o objeto dos vencedores dos pr\u00eamios individuais e, em seguida, determinar e filtrar pelo comprimento da matriz.  H\u00e1 uma entrada por pr\u00eamio.  Para saber mais sobre o manuseio de matrizes e opera\u00e7\u00f5es UNNEST, consulte o artigo: <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/working-json-arrays-n1ql\/\">Trabalhando com matrizes JSON no 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>Tarefa 2: Determine qual pa\u00eds produziu o maior n\u00famero de ganhadores do Pr\u00eamio Nobel.<\/strong><\/p>\n<p>Consulta 2: Simplesmente anule os laureados e agrupe pelo 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>Agora, h\u00e1 33 vencedores sem um pa\u00eds ou origem... O que est\u00e1 acontecendo aqui?<\/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>Essas parecem ser organiza\u00e7\u00f5es internacionais e, em seguida, alguns vencedores cujos dados est\u00e3o faltando no bornCountry.<\/p>\n<p><strong>Tarefa 3: Quantos vieram da \u00cdndia.<\/strong><\/p>\n<p>Pergunta 3: Os pr\u00eamios Nobel s\u00e3o concedidos desde 1901, mas a \u00cdndia obteve sua independ\u00eancia em 1947. At\u00e9 1947, o pa\u00eds de origem tinha \"\u00cdndia Brit\u00e2nica\" como r\u00f3tulo.   Vamos fazer uma pesquisa 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>Alguns resultados surpreendentes!  Al\u00e9m dos conhecidos ganhadores indianos do Pr\u00eamio Nobel, alguns ganhadores famosos do Reino Unido, incluindo Rudyard Kipling, nasceram na \u00cdndia. H\u00e1 apenas um ganhador que n\u00e3o nasceu na \u00cdndia, mas morreu l\u00e1: Madre Teresa.<\/p>\n<p>Vamos descobrir as categorias.<\/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>Tarefa 4: Crie um gr\u00e1fico empilhado dos 7 pa\u00edses que mais ganharam pr\u00eamios Nobel com categoria<\/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 fins de brevidade)<\/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 disso, vamos criar um gr\u00e1fico de colunas empilhadas dos sete principais pa\u00edses e mostrar os pr\u00eamios por categoria.<\/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 essas manipula\u00e7\u00f5es de dados s\u00e3o para divers\u00e3o e aprendizado. Mas o progresso e a paz que esses vencedores alcan\u00e7aram sem fronteiras.<\/p>\n<p>Voc\u00ea pode fazer o download do <a href=\"https:\/\/github.com\/jdorfman\/awesome-json-datasets\">conjunto de dados<\/a> e <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/\">Couchbase<\/a>. Em seguida, fa\u00e7a suas pr\u00f3prias perguntas interessantes e responda-as!<\/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.1 (Yoast SEO v26.1.1) - 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\/pt\/json-to-insights-nobel-prize-winners-dataset\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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\/pt\/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\":\"pt-BR\",\"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\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\":\"pt-BR\",\"@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\/pt\/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\/pt\/json-to-insights-nobel-prize-winners-dataset\/","og_locale":"pt_BR","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\/pt\/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":"pt-BR","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":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/json-to-insights-nobel-prize-winners-dataset\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@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":"Blog do Couchbase","description":"Couchbase, o banco de dados 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":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@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":"pt-BR","@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 \u00e9 vice-presidente de P&amp;D da Couchbase. Anteriormente, ele trabalhou na MapR, IBM, Informix e Sybase, com mais de 20 anos de experi\u00eancia em design e desenvolvimento de bancos de dados. Ele liderou a equipe de P&amp;D de SQL e NoSQL na IBM Informix. Ele recebeu dois pr\u00eamios President's Club na Couchbase e dois Outstanding Technical Achievement Awards na IBM. Keshav \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o e Engenharia pela Universidade de Mysore, \u00cdndia, det\u00e9m onze patentes nos EUA e tem quatro patentes pendentes nos EUA.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/pt\/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 \u00e9 vice-presidente de P&amp;D da Couchbase. Anteriormente, ele trabalhou na MapR, IBM, Informix e Sybase, com mais de 20 anos de experi\u00eancia em design e desenvolvimento de bancos de dados. Ele liderou a equipe de P&amp;D de SQL e NoSQL na IBM Informix. Recebeu dois pr\u00eamios President's Club na Couchbase e dois Outstanding Technical Achievement Awards na IBM. Keshav \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o e Engenharia pela Universidade de Mysore, \u00cdndia, det\u00e9m dez patentes nos EUA e tem tr\u00eas patentes pendentes nos EUA."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/6135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=6135"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/6135\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/6136"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=6135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=6135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=6135"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=6135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}