R2R 2014

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id vv43-e55n
Name R2R 2014
Attribution Austin Police Department
Category Government
Tags polce, r2r, response to resistance
Created 2016-09-20T20:11:43Z
Publication Date 2016-09-20T20:13:14Z

Description

Response to Resistance dataset for 2014.
AUSTIN POLICE DEPARTMENT DATA DISCLAIMER 1. The data provided are for informational use only and may differ from official APD crime data. 2. APD?s crime database is continuously updated, so reports run at different times may produce different results. Care should be taken when comparing against other reports as different data collection methods and different data sources may have been used. 3. The Austin Police Department does not assume any liability for any decision made or action taken or not taken by the recipient in reliance upon any information or data provided.

Columns

| Included | Schema Type    | Field Name                | Name                      | Data Type     | Render Type   |
| ======== | ============== | ========================= | ========================= | ============= | ============= |
| Yes      | numeric metric | rin                       | RIN                       | number        | number        |
| Yes      | numeric metric | primary_key               | Primary Key               | number        | number        |
| Yes      | time           | date_occurred             | Date Occurred             | calendar_date | calendar_date |
| No       |                | time_occurred             | Time Occurred             | text          | text          |
| Yes      | series tag     | location                  | Location                  | text          | text          |
| Yes      | series tag     | area_command              | Area Command              | text          | text          |
| Yes      | series tag     | nature_of_contact         | Nature of Contact         | text          | text          |
| Yes      | series tag     | reason_desc               | Reason Desc               | text          | text          |
| Yes      | numeric metric | r2r_level                 | R2R Level                 | number        | number        |
| Yes      | series tag     | master_subject_id         | Master Subject ID         | text          | text          |
| Yes      | series tag     | subject_sex               | Subject Sex               | text          | text          |
| Yes      | series tag     | subject_race              | Subject Race              | text          | text          |
| Yes      | series tag     | subject_ethnicity         | Subject Ethnicity         | text          | text          |
| Yes      | series tag     | subject_conduct_desc      | Subject Conduct Desc      | text          | text          |
| Yes      | series tag     | subject_resistance        | Subject Resistance        | text          | text          |
| Yes      | series tag     | weapon_used_1             | Weapon Used 1             | text          | text          |
| Yes      | series tag     | weapon_used_2             | Weapon Used 2             | text          | text          |
| Yes      | series tag     | weapon_used_3             | Weapon Used 3             | text          | text          |
| Yes      | series tag     | weapon_used_4             | Weapon Used 4             | text          | text          |
| Yes      | series tag     | weapon_used_5             | Weapon Used 5             | text          | text          |
| Yes      | numeric metric | number_shots              | Number Shots              | number        | number        |
| Yes      | series tag     | subject_effects           | Subject Effects           | text          | text          |
| Yes      | series tag     | effect_on_officer         | Effect on Officer         | text          | text          |
| Yes      | series tag     | officer_organization_desc | Officer Organization Desc | text          | text          |
| No       |                | officer_commission_date   | Officer Commission Date   | calendar_date | calendar_date |
| Yes      | numeric metric | officer_yrs_of_service    | Officer Yrs of Service    | number        | number        |
| No       |                | x_coordinate              | X-Coordinate              | number        | number        |
| No       |                | y_coordinate              | Y-Coordinate              | number        | number        |
| Yes      | series tag     | councildistrict           | CouncilDistrict           | text          | number        |

Time Field

Value = date_occurred
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = time_occurred,officer_commission_date,x_coordinate,y_coordinate

Data Commands

series e:vv43-e55n d:2014-01-01T00:00:00.000Z t:subject_effects="NO COMPLAINT OF INJURY/PAIN" t:effect_on_officer="NO COMPLAINT OF INJURY/PAIN" t:area_command=BA t:subject_resistance="EMPTY HAND DEFENSIVE RESISTANCE" t:nature_of_contact="VIEWED OFFENSE" t:location="615 E 15TH ST" t:councildistrict=1 t:reason_desc="NECESSARY TO EFFECT ARREST / DETENTION" t:officer_organization_desc="IDA 700 REG I PATROL" t:master_subject_id="459114135: 201410691" t:subject_race=W t:weapon_used_1="WEAPONLESS (PRESSURE POINTS/KICKS/HAND)" t:subject_sex=M t:subject_ethnicity=N t:subject_conduct_desc="SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS" m:r2r_level=3 m:primary_key=201410691 m:officer_yrs_of_service=6 m:rin=141850

