- Anhad Dhillon, Saasha Mor (Section BE)
- Divit Jawa, Kartik Arora (Section BF)
We’ll be working with the “Seattle police department 911 response dataset”. This data set provides a plethora of data to work with which allows us to answer many questions and draw constructive conclusions about crime in Seattle.
Here is our shiny app
This data set contains data about 911 calls made and their time, coordinates and grouping/subgrouping about the type of complaint.
It makes the data generated by the City of Seattle openly available to the public for the purpose of increasing transparency, accountability and comparability; promoting economic development and research; and improving internal performance management. (“City of Seattle Open Data Portal.” Seattle ,
- Seattle PD It can also be used by:
- People who shifted to Seattle that need to find safe areas to live
- Students
- Homeless people
- How can we help Seattle PD recognize which areas and crimes need more attention?
- Is the negative perception of Marijuana and its role as a catalyst for crime supported by Statistical data?
- Which area of Seattle has the most density of crime?
- How does crime correlate to a particular time during the day?
- What kind of crimes are prevalent across different years?
- Did Marijuana legalization affect crime rates in Seattle? If so, how?
Our final project would be a Shiny app, which allows for most versatility and flexibility in terms the data we can display.
We will be obtaining our data with a downloaded CSV file which has data till the year 2016.
- What was the change in crime rates before and after Marijuana legalization?
- Which crimes became more or less prevalent before and after Marijuana legalization
- Which district had the least crime rate across time?
- Which district had the highest crime rate overall?
- ggplot
- Plotly
- Shiny
- httr
- Data collected might be outdated and may not reflect accurate results for the users today
- Visualizing data before performing huge operations to answer our questions
- Crime rates in fact, decreased drastically after marijuana legalization as shown in the graphs
- Area with most density of crime is Downton Seattle across all years
- Our data could be more helpful if we had Seattle PD response times so that we could assess their effectiveness