{"id":584,"date":"2021-12-06T10:25:00","date_gmt":"2021-12-06T10:25:00","guid":{"rendered":"https:\/\/healthanalyticinsights.com\/?p=584"},"modified":"2024-03-01T17:54:27","modified_gmt":"2024-03-01T17:54:27","slug":"sql-queries-you-need-to-know-in-health-informatics","status":"publish","type":"post","link":"https:\/\/healthanalyticinsights.com\/?p=584","title":{"rendered":"SQL Queries You Need to Know in Health Informatics"},"content":{"rendered":"\n<figure class=\"wp-embed-aspect-16-9 wp-has-aspect-ratio wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Health Informatics - Day in the Life\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/KcHWZ8bc5yc?start=2&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\">In this video I speak about the importance of using SQL in some health informatics positions. <\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post, I am going to go over some common SQL queries that are used in the health informatics field. Experience writing SQL queries is a common skill listed on many health informatics roles because knowing how to &#8220;slice and dice&#8221; raw, unstructured into actionable insights can be a large part of the role. Healthcare data is oftentimes messy and can come from multiple sources: it can be entered in manually, it can be sourced from the EHR\/EMR, it can come from labs, the possibilities are endless! Nevertheless it may be your role to make sense of all this data and tell the story of the patient&#8217;s medical history.  <br><br><strong><span wfd-id=\"990\" style=\"text-decoration: underline;\">SQL Joins<\/span><\/strong><br><br>SQL joins are one of the first commands that you learn when programming in SQL. Some of the important syntax you will want to know from your SQL queries is how to join different tables, which houses your healthcare data, using left, right, inner and outer joins. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the below image I have two example tables, Table 1 has some patient demographic information such as the patient&#8217;s name and gender and Table 2 indicates if the patient has a positive or negative COVID-19 test. We often will want to join information from matching rows in one table together with another table so we can view the data as one large table and do further analysis on this single table (e.g. counting the number of rows in this single table). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To &#8220;combine&#8221; data from Table 1 and Table 2 into one table which contains both Patient Demographic and Patient Health Condition information, we need to use the join commands and have a common column which is shared between the tables we are joining. In this case, the common column or key between Patient Demographics and Patient Health Condition which we will join on, is the <strong>Patient Health Card Number<\/strong> column.  <br><br><br><img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"681\" class=\"wp-image-679\" style=\"width: 800px;\" src=\"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png\" alt=\"\" srcset=\"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png 713w, https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1-300x255.png 300w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><br><br>With the <strong>Left Join<\/strong> command when you join Table 1 and Table 2 together on the Patient Health Card Number columns in each table, you will end up a table with just two rows containing Joaquin and Joanna&#8217;s records because a Left Join joins all the rows in the left table and all the matching rows in the right table and Billy, Jillian and Chad are not present in the left table which is Table 1. <br><br>Similarly with the Right Join when you join Table 1 and Table 2 together you will have three nulls with your Right Join because a Right Join joins all the rows in the right table and all the matching tables in the left table which are are just Joaquin and Joanna&#8217;s records. <br><br>The other types of Joins that are common with SQL queries are <strong>Inner Joins<\/strong> which returns only matching records which are both in Table 1 and Table 2 and a <strong>Full Join<\/strong> which is usually used for specific business cases where you return records both in Table 1 and Table 2 and will output nulls when there is no matching between tables. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have joined your tables together to show the relevant data you want to query, that&#8217;s when one can start getting into using aggregations such as COUNT, DISTINCT, SUM, AVERAGE and much more, to output certain calculations. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For instance, one query you might write: <br><br>SELECT COUNT(Patient Health Card Number. Patient Health Condition) <br>FROM Patient Demographics <br>LEFT JOIN Patient Health Condition <br>ON Patient Demographics<strong>.<\/strong> Patient Health Card Number = Patient Health Condition<strong>.<\/strong> Patient Health Card Number <br><br>The result of this query counts the number of patients who have matching records between Table 1 and Table 2. In this toy example, this can be eye-balled but when you have hundreds or thousands of patients being added daily to your database, writing these quick queries are essential for getting quick insights from your data. <br><br><br><\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100 nfd-wb-animate nfd-wb-zoom-in\"><a class=\"wp-block-button__link wp-element-button\">Click Here to Become a Healthcare Data Analyst<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><br><\/strong><br><br><strong><span wfd-id=\"304\" style=\"text-decoration: underline;\">Wildcard statements<\/span><br><\/strong><br>Wildcard statements can allow you to filter the data by selecting specific conditions. For instance, if you only wanted to count the number of patients who have a first name which <strong>starts<\/strong> with &#8220;J&#8221; the query would look like this: <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT COUNT(Patient Health Card Number. Patient Health Condition)<br>FROM Patient Demographics <br>LEFT JOIN Patient Health Condition<br>ON Patient Demographics. Patient Health Card Number = Patient Health Condition. Patient Health Card Number<br><span wfd-id=\"303\" class=\"highlight\">WHERE Patient Name LIKE &#8216;J%&#8217;<br><\/span><br><strong><span wfd-id=\"302\" style=\"text-decoration: underline;\">Group By <\/span><\/strong><br><br>Another important function when learning SQL is to learn how to use &#8220;Group By&#8221; statements, as the name suggests, this function groups rows by certain criteria. For instance you could group your patients by, have they been diagnosed with a positive or negative test for COVID-19. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT COUNT(Patient Health Card Number. Patient Health Condition)<br>FROM Patient Demographics<br>LEFT JOIN Patient Health Condition<br>ON Patient Demographics. Patient Health Card Number = Patient Health Condition. Patient Health Card Number<br>WHERE Patient Name LIKE &#8216;J%&#8217;<br><span wfd-id=\"301\" class=\"highlight\">GROUP BY Patient Health Condition<\/span><br><br><span wfd-id=\"300\" style=\"text-decoration: underline;\"><strong>Order By <\/strong><\/span><br><br>Order by allows you to order the dataset in the table either by ascending or descending order, in this below example Joanna would appear in the table before Joaquin:<br><br>SELECT COUNT(Patient Health Card Number. Patient Health Condition)<br>FROM Patient Demographics<br>LEFT JOIN Patient Health Condition<br>ON Patient Demographics. Patient Health Card Number = Patient Health Condition. Patient Health Card Number<br>WHERE Patient Name LIKE &#8216;J%&#8217;<br>GROUP BY Patient Health Condition<br><span wfd-id=\"299\" class=\"highlight\">ORDER BY Patient Name ASC<\/span><br><br>These are just a few SQL functions that can be used to &#8220;slice and dice&#8221; the data into a format that can then be integrated into a tool such as R, Python or Power BI for further analysis and visualization. Be on the lookout for more posts on tips on how to visualize healthcare data! <strong>Looking to<\/strong> <strong>develop your SQL skills and become a healthcare data analyst? Check out the course\u00a0<a href=\"https:\/\/healthanalyticinsights.com\/?page_id=1195\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>\u00a0to learn more!\u00a0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, I am going to go over some common SQL queries that are used in the health informatics field. Experience writing SQL queries is a common skill listed on many health informatics roles because knowing how to &#8220;slice and dice&#8221; raw, unstructured into actionable insights can be [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","iawp_total_views":1785,"footnotes":""},"categories":[1],"tags":[111,109,110,113,112,107,108],"class_list":["post-584","post","type-post","status-publish","format-standard","hentry","category-health-analytic-informatics","tag-health-informatics-specialist","tag-healthcare-data-analysts","tag-how-do-i-become-a-clinical-data-analyst","tag-what-do-you-study-in-health-informatics","tag-what-exactly-is-health-informatics","tag-what-is-sql-in-healthcare","tag-what-is-the-role-of-a-data-analyst-in-healthcare"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights<\/title>\n<meta name=\"description\" content=\"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/healthanalyticinsights.com\/?p=584\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights\" \/>\n<meta property=\"og:description\" content=\"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/healthanalyticinsights.com\/?p=584\" \/>\n<meta property=\"og:site_name\" content=\"HealthAnalyticInsights\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-06T10:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-01T17:54:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png\" \/>\n<meta name=\"author\" content=\"healthanalyticinsights\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"healthanalyticinsights\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584\"},\"author\":{\"name\":\"healthanalyticinsights\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#\\\/schema\\\/person\\\/38b29eb1c2f4c376fc0b481b4d5ed267\"},\"headline\":\"SQL Queries You Need to Know in Health Informatics\",\"datePublished\":\"2021-12-06T10:25:00+00:00\",\"dateModified\":\"2024-03-01T17:54:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584\"},\"wordCount\":980,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/BlogPostImage_051021-1.png\",\"keywords\":[\"health informatics specialist\",\"Healthcare data analysts\",\"How do I become a clinical data analyst?\",\"What do you study in health informatics?\",\"What exactly is health informatics?\",\"What is SQL in healthcare?\",\"What is the role of a data analyst in healthcare?\"],\"articleSection\":[\"Health Analytic Informatics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584\",\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584\",\"name\":\"SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/BlogPostImage_051021-1.png\",\"datePublished\":\"2021-12-06T10:25:00+00:00\",\"dateModified\":\"2024-03-01T17:54:27+00:00\",\"description\":\"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#primaryimage\",\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/BlogPostImage_051021-1.png\",\"contentUrl\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/BlogPostImage_051021-1.png\",\"width\":713,\"height\":607},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?p=584#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/healthanalyticinsights.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Queries You Need to Know in Health Informatics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#website\",\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/\",\"name\":\"HealthAnalyticInsights\",\"description\":\"Creating a community of students and professionals interested in the field of health analytics\",\"publisher\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#organization\",\"name\":\"HealthAnalyticInsights\",\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/cropped-HealthAnalyticInsightLogo_081020.png\",\"contentUrl\":\"https:\\\/\\\/healthanalyticinsights.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/cropped-HealthAnalyticInsightLogo_081020.png\",\"width\":208,\"height\":260,\"caption\":\"HealthAnalyticInsights\"},\"image\":{\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/healthanalyticinsights.com\\\/#\\\/schema\\\/person\\\/38b29eb1c2f4c376fc0b481b4d5ed267\",\"name\":\"healthanalyticinsights\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g\",\"caption\":\"healthanalyticinsights\"},\"url\":\"https:\\\/\\\/healthanalyticinsights.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights","description":"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.","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:\/\/healthanalyticinsights.com\/?p=584","og_locale":"en_US","og_type":"article","og_title":"SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights","og_description":"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.","og_url":"https:\/\/healthanalyticinsights.com\/?p=584","og_site_name":"HealthAnalyticInsights","article_published_time":"2021-12-06T10:25:00+00:00","article_modified_time":"2024-03-01T17:54:27+00:00","og_image":[{"url":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png","type":"","width":"","height":""}],"author":"healthanalyticinsights","twitter_card":"summary_large_image","twitter_misc":{"Written by":"healthanalyticinsights","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/healthanalyticinsights.com\/?p=584#article","isPartOf":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584"},"author":{"name":"healthanalyticinsights","@id":"https:\/\/healthanalyticinsights.com\/#\/schema\/person\/38b29eb1c2f4c376fc0b481b4d5ed267"},"headline":"SQL Queries You Need to Know in Health Informatics","datePublished":"2021-12-06T10:25:00+00:00","dateModified":"2024-03-01T17:54:27+00:00","mainEntityOfPage":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584"},"wordCount":980,"commentCount":0,"publisher":{"@id":"https:\/\/healthanalyticinsights.com\/#organization"},"image":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584#primaryimage"},"thumbnailUrl":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png","keywords":["health informatics specialist","Healthcare data analysts","How do I become a clinical data analyst?","What do you study in health informatics?","What exactly is health informatics?","What is SQL in healthcare?","What is the role of a data analyst in healthcare?"],"articleSection":["Health Analytic Informatics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/healthanalyticinsights.com\/?p=584#respond"]}]},{"@type":"WebPage","@id":"https:\/\/healthanalyticinsights.com\/?p=584","url":"https:\/\/healthanalyticinsights.com\/?p=584","name":"SQL Queries You Need to Know in Health Informatics - HealthAnalyticInsights","isPartOf":{"@id":"https:\/\/healthanalyticinsights.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584#primaryimage"},"image":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584#primaryimage"},"thumbnailUrl":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png","datePublished":"2021-12-06T10:25:00+00:00","dateModified":"2024-03-01T17:54:27+00:00","description":"SQL is a commonly requested skill on many health informatics positions, in this blog post I will demonstrate some widely used SQL commands.","breadcrumb":{"@id":"https:\/\/healthanalyticinsights.com\/?p=584#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/healthanalyticinsights.com\/?p=584"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/healthanalyticinsights.com\/?p=584#primaryimage","url":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png","contentUrl":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2021\/05\/BlogPostImage_051021-1.png","width":713,"height":607},{"@type":"BreadcrumbList","@id":"https:\/\/healthanalyticinsights.com\/?p=584#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/healthanalyticinsights.com\/"},{"@type":"ListItem","position":2,"name":"SQL Queries You Need to Know in Health Informatics"}]},{"@type":"WebSite","@id":"https:\/\/healthanalyticinsights.com\/#website","url":"https:\/\/healthanalyticinsights.com\/","name":"HealthAnalyticInsights","description":"Creating a community of students and professionals interested in the field of health analytics","publisher":{"@id":"https:\/\/healthanalyticinsights.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/healthanalyticinsights.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/healthanalyticinsights.com\/#organization","name":"HealthAnalyticInsights","url":"https:\/\/healthanalyticinsights.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/healthanalyticinsights.com\/#\/schema\/logo\/image\/","url":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2020\/09\/cropped-HealthAnalyticInsightLogo_081020.png","contentUrl":"https:\/\/healthanalyticinsights.com\/wp-content\/uploads\/2020\/09\/cropped-HealthAnalyticInsightLogo_081020.png","width":208,"height":260,"caption":"HealthAnalyticInsights"},"image":{"@id":"https:\/\/healthanalyticinsights.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/healthanalyticinsights.com\/#\/schema\/person\/38b29eb1c2f4c376fc0b481b4d5ed267","name":"healthanalyticinsights","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63531fb5510bd61e1e2976d465b2a837b8c62387fb89940e1f48599ce921303b?s=96&d=mm&r=g","caption":"healthanalyticinsights"},"url":"https:\/\/healthanalyticinsights.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/posts\/584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=584"}],"version-history":[{"count":4,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/posts\/584\/revisions"}],"predecessor-version":[{"id":1545,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=\/wp\/v2\/posts\/584\/revisions\/1545"}],"wp:attachment":[{"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/healthanalyticinsights.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}