2012 - 2013 D75 Progress Reports
City of New York
@usgov.city_of_new_york_2012_2013_d75_progress_reports
City of New York
@usgov.city_of_new_york_2012_2013_d75_progress_reports
New York City Department of Education 2012 - 2013 D75 Progress Reports
Organization: City of New York
Last updated: 2020-11-10T17:02:39.024562
CREATE TABLE table_1 (
"dbn" VARCHAR,
"school" VARCHAR,
"principal" VARCHAR,
"enrollment" BIGINT,
"school_type" VARCHAR,
"progress_score" DOUBLE,
"progress_grade" VARCHAR,
"ela_unadjusted_growth_percentile_std" DOUBLE -- ELA Unadjusted Growth Percentile (STD),
"peer_percent_of_range" DOUBLE,
"peer_0_of_range" DOUBLE -- Peer 0% Of Range,
"peer_100_of_range" DOUBLE -- Peer 100% Of Range,
"ela_unadjusted_growth_percentile_tran" VARCHAR -- ELA Unadjusted Growth Percentile (TRAN),
"peer_percent_of_range_1" VARCHAR,
"peer_0_of_range_1" DOUBLE -- Peer 0% Of Range 1,
"peer_100_of_range_1" DOUBLE -- Peer 100% Of Range 1,
"math_unadjusted_growth_percentile_std" DOUBLE -- Math Unadjusted Growth Percentile (STD),
"peer_percent_of_range_2" DOUBLE,
"peer_0_of_range_2" DOUBLE -- Peer 0% Of Range 2,
"peer_100_of_range_2" DOUBLE -- Peer 100% Of Range 2,
"math_unadjusted_growth_percentile_tran" VARCHAR -- Math Unadjusted Growth Percentile (TRAN),
"peer_percent_of_range_3" VARCHAR,
"peer_0_of_range_3" DOUBLE -- Peer 0% Of Range 3,
"peer_100_of_range_3" DOUBLE -- Peer 100% Of Range 3,
"average_change_attendance" DOUBLE,
"peer_percent_of_range_4" DOUBLE,
"peer_0_of_range_4" DOUBLE -- Peer 0% Of Range 4,
"peer_100_of_range_4" DOUBLE -- Peer 100% Of Range 4,
"movement_to_lre" DOUBLE,
"peer_percent_of_range_5" DOUBLE,
"peer_0_of_range_5" DOUBLE -- Peer 0% Of Range 5,
"peer_100_of_range_5" DOUBLE -- Peer 100% Of Range 5,
"integration_into_gen_ed" DOUBLE,
"peer_percent_of_range_6" DOUBLE,
"peer_0_of_range_6" DOUBLE -- Peer 0% Of Range 6,
"peer_100_of_range_6" DOUBLE -- Peer 100% Of Range 6,
"performance_score" DOUBLE,
"performance_grade" VARCHAR,
"ela_level_3_4" DOUBLE -- ELA % Level 3/4,
"peer_percent_of_range_7" DOUBLE,
"peer_0_of_range_7" BIGINT -- Peer 0% Of Range 7,
"peer_100_of_range_7" DOUBLE -- Peer 100% Of Range 7,
"ela_level_2" DOUBLE -- ELA % Level 2+,
"peer_percent_of_range_8" DOUBLE,
"peer_0_of_range_8" DOUBLE -- Peer 0% Of Range 8,
"peer_100_of_range_8" DOUBLE -- Peer 100% Of Range 8,
"ela_nysaa_level_3_4" DOUBLE -- ELA% NYSAA Level 3/4,
"peer_percent_of_range_9" DOUBLE,
"peer_0_of_range_9" DOUBLE -- Peer 0% Of Range 9,
"peer_100_of_range_9" BIGINT -- Peer 100% Of Range 9,
"math_level_3_4" DOUBLE -- Math % Level 3/4,
"peer_percent_of_range_10" DOUBLE,
"peer_0_of_range_10" BIGINT -- Peer 0% Of Range 10,
"peer_100_of_range_10" DOUBLE -- Peer 100% Of Range 10,
"math_level_2" DOUBLE -- Math % Level 2+,
"peer_percent_of_range_11" DOUBLE,
"peer_0_of_range_11" DOUBLE -- Peer 0% Of Range 11,
"peer_100_of_range_11" DOUBLE -- Peer 100% Of Range 11,
"math_nysaa_level_3_4" DOUBLE -- Math % NYSAA Level 3/4,
"peer_percent_of_range_12" DOUBLE,
"peer_0_of_range_12" DOUBLE -- Peer 0% Of Range 12,
"peer_100_of_range_12" BIGINT -- Peer 100% Of Range 12,
"environment_score" DOUBLE,
"environment_grade" VARCHAR,
"academic_expectations" DOUBLE,
"peer_percent_of_range_13" DOUBLE,
"peer_0_of_range_13" DOUBLE -- Peer 0% Of Range 13,
"peer_100_of_range_13" DOUBLE -- Peer 100% Of Range 13,
"communications" DOUBLE,
"peer_percent_of_range_14" DOUBLE,
"peer_0_of_range_14" DOUBLE -- Peer 0% Of Range 14,
"peer_100_of_range_14" DOUBLE -- Peer 100% Of Range 14,
"engagement" DOUBLE,
"peer_percent_of_range_15" DOUBLE,
"peer_0_of_range_15" DOUBLE -- Peer 0% Of Range 15,
"peer_100_of_range_15" DOUBLE -- Peer 100% Of Range 15,
"safety_and_respect" DOUBLE,
"peer_percent_of_range_16" DOUBLE,
"peer_0_of_range_16" DOUBLE -- Peer 0% Of Range 16,
"peer_100_of_range_16" DOUBLE -- Peer 100% Of Range 16,
"maintaining_a_safe_school_environment" DOUBLE,
"peer_percent_of_range_17" DOUBLE,
"peer_0_of_range_17" DOUBLE -- Peer 0% Of Range 17,
"peer_100_of_range_17" BIGINT -- Peer 100% Of Range 17
);Anyone who has the link will be able to view this.