Raw San Diego County Crime Incidents 2012-2017

Unprocessed crime incident files from SANDAG

sandag.org-crime-2012e2017-raw-2.1.1. Modified 2020-11-22T22:18:25

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

These are files of crime incidents from SANDAG. These records come from two public records requests, one in 2016, and one in Feb 2019. The second request returned two files for 2015, which different numbers of records:

  • 2015.xlsx 208854 records
  • 2015-2019-request.xlsx 165796

We don’t know why the earlier request has more records.

Contacts

Data Dictionary

crime-incidents

crime-incidents

Column NameData TypeDescription
reportingYearinteger
reportingMonthinteger
agencystring
activityStatusstring
activitydatedatetime
numberActualReportedinteger
BLOCK_ADDRESSstring
citystring
zipCodeinteger
censusTractinteger
censusBlockinteger
CrimeCategorystring
CrimeDescriptionstring

References

Urls used in the creation of this data package.

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


crime-incidents-2012_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2012.csv')
crime-incidents-2013_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2013.csv')
crime-incidents-2014_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2014.csv')
crime-incidents-2015_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2015.csv')
crime-incidents-2016_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2016.csv')
crime-incidents-2017_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1/data/crime-incidents-2017.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandag.org-crime-2012e2017-raw-2.1.1.csv')

# Create Dataframes
crime-incidents-2012_df = pkg.resource('crime-incidents-2012').dataframe()
crime-incidents-2013_df = pkg.resource('crime-incidents-2013').dataframe()
crime-incidents-2014_df = pkg.resource('crime-incidents-2014').dataframe()
crime-incidents-2015_df = pkg.resource('crime-incidents-2015').dataframe()
crime-incidents-2016_df = pkg.resource('crime-incidents-2016').dataframe()
crime-incidents-2017_df = pkg.resource('crime-incidents-2017').dataframe()