home / vice

vice

Custom SQL query returning 101 rows

This data as .json, .jsono

rowidDateNumberOfSubjectsFatalSubjectArmedNotesSubjectRaceSubjectGenderSubjectAgeNatureOfStopNumberOfShotsNumberOfOfficersOfficerRaceOfficerGenderDepartmentFullNarrativecity
1 1/9/2010 1 1 1   1 1       1 1 1 1   1
2 1/13/2010 1 1 1   1 1       1 1 1 1   1
3 1/29/2010 1 2 1   2 1       1 1 1 1   1
4 3/4/2010 1 2 2 motorized vehicle; no hits 2 2       1 1 1 1   1
5 3/29/2010 1 1 2 motorized vehicle 1 1       1 1 1 1   1
6 4/14/2010 1 2 1   2 1       1 1 1 1   1
7 6/10/2010 1 1 1   1 1       2 2 2 1   1
8 6/15/2010 1 1 2 knife/cutting instrument   1       1 1 1 1   1
9 7/27/2010 1 1 2 knife/cutting instrument 2 1       1 1 1 1   1
10 7/28/2010 1 2 2 motorized vehicle   2       2 2 2 1   1
11 8/17/2010 1 1 2 knife/cutting instrument 2 1       1 1 1 1   1
12 9/14/2010 1 2 2 knife/cutting instrument 1 1       1 1 3 1   1
13 10/18/2010 1 1 1     1       3 3 4 1   1
14 10/31/2010 1 1 2 motorized vehicle 1 1       1 1 1 1   1
15 11/10/2010 1 2 1     1       1 1 1 1   1
16 11/11/2010 1 2 1   2 1       1 1 1 1   1
17 11/11/2010 1 2 2 motorized vehicle 2 3       1 1 1 1   1
18 1/14/2011 1 2 2 no hits   1       1 1 1 1   1
19 2/9/2011 1 1 1   1 1       1 1 1 1   1
20 4/12/2011 1 1 1   2 1       1 1 1 1   1
21 5/10/2011 1 1 1   2 1       1 1 1 1   1
22 6/4/2011 1 1 1   2 1       3 4 4 1   1
23 6/26/2011 1 2 2 knife/cutting instrument 2 1       1 1 1 1   1
24 8/30/2011 1 1 1   2 1       1 1 1 1   1
25 9/7/2011 1 2 1     1       1 1 1 1   1
26 1/4/2012 1 1 1   1 1       1 1 1 1   1
27 3/19/2012 1 1 2 motorized vehicle 1 1       1 1 1 1   1
28 3/21/2012 1 1 1   1 1       1 1 1 1   1
29 4/19/2012 1 2 1   2 1       1 1 1 1   1
30 6/20/2012 1 2 1   2 1       1 5 1 1   1
31 8/6/2012 1 2 1   2 1       1 1 1 1   1
32 12/17/2012 1 2 2 no hits 2 2       1 1 1 1   1
33 3/5/2013 1 1 1   1 1       3 4 4 1   1
34 3/19/2013 1 1 1   3 1       1 1 1 1   1
35 7/5/2013 1 1 2 knife/cutting instrument 3 1       2 2 5 1   1
36 7/30/2013 1 2 2     2       2 2 2 1   1
37 9/3/2013 1 2 1     2       1 1 1 1   1
38 8/21/2013 1 2 2     2       1 1 1 1   1
39 10/26/2013 1 1 1   1 1       6 6 6 1   1
40 10/28/2013 1 2 1   2 1       1 1 1 1   1
41 11/9/2013 1 2 1     2       4 7 7 1   1
42 11/15/2013 1 2 1   2 1       1 1 1 1   1
43 12/1/2013 1 1 2 blunt instrument 1 1       3 4 4 1   1
44 12/8/2013 1 1 2 blunt instrument 1 1       1 1 1 1   1
45 1/9/2014 1 2 2 motorized vehicle   2       1 1 1 1   1
46 3/16/2014 1 1 2 knife/cutting instrument 1 1       2 8 2 1   1
47 3/25/2014 1 1 1     1       1 1 1 1   1
48 4/21/2014 1 1 1   1 3       1 1 1 1   1
49 5/22/2014 1 1 2 knife/cutting instrument 2 1       2 2 2 1   1
50 5/3/2014 1 1 1   3 1       1 1 1 1   1
51 7/22/2014 1 1 1   1 1       2 2 2 1   1
52 12/14/2014 1 2 2 accidental discharge   1       1 1 1 1   1
53 1/3/2015 1 2 1   1 1       1 1 1 1   1
54 1/9/2015 1 2 1     1       1 1 1 1   1
55 1/13/2015 1 1 1   1 1       2 2 2 1   1
56 5/25/2015 1 2 3 no hits 2 1       1 1 1 1   1
57 5/28/2015 1 2 3 no hits 2 1       10 9 8 1   1
58 6/4/2015 1 2 2 motorized vehicle; no hits 2 1       1 1 1 1   1
59 7/31/2015 1 1 1   2 1       2 2 2 1   1
60 9/30/2015 1 2 1   2 1       1 1 1 1   1
61 12/22/2015 1 2 1   2 1       2 2 9 1   1
62 1/11/2016 1 2 1   2 1       1 1 1 1   1
63 2/2/2016 1 1 1     1       1 1 1 1   1
64 5/24/2016 1 1 1     1       1 1 1 1   1
65 5/28/2016 1 1 1     1       1 1 1 1   1
66 6/15/2016 1 1 1     1       3 4 4 1   1
67 10/22/2016 1 2 1     1       1 1 1 1   1
68 10/10/2015 1 2 2 hits unknown; vehicle           1     2   2
69 8/21/2015 1 2 2 hits unknown; vehicle           3     2   2
70 7/1/2015 1 2 2 hits unknown; vehicle           2     2   2
71 4/30/2015 1 1 1 hits unknown           2     2   2
72 4/8/2015 1 2 1 4.0         20.0 2     2   2
73 10/24/2014 1 2 1 1.0         1.0 1     2   2
74 9/7/2014 1 2 1 1.0         3.0 1     2   2
75 8/27/2014 1 2 2 1; knife         3.0 1     2   2
76 7/10/2014 1 2 2 1; furtive movement         1.0 1     2   2
77 7/3/2014 1 1 2 hits unknown; ax           1     2   2
78 6/20/2014 1 2 1 1.0         1.0 1     2   2
79 6/16/2014 1 2 2 hits unknown; crowbar           1     2   2
80 5/21/2014 1 2 2 hits unknown; fake pistol           3     2   2
81 5/2/2014 1 2 1 hits unknown           2     2   2
82 1/23/2014 1 2 1 hits unknown           1     2   2
83 10/14/2013 1 2 2 1; vehicle         3.0 1     2   2
84 9/19/2013 1 2 1 hits unknown         9.0 1     2   2
85 6/19/2013 1 2 1 2.0         4.0 1     2   2
86 5/13/2013 1 1 1 hits unknown         11.0 2     2   2
87 4/4/2013 1 2 2 1; ad         1.0 1     2   2
88 12/18/2012 1 2 1 1.0         13.0 1     2   2
89 11/8/2012 1 2 1 2.0         6.0 1     2   2
90 9/5/2012 1 1 1 3.0         3.0 1     2   2
91 7/13/2012 1 1 1 3.0         5.0 2     2   2
92 6/27/2012 1 1 2 hits unknown; vehicle         17.0 3     2   2
93 5/18/2012 1 2 2 2; knife         2.0 1     2   2
94 4/30/2012 1 2 1 hits unknown         2.0 1     2   2
95 11/28/2011 1 1 2 hits unknown; knife         16.0 2     2   2
96 10/25/2011 1 2 1 2.0         10.0 2     2   2
97 9/1/2011 1 2 1 2.0         2.0 1     2   2
98 8/10/2011 1 1 2 5; BB gun         10.0 1     2   2
99 6/30/2011 1 1 2 1; asp baton         1.0 1     2   2
100 4/8/2011 1 2 1 1.0         14.0 3     2   2
101 6/23/2010 1 2 2 Shots grazed; ricichet         1.0 1     2   2
Powered by Datasette · Query took 2.261ms · Data license: CC BY-NC-SA 4.0 · Data source: VICE News