About this Dataset

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

This dataset shows the 2012 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://cps.edu/Schools/Pages/SchoolProgressReportCards.aspx.
Organization: City of Chicago
Last updated: 2021-08-07T18:07:43.979936
Tags: cps, education, report-cards

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_elementary_scho_88da99e8.table_1

198.97 kB
460 rows
83 columns

CREATE TABLE table_1 (
  "school_id" BIGINT,
  "school_short_name" VARCHAR,
  "school_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "phone_number" VARCHAR,
  "website" VARCHAR,
  "managed_by_network" VARCHAR,
  "geographic_network" VARCHAR,
  "school_track" VARCHAR,
  "overall_rating" VARCHAR,
  "on_probation" VARCHAR,
  "years_on_probation" BIGINT,
  "nwea_or_scantron" VARCHAR,
  "growth_overall_level" VARCHAR,
  "growth_overall_reading_and_math" DOUBLE,
  "reading_growth_grade_3" DOUBLE,
  "reading_growth_grade_4" DOUBLE,
  "reading_growth_grade_5" DOUBLE,
  "reading_growth_grade_6" DOUBLE,
  "reading_growth_grade_7" DOUBLE,
  "reading_growth_grade_8" DOUBLE,
  "reading_growth_all_grades" DOUBLE,
  "math_growth_grade_3" DOUBLE,
  "math_growth_grade_4" DOUBLE,
  "math_growth_grade_5" DOUBLE,
  "math_growth_grade_6" DOUBLE,
  "math_growth_grade_7" DOUBLE,
  "math_growth_grade_8" DOUBLE,
  "math_growth_all_grades" DOUBLE,
  "student_performance_level" VARCHAR,
  "student_performance_reading_and_math" DOUBLE,
  "reading_performance_grade_3" DOUBLE,
  "reading_performance_grade_4" DOUBLE,
  "reading_performance_grade_5" DOUBLE,
  "reading_performance_grade_6" DOUBLE,
  "reading_performance_grade_7" DOUBLE,
  "reading_performance_grade_8" DOUBLE,
  "reading_performance_all_grades" DOUBLE,
  "math_performance_grade_3" DOUBLE,
  "math_performance_grade_4" DOUBLE,
  "math_performance_grade_5" DOUBLE,
  "math_performance_grade_6" DOUBLE,
  "math_performance_grade_7" DOUBLE,
  "math_performance_grade_8" DOUBLE,
  "math_performance_all_grades" DOUBLE,
  "reading_growth_african_american" DOUBLE,
  "reading_growth_hispanic" DOUBLE,
  "reading_growth_white" DOUBLE,
  "reading_growth_students_with_disabilities" DOUBLE,
  "reading_growth_english_language_learners" DOUBLE,
  "reading_growth_free_and_reduced_lunch" DOUBLE,
  "math_growth_african_american" DOUBLE,
  "math_growth_hispanic" DOUBLE,
  "math_growth_white" DOUBLE,
  "math_growth_students_with_disabilities" DOUBLE,
  "math_growth_english_language_learners" DOUBLE,
  "math_growth_free_and_reduced_lunch" DOUBLE,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);