Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 89,718
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
944481 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2017   pk_12_total 5.0 104.0 326.0   1.0     4.0     2.0   394.0 48.0     99       398     129   442 5 104 326   1     4     2   394 48     99   398   129   442
950520 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805803 321100011513 NEW WORLD HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 10.0 8.0 73.0   2.0     15.0         56.0 52.0     99       102     *   108 10 8 73   2     15         56 52     99   102       108
975546 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702526 333200010145 PS 145 ANDREW JACKSON public Regular School No Elementary PK 05 2017   pk_12_total 5.0 14.0 589.0   3.0     5.0         323.0 293.0     99       495     98   616 5 14 589   3     5         323 293     99   495   98   616
986737 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No High 07 12 2017   pk_12_total 14.0 78.0 164.0   3.0     2.0         188.0 73.0     99       176     261   261 14 78 164   3     2         188 73     99   176   261   261
989992 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706178 310200011427 MANHATTAN ACAD-ARTS AND LANGUAGE public Regular School No High 09 12 2017   grade_10 1.0 3.0 105.0         3.0         63.0 49.0     99       108     *   112 1 3 105         3         63 49     99   108       112
992665 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102455 310500010123 PS 123 MAHALIA JACKSON public Regular School No Elementary PK 08 2017   pk_12_total 20.0 254.0 228.0   4.0     5.0     1.0   275.0 237.0     99       464     125   512 20 254 228   4     5     1   275 237     99   464   125   512
994258 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008304305 310600011540 A PHILIP RANDOLPH CAMPUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 15.0 142.0 319.0   4.0     23.0     9.0   265.0 247.0     99       442     78   512 15 142 319   4     23     9   265 247     99   442   78   512
1002904 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2017   kindergarten_full_day 13.0 0.0 80.0   0.0     111.0         108.0 96.0     99       *     30   204 13 0 80   0     111         108 96     99       30   204
1005547 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2017   pk_12_total 51.0 17.0 168.0   15.0     131.0     6.0   205.0 183.0     99       339     76   388 51 17 168   15     131     6   205 183     99   339   76   388
1006018 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2017   grade_8 21.0 38.0 374.0   11.0     169.0     0.0   307.0 306.0     99       442     95   613 21 38 374   11     169     0   307 306     99   442   95   613
1007067 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 12.0 48.0 120.0   63.0     477.0     8.0   373.0 355.0     99       645     103   728 12 48 120   63     477     8   373 355     99   645   103   728
1031083 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 245.0 158.0 557.0   2.0     219.0     17.0   471.0 727.0     99       909     95   1198 245 158 557   2     219     17   471 727     99   909   95   1198
951632 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001767 321200011550 HIGH SCHOOL OF WORLD CULTURES public Regular School No High 09 12 2017   grade_11 3.0 4.0 88.0   0.0     9.0         61.0 43.0     98       102     0   104 3 4 88   0     9         61 43     98   102   0   104
951720 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001341 321200011692 MONROE ACAD FOR VISUAL ARTS & DESIGN public Regular School No High 09 12 2017   pk_12_total 7.0 55.0 263.0   6.0     3.0     2.0   182.0 154.0     98       321     102   336 7 55 263   6     3     2   182 154     98   321   102   336
958731 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No Elementary PK 5 2017   pk_12_total 412.0 143.0 41.0   2.0     84.0     60.0   393.0 349.0     98       354     100   742 412 143 41   2     84     60   393 349     98   354   100   742
969352 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502631 331700010181 PS 181 public Regular School No Elementary PK 8 2017   pk_12_total 18.0 655.0 85.0   15.0     7.0     2.0   413.0 369.0     98       485     146   782 18 655 85   15     7     2   413 369     98   485   146   782
969852 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505712 331700011524 INTERNTL HS AT PROSPECT HGHTS public Regular School No High 09 12 2017   grade_10 5.0 23.0 61.0   2.0     14.0         62.0 43.0     98       62     5   105 5 23 61   2     14         62 43     98   62   5   105
979742 NY Monroe   school 3624750 261600010000   ROCHESTER 362475006216 261600010095 EDISON CAREER AND TECHNOLOGY HIGH public Regular School No High 09 12 2017   grade_9 55.0 386.0 159.0   1.0     27.0     1.0   322.0 307.0     98       597     148   629 55 386 159   1     27     1   322 307     98   597   148   629
982075 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No Middle 05 06 2017   grade_5 36.0 158.0 340.0   1.0     9.0     12.0   300.0 256.0     98       405     95   556 36 158 340   1     9     12   300 256     98   405   95   556
987500 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502070 307500014009 PS 9 public Special Education School No Other KG 10 2017   ungraded_elementary 41.0 88.0 137.0   5.0     33.0     0.0   190.0 114.0     98       184     304   304 41 88 137   5     33     0   190 114     98   184   304   304
987558 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504354 307500014177 PS 177 public Special Education School No Other KG 12 2017   ungraded_secondary 104.0 122.0 90.0   5.0     73.0     1.0   303.0 92.0     98       207     395   395 104 122 90   5     73     1   303 92     98   207   395   395
1003786 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804896 342400011530 INTNTL HIGH SCHOOL AT LA GUARDIA public Regular School No High 09 12 2017   grade_10 14.0 1.0 73.0   0.0     27.0     0.0   48.0 67.0     98       55     *   115 14 1 73   0     27     0   48 67     98   55       115
1004698 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201950 342500011460 FLUSHING HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 19.0 98.0 275.0   4.0     72.0     1.0   243.0 226.0     98       318     56   469 19 98 275   4     72     1   243 226     98   318   56   469
1012954 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003779 500402060018 RAMAPO HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 10.0 140.0 176.0         16.0     4.0   187.0 159.0     98       301     56   346 10 140 176         16     4   187 159     98   301   56   346
944222 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405873 320700011334 INTERNATIONAL COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 0.0 15.0 86.0   0.0     5.0     0.0   63.0 43.0     97       100     *   106 0 15 86   0     5     0   63 43     97   100       106
948642 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary PK 05 2017   pk_12_total 1.0 71.0 214.0   2.0     1.0         133.0 156.0     97       282     48   289 1 71 214   2     1         133 156     97   282   48   289
967710 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 5 2017   grade_4 7.0 2.0 105.0   0.0     133.0     0.0   114.0 133.0     97       241     26   247 7 2 105   0     133     0   114 133     97   241   26   247
975470 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702334 333200010086 PS 86 IRVINGTON (THE) public Regular School No Elementary KG 05 2017   pk_12_total 6.0 6.0 360.0   1.0     14.0         209.0 178.0     97       379     84   387 6 6 360   1     14         209 178     97   379   84   387
975603 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702788 333200010274 PS 274 KOSCIUSKO public Regular School No Elementary PK 05 2017   pk_12_total 11.0 39.0 380.0   7.0     4.0     1.0   243.0 199.0     97       437     80   442 11 39 380   7     4     1   243 199     97   437   80   442
1003338 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802464 342400010125 IS 125 THOMAS J MCCANN WOODSIDE public Regular School No Middle 06 08 2017   grade_7 28.0 7.0 259.0   4.0     228.0     0.0   277.0 249.0     97       265     87   526 28 7 259   4     228     0   277 249     97   265   87   526
1003748 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801959 342400011485 GROVER CLEVELAND HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 97.0 29.0 346.0   4.0     47.0     9.0   310.0 222.0     97       370     97   532 97 29 346   4     47     9   310 222     97   370   97   532
1005072 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902580 342600010162 PS 162 JOHN GOLDEN public Regular School No Elementary PK 05 2017   pk_12_total 115.0 14.0 82.0   1.0     484.0     10.0   364.0 342.0     97       438     101   706 115 14 82   1     484     10   364 342     97   438   101   706
1007194 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002718 342800010217 JHS 217 ROBERT A VAN WYCK public Regular School No Middle 06 08 2017   grade_6 29.0 91.0 204.0   18.0     187.0     4.0   259.0 274.0     97       285     102   533 29 91 204   18     187     4   259 274     97   285   102   533
1007751 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No Elementary PK 05 2017   pk_12_total 18.0 224.0 189.0   47.0     192.0     4.0   335.0 339.0     97       584     109   674 18 224 189   47     192     4   335 339     97   584   109   674
981037 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001152 280201030007 HEMPSTEAD HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 26.0 676.0 1766.0   7.0     13.0     5.0   1323.0 1170.0     962       1490     240   2493 26 676 1766   7     13     5   1323 1170     962   1490   240   2493
945032 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502302 320800010075 PS 75 SCHOOL OF RESEARCH-DISCOVERY public Regular School No Elementary PK 05 2017   pk_12_total 16.0 152.0 455.0   2.0     7.0     2.0   325.0 309.0     96       505     144   634 16 152 455   2     7     2   325 309     96   505   144   634
947521 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes Elementary KG 08 2017   pk_12_total 2.0 92.0 369.0   3.0     3.0     1.0   205.0 265.0     96       416     49   470 2 92 369   3     3     1   205 265     96   416   49   470
974444 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015303385 332200010315 PS 315 public Regular School No Elementary PK 5 2017   pk_12_total 31.0 384.0 167.0   9.0     62.0     1.0   328.0 326.0     96       561     177   654 31 384 167   9     62     1   328 326     96   561   177   654
1002991 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805244 342400010028 PS 28 THOMAS EMANUEL EARLY CHILD CTR public Regular School No Elementary PK 02 2017   grade_2 0.0   141.0   1.0     15.0     1.0   73.0 85.0     96       114     37   158 0   141   1     15     1   73 85     96   114   37   158
1003590 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806485 342400010343 CHILDREN'S LAB SCHOOL (THE) public Regular School No Elementary PK 05 2017   pk_12_total 36.0 1.0 175.0   1.0     88.0     1.0   164.0 138.0     96       247     71   302 36 1 175   1     88     1   164 138     96   247   71   302
1004623 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205727 342500011263 FLUSHING INTRNL HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 5.0 0.0 45.0   2.0     54.0         60.0 46.0     96       96     *   106 5 0 45   2     54         60 46     96   96       106
1008644 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202045 343000010002 PS 2 ALFRED ZIMBERG public Regular School No Elementary KG 05 2017   pk_12_total 231.0 19.0 219.0   1.0     118.0     3.0   299.0 292.0     96       444     107   591 231 19 219   1     118     3   299 292     96   444   107   591
1019626 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001264 580403030005 JEFFERSON SCHOOL public Regular School No Elementary KG 04 2017   pk_12_total 98.0 10.0 206.0         3.0     12.0   173.0 156.0     96       208     52   329 98 10 206         3     12   173 156     96   208   52   329
1020424 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003724 580413030013 HENRY L STIMSON MIDDLE SCHOOL public Regular School No Middle 07 08 2017   pk_12_total 449.0 65.0 336.0   2.0     56.0     25.0   516.0 417.0     96       467     139   933 449 65 336   2     56     25   516 417     96   467   139   933
1029568 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003184 661500010004 WOODSIDE SCHOOL public Regular School No Elementary KG 02 2017   grade_1 27.0 46.0 188.0         6.0     10.0   161.0 116.0     96       237     *   277 27 46 188         6     10   161 116     96   237       277
943835 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402147 320700010031 PS/MS 31 WILLIAM LLOYD GARRISON public Regular School No Elementary PK 08 2017   pk_12_total 14.0 195.0 499.0   5.0     17.0     1.0   393.0 338.0     95       680     189   731 14 195 499   5     17     1   393 338     95   680   189   731
994014 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305990 310600010366 WASHINGTON HEIGHTS ACADEMY public Regular School No Elementary PK 08 2017   pk_12_total 13.0 9.0 523.0   5.0     13.0     1.0   245.0 319.0     95       503     77   564 13 9 523   5     13     1   245 319     95   503   77   564
1000132 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932001765 441000010010 MIDDLETOWN TWIN TOWERS MIDDLE SCH public Regular School No Middle 06 08 2017   pk_12_total 142.0 233.0 491.0   1.0     30.0     12.0   446.0 463.0     95       706     138   909 142 233 491   1     30     12   446 463     95   706   138   909
1004519 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012206032 342500010244 ACTIVE LEARNING ELEMENTARY SCH (THE) public Regular School No Elementary PK 03 2017   kindergarten_full_day 4.0 1.0 10.0   0.0     109.0     1.0   68.0 57.0     95       96     15   125 4 1 10   0     109     1   68 57     95   96   15   125
1012425 NY Rockland   school 3621480 500304030000   NYACK 362148003050 500304030002 LIBERTY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 180.0 67.0 188.0         25.0     27.0   237.0 250.0     95       226     59   487 180 67 188         25     27   237 250     95   226   59   487
1021597 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000263 580512030015 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 31.0 39.0 213.0   1.0     9.0     3.0   149.0 147.0     95       253     51   296 31 39 213   1     9     3   149 147     95   253   51   296
1028651 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001835 660900010004 HAMILTON SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 12.0 221.0 170.0   1.0     5.0     3.0   199.0 213.0     95       363     47   412 12 221 170   1     5     3   199 213     95   363   47   412
1029534 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2017   grade_2 18.0 48.0 187.0   0.0     4.0     12.0   150.0 119.0     95       232     36   269 18 48 187   0     4     12   150 119     95   232   36   269
1030013 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 49.0 14.0 273.0         7.0         177.0 166.0     95       276     50   343 49 14 273         7         177 166     95   276   50   343
1031159 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2017   pk_12_total 20.0 64.0 249.0         13.0     8.0   185.0 169.0     95       330     38   354 20 64 249         13     8   185 169     95   330   38   354
943968 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 8.0 114.0 378.0   1.0     3.0     1.0   277.0 228.0     94       475     140   505 8 114 378   1     3     1   277 228     94   475   140   505
946434 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE public Regular School No Middle 06 08 2017   grade_8 4.0 36.0 184.0   0.0     5.0     0.0   128.0 101.0     94       196     69   229 4 36 184   0     5     0   128 101     94   196   69   229
949003 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705181 321000011433 HS FOR TEACHING AND PROFESSIONS public Regular School No High 09 12 2017   pk_12_total 13.0 78.0 355.0         11.0     6.0   211.0 252.0     94       392     116   463 13 78 355         11     6   211 252     94   392   116   463
968307 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205930 331500011592 KHALIL GIBRAN INTERNATIONAL ACADEMY public Regular School No High 09 12 2017   pk_12_total 94.0 92.0 20.0   3.0     44.0     8.0   143.0 118.0     94       161     40   261 94 92 20   3     44     8   143 118     94   161   40   261
972325 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105227 332000010069 PS 69 VINCENT D GRIPPO SCHOOL public Regular School No Elementary KG 5 2017   grade_2 6.0 1.0 4.0         128.0     1.0   65.0 75.0     94       139     10   140 6 1 4         128     1   65 75     94   139   10   140
986908 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502079 307500012012 PS 12 LEWIS AND CLARK SCHOOL public Special Education School No Other 03 12 2017   pk_12_total 12.0 91.0 155.0   18.0     9.0         212.0 73.0     94       210     285   285 12 91 155   18     9         212 73     94   210   285   285
987706 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502843 307500014811 PS 811 public Special Education School No Other KG 12 2017   pk_12_total 62.0 139.0 123.0   17.0     78.0         286.0 133.0     94       232     419   419 62 139 123   17     78         286 133     94   232   419   419
990344 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705500 310200011542 MANHATTAN BRIDGES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9   0.0 154.0         1.0     1.0   71.0 85.0     94       100     20   156   0 154         1     1   71 85     94   100   20   156
996332 NY Oneida   school 3629370 412300010000   UTICA 362937003957 412300010011 MARTIN LUTHER KING JR ELEM SCH public Regular School No Elementary KG 06 2017   pk_12_total 34.0 109.0 79.0         93.0     12.0   161.0 166.0     94       322     32   327 34 109 79         93     12   161 166     94   322   32   327
998675 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003871 421800010039 NOTTINGHAM HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 66.0 194.0 27.0   2.0     54.0     9.0   177.0 175.0     94       273     52   352 66 194 27   2     54     9   177 175     94   273   52   352
1021672 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000258 580512030021 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 11.0 30.0 272.0   1.0     5.0     1.0   161.0 159.0     94       301     50   320 11 30 272   1     5     1   161 159     94   301   50   320
946001 NY Bronx   school 3600165 320800860903   HYDE LEADERSHIP CHARTER SCHO 360016505889 320800860903 HYDE LEADERSHIP CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   pk_12_total 7.0 311.0 633.0   1.0     3.0     1.0   462.0 494.0     93       857     216   956 7 311 633   1     3     1   462 494     93   857   216   956
951641 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001767 321200011550 HIGH SCHOOL OF WORLD CULTURES public Regular School No High 09 12 2017   grade_9 6.0 8.0 85.0   3.0     7.0         63.0 46.0     93       108     *   109 6 8 85   3     7         63 46     93   108       109
979609 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003371 261600010066 JAMES MONROE HIGH SCHOOL public Regular School No High 07 12 2017   grade_9 9.0 112.0 143.0   1.0     0.0     2.0   137.0 130.0     93       259     59   267 9 112 143   1     0     2   137 130     93   259   59   267
980885 NY Nassau   school 3612180 280100010000   GLEN COVE 361218000975 280100010004 GRIBBIN SCHOOL public Regular School No Elementary KG 02 2017   pk_12_total 101.0 22.0 234.0         10.0     8.0   187.0 188.0     93       243     36   375 101 22 234         10     8   187 188     93   243   36   375
990524 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704778 310200011575 MANHATTAN COMP NIGHT AND DAY HS public Regular School No High 09 12 2017   grade_10 9.0 44.0 47.0   3.0     34.0     1.0   82.0 56.0     93       115     12   138 9 44 47   3     34     1   82 56     93   115   12   138
998694 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003864 421800010040 HENNINGER HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 126.0 183.0 52.0   6.0     51.0     11.0   197.0 232.0     93       331     65   429 126 183 52   6     51     11   197 232     93   331   65   429
1004131 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202444 342500010120 PS 120 public Regular School No Elementary PK 05 2017   grade_2 1.0 1.0 24.0   0.0     135.0     0.0   73.0 88.0     93       71     19   161 1 1 24   0     135     0   73 88     93   71   19   161
1007501 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010001951 342800011440 FOREST HILLS HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 292.0 85.0 370.0   7.0     217.0     30.0   512.0 489.0     93       641     212   1001 292 85 370   7     217     30   512 489     93   641   212   1001
1017153 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831000609 580105030005 WALTER G O'CONNELL COPIAGUE HIGH SCH public Regular School No High 09 12 2017   grade_9 46.0 98.0 251.0         11.0     4.0   216.0 194.0     93       308     55   410 46 98 251         11     4   216 194     93   308   55   410
1020405 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003725 580413030012 MAPLEWOOD INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   pk_12_total 297.0 47.0 278.0   1.0     36.0     30.0   342.0 347.0     93       357     116   689 297 47 278   1     36     30   342 347     93   357   116   689
1021474 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_1 4.0 9.0 187.0   0.0     3.0     2.0   97.0 108.0     93       192     23   205 4 9 187   0     3     2   97 108     93   192   23   205
944367 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Regular School No High 09 12 2017   pk_12_total 18.0 128.0 408.0   4.0     8.0     3.0   459.0 110.0     92       525     162   569 18 128 408   4     8     3   459 110     92   525   162   569
945146 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2017   pk_12_total 1.0 74.0 236.0   2.0     11.0         155.0 169.0     92       258     102   324 1 74 236   2     11         155 169     92   258   102   324
949478 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No Elementary KG 05 2017   pk_12_total 16.0 503.0 395.0   8.0     14.0     1.0   467.0 470.0     92       927     165   937 16 503 395   8     14     1   467 470     92   927   165   937
950922 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002350 321200010092 PS 92 public Regular School No Elementary PK 05 2017   pk_12_total 10.0 79.0 337.0   4.0     4.0     1.0   208.0 227.0     92       399     105   435 10 79 337   4     4     1   208 227     92   399   105   435
951207 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005807 321200010300 SCHOOL OF SCIENCE & APPLIED LRNG public Regular School No Elementary PK 05 2017   pk_12_total 6.0 225.0 376.0   2.0     3.0         305.0 307.0     92       563     195   612 6 225 376   2     3         305 307     92   563   195   612
954133 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000719 60800010009 DUNKIRK SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 233.0 57.0 294.0   5.0     3.0     6.0   305.0 293.0     92       405     54   598 233 57 294   5     3     6   305 293     92   405   54   598
987858 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007602104 310100010020 PS 20 ANNA SILVER public Regular School No Elementary PK 05 2017   pk_12_total 28.0 53.0 261.0   7.0     175.0     14.0   275.0 263.0     92       313     117   538 28 53 261   7     175     14   275 263     92   313   117   538
989853 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700116 310200011400 HS FOR ENVIRONMENTAL STUDIES public Regular School No High 09 12 2017   pk_12_total 79.0 196.0 766.0   5.0     159.0     10.0   598.0 617.0     92       963     221   1215 79 196 766   5     159     10   598 617     92   963   221   1215
993672 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302609 310600010173 PS 173 public Regular School No Elementary PK 05 2017   pk_12_total 10.0 8.0 505.0   1.0     18.0     1.0   282.0 261.0     92       475     94   543 10 8 505   1     18     1   282 261     92   475   94   543
1002936 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2017   grade_4 3.0 10.0 272.0   4.0     23.0     0.0   159.0 153.0     92       212     52   312 3 10 272   4     23     0   159 153     92   212   52   312
1005110 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2017   pk_12_total 254.0 15.0 111.0   5.0     538.0     21.0   504.0 440.0     92       541     144   944 254 15 111   5     538     21   504 440     92   541   144   944
1005870 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302460 342700010124 PS 124 OSMOND A CHURCH public Regular School No Elementary KG 08 2017   pk_12_total 35.0 239.0 272.0   63.0     639.0     6.0   651.0 603.0     92       558     164   1254 35 239 272   63     639     6   651 603     92   558   164   1254
1006560 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302013 342700011480 JOHN ADAMS HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 12.0 116.0 176.0   29.0     169.0     2.0   289.0 215.0     92       419     81   504 12 116 176   29     169     2   289 215     92   419   81   504
1006896 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002376 342800010099 PS 99 KEW GARDENS public Regular School No Elementary KG 06 2017   pk_12_total 236.0 53.0 320.0   9.0     169.0     20.0   438.0 369.0     92       527     170   807 236 53 320   9     169     20   438 369     92   527   170   807
1008184 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101997 342900010238 IS 238 SUSAN B ANTHONY ACADEMY public Regular School No Middle 06 08 2017   grade_8 11.0 184.0 135.0   20.0     175.0     1.0   266.0 260.0     92       420     72   526 11 184 135   20     175     1   266 260     92   420   72   526
1015313 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003583 530600010025 SCHENECTADY HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 687.0 933.0 430.0   4.0     545.0     36.0   1324.0 1311.0     92       2194     498   2635 687 933 430   4     545     36   1324 1311     92   2194   498   2635
1018866 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003161 580224030010 CANAAN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 276.0 16.0 207.0         11.0     16.0   285.0 241.0     92       281     85   526 276 16 207         11     16   285 241     92   281   85   526
1020557 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 487.0 267.0 564.0         49.0     18.0   741.0 644.0     92       728     224   1385 487 267 564         49     18   741 644     92   728   224   1385
1021497 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 2.0 12.0 194.0   0.0     1.0     4.0   98.0 115.0     92       202     22   213 2 12 194   0     1     4   98 115     92   202   22   213
1027302 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003889 660401030003 SLEEPY HOLLOW HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 281.0 53.0 467.0         14.0     12.0   405.0 422.0     92       443     109   827 281 53 467         14     12   405 422     92   443   109   827
1028803 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001839 660900010013 MT VERNON HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 62.0 1139.0 216.0   1.0     15.0     4.0   790.0 647.0     92       1011     332   1437 62 1139 216   1     15     4   790 647     92   1011   332   1437
1029145 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 431.0 200.0 342.0   1.0     57.0     9.0   535.0 505.0     92       356     140   1040 431 200 342   1     57     9   535 505     92   356   140   1040
1029344 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2017   grade_2 76.0 33.0 245.0         11.0     17.0   204.0 178.0     92       251     29   382 76 33 245         11     17   204 178     92   251   29   382

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]);