aa_main_table

Data license: ODbL · Data source: Open Justice

1,800,054 rows

View and edit SQL

AGENCY_NAME

Link rowid ▼ UNIQUE_ID DOJ_RECORD_ID PERSON_NUMBER AGENCY_ORI AGENCY_ORI_2 AGENCY_NAME TIME_OF_STOP DATE_OF_STOP STOP_DURATION CLOSEST_CITY SCHOOL_CODE SCHOOL_NAME STOP_STUDENT K12_SCHOOL_GROUNDS LGBT AGE AGE_GROUP LIMITED_ENGLISH_FLUENCY REASON_FOR_STOP CALL_FOR_SERVICE
1 1000000 W711019070C02B98AG1U 1 CA0371100 7 SAN DIEGO PD 730 8/8/2018 0:00:00 10 SAN DIEGO 0 0 0 20 4 0 1 0
2 1000001 W711019070PE4K98L8BO 1 CA0371100 7 SAN DIEGO PD 1925 7/25/2018 0:00:00 10 SAN DIEGO 0 0 0 50 7 0 1 0
3 1000002 W711019070LJT0Y0YXQI 1 CA0371100 7 SAN DIEGO PD 1101 7/22/2018 0:00:00 15 SAN DIEGO 0 0 0 65 9 1 1 0
4 1000003 W4990190709982J22GNN 1 CA0349902 4 CHP-HQ A/C, STAFF 2316 9/7/2018 0:00:00 8 EL CAJON 0 0 0 28 5 0 1 0
5 1000004 W499019066JLQMOTR0LE 1 CA0349902 4 CHP-HQ A/C, STAFF 746 8/9/2018 0:00:00 37 THOUSAND OAKS 0 0 0 34 5 0 1 0
6 1000005 W499019070PBG2UIJF8F 1 CA0349902 4 CHP-HQ A/C, STAFF 1242 9/1/2018 0:00:00 12 FRESNO 0 0 0 32 5 0 1 0
7 1000006 W499019066EVX73XW92S 1 CA0349902 4 CHP-HQ A/C, STAFF 1923 8/5/2018 0:00:00 14 OAKLAND 0 0 0 42 6 0 1 0
8 1000007 W499019071RJGPX9C18X 1 CA0349902 4 CHP-HQ A/C, STAFF 2028 9/11/2018 0:00:00 20 UNINCORPORATED AREA-RIVERSIDE COUNTY 0 0 0 50 7 0 1 0
9 1000008 W499019071FJQME9QUBG 1 CA0349902 4 CHP-HQ A/C, STAFF 2350 9/15/2018 0:00:00 30 UNINCORPORATED AREA-LOS ANGELES COUNTY 0 0 0 50 7 0 1 0
10 1000009 W499019067G55DFYYAHB 1 CA0349902 4 CHP-HQ A/C, STAFF 2248 8/12/2018 0:00:00 10 GLENDALE 0 0 0 20 4 0 1 0
11 1000010 W499019070AUAFLP47J0 1 CA0349902 4 CHP-HQ A/C, STAFF 43 9/2/2018 0:00:00 20 GOLETA 0 0 0 29 5 0 1 0
12 1000011 W4990190711JW9CAIL0B 1 CA0349902 4 CHP-HQ A/C, STAFF 1956 9/14/2018 0:00:00 5 MADERA 0 0 0 22 4 0 1 0
13 1000012 W4990190678SPCENMIZS 1 CA0349902 4 CHP-HQ A/C, STAFF 1955 8/18/2018 0:00:00 6 UNINCORPORATED AREA-KINGS COUNTY 0 0 0 19 4 0 1 0
14 1000013 W7110190707OA3QWWX76 1 CA0371100 7 SAN DIEGO PD 1937 8/15/2018 0:00:00 2 SAN DIEGO 0 0 0 35 6 0 1 0
15 1000014 W499019066NHMV7ZXY8V 1 CA0349902 4 CHP-HQ A/C, STAFF 1851 8/7/2018 0:00:00 7 FRESNO 0 0 0 50 7 0 1 0
16 1000015 W4990190712NC9UA93CT 1 CA0349902 4 CHP-HQ A/C, STAFF 813 9/18/2018 0:00:00 22 UNINCORPORATED AREA-MENDOCINO COUNTY 0 0 0 19 4 0 1 0
17 1000016 W499019071J8A6TJP3W7 1 CA0349902 4 CHP-HQ A/C, STAFF 908 9/16/2018 0:00:00 8 DIAMOND BAR 0 0 0 38 6 0 1 0
18 1000017 W499019071MN841Y6H47 1 CA0349902 4 CHP-HQ A/C, STAFF 948 9/12/2018 0:00:00 12 UNINCORPORATED AREA-NAPA COUNTY 0 0 0 21 4 0 1 0
19 1000018 W711019071ZM1JOUODSQ 2 CA0371100 7 SAN DIEGO PD 1605 8/31/2018 0:00:00 8 SAN DIEGO 0 0 0 25 5 0 1 0
20 1000019 W499019071E1DIVCMMQ6 1 CA0349902 4 CHP-HQ A/C, STAFF 432 9/19/2018 0:00:00 11 UNINCORPORATED AREA-SAN BERNARDINO COUNTY 0 0 0 41 6 0 1 0
21 1000020 W499019071LCSS1CSFFK 1 CA0349902 4 CHP-HQ A/C, STAFF 1347 9/11/2018 0:00:00 2 UNINCORPORATED AREA-LOS ANGELES COUNTY 19650376022818 HOWARD J. MCKIBBEN ELEMENTARY 0 1 0 17 3 0 1 0
22 1000021 W499019064Y2WR2TDH48 1 CA0349902 4 CHP-HQ A/C, STAFF 1850 7/13/2018 0:00:00 10 FREMONT 0 0 0 42 6 0 1 0
23 1000022 W499019065XWBV06KABO 1 CA0349902 4 CHP-HQ A/C, STAFF 1433 7/17/2018 0:00:00 10 LOS ALTOS 0 0 0 57 8 0 1 0
24 1000023 W499019065FE8NITI4Z1 1 CA0349902 4 CHP-HQ A/C, STAFF 2004 7/22/2018 0:00:00 1213 UNINCORPORATED AREA-STANISLAUS COUNTY 0 0 0 20 4 0 1 0
25 1000024 W499019065A4S2QR49E6 1 CA0349902 4 CHP-HQ A/C, STAFF 1621 7/22/2018 0:00:00 1 UNINCORPORATED AREA-VENTURA COUNTY 0 0 0 55 8 0 1 0
26 1000025 W499019065NJQ5A0796E 1 CA0349902 4 CHP-HQ A/C, STAFF 1303 7/21/2018 0:00:00 5 UNINCORPORATED AREA-SAN DIEGO COUNTY 0 0 0 44 6 0 1 0
27 1000026 W499019065NKT4FEB2PW 1 CA0349902 4 CHP-HQ A/C, STAFF 1630 7/15/2018 0:00:00 7 LOS ANGELES 0 0 0 28 5 0 1 0
28 1000027 W499019067M9AOQJQ62M 1 CA0349902 4 CHP-HQ A/C, STAFF 857 8/22/2018 0:00:00 9 UNINCORPORATED AREA-LOS ANGELES COUNTY 0 0 0 47 7 0 1 0
29 1000028 W499019064RX4512BUWO 1 CA0349902 4 CHP-HQ A/C, STAFF 650 7/1/2018 0:00:00 15 UNINCORPORATED AREA-KERN COUNTY 0 0 0 38 6 0 1 0
30 1000029 W499019066BDPYSSNTY9 1 CA0349902 4 CHP-HQ A/C, STAFF 1700 8/11/2018 0:00:00 11 UNINCORPORATED AREA-SUTTER COUNTY 0 0 0 18 4 0 1 0
31 1000030 W499019067L3SYCWY3JL 1 CA0349902 4 CHP-HQ A/C, STAFF 1954 8/27/2018 0:00:00 8 MORGAN HILL 0 0 0 25 5 0 1 0
32 1000031 W499019067GL72TJEUCH 1 CA0349902 4 CHP-HQ A/C, STAFF 1151 8/28/2018 0:00:00 5 UNINCORPORATED AREA-VENTURA COUNTY 0 0 0 20 4 0 1 0
33 1000032 W499019067RK45GAZDJ4 1 CA0349902 4 CHP-HQ A/C, STAFF 1707 8/30/2018 0:00:00 8 UNINCORPORATED AREA-PLACER COUNTY 0 0 0 44 6 0 1 0
34 1000033 W4990190678R5KZJ85CP 1 CA0349902 4 CHP-HQ A/C, STAFF 1437 8/21/2018 0:00:00 21 UNINCORPORATED AREA-SAN DIEGO COUNTY 0 0 0 31 5 0 1 0
35 1000034 W499019067N46TY4SOO9 1 CA0349902 4 CHP-HQ A/C, STAFF 1101 8/30/2018 0:00:00 6 UNINCORPORATED AREA-MONTEREY COUNTY 0 0 0 20 4 0 1 0
36 1000035 W499019067GMNWA8AH7M 1 CA0349902 4 CHP-HQ A/C, STAFF 141 8/18/2018 0:00:00 136 SAN JOSE 0 0 0 24 4 0 1 0
37 1000036 W4990190650AXOP1NCC8 1 CA0349902 4 CHP-HQ A/C, STAFF 1121 7/17/2018 0:00:00 10 UNINCORPORATED AREA-SAN JOAQUIN COUNTY 0 0 0 5 1 0 1 0
38 1000037 W499019067X0GK4CVAUK 1 CA0349902 4 CHP-HQ A/C, STAFF 1916 8/20/2018 0:00:00 9 UNINCORPORATED AREA-MADERA COUNTY 0 0 0 22 4 0 1 0
39 1000038 W499019067E3MXFQQEJA 1 CA0349902 4 CHP-HQ A/C, STAFF 701 8/26/2018 0:00:00 6 COLTON 0 0 0 23 4 0 1 0
40 1000039 W499019067MI77YSCS6U 1 CA0349902 4 CHP-HQ A/C, STAFF 1220 8/30/2018 0:00:00 5 UNINCORPORATED AREA-SONOMA COUNTY 0 0 0 68 9 0 1 0
41 1000040 W499019067UVL5JLVAKB 1 CA0349902 4 CHP-HQ A/C, STAFF 151 8/18/2018 0:00:00 14 SAN RAFAEL 0 0 0 23 4 0 1 0
42 1000041 W499019067ESTURPY8XJ 1 CA0349902 4 CHP-HQ A/C, STAFF 802 8/27/2018 0:00:00 6 LOS ANGELES 0 0 0 55 8 0 1 0
43 1000042 W4990190675N98SW781V 1 CA0349902 4 CHP-HQ A/C, STAFF 1550 8/22/2018 0:00:00 20 UNINCORPORATED AREA-SANTA CLARA COUNTY 0 0 0 43 6 0 1 0
44 1000043 W499019065WSCALO63KA 1 CA0349902 4 CHP-HQ A/C, STAFF 50 7/24/2018 0:00:00 20 UNINCORPORATED AREA-FRESNO COUNTY 0 0 0 27 5 0 1 0
45 1000044 W4990190678GLUVEZ280 1 CA0349902 4 CHP-HQ A/C, STAFF 1910 8/28/2018 0:00:00 5 UNINCORPORATED AREA-KERN COUNTY 0 0 0 40 6 0 1 0
46 1000045 W4990190671CRIWYYINH 1 CA0349902 4 CHP-HQ A/C, STAFF 1808 8/30/2018 0:00:00 5 LIVERMORE 0 0 0 32 5 0 1 0
47 1000046 W4990190656CI24HM8T6 1 CA0349902 4 CHP-HQ A/C, STAFF 652 7/27/2018 0:00:00 8 SAN DIMAS 0 0 0 41 6 0 1 0
48 1000047 W499019065P0YAR6OWSM 1 CA0349902 4 CHP-HQ A/C, STAFF 1717 7/28/2018 0:00:00 15 UNINCORPORATED AREA-MONTEREY COUNTY 0 0 0 30 5 0 1 0
49 1000048 W4990190652VYH6SGSZ8 1 CA0349902 4 CHP-HQ A/C, STAFF 1921 7/27/2018 0:00:00 5 UNINCORPORATED AREA-FRESNO COUNTY 0 0 0 22 4 0 1 0
50 1000049 W499019067OS5XRXLDHA 1 CA0349902 4 CHP-HQ A/C, STAFF 50 8/30/2018 0:00:00 60 SANTA ROSA 0 0 0 28 5 0 1 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "aa_main_table" (
"UNIQUE_ID" INTEGER,
  "DOJ_RECORD_ID" TEXT,
  "PERSON_NUMBER" INTEGER,
  "AGENCY_ORI" TEXT,
  "AGENCY_ORI_2" INTEGER,
  "AGENCY_NAME" TEXT,
  "TIME_OF_STOP" INTEGER,
  "DATE_OF_STOP" TEXT,
  "STOP_DURATION" INTEGER,
  "CLOSEST_CITY" TEXT,
  "SCHOOL_CODE" TEXT,
  "SCHOOL_NAME" TEXT,
  "STOP_STUDENT" INTEGER,
  "K12_SCHOOL_GROUNDS" INTEGER,
  "LGBT" INTEGER,
  "AGE" INTEGER,
  "AGE_GROUP" INTEGER,
  "LIMITED_ENGLISH_FLUENCY" INTEGER,
  "REASON_FOR_STOP" INTEGER,
  "CALL_FOR_SERVICE" INTEGER
);