Skip to content

The City of Chicago conducts an analysis of census, crime, and school data specific to individual neighborhoods or districts.

Notifications You must be signed in to change notification settings

JosePaor/Chicago-Socieconomic-Data-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

Chicago Socieconomic Data Analysis

The City of Chicago conducts an analysis of census, crime, and school data specific to individual neighborhoods or districts.

As a hands on Assignment, you will be working on a real world dataset provided by the Chicago Data Portal. Imagine, you have been hired by a non-profit organization that strives to improve educational outcomes for children and youth in the City of Chicago. Your job is to analyze the census, crime, and school data for a given neighborhood or district. You will identify causes that impact the enrollment, safety, health, environment ratings of schools.

Work: download the datasets provided, load them into a database, write and execute SQL queries.

  1. Chicago Socioeconomic Indicators

This dataset contains a selection of six socioeconomic indicators of public health significance and a hardship index, by Chicago community area, for the years 2008 - 2012.

  1. Chicago Public Schools

This dataset shows all school level performance data used to create CPS School Report Cards for the 2011-2012 school year.

  1. 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.

About

The City of Chicago conducts an analysis of census, crime, and school data specific to individual neighborhoods or districts.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published