basis_for_search

Data license: ODbL · Data source: Open Justice

1,800,054 rows

View and edit SQL

Link rowid ▼ UNIQUE_ID BFS_CONSENT_GIVEN BFS_OFFICER_SAFETY BFS_SEARCH_WARRANT BFS_PAROLE BFS_SUSPECT_WEAPON BFS_VISIBLE_CONTRABAND BFS_ODOR_CONTRABAND BFS_CANINE_DETECT BFS_EVIDENCE BFS_INCIDENT BFS_EXIGENT_CIRCUM BFS_VEHICLE_INVENT BFS_SCHOOL_POLICY
1 1000000
2 1000001
3 1000002
4 1000003
5 1000004
6 1000005
7 1000006
8 1000007
9 1000008
10 1000009
11 1000010 0 0 0 0 0 0 0 0 1 0 0 0
12 1000011
13 1000012
14 1000013
15 1000014
16 1000015
17 1000016
18 1000017
19 1000018
20 1000019
21 1000020
22 1000021
23 1000022
24 1000023
25 1000024
26 1000025
27 1000026
28 1000027
29 1000028
30 1000029
31 1000030
32 1000031
33 1000032
34 1000033
35 1000034
36 1000035 0 0 0 0 0 0 0 0 1 0 0 0
37 1000036
38 1000037
39 1000038
40 1000039
41 1000040
42 1000041
43 1000042
44 1000043
45 1000044
46 1000045
47 1000046
48 1000047
49 1000048
50 1000049 0 0 0 0 0 0 0 0 1 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "basis_for_search" (
"UNIQUE_ID" INTEGER,
  "BFS_CONSENT_GIVEN" TEXT,
  "BFS_OFFICER_SAFETY" TEXT,
  "BFS_SEARCH_WARRANT" TEXT,
  "BFS_PAROLE" TEXT,
  "BFS_SUSPECT_WEAPON" TEXT,
  "BFS_VISIBLE_CONTRABAND" TEXT,
  "BFS_ODOR_CONTRABAND" TEXT,
  "BFS_CANINE_DETECT" TEXT,
  "BFS_EVIDENCE" TEXT,
  "BFS_INCIDENT" TEXT,
  "BFS_EXIGENT_CIRCUM" TEXT,
  "BFS_VEHICLE_INVENT" TEXT,
  "BFS_SCHOOL_POLICY" TEXT
);