Data source: Big Local News · About: Big Local

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

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
1433215 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE 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
1433329 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY 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
1433405 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH 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
1433462 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL 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   0
1433519 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 290.0 12.0 10.0         34.0     4.0   199.0 151.0     *       37     34   350 290 12 10         34     4   199 151         37   34   350
1433557 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2021   grade_9 115.0 8.0 14.0         3.0     10.0   80.0 70.0     *       76     30   150 115 8 14         3     10   80 70         76   30   150
1433614 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID 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
1433652 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND 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
1433671 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 107.0 21.0 11.0   0.0     1.0     10.0   73.0 77.0     *       102     35   150 107 21 11   0     1     10   73 77         102   35   150
1433728 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE 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   0
1433823 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No 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   0
1433861 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL 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
1434127 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 266.0 18.0 11.0   1.0     45.0     12.0   169.0 184.0     *       64     37   353 266 18 11   1     45     12   169 184         64   37   353
1434203 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE 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   0
1434241 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE 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
1434279 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2021   grade_9 40.0 27.0 17.0         10.0     12.0   56.0 50.0     *       75     21   106 40 27 17         10     12   56 50         75   21   106
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
1434431 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 51.0 0.0 1.0   0.0     0.0     0.0   25.0 27.0     *       30     5   52 51 0 1   0     0     0   25 27         30   5   52
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
1434488 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD 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 0         0   0   0
1434564 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE 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   0
1435153 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 0.0 7.0 15.0   1.0     0.0     0.0   13.0 10.0     *       21     8   23 0 7 15   1     0     0   13 10         21   8   23
1435172 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 0.0 6.0 15.0   0.0     0.0         11.0 10.0     *       17     9   21 0 6 15   0     0         11 10         17   9   21
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
1435419 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_9 0.0 30.0 40.0   2.0     0.0     0.0   41.0 31.0     *       63     16   72 0 30 40   2     0     0   41 31         63   16   72
1435761 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes High 09 12 2021   grade_9 0.0 36.0 45.0         3.0         45.0 39.0     *       75     23   84 0 36 45         3         45 39         75   23   84
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
1436483 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505654 320800010312 MILLENIUM ART ACADEMY public Regular School No High 09 12 2021   grade_9 1.0 33.0 48.0   3.0     2.0     1.0   33.0 55.0     *       78     18   88 1 33 48   3     2     1   33 55         78   18   88
1437091 NY Bronx   school 3601072 320800861017   NEW VISIONS CHARTER HS-MATH 360107206365 320800861017 NEW VISIONS CHTR HS-ADV MA/SCI II charter Regular School Yes High 09 12 2021   grade_9 2.0 58.0 88.0   2.0     1.0     1.0   84.0 68.0     *       137     35   152 2 58 88   2     1     1   84 68         137   35   152
1438098 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No High 06 12 2021   grade_9 1.0 24.0 53.0   0.0     5.0     0.0     83.0     *       70     20   83 1 24 53   0     5     0     83         70   20   83
1438174 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No High 06 12 2021   grade_9 0.0 43.0 35.0   0.0     0.0     2.0   80.0 0.0     *       67     27   80 0 43 35   0     0     2   80 0         67   27   80
1438345 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No High 07 12 2021   grade_9 1.0 19.0 24.0   0.0     0.0         26.0 18.0     *       41     16   44 1 19 24   0     0         26 18         41   16   44
1438554 NY Bronx   school 3600042 320900860807   BRONX PREP CHARTER SCHOOL 360004204466 320900860807 BRONX PREP CHARTER SCHOOL charter Regular School Yes High 06 12 2021   grade_9 0.0 60.0 66.0   1.0     2.0     0.0   73.0 56.0     *       103     22   129 0 60 66   1     2     0   73 56         103   22   129
1438649 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 12 2021   grade_9 1.0 17.0 32.0   0.0     0.0         22.0 28.0     *       47     7   50 1 17 32   0     0         22 28         47   7   50
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
1439941 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705674 321000011243 WEST BRONX ACAD FOR THE FUTURE public Regular School No High 06 12 2021   grade_9 1.0 19.0 91.0   0.0     1.0     1.0   46.0 67.0     *       104     26   113 1 19 91   0     1     1   46 67         104   26   113
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
1440245 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705556 321000011442 CELIA CRUZ BRONX HS OF MUSIC (THE) public Regular School No High 09 12 2021   grade_9 3.0 50.0 77.0   3.0     1.0     1.0   62.0 73.0     *       118     33   135 3 50 77   3     1     1   62 73         118   33   135
1440264 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2021   grade_9 134.0 39.0 73.0   11.0     451.0     12.0   376.0 344.0     *       344     18   720 134 39 73   11     451     12   376 344         344   18   720
1440321 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705496 321000011546 BRONX THEATRE HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 2.0 37.0 56.0   1.0     1.0     2.0   31.0 68.0     *       86     27   99 2 37 56   1     1     2   31 68         86   27   99
1441575 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805684 321100011275 HIGH SCHOOL-COMPUTERS & TECHNOLOGY public Career and Technical School No High 09 12 2021   grade_9 5.0 43.0 68.0   1.0     9.0     1.0   113.0 14.0     *       109     40   127 5 43 68   1     9     1   113 14         109   40   127
1441936 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 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   0
1442031 NY Bronx   school 3601223 321100861163   CAPITAL PREPARATORY BRONX CH 360122306721 321100861163 CAPITAL PREPARATORY BRONX CHARTER charter Regular School Yes Middle 06 07 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
1442886 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001332 321200011684 WINGS ACADEMY public Regular School No High 09 12 2021   grade_9 0.0 37.0 40.0   2.0     2.0     1.0   61.0 21.0     *       74     31   82 0 37 40   2     2     1   61 21         74   31   82
1442924 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 PHAROS ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_9 0.0 24.0 35.0   0.0     1.0     3.0   30.0 33.0     *       50     10   63 0 24 35   0     1     3   30 33         50   10   63
1443038 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 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
1443057 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS 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   0
1443076 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 98.0 0.0 5.0   1.0     0.0     4.0   57.0 51.0     *       45     17   108 98 0 5   1     0     4   57 51         45   17   108
1443095 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS 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
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
1443171 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000230 30200010011 MACARTHUR 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
1443247 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST 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
1443380 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK 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
1443399 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2021   grade_9 98.0 3.0 2.0         1.0     6.0   56.0 54.0     *       53     15   110 98 3 2         1     6   56 54         53   15   110
1443418 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000517 30701060001 CHENANGO VALLEY HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 106.0 1.0 4.0   0.0     4.0     4.0   54.0 65.0     *       59     19   119 106 1 4   0     4     4   54 65         59   19   119
1443437 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE 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 0   0     0     0   0 0         0   0   0
1443456 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No 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   0
1443475 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY 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
1443551 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 166.0 2.0 6.0   0.0     1.0     3.0   89.0 89.0     *       69     34   178 166 2 6   0     1     3   89 89         69   34   178
1443570 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 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
1443741 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY 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   0
1443817 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001375 31502060006 JOHNSON CITY SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 120.0 12.0 18.0         15.0     22.0   85.0 102.0     *       110     30   187 120 12 18         15     22   85 102         110   30   187
1443950 NY Broome   school 3629610 31601060000   VESTAL 362961003992 31601060051 VESTAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 191.0 10.0 9.0   0.0     32.0     8.0   139.0 111.0     *       60     21   250 191 10 9   0     32     8   139 111         60   21   250
1443969 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL 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   0
1443988 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS 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   0
1444064 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH public Regular School No High 06 12 2021   grade_9 85.0 0.0 2.0         1.0     3.0   51.0 40.0     *       36     14   91 85 0 2         1     3   51 40         36   14   91
1444083 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY 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   0
1444140 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 06 12 2021   grade_9 39.0   3.0   0.0     0.0     0.0   19.0 23.0     *       18     5   42 39   3   0     0     0   19 23         18   5   42
1444159 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE 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 0         0   0   0
1444197 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY 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 0         0   0   0
1444254 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST 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   0 0         0   0   0
1444273 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW 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   0 0         0   0   0
1444311 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 04 07 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
1444539 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 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
1444615 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE 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   0
1444634 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 172.0 1.0 3.0   0.0     1.0     2.0   83.0 96.0     *       93     38   179 172 1 3   0     1     2   83 96         93   38   179
1444748 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH 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     0   0 0         0   0   0
1444767 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 261.0 21.0 23.0         5.0     34.0   185.0 159.0     *       198     59   344 261 21 23         5     34   185 159         198   59   344
1444786 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004095 50301040002 WEEDSPORT JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 63.0   0.0   0.0     1.0     5.0   32.0 37.0     *       14     9   69 63   0   0     1     5   32 37         14   9   69
1444805 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT 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         0   0   0
1444824 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN 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         0   0   0
1444843 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669000455 50401040003 CATO-MERIDIAN JUNIOR-SENIOR HS public Regular School No High 07 12 2021   grade_9 55.0 1.0 1.0   0.0     1.0     4.0   31.0 31.0     *       26     5   62 55 1 1   0     1     4   31 31         26   5   62
1444862 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2021   grade_9 35.0   8.0   0.0     0.0     1.0   20.0 24.0     *       18     7   44 35   8   0     0     1   20 24         18   7   44
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
1444957 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2021   grade_9 67.0 0.0 1.0   1.0     1.0     1.0   37.0 34.0     *       32     12   71 67 0 1   1     1     1   37 34         32   12   71
1444976 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH 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
1444995 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 51.0 2.0 7.0         2.0     0.0   37.0 25.0     *       24         62 51 2 7         2     0   37 25         24       62
1445014 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925006575 51901040006 UNION SPRINGS 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
1445033 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 104.0 2.0 9.0   0.0     4.0     5.0   64.0 60.0     *       49     20   124 104 2 9   0     4     5   64 60         49   20   124
1445090 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON 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
1445128 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE 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 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
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
1445470 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 58.0 1.0 12.0   10.0     0.0     2.0   44.0 39.0     *       43     18   83 58 1 12   10     0     2   44 39         43   18   83
1445565 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 36.0   0.0         0.0     0.0   12.0 24.0     *       19     5   36 36   0         0     0   12 24         19   5   36
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
1445622 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001346 61700010003 CLINTON V BUSH 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   0
1445641 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563004390 61700010006 PERSELL 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

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