Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_7", state = "NY" and year = 2020 sorted by low_income

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_7 · 4,742
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
1524698 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_7 0.0                       0.0 0.0                       0 0                       0 0                 0
1575922 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2020   grade_7 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1576967 NY Oneida   school 3620610 411504020000   NEW YORK MILLS 362061002891 411504020001 NY MILLS JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 36.0 2.0 3.0         0.0     1.0   19.0 23.0                       42 36 2 3         0     1   19 23                 42
1576986 NY Oneida   school 3620610 411504020000   NEW YORK MILLS 362061001416 411504020003 NY MILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0                       0 0 0 0   0     0     0   0 0                 0
1591350 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2020   grade_7 0.0   0.0         0.0         0.0 0.0                   *   0 0   0         0         0 0                 0
1600755 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     0             0   0 0 0 0               0   0 0     0       0   0
1600831 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2020   grade_7 20.0 2.0 16.0         1.0     0.0   18.0 21.0     *             6   39 20 2 16         1     0   18 21             6   39
1603282 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *             0   0 0 0 0         0         0 0             0   0
1604118 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2020   grade_7 0.0   0.0                   0.0 0.0                   *   0 0   0                   0 0                 0
1604289 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2020   grade_7 9.0 0.0 1.0               1.0   5.0 6.0                   0   11 9 0 1               1   5 6             0   11
1604422 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0   0.0               0.0   0.0 0.0                   *   0 0   0               0   0 0                 0
1609020 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004508 660406030002 SEELY PLACE SCHOOL public Regular School No Elementary KG 06 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1611129 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0   0   0     0     0   0 0     0       0   0
1611452 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1611471 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
1611490 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1611509 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1611528 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1611547 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
1611566 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 238.0 2.0 24.0         92.0     25.0   187.0 194.0     5             33   381 238 2 24         92     25   187 194     5       33   381
1523577 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 280.0 12.0 6.0         29.0     7.0   165.0 169.0     5       *     39   334 280 12 6         29     7   165 169     5       39   334
1524090 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   grade_7 271.0 14.0 25.0   3.0     83.0     23.0   219.0 200.0     16       *     *   419 271 14 25   3     83     23   219 200     16           419
1525648 NY Bronx   school 3601011 320700860981   SUCCESS ACADEMY-BRONX 1 360101106211 320700860981 SUCCESS ACADEMY CHARTER-BRONX 1 charter Regular School Yes Elementary KG 07 2020   grade_7 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     0   1 0 1 0   0     0     0   1 0     0       0   1
1525762 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 07 2020   grade_7 0.0 8.0 5.0               0.0   7.0 6.0     0       *     0   13 0 8 5               0   7 6     0       0   13
1526446 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505122 320800010302 MS 302 LUISA DESSUS CRUZ public Regular School No Middle 06 08 2020   grade_7 1.0 24.0 112.0   1.0     1.0     0.0   75.0 64.0     20       *     *   139 1 24 112   1     1     0   75 64     20           139
1527130 NY Bronx   school 3601096 320800861044   SUCCESS ACAD CHARTER SCH-BR 3 360109606390 320800861044 SUCCESS ACAD CHARTER SCH-BRONX 3 charter Regular School Yes Elementary KG 07 2020   grade_7 0.0 56.0 46.0   2.0     1.0     2.0   57.0 50.0     0       *     5   107 0 56 46   2     1     2   57 50     0       5   107
1527890 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603767 320900010313 IS 313 SCHOOL OF LEADERSHIP DEV public Regular School No Middle 06 08 2020   grade_7 0.0 15.0 67.0   2.0     0.0         53.0 31.0     37       *     *   84 0 15 67   2     0         53 31     37           84
1527909 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2020   grade_7 3.0 28.0 73.0   1.0     3.0     0.0   51.0 57.0     33       *     *   108 3 28 73   1     3     0   51 57     33           108
1527985 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2020   grade_7 3.0 25.0 88.0               0.0   56.0 60.0     *       *     *   116 3 25 88               0   56 60                 116
1528441 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605177 320900011413 BRONX HS FOR MEDICAL SCIENCE public Regular School No High 06 12 2020   grade_7 0.0 11.0 27.0   0.0     4.0     0.0   25.0 17.0     8       *     11   42 0 11 27   0     4     0   25 17     8       11   42
1532431 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005691 321200010316 KAPPA III public Regular School No Middle 06 08 2020   grade_7 0.0 29.0 86.0   1.0     2.0     1.0   63.0 56.0     12       *     31   119 0 29 86   1     2     1   63 56     12       31   119
1534255 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 1 0 0   0     0     0   1 0                 1
1534445 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2020   grade_7 5.0 1.0 3.0   0.0           1.0   10.0 0.0             *     10   10 5 1 3   0           1   10 0             10   10
1534464 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0           0.0   1.0 0.0             *     *   1 1 0 0   0           0   1 0                 1
1534521 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2020   grade_7         0.0           0.0   0.0               *         0         0           0   0                   0
1536117 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2020   grade_7 310.0 65.0 12.0   1.0     1.0     68.0   239.0 218.0     *       *     *   457 310 65 12   1     1     68   239 218                 457
1536877 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 73.0 3.0 0.0                   34.0 42.0             *     17   76 73 3 0                   34 42             17   76
1537352 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_7 0.0 2.0 0.0                   1.0 1.0             *     *   2 0 2 0                   1 1                 2
1538245 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 74.0 1.0 8.0               5.0   48.0 40.0     *       *     *   88 74 1 8               5   48 40                 88
1539575 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   grade_7 255.0 35.0 106.0         16.0     11.0   222.0 201.0     *       *     72   423 255 35 106         16     11   222 201             72   423
1540525 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2020   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     0       *     *   0 0 0 0         0         0 0     0           0
1541209 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2020   grade_7 2.0 3.0 2.0   0.0           0.0   3.0 4.0     *       *     *   7 2 3 2   0           0   3 4                 7
1542292 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001065 141101060004 GRIFFITH INST MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 140.0   2.0   2.0           1.0   79.0 66.0             *     19   145 140   2   2           1   79 66             19   145
1543850 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2020   grade_7 11.0 0.0 1.0   0.0           0.0   7.0 5.0             *     *   12 11 0 1   0           0   7 5                 12
1543926 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 4.0   0.0         0.0         1.0 3.0             *     *   4 4   0         0         1 3                 4
1544477 NY Franklin   school 3627990 161801040000   ST REGIS FALLS 362799003793 161801040001 ST REGIS FALLS CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 17.0 0.0 0.0   1.0           2.0   11.0 9.0     *       *     6   20 17 0 0   1           2   11 9             6   20
1545389 NY Greene   school 3608490 190501040000   COXSACKIE ATHENS 360849004765 190501040004 COXSACKIE-ATHENS MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 85.0 2.0 9.0   1.0     2.0     4.0   54.0 49.0     *       *     23   103 85 2 9   1     2     4   54 49             23   103
1545522 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 4.0 1.0 0.0         0.0     0.0   3.0 2.0             *     *   5 4 1 0         0     0   3 2                 5
1545541 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Elementary PK 08 2020   grade_7 8.0                   1.0   3.0 6.0             *     *   9 8                   1   3 6                 9
1545560 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 5.0 0.0 0.0                   2.0 3.0     *       *     *   5 5 0 0                   2 3                 5
1545579 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2020   grade_7 8.0 1.0 0.0                   5.0 4.0             *     *   9 8 1 0                   5 4                 9
1545978 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701787 212101040001 GREGORY B JARVIS MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 142.0 0.0 7.0         1.0     11.0   80.0 81.0     *       *     30   161 142 0 7         1     11   80 81             30   161
1546757 NY Jefferson   school 3606630 222201060000   CARTHAGE 360663000445 222201060011 CARTHAGE MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 156.0 17.0 21.0   2.0     2.0     21.0   101.0 118.0     *       *     47   219 156 17 21   2     2     21   101 118             47   219
1547042 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102781 331300010265 DR SUSAN S MCKINNEY SEC SCH-ARTS public Regular School No High 06 12 2020   grade_7 1.0 18.0 6.0   0.0     0.0     0.0   12.0 13.0     0       *     12   25 1 18 6   0     0     0   12 13     0       12   25
1547213 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106366 331300010351 URBAN ASSEMBLY UNISON SCHOOL (THE) public Regular School No Middle 06 08 2020   grade_7 0.0 39.0 8.0   1.0     1.0         26.0 23.0     *       *     *   49 0 39 8   1     1         26 23                 49
1547251 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106704 331300010915 IS 915 public Regular School No Middle 06 08 2020   grade_7 26.0 27.0 12.0   1.0     3.0     5.0   39.0 35.0     *       *     17   74 26 27 12   1     3     5   39 35             17   74
1547726 NY Kings   school 3601111 331300861063   BROOKLYN LABORATORY CHARTER S 360111106493 331300861063 BROOKLYN LABORATORY CHARTER SCHOOL charter Regular School Yes Secondary 06 11 2020   grade_7 0.0 59.0 10.0   2.0     1.0     2.0   47.0 27.0     0       *     30   74 0 59 10   2     1     2   47 27     0       30   74
1548258 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905701 331400010577 CONSELYEA PREPARATORY SCHOOL public Regular School No Middle 06 08 2020   grade_7 59.0 7.0 81.0   1.0     7.0     0.0   72.0 83.0     *       *     36   155 59 7 81   1     7     0   72 83             36   155
1548847 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202226 331500010051 MS 51 WILLIAM ALEXANDER public Regular School No Middle 06 08 2020   grade_7 182.0 23.0 90.0   1.0     71.0     19.0   184.0 202.0     *       *     86   386 182 23 90   1     71     19   184 202             86   386
1550823 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505820 331700010354 SCHOOL OF INTEGRATED LRNING (THE) public Regular School No Middle 06 08 2020   grade_7 1.0 92.0 17.0   3.0     1.0     1.0   47.0 68.0     *       *     *   115 1 92 17   3     1     1   47 68                 115
1551469 NY Kings   school 3601095 331700861041   SUCCESS ACAD-CROWN HEIGHTS 360109506413 331700861041 SUCCESS ACAD CHARTER SCH-CROWN HGTS charter Regular School Yes Elementary KG 07 2020   grade_7 1.0 68.0 6.0   0.0     2.0     2.0   35.0 44.0     0       *     6   79 1 68 6   0     2     2   35 44     0       6   79
1551583 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602283 331800010068 IS 68 ISAAC BILDERSEE public Regular School No Middle 06 08 2020   grade_7 6.0 47.0 8.0         6.0     1.0   47.0 21.0     20       *     *   68 6 47 8         6     1   47 21     20           68
1552495 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002604 331900010171 IS 171 ABRAHAM LINCOLN public Regular School No Middle 06 08 2020   grade_7 0.0 13.0 89.0   2.0     9.0         68.0 45.0     34       *     *   113 0 13 89   2     9         68 45     34           113
1552875 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006419 331900010662 LIBERTY AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 3.0 38.0 109.0   4.0     6.0     0.0   74.0 86.0     27       *     41   160 3 38 109   4     6     0   74 86     27       41   160
1552951 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006483 331900010760 HIGHLAND PARK COMMUNITY SCHOOL public Regular School No Middle 06 08 2020   grade_7 4.0 14.0 87.0   3.0     6.0     0.0   60.0 54.0     21       *     *   114 4 14 87   3     6     0   60 54     21           114
1554756 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 08 2020   grade_7 121.0 22.0 89.0   2.0     176.0     2.0   215.0 197.0     74       *     82   412 121 22 89   2     176     2   215 197     74       82   412
1555155 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302007 332200010078 JHS 78 ROY H MANN public Regular School No Middle 06 08 2020   grade_7 30.0 116.0 24.0   5.0     9.0     3.0   105.0 82.0     9       *     49   187 30 116 24   5     9     3   105 82     9       49   187
1555611 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302012 332200010278 JHS 278 MARINE PARK public Regular School No Middle 06 08 2020   grade_7 122.0 138.0 65.0   1.0     49.0     6.0   189.0 192.0     14       *     69   381 122 138 65   1     49     6   189 192     14       69   381
1558461 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000275 260101060008 TWELVE CORNERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 189.0 22.0 18.0   1.0     20.0     26.0   139.0 137.0     *       *     *   276 189 22 18   1     20     26   139 137                 276
1560000 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
1560133 NY Monroe   school 3607530 261501060000   CHURCHVILLE CHILI 360753002002 261501060008 CHURCHVILLE-CHILI MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 224.0 22.0 17.0   3.0     10.0     23.0   147.0 152.0     8       *     32   299 224 22 17   3     10     23   147 152     8       32   299
1560190 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003379 261600010004 SCHOOL 4-GEORGE MATHER FORBES public Regular School No Elementary KG 08 2020   grade_7 0.0 4.0 0.0         0.0     0.0   3.0 1.0     0       *     *   4 0 4 0         0     0   3 1     0           4
1560342 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003390 261600010016 SCHOOL 16-JOHN WALTON SPENCER public Regular School No Elementary PK 07 2020   grade_7 0.0 2.0 0.0   0.0     0.0     0.0   1.0 1.0     *       *     0   2 0 2 0   0     0     0   1 1             0   2
1561938 NY Montgomery   school 3606300 270301040000   CANAJOHARIE 360630000410 270301040003 CANAJOHARIE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 56.0 1.0 2.0               0.0   32.0 27.0     *       *     6   59 56 1 2               0   32 27             6   59
1564104 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001504 280215030008 LAWRENCE MIDDLE SCHOOL-BROADWAY CAMP public Regular School No Middle 06 08 2020   grade_7 24.0 36.0 106.0   6.0     11.0     1.0   107.0 77.0     26       *     26   184 24 36 106   6     11     1   107 77     26       26   184
1564294 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2020   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       *     0   0 0 0 0         0     0   0 0             0   0
1564313 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2020   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0       *     0   0 0   0         0     0   0 0     0       0   0
1564332 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No Elementary KG 01 2020   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0       *     0   0 0   0         0     0   0 0     0       0   0
1565491 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 368.0 23.0 60.0   0.0     31.0     8.0   238.0 252.0     *       *     *   490 368 23 60   0     31     8   238 252                 490
1565510 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001726 280253070004 MERRICK AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 304.0 9.0 24.0   0.0     21.0     6.0   183.0 181.0     *       *     *   364 304 9 24   0     21     6   183 181                 364
1565947 NY Nassau   school 3625050 280403030000   ROSLYN 362505003472 280403030009 ROSLYN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 156.0 8.0 10.0   0.0     53.0     3.0   111.0 119.0     *       *     17   230 156 8 10   0     53     3   111 119             17   230
1566422 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2020   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             *     0   0 0 0 0         0         0 0             0   0
1567125 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003250 280504060006 H B MATTLIN MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 157.0 0.0 8.0         33.0     3.0   92.0 109.0     0       *     38   201 157 0 8         33     3   92 109     0       38   201
1568018 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 03 12 2020   grade_7 0.0 1.0 0.0   0.0     1.0         0.0 2.0     0       *     *   2 0 1 0   0     1         0 2     0           2
1568056 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2020   grade_7 0.0 1.0 2.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 1 2   0     0     0   2 1                 3
1568493 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504605 307500013053 PS 53 public Special Education School No Other KG 12 2020   grade_7 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 1 0   0     0     0   1 0     0           1
1568512 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502311 307500013077 PS 77 public Special Education School No Other KG 12 2020   grade_7 0.0 1.0 2.0         0.0         2.0 1.0     0       *     *   3 0 1 2         0         2 1     0           3
1568550 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504477 307500013141 PS 141 public Special Education School No Other PK 11 2020   grade_7 0.0 0.0 1.0   0.0     0.0     1.0   2.0 0.0     *       *     *   2 0 0 1   0     0     1   2 0                 2
1568569 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504478 307500013231 PS 231 public Special Education School No Elementary KG 08 2020   grade_7 1.0 0.0 4.0   0.0     0.0     0.0   5.0 0.0     *       *     *   5 1 0 4   0     0     0   5 0                 5
1568778 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013501926 307500013811 PS 811 CONNIE LEKAS SCHOOL public Special Education School No High 06 12 2020   grade_7 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 1 0   0     0     0   1 0     0           1
1568873 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504354 307500014177 PS 177 public Special Education School No Other KG 10 2020   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1568892 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502858 307500014224 PS 224 public Special Education School No Elementary PK 08 2020   grade_7 1.0 1.0 2.0   1.0     1.0     0.0   2.0 4.0     *       *     6   6 1 1 2   1     1     0   2 4             6   6
1568968 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013506368 307500014277 RIVERVIEW SCHOOL (THE) public Special Education School No Other KG 10 2020   grade_7 0.0 1.0 4.0   0.0     0.0     0.0   4.0 1.0     0       *     5   5 0 1 4   0     0     0   4 1     0       5   5
1569025 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502843 307500014811 PS Q811 public Special Education School No Other KG 12 2020   grade_7 1.0 1.0 0.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 1 1 0   0     0     0   2 0     0           2
1569044 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504818 307500014993 PS 993 public Special Education School No Other KG 12 2020   grade_7 0.0 5.0 0.0   0.0     0.0     0.0   3.0 2.0     0       *     5   5 0 5 0   0     0     0   3 2     0       5   5
1569082 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502170 307500015037 DAVID MARQUIS SCHOOL OF THE ARTS public Special Education School No Elementary PK 08 2020   grade_7 2.0 0.0 0.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 2 0 0   0     0     0   2 0     0           2
1569101 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500957 307500015373 PS 373 public Special Education School No Elementary PK 07 2020   grade_7 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 0 1   0     0     0   1 0     0           1
1569120 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502864 307500015721 RICHARD H HUNGERFORD SCHOOL (THE) public Special Education School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1569386 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007605616 310100010332 UNIVERSITY NEIGHBORHOOD MIDDLE public Regular School No Middle 06 08 2020   grade_7 8.0 16.0 41.0         5.0     0.0   42.0 28.0     *       *     31   70 8 16 41         5     0   42 28             31   70
1570735 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706462 310200010933 CITY KNOLL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 3.0 9.0 21.0   0.0     3.0     0.0   20.0 16.0     *       *     *   36 3 9 21   0     3     0   20 16                 36

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