home / vice

ViceNews_FullOISData

4,281 rows

View and edit SQL

This data as .json, .jsono

LinkrowidDateNumberOfSubjectsFatalSubjectArmedNotesSubjectRaceSubjectGenderSubjectAgeNatureOfStopNumberOfShotsNumberOfOfficersOfficerRaceOfficerGenderDepartmentFullNarrativecity
101 101 6/23/2010 1 N 2 N 2 Shots grazed; ricichet         1.0 1     Atlanta Police Department 2   Atlanta 2
102 102 4/20/2010 1 F 1 Y 1 1.0         1.0 3     Atlanta Police Department 2   Atlanta 2
103 103 2/27/2010 1 N 2 Y 1 1.0         5.0       Atlanta Police Department 2   Atlanta 2
104 104 9/25/2010 1 F 1 Y 1   W 1 M 1 26.0 Domestic Disturbance 1   1 H 10 M 1 Austin PD 3   Austin 3
105 105 10/1/2010 1 F 1 Y 1   L 2 M 1 16.0 Burglary / home invasion 2   1 W 1 M 1 Austin PD 3   Austin 3
106 106 11/2/2010 1 F 1 Y 1   A 4 M 1 26.0 Shots fired / shooting 3   2 W,W 11 M,M 10 Austin PD 3   Austin 3
107 107 12/23/2010 1 F 1 N 2 Fired, knife W 1 M 1 35.0 Traffic stop 4   1 B 12 M 1 Austin PD 3   Austin 3
108 108 5/9/2011 1 F 1 Y 1   L 2 M 1 30.0 Shots fired / shooting 3   1 H 10 M 1 Austin PD 3   Austin 3
109 109 8/15/2011 1 N 2 Y 1 No Hits W 1 M 1 21.0 Robbery 5   2 H, W 13 M, M 11 Austin PD 3   Austin 3
110 110 11/5/2011 1 N 2 N 2 No Hits L 2 M 1 34.0 Fight / disorderly conduct 6   1 W 1 M 1 Austin PD 3   Austin 3
111 111 12/5/2011 1 N 2 N 2 Vehicle W 1 M 1 26.0 Stolen vehicle 7   2 W, W 14 M,M 10 Austin PD 3   Austin 3
112 112 12/28/2011 1 N 2 N 2 No Hits; vehicle as weapon B 3 M 1 32.0 Drug suspicion / drug warrant 8   1 W 1 M 1 Austin PD 3   Austin 3
113 113 2/3/2012 1 N 2 Y 1 Indicted; charges dropped W 1 M 1 34.0 Mental crisis / suicide attempt 9   1 W 1 M 1 Austin PD 3   Austin 3
114 114 4/5/2012 1 F 1 N 2   B 3 M 1 35.0 Traffic stop 4   1 W 1 M 1 Austin PD 3   Austin 3
115 115 9/25/2012 1 F 1 N 2 Vehicle as weapon W 1 M 1 42.0 Stolen vehicle 7   1 W 1 M 1 Austin PD 3   Austin 3
116 116 10/20/2012 1 N 2 N 2 No Hits; vehicle as weapon B 3 F 3 24.0 Suspicious activity / patrol 10   1 W 1 M 1 Austin PD 3   Austin 3
117 117 1/14/2013 1 N 2 Y 1 No Hits B 3 M 1 51.0 Robbery 5   2 B, W 15 M, M 11 Austin PD 3   Austin 3
118 118 3/1/2013 1 F 1 Y 1   W 1 M 1 70.0 Shots fired / shooting 3   1 W 1 M 1 Austin PD 3   Austin 3
119 119 4/23/2013 1 F 1 Y 1   W 1 M 1 54.0 Weapons disturbance 11   4 W, H, W, W 16 M,M,M,M 12 Austin PD 3   Austin 3
120 120 5/8/2013 1 N 2 N 2 No Hits W 1 M 1 55.0 Traffic stop 4   1 W 1 M 1 Austin PD 3   Austin 3
121 121 5/17/2013 1 N 2 Y 1 No Hits W 1 M 1 26.0 Weapons disturbance 11   1 W 1 M 1 Austin PD 3   Austin 3
122 122 7/26/2013 1 F 1 N 2   B 3 M 1 32.0 Suspicious activity / patrol 10   1 W 1 M 1 Austin PD 3   Austin 3
123 123 8/31/2013 1 N 2 N 2 Vehicle as weapon L 2 M 1 46.0 Burglary / home invasion 2   1 A 17 M 1 Austin PD 3   Austin 3
124 124 10/18/2013 1 N 2 Y 1 Ofc. Cecil Jones Fired W 1 M 1 44.0 Shots fired / shooting 3   3 W, B, W 18 M, M, M 13 Austin PD 3   Austin 3
125 125 11/10/2013 1 N 2 Y 1   L 2 M 1 30.0 Other 12   2 W, H 19 M, M 11 Austin PD 3   Austin 3
126 126 1/25/2014 1 N 2 N 2 No Hits, vehicle as weapon L 2 M 1 22.0 Traffic stop 4   1 W 1 M 1 Austin PD 3   Austin 3
127 127 3/18/2014 1 N 2 N 2 BB gun B 3 M 1 22.0 Domestic Disturbance 1   1 W 1 M 1 Austin PD 3   Austin 3
128 128 9/8/2014 1 F 1 Y 1   W 1 M 1 24.0 Robbery 5   2 W,W 11 M,M 10 Austin PD 3   Austin 3
129 129 11/28/2014 1 F 1 Y 1   W 1 M 1 49.0 Shots fired / shooting 3   1 W 1 M 1 Austin PD 3   Austin 3
130 130 1/23/2015 1 F 1 Y 1   W 1 M 1 61.0 Mental crisis / suicide attempt 9   1 W 1 M 1 Austin PD 3   Austin 3
131 131 2/7/2015 1 F 1 Y 1   W 1 M 1 27.0 Shots fired / shooting 3   1 W 1 M 1 Austin PD 3   Austin 3
132 132 5/24/2015 1 N 2 Y 1   B 3 M 1 30.0 Weapons disturbance 11   2 H,W 20 F, M 14 Austin PD 3   Austin 3
133 133 5/25/2015 1 F 1 Y 1   W 1 F 3 31.0 Mental crisis / suicide attempt 9   1 W 1 M 1 Austin PD 3   Austin 3
134 134 7/5/2015 1 F 1 N 2   W 1 M 1 25.0 Other 12   3 W, W, A 21 M,M,M 15 Austin PD 3   Austin 3
135 135 7/5/2015 1 F 1 Y 1 BB gun W 1 M 1 35.0 Shots fired / shooting 3   1 H 10 M 1 Austin PD 3   Austin 3
136 136 7/12/2015 1 F 1 Y 1   W 1 M 1 63.0 Suspicious activity / patrol 10   1 W 1 M 1 Austin PD 3   Austin 3
137 137 4/3/2016 1 F 1 Y 1   W 1 M 1 25.0 Suspicious person 13 >/=4 1 H 10 M 1 Austin PD 3 The concierge at 800 W 5th Street observed a subject on video surveillance as he attempted to burglarize vehicles. The concierge attempted to subdue the subject several times but was unsuccessful. Ofc observed the concierge chasing the subject on foot. Ofc exited his vehicle as the concierge tackled the subject. As Ofc attempted to handcuff the subject, he produced a handgun and shot Ofc. Ofc returned fire , striking and killing the subject. Austin 3
138 138 3/20/2016 1 N 2 N 2 Knife B 3 M 1 34.0 Agg. Assault 14 >/=2 1 W 1 M 1 Austin PD 3 Multiple 911 calls were received regarding a male threatening customers with knives at a grocery store. An additional call was received indicating the same subject had attempted to force entry into a residence nearby . Responding officers searched the area and located the subject behind a nearby business. Subject fled across all lanes of IH35 still wielding the knives. Subject was observed behind another nearby business throwing rocks and bricks at officers. Subject fled again and was located at a school nearby. Subject was noncompliant with responding officers' multiple requests to drop his weapons. Officer fired his shotgun hitting the subject who once again fled. Subject was later located, apprehended and taken to a local hospital and treated for gunshot wound(s) and K9 dog bite. Subject was transported & booked at TCSO a few hours later. Austin 3
139 139 4/14/2016 1 N 2 Y 1 SWAT Team, W 1 M 1 18.0 Warrant Service 15 >/=3 2 W,W 11 M,M 10 Austin PD 3 APD SWAT team officers arrived at the subject's residence to execute a search warrant. The presence of SWAT team officers was announced over the loud speaker system as officers were entering the residence. Officers entered the subject's residence and the subject, who was standing on the second floor, fired a rifle at officers striking one officer with a non-fatal injury. The subject was later taken into custody and transported to jail where he was subsequently charged and indicted for Attempted Capital Murder. Austin 3
140 140 4/22/2016 1 F 1 N 2 Knife W 1 M 1 29.0 Disturbance 16 >/=1 1 H 10 M 1 Austin PD 3 Multiple 911 calls were received, later determined to be from the suspect, regarding a male subject threatening people with knives. Ofc responded to the first call but was unable to locate the described suspect. He later responded to a similar call at a different location where the subject was observed with knives in his hands. The subject charged at Ofc, who fired his firearm, wounding the subject. The subject was transported to the hospital where he was later pronounced deceased. Austin 3
141 141 2/8/2016 1 F 1 N 2 Naked suspect, Unarmed, Possible Mental Health B 3 M 1 17.0 Suspicious Person 17 >/=2 1 B 12 M 1 Austin PD 3 Officers responded to a call regarding a subject that had jumped over a fence to chase someone. The complainant indicated that the chase had ended and the subject was no longer visible. Shortly thereafter, multiple calls came in regarding a suspicious person that was believed to be related to the original call and was now being described as naked. Upon locating the subject, Ofc exited his vehicle and ordered the subject, who was completely unclothed, to stop as he was walking toward him. The male subject then took off running, charging directly at Ofc while disregarding his repeated commands to stop. Ofc Freeman fired at the subject, who was later pronounced deceased at a local hospital. Austin 3
142 142 9/14/2016 1 F 1 Y 1   W 1 M 1 34.0 Suspicious Person 17 >/=20 3 W,W,H 22 M,M,M 15 Austin PD 3 Officers responded to a call regarding a suspicious person looking into cars in an apartment complex. Officers arrived but were unable to locate the subject. Officers later responded to a second call regarding the same subject. The subject was located, but fled and a foot pursuit ensued. The subject did not comply with officer's orders to stop and show his hands and was subsequently tased. The subject fell to the ground but still failied to comply with orders to show his hands, retrieved a concealed handgun and fired multiple rounds at officers. Officers returned fire, striking the subject. While still not complying with verbal commands, less lethal rounds were used to incapacitate the subject and take control of his weapon. Officers then began life saving measures. Subject was transported to the hopsital where he was pronounced deceased. Austin 3
143 143 10/16/2016 1 F 1 N 2 Mental Health, Toy Gun W 1 F 3 26.0 Welfare Check 18 >/=12 2 W,W 11 M,F 16 Austin PD 3 Officers responded to a CIT call of a female having a mental health crisis. As the officers arrived, information was obtained that a weapon was possibly involved. Officers began walking toward the building where the call was originating from when the subject exited a breezeway, walking towards the officers while pointing a firearm at them. The officers gave commands to drop the handgun, to which the subject did not comply. The officers fired at the subject, striking her. The subject continue to attempt to manipulate the firearm in her possession and a single officer fired and additional volley of shots at the subject. The subject was placed into custody, transported to the hospital, where she was pronounced deceased. Austin 3
144 144 3/21/2010 1 F 1     B 3         3 W;W;W 4   Baltimore Police Department 4   BaltimoreCity 4
145 145 6/4/2010 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
146 146 6/5/2010 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
147 147 1/27/2010 1 N 2     W 1         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
148 148 6/9/2010 1 N 2               1 B 12   Baltimore Police Department 4   BaltimoreCity 4
149 149 5/21/2010 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
150 150 7/31/2010 1 N 2     W 1         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
151 151 8/14/2010 1 N 2     B 3         2 B;W 23   Baltimore Police Department 4   BaltimoreCity 4
152 152 8/15/2010 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
153 153 8/29/2010 1 N 2     B 3         1 H 10   Baltimore Police Department 4   BaltimoreCity 4
154 154 11/27/2010 1 N 2     B 3         3 W;W;B 24   Baltimore Police Department 4   BaltimoreCity 4
155 155 10/2/2011 1 F 1     W 1         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
156 156 10/8/2011 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
157 157 11/23/2011 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
158 158 3/18/2011 1 N 2     B 3         2 B;W 23   Baltimore Police Department 4   BaltimoreCity 4
159 159 4/11/2011 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
160 160 7/13/2011 1 N 2     B 3         2 B;W 23   Baltimore Police Department 4   BaltimoreCity 4
161 161 8/2/2011 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
162 162 12/12/2011 1 N 2     B 3         2 W;W 2   Baltimore Police Department 4   BaltimoreCity 4
163 163 3/27/2012 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
164 164 3/31/2012 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
165 165 5/19/2012 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
166 166 6/1/2012 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
167 167 7/1/2012 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
168 168 7/14/2012 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
169 169 7/31/2012 1 F 1     W 1         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
170 170 8/18/2012 1 F 1     B 3         2 H;W 25   Baltimore Police Department 4   BaltimoreCity 4
171 171 4/10/2012 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
172 172 8/8/2012 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
173 173 8/24/2012 1 N 2     B 3         3 W;B;H 26   Baltimore Police Department 4   BaltimoreCity 4
174 174 9/1/2012 1 N 2     B 3         2 B;B 27   Baltimore Police Department 4   BaltimoreCity 4
175 175 9/24/2012 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
176 176 10/4/2012 1 N 2     B 3         2 W;W 2   Baltimore Police Department 4   BaltimoreCity 4
177 177 10/23/2012 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
178 178 1/25/2013 1 F 1     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
179 179 4/19/2013 1 F 1     B 3         3 W;B;H 26   Baltimore Police Department 4   BaltimoreCity 4
180 180 5/25/2013 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
181 181 9/4/2013 1 F 1     B 3         3 W;W;B 24   Baltimore Police Department 4   BaltimoreCity 4
182 182 10/16/2013 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
183 183 1/2/2013 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
184 184 1/13/2013 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
185 185 1/28/2013 1 N 2     B 3         3 W;W;W 4   Baltimore Police Department 4   BaltimoreCity 4
186 186 1/29/2013 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
187 187 3/28/2013 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
188 188 8/13/2013 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
189 189 6/15/2014 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
190 190 1/13/2014 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
191 191 2/12/2014 1 F 1     B 3         2 W;H 28   Baltimore Police Department 4   BaltimoreCity 4
192 192 2/12/2014 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
193 193 2/21/2014 1 N 2     B 3         2 H;W 25   Baltimore Police Department 4   BaltimoreCity 4
194 194 4/29/2014 1 N 2     L 2         1 H 10   Baltimore Police Department 4   BaltimoreCity 4
195 195 5/16/2014 1 N 2     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
196 196 6/6/2014 1 N 2     L 2         2 B;B 27   Baltimore Police Department 4   BaltimoreCity 4
197 197 9/22/2014 1 N 2     B 3         1 B 12   Baltimore Police Department 4   BaltimoreCity 4
198 198 12/28/2014 1 N 2     W 1         3 W;W;B 24   Baltimore Police Department 4   BaltimoreCity 4
199 199 1/24/2015 1 F 1     B 3         1 W 1   Baltimore Police Department 4   BaltimoreCity 4
200 200 11/11/2015 1 F 1     B 3         2 W;B 29   Baltimore Police Department 4   BaltimoreCity 4

