{"id":2666,"date":"2015-03-12T13:51:41","date_gmt":"2015-03-12T17:51:41","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=2666"},"modified":"2015-03-12T13:51:41","modified_gmt":"2015-03-12T17:51:41","slug":"tableau-lab-leading-causes-of-death-in-nyc-2007-2011","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/tableau-lab-leading-causes-of-death-in-nyc-2007-2011\/","title":{"rendered":"Leading Causes of Death in NYC (2007-2011)"},"content":{"rendered":"

The following visualizations depict several facets of data concerning\u00a0New York City\u2019s \u201cLeading Causes of Death\u201d from 2007 to 2011<\/strong>. The dataset used to create the visualizations (using\u00a0Tableau Public<\/em>) in this post can be\u00a0downloaded from NYC OpenData<\/a>; the data was collected by the Department of Health and Mental Hygiene (DOHMH).<\/p>\n

*Click links [Viz 1, etc.] for interactive visualizations<\/em><\/p>\n

Viz 1:\u00a0<\/strong>What are the top two causes?\u00a0<\/strong><\/a><\/p>\n

Notice I’ve isolated heart disease<\/strong> and tumors<\/strong>\u00a0in this viz–this is because I’ve predetermined them to be the top causes of death (by quite large margins) for all ethnicities and both sexes from 2007 to 2011. Across almost all ethnicities except for Asian & Pacific Islanders, more women died from heart disease than men while more women died from tumors than men with the exceptions of Hispanic and Asian &\u00a0Pacific Islander men<\/strong>. The amount of deaths relating to tumors remains consistent throughout the years, while heart disease steadily decreases (though, from 2009 to 2010, there is a a bigger dip than other year ranges [19,803 -> 17, 687]). The red gradient used for the horizontal bar graph is a cognitive tool\u2014it illustrates that a greater amount of deaths equal a darker shade. A legend denotes the sexes using\u00a0the gendered colors of pink and blue.<\/p>\n

Viz 2: Leading causes of death by ethnicity and sex<\/strong><\/a><\/p>\n

Here are the rest of the leading causes of death by ethnicity and sex sans<\/em> top two causes. I decided to remove the top two causes of death from the default viz because it renders a smaller range of values to work with for better examination of data. By\u00a0using pink and blue circles without a fill as the plot points, a user can see where women and men have had similar amounts of deaths (illustrated by overlapping circles; see image below). It’s instantly apparent that the\u00a0highest amount of deaths (~3,300) in this viz belong to Caucasian females who suffered from influenza and pneumonia.<\/strong><\/p>\n

\"\"<\/a>

Leading Causes of Death (by Ethnicity and Sex)<\/p><\/div>\n

To highlight a particular cause of death, it can simply be clicked on in the y-axis; this will isolate the data of interest, fading out the rest of the data. Alternatively, because there is such a wide range of values and numerous causes of death, the Quick Filter (which includes a checklist and a search option) can be used in order to more closely examine particular causes (or compare causes) and their corresponding amounts of deaths\u2014pretend you\u2019re taking a magnifying glass to the data you are most interested in. That\u2019s what Quick Filter does.<\/p>\n

Viz 3:\u00a0\u00a0Total amount of deaths over time<\/strong><\/a><\/p>\n

Let\u2019s look at the big picture: total amount of deaths over time. There is a staggering amount of deaths in the Caucasian population in comparison to Africans, Hispanics, and Asian & Pacific Islanders.<\/strong>\u00a0 The amount of deaths for all ethnicities seem quite consistent over the five years i.e., there is no outstanding increase or decrease of deaths for any year. More women died\u00a0than men over the five year period. In 2010, women and men had the smallest difference in amount of deaths (20,086 vs. 19,761)\u2014though women still, sadly, triumphed here.<\/strong><\/p>\n

Amount of Deaths over Time (by Ethnicity) and Amount of Deaths over Time (by Sex) show scales of 0 to 25,000 and 15,000 to 25,000, respectively. Amount of Deaths over Time (by Sex)\u2019s lowest plot point is ~19,700, so I truncated the y-axis range from 0-25,000 to 15,000-25,000 to allow\u00a0for a closer\u00a0view of the data. (See images below).<\/p>\n

\"\"<\/a>

Amount of Deaths over Time (by Ethnicity)<\/p><\/div>\n

\"\"<\/a>

Amount of Deaths over Time (by Sex)<\/p><\/div>\n

 <\/p>\n

Viz 4: What are the leading causes by ethnicity?<\/a> \/ Viz 5:\u00a0What are the leading causes by sex?<\/a><\/strong><\/p>\n

These two highlight tables, while not very exciting-looking, are quite useful for analysis of data. Firstly, the tables immediately shed light on gaps in the data. For example, looking at Causes of Death (by Sex), it can easily be discerned that there were no recorded deaths from viral hepatitis among women; looking at Causes of Death (by Ethnicity) there is no recorded data for congenital malformations, deformations in Asian & Pacific Islander, Caucasian, and Hispanic populations. The visualizations can also highlight the lowest amounts which can sometimes be lost in a dataset with a large range\u00a0of numbers: e.g.,<\/strong> Causes of Death (by Ethnicity) makes it easy to see that aortic aneurysm and dissection had the lowest amount of deaths amongst the four ethnicities.<\/strong><\/p>\n

In the same vein as Viz 1, the red gradient used for these two highlight tables allows a user to easily see that a darker shade equal more deaths. These two visualizations can be used as an alternative to Viz 1 which displays all<\/em> data (disregarding years); however, these visualizations provide a clearer overview of the total amounts of deaths for each corresponding cause.<\/p>\n

–Sarah Hatoum<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

The following visualizations depict several facets of data concerning\u00a0New York City\u2019s \u201cLeading Causes of Death\u201d from 2007 to 2011. The dataset used to create the visualizations (using\u00a0Tableau Public) in this post can be\u00a0downloaded from NYC OpenData; the data was collected by the Department of Health and Mental Hygiene (DOHMH). *Click links [Viz 1, etc.] for…<\/p>\n","protected":false},"author":359,"featured_media":2842,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[],"class_list":["post-2666","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-H0","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/2666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/359"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=2666"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/2666\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=2666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=2666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=2666"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=2666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}