{"id":6111,"date":"2018-12-07T16:42:43","date_gmt":"2018-12-08T00:42:43","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=6111"},"modified":"2025-06-13T18:44:57","modified_gmt":"2025-06-14T01:44:57","slug":"json-insights-analyze-usa-healthcare-data","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/json-insights-analyze-usa-healthcare-data\/","title":{"rendered":"\uc778\uc0ac\uc774\ud2b8\uc5d0 \ub300\ud55c JSON: \ubbf8\uad6d \uc758\ub8cc \uc11c\ube44\uc2a4 \ub370\uc774\ud130 \ubd84\uc11d."},"content":{"rendered":"

\"\uc8fd\uc74c\uacfc \uc138\uae08 \uc678\uc5d0\ub294 \ud655\uc2e4\ud55c \uac83\uc740 \uc5c6\uc2b5\ub2c8\ub2e4.\"<\/p><\/blockquote>\n

\uc774\uac83\uc740 \ub370\uc774\ud130 \uc138\ud2b8\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uc7a5\ubbf8\uc758 \uce68\ub300<\/a> \ub610\ub294 \uc798 \ub2e4\ub4ec\uc5b4\uc9c4 \ub179\uc0c9 \uc794\ub514<\/a>. \uc870\uae08 \ub354 \uc2ec\uac01\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ube60\ub974\uac8c \ubc30\uc6b8 \uc218 \uc788\ub294 \uac83\uc774 \uc788\ub294\uc9c0 \uc0b4\ud3b4\ubd05\uc2dc\ub2e4.\u00a0<\/span>\ub370\uc774\ud130 \uc138\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\"name\" : \"NCHS - \uc8fc\uc694 \uc0ac\ub9dd \uc6d0\uc778: \ubbf8\uad6d\",<\/b> <\/b>
\n\"\uc18d\uc131\" : \"\uad6d\ub9bd \ubcf4\uac74 \ud1b5\uacc4 \uc13c\ud130\",<\/b><\/p>\n

\ub300\uc911 d<\/span>\uc544\ud0c0\uc14b\uc740 \ub2e4\uc74c\uc5d0\uc11c \uad6c\uc785\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/span>https:\/\/data.cdc.gov\/api\/views\/bi63-dtpu\/rows.json?accessType=DOWNLOAD<\/span><\/a><\/p>\n

1\ub2e8\uacc4: <\/b>\ud30c\uc77c\uc744 \ub85c\uceec \ud30c\uc77c(\uc608: health.json)\ub85c \ub2e4\uc6b4\ub85c\ub4dc\ud569\ub2c8\ub2e4.\u00a0\uc774 \ud30c\uc77c\uc744 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud074\ub7ec\uc2a4\ud130\uc758 \ub178\ub4dc \uc911 \ud558\ub098\uc5d0 \uc5c5\ub85c\ub4dc\ud569\ub2c8\ub2e4.<\/span><\/p>\n

2\ub2e8\uacc4<\/strong>\ub77c\ub294 \ubc84\ud0b7\uc73c\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. \ubc84\ud0b7\uc744 \ub9cc\ub4e0 \ud6c4\uc5d0\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uc704\ud574 \uc774 \uc778\ub371\uc2a4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\/opt\/couchbase\/bin\/cbimport json -c couchbase:\/\/127.0.0.1 -u \uad00\ub9ac\uc790 -p \ube44\ubc00\ubc88\ud638 -b \uc6d0\uc778 -d \ud30c\uc77c:\/\/health.json -g \uc6d0\uc778:0 -f \uc0d8\ud50c<\/b><\/p>\n

>\u00a0\uc6d0\uc778\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4;<\/b><\/strong><\/p>\n

3\ub2e8\uacc4<\/strong>. \ub370\uc774\ud130\uc758 \uad6c\uc870\ub97c \uac80\uc0ac\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ubaa8\ub4e0 \ub370\uc774\ud130\ub294 \ub2e8\uc77c JSON \ubb38\uc11c\ub85c \uc81c\uacf5\ub429\ub2c8\ub2e4. \ub530\ub77c\uc11c INFER\ub294 \ub3c4\uc6c0\uc774 \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uad6c\uc870\ub97c \uc218\ub3d9\uc73c\ub85c \uac80\uc0ac\ud558\uace0 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4.\u00a0\uc774 \ub370\uc774\ud130\ub294 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \uac01 \uc5d4\ud2f0\ud2f0\uc758 \uc758\ubbf8\uc640 \ud568\uaed8 \ub2e8\uc21c\ud55c \ubc30\uc5f4\ub85c \ub41c \ub9ce\uc740 \ub370\uc774\ud130\uac00 \uc788\ub294 \uc77c\ubc18\uc801\uc778 \uc815\ubd80 \ub370\uc774\ud130 \uc138\ud2b8\uc785\ub2c8\ub2e4.<\/span><\/p>\n

\ub2e8\uc21c \ubc30\uc5f4:<\/span><\/p>\n

select data from cause ;<\/strong><\/pre>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uc5ec\uae30\uc5d0\ub294 \uc2a4\ud0a4\ub9c8 \uc5c6\uc774 \ub2e8\uc21c\ud788 \ub370\uc774\ud130 \ubc30\uc5f4\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.  \uacf5\uac1c \ub370\uc774\ud130 \uc9d1\ud569\uc758 \uacbd\uc6b0 \uc2a4\ud0a4\ub9c8\ub294 \uba54\ud0c0 \ud544\ub4dc\uc5d0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uad6c\uc870\ub97c \uac04\ub2e8\ud55c JSON \ud0a4-\uac12 \uc30d\uc73c\ub85c \ubcc0\ud658\ud558\uc5ec \uc880 \ub354 \ud6a8\uacfc\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.  \uc774 \ub9c8\ubc95\uc774 \uc5b4\ub5bb\uac8c \uc77c\uc5b4\ub0ac\ub294\uc9c0 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. \uc774 \ubb38\uc11c\uc5d0\uc11c<\/a>.<\/span><\/p>\n
WITH cs AS (\r\n  SELECT\r\n    meta.`view`.columns [*].fieldName f,\r\n    data\r\n  FROM\r\n    cause\r\n)\r\nSELECT\r\n  o\r\nFROM\r\n  cs UNNEST cs.data AS d1 \r\nLET o = OBJECT p :d1 [ARRAY_POSITION(cs.f, p)] FOR p IN cs.f END;<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uacfc\uc81c1: \ud55c \uc8fc\uc5d0\uc11c \uc5f0\ub3c4\ubcc4\ub85c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\ub9dd\ud55c \uc6d0\uc778\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/strong><\/h5>\n
WITH \uc808\uc758 \uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd(CTE)\uc740 \ubcf5\uc7a1\ud55c json \ub370\uc774\ud130\ub97c \ud50c\ub7ab JSON\uc73c\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4(csdata).   \uc774 \uc791\uc5c5\uc744 \ub3d9\uc801\uc73c\ub85c \uc218\ud589\ud558\uac70\ub098, \uc774 \uc791\uc5c5\uc744 \ud55c \ubc88 \uc218\ud589\ud55c \ud6c4 \ubc84\ud0b7\uc5d0 \ub2e4\uc2dc INSERT\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub274\uc695 \uc544\uae30 \uc774\ub984<\/a>. \uc774 \uae00\uc5d0\uc11c\ub294 CTE\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
WITH csdata as (\r\n  WITH cs AS (\r\n    SELECT\r\n      meta.`view`.columns [*].fieldName f,\r\n      data\r\n    FROM\r\n      cause\r\n  )\r\n  SELECT\r\n    o\r\n  FROM\r\n    cs UNNEST cs.data AS d1 LET o = OBJECT p :d1 [ARRAY_POSITION(cs.f, p)] FOR p IN cs.f END\r\n)\r\nSELECT\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name,\r\n  COUNT(c.o.cause_name),\r\n  SUM(TONUMBER(c.o.deaths)) totdeaths\r\nFROM\r\n  csdata as c\r\nWHERE\r\n  c.o.state <> \"United States\"\r\n  and c.o.cause_name <> \"All causes\"\r\nGROUP BY\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name\r\nORDER BY\r\n  totdeaths DESC,\r\n  c.o.state,\r\n  c.o.year<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uc774 \uacbd\uc6b0 \uce98\ub9ac\ud3ec\ub2c8\uc544\uc758 \ubaa8\ub4e0 \uc0ac\ub9dd\uc790\ub294 \uc8fc\ub85c \uc778\uad6c\ub85c \uc778\ud574 \uac00\uc7a5 \ub9ce\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n
\uacfc\uc81c 2. 2016\ub144 \ud55c \ud574 \ub3d9\uc548 \uac01 \uc8fc\uc758 \uc8fc\uc694 \uc0ac\ub9dd \uc6d0\uc778\uc744 \uc54c\uc544\ubcf4\uc138\uc694.<\/strong><\/p>\n
\ucffc\ub9ac 2: <\/strong>\uc774\uc804 \ucffc\ub9ac\uc758 \uacb0\uacfc \uc9d1\ud569\uc744 \uc0ac\uc6a9\ud55c \ub2e4\uc74c FIRST_VALUE() \ucc3d \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c1\uc704 \uc6d0\uc778\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.  OVER BY \uc808\uc5d0\uc11c \uc0c1\ud0dc\ubcc4\ub85c \ud30c\ud2f0\uc158\uc744 \ub098\ub204\uba74 \uc0c1\ud0dc\ubcc4 \ud30c\ud2f0\uc158\uc744 \uc5bb\uc744 \uc218 \uc788\uace0, OVER BY \uc808 \ub0b4\uc5d0\uc11c ORDER BY dx.totdeaths\ub97c \uc0ac\uc6a9\ud558\uba74 \ubaa8\ub4e0 \uc0c1\ud0dc\uc758 \uc0c1\uc704 \uc6d0\uc778\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
WITH csdata as (\r\n  WITH cs AS (\r\n    SELECT\r\n      meta.`view`.columns [*].fieldName f,\r\n      data\r\n    FROM\r\n      cause\r\n  )\r\n  SELECT\r\n    o\r\n  FROM\r\n    cs UNNEST cs.data AS d1 LET o = OBJECT p :d1 [ARRAY_POSITION(cs.f, p)] FOR p IN cs.f END\r\n),\r\nd2 as(\r\nSELECT\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name,\r\n  SUM(TONUMBER(c.o.deaths)) totdeaths\r\nFROM\r\n  csdata as c\r\nWHERE\r\n  c.o.state <> \"United States\"\r\n  and c.o.cause_name <> \"All causes\"\r\n  and c.o.year = \"2016\"\r\nGROUP BY\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name),\r\nd3 as (\r\nSELECT dx.state, dx.cause_name, dx.totdeaths,\r\n  FIRST_VALUE(dx.cause_name) OVER(PARTITION BY dx.state ORDER BY dx.totdeaths DESC) topreason,\r\n  FIRST_VALUE(dx.totdeaths) OVER(PARTITION BY dx.state ORDER BY dx.totdeaths DESC) topcount\r\nFROM d2 dx)\r\nSELECT d3\r\nFROM d3\r\nWHERE d3.topcount = d3.totdeaths\r\norder by d3.state<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uc791\uc5c5 3.\u00a0\u00a0<\/strong>1999\ub144\ubd80\ud130 2016\ub144\uae4c\uc9c0 \uc8fc\ubcc4\ub85c \uac00\uc7a5 \ud070 \uc774\uc720\uac00 \uc5f0\ub3c4\ubcc4\ub85c \uc5b4\ub5bb\uac8c \ubcc0\ud654\ud588\ub294\uc9c0 \uc54c\uc544\ubcf4\uc138\uc694.<\/p>\n
\ucffc\ub9ac 3:\u00a0\u00a0<\/strong>\ubaa8\ub4e0 \uc5f0\ub3c4(199-2016)\uc5d0 \ub300\ud55c \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud55c \ub2e4\uc74c \uc8fc, \uc5f0\ub3c4\ubcc4\ub85c \uadf8\ub8f9\ud654\ud558\uace0 \ucd5c\uace0 \uc774\uc720\uc5d0 \ub300\ud55c \ucd5c\ub300\uac12(\ucd5c\uace0 \uc218)\uc744 \uad6c\ud558\uc5ec \ucd5c\uace0 \uc774\uc720\ub97c \uacb0\uc815\ud558\uba74 \ucd5c\uc885\uc801\uc73c\ub85c \ucd5c\uace0 \uc774\uc720\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
WITH csdata as (\r\n  WITH cs AS (\r\n    SELECT\r\n      meta.`view`.columns [*].fieldName f,\r\n      data\r\n    FROM\r\n      cause\r\n  )\r\n  SELECT\r\n    o\r\n  FROM\r\n    cs UNNEST cs.data AS d1 LET o = OBJECT p :d1 [ARRAY_POSITION(cs.f, p)] FOR p IN cs.f END\r\n),\r\nd2 as(\r\nSELECT\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name,\r\n  SUM(TONUMBER(c.o.deaths)) totdeaths\r\nFROM\r\n  csdata as c\r\nWHERE\r\n  c.o.state <> \"United States\" \r\n  and c.o.cause_name <> \"All causes\"\r\nGROUP BY\r\n  c.o.state,\r\n  c.o.year,\r\n  c.o.cause_name),\r\nd3 as (\r\nSELECT dx.state, dx.year,\r\n  FIRST_VALUE(dx.cause_name) OVER(PARTITION BY dx.state, dx.year ORDER BY dx.totdeaths DESC ) topreason,\r\n  FIRST_VALUE(dx.totdeaths) OVER(PARTITION BY dx.state, dx.year ORDER BY dx.totdeaths DESC) topcount\r\nFROM d2 dx)\r\nSELECT d3.state , d3.year , d3.topreason, max(d3.topcount) topcount\r\nFROM d3\r\nGROUP BY d3.state, d3.year, d3.topreason\r\norder by d3.state, d3.year<\/pre>\n
\ub2e4\uc74c\uc740 \uc77c\ubd80 \uacb0\uacfc\uc785\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
\uc774\ub97c \uc2dc\uac01\ud654\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ud788\uc2a4\ud1a0\uadf8\ub7a8\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>","protected":false},"excerpt":{"rendered":"
\u201cNothing is certain except for death and taxes.\u201d This isn\u2019t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let\u2019s see if we can quickly learn anything here.\u00a0The dataset is the following. “name” […]<\/p>","protected":false},"author":55,"featured_media":7451,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1814,1815,1812],"tags":[2378,2318,2317,1261,1725],"ppma_author":[8929],"class_list":["post-6111","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-design","category-best-practices-and-tutorials","category-n1ql-query","tag-6-5","tag-healthcare","tag-insights","tag-json","tag-nosql-database"],"acf":[],"yoast_head":"\nJSON to Insights: Analyzing US healthcare Data. - 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\/ko\/json-insights-analyze-usa-healthcare-data\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JSON to Insights: Analyzing US healthcare Data.\" \/>\n<meta property=\"og:description\" content=\"\u201cNothing is certain except for death and taxes.\u201d This isn\u2019t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let\u2019s see if we can quickly learn anything here.\u00a0The dataset is the following. “name” […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/json-insights-analyze-usa-healthcare-data\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-08T00:42:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:44:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"553\" \/>\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\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"JSON to Insights: Analyzing US healthcare Data.\",\"datePublished\":\"2018-12-08T00:42:43+00:00\",\"dateModified\":\"2025-06-14T01:44:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/\"},\"wordCount\":548,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg\",\"keywords\":[\"6.5\",\"healthcare\",\"insights\",\"JSON\",\"NoSQL Database\"],\"articleSection\":[\"Application Design\",\"Best Practices and Tutorials\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/\",\"name\":\"JSON to Insights: Analyzing US healthcare Data. - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg\",\"datePublished\":\"2018-12-08T00:42:43+00:00\",\"dateModified\":\"2025-06-14T01:44:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg\",\"width\":1400,\"height\":553},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JSON to Insights: Analyzing US healthcare Data.\"}]},{\"@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\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@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\":\"ko-KR\",\"@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&D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design & development. He lead the SQL and NoSQL R&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\/ko\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JSON to Insights: Analyzing US healthcare Data. - 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\/ko\/json-insights-analyze-usa-healthcare-data\/","og_locale":"ko_KR","og_type":"article","og_title":"JSON to Insights: Analyzing US healthcare Data.","og_description":"\u201cNothing is certain except for death and taxes.\u201d This isn\u2019t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let\u2019s see if we can quickly learn anything here.\u00a0The dataset is the following. “name” […]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/json-insights-analyze-usa-healthcare-data\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-12-08T00:42:43+00:00","article_modified_time":"2025-06-14T01:44:57+00:00","og_image":[{"width":1400,"height":553,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.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\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"JSON to Insights: Analyzing US healthcare Data.","datePublished":"2018-12-08T00:42:43+00:00","dateModified":"2025-06-14T01:44:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/"},"wordCount":548,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg","keywords":["6.5","healthcare","insights","JSON","NoSQL Database"],"articleSection":["Application Design","Best Practices and Tutorials","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/","url":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/","name":"JSON to Insights: Analyzing US healthcare Data. - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg","datePublished":"2018-12-08T00:42:43+00:00","dateModified":"2025-06-14T01:44:57+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Transactions-alternative-3.jpg","width":1400,"height":553},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/json-insights-analyze-usa-healthcare-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JSON to Insights: Analyzing US healthcare Data."}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","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":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@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":"\ucf00\uc0e4\ube0c \uba38\uc2dc","image":{"@type":"ImageObject","inLanguage":"ko-KR","@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":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 Outstanding Technical Achievement Award\ub97c \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 11\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 4\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/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","first_name":"Keshav","last_name":"Murthy","user_url":"https:\/\/blog.planetnosql.com\/","author_category":"","description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ubc88\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ubc88\uc758 \uc6b0\uc218 \uae30\uc220 \uc5c5\uc801\uc0c1\uc744 \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 10\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 3\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/6111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=6111"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/6111\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/7451"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=6111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=6111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=6111"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=6111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}