Skip to content

Instantly share code, notes, and snippets.

@IreneJeong

IreneJeong/Assignment_5wk.ipynb

Created May 7, 2021 15:51
Show Gist options
  • Save IreneJeong/36c3a911256e1f681906e023a26897a6 to your computer and use it in GitHub Desktop.
Save IreneJeong/36c3a911256e1f681906e023a26897a6 to your computer and use it in GitHub Desktop.
Download ZIP
Created on Skills Network Labs
Display the source blob
Display the rendered blob
Raw
Assignment_5wk.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"<center>\n",
" <img src=\"https://s3-api.us-geo.objectstorage.softlayer.net/cf-courses-data/CognitiveClass/Logos/organization_logo/organization_logo.png\" width=\"300\" alt=\"cognitiveclass.ai logo\" />\n",
"</center>\n",
"\n",
"# Assignment Dahye Jeong"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Instruction\n",
"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.\n",
"\n",
"You will be asked questions that will help you understand the data just like a data analyst or data scientist would. You will be assessed both on the correctness of your SQL queries and results.\n",
"\n",
"A Python based Jupyter notebook has been provided to help with completing this assignment. Follow the instructions to complete all the problems. Then share the Queries and Results with your peers for reviewing.\n",
"\n",
"### Step-By-Step Assignmet Instructions \n",
"## Assignment Topic:\n",
"\n",
"In this assignment, you will download the datasets provided, load them into a database, write and execute SQL queries to answer the problems provided, and upload a screenshot showing the correct SQL query and result for review by your peers. A Jupyter notebook is provided in the preceding lesson to help you with the process.\n",
"\n",
"This assignment involves 3 datasets for the city of Chicago obtained from the Chicago Data Portal:\n",
"\n",
"1. Chicago Socioeconomic Indicators\n",
"\n",
"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.\n",
"\n",
"2. Chicago Public Schools\n",
"\n",
"This dataset shows all school level performance data used to create CPS School Report Cards for the 2011-2012 school year.\n",
"\n",
"3. Chicago Crime Data\n",
"\n",
"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.\n",
"\n",
"#### Instructions:\n",
"\n",
"### 1. Review the datasets\n",
"\n",
"Before you begin, you will need to become familiar with the datasets. Snapshots for the three datasets in .CSV format can be downloaded from the following links:\n",
"\n",
"Chicago Socioeconomic Indicators: Click here\n",
"\n",
"Chicago Public Schools: Click here\n",
"\n",
"Chicago Crime Data: Click here\n",
"\n",
"NOTE: Ensure you have downloaded the datasets using the links above instead of directly from the Chicago Data Portal. The versions linked here are subsets of the original datasets and have some of the column names modified to be more database friendly which will make it easier to complete this assignment. The CSV file provided above for the Chicago Crime Data is a very small subset of the full dataset available from the Chicago Data Portal. The original dataset is over 1.55GB in size and contains over 6.5 million rows. For the purposes of this assignment you will use a much smaller sample with only about 500 rows.\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 2. Load the datasets into a database\n",
"\n",
"Perform this step using the LOAD tool in the Db2 console. You will need to create 3 tables in the database, one for each dataset, named as follows, and then load the respective .CSV file into the table:\n",
"\n",
"CENSUS_DATA\n",
"\n",
"CHICAGO_PUBLIC_SCHOOLS\n",
"\n",
"CHICAGO_CRIME_DATA\n",
"\n",
"To load the data into the tables the steps are similar to Week 2 Lab 1 Part II. The only difference with that lab is that in Step 5 of the instructions you will need to click on create (+) New Table and specify the name of the table you want to create and then click Next."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 3. Write and execute queries\n",
"\n",
"Perform this step in the Jupyter notebook provided in the previous section. Carefully read and understand each problem. Compose and execute the appropriate SQL queries to answer each of the problems. Take a screenshot of each query and its results and save it as a jpg file.."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Requirement already satisfied: sqlalchemy==1.3.9 in /home/jupyterlab/conda/envs/python/lib/python3.6/site-packages (1.3.9)\n",
"Requirement already satisfied: ibm_db_sa in /home/jupyterlab/conda/envs/python/lib/python3.6/site-packages (0.3.3)\n",
"Requirement already satisfied: sqlalchemy>=0.7.3 in /home/jupyterlab/conda/envs/python/lib/python3.6/site-packages (from ibm_db_sa) (1.3.9)\n"
]
}
],
"source": [
"!pip install sqlalchemy==1.3.9\n",
"!pip install ibm_db_sa"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"%load_ext sql"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'Connected: svs59742@BLUDB'"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Enter the connection string for your Db2 on Cloud database instance below\n",
"# %sql ibm_db_sa://my-username:my-password@my-hostname:my-port/my-db-name\n",
"%sql ibm_db_sa://svs59742:3-q9b0k75qpnxmg6@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>colname</th>\n",
" <th>tabname</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>COMMUNITY_AREA_NAME</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>COMMUNITY_AREA_NUMBER</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>HARDSHIP_INDEX</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PERCENT_AGED_16__UNEMPLOYED</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PERCENT_AGED_25__WITHOUT_HIGH_SCHOOL_DIPLOMA</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PERCENT_AGED_UNDER_18_OR_OVER_64</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PERCENT_HOUSEHOLDS_BELOW_POVERTY</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PERCENT_OF_HOUSING_CROWDED</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PER_CAPITA_INCOME</td>\n",
" <td>CENSUS_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ARREST</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>BEAT</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>BLOCK</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CASE_NUMBER</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>COMMUNITY_AREA_NUMBER</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DATE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DESCRIPTION</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DISTRICT</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DOMESTIC</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>FBICODE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ID</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>IUCR</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LATITUDE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LOCATION</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LOCATION_DESCRIPTION</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LONGITUDE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PRIMARY_TYPE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>WARD</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>X_COORDINATE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>YEAR</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Y_COORDINATE</td>\n",
" <td>CHICAGO_CRIME_DATA</td>\n",
" </tr>\n",
" <tr>\n",
" <td>10th Grade PLAN (2009)</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>10th Grade PLAN (2010)</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>11th Grade Average ACT (2011)</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>9th Grade EXPLORE (2009)</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>9th Grade EXPLORE (2010)</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>AVERAGE_STUDENT_ATTENDANCE</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Adequate_Yearly_Progress_Made_</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Average_Teacher_Attendance</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>COLLEGE_ENROLLMENT</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>COMMUNITY_AREA_NAME</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>COMMUNITY_AREA_NUMBER</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CPS_Performance_Policy_Level</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CPS_Performance_Policy_Status</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>City</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Collaborative_Name</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>College_Eligibility__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>College_Enrollment_Rate__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Elementary, Middle, or High School</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Environment_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Environment_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Family_Involvement_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Family_Involvement_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Freshman_on_Track_Rate__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>General_Services_Route</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr3_5_Grade_Level_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr3_5_Grade_Level_Read__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr3_5_Keep_Pace_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr3_5_Keep_Pace_Read__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr6_8_Grade_Level_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr6_8_Grade_Level_Read__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr6_8_Keep_Pace_Math_</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr6_8_Keep_Pace_Read__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr_8_Explore_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gr_8_Explore_Read__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Graduation_Rate__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>HEALTHY_SCHOOL_CERTIFIED</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Exceeding_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Exceeding_Reading__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Value_Add_Color_Math</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Value_Add_Color_Read</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Value_Add_Math</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ISAT_Value_Add_Read</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Individualized_Education_Program_Compliance_Rate</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Instruction_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Instruction_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Latitude</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Leaders_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Leaders_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Link</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Location</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Longitude</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NAME_OF_SCHOOL</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Net_Change_EXPLORE_and_PLAN</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Net_Change_PLAN_and_ACT</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Network_Manager</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Parent_Engagement_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Parent_Engagement_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Parent_Environment_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Parent_Environment_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Phone_Number</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pk_2_Literacy__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pk_2_Math__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Police_District</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rate_of_Misconducts__per_100_students_</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>SAFETY_SCORE</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Safety_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>School_ID</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>State</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Street_Address</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Students_Passing__Algebra__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Students_Taking__Algebra__</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Teachers_Icon</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Teachers_Score</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Track_Schedule</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ward</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>X_COORDINATE</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Y_COORDINATE</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ZIP_Code</td>\n",
" <td>CHICAGO_PUBLIC_SCHOOLS</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('COMMUNITY_AREA_NAME', 'CENSUS_DATA'),\n",
" ('COMMUNITY_AREA_NUMBER', 'CENSUS_DATA'),\n",
" ('HARDSHIP_INDEX', 'CENSUS_DATA'),\n",
" ('PERCENT_AGED_16__UNEMPLOYED', 'CENSUS_DATA'),\n",
" ('PERCENT_AGED_25__WITHOUT_HIGH_SCHOOL_DIPLOMA', 'CENSUS_DATA'),\n",
" ('PERCENT_AGED_UNDER_18_OR_OVER_64', 'CENSUS_DATA'),\n",
" ('PERCENT_HOUSEHOLDS_BELOW_POVERTY', 'CENSUS_DATA'),\n",
" ('PERCENT_OF_HOUSING_CROWDED', 'CENSUS_DATA'),\n",
" ('PER_CAPITA_INCOME', 'CENSUS_DATA'),\n",
" ('ARREST', 'CHICAGO_CRIME_DATA'),\n",
" ('BEAT', 'CHICAGO_CRIME_DATA'),\n",
" ('BLOCK', 'CHICAGO_CRIME_DATA'),\n",
" ('CASE_NUMBER', 'CHICAGO_CRIME_DATA'),\n",
" ('COMMUNITY_AREA_NUMBER', 'CHICAGO_CRIME_DATA'),\n",
" ('DATE', 'CHICAGO_CRIME_DATA'),\n",
" ('DESCRIPTION', 'CHICAGO_CRIME_DATA'),\n",
" ('DISTRICT', 'CHICAGO_CRIME_DATA'),\n",
" ('DOMESTIC', 'CHICAGO_CRIME_DATA'),\n",
" ('FBICODE', 'CHICAGO_CRIME_DATA'),\n",
" ('ID', 'CHICAGO_CRIME_DATA'),\n",
" ('IUCR', 'CHICAGO_CRIME_DATA'),\n",
" ('LATITUDE', 'CHICAGO_CRIME_DATA'),\n",
" ('LOCATION', 'CHICAGO_CRIME_DATA'),\n",
" ('LOCATION_DESCRIPTION', 'CHICAGO_CRIME_DATA'),\n",
" ('LONGITUDE', 'CHICAGO_CRIME_DATA'),\n",
" ('PRIMARY_TYPE', 'CHICAGO_CRIME_DATA'),\n",
" ('WARD', 'CHICAGO_CRIME_DATA'),\n",
" ('X_COORDINATE', 'CHICAGO_CRIME_DATA'),\n",
" ('YEAR', 'CHICAGO_CRIME_DATA'),\n",
" ('Y_COORDINATE', 'CHICAGO_CRIME_DATA'),\n",
" ('10th Grade PLAN (2009)', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('10th Grade PLAN (2010)', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('11th Grade Average ACT (2011)', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('9th Grade EXPLORE (2009)', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('9th Grade EXPLORE (2010)', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('AVERAGE_STUDENT_ATTENDANCE', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Adequate_Yearly_Progress_Made_', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Average_Teacher_Attendance', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('COLLEGE_ENROLLMENT', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('COMMUNITY_AREA_NAME', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('COMMUNITY_AREA_NUMBER', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('CPS_Performance_Policy_Level', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('CPS_Performance_Policy_Status', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('City', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Collaborative_Name', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('College_Eligibility__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('College_Enrollment_Rate__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Elementary, Middle, or High School', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Environment_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Environment_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Family_Involvement_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Family_Involvement_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Freshman_on_Track_Rate__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('General_Services_Route', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr3_5_Grade_Level_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr3_5_Grade_Level_Read__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr3_5_Keep_Pace_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr3_5_Keep_Pace_Read__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr6_8_Grade_Level_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr6_8_Grade_Level_Read__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr6_8_Keep_Pace_Math_', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr6_8_Keep_Pace_Read__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr_8_Explore_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Gr_8_Explore_Read__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Graduation_Rate__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('HEALTHY_SCHOOL_CERTIFIED', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Exceeding_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Exceeding_Reading__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Value_Add_Color_Math', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Value_Add_Color_Read', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Value_Add_Math', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ISAT_Value_Add_Read', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Individualized_Education_Program_Compliance_Rate', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Instruction_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Instruction_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Latitude', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Leaders_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Leaders_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Link', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Location', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Longitude', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('NAME_OF_SCHOOL', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Net_Change_EXPLORE_and_PLAN', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Net_Change_PLAN_and_ACT', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Network_Manager', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Parent_Engagement_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Parent_Engagement_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Parent_Environment_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Parent_Environment_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Phone_Number', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Pk_2_Literacy__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Pk_2_Math__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Police_District', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Rate_of_Misconducts__per_100_students_', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('SAFETY_SCORE', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Safety_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('School_ID', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('State', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Street_Address', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Students_Passing__Algebra__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Students_Taking__Algebra__', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Teachers_Icon', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Teachers_Score', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Track_Schedule', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Ward', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('X_COORDINATE', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('Y_COORDINATE', 'CHICAGO_PUBLIC_SCHOOLS'),\n",
" ('ZIP_Code', 'CHICAGO_PUBLIC_SCHOOLS')]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select COLNAME, TABNAME from SYSCAT.COLUMNS \\\n",
"where TABNAME ='CENSUS_DATA' or TABNAME='CHICAGO_CRIME_DATA' or TABNAME='CHICAGO_PUBLIC_SCHOOLS'\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Problems\n",
"\n",
"### Problem 1\n",
"\n",
"##### Problem 1: Find the total number of crimes recorded in the CRIME table."
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>total_number_of_crime</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>533</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[(Decimal('533'),)]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select count(*) as Total_Number_of_Crime \\\n",
" from CHICAGO_CRIME_DATA"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 2\n",
"\n",
"##### Problem 2: List community areas with per capita income less than 11000."
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>community_area_name</th>\n",
" <th>per_capita_income</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>West Garfield Park</td>\n",
" <td>10934</td>\n",
" </tr>\n",
" <tr>\n",
" <td>South Lawndale</td>\n",
" <td>10402</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Fuller Park</td>\n",
" <td>10432</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Riverdale</td>\n",
" <td>8201</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('West Garfield Park', 10934),\n",
" ('South Lawndale', 10402),\n",
" ('Fuller Park', 10432),\n",
" ('Riverdale', 8201)]"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select COMMUNITY_AREA_NAME, PER_CAPITA_INCOME \\\n",
" from CENSUS_DATA \\\n",
" where PER_CAPITA_INCOME < '11000'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 3\n",
"\n",
"##### Problem 3: List all case numbers for crimes involving minors?"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>case_number</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>HL266884</td>\n",
" </tr>\n",
" <tr>\n",
" <td>HK238408</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('HL266884',), ('HK238408',)]"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select CASE_NUMBER from CHICAGO_CRIME_DATA where DESCRIPTION like '%MINOR%'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 4\n",
"\n",
"##### Problem 4: List all kidnapping crimes involving a child?"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>case_number</th>\n",
" <th>primary_type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>HN144152</td>\n",
" <td>KIDNAPPING</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('HN144152', 'KIDNAPPING')]"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select CASE_NUMBER,PRIMARY_TYPE from CHICAGO_CRIME_DATA \\\n",
" where lcase(PRIMARY_TYPE) like '%kidnapping%' and lcase(description) like '%child%'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 5\n",
"\n",
"##### Problem 5: What kind of crimes were recorded at schools?"
]
},
{
"cell_type": "code",
"execution_count": 47,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>primary_type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>ARSON</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ASSAULT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>BATTERY</td>\n",
" </tr>\n",
" <tr>\n",
" <td>BURGLARY</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CONCEALED CARRY LICENSE VIOLATION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CRIM SEXUAL ASSAULT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CRIMINAL DAMAGE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>CRIMINAL TRESPASS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DECEPTIVE PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DOMESTIC VIOLENCE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>GAMBLING</td>\n",
" </tr>\n",
" <tr>\n",
" <td>HOMICIDE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>HUMAN TRAFFICKING</td>\n",
" </tr>\n",
" <tr>\n",
" <td>INTERFERENCE WITH PUBLIC OFFICER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>INTIMIDATION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>KIDNAPPING</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LIQUOR LAW VIOLATION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>MOTOR VEHICLE THEFT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NARCOTICS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NON - CRIMINAL</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NON-CRIMINAL</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NON-CRIMINAL (SUBJECT SPECIFIED)</td>\n",
" </tr>\n",
" <tr>\n",
" <td>OBSCENITY</td>\n",
" </tr>\n",
" <tr>\n",
" <td>OFFENSE INVOLVING CHILDREN</td>\n",
" </tr>\n",
" <tr>\n",
" <td>OTHER NARCOTIC VIOLATION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>OTHER OFFENSE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PROSTITUTION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PUBLIC INDECENCY</td>\n",
" </tr>\n",
" <tr>\n",
" <td>PUBLIC PEACE VIOLATION</td>\n",
" </tr>\n",
" <tr>\n",
" <td>RITUALISM</td>\n",
" </tr>\n",
" <tr>\n",
" <td>ROBBERY</td>\n",
" </tr>\n",
" <tr>\n",
" <td>SEX OFFENSE</td>\n",
" </tr>\n",
" <tr>\n",
" <td>STALKING</td>\n",
" </tr>\n",
" <tr>\n",
" <td>THEFT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>WEAPONS VIOLATION</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('ARSON',),\n",
" ('ASSAULT',),\n",
" ('BATTERY',),\n",
" ('BURGLARY',),\n",
" ('CONCEALED CARRY LICENSE VIOLATION',),\n",
" ('CRIM SEXUAL ASSAULT',),\n",
" ('CRIMINAL DAMAGE',),\n",
" ('CRIMINAL TRESPASS',),\n",
" ('DECEPTIVE PRACTICE',),\n",
" ('DOMESTIC VIOLENCE',),\n",
" ('GAMBLING',),\n",
" ('HOMICIDE',),\n",
" ('HUMAN TRAFFICKING',),\n",
" ('INTERFERENCE WITH PUBLIC OFFICER',),\n",
" ('INTIMIDATION',),\n",
" ('KIDNAPPING',),\n",
" ('LIQUOR LAW VIOLATION',),\n",
" ('MOTOR VEHICLE THEFT',),\n",
" ('NARCOTICS',),\n",
" ('NON - CRIMINAL',),\n",
" ('NON-CRIMINAL',),\n",
" ('NON-CRIMINAL (SUBJECT SPECIFIED)',),\n",
" ('OBSCENITY',),\n",
" ('OFFENSE INVOLVING CHILDREN',),\n",
" ('OTHER NARCOTIC VIOLATION',),\n",
" ('OTHER OFFENSE',),\n",
" ('PROSTITUTION',),\n",
" ('PUBLIC INDECENCY',),\n",
" ('PUBLIC PEACE VIOLATION',),\n",
" ('RITUALISM',),\n",
" ('ROBBERY',),\n",
" ('SEX OFFENSE',),\n",
" ('STALKING',),\n",
" ('THEFT',),\n",
" ('WEAPONS VIOLATION',)]"
]
},
"execution_count": 47,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select DISTINCT(c.PRIMARY_TYPE) \\\n",
" from CHICAGO_CRIME_DATA as c, CHICAGO_PUBLIC_SCHOOLS as s \\\n",
" where s.\"Police_District\" in (select DISTRICT from CHICAGO_CRIME_DATA)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 6\n",
"\n",
"##### Problem 6: List the average safety score for all types of schools."
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {
"tags": []
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>name_of_school</th>\n",
" <th>avg_safety_score</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>Abraham Lincoln Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alexander Graham Bell Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Annie Keller Elementary Gifted Magnet School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Augustus H Burley Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edgar Allan Poe Elementary Classical School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edgebrook Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ellen Mitchell Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James E McDade Elementary Classical School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James G Blaine Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LaSalle Elementary Language Academy</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary E Courtenay Elementary Language Arts Center</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Northside College Preparatory High School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Northside Learning Center High School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Norwood Park Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Oriole Park Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Sauganash Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Stephen Decatur Classical Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Talman Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wildwood Elementary School</td>\n",
" <td>99.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walter Payton College Preparatory High School</td>\n",
" <td>98.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edison Park Elementary School</td>\n",
" <td>95.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John J Audubon Elementary School</td>\n",
" <td>95.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Whitney M Young Magnet High School</td>\n",
" <td>95.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hawthorne Elementary Scholastic Academy</td>\n",
" <td>92.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William Jones College Preparatory High School</td>\n",
" <td>92.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas A Edison Regional Gifted Center Elementary School</td>\n",
" <td>91.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ray Graham Training Center High School</td>\n",
" <td>90.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H Prescott Elementary School</td>\n",
" <td>90.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Albert G Lane Technical High School</td>\n",
" <td>88.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arthur E Canty Elementary School</td>\n",
" <td>87.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Chicago High School for Agricultural Sciences</td>\n",
" <td>87.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Franklin Elementary Fine Arts Center</td>\n",
" <td>87.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John C Coonley Elementary School</td>\n",
" <td>87.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mark Skinner Elementary School</td>\n",
" <td>87.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Andrew Jackson Elementary Language Academy</td>\n",
" <td>86.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Elizabeth H Sutherland Elementary School</td>\n",
" <td>86.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frederic Chopin Elementary School</td>\n",
" <td>86.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas J Waters Elementary School</td>\n",
" <td>85.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mount Greenwood Elementary School</td>\n",
" <td>84.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>South Loop Elementary School</td>\n",
" <td>84.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Otis Elementary School</td>\n",
" <td>83.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Amelia Earhart Options for Knowledge Elementary School</td>\n",
" <td>81.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Philip Rogers Elementary School</td>\n",
" <td>81.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John B Murphy Elementary School</td>\n",
" <td>80.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lenart Elementary Regional Gifted Center</td>\n",
" <td>79.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert L Grimes Elementary School</td>\n",
" <td>79.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Christian Ebinger Elementary School</td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hannah G Solomon Elementary School</td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Stone Elementary Scholastic Academy</td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William Penn Elementary School</td>\n",
" <td>78.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward N Hurley Elementary School</td>\n",
" <td>77.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George F Cassell Elementary School</td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Kate S Kellogg Elementary School</td>\n",
" <td>76.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Belmont-Cragin Elementary School</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Johann W von Goethe Elementary School</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Palmer Elementary School</td>\n",
" <td>75.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Westinghouse High School</td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John C Dore Elementary School</td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John H Vanderpoel Elementary Magnet School</td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mark Sheridan Elementary Math &amp; Science Academy</td>\n",
" <td>74.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alexander Hamilton Elementary School</td>\n",
" <td>73.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Friedrich Ludwig Jahn Elementary School</td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John L Marsh Elementary School</td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Stephen K Hayt Elementary School</td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas Drummond Elementary School</td>\n",
" <td>72.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ernst Prussing Elementary School</td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James B McPherson Elementary School</td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jonathan Burr Elementary School</td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walter L Newberry Math &amp; Science Academy Elementary School</td>\n",
" <td>71.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alcott High School for the Humanities</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Eliza Chappell Elementary School</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Friedrich W von Steuben Metropolitan Science High School</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ole A Thorp Elementary Scholastic Academy</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Spry Community Links High School</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William C Goudy Elementary School</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Woodlawn Community Elementary School</td>\n",
" <td>70.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Willa Cather Elementary School</td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H Ray Elementary School</td>\n",
" <td>69.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Carl von Linne Elementary School</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Harriet E Sayre Elementary Language Academy</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pulaski International Academy Elmentary School</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert A Black Magnet Elementary School</td>\n",
" <td>68.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Albert R Sabin Elementary Magnet School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Eric Solorio Academy High School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Inter-American Elementary Magnet School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Weldon Johnson Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Julia C Lathrop Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Julia Ward Howe Elementary School of Excellence</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mark Twain Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>National Teachers Elementary Academy</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Norman A Bridge Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>North River Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Oscar F Mayer Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas Hoyne Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>West Ridge Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William E Dever Elementary School</td>\n",
" <td>67.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Albany Park Multicultural Academy</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Chicago Academy Elementary School</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Christopher Columbus Elementary School</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Spry Elementary Community School</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>LaSalle II Magnet Elementary School</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Phillip Murray Elementary Language Academy</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert Lindblom Math &amp; Science Academy High School</td>\n",
" <td>66.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Galileo Math &amp; Science Scholastic Academy Elementary School</td>\n",
" <td>65.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Horace Greeley Elementary School</td>\n",
" <td>65.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Greenleaf Whittier Elementary School</td>\n",
" <td>65.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lincoln Park High School</td>\n",
" <td>65.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Grover Cleveland Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gwendolyn Brooks College Preparatory Academy High School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hiram H Belding Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hyman G Rickover Naval Academy High School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John H Kinzie Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lake View High School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Minnie Mars Jamieson Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rueben Salazar Elementary Bilingual Center</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rufus M Hitch Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William J Onahan Elementary School</td>\n",
" <td>64.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Bret Harte Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jacob Beidler Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jean Baptiste Beaubien Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Kenwood Academy High School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mancel Talcott Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Michael M Byrne Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert Healy Elementary School</td>\n",
" <td>63.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joshua D Kershaw Elementary School</td>\n",
" <td>62.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary Gage Peterson Elementary School</td>\n",
" <td>62.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Portage Park Elementary School</td>\n",
" <td>62.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Virgil Grissom Elementary School</td>\n",
" <td>62.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Adlai E Stevenson Elementary School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Burnham Elementary Inclusive Academy</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Durkin Park Elementary School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Genevieve Melody Elementary School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George B Swift Elementary Specialty School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jordan Elementary Community School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William Howard Taft High School</td>\n",
" <td>61.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Collins Academy High School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Emiliano Zapata Elementary Academy</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Evergreen Academy Middle School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frazier Prospective IB Magnet Elementary School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John A Walsh Elementary School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John W Garvy Elementary School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Johnnie Colemon Elementary Academy</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Maria Saucedo Elementary Scholastic Academy</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Peter A Reinberg Elementary School</td>\n",
" <td>60.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>A.N. Pritzker School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles Allen Prosser Career Academy High School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Columbia Explorers Elementary Academy</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Armstrong International Studies Elementary School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George M Pullman Elementary School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John B Drake Elementary School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lyman A Budlong Elementary School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard Henry Lee Elementary School</td>\n",
" <td>59.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Calmeca Academy of Fine Arts and Dual Language</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles R Darwin Elementary School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Chicago Academy High School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Washington Elementary School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Helen Peirce International Studies Elementary School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Infinity Math Science and Technology High School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Kellman Corporate Community Elementary School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Louis Nettelhorst Elementary School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Stephen T Mather High School</td>\n",
" <td>58.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ana Roque de Duprey Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Irma C Ruiz Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jacqueline B Vaughn Occupational High School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jose De Diego Elementary Community Academy</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Josephine C Locke Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lorenz Brentano Math &amp; Science Academy Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary Mapes Dodge Elementary Renaissance Academy</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Miriam G Canter Middle School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Sidney Sawyer Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William P Gray Elementary School</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Agustin Lara Elementary Academy</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jane Addams Elementary School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John T McCutcheon Elementary School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Logandale Middle School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lyman Trumbull Elementary School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ogden International High School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Turner-Drew Elementary Language Academy</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William F Finkl Elementary School</td>\n",
" <td>56.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Brighton Park Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles S Deneen Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James B Farnsworth Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary Lyon Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nathan Hale Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Newton Bateman Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Orozco Fine Arts &amp; Sciences Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rodolfo Lozano Bilingual &amp; International Center Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Salmon P Chase Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Washington D Smyser Elementary School</td>\n",
" <td>55.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Adam Clayton Powell Paideia Community Academy Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Carrie Jacobs Bond Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Cesar E Chavez Multicultural Academic Center Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Laughlin Falconer Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mariano Azuela Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Marvin Camras Elementary School</td>\n",
" <td>54.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles N Holden Elementary School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Federico Garcia Lorca Elementary School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Washington Carver Military Academy High School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John F Kennedy High School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Louis A Agassiz Elementary School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary McLeod Bethune Elementary School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Morton School of Excellence</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Phoenix Military Academy High School</td>\n",
" <td>53.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Al Raby High School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel Boone Elementary School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Calhoun North Elementary School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Neal F Simeon Career Academy High School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rudyard Kipling Elementary School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William J &amp; Charles H Mayo Elementary School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William P Nixon Elementary School</td>\n",
" <td>52.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Burnside Elementary Scholastic Academy</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Elizabeth Peabody Elementary School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ferdinand Peck Elementary School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Hancock College Preparatory High School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Harvard Elementary School of Excellence</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Marshall Metropolitan High School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Paul Cuffe Math-Science Technology Academy Elementary School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Roald Amundsen High School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wells Community Academy High School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>World Language Academy High School</td>\n",
" <td>51.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Bernhard Moos Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel Hale Williams Prep School of Medicine</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward Jenner Elementary Academy of the Arts</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John C Burroughs Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Brennemann Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Josiah Pickard Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Louis Pasteur Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Marcus Moziah Garvey Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mason High School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Near North Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Uplift Community High School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Victor Herbert Elementary School</td>\n",
" <td>50.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Air Force Academy High School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alexander Graham Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Francisco I Madero Middle School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George B McClellan Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Graeme Stewart Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ida B Wells Preparatory Elementary Academy</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Ward Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Matthew Gallistel Elementary Language Academy</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nathan R Goldblatt Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William Bishop Owen Scholastic Academy Elementary School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Williams Preparatory Academy Middle School</td>\n",
" <td>49.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Andrew Carnegie Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ashburn Community Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Carl Schurz High School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel Webster Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frank W Reilly Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John P Altgeld Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Multicultural Academy of Scholarship</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nathaniel Pope Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nicholas Senn High School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nicholson Technology Academy</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard Edwards Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert Nathaniel Dett Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Tarkington School of Excellence Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William C Reavis Math &amp; Science Specialty Elementary School</td>\n",
" <td>48.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arthur Dixon Elementary School</td>\n",
" <td>47.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DeWitt Clinton Elementary School</td>\n",
" <td>47.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward Beasley Elementary Magnet Academic Center</td>\n",
" <td>47.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William E B Dubois Elementary School</td>\n",
" <td>47.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H King Elementary School</td>\n",
" <td>47.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alice L Barnard Computer Math &amp; Science Center Elementary School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Benito Juarez Community Academy High School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dunne Technology Academy</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dvorak Technology Academy</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frank I Bennett Elementary School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frank W Gunsaulus Elementary Scholastic Academy</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Washington High School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pershing West Middle School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ravenswood Elementary School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert Fulton Elementary School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Theophilus Schmid Elementary School</td>\n",
" <td>46.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ambrose Plamondon Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Beulah Shoesmith Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Crispus Attucks Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Henry R Clissold Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Monroe Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Whistler Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Little Village Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Manuel Perez Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Patrick Henry Elementary School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>TEAM Englewood Community Academy High School</td>\n",
" <td>45.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles Gates Dawes Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Elaine O Goodlow Elementary Magnet School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Eli Whitney Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Everett McKinley Dirksen Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frederick A Douglass Academy High School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gerald Delgado Kanoon Elementary Magnet School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Irvin C Mollison Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jean D Lafayette Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Hay Elementary Community Academy</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Milton Gregory Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jonathan Y Scammon Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard J Oglesby Elementary School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Roberto Clemente Community Academy High School</td>\n",
" <td>44.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alessandro Volta Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>David G Farragut Career Academy High School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Manierre Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Greater Lawndale High School For Social Justice</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Helge A Haugan Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Lovett Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Marie Sklodowska Curie Metropolitan High School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Martha Ruggles Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nathan S Davis Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pilsen Elementary Community Academy</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard T Crane Technical Preparatory High School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Washington Irving Elementary School</td>\n",
" <td>43.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles Evans Hughes Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel R Cameron Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Eugene Field Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gurdon S Hubbard High School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Horatio May Elementary Community Academy</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jane A Neil Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John F Eberhart Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Foster Dulles Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lionel Hampton Fine &amp; Performing Arts Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Louis Armstrong Math &amp; Science Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>North-Grand High School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard Yates Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Telpochcalli Elementary School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Theodore Roosevelt High School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>VOISE Academy High School</td>\n",
" <td>42.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Bronzeville Scholastic Academy High School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles Sumner Math &amp; Science Community Acad Elementary School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dewey Elementary Academy of Fine Arts</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Henry H Nash Elementary School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Manley Career Academy High School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Marine Military Math and Science Academy</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Theodore Herzl Elementary School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wolfgang A Mozart Elementary School</td>\n",
" <td>41.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles G Hammond Elementary School</td>\n",
" <td>40.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ludwig Van Beethoven Elementary School</td>\n",
" <td>40.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Martin A Ryerson Elementary School</td>\n",
" <td>40.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Morgan Park High School</td>\n",
" <td>40.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H Seward Communication Arts Academy Elementary School</td>\n",
" <td>40.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Betsy Ross Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel J Corkery Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Rogers Clark Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ira F Aldridge Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Madison Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Russell Lowell Elementary School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Stephen F Gale Elementary Community Academy</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thurgood Marshall Middle School</td>\n",
" <td>39.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ames Middle School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Austin Business and Entrepreneurship Academy High School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Austin Polytechnical Academy High School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward C Delano Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Francis Parkman Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Henry Clay Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Shields Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jesse Sherwood Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mahalia Jackson Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rachel Carson Elementary School</td>\n",
" <td>38.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alfred Nobel Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Francis Scott Key Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John M Smyth Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Stockton Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Luther Burbank Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Matthew A Henson Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert Emmet Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Roswell B Mason Elementary School</td>\n",
" <td>37.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arthur A Libby Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Benjamin Banneker Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles Kozminski Elementary Community Academy</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Christian Fenger Academy High School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Claremont Academy Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Esmond Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Jungman Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ninos Heroes Elementary Academic Center</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Paul Revere Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Phillip D Armour Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Rosario Castellanos Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas Kelly High School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H Brown Elementary School</td>\n",
" <td>36.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Carroll-Rosenwald Specialty Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Florence Nightingale Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Granville T Woods Math &amp; Science Academy Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hanson Park Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jensen Elementary Scholastic Academy</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Barry Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Michael Faraday Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Oscar DePriest Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Scott Joplin Elementary School</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Sir Miles Davis Magnet Elementary Academy</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Spencer Technology Academy</td>\n",
" <td>35.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Douglas Taylor Elementary School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward Tilden Career Community Academy High School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Fort Dearborn Elementary School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Irene C. Hernandez Middle School for the Advancement of Science</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Northwest Middle School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Samuel Gompers Fine Arts Options Elementary School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas Chalmers Specialty Elementary School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William H Ryder Math &amp; Science Specialty Elementary School</td>\n",
" <td>34.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arna Wendell Bontemps Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward A Bouchet Math &amp; Science Academy Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George H Corliss High School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Henry O Tanner Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John H Hamline Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph Warren Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Leif Ericson Elementary Scholastic Academy</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Phobe Apperson Hearst Elementary School</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas A Hendricks Elementary Community Academy</td>\n",
" <td>33.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Anthony Overton Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Avalon Park Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles H Wacker Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Chicago Military Academy High School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James N Thorp Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Charles Haines Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John D Shoop Math-Science Technical Academy Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joseph E Gary Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Kelvyn Park High School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wendell E Green Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William T Sherman Elementary School</td>\n",
" <td>32.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alexander von Humboldt Elementary School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Anna R. Langford Community Academy</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ella Flagg Young Elementary School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Emmett Louis Till Math and Science Academy</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Fairfield Elementary Academy</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hope College Preparatory High School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ignance Paderewski Elementary Learning Academy</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Kate S Buckingham Special Education Center</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mount Vernon Elementary School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Myra Bradwell Communications Arts &amp; Sciences Elementary School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ronald Brown Elementary Community Academy</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ronald E McNair Elementary School</td>\n",
" <td>31.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel S Wentworth Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward K Ellington Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ellen H Richards Career Academy High School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Enrico Fermi Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Francis W Parker Elementary Community Academy</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James R Doolittle Jr Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Milton Brunson Math &amp; Science Specialty Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Oliver S Westcott Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Roger C Sullivan High School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Simon Guggenheim Elementary School</td>\n",
" <td>30.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Elihu Yale Elementary School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Fernwood Elementary School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Helen M Hefferan Elementary School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Hyde Park Academy High School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Paul Laurence Dunbar Career Academy High School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Paul Robeson High School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Richard J Daley Elementary Academy</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walter Reed Elementary School</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>West Park Elementary Academy</td>\n",
" <td>29.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alex Haley Elementary Academy</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Donald Morrill Math &amp; Science Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Garrett A Morgan Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Harold Washington Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Harriet Beecher Stowe Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Horace Mann Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Langston Hughes Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Moses Montefiore Special Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Park Manor Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Percy L Julian High School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Perkins Bass Elementary School</td>\n",
" <td>28.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arnold Mireles Elementary Academy</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Benjamin E Mays Elementary Academy</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Brian Piccolo Elementary Specialty School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Chicago Vocational Career Academy High School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Crown Community Academy of Fine Arts Center Elementary School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dyett High School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward White Elementary Career Academy</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frank L Gillespie Elementary School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Medgar Evers Elementary School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William K New Sullivan Elementary School</td>\n",
" <td>27.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Carter G Woodson South Elementary School</td>\n",
" <td>26.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles P Steinmetz Academic Centre High School</td>\n",
" <td>26.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edwin G Foreman High School</td>\n",
" <td>26.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Guglielmo Marconi Elementary Community Academy</td>\n",
" <td>26.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John T Pirie Fine Arts &amp; Academic Center Elementary School</td>\n",
" <td>26.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles P Caldwell Academy of Math &amp; Science Elementary School</td>\n",
" <td>25.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Clara Barton Elementary School</td>\n",
" <td>25.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Washington Carver Primary School</td>\n",
" <td>25.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walter Q Gresham Elementary School</td>\n",
" <td>25.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles W Earle Elementary School</td>\n",
" <td>24.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Amos Alonzo Stagg Elementary School</td>\n",
" <td>23.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Austin O Sexton Elementary School</td>\n",
" <td>23.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Francis M McKay Elementary School</td>\n",
" <td>23.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George W Curtis Elementary School</td>\n",
" <td>23.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>West Pullman Elementary School</td>\n",
" <td>23.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward Coles Elementary Language Academy</td>\n",
" <td>22.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Hedges Elementary School</td>\n",
" <td>22.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Melville W Fuller Elementary School</td>\n",
" <td>22.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wendell Smith Elementary School</td>\n",
" <td>22.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William Rainey Harper High School</td>\n",
" <td>22.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Leslie Lewis Elementary School</td>\n",
" <td>21.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Oliver Wendell Holmes Elementary School</td>\n",
" <td>21.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles S Brownell Elementary School</td>\n",
" <td>20.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Florence B Price Elementary School</td>\n",
" <td>20.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William J Bogan High School</td>\n",
" <td>20.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Alfred David Kohn Elementary School</td>\n",
" <td>19.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dumas Technology Academy</td>\n",
" <td>19.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Robert H Lawrence Elementary School</td>\n",
" <td>19.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Orville T Bright Elementary School</td>\n",
" <td>18.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William A Hinton Elementary School</td>\n",
" <td>18.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Isabelle C O&#x27;Keeffe Elementary School</td>\n",
" <td>17.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>New Millennium High School of Health at Bowen</td>\n",
" <td>17.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Songhai Elementary Learning Institute</td>\n",
" <td>17.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Charles R Henderson Elementary School</td>\n",
" <td>16.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frederick Funston Elementary School</td>\n",
" <td>16.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Asa Philip Randolph Elementary School</td>\n",
" <td>15.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Marquette Elementary School</td>\n",
" <td>15.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mildred I Lavizzo Elementary School</td>\n",
" <td>15.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Countee Cullen Elementary School</td>\n",
" <td>14.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Gage Park High School</td>\n",
" <td>14.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Emil G Hirsch Metropolitan High School</td>\n",
" <td>13.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John Fiske Elementary School</td>\n",
" <td>13.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William W Carter Elementary School</td>\n",
" <td>13.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Foster Park Elementary School</td>\n",
" <td>11.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George W Tilton Elementary School</td>\n",
" <td>6.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Luke O&#x27;Toole Elementary School</td>\n",
" <td>5.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edmond Burke Elementary School</td>\n",
" <td>1.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ariel Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Arthur R Ashe Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Barbara Vick Early Childhood &amp; Family Center</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Blair Early Childhood Center</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Cyrus H McCormick Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Daniel C Beard Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>DeVry University Advantage Academy High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Disney II Magnet School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dr Martin Luther King Jr College Prep High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Dr Jorge Prieto Math and Science</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Edward Everett Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Enrico Tonti Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Franz Peter Schubert Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Frederick Stock Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>George Leland Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Henry D Lloyd Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>High School of Leadership at South Shore</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jackie Robinson Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>James Wadsworth Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jesse Owens Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John J Pershing Elementary Humanities Magnet</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John M Harlan Community Academy High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>John W Cook Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Josefa Ortiz De Dominguez Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Joyce Kilmer Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Laura S Ward Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lawndale Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Lazaro Cardenas Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Louisa May Alcott Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Mary E McDowell Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Michele Clark Academic Prep Magnet High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Nathanael Greene Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>New Field Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Orr Academy High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Pablo Casals Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Parkside Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Peter Cooper Elementary Dual Language Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Ralph H Metcalfe Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Sharon Christa McAuliffe Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Skinner North</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Socorro Sandoval Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>South Shore Fine Arts Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Southside Occupational Academy High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Suder Montessori Magnet Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Thomas J Higgins Elementary Community Academy</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Velma F Thomas Early Childhood Center</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walt Disney Magnet Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Walter S Christopher Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wendell Phillips Academy High School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William B Ogden Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>William G Hibbard Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Williams Multiplex Elementary School</td>\n",
" <td>None</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Wilma Rudolph Elementary Learning Center</td>\n",
" <td>None</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('Abraham Lincoln Elementary School', Decimal('99.000000')),\n",
" ('Alexander Graham Bell Elementary School', Decimal('99.000000')),\n",
" ('Annie Keller Elementary Gifted Magnet School', Decimal('99.000000')),\n",
" ('Augustus H Burley Elementary School', Decimal('99.000000')),\n",
" ('Edgar Allan Poe Elementary Classical School', Decimal('99.000000')),\n",
" ('Edgebrook Elementary School', Decimal('99.000000')),\n",
" ('Ellen Mitchell Elementary School', Decimal('99.000000')),\n",
" ('James E McDade Elementary Classical School', Decimal('99.000000')),\n",
" ('James G Blaine Elementary School', Decimal('99.000000')),\n",
" ('LaSalle Elementary Language Academy', Decimal('99.000000')),\n",
" ('Mary E Courtenay Elementary Language Arts Center', Decimal('99.000000')),\n",
" ('Northside College Preparatory High School', Decimal('99.000000')),\n",
" ('Northside Learning Center High School', Decimal('99.000000')),\n",
" ('Norwood Park Elementary School', Decimal('99.000000')),\n",
" ('Oriole Park Elementary School', Decimal('99.000000')),\n",
" ('Sauganash Elementary School', Decimal('99.000000')),\n",
" ('Stephen Decatur Classical Elementary School', Decimal('99.000000')),\n",
" ('Talman Elementary School', Decimal('99.000000')),\n",
" ('Wildwood Elementary School', Decimal('99.000000')),\n",
" ('Walter Payton College Preparatory High School', Decimal('98.000000')),\n",
" ('Edison Park Elementary School', Decimal('95.000000')),\n",
" ('John J Audubon Elementary School', Decimal('95.000000')),\n",
" ('Whitney M Young Magnet High School', Decimal('95.000000')),\n",
" ('Hawthorne Elementary Scholastic Academy', Decimal('92.000000')),\n",
" ('William Jones College Preparatory High School', Decimal('92.000000')),\n",
" ('Thomas A Edison Regional Gifted Center Elementary School', Decimal('91.000000')),\n",
" ('Ray Graham Training Center High School', Decimal('90.000000')),\n",
" ('William H Prescott Elementary School', Decimal('90.000000')),\n",
" ('Albert G Lane Technical High School', Decimal('88.000000')),\n",
" ('Arthur E Canty Elementary School', Decimal('87.000000')),\n",
" ('Chicago High School for Agricultural Sciences', Decimal('87.000000')),\n",
" ('Franklin Elementary Fine Arts Center', Decimal('87.000000')),\n",
" ('John C Coonley Elementary School', Decimal('87.000000')),\n",
" ('Mark Skinner Elementary School', Decimal('87.000000')),\n",
" ('Andrew Jackson Elementary Language Academy', Decimal('86.000000')),\n",
" ('Elizabeth H Sutherland Elementary School', Decimal('86.000000')),\n",
" ('Frederic Chopin Elementary School', Decimal('86.000000')),\n",
" ('Thomas J Waters Elementary School', Decimal('85.000000')),\n",
" ('Mount Greenwood Elementary School', Decimal('84.000000')),\n",
" ('South Loop Elementary School', Decimal('84.000000')),\n",
" ('James Otis Elementary School', Decimal('83.000000')),\n",
" ('Amelia Earhart Options for Knowledge Elementary School', Decimal('81.000000')),\n",
" ('Philip Rogers Elementary School', Decimal('81.000000')),\n",
" ('John B Murphy Elementary School', Decimal('80.000000')),\n",
" ('Lenart Elementary Regional Gifted Center', Decimal('79.000000')),\n",
" ('Robert L Grimes Elementary School', Decimal('79.000000')),\n",
" ('Christian Ebinger Elementary School', Decimal('78.000000')),\n",
" ('Hannah G Solomon Elementary School', Decimal('78.000000')),\n",
" ('Stone Elementary Scholastic Academy', Decimal('78.000000')),\n",
" ('William Penn Elementary School', Decimal('78.000000')),\n",
" ('Edward N Hurley Elementary School', Decimal('77.000000')),\n",
" ('George F Cassell Elementary School', Decimal('76.000000')),\n",
" ('Kate S Kellogg Elementary School', Decimal('76.000000')),\n",
" ('Belmont-Cragin Elementary School', Decimal('75.000000')),\n",
" ('Johann W von Goethe Elementary School', Decimal('75.000000')),\n",
" ('John Palmer Elementary School', Decimal('75.000000')),\n",
" ('George Westinghouse High School', Decimal('74.000000')),\n",
" ('John C Dore Elementary School', Decimal('74.000000')),\n",
" ('John H Vanderpoel Elementary Magnet School', Decimal('74.000000')),\n",
" ('Mark Sheridan Elementary Math & Science Academy', Decimal('74.000000')),\n",
" ('Alexander Hamilton Elementary School', Decimal('73.000000')),\n",
" ('Friedrich Ludwig Jahn Elementary School', Decimal('72.000000')),\n",
" ('John L Marsh Elementary School', Decimal('72.000000')),\n",
" ('Stephen K Hayt Elementary School', Decimal('72.000000')),\n",
" ('Thomas Drummond Elementary School', Decimal('72.000000')),\n",
" ('Ernst Prussing Elementary School', Decimal('71.000000')),\n",
" ('James B McPherson Elementary School', Decimal('71.000000')),\n",
" ('Jonathan Burr Elementary School', Decimal('71.000000')),\n",
" ('Walter L Newberry Math & Science Academy Elementary School', Decimal('71.000000')),\n",
" ('Alcott High School for the Humanities', Decimal('70.000000')),\n",
" ('Eliza Chappell Elementary School', Decimal('70.000000')),\n",
" ('Friedrich W von Steuben Metropolitan Science High School', Decimal('70.000000')),\n",
" ('Ole A Thorp Elementary Scholastic Academy', Decimal('70.000000')),\n",
" ('Spry Community Links High School', Decimal('70.000000')),\n",
" ('William C Goudy Elementary School', Decimal('70.000000')),\n",
" ('Woodlawn Community Elementary School', Decimal('70.000000')),\n",
" ('Willa Cather Elementary School', Decimal('69.000000')),\n",
" ('William H Ray Elementary School', Decimal('69.000000')),\n",
" ('Carl von Linne Elementary School', Decimal('68.000000')),\n",
" ('Harriet E Sayre Elementary Language Academy', Decimal('68.000000')),\n",
" ('Pulaski International Academy Elmentary School', Decimal('68.000000')),\n",
" ('Robert A Black Magnet Elementary School', Decimal('68.000000')),\n",
" ('Albert R Sabin Elementary Magnet School', Decimal('67.000000')),\n",
" ('Eric Solorio Academy High School', Decimal('67.000000')),\n",
" ('Inter-American Elementary Magnet School', Decimal('67.000000')),\n",
" ('James Weldon Johnson Elementary School', Decimal('67.000000')),\n",
" ('Julia C Lathrop Elementary School', Decimal('67.000000')),\n",
" ('Julia Ward Howe Elementary School of Excellence', Decimal('67.000000')),\n",
" ('Mark Twain Elementary School', Decimal('67.000000')),\n",
" ('National Teachers Elementary Academy', Decimal('67.000000')),\n",
" ('Norman A Bridge Elementary School', Decimal('67.000000')),\n",
" ('North River Elementary School', Decimal('67.000000')),\n",
" ('Oscar F Mayer Elementary School', Decimal('67.000000')),\n",
" ('Thomas Hoyne Elementary School', Decimal('67.000000')),\n",
" ('West Ridge Elementary School', Decimal('67.000000')),\n",
" ('William E Dever Elementary School', Decimal('67.000000')),\n",
" ('Albany Park Multicultural Academy', Decimal('66.000000')),\n",
" ('Chicago Academy Elementary School', Decimal('66.000000')),\n",
" ('Christopher Columbus Elementary School', Decimal('66.000000')),\n",
" ('John Spry Elementary Community School', Decimal('66.000000')),\n",
" ('LaSalle II Magnet Elementary School', Decimal('66.000000')),\n",
" ('Phillip Murray Elementary Language Academy', Decimal('66.000000')),\n",
" ('Robert Lindblom Math & Science Academy High School', Decimal('66.000000')),\n",
" ('Galileo Math & Science Scholastic Academy Elementary School', Decimal('65.000000')),\n",
" ('Horace Greeley Elementary School', Decimal('65.000000')),\n",
" ('John Greenleaf Whittier Elementary School', Decimal('65.000000')),\n",
" ('Lincoln Park High School', Decimal('65.000000')),\n",
" ('Grover Cleveland Elementary School', Decimal('64.000000')),\n",
" ('Gwendolyn Brooks College Preparatory Academy High School', Decimal('64.000000')),\n",
" ('Hiram H Belding Elementary School', Decimal('64.000000')),\n",
" ('Hyman G Rickover Naval Academy High School', Decimal('64.000000')),\n",
" ('John H Kinzie Elementary School', Decimal('64.000000')),\n",
" ('Lake View High School', Decimal('64.000000')),\n",
" ('Minnie Mars Jamieson Elementary School', Decimal('64.000000')),\n",
" ('Rueben Salazar Elementary Bilingual Center', Decimal('64.000000')),\n",
" ('Rufus M Hitch Elementary School', Decimal('64.000000')),\n",
" ('William J Onahan Elementary School', Decimal('64.000000')),\n",
" ('Bret Harte Elementary School', Decimal('63.000000')),\n",
" ('Jacob Beidler Elementary School', Decimal('63.000000')),\n",
" ('Jean Baptiste Beaubien Elementary School', Decimal('63.000000')),\n",
" ('Kenwood Academy High School', Decimal('63.000000')),\n",
" ('Mancel Talcott Elementary School', Decimal('63.000000')),\n",
" ('Michael M Byrne Elementary School', Decimal('63.000000')),\n",
" ('Robert Healy Elementary School', Decimal('63.000000')),\n",
" ('Joshua D Kershaw Elementary School', Decimal('62.000000')),\n",
" ('Mary Gage Peterson Elementary School', Decimal('62.000000')),\n",
" ('Portage Park Elementary School', Decimal('62.000000')),\n",
" ('Virgil Grissom Elementary School', Decimal('62.000000')),\n",
" ('Adlai E Stevenson Elementary School', Decimal('61.000000')),\n",
" ('Burnham Elementary Inclusive Academy', Decimal('61.000000')),\n",
" ('Durkin Park Elementary School', Decimal('61.000000')),\n",
" ('Genevieve Melody Elementary School', Decimal('61.000000')),\n",
" ('George B Swift Elementary Specialty School', Decimal('61.000000')),\n",
" ('Jordan Elementary Community School', Decimal('61.000000')),\n",
" ('William Howard Taft High School', Decimal('61.000000')),\n",
" ('Collins Academy High School', Decimal('60.000000')),\n",
" ('Emiliano Zapata Elementary Academy', Decimal('60.000000')),\n",
" ('Evergreen Academy Middle School', Decimal('60.000000')),\n",
" ('Frazier Prospective IB Magnet Elementary School', Decimal('60.000000')),\n",
" ('John A Walsh Elementary School', Decimal('60.000000')),\n",
" ('John W Garvy Elementary School', Decimal('60.000000')),\n",
" ('Johnnie Colemon Elementary Academy', Decimal('60.000000')),\n",
" ('Maria Saucedo Elementary Scholastic Academy', Decimal('60.000000')),\n",
" ('Peter A Reinberg Elementary School', Decimal('60.000000')),\n",
" ('A.N. Pritzker School', Decimal('59.000000')),\n",
" ('Charles Allen Prosser Career Academy High School', Decimal('59.000000')),\n",
" ('Columbia Explorers Elementary Academy', Decimal('59.000000')),\n",
" ('George Armstrong International Studies Elementary School', Decimal('59.000000')),\n",
" ('George M Pullman Elementary School', Decimal('59.000000')),\n",
" ('John B Drake Elementary School', Decimal('59.000000')),\n",
" ('Lyman A Budlong Elementary School', Decimal('59.000000')),\n",
" ('Richard Henry Lee Elementary School', Decimal('59.000000')),\n",
" ('Calmeca Academy of Fine Arts and Dual Language', Decimal('58.000000')),\n",
" ('Charles R Darwin Elementary School', Decimal('58.000000')),\n",
" ('Chicago Academy High School', Decimal('58.000000')),\n",
" ('George Washington Elementary School', Decimal('58.000000')),\n",
" ('Helen Peirce International Studies Elementary School', Decimal('58.000000')),\n",
" ('Infinity Math Science and Technology High School', Decimal('58.000000')),\n",
" ('Joseph Kellman Corporate Community Elementary School', Decimal('58.000000')),\n",
" ('Louis Nettelhorst Elementary School', Decimal('58.000000')),\n",
" ('Stephen T Mather High School', Decimal('58.000000')),\n",
" ('Ana Roque de Duprey Elementary School', Decimal('57.000000')),\n",
" ('Irma C Ruiz Elementary School', Decimal('57.000000')),\n",
" ('Jacqueline B Vaughn Occupational High School', Decimal('57.000000')),\n",
" ('Jose De Diego Elementary Community Academy', Decimal('57.000000')),\n",
" ('Josephine C Locke Elementary School', Decimal('57.000000')),\n",
" ('Lorenz Brentano Math & Science Academy Elementary School', Decimal('57.000000')),\n",
" ('Mary Mapes Dodge Elementary Renaissance Academy', Decimal('57.000000')),\n",
" ('Miriam G Canter Middle School', Decimal('57.000000')),\n",
" ('Sidney Sawyer Elementary School', Decimal('57.000000')),\n",
" ('William P Gray Elementary School', Decimal('57.000000')),\n",
" ('Agustin Lara Elementary Academy', Decimal('56.000000')),\n",
" ('Jane Addams Elementary School', Decimal('56.000000')),\n",
" ('John T McCutcheon Elementary School', Decimal('56.000000')),\n",
" ('Logandale Middle School', Decimal('56.000000')),\n",
" ('Lyman Trumbull Elementary School', Decimal('56.000000')),\n",
" ('Ogden International High School', Decimal('56.000000')),\n",
" ('Turner-Drew Elementary Language Academy', Decimal('56.000000')),\n",
" ('William F Finkl Elementary School', Decimal('56.000000')),\n",
" ('Brighton Park Elementary School', Decimal('55.000000')),\n",
" ('Charles S Deneen Elementary School', Decimal('55.000000')),\n",
" ('James B Farnsworth Elementary School', Decimal('55.000000')),\n",
" ('Mary Lyon Elementary School', Decimal('55.000000')),\n",
" ('Nathan Hale Elementary School', Decimal('55.000000')),\n",
" ('Newton Bateman Elementary School', Decimal('55.000000')),\n",
" ('Orozco Fine Arts & Sciences Elementary School', Decimal('55.000000')),\n",
" ('Rodolfo Lozano Bilingual & International Center Elementary School', Decimal('55.000000')),\n",
" ('Salmon P Chase Elementary School', Decimal('55.000000')),\n",
" ('Washington D Smyser Elementary School', Decimal('55.000000')),\n",
" ('Adam Clayton Powell Paideia Community Academy Elementary School', Decimal('54.000000')),\n",
" ('Carrie Jacobs Bond Elementary School', Decimal('54.000000')),\n",
" ('Cesar E Chavez Multicultural Academic Center Elementary School', Decimal('54.000000')),\n",
" ('Laughlin Falconer Elementary School', Decimal('54.000000')),\n",
" ('Mariano Azuela Elementary School', Decimal('54.000000')),\n",
" ('Marvin Camras Elementary School', Decimal('54.000000')),\n",
" ('Charles N Holden Elementary School', Decimal('53.000000')),\n",
" ('Federico Garcia Lorca Elementary School', Decimal('53.000000')),\n",
" ('George Washington Carver Military Academy High School', Decimal('53.000000')),\n",
" ('John F Kennedy High School', Decimal('53.000000')),\n",
" ('Louis A Agassiz Elementary School', Decimal('53.000000')),\n",
" ('Mary McLeod Bethune Elementary School', Decimal('53.000000')),\n",
" ('Morton School of Excellence', Decimal('53.000000')),\n",
" ('Phoenix Military Academy High School', Decimal('53.000000')),\n",
" ('Al Raby High School', Decimal('52.000000')),\n",
" ('Daniel Boone Elementary School', Decimal('52.000000')),\n",
" ('John Calhoun North Elementary School', Decimal('52.000000')),\n",
" ('Neal F Simeon Career Academy High School', Decimal('52.000000')),\n",
" ('Rudyard Kipling Elementary School', Decimal('52.000000')),\n",
" ('William J & Charles H Mayo Elementary School', Decimal('52.000000')),\n",
" ('William P Nixon Elementary School', Decimal('52.000000')),\n",
" ('Burnside Elementary Scholastic Academy', Decimal('51.000000')),\n",
" ('Elizabeth Peabody Elementary School', Decimal('51.000000')),\n",
" ('Ferdinand Peck Elementary School', Decimal('51.000000')),\n",
" ('John Hancock College Preparatory High School', Decimal('51.000000')),\n",
" ('John Harvard Elementary School of Excellence', Decimal('51.000000')),\n",
" ('John Marshall Metropolitan High School', Decimal('51.000000')),\n",
" ('Paul Cuffe Math-Science Technology Academy Elementary School', Decimal('51.000000')),\n",
" ('Roald Amundsen High School', Decimal('51.000000')),\n",
" ('Wells Community Academy High School', Decimal('51.000000')),\n",
" ('World Language Academy High School', Decimal('51.000000')),\n",
" ('Bernhard Moos Elementary School', Decimal('50.000000')),\n",
" ('Daniel Hale Williams Prep School of Medicine', Decimal('50.000000')),\n",
" ('Edward Jenner Elementary Academy of the Arts', Decimal('50.000000')),\n",
" ('John C Burroughs Elementary School', Decimal('50.000000')),\n",
" ('Joseph Brennemann Elementary School', Decimal('50.000000')),\n",
" ('Josiah Pickard Elementary School', Decimal('50.000000')),\n",
" ('Louis Pasteur Elementary School', Decimal('50.000000')),\n",
" ('Marcus Moziah Garvey Elementary School', Decimal('50.000000')),\n",
" ('Mason High School', Decimal('50.000000')),\n",
" ('Near North Elementary School', Decimal('50.000000')),\n",
" ('Uplift Community High School', Decimal('50.000000')),\n",
" ('Victor Herbert Elementary School', Decimal('50.000000')),\n",
" ('Air Force Academy High School', Decimal('49.000000')),\n",
" ('Alexander Graham Elementary School', Decimal('49.000000')),\n",
" ('Francisco I Madero Middle School', Decimal('49.000000')),\n",
" ('George B McClellan Elementary School', Decimal('49.000000')),\n",
" ('Graeme Stewart Elementary School', Decimal('49.000000')),\n",
" ('Ida B Wells Preparatory Elementary Academy', Decimal('49.000000')),\n",
" ('James Ward Elementary School', Decimal('49.000000')),\n",
" ('Matthew Gallistel Elementary Language Academy', Decimal('49.000000')),\n",
" ('Nathan R Goldblatt Elementary School', Decimal('49.000000')),\n",
" ('William Bishop Owen Scholastic Academy Elementary School', Decimal('49.000000')),\n",
" ('Williams Preparatory Academy Middle School', Decimal('49.000000')),\n",
" ('Andrew Carnegie Elementary School', Decimal('48.000000')),\n",
" ('Ashburn Community Elementary School', Decimal('48.000000')),\n",
" ('Carl Schurz High School', Decimal('48.000000')),\n",
" ('Daniel Webster Elementary School', Decimal('48.000000')),\n",
" ('Frank W Reilly Elementary School', Decimal('48.000000')),\n",
" ('John P Altgeld Elementary School', Decimal('48.000000')),\n",
" ('Multicultural Academy of Scholarship', Decimal('48.000000')),\n",
" ('Nathaniel Pope Elementary School', Decimal('48.000000')),\n",
" ('Nicholas Senn High School', Decimal('48.000000')),\n",
" ('Nicholson Technology Academy', Decimal('48.000000')),\n",
" ('Richard Edwards Elementary School', Decimal('48.000000')),\n",
" ('Robert Nathaniel Dett Elementary School', Decimal('48.000000')),\n",
" ('Tarkington School of Excellence Elementary School', Decimal('48.000000')),\n",
" ('William C Reavis Math & Science Specialty Elementary School', Decimal('48.000000')),\n",
" ('Arthur Dixon Elementary School', Decimal('47.000000')),\n",
" ('DeWitt Clinton Elementary School', Decimal('47.000000')),\n",
" ('Edward Beasley Elementary Magnet Academic Center', Decimal('47.000000')),\n",
" ('William E B Dubois Elementary School', Decimal('47.000000')),\n",
" ('William H King Elementary School', Decimal('47.000000')),\n",
" ('Alice L Barnard Computer Math & Science Center Elementary School', Decimal('46.000000')),\n",
" ('Benito Juarez Community Academy High School', Decimal('46.000000')),\n",
" ('Dunne Technology Academy', Decimal('46.000000')),\n",
" ('Dvorak Technology Academy', Decimal('46.000000')),\n",
" ('Frank I Bennett Elementary School', Decimal('46.000000')),\n",
" ('Frank W Gunsaulus Elementary Scholastic Academy', Decimal('46.000000')),\n",
" ('George Washington High School', Decimal('46.000000')),\n",
" ('Pershing West Middle School', Decimal('46.000000')),\n",
" ('Ravenswood Elementary School', Decimal('46.000000')),\n",
" ('Robert Fulton Elementary School', Decimal('46.000000')),\n",
" ('Theophilus Schmid Elementary School', Decimal('46.000000')),\n",
" ('Ambrose Plamondon Elementary School', Decimal('45.000000')),\n",
" ('Beulah Shoesmith Elementary School', Decimal('45.000000')),\n",
" ('Crispus Attucks Elementary School', Decimal('45.000000')),\n",
" ('Henry R Clissold Elementary School', Decimal('45.000000')),\n",
" ('James Monroe Elementary School', Decimal('45.000000')),\n",
" ('John Whistler Elementary School', Decimal('45.000000')),\n",
" ('Little Village Elementary School', Decimal('45.000000')),\n",
" ('Manuel Perez Elementary School', Decimal('45.000000')),\n",
" ('Patrick Henry Elementary School', Decimal('45.000000')),\n",
" ('TEAM Englewood Community Academy High School', Decimal('45.000000')),\n",
" ('Charles Gates Dawes Elementary School', Decimal('44.000000')),\n",
" ('Elaine O Goodlow Elementary Magnet School', Decimal('44.000000')),\n",
" ('Eli Whitney Elementary School', Decimal('44.000000')),\n",
" ('Everett McKinley Dirksen Elementary School', Decimal('44.000000')),\n",
" ('Frederick A Douglass Academy High School', Decimal('44.000000')),\n",
" ('Gerald Delgado Kanoon Elementary Magnet School', Decimal('44.000000')),\n",
" ('Irvin C Mollison Elementary School', Decimal('44.000000')),\n",
" ('Jean D Lafayette Elementary School', Decimal('44.000000')),\n",
" ('John Hay Elementary Community Academy', Decimal('44.000000')),\n",
" ('John Milton Gregory Elementary School', Decimal('44.000000')),\n",
" ('Jonathan Y Scammon Elementary School', Decimal('44.000000')),\n",
" ('Richard J Oglesby Elementary School', Decimal('44.000000')),\n",
" ('Roberto Clemente Community Academy High School', Decimal('44.000000')),\n",
" ('Alessandro Volta Elementary School', Decimal('43.000000')),\n",
" ('David G Farragut Career Academy High School', Decimal('43.000000')),\n",
" ('George Manierre Elementary School', Decimal('43.000000')),\n",
" ('Greater Lawndale High School For Social Justice', Decimal('43.000000')),\n",
" ('Helge A Haugan Elementary School', Decimal('43.000000')),\n",
" ('Joseph Lovett Elementary School', Decimal('43.000000')),\n",
" ('Marie Sklodowska Curie Metropolitan High School', Decimal('43.000000')),\n",
" ('Martha Ruggles Elementary School', Decimal('43.000000')),\n",
" ('Nathan S Davis Elementary School', Decimal('43.000000')),\n",
" ('Pilsen Elementary Community Academy', Decimal('43.000000')),\n",
" ('Richard T Crane Technical Preparatory High School', Decimal('43.000000')),\n",
" ('Washington Irving Elementary School', Decimal('43.000000')),\n",
" ('Charles Evans Hughes Elementary School', Decimal('42.000000')),\n",
" ('Daniel R Cameron Elementary School', Decimal('42.000000')),\n",
" ('Eugene Field Elementary School', Decimal('42.000000')),\n",
" ('Gurdon S Hubbard High School', Decimal('42.000000')),\n",
" ('Horatio May Elementary Community Academy', Decimal('42.000000')),\n",
" ('Jane A Neil Elementary School', Decimal('42.000000')),\n",
" ('John F Eberhart Elementary School', Decimal('42.000000')),\n",
" ('John Foster Dulles Elementary School', Decimal('42.000000')),\n",
" ('Lionel Hampton Fine & Performing Arts Elementary School', Decimal('42.000000')),\n",
" ('Louis Armstrong Math & Science Elementary School', Decimal('42.000000')),\n",
" ('North-Grand High School', Decimal('42.000000')),\n",
" ('Richard Yates Elementary School', Decimal('42.000000')),\n",
" ('Telpochcalli Elementary School', Decimal('42.000000')),\n",
" ('Theodore Roosevelt High School', Decimal('42.000000')),\n",
" ('VOISE Academy High School', Decimal('42.000000')),\n",
" ('Bronzeville Scholastic Academy High School', Decimal('41.000000')),\n",
" ('Charles Sumner Math & Science Community Acad Elementary School', Decimal('41.000000')),\n",
" ('Dewey Elementary Academy of Fine Arts', Decimal('41.000000')),\n",
" ('Henry H Nash Elementary School', Decimal('41.000000')),\n",
" ('Manley Career Academy High School', Decimal('41.000000')),\n",
" ('Marine Military Math and Science Academy', Decimal('41.000000')),\n",
" ('Theodore Herzl Elementary School', Decimal('41.000000')),\n",
" ('Wolfgang A Mozart Elementary School', Decimal('41.000000')),\n",
" ('Charles G Hammond Elementary School', Decimal('40.000000')),\n",
" ('Ludwig Van Beethoven Elementary School', Decimal('40.000000')),\n",
" ('Martin A Ryerson Elementary School', Decimal('40.000000')),\n",
" ('Morgan Park High School', Decimal('40.000000')),\n",
" ('William H Seward Communication Arts Academy Elementary School', Decimal('40.000000')),\n",
" ('Betsy Ross Elementary School', Decimal('39.000000')),\n",
" ('Daniel J Corkery Elementary School', Decimal('39.000000')),\n",
" ('George Rogers Clark Elementary School', Decimal('39.000000')),\n",
" ('Ira F Aldridge Elementary School', Decimal('39.000000')),\n",
" ('James Madison Elementary School', Decimal('39.000000')),\n",
" ('James Russell Lowell Elementary School', Decimal('39.000000')),\n",
" ('Stephen F Gale Elementary Community Academy', Decimal('39.000000')),\n",
" ('Thurgood Marshall Middle School', Decimal('39.000000')),\n",
" ('Ames Middle School', Decimal('38.000000')),\n",
" ('Austin Business and Entrepreneurship Academy High School', Decimal('38.000000')),\n",
" ('Austin Polytechnical Academy High School', Decimal('38.000000')),\n",
" ('Edward C Delano Elementary School', Decimal('38.000000')),\n",
" ('Francis Parkman Elementary School', Decimal('38.000000')),\n",
" ('Henry Clay Elementary School', Decimal('38.000000')),\n",
" ('James Shields Elementary School', Decimal('38.000000')),\n",
" ('Jesse Sherwood Elementary School', Decimal('38.000000')),\n",
" ('Mahalia Jackson Elementary School', Decimal('38.000000')),\n",
" ('Rachel Carson Elementary School', Decimal('38.000000')),\n",
" ('Alfred Nobel Elementary School', Decimal('37.000000')),\n",
" ('Francis Scott Key Elementary School', Decimal('37.000000')),\n",
" ('John M Smyth Elementary School', Decimal('37.000000')),\n",
" ('Joseph Stockton Elementary School', Decimal('37.000000')),\n",
" ('Luther Burbank Elementary School', Decimal('37.000000')),\n",
" ('Matthew A Henson Elementary School', Decimal('37.000000')),\n",
" ('Robert Emmet Elementary School', Decimal('37.000000')),\n",
" ('Roswell B Mason Elementary School', Decimal('37.000000')),\n",
" ('Arthur A Libby Elementary School', Decimal('36.000000')),\n",
" ('Benjamin Banneker Elementary School', Decimal('36.000000')),\n",
" ('Charles Kozminski Elementary Community Academy', Decimal('36.000000')),\n",
" ('Christian Fenger Academy High School', Decimal('36.000000')),\n",
" ('Claremont Academy Elementary School', Decimal('36.000000')),\n",
" ('Esmond Elementary School', Decimal('36.000000')),\n",
" ('Joseph Jungman Elementary School', Decimal('36.000000')),\n",
" ('Ninos Heroes Elementary Academic Center', Decimal('36.000000')),\n",
" ('Paul Revere Elementary School', Decimal('36.000000')),\n",
" ('Phillip D Armour Elementary School', Decimal('36.000000')),\n",
" ('Rosario Castellanos Elementary School', Decimal('36.000000')),\n",
" ('Thomas Kelly High School', Decimal('36.000000')),\n",
" ('William H Brown Elementary School', Decimal('36.000000')),\n",
" ('Carroll-Rosenwald Specialty Elementary School', Decimal('35.000000')),\n",
" ('Florence Nightingale Elementary School', Decimal('35.000000')),\n",
" ('Granville T Woods Math & Science Academy Elementary School', Decimal('35.000000')),\n",
" ('Hanson Park Elementary School', Decimal('35.000000')),\n",
" ('Jensen Elementary Scholastic Academy', Decimal('35.000000')),\n",
" ('John Barry Elementary School', Decimal('35.000000')),\n",
" ('Michael Faraday Elementary School', Decimal('35.000000')),\n",
" ('Oscar DePriest Elementary School', Decimal('35.000000')),\n",
" ('Scott Joplin Elementary School', Decimal('35.000000')),\n",
" ('Sir Miles Davis Magnet Elementary Academy', Decimal('35.000000')),\n",
" ('Spencer Technology Academy', Decimal('35.000000')),\n",
" ('Douglas Taylor Elementary School', Decimal('34.000000')),\n",
" ('Edward Tilden Career Community Academy High School', Decimal('34.000000')),\n",
" ('Fort Dearborn Elementary School', Decimal('34.000000')),\n",
" ('Irene C. Hernandez Middle School for the Advancement of Science', Decimal('34.000000')),\n",
" ('Northwest Middle School', Decimal('34.000000')),\n",
" ('Samuel Gompers Fine Arts Options Elementary School', Decimal('34.000000')),\n",
" ('Thomas Chalmers Specialty Elementary School', Decimal('34.000000')),\n",
" ('William H Ryder Math & Science Specialty Elementary School', Decimal('34.000000')),\n",
" ('Arna Wendell Bontemps Elementary School', Decimal('33.000000')),\n",
" ('Edward A Bouchet Math & Science Academy Elementary School', Decimal('33.000000')),\n",
" ('George H Corliss High School', Decimal('33.000000')),\n",
" ('Henry O Tanner Elementary School', Decimal('33.000000')),\n",
" ('John H Hamline Elementary School', Decimal('33.000000')),\n",
" ('Joseph Warren Elementary School', Decimal('33.000000')),\n",
" ('Leif Ericson Elementary Scholastic Academy', Decimal('33.000000')),\n",
" ('Phobe Apperson Hearst Elementary School', Decimal('33.000000')),\n",
" ('Thomas A Hendricks Elementary Community Academy', Decimal('33.000000')),\n",
" ('Anthony Overton Elementary School', Decimal('32.000000')),\n",
" ('Avalon Park Elementary School', Decimal('32.000000')),\n",
" ('Charles H Wacker Elementary School', Decimal('32.000000')),\n",
" ('Chicago Military Academy High School', Decimal('32.000000')),\n",
" ('James N Thorp Elementary School', Decimal('32.000000')),\n",
" ('John Charles Haines Elementary School', Decimal('32.000000')),\n",
" ('John D Shoop Math-Science Technical Academy Elementary School', Decimal('32.000000')),\n",
" ('Joseph E Gary Elementary School', Decimal('32.000000')),\n",
" ('Kelvyn Park High School', Decimal('32.000000')),\n",
" ('Wendell E Green Elementary School', Decimal('32.000000')),\n",
" ('William T Sherman Elementary School', Decimal('32.000000')),\n",
" ('Alexander von Humboldt Elementary School', Decimal('31.000000')),\n",
" ('Anna R. Langford Community Academy', Decimal('31.000000')),\n",
" ('Ella Flagg Young Elementary School', Decimal('31.000000')),\n",
" ('Emmett Louis Till Math and Science Academy', Decimal('31.000000')),\n",
" ('Fairfield Elementary Academy', Decimal('31.000000')),\n",
" ('Hope College Preparatory High School', Decimal('31.000000')),\n",
" ('Ignance Paderewski Elementary Learning Academy', Decimal('31.000000')),\n",
" ('Kate S Buckingham Special Education Center', Decimal('31.000000')),\n",
" ('Mount Vernon Elementary School', Decimal('31.000000')),\n",
" ('Myra Bradwell Communications Arts & Sciences Elementary School', Decimal('31.000000')),\n",
" ('Ronald Brown Elementary Community Academy', Decimal('31.000000')),\n",
" ('Ronald E McNair Elementary School', Decimal('31.000000')),\n",
" ('Daniel S Wentworth Elementary School', Decimal('30.000000')),\n",
" ('Edward K Ellington Elementary School', Decimal('30.000000')),\n",
" ('Ellen H Richards Career Academy High School', Decimal('30.000000')),\n",
" ('Enrico Fermi Elementary School', Decimal('30.000000')),\n",
" ('Francis W Parker Elementary Community Academy', Decimal('30.000000')),\n",
" ('James R Doolittle Jr Elementary School', Decimal('30.000000')),\n",
" ('Milton Brunson Math & Science Specialty Elementary School', Decimal('30.000000')),\n",
" ('Oliver S Westcott Elementary School', Decimal('30.000000')),\n",
" ('Roger C Sullivan High School', Decimal('30.000000')),\n",
" ('Simon Guggenheim Elementary School', Decimal('30.000000')),\n",
" ('Elihu Yale Elementary School', Decimal('29.000000')),\n",
" ('Fernwood Elementary School', Decimal('29.000000')),\n",
" ('Helen M Hefferan Elementary School', Decimal('29.000000')),\n",
" ('Hyde Park Academy High School', Decimal('29.000000')),\n",
" ('Paul Laurence Dunbar Career Academy High School', Decimal('29.000000')),\n",
" ('Paul Robeson High School', Decimal('29.000000')),\n",
" ('Richard J Daley Elementary Academy', Decimal('29.000000')),\n",
" ('Walter Reed Elementary School', Decimal('29.000000')),\n",
" ('West Park Elementary Academy', Decimal('29.000000')),\n",
" ('Alex Haley Elementary Academy', Decimal('28.000000')),\n",
" ('Donald Morrill Math & Science Elementary School', Decimal('28.000000')),\n",
" ('Garrett A Morgan Elementary School', Decimal('28.000000')),\n",
" ('Harold Washington Elementary School', Decimal('28.000000')),\n",
" ('Harriet Beecher Stowe Elementary School', Decimal('28.000000')),\n",
" ('Horace Mann Elementary School', Decimal('28.000000')),\n",
" ('Langston Hughes Elementary School', Decimal('28.000000')),\n",
" ('Moses Montefiore Special Elementary School', Decimal('28.000000')),\n",
" ('Park Manor Elementary School', Decimal('28.000000')),\n",
" ('Percy L Julian High School', Decimal('28.000000')),\n",
" ('Perkins Bass Elementary School', Decimal('28.000000')),\n",
" ('Arnold Mireles Elementary Academy', Decimal('27.000000')),\n",
" ('Benjamin E Mays Elementary Academy', Decimal('27.000000')),\n",
" ('Brian Piccolo Elementary Specialty School', Decimal('27.000000')),\n",
" ('Chicago Vocational Career Academy High School', Decimal('27.000000')),\n",
" ('Crown Community Academy of Fine Arts Center Elementary School', Decimal('27.000000')),\n",
" ('Dyett High School', Decimal('27.000000')),\n",
" ('Edward White Elementary Career Academy', Decimal('27.000000')),\n",
" ('Frank L Gillespie Elementary School', Decimal('27.000000')),\n",
" ('Medgar Evers Elementary School', Decimal('27.000000')),\n",
" ('William K New Sullivan Elementary School', Decimal('27.000000')),\n",
" ('Carter G Woodson South Elementary School', Decimal('26.000000')),\n",
" ('Charles P Steinmetz Academic Centre High School', Decimal('26.000000')),\n",
" ('Edwin G Foreman High School', Decimal('26.000000')),\n",
" ('Guglielmo Marconi Elementary Community Academy', Decimal('26.000000')),\n",
" ('John T Pirie Fine Arts & Academic Center Elementary School', Decimal('26.000000')),\n",
" ('Charles P Caldwell Academy of Math & Science Elementary School', Decimal('25.000000')),\n",
" ('Clara Barton Elementary School', Decimal('25.000000')),\n",
" ('George Washington Carver Primary School', Decimal('25.000000')),\n",
" ('Walter Q Gresham Elementary School', Decimal('25.000000')),\n",
" ('Charles W Earle Elementary School', Decimal('24.000000')),\n",
" ('Amos Alonzo Stagg Elementary School', Decimal('23.000000')),\n",
" ('Austin O Sexton Elementary School', Decimal('23.000000')),\n",
" ('Francis M McKay Elementary School', Decimal('23.000000')),\n",
" ('George W Curtis Elementary School', Decimal('23.000000')),\n",
" ('West Pullman Elementary School', Decimal('23.000000')),\n",
" ('Edward Coles Elementary Language Academy', Decimal('22.000000')),\n",
" ('James Hedges Elementary School', Decimal('22.000000')),\n",
" ('Melville W Fuller Elementary School', Decimal('22.000000')),\n",
" ('Wendell Smith Elementary School', Decimal('22.000000')),\n",
" ('William Rainey Harper High School', Decimal('22.000000')),\n",
" ('Leslie Lewis Elementary School', Decimal('21.000000')),\n",
" ('Oliver Wendell Holmes Elementary School', Decimal('21.000000')),\n",
" ('Charles S Brownell Elementary School', Decimal('20.000000')),\n",
" ('Florence B Price Elementary School', Decimal('20.000000')),\n",
" ('William J Bogan High School', Decimal('20.000000')),\n",
" ('Alfred David Kohn Elementary School', Decimal('19.000000')),\n",
" ('Dumas Technology Academy', Decimal('19.000000')),\n",
" ('Robert H Lawrence Elementary School', Decimal('19.000000')),\n",
" ('Orville T Bright Elementary School', Decimal('18.000000')),\n",
" ('William A Hinton Elementary School', Decimal('18.000000')),\n",
" (\"Isabelle C O'Keeffe Elementary School\", Decimal('17.000000')),\n",
" ('New Millennium High School of Health at Bowen', Decimal('17.000000')),\n",
" ('Songhai Elementary Learning Institute', Decimal('17.000000')),\n",
" ('Charles R Henderson Elementary School', Decimal('16.000000')),\n",
" ('Frederick Funston Elementary School', Decimal('16.000000')),\n",
" ('Asa Philip Randolph Elementary School', Decimal('15.000000')),\n",
" ('Marquette Elementary School', Decimal('15.000000')),\n",
" ('Mildred I Lavizzo Elementary School', Decimal('15.000000')),\n",
" ('Countee Cullen Elementary School', Decimal('14.000000')),\n",
" ('Gage Park High School', Decimal('14.000000')),\n",
" ('Emil G Hirsch Metropolitan High School', Decimal('13.000000')),\n",
" ('John Fiske Elementary School', Decimal('13.000000')),\n",
" ('William W Carter Elementary School', Decimal('13.000000')),\n",
" ('Foster Park Elementary School', Decimal('11.000000')),\n",
" ('George W Tilton Elementary School', Decimal('6.000000')),\n",
" (\"Luke O'Toole Elementary School\", Decimal('5.000000')),\n",
" ('Edmond Burke Elementary School', Decimal('1.000000')),\n",
" ('Ariel Elementary Community Academy', None),\n",
" ('Arthur R Ashe Elementary School', None),\n",
" ('Barbara Vick Early Childhood & Family Center', None),\n",
" ('Blair Early Childhood Center', None),\n",
" ('Cyrus H McCormick Elementary School', None),\n",
" ('Daniel C Beard Elementary School', None),\n",
" ('DeVry University Advantage Academy High School', None),\n",
" ('Disney II Magnet School', None),\n",
" ('Dr Martin Luther King Jr College Prep High School', None),\n",
" ('Dr Jorge Prieto Math and Science', None),\n",
" ('Edward Everett Elementary School', None),\n",
" ('Enrico Tonti Elementary School', None),\n",
" ('Franz Peter Schubert Elementary School', None),\n",
" ('Frederick Stock Elementary School', None),\n",
" ('George Leland Elementary School', None),\n",
" ('Henry D Lloyd Elementary School', None),\n",
" ('High School of Leadership at South Shore', None),\n",
" ('Jackie Robinson Elementary School', None),\n",
" ('James Wadsworth Elementary School', None),\n",
" ('Jesse Owens Elementary Community Academy', None),\n",
" ('John J Pershing Elementary Humanities Magnet', None),\n",
" ('John M Harlan Community Academy High School', None),\n",
" ('John W Cook Elementary School', None),\n",
" ('Josefa Ortiz De Dominguez Elementary School', None),\n",
" ('Joyce Kilmer Elementary School', None),\n",
" ('Laura S Ward Elementary School', None),\n",
" ('Lawndale Elementary Community Academy', None),\n",
" ('Lazaro Cardenas Elementary School', None),\n",
" ('Louisa May Alcott Elementary School', None),\n",
" ('Mary E McDowell Elementary School', None),\n",
" ('Michele Clark Academic Prep Magnet High School', None),\n",
" ('Nathanael Greene Elementary School', None),\n",
" ('New Field Elementary School', None),\n",
" ('Orr Academy High School', None),\n",
" ('Pablo Casals Elementary School', None),\n",
" ('Parkside Elementary Community Academy', None),\n",
" ('Peter Cooper Elementary Dual Language Academy', None),\n",
" ('Ralph H Metcalfe Elementary Community Academy', None),\n",
" ('Sharon Christa McAuliffe Elementary School', None),\n",
" ('Skinner North', None),\n",
" ('Socorro Sandoval Elementary School', None),\n",
" ('South Shore Fine Arts Academy', None),\n",
" ('Southside Occupational Academy High School', None),\n",
" ('Suder Montessori Magnet Elementary School', None),\n",
" ('Thomas J Higgins Elementary Community Academy', None),\n",
" ('Velma F Thomas Early Childhood Center', None),\n",
" ('Walt Disney Magnet Elementary School', None),\n",
" ('Walter S Christopher Elementary School', None),\n",
" ('Wendell Phillips Academy High School', None),\n",
" ('William B Ogden Elementary School', None),\n",
" ('William G Hibbard Elementary School', None),\n",
" ('Williams Multiplex Elementary School', None),\n",
" ('Wilma Rudolph Elementary Learning Center', None)]"
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select NAME_OF_SCHOOL,AVG(SAFETY_SCORE) as AVG_SAFETY_SCORE from CHICAGO_PUBLIC_SCHOOLS \\\n",
" Group by NAME_OF_SCHOOL order by AVG_SAFETY_SCORE desc nulls last"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 7\n",
"\n",
"##### Problem 7: List 5 community areas with highest % of households below poverty line."
]
},
{
"cell_type": "code",
"execution_count": 55,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>community_area_name</th>\n",
" <th>percent_households_below_poverty</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>Riverdale</td>\n",
" <td>56.5</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Fuller Park</td>\n",
" <td>51.2</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Englewood</td>\n",
" <td>46.6</td>\n",
" </tr>\n",
" <tr>\n",
" <td>North Lawndale</td>\n",
" <td>43.1</td>\n",
" </tr>\n",
" <tr>\n",
" <td>East Garfield Park</td>\n",
" <td>42.4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('Riverdale', Decimal('56.5')),\n",
" ('Fuller Park', Decimal('51.2')),\n",
" ('Englewood', Decimal('46.6')),\n",
" ('North Lawndale', Decimal('43.1')),\n",
" ('East Garfield Park', Decimal('42.4'))]"
]
},
"execution_count": 55,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select COMMUNITY_AREA_NAME, PERCENT_HOUSEHOLDS_BELOW_POVERTY \\\n",
" from CENSUS_DATA \\\n",
" order by PERCENT_HOUSEHOLDS_BELOW_POVERTY desc fetch first 5 rows only"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 8\n",
"\n",
"##### Problem 8: Which community area(number) is most crime prone?"
]
},
{
"cell_type": "code",
"execution_count": 69,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>community_area_number</th>\n",
" <th>crime_num</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>25</td>\n",
" <td>43</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[(25, Decimal('43'))]"
]
},
"execution_count": 69,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select COMMUNITY_AREA_NUMBER, count(COMMUNITY_AREA_NUMBER) as CRIME_NUM \\\n",
" from CHICAGO_CRIME_DATA \\\n",
" group by COMMUNITY_AREA_NUMBER \\\n",
" order by CRIME_NUM desc nulls last LIMIT 1"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 9\n",
"\n",
"##### Problem 9: Use a sub-query to find the name of the community area with highest hardship index."
]
},
{
"cell_type": "code",
"execution_count": 70,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>community_area_name</th>\n",
" <th>hardship_index</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>Riverdale</td>\n",
" <td>98</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[('Riverdale', 98)]"
]
},
"execution_count": 70,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select COMMUNITY_AREA_NAME, HARDSHIP_INDEX \\\n",
" from CENSUS_DATA \\\n",
" where HARDSHIP_INDEX in (select MAX(HARDSHIP_INDEX) from CENSUS_DATA)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problem 10\n",
"\n",
"##### Problem 10: Use a sub-query to determine the Community Area Name with most number of crimes?"
]
},
{
"cell_type": "code",
"execution_count": 154,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * ibm_db_sa://svs59742:***@dashdb-txn-sbox-yp-dal09-04.services.dal.bluemix.net:50000/BLUDB\n",
"Done.\n"
]
},
{
"data": {
"text/html": [
"<table>\n",
" <thead>\n",
" <tr>\n",
" <th>MAX</th>\n",
" <th>community_area_name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Rogers Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Ridge</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Uptown</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Lincoln Square</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>North Center</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Lake View</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Lincoln Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Near North Side</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Edison Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Norwood Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Jefferson Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Forest Glen</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>North Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Albany Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Portage Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Irving Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Dunning</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Montclaire</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Belmont Cragin</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Hermosa</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Avondale</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Logan Square</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Humboldt park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Town</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Austin</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Garfield Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>East Garfield Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Near West Side</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>North Lawndale</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>South Lawndale</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Lower West Side</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Loop</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Near South Side</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Armour Square</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Douglas</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Oakland</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Fuller Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Grand Boulevard</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Kenwood</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Washington Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Hyde Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Woodlawn</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>South Shore</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Chatham</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Avalon Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>South Chicago</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Burnside</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Calumet Heights</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Roseland</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Pullman</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>South Deering</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>East Side</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Pullman</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Riverdale</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Hegewisch</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Garfield Ridge</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Archer Heights</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Brighton Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>McKinley Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Bridgeport</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>New City</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Elsdon</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Gage Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Clearing</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Lawn</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Chicago Lawn</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>West Englewood</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Englewood</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Greater Grand Crossing</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Ashburn</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Auburn Gresham</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Beverly</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Washington Height</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Mount Greenwood</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Morgan Park</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>O&#x27;Hare</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Edgewater</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>CHICAGO</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"text/plain": [
"[(Decimal('43'), 'Rogers Park'),\n",
" (Decimal('43'), 'West Ridge'),\n",
" (Decimal('43'), 'Uptown'),\n",
" (Decimal('43'), 'Lincoln Square'),\n",
" (Decimal('43'), 'North Center'),\n",
" (Decimal('43'), 'Lake View'),\n",
" (Decimal('43'), 'Lincoln Park'),\n",
" (Decimal('43'), 'Near North Side'),\n",
" (Decimal('43'), 'Edison Park'),\n",
" (Decimal('43'), 'Norwood Park'),\n",
" (Decimal('43'), 'Jefferson Park'),\n",
" (Decimal('43'), 'Forest Glen'),\n",
" (Decimal('43'), 'North Park'),\n",
" (Decimal('43'), 'Albany Park'),\n",
" (Decimal('43'), 'Portage Park'),\n",
" (Decimal('43'), 'Irving Park'),\n",
" (Decimal('43'), 'Dunning'),\n",
" (Decimal('43'), 'Montclaire'),\n",
" (Decimal('43'), 'Belmont Cragin'),\n",
" (Decimal('43'), 'Hermosa'),\n",
" (Decimal('43'), 'Avondale'),\n",
" (Decimal('43'), 'Logan Square'),\n",
" (Decimal('43'), 'Humboldt park'),\n",
" (Decimal('43'), 'West Town'),\n",
" (Decimal('43'), 'Austin'),\n",
" (Decimal('43'), 'West Garfield Park'),\n",
" (Decimal('43'), 'East Garfield Park'),\n",
" (Decimal('43'), 'Near West Side'),\n",
" (Decimal('43'), 'North Lawndale'),\n",
" (Decimal('43'), 'South Lawndale'),\n",
" (Decimal('43'), 'Lower West Side'),\n",
" (Decimal('43'), 'Loop'),\n",
" (Decimal('43'), 'Near South Side'),\n",
" (Decimal('43'), 'Armour Square'),\n",
" (Decimal('43'), 'Douglas'),\n",
" (Decimal('43'), 'Oakland'),\n",
" (Decimal('43'), 'Fuller Park'),\n",
" (Decimal('43'), 'Grand Boulevard'),\n",
" (Decimal('43'), 'Kenwood'),\n",
" (Decimal('43'), 'Washington Park'),\n",
" (Decimal('43'), 'Hyde Park'),\n",
" (Decimal('43'), 'Woodlawn'),\n",
" (Decimal('43'), 'South Shore'),\n",
" (Decimal('43'), 'Chatham'),\n",
" (Decimal('43'), 'Avalon Park'),\n",
" (Decimal('43'), 'South Chicago'),\n",
" (Decimal('43'), 'Burnside'),\n",
" (Decimal('43'), 'Calumet Heights'),\n",
" (Decimal('43'), 'Roseland'),\n",
" (Decimal('43'), 'Pullman'),\n",
" (Decimal('43'), 'South Deering'),\n",
" (Decimal('43'), 'East Side'),\n",
" (Decimal('43'), 'West Pullman'),\n",
" (Decimal('43'), 'Riverdale'),\n",
" (Decimal('43'), 'Hegewisch'),\n",
" (Decimal('43'), 'Garfield Ridge'),\n",
" (Decimal('43'), 'Archer Heights'),\n",
" (Decimal('43'), 'Brighton Park'),\n",
" (Decimal('43'), 'McKinley Park'),\n",
" (Decimal('43'), 'Bridgeport'),\n",
" (Decimal('43'), 'New City'),\n",
" (Decimal('43'), 'West Elsdon'),\n",
" (Decimal('43'), 'Gage Park'),\n",
" (Decimal('43'), 'Clearing'),\n",
" (Decimal('43'), 'West Lawn'),\n",
" (Decimal('43'), 'Chicago Lawn'),\n",
" (Decimal('43'), 'West Englewood'),\n",
" (Decimal('43'), 'Englewood'),\n",
" (Decimal('43'), 'Greater Grand Crossing'),\n",
" (Decimal('43'), 'Ashburn'),\n",
" (Decimal('43'), 'Auburn Gresham'),\n",
" (Decimal('43'), 'Beverly'),\n",
" (Decimal('43'), 'Washington Height'),\n",
" (Decimal('43'), 'Mount Greenwood'),\n",
" (Decimal('43'), 'Morgan Park'),\n",
" (Decimal('43'), \"O'Hare\"),\n",
" (Decimal('43'), 'Edgewater'),\n",
" (Decimal('43'), 'CHICAGO')]"
]
},
"execution_count": 154,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql select m.max, c.COMMUNITY_AREA_NAME \\\n",
" from (SELECT MAX(numcount) as max \\\n",
" FROM (SELECT COUNT(COMMUNITY_AREA_NUMBER) numcount \\\n",
" FROM CHICAGO_CRIME_DATA \\\n",
" GROUP BY COMMUNITY_AREA_NUMBER)) as m, CENSUS_DATA as c"
]
},
{
"cell_type": "markdown",
"metadata": {
"tags": []
},
"source": [
"## Author\n",
"\n",
"Rav Ahuja\n",
"\n",
"## Assignment Representer\n",
"<a href=\"https://github.com/IreneJeong\" target=\"_blank\">Irene Jeong</a>\n",
"\n",
"## Change Log\n",
"\n",
"| Date (YYYY-MM-DD) | Version | Changed By | Change Description |\n",
"| ----------------- | ------- | ----------------- | ----------------------------------------- |\n",
"| 2021-05-07 | N/A | Irene Jeong | Updated the assignment answer sheet |\n",
"| 2021-03-09 | 1.1 | Rav Ahuja | Updated intro, dataset links, etc. |\n",
"| 2021-01-14 | 1.0 | Rose Malcolm | Updated |\n",
"\n",
"<hr>\n",
"\n",
"## <h3 align=\"center\"> © IBM Corporation 2020. All rights reserved. <h3/>\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"celltoolbar": "Raw Cell Format",
"kernelspec": {
"display_name": "Python",
"language": "python",
"name": "conda-env-python-py"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.13"
},
"widgets": {
"state": {},
"version": "1.1.2"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment