home / vice

ViceNews_FullOISData

4,381 rows

View and edit SQL

This data as .json, .jsono

LinkrowidDateNumberOfSubjectsFatalSubjectArmedNotesSubjectRaceSubjectGenderSubjectAgeNatureOfStopNumberOfShotsNumberOfOfficersOfficerRaceOfficerGenderDepartmentFullNarrativecity
1 1 1/9/2010 1 F 1 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
2 2 1/13/2010 1 F 1 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
3 3 1/29/2010 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
4 4 3/4/2010 1 N 2 N 2 motorized vehicle; no hits L 2 U 2       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
5 5 3/29/2010 1 F 1 N 2 motorized vehicle W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
6 6 4/14/2010 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
7 7 6/10/2010 1 F 1 Y 1   W 1 M 1       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
8 8 6/15/2010 1 F 1 N 2 knife/cutting instrument   M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
9 9 7/27/2010 1 F 1 N 2 knife/cutting instrument L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
10 10 7/28/2010 1 N 2 N 2 motorized vehicle   U 2       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
11 11 8/17/2010 1 F 1 N 2 knife/cutting instrument L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
12 12 9/14/2010 1 N 2 N 2 knife/cutting instrument W 1 M 1       1 W 1 F 3 Albuquerque Police Department 1   Albuquerque 1
13 13 10/18/2010 1 F 1 Y 1     M 1       3 U;W;W 3 M;M;M 4 Albuquerque Police Department 1   Albuquerque 1
14 14 10/31/2010 1 F 1 N 2 motorized vehicle W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
15 15 11/10/2010 1 N 2 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
16 16 11/11/2010 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
17 17 11/11/2010 1 N 2 N 2 motorized vehicle L 2 F 3       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
18 18 1/14/2011 1 N 2 N 2 no hits   M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
19 19 2/9/2011 1 F 1 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
20 20 4/12/2011 1 F 1 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
21 21 5/10/2011 1 F 1 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
22 22 6/4/2011 1 F 1 Y 1   L 2 M 1       3 W;W;W 4 M;M;M 4 Albuquerque Police Department 1   Albuquerque 1
23 23 6/26/2011 1 N 2 N 2 knife/cutting instrument L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
24 24 8/30/2011 1 F 1 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
25 25 9/7/2011 1 N 2 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
26 26 1/4/2012 1 F 1 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
27 27 3/19/2012 1 F 1 N 2 motorized vehicle W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
28 28 3/21/2012 1 F 1 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
29 29 4/19/2012 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
30 30 6/20/2012 1 N 2 Y 1   L 2 M 1       1 U 5 M 1 Albuquerque Police Department 1   Albuquerque 1
31 31 8/6/2012 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
32 32 12/17/2012 1 N 2 N 2 no hits L 2 U 2       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
33 33 3/5/2013 1 F 1 Y 1   W 1 M 1       3 W;W;W 4 M;M;M 4 Albuquerque Police Department 1   Albuquerque 1
34 34 3/19/2013 1 F 1 Y 1   B 3 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
35 35 7/5/2013 1 F 1 N 2 knife/cutting instrument B 3 M 1       2 W;W 2 M;F 5 Albuquerque Police Department 1   Albuquerque 1
36 36 7/30/2013 1 N 2 N 2     U 2       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
37 37 9/3/2013 1 N 2 Y 1     U 2       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
38 38 8/21/2013 1 N 2 N 2     U 2       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
39 39 10/26/2013 1 F 1 Y 1   W 1 M 1       6 W;W;W;W;W;W 6 M;F;M;M;M;M 6 Albuquerque Police Department 1   Albuquerque 1
40 40 10/28/2013 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
41 41 11/9/2013 1 N 2 Y 1     U 2       4 W;W;W;W 7 M;M;M;M 7 Albuquerque Police Department 1   Albuquerque 1
42 42 11/15/2013 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
43 43 12/1/2013 1 F 1 N 2 blunt instrument W 1 M 1       3 W;W;W 4 M;M;M 4 Albuquerque Police Department 1   Albuquerque 1
44 44 12/8/2013 1 F 1 N 2 blunt instrument W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
45 45 1/9/2014 1 N 2 N 2 motorized vehicle   U 2       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
46 46 3/16/2014 1 F 1 N 2 knife/cutting instrument W 1 M 1       2 W;U 8 M;M 2 Albuquerque Police Department 1   Albuquerque 1
47 47 3/25/2014 1 F 1 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
48 48 4/21/2014 1 F 1 Y 1   W 1 F 3       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
49 49 5/22/2014 1 F 1 N 2 knife/cutting instrument L 2 M 1       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
50 50 5/3/2014 1 F 1 Y 1   B 3 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
51 51 7/22/2014 1 F 1 Y 1   W 1 M 1       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
52 52 12/14/2014 1 N 2 N 2 accidental discharge   M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
53 53 1/3/2015 1 N 2 Y 1   W 1 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
54 54 1/9/2015 1 N 2 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
55 55 1/13/2015 1 F 1 Y 1   W 1 M 1       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
56 56 5/25/2015 1 N 2 U 3 no hits L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
57 57 5/28/2015 1 N 2 U 3 no hits L 2 M 1       10 W;W;W;W;W;W;W;B;U;W 9 F;M;M;M;M;M;M;M;M;M 8 Albuquerque Police Department 1   Albuquerque 1
58 58 6/4/2015 1 N 2 N 2 motorized vehicle; no hits L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
59 59 7/31/2015 1 F 1 Y 1   L 2 M 1       2 W;W 2 M;M 2 Albuquerque Police Department 1   Albuquerque 1
60 60 9/30/2015 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
61 61 12/22/2015 1 N 2 Y 1   L 2 M 1       2 W;W 2 F;M 9 Albuquerque Police Department 1   Albuquerque 1
62 62 1/11/2016 1 N 2 Y 1   L 2 M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
63 63 2/2/2016 1 F 1 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
64 64 5/24/2016 1 F 1 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
65 65 5/28/2016 1 F 1 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
66 66 6/15/2016 1 F 1 Y 1     M 1       3 W;W;W 4 M;M;M 4 Albuquerque Police Department 1   Albuquerque 1
67 67 10/22/2016 1 N 2 Y 1     M 1       1 W 1 M 1 Albuquerque Police Department 1   Albuquerque 1
68 68 10/10/2015 1 N 2 N 2 hits unknown; vehicle           1     Atlanta Police Department 2   Atlanta 2
69 69 8/21/2015 1 N 2 N 2 hits unknown; vehicle           3     Atlanta Police Department 2   Atlanta 2
70 70 7/1/2015 1 N 2 N 2 hits unknown; vehicle           2     Atlanta Police Department 2   Atlanta 2
71 71 4/30/2015 1 F 1 Y 1 hits unknown           2     Atlanta Police Department 2   Atlanta 2
72 72 4/8/2015 1 N 2 Y 1 4.0         20.0 2     Atlanta Police Department 2   Atlanta 2
73 73 10/24/2014 1 N 2 Y 1 1.0         1.0 1     Atlanta Police Department 2   Atlanta 2
74 74 9/7/2014 1 N 2 Y 1 1.0         3.0 1     Atlanta Police Department 2   Atlanta 2
75 75 8/27/2014 1 N 2 N 2 1; knife         3.0 1     Atlanta Police Department 2   Atlanta 2
76 76 7/10/2014 1 N 2 N 2 1; furtive movement         1.0 1     Atlanta Police Department 2   Atlanta 2
77 77 7/3/2014 1 F 1 N 2 hits unknown; ax           1     Atlanta Police Department 2   Atlanta 2
78 78 6/20/2014 1 N 2 Y 1 1.0         1.0 1     Atlanta Police Department 2   Atlanta 2
79 79 6/16/2014 1 N 2 N 2 hits unknown; crowbar           1     Atlanta Police Department 2   Atlanta 2
80 80 5/21/2014 1 N 2 N 2 hits unknown; fake pistol           3     Atlanta Police Department 2   Atlanta 2
81 81 5/2/2014 1 N 2 Y 1 hits unknown           2     Atlanta Police Department 2   Atlanta 2
82 82 1/23/2014 1 N 2 Y 1 hits unknown           1     Atlanta Police Department 2   Atlanta 2
83 83 10/14/2013 1 N 2 N 2 1; vehicle         3.0 1     Atlanta Police Department 2   Atlanta 2
84 84 9/19/2013 1 N 2 Y 1 hits unknown         9.0 1     Atlanta Police Department 2   Atlanta 2
85 85 6/19/2013 1 N 2 Y 1 2.0         4.0 1     Atlanta Police Department 2   Atlanta 2
86 86 5/13/2013 1 F 1 Y 1 hits unknown         11.0 2     Atlanta Police Department 2   Atlanta 2
87 87 4/4/2013 1 N 2 N 2 1; ad         1.0 1     Atlanta Police Department 2   Atlanta 2
88 88 12/18/2012 1 N 2 Y 1 1.0         13.0 1     Atlanta Police Department 2   Atlanta 2
89 89 11/8/2012 1 N 2 Y 1 2.0         6.0 1     Atlanta Police Department 2   Atlanta 2
90 90 9/5/2012 1 F 1 Y 1 3.0         3.0 1     Atlanta Police Department 2   Atlanta 2
91 91 7/13/2012 1 F 1 Y 1 3.0         5.0 2     Atlanta Police Department 2   Atlanta 2
92 92 6/27/2012 1 F 1 N 2 hits unknown; vehicle         17.0 3     Atlanta Police Department 2   Atlanta 2
93 93 5/18/2012 1 N 2 N 2 2; knife         2.0 1     Atlanta Police Department 2   Atlanta 2
94 94 4/30/2012 1 N 2 Y 1 hits unknown         2.0 1     Atlanta Police Department 2   Atlanta 2
95 95 11/28/2011 1 F 1 N 2 hits unknown; knife         16.0 2     Atlanta Police Department 2   Atlanta 2
96 96 10/25/2011 1 N 2 Y 1 2.0         10.0 2     Atlanta Police Department 2   Atlanta 2
97 97 9/1/2011 1 N 2 Y 1 2.0         2.0 1     Atlanta Police Department 2   Atlanta 2
98 98 8/10/2011 1 F 1 N 2 5; BB gun         10.0 1     Atlanta Police Department 2   Atlanta 2
99 99 6/30/2011 1 F 1 N 2 1; asp baton         1.0 1     Atlanta Police Department 2   Atlanta 2
100 100 4/8/2011 1 N 2 Y 1 1.0         14.0 3     Atlanta Police Department 2   Atlanta 2

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.15ms