Next page

CREATE TABLE "ViceNews_FullOISData" (
"Date" TEXT,
  "NumberOfSubjects" INTEGER,
  "Fatal" INTEGER,
  "SubjectArmed" INTEGER,
  "Notes" REAL,
  "SubjectRace" INTEGER,
  "SubjectGender" INTEGER,
  "SubjectAge" REAL,
  "NatureOfStop" INTEGER,
  "NumberOfShots" REAL,
  "NumberOfOfficers" TEXT,
  "OfficerRace" INTEGER,
  "OfficerGender" INTEGER,
  "Department" INTEGER,
  "FullNarrative" REAL,
  "city" INTEGER
,
FOREIGN KEY ("Fatal") REFERENCES [Fatal](id),
    FOREIGN KEY ("SubjectArmed") REFERENCES [SubjectArmed](id),
    FOREIGN KEY ("SubjectRace") REFERENCES [SubjectRace](id),
    FOREIGN KEY ("SubjectGender") REFERENCES [SubjectGender](id),
    FOREIGN KEY ("OfficerRace") REFERENCES [OfficerRace](id),
    FOREIGN KEY ("OfficerGender") REFERENCES [OfficerGender](id),
    FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("city") REFERENCES [city](id),
    FOREIGN KEY ("NatureOfStop") REFERENCES [NatureOfStop](id))
Powered by Datasette · Query took 3.673ms