Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 89,618
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
946467 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_3   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946468 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946469 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946470 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_6   43.0 81.0   0.0     2.0     1.0   50.0 77.0     *       116     19   127   43 81   0     2     1   50 77         116   19   127
946471 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_7   59.0 61.0   1.0     1.0     0.0   52.0 70.0     *       112     21   122   59 61   1     1     0   52 70         112   21   122
946472 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_8   53.0 55.0   0.0     3.0     0.0   52.0 59.0     8       107     19   111   53 55   0     3     0   52 59     8   107   19   111
946473 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946474 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   kindergarten_full_day   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946475 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   kindergarten_half_day   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946476 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   pk_12_total   155.0 197.0   1.0     6.0     1.0   154.0 206.0     19       335     59   360   155 197   1     6     1   154 206     19   335   59   360
946477 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   pre_kindergarten_full_day   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946478 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   pre_kindergarten_half_day   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946479 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   ungraded_elementary   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946480 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   ungraded_secondary   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
947241 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_1   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947242 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_10   8.0 18.0   0.0     1.0         16.0 11.0     15       21     10   27   8 18   0     1         16 11     15   21   10   27
947243 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_11   0.0 5.0   0.0     0.0         5.0 0.0     *       *     0   5   0 5   0     0         5 0             0   5
947244 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_12   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947245 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947246 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_3   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947247 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947248 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_5   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947249 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_6   5.0 10.0   1.0     0.0         6.0 10.0     *       *     *   16   5 10   1     0         6 10                 16
947250 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_7   21.0 22.0   6.0     0.0         25.0 24.0     16       44     23   49   21 22   6     0         25 24     16   44   23   49
947251 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_8   12.0 44.0   2.0     0.0         37.0 21.0     19       44     15   58   12 44   2     0         37 21     19   44   15   58
947252 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_9   20.0 45.0   0.0     0.0         35.0 30.0     17       54     24   65   20 45   0     0         35 30     17   54   24   65
947253 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   kindergarten_full_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947254 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   kindergarten_half_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947255 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   pk_12_total   66.0 145.0   9.0     1.0         124.0 97.0     76       180     82   221   66 145   9     1         124 97     76   180   82   221
947256 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   pre_kindergarten_full_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947257 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   pre_kindergarten_half_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947258 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   ungraded_elementary   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947259 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   ungraded_secondary   0.0 1.0   0.0     0.0         0.0 1.0     0       0     *   1   0 1   0     0         0 1     0   0       1
947260 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_1   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947261 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_10   0.0 85.0                   40.0 45.0     81       84     6   85   0 85                   40 45     81   84   6   85
947262 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_11   0.0 76.0                   54.0 22.0     39       74     10   76   0 76                   54 22     39   74   10   76
947263 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_12   0.0 67.0                   41.0 26.0     *       *     *   67   0 67                   41 26                 67
947264 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947265 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_3   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947266 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_4   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947267 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_5   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947268 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_6   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947269 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_7   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947270 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_8   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947271 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_9   1.0 87.0                   54.0 34.0     81       86     *   88   1 87                   54 34     81   86       88
947272 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   kindergarten_full_day   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947273 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   kindergarten_half_day   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947274 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   pk_12_total   1.0 316.0                   190.0 127.0     209       312     23   317   1 316                   190 127     209   312   23   317
947275 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   pre_kindergarten_full_day   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947276 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   pre_kindergarten_half_day   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947277 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   ungraded_elementary   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
947278 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   ungraded_secondary   0.0 1.0                   1.0 0.0     *       *     *   1   0 1                   1 0                 1
950756 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_1   17.0 18.0   0.0     21.0         27.0 29.0     5       43     *   56   17 18   0     21         27 29     5   43       56
950757 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_10   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950758 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_11   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950759 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_12   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950760 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950761 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_3   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950762 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950763 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_5   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950764 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_6   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950765 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_7   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950766 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_8   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950767 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950768 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   kindergarten_full_day   16.0 27.0   1.0     9.0         26.0 27.0     12       40     9   53   16 27   1     9         26 27     12   40   9   53
950769 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   kindergarten_half_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950770 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   pk_12_total   34.0 45.0   1.0     30.0         54.0 56.0     17       83     16   110   34 45   1     30         54 56     17   83   16   110
950771 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   pre_kindergarten_full_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950772 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   pre_kindergarten_half_day   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
950773 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   ungraded_elementary   1.0 0.0   0.0     0.0         1.0 0.0     0       0     *   1   1 0   0     0         1 0     0   0       1
950774 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   ungraded_secondary   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
951497 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_1     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951498 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_10     140.0                   67.0 73.0     139       135     *   140     140                   67 73     139   135       140
951499 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_11     115.0                   62.0 53.0     107       113     *   115     115                   62 53     107   113       115
951500 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_12     56.0                   33.0 23.0     24       54     *   56     56                   33 23     24   54       56
951501 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951502 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_3     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951503 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_4     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951504 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_5     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951505 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_6     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951506 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_7     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951507 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_8     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951508 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_9     119.0                   56.0 63.0     117       115     *   119     119                   56 63     117   115       119
951509 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   kindergarten_full_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951510 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   kindergarten_half_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951511 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   pk_12_total     430.0                   218.0 212.0     387       417     12   430     430                   218 212     387   417   12   430
951512 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   pre_kindergarten_full_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951513 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   pre_kindergarten_half_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951514 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   ungraded_elementary     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951515 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   ungraded_secondary     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
960446 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_1   50.0 5.0   1.0           4.0   19.0 41.0     *       59     *   60   50 5   1           4   19 41         59       60
960447 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_10   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
960448 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_11   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
960449 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_12   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
960450 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_2   49.0 8.0   0.0           4.0   30.0 31.0     *       59     5   61   49 8   0           4   30 31         59   5   61
960451 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_3   51.0 4.0   0.0           0.0   30.0 25.0     *       55     5   55   51 4   0           0   30 25         55   5   55
960452 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_4   50.0 5.0   0.0           3.0   21.0 37.0     *       57     5   58   50 5   0           3   21 37         57   5   58
960453 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_5   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
960454 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_6   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
960455 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_7   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);