Records of alcohol licenses in california, from the CA ABC daily file, with improvements to geographic identifiers, and acompilation of areal densities of on-sale and off-sale licenses in San Diego county.

abc.ca.gov-licenses-2.1.2. Modified 2020-11-27T23:20:08

Resources

• ca_abc_licenses. California Alcohol Beverage Control Licenses
• sd_abc_density. Areal density of on-sale and off-sale licenses in San Diego county

Documentation

This package is a conversion of the California Daily ABC file, so it is current as of the modification date of the package. The main change is the addition of the county variable, the FIPS code for the county, and the tract, the ACS format geoid version of the tract identifier.

Crime incidents in San Diego, from 2016 though July 2020 inclusive, with UCR codes for the crime and the age, race and sex of the victim and suspect.

sandiegodata.org-crime_victims-1.1.3. Modified 2020-11-22T23:31:33

Resources

• sdcrime_16_20. San Diego crime suspects and victims, 2016 to 2020
• ucrcodes. UCR codes and detailed descriptions

Documentation

This dataset describes crime incidents from 2016 to 2020, with demographic information for both the victims and suspects. The file has multiple rows per incident, one for each suspect or victim. The primary key pk links records together into a single crime incident. The dataset is derived from data acquired for a PRA request and is processed to standardize geographic identifiers and racial categories.

Boundary shapes for San Diego neighborhoods, beats and divisions, with ACS 2019 estimates for populations, by race.

sandiego.gov-police_regions-2.1.2. Modified 2021-02-25T19:08:44

Resources

• pd_beats. Police beats
• pd_divisions. Police Divisions
• pd_neighborhoods. Police Neighborhoods
• beat_demographics. Counts of people in the beat, by race.

Documentation

This package links shapefiles for San Diego police beats to Census tracts and merges in ACS estimates for population, by race, from the 2016 5 year ACS. When a police beat boundry crosses a tract, the tract population is allocated to beats by the proportion of the overlap by area. See the Jupyter notebook that performs the procedure for details.

Processed crime incidents for San Diego county, 2007-2013. Of our crime datasets, this one is most useful for analysis.

sandag.gov-crime-2007e2013-2.1.4. Modified 2020-11-26T06:39:42

Resources

• incidents. San Diego county crime incidents, 2007 to 2013
• i5y_sample. A sample of 10,000 incidents, from years 2008 to 2012

Documentation

Processed crime incidents, based on data supplied by SANDAG.

Important:

• See Caveats for limitations and warnings regarding this data.
• Use of this data is subject to multiple terms and conditions. See Terms for details.

This dataset includes geocoded crime incidents from 1 Jan 2007 to 31 March 2013 that were returned by SANDAG for Public Records request 12-075.

Unprocessed crime incident files from SANDAG

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

Resources

• crime-incidents-2012. Crime Incidents 2012
• crime-incidents-2013. Crime Incidents, 2013
• crime-incidents-2014. Crime Incidents, 2014
• crime-incidents-2015. Crime Incidents, 2015
• crime-incidents-2016. Crime Incidents, 2016
• crime-incidents-2017. Crime Incidents, 2017

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:

Unprocessed crime incident files from SANDAG

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

Resources

• crime_2007_2013. San Diego crime incidents, 2007 to 2013

Documentation

NOTE: These are original files from SANDAG. You probably want to work with thecleaned 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.