action_taken

Data license: ODbL · Data source: Open Justice

1,800,054 rows

View and edit SQL

Link rowid ▼ UNIQUE_ID ADS_REMOVED_VEHICLE_ORDER ADS_REMOVED_VEHICLE_PHYCONTACT ADS_SOBRIETY_TEST ADS_CURB_DETENT ADS_HANDCUFFED ADS_PATCAR_DETENT ADS_CANINE_SEARCH ADS_FIREARM_POINT ADS_FIREARM_DISCHARGE ADS_ELECT_DEVICE ADS_IMPACT_DISCHARGE ADS_CANINE_BITE ADS_BATON ADS_CHEM_SPRAY ADS_OTHER_CONTACT ADS_PHOTO ADS_ASKED_SEARCH_PER ADS_SEARCH_PERSON ADS_ASKED_SEARCH_PROP ADS_SEARCH_PROPERTY ADS_PROP_SEIZE ADS_VEHICLE_IMPOUND ADS_WRITTEN_STATEMENT ADS_NO_ACTIONS ADS_SEARCH_PERS_CONSEN ADS_SEARCH_PROP_CONSEN
1 1000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
2 1000001 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
3 1000002 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
4 1000003 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
5 1000004 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
6 1000005 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
7 1000006 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
8 1000007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
9 1000008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
10 1000009 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
11 1000010 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0
12 1000011 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
13 1000012 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
14 1000013 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
15 1000014 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
16 1000015 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
17 1000016 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
18 1000017 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
19 1000018 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
20 1000019 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
21 1000020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
22 1000021 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
23 1000022 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
24 1000023 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
25 1000024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
26 1000025 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
27 1000026 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
28 1000027 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
29 1000028 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
30 1000029 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
31 1000030 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
32 1000031 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
33 1000032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
34 1000033 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
35 1000034 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
36 1000035 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
37 1000036 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
38 1000037 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
39 1000038 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
40 1000039 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
41 1000040 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
42 1000041 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
43 1000042 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
44 1000043 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
45 1000044 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
46 1000045 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
47 1000046 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
48 1000047 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
49 1000048 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
50 1000049 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "action_taken" (
"UNIQUE_ID" INTEGER,
  "ADS_REMOVED_VEHICLE_ORDER" TEXT,
  "ADS_REMOVED_VEHICLE_PHYCONTACT" TEXT,
  "ADS_SOBRIETY_TEST" TEXT,
  "ADS_CURB_DETENT" TEXT,
  "ADS_HANDCUFFED" TEXT,
  "ADS_PATCAR_DETENT" TEXT,
  "ADS_CANINE_SEARCH" TEXT,
  "ADS_FIREARM_POINT" TEXT,
  "ADS_FIREARM_DISCHARGE" TEXT,
  "ADS_ELECT_DEVICE" TEXT,
  "ADS_IMPACT_DISCHARGE" TEXT,
  "ADS_CANINE_BITE" TEXT,
  "ADS_BATON" TEXT,
  "ADS_CHEM_SPRAY" TEXT,
  "ADS_OTHER_CONTACT" TEXT,
  "ADS_PHOTO" TEXT,
  "ADS_ASKED_SEARCH_PER" TEXT,
  "ADS_SEARCH_PERSON" TEXT,
  "ADS_ASKED_SEARCH_PROP" TEXT,
  "ADS_SEARCH_PROPERTY" TEXT,
  "ADS_PROP_SEIZE" TEXT,
  "ADS_VEHICLE_IMPOUND" TEXT,
  "ADS_WRITTEN_STATEMENT" TEXT,
  "ADS_NO_ACTIONS" TEXT,
  "ADS_SEARCH_PERS_CONSEN" TEXT,
  "ADS_SEARCH_PROP_CONSEN" TEXT
);