Dataset: 2020-2021 Demographic Snapshot Borough

About this Dataset

2020-2021 Demographic Snapshot Borough

To provide a snapshot of citywide student enrollment and demographic information across multiple years. Data is collected using multiple data sources, including DOE's Audited Register, biographic data from Automate The Schools (ATS) system and the Location Code Generation and Management System (LCGMS). Data can be used to view citywide demographic and enrollment trends over time. Enrollment counts are based on the October 31 Audited Register for each school year. Please note that October 31 enrollment is not audited for charter schools or Pre-K Early Education Centers(NYCEECs). Charter schools are required to submit enrollment as of BEDS Day the first Wednesday in October to the New York State Education Department of Education. Enrollment counts will exceed operational enrollment counts due the fact that long term absence (LTA) students are excluded for funding purposes.
Organization: City of New York
Last updated: 2021-11-19T10:39:27.046953

Tables

Table 1

@usgov.city_of_new_york_2020_2021_demographic_snapshot_borough.table_1

35.97 KB
25 rows
42 columns


CREATE TABLE table_1 (
  "borough" VARCHAR,
  "year" VARCHAR,
  "total_enrollment" BIGINT,
  "grade_3k_pk_half_day_full_day" BIGINT,
  "grade_k" BIGINT,
  "grade_1" BIGINT,
  "grade_2" BIGINT,
  "grade_3" BIGINT,
  "grade_4" BIGINT,
  "grade_5" BIGINT,
  "grade_6" BIGINT,
  "grade_7" BIGINT,
  "grade_8" BIGINT,
  "grade_9" BIGINT,
  "grade_10" BIGINT,
  "grade_11" BIGINT,
  "grade_12" BIGINT,
  "n__female" BIGINT,
  "n__female_19295c" DOUBLE,
  "n__male" BIGINT,
  "n__male_d142ac" DOUBLE,
  "n__asian" BIGINT,
  "n__asian_10fa06" DOUBLE,
  "n__black" BIGINT,
  "n__black_509a90" DOUBLE,
  "n__hispanic" BIGINT,
  "n__hispanic_7d1acf" DOUBLE,
  "n__multi_racial" BIGINT,
  "n__multi_racial_ed8fe4" DOUBLE,
  "n__native_american" BIGINT,
  "n__native_american_e3b321" DOUBLE,
  "n__white" BIGINT,
  "n__white_6b5bdc" DOUBLE,
  "n__missing_race_ethnicity_data" BIGINT,
  "n__missing_race_ethnicity_data_2122ca" DOUBLE,
  "n__students_with_disabilities" BIGINT,
  "n__students_with_disabilities_b549a7" DOUBLE,
  "n__english_language_learners" BIGINT,
  "n__english_language_learners_3c2f4d" DOUBLE,
  "n__poverty" BIGINT,
  "n__poverty_ac3464" DOUBLE,
  "economic_need_index" DOUBLE
);