Chicago Public Schools - Elementary School Progress Report (2013-2014)
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_elementary_scho_1faae86e
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_elementary_scho_1faae86e
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_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
);
Anyone who has the link will be able to view this.