Data source: Big Local News · About: Big Local

33,145 rows where grade = "ungraded_elementary" and state = "NY" sorted by ell_int

View and edit SQL

year

grade

  • ungraded_elementary · 33,145
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
942147 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary KG 06 2017   ungraded_elementary 3.0 11.0 4.0   0.0     1.0     1.0   11.0 9.0     *       12     20   20 3 11 4   0     1     1   11 9         12   20   20
942318 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 2.0 0.0   0.0     1.0     0.0   2.0 1.0     *       *     *   3 0 2 0   0     1     0   2 1                 3
942660 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   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
942679 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   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
942774 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
943097 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   ungraded_elementary 7.0 1.0 0.0   0.0     6.0     1.0   12.0 3.0     *       9     15   15 7 1 0   0     6     1   12 3         9   15   15
943154 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   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
943173 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 8.0 0.0 0.0         3.0     0.0   6.0 5.0     *       6     11   11 8 0 0         3     0   6 5         6   11   11
943306 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943325 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   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
943363 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   ungraded_elementary 1.0 0.0 0.0         1.0     0.0   2.0 0.0     *       *     *   2 1 0 0         1     0   2 0                 2
943572 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   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
943610 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
943667 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 2.0 1.0 0.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 2 1 0   0     0     0   3 0                 3
943743 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2017   ungraded_elementary 0.0 3.0 1.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 3 1   0     0     0   3 1                 4
943762 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2017   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
943781 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   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
943876 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 5.0   0.0     0.0     0.0   3.0 2.0     *       5     *   5 0 0 5   0     0     0   3 2         5       5
943933 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 0 1 2   0     0     0   3 0                 3
943971 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   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
943990 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   ungraded_elementary   0.0 1.0   0.0               1.0 0.0     *       *     *   1   0 1   0               1 0                 1
944104 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 1.0               0.0   0.0 1.0     *       *     *   1 0 0 1               0   0 1                 1
944142 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
944579 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2017   ungraded_elementary 0.0 1.0 1.0   0.0     0.0         2.0 0.0     *       *     *   2 0 1 1   0     0         2 0                 2
944731 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 04 2017   ungraded_elementary 0.0 1.0 1.0         0.0     0.0   2.0 0.0     *       *     *   2 0 1 1         0     0   2 0                 2
944826 NY Bronx   school 3601131 320700861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320700861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 07 2017   ungraded_elementary 0.0 2.0 1.0   0.0               2.0 1.0     *       *     *   3 0 2 1   0               2 1                 3
944921 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502168 320800010036 PS 36 UNIONPORT public Regular School No Elementary PK 05 2017   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
944940 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2017   ungraded_elementary 1.0 1.0 3.0   0.0     0.0     0.0   1.0 4.0     *       5     5   5 1 1 3   0     0     0   1 4         5   5   5
945035 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502302 320800010075 PS 75 SCHOOL OF RESEARCH-DISCOVERY public Regular School No Elementary PK 05 2017   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
945111 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 5.0 5.0   0.0     0.0     0.0   5.0 5.0     *       *     *   10 0 5 5   0     0     0   5 5                 10
945130 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 EMMETT W BASSETT SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   1.0 1.0     *       0     *   2 0 0 2   0     0     0   1 1         0       2
945149 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2017   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
945168 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502463 320800010125 JHS 125 HENRY HUDSON public Regular School No Middle 06 08 2017   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
945225 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502505 320800010138 PS 138 SAMUEL RANDALL public Regular School No Elementary PK 05 2017   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
945339 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505122 320800010302 MS 302 LUISA DESSUS CRUZ public Regular School No Middle 06 08 2017   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
945358 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 2017   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
945510 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2017   ungraded_elementary   0.0 1.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1   0 1   0     0     0   0 1                 1
945567 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 0.0   0.0     1.0         1.0 0.0     *       *     *   1 0 0 0   0     1         1 0                 1
945757 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No Other 06 12 2017   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
945890 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506258 320800011537 BRONX ARENA HIGH SCHOOL public Regular School No High 09 12 2017   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
946080 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 05 2017   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
946194 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602133 320900010028 PS 28 MOUNT HOPE public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 2.0         0.0     0.0   2.0 0.0     *       *     *   2 0 0 2         0     0   2 0                 2
946289 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602250 320900010058 PS 58 public Regular School No Elementary PK 06 2017   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
946327 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 3.0 2.0   0.0     0.0     0.0   4.0 1.0     *       5     5   5 0 3 2   0     0     0   4 1         5   5   5
946422 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602276 320900010114 PS 114 LUIS LORENS TORRES SCHOOL public Regular School No Elementary KG 05 2017   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
946498 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602486 320900010132 PS 132 GARRETT A MORGAN public Regular School No Elementary PK 05 2017   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
946517 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602528 320900010145 JHS 145 ARTURO TOSCANINI public Regular School No Middle 05 08 2017   ungraded_elementary 0.0 0.0 1.0         0.0         0.0 1.0     *       *     *   1 0 0 1         0         0 1                 1
946593 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604808 320900010204 PS 204 MORRIS HEIGHTS public Regular School No Elementary PK 05 2017   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
946688 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2017   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
946764 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603764 320900010303 IS 303 LEADERSHIP & COMM SERVICE public Regular School No Middle 06 08 2017   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
946821 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2017   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
946859 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605666 320900010327 COMP MODEL SCH PROJECT MS 327 public Regular School No Other 06 12 2017   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
946897 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 2.0   0.0     0.0         2.0 0.0     *       *     *   2 0 0 2   0     0         2 0                 2
946916 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2017   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
946992 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606150 320900010457 SHERIDAN ACADEMY FOR YOUNG LEADERS public Regular School No Elementary KG 05 2017   ungraded_elementary 1.0 2.0 0.0   0.0     0.0         1.0 2.0     *       *     *   3 1 2 0   0     0         1 2                 3
947011 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606312 320900010555 MOUNT EDEN CHILDREN'S ACADEMY public Regular School No Elementary PK 05 2017   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
947524 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes Elementary KG 08 2017   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
947638 NY Bronx   school 3601129 320900861073   ROSALYN YALOW CHARTER SCHOOL 360112906566 320900861073 ROSALYN YALOW CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   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
947771 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 2017   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
947790 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700130 321000010023 PS 23 NEW CHILDREN'S SCHOOL (THE) public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 5.0 1.0   0.0     0.0     0.0   4.0 2.0     *       6     *   6 0 5 1   0     0     0   4 2         6       6
947809 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2017   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
947828 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2017   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
947847 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 3.0 7.0   0.0     0.0     0.0   8.0 2.0     *       6     *   10 0 3 7   0     0     0   8 2         6       10
947866 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2017   ungraded_elementary 1.0 3.0 3.0   0.0     1.0     0.0   4.0 4.0     *       *     *   8 1 3 3   0     1     0   4 4                 8
947885 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702202 321000010045 THOMAS C GIORDANO MS 45 public Regular School No Middle 06 08 2017   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
947904 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLEN POE public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 1.0 6.0   0.0     1.0     0.0   7.0 1.0     *       5     8   8 0 1 6   0     1     0   7 1         5   8   8
947999 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706507 321000010077 BEDFORD PARK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 1.0 2.0 0.0   0.0     0.0     0.0   1.0 2.0     *       *     *   3 1 2 0   0     0     0   1 2                 3
948075 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2017   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     1.0   2.0 1.0     *       *     *   3 0 0 2   0     0     1   2 1                 3
948132 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702361 321000010095 PS 95 SHEILA MENCHER public Regular School No Elementary PK 08 2017   ungraded_elementary 0.0 1.0 3.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 1 3   0     0     0   4 0                 4
948170 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704353 321000010159 PS 159 LUIS MUNOZ MARIN BILING public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 0.0 1.0   0.0               1.0 0.0     *       *     *   1 0 0 1   0               1 0                 1
948189 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 3.0 5.0   0.0     0.0     0.0   4.0 4.0     *       7     8   8 0 3 5   0     0     0   4 4         7   8   8
948208 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704310 321000010206 IS 206 ANN MERSEREAU public Regular School No Middle 05 08 2017   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
948284 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2017   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
948322 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2017   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
948360 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 4.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 0 4   0     0     0   4 0                 4
948379 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 2017   ungraded_elementary 0.0 2.0 3.0   0.0     0.0     0.0   3.0 2.0     *       *     *   5 0 2 3   0     0     0   3 2                 5
948398 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704695 321000010280 PS/MS 280 MOSHOLU PARKWAY public Regular School No Elementary KG 08 2017   ungraded_elementary 0.0 0.0 0.0   0.0     1.0         1.0 0.0     *       *     *   1 0 0 0   0     1         1 0                 1
948436 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701307 321000010306 PS 306 public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 0.0 4.0   0.0     0.0         4.0 0.0     *       *     *   4 0 0 4   0     0         4 0                 4
948493 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702210 321000010310 PS 310 MARBLE HILL public Regular School No Elementary PK 05 2017   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
948550 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703795 321000010340 PS 340 public Regular School No Elementary PK 05 2017   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
948645 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary PK 05 2017   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
948664 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706015 321000010386 SCHOOL FOR ENVIRONMENTAL CITIZENSHIP public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 3.0   0.0     1.0         3.0 2.0     *       5     5   5 0 1 3   0     1         3 2         5   5   5
949481 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No Elementary KG 05 2017   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
949519 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802306 321100010076 PS 76 BENNINGTON SCHOOL (THE) public Regular School No Elementary KG 05 2017   ungraded_elementary 1.0 1.0 1.0   0.0     0.0     0.0   1.0 2.0     *       *     *   3 1 1 1   0     0     0   1 2                 3
949595 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802342 321100010089 PS 89 public Regular School No Elementary PK 08 2017   ungraded_elementary 1.0 1.0 1.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 1 1 1   0     0     0   2 1                 3
949614 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802364 321100010096 PS 96 RICHARD RODGERS public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 0.0 2.0   0.0     1.0     0.0   0.0 3.0     *       *     *   3 0 0 2   0     1     0   0 3                 3
949652 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 3.0 3.0   0.0     0.0     0.0   3.0 3.0     *       *     6   6 0 3 3   0     0     0   3 3             6   6
949671 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802394 321100010105 PS 105 SEN ABRAHAM BERNSTEIN public Regular School No Elementary KG 05 2017   ungraded_elementary 1.0 1.0 0.0   0.0     2.0     0.0   3.0 1.0     *       *     *   4 1 1 0   0     2     0   3 1                 4
949804 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802524 321100010144 JHS 144 MICHELANGELO public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 2.0 2.0   0.0     0.0         2.0 2.0     *       *     *   4 0 2 2   0     0         2 2                 4
949842 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802573 321100010160 PS 160 WALT DISNEY public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 3.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 1 3   0     0     0   4 0                 4
949918 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 2017   ungraded_elementary 0.0 2.0 5.0   0.0     0.0     0.0   1.0 6.0     *       7     7   7 0 2 5   0     0     0   1 6         7   7   7
949937 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 2.0 0.0   0.0     1.0     0.0   2.0 1.0     *       *     *   3 0 2 0   0     1     0   2 1                 3
949994 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 1.0   0.0     0.0         0.0 1.0     *       0     *   1 0 0 1   0     0         0 1         0       1
950108 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2017   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
950165 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806559 321100010483 MATILDA AVENUE SCHOOL (THE) public Regular School No Elementary KG 05 2017   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
950279 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806338 321100010567 LINDEN TREE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 0 1 2   0     0     0   3 0                 3
950697 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   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
950735 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   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
950792 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002059 321200010006 PS 6 WEST FARMS public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 2.0         0.0     0.0   2.0 0.0     *       *     *   2 0 0 2         0     0   2 0                 2
950849 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002245 321200010057 PS 57 CRESCENT public Regular School No Elementary PK 05 2017   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

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