Chicago Public Schools - School Progress Reports SY2122 by US Government | Demographics and Population Studies

About this Dataset

Chicago Public Schools - School Progress Reports SY2122

2021-2022 school progress report ratings for all Chicago Public Schools.
Organization: City of Chicago
Last updated: 2021-10-23T03:20:00.530628
Tags: 2021, 2022, cps, metrics, report-cards, schools

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_school_progress_65e6f260.table_1

249.99 KB
651 rows
182 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" VARCHAR,
  "fax" VARCHAR,
  "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
);