{"id":987,"date":"2014-03-14T20:17:09","date_gmt":"2014-03-15T00:17:09","guid":{"rendered":"http:\/\/commons.trincoll.edu\/dataviz\/?p=987"},"modified":"2014-03-18T14:10:32","modified_gmt":"2014-03-18T18:10:32","slug":"progress-report-ipc","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/14\/progress-report-ipc\/","title":{"rendered":"Progress Report (IPC)"},"content":{"rendered":"<p>At the Injury Prevention Center, I have been looking at and analyzing data from a database of pediatric trauma patients from 2007 to 2012. Having received this massive dataset, there was a lot of different routes in which we could have approached this. For the beginning of the semester, I have been organizing data into formats that represented the data shown in an earlier pediatric trauma registry paper. For instance, I would group the patients by year, age, ethnicity, etc. Although I am still in the process of formatting some of the data, such as organizing the data based off of time, I have made progress in creating graphs and visualizations that represented the paper. Moreover, I have played around with other visualization to see whether they are effective in displaying that data, such as the motion graph.<br \/>\nNow that most of the data organization has been completed, my next step is to continue making visualizations based off of my data. After Alvin Chang\u2019s presentation, I started to think about how each of my visualization could tell a story, what audience I wanted to show, and how effectively I could portray this data to them. After completing the preliminary visualizations, I will start to delve into the data and look at any trends or anything of significance that I could potentially visualize. I have sketched a few ideas on what I want to do and hopefully within the next few weeks I will bring them to light. Moreover, within the next week or couple of days, I will start compiling a list of questions that I could ask patients, doctors, and families. Similar to what Alvin did, I would like to be able to embed a story behind the data to make it more powerful. By the end, we hope that we will have a collection of visualization to choose from, and tell impactful stories that promote the cause of injury prevention.<\/p>\n<p>Below are some examples of what I have done so far:<\/p>\n<p>In this graph I compared the number of patients by age group. From this graph we can see that males ages 0-9 usually are the ones who get injured the most. However, this changes the older the children get. It would be interesting to find out why this trend exists.<\/p>\n<p><em>Update by Jack, March 18th: the interactive image below <strong>did not consistently appear<\/strong> in your post, most likely due to Google Drive hosting issues. But I was able to paste the underlying URL into another browser to capture this static image, which I have pasted in. Therefore, both the static and interactive versions may appear in some browsers. See my comment below about hosting code on GitHub instead.<\/em><\/p>\n<figure id=\"attachment_1010\" aria-describedby=\"caption-attachment-1010\" style=\"width: 659px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2014\/03\/RayStaticImage-2014-03-18.png\"><img loading=\"lazy\" class=\"size-full wp-image-1010\" alt=\"static view of interactive chart\" src=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2014\/03\/RayStaticImage-2014-03-18.png\" width=\"659\" height=\"372\" srcset=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2014\/03\/RayStaticImage-2014-03-18.png 659w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2014\/03\/RayStaticImage-2014-03-18-300x169.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><figcaption id=\"caption-attachment-1010\" class=\"wp-caption-text\">static view of interactive chart<\/figcaption><\/figure>\n<p><em>The interactive version:<\/em><br \/>\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe src=\"https:\/\/googledrive.com\/host\/0ByytieAfSNb4TDZ4WjFTVmt3RFk\/index.html\" width=\"100%\" height=\"500\" scrolling=\"yes\" class=\"iframe-class\" frameborder=\"0\"><\/iframe>\n<\/p>\n<p>In the next two graphs, I show the percentages of patients by ethnicity. Each graph represents either male or female patients. Hopefully for future graphs I can mix both male and female so that all the data could be contained in just one graph.<\/p>\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe width=\"500\" height=\"300\" scrolling=\"no\" frameborder=\"no\" src=\"https:\/\/www.google.com\/fusiontables\/embedviz?containerId=googft-gviz-canvas&#038;q=select+col0%2C+col1+from+1nnabgyMq_KbO90JUNbSX2Lsz9kOKECUREewHrsE+order+by+col1+asc+limit+7&#038;viz=GVIZ&#038;t=PIE&#038;uiversion=2&#038;gco_forceIFrame=true&#038;gco_hasLabelsColumn=true&#038;gco_useFirstColumnAsDomain=true&#038;gco_is3D=false&#038;gco_pieHole=0&#038;gco_booleanRole=certainty&#038;gco_colors=%5B%22%233366CC%22%2C%22%23DC3912%22%2C%22%23FF9900%22%2C%22%23109618%22%2C%22%23990099%22%2C%22%230099C6%22%2C%22%23DD4477%22%2C%22%2366AA00%22%2C%22%23B82E2E%22%2C%22%23316395%22%2C%22%23994499%22%2C%22%2322AA99%22%2C%22%23AAAA11%22%2C%22%236633CC%22%2C%22%23E67300%22%2C%22%238B0707%22%2C%22%23651067%22%2C%22%23329262%22%2C%22%235574A6%22%2C%22%233B3EAC%22%2C%22%23B77322%22%2C%22%2316D620%22%2C%22%23B91383%22%2C%22%23F4359E%22%2C%22%239C5935%22%2C%22%23A9C413%22%2C%22%232A778D%22%2C%22%23668D1C%22%2C%22%23BEA413%22%2C%22%230C5922%22%2C%22%23743411%22%5D&#038;gco_hAxis=%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D&#038;gco_vAxes=%5B%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D%2C%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D%5D&#038;gco_title=Percentage+of+Male+Patients+(2007-2012)&#038;gco_pieSliceText=percentage&#038;gco_legend=labeled&#038;gco_pieSliceTextStyle=%7B%22fontSize%22%3A%2212%22%7D&#038;width=500&#038;height=300\" class=\"iframe-class\"><\/iframe>\n\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe width=\"500\" height=\"300\" scrolling=\"no\" frameborder=\"no\" src=\"https:\/\/www.google.com\/fusiontables\/embedviz?containerId=googft-gviz-canvas&#038;q=select+col0%2C+col2+from+1nnabgyMq_KbO90JUNbSX2Lsz9kOKECUREewHrsE+order+by+col0+asc+limit+7&#038;viz=GVIZ&#038;t=PIE&#038;uiversion=2&#038;gco_forceIFrame=true&#038;gco_hasLabelsColumn=true&#038;gco_useFirstColumnAsDomain=true&#038;gco_is3D=false&#038;gco_pieHole=0&#038;gco_booleanRole=certainty&#038;gco_colors=%5B%22%233366CC%22%2C%22%23DC3912%22%2C%22%23FF9900%22%2C%22%23109618%22%2C%22%23990099%22%2C%22%230099C6%22%2C%22%23DD4477%22%2C%22%2366AA00%22%2C%22%23B82E2E%22%2C%22%23316395%22%2C%22%23994499%22%2C%22%2322AA99%22%2C%22%23AAAA11%22%2C%22%236633CC%22%2C%22%23E67300%22%2C%22%238B0707%22%2C%22%23651067%22%2C%22%23329262%22%2C%22%235574A6%22%2C%22%233B3EAC%22%2C%22%23B77322%22%2C%22%2316D620%22%2C%22%23B91383%22%2C%22%23F4359E%22%2C%22%239C5935%22%2C%22%23A9C413%22%2C%22%232A778D%22%2C%22%23668D1C%22%2C%22%23BEA413%22%2C%22%230C5922%22%2C%22%23743411%22%5D&#038;gco_hAxis=%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D&#038;gco_vAxes=%5B%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D%2C%7B%22useFormatFromData%22%3Atrue%2C+%22viewWindow%22%3A%7B%22max%22%3Anull%2C+%22min%22%3Anull%7D%2C+%22minValue%22%3Anull%2C+%22maxValue%22%3Anull%7D%5D&#038;gco_legend=labeled&#038;gco_title=Percentage+of+Females+(2007-2012)&#038;width=500&#038;height=300\" class=\"iframe-class\"><\/iframe>\n\n<p>For this graph, I made a times series of female patients based off of ethnicity. I will include the males once I am able to. Here we can see the the number of patients throughout each year. Whites mostly make up most of the injuries, but there was a significant decrease in 2010. I could possibly research why there was such a big drop to see if it was just a coincidence or not.<\/p>\n<p><em>Note from Jack, March 18th: The Google Motion Chart below appears in some browsers, but not others, which also may be a Google Drive hosting issue. Please try hosting with GitHub to see if that resolves the issue.<\/em><\/p>\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe src=\"https:\/\/googledrive.com\/host\/0ByytieAfSNb4UmtsSXlGdDN4Rnc\" width=\"100%\" height=\"500\" scrolling=\"yes\" class=\"iframe-class\" frameborder=\"0\"><\/iframe>\n\n<p>Below is a Google Fusion Map that I made which compiles the total number of patients in each city\/town from 2007-2012. Around the Hartford area is where the most injuries take place. I would however like to use the Leaflet application instead of the Google Fusion.<\/p>\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe width=\"500\" height=\"300\" scrolling=\"no\" frameborder=\"no\" src=\"https:\/\/www.google.com\/fusiontables\/embedviz?q=select+col2%3E%3E1+from+1crpvzTHPrVQGJoVj4L4zGY1VY7cXIDvEIkZlVl6l&#038;viz=MAP&#038;h=false&#038;lat=41.503107694937924&#038;lng=-72.75750800000003&#038;t=1&#038;z=8&#038;l=col2%3E%3E1&#038;y=2&#038;tmplt=2&#038;hml=KML\" class=\"iframe-class\"><\/iframe>\n\n","protected":false},"excerpt":{"rendered":"<p>At the Injury Prevention Center, I have been looking at and analyzing data from a database of pediatric trauma patients from 2007 to 2012. Having received this massive dataset, there was a lot of different routes in which we could have approached this. For the beginning of the semester, I have been organizing data into &hellip; <a href=\"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/14\/progress-report-ipc\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Progress Report (IPC)<\/span><\/a><\/p>\n","protected":false},"author":719,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23,9,1],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/987"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/users\/719"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/comments?post=987"}],"version-history":[{"count":8,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/987\/revisions"}],"predecessor-version":[{"id":1009,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/987\/revisions\/1009"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/media?parent=987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/categories?post=987"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/tags?post=987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}