Alright, time for a 2022 comparison. Most of the numbers come from
https://www.ahdatalytics.com/dashboa...er-comparison/ except for Jackson for which I used a local news source. I omitted places where I know that the jurisdiction of the police department doesn't match city boundaries (e.g. Miami, Las Vegas). I used 2020 census populations for all cities since the estimates are probably bullshit for '21 and '22. If the data was not from Dec 31 (only a few cases), I annualized it . Quoted errors assume Poisson statistics on the counts and moreover that the Poisson is approximately a Gaussian (in other words, I just used the square root of the count).
Code:
---------------------------------------------------------------
NORTHEAST
---------------------------------------------------------------
Baltimore 55.32 +/- 3.07 (2021: 57.54 +/- 3.13)
Boston 6.07 +/- 0.95 (2021: 5.92 +/- 0.94)
Buffalo 24.43 +/- 2.96 (2021: 24.07 +/- 2.94)
New York 4.94 +/- 0.24 (2021: 5.54 +/- 0.25)
Newark 16.05 +/- 2.27 (2021: 19.26 +/- 2.49)
Philadelphia 31.43 +/- 1.40 (2021: 34.67 +/- 1.47)
Pittsburgh 23.43 +/- 2.78 (2021: 17.49 +/- 2.40)
Providence 4.79 +/- 1.57 (2021: 12.05 +/- 2.51)
Rochester 35.96 +/- 4.13 (2021: 39.75 +/- 4.34)
Syracuse 12.11 +/- 2.85 (2021: 19.51 +/- 3.62)
Washington 29.44 +/- 2.07 (2021: 32.78 +/- 2.18)
---------------------------------------------------------------
MIDWEST
---------------------------------------------------------------
Akron 22.95 +/- 3.32 (2021: 21.53 +/- 3.36)
Chicago 25.31 +/- 0.96 (2021: 29.27 +/- 1.03)
Cincinnati 26.67 +/- 2.89 (2021: 30.07 +/- 3.12)
Cleveland 41.33 +/- 3.33 (2021: 45.62 +/- 3.50)
Columbus 15.46 +/- 1.31 (2021: 22.52 +/- 1.58)
Detroit 48.17 +/- 2.74 (2021: 48.04 +/- 2.74)
Fort Wayne 7.58 +/- 1.69 (2021: 15.16 +/- 2.40)
Indianapolis 25.46 +/- 1.69 (2021: 30.53 +/- 1.85)
Kansas City 33.26 +/- 2.56 (2021: 30.90 +/- 2.47)
Lincoln 3.78 +/- 1.14 (2021: 2.75 +/- 0.97)
Madison 2.48 +/- 0.83 (2021: 2.96 +/- 1.05)
Milwaukee 37.07 +/- 2.53 (2021: 33.44 +/- 2.41)
Minneapolis 19.30 +/- 2.12 (2021: 22.10 +/- 2.27)
Omaha 5.97 +/- 1.11 (2021: 6.58 +/- 1.16)
St Louis 65.65 +/- 4.67 (2021: 66.32 +/- 4.69)
Toledo 23.69 +/- 2.95 (2021: 26.21 +/- 3.11)
Wichita 7.55 +/- 1.38 (2021: 11.82 +/- 1.72)
---------------------------------------------------------------
SOUTH
---------------------------------------------------------------
Atlanta 34.09 +/- 2.61 (2021: 31.88 +/- 2.53)
Austin 7.07 +/- 0.86 (2021: 8.32 +/- 0.93)
Birmingham 67.50 +/- 5.77 (2021: 58.29 +/- 5.39)
Charleston 5.99 +/- 2.00 (2021: 10.65 +/- 2.66)
Charlotte 12.58 +/- 1.20 (2021: 11.09 +/- 1.13)
Dallas 16.41 +/- 1.12 (2021: 17.02 +/- 1.14)
Durham 16.23 +/- 2.39 (2021: 17.28 +/- 2.47)
Fort Worth 10.99 +/- 1.09 (2021: 12.84 +/- 1.18)
Greensboro 13.71 +/- 2.14 (2021: 17.72 +/- 2.43)
Houston 17.83 +/- 0.88 (2021: 18.83 +/- 0.90)
Jacksonville 13.27 +/- 1.18 (2021: 11.79 +/- 1.11)
Lexington 13.64 +/- 2.06 (2021: 11.47 +/- 1.89)
Little Rock 39.98 +/- 4.44 (2021: 32.08 +/- 3.98)
Louisville 41.36 +/- 3.27 (2021: 44.97 +/- 3.41)
Memphis 45.49 +/- 2.68 (2021: 51.18 +/- 2.84)
Nashville 15.37 +/- 1.49 (2021: 14.65 +/- 1.46)
New Orleans 69.01 +/- 4.24 (2021: 56.77 +/- 3.85)
Oklahoma City 10.43 +/- 1.24 (2021: 12.04 +/- 1.33)
Orlando 13.01 +/- 2.06 (2021: 10.08 +/- 1.81)
Raleigh 9.19 +/- 1.40 (2021: 7.06 +/- 1.23)
Richmond 25.15 +/- 3.33 (2021: 39.72 +/- 4.19)
Savannah 21.65 +/- 3.83 (2021: 23.01 +/- 3.95)
Shreveport 25.05 +/- 3.65 (2021: 44.24 +/- 4.86)
Tampa 12.47 +/- 1.80 (2021: 11.17 +/- 1.70)
Tulsa 18.16 +/- 2.10 (2021: 17.19 +/- 2.04)
Virginia Beach 5.01 +/- 1.04 (2021: 3.26 +/- 0.84)
Winston-Salem 13.14 +/- 2.19 (2021: 12.82 +/- 2.27)
---------------------------------------------------------------
WEST
---------------------------------------------------------------
Albuquerque 21.26 +/- 1.94 (2021: 19.48 +/- 1.86)
Aurora 13.16 +/- 1.83 (2021: 10.87 +/- 1.68)
Colorado Springs 9.60 +/- 1.42 (2021: 6.26 +/- 1.14)
Denver 12.30 +/- 1.31 (2021: 13.42 +/- 1.37)
El Paso 4.12 +/- 0.78 (2021: 5.75 +/- 0.92)
Fresno 11.07 +/- 1.43 (2021: 13.65 +/- 1.59)
Honolulu 6.84 +/- 1.40 (2021: 5.13 +/- 1.21)
Long Beach 7.71 +/- 1.29 (2021: 8.36 +/- 1.34)
Los Angeles 9.80 +/- 0.50 (2021: 10.31 +/- 0.51)
Oakland 27.23 +/- 2.49 (2021: 30.41 +/- 2.63)
Phoenix 13.87 +/- 0.93 (2021: 12.31 +/- 0.88)
Portland 14.87 +/- 1.51 (2021: 13.49 +/- 1.44)
Sacramento 10.29 +/- 1.40 (2021: 11.05 +/- 1.45)
Salt Lake City 7.51 +/- 1.94 (2021: 9.01 +/- 2.12)
San Antonio 16.10 +/- 1.06 (2021: 11.22 +/- 0.88)
San Diego 3.68 +/- 0.51 (2021: 4.11 +/- 0.54)
San Francisco 6.41 +/- 0.86 (2021: 6.41 +/- 0.86)
San Jose 3.45 +/- 0.58 (2021: 3.06 +/- 0.55)
Seattle 7.06 +/- 0.98 (2021: 5.70 +/- 0.88)
Spokane 6.99 +/- 1.75 (2021: 6.55 +/- 1.69)
Stockton 15.33 +/- 2.09 (2021: 11.22 +/- 1.87)
Tucson 11.61 +/- 1.46 (2021: 15.30 +/- 1.68)
Impressive decreases in places like Columbus, Providence, Fort Wayne, Richmond, and Charleston. Largest increase is... San Antonio? But I suppose this is probably due to 53 migrants found dead in a truck, which totally violates my Poisson error model. Pittsburgh also jumps out at me.