Welcome to DataInsights
Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Chicago’s Data Portal - Analysis Done Using SQL
Project type
SQL
Date
Dec 2023
Analysis Report Link
StackHolder - Business Talk
Certainly, here are the 10 problem statements from Stack holder.
1. Find the total number of crimes recorded in the CRIME table.
2. Retrieve the first 10 rows from the CRIME table.
3. Determine how many crimes involve an arrest.
4. Identify unique types of crimes recorded at GAS STATION locations.
5. List all Community Areas whose names start with the letter ‘B’ from the CENSUS_DATA table.
6. Identify schools in Community Areas 10 to 15 that are healthy school certified.
7. Calculate the average school Safety Score.
8. List the top 5 Community Areas by average College Enrollment [number of students].
9. Determine which Community Area has the least value for school Safety Score.
10. Find the Per Capita Income of the Community Area that has a school Safety Score of 1.
1. Socioeconomic Indicators in Chicago
This dataset contains a selection of six socioeconomic indicators of public health significance and a “hardship index,” for each Chicago community area, for the years 2008 – 2012.
A detailed description of this dataset and the original dataset can be obtained from the Chicago Data Portal at:
https://data.cityofchicago.org/Health-Human-Services/Census-Data-Selected-socioeconomic-indicators-in-C/kn9c-c2s2
2. Chicago Public Schools
This dataset shows all school level performance data used to create CPS School Report Cards for the 2011-2012 school year.
A detailed description of this dataset and the original dataset can be obtained from the Chicago Data Portal at:
https://data.cityofchicago.org/Education/Chicago-Public-Schools-Progress-Report-Cards-2011-/9xs2-f89t
3. Chicago Crime Data
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days.
A detailed description of this dataset and the original dataset can be obtained from the Chicago Data Portal at:
https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-present/ijzp-q8t2
