INTRODUCTION

Correctional homes, often called correctional facilities or prisons, play a vital role in the criminal justice system. These institutions serve as the primary means of punishment, rehabilitation, and societal reintegration for individuals who have committed offenses. In this case, the analysis was done for minors between the ages of 14 years to 18 years.

Tools Used:

Microsoft SQL Server, Tableau

Key Questions

• What crimes are the most committed
• Which guardian of the juvenile has the most committed crime rate
• Which referral brings in the highest juvenile offenders

Findings

The data set was uploaded into the SQL server for further analysis with the name 'correctional_home'

select * from sysobjects where xtype = 'u'
select * from Correctional_home;

select GENDER, count(GENDER)as 'Count'
from Correctional_home
group By GENDER;

• A total number of 412 juveniles were recorded 18 being females and 394 being males.

select Avg(AGE)as 'Avg Age'
from correctional_home;

select Count(Distinct NATURE_OF_OFFENCE) as DistinctCount
from correctional_home;

What crimes are the most committed

-- Top 5 cases by Gender
select Top 5 count(NATURE_OF_OFFENCE) as Count_of_offence, GENDER, NATURE_OF_OFFENCE 
from Correctional_home
where GENDER = 'M'
group by GENDER, NATURE_OF_OFFENCE 
order by Count_of_offence Desc;


select Top 5 NATURE_OF_OFFENCE, GENDER, count(NATURE_OF_OFFENCE) as count
from correctional_home
where GENDER = 'F'
group by NATURE_OF_OFFENCE, GENDER
order by count desc;

Which guardian of the juvenile has the most committed crime rate

-- Guardians by cases
select WHO_DID_THE_CHILD_LIVE_PRIOR_TO_INCIDENT, count (NATURE_OF_OFFENCE) as OffenceCount
from Correctional_home
group by WHO_DID_THE_CHILD_LIVE_PRIOR_TO_INCIDENT
order by OffenceCount Desc;

Which referral brings in the highest juvenile offenders

-- Highest referral 
select Top 5 MODE_OF_REFERRAL, count (MODE_OF_REFERRAL) count
from Correctional_home
group by MODE_OF_REFERRAL
order by count (MODE_OF_REFERRAL)desc;

Summary

• Crime conspiracy, theft, culpable homicide, and house trespass are the highest crimes committed by the juveniles
• Juveniles living with their parents commit the most crimes
• referrals are mostly from the court

Recommendation

• Parents should be made accountable if they are lacking in training, it's ironic that single parents have a lower crime rate
• Juveniles should be spoken to from tender ages on the evils of crimes, in schools, social events even religious gatherings
• Society should be educated on the advantages of these correctional homes, so they can know where to direct each case
• The government should organize conferences, vocational activities, and more engaging and productive activities that will create a good leverage ground for the youths