Data source: Big Local News · About: Big Local

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

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
1443044 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   ungraded_elementary 0.0 1.0 0.0         0.0         0.0 1.0     *       *     *   1 0 1 0         0         0 1                 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
2156381 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 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
799632 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No 1 PK PK 2015   ungraded_elementary 0.0 0.0 0.0         0.0         0.0 0.0             *     *   0 0 0 0         0         0 0                 0
800791 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No 1 PK PK 2015   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
800810 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No 1 PK PK 2015   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
819639 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY ELEMENTARY SCHOOL public Regular School No 1 PK PK 2015   ungraded_elementary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
831495 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No 1 PK PK 2015   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
833300 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No 1 PK PK 2015   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
981059 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Elementary PK PK 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
994644 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Elementary PK PK 2017   ungraded_elementary 0.0 0.0     0.0           0.0   0.0 0.0             *     *   0 0 0     0           0   0 0                 0
995917 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Elementary PK PK 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
997076 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Elementary PK PK 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
997095 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Elementary PK PK 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
1015981 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK PK 2017   ungraded_elementary 0.0                       0.0 0.0             0     *   0 0                       0 0         0       0
1029566 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Elementary PK PK 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
1071062 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No 1.0 PK PK 2016   ungraded_elementary 0.0 0.0 0.0         0.0         0.0 0.0             *     *   0 0 0 0         0         0 0                 0
1085996 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No 1.0 PK PK 2016   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
1087155 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No 1.0 PK PK 2016   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
1087174 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No 1.0 PK PK 2016   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
1106079 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD CENTER public Regular School No 1.0 PK PK 2016   ungraded_elementary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1117935 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No 1.0 PK PK 2016   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
1119759 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No 1.0 PK PK 2016   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
1434627 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   ungraded_elementary 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1485775 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2021   ungraded_elementary 0.0   0.0         0.0     0.0   0.0 0.0                   *   0 0   0         0     0   0 0                 0
1487010 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Prekindergarten PK PK 2021   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
1488169 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   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
1488188 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   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
1507264 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2021   ungraded_elementary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1507872 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   ungraded_elementary 0.0                   0.0   0.0 0.0             *     *   0 0                   0   0 0                 0
1508480 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No Prekindergarten PK PK 2021   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
1518987 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No Prekindergarten PK PK 2021   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
1520811 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   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
1524706 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   ungraded_elementary 0.0                       0.0 0.0                       0 0                       0 0                 0
1575930 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2020   ungraded_elementary 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1577165 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Prekindergarten PK PK 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
1578324 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 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
1578343 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 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
1597400 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2020   ungraded_elementary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1609123 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No Prekindergarten PK PK 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
1610928 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 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
2051064 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   ungraded_elementary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2088380 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Prekindergarten PK PK 2018   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
2102022 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2018   ungraded_elementary 0.0   0.0   0.0               0.0 0.0                   *   0 0   0   0               0 0                 0
2104454 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2018   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
2104473 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 2018   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
2123378 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2018   ungraded_elementary 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
2135082 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No Prekindergarten PK PK 2018   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
2136906 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 2018   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
2140782 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   ungraded_elementary 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2178060 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Prekindergarten PK PK 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
2191626 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   ungraded_elementary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2192880 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Prekindergarten PK PK 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
2194039 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 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
2194058 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 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
2213020 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2019   ungraded_elementary 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
2224743 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No Prekindergarten PK PK 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
2226567 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 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
748750 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No 1.0 PK KG 2015   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
751296 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706507 321000010077 BEDFORD PARK ELEMENTARY SCHOOL public Regular School No 1.0 PK KG 2015   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
754621 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY SCHOOL public Regular School No 1.0 PK KG 2015   ungraded_elementary   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
761043 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004326 131500010013 COLUMBUS SCHOOL public Regular School No 1.0 PK KG 2015   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
784622 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No 1 PK KG 2015   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
784698 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413006370 280201030016 PROSPECT ELEMENTARY SCHOOL public Regular School No 1 KG KG 2015   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
785667 NY Nassau   school 3611550 280209030000   FREEPORT 361155004441 280209030004 COLUMBUS AVENUE SCHOOL public Regular School No 1 KG KG 2015   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
786066 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157002021 280211030016 SCHOOL 6-KINDERGARTEN CTR public Regular School No 1 PK KG 2015   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
786351 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001501 280215030004 4 SCHOOL public Regular School No 1 PK KG 2015   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
786788 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001657 280220030001 KINDERGARTEN CENTER public Regular School No 1 KG KG 2015   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
788612 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001022 280407030009 EARLY CHILDHOOD CENTER public Regular School No 1 PK KG 2015   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
789486 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322002037 280504060016 PLAINVIEW-OLD BETHPAGE KNDG CTR public Regular School No 1 KG KG 2015   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
792811 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706523 310200010340 SIXTH AVENUE ELEMENTARY SCHOOL public Regular School No 1 PK KG 2015   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
798359 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No 1 PK KG 2015   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
802653 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859006481 421800010072 DELAWARE PRIMARY SCHOOL public Regular School No 1 KG KG 2015   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
804173 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No 1 PK KG 2015   ungraded_elementary 77.0                       43.0 34.0             72     77   77 77                       43 34         72   77   77
807289 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806485 342400010343 CHILDREN'S LAB SCHOOL (THE) public Regular School No 1 PK KG 2015   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
809949 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306525 342700010316 QUEENS EXPLORERS ELEMENTARY SCHOOL public Regular School No 1 PK KG 2015   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
810956 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006518 342800010312 JAMAICA CHILDREN'S SCHOOL public Regular School No 1 KG KG 2015   ungraded_elementary   1.0 0.0                   1.0 0.0             *     *   1   1 0                   1 0                 1
814186 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306458 353100010010 FORT HILL COLLABORATIVE ELEMENTARY public Regular School No 1 KG KG 2015   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
816447 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781006098 500402060006 EAST RAMAPO EARLY CHLD CTR AT KAKIAT public Regular School No 1 KG KG 2015   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
825586 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687001061 580513030009 CENTRAL ISLIP EARLY CHLDHD CENTER public Regular School No 1 PK KG 2015   ungraded_elementary 0.0 0.0 1.0         0.0         1.0 0.0             *     *   1 0 0 1         0         1 0                 1
829538 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001256 641301060003 MARGARET MURPHY KINDERGARTEN CENTER public Regular School No 1 PK KG 2015   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
831020 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003888 660401030001 JOHN PAULDING SCHOOL public Regular School No 1 KG KG 2015   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
833129 NY Westchester   school 3622020 661401030000   OSSINING 362202003122 661401030003 PARK SCHOOL public Regular School No 1 PK KG 2015   ungraded_elementary 3.0 1.0 7.0         0.0     0.0   7.0 4.0             8     11   11 3 1 7         0     0   7 4         8   11   11
957746 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004616 131500010007 SMITH EARLY LEARNING CENTER public Regular School No Elementary PK KG 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   0   0
980014 NY Monroe   school 3601153 261600861049   ROCHESTER PREP CHARTER SCHOO 360115306592 261600861049 ROCHESTER PREP CHARTER SCHOOL 3 charter Regular School Yes Elementary KG KG 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
981135 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413006370 280201030016 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary KG KG 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   0   0
982104 NY Nassau   school 3611550 280209030000   FREEPORT 361155004441 280209030004 COLUMBUS AVENUE SCHOOL public Regular School No Elementary KG KG 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
982503 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157002021 280211030016 SCHOOL 6-KINDERGARTEN CTR public Regular School No Elementary KG KG 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
983225 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001657 280220030001 KINDERGARTEN CENTER public Regular School No Elementary KG KG 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   0   0
985049 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001022 280407030009 EARLY CHILDHOOD CENTER public Regular School No Elementary PK KG 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
1000439 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No Elementary PK KG 2017   ungraded_elementary 73.0                       45.0 28.0     67       69     73   73 73                       45 28     67   69   73   73
1012846 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781006098 500402060006 EAST RAMAPO EARLY CHLD CTR AT KAKIAT public Regular School No Elementary KG KG 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   0   0
1018375 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004843 580211060006 BICYCLE PATH KINDERGARTEN-PRE K public Regular School No Elementary PK KG 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
1018546 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004343 580211060018 UNITY DRIVE KINDERGARTEN-PRE K public Regular School No Elementary PK KG 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
1021852 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687001061 580513030009 CENTRAL ISLIP EARLY CHLDHD CENTER public Regular School No Elementary PK KG 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
1025785 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001256 641301060003 MARGARET MURPHY KINDERGARTEN CENTER public Regular School No Elementary PK KG 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
1027267 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003888 660401030001 JOHN PAULDING SCHOOL public Regular School No Elementary KG KG 2017   ungraded_elementary 3.0 0.0 2.0         0.0     0.0   5.0 0.0     *       *     5   5 3 0 2         0     0   5 0             5   5
1039959 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806562 321100010481 STEM BRIDGE SCHOOL (THE) public Regular School No 1.0 KG KG 2016   ungraded_elementary 1.0 1.0 0.0   0.0           0.0   2.0 0.0             *     *   2 1 1 0   0           0   2 0                 2
1039978 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806559 321100010483 MATILDA AVENUE SCHOOL (THE) public Regular School No 1.0 KG KG 2016   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
1040605 NY Bronx   school 3601127 321100861076   BRONX CHARTER SCHOOL-BETTER 360112706551 321100861076 BRONX CHARTER-BETTER LEARNING II charter Regular School Yes 1.0 KG KG 2016   ungraded_elementary 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]);