Data source: Big Local News · About: Big Local

4,719 rows where grade = "ungraded_elementary", state = "NY" and year = 2019 sorted by ell_int

View and edit SQL

year

  • 2019 · 4,719

grade

  • ungraded_elementary · 4,719
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
2139205 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   ungraded_elementary 1.0 16.0 7.0   0.0     0.0     1.0   15.0 10.0     *       23     25   25 1 16 7   0     0     1   15 10         23   25   25
2139756 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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
2139832 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   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
2139851 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     1.0   1.0 1.0     *       *     *   2 1 0 0   0     0     1   1 1                 2
2140231 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   ungraded_elementary 10.0 0.0 0.0         1.0     0.0   8.0 3.0     *       8     11   11 10 0 0         1     0   8 3         8   11   11
2140364 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   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
2140383 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   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
2140402 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2140421 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 0.0 0.0 1.0         1.0     0.0   1.0 1.0     *       *     *   2 0 0 1         1     0   1 1                 2
2140592 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   ungraded_elementary 4.0 0.0 0.0   0.0     0.0         2.0 2.0     *       *     *   4 4 0 0   0     0         2 2                 4
2140687 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   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
2140706 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   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
2140839 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2019   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
2140858 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 0.0 4.0         0.0     1.0   3.0 2.0     *       5     *   5 0 0 4         0     1   3 2         5       5
2140896 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2019   ungraded_elementary 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
2140972 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2019   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
2141048 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 JUAN PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2019   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
2141067 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2019   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
2141162 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 3.0   0.0           0.0   3.0 0.0     *       *     *   3 0 0 3   0           0   3 0                 3
2141637 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2019   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
2142017 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502085 320800010014 PS 14 SENATOR JOHN CALANDRA public Regular School No Elementary KG 05 2019   ungraded_elementary 1.0 0.0 1.0   0.0     1.0     0.0   2.0 1.0     *       *     *   3 1 0 1   0     1     0   2 1                 3
2142055 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2019   ungraded_elementary 1.0 0.0 3.0   0.0     0.0         2.0 2.0     *       *     *   4 1 0 3   0     0         2 2                 4
2142131 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2019   ungraded_elementary 1.0 5.0 13.0         0.0         10.0 9.0     *       18     *   19 1 5 13         0         10 9         18       19
2142188 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502380 320800010100 PS 100 ISAAC CLASON public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 3.0 7.0   0.0     0.0     0.0   8.0 2.0     *       10     10   10 0 3 7   0     0     0   8 2         10   10   10
2142226 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2019   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
2142283 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502479 320800010130 PS 130 ABRAM STEVENS HEWITT public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 1.0 0.0   0.0     0.0         1.0 0.0     *       *     *   1 0 1 0   0     0         1 0                 1
2142492 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505655 320800010333 LONGWOOD ACADEMY FOR DISCOVERY public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 2.0 5.0   0.0     0.0         6.0 1.0     *       7     *   7 0 2 5   0     0         6 1         7       7
2142511 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505657 320800010337 SCHOOL FOR INQUIRY & SOCIAL JUSTICE public Regular School No Middle 06 08 2019   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
2142644 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0         1.0 1.0     *       *     *   2 0 0 2   0     0         1 1                 2
2143176 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605191 320900010004 PS/MS 4 CROTONA PARK WEST public Regular School No Elementary PK 08 2019   ungraded_elementary 0.0 1.0 1.0         0.0     0.0   1.0 1.0     *       *     *   2 0 1 1         0     0   1 1                 2
2143214 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604461 320900010022 JHS 22 JORDAN L MOTT public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 1.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 0 1 0   0     0     0   0 1                 1
2143252 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602160 320900010035 PS 35 FRANZ SIEGEL public Regular School No Elementary KG 05 2019   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
2143290 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602232 320900010053 PS 53 BASHEER QUISIM public Regular School No Elementary PK 05 2019   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
2143461 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602276 320900010114 PS 114 LUIS LLORENS TORRES SCHOOL public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 2.0 3.0   0.0     0.0     0.0   3.0 2.0     *       5     5   5 0 2 3   0     0     0   3 2         5   5   5
2143708 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 1.0               0.0   1.0 0.0     *       *     *   1 0 0 1               0   1 0                 1
2143879 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BUSINESS ACAD MS public Regular School No Middle 06 08 2019   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
2143898 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 1.0 4.0   0.0     0.0     0.0   1.0 4.0     *       5     5   5 0 1 4   0     0     0   1 4         5   5   5
2143955 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606121 320900010449 GRANT AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2143993 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606150 320900010457 SHERIDAN ACADEMY FOR YOUNG LEADERS public Regular School No Elementary PK 05 2019   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
2144012 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606312 320900010555 MOUNT EDEN CHILDREN'S ACADEMY public Regular School No Elementary PK 05 2019   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
2144734 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702060 321000010007 MILTON FEIN SCHOOL public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 0.0 6.0   0.0     0.0     0.0   1.0 5.0     *       6     6   6 0 0 6   0     0     0   1 5         6   6   6
2144810 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2019   ungraded_elementary 0.0 2.0 3.0   0.0     0.0     0.0   2.0 3.0     *       5     5   5 0 2 3   0     0     0   2 3         5   5   5
2144867 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2019   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
2144886 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 1.0 4.0   0.0     0.0     0.0   4.0 1.0     *       5     5   5 0 1 4   0     0     0   4 1         5   5   5
2144905 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2019   ungraded_elementary 0.0 1.0 3.0   0.0     1.0     0.0   2.0 3.0     *       5     5   5 0 1 3   0     1     0   2 3         5   5   5
2144943 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLAN POE public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 0.0 4.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 0 4   0     0     0   3 1                 4
2145095 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705139 321000010085 PS 85 GREAT EXPECTATIONS public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 0.0 3.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 0 3   0     0     0   2 1                 3
2145190 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 0 2   0     0     0   2 0                 2
2145228 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 1.0 3.0   0.0     0.0     0.0   2.0 2.0     *       *     *   4 0 1 3   0     0     0   2 2                 4
2145323 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2019   ungraded_elementary   1.0 3.0   0.0     0.0         2.0 2.0     *       *     *   4   1 3   0     0         2 2                 4
2145361 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2019   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
2145399 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2019   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
2145418 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 2019   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
2145437 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704695 321000010280 PS/MS 280 MOSHOLU PARKWAY public Regular School No Elementary KG 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 0 2   0     0     0   2 0                 2
2145456 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701306 321000010291 PS 291 public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 0.0 3.0         0.0         2.0 1.0     *       *     *   3 0 0 3         0         2 1                 3
2145627 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703805 321000010360 PS 360 public Regular School No Elementary PK 05 2019   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
2145722 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703811 321000010390 MS 390 public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0         0.0 2.0     *       *     *   2 0 0 2   0     0         0 2                 2
2145779 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706141 321000010447 CRESTON ACADEMY public Regular School No Middle 06 08 2019   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
2146178 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2019   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
2146710 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 2.0 3.0   0.0     0.0     0.0   4.0 1.0     *       5     5   5 0 2 3   0     0     0   4 1         5   5   5
2146900 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802573 321100010160 PS 160 WALT DISNEY public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 2.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 2 2   0     0     0   4 0                 4
2146976 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2019   ungraded_elementary 1.0 4.0 6.0   0.0     0.0     0.0   7.0 4.0     *       9     11   11 1 4 6   0     0     0   7 4         9   11   11
2147052 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2019   ungraded_elementary 1.0 1.0 1.0   0.0     0.0     0.0   0.0 3.0     *       *     *   3 1 1 1   0     0     0   0 3                 3
2147223 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 2019   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
2147299 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806322 321100010566 PELHAM GARDENS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 0 0 2   0     0     0   1 1                 2
2147774 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   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
2147888 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002059 321200010006 PS 6 WEST FARMS public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 2.0 1.0   0.0     0.0         3.0 0.0     *       *     *   3 0 2 1   0     0         3 0                 3
2147926 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2019   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 1 2   0     0     0   2 1                 3
2147945 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002245 321200010057 PS 57 CRESCENT public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 2.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 2 2   0     0     0   4 0                 4
2147983 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005509 321200010066 PS 66 SCHOOL OF HIGHER EXPECTATIONS public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 0.0 0.0   0.0     1.0         0.0 1.0     *       *     *   1 0 0 0   0     1         0 1                 1
2148211 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005169 321200010217 SCHOOL OF PERFORMING ARTS public Regular School No Middle 06 08 2019   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     *       *     *   2 0 0 2   0     0     0   2 0                 2
2148230 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005805 321200010242 MOTT HALL V public Regular School No High 06 12 2019   ungraded_elementary 0.0 0.0 2.0         0.0         2.0 0.0     *       *     *   2 0 0 2         0         2 0                 2
2148382 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2019   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
2148458 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006261 321200010536 PS 536 public Regular School No Elementary PK 05 2019   ungraded_elementary 0.0 2.0 1.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 0 2 1   0     0     0   3 0                 3
2148762 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003847 321200011691 BRONX LITTLE SCHOOL public Regular School No Elementary PK 05 2019   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
2148895 NY Bronx   school 3601161 321200861108   NY CENTER FOR AUTISM CS - BR 360116106615 321200861108 NY CENTER FOR AUTISM CS - BRONX charter Special Education School Yes Elementary KG KG 2019   ungraded_elementary 1.0 8.0 11.0                   18.0 2.0     *       16     20   20 1 8 11                   18 2         16   20   20
2148914 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2148933 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   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
2148952 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149047 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000232 30200010012 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 05 2019   ungraded_elementary 4.0 2.0 0.0         0.0     3.0   8.0 1.0     *       9     9   9 4 2 0         0     3   8 1         9   9   9
2149104 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149199 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   ungraded_elementary 6.0 0.0 1.0   0.0     0.0     0.0   6.0 1.0     *       7     7   7 6 0 1   0     0     0   6 1         7   7   7
2149237 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 6.0 0.0 0.0   0.0     0.0     0.0   5.0 1.0     *       *     6   6 6 0 0   0     0     0   5 1             6   6
2149256 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   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
2149313 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   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
2149446 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2149522 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   ungraded_elementary 0.0 0.0 1.0               0.0   1.0 0.0     *       *     *   1 0 0 1               0   1 0                 1
2149541 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 2.0 0.0 0.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 2 0 0   0     0     0   1 1                 2
2149731 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   ungraded_elementary 2.0 0.0 0.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 2 0 0   0     0     0   1 1                 2
2149826 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2149864 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   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
2149940 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   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
2150054 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   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
2150130 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150168 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   ungraded_elementary 4.0 0.0 0.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 4 0 0   0     0     0   4 0                 4
2150339 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   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
2150358 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   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
2150377 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150396 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   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
2150415 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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]);