{"id":5453,"date":"2016-10-04T12:22:00","date_gmt":"2016-10-04T16:22:00","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=5453"},"modified":"2016-10-04T12:22:00","modified_gmt":"2016-10-04T16:22:00","slug":"u-s-severe-weather-fatalities-2011-2015","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/u-s-severe-weather-fatalities-2011-2015\/","title":{"rendered":"U. S. Severe Weather Fatalities: 2011 &#8211; 2015"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>With this project, I explored an interest in the severe weather events that caused fatalities in the United States, between January 1<sup>st<\/sup>, 2011, and December 31<sup>st<\/sup>, 2015. About 10 years ago, I studied severe and unusual weather, in the pursuit of becoming a \u201cTrained Spotter,\u201d so this data was directly related to my personal curiosities. While I allowed myself plenty of room to experiment with the data, I did focus the manipulation of my visualizations on these 2 questions:<\/p>\n<p>1\/ In the last 5 year, what type(s) of severe weather events caused the most fatalities?<\/p>\n<p>2\/ If 1 type of event emerges as the most fatal, will 1 particular storm be revealed in the data \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0or, will there simply be in an increase in the number of events categorized as that type?<\/p>\n<p><strong>Materials<\/strong><\/p>\n<p><strong>\u00a0<\/strong>First, using Excel, I created a dataset from the <em>Storm Events Database <\/em>(http:\/\/www.ncdc.noaa.gov\/stormevents\/) made publicly available by the National Oceanic and Atmospheric Administration\u2019s (NOAA) National Centers for Environmental Information (NCEI). Then, I took this Excel sheet into Google\u2019s OpenRefine (2.6-ro.2), for the following purposes:<\/p>\n<ul>\n<li>To eliminate fields that were irrelevant to my questions (ex. \u201cTime Zone,\u201d \u201cCrop Damage,\u201d etc.)<\/li>\n<li>To delete rows representing U.S. territories (Guam, Puerto Rico, U.S. Virgin Islands, etc.), as each of these events were represented by an \u201cXX\u201d in the \u201cState\u201d field, and this would complicate any attempt at mapping the events<\/li>\n<li>To group event types into larger categories (ex. \u201cHigh Wind, \u201cThunderstorm Wind,\u201d and \u201cStrong Wind,\u201d all became \u201cWind\u201d)<\/li>\n<\/ul>\n<p>Later, I also used OpenRefine to isolate tornadic events, in the creation of a second, much smaller dataset.<\/p>\n<p>Both of these datasets, then, were taken into Tableau Public 10.0, where I made all of my visualizations.<\/p>\n<p><strong>Methods &amp; Discussion<\/strong><\/p>\n<p>Initially, I wanted to illustrate the types of severe weather events, the number of fatalities, and time. Many of the example visualizations that I found representing similar data resorted to layered area graphs. With this type of graph, much is lost; as you can see in the <em>US Weather Fatalities, 1940-2011<\/em> example, whole weather events are completely invisible for large stretches of time (ex. The problematically undefined \u201cOther\u201d category is invisible for more than 50 years, despite representing 1 of the highest spikes in the last decade). Also, in this graph, far too many colors are employed, making it difficult to decode. These are some things that I wanted to avoid, in creating my first visualization.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/weatherfatalities1.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5456 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/weatherfatalities1.jpg?resize=606%2C524\" alt=\"weatherfatalities1\" width=\"606\" height=\"524\" \/><\/a><\/p>\n<p>For my first design, in Tableau Public, I added \u201cDate\u201d to columns, \u201cType\u201d to rows, and \u201cDeaths\u201d to color. I thought that the resulting heat map was effective, and so, started playing with elements inside of this framework. For example, I toyed with time measurements (ex. When looking at \u201cmonths,\u201d rather than \u201cyears,\u201d the increase in severe weather events during warmer months became clear), and the addition of various \u201cMark Labels.\u201d After adding the \u201cMark Labels\u201d which represent percentages of the full table, I was surprised to see that, in the last 5 years, 2011\u2019s tornadic events caused nearly 20% of all severe weather fatalities! This led me to wonder if there were more tornadoes that year or, if a small number of events caused a great deal of damage.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Severe-Weather-Fatalities-2011-2015.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5457 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Severe-Weather-Fatalities-2011-2015.jpg?resize=592%2C304\" alt=\"u-s-severe-weather-fatalities-2011-2015\" width=\"592\" height=\"304\" \/><\/a><\/p>\n<p>Again, the sample visualizations that I saw incorporating the \u201cNumber of Records\u201d into similar facets with which I was already working, employed layered graphs. This example of a layered bar graph has the same problem with lost information as the layered area graph that I had presented earlier. Also, I found the differing units of measurement along the left and right sides of the graph to be confusing. So, once more, this stood as an example of what not to do.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/pauldouglas_1463608316_billion-dollar-disasters.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5454 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/pauldouglas_1463608316_billion-dollar-disasters-620x410.jpg?resize=620%2C410\" alt=\"pauldouglas_1463608316_billion-dollar-disasters\" width=\"620\" height=\"410\" \/><\/a><\/p>\n<p>Working with small multiples in my second visualization, I resolved some of the issues that I saw in the examples I have discussed here; I was pleased with the consistent units of measurement, and the monochromatic presentation. At this point, the \u201cMark Labels\u201d made the table look messy, and anyway, their purpose was less apparent, so I removed them. This new graph revealed that there were, in fact, more fatal tornadoes in 2011 (85) than in all of the other 4 years combined (72). This would lead me to believe that there was not, necessarily, 1, particular event that caused a surge, but I wanted to take a closer look.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Fatal-Severe-Weather-Events-2011-2015.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5459 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Fatal-Severe-Weather-Events-2011-2015-620x167.jpg?resize=620%2C167\" alt=\"u-s-fatal-severe-weather-events-2011-2015\" width=\"620\" height=\"167\" \/><\/a><\/p>\n<p>At this point, I went back into OpenRefine to isolate all of the fatal tornado events in the year 2011, and then, brought that new dataset into Tableau Public. Inspired by this example visualization which deals with similar content, I made a line graph, and later, added annotations. When I changed the time measurement to days rather than years, a huge spike emerged on 1, specific day. When I googled the date, I discovered that the most fatal tornado event in nearly a century occurred on that day! This led me to search for the other significant dates, in order to annotate all of the noticeable spikes on this third visualization.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Fatal-Tornado-Events-2011.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5460 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/U.S.-Fatal-Tornado-Events-2011-620x253.jpg?resize=620%2C253\" alt=\"u-s-fatal-tornado-events-2011\" width=\"620\" height=\"253\" \/><\/a><\/p>\n<p>Finally, since I had data about the states in which each of the severe weather events took place, I decided to make a quick map, in the true fashion of weather studies. While this did not support my goal of looking at trends across time, it ultimately supported my findings, as, sure enough, Alabama was the state most affected by 2011\u2019s \u201cSuper Outbreak,\u201d and Missouri was the state most affected by both of the smaller outbreaks. This does not explain the other prominent states, but that is a project for another day.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/Map-of-U.S.-Severe-Weather-Fatalities-2011-2015.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5458 aligncenter\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2016\/10\/Map-of-U.S.-Severe-Weather-Fatalities-2011-2015-620x255.jpg?resize=620%2C255\" alt=\"map-of-u-s-severe-weather-fatalities-2011-2015\" width=\"620\" height=\"255\" \/><\/a><\/p>\n<p><strong>Future Directions<\/strong><\/p>\n<p>If I were to move forward with this project, I think that it would be interesting to zero in on each of the event types, as I did with 2011\u2019s tornadic events, to take a closer look at each of the major happenings, and annotate all of the severest storms. On the other hand, I would also like to zoom out, and look at a much larger stretch of time, in order to a create a more impactful heat map; it was relatively time-consuming to collect 5 years\u2019 worth of data, but with more time, it would be possible to go back as far as January of 1950, using the same <em>Storm Events Database<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction With this project, I explored an interest in the severe weather events that caused fatalities in the United States, between January 1st, 2011, and December 31st, 2015. About 10 years ago, I studied severe and unusual weather, in the pursuit of becoming a \u201cTrained Spotter,\u201d so this data was directly related to my personal&hellip;<\/p>\n","protected":false},"author":435,"featured_media":5457,"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-5453","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-1pX","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/5453","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\/435"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=5453"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/5453\/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=5453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=5453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=5453"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=5453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}