Chicago Public Schools – High School Progress Report Card (2012-2013)
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_high_school_pro_562c60ab
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_high_school_pro_562c60ab
CREATE TABLE table_1 (
"school_id" BIGINT,
"school_short_name" VARCHAR,
"school_name" VARCHAR,
"street_address" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" BIGINT,
"website" VARCHAR,
"managed_by_network" VARCHAR,
"geographic_network" VARCHAR,
"school_track" VARCHAR,
"overall_rating" VARCHAR,
"on_probation" VARCHAR,
"years_on_probation" BIGINT,
"growth_overall_level" VARCHAR,
"growth_explore" DOUBLE,
"growth_plan" DOUBLE,
"growth_act" DOUBLE,
"growth_all_grades" DOUBLE,
"student_performance_level" VARCHAR,
"over_time_explore_2010" DOUBLE,
"over_time_plan_2011" DOUBLE,
"over_time_act_2012" DOUBLE,
"average_score_explore_2012" DOUBLE,
"average_score_plan_2012" DOUBLE,
"average_score_act_2012" DOUBLE,
"n_5_year_cohort_graduation_rate_2011_percent" DOUBLE,
"n_5_year_cohort_graduation_rate_2012_percent" DOUBLE,
"one_year_dropout_rate_2011_percent" DOUBLE,
"one_year_dropout_rate_2012_percent" DOUBLE,
"freshman_on_track_to_graduate_2011_percent" DOUBLE,
"freshman_on_track_to_graduate_2012_percent" DOUBLE,
"college_eligibility_2011_percent" DOUBLE,
"college_eligibility_2012_percent" DOUBLE,
"college_enrollment_2011_percent" DOUBLE,
"college_enrollment_2012_percent" DOUBLE,
"college_retention_2009_percent" DOUBLE,
"college_retention_2010_percent" 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_2012_percent" DOUBLE,
"average_days_of_suspension_2011" DOUBLE,
"average_days_of_suspension_2012" DOUBLE,
"student_attendance_2011_percent" DOUBLE,
"student_attendance_2012_percent" DOUBLE,
"teacher_attendance_2011_percent" DOUBLE,
"teacher_attendance_2012_percent" DOUBLE,
"healthy_school_certified" VARCHAR,
"blue_ribbon_award" VARCHAR,
"blue_ribbon_award_year" DOUBLE,
"x_coordinate" DOUBLE,
"y_coordinate" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"location" VARCHAR
);
Anyone who has the link will be able to view this.