Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_9", state = "NY" and year = 2021 sorted by low_income

View and edit SQL

year

  • 2021 · 4,741

grade

  • grade_9 · 4,741
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
1434621 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_9 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1448016 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other KG 12 2021   grade_9 6.0 1.0 0.0                   4.0 3.0                       7 6 1 0                   4 3                 7
1448282 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 20.0 0.0 0.0         0.0     0.0   10.0 10.0     *             *   20 20 0 0         0     0   10 10                 20
1451493 NY Erie   school 3600071 140600860851   BUFFALO UNITED CHARTER SCH 360007105538 140600860851 BUFFALO UNITED CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0                       0 0 0 0         0     0   0 0                 0
1451740 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 2021   grade_9 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
1456224 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000959 220401040003 DEXTER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2021   grade_9 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
1467833 NY Madison   school 3605670 250109040000   BROOKFIELD 360567000292 250109040001 BROOKFIELD CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 15.0   0.0               0.0   6.0 9.0                   7   15 15   0               0   6 9             7   15
1471082 NY Monroe   school 3601117 261600861069   VERTUS CHARTER SCHOOL 360111706470 261600861069 VERTUS CHARTER SCHOOL charter Regular School Yes High 09 12 2021   grade_9 1.0 45.0 9.0         0.0         55.0                         55 1 45 9         0         55                   55
1475718 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2021   grade_9 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
1475737 NY Nassau   school 3625050 280403030000   ROSLYN 362505003471 280403030006 ROSLYN HTS ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2021   grade_9 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
1475756 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1475794 NY Nassau   school 3625050 280403030000   ROSLYN 362505003472 280403030009 ROSLYN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 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
1476098 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001013 280407030006 E M BAKER SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1476117 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001019 280407030007 JOHN F KENNEDY SCHOOL public Regular School No Elementary PK 05 2021   grade_9 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
1476136 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_9 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
1476155 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001022 280407030009 EARLY CHILDHOOD CENTER public Regular School No Elementary PK KG 2021   grade_9 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
1476174 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001023 280407030010 SADDLE ROCK SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1476193 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001015 280407030012 GREAT NECK NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 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
1476212 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001017 280407030013 GREAT NECK SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 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
1476231 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001018 280407030014 GREAT NECK SOUTH HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 48.0 4.0 17.0         215.0     7.0   129.0 162.0     12             *   291 48 4 17         215     7   129 162     12           291
1485769 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2021   grade_9 0.0   0.0         0.0     0.0   0.0 0.0                   *   0 0   0         0     0   0 0                 0
1489987 NY Onondaga   school 3600070 421800860845   SOUTHSIDE ACADEMY CHARTER SC 360007004898 421800860845 SOUTHSIDE ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_9 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
1501216 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2021   grade_9 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
1504465 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236001002 511101060005 GOUVERNEUR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 131.0 0.0 1.0         0.0     0.0   72.0 60.0     *             23   132 131 0 1         0     0   72 60             23   132
1504503 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236006655 511101060008 GOUVERNEUR MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_9 0.0 0.0 0.0                   0.0 0.0     *             0   0 0 0 0                   0 0             0   0
1510602 NY Suffolk   school 3629760 580302080000   WAINSCOTT 362976003999 580302080001 WAINSCOTT SCHOOL public Regular School No Elementary KG 03 2021   grade_9 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1510621 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2021   grade_9 0.0 0.0 0.0         0.0         0.0 0.0     *             0   0 0 0 0         0         0 0             0   0
1510697 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2021   grade_9 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
1513148 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary KG 06 2021   grade_9 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
1513984 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2021   grade_9 0.0   0.0                   0.0 0.0                   *   0 0   0                   0 0                 0
1514155 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2021   grade_9 4.0 0.0 0.0               1.0   2.0 3.0                   0   5 4 0 0               1   2 3             0   5
1514288 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2021   grade_9 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
1518886 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004508 660406030002 SEELY PLACE SCHOOL public Regular School No Elementary KG 06 2021   grade_9 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
1520159 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 08 2021   grade_9 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
1521014 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1521299 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463003350 661905020002 BLIND BROOK HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 74.0 0.0 4.0         5.0     12.0   43.0 52.0     *             9   95 74 0 4         5     12   43 52             9   95
1521337 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2021   grade_9 0.0   0.0         0.0     0.0   0.0 0.0     0             0   0 0   0         0     0   0 0     0       0   0
1521356 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1521375 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1521394 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1521413 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1521432 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 252.0 5.0 30.0   0.0     73.0     19.0   197.0 182.0     *             40   379 252 5 30   0     73     19   197 182             40   379
1521451 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 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
1522420 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2021   grade_9 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
1434450 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 6.0   0.0                   3.0 3.0     *       *     0   6 6   0                   3 3             0   6
1436844 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 0.0 3.0 4.0   0.0     0.0         3.0 4.0     0       *     *   7 0 3 4   0     0         3 4     0           7
1438402 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605175 320900011404 SCHOOL FOR EXCELLENCE public Regular School No High 08 12 2021   grade_9 1.0 8.0 21.0   0.0     0.0         19.0 11.0     7       *     11   30 1 8 21   0     0         19 11     7       11   30
1441537 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805683 321100011265 BRONX LAB SCHOOL public Regular School No High 08 12 2021   grade_9 1.0 21.0 31.0   0.0     2.0         32.0 23.0     8       *     17   55 1 21 31   0     2         32 23     8       17   55
1444045 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 12.0   0.0   0.0           0.0   5.0 7.0             *     *   12 12   0   0           0   5 7                 12
1444463 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2021   grade_9 10.0 0.0 1.0   0.0     0.0     0.0   9.0 2.0             *     10   11 10 0 1   0     0     0   9 2             10   11
1444482 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2021   grade_9 3.0 1.0 0.0   1.0     0.0     4.0   6.0 3.0             *     9   9 3 1 0   1     0     4   6 3             9   9
1444558 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_9         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1445356 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 06 10 2021   grade_9 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
1446135 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Secondary 09 09 2021   grade_9 296.0 52.0 13.0         5.0     57.0   210.0 213.0     5       *     *   423 296 52 13         5     57   210 213     5           423
1447997 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000694 31301040003 DEPOSIT MIDDLE-SENIOR HIGH SCHOOL public Regular School No High 06 12 2021   grade_9 29.0 2.0 1.0   0.0           0.0   15.0 17.0             *     *   32 29 2 1   0           0   15 17                 32
1448738 NY Dutchess   school 3622530 131201040000   PAWLING 362253003173 131201040002 PAWLING HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 65.0 2.0 23.0         1.0     1.0   48.0 44.0     *       *     9   92 65 2 23         1     1   48 44             9   92
1449650 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   grade_9 5.0 0.0 1.0         0.0     0.0   2.0 4.0             *     *   6 5 0 1         0     0   2 4                 6
1449954 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004219 140203060004 WILLIAMSVILLE SOUTH HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 149.0 12.0 11.0   0.0     15.0     9.0   95.0 101.0     *       *     25   196 149 12 11   0     15     9   95 101             25   196
1453830 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2021   grade_9 14.0 0.0 0.0   0.0     0.0     1.0   6.0 9.0             *     *   15 14 0 0   0     0     1   6 9                 15
1453849 NY Essex   school 3619530 150801040000   MINERVA 361953001782 150801040001 MINERVA CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 7.0   0.0               0.0   4.0 3.0             *     0   7 7   0               0   4 3             0   7
1453906 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 6.0 0.0 0.0         0.0         5.0 1.0             *     0   6 6 0 0         0         5 1             0   6
1454514 NY Fulton   school 3612270 170500010000   GLOVERSVILLE 361227000986 170500010008 GLOVERSVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 2.0 0.0 0.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 2 0 0   0     0     0   1 1                 2
1455445 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 6.0 0.0 2.0               0.0   4.0 4.0     *       *     *   8 6 0 2               0   4 4                 8
1455464 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2021   grade_9 12.0 0.0 0.0                   6.0 6.0             *     *   12 12 0 0                   6 6                 12
1455768 NY Herkimer   school 3622200 211701040000   VAN HORNSVILLE 362220003142 211701040001 OWEN D YOUNG CENTRAL SCHOOL public Regular School No Other KG 12 2021   grade_9 11.0   0.0               0.0   4.0 7.0     *       *     0   11 11   0               0   4 7             0   11
1456300 NY Jefferson   school 3607650 220701040000   THOUSAND ISLANDS 360765000548 220701040003 THOUSAND ISLANDS HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 45.0 0.0 4.0   0.0           1.0   20.0 30.0     *       *     *   50 45 0 4   0           1   20 30                 50
1457212 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101928 331300011430 BROOKLYN TECHNICAL HIGH SCHOOL public Regular School No High 08 12 2021   grade_9 293.0 91.0 106.0   11.0     795.0     133.0   814.0 615.0     *       *     35   1429 293 91 106   11     795     133   814 615             35   1429
1461240 NY Kings   school 3600148 331700860882   KIPP AMP CHARTER SCHOOL 360014805822 331700860882 KIPP AMP CHARTER SCHOOL charter Regular School Yes Other KG 09 2021   grade_9 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 0 1   0     0     0   0 1     0       0   1
1466484 NY Kings   school 3601032 332300860936   OCEAN HILL COLLEGIATE CHA 360103206229 332300860936 OCEAN HILL COLLEGIATE CHARTER SCH charter Regular School Yes Other KG 09 2021   grade_9 0.0 5.0 0.0   1.0     0.0     0.0   2.0 4.0     0       *     0   6 0 5 0   1     0     0   2 4     0       0   6
1466959 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009705725 333200010564 BUSHWICK COMMUNITY HS public Regular School No High 09 12 2021   grade_9   1.0 5.0                   4.0 2.0     0       *     *   6   1 5                   4 2     0           6
1468042 NY Madison   school 3606390 250901060000   CANASTOTA 360639000419 250901060004 CANASTOTA HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 71.0 3.0 3.0   2.0     2.0     3.0   47.0 37.0     *       *     18   84 71 3 3   2     2     3   47 37             18   84
1469904 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No Elementary KG 05 2021   grade_9 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
1470113 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003380 261600010005 SCHOOL 5-JOHN WILLIAMS public Regular School No Elementary PK 08 2021   grade_9 0.0 0.0 0.0   0.0     1.0     0.0   1.0 0.0     *       *     0   1 0 0 0   0     1     0   1 0             0   1
1470759 NY Monroe   school 3624750 261600010000   ROCHESTER 362475005849 261600010089 NORTHWEST COLLEGE PREP HIGH SCHOOL public Regular School No Middle 07 09 2021   grade_9 0.0 1.0 0.0         0.0     0.0   0.0 1.0     0       *     0   1 0 1 0         0     0   0 1     0       0   1
1474141 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2021   grade_9 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
1474160 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2021   grade_9 0.0   0.0         0.0     0.0   0.0 0.0     *       *     0   0 0   0         0     0   0 0             0   0
1474179 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No Elementary KG 01 2021   grade_9 0.0   0.0         0.0         0.0 0.0     0       *     0   0 0   0         0         0 0     0       0   0
1474255 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000942 280218030007 GARDEN CITY HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 227.0 2.0 13.0         14.0     4.0   119.0 141.0     *       *     30   260 227 2 13         14     4   119 141             30   260
1474464 NY Nassau   school 3624780 280221030000   ROCKVILLE CENTRE 362478003431 280221030001 SOUTH SIDE HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 0.0 0.0 5.0         0.0     1.0   2.0 4.0     *       *     0   6 0 0 5         0     1   2 4             0   6
1475414 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001724 280253070007 JOHN F KENNEDY HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 202.0 5.0 23.0   1.0     6.0     2.0   125.0 114.0     *       *     25   239 202 5 23   1     6     2   125 114             25   239
1475775 NY Nassau   school 3625050 280403030000   ROSLYN 362505003470 280403030008 ROSLYN HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 181.0 8.0 8.0         44.0     3.0   134.0 110.0             *     19   244 181 8 8         44     3   134 110             19   244
1476250 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001016 280407030015 GREAT NECK NORTH HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 191.0 2.0 7.0         50.0     3.0   124.0 129.0     5       *     45   253 191 2 7         50     3   124 129     5       45   253
1476269 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2021   grade_9 6.0   1.0         1.0         5.0 3.0             *     *   8 6   1         1         5 3                 8
1476592 NY Nassau   school 3626370 280501060000   NORTH SHORE 362637003614 280501060004 NORTH SHORE SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 149.0 0.0 16.0   0.0     14.0     6.0   85.0 100.0     *       *     38   185 149 0 16   0     14     6   85 100             38   185
1477846 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863003506 280523030014 MHS AMES CAMPUS public Regular School No Secondary 09 09 2021   grade_9 458.0 2.0 26.0   2.0     12.0     6.0   246.0 260.0     *       *     60   506 458 2 26   2     12     6   246 260             60   506
1477903 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_9 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 0 1 1   0     0     0   2 0     0           2
1477941 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502601 307500011169 PS 169 ROBERT F KENNEDY public Special Education School No Other KG 12 2021   grade_9 0.0 1.0 3.0   0.0     1.0     0.0   5.0 0.0     *       *     *   5 0 1 3   0     1     0   5 0                 5
1477998 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502870 307500011751 MANHATTAN SCHOOL FOR CAREER DVLPMNT public Special Education School No High 07 12 2021   grade_9 0.0 9.0 5.0   1.0     0.0     0.0   10.0 5.0     *       *     *   15 0 9 5   1     0     0   10 5                 15
1478036 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504560 307500012010 PS 10 public Special Education School No Other PK 12 2021   grade_9 0.0 0.0 2.0   0.0     0.0     0.0   0.0 2.0     0       *     *   2 0 0 2   0     0     0   0 2     0           2
1478093 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502224 307500012168 PS 168 public Special Education School No Other PK 12 2021   grade_9 0.0 0.0 3.0   0.0     0.0     0.0   3.0 0.0     0       *     *   3 0 0 3   0     0     0   3 0     0           3
1478283 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502844 307500012811 PS 811 public Special Education School No High 09 12 2021   grade_9 0.0 7.0 15.0   0.0     2.0         17.0 7.0     *       *     *   24 0 7 15   0     2         17 7                 24
1478321 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504476 307500013036 PS 36 public Special Education School No Other PK 12 2021   grade_9 0.0 1.0 3.0   0.0     0.0         2.0 2.0     *       *     *   4 0 1 3   0     0         2 2                 4
1478359 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502311 307500013077 PS 77 public Special Education School No Other KG 12 2021   grade_9 0.0 5.0 2.0         0.0         6.0 1.0     0       *     7   7 0 5 2         0         6 1     0       7   7
1478397 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504477 307500013141 PS 141 public Special Education School No Other PK 12 2021   grade_9 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 1 0 0   0     0     0   0 1     0           1
1478530 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500806 307500013373 PS 373 BROOKLYN TRANSITION CENTER public Special Education School No Secondary 09 11 2021   grade_9 1.0 17.0 8.0   0.0     3.0     1.0   18.0 12.0     *       *     *   30 1 17 8   0     3     1   18 12                 30
1478663 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502070 307500014009 PS 9 public Special Education School No Elementary KG 08 2021   grade_9 2.0 0.0 1.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 2 0 1   0     0     0   2 1                 3
1478701 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502305 307500014075 ROBERT E PEARY SCHOOL public Special Education School No Elementary PK 08 2021   grade_9 0.0 1.0 0.0   0.0     1.0     0.0   2.0 0.0     *       *     *   2 0 1 0   0     1     0   2 0                 2
1478891 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504818 307500014993 PS 993 public Special Education School No Other KG 12 2021   grade_9 1.0 3.0 3.0   0.0     2.0     0.0   6.0 3.0     *       *     9   9 1 3 3   0     2     0   6 3             9   9
1478929 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502170 307500015037 DAVID MARQUIS SCHOOL OF THE ARTS public Special Education School No Other PK 09 2021   grade_9 1.0 0.0 1.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 1 0 1   0     0     0   2 0     0           2
1478967 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502864 307500015721 RICHARD H HUNGERFORD SCHOOL (THE) public Special Education School No Secondary 09 09 2021   grade_9 2.0 5.0 3.0   0.0     0.0     0.0   7.0 3.0     *       *     *   10 2 5 3   0     0     0   7 3                 10

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