Total Datset - cities, 2021.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	City	Population	# of aggravated assaults, by weapon used								% of aggravated assaults by weapons used				Homicides, by weapon used							Kill percentage, by weapon used				Assault type, per 100,000 residents					City-wide rates
2	City	Population	Total	Gun	Knife	Blunt	Hands	Other	N/A	N/A %	Gun	Knife	Blunt	Hands	Total	Gun	Knife	Blunt	Hands	Other	N/A	Gun	Knife	Blunt	Hands	Shooting	Knifing	Clubbing	Beating	All-Weapon	Ag. Assault	Homicide

3	Akron, OH	190,469	1,249	445	219	209	172	31	173	13.9%	41.4%	20.4%	19.4%	16.0%	36	29	1	0	0	1	5	6.1%	0.5%	0.0%	0.0%	233.6	115.0	109.7	90.3	565.4	655.7	18.9
4	Albuquerque, NM	564,559	5,581	1,716	771	894	661	453	1,086	19.5%	38.2%	17.2%	19.9%	14.7%	120	83	11	2	5	1	18	4.6%	1.4%	0.2%	0.8%	304.0	136.6	158.4	117.1	871.5	988.6	21.3
5	Alexandria, VA	159,467	233	62	29	8	36	53	45	19.3%	33.0%	15.4%	4.3%	19.1%	2	0	1	0	1	0	0	0.0%	3.3%	0.0%	2.7%	38.9	18.2	5.0	22.6	123.5	146.1	1.3
6	Austin, TX	986,190	3,379	1,135	676	121	814	110	523	15.5%	39.7%	23.7%	4.2%	28.5%	79	67	4	0	4	2	2	5.6%	0.6%	0.0%	0.5%	115.1	68.5	12.3	82.5	260.1	342.6	8.0
7	Baton Rouge, LA	227,470	2,165	933	161	144	329	211	387	17.9%	52.5%	9.1%	8.1%	18.5%	88	76	5	1	0	4	2	7.5%	3.0%	0.7%	0.0%	410.2	70.8	63.3	144.6	807.1	951.8	38.7
8	Beaumont, TX	115,282	886	375	169	151	147	22	22	2.5%	43.4%	19.6%	17.5%	17.0%	17	12	1	0	2	0	2	3.1%	0.6%	0.0%	1.3%	325.3	146.6	131.0	127.5	641.0	768.6	14.7
9	Bellevue, WA	151,854	91	15	14	13	27	8	14	15.4%	19.5%	18.2%	16.9%	35.1%	2	2	0	0	0	0	0	11.8%	0.0%	0.0%	0.0%	9.9	9.2	8.6	17.8	42.1	59.9	1.3
10	Boston, MA	675,647	2,888	397	733	309	327	674	448	15.5%	16.3%	30.0%	12.7%	13.4%	36	21	11	0	0	0	4	5.0%	1.5%	0.0%	0.0%	58.8	108.5	45.7	48.4	379.0	427.4	5.3
11	Bridgeport, CN	148,654	306	101	81	50	32	17	25	8.2%	35.9%	28.8%	17.8%	11.4%	20	15	3	0	0	0	2	12.9%	3.6%	0.0%	0.0%	67.9	54.5	33.6	21.5	184.3	205.8	13.5
12	Brockton, MA	105,643	518	74	114	82	93	87	68	13.1%	16.4%	25.3%	18.2%	20.7%	8	6	2	0	0	0	0	7.5%	1.7%	0.0%	0.0%	70.0	107.9	77.6	88.0	402.3	490.3	7.6
13	Buffalo, NY	281,757	1,616	580	484	159	273	85	35	2.2%	36.7%	30.6%	10.1%	17.3%	65	54	3	2	3	0	3	8.5%	0.6%	1.2%	1.1%	205.9	171.8	56.4	96.9	476.7	573.5	23.1
14	Cambridge, MA	118,403	294	28	57	47	63	60	39	13.3%	11.0%	22.4%	18.4%	24.7%	1	1	0	0	0	0	0	3.4%	0.0%	0.0%	0.0%	23.6	48.1	39.7	53.2	195.1	248.3	0.8
15	Carrollton, TX	133,434	144	40	30	18	30	14	12	8.3%	30.3%	22.7%	13.6%	22.7%	4	1	0	0	1	0	2	2.4%	0.0%	0.0%	3.2%	30.0	22.5	13.5	22.5	85.4	107.9	3.0
16	Cedar Rapids, IA	137,710	383	93	96	51	93	24	26	6.8%	26.1%	26.9%	14.3%	26.1%	10	4	3	1	0	0	2	4.1%	3.0%	1.9%	0.0%	67.5	69.7	37.0	67.5	210.6	278.1	7.3
17	Cincinnati, OH	311,791	1,600	866	212	71	93	46	312	19.5%	67.2%	16.5%	5.5%	7.2%	90	73	1	1	2	1	12	7.8%	0.5%	1.4%	2.1%	277.8	68.0	22.8	29.8	483.3	513.2	28.9
18	College Station, TX	120,511	130	48	27	7	23	3	22	16.9%	44.4%	25.0%	6.5%	21.3%	3	3	0	0	0	0	0	5.9%	0.0%	0.0%	0.0%	39.8	22.4	5.8	19.1	88.8	107.9	2.5
19	Columbia, SC	136,632	695	337	74	28	99	24	133	19.1%	60.0%	13.2%	5.0%	17.6%	23	16	3	1	0	0	3	4.5%	3.9%	3.4%	0.0%	246.6	54.2	20.5	72.5	436.2	508.7	16.8
20	Des Moines, IA	214,133	1,067	129	133	84	513	62	146	13.7%	14.0%	14.4%	9.1%	55.7%	2	2	0	0	0	0	0	1.5%	0.0%	0.0%	0.0%	60.2	62.1	39.2	239.6	258.7	498.3	0.9
21	Elizabeth, NJ	137,298	323	48	81	6	95	47	46	14.2%	17.3%	29.2%	2.2%	34.3%	10	6	3	0	0	0	1	11.1%	3.6%	0.0%	0.0%	35.0	59.0	4.4	69.2	166.1	235.3	7.3
22	Eugene, OR	176,654	434	33	61	60	214	41	25	5.8%	8.1%	14.9%	14.7%	52.3%	3	0	0	1	0	1	1	0.0%	0.0%	1.6%	0.0%	18.7	34.5	34.0	121.1	124.5	245.7	1.7
23	Evansville, IN	117,298	685	137	63	76	230	50	129	18.8%	24.6%	11.3%	13.7%	41.4%	19	13	1	0	3	0	2	8.7%	1.6%	0.0%	1.3%	116.8	53.7	64.8	196.1	387.9	584.0	16.2
24	Fargo, ND	125,990	430	19	45	34	282	50	0	0.0%	4.4%	10.5%	7.9%	65.6%	6	3	1	0	1	0	1	13.6%	2.2%	0.0%	0.4%	15.1	35.7	27.0	223.8	117.5	341.3	4.8
25	Fort Collins, CO	168,972	373	31	72	89	129	16	36	9.7%	9.2%	21.4%	26.4%	38.3%	3	1	1	0	0	0	1	3.1%	1.4%	0.0%	0.0%	18.3	42.6	52.7	76.3	144.4	220.7	1.8
26	Fort Wayne, IN	263,886	376	165	59	26	55	24	47	12.5%	50.2%	17.9%	7.9%	16.7%	41	28	3	2	2	0	6	14.5%	4.8%	7.1%	3.5%	62.5	22.4	9.9	20.8	121.6	142.5	15.5
27	Frisco, TX	200,509	136	59	21	8	15	9	24	17.6%	52.7%	18.8%	7.1%	13.4%	4	4	0	0	0	0	0	6.3%	0.0%	0.0%	0.0%	29.4	10.5	4.0	7.5	60.3	67.8	2.0
28	Garland, TX	246,018	316	131	92	28	9	20	36	11.4%	46.8%	32.9%	10.0%	3.2%	21	15	1	0	2	0	3	10.3%	1.1%	0.0%	18.2%	53.2	37.4	11.4	3.7	124.8	128.4	8.5
29	Grand Prairie, TX	196,100	300	117	63	10	49	5	56	18.7%	48.0%	25.8%	4.1%	20.1%	8	5	0	0	0	0	3	4.1%	0.0%	0.0%	0.0%	59.7	32.1	5.1	25.0	128.0	153.0	4.1
30	Green Bay, WI	107,395	374	58	49	28	169	24	46	12.3%	17.7%	14.9%	8.5%	51.5%	3	1	2	0	0	0	0	1.7%	3.9%	0.0%	0.0%	54.0	45.6	26.1	157.4	190.9	348.2	2.8
31	Gresham, OR	114,247	334	81	57	24	87	21	64	19.2%	30.0%	21.1%	8.9%	32.2%	14	9	1	1	2	0	1	10.0%	1.7%	4.0%	2.2%	70.9	49.9	21.0	76.2	216.2	292.3	12.3
32	Hampton, VA	137,148	218	112	23	13	45	7	18	8.3%	56.0%	11.5%	6.5%	22.5%	27	23	1	0	0	0	3	17.0%	4.2%	0.0%	0.0%	81.7	16.8	9.5	32.8	126.1	159.0	19.7
33	Hartford, CN	121,054	406	116	88	41	34	55	72	17.7%	34.7%	26.3%	12.3%	10.2%	34	29	4	0	1	0	0	20.0%	4.3%	0.0%	2.9%	95.8	72.7	33.9	28.1	307.3	335.4	28.1
34	Henderson, NV	317,610	531	117	95	47	175	30	67	12.6%	25.2%	20.5%	10.1%	37.7%	14	8	1	0	3	0	2	6.4%	1.0%	0.0%	1.7%	36.8	29.9	14.8	55.1	112.1	167.2	4.4
35	Hillsboro, OR	106,447	173	18	41	29	46	21	18	10.4%	11.6%	26.5%	18.7%	29.7%	6	3	2	0	1	0	0	14.3%	4.7%	0.0%	2.1%	16.9	38.5	27.2	43.2	119.3	162.5	5.6
36	Honolulu, HI	350,964	1,271	180	309	254	409	119	0	0.0%	14.2%	24.3%	20.0%	32.2%	6	1	2	0	1	0	2	0.6%	0.6%	0.0%	0.2%	51.3	88.0	72.4	116.5	245.6	362.1	1.7
37	Indianapolis, IN	887,642	3,942	1,795	474	324	494	93	762	19.3%	56.4%	14.9%	10.2%	15.5%	239	185	10	2	7	1	34	9.3%	2.1%	0.6%	1.4%	202.2	53.4	36.5	55.7	388.4	444.1	26.9
38	Jersey City, NJ	292,449	258	25	36	24	130	17	26	10.1%	10.8%	15.5%	10.3%	56.0%	21	13	2	2	3	0	1	34.2%	5.3%	7.7%	2.3%	8.5	12.3	8.2	44.5	43.8	88.2	7.2
39	Lakewood, CO	160,441	680	152	129	65	166	42	126	18.5%	27.4%	23.3%	11.7%	30.0%	12	7	4	0	1	0	0	4.4%	3.0%	0.0%	0.6%	94.7	80.4	40.5	103.5	320.4	423.8	7.5
40	Las Cruces, NM	111,385	482	160	89	51	71	22	89	18.5%	40.7%	22.6%	13.0%	18.1%	8	7	1	0	0	0	0	4.2%	1.1%	0.0%	0.0%	143.6	79.9	45.8	63.7	369.0	432.7	7.2
41	Las Vegas, NV	641,903	5,448	1,543	1,242	509	1,285	132	737	13.5%	32.8%	26.4%	10.8%	27.3%	152	102	13	7	9	7	14	6.2%	1.0%	1.4%	0.7%	240.4	193.5	79.3	200.2	648.5	848.7	23.7
42	League City, TX	114,392	54	22	17	0	6	0	9	16.7%	48.9%	37.8%	0.0%	13.3%	3	3	0	0	0	0	0	12.0%	0.0%	0.0%	0.0%	19.2	14.9	0.0	5.2	42.0	47.2	2.6
43	Lewisville, TX	111,822	209	78	46	19	32	6	28	13.4%	43.1%	25.4%	10.5%	17.7%	2	2	0	0	0	0	0	2.5%	0.0%	0.0%	0.0%	69.8	41.1	17.0	28.6	158.3	186.9	1.8
44	Lexington, KY	322,570	460	126	69	66	116	40	43	9.3%	30.2%	16.5%	15.8%	27.8%	31	30	0	0	1	0	0	19.2%	0.0%	0.0%	0.9%	39.1	21.4	20.5	36.0	106.6	142.6	9.6
45	Lincoln, NE	291,082	816	85	174	110	138	161	148	18.1%	12.7%	26.0%	16.5%	20.7%	8	3	0	1	0	4	0	3.4%	0.0%	0.9%	0.0%	29.2	59.8	37.8	47.4	232.9	280.3	2.7
46	Lynn, MA	101,253	381	37	88	72	31	109	44	11.5%	11.0%	26.1%	21.4%	9.2%	1	0	0	0	0	0	1	0.0%	0.0%	0.0%	0.0%	36.5	86.9	71.1	30.6	345.7	376.3	1.0
47	McKinney, TX	195,308	198	68	62	18	7	7	36	18.2%	42.0%	38.3%	11.1%	4.3%	5	4	0	0	0	1	0	5.6%	0.0%	0.0%	0.0%	34.8	31.7	9.2	3.6	97.8	101.4	2.6
48	Meridian, ID	117,635	161	24	20	16	68	18	15	9.3%	16.4%	13.7%	11.0%	46.6%	0	0	0	0	0	0	0	0.0%	0.0%	0.0%	0.0%	20.4	17.0	13.6	57.8	79.1	136.9	0.0
49	Milwaukee, WI	577,222	6,974	2,990	490	456	2,026	248	764	11.0%	48.1%	7.9%	7.3%	32.6%	195	179	5	2	1	1	7	5.6%	1.0%	0.4%	0.0%	518.0	84.9	79.0	351.0	857.2	1208.2	33.8
50	New Bedford, MA	101,079	478	44	133	91	54	65	91	19.0%	11.4%	34.4%	23.5%	14.0%	4	3	1	0	0	0	0	6.4%	0.7%	0.0%	0.0%	43.5	131.6	90.0	53.4	419.5	472.9	4.0
51	New Haven, CN	134,023	503	169	118	54	58	32	72	14.3%	39.2%	27.4%	12.5%	13.5%	25	23	0	0	0	0	2	12.0%	0.0%	0.0%	0.0%	126.1	88.0	40.3	43.3	332.0	375.3	18.7
52	Newark, NJ	311,549	956	353	218	142	56	61	126	13.2%	42.5%	26.3%	17.1%	6.7%	60	50	6	3	0	0	1	12.4%	2.7%	2.1%	0.0%	113.3	70.0	45.6	18.0	288.9	306.9	19.3
53	Norman, OK	128,026	278	50	30	17	114	15	52	18.7%	22.1%	13.3%	7.5%	50.4%	1	0	0	0	0	1	0	0.0%	0.0%	0.0%	0.0%	39.1	23.4	13.3	89.0	128.1	217.1	0.8
54	Oceanside, CA	174,068	525	62	112	89	121	45	96	18.3%	14.5%	26.1%	20.7%	28.2%	6	3	0	0	1	0	2	4.6%	0.0%	0.0%	0.8%	35.6	64.3	51.1	69.5	232.1	301.6	3.4
55	Pasadena, TX	151,950	676	181	84	45	214	36	116	17.2%	32.3%	15.0%	8.0%	38.2%	8	6	0	1	0	0	1	3.2%	0.0%	2.2%	0.0%	119.1	55.3	29.6	140.8	304.0	444.9	5.3
56	Philadelphia, PA	1,603,797	7,558	2,850	1,140	669	1,134	986	779	10.3%	42.0%	16.8%	9.9%	16.7%	455	381	21	4	11	14	24	11.8%	1.8%	0.6%	1.0%	177.7	71.1	41.7	70.7	400.5	471.3	28.4
57	Plano, TX	285,494	259	83	59	23	52	14	28	10.8%	35.9%	25.5%	10.0%	22.5%	5	3	1	0	0	0	1	3.5%	1.7%	0.0%	0.0%	29.1	20.7	8.1	18.2	72.5	90.7	1.8
58	Portland, OR	632,309	3,311	760	520	367	838	407	419	12.7%	26.3%	18.0%	12.7%	29.0%	83	59	8	1	4	2	3	7.2%	1.5%	0.3%	0.5%	120.2	82.2	58.0	132.5	391.1	523.6	13.1
59	Providence, RI	190,934	504	98	129	68	92	33	84	16.7%	23.3%	30.7%	16.2%	21.9%	22	17	1	0	1	0	3	14.8%	0.8%	0.0%	1.1%	51.3	67.6	35.6	48.2	215.8	264.0	11.5
60	Provo, UT	115,162	77	2	15	13	36	2	9	11.7%	2.9%	22.1%	19.1%	52.9%	0	0	0	0	0	0	0	0.0%	0.0%	0.0%	0.0%	1.7	13.0	11.3	31.3	35.6	66.9	0.0
61	Quincy, MA	101,636	253	13	34	52	97	25	32	12.6%	5.9%	15.4%	23.5%	43.9%	0	0	0	0	0	0	0	0.0%	0.0%	0.0%	0.0%	12.8	33.5	51.2	95.4	153.5	248.9	0.0
62	Renton, WA	106,785	197	62	17	6	63	17	32	16.2%	37.6%	10.3%	3.6%	38.2%	3	2	0	0	0	0	1	3.1%	0.0%	0.0%	0.0%	58.1	15.9	5.6	59.0	125.5	184.5	2.8
63	Richardson, TX	119,469	104	42	23	5	14	4	16	15.4%	47.7%	26.1%	5.7%	15.9%	5	3	2	0	0	0	0	6.7%	8.0%	0.0%	0.0%	35.2	19.3	4.2	11.7	75.3	87.1	4.2
64	Roanoke, VA	100,011	314	121	57	22	49	10	55	17.5%	46.7%	22.0%	8.5%	18.9%	16	15	0	1	0	0	0	11.0%	0.0%	4.3%	0.0%	121.0	57.0	22.0	49.0	265.0	314.0	16.0
65	Round Rock, TX	119,468	105	53	26	8	8	4	6	5.7%	53.5%	26.3%	8.1%	8.1%	3	3	0	0	0	0	0	5.4%	0.0%	0.0%	0.0%	44.4	21.8	6.7	6.7	81.2	87.9	2.5
66	Saint Paul, MN	311,527	1,607	578	273	171	289	43	253	15.7%	42.7%	20.2%	12.6%	21.3%	38	25	4	0	3	0	6	4.1%	1.4%	0.0%	1.0%	185.5	87.6	54.9	92.8	423.1	515.8	12.2
67	Salem, OR	175,535	617	91	94	51	186	131	64	10.4%	16.5%	17.0%	9.2%	33.6%	8	5	1	0	0	1	1	5.2%	1.1%	0.0%	0.0%	51.8	53.6	29.1	106.0	245.5	351.5	4.6
68	Salt Lake City, UT	199,723	1,242	202	275	203	293	64	205	16.5%	19.5%	26.5%	19.6%	28.3%	16	11	1	1	0	0	3	5.2%	0.4%	0.5%	0.0%	101.1	137.7	101.6	146.7	475.2	621.9	8.0
69	San Diego, CA	1,386,932	3,905	530	739	625	974	303	734	18.8%	16.7%	23.3%	19.7%	30.7%	63	28	7	9	7	3	9	5.0%	0.9%	1.4%	0.7%	38.2	53.3	45.1	70.2	211.3	281.6	4.5
70	Sandy Springs, GA	108,080	147	53	16	7	44	0	27	18.4%	44.2%	13.3%	5.8%	36.7%	7	4	0	0	1	0	2	7.0%	0.0%	0.0%	2.2%	49.0	14.8	6.5	40.7	95.3	136.0	6.5
71	Seattle, WA	737,015	3,849	567	640	709	1,270	633	30	0.8%	14.8%	16.8%	18.6%	33.3%	41	31	3	0	1	0	6	5.2%	0.5%	0.0%	0.1%	76.9	86.8	96.2	172.3	349.9	522.2	5.6
72	Sioux Falls, SD	192,517	856	131	167	92	292	35	139	16.2%	18.3%	23.3%	12.8%	40.7%	3	1	1	0	1	0	0	0.8%	0.6%	0.0%	0.3%	68.0	86.7	47.8	151.7	293.0	444.6	1.6
73	Spokane, WA	228,989	982	199	137	113	282	110	141	14.4%	23.7%	16.3%	13.4%	33.5%	14	8	3	2	0	1	0	3.9%	2.1%	1.7%	0.0%	86.9	59.8	49.3	123.2	305.7	428.8	6.1
74	Springfield, MA	155,929	1,078	230	247	197	61	134	209	19.4%	26.5%	28.4%	22.7%	7.0%	18	14	1	0	2	0	1	5.7%	0.4%	0.0%	3.2%	147.5	158.4	126.3	39.1	652.2	691.3	11.5
75	Springfield, MO	169,176	2,105	371	288	312	831	303	0	0.0%	17.6%	13.7%	14.8%	39.5%	19	15	1	1	2	0	0	3.9%	0.3%	0.3%	0.2%	219.3	170.2	184.4	491.2	753.1	1244.3	11.2
76	Stamford, CN	135,470	144	21	27	36	36	10	14	9.7%	16.2%	20.8%	27.7%	27.7%	6	2	2	1	1	0	0	8.7%	6.9%	2.7%	2.7%	15.5	19.9	26.6	26.6	79.7	106.3	4.4
77	Tulsa, OK	413,066	3,466	1,352	566	488	775	239	46	1.3%	39.5%	16.5%	14.3%	22.7%	59	47	3	3	5	1	0	3.4%	0.5%	0.6%	0.6%	327.3	137.0	118.1	187.6	651.5	839.1	14.3
78	Vancouver, WA	190,915	742	129	61	78	322	39	113	15.2%	20.5%	9.7%	12.4%	51.2%	18	13	3	0	0	1	1	9.2%	4.7%	0.0%	0.0%	67.6	32.0	40.9	168.7	220.0	388.7	9.4
79	Virginia Beach, VA	459,470	289	54	27	10	158	15	25	8.7%	20.5%	10.2%	3.8%	59.8%	14	10	1	1	1	1	0	15.6%	3.6%	9.1%	0.6%	11.8	5.9	2.2	34.4	28.5	62.9	3.0
80	Waterbury, CN	114,403	171	37	48	30	24	10	22	12.9%	24.8%	32.2%	20.1%	16.1%	9	8	1	0	0	0	0	17.8%	2.0%	0.0%	0.0%	32.3	42.0	26.2	21.0	128.5	149.5	7.9
81	West Jordan, UT	116,961	213	26	25	7	101	29	25	11.7%	13.8%	13.3%	3.7%	53.7%	4	3	0	0	0	0	1	10.3%	0.0%	0.0%	0.0%	22.2	21.4	6.0	86.4	95.8	182.1	3.4
82	West Valley City, UT	140,230	552	87	83	51	213	57	61	11.1%	17.7%	16.9%	10.4%	43.4%	5	4	0	1	0	0	0	4.4%	0.0%	1.9%	0.0%	62.0	59.2	36.4	151.9	241.7	393.6	3.6
83	Westminster, CO	114,561	283	72	35	35	74	15	52	18.4%	31.2%	15.2%	15.2%	32.0%	12	8	3	0	0	0	1	10.0%	7.9%	0.0%	0.0%	62.8	30.6	30.6	64.6	182.4	247.0	10.5
84	Worcester, MA	206,518	961	121	229	209	201	145	56	5.8%	13.4%	25.3%	23.1%	22.2%	6	3	2	0	0	0	1	2.4%	0.9%	0.0%	0.0%	58.6	110.9	101.2	97.3	368.0	465.3	2.9
85	Yonkers, NY	211,569	360	45	170	64	39	11	31	8.6%	13.7%	51.7%	19.5%	11.9%	8	5	2	0	0	0	1	10.0%	1.2%	0.0%	0.0%	21.3	80.4	30.3	18.4	151.7	170.2	3.8
86
87	Total	21,736,646	89,635	25,740	15,097	10,108	19,903	7,500	11,287	12.6%	32.9%	19.3%	12.9%	25.4%	2,566	1,962	186	55	97	49	217	7.08%	1.22%	0.54%	0.49%	118.4	69.5	46.5	91.6	320.8	412.4	11.8
88
89
90
91
92
93
94
95
96
97
98
99
100