Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_2 · 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
1443031 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   grade_2 0.0 1.0 1.0         0.0         2.0 0.0     *       *     *   2 0 1 1         0         2 0                 2
1532996 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
2156368 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       *     *   0 0 0 0   0     0     0   0 0                 0
1435374 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406714 320700011625 WALKABOUT BRONX HIGH SCHOOL public Regular School No Secondary 09 09 2021   grade_2   0.0 0.0                   0.0 0.0     *       0     0   0   0 0                   0 0         0   0   0
1435906 NY Bronx   school 3601195 320700861154   AECI II: NYC CHARTER HS-COM 360119506687 320700861154 AECI II: NYC CHARTER HS-COMP ENGIN charter Regular School Yes Secondary 09 10 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1443012 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 11 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1446128 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Secondary 09 09 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450498 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1469669 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000864 261301060007 MINERVA DELAND SCHOOL public Regular School No Secondary 09 10 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1477839 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863003506 280523030014 MHS AMES CAMPUS public Regular School No Secondary 09 09 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1478523 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500806 307500013373 PS 373 BROOKLYN TRANSITION CENTER public Special Education School No Secondary 09 11 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1478960 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502864 307500015721 RICHARD H HUNGERFORD SCHOOL (THE) public Special Education School No Secondary 09 09 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1482456 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806547 310300011291 WEST END SECONDARY SCHOOL public Regular School No Secondary 06 11 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1488099 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1488764 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1490037 NY Onondaga   school 3601174 421800861125   ONTECH CHARTER HIGH SCHOOL 360117406658 421800861125 ONTECH CHARTER HIGH SCHOOL charter Regular School Yes Secondary 09 11 2021   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
1497884 NY Queens   school 3601211 342700861147   NEW DAWN CHARTER HS II 360121106692 342700861147 NEW DAWN CHARTER HS II charter Regular School Yes Secondary 09 10 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1503033 NY Richmond   school 3601179 353100861136   LOIS AND RICHARD NICOTRA EAR 360117906664 353100861136 LOIS AND RICHARD NICOTRA EARLY COLLE charter Regular School Yes Secondary 08 11 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1512970 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004829 580512030026 FRESHMAN CENTER public Regular School No Secondary 09 09 2021   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
1518366 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000784 660301030005 EASTCHESTER MIDDLE SCHOOL public Regular School No Secondary 06 11 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1519145 NY Westchester   school 3610140 660411020000   GREENBURGH 11 361014000454 660411020003 GREENBURGH ELEVEN MIDDLE SCHOOL public Special Education School No Secondary 07 11 2021   grade_2 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
1525776 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes Secondary 06 11 2020   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
1525966 NY Bronx   school 3601195 320700861154   AECI II: NYC CHARTER HS-COM 360119506687 320700861154 AECI II: NYC CHARTER HS-COMP ENGIN charter Regular School Yes Secondary 09 09 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1532977 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 10 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1536150 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2020   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1540520 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2020   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       *     *   0 0 0 0         0         0 0     0           0
1541337 NY Erie   school 3605850 140600010000   BUFFALO 360585006609 140600010310 RIVERSIDE ACADEMY HIGH SCHOOL public Regular School No Secondary 09 11 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1547721 NY Kings   school 3601111 331300861063   BROOKLYN LABORATORY CHARTER S 360111106493 331300861063 BROOKLYN LABORATORY CHARTER SCHOOL charter Regular School Yes Secondary 06 11 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1550419 NY Kings   school 3601160 331600861112   BROOKLYN EMERGING LEADERS AC 360116006622 331600861112 BROOKLYN EMERGING LEADERS ACADEMY CS charter Regular School Yes Secondary 09 11 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0     0.0     *       0     0   0 0 0 0   0     0     0     0         0   0   0
1559767 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000864 261301060007 MINERVA DELAND SCHOOL public Regular School No Secondary 09 09 2020   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1567994 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863003506 280523030014 MHS AMES CAMPUS public Regular School No Secondary 09 09 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1568203 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502079 307500012012 PS 12 LEWIS AND CLARK SCHOOL public Special Education School No Secondary 10 10 2020   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
1578254 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1578919 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1580192 NY Onondaga   school 3601174 421800861125   ONTECH CHARTER HIGH SCHOOL 360117406658 421800861125 ONTECH CHARTER HIGH SCHOOL charter Regular School Yes Secondary 09 10 2020   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1587906 NY Queens   school 3601162 342700861052   NEW VISIONS CHARTER HS-HUMAN 360116206621 342700861052 NEW VISIONS CHARTER HS-HUMANITIES IV charter Regular School Yes Secondary 09 11 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1588001 NY Queens   school 3601211 342700861147   NEW DAWN CHARTER HS II 360121106692 342700861147 NEW DAWN CHARTER HS II charter Regular School Yes Secondary 09 09 2020   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1592162 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306522 353100010028 EAGLE ACADEMY FOR YOUNG MEN public Regular School No Secondary 06 11 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0       0       0     0   0 0 0 0   0     0     0   0       0   0   0   0
1593169 NY Richmond   school 3601179 353100861136   LOIS AND RICHARD NICOTRA EAR 360117906664 353100861136 LOIS AND RICHARD NICOTRA EARLY COLLE charter Regular School Yes Secondary 08 10 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1603106 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004829 580512030026 FRESHMAN CENTER public Regular School No Secondary 09 09 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1609281 NY Westchester   school 3610140 660411020000   GREENBURGH 11 361014000454 660411020003 GREENBURGH ELEVEN MIDDLE SCHOOL public Special Education School No Secondary 07 10 2020   grade_2   0.0 0.0               0.0   0.0               0     0   0   0 0               0   0           0   0   0
2052229 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 10 2018   grade_2   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
2054376 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No Secondary 06 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
2056713 NY Bronx   school 3601133 321000861064   CHARTER HIGH SCHOOL-LAW AND 360113306569 321000861064 CHARTER HIGH SCHOOL-LAW AND SOCIAL charter Regular School Yes Secondary 09 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2062280 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2066707 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       *     *   0 0 0 0   0     0         0 0                 0
2067467 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY HIGH SCHOOL public Regular School No Secondary 08 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2067486 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 10 2018   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2067581 NY Erie   school 3605850 140600010000   BUFFALO 360585006609 140600010310 RIVERSIDE ACADEMY HIGH SCHOOL public Regular School No Secondary 09 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2067600 NY Erie   school 3605850 140600010000   BUFFALO 360585006611 140600010311 LEWIS J BENNETT HS OF INNOVATIVE TEC public Regular School No Secondary 09 10 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2079076 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006339 331900011422 SPRING CREEK COMMUNITY SCHOOL public Regular School No Secondary 06 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2085821 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000864 261301060007 MINERVA DELAND SCHOOL public Regular School No Secondary 09 09 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2094010 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863003506 280523030014 MHS AMES CAMPUS public Regular School No Secondary 09 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2094675 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500806 307500013373 PS 373 BROOKLYN TRANSITION CENTER public Special Education School No Secondary 11 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2096385 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704410 310200010260 MS 260 CLINTON SCH WRITERS & ARTISTS public Regular School No Secondary 06 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2097145 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No Secondary 09 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
2100698 NY New York   school 3601078 310500861001   DEMOCRACY PREP ENDURANCE 360107806310 310500861001 DEMOCRACY PREP ENDURANCE CHARTER charter Regular School Yes Secondary 06 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2104384 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2105049 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2111243 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806066 342400011744 VOYAGES PREPARATORY public Regular School No Secondary 09 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2114036 NY Queens   school 3601162 342700861052   NEW VISIONS CHARTER HS-HUMAN 360116206621 342700861052 NEW VISIONS CHARTER HS-HUMANITIES IV charter Regular School Yes Secondary 09 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2114055 NY Queens   school 3601136 342700861054   NEW VISIONS CHTR HS-ADV MA/S 360113606549 342700861054 NEW VISIONS CHTR HS-ADV MA/SCI IV charter Regular School Yes Secondary 09 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2129084 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004829 580512030026 FRESHMAN CENTER public Regular School No Secondary 09 09 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141909 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2148863 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2151998 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2157109 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2157128 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2157204 NY Erie   school 3605850 140600010000   BUFFALO 360585006609 140600010310 RIVERSIDE ACADEMY HIGH SCHOOL public Regular School No Secondary 09 10 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2157223 NY Erie   school 3605850 140600010000   BUFFALO 360585006611 140600010311 LEWIS J BENNETT HS OF INNOVATIVE TEC public Regular School No Secondary 09 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2163550 NY Kings   school 3601094 331300861056   UNITY PREP CHARTER SCH OF BR 360109406404 331300861056 UNITY PREP CHARTER SCH OF BROOKLYN charter Regular School Yes Secondary 06 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2175501 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000864 261301060007 MINERVA DELAND SCHOOL public Regular School No Secondary 09 09 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2183728 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863003506 280523030014 MHS AMES CAMPUS public Regular School No Secondary 09 09 2019   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2183766 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Secondary 08 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2183937 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502079 307500012012 PS 12 LEWIS AND CLARK SCHOOL public Special Education School No Secondary 11 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2184849 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502864 307500015721 RICHARD H HUNGERFORD SCHOOL (THE) public Special Education School No Secondary 11 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2187566 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700668 310200011570 SATELLITE ACADEMY HIGH SCHOOL public Regular School No Secondary 09 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2189941 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008106379 310500011148 EAGLE ACADEMY FOR YOUNG MEN-HARLEM public Regular School No Secondary 06 11 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0       0       0     0   0 0 0 0   0     0     0   0       0   0   0   0
2193969 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2194634 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2195926 NY Onondaga   school 3601174 421800861125   ONTECH CHARTER HIGH SCHOOL 360117406658 421800861125 ONTECH CHARTER HIGH SCHOOL charter Regular School Yes Secondary 09 09 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2200790 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806066 342400011744 VOYAGES PREPARATORY public Regular School No Secondary 09 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2203621 NY Queens   school 3601162 342700861052   NEW VISIONS CHARTER HS-HUMAN 360116206621 342700861052 NEW VISIONS CHARTER HS-HUMANITIES IV charter Regular School Yes Secondary 09 10 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2208827 NY Richmond   school 3601179 353100861136   LOIS AND RICHARD NICOTRA EAR 360117906664 353100861136 LOIS AND RICHARD NICOTRA EARLY COLLE charter Regular School Yes Secondary 08 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2218726 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004829 580512030026 FRESHMAN CENTER public Regular School No Secondary 09 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2225889 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010006668 660900010027 MOUNT VERNON STEAM ACADEMY public Regular School No Secondary 08 10 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1434614 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_2 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1485762 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2021   grade_2 0.0   0.0         0.0     0.0   0.0 0.0                   *   0 0   0         0     0   0 0                 0
1486997 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1488156 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1488175 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     *   0 0 0 0         0     0   0 0                 0
1507251 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1507859 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0                   0.0   0.0 0.0             *     *   0 0                   0   0 0                 0
1508467 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1518974 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001047 660407060006 EARLY CHLDHD PROG public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
1520798 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524693 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_2 0.0                       0.0 0.0                       0 0                       0 0                 0
1575917 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2020   grade_2 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1577152 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Prekindergarten PK PK 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1578311 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2020   grade_2 0.0 0.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]);