Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_7", state = "NY" and year = 2019 sorted by low_income

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_7 · 4,719
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
2191618 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_7 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2207008 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2216375 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216451 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_7 26.0 1.0 15.0         0.0     0.0   18.0 24.0     6             5   42 26 1 15         0     0   18 24     6       5   42
2218902 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2219738 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_7 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2219909 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2019   grade_7 6.0 0.0 0.0               1.0   3.0 4.0                   0   7 6 0 0               1   3 4             0   7
2220042 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0                   0.0 0.0     *             *   0 0   0                   0 0                 0
2224640 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004508 660406030002 SEELY PLACE SCHOOL public Regular School No Elementary KG 06 2019   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
2226768 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2019   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
2227091 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2019   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
2227110 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2019   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
2227129 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2019   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
2227148 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2019   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
2227167 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2019   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
2227186 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2227205 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 254.0 5.0 28.0         76.0     19.0   201.0 181.0     *             34   382 254 5 28         76     19   201 181             34   382
2140166 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 270.0 19.0 33.0   1.0     81.0     30.0   229.0 205.0     21       *     64   434 270 19 33   1     81     30   229 205     21       64   434
2140774 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_7 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2141097 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2019   grade_7 4.0 24.0 68.0         0.0         53.0 43.0     22       *     *   96 4 24 68         0         53 43     22           96
2141135 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2019   grade_7   25.0 36.0   1.0     3.0         34.0 31.0     10       *     *   65   25 36   1     3         34 31     10           65
2141249 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2019   grade_7 1.0 28.0 51.0   1.0     1.0     0.0   31.0 51.0     7       *     22   82 1 28 51   1     1     0   31 51     7       22   82
2141401 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2019   grade_7 0.0 14.0 36.0   0.0     0.0         25.0 25.0     *       *     10   50 0 14 36   0     0         25 25             10   50
2142598 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY public Regular School No Middle 06 08 2019   grade_7 0.0 39.0 78.0   2.0     5.0         66.0 58.0     8       *     *   124 0 39 78   2     5         66 58     8           124
2143472 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE public Regular School No Middle 06 08 2019   grade_7 2.0 20.0 126.0   1.0     2.0         87.0 64.0     68       *     *   151 2 20 126   1     2         87 64     68           151
2143871 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BUSINESS ACAD MS public Regular School No Middle 06 08 2019   grade_7 1.0 39.0 60.0         1.0     1.0   55.0 47.0     39       *     32   102 1 39 60         1     1   55 47     39       32   102
2144593 NY Bronx   school 3601012 320900860980   SUCCESS ACADEMY -BRONX 2 360101206219 320900860980 SUCCESS ACADEMY CHARTER-BRONX 2 charter Regular School Yes Elementary KG 08 2019   grade_7 1.0 36.0 16.0   1.0     1.0     0.0   33.0 22.0     0       *     12   55 1 36 16   1     1     0   33 22     0       12   55
2144916 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702202 321000010045 THOMAS C GIORDANO MS 45 public Regular School No Middle 06 08 2019   grade_7 9.0 33.0 172.0   1.0     4.0     1.0   115.0 105.0     *       *     *   220 9 33 172   1     4     1   115 105                 220
2146835 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802469 321100010127 JHS 127 CASTLE HILL (THE) public Regular School No Middle 06 08 2019   grade_7 5.0 54.0 95.0   5.0     78.0     2.0   117.0 122.0     29       *     *   239 5 54 95   5     78     2   117 122     29           239
2147044 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2019   grade_7 3.0 99.0 67.0   1.0     9.0     0.0   106.0 73.0     26       *     *   179 3 99 67   1     9     0   106 73     26           179
2147063 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805953 321100010326 BRONX GREEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 22.0 22.0 75.0   1.0     4.0     0.0   68.0 56.0     30       *     *   124 22 22 75   1     4     0   68 56     30           124
2147082 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 0.0 66.0 29.0   0.0     3.0         53.0 45.0     *       *     24   98 0 66 29   0     3         53 45             24   98
2147234 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806259 321100010529 ONE WORLD MS AT EDENWALD public Regular School No Middle 06 08 2019   grade_7 0.0 67.0 37.0   3.0     2.0         64.0 45.0     7       *     *   109 0 67 37   3     2         64 45     7           109
2147272 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806314 321100010556 BRONX PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 20.0 23.0 67.0   0.0     11.0     0.0   66.0 55.0     26       *     *   121 20 23 67   0     11     0   66 55     26           121
2147291 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806322 321100010566 PELHAM GARDENS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 4.0 88.0 46.0   5.0     6.0     1.0   83.0 67.0     *       *     42   150 4 88 46   5     6     1   83 67             42   150
2148032 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002477 321200010129 MS 129 ACAD FOR INDEPENDENT LRNING public Regular School No Middle 06 08 2019   grade_7 4.0 42.0 122.0   1.0     2.0         86.0 85.0     29       *     49   171 4 42 122   1     2         86 85     29       49   171
2148089 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005166 321200010190 ESMT-IS 190 public Regular School No Middle 06 08 2019   grade_7 0.0 18.0 67.0   2.0     2.0     1.0   43.0 47.0     12       *     *   90 0 18 67   2     2     1   43 47     12           90
2148336 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009004878 321200010318 IS 318 MATH, SCIENCE & TECH THRO ART public Regular School No Middle 06 08 2019   grade_7 0.0 27.0 50.0   0.0     0.0     0.0   40.0 37.0     11       *     25   77 0 27 50   0     0     0   40 37     11       25   77
2148374 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2019   grade_7 4.0 22.0 70.0   1.0     3.0     0.0   54.0 46.0     20       *     *   100 4 22 70   1     3     0   54 46     20           100
2150141 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 5.0 0.0 0.0   0.0     0.0     0.0   3.0 2.0             *     *   5 5 0 0   0     0     0   3 2                 5
2150312 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2019   grade_7 3.0 0.0 0.0   0.0     0.0     0.0   3.0 0.0             *     *   3 3 0 0   0     0     0   3 0                 3
2150331 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_7 3.0 2.0 1.0   1.0           2.0   8.0 1.0     *       *     9   9 3 2 1   1           2   8 1             9   9
2151642 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000908 62201060002 FREDONIA MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 96.0 2.0 13.0   0.0     1.0     5.0   50.0 67.0     *       *     14   117 96 2 13   0     1     5   50 67             14   117
2151813 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099003239 62901040004 WESTFIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 42.0 0.0 3.0   0.0     1.0         22.0 24.0     *       *     9   46 42 0 3   0     1         22 24             9   46
2151965 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2019   grade_7 312.0 56.0 10.0         4.0     55.0   215.0 222.0     *       *     *   437 312 56 10         4     55   215 222                 437
2152630 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 87.0 0.0 2.0         0.0     1.0   48.0 42.0     *       *     21   90 87 0 2         0     1   48 42             21   90
2152877 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 73.0   3.0   0.0     2.0     0.0   32.0 46.0             *     *   78 73   3   0     2     0   32 46                 78
2153162 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 96.0 1.0 1.0               4.0   49.0 53.0             *     *   102 96 1 1               4   49 53                 102
2153181 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_7 1.0 0.0 1.0                   2.0 0.0             *     *   2 1 0 1                   2 0                 2
2153789 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2019   grade_7 142.0 0.0 6.0         1.0     5.0   74.0 80.0     *       *     19   154 142 0 6         1     5   74 80             19   154
2153865 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000694 31301040003 DEPOSIT MIDDLE-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 27.0 1.0 0.0   0.0               14.0 14.0             *     *   28 27 1 0   0               14 14                 28
2154283 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 101.0 37.0 62.0         4.0     11.0   93.0 122.0     *       *     48   215 101 37 62         4     11   93 122             48   215
2154625 NY Dutchess   school 3622530 131201040000   PAWLING 362253003255 131201040003 PAWLING MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 65.0 1.0 21.0         1.0     1.0   45.0 44.0     *       *     11   89 65 1 21         1     1   45 44             11   89
2155081 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000433 131602020004 ORVILLE A TODD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 71.0 20.0 20.0   0.0     14.0     3.0   66.0 62.0     *       *     16   128 71 20 20   0     14     3   66 62             16   128
2156373 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2157171 NY Erie   school 3605850 140600010000   BUFFALO 360585005939 140600010308 INTER PREP SCHOOL (THE) public Regular School No High 07 12 2019   grade_7 6.0 27.0 3.0   1.0     9.0     2.0   26.0 22.0     17       *     7   48 6 27 3   1     9     2   26 22     17       7   48
2159755 NY Essex   school 3619530 150801040000   MINERVA 361953001782 150801040001 MINERVA CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0   0.0         0.0     0.0   2.0 3.0             *     0   5 5   0         0     0   2 3             0   5
2159812 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0 0.0 0.0         0.0         5.0 0.0             *     0   5 5 0 0         0         5 0             0   5
2159926 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No Middle 06 09 2019   grade_7 59.0 0.0     0.0     0.0         34.0 25.0             *     *   59 59 0     0     0         34 25                 59
2160173 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 87.0   0.0               1.0   45.0 43.0             *     *   88 87   0               1   45 43                 88
2161389 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0 0.0 0.0         0.0     0.0   2.0 3.0             *     *   5 5 0 0         0     0   2 3                 5
2161408 NY Hamilton   school 3615330 200501080000   INLET 361533001291 200501080001 INLET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0                   0.0 0.0             *     0   0 0   0                   0 0             0   0
2161427 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Other PK 09 2019   grade_7 4.0 0.0 0.0               0.0   0.0 4.0             *     0   4 4 0 0               0   0 4             0   4
2161446 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0                       3.0 2.0             *     *   5 5                       3 2                 5
2161465 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2019   grade_7 11.0 0.0 0.0                   7.0 4.0             *     *   11 11 0 0                   7 4                 11
2162947 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009104483 331300010266 MS 266 PARK PLACE COMMUNITY MS public Regular School No Middle 06 08 2019   grade_7 3.0 29.0 10.0         0.0     0.0   26.0 16.0     *       *     17   42 3 29 10         0     0   26 16             17   42
2163099 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106366 331300010351 URBAN ASSEMBLY UNISON SCHOOL (THE) public Regular School No Middle 06 08 2019   grade_7 1.0 42.0 7.0   0.0     0.0         23.0 27.0     6       *     23   50 1 42 7   0     0         23 27     6       23   50
2164315 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905933 331400011586 LYONS COMMUNITY SCHOOL public Regular School No High 06 12 2019   grade_7 1.0 18.0 30.0   0.0     0.0     0.0   30.0 19.0     *       *     16   49 1 18 30   0     0     0   30 19             16   49
2165094 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205497 331500010448 BROOKLYN COLLABORATIVE STUDIES public Regular School No High 06 12 2019   grade_7 20.0 23.0 46.0   0.0     0.0     1.0   51.0 39.0     *       *     37   90 20 23 46   0     0     1   51 39             37   90
2165284 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205529 331500011464 PARK SLOPE COLLEGIATE public Regular School No High 06 12 2019   grade_7 30.0 19.0 30.0   1.0     1.0     2.0   45.0 38.0     *       *     14   83 30 19 30   1     1     2   45 38             14   83
2165569 NY Kings   school 3601060 331500861023   SUCCESS ACA-COBBLE HILL 360106006359 331500861023 SUCCESS ACADEMY CS-COBBLE HILL charter Regular School Yes Elementary KG 07 2019   grade_7 0.0 1.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 1 0   0     0     0   0 1     0       0   1
2166196 NY Kings   school 3601059 331600861003   LAUNCH EXPEDITIONARY LRNING 360105906349 331600861003 LAUNCH EXPEDITIONARY LRNING CHARTER charter Regular School Yes Middle 06 08 2019   grade_7 1.0 81.0 13.0   2.0     0.0     1.0   47.0 51.0     *       *     *   98 1 81 13   2     0     1   47 51                 98
2166291 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502262 331700010061 MS 61 DR GLADSTONE H ATWELL public Regular School No Middle 06 08 2019   grade_7 1.0 163.0 18.0   2.0     5.0     0.0   97.0 92.0     11       *     *   189 1 163 18   2     5     0   97 92     11           189
2166557 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009504813 331700010340 IS 340 public Regular School No Middle 06 08 2019   grade_7 1.0 46.0 7.0   1.0     0.0     0.0   28.0 27.0     *       *     *   55 1 46 7   1     0     0   28 27                 55
2166595 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505819 331700010353 ELIJAH STROUD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 3.0 37.0 12.0   1.0     4.0         32.0 25.0     7       *     *   57 3 37 12   1     4         32 25     7           57
2167336 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602283 331800010068 IS 68 ISAAC BILDERSEE public Regular School No Middle 06 08 2019   grade_7 7.0 66.0 6.0   0.0     5.0     0.0   52.0 32.0     16       *     *   84 7 66 6   0     5     0   52 32     16           84
2167640 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009605960 331800010581 EAST FLATBUSH COMM RESEARCH SCHOOL public Regular School No Middle 06 08 2019   grade_7 1.0 65.0 4.0   1.0     2.0     1.0   37.0 37.0     7       *     22   74 1 65 4   1     2     1   37 37     7       22   74
2171421 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015304070 332200010381 IS 381 public Regular School No Middle 06 08 2019   grade_7 7.0 38.0 8.0   1.0     8.0     0.0   29.0 33.0     10       *     *   62 7 38 8   1     8     0   29 33     10           62
2172561 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702582 333200010162 JHS 162 WILLOUGHBY (THE) public Regular School No Middle 06 08 2019   grade_7 1.0 2.0 68.0   1.0     5.0         37.0 40.0     *       *     *   77 1 2 68   1     5         37 40                 77
2172599 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702799 333200010291 JHS 291 ROLAND HAYES public Regular School No Middle 06 08 2019   grade_7 0.0 15.0 71.0   1.0     1.0         51.0 37.0     *       *     26   88 0 15 71   1     1         51 37             26   88
2173112 NY Lewis   school 3617820 230901040000   LOWVILLE 361782004350 230901040003 LOWVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 87.0 0.0 1.0               0.0   39.0 49.0             *     *   88 87 0 1               0   39 49                 88
2173682 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000467 250201060001 CAZENOVIA MIDDLE SCHOOL public Regular School No Middle 05 07 2019   grade_7 93.0 1.0 4.0         1.0     1.0   40.0 60.0             *     10   100 93 1 4         1     1   40 60             10   100
2175601 NY Monroe   school 3609930 261313030000   EAST ROCHESTER 360993000767 261313030002 EAST ROCHESTER JUNIOR-SENIOR HS public Regular School No High 06 12 2019   grade_7 49.0 7.0 10.0   1.0     0.0     3.0   35.0 35.0     *       *     7   70 49 7 10   1     0     3   35 35             7   70
2176665 NY Monroe   school 3624750 261600010000   ROCHESTER 362475005849 261600010089 NORTHWEST COLLEGE PREP HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 7.0 77.0 44.0   0.0     2.0         65.0 65.0     *       *     53   130 7 77 44   0     2         65 65             53   130
2177748 NY Montgomery   school 3611190 270601040000   FONDA FULTONVILLE 361119004586 270601040003 FONDA-FULTONVILLE 5-8 SCHOOL public Regular School No Middle 05 08 2019   grade_7 84.0 1.0 3.0         2.0     1.0   45.0 46.0     *       *     12   91 84 1 3         2     1   45 46             12   91
2177938 NY Nassau   school 3612180 280100010000   GLEN COVE 361218000977 280100010008 ROBERT M FINLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 74.0 13.0 126.0         6.0     2.0   107.0 114.0     *       *     *   221 74 13 126         6     2   107 114                 221
2178052 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Prekindergarten PK PK 2019   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
2178755 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001524 280205030013 JONAS E SALK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 214.0 2.0 47.0   1.0     19.0     1.0   144.0 140.0     *       *     33   284 214 2 47   1     19     1   144 140             33   284
2180047 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2019   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
2180123 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000941 280218030006 GARDEN CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 267.0 2.0 10.0         14.0     4.0   143.0 154.0     *       *     37   297 267 2 10         14     4   143 154             37   297
2181225 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 364.0 6.0 60.0   4.0     26.0     6.0   253.0 213.0     *       *     80   466 364 6 60   4     26     6   253 213             80   466
2181396 NY Nassau   school 3617730 280300010000   LONG BEACH 361773001598 280300010006 LONG BEACH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 166.0 20.0 77.0         10.0     2.0   145.0 130.0     8       *     46   275 166 20 77         10     2   145 130     8       46   275
2182156 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 09 12 2019   grade_7 0.0   0.0         0.0         0.0 0.0             *     0   0 0   0         0         0 0             0   0
2182232 NY Nassau   school 3614280 280409030000   HERRICKS 361428001179 280409030007 HERRICKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 95.0 2.0 19.0         203.0     5.0   161.0 163.0     *       *     42   324 95 2 19         203     5   161 163             42   324
2182498 NY Nassau   school 3626370 280501060000   NORTH SHORE 362637003613 280501060005 NORTH SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 164.0 0.0 15.0   0.0     12.0     6.0   97.0 100.0     *       *     34   197 164 0 15   0     12     6   97 100             34   197
2182726 NY Nassau   school 3617700 280503060000   LOCUST VALLEY 361770001664 280503060002 LOCUST VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 120.0 2.0 30.0         3.0     2.0   88.0 69.0     *       *     25   157 120 2 30         3     2   88 69             25   157
2183087 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 97.0 7.0 6.0         153.0     2.0   138.0 127.0     *       *     40   265 97 7 6         153     2   138 127             40   265
2183790 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2019   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
2183809 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504780 307500011138 PS 138 public Special Education School No Other PK 12 2019   grade_7 0.0 2.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 2 2   0     0     0   4 0                 4
2184037 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504469 307500012188 PS 188 public Special Education School No Other PK 12 2019   grade_7 1.0 3.0 2.0   0.0     0.0     0.0   6.0 0.0     0       *     6   6 1 3 2   0     0     0   6 0     0       6   6

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