Chicago Public Schools - School Profile Information SY2122 by US Government | Demographics and Population Studies

About this Dataset

Chicago Public Schools - School Profile Information SY2122

School profile information for all schools in the Chicago Public School district for the school year 2021-2022.

Data set is no longer being updated when data set for next year is created
Organization: City of Chicago
Last updated: 2021-10-23T03:14:42.547032
Tags: 2021, 2022, cps, metrics, report-cards, schools

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_school_profile__36284956.table_1

465.6 KB
655 rows
96 columns


CREATE TABLE table_1 (
  "school_id" BIGINT,
  "legacy_unit_id" BIGINT,
  "finance_id" BIGINT,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "primary_category" VARCHAR,
  "is_high_school" BOOLEAN,
  "is_middle_school" BOOLEAN,
  "is_elementary_school" BOOLEAN,
  "is_pre_school" BOOLEAN,
  "summary" VARCHAR,
  "administrator_title" VARCHAR,
  "administrator" VARCHAR,
  "secondary_contact_title" VARCHAR,
  "secondary_contact" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "cps_school_profile" VARCHAR,
  "website" VARCHAR,
  "facebook" VARCHAR,
  "twitter" VARCHAR,
  "youtube" VARCHAR,
  "pinterest" VARCHAR,
  "attendance_boundaries" BOOLEAN,
  "grades_offered_all" VARCHAR,
  "grades_offered" VARCHAR,
  "student_count_total" BIGINT,
  "student_count_low_income" BIGINT,
  "student_count_special_ed" BIGINT,
  "student_count_english_learners" BIGINT,
  "student_count_black" BIGINT,
  "student_count_hispanic" BIGINT,
  "student_count_white" BIGINT,
  "student_count_asian" BIGINT,
  "student_count_native_american" BIGINT,
  "student_count_other_ethnicity" BIGINT,
  "student_count_asian_pacific_islander" BIGINT,
  "student_count_multi" BIGINT,
  "student_count_hawaiian_pacific_islander" BIGINT,
  "student_count_ethnicity_not_available" BIGINT,
  "statistics_description" VARCHAR,
  "demographic_description" VARCHAR,
  "dress_code" BOOLEAN,
  "prek_school_day" VARCHAR,
  "kindergarten_school_day" VARCHAR,
  "school_hours" VARCHAR,
  "freshman_start_end_time" VARCHAR,
  "after_school_hours" VARCHAR,
  "earliest_drop_off_time" VARCHAR,
  "classroom_languages" VARCHAR,
  "bilingual_services" VARCHAR,
  "refugee_services" VARCHAR,
  "title_1_eligible" VARCHAR,
  "preschool_inclusive" VARCHAR,
  "preschool_instructional" VARCHAR,
  "significantly_modified" VARCHAR,
  "hard_of_hearing" VARCHAR,
  "visual_impairments" VARCHAR,
  "transportation_bus" VARCHAR,
  "transportation_el" VARCHAR,
  "transportation_metra" VARCHAR,
  "average_act_school" VARCHAR,
  "mean_act" VARCHAR,
  "college_enrollment_rate_school" DOUBLE,
  "college_enrollment_rate_mean" DOUBLE,
  "graduation_rate_school" DOUBLE,
  "graduation_rate_mean" DOUBLE,
  "overall_rating" VARCHAR,
  "rating_status" VARCHAR,
  "rating_statement" VARCHAR,
  "classification_description" VARCHAR,
  "school_year" VARCHAR,
  "third_contact_title" VARCHAR,
  "third_contact_name" VARCHAR,
  "fourth_contact_title" VARCHAR,
  "fourth_contact_name" VARCHAR,
  "fifth_contact_title" VARCHAR,
  "fifth_contact_name" VARCHAR,
  "sixth_contact_title" VARCHAR,
  "sixth_contact_name" VARCHAR,
  "seventh_contact_title" VARCHAR,
  "seventh_contact_name" VARCHAR,
  "network" VARCHAR,
  "is_gocps_participant" BOOLEAN,
  "is_gocps_prek" BOOLEAN,
  "is_gocps_elementary" VARCHAR,
  "is_gocps_high_school" BOOLEAN,
  "open_for_enrollment_date" TIMESTAMP,
  "closed_for_enrollment_date" TIMESTAMP,
  "school_latitude" DOUBLE,
  "school_longitude" DOUBLE,
  "location" VARCHAR
);