About this Dataset

Chicago Public Schools - Elementary School Progress Report (2013-2014)

This dataset shows the 2013 School Progress Report Card data elements for each CPS elementary 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://www.cps.edu/SCHOOLDATA/Pages/SchoolProgressReports.aspx
Organization: City of Chicago
Last updated: 2020-11-10T16:55:26.808241
Tags: cps, education, report-cards

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_elementary_scho_1faae86e.table_1

160.12 kB
483 rows
74 columns

CREATE TABLE table_1 (
  "school_id" BIGINT,
  "name_of_school" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "phone_number" VARCHAR,
  "website" VARCHAR,
  "blue_ribbon_award" DOUBLE,
  "cps_performance_policy_level" VARCHAR,
  "cps_performance_policy_status" VARCHAR,
  "probation_length" DOUBLE,
  "my_voice_my_school_overall_rating" VARCHAR  -- My Voice, My School Overall Rating,
  "student_response_rate" DOUBLE,
  "teacher_response_rate" DOUBLE,
  "involved_family" VARCHAR,
  "supportive_environment" VARCHAR,
  "ambitious_instruction" VARCHAR,
  "effective_leaders" VARCHAR,
  "collaborative_teachers" VARCHAR,
  "safe" VARCHAR,
  "school_community" VARCHAR,
  "parent_teacher_partnership" VARCHAR,
  "quality_of_facilities" VARCHAR,
  "healthy_schools_certification" VARCHAR,
  "creative_schools_certification" VARCHAR,
  "nwea_reading_growth_percentile_all_grades" DOUBLE,
  "nwea_reading_growth_percentile_grade_3" DOUBLE,
  "nwea_reading_growth_percentile_grade_4" DOUBLE,
  "nwea_reading_growth_percentile_grade_5" DOUBLE,
  "nwea_reading_growth_percentile_grade_6" DOUBLE,
  "nwea_reading_growth_percentile_grade_7" DOUBLE,
  "nwea_reading_growth_percentile_grade_8" DOUBLE,
  "nwea_math_growth_percentile_all_grades" DOUBLE,
  "nwea_math_growth_percentile_grade_3" DOUBLE,
  "nwea_math_growth_percentile_grade_4" DOUBLE,
  "nwea_math_growth_percentile_grade_5" DOUBLE,
  "nwea_math_growth_percentile_grade_6" DOUBLE,
  "nwea_math_growth_percentile_grade_7" DOUBLE,
  "nwea_math_growth_percentile_grade_8" DOUBLE,
  "nwea_reading_attainment_percentile_all_grades" DOUBLE,
  "nwea_reading_attainment_percentile_grade_2" DOUBLE,
  "nwea_reading_attainment_percentile_grade_3" DOUBLE,
  "nwea_reading_attainment_percentile_grade_4" DOUBLE,
  "nwea_reading_attainment_percentile_grade_5" DOUBLE,
  "nwea_reading_attainment_percentile_grade_6" DOUBLE,
  "nwea_reading_attainment_percentile_grade_7" DOUBLE,
  "nwea_reading_attainment_percentile_grade_8" DOUBLE,
  "nwea_math_attainment_percentile_all_grades" DOUBLE,
  "nwea_math_attainment_percentile_grade_2" DOUBLE,
  "nwea_math_attainment_percentile_grade_3" DOUBLE,
  "nwea_math_attainment_percentile_grade_4" DOUBLE,
  "nwea_math_attainment_percentile_grade_5" DOUBLE,
  "nwea_math_attainment_percentile_grade_6" DOUBLE,
  "nwea_math_attainment_percentile_grade_7" DOUBLE,
  "nwea_math_attainment_percentile_grade_8" DOUBLE,
  "suspensions_per_100_students_2013" DOUBLE,
  "suspensions_per_100_students_2012" DOUBLE,
  "percentage_misconducts_resulting_in_suspension_2013" DOUBLE,
  "percentage_misconducts_resulting_in_suspension_2012" DOUBLE,
  "average_length_of_suspensions_2013" DOUBLE,
  "average_length_of_suspension_2012" DOUBLE,
  "student_attendance_percentage_2013" DOUBLE,
  "student_attendance_percentage_2012" DOUBLE,
  "teacher_attendance_percentage_2013" DOUBLE,
  "teacher_attendance_percentage_2012" DOUBLE,
  "grade_3_8_on_track_percentage_2013" DOUBLE,
  "one_year_drop_out_rate_percentage_2013" DOUBLE,
  "one_year_drop_out_rate_percentage_2012" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);