Baselight
Sign In

IBM Data Science Chicago Assignment

A project with data from Chicago's education, census and crime

@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment

Chicagopublicschools
@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment.chicagopublicschools

  • 169.46 KB
  • 566 rows
  • 78 columns
school_id

School ID

name_of_school

NAME OF SCHOOL

elementary_middle_or_high_school

Elementary, Middle, Or High School

street_address

Street Address

city

City

state

State

zip_code

ZIP Code

phone_number

Phone Number

link

Link

network_manager

Network Manager

collaborative_name

Collaborative Name

adequate_yearly_progress_made

Adequate Yearly Progress Made

track_schedule

Track Schedule

cps_performance_policy_status

CPS Performance Policy Status

cps_performance_policy_level

CPS Performance Policy Level

healthy_school_certified

HEALTHY SCHOOL CERTIFIED

safety_icon

Safety Icon

safety_score

SAFETY SCORE

family_involvement_icon

Family Involvement Icon

family_involvement_score

Family Involvement Score

environment_icon

Environment Icon

environment_score

Environment Score

instruction_icon

Instruction Icon

instruction_score

Instruction Score

leaders_icon

Leaders Icon

leaders_score

Leaders Score

teachers_icon

Teachers Icon

teachers_score

Teachers Score

parent_engagement_icon

Parent Engagement Icon

parent_engagement_score

Parent Engagement Score

parent_environment_icon

Parent Environment Icon

parent_environment_score

Parent Environment Score

average_student_attendance

AVERAGE STUDENT ATTENDANCE

rate_of_misconducts_per_100_students

Rate Of Misconducts, Per 100 Students

average_teacher_attendance

Average Teacher Attendance

individualized_education_program_compliance_rate

Individualized Education Program Compliance Rate

pk_2_literacy

Pk 2 Literacy,

pk_2_math

Pk 2 Math,

gr3_5_grade_level_math

Gr3–5 Grade Level Math,

gr3_5_grade_level_read

Gr3–5 Grade Level Read,

gr3_5_keep_pace_read

Gr3–5 Keep Pace Read,

gr3_5_keep_pace_math

Gr3–5 Keep Pace Math,

gr6_8_grade_level_math

Gr6–8 Grade Level Math,

gr6_8_grade_level_read

Gr6–8 Grade Level Read,

gr6_8_keep_pace_math

Gr6–8 Keep Pace Math

gr6_8_keep_pace_read

Gr6–8 Keep Pace Read,

gr_8_explore_math

Gr 8 Explore Math,

gr_8_explore_read

Gr 8 Explore Read,

isat_exceeding_math

ISAT Exceeding Math,

isat_exceeding_reading

ISAT Exceeding Reading,

isat_value_add_math

ISAT Value Add Math

isat_value_add_read

ISAT Value Add Read

isat_value_add_color_math

ISAT Value Add Color Math

isat_value_add_color_read

ISAT Value Add Color Read

students_taking_algebra

Students Taking, Algebra,

students_passing_algebra

Students Passing, Algebra,

n_9th_grade_explore_2009

9th Grade EXPLORE (2009)

n_9th_grade_explore_2010

9th Grade EXPLORE (2010)

n_10th_grade_plan_2009

10th Grade PLAN (2009)

n_10th_grade_plan_2010

10th Grade PLAN (2010)

net_change_explore_and_plan

Net Change EXPLORE And PLAN

n_11th_grade_average_act_2011

11th Grade Average ACT (2011)

net_change_plan_and_act

Net Change PLAN And ACT

college_eligibility

College Eligibility,

graduation_rate

Graduation Rate,

college_enrollment_rate

College Enrollment Rate,

college_enrollment

COLLEGE ENROLLMENT

general_services_route

General Services Route

freshman_on_track_rate

Freshman On Track Rate,

x_coordinate

X COORDINATE

y_coordinate

Y COORDINATE

latitude

Latitude

longitude

Longitude

community_area_number

COMMUNITY AREA NUMBER

community_area_name

COMMUNITY AREA NAME

ward

Ward

police_district

Police District

location

Location

