How the IPRC

1
How the IPRCs Data Services Can Enhance Your
Prevention Efforts

• Safe Drug Free Schools Workshop
• Spring 2008

The Indiana Prevention Resource Center is funded,
in part, by a contract with the Indiana Family
and Social Services Administration, Division of
Mental Health and Addiction, financially
supported through HHS/Substance Abuse Mental
Health Services Administration, Center for
Substance Abuse Prevention, Substance Abuse
Prevention and Treatment Block Grant. The IPRC is
operated by the Indiana University Department of
Applied Health Science and School of Health,
Physical Education and Recreation. It is
affiliated with the Department's Institute of
Drug Abuse Prevention.
2
Data What is it?

• Its up to you!

http//skywalker.cochise.edu/wellerr/rocks/sdrx/li
mestoneL.htm
www.breitbart.com/article.php?id070312165704.qtgd
3817show_article 1catusimagelarge
3
Use it to raise quality of life

• Its what you make of it!

Limestone detail, IU
http//www.indexstock.com/content/ artists/Rich20
Remsberg.asp
House of Parliament, London, England
http//www.bluffton.edu/sullivanm/england/london/
parliament/frmriver.jpg
4
Alcohol Spending per Household
Per Household Spending on Alcohol, 2006 est. (AGS, 2007) -- Per Household Spending on Alcohol, 2006 est. (AGS, 2007) -- Per Household Spending on Alcohol, 2006 est. (AGS, 2007) -- Per Household Spending on Alcohol, 2006 est. (AGS, 2007) --
  Adams Indiana U.S.
Spending on Alcohol 529.8 664.9 621.7
Beer and ale not at home 73.9 93 87
Wine away from home 36.1 45.4 42.5
Whiskey away from home 60.1 75.6 70.7
Alcohol On Out-Of-Town Trips 65.4 81.7 76.4
Spending on Alcohol for Consumption in the Home 292.9 367.2 343.4
Beer and ale at home 157.2 197.1 184.3
Wine at home 84.7 106.2 99.3
Whiskey at home 20.7 25.9 24.2
Whiskey and other Liquor at Home 51.1 63.9 59.7
Median Household Income 45,791.50 54,272.10 48,276.60
Total Spending Per HH as of Median HH income 1.155 1.225 1.288
Rank for Spending as of Median HH Income 67 40th of 51  
5
Alcohol Retail Outlets Density/Map
Alcohol Sales Outlets Per Capita, (IN ATC, 2006) Alcohol Sales Outlets Per Capita, (IN ATC, 2006) Alcohol Sales Outlets Per Capita, (IN ATC, 2006)
  Monroe Co. Indiana
Total Population (2006 est.) 121,477 6,310,320
Number of Outlets (March 2006) 251 11,011
Outlets Per Capita 0.0021 0.0017
Outlets Per 1,000 Persons 2.07 1.74
Indiana Prevention Resource Center
Indiana Alcohol Tobacco Commission, 2006
6
Adults () without a High School Diploma
Educational Attainment, 2006 est. (AGS, 2007)-- Educational Attainment, 2006 est. (AGS, 2007)-- Educational Attainment, 2006 est. (AGS, 2007)-- Educational Attainment, 2006 est. (AGS, 2007)--
  Lake Co. Indiana U.S.
Less than 9th grade 3 5 5.8
9th to 12th grade, no diploma 9.5 9.7 8.9
Total, Less Than 9th or less than HS Diploma 12.5 14.6 14.7
High school graduate 40.4 36.5 29.8
Some college, no degree 20.8 19.7 19.9
Associate degree 8.5 6.7 7.4
Bachelor's degree 11.4 14.2 17.9
Graduate or profession degree 6.4 8.2 10.3
7
Map Education Any College Degree (prism map)
CW
NC
AGS, Core Demographics, 2005 estimates (2006)
8
Data can seem overwhelming

• Too much data can seem overwhelming.

