citizens

841,673 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ citizen_uid allegation_uid uof_uid stop_and_search_uid complainant_type complainant_sex complainant_race citizen_influencing_factors citizen_distance_from_officer citizen_arrested citizen_arrest_charges citizen_hospitalized citizen_injured citizen_age citizen_race citizen_sex citizen_id citizen_height citizen_weight citizen_hair_color citizen_eye_color citizen_driver_license_state agency
1 1 000005c091acb67e650fdcd89eb58180     bd93c822c54ce2e33d559420dc3e088c                     black male 552724 71.0 170 black brown   new-orleans-pd
2 2 00000778cc9ba28a017ed8949d021383     0abab977340c6772557764f4cd496d50                     black female 513634 68.0 180 black brown la new-orleans-pd
3 3 00002395d9281baba3092425676e42c8     597930b0889f574d8d7f07a31ee9baa0                     black female 432292 64.0 140 black brown   new-orleans-pd
4 4 00002dc40157c687ceffe9838cab7bb0     5f3d1c15abe1aab21f3ea81fb22e7db5                     black female 424006 65.0 120 brown brown la new-orleans-pd
5 5 00004446e6ada776b8c766e34a9fc0e7     335b8bf0aaeb5af3c921ac9de35ce74e                     black male 78836 69.0 150 black brown   new-orleans-pd
6 6 00008cb7259587c20252e45b9f3694bc     2b4df78741cc7ebf1ecb0c6e88faf1b7                     black male 649833 69.0 185 grey/silver brown la new-orleans-pd
7 7 0000972df76bda334eb57b40bd6b4832     08284510b05453c254004b4613411a44                                     new-orleans-pd
8 8 0000a150be55a848744e31daa4c29824     37373c46672832ee7ec0b39f2673f7b7                     black male 286010 69.0 165 salt/pepper brown   new-orleans-pd
9 9 0000b12cee20b16b3f8e4dffdff191f6     569192100fad29fb87fe493f837d2005                     black female 481442 59.0 100 black brown la new-orleans-pd
10 10 0000d55720ea23cae77b42463ff71da6     45207b6a4bbea5eb55053422ea9a18f5                     black male 603659 66.0 163 brown brown la new-orleans-pd
11 11 00010c2c33988c5ad445ffd80987a6bf     a9d35eda661a7f9a43bf5678d59e2d36                     black female 380135 66.0 140 grey/silver brown la new-orleans-pd
12 12 00011b498c660c045ba5bfd9b82b430f     06f60ef3e26b6b177d44a91b110496f5                     black male 346049 73.0 180 black brown   new-orleans-pd
13 13 00016df7ae6b0f6417a856624fa2660b     aa08f2a599feff77354b8d9eb06f5dcb                     black male 58074 68.0 140 black brown   new-orleans-pd
14 14 0001991a61fe318a4d52caed88b1772a     1a320e04694fc0621ff251be1ee3ccf1                     black male 639657 66.0 100 black brown la new-orleans-pd
15 15 0001b4ac0fafaec617fb4be73c5b6415     d5dee913f3de8634b0c91eda608f2577                     black male 175528 69.0 125 black brown   new-orleans-pd
16 16 0001b86f576aebd15a055ab7a3c87511     40450bcab1ba8892f182c868e5df407b                     white male 438812 71.0 185 blonde blue la new-orleans-pd
17 17 0001b945dd4ced92c97b6abf9ceb834b     b4decb10347a824bc1b3da15e82af001                     black male 320637 68.0 182 brown brown la new-orleans-pd
18 18 0001e711e49fc9aa5d2cc8b32219221a     fb23017381f306c2223957ebef991281                     black female 41211 67.0 130 black brown   new-orleans-pd
19 19 00020c573578910de6c38bcaa259cf46     8670e36cd8350cf673d9b6124c82779b                     black male 445657 67.0 150 brown brown la new-orleans-pd
20 20 0002254c7ba9e1265ef5b4b7398c524e     69c6df649f263237c34b4077b1f4fb0a                     black female 476595 69.0 150 black brown   new-orleans-pd
21 21 000228839d5b6a008a0600887fcaa80b     c450b8925643e0ff212501d662ac419b                     white female 582975 65.0 140 blonde blue   new-orleans-pd
22 22 00022bc4bbce7c77471b03f8d287adc8     3f6013c9be920983247fac35ea71502b                     black female 539506 65.0 185 black brown la new-orleans-pd
23 23 00022f2019644f9fe4ec8518c5ea15e7     d892b893f0a7608c4c455d7233da9586                     black female 56664 66.0 125 brown brown la new-orleans-pd
24 24 0002849a851555a07891ca22527e4456     8ce9d4d99133ac17157ba9f0538af2e3                     black female 184095 68.0 160 black brown la new-orleans-pd
25 25 00028a35183bc3407d83c774c648658e     6f023c6c4730db5fc8a1f4c5c2bd6fe7                     black female 256661 67.0 120 black brown la new-orleans-pd
26 26 0002a25db88a9fdeb22f673c3f7d6bb3     91efe05cad414eb8a8e016ce8d165583                     white male 417303 72.0 185 brown brown   new-orleans-pd
27 27 0002a5114d5c0888eb57f4a6e29cdb08     d4d78f1eb623f7a9b776ab67dada5fbf                     black male 60857 78.0 275 black brown   new-orleans-pd
28 28 00030dd04ea7496654ff5eb31604a86b     3644415667d393bb42d2be15667baa7b                     black male 637410 70.0 160 black brown   new-orleans-pd
29 29 000312889cafc9b718339dae884a72c7     e2a4b11dec88cd562d103b78d16419c1                     black male 45620 74.0 65 black brown la new-orleans-pd
30 30 000318079a179c506423902100f354f8     dec99adad7aee83dbe35d9ffc648a34a                     black male 225820 73.0 254 black brown   new-orleans-pd
31 31 00033c497364e8eda89455b74621d00a     cd8355a3ce53ebcb26babf47f0d796ee                     black male 233116 70.0 145 black brown   new-orleans-pd
32 32 000354fcb9907c2ebaaa343bb7315d4b     8b38f663fcb44054ac03c1b2a1e3cea8                     black female 650207 64.0 220 black brown   new-orleans-pd
33 33 000357b9261151cbeff0288c845d4999     dc2e699993fad4794371e992ab64f33c                     black male 183293 67.0 170 black brown la new-orleans-pd
34 34 00036db08ba714cdd1d50dacee2777a7     dd37186f1b40fcd328c314b5a436fb75                     black male 584563 65.0 135 black brown la new-orleans-pd
35 35 00039144652fb740a9ee0e22d3806c29     4ca8555e5c031c905a2602fb18262386                     black female 308051 65.0 155 black brown tn new-orleans-pd
36 36 00039a48a92ce8c3cb2f9afe8ee35eee     b3243fe33f9f6b8df4d859d7b6e772fd                     black female 495470 66.0 120 black brown   new-orleans-pd
37 37 0003a145b6b7cc0aeff85e8fb8ff58dd     989a3958a446ad19b0427a598c27dd4d                     black female 203788 60.0 160 black brown la new-orleans-pd
38 38 0003b744a388b3fd6824e63ee63d235a     ba3d10b0cdf82857f2034ce00c632c80                     black male 165177 68.0 130 black brown la new-orleans-pd
39 39 00040e212276e61fb0c757444a839f89     c8cd044844198d514561885454515866                     white female 384586 61.0 140 brown brown or new-orleans-pd
40 40 00041002574366d7a46c53e76531ba69     927ae14ca260f114f392907fec5c2fb1                     black female 556851 62.0 120 black brown la new-orleans-pd
41 41 000449b91f357aa97551b5f14955f3b5     aa0daad269932a8b0578a103c80367d7                     black male 375236 67.0 170 black brown la new-orleans-pd
42 42 00044be0044d056e5645c082ca245763     0201fcb7f0923f0053f09ec8666b88fe                     white male 279504 70.0 250 brown brown   new-orleans-pd
43 43 0004829c04aa46531dbb469eaab84a32     4ada291d8373b5d43aaa5a01a84d87d1                     black male 114863 76.0 220 black brown   new-orleans-pd
44 44 000482f792b727652c85ee13b7bfc159     1728666456d645d6a7f09a1f70126b22                     white male 561407 68.0 185 brown brown la new-orleans-pd
45 45 00049baf007bda70115460f699e9631b     8c9c38681c17c575f01d1152475b450f                     black female 398083 63.0 130 black brown   new-orleans-pd
46 46 00049d786b8a3472a4039a7bd78eb7a6     c76af2a0222650194009bb35dd20288c                     black male 247423 69.0 175 black brown   new-orleans-pd
47 47 0004b9695e794c1a870b452023b3e8fb     fc6d40eab6a415fb837b0ec4c44f2bf1                     black male 318766 68.0 170 black brown   new-orleans-pd
48 48 0004baf1bf4a7d3c87d64bbe3af4cba6     022d1f1a76b9d8ed472ac9ccf91802d1                     white male 503976 67.0 175 red blue la new-orleans-pd
49 49 0004bc0f50b5c6edb92c614df5b18e79     3332dc69404656a4cbd2d294e2686aa2                     black male 195681 70.0 160 black brown la new-orleans-pd
50 50 0004c8a7a7ff07f253968b462a99f869     39df83aa94277680b407d88ab8d3ab06                     black female 358483 68.0 120 brown brown la new-orleans-pd
51 51 0004f5328c2658f3997ac93fcb225360     b77b788fe7e2aa673b593a07ed626261                     black male 177183 71.0 175 black brown la new-orleans-pd
52 52 00050e2a2392df02b2ddd1553050f66c     eea4cbd9285cddce666ca28ec5f72cdc                     black male 210727 72.0 205 black brown   new-orleans-pd
53 53 00052598655bdd52a150a5fa42145cac     f687c521e03bfd75dc943745dfb9f35e                     black male 368465 64.0 165 black brown la new-orleans-pd
54 54 0005363fd2d6bcbccccaa239e820f7b9     b4a76a10b3a235c8b55258d8dfb320a0                     white male 559076 70.0 160 brown brown il new-orleans-pd
55 55 000552a0dde21e9d9209ba328b62693e     f214ac45700f901932a69d0a10fd6796                     white male 367340 65.0 156 brown blue   new-orleans-pd
56 56 00055f3f852aac1a2c555488df1145a6     41f25bf992f30add07d6e5f70171097e                     black male 163917 64.0 140 black brown la new-orleans-pd
57 57 0005668136769e31190c9ed6fedb2a1b     99b6026ece8260ab56403b02aa2f095c                     hispanic male 263438 66.0 150 black brown nv new-orleans-pd
58 58 000568d342428518432e4397df736dc9     455c3520773223b2a1bfb0fbb6bd645f                     black female 184123 66.0 180 black brown la new-orleans-pd
59 59 00056a18ff3b3fef4b970dac00482c1c     c48c8648303b2ce61a94cd3b2e329657                     hispanic male 588377 65.0 150 black brown   new-orleans-pd
60 60 0005a457f13e87ec4d234f239c2dec47     a98ec63fa5551fb8e302b65183174961                     black male 90564 73.0 185 black brown la new-orleans-pd
61 61 0005b8eb9c27612b5ded13567e446815     8dbcb85f9df24b97bf8f05f64907934e                     black female 300799 71.0 155 black brown la new-orleans-pd
62 62 0005bcc84a53490217576f2c8990bdc4     38500c4dc16e6cdd71ebad444bdd8dda                     white female 379254 63.0 150 blonde brown la new-orleans-pd
63 63 0005cee8fe7950b6cbe92c225744cbc9     d9c5d98de5d3b22827ad34893ac81a00                     white male 595448 68.0 140 brown brown la new-orleans-pd
64 64 00060b893603d909a76fb9135f4827bc     5dddeb05089cd81fc348f563b11e9709                     black male 143620 72.0 190 black brown la new-orleans-pd
65 65 000614f4f18fe8825982fbc9543832cf     330e328796e91a4603fa602837984555                     black female 296082     brown brown   new-orleans-pd
66 66 0006168e431b6b783a73cc92f2878d15     4c91e199c5e6426856ba97dee1fe2576                     black male 515034 69.0 245 black brown   new-orleans-pd
67 67 000649ffa3db9ddabcd7d8eb027a32ee     2350798c9c02412bdf190bdf6e9bc57f                     white male 493767 69.0 150 brown brown la new-orleans-pd
68 68 00065cdedcce7c0be130e84dc32d4a37     7c972a4478e1cc7214d535e13218f51c                     black male 351923 68.0 140 black brown   new-orleans-pd
69 69 00067f5233c5257fd84a78f90e6d723c 4a0f8c08b4e2a4074dfdaf8a9426d7b5     rank                                   new-orleans-pd
70 70 0006c172be254080cffb73d3cad2076f     83659923586e268ca06b83a076069cca                     black male 540271 69.0 160 black brown al new-orleans-pd
71 71 0006d00b9131cc06f5246324ccc5cc81     44c371c72aea9c7f321f6a5e67ac605d                     hispanic female 299574 63.0 135 black brown   new-orleans-pd
72 72 0006d19cfd7567d957d4d4622388a1df     482c593bf46c8de7629fddab46a65dbf                     white male 272076 71.0 170 brown green la new-orleans-pd
73 73 0006f3a27fbb1faf607040a277de265d     f78c108bb6e51a44396b2a80a8cf4970                     black male 136051 68.0 135 brown brown la new-orleans-pd
74 74 0006fd052b70a98a69462cb5de9ce906     b4561798d27b101271761243d6779111                     white male 364496 68.0 160 blonde blue la new-orleans-pd
75 75 0007088b4fb47d686fe98980d6aa42a4     5b369a5860a6b240215c842792fba8b9                     black male 567927 70.0 205   brown la new-orleans-pd
76 76 0007122b7ab179f17a5b49f664e53e5c     04ffc65fc270142ce401fe1bef916e0a                     black male 333378 75.0 200 grey/silver brown   new-orleans-pd
77 77 0007227cf5d138b3d3ac8efa72c1bac8     5743037edae16d8bae6cb288eba13e0f                     black female 632760 65.0 130 black brown la new-orleans-pd
78 78 000729dfd1eade8565e2a460ef49ef2e     5200435d854d843d19a780928c4e6fbe                     black male 332237 71.0 190 black brown la new-orleans-pd
79 79 00072f54b1bd4b3db604bfcb76bf005e     eb8f322e0b54f3cf59aa12cd1d2e6faf                     white male 379673 68.0 130 brown brown   new-orleans-pd
80 80 00073695d5e073067758b54a3b814f19     693a9c7c1c2db6d356f92d89017db9aa                     black male 530153 65.0   black brown la new-orleans-pd
81 81 000752002475915ea826b4a892831385     0a0a0d1a389b51bbcfb92b0bad813de2                     black male 514748 73.0   black brown la new-orleans-pd
82 82 000759529aa13741e12dbfa1a096452d     86d1855e4eac8689654fbe3fd29b5612                     black male 390943 67.0 180 black brown   new-orleans-pd
83 83 00075b9ceda286df0c37bfee50200bd9     7cf0213c640f77cbee2922e79dd34d6b                     white male 84166 71.0 170 black blue la new-orleans-pd
84 84 00076a534fc3a361cbd2fe14186f2525     c4b4bc64257e0d834be5844f4955d970                     black male 178593 69.0 140 black brown   new-orleans-pd
85 85 00079486ad01887b2104e1ba750091b9     9836483f64232380a7d6123cdc1e6864                     white female 556629 68.0 140 brown brown   new-orleans-pd
86 86 0007cbc6deac49f799d597e0469994a1     efffa4fde1d5475da5b070409af5415a                     white female 472887 67.0 140 brown brown la new-orleans-pd
87 87 0007d2f34bf0f65699f3acbf7260efd0     de001efe9de095e5bb17065892ad4725                     black male 218809 66.0 165 black brown la new-orleans-pd
88 88 0007d820fed79f4f4c2a1e9cda554479     438ece357f586db159cec4c38df30719                     black female 37682 65.0 150 black brown la new-orleans-pd
89 89 0007dce60a201630207183a053b04ef9     ee96a44a543002ca201cd9576a7cdb22                     white female 241633 64.0 125 blonde blue la new-orleans-pd
90 90 0007f33aa382694ca00a5c038e95d8e5     1d0bfe878e572dee3bf57aa5b85faeb6                     black male 205928 74.0 327 black brown   new-orleans-pd
91 91 00081e3c88ecdaf7dd399077ba38d3d3     cf59205c1ced9def9f8d36dc2dbf9fe6                     black female 430564 59.0 130 black brown la new-orleans-pd
92 92 0008237bcb7086791f5ac262add635a3     bc32e2a7948dc158a9964b43861905da                     black male 34139 67.0 160 black brown   new-orleans-pd
93 93 00083d7df144a4f14d9868acdf51e8f2     31850554136490aedf5ed852c4440730                     black female 376299 66.0 200 black brown   new-orleans-pd
94 94 000842559fa5e5d8df859e604fdb0877     a863c6b7e3fa707e845e3b7f463e26d9                     white male 195147 66.0 170 brown brown   new-orleans-pd
95 95 000845e667c0e4e1ed73282d217454b2     56b9f79a9609368b9945bc76020fe5ed                     black female 615724           new-orleans-pd
96 96 00084a0143463691671fea2a29030aaf     f544e90d945d31c193046d8f3a3b2531                     black male 626408 67.0 160   brown   new-orleans-pd
97 97 00086313c456d8f7172eb79e30dff67b     8d2bd77f6a8ab7f805aa80faafa836fe                     white male 242673 73.0 175 brown brown ny new-orleans-pd
98 98 00086643d658b12979b14196b6556ce8     4f3b7e5958f0510a41e174048ed7f5bb                     black male 86924 68.0 160 black brown   new-orleans-pd
99 99 00087b540b9daa31f999ebc482c4f498     4f250f334e94ef97c2a8bdb769a1a166                     black female 610728 63.0 130 grey/silver brown   new-orleans-pd
100 100 0008809ae40342b89e420ae89423fa83     7b2137c7789f8b053e4dfbc5a451d2d4                     black male 230551 69.0 135 black brown la new-orleans-pd

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "citizens" (
"citizen_uid" TEXT,
  "allegation_uid" TEXT,
  "uof_uid" TEXT,
  "stop_and_search_uid" TEXT,
  "complainant_type" TEXT,
  "complainant_sex" TEXT,
  "complainant_race" TEXT,
  "citizen_influencing_factors" TEXT,
  "citizen_distance_from_officer" TEXT,
  "citizen_arrested" TEXT,
  "citizen_arrest_charges" TEXT,
  "citizen_hospitalized" TEXT,
  "citizen_injured" TEXT,
  "citizen_age" INTEGER,
  "citizen_race" TEXT,
  "citizen_sex" TEXT,
  "citizen_id" INTEGER,
  "citizen_height" TEXT,
  "citizen_weight" INTEGER,
  "citizen_hair_color" TEXT,
  "citizen_eye_color" TEXT,
  "citizen_driver_license_state" TEXT,
  "agency" TEXT
);