Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_9", state = "NY" and year = 2020 sorted by ell_int

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_9 · 4,742
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int ▼ homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1523484 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   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
1523541 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523598 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 305.0 9.0 11.0         21.0     2.0   157.0 191.0     *       53     36   348 305 9 11         21     2   157 191         53   36   348
1523750 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 100.0 18.0 16.0   2.0     2.0     7.0   64.0 81.0     *       89     20   145 100 18 16   2     2     7   64 81         89   20   145
1523769 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1523807 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   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
1523883 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1523902 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1524282 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1524453 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_9 26.0 0.0 2.0               0.0   18.0 10.0     *       24     10   28 26 0 2               0   18 10         24   10   28
1524529 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_9 15.0 0.0 0.0                   6.0 9.0     *       11     *   15 15 0 0                   6 9         11       15
1524624 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2020   grade_9 94.0 3.0 1.0   0.0     1.0     2.0   52.0 49.0     *       47     17   101 94 3 1   0     1     2   52 49         47   17   101
1525175 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2020   grade_9 2.0 22.0 81.0   0.0     2.0     0.0   51.0 56.0     *       101     25   107 2 22 81   0     2     0   51 56         101   25   107
1525232 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 0.0 5.0 9.0   1.0     0.0     0.0   9.0 6.0     *       14     5   15 0 5 9   1     0     0   9 6         14   5   15
1525251 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 0.0 3.0 10.0   0.0     0.0         7.0 6.0     *       10     7   13 0 3 10   0     0         7 6         10   7   13
1525612 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2020   grade_9   50.0 79.0   2.0     0.0     1.0   90.0 42.0     *       128     26   132   50 79   2     0     1   90 42         128   26   132
1525840 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes High 09 12 2020   grade_9 0.0 20.0 41.0         1.0     0.0   23.0 39.0     *       *     18   62 0 20 41         1     0   23 39             18   62
1526486 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505654 320800010312 MILLENIUM ART ACADEMY public Regular School No High 09 12 2020   grade_9 2.0 22.0 76.0   1.0     0.0     0.0   41.0 60.0     *       88     20   101 2 22 76   1     0     0   41 60         88   20   101
1526847 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 0.0 13.0 17.0   1.0     0.0         14.0 17.0     *       26     *   31 0 13 17   1     0         14 17         26       31
1526942 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506258 320800011537 BRONX ARENA HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 1.0 8.0 5.0         0.0         6.0 8.0     *       13     *   14 1 8 5         0         6 8         13       14
1528177 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No High 06 12 2020   grade_9 0.0 55.0 29.0   1.0     1.0     1.0   87.0       *       75     30   87 0 55 29   1     1     1   87           75   30   87
1528310 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605865 320900011324 BRONX EARLY COL ACAD-TEACH/LEARN public Regular School No High 06 12 2020   grade_9 0.0 20.0 67.0   0.0     1.0         49.0 39.0     *       76     20   88 0 20 67   0     1         49 39         76   20   88
1528386 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604879 320900011403 BRONX INTERNATIONAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 0.0 5.0 59.0   0.0     1.0         29.0 36.0     *       *     *   65 0 5 59   0     1         29 36                 65
1528519 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605547 320900011543 HIGH SCHOOL FOR VIOLIN AND DANCE public Regular School No High 09 12 2020   grade_9 0.0 25.0 51.0   2.0     0.0         24.0 54.0     *       71     29   78 0 25 51   2     0         24 54         71   29   78
1528652 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 11 2020   grade_9 1.0 18.0 26.0   0.0     0.0         19.0 26.0     *       44     9   45 1 18 26   0     0         19 26         44   9   45
1530001 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Regular School No High 09 12 2020   grade_9   0.0 13.0   7.0               15.0 5.0     *       18     *   20   0 13   7               15 5         18       20
1530153 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705183 321000011437 FORDHAM HIGH SCHOOL FOR THE ARTS public Regular School No High 09 12 2020   grade_9 1.0 37.0 97.0   2.0     4.0     1.0   57.0 85.0     *       123     37   142 1 37 97   2     4     1   57 85         123   37   142
1530229 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 2020   grade_9 3.0 48.0 85.0   2.0     4.0     3.0   54.0 91.0     *       123     30   145 3 48 85   2     4     3   54 91         123   30   145
1530248 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2020   grade_9 178.0 19.0 48.0   6.0     470.0     22.0   415.0 328.0     *       337     13   743 178 19 48   6     470     22   415 328         337   13   743
1530305 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705496 321000011546 BRONX THEATRE HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 3.0 29.0 52.0   2.0     1.0     3.0   32.0 58.0     *       81     27   90 3 29 52   2     1     3   32 58         81   27   90
1531464 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805680 321100011249 BRONX HEALTH SCIENCES HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 5.0 44.0 38.0   3.0     14.0         50.0 54.0     *       84     18   104 5 44 38   3     14         50 54         84   18   104
1531521 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805810 321100011270 ACAD-SCHOLARSHIP & ENTREPRENEURSHIP public Regular School No High 09 12 2020   grade_9 3.0 58.0 32.0   2.0     0.0     1.0   54.0 42.0     *       84     27   96 3 58 32   2     0     1   54 42         84   27   96
1531901 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2020   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
1532889 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2020   grade_9 1.0 21.0 40.0   0.0     0.0     0.0   35.0 27.0     *       50     18   62 1 21 40   0     0     0   35 27         50   18   62
1533003 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533022 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533041 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 110.0 2.0 4.0   1.0     1.0     5.0   62.0 61.0     *       51     15   123 110 2 4   1     1     5   62 61         51   15   123
1533212 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1533345 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1533364 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2020   grade_9 90.0 3.0 6.0   1.0     0.0     2.0   55.0 47.0     *       53     16   102 90 3 6   1     0     2   55 47         53   16   102
1533383 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000517 30701060001 CHENANGO VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 106.0 5.0 5.0   1.0     1.0     4.0   62.0 60.0     *       50     22   122 106 5 5   1     1     4   62 60         50   22   122
1533402 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   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
1533421 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   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
1533440 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1533516 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 158.0 7.0 5.0   2.0     2.0     4.0   95.0 83.0     *       66     25   178 158 7 5   2     2     4   95 83         66   25   178
1533535 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   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
1533554 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 109.0 0.0 2.0         1.0     0.0   51.0 61.0     *       68     27   112 109 0 2         1     0   51 61         68   27   112
1533649 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1533668 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000854 31501060012 UNION-ENDICOTT HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 191.0 22.0 24.0   0.0     8.0     23.0   132.0 136.0     *       70     36   268 191 22 24   0     8     23   132 136         70   36   268
1533706 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2020   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
1533839 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1533915 NY Broome   school 3629610 31601060000   VESTAL 362961003992 31601060051 VESTAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 200.0 10.0 18.0   0.0     35.0     6.0   129.0 140.0     *       77     27   269 200 10 18   0     35     6   129 140         77   27   269
1533934 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533991 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 125.0 6.0 4.0         1.0     5.0   74.0 67.0     *       75     26   141 125 6 4         1     5   74 67         75   26   141
1534048 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2020   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
1534105 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_9 37.0 0.0 1.0   1.0     1.0     0.0   17.0 23.0     *       21     *   40 37 0 1   1     1     0   17 23         21       40
1534124 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1534162 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2020   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
1534219 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   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
1534238 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   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
1534276 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2020   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
1534485 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   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
1534580 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534599 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 154.0 0.0 3.0   0.0     0.0     0.0   75.0 82.0     *       74     23   157 154 0 3   0     0     0   75 82         74   23   157
1534713 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   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
1534732 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 256.0 29.0 14.0   0.0     3.0     28.0   182.0 148.0     *       186     52   330 256 29 14   0     3     28   182 148         186   52   330
1534770 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1534789 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534808 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1534827 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669000455 50401040003 CATO-MERIDIAN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 56.0 0.0 1.0   0.0     0.0     4.0   31.0 30.0     *       28     6   61 56 0 1   0     0     4   31 30         28   6   61
1534846 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2020   grade_9 44.0 0.0 9.0   0.0     0.0     2.0   30.0 25.0     *       31     11   55 44 0 9   0     0     2   30 25         31   11   55
1534922 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1534941 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 74.0 0.0 2.0   0.0     0.0     0.0   35.0 41.0     *       40     13   76 74 0 2   0     0     0   35 41         40   13   76
1534998 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925006575 51901040006 UNION SPRINGS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1535017 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 94.0 1.0 2.0   0.0     3.0     2.0   63.0 39.0     *       35     11   102 94 1 2   0     3     2   63 39         35   11   102
1535036 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1535074 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1535112 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1535454 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 59.0 0.0 3.0   7.0     0.0     6.0   37.0 38.0     *       37     9   75 59 0 3   7     0     6   37 38         37   9   75
1535473 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1535549 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2020   grade_9 29.0   2.0               0.0   18.0 13.0     *       12     *   31 29   2               0   18 13         12       31
1535568 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No Elementary PK 06 2020   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
1535625 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563004390 61700010006 PERSELL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1535644 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001353 61700010007 MILTON J FLETCHER ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1535796 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000907 62201060003 FREDONIA HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 104.0 2.0 17.0         1.0     5.0   63.0 66.0     *       49     9   129 104 2 17         1     5   63 66         49   9   129
1535853 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 31.0 0.0 5.0   0.0           1.0   14.0 23.0     *       26     9   37 31 0 5   0           1   14 23         26   9   37
1535872 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL SCHOOL public Regular School No Elementary PK 06 2020   grade_9 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
1535929 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099004163 62901040001 WESTFIELD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1535967 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099003239 62901040004 WESTFIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1535986 NY Chemung   school 3610560 70600010000   ELMIRA 361056000816 70600010006 DIVEN SCHOOL public Regular School No Elementary PK 02 2020   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
1536005 NY Chemung   school 3610560 70600010000   ELMIRA 361056000817 70600010007 FASSETT ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   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
1536024 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2020   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
1536062 NY Chemung   school 3610560 70600010000   ELMIRA 361056000822 70600010014 PINE CITY SCHOOL public Regular School No Elementary PK 02 2020   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
1536100 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2020   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
1536119 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2020   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
1536138 NY Chemung   school 3610560 70600010000   ELMIRA 361056000824 70600010020 ELMIRA HIGH SCHOOL public Regular School No High 10 12 2020   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
1536157 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2020   grade_9 328.0 74.0 14.0         2.0     32.0   233.0 217.0     *       *     *   450 328 74 14         2     32   233 217                 450
1536195 NY Chemung   school 3601128 70600861078   FINN ACADEMY:AN ELMIRA CHART 360112806541 70600861078 FINN ACADEMY:AN ELMIRA CHARTER SCHOO charter Regular School Yes Elementary KG 07 2020   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
1536233 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001243 70901060004 RIDGE ROAD SCHOOL public Regular School No Elementary PK 04 2020   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
1536252 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001236 70901060005 BIG FLATS SCHOOL public Regular School No Elementary PK 04 2020   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]);