Dataset: Chicago Public Schools - School Progress Reports SY2425

About this Dataset

Chicago Public Schools - School Progress Reports SY2425

2024-2025 school progress report ratings for all Chicago Public Schools, based on 2023-2024 data.

Data set is no longer being updated when data set for next year is created
Organization: City of Chicago
Last updated: 2024-11-01T21:08:57.162235
Tags: 2023, 2024, 2025, cps, metrics, report-cards, schools

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_school_progress_3b625801.table_1

258.97 KB
649 rows
183 columns


CREATE TABLE table_1 (
  "school_id" BIGINT,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "school_type" VARCHAR,
  "primary_category" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "phone" BIGINT,
  "fax" DOUBLE,
  "cps_school_profile" VARCHAR,
  "website" VARCHAR,
  "progress_report_year" BIGINT,
  "blue_ribbon_award_year" DOUBLE,
  "excelerate_award_gold_year" DOUBLE,
  "spot_light_award_year" DOUBLE,
  "improvement_award_year" DOUBLE,
  "excellence_award_year" DOUBLE,
  "student_growth_rating" VARCHAR,
  "student_growth_description" VARCHAR,
  "growth_reading_grades_tested_pct_es" VARCHAR,
  "growth_reading_grades_tested_label_es" VARCHAR,
  "growth_math_grades_tested_pct_es" VARCHAR,
  "growth_math_grades_tested_label_es" VARCHAR,
  "student_attainment_rating" VARCHAR,
  "student_attainment_description" VARCHAR,
  "attainment_reading_pct_es" VARCHAR,
  "attainment_reading_lbl_es" VARCHAR,
  "attainment_math_pct_es" VARCHAR,
  "attainment_math_lbl_es" VARCHAR,
  "culture_climate_rating" VARCHAR,
  "culture_climate_description" VARCHAR,
  "school_survey_student_response_rate_pct" DOUBLE,
  "school_survey_student_response_rate_avg_pct" DOUBLE,
  "school_survey_teacher_response_rate_pct" DOUBLE,
  "school_survey_teacher_response_rate_avg_pct" DOUBLE,
  "school_survey_parent_response_rate_pct" VARCHAR,
  "school_survey_parent_response_rate_avg_pct" VARCHAR,
  "healthy_school_certification" VARCHAR,
  "healthy_school_certification_description" VARCHAR,
  "creative_school_certification" VARCHAR,
  "creative_school_certification_description" VARCHAR,
  "nwea_reading_growth_grade_3_pct" VARCHAR,
  "nwea_reading_growth_grade_3_lbl" VARCHAR,
  "nwea_reading_growth_grade_4_pct" VARCHAR,
  "nwea_reading_growth_grade_4_lbl" VARCHAR,
  "nwea_reading_growth_grade_5_pct" VARCHAR,
  "nwea_reading_growth_grade_5_lbl" VARCHAR,
  "nwea_reading_growth_grade_6_pct" VARCHAR,
  "nwea_reading_growth_grade_6_lbl" VARCHAR,
  "nwea_reading_growth_grade_7_pct" VARCHAR,
  "nwea_reading_growth_grade_7_lbl" VARCHAR,
  "nwea_reading_growth_grade_8_pct" VARCHAR,
  "nwea_reading_growth_grade_8_lbl" VARCHAR,
  "nwea_math_growth_grade_3_pct" VARCHAR,
  "nwea_math_growth_grade_3_lbl" VARCHAR,
  "nwea_math_growth_grade_4_pct" VARCHAR,
  "nwea_math_growth_grade_4_lbl" VARCHAR,
  "nwea_math_growth_grade_5_pct" VARCHAR,
  "nwea_math_growth_grade_5_lbl" VARCHAR,
  "nwea_math_growth_grade_6_pct" VARCHAR,
  "nwea_math_growth_grade_6_lbl" VARCHAR,
  "nwea_math_growth_grade_7_pct" VARCHAR,
  "nwea_math_growth_grade_7_lbl" VARCHAR,
  "nwea_math_growth_grade_8_pct" VARCHAR,
  "nwea_math_growth_grade_8_lbl" VARCHAR,
  "nwea_reading_attainment_grade_2_pct" VARCHAR,
  "nwea_reading_attainment_grade_2_lbl" VARCHAR,
  "nwea_reading_attainment_grade_3_pct" VARCHAR,
  "nwea_reading_attainment_grade_3_lbl" VARCHAR,
  "nwea_reading_attainment_grade_4_pct" VARCHAR,
  "nwea_reading_attainment_grade_4_lbl" VARCHAR,
  "nwea_reading_attainment_grade_5_pct" VARCHAR,
  "nwea_reading_attainment_grade_5_lbl" VARCHAR,
  "nwea_reading_attainment_grade_6_pct" VARCHAR,
  "nwea_reading_attainment_grade_6_lbl" VARCHAR,
  "nwea_reading_attainment_grade_7_pct" VARCHAR,
  "nwea_reading_attainment_grade_7_lbl" VARCHAR,
  "nwea_reading_attainment_grade_8_pct" VARCHAR,
  "nwea_reading_attainment_grade_8_lbl" VARCHAR,
  "nwea_math_attainment_grade_2_pct" VARCHAR,
  "nwea_math_attainment_grade_2_lbl" VARCHAR,
  "nwea_math_attainment_grade_3_pct" VARCHAR,
  "nwea_math_attainment_grade_3_lbl" VARCHAR,
  "nwea_math_attainment_grade_4_pct" VARCHAR,
  "nwea_math_attainment_grade_4_lbl" VARCHAR,
  "nwea_math_attainment_grade_5_pct" VARCHAR,
  "nwea_math_attainment_grade_5_lbl" VARCHAR,
  "nwea_math_attainment_grade_6_pct" VARCHAR,
  "nwea_math_attainment_grade_6_lbl" VARCHAR,
  "nwea_math_attainment_grade_7_pct" VARCHAR,
  "nwea_math_attainment_grade_7_lbl" VARCHAR,
  "nwea_math_attainment_grade_8_pct" VARCHAR,
  "nwea_math_attainment_grade_8_lbl" VARCHAR,
  "school_survey_involved_families" VARCHAR,
  "school_survey_supportive_environment" VARCHAR,
  "school_survey_ambitious_instruction" VARCHAR,
  "school_survey_effective_leaders" VARCHAR,
  "school_survey_collaborative_teachers" VARCHAR
);