2015 - 2016 Demographic Snapshot

CREATE TABLE table_1 (
  "district" BIGINT,
  "category" VARCHAR,
  "year" VARCHAR,
  "total_enrollment" BIGINT,
  "n__grade_k" BIGINT,
  "n__grade_1" BIGINT,
  "n__grade_2" BIGINT,
  "n__grade_3" BIGINT,
  "n__grade_4" BIGINT,
  "n__grade_5" BIGINT,
  "n__grade_6" VARCHAR,
  "n__grade_7" BIGINT,
  "n__grade_8" VARCHAR,
  "n__female" BIGINT,
  "n__female_19295c" DOUBLE,
  "n__male" BIGINT,
  "n__male_d142ac" DOUBLE,
  "n__asian" VARCHAR,
  "n__asian_10fa06" VARCHAR,
  "n__black" VARCHAR,
  "n__black_509a90" VARCHAR,
  "n__hispanic" BIGINT,
  "n__hispanic_7d1acf" DOUBLE,
  "n__other" VARCHAR,
  "n__other_8ee4d4" VARCHAR,
  "n__white" BIGINT,
  "n__white_6b5bdc" DOUBLE,
  "n__ell_spanish" DOUBLE,
  "n__ell_spanish_7d3445" DOUBLE,
  "n__ell_chinese" VARCHAR,
  "n__ell_chinese_236fb0" VARCHAR,
  "n__ell_bengali" VARCHAR,
  "n__ell_bengali_4b90d3" VARCHAR,
  "n__ell_arabic" DOUBLE,
  "n__ell_arabic_3fee03" DOUBLE,
  "n__ell_haitian_creole" VARCHAR,
  "n__ell_haitian_creole_0dfc83" VARCHAR,
  "n__ell_french" VARCHAR,
  "n__ell_french_725571" VARCHAR,
  "n__ell_russian" VARCHAR,
  "n__ell_russian_18f394" VARCHAR,
  "n__ell_korean" VARCHAR,
  "n__ell_korean_fa4303" VARCHAR,
  "n__ell_urdu" VARCHAR,
  "n__ell_urdu_27fb39" VARCHAR,
  "n__ell_other" DOUBLE,
  "n__ell_other_a52dcb" DOUBLE,
  "ela_test_takers" BIGINT,
  "ela_level_1" BIGINT,
  "ela_level_1_b49bd3" DOUBLE,
  "ela_level_2" BIGINT,
  "ela_level_2_6179eb" DOUBLE,
  "ela_level_3" VARCHAR,
  "ela_level_3_df298e" VARCHAR,
  "ela_level_4" VARCHAR,
  "ela_level_4_2d8d54" VARCHAR,
  "ela_l3_l4" VARCHAR,
  "ela_l3_l4_7c5e02" VARCHAR,
  "math_test_takers" BIGINT,
  "math_level_1" BIGINT,
  "math_level_1_363341" DOUBLE,
  "math_level_2" BIGINT,
  "math_level_2_dff5b3" DOUBLE,
  "math_level_3" VARCHAR,
  "math_level_3_3bf734" VARCHAR,
  "math_level_4" VARCHAR,
  "math_level_4_929d1c" VARCHAR,
  "math_l3_l4" BIGINT,
  "math_l3_l4_ab680f" DOUBLE
);