Transcript Rock County Juvenile Detention Center Data Trends

Useful Presentation of Data:
Letting the Data Speak
Ariel Barak
Rock County DMC Data Analyst
2009.12.07
DMC Action Network – Technical Assistance Series:
DMC Coordinators Seminar One
1
Overview of Presentation
1. Graphing Best Practices
2. Explaining System Flow and Definitions
3. Seasonal Effects on the Juvenile Justice
System
4. Raw Reductions vs. Rate Reductions
5. The Importance of Current and Local Data
•
Population changes over time – Census
Data vs. School Enrollment
•
Data Specificity - Uniform Crime
Reporting (UCR) vs. Law Enforcement
Records Management Systems (RMS)
2
12/2/2009
12/1/2009
11/30/2009
11/29/2009
11/28/2009
11/27/2009
11/26/2009
11/25/2009
11/24/2009
11/23/2009
11/22/2009
11/21/2009
11/20/2009
11/19/2009
11/18/2009
DJIA Close
Graphing Best Practices
Dow Jones Industrial Average @ Close, 11/18/2009-12/2/2009
10,500
10,450
10,400
10,350
DJIA Close
10,300
10,250
10,200
3
Graphing Best Practices
Dow Jones Industrial Average @ Close, 11/18/2009-12/2/2009
11,000
10,000
9,000
7,000
6,000
DJIA Close
5,000
4,000
3,000
2,000
1,000
12/2/2009
12/1/2009
11/30/2009
11/29/2009
11/28/2009
11/27/2009
11/26/2009
11/25/2009
11/24/2009
11/23/2009
11/22/2009
11/21/2009
11/20/2009
11/19/2009
0
11/18/2009
DJIA Close
8,000
Scale All Graphs to Start at Zero
4
12/2/2009
12/1/2009
8,000
11/30/2009
11/29/2009
11/28/2009
11/27/2009
11/26/2009
11/25/2009
11/24/2009
11/23/2009
11/22/2009
11/21/2009
11/20/2009
11/19/2009
11/18/2009
DJIA Close
Graphing Best Practices
Dow Jones Industrial Average @ Close, 11/18/2009-12/2/2009
11,000
10,000
9,000
DJIA Close
7,000
6,000
5,000
4,000
3,000
2,000
1,000
0
5
Graphing Best Practices
History of the Dow Jones
Industrial Average: 1900-2007
Issues with this graph?
6
Graphing Best Practices
Dow Jones Industrial Average: 1900-2007
14,000
DJIA Close
12,000
8,000
6,000
4,000
2,000
0
19
00
19
0
19 5
10
19
15
19
2
19 0
25
19
30
19
35
19
4
19 0
4
19 5
50
19
5
19 5
60
19
6
19 5
70
19
75
19
8
19 0
85
19
90
19
9
20 5
00
20
05
DJIA
10,000
7
Graphing Best Practices
Same Data, Different Graphs
BPD, JPD, RCSO Total Arrests by Year
BPD, JPD, RCSO Total Arrests by Year
20,000
9,000
18,000
8,000
16,000
14,000
7,000
7,482
8,235
7,886
7,579
7,082
7,321
12,000
Janesville PD
Beloit PD
10,000
8,000
6,000
7,119
Rock Co. SO
6,594
6,935
6,905
6,309
7,289
6,576
Janesville PD
5,000
Beloit PD
4,000
Rock Co. SO
3,000
2,000
4,000
2,000
6,000
7,702
3,402
3,106
3,062
3,319
3,313
2,757
2,610
2002
2003
2004
2005
2006
2007
2008
0
1,000
0
2002
2003
2004
2005
2006
2007
2008
Showing the same data in different graphs can add context
8
Explaining System Flow and Definitions
Why should this be done?
•
Empower non-system agents with
knowledge
•
Educate system agents as to what
happens outside of their sphere of
knowledge
•
Ensure everyone is talking about the same
decision point or issue
9
Explaining System Flow and Definitions
What is important?
•
Explain the usual path a case takes, not
each and every possible outcome
•
Explain what a term means - Apprehension
Request vs. Capias
•
Explain the implication(s) of a decision
10
Explaining System Flow and Definitions
Not Guilty
Alternatives
Consent
Decree
Impose and
Stayed
Citation
Arrest
Juvenile
Probation
District
Attorney
District
Attorney
Juvenile
Court
Fine
Restitution
and or
Community
Service
Formal
Supervision
(Probation)
Corrections
Placement
11
Explaining System Flow and Definitions
Examples from Site Coordinators
12
Our Business is Seasonal
Rock County Juvenile Probation: Referrals and Pager Contacts by
Month
450
2000
400
2001
350
2002
300
2003
2004
250
2005
200
2006
150
2007
100
2008
2009
50
Average
0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
13
Our Business is Seasonal
Rock County Juvenile Probation: Referrals and Pager Contacts by
Month
350
300
250
2007
200
2008
150
2009
100
50
0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Which comparison makes more sense?
• October 2009 vs September 2009
• October 2009 vs October 2008
14
Our Business is Seasonal
Rock County Juvenile Detention Center: Admissions by Month and
Year
160
2000
140
2001
Admissions
120
2002
2003
100
2004
80
2005
2006
60
2007
2008
40
2009
20
Average
0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
15
Our Business is Seasonal
Rock County Juvenile Detention Center: Admissions by Month and
Year
160
140
Admissions
120
100
2007
80
2008
2009
60
40
20
0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Which comparison makes more sense?
• September 2009 vs August 2009
• September 2009 vs September 2008
16
Review: How a Relative
Rate Index (RRI) value is Calculated
Black Relative Rate Index Value Example at Point of Arrest:
374 Black Arrests
739 Black Youth
526 White Arrests
1,252 White Youth
X 1,000 = 506.09
X 1,000 = 420.13
506.09
420.13
= 1.20
1
Raw Reductions vs Rate Reductions (RRI)
Raw Reduction
Yes
No
RRI Reduction
Yes
No
Almost any comparison of yearly
data will fit in one of the boxes above
18
Raw Reductions vs Rate Reductions (RRI)
Alpha County
Race /
Ethnicity
White
Black
Total
X
Population
1000
300
1300
Base Year
Arrests Arrest Rate
200
200.00
120
400.00
320
246.15
RRI
Population
1000
2.00
300
1300
Current Year
Arrests Arrest Rate
300
300.00
240
800.00
540
415.38
RRI
2.67
Alpha County - Raw Increase and Rate Increase
600
3.0
2.67
500
2.5
2.00
2.0
300
1.5
120
200
1.0
Black Arrest RRI
240
400
Arrests
Raw Reduction
Yes
No
RRI Reduction
No
Yes
Black Arrests
White Arrests
Black Arrest RRI
300
100
200
0.5
0
0.0
Base Year Current Year
Base Year Current Year
19
Raw Reductions vs Rate Reductions (RRI)
Beta County
Race /
Ethnicity
White
Black
Total
X
Population
1000
300
1300
Base Year
Arrests Arrest Rate
200
200.00
120
400.00
320
246.15
RRI
Population
1000
2.00
300
1300
Current Year
Arrests Arrest Rate
250
250.00
90
300.00
340
261.54
RRI
1.20
Beta County - Raw Increase and Rate Decrease
600
2.5
2.00
500
1.5
300
90
1.20
120
1.0
200
100
200
250
Black Arrest RRI
2.0
400
Arrests
Raw Reduction
Yes
No
RRI Reduction
No
Yes
Black Arrests
White Arrests
Black Arrest RRI
0.5
0
0.0
Base Year Current Year
Base Year Current Year
20
Raw Reductions vs Rate Reductions (RRI)
Charlie County
Race /
Ethnicity
White
Black
Total
Population
1000
300
1300
Base Year
Arrests Arrest Rate
200
200.00
120
400.00
320
246.15
RRI
Population
1000
2.00
300
1300
Current Year
Arrests Arrest Rate
100
100.00
75
250.00
175
134.62
RRI
2.50
X
Charlie County - Raw Decrease and Rate Increase
600
3.0
2.50
500
2.5
2.0
300
1.5
120
200
1.0
Black Arrest RRI
2.00
400
Arrests
Raw Reduction
Yes
No
RRI Reduction
No
Yes
Black Arrests
White Arrests
Black Arrest RRI
75
100
200
0.5
100
0
0.0
Base Year Current Year
Base Year Current Year
21
Raw Reductions vs Rate Reductions (RRI)
Delta County
Race /
Ethnicity
White
Black
Total
Population
1000
300
1300
Base Year
Arrests Arrest Rate
200
200.00
120
400.00
320
246.15
RRI
Population
1000
2.00
300
1300
Current Year
Arrests Arrest Rate
100
100.00
30
100.00
130
100.00
RRI
1.00
X
Delta County - Raw Decrease and Rate Decrease
600
2.5
2.00
500
1.5
300
1.00
120
1.0
200
100
200
Black Arrest RRI
2.0
400
Arrests
Raw Reduction
Yes
No
RRI Reduction
No
Yes
Black Arrests
White Arrests
Black Arrest RRI
0.5
30
100
0
0.0
Base Year Current Year
Base Year Current Year
22
Raw Reductions vs Rate Reductions (RRI)
Examples from Site Coordinators
23
Shifts in Population
Examples from Site Coordinators
24
Shifts in Population: A Rock County Example
Beloit School District - Enrollment Count by Year, 10-16 Year Olds
70%
60%
50%
Percent
White
Black
40%
Hispanic
30%
Asian
Am Ind
20%
10%
0%
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
Beloit School District - Enrollment Count by Year, 10-16yr olds
Year
Race
White
Black
Hispanic
Asian
Am Ind
Total
2000
2,171
995
353
41
11
3,571
2001
2,310
1,100
450
31
12
3,903
2002
2,171
1,035
460
29
11
3,706
2003
2,164
1,038
524
39
15
3,780
2004
2,182
1,065
586
41
18
3,892
2005
2,079
1,052
645
43
17
3,836
2006
1,986
1,021
750
38
19
3,814
2007
1,867
998
806
40
20
3,731
2008
1,809
965
852
39
18
3,683
2009
1,683
944
900
37
21
3,585
25
Shifts in Population – Why It Matters
Janesville RRI - Census 2000 vs. School Enrollment 2009
Race/Ethnicity
White Non-Hispanic
Black or African American
Hispanic
Race/Ethnicity
White Non-Hispanic
Black or African American
Hispanic
Census 2000
5,664
110
188
2008 Arrest
Rate 2008 Arrests Census
1,265
223
430
3,909
206
1,096
RRI - Census
17.50
4.91
School
2008 Arrest
Enrollment Rate 2009
2008 Arrests Enrollment RRI - Enrollment
4,478
1,265
282
317
430
1,356
4.80
394
206
523
1.85
26
Shifts in Population – Why It Matters
Beloit RRI - Census 2000 vs. School Enrollment 2009
Race/Ethnicity
White Non-Hispanic
Black or African American
Hispanic
Race/Ethnicity
White Non-Hispanic
Black or African American
Hispanic
Census 2000
2,354
837
333
2008 Arrest
Rate 2008 Arrests Census
204
481
1,047
876
625
208
RRI - Census
5.12
3.06
2008 Arrest
School
Rate Enrollment 2008 Arrests Enrollment RRI - Enrollment
2009
286
481
1,683
3.25
928
876
944
0.81
231
208
900
27
Uniform Crime Reporting (UCR) Arrest Data
2007 Rock County Juvenile Arrests by Offense by
Frequency - Total
Code
26
24
6
29
28
22
8
14
187
15
Offense
All Other (Except Traffic)
Disorderly Conduct
Theft
Runaways
Curfew and Loitering
Liquor Laws
Other Assaults
Vandalism
Marijuana Possession
Weapons
White Black AmInd Asian Total
948
462
7
3 1,420
666
378
2
4 1,050
421
128
0
1
550
282
158
3
4
447
228
179
1
1
409
289
48
4
1
342
127
114
0
3
244
180
54
0
0
234
120
49
0
0
169
45
16
1
0
62
Source: Wisconsin Office of Justice Assistance - Statistical Analysis Center
Issues with UCR Data
• Does not require
collection of Ethnicity Hispanic / Non-Hispanic
• Arrest information
regarding Age, Sex, and
Race is not all kept in the
same table
• Juvenile Arrests include
youth 0-17, regardless of
local age of majority
• Very aggregated - no
names, addresses, times,
or statute specificity
28
Local Law Enforcement Agency Arrest Data
Benefits of Local Arrest Data
• Collects Ethnicity Hispanic / NonHispanic
• Arrest information
regarding Age, Sex,
Race, Name,
Address, Time,
Statute, and UCR
Category is kept
• Allows you to
answer more specific
questions and
present more
meaningful data
analysis
Beloit PD 2008 - Top 10 Addresses Black Juvenile Arrests
Description
Memorial High School
Aldrich Middle School
McNeel Middle School
Shopko
Beloit PD
Residence
Keeler Grocery
Residence
CVS
Residence
Address
Arrests
1225 FOURTH ST
114
1859 NORTHGATE DR
64
1524 FREDERICK ST
41
2761 PRAIRIE AV
20
100 STATE ST
19
XXXX SUMMIT AV
11
1303 KEELER AV
10
XXXX SAINT LAWRENCE AV
9
2785 MILW RD
9
XXXX BURTON ST
8
Beloit PD 2008 - Juvenile Arrests in Beloit Schools
Statute Description
Truancy or Habitual Truancy
Disorderly Conduct - Muni
Disorderly Conduct
Battery-(Misdemeanor)
Possession of THC Less than 25 Grams-Muni
Theft < or = $1,000
Juv PO Hold/Apprehension Request
Poss Dangerous Weapon on School Grounds
Resist or Obstruct Officer
Daytime Curfew
Statute
15.26(2)
947.01-15.01
947.01
940.19(1)
961.41(3g)(e)-15.01
943.20(1)(a)(3)(a)
938.19(1)(d)6
948.61(1)
946.41(1)
15.27
Black
42
40
29
19
7
10
9
3
8
5
Hispanic
25
9
5
1
2
0
0
0
1
1
White
34
13
7
9
7
5
5
7
1
2
Total
101
62
41
29
16
15
14
10
10
8
29
Questions?
30
Ariel Barak
DMC Data Analyst
[email protected]
608-757-5225
31