San Diego Crime Incidents 2016_2020
Joe Long
December 15 2020
Reading datasets
From https://data.sandiegodata.org/dataset/sandag-gov-crime-2007e2013/
San Diego county crime incidents,From SANDAG http://www.sandag.org/programs/public_safety/arjis/CrimeData/crimedata.zip
sdcrime_16_20.csv ### Cautions:
Crime incident reports are collected and reported by field officers from various different law enforcement agencies
Data is collected by 19 different agencies. Each law enforcement departments practice different policies, that can result in different categorizations, codifications.
Many incident reports could be generated using the same single location block. Because all of the crimes on a block are geocoded to the middle of the block, many incidents will appear as a single point.
Some incidents are not geocoded.
Some incident might have multipple report IDs due to multiple suspects or/and victims or multiple crimes
Some incidents might have victims but no suspects
Some incidents might have suspect but no victim
## pk activitynumber activitydate year agency
## 1 12144871 '01600014' 2016-01-01 00:00:00 2016 NATIONAL CITY
## 2 12127327 '16000042' 2016-01-01 00:00:00 2016 SAN DIEGO
## 3 12278698 '16005661' 2016-01-01 00:00:00 2016 SAN DIEGO
## 4 12278698 '16005661' 2016-01-01 00:00:00 2016 SAN DIEGO
## 5 12364997 '16008822' 2016-01-01 00:00:00 2016 SAN DIEGO
## 6 12532599 '16013155' 2016-01-01 00:00:00 2016 SAN DIEGO
## violationsection violationtype chargedescription
## 1 10851 VC TAKE VEHICLE W/O OWNER'S CONSENT/VEHICLE THEFT
## 2 459 PC BURGLARY/UNSPECIFIED
## 3 488 PC PETTY THEFT
## 4 488 PC PETTY THEFT
## 5 487(A) PC GRAND THEFT:MONEY/LABOR/PROPERTY OVER $950
## 6 422A PC TERRORIST THREATS THAT THREATEN FAMILY
## chargelevel codeucr crimecategory personrole race age sex
## 1 FELONY 7A0 Vehicle Theft VICTIM OTHER NA FEMALE
## 2 FELONY 5A6 Non Res Burglary nan nan NA nan
## 3 MISDEMEANOR 6DG Larceny < $400 SUSPECT WHITE 28 MALE
## 4 MISDEMEANOR 6DG Larceny < $400 VICTIM/WITNESS HISPANIC 74 MALE
## 5 FELONY 6AE Larceny >= $400 VICTIM/WITNESS WHITE 70 MALE
## 6 FELONY 4E0 Simple Assault VICTIM HISPANIC 48 FEMALE
## zipcode censusblock censustract city census_race tract_geoid
## 1 91950 2000 22000 NATIONAL CITY other 14000US06073022000
## 2 92109 20000 7907 SAN DIEGO unknown 14000US06073007907
## 3 92115 20230 2902 SAN DIEGO nhwhite 14000US06073002902
## 4 92115 20230 2902 SAN DIEGO hisp 14000US06073002902
## 5 92109 20120 7905 SAN DIEGO nhwhite 14000US06073007905
## 6 NA NA NA EL CAJON hisp
## block_geoid intptlat intptlon
## 1 10100US060730220002000 32.67887 -117.0875
## 2 10100US0607300790720000 NaN NaN
## 3 10100US0607300290220230 NaN NaN
## 4 10100US0607300290220230 NaN NaN
## 5 10100US0607300790520120 NaN NaN
## 6 NaN NaN
## geometry date month weekday hour
## 1 POINT (-117.0875061797541 32.67887038013) 2016-01-01 Jan Fri 0
## 2 nan 2016-01-01 Jan Fri 0
## 3 nan 2016-01-01 Jan Fri 0
## 4 nan 2016-01-01 Jan Fri 0
## 5 nan 2016-01-01 Jan Fri 0
## 6 nan 2016-01-01 Jan Fri 0filtering datat with identifiable suspects
- Clarification : multiple crime report IDs are generated for each crime, with victim(s) and with suspect(s).
- Some crime incidents might have victims not, with no identifiable suspects, such as car theft
- Counting all crime report ID might lead to double counting number of some crime incidents, especially domestic crimes.
##
## Aggravated Assault Armed Robbery Arson Larceny
## 68300 14799 2180 18
## Larceny < $400 Larceny >= $400 Murder Non Res Burglary
## 125234 101260 1029 25591
## Rape Res Burglary Simple Assault Strong ArmRobbery
## 6672 40304 198196 19528
## Vehicle Theft
## 73133##
## Aggravated Assault Armed Robbery Arson Larceny
## 32911 8607 983 10
## Larceny < $400 Larceny >= $400 Murder Non Res Burglary
## 50227 31086 524 11924
## Rape Res Burglary Simple Assault Strong ArmRobbery
## 3405 10916 96245 11283
## Vehicle Theft
## 15726## `summarise()` ungrouping output (override with `.groups` argument)| year | Total |
|---|---|
| 2016 | 58923 |
| 2017 | 57391 |
| 2018 | 57538 |
| 2019 | 64037 |
| 2020 | 35958 |
## `summarise()` regrouping output by 'year' (override with `.groups` argument)
## `summarise()` regrouping output by 'year' (override with `.groups` argument)
Domestic Sexual assaults in San Diego City with identifiable suspects
## `summarise()` ungrouping output (override with `.groups` argument)## Warning: `as_data_frame()` is deprecated as of tibble 2.0.0.
## Please use `as_tibble()` instead.
## The signature and semantics have changed, see `?as_tibble`.
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_warnings()` to see where this warning was generated.