enrollments

Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_8", state = "NY" and year = 2017 sorted by disability_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 4,722 ✖

grade ✖

  • grade_8 · 4,722 ✖
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
942387 942387 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_8 1.0 38.0 6.0   2.0     0.0     1.0   17.0 31.0             23         48 1 38 6   2     0     1   17 31         23       48
942406 942406 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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       0
989811 989811 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL 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   0     0         0 0     0   0       0
1000793 1000793 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_8 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1009229 1009229 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_8 11.0 0.0 49.0   1.0     7.0         30.0 38.0     67       64         68 11 0 49   1     7         30 38     67   64       68
1016259 1016259 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_8 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1022719 1022719 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2017   grade_8 0.0   0.0         0.0         0.0 0.0     *                 0 0   0         0         0 0                 0
1028913 1028913 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_8 0.0 60.0 8.0   1.0     0.0     0.0   36.0 33.0                       69 0 60 8   1     0     0   36 33                 69
1003054 1003054 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2017   grade_8 13.0 25.0 661.0   0.0     37.0     1.0   389.0 348.0     211       698     149   737 13 25 661   0     37     1   389 348     211   698   149   737
1003111 1003111 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802300 342400010073 IS 73 FRANK SANSIVIERI INTER SCHOOL public Regular School No Middle 06 08 2017   grade_8 125.0 7.0 409.0   2.0     183.0     1.0   409.0 318.0     *       344     132   727 125 7 409   2     183     1   409 318         344   132   727
1008963 1008963 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2017   grade_8 13.0 9.0 611.0   3.0     60.0     0.0   356.0 340.0     123       660     125   696 13 9 611   3     60     0   356 340     123   660   125   696
1018653 1018653 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 400.0 126.0 148.0   4.0     29.0     14.0   371.0 350.0     *       383     124   721 400 126 148   4     29     14   371 350         383   124   721
1011148 1011148 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302057 353100010051 IS 51 EDWIN MARKHAM public Regular School No Middle 06 08 2017   grade_8 98.0 87.0 178.0   2.0     33.0     2.0   206.0 194.0     39       298     120   400 98 87 178   2     33     2   206 194     39   298   120   400
1011490 1011490 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010304526 353100010075 IS 75 FRANK D PAULO public Regular School No Middle 06 08 2017   grade_8 390.0 6.0 59.0   0.0     42.0     2.0   254.0 245.0     *       164     118   499 390 6 59   0     42     2   254 245         164   118   499
1010749 1010749 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302120 353100010024 IS 24 MYRA S BARNES public Regular School No Middle 06 08 2017   grade_8 365.0 11.0 54.0   2.0     18.0     4.0   226.0 228.0     8       173     116   454 365 11 54   2     18     4   226 228     8   173   116   454
967695 967695 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 8 2017   grade_8 42.0 42.0 244.0   1.0     59.0     2.0   187.0 203.0     26       273     111   390 42 42 244   1     59     2   187 203     26   273   111   390
1003339 1003339 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_8 26.0 7.0 305.0   3.0     241.0     0.0   320.0 262.0     77       289     106   582 26 7 305   3     241     0   320 262     77   289   106   582
1010901 1010901 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301970 353100010034 IS 34 TOTTENVILLE public Regular School No Middle 06 08 2017   grade_8 325.0 1.0 41.0   3.0     16.0     0.0   197.0 189.0     7       129     106   386 325 1 41   3     16     0   197 189     7   129   106   386
1011452 1011452 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301974 353100010072 IS 72 ROCCO LAURIE public Regular School No Middle 06 08 2017   grade_8 210.0 20.0 97.0   1.0     101.0     3.0   236.0 196.0     *       255     99   432 210 20 97   1     101     3   236 196         255   99   432
973471 973471 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202736 332100010228 IS 228 DAVID A BOODY public Regular School No Middle 06 8 2017   grade_8 195.0 47.0 143.0   4.0     146.0     2.0   266.0 271.0     48       426     95   537 195 47 143   4     146     2   266 271     48   426   95   537
1006018 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
1000394 1000394 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 353.0 48.0 126.0   1.0     44.0     4.0   282.0 294.0     11       156     90   576 353 48 126   1     44     4   282 294     11   156   90   576
1007196 1007196 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_8 31.0 58.0 229.0   8.0     238.0     0.0   320.0 244.0     105       *     88   564 31 58 229   8     238     0   320 244     105       88   564
1020249 1020249 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 448.0 4.0 28.0   0.0     46.0     16.0   260.0 282.0     *       41     88   542 448 4 28   0     46     16   260 282         41   88   542
1011110 1011110 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302216 353100010049 IS 49 BERTA A DREYFUS public Regular School No Middle 06 08 2017   grade_8 29.0 94.0 107.0   0.0     25.0     1.0   130.0 126.0     *       204     87   256 29 94 107   0     25     1   130 126         204   87   256
1017076 1017076 NY Suffolk   school 3617380 580104030000   LINDENHURST 361738001547 580104030011 LINDENHURST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 320.0 13.0 109.0   0.0     14.0     2.0   235.0 223.0     16       *     84   458 320 13 109   0     14     2   235 223     16       84   458
1002864 1002864 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2017   grade_8 9.0 9.0 306.0   1.0     269.0     2.0   320.0 276.0     83       314     83   596 9 9 306   1     269     2   320 276     83   314   83   596
988937 988937 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702597 310200010167 JHS 167 ROBERT F WAGNER public Regular School No Middle 06 08 2017   grade_8 173.0 52.0 78.0   2.0     119.0     11.0   225.0 210.0     11       176     81   435 173 52 78   2     119     11   225 210     11   176   81   435
1003130 1003130 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No Middle 06 08 2017   grade_8 27.0 8.0 248.0   0.0     35.0     0.0   162.0 156.0     *       266     79   318 27 8 248   0     35     0   162 156         266   79   318
1012326 1012326 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 193.0 76.0 311.0   1.0     25.0     1.0   291.0 316.0     *       339     78   607 193 76 311   1     25     1   291 316         339   78   607
1020040 1020040 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001094 580405060014 WEST HOLLOW MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 292.0 46.0 39.0         65.0     12.0   236.0 218.0     7       72     78   454 292 46 39         65     12   236 218     7   72   78   454
1024429 1024429 NY Ulster   school 3616290 620600010000   KINGSTON 361629001434 620600010020 J WATSON BAILEY MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_8 159.0 29.0 52.0   1.0     8.0     16.0   146.0 119.0     16       145     78   265 159 29 52   1     8     16   146 119     16   145   78   265
997012 997012 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Other 08 09 2017   grade_8 559.0 34.0 25.0   4.0     17.0     32.0   340.0 331.0     *       254     77   671 559 34 25   4     17     32   340 331         254   77   671
1003244 1003244 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2017   grade_8 74.0 5.0 269.0   4.0     44.0     0.0   189.0 207.0     *       *     77   396 74 5 269   4     44     0   189 207             77   396
1031307 1031307 NY Westchester   school 3616620 662401060000   LAKELAND 361662001472 662401060008 LAKELAND-COPPER BEECH MIDDLE SCH public Regular School No Middle 06 08 2017   grade_8 348.0 30.0 84.0         29.0     3.0   248.0 246.0     8       59     77   494 348 30 84         29     3   248 246     8   59   77   494
966954 966954 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902816 331400010318 IS 318 EUGENO MARIA DE HOSTOS public Regular School No Middle 06 8 2017   grade_8 73.0 93.0 293.0   2.0     33.0     2.0   258.0 238.0     15       262     76   496 73 93 293   2     33     2   258 238     15   262   76   496
958404 958404 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 278.0 40.0 89.0         28.0     4.0   210.0 229.0     5       167     75   439 278 40 89         28     4   210 229     5   167   75   439
1030414 1030414 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 154.0 79.0 284.0   1.0     17.0     9.0   269.0 275.0     39       298     73   544 154 79 284   1     17     9   269 275     39   298   73   544
958385 958385 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 377.0 17.0 42.0   1.0     26.0     3.0   233.0 233.0     *       100     72   466 377 17 42   1     26     3   233 233         100   72   466
988728 988728 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704447 310200010104 JHS 104 SIMON BARUCH public Regular School No Middle 06 08 2017   grade_8 124.0 35.0 69.0   7.0     161.0     4.0   229.0 171.0     16       212     72   400 124 35 69   7     161     4   229 171     16   212   72   400
1008184 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
949930 949930 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2017   grade_8 7.0 165.0 69.0   4.0     10.0     0.0   132.0 123.0     *       197     71   255 7 165 69   4     10     0   132 123         197   71   255
1005980 1005980 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302685 342700010202 JHS 202 ROBERT H GODDARD public Regular School No Middle 06 08 2017   grade_8 34.0 23.0 175.0   6.0     130.0     2.0   183.0 187.0     26       297     71   370 34 23 175   6     130     2   183 187     26   297   71   370
1017836 1017836 NY Suffolk   school 3625350 580205060000   SACHEM 362535003507 580205060007 SAGAMORE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 285.0 18.0 58.0         24.0     2.0   180.0 207.0     *       112     71   387 285 18 58         24     2   180 207         112   71   387
974231 974231 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 8 2017   grade_8 282.0 125.0 84.0   4.0     160.0     3.0   332.0 326.0     54       387     70   658 282 125 84   4     160     3   332 326     54   387   70   658
946434 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
982135 982135 NY Nassau   school 3611550 280209030000   FREEPORT 361155000915 280209030006 JOHN W DODD MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 28.0 110.0 284.0   2.0     6.0     6.0   226.0 210.0     73       *     69   436 28 110 284   2     6     6   226 210     73       69   436
1010502 1010502 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301966 353100010007 IS 7 ELIAS BERNSTEIN public Regular School No Middle 06 08 2017   grade_8 349.0 2.0 23.0   1.0     21.0     3.0   188.0 211.0     *       145     69   399 349 2 23   1     21     3   188 211         145   69   399
943109 943109 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 308.0 26.0 20.0   0.0     75.0     13.0   220.0 222.0     9       103     68   442 308 26 20   0     75     13   220 222     9   103   68   442
948144 948144 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2017   grade_8 11.0 76.0 223.0   1.0     65.0     0.0   176.0 200.0     37       339     68   376 11 76 223   1     65     0   176 200     37   339   68   376
1002503 1002503 NY Putnam   school 3618120 480101060000   MAHOPAC 361812001625 480101060004 MAHOPAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 270.0 4.0 62.0         10.0     8.0   182.0 172.0     9       45     68   354 270 4 62         10     8   182 172     9   45   68   354
1012877 1012877 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003781 500402060013 CHESTNUT RIDGE MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 11.0 114.0 140.0         7.0     3.0   153.0 122.0     49       249     68   275 11 114 140         7     3   153 122     49   249   68   275
943261 943261 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 314.0 17.0 20.0   1.0     42.0     7.0   199.0 202.0     *       74     65   401 314 17 20   1     42     7   199 202         74   65   401
961615 961615 NY Erie   school 3611670 141604060000   FRONTIER 361167000920 141604060007 FRONTIER MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 349.0 2.0 19.0   3.0     7.0     14.0   207.0 187.0     *       145     65   394 349 2 19   3     7     14   207 187         145   65   394
961862 961862 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 8 2017   grade_8 432.0 7.0 11.0   4.0     10.0     9.0   214.0 259.0     *       107     65   473 432 7 11   4     10     9   214 259         107   65   473
972673 972673 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102682 332000010201 JHS 201 DYKER HEIGHTS (THE) public Regular School No Middle 06 8 2017   grade_8 191.0 1.0 75.0   0.0     228.0     0.0   265.0 230.0     41       365     65   495 191 1 75   0     228     0   265 230     41   365   65   495
995891 995891 NY Oneida   school 3624900 411800010000   ROME 362490003446 411800010010 LYNDON H STROUGH MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 326.0 26.0 36.0         6.0     2.0   195.0 201.0     *       230     65   396 326 26 36         6     2   195 201         230   65   396
1012915 1012915 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003778 500402060015 POMONA MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 3.0 133.0 132.0         13.0     9.0   148.0 142.0     57       247     65   290 3 133 132         13     9   148 142     57   247   65   290
1019945 1019945 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001081 580405060008 CANDLEWOOD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 197.0 54.0 25.0   1.0     48.0     11.0   168.0 168.0     *       55     65   336 197 54 25   1     48     11   168 168         55   65   336
1020420 1020420 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003724 580413030013 HENRY L STIMSON MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 237.0 37.0 166.0   1.0     32.0     8.0   264.0 217.0     49       235     65   481 237 37 166   1     32     8   264 217     49   235   65   481
1010787 1010787 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302130 353100010027 IS 27 ANNING S PRALL public Regular School No Middle 06 08 2017   grade_8 91.0 87.0 125.0   0.0     45.0     6.0   180.0 174.0     *       253     64   354 91 87 125   0     45     6   180 174         253   64   354
972312 972312 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102266 332000010062 JHS 62 DITMAS public Regular School No Middle 06 8 2017   grade_8 53.0 100.0 107.0   2.0     143.0     3.0   206.0 202.0     87       358     63   408 53 100 107   2     143     3   206 202     87   358   63   408
974402 974402 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302012 332200010278 JHS 278 MARINE PARK public Regular School No Middle 06 8 2017   grade_8 99.0 144.0 44.0   2.0     25.0     0.0   158.0 156.0     21       228     63   314 99 144 44   2     25     0   158 156     21   228   63   314
1000147 1000147 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003198 441000010014 MONHAGEN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 40.0 76.0 160.0         8.0     2.0   142.0 144.0     *       220     63   286 40 76 160         8     2   142 144         220   63   286
1016278 1016278 NY Steuben   school 3608400 571000010000   CORNING 360840006459 571000010020 CORNING-PAINTED POST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 277.0 7.0 7.0   1.0     22.0     9.0   166.0 157.0     *       139     63   323 277 7 7   1     22     9   166 157         139   63   323
954946 954946 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Other 08 09 2017   grade_8 327.0 58.0 13.0   0.0     2.0     27.0   219.0 208.0     *       277     62   427 327 58 13   0     2     27   219 208         277   62   427
972730 972730 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102724 332000010220 JHS 220 JOHN J PERSHING public Regular School No Middle 06 8 2017   grade_8 40.0 2.0 209.0         229.0         238.0 242.0     124       308     62   480 40 2 209         229         238 242     124   308   62   480
1000527 1000527 NY Orange   school 3619680 441301060000   VALLEY-MONTGMRY 361968001802 441301060006 VALLEY CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 240.0 34.0 62.0   0.0     7.0     5.0   167.0 181.0     *       123     62   348 240 34 62   0     7     5   167 181         123   62   348
1022016 1022016 NY Suffolk   school 3624690 580602040000   RIVERHEAD 362469003358 580602040006 RIVERHEAD MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 197.0 53.0 128.0   1.0     7.0     1.0   176.0 211.0     *       178     62   387 197 53 128   1     7     1   176 211         178   62   387
948315 948315 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2017   grade_8 7.0 24.0 236.0   0.0     4.0     2.0   141.0 132.0     55       262     61   273 7 24 236   0     4     2   141 132     55   262   61   273
986638 986638 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001682 280523030010 BERNER MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 522.0 1.0 21.0   1.0     14.0     1.0   288.0 272.0     *       56     61   560 522 1 21   1     14     1   288 272         56   61   560
997677 997677 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Other 08 09 2017   grade_8 360.0 9.0 17.0   1.0     5.0     19.0   211.0 200.0     *       102     61   411 360 9 17   1     5     19   211 200         102   61   411
1022738 1022738 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012504241 580912060001 EASTPORT-SOUTH MANOR JR-SR HS public Regular School No High 07 12 2017   grade_8 284.0 3.0 16.0   0.0     1.0     3.0   162.0 145.0     5       57     61   307 284 3 16   0     1     3   162 145     5   57   61   307
1008944 1008944 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202514 343000010141 IS 141 STEINWAY (THE) public Regular School No Middle 06 08 2017   grade_8 140.0 14.0 154.0   2.0     79.0     11.0   216.0 184.0     *       191     60   400 140 14 154   2     79     11   216 184         191   60   400
1009343 1009343 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010203146 343000011227 IS 227 LOUIS ARMSTRONG public Regular School No Middle 05 08 2017   grade_8 112.0 49.0 223.0   3.0     64.0     3.0   217.0 237.0     *       311     60   454 112 49 223   3     64     3   217 237         311   60   454
1015290 1015290 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003585 530600010024 MONT PLEASANT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 58.0 78.0 50.0   1.0     32.0     5.0   122.0 102.0     12       204     60   224 58 78 50   1     32     5   122 102     12   204   60   224
1020553 1020553 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 183.0 96.0 196.0         18.0     5.0   260.0 238.0     30       252     60   498 183 96 196         18     5   260 238     30   252   60   498
967657 967657 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202226 331500010051 MS 51 WILLIAM ALEXANDER public Regular School No Middle 06 8 2017   grade_8 240.0 23.0 54.0   1.0     41.0     10.0   176.0 193.0     5       70     59   369 240 23 54   1     41     10   176 193     5   70   59   369
982287 982287 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 78.0 197.0 104.0         23.0     17.0   218.0 201.0     20       111     59   419 78 197 104         23     17   218 201     20   111   59   419
984795 984795 NY Nassau   school 3623580 280404030000   PORT WASHINGTON 362358003288 280404030008 CARRIE PALMER WEBER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 253.0 6.0 63.0   0.0     42.0     5.0   189.0 180.0     *       61     59   369 253 6 63   0     42     5   189 180         61   59   369
962356 962356 NY Erie   school 3616230 142601030000   KENMORE 361623001412 142601030026 KENMORE WEST SENIOR HIGH SCHOOL public Regular School No High 08 12 2017   grade_8 264.0 14.0 25.0   6.0     7.0     10.0   184.0 142.0     *       127     58   326 264 14 25   6     7     10   184 142         127   58   326
1004479 1004479 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2017   grade_8 5.0 30.0 69.0   1.0     303.0     0.0   220.0 188.0     *       *     58   408 5 30 69   1     303     0   220 188             58   408
1029198 1029198 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001897 661100010014 ISAAC E YOUNG MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 40.0 85.0 261.0   1.0     20.0     1.0   212.0 196.0     41       266     58   408 40 85 261   1     20     1   212 196     41   266   58   408
973927 973927 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302007 332200010078 JHS 78 ROY H MANN public Regular School No Middle 06 8 2017   grade_8 37.0 141.0 16.0   2.0     13.0     0.0   108.0 101.0     11       175     57   209 37 141 16   2     13     0   108 101     11   175   57   209
1002655 1002655 NY Putnam   school 3606570 480102060000   CARMEL 360657000439 480102060007 GEORGE FISCHER MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_8 241.0 5.0 80.0   0.0     6.0     14.0   165.0 181.0     6       107     57   346 241 5 80   0     6     14   165 181     6   107   57   346
958005 958005 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 283.0 17.0 41.0         13.0     5.0   191.0 168.0     0       62     56   359 283 17 41         13     5   191 168     0   62   56   359
995150 995150 NY Niagara   school 3621240 400900010000   NORTH TONAWANDA 362124003007 400900010012 NORTH TONAWANDA MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 231.0 3.0 8.0   6.0     1.0     1.0   149.0 101.0     *       *     56   250 231 3 8   6     1     1   149 101             56   250
1001382 1001382 NY Oswego   school 3611700 460500010000   FULTON 361170000930 460500010006 FULTON JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 275.0 0.0 9.0   1.0     2.0     2.0   161.0 128.0     *       178     56   289 275 0 9   1     2     2   161 128         178   56   289
965396 965396 NY Jefferson   school 3630120 222000010000   WATERTOWN 363012004047 222000010013 CASE MIDDLE SCHOOL public Regular School No Middle 07 8 2017   grade_8 207.0 26.0 23.0   2.0     8.0     11.0   136.0 141.0     *       170     55   277 207 26 23   2     8     11   136 141         170   55   277
973129 973129 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202367 332100010096 IS 96 SETH LOW public Regular School No Middle 06 8 2017   grade_8 65.0 24.0 59.0   1.0     74.0     4.0   123.0 104.0     84       *     55   227 65 24 59   1     74     4   123 104     84       55   227
996442 996442 NY Oneida   school 3629370 412300010000   UTICA 362937003962 412300010023 SENATOR JAMES H DONOVAN MIDDLE SCH public Regular School No Middle 07 08 2017   grade_8 81.0 95.0 56.0   1.0     79.0     12.0   141.0 183.0     *       292     55   324 81 95 56   1     79     12   141 183         292   55   324
1016772 1016772 NY Suffolk   school 3630540 580102030000   WEST BABYLON 363054004105 580102030007 WEST BABYLON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2017   grade_8 211.0 20.0 67.0   1.0     12.0     3.0   159.0 155.0     6       *     55   314 211 20 67   1     12     3   159 155     6       55   314
1017171 1017171 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831000610 580105030006 COPIAGUE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 65.0 102.0 221.0         7.0     3.0   199.0 199.0     51       297     55   398 65 102 221         7     3   199 199     51   297   55   398
1024486 1024486 NY Ulster   school 3616290 620600010000   KINGSTON 361629001438 620600010025 M CLIFFORD MILLER MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_8 115.0 40.0 33.0   0.0     4.0     15.0   109.0 98.0             133     55   207 115 40 33   0     4     15   109 98         133   55   207
945199 945199 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008501979 320800010131 JHS 131 ALBERT EINSTEIN public Regular School No Middle 06 08 2017   grade_8 0.0 59.0 87.0   0.0     2.0     0.0   79.0 69.0     6       108     54   148 0 59 87   0     2     0   79 69     6   108   54   148
948353 948353 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2017   grade_8 3.0 34.0 156.0   1.0     5.0     0.0   102.0 97.0     66       152     54   199 3 34 156   1     5     0   102 97     66   152   54   199
949911 949911 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2017   grade_8 9.0 186.0 77.0   2.0     12.0     1.0   135.0 152.0     *       222     54   287 9 186 77   2     12     1   135 152         222   54   287
972825 972825 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 8 2017   grade_8 183.0 10.0 120.0   0.0     250.0     1.0   299.0 265.0     53       402     54   564 183 10 120   0     250     1   299 265     53   402   54   564
1007025 1007025 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002567 342800010157 JHS 157 STEPHEN A HALSEY public Regular School No Other 06 09 2017   grade_8 201.0 36.0 131.0   2.0     113.0     6.0   247.0 242.0     34       246     54   489 201 36 131   2     113     6   247 242     34   246   54   489
1014150 1014150 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000148 521301060005 BALLSTON SPA MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 304.0 8.0 5.0         7.0     1.0   177.0 148.0     *       113     54   325 304 8 5         7     1   177 148         113   54   325

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