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

About this Dataset

2016 - 2017 Demographic Snapshot

Department of Education Report on Demographic data in New York City Public School
Organization: City of New York
Last updated: 2020-11-10T17:00:45.299001

Tables

Table 1

@usgov.city_of_new_york_2016_2017_demographic_snapshot.table_1

221.28 kB
2,873 rows
65 columns

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "category" VARCHAR,
  "year" VARCHAR,
  "total_enrollment" VARCHAR,
  "n__grade_9" VARCHAR  -- #Grade 9,
  "n__grade_10" VARCHAR  -- #Grade 10,
  "n__grade_11" VARCHAR  -- #Grade 11,
  "n__grade_12" VARCHAR  -- #Grade 12,
  "n__female" VARCHAR  -- #Female,
  "n__female_19295c" VARCHAR  -- %Female,
  "n__male" VARCHAR  -- #Male,
  "n__male_d142ac" VARCHAR  -- %Male,
  "n__asian" VARCHAR  -- #Asian,
  "n__asian_10fa06" VARCHAR  -- %Asian,
  "n__black" VARCHAR  -- #Black,
  "n__black_509a90" VARCHAR  -- %Black,
  "n__hispanic" VARCHAR  -- #Hispanic,
  "n__hispanic_7d1acf" VARCHAR  -- %Hispanic,
  "n__other" VARCHAR  -- #Other,
  "n__other_8ee4d4" VARCHAR  -- %Other,
  "n__white" VARCHAR  -- #White,
  "n__white_6b5bdc" VARCHAR  -- %White,
  "n__ell_spanish" VARCHAR  -- #ELL Spanish,
  "n__ell_spanish_7d3445" VARCHAR  -- %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" VARCHAR  -- #ELL Arabic,
  "n__ell_arabic_3fee03" VARCHAR  -- %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" VARCHAR  -- #ELL Other,
  "n__ell_other_a52dcb" VARCHAR  -- %ELL Other,
  "ela_test_takers" VARCHAR  -- ELA #Test Takers,
  "ela_level_1" VARCHAR  -- ELA #Level 1,
  "ela_level_1_b49bd3" VARCHAR  -- ELA %Level 1,
  "ela_level_2" VARCHAR  -- ELA #Level 2,
  "ela_level_2_6179eb" VARCHAR  -- 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" VARCHAR  -- Math #Test Takers,
  "math_level_1" VARCHAR  -- Math #Level 1,
  "math_level_1_363341" VARCHAR  -- Math %Level 1,
  "math_level_2" VARCHAR  -- Math #Level 2,
  "math_level_2_dff5b3" VARCHAR  -- 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" VARCHAR  -- Math #L3+L4,
  "math_l3_l4_ab680f" VARCHAR  -- Math %L3+L4
);