2023 CPD IBD DML Pivot Tables 5 5 24.xlsx

	A	B	C	D	E	F	G	H	J	K	L	M	N	O	P	Q	R	T	U	V	W	X	Y	Z	AA	AB
1
2
3
4
5									2023 CPD IBD Stops and Stop Reasons									Equal Rates
6									Group	Officer Perception	Asian	Black	Hispanic	Native American	Other	White	Total	Group	Officer Perception	Asian	Black	Hispanic	Native American	Other	White	Total
7		race							Group Population	2021 VSR ACS Estimates	6,452	10,661	3,301	258	4,654	78,132	102,321	Group Population	2021 VSR ACS Estimates	6,452	10,661	3,301	258	4,654	78,132	102,321
8	Values	A	B	H	I	O	W	Grand Total	Stops	CPD IBD	88	1443	114	19	37	2249	3950	Stops	CPD IBD	88	305	114	19	37	2249	3950
9	Count of cadcallid	88	1443	114	19	37	2249	3950	Rate	Stops/Driver	0.0136	0.1354	0.0345	0.0736	0.0080	0.0288	0.0386	Rate	Stops/Driver	0.0136	0.0286	0.0345	0.0736	0.0080	0.0288	0.0386
10	Sum of Reasons_For_Stop_Moving_Violation	37	492	48	7	17	907	1508	Disproportion	Non-White/White, W/B	0.47	4.70	1.20	2.56	0.28	0.21		Disproportion	Non-White/White, W/B	0.47	0.99	1.20	2.56	0.28	1.01
11	Sum of Reasons_For_Stop_Equipment_Violation	9	97	9	0	2	164	281	Moving Violation	IBD	37	492	48	7	17	907	1508
12	Sum of Reasons_For_Stop_License_or_Registration_Violation	3	398	16	0	7	493	917	Rate	Stops/Driver	0.0057	0.0461	0.0145	0.0271	0.0037	0.0116	0.0147
13	Sum of Reasons_For_Stop_Investigative_Violation	3	158	5	0	4	129	299	Disproportion	Non-White/White, W/B	0.49	3.98	1.25	2.34	0.31	0.25		2023 CPD IBD Resident Stops
14									Equipment Violation	IBD	9	97	9	0	2	164	281	Group	Officer Perception	Asian	Black	Hispanic	Native Am	Other	White	Total
15									Rate	Stops/Driver	0.0014	0.0091	0.0027	-	0.0004	0.0021	0.0027	Group Population	2021 VSR ACS Estimates	6,452	10,661	3,301	258	4,654	78,132	102,321
16									Disproportion	Non-White/White, W/B	0.66	4.33	1.30	0.00	0.20	0.23		Stops	CPD IBD	74	1189	82	14	30	1578	2967
17									License or Registration Violation	IBD	3	398	16	0	7	493	917	Rate	Stops/Driver	0.01	0.11	0.02	0.05	0.01	0.02	0.03
18									Rate	Stops/Driver	0.0005	0.0373	0.0048	-	0.0015	0.0063	0.0090	Disproportion	Non-White/White, W/B	0.57	5.52	1.23	2.69	0.32	0.18
19									Disproportion	Non-White/White, W/B	0.07	5.92	0.77	0.00	0.24	0.17		VSR Stop Reasons 4 25 24
20									Investigative Reason	IBD	3	158	5	0	4	129	299
21									Rate	Stops/Driver	0.0005	0.0148	0.0015	-	0.0009	0.0017	0.0029
22									Disproportion	Non-White/White, W/B	0.28	8.98	0.92	0.00	0.52	0.11
23									VSR Stop Reasons 4 25 24
24
25									No Reason Reported	IBD	36	425	39	12	9	677	1198
26									Rate	Stops/Driver	0.01	0.04	0.01	-	0.00	0.01	0.01
27									Disproportion	Non-White/White, W/B	0.64	4.60	1.36	0.00	0.22	0.22
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100