Chicago Public Schools - High School Progress Report (2013-2014)
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_high_school_pro_c738d044
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_high_school_pro_c738d044
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,
"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_all_grades" DOUBLE,
"nwea_math_growth_grade_3" DOUBLE,
"nwea_math_growth_grade_4" DOUBLE,
"nwea_math_growth_grade_5" DOUBLE,
"nwea_math_growth_grade_6" DOUBLE,
"nwea_math_growth_grade_7" DOUBLE,
"nwea_math_growth_grade_8" DOUBLE,
"nwea_reading_attainment_percentile_all_grades" DOUBLE,
"nwea_reading_attainment_percentile_grade_2" VARCHAR,
"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" VARCHAR,
"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,
"epas_growth_percentile" DOUBLE,
"explore_growth_percentile_grade_9" DOUBLE,
"plan_growth_percentile_grade_10" DOUBLE,
"act_growth_percentile_grade_11" DOUBLE,
"epas_attainment_percentile" DOUBLE,
"explore_attainment_percentile_grade_9" DOUBLE,
"plan_attainment_percentile_grade_10" DOUBLE,
"grade_act_attainment_percentile_grade_11" DOUBLE,
"explore_spring_2013_average_grade_9" DOUBLE,
"explore_spring_2013_average_grade_10" DOUBLE,
"explore_fall_2011_average_grade_9" DOUBLE,
"plan_fall_2012_average_grade_10" DOUBLE,
"act_spring_2013_average_grade_11" DOUBLE,
"freshmen_on_track_rate_percentage_2013" DOUBLE,
"freshmen_on_track_rate_percentage_2012" DOUBLE,
"n_4_year_graduation_rate_percentage_2013" DOUBLE,
"n_4_year_graduation_rate_percentage_2012" DOUBLE,
"n_5_year_graduation_rate_percentage_2013" DOUBLE,
"n_5_year_graduation_rate_percentage_2012" DOUBLE,
"college_enrollment_rate_percentage_2013" DOUBLE,
"college_enrollment_rate_percentage_2012" DOUBLE,
"college_persistence_rate_percentage_2013" DOUBLE,
"college_persistence_rate_percentage_2012" DOUBLE,
"suspensions_per_100_2013" DOUBLE,
"suspensions_per_100_2012" DOUBLE,
"percentage_of_misconducts_resulting_in_suspension_2013" DOUBLE,
"percentage_of_misconducts_resulting_in_suspension_2012" DOUBLE,
"average_length_of_suspensions_2013" DOUBLE,
"average_length_of_suspensions_2012" DOUBLE,
"student_attendance_percentage_2013" DOUBLE,
"student_attendance_percentage_2012" DOUBLE,
"teacher_attendance_percentage_2013" DOUBLE,
"teacher_attendance_percentage_2012" DOUBLE,
"gr3_8_on_track_percentage_2013" DOUBLE,
"one_year_dropout_rate_percentage_2013" DOUBLE,
"one_year_dropout_rate_percentage_2012" DOUBLE,
"x_coordinate" DOUBLE,
"y_coordinate" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"location" VARCHAR
);
Anyone who has the link will be able to view this.