Response to Resistance

Austin Police Department response to police resistance incidents.

austintexas.gov-response_to_resistance-1.1.4. Modified 2020-06-17T23:53:20

Documentation

This data package collects multiple years of the Response to Resistance dataset from the Austin, TX Police department. It includes each of the four source files and a fifth file that combines the four source files.

Processing & Caveats

The source files, one year of data per file, have slightly different columns, so in the combined file there are some columns which will not have data across all years. These columns are:

• census_tract
• county
• location_1
• zip
• county_description

The combined file also has a set of dummy variables for each of the values of the subject_resistance variable. The categories for subject_resistance change from year to year, and some codes from earlier years are “expired” in later years. The expiration tags have been removed, so the dummy variables mix expired and unexpired codes. This is because there are many subject_resistance values that only have expired codes in them. The original values etained in subject_resistance

It appears that the earlier two years used a wide range of detailed codes, such as “firearm” or “edged weapon” which the later years have collapsed into “agressive_resistance”, “defensive resistance” and “passive resistance”, with out a definite cutoffdate for the transition. The image below shows True values for the dummy variables in yellow.

Police Data Collection

This package is part of the San Diego Data Library’s Police Data Collection

Images

• True Values for Subject Resistance Dummy Variables by Date

• Wrangler

Data Dictionary

r2r_2017 | r2r_2018 | r2r_2015 | r2r_2016 | r2r_2015_2018

r2r_2017

Column NameData TypeDescription
rininteger
primary_keyinteger
date_occurreddatetime
time_occurredinteger
locationstring
area_commandstring
nature_of_contactstring
reason_descstring
r2r_levelinteger
master_subject_idstring
subject_sexstring
subject_racestring
subject_ethnicitystring
subject_conduct_descstring
subject_resistancestring
weapon_used_1string
weapon_used_2string
weapon_used_3string
weapon_used_4string
weapon_used_5string
number_shotsinteger
subject_effectsstring
effect_on_officerstring
officer_organization_descstring
officer_commission_datedatetime
officer_yrs_of_serviceinteger
x_coordinateinteger
y_coordinateinteger
council_districtinteger
census_tractnumber
countystring
location_1string

r2r_2018

Column NameData TypeDescription
rininteger
primary_keyinteger
date_occurreddatetime
time_occurredinteger
locationstring
area_commandstring
nature_of_contactstring
reason_descstring
r2r_levelinteger
master_subject_idstring
subject_sexstring
subject_racestring
subject_ethnicitystring
subject_conduct_descstring
subject_resistancestring
weapon_used_1string
weapon_used_2string
weapon_used_3string
weapon_used_4string
weapon_used_5unknown
number_shotsinteger
effect_on_officerstring
officer_organization_descstring
officer_commission_datedate
officer_yrs_of_serviceinteger
x_coordinateinteger
y_coordinateinteger
council_districtinteger
census_tractstring
zipinteger
countyinteger
county_descriptionstring

r2r_2015

Column NameData TypeDescription
rininteger
primary_keyinteger
date_occurreddatetime
time_occurredstring
locationstring
area_commandstring
nature_of_contactstring
reason_descstring
r2r_levelinteger
master_subject_idstring
subject_sexstring
subject_racestring
subject_ethnicitystring
subject_conduct_descstring
subject_resistancestring
weapon_used_1string
weapon_used_2string
weapon_used_3string
weapon_used_4string
weapon_used_5unknown
number_shotsinteger
subject_effectsstring
effect_on_officerstring
officer_organization_descstring
officer_commission_datedatetime
officer_yrs_of_serviceinteger
x_coordinateinteger
y_coordinateinteger
council_districtinteger

r2r_2016

Column NameData TypeDescription
rininteger
primary_keyinteger
date_occurreddate
time_occurredinteger
locationstring
area_commandstring
nature_of_contactstring
reason_descstring
r2r_levelinteger
master_subject_idstring
subject_sexstring
subject_racestring
subject_ethnicitystring
subject_conduct_descstring
subject_resistancestring
weapon_used_1string
weapon_used_2string
weapon_used_3string
weapon_used_4string
weapon_used_5unknown
number_shotsinteger
subject_effectsstring
effect_on_officerstring
officer_organization_descstring
officer_commission_datedate
officer_yrs_of_serviceinteger
x_coordinateinteger
y_coordinateinteger
council_districtinteger

r2r_2015_2018

Column NameData TypeDescription
rininteger
primary_keyinteger
date_occurreddatetime
time_occurredstring
locationstring
area_commandstring
nature_of_contactstring
reason_descstring
r2r_levelinteger
master_subject_idstring
subject_sexstring
subject_racestring
subject_ethnicitystring
subject_conduct_descstring
subject_resistancestring
weapon_used_1string
weapon_used_2string
weapon_used_3string
weapon_used_4string
weapon_used_5string
number_shotsinteger
subject_effectsstring
effect_on_officerstring
officer_organization_descstring
officer_commission_datedatetime
officer_yrs_of_serviceinteger
x_coordinateinteger
y_coordinateinteger
council_districtinteger
census_tractnumber
countystring
location_1string
zipinteger
county_descriptionstring
sr_not_resistantstring
sr_edged_weaponstring
sr_preparatory_resistancestring
sr_aggressive_resistancestring
sr_firearmstring
sr_defensive_resistancestring
sr_empty_hand_defensive_resistancestring
sr_passive_resistancestring
sr_verbal_resistance_aggressionstring
sr_otherstring
sr_nonestring
sr_empty_hand_active_aggressionstring

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/austintexas.gov-response_to_resistance-1.1.4.csv')

# Create Dataframes
r2r_2015_df = pkg.resource('r2r_2015').dataframe()
r2r_2016_df = pkg.resource('r2r_2016').dataframe()
r2r_2017_df = pkg.resource('r2r_2017').dataframe()
r2r_2018_df = pkg.resource('r2r_2018').dataframe()
r2r_2015_2018_df = pkg.resource('r2r_2015_2018').dataframe()