Data source: Big Local News · About: Big Local

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

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
1433310 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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
1434051 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2021   grade_9 12.0 1.0 1.0               4.0   5.0 13.0             10     9   18 12 1 1               4   5 13         10   9   18
1434374 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2021   grade_9 20.0 0.0 0.0               1.0   12.0 9.0     *       7     *   21 20 0 0               1   12 9         7       21
1434412 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 22.0 0.0 0.0               0.0   10.0 12.0             12     *   22 22 0 0               0   10 12         12       22
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
1434526 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 20.0 0.0 0.0   0.0           0.0   9.0 11.0             9     *   20 20 0 0   0           0   9 11         9       20
1434583 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2021   grade_9 65.0 1.0 1.0               0.0   37.0 30.0             39     6   67 65 1 1               0   37 30         39   6   67
1434602 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY 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
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
1434735 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON 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   0   0
1434982 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA 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
1435058 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY 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
1435267 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Career and Technical School No High 09 12 2021   grade_9 0.0 33.0 71.0   0.0           0.0   85.0 19.0     20       103     51   104 0 33 71   0           0   85 19     20   103   51   104
1435381 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406714 320700011625 WALKABOUT BRONX HIGH SCHOOL public Regular School No Secondary 09 09 2021   grade_9   21.0 30.0                   19.0 32.0     *       42     8   51   21 30                   19 32         42   8   51
1435533 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2021   grade_9   62.0 87.0   0.0               103.0 46.0     18       145     41   149   62 87   0               103 46     18   145   41   149
1435704 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes High 06 12 2021   grade_9 0.0 3.0 79.0               0.0   41.0 41.0     17       78     9   82 0 3 79               0   41 41     17   78   9   82
1435742 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes 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   0
1435932 NY Bronx   school 3601196 320700861167   DREAM CHARTER SCHOOL MOTT HA 360119606691 320700861167 DREAM CHARTER SCHOOL MOTT HAVEN charter Regular School Yes Elementary KG 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
1435989 NY Bronx   school 3601218 320700861181   ZETA CHARTER SCHOOL - NYC 3 360121806716 320700861181 ZETA CHARTER SCHOOL - BRONX 3 charter Regular School Yes Elementary KG 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
1436008 NY Bronx   school 3601219 320700861182   ZETA CHARTER SCHOOL - NYC 4 360121906717 320700861182 ZETA CHARTER SCHOOL - BRONX 2 charter Regular School Yes Elementary KG 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
1436065 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE 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   0   0
1436426 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR 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
1436920 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502968 320800011530 LONGWOOD PREPARATORY ACADEMY public Regular School No High 09 12 2021   grade_9 1.0 25.0 57.0   0.0           0.0   44.0 39.0     16       79     30   83 1 25 57   0           0   44 39     16   79   30   83
1436977 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506348 320800011559 SCHOOL FOR TOURISM AND HOSPITALITY public Career and Technical School No High 09 12 2021   grade_9 1.0 23.0 33.0   0.0           1.0   31.0 27.0     12       54     16   58 1 23 33   0           1   31 27     12   54   16   58
1437338 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602188 320900010042 PS 42 CLAREMONT 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
1437376 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602238 320900010055 PS 55 BENJAMIN FRANKLIN 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
1437452 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602298 320900010073 PS 73 BRONX 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   0   0
1437509 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602413 320900010110 PS 110 THEODORE SCHOENFELD 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   0   0
1437547 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE 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
1437737 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603747 320900010219 IS 219 NEW VENTURE 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
1437775 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 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
1437870 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606393 320900010311 LUCERO ELEMENTARY 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
1437965 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 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
1437984 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) 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
1438364 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2021   grade_9     97.0                   57.0 40.0     97       95     *   97     97                   57 40     97   95       97
1438573 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN 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   0   0   0
1438782 NY Bronx   school 3601220 320900861174   WILDFLOWER NEW YORK CHARTER 360122006718 320900861174 WILDFLOWER NEW YORK CHARTER SCHOOL charter Regular School Yes Elementary PK 01 2021   grade_9   0.0 0.0                   0.0 0.0     *       0     *   0   0 0                   0 0         0       0
1438801 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY 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
1439295 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704353 321000010159 PS 159 LUIS MUNOZ MARIN BILING 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   0
1440017 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 1.0 0.0 16.0   3.0               10.0 10.0     *       18     *   20 1 0 16   3               10 10         18       20
1440036 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2021   grade_9     99.0                   63.0 36.0     82       98     18   99     99                   63 36     82   98   18   99
1440473 NY Bronx   school 3601133 321000861064   CHARTER HIGH SCHOOL-LAW AND 360113306569 321000861064 CHARTER HIGH SCHOOL-LAW AND SOCIAL charter Regular School Yes High 09 12 2021   grade_9 1.0 25.0 91.0   2.0               66.0 53.0     24       95     25   119 1 25 91   2               66 53     24   95   25   119
1442069 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002194 321200010044 PS 44 DAVID C FARRAGUT 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
1442164 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002279 321200010067 PS 67 MOHEGAN 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   0   0
1442449 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006401 321200010314 FAIRMONT NEIGHBORHOOD 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
1442544 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY 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
1442620 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006630 321200010595 PS 595 public Regular School No Elementary PK 04 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
1442715 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2021   grade_9   0.0 86.0   0.0               58.0 28.0     78       83     5   86   0 86   0               58 28     78   83   5   86
1443114 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE 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
1443513 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001631 31101060004 MAINE MEMORIAL 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
1443608 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY 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
1443665 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No High 08 12 2021   grade_9 9.0 1.0 1.0               1.0   6.0 6.0             11     *   12 9 1 1               1   6 6         11       12
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
1444216 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404324 42302040003 CATTARAUGUS-LITTLE VALLEY HS public Regular School No High 09 12 2021   grade_9 55.0 2.0 3.0   0.0           3.0   29.0 34.0             31     10   63 55 2 3   0           3   29 34         31   10   63
1444235 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH 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 0   0           0   0 0         0   0   0
1444330 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1444349 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239004858 42801060005 GOWANDA 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 0   0           0   0 0         0   0   0
1444387 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY 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   0 0         0   0   0
1444444 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY 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   0 0         0   0   0
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
1444900 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY 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
1444919 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003272 51101040004 PORT BYRON SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 63.0 1.0 5.0               1.0   38.0 32.0             70     12   70 63 1 5               1   38 32         70   12   70
1444938 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY 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
1445166 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2021   grade_9 60.0   1.0   0.0           0.0   25.0 36.0             30     9   61 60   1   0           0   25 36         30   9   61
1445185 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801938 60503040002 CHAUTAUQUA LAKE ELEMENTARY 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
1445204 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY 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
1445223 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 06 12 2021   grade_9 34.0 1.0 1.0   1.0           1.0   24.0 14.0     *       21     11   38 34 1 1   1           1   24 14         21   11   38
1445261 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000720 60800010003 SCHOOL 3 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   0
1445413 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 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
1445527 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000890 61503040002 FORESTVILLE ELEMENTARY 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   0 0         0   0   0
1445584 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 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   0   0
1445679 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001355 61700010009 SAMUEL G LOVE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1445869 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No High 06 12 2021   grade_9 33.0 0.0 3.0   0.0           4.0   15.0 25.0     0       24     5   40 33 0 3   0           4   15 25     0   24   5   40
1445888 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL 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
1445926 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673003650 62601040003 SHERMAN HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 36.0   2.0   0.0           1.0   22.0 17.0     *       20     8   39 36   2   0           1   22 17         20   8   39
1445983 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099003239 62901040004 WESTFIELD 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
1446097 NY Chemung   school 3610560 70600010000   ELMIRA 361056000823 70600010015 RIVERSIDE ELEMENTARY 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
1446192 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 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
1446382 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059002828 70902060004 COHEN 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
1446420 NY Chenango   school 3602400 80101040000   AFTON 360240000010 80101040002 AFTON ELEMENTARY 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
1446496 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 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
1446610 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001906369 81003040006 UNADILLA VALLEY ELEMENTARY 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
1446762 NY Chenango   school 3622260 81501040000   OXFORD 362226003145 81501040003 OXFORD ACADEMY PRIMARY SCHOOL public Regular School No Elementary PK 04 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
1446838 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY 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
1446876 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY 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
1446895 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 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
1447123 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No High 06 12 2021   grade_9 62.0 0.0 1.0                   31.0 32.0             25     11   63 62 0 1                   31 32         25   11   63
1447313 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY 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
1447617 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY 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   0   0
1447636 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2021   grade_9 26.0 0.0 1.0               1.0   11.0 17.0             14     *   28 26 0 1               1   11 17         14       28
1447655 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1447674 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 34.0 0.0 0.0               0.0   11.0 23.0             18     *   34 34 0 0               0   11 23         18       34
1447693 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS 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
1447807 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY 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
1447921 NY Cortland   school 3601188 110701861172   TRUXTON ACADEMY CHARTER SCHO 360118806703 110701861172 TRUXTON ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 03 2021   grade_9 0.0   0.0               0.0   0.0 0.0     *       0     *   0 0   0               0   0 0         0       0
1447940 NY Cortland   school 3618450 110901040000   MARATHON 361845001661 110901040001 MARATHON HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 55.0 0.0 0.0                   26.0 29.0     *       30     7   55 55 0 0                   26 29         30   7   55
1447978 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000693 31301040002 DEPOSIT ELEMENTARY 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
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
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
1448054 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2021   grade_9 29.0 0.0 3.0               0.0   18.0 14.0             17     5   32 29 0 3               0   18 14         17   5   32

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