enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "grade_2" and state = "CT" sorted by ccd_school_lvl descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2436771 | 2436771 | CT | school | 904140 | 1290011 | Somers School District | 90414000818 | 1295111 | Mabelle B. Avery Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436779 | 2436779 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436796 | 2436796 | CT | school | 904230 | 1310011 | Southington School District | 90423000832 | 1315311 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436798 | 2436798 | CT | school | 904230 | 1310011 | Southington School District | 90423000833 | 1315111 | Joseph A. Depaolo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436809 | 2436809 | CT | school | 904290 | 1340011 | Stafford School District | 90429000061 | 1345211 | Stafford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436828 | 2436828 | CT | school | 904320 | 1350011 | Stamford School District | 90432000851 | 1355611 | Cloonan School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436829 | 2436829 | CT | school | 904320 | 1350011 | Stamford School District | 90432000853 | 1355311 | Dolan School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436830 | 2436830 | CT | school | 904320 | 1350011 | Stamford School District | 90432001353 | 1355811 | Rippowam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436831 | 2436831 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436832 | 2436832 | CT | school | 904320 | 1350011 | Stamford School District | 90432000870 | 1355511 | Turn of River School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436844 | 2436844 | CT | school | 904380 | 1370011 | Stonington School District | 90438000879 | 1375111 | Pawcatuck Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2436845 | 2436845 | CT | school | 904380 | 1370011 | Stonington School District | 90438000877 | 1375211 | Stonington Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436861 | 2436861 | CT | school | 904440 | 1380011 | Stratford School District | 90444000900 | 1385211 | David Wooster Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436862 | 2436862 | CT | school | 904440 | 1380011 | Stratford School District | 90444000888 | 1385311 | Harry B. Flood Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436873 | 2436873 | CT | school | 904470 | 1390011 | Suffield School District | 90447000902 | 1395111 | Suffield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436876 | 2436876 | CT | school | 904500 | 1400011 | Thomaston School District | 90450001117 | 1400211 | Thomaston Center School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436880 | 2436880 | CT | school | 904530 | 1410011 | Thompson School District | 90453000910 | 1415111 | Thompson Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436884 | 2436884 | CT | school | 904560 | 1420011 | Tolland School District | 90456000915 | 1425111 | Tolland Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436894 | 2436894 | CT | school | 904590 | 1430011 | Torrington School District | 90459000925 | 1435111 | Torrington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436904 | 2436904 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000930 | 1445211 | Hillcrest Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436905 | 2436905 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000933 | 1445111 | Madison Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436919 | 2436919 | CT | school | 904680 | 1460011 | Vernon School District | 90468000947 | 1465111 | Vernon Center Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436936 | 2436936 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000951 | 1485211 | Dag Hammarskjold Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436938 | 2436938 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000954 | 1485311 | James H. Moran Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436979 | 2436979 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000991 | 1515211 | West Side Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436982 | 2436982 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000983 | 1515111 | Michael F. Wallace Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436986 | 2436986 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001115 | 1515311 | North End Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436991 | 2436991 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001395 | 1515011 | Waterbury Arts Magnet School (Middle) | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437007 | 2437007 | CT | school | 904860 | 1520011 | Waterford School District | 90486000994 | 1525111 | Clark Lane Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437014 | 2437014 | CT | school | 904890 | 1530011 | Watertown School District | 90489001007 | 1535111 | Swift Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437034 | 2437034 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001419 | 1555311 | Bristow Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437035 | 2437035 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437036 | 2437036 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437050 | 2437050 | CT | school | 904950 | 1560011 | West Haven School District | 90495001037 | 1565311 | Carrigan 5/6 Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437051 | 2437051 | CT | school | 904950 | 1560011 | West Haven School District | 90495001036 | 1565111 | Harry M. Bailey Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437057 | 2437057 | CT | school | 904980 | 1540011 | Westbrook School District | 90498001043 | 1545111 | Westbrook Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437061 | 2437061 | CT | school | 905010 | 1570011 | Weston School District | 90501001047 | 1575111 | Weston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437072 | 2437072 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437073 | 2437073 | CT | school | 905040 | 1580011 | Westport School District | 90504001052 | 1585311 | Coleytown Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437082 | 2437082 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001066 | 1595211 | Silas Deane Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437086 | 2437086 | CT | school | 905100 | 1600011 | Willington School District | 90510001070 | 1605111 | Hall Memorial School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437088 | 2437088 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437103 | 2437103 | CT | school | 905190 | 1630011 | Windham School District | 90519001081 | 1635111 | Windham Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437109 | 2437109 | CT | school | 905250 | 1650011 | Windsor Locks School District | 90525001101 | 1655111 | Windsor Locks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437117 | 2437117 | CT | school | 905220 | 1640011 | Windsor School District | 90522001095 | 1645311 | Sage Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437125 | 2437125 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001102 | 1665111 | Tyrrell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437130 | 2437130 | CT | school | 905370 | 1690011 | Woodstock School District | 90537000573 | 1695111 | Woodstock Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437144 | 2437144 | CT | school | 900033 | 2830013 | Park City Prep Charter School District | 90003301449 | 2835113 | Park City Prep Charter School | Public Charter Schools | Regular School | Yes | Middle | 05 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437145 | 2437145 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Middle | 06 | 10 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437146 | 2437146 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437147 | 2437147 | CT | school | 900023 | 2780013 | Trailblazers Academy District | 90002300965 | 2785113 | Trailblazers Academy | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2437148 | 2437148 | CT | school | 903630 | 2040012 | Regional School District 04 | 90363000767 | 2045112 | John Winthrop Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437151 | 2437151 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366001114 | 2055112 | Amity Middle School: Bethany | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437152 | 2437152 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000769 | 2055212 | Amity Middle School: Orange | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437157 | 2437157 | CT | school | 903720 | 2070012 | Regional School District 07 | 90372001226 | 2075112 | Northwestern Regional Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2437162 | 2437162 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375001210 | 2085112 | RHAM Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741408 | 2741408 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741417 | 2741417 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741418 | 2741418 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741426 | 2741426 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741433 | 2741433 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741441 | 2741441 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741443 | 2741443 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741453 | 2741453 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741518 | 2741518 | CT | school | 900510 | 170011 | Bristol School District | 90051000089 | 175111 | Chippens Hill Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741525 | 2741525 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741534 | 2741534 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741537 | 2741537 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741539 | 2741539 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741542 | 2741542 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741560 | 2741560 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001625 | 2415314 | Greater Hartford Academy of the Arts Magnet Middle | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741562 | 2741562 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001364 | 2415014 | Two Rivers Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741576 | 2741576 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741582 | 2741582 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741586 | 2741586 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741603 | 2741603 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741608 | 2741608 | CT | school | 900990 | 330011 | Cromwell School District | 90099000147 | 335111 | Cromwell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741624 | 2741624 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741625 | 2741625 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741626 | 2741626 | CT | school | 901020 | 340011 | Danbury School District | 90102001691 | 340311 | Westside Middle School Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741635 | 2741635 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741640 | 2741640 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741645 | 2741645 | CT | school | 901170 | 400011 | East Granby School District | 90117000182 | 405111 | East Granby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741648 | 2741648 | CT | school | 901200 | 410011 | East Haddam School District | 90120000198 | 415111 | Nathan Hale-Ray Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741653 | 2741653 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741666 | 2741666 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741667 | 2741667 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741677 | 2741677 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741683 | 2741683 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741688 | 2741688 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741699 | 2741699 | CT | school | 901410 | 460011 | Easton School District | 90141000233 | 465111 | Helen Keller Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741710 | 2741710 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741732 | 2741732 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741751 | 2741751 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741752 | 2741752 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741753 | 2741753 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741763 | 2741763 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741764 | 2741764 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741775 | 2741775 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2021 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2741776 | 2741776 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | grade_2 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);