Name: 2015 - 2016 Demographic Snapshot
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2015 - 2016 Demographic Snapshot

Report on Demographic Snapshot data in New York City Pubic School.
Organization: City of New York
Last updated: 2020-11-10T17:06:00.576866

Tables

Table 1

@usgov.city_of_new_york_2015_2016_demographic_snapshot.table_1

94.6 kB
192 rows
69 columns

CREATE TABLE table_1 (
  "district" BIGINT,
  "category" VARCHAR,
  "year" VARCHAR,
  "total_enrollment" BIGINT,
  "n__grade_k" BIGINT  -- #Grade K,
  "n__grade_1" BIGINT  -- #Grade 1,
  "n__grade_2" BIGINT  -- #Grade 2,
  "n__grade_3" BIGINT  -- #Grade 3,
  "n__grade_4" BIGINT  -- #Grade 4,
  "n__grade_5" BIGINT  -- #Grade 5,
  "n__grade_6" VARCHAR  -- #Grade 6,
  "n__grade_7" BIGINT  -- #Grade 7,
  "n__grade_8" VARCHAR  -- #Grade 8,
  "n__female" BIGINT  -- #Female,
  "n__female_19295c" DOUBLE  -- %Female,
  "n__male" BIGINT  -- #Male,
  "n__male_d142ac" DOUBLE  -- %Male,
  "n__asian" VARCHAR  -- #Asian,
  "n__asian_10fa06" VARCHAR  -- %Asian,
  "n__black" VARCHAR  -- #Black,
  "n__black_509a90" VARCHAR  -- %Black,
  "n__hispanic" BIGINT  -- #Hispanic,
  "n__hispanic_7d1acf" DOUBLE  -- %Hispanic,
  "n__other" VARCHAR  -- #Other,
  "n__other_8ee4d4" VARCHAR  -- %Other,
  "n__white" BIGINT  -- #White,
  "n__white_6b5bdc" DOUBLE  -- %White,
  "n__ell_spanish" DOUBLE  -- #ELL Spanish,
  "n__ell_spanish_7d3445" DOUBLE  -- %ELL Spanish,
  "n__ell_chinese" VARCHAR  -- #ELL Chinese,
  "n__ell_chinese_236fb0" VARCHAR  -- %ELL Chinese,
  "n__ell_bengali" VARCHAR  -- #ELL Bengali,
  "n__ell_bengali_4b90d3" VARCHAR  -- %ELL Bengali,
  "n__ell_arabic" DOUBLE  -- #ELL Arabic,
  "n__ell_arabic_3fee03" DOUBLE  -- %ELL Arabic,
  "n__ell_haitian_creole" VARCHAR  -- #ELL Haitian Creole,
  "n__ell_haitian_creole_0dfc83" VARCHAR  -- %ELL Haitian Creole,
  "n__ell_french" VARCHAR  -- #ELL French,
  "n__ell_french_725571" VARCHAR  -- %ELL French,
  "n__ell_russian" VARCHAR  -- #ELL Russian,
  "n__ell_russian_18f394" VARCHAR  -- %ELL Russian,
  "n__ell_korean" VARCHAR  -- #ELL Korean,
  "n__ell_korean_fa4303" VARCHAR  -- %ELL Korean,
  "n__ell_urdu" VARCHAR  -- #ELL Urdu,
  "n__ell_urdu_27fb39" VARCHAR  -- %ELL Urdu,
  "n__ell_other" DOUBLE  -- #ELL Other,
  "n__ell_other_a52dcb" DOUBLE  -- %ELL Other,
  "ela_test_takers" BIGINT  -- ELA #Test Takers,
  "ela_level_1" BIGINT  -- ELA #Level 1,
  "ela_level_1_b49bd3" DOUBLE  -- ELA %Level 1,
  "ela_level_2" BIGINT  -- ELA #Level 2,
  "ela_level_2_6179eb" DOUBLE  -- ELA %Level 2,
  "ela_level_3" VARCHAR  -- ELA #Level 3,
  "ela_level_3_df298e" VARCHAR  -- ELA %Level 3,
  "ela_level_4" VARCHAR  -- ELA #Level 4,
  "ela_level_4_2d8d54" VARCHAR  -- ELA %Level 4,
  "ela_l3_l4" VARCHAR  -- ELA #L3+L4,
  "ela_l3_l4_7c5e02" VARCHAR  -- ELA %L3+L4,
  "math_test_takers" BIGINT  -- Math #Test Takers,
  "math_level_1" BIGINT  -- MATH #Level 1,
  "math_level_1_363341" DOUBLE  -- MATH %Level 1,
  "math_level_2" BIGINT  -- MATH #Level 2,
  "math_level_2_dff5b3" DOUBLE  -- MATH %Level 2,
  "math_level_3" VARCHAR  -- MATH #Level 3,
  "math_level_3_3bf734" VARCHAR  -- MATH %Level 3,
  "math_level_4" VARCHAR  -- MATH #Level 4,
  "math_level_4_929d1c" VARCHAR  -- MATH %Level 4,
  "math_l3_l4" BIGINT  -- MATH #L3+L4,
  "math_l3_l4_ab680f" DOUBLE  -- MATH %L3 + L4
);