police-locals/police-locals

75 rows

View and edit SQL

Suggested facets: asian

Link rowid city police_force_size all white non-white black hispanic asian
1 New York 32300 0.617956656 0.446386555 0.7644189379999999 0.770891365 0.762860728 0.749235474
2 Chicago 12120 0.875 0.871962617 0.877400295 0.89740566 0.83982684 0.966666667
3 Los Angeles 10100 0.228217822 0.152777778 0.263848397 0.387387387 0.217679558 0.305263158
4 Washington 9340 0.115631692 0.05677419400000001 0.15736505 0.170189099 0.08988764 0.230769231
5 Houston 7700 0.29220779199999997 0.17373461 0.399258344 0.36637931 0.457142857 0.408163265
6 Philadelphia 6045 0.8354011579999999 0.7768987340000001 0.8994800690000001 0.924657534 0.817391304 **
7 Phoenix 4475 0.311731844 0.270801815 0.42735042700000003 0.52173913 0.427710843 **
8 San Diego 4460 0.362107623 0.372983871 0.34848484799999996 0.538461538 0.297794118 0.515625
9 Dallas 3605 0.191400832 0.171503958 0.21345029199999999 0.214634146 0.256880734 **
10 Detroit 3265 0.37059724299999997 0.081967213 0.542787286 0.568 0.333333333 **
11 San Francisco 3020 0.316225166 0.25949367100000004 0.378472222 0.186046512 0.253333333 0.486111111
12 San Antonio 2955 0.6243654820000001 0.44387755100000004 0.7139240509999999 0.574468085 0.739130435 **
13 Atlanta 2950 0.137288136 0.18627451 0.111398964 0.101983003 ** **
14 Las Vegas 2830 0.374558304 0.4 0.307692308 0.387755102 0.267857143 **
15 Baltimore 2800 0.257142857 0.1328125 0.361842105 0.391459075 ** **
16 Boston 2560 0.4765625 0.44155844200000005 0.582677165 0.686567164 0.75 **
17 Jacksonville, Fla. 2335 0.809421842 0.7137809190000001 0.956521739 1 0.888888889 1
18 El Paso, Texas 2260 0.8517699120000001 0.826446281 0.86102719 ** 0.86102719 **
19 Columbus, Ohio 2245 0.405345212 0.379781421 0.518072289 0.571428571 ** **
20 Cleveland 2045 0.557457213 0.498127341 0.669014085 0.595959596 0.941176471 **
21 Tucson, Ariz. 2020 0.398514851 0.41666666700000005 0.375 ** 0.333333333 **
22 Newark, N.J. 2005 0.279301746 0.207964602 0.37142857100000004 0.519480519 0.260416667 **
23 Austin, Texas 1985 0.294710327 0.194690265 0.426900585 0.25 0.453846154 **
24 Memphis, Tenn. 1970 0.464467005 0.339130435 0.640243902 0.668874172 ** **
25 Milwaukee 1960 0.7219387759999999 0.692883895 0.784 0.931034483 0.733333333 **
26 San Jose, Calif. 1875 0.46666666700000003 0.47234042600000004 0.457142857 ** 0.406976744 0.44
27 Miami 1860 0.072580645 0.030612245 0.087591241 0 0.116751269 **
28 Denver 1820 0.28296703300000003 0.14932126699999998 0.48951049 0.580645161 0.391752577 **
29 Sacramento, Calif. 1820 0.07967033 0.063380282 0.1375 0.32 0 **
30 Charlotte, N.C. 1780 0.362359551 0.294545455 0.592592593 0.833333333 0.321428571 **
31 Tampa, Fla. 1715 0.177842566 0.131914894 0.27777777800000003 0.276595745 0.326923077 **
32 Indianapolis 1620 0.648148148 0.71042471 0.4 0.383333333 ** **
33 Santa Ana, Calif. 1590 0.09433962300000001 0.058823529000000006 0.12087912099999999 ** 0.148648649 0
34 New Orleans 1560 0.5 0.324074074 0.593137255 0.62371134 ** **
35 Oakland, Calif. 1530 0.09477124199999999 0.026666667 0.16025641 0.0625 0.108108108 0.28125
36 Orlando, Fla. 1530 0.117647059 0.09 0.16981132100000002 ** 0.111111111 **
37 Oklahoma City, Okla. 1500 0.596666667 0.5473251029999999 0.807017544 0.62962963 ** **
38 Seattle 1445 0.117647059 0.115577889 0.12222222199999999 0.1875 0 **
39 Kansas City, Mo. 1440 0.7777777779999999 0.768 0.842105263 1 ** **
40 Nashville, Tenn. 1440 0.6180555560000001 0.43715847 0.933333333 0.947368421 ** **
41 Laredo, Texas 1435 0.93728223 0.962962963 0.9313304720000001 ** 0.931330472 **
42 Fort Worth, Texas 1430 0.426573427 0.306748466 0.585365854 0.637931034 0.559322034 **
43 Louisville, Ky. 1430 0.6468531470000001 0.620833333 0.7826086959999999 0.772727273 ** **
44 Norfolk, Va. 1425 0.21754386 0.267080745 0.153225806 0.106796117 ** **
45 Arlington, Va. 1360 0.202205882 0.222222222 0.1796875 0.16 ** **
46 Pittsburgh 1350 0.6592592589999999 0.67965368 0.538461538 0.533333333 ** **
47 Albuquerque, N.M. 1340 0.615671642 0.62962963 0.601503759 ** 0.566371681 **
48 Jersey City, N.J. 1170 0.252136752 0.206451613 0.34177215200000005 0.303030303 0.325581395 **
49 Raleigh, N.C. 1150 0.26956521699999997 0.206349206 0.56097561 ** ** **
50 Rochester, N.Y. 1150 0.1 0.040935673 0.271186441 0.195121951 ** **
51 Cincinnati 1145 0.227074236 0.14772727300000002 0.490566038 0.648648649 ** **
52 Long Beach, Calif. 1115 0.29147982100000003 0.277227723 0.303278689 ** 0.3125 0
53 Birmingham, Ala. 1110 0.225225225 0.086021505 0.325581395 0.328125 ** **
54 Wichita, Kan. 1075 0.6 0.511764706 0.933333333 ** 0.896551724 **
55 Virginia Beach, Va. 1070 0.7897196259999999 0.75625 0.8888888890000001 0.727272727 1 **
56 Fresno, Calif. 1040 0.514423077 0.509615385 0.519230769 0.681818182 0.46031746 **
57 Buffalo, N.Y. 1010 0.33663366299999997 0.29239766100000003 0.580645161 ** 0.523809524 **
58 Minneapolis 1000 0.1 0.052631579000000005 0.379310345 ** ** **
59 Portland, Ore. 1000 0.21 0.186440678 0.39130434799999997 ** ** **
60 Reno, Nev. 1000 0.34 0.323863636 0.45833333299999995 ** ** **
61 Richmond, Va. 1000 0.11 0.101694915 0.12195122 0.208333333 ** **
62 Baton Rouge, La. 980 0.214285714 0.144067797 0.320512821 0.342465753 ** **
63 Jackson, Miss. 960 0.390625 0.08219178099999999 0.579831933 0.579831933 ** **
64 Riverside, Calif. 955 0.219895288 0.35 0.076923077 0 0.142857143 **
65 Fort Lauderdale, Fla. 950 0.16842105300000001 0.220183486 0.09876543199999999 0.102564103 0.114285714 **
66 St. Louis 950 0.589473684 0.538461538 0.671232877 0.682539683 ** **
67 Brownsville, Texas 925 0.513513514 0.5 0.514124294 ** 0.520231214 **
68 Albany, N.Y. 890 0.185393258 0.16025641 0.363636364 ** ** **
69 Colorado Springs, Colo. 860 0.604651163 0.553030303 0.775 ** 0.913043478 **
70 Savannah, Ga. 860 0.215116279 0.076923077 0.299065421 0.170731707 0.75 **
71 Winston-Salem, N.C. 860 0.575581395 0.424778761 0.86440678 0.869565217 ** **
72 Toledo, Ohio 805 0.565217391 0.5307692310000001 0.709677419 0.75 ** **
73 Madison, Wis. 790 0.278481013 0.24647887300000001 0.5625 ** ** **
74 Corpus Christi, Texas 770 0.857142857 0.893333333 0.82278481 ** 0.847222222 **
75 San Bernardino, Calif. 755 0.271523179 0.263157895 0.28 ** 0.274509804 **

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "police-locals/police-locals" (
"city" TEXT,
  "police_force_size" INTEGER,
  "all" REAL,
  "white" REAL,
  "non-white" REAL,
  "black" TEXT,
  "hispanic" TEXT,
  "asian" TEXT
);
Powered by Datasette · Query took 17.367ms