2017 - 2018 Co-Location Report
City of New York
@usgov.city_of_new_york_2017_2018_co_location_report
City of New York
@usgov.city_of_new_york_2017_2018_co_location_report
Academic and demographic information on co-located schools
Organization: City of New York
Last updated: 2020-11-10T17:00:42.812377
CREATE TABLE table_1 (
"dbn" VARCHAR,
"district" BIGINT,
"school_name" VARCHAR,
"is_org_split_sited" BOOLEAN,
"building_id_s" VARCHAR -- Building ID(s),
"transfer_school" BOOLEAN,
"total_enrollment" BIGINT,
"grades_pk_5_enrollment" BIGINT,
"grades_6_8_enrollment" BIGINT,
"grades_9_12_enrollment" BIGINT,
"n__asian" DOUBLE -- % Asian,
"n__black" DOUBLE -- % Black,
"n__hispanic" DOUBLE -- % Hispanic,
"n__multiple_race_categories_not_represented" DOUBLE -- % Multiple Race Categories Not Represented,
"n__white" DOUBLE -- % White,
"n__swd" DOUBLE -- % Swd,
"n__ell" DOUBLE -- % Ell,
"n__poverty" DOUBLE -- % Poverty,
"ela_tested" VARCHAR -- ELA # Tested,
"ela_proficient_l3_4" VARCHAR -- ELA # Proficient (L3&4),
"ela_proficient_l3_4_28c881" VARCHAR -- ELA % Proficient (L3&4),
"math_tested" VARCHAR -- Math # Tested,
"math_proficient_l3_4" VARCHAR -- Math # Proficient (L3&4),
"math_proficient_l3_4_f3df71" VARCHAR -- Math % Proficient (L3&4),
"n_2016_17_total_grad_cohort" VARCHAR -- 2016-17 Total Grad Cohort,
"n_2016_17_4_year_august_graduates" VARCHAR -- 2016-17 % 4-Year August Graduates,
"n_2016_17_6_year_graduates" VARCHAR -- 2016-17 % 6-Year Graduates
);Anyone who has the link will be able to view this.