April 9, 2018

Introduction

This application provides interactive visualizations based on Washington Post's Database of every fatal shooting by a police in the U.S. since 2015.

To create beautiful interactive maps and plots this application used the power of leaflet and plotly packages.

The Shiny application was deployed to the ShinyApps.io service and it is available at this link:

All source files of the application can be found at the Github repository below:

About dataset

In 2015, The Washington Post created a database cataloging every fatal shooting nationwide by a police officer in the line of duty, collecting data on those who were killed and details of the shootings.

The effort began because data compiled by the federal government was unreliable and incomplete.

This database is based on news reports, public records, social media and other sources.

Original dataset is csv file and it is located here.

About dataset, pt.2

The original dataset looks like this:
id name date manner_of_death armed age gender race city state signs_of_mental_illness threat_level flee body_camera
3 Tim Elliot 2015-01-02 shot gun 53 M A Shelton WA True attack Not fleeing False
4 Lewis Lee Lembke 2015-01-02 shot gun 47 M W Aloha OR False attack Not fleeing False
5 John Paul Quintero 2015-01-03 shot and Tasered unarmed 23 M H Wichita KS False other Not fleeing False
8 Matthew Hoffman 2015-01-04 shot toy weapon 32 M W San Francisco CA True attack Not fleeing False
9 Michael Rodriguez 2015-01-04 shot nail gun 39 M H Evans CO False attack Not fleeing False

What we did apply on the dataset:

  • Some transformations
  • Adding geographic coordinates
  • Dealing with missing values

Application overview

  • Useful interactive map based on your filters
  • Useful interactive histograms based on your filters

Application overview, pt. 2

Application overview, pt. 3

Thank you!