enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_8", state = "CT" and year = 2021 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,344 ✖

grade ✖

  • grade_8 · 1,344 ✖
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
2750726 2750726 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   350                                             350
2750750 2750750 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2021   grade_8                                                   54                                             54
2750751 2750751 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   315                                             315
2750753 2750753 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   262                                             262
2750761 2750761 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   357                                             357
2750766 2750766 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   174                                             174
2750816 2750816 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   114                                             114
2750836 2750836 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   111                                             111
2750843 2750843 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   321                                             321
2750850 2750850 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   170                                             170
2750851 2750851 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   164                                             164
2750859 2750859 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2750861 2750861 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   338                                             338
2750867 2750867 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   123                                             123
2750875 2750875 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   270                                             270
2750893 2750893 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   207                                             207
2750894 2750894 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   212                                             212
2750895 2750895 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   195                                             195
2750896 2750896 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   273                                             273
2750916 2750916 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   239                                             239
2750918 2750918 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   146                                             146
2750922 2750922 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   87                                             87
2750930 2750930 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   157                                             157
2750938 2750938 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   169                                             169
2750943 2750943 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2021   grade_8                                                   176                                             176
2750948 2750948 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   100                                             100
2750953 2750953 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2750954 2750954 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   109                                             109
2750957 2750957 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   58                                             58
2750959 2750959 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   91                                             91
2750963 2750963 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   100                                             100
2750971 2750971 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   grade_8                                                   197                                             197
2750981 2750981 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   138                                             138
2750986 2750986 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   95                                             95
2750992 2750992 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   146                                             146
2750993 2750993 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   130                                             130
2750998 2750998 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   177                                             177
2751004 2751004 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   144                                             144
2751009 2751009 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   grade_8                                                   96                                             96
2751022 2751022 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   188                                             188
2751023 2751023 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   191                                             191
2751033 2751033 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   179                                             179
2751041 2751041 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   194                                             194
2751054 2751054 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2751055 2751055 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   383                                             383
2751065 2751065 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   325                                             325
2751069 2751069 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   106                                             106
2751076 2751076 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   333                                             333
2751094 2751094 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   240                                             240
2751096 2751096 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   222                                             222
2751107 2751107 CT     school 904290 1340011   Stafford School District 90429000061 1345211 Stafford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   101                                             101
2751125 2751125 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   240                                             240
2751126 2751126 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   217                                             217
2751127 2751127 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   285                                             285
2751128 2751128 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   228                                             228
2751129 2751129 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   239                                             239
2751139 2751139 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   177                                             177
2751156 2751156 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   307                                             307
2751157 2751157 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   237                                             237
2751169 2751169 CT     school 904470 1390011   Suffield School District 90447000902 1395111 Suffield Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   154                                             154
2751172 2751172 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2021   grade_8                                                   0                                             0
2751176 2751176 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   79                                             79
2751180 2751180 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   200                                             200
2751190 2751190 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   335                                             335
2751200 2751200 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   261                                             261
2751201 2751201 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   266                                             266
2751214 2751214 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   251                                             251
2751232 2751232 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   219                                             219
2751234 2751234 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   186                                             186
2751274 2751274 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2021   grade_8                                                   370                                             370
2751278 2751278 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   291                                             291
2751283 2751283 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2021   grade_8                                                   127                                             127
2751286 2751286 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   332                                             332
2751303 2751303 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   204                                             204
2751309 2751309 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   234                                             234
2751328 2751328 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   138                                             138
2751329 2751329 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   290                                             290
2751330 2751330 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   296                                             296
2751343 2751343 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2751344 2751344 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   477                                             477
2751350 2751350 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   48                                             48
2751354 2751354 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   196                                             196
2751365 2751365 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   422                                             422
2751374 2751374 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   295                                             295
2751378 2751378 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   58                                             58
2751380 2751380 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   310                                             310
2751397 2751397 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   247                                             247
2751403 2751403 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   118                                             118
2751411 2751411 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   242                                             242
2751420 2751420 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   198                                             198
2751425 2751425 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   101                                             101
2751435 2751435 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_8                                                   239                                             239
2751450 2751450 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 2021   grade_8                                                   79                                             79
2751452 2751452 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 2021   grade_8                                                   94                                             94
2751455 2751455 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2021   grade_8                                                   122                                             122
2751458 2751458 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2021   grade_8                                                   172                                             172
2751459 2751459 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2021   grade_8                                                   180                                             180
2751463 2751463 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2021   grade_8                                                   157                                             157
2751469 2751469 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   grade_8                                                   199                                             199
2750073 2750073 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2021   grade_8                                                   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]);