Raw San Diego County Crime Incidents, 2007- 2013

Unprocessed crime incident files from SANDAG

sandag.org-crime-2017e2013-raw-1.1.1. Modified 2020-11-22T22:18:08

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

Documentation

NOTE: These are original files from SANDAG. You probably want to work with the cleaned version.

Crime incidents obtained from SANDAG through PRA request 12-075, presented as zipped CSV files. The request was for 1.5M incident records, and was delivered in April of 2013. Records start on Jan 1, 2007 and end on 31 March, 2013, for about 1008525 records.

These records are not cleaned, processed or geocoded. As is, they will only be useful for either further cleaning, or for time-series analysis.

This a later extract of the same data as in Revision 1. Revision one is being kept for historical comparisons; this data set is probably the one you want.

Contacts

Data Dictionary

crime_2007_2013

crime_2007_2013

Column NameData TypeDescription
activitytypestring
agencystring
activitydatedatetime
legendstring
charge_descriptionstring
block_addresstext
city_namestring
zipcodeinteger

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


crime_2007_2013_df =  pd.read_csv('http://library.metatab.org/sandag.org-crime-2017e2013-raw-1.1.1/data/crime_2007_2013.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandag.org-crime-2017e2013-raw-1.1.1.csv')

# Create Dataframes
crime_2007_2013_df = pkg.resource('crime_2007_2013').dataframe()