About this Dataset

Chicago Public Schools – High School Progress Report Card (2012-2013)

This dataset shows the 2012 School Progress Report Card data elements for each CPS high school. The report card is an annual summary of how the school is doing. For more information on the School Progress Report Cards, please see http://cps.edu/Schools/Pages/SchoolProgressReportCards.aspx.
Organization: City of Chicago
Last updated: 2021-08-07T18:20:37.914123
Tags: cps, education, report-cards

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_high_school_pro_562c60ab.table_1

73.47 kB
92 rows
61 columns

CREATE TABLE table_1 (
  "school_id" BIGINT,
  "school_short_name" VARCHAR,
  "school_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "website" VARCHAR,
  "managed_by_network" VARCHAR,
  "geographic_network" VARCHAR,
  "school_track" VARCHAR,
  "overall_rating" VARCHAR,
  "on_probation" VARCHAR,
  "years_on_probation" BIGINT,
  "growth_overall_level" VARCHAR,
  "growth_explore" DOUBLE,
  "growth_plan" DOUBLE,
  "growth_act" DOUBLE,
  "growth_all_grades" DOUBLE,
  "student_performance_level" VARCHAR,
  "over_time_explore_2010" DOUBLE,
  "over_time_plan_2011" DOUBLE,
  "over_time_act_2012" DOUBLE,
  "average_score_explore_2012" DOUBLE,
  "average_score_plan_2012" DOUBLE,
  "average_score_act_2012" DOUBLE,
  "n_5_year_cohort_graduation_rate_2011_percent" DOUBLE  -- 5-Year Cohort Graduation Rate 2011 - Percent,
  "n_5_year_cohort_graduation_rate_2012_percent" DOUBLE  -- 5-Year Cohort Graduation Rate 2012 - Percent,
  "one_year_dropout_rate_2011_percent" DOUBLE  -- One-Year Dropout Rate 2011 - Percent,
  "one_year_dropout_rate_2012_percent" DOUBLE  -- One-Year Dropout Rate 2012 - Percent,
  "freshman_on_track_to_graduate_2011_percent" DOUBLE  -- Freshman On-Track To Graduate 2011 - Percent,
  "freshman_on_track_to_graduate_2012_percent" DOUBLE  -- Freshman On-Track To Graduate 2012 - Percent,
  "college_eligibility_2011_percent" DOUBLE  -- College Eligibility 2011 - Percent,
  "college_eligibility_2012_percent" DOUBLE  -- College Eligibility 2012 - Percent,
  "college_enrollment_2011_percent" DOUBLE  -- College Enrollment 2011 - Percent,
  "college_enrollment_2012_percent" DOUBLE  -- College Enrollment 2012 - Percent,
  "college_retention_2009_percent" DOUBLE  -- College Retention 2009 - Percent,
  "college_retention_2010_percent" DOUBLE  -- College Retention 2010 - Percent,
  "overall_foundation" VARCHAR,
  "involved_families" VARCHAR,
  "supportive_environment" VARCHAR,
  "ambitious_instruction" VARCHAR,
  "effective_leaders" VARCHAR,
  "collaborative_teachers" VARCHAR,
  "safety" VARCHAR,
  "misconducts_resulting_in_suspensions_2011_percent" DOUBLE  -- Misconducts Resulting In Suspensions 2011 - Percent,
  "misconducts_resulting_in_suspensions_2012_percent" DOUBLE  -- Misconducts Resulting In Suspensions 2012 - Percent,
  "average_days_of_suspension_2011" DOUBLE,
  "average_days_of_suspension_2012" DOUBLE,
  "student_attendance_2011_percent" DOUBLE  -- Student Attendance 2011 - Percent,
  "student_attendance_2012_percent" DOUBLE  -- Student Attendance 2012 - Percent,
  "teacher_attendance_2011_percent" DOUBLE  -- Teacher Attendance 2011 - Percent,
  "teacher_attendance_2012_percent" DOUBLE  -- Teacher Attendance 2012 - Percent,
  "healthy_school_certified" VARCHAR,
  "blue_ribbon_award" VARCHAR,
  "blue_ribbon_award_year" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR
);