Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 4,742

grade

  • ungraded_elementary · 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
1523110 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   ungraded_elementary 2.0 12.0 4.0   0.0     0.0     2.0   13.0 7.0     *       20     20   20 2 12 4   0     0     2   13 7         20   20   20
1523490 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523547 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523756 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523775 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 2.0 0.0 1.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 2 0 1   0     0     0   2 1                 3
1523813 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523889 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   ungraded_elementary 7.0 0.0 2.0         1.0     0.0   4.0 6.0     *       10     10   10 7 0 2         1     0   4 6         10   10   10
1523908 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524250 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 5.0 1.0 0.0   0.0     2.0     0.0   5.0 3.0     *       8     8   8 5 1 0   0     2     0   5 3         8   8   8
1524288 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1524459 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   ungraded_elementary 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
1524535 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   ungraded_elementary 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
1524630 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 1 0 0   0     0     0   1 0                 1
1524782 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 3.0         0.0     1.0   3.0 1.0     *       *     *   4 0 0 3         0     1   3 1                 4
1524858 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 4.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 0 0 4   0     0     0   2 2                 4
1524953 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2020   ungraded_elementary 1.0 0.0 1.0   0.0           0.0   2.0 0.0     *       *     *   2 1 0 1   0           0   2 0                 2
1526036 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502085 320800010014 PS 14 SENATOR JOHN CALANDRA public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 0 1 1   0     0     0   1 1                 2
1526150 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2020   ungraded_elementary 1.0 5.0 10.0         0.0     0.0   10.0 6.0     *       14     16   16 1 5 10         0     0   10 6         14   16   16
1526207 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502380 320800010100 PS 100 ISAAC CLASON public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 1.0 6.0   0.0     0.0     0.0   4.0 3.0     *       7     7   7 0 1 6   0     0     0   4 3         7   7   7
1526245 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 2.0 2.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 2 2   0     0     0   3 1                 4
1526283 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0         0.0 1.0     *       *     *   1 0 0 1   0     0         0 1                 1
1526302 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502479 320800010130 PS 130 ABRAM STEVENS HEWITT public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0         1.0 0.0     *       0     *   1 0 0 1   0     0         1 0         0       1
1526511 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505655 320800010333 LONGWOOD ACADEMY FOR DISCOVERY public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 5.0   0.0     0.0         2.0 3.0     *       5     *   5 0 0 5   0     0         2 3         5       5
1526853 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
1527328 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602160 320900010035 PS 35 FRANZ SIEGEL public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 0 1 1   0     0     0   1 1                 2
1527461 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602298 320900010073 PS 73 BRONX public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0   0.0           0.0   0.0 1.0     *       *     *   1 0 0 1   0           0   0 1                 1
1527575 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602465 320900010126 PS 126 DR MARJORIE H DUNBAR public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 1.0 1.0         0.0         1.0 1.0     *       *     *   2 0 1 1         0         1 1                 2
1527632 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602583 320900010163 PS 163 ARTHUR A SCHOMBERG public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0         1.0 0.0     *       *     *   1 0 0 1   0     0         1 0                 1
1527822 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606391 320900010274 NEW AMERICAN ACAD-R CLEMENTE STATE public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 1 1   0     0     0   2 0                 2
1527993 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0               0.0   0.0 1.0     *       *     *   1 0 0 1               0   0 1                 1
1528810 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702060 321000010007 MILTON FEIN SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 3.0   0.0     0.0     0.0   1.0 2.0     *       *     *   3 0 0 3   0     0     0   1 2                 3
1528943 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1528962 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 1.0 3.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 1 3   0     0     0   3 1                 4
1528981 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2020   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 1 1   0     0     0   2 0                 2
1529019 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLAN POE public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 2.0 2.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 0 2 2   0     0     0   2 2                 4
1529057 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703783 321000010054 PS/IS 54 public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 2.0 3.0   0.0     0.0         4.0 1.0     *       5     *   5 0 2 3   0     0         4 1         5       5
1529171 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705139 321000010085 PS 85 GREAT EXPECTATIONS public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 2.0   0.0     1.0     0.0   3.0 0.0     *       *     *   3 0 0 2   0     1     0   3 0                 3
1529228 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 1.0 3.0   1.0     0.0     0.0   3.0 2.0     *       *     5   5 0 1 3   1     0     0   3 2             5   5
1529304 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   1.0 2.0     *       *     *   3 0 1 2   0     0     0   1 2                 3
1529342 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704693 321000010207 PS 207 public Regular School No Elementary PK 04 2020   ungraded_elementary 1.0 0.0 3.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 1 0 3   0     0     0   3 1                 4
1529456 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704464 321000010246 PS 246 POE CENTER public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 4.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 0 0 4   0     0     0   2 2                 4
1529494 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700183 321000010279 PS 279 CAPT MANUEL RIVERA JR public Regular School No Elementary KG 08 2020   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   1.0 2.0     *       *     *   3 0 1 2   0     0     0   1 2                 3
1529532 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701306 321000010291 PS 291 public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 5.0         0.0         2.0 3.0     *       5     5   5 0 0 5         0         2 3         5   5   5
1529703 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703805 321000010360 PS 360 public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0   0.0     1.0         1.0 1.0     *       *     *   2 0 0 1   0     1         1 1                 2
1529722 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1529779 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706015 321000010386 SCHOOL FOR ENVIRONMENTAL CITIZENSHIP public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 1.0         0.0         0.0 1.0     *       *     *   1 0 0 1         0         0 1                 1
1529855 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706141 321000010447 CRESTON ACADEMY public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0         0.0 1.0     *       *     *   1 0 0 1   0     0         0 1                 1
1530254 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   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1530710 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802306 321100010076 PS 76 BENNINGTON SCHOOL (THE) public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 1 1   0     0     0   2 0                 2
1530748 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
1530786 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802342 321100010089 PS 89 public Regular School No Elementary PK 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     1.0     0.0   0.0 1.0     *       *     *   1 0 0 0   0     1     0   0 1                 1
1531128 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 2.0 2.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 0 2 2   0     0     0   2 2                 4
1531356 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806217 321100010498 PS/MS 498 VAN NEST ACADEMY public Regular School No Elementary KG 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 0 0 1   0     0     0   0 1                 1
1531413 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806314 321100010556 BRONX PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1531907 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1532002 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002059 321200010006 PS 6 WEST FARMS public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 2.0 1.0         0.0         3.0 0.0     *       *     *   3 0 2 1         0         3 0                 3
1532439 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005691 321200010316 KAPPA III public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1533009 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   ungraded_elementary 1.0 12.0 17.0         1.0         27.0 4.0     *       28     31   31 1 12 17         1         27 4         28   31   31
1533028 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533047 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533161 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000232 30200010012 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 6.0 5.0 0.0         0.0     1.0   8.0 4.0     *       12     12   12 6 5 0         0     1   8 4         12   12   12
1533218 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533351 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533370 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533389 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000517 30701060001 CHENANGO VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533408 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533427 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533446 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533541 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   ungraded_elementary 4.0 0.0 0.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 4 0 0   0     0     0   2 2                 4
1533560 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533655 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1533712 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533731 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Elementary 03 05 2020   ungraded_elementary 6.0 1.0 0.0   0.0     0.0     1.0   6.0 2.0     *       8     8   8 6 1 0   0     0     1   6 2         8   8   8
1533845 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   0.0 2.0     *       *     *   2 2 0 0         0     0   0 2                 2
1533940 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0     *       *     *   1 1 0 0         0     0   1 0                 1
1533997 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1534054 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
1534111 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534130 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   ungraded_elementary 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1534168 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534225 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534244 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534282 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2020   ungraded_elementary 2.0 0.0 0.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 2 0 0   0     0     0   2 0                 2
1534491 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   ungraded_elementary 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1534586 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   ungraded_elementary 4.0 0.0 1.0         0.0     0.0   1.0 4.0     *       *     5   5 4 0 1         0     0   1 4             5   5
1534605 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534719 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1534738 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534776 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   ungraded_elementary 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1534795 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 1 0 0   0     0     0   1 0                 1
1534814 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534833 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669000455 50401040003 CATO-MERIDIAN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534928 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
1534947 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535004 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925006575 51901040006 UNION SPRINGS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1535023 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535042 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535080 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   ungraded_elementary 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1535118 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   1.0 1.0     *       *     *   2 2 0 0         0     0   1 1                 2
1535460 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_elementary 0.0 0.0 0.0   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]);