{"id":10027,"date":"2018-07-24T15:28:35","date_gmt":"2018-07-24T19:28:35","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=10027"},"modified":"2019-01-11T00:04:31","modified_gmt":"2019-01-11T05:04:31","slug":"the-price-of-freedom-gun-violence-and-children","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/the-price-of-freedom-gun-violence-and-children\/","title":{"rendered":"The Price of Freedom: Gun Violence and Children"},"content":{"rendered":"<h2>Introduction<\/h2>\n<blockquote><p>&#8220;This is the price of freedom.\u00a0\u00a0Violent nuts are allowed to roam free until they do damage, no matter how threatening they are.\u201d<\/p><\/blockquote>\n<div>A quote from Bill O\u2019Reilly\u2019s Blog, No Spin News, regarding the mass murder in Las Vegas at the Mandalay Bay hotel in the Fall of 2017. \u00a0This quote, unfortunately, clearly states that innocent lives are lost due to lack of gun control.\u00a0 Hearing this quote I had a desire to map out this cost. Focusing on the most innocent, I mapped out the gun deaths and injuries of children under the age of 12.<\/div>\n<div><\/div>\n<div><a href=\"http:\/\/www.gunviolencearchive.org\/\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-10051\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-12.49.05.png?resize=840%2C553\" alt=\"\" width=\"840\" height=\"553\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-12.49.05.png?resize=1024%2C674&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-12.49.05.png?resize=300%2C197&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-12.49.05.png?resize=768%2C505&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-12.49.05.png?w=1426&amp;ssl=1 1426w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><\/div>\n<div><\/div>\n<div>I started by looking at a possible correlation between overall\u00a0rates of death for each state. I then began looking into connections between domestic violence and gun violence.<\/div>\n<div><\/div>\n<div>\n<div id=\"attachment_10049\" style=\"width: 840px\" class=\"wp-caption alignnone\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-10049\" class=\"wp-image-10049 size-large\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.08.15.png?resize=840%2C528\" alt=\"\" width=\"840\" height=\"528\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.08.15.png?resize=1024%2C644&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.08.15.png?resize=300%2C189&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.08.15.png?resize=768%2C483&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.08.15.png?w=1511&amp;ssl=1 1511w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><p id=\"caption-attachment-10049\" class=\"wp-caption-text\">Everytown Gun Research<\/p><\/div>\n<div id=\"attachment_10050\" style=\"width: 574px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/DomesticShelters.org\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-10050\" class=\"wp-image-10050 size-large\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-13.40.42.png?resize=574%2C1024\" alt=\"\" width=\"574\" height=\"1024\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-13.40.42.png?resize=574%2C1024&amp;ssl=1 574w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-13.40.42.png?resize=168%2C300&amp;ssl=1 168w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-13.40.42.png?w=647&amp;ssl=1 647w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/a><p id=\"caption-attachment-10050\" class=\"wp-caption-text\">DomesticShelters.org<\/p><\/div>\n<\/div>\n<h2>Process<\/h2>\n<div><strong>Data Collection<\/strong><\/div>\n<div>Using data from the Guardian regarding gun crimes and death in the United States, I pulled the rate of deaths for each state. \u00a0I then found data on deaths and injuries of children under 12 from the Gun Violence Archive. \u00a0In order to get a geolocation from this dataset, I needed to bring the data into OpenRefine to combine columns into a format that could be used with google sheets services.<\/div>\n<div><\/div>\n<div><strong>Data Visualization<\/strong><\/div>\n<div>The data for states from the Guardian file easily over the shapefile from the U.S. Census site. I used light and dark on each state to show higher or lower death rate. \u00a0The locations of deaths and injuries are shown with a marker. \u00a0The size of the marker indicates the number of deaths.<\/div>\n<div><\/div>\n<div><strong>Tools<\/strong><\/div>\n<div>Carto<\/div>\n<div>Google Sheets<\/div>\n<div>OpenRefine<\/div>\n<div>Geocoding<\/div>\n<div><\/div>\n<div><strong>Sources<\/strong><\/div>\n<div><a href=\"https:\/\/www.census.gov\/geo\/maps-data\/data\/cbf\/cbf_state.html\">Census.gov<\/a><\/div>\n<div><a href=\"http:\/\/www.gunviolencearchive.org\/\">Gun Violence Archive<\/a><\/div>\n<div><a href=\"https:\/\/www.theguardian.com\/news\/datablog\/2011\/jan\/10\/gun-crime-us-state\">Guardian, Gun Death Rates by State<\/a><\/div>\n<div><\/div>\n<div><strong>References<\/strong><\/div>\n<div><a href=\"https:\/\/www.billoreilly.com\/b\/Mass-Murder-in-Las-Vegas\/851098107399788721.html\">Mass Murder in Las Vegas<\/a><\/div>\n<div><a href=\"https:\/\/www.domesticshelters.org\/domestic-violence-articles-information\/children-and-domestic-violence\">DomesticShelters.org<\/a><\/div>\n<div><a href=\"https:\/\/everytownresearch.org\/\">Everytown for Gun Safety<\/a><\/div>\n<div><\/div>\n<h2>Results<\/h2>\n<div><a href=\"https:\/\/savi.carto.com\/u\/tkubert\/builder\/a25a4a2a-a29b-4a5e-8fbb-8bc6148f6674\/embed\">View Map in Carto<\/a><\/div>\n<div>\n<div id=\"attachment_10046\" style=\"width: 840px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/savi.carto.com\/u\/tkubert\/builder\/a25a4a2a-a29b-4a5e-8fbb-8bc6148f6674\/embed?state=%7B%22map%22%3A%7B%22ne%22%3A%5B16.846605106396304%2C-130.29785156250003%5D%2C%22sw%22%3A%5B54.85131525968609%2C-55.15136718750001%5D%2C%22center%22%3A%5B38.272688535980976%2C-92.72460937500001%5D%2C%22zoom%22%3A5%7D%7D\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-10046\" class=\"size-large wp-image-10046\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?resize=840%2C578\" alt=\"\" width=\"840\" height=\"578\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?resize=1024%2C705&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?resize=300%2C207&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?resize=768%2C529&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?w=1396&amp;ssl=1 1396w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><p id=\"caption-attachment-10046\" class=\"wp-caption-text\">Gun Violence Rates and Children<\/p><\/div>\n<\/div>\n<div>When the data was laid out in Carto the resulting map did not show a strong correlation between gun deaths of children and rates of total gun deaths by\u00a0state, which I found surprising. \u00a0There must be another influencing factor, so I began to look at domestic violence since there is such a strong correlation between femicide and domestic partners.<\/div>\n<div><\/div>\n<div>As I began to look at data from DomesticShelters.org, there does seem to be a connection between lack of support services and domestic gun violence.\u00a0 This data was in separate\u00a0tables for each state, so a new dataset would need to be created from the others.\u00a0 Creating an additional layer of shading on the state map that displays each state&#8217;s ability to meet the needs of victims, may illustrate this connection.<\/div>\n<div><\/div>\n<h2>Future Considerations<\/h2>\n<div>I would have liked to have spent more time gathering and working with the data. \u00a0Most resources only gave parts of a full data-set and normalizing the data was challenging. \u00a0Also, some data simply did not exist. Not all states report the same, or any, data on gun violence or domestic abuse. \u00a0It is an interesting subject that deserves more attention. \u00a0Most news coverage is focused on mass shootings like the one in Newtown, CT, but the same number of children under 12 are killed every two months in the US.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction &#8220;This is the price of freedom.\u00a0\u00a0Violent nuts are allowed to roam free until they do damage, no matter how threatening they are.\u201d A quote from Bill O\u2019Reilly\u2019s Blog, No Spin News, regarding the mass murder in Las Vegas at the Mandalay Bay hotel in the Fall of 2017. \u00a0This quote, unfortunately, clearly states that&hellip;<\/p>\n","protected":false},"author":533,"featured_media":10046,"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":[149,341],"tags":[111,38,213],"coauthors":[348],"class_list":["post-10027","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-labs","category-maps","tag-carto","tag-cartodb","tag-gun-violence"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/07\/Screenshot-2018-07-24-15.26.03.png?fit=1396%2C961&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-2BJ","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10027","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\/533"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=10027"}],"version-history":[{"count":9,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10027\/revisions"}],"predecessor-version":[{"id":10117,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/10027\/revisions\/10117"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/10046"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=10027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=10027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=10027"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=10027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}