series e:vv43-e55n d:2014-01-01T00:00:00.000Z t:subject_effects="NO COMPLAINT OF INJURY/PAIN" t:effect_on_officer="NO COMPLAINT OF INJURY/PAIN" t:area_command=GE t:subject_resistance="EMPTY HAND ACTIVE AGGRESSION" t:nature_of_contact=OTHER t:location="300 E 6TH ST" t:councildistrict=9 t:reason_desc="IN CUSTODY, MAINTAINING CONTROL" t:officer_organization_desc="GEORGE 400 REG I PATROL" t:master_subject_id="458902562: 201410620" t:subject_race=W t:weapon_used_1="WEAPONLESS (PRESSURE POINTS/KICKS/HAND)" t:subject_sex=M t:subject_ethnicity=N t:subject_conduct_desc="SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS" m:r2r_level=3 m:primary_key=201410620 m:officer_yrs_of_service=4 m:rin=141851

series e:vv43-e55n d:2014-01-01T00:00:00.000Z t:subject_effects="NO COMPLAINT OF INJURY/PAIN" t:effect_on_officer="NO COMPLAINT OF INJURY/PAIN" t:area_command=DA t:subject_resistance="PASSIVE RESISTANCE" t:nature_of_contact="TACTICAL OPERATION" t:location="901 W BEN WHITE BLVD EB" t:councildistrict=3 t:reason_desc="NECESSARY TO EFFECT ARREST / DETENTION" t:officer_organization_desc="METRO TAC REGION 4" t:master_subject_id="302385077: 201411950" t:subject_race=W t:weapon_used_1="WEAPONLESS (PRESSURE POINTS/KICKS/HAND)" t:subject_sex=M t:subject_ethnicity=H t:subject_conduct_desc="SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS" m:r2r_level=3 m:primary_key=201411950 m:officer_yrs_of_service=6 m:rin=141908

Meta Commands

metric m:rin p:integer l:RIN t:dataTypeName=number

metric m:primary_key p:long l:"Primary Key" t:dataTypeName=number

metric m:r2r_level p:integer l:"R2R Level" t:dataTypeName=number

metric m:number_shots p:integer l:"Number Shots" t:dataTypeName=number

metric m:officer_yrs_of_service p:integer l:"Officer Yrs of Service" t:dataTypeName=number

entity e:vv43-e55n l:"R2R 2014" t:attribution="Austin Police Department" t:url=https://data.austintexas.gov/api/views/vv43-e55n

property e:vv43-e55n t:meta.view v:id=vv43-e55n v:category=Government v:averageRating=0 v:name="R2R 2014" v:attribution="Austin Police Department"

property e:vv43-e55n t:meta.view.owner v:id=q374-e9d9 v:screenName="Ron MacKay" v:displayName="Ron MacKay"

property e:vv43-e55n t:meta.view.tableauthor v:id=q374-e9d9 v:screenName="Ron MacKay" v:roleName=publisher_stories v:displayName="Ron MacKay"

Top Records