610038Abraham Lincoln Elementary SchoolES615 W Kemper PlChicagoIL60614(773) 534-5720http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610038.pdfFullerton Elementary NetworkNORTH-NORTHWEST SIDE COLLABORATIVENoStandardNot on ProbationLevel 1YesVery Strong99Very Strong99Strong74Strong66Weak65Strong70Strong56Average4796.00%296.40%95.80%80.143.389.684.960.762.681.985.25262.466.377.969.764.40.20.9YellowGreen67.154.5NDANDANDANDANDANDANDANDANDANDA81333NDA1171699.4581915829.42841.92449696-87.644521637LINCOLN PARK4318(41.92449696, -87.64452163)
610281Adam Clayton Powell Paideia Community Academy Elementary SchoolES7511 S South Shore DrChicagoIL60649(773) 535-6650http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610281.pdfSkyway Elementary NetworkSOUTH SIDE COLLABORATIVENoTrack_ENot on ProbationLevel 1NoAverage54Strong66Strong74Very Strong84Weak63Strong76Weak46Average5095.60%15.795.30%100.00%62.451.721.915.12942.838.527.444.842.714.134.416.816.50.71.4GreenGreen17.227.3NDANDANDANDANDANDANDANDANDANDA52146NDA1196129.9851856209.46641.76032435-87.5567362743SOUTH SHORE74(41.76032435, -87.55673627)
610185Adlai E Stevenson Elementary SchoolES8010 S Kostner AveChicagoIL60652(773) 535-2280http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610185.pdfMidway Elementary NetworkSOUTHWEST SIDE COLLABORATIVENoStandardNot on ProbationLevel 2NoStrong61NDANDAAverage50Weak36WeakNDANDANDAAverage47Weak4195.70%2.394.70%98.30%53.726.638.334.743.757.348.839.246.8447.521.918.315.5-0.9-1RedRedNDANDANDANDANDANDANDANDANDANDANDANDA132444NDA1148427.1651851012.21541.74711093-87.7317024870ASHBURN138(41.74711093, -87.73170248)
609993Agustin Lara Elementary AcademyES4619 S Wolcott AveChicagoIL60609(773) 535-4389http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609993.pdfPershing Elementary NetworkSOUTHWEST SIDE COLLABORATIVENoTrack_ENot on ProbationLevel 1NoAverage56Average44Average45Weak37Weak65Average48Average53Strong5895.50%10.495.80%100.00%76.9NDA2624.761.849.739.227.269.760.69.118.211.19.60.92.4GreenGreen42.925NDANDANDANDANDANDANDANDANDANDA55642NDA1164504.291873959.19941.8097569-87.672144661NEW CITY209(41.8097569, -87.6721446)
610513Air Force Academy High SchoolHS3630 S Wells StChicagoIL60609(773) 535-1590http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610513.pdfSouthwest Side High School NetworkSOUTHWEST SIDE COLLABORATIVENDAStandardNot on ProbationNot Enough DataYesAverage49Strong60Strong60Average55Weak45Average54Average53Average4993.30%15.696.90%100.00%NDANDANDANDANDANDANDANDANDANDANDANDANDANDANDANDA14.614.8NDA161.4NDANDANDANDANDA3024091.81175177.6221880745.12641.82814609-87.6327936934ARMOUR SQUARE119(41.82814609, -87.63279369)
610212Albany Park Multicultural AcademyMS4929 N Sawyer AveChicagoIL60625(773) 534-5108http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610212.pdfO'Hare Elementary NetworkNORTH-NORTHWEST SIDE COLLABORATIVEYesStandardNot on ProbationLevel 1NoStrong66Weak37Strong66Strong71Weak43Average50Weak46Average5197.00%2.396.90%100.00%NDANDANDANDANDANDA60.739.853.759.817.520.834.515.60.20.3YellowYellow29.250NDANDANDANDANDANDANDANDANDANDA26631NDA1153858.1961932691.89141.9711433-87.7096272514ALBANY PARK3917(41.9711433, -87.70962725)
609720Albert G Lane Technical High SchoolHS2501 W Addison StChicagoIL60618(773) 534-5400http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609720.pdfNorth-Northwest Side High School NetworkNORTH-NORTHWEST SIDE COLLABORATIVEYesStandardNot on ProbationLevel 1NoVery Strong88NDANDAStrong62Average52WeakNDANDANDANDANDANDANDA96.30%2.196.20%99.40%NDANDANDANDANDANDANDANDANDANDANDANDANDANDANDANDA19.119.519.920.1123.43.567.992.279.843683590.71158975.3921923791.70541.94661693-87.691056035NORTH CENTER4719(41.94661693, -87.69105603)
610342Albert R Sabin Elementary Magnet SchoolES2216 W Hirsch StChicagoIL60622(773) 534-4491http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610342.pdfFulton Elementary NetworkWEST SIDE COLLABORATIVENoStandardProbationLevel 3NoStrong67NDANDAWeak30Very Weak18WeakNDANDANDANDANDANDANDA94.70%28.195.00%100.00%56.3NDA33.533.549.549.527.439.335.544.42523.41812.8-1.80.1RedYellowNDANDANDANDANDANDANDANDANDANDANDANDA62035NDA1161265.2991909314.59241.90684338-87.6830425924WEST TOWN114(41.90684338, -87.68304259)
610524Alcott High School for the HumanitiesHS2957 N Hoyne AveChicagoIL60618(773) 534-5979http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610524.pdfNorth-Northwest Side High School NetworkNORTH-NORTHWEST SIDE COLLABORATIVENDAStandardNot on ProbationNot Enough DataNoStrong70NDANDAStrong67Average51WeakNDANDANDAStrong57Weak4392.70%7.196.90%100.00%NDANDANDANDANDANDANDANDANDANDANDANDANDANDANDANDA14.713.7NDA161.3NDANDANDANDANDA2323387.61161870.5561919857.4441.93576106-87.680524415NORTH CENTER119(41.93576106, -87.68052441)
610209Alessandro Volta Elementary SchoolES4950 N Avers AveChicagoIL60625(773) 534-5080http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610209.pdfO'Hare Elementary NetworkNORTH-NORTHWEST SIDE COLLABORATIVENoTrack_ENot on ProbationLevel 2NoAverage43Strong61Weak28Weak37Weak62Average56Average51Average5396.40%22.595.90%100.00%63.943.251.332.950.77052.531.359.857.616.524.719.914.20.3-0.4YellowYellow31.665.2NDANDANDANDANDANDANDANDANDANDA102331NDA1149774.0951932831.15141.97160605-87.7246413914ALBANY PARK3917(41.97160605, -87.72464139)

