Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by disability descending

View and edit SQL

year

grade

  • grade_7 · 33,145
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
1502563 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301973 353100010061 IS 61 WILLIAM A MORRIS public Regular School No Middle 06 08 2021   grade_7 39.0 110.0 168.0   0.0     11.0     9.0   151.0 186.0     40       238     99   337 39 110 168   0     11     9   151 186     40   238   99   337
1509916 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 291.0 121.0 176.0   0.0     25.0     39.0   313.0 339.0     34       266     99   652 291 121 176   0     25     39   313 339     34   266   99   652
1584529 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 2020   grade_7 34.0 5.0 265.0   3.0     201.0     2.0   238.0 272.0     76       395     99   510 34 5 265   3     201     2   238 272     76   395   99   510
1612478 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 43.0 75.0 172.0   0.0     13.0     5.0   170.0 138.0     37       273     99   308 43 75 172   0     13     5   170 138     37   273   99   308
2164733 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 08 2019   grade_7 45.0 59.0 227.0   2.0     94.0     1.0   223.0 205.0     56       344     99   428 45 59 227   2     94     1   223 205     56   344   99   428
814425 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302130 353100010027 IS 27 ANNING S PRALL public Regular School No 2 06 08 2015   grade_7 90.0 83.0 154.0   3.0     38.0     7.0   189.0 186.0             260     98   375 90 83 154   3     38     7   189 186         260   98   375
1002863 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_7 18.0 8.0 308.0   0.0     288.0     2.0   308.0 316.0     90       368     98   624 18 8 308   0     288     2   308 316     90   368   98   624
1003129 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No Middle 06 08 2017   grade_7 31.0 8.0 261.0   0.0     32.0     1.0   186.0 147.0     78       302     98   333 31 8 261   0     32     1   186 147     78   302   98   333
1003243 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2017   grade_7 65.0 6.0 272.0   1.0     44.0     1.0   207.0 182.0     69       308     98   389 65 6 272   1     44     1   207 182     69   308   98   389
1011489 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_7 322.0 7.0 38.0   3.0     43.0     2.0   235.0 180.0     *       133     98   415 322 7 38   3     43     2   235 180         133   98   415
1101492 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301974 353100010072 IS 72 ROCCO LAURIE public Regular School No 2.0 05 08 2016   grade_7 211.0 20.0 93.0   1.0     94.0     3.0   227.0 195.0             264     98   422 211 20 93   1     94     3   227 195         264   98   422
2081494 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 08 2018   grade_7 271.0 126.0 85.0   10.0     153.0     3.0   345.0 303.0     *       471     98   648 271 126 85   10     153     3   345 303         471   98   648
2110678 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 2018   grade_7 29.0 14.0 315.0   2.0     203.0     1.0   294.0 270.0     85       413     98   564 29 14 315   2     203     1   294 270     85   413   98   564
2197356 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 302.0 46.0 168.0   0.0     38.0     15.0   295.0 274.0     26       190     98   569 302 46 168   0     38     15   295 274     26   190   98   569
1502126 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301970 353100010034 IS 34 TOTTENVILLE public Regular School No Middle 06 08 2021   grade_7 219.0 1.0 70.0   3.0     20.0     4.0   153.0 164.0     10       104     97   317 219 1 70   3     20     4   153 164     10   104   97   317
1593478 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005874 500101060023 FELIX FESTA CHARACTER MIDDLE SCHOOL public Regular School No Middle 07 07 2020   grade_7 355.0 26.0 116.0         83.0     21.0   329.0 272.0     12       *     97   601 355 26 116         83     21   329 272     12       97   601
1005884 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL-HEROES public Regular School No Middle 06 08 2017   grade_7 13.0 30.0 207.0   34.0     347.0     1.0   350.0 282.0     62       *     96   632 13 30 207   34     347     1   350 282     62       96   632
1587132 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL OF HEROES public Regular School No Middle 06 08 2020   grade_7 21.0 25.0 245.0   9.0     363.0     3.0   355.0 311.0     54       554     96   666 21 25 245   9     363     3   355 311     54   554   96   666
2200149 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2019   grade_7 70.0 10.0 267.0   1.0     33.0     2.0   205.0 178.0     *       341     96   383 70 10 267   1     33     2   205 178         341   96   383
2217287 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 404.0 8.0 42.0   1.0     49.0     8.0   261.0 251.0     *       52     96   512 404 8 42   1     49     8   261 251         52   96   512
815090 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010304526 353100010075 IS 75 FRANK D PAULO public Regular School No 2 06 08 2015   grade_7 369.0 7.0 46.0   1.0     44.0     2.0   253.0 216.0             187     95   469 369 7 46   1     44     2   253 216         187   95   469
1063454 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202736 332100010228 IS 228 DAVID A BOODY public Regular School No 2.0 05 8 2016   grade_7 191.0 52.0 146.0   4.0     142.0     2.0   267.0 270.0             447     95   537 191 52 146   4     142     2   267 270         447   95   537
1463917 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 08 2021   grade_7 170.0 6.0 112.0   0.0     298.0     2.0   329.0 259.0     74       440     95   588 170 6 112   0     298     2   329 259     74   440   95   588
1491467 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 11 2021   grade_7 243.0 55.0 219.0   2.0     32.0     16.0   287.0 280.0     31       194     95   567 243 55 219   2     32     16   287 280     31   194   95   567
823982 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 494.0 7.0 35.0         42.0     3.0   308.0 273.0             48     94   581 494 7 35         42     3   308 273         48   94   581
1097217 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002718 342800010217 JHS 217 ROBERT A VAN WYCK public Regular School No 2.0 05 08 2016   grade_7 35.0 59.0 221.0   8.0     210.0     0.0   311.0 222.0             292     94   533 35 59 221   8     210     0   311 222         292   94   533
1529714 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2020   grade_7 9.0 44.0 239.0   1.0     11.0     1.0   163.0 142.0     74       279     94   305 9 44 239   1     11     1   163 142     74   279   94   305
2080791 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 08 2018   grade_7 134.0 32.0 129.0   1.0     194.0     1.0   263.0 228.0     81       437     94   491 134 32 129   1     194     1   263 228     81   437   94   491
2110469 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No Middle 06 08 2018   grade_7 29.0 7.0 277.0   1.0     28.0     0.0   153.0 189.0     67       318     94   342 29 7 277   1     28     0   153 189     67   318   94   342
2171174 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 08 2019   grade_7 255.0 88.0 91.0   5.0     138.0     4.0   259.0 322.0     53       439     94   581 255 88 91   5     138     4   259 322     53   439   94   581
751611 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No 2.0 06 08 2015   grade_7 6.0 35.0 248.0   1.0     6.0     2.0   147.0 151.0             275     93   298 6 35 248   1     6     2   147 151         275   93   298
1090472 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 358.0 46.0 118.0   0.0     43.0     3.0   286.0 282.0             *     93   568 358 46 118   0     43     3   286 282             93   568
1553977 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102735 332000010227 JHS 227 EDWARD B SHALLOW public Regular School No Middle 06 08 2020   grade_7 55.0 4.0 181.0   3.0     277.0     1.0   285.0 236.0     116       462     93   521 55 4 181   3     277     1   285 236     116   462   93   521
1592148 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302130 353100010027 IS 27 ANNING S PRALL public Regular School No Middle 06 08 2020   grade_7 82.0 79.0 139.0   1.0     53.0     8.0   187.0 175.0     17       271     93   362 82 79 139   1     53     8   187 175     17   271   93   362
2116378 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2018   grade_7 6.0 13.0 503.0   2.0     57.0     1.0   307.0 275.0     113       551     93   582 6 13 503   2     57     1   307 275     113   551   93   582
2169692 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102735 332000010227 JHS 227 EDWARD B SHALLOW public Regular School No Middle 06 08 2019   grade_7 74.0 3.0 169.0   2.0     342.0     1.0   337.0 254.0     166       543     93   591 74 3 169   2     342     1   337 254     166   543   93   591
2209364 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 155.0 81.0 349.0   3.0     21.0     2.0   307.0 304.0     61       357     93   611 155 81 349   3     21     2   307 304     61   357   93   611
1591768 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302046 353100010002 IS 2 GEORGE L EGBERT public Regular School No Middle 06 08 2020   grade_7 144.0 47.0 104.0   1.0     56.0     4.0   193.0 163.0     16       260     92   356 144 47 104   1     56     4   193 163     16   260   92   356
2208357 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301973 353100010061 IS 61 WILLIAM A MORRIS public Regular School No Middle 06 08 2019   grade_7 46.0 96.0 162.0   1.0     8.0     4.0   150.0 167.0     46       247     92   317 46 96 162   1     8     4   150 167     46   247   92   317
807034 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802464 342400010125 IS 125 THOMAS J MCCANN WOODSIDE public Regular School No 2 06 08 2015   grade_7 32.0 11.0 297.0   1.0     194.0     1.0   276.0 260.0             312     91   536 32 11 297   1     194     1   276 260         312   91   536
814748 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302216 353100010049 IS 49 BERTHA A DREYFUS public Regular School No 2 06 08 2015   grade_7 35.0 94.0 101.0   0.0     32.0     1.0   133.0 130.0             217     91   263 35 94 101   0     32     1   133 130         217   91   263
966953 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_7 50.0 84.0 289.0   2.0     38.0     4.0   219.0 248.0     37       255     91   467 50 84 289   2     38     4   219 248     37   255   91   467
1478148 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504469 307500012188 PS 188 public Special Education School No Other PK 12 2021   grade_7 3.0 26.0 60.0   0.0     2.0     0.0   66.0 25.0     26       82     91   91 3 26 60   0     2     0   66 25     26   82   91   91
1590286 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2020   grade_7 11.0 8.0 522.0   1.0     48.0     1.0   300.0 291.0     68       526     91   591 11 8 522   1     48     1   300 291     68   526   91   591
806825 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No 2 06 08 2015   grade_7 46.0 6.0 258.0   1.0     32.0         175.0 168.0             292     90   343 46 6 258   1     32         175 168         292   90   343
2107771 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 313.0 54.0 140.0   2.0     38.0     3.0   277.0 273.0     17       151     90   550 313 54 140   2     38     3   277 273     17   151   90   550
746652 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 22.0   1.0               0.0   11.0 12.0             10     9   23 22   1               0   11 12         10   9   23
747868 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BRONX GLOBAL LRNING INST FOR GIRLS charter Regular School Yes 1.0 KG 07 2015   grade_7 0.0 16.0 29.0   0.0     0.0     0.0     45.0             39     9   45 0 16 29   0     0     0     45         39   9   45
749901 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603742 320900010218 PS/IS 218 R H DUAL LANG MAGNET public Regular School No 1.0 KG 08 2015   grade_7 0.0 12.0 73.0   0.0     4.0     0.0   50.0 39.0             61     9   89 0 12 73   0     4     0   50 39         61   9   89
751041 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No 1.0 KG 08 2015   grade_7 0.0 8.0 53.0   0.0     0.0     0.0   28.0 33.0             46     9   61 0 8 53   0     0     0   28 33         46   9   61
753910 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes 1.0 KG 08 2015   grade_7   30.0 19.0   0.0     6.0         18.0 37.0             42     9   55   30 19   0     6         18 37         42   9   55
756817 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004095 50301040002 WEEDSPORT JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 56.0 0.0 1.0   0.0     0.0     2.0   34.0 25.0             20     9   59 56 0 1   0     0     2   34 25         20   9   59
757216 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No 3.0 07 12 2015   grade_7 71.0 0.0 1.0   1.0     0.0     0.0   36.0 37.0             38     9   73 71 0 1   1     0     0   36 37         38   9   73
759895 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No 4.0 06 12 2015   grade_7 38.0 0.0 1.0   0.0     1.0     1.0   20.0 21.0             24     9   41 38 0 1   0     1     1   20 21         24   9   41
761453 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 71.0 2.0 3.0         0.0     0.0   45.0 31.0             18     9   76 71 2 3         0     0   45 31         18   9   76
761757 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001772 132201040001 MILLBROOK MIDDLE SCHOOL public Regular School No 2 06 8 2015   grade_7 61.0 2.0 5.0         2.0     0.0   32.0 38.0             24     9   70 61 2 5         2     0   32 38         24   9   70
762384 NY Erie   school 3605850 140600010000   BUFFALO 360585003478 140600010001 DISCOVERY SCHOOL public Regular School No 1 PK 8 2015   grade_7 39.0 11.0 3.0   0.0     0.0     0.0   31.0 22.0             23     9   53 39 11 3   0     0     0   31 22         23   9   53
762669 NY Erie   school 3605850 140600010000   BUFFALO 360585000346 140600010053 COMMUNITY SCHOOL #53 AT #4 public Regular School No 1 PK 8 2015   grade_7 0.0 45.0 1.0         0.0     1.0   19.0 28.0             38     9   47 0 45 1         0     1   19 28         38   9   47
763486 NY Erie   school 3600038 140600860838   TAPESTRY CHARTER SCHOOL 360003804346 140600860838 TAPESTRY CHARTER SCHOOL charter Regular School Yes 4 KG 12 2015   grade_7 18.0 26.0 7.0         1.0     0.0   32.0 20.0             31     9   52 18 26 7         1     0   32 20         31   9   52
767020 NY Genesee   school 3606090 180701040000   BYRON BERGEN 360609000394 180701040001 BYRON-BERGEN JR/SR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 72.0 4.0 6.0   0.0     1.0     2.0   46.0 39.0             39     9   85 72 4 6   0     1     2   46 39         39   9   85
767742 NY Herkimer   school 3611400 210402060000   FRANKFORT-SCHUYLER 361140005755 210402060005 FRANKFORT-SCHUYLER MIDDLE SCHOOL public Regular School No 2 06 8 2015   grade_7 81.0 1.0 1.0         0.0     2.0   45.0 40.0             29     9   85 81 1 1         0     2   45 40         29   9   85
770668 NY Kings   school 3600041 331400860825   BEGINNING WITH CHLDRN CHARTER 360004104491 331400860825 BEGINNING WITH CHLDRN CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 1.0 19.0 27.0   0.0     0.0     0.0   32.0 15.0             37     9   47 1 19 27   0     0     0   32 15         37   9   47
772055 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402779 331600010262 PS 262 EL HAJJ MALIK EL SHABAZZ public Regular School No 1 PK 8 2015   grade_7 1.0 55.0 5.0         1.0         29.0 33.0             59     9   62 1 55 5         1         29 33         59   9   62
773214 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505916 331700011382 ACAD FOR COLLEGE PREP AND CAREER EXP public Regular School No 4 06 12 2015   grade_7 1.0 41.0 6.0   1.0     0.0     0.0   22.0 27.0             44     9   49 1 41 6   1     0     0   22 27         44   9   49
773594 NY Kings   school 3600147 331700860879   ACHIEVEMENT FIRST CROWN HGTS 360014705821 331700860879 ACHIEVEMENT FIRST CROWN HEIGHTS charter Regular School Yes 4 KG 12 2015   grade_7 0.0 81.0 2.0   0.0     0.0     0.0   34.0 49.0             53     9   83 0 81 2   0     0     0   34 49         53   9   83
780092 NY Livingston   school 3621450 241101040000   DALTON-NUNDA 362145003293 241101040001 DALTON-NUNDA MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 53.0   0.0               1.0   26.0 28.0             28     9   54 53   0               1   26 28         28   9   54
780586 NY Madison   school 3628140 251501040000   STOCKBRIDGE VALLEY 362814003801 251501040001 STOCKBRIDGE VALLEY CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_7 33.0   0.0   1.0           1.0   15.0 20.0             20     9   35 33   0   1           1   15 20         20   9   35
783493 NY Monroe   school 3600173 261600860906   TRUE NORTH ROCHESTER PREP CH 360017305854 261600860906 TRUE NORTH ROCHESTER PREP CHARTER charter Regular School Yes 4 KG 09 2015   grade_7 5.0 74.0 3.0                   34.0 48.0             57     9   82 5 74 3                   34 48         57   9   82
783569 NY Monroe   school 3601080 261600861020   YOUNG WOMEN'S COLLEGE PRE 360108006316 261600861020 YOUNG WOMEN'S COLLEGE PREP CHARTE charter Regular School Yes 2 07 09 2015   grade_7 0.0 46.0 22.0         0.0     4.0     72.0             59     9   72 0 46 22         0     4     72         59   9   72
790770 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504561 307500013140 PS 140 public Special Education School No 1 KG 08 2015   grade_7 0.0 8.0 1.0         0.0     0.0   7.0 2.0             *     9   9 0 8 1         0     0   7 2             9   9
793449 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701720 310200011407 INST FOR COLLABORATIVE EDUCATION public Regular School No 4 06 12 2015   grade_7 37.0 13.0 13.0   0.0     5.0     4.0   34.0 38.0             10     9   72 37 13 13   0     5     4   34 38         10   9   72
794779 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007803552 310300010243 MS 243 CENTER SCHOOL public Regular School No 2 05 08 2015   grade_7 33.0 10.0 3.0   0.0     5.0     1.0   26.0 26.0             7     9   52 33 10 3   0     5     1   26 26         7   9   52
796147 NY New York   school 3600141 310400860849   HARLEM VILLAGE ACADEMY 360014105778 310400860849 HARLEM VILLAGE ACADEMY LEADERSHIP charter Regular School Yes 4 KG 12 2015   grade_7 0.0 35.0 21.0   0.0     0.0         32.0 24.0             46     9   56 0 35 21   0     0         32 24         46   9   56
797173 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008300523 310600010018 PS 18 PARK TERRACE public Regular School No 1 KG 08 2015   grade_7 0.0 0.0 50.0         0.0         20.0 30.0             38     9   50 0 0 50         0         20 30         38   9   50
799434 NY Oneida   school 3620610 411504020000   NEW YORK MILLS 362061002891 411504020001 NY MILLS JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 45.0 2.0 2.0         0.0     2.0   27.0 24.0             23     9   51 45 2 2         0     2   27 24         23   9   51
804906 NY Orleans   school 3614610 450704040000   HOLLEY 361461001213 450704040001 HOLLEY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 78.0 4.0 2.0         0.0     6.0   34.0 56.0             58     9   90 78 4 2         0     6   34 56         58   9   90
808820 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902622 342600010178 PS/IS 178 HOLLISWOOD public Regular School No 1 PK 08 2015   grade_7 37.0 5.0 10.0   0.0     9.0     0.0   29.0 32.0             25     9   61 37 5 10   0     9     0   29 32         25   9   61
811024 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010005935 342800011284 YORK EARLY COLLEGE ACADEMY public Regular School No 4 06 12 2015   grade_7 2.0 52.0 8.0   8.0     23.0     4.0   33.0 64.0             79     9   97 2 52 8   8     23     4   33 64         79   9   97
811271 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010005832 342800011896 YOUNG WOMEN'S LRDSHP SCH-QUEENS public Regular School No 4 06 12 2015   grade_7 0.0 40.0 11.0   3.0     23.0     1.0     78.0             60     9   78 0 40 11   3     23     1     78         60   9   78
816895 NY Saint Lawrence   school 3618090 511901040000   MADRID WADDINGTON 361809001618 511901040001 MADRID-WADDINGTON JUNIOR-SENIOR HS public Regular School No 4 06 12 2015   grade_7 51.0 1.0 2.0   0.0     0.0     0.0   32.0 22.0             24     9   54 51 1 2   0     0     0   32 22         24   9   54
820106 NY Steuben   school 3623790 572301040000   PRATTSBURGH 362379003310 572301040001 PRATTSBURGH CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_7 28.0 2.0 1.0   1.0     0.0         17.0 15.0             16     9   32 28 2 1   1     0         17 15         16   9   32
826566 NY Suffolk   school 3629070 580913080000   TUCKAHOE COMMON 362907003925 580913080001 TUCKAHOE SCHOOL public Regular School No 1 PK 08 2015   grade_7 10.0 2.0 22.0         1.0         19.0 16.0             18     9   35 10 2 22         1         19 16         18   9   35
830993 NY Westchester   school 3605640 660303030000   BRONXVILLE 360564004547 660303030004 BRONXVILLE MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 122.0 0.0 5.0         8.0     4.0   76.0 63.0                   9   139 122 0 5         8     4   76 63             9   139
833064 NY Westchester   school 3621180 661301040000   NORTH SALEM 362118002991 661301040003 NORTH SALEM MIDDLE/ HIGH SCHOOL public Regular School No 4 06 12 2015   grade_7 93.0 0.0 13.0         4.0     2.0   59.0 53.0             13     9   112 93 0 13         4     2   59 53         13   9   112
943450 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 25.0 0.0 0.0   1.0     0.0     1.0   16.0 11.0             21     9   27 25 0 0   1     0     1   16 11         21   9   27
943602 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 61.0 2.0 4.0   0.0     0.0         39.0 28.0     *       44     9   67 61 2 4   0     0         39 28         44   9   67
943678 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No Other 06 12 2017   grade_7 58.0 0.0 2.0   0.0     0.0     0.0   33.0 27.0             43     9   60 58 0 2   0     0     0   33 27         43   9   60
944666 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_7 2.0 50.0 44.0   1.0     0.0     0.0   42.0 55.0     12       93     9   97 2 50 44   1     0     0   42 55     12   93   9   97
950632 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 42.0 32.0   1.0     16.0     0.0   44.0 47.0     *       73     9   91 0 42 32   1     16     0   44 47         73   9   91
953729 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 68.0   0.0   0.0     1.0     2.0   35.0 36.0             40     9   71 68   0   0     1     2   35 36         40   9   71
954641 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 43.0   1.0   0.0     0.0     1.0   22.0 23.0     *       27     9   45 43   1   0     0     1   22 23         27   9   45
955154 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059002828 70902060004 COHEN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 65.0 0.0 0.0   1.0     1.0     3.0   32.0 38.0     *       39     9   70 65 0 0   1     1     3   32 38         39   9   70
955211 NY Chenango   school 3602400 80101040000   AFTON 360240000011 80101040003 AFTON JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 30.0 0.0 1.0         2.0     1.0   18.0 16.0             21     9   34 30 0 1         2     1   18 16         21   9   34
956522 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 31.0   0.0               1.0   22.0 10.0             21     9   32 31   0               1   22 10         21   9   32
966402 NY Kings   school 3600172 331300860901   LEADERSHIP PREP BEDFORD STUY 360017205868 331300860901 LEADERSHIP PREP BEDFORD STUYVESANT charter Regular School Yes Other KG 12 2017   grade_7 0.0 79.0 6.0   0.0     1.0     0.0   47.0 39.0     0       69     9   86 0 79 6   0     1     0   47 39     0   69   9   86
967276 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011906033 331400011614 YOUNG WOMENS LEADERSHIP SCH-BROOKLY public Regular School No Other 06 12 2017   grade_7 2.0 18.0 25.0   1.0     1.0     1.0     48.0     *       39     9   48 2 18 25   1     1     1     48         39   9   48
970658 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009605960 331800010581 EAST FLATBUSH COMM RESEARCH SCHOOL public Regular School No Middle 06 8 2017   grade_7 1.0 23.0 1.0   1.0               12.0 14.0     *       24     9   26 1 23 1   1               12 14         24   9   26
983179 NY Nassau   school 3609960 280219030000   EAST ROCKAWAY 360996000769 280219030002 EAST ROCKAWAY JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_7 58.0 4.0 23.0   0.0     5.0     3.0   38.0 55.0     *       30     9   93 58 4 23   0     5     3   38 55         30   9   93
983293 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001605 280220030005 LYNBROOK NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 63.0 2.0 25.0         5.0     1.0   49.0 47.0     *       19     9   96 63 2 25         5     1   49 47         19   9   96
990893 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802539 310300010149 PS 149 SOJOURNER TRUTH public Regular School No Elementary PK 08 2017   grade_7 1.0 13.0 8.0   1.0     0.0         9.0 14.0     *       21     9   23 1 13 8   1     0         9 14         21   9   23

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