| rin    | primary_key | date_occurred       | time_occurred | location                | area_command | nature_of_contact  | reason_desc                            | r2r_level | master_subject_id    | subject_sex | subject_race | subject_ethnicity | subject_conduct_desc                       | subject_resistance                                            | weapon_used_1                           | weapon_used_2                           | weapon_used_3 | weapon_used_4 | weapon_used_5 | number_shots | subject_effects                        | effect_on_officer                      | officer_organization_desc | officer_commission_date | officer_yrs_of_service | x_coordinate | y_coordinate | councildistrict | 
| ====== | =========== | =================== | ============= | ======================= | ============ | ================== | ====================================== | ========= | ==================== | =========== | ============ | ================= | ========================================== | ============================================================= | ======================================= | ======================================= | ============= | ============= | ============= | ============ | ====================================== | ====================================== | ========================= | ======================= | ====================== | ============ | ============ | =============== | 
| 141850 | 201410691   | 2014-01-01T00:00:00 |               | 615 E 15TH ST           | BA           | VIEWED OFFENSE     | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 459114135: 201410691 | M           | W            | N                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | EMPTY HAND DEFENSIVE RESISTANCE                               | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | IDA 700 REG I PATROL      | 2008-01-04T00:00:00     | 6                      | 3117183      | 10073404     | 1               | 
| 141851 | 201410620   | 2014-01-01T00:00:00 | 0230          | 300 E 6TH ST            | GE           | OTHER              | IN CUSTODY, MAINTAINING CONTROL        | 3         | 458902562: 201410620 | M           | W            | N                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | EMPTY HAND ACTIVE AGGRESSION                                  | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | GEORGE 400 REG I PATROL   | 2010-04-23T00:00:00     | 4                      | 3115155      | 10070604     | 9               | 
| 141908 | 201411950   | 2014-01-01T00:00:00 | 2119          | 901 W BEN WHITE BLVD EB | DA           | TACTICAL OPERATION | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 302385077: 201411950 | M           | W            | H                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | PASSIVE RESISTANCE                                            | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | METRO TAC REGION 4        | 2008-01-04T00:00:00     | 6                      | 3104682      | 10055365     | 3               | 
| 141928 | 201410445   | 2014-01-01T00:00:00 |               | 7104 BERKMAN DR         | ID           | DISPATCHED CALL    | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 458927427: 201410445 | M           | W            | H                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | OTHER                                                         | CED - PRONGS MISSED-ENTER # SHOTS       |                                         |               |               |               | 1            | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | IDA 800 REG I PATROL      | 2013-05-17T00:00:00     | 1                      | 3130488      | 10091489     | 1               | 
| 141929 | 201410761   | 2014-01-01T00:00:00 | 0325          | 4600 ELMONT DR          | HE           | DISPATCHED CALL    | IN CUSTODY, MAINTAINING CONTROL        | 3         | 318244064: 201410761 | M           | B            | N                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | VERBAL RESISTANCE/AGGRESSION; EMPTY HAND DEFENSIVE RESISTANCE | OTHER                                   | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |               |               |               |              | COMPLAINT OF INJURY/PAIN               | COMPLAINT OF INJURY/PAIN               | HENRY 600 REG III PATROL  | 2011-10-07T00:00:00     | 2                      | 3122853      | 10060648     | 3               | 
| 141930 | 201410761   | 2014-01-01T00:00:00 | 0454          | 4600 ELMONT DR          | HE           | DISPATCHED CALL    | IN CUSTODY, MAINTAINING CONTROL        | 3         | 318244064: 201410761 | M           | B            | N                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | VERBAL RESISTANCE/AGGRESSION; EMPTY HAND DEFENSIVE RESISTANCE | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | COMPLAINT OF INJURY/PAIN               | NO COMPLAINT OF INJURY/PAIN            | HENRY 300 REG III PATROL  | 2010-04-23T00:00:00     | 4                      | 3122853      | 10060648     | 3               | 
| 141934 | 201410649   | 2014-01-01T00:00:00 | 0250          | 811 KING EDWARD PL      | FR           | DISPATCHED CALL    | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 296879138: 201410649 | M           | W            | H                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | VERBAL RESISTANCE/AGGRESSION; EMPTY HAND ACTIVE AGGRESSION    | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | NO COMPLAINT OF INJURY/PAIN            | MINOR INJURY; COMPLAINT OF INJURY/PAIN | DAVID 800 REG IV PATROL   | 2011-10-07T00:00:00     | 2                      | 3100065      | 10045518     | 2               | 
| 141988 | 201410352   | 2014-01-01T00:00:00 | 0104          | 11601 DOMAIN DR         | AD           | DISPATCHED CALL    | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 85262671: 201410352  | M           | A            | N                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | OTHER                                                         | CED - PRONGS-ENTER # SHOTS              |                                         |               |               |               | 1            | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | ADAM 800 REG II PATROL    | 2012-11-30T00:00:00     | 1                      | 3119160      | 10119859     | 7               | 
| 142088 | 201411950   | 2014-01-01T00:00:00 |               | 901 W BEN WHITE BLVD EB | DA           | OTHER              | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 302385077: 201411950 | M           | W            | H                 |                                            | EMPTY HAND DEFENSIVE RESISTANCE                               | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |                                         |               |               |               |              | NO COMPLAINT OF INJURY/PAIN            | NO COMPLAINT OF INJURY/PAIN            | METRO TAC REGION 4        | 2008-06-20T00:00:00     | 6                      | 3104682      | 10055365     | 3               | 
| 142108 | 201410880   | 2014-01-01T00:00:00 |               | 7904 FORBSDALE DR       | FR           | DISPATCHED CALL    | NECESSARY TO EFFECT ARREST / DETENTION | 3         | 459114153: 201410880 | M           | W            | H                 | SUSPECTED UNDER INFLUENCE OF ALCOHOL/DRUGS | EMPTY HAND ACTIVE AGGRESSION                                  | CED - PRONGS-ENTER # SHOTS              | WEAPONLESS (PRESSURE POINTS/KICKS/HAND) |               |               |               | 2            | MINOR INJURY; COMPLAINT OF INJURY/PAIN | NO COMPLAINT OF INJURY/PAIN            | FRANK 800 REG IV PATROL   | 1998-07-17T00:00:00     | 15                     | 3116624      | 10030872     | 2               |