CREATE TABLE chicagopublicschools (
  "school_id" BIGINT,
  "name_of_school" VARCHAR,
  "elementary_middle_or_high_school" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "phone_number" VARCHAR,
  "link" VARCHAR,
  "network_manager" VARCHAR,
  "collaborative_name" VARCHAR,
  "adequate_yearly_progress_made" VARCHAR,
  "track_schedule" VARCHAR,
  "cps_performance_policy_status" VARCHAR,
  "cps_performance_policy_level" VARCHAR,
  "healthy_school_certified" VARCHAR,
  "safety_icon" VARCHAR,
  "safety_score" DOUBLE,
  "family_involvement_icon" VARCHAR,
  "family_involvement_score" VARCHAR,
  "environment_icon" VARCHAR,
  "environment_score" DOUBLE,
  "instruction_icon" VARCHAR,
  "instruction_score" DOUBLE,
  "leaders_icon" VARCHAR,
  "leaders_score" VARCHAR,
  "teachers_icon" VARCHAR,
  "teachers_score" VARCHAR,
  "parent_engagement_icon" VARCHAR,
  "parent_engagement_score" VARCHAR,
  "parent_environment_icon" VARCHAR,
  "parent_environment_score" VARCHAR,
  "average_student_attendance" VARCHAR,
  "rate_of_misconducts_per_100_students" DOUBLE,
  "average_teacher_attendance" VARCHAR,
  "individualized_education_program_compliance_rate" VARCHAR,
  "pk_2_literacy" VARCHAR,
  "pk_2_math" VARCHAR,
  "gr3_5_grade_level_math" VARCHAR,
  "gr3_5_grade_level_read" VARCHAR,
  "gr3_5_keep_pace_read" VARCHAR,
  "gr3_5_keep_pace_math" VARCHAR,
  "gr6_8_grade_level_math" VARCHAR,
  "gr6_8_grade_level_read" VARCHAR,
  "gr6_8_keep_pace_math" VARCHAR,
  "gr6_8_keep_pace_read" VARCHAR,
  "gr_8_explore_math" VARCHAR,
  "gr_8_explore_read" VARCHAR,
  "isat_exceeding_math" DOUBLE,
  "isat_exceeding_reading" DOUBLE,
  "isat_value_add_math" DOUBLE,
  "isat_value_add_read" DOUBLE,
  "isat_value_add_color_math" VARCHAR,
  "isat_value_add_color_read" VARCHAR,
  "students_taking_algebra" VARCHAR,
  "students_passing_algebra" VARCHAR,
  "n_9th_grade_explore_2009" VARCHAR,
  "n_9th_grade_explore_2010" VARCHAR,
  "n_10th_grade_plan_2009" VARCHAR,
  "n_10th_grade_plan_2010" VARCHAR,
  "net_change_explore_and_plan" VARCHAR,
  "n_11th_grade_average_act_2011" VARCHAR,
  "net_change_plan_and_act" VARCHAR,
  "college_eligibility" VARCHAR,
  "graduation_rate" VARCHAR,
  "college_enrollment_rate" VARCHAR,
  "college_enrollment" BIGINT,
  "general_services_route" BIGINT,
  "freshman_on_track_rate" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_area_number" BIGINT,
  "community_area_name" VARCHAR,
  "ward" BIGINT,
  "police_district" BIGINT,
  "location" VARCHAR
);

Share link

Anyone who has the link will be able to view this.