http//entertainment.webshots.com/photo/1041702010
015901341YseGEP
9
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
10
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
11
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
Census Tracts 30300 30100 30200 31000 20400
20600 10202 10700 10500 11300 41200
12
Lake County Less Than High School Diploma
13
Family Conflict Divorce
Divorce Rate, 2006 est. (AGS,2007) Divorce Rate, 2006 est. (AGS,2007) Divorce Rate, 2006 est. (AGS,2007) Divorce Rate, 2006 est. (AGS,2007)
County Lake Indiana U.S.
Divorced (Percent) 10.2 10.7 9.7
14
Lake County Divorce Rate
Source AGS, 2007 estimates
15
Lake County Divorce Rate
Source AGS, 2007 estimates
Census Tracts 20600 10203 10202 10201
10900 11300 11700 1160011900 41600 12600
16
(No Transcript)
17
Marion County Schools, Alcohol Retail Outlets by
School District
Marion County Alcohol Retail Outlets by Township
Public School Other School Alcohol Retail
Outlet
18
MSD Washington Township Schools
Public School Other School Alcohol Retail
Outlet
19
Marion County Universities and Alcohol Retail
Outlets
University Alcohol Retail Outlet
Butler
Marion College
Indianapolis Downtown Campus of Ivy Tech
IUPUI
U of Indy
20
1 Mile around University of Indianapolis
21
Jefferson County Profile, 6.9
TRIP Inspection Data (using data for 2005 from IN State Excise Police), ATC 2006   TRIP Inspection Data (using data for 2005 from IN State Excise Police), ATC 2006   TRIP Inspection Data (using data for 2005 from IN State Excise Police), ATC 2006  
  Jefferson Indiana
Intensity of Inspection 2 1
No. Insp per 1,000 Youth, 10-17 13 12
Population 10-17 3,686 726,218
Total Population 32,343 6,270,352
Total No. of Tobacco Retail Outlets 2005 33 6,401
Total inspections Completed 49 8,503
Total Failed Inspections 10 1,076
Percent, Failed Inspections 20 13
Percent, Passed Inspections 80 87
Ranking (1-81) for Failed Inspections 22  
Ranking (1-81) for Passed Inspections 62  
Table 6.9 Intensity of TRIP Inspections and Related Statistics, Calculations for 2005 Based on Data from the TRIP Program (ATC, Indiana State Excise Police, 2006)
22
Schools in Proximity to Failed Trip Inspections
Close-up

• Jefferson County

23
Schools in Proximity to Failed Trip Inspections
Close-up
Source ISP, Excise Police, 2007
Grace Baptist School
Shawe Memorial High School
Pope John XXIII School

• Madison, Indiana

24
Property Crime Indices
Bottom Quarter, Mid Range, Top Quarter (includes
over IN over US)
Above US (9), 101.55-194 Above IN (12),
95.55-194 Top Quarter (23), 64-194 Mid Range
(46), 19-64 Lowest Quarter (23), 4-19
AGS, Crime Indices 2004 (2005)
Indiana Prevention Resource Center
25
Data frustrates there will be obstacles
http//entertainment.webshots.com/photo/1040516534
015901341MFYhbt
26
Ischemic Heart Disease
Mortality
Age-adjusted Ischemic Heart Disease mortality
rate, 2005
33.8
31.8
CW and CE regions Top county in CW 3 of
the top 4 counties in CW 5 of the top 10 in
CW or CE 8 of the top 16 in CW or CE 12
of the top 16 either in or bordering the CW or CE
regions.
Source Indiana State Department of Health,
October 19, 2007
27
Cancer of the Trachea, Lung, Bronchus
Morbidity
Rate/100,000 of DRG082 (C33), Cancer, 2005
CW and CE regions 2 of top 3 (CW) 4 of
top 9 counties (CW or CE) 6 of top 11
counties (CW or CE) 8 of top 11 counties (in
or bordering CW or CE)
33.8
31.8
Region Counties IN Cos T-R
CW/CE 24 26 of 92 66 of 3
CW/CE 24 26 of 92 44 of 9
CW/CE 24 26 of 92 54 of 11
Source Health Service Demand Estimates 2005. 
 Franking, TN  Planning 2.0, 2006. 
28
Dont let the task get you down.
http//entertainment.webshots.com/photo/1041702014
015901341TIYRAl
29
Without data you wont get far.
http//entertainment.webshots.com/photo/1040516516
015901341VzRwAP
30
Thank You !

• Indiana Prevention Resource Center
• 501 N. Morton, Suite110
• Bloomington, IN 47404
• Phone [phone]
• Fax [phone]
• E-mail drugprc_at_indiana.edu
• WWW http//www.drugs.indiana.edu
• A special thanks to Jennifer Kelley, MPH,
  Mikyung Jun, PhD, Aaron Jones, MPH, and Erika
  Pitcher for their assistance.