{"id":6723,"date":"2017-06-15T00:00:00","date_gmt":"2017-06-15T04:00:00","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=6723"},"modified":"2017-06-15T00:00:00","modified_gmt":"2017-06-15T04:00:00","slug":"fatal-police-shootings-united-states-tableau","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/fatal-police-shootings-united-states-tableau\/","title":{"rendered":"Fatal Police Shootings in the United States (Tableau)"},"content":{"rendered":"<h4>Introduction<\/h4>\n<p>The roots of policing in the United States \u201ccan be traced back to a multitude of historical, legal, and political-economic conditions,\u201d primary among which are \u201cthe institution of slavery\u201d and \u201cthe control of minorities\u201d (Kappeler, 2014). Just as \u201cthe legacy and slavery of racism did not end after the Civil War\u201d (Kappeler, 2014), the role of police in civilized society evolved and adapted to the transformations of hegemony.<\/p>\n<p style=\"text-align: center\">[iframe src=&#8217;http:\/\/player.theplatform.com\/p\/7wvmTC\/MSNBCEmbeddedOffSite?guid=n_mhp_1policing_150104_435251&#8242; height=&#8217;500&#8242; width=&#8217;635&#8242; scrolling=&#8217;no&#8217; border=&#8217;no&#8217;]<\/p>\n<p>We understand, therefore, that police violence against racial minorities and other marginalized groups is by no measure a strictly modern phenomenon. What is modern is the application of information science to the collection, analysis, and communication of data related to policing. Using tools of data processing and visualization, we are better able to understand and share both the immensity of this issue and its damaging consequences for all of the American public.<\/p>\n<p>&nbsp;<\/p>\n<h4>Discussion<\/h4>\n<p>In their project, \u201cThe Counted,\u201d the Guardian seeks to document data pertaining to the epidemic of police shootings in the United States. (\u201cThe Counted,\u201d n.d.) Similarly, the Washington Post released a public database containing records of police shootings of civilians from 2015 to present (\u201cPolice shootings 2016 database,\u201d n.d.) which will be updated into the foreseeable future. These sources are so widely considered authoritative that in 2015, James Comey, then director of the FBI, told reporters that \u201cit is unacceptable that the Washington Post and the Guardian newspaper from UK are becoming the lead source of information about violent encounters between [US] police and civilians\u201d (Tran, 2015). These news outlets utilize the data to support their content, often providing visualizations to complement and reinforce the analysis and conclusions from the text. The graphics for this lab share the same purpose: users should be able to make definitive statements about on the nature of police violence in the United States. Additionally, users should feel a sense of urgency to share the information within the graphics with their social networks.<\/p>\n<p>&nbsp;<\/p>\n<h4>Materials<\/h4>\n<p>I have chosen to use the Washington Post data for my visualizations. Software employed for this lab includes OpenRefine and Tableau Public. A computer with an internet connection is also required. A few other internet based resources are optional: <a href=\"https:\/\/data.world\/\" target=\"_blank\" rel=\"noopener noreferrer\">data.world<\/a>, <a href=\"https:\/\/github.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GitHub<\/a>, Google Drive, <a href=\"https:\/\/www.jstor.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">JSTOR<\/a>, and <a href=\"https:\/\/www.zotero.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">Zotero<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h4>Methods<\/h4>\n<p>I queried <a href=\"https:\/\/data.world\/search?q=african+american&amp;type=dataset\" target=\"_blank\" rel=\"noopener noreferrer\">\u201cafrican american\u201d<\/a> on data.world to locate a dataset. Note that you must have an account with data.world to search view and\/or download files. Fortunately, the Washington Post provides a direct link to <a href=\"https:\/\/github.com\/washingtonpost\/data-police-shootings\/blob\/master\/fatal-police-shootings-data.csv\" target=\"_blank\" rel=\"noopener noreferrer\">download the file<\/a> on GitHub (data-police-shootings, June 30, 2015\/2017). I uploaded the csv file to OpenRefine and cleaned the data <a href=\"https:\/\/docs.google.com\/document\/d\/18izMtPlOyOGT27UY2-WVEnCHjTMK4Sj4ZpTsAZ28YwI\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">with JSON<\/a>. A txt file of the code is here. I then exported the csv file again under a new name, and imported the new file to Tableau Public. In Tableau, I created several visualizations using primarily Race, Gender, Signs of Mental Illness, State and City, Age, and Count(Number of Records). In the final dashboard, an interactive map of the United States acts a filter for the other charts and graphs. I chose this design, because I want the user to have dynamic control over the display and because I wanted to share multiple visuals within a single dashboard.<\/p>\n<h4>Results<\/h4>\n<p><a href=\"https:\/\/public.tableau.com\/views\/FatalPoliceShootings_1\/USMapasFilter?:embed=y&amp;:display_count=yes&amp;publish=yes\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6739\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2017\/06\/US-Map-as-Filter-1-620x1030.png?resize=620%2C1030\" alt=\"\" width=\"620\" height=\"1030\" \/><\/a><\/p>\n<p>Of particular note in the content is the large number of deadly shootings of white men. Given that concerns about the use of excessive and fatal force are often discounted by the label \u201cidentity politics,\u201d it would follow that individuals with those identities would be especially concerned with their treatment under law enforcement. We see in the United States\u2019 current socio-political climate that this is not the case. Instead (and rightfully so), data concerning police reform is framed as a single part of a multi-dimensional approach to dismantling the systemic oppression of marginalized groups. As any scholar of Black feminism could tell you, the path to freedom for the most disadvantaged in our society is also the path to the enrichment and prosperity of people from all identities and backgrounds. Perhaps this data can serve as a call to action for more white men to demand accountability in law enforcement.<\/p>\n<p>Technical results are generally positive. Three main design concerns arose and were resolved in the following manner:<br \/>\n\u2022 In order to eliminate the automatically rendered scroll bars from the graphics, I resized the dashboard, increasing width and height until reaching the desired proportions. An observer noted that this action decreased or possibly eliminated access to the graphics from mobile devices.<br \/>\n\u2022 I froze the positions of the maps to make sure that the intended filter function is not disturbed by user error.<br \/>\n\u2022 Color graphics use the \u201cColor Blind\u201d scheme to ensure that anyone with such sensory impairments can observe this layer of detail. The graphics also show well in gray-scale for individuals that would like to print the visualization.<\/p>\n<p>&nbsp;<\/p>\n<h4>Future Directions<\/h4>\n<p>As the Washington Post adds records to the database over the next few years, I would like to continue updating the source table for the Tableau project. Temporal data is key to making informed predictions about the future, and in this case, to demonstrating a sustained need for the reform (dare I say abolition) of policing in the United States. I would also like to pull international data to demonstrate that the this country\u2019s status quo in an extreme outlier in larger contexts.<\/p>\n<p>&nbsp;<\/p>\n<h4>References<\/h4>\n<ul>\n<li>data-police-shootings: The Washington Post is compiling a database of every fatal shooting in the United States by a police officer in the line of duty in 2015 and 2016. (2017). The Washington Post. Retrieved from https:\/\/github.com\/washingtonpost\/data-police-shootings (Original work published June 30, 2015)<\/li>\n<li>Kappeler, V. E. (2014, January 7). A Brief History of Slavery and the Origins of American Policing | Police Studies Online. Retrieved June 15, 2017, from http:\/\/plsonline.eku.edu\/insidelook\/brief-history-slavery-and-origins-american-policing<br \/>\nPolice shootings 2016 database. (n.d.). Retrieved June 14, 2017, from https:\/\/www.washingtonpost.com\/graphics\/national\/police-shootings-2016\/<\/li>\n<li>The Counted: tracking people killed by police in the United States | US News. (n.d.). Retrieved June 15, 2017, from http:\/\/www.theguardian.com\/us-news\/series\/counted-us-police-killings<\/li>\n<li>Tran, M. (2015, October 8). FBI chief: \u201cunacceptable\u201d that Guardian has better data on police violence. The Guardian. Retrieved from https:\/\/www.theguardian.com\/us-news\/2015\/oct\/08\/fbi-chief-says-ridiculous-guardian-washington-post-better-information-police-shootings<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction The roots of policing in the United States \u201ccan be traced back to a multitude of historical, legal, and political-economic conditions,\u201d primary among which are \u201cthe institution of slavery\u201d and \u201cthe control of minorities\u201d (Kappeler, 2014). Just as \u201cthe legacy and slavery of racism did not end after the Civil War\u201d (Kappeler, 2014), the&hellip;<\/p>\n","protected":false},"author":225,"featured_media":6736,"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-6723","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-1Kr","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/6723","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\/225"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=6723"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/6723\/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=6723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=6723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=6723"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=6723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}