enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,444 ✖

grade ✖

  • grade_6 · 1,444 ✖
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 ▲
2747735 2747735 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2021   grade_6                                                   454                                             454
2747551 2747551 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2021   grade_6                                                   416                                             416
2747508 2747508 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   390                                             390
2748386 2748386 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2021   grade_6                                                   380                                             380
2748455 2748455 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_6                                                   379                                             379
2748166 2748166 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   378                                             378
2748477 2748477 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   375                                             375
2747411 2747411 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   359                                             359
2747400 2747400 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   357                                             357
2748188 2748188 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   356                                             356
2747873 2747873 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   346                                             346
2747586 2747586 CT     school 901770 590011   Groton School District 90177001938 591111 Groton Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   324                                             324
2748302 2748302 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   322                                             322
2747401 2747401 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   317                                             317
2748492 2748492 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   317                                             317
2747539 2747539 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2021   grade_6                                                   314                                             314
2748390 2748390 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   308                                             308
2748398 2748398 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   304                                             304
2747863 2747863 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   301                                             301
2747865 2747865 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   299                                             299
2747442 2747442 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   294                                             294
2747971 2747971 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   291                                             291
2747791 2747791 CT     school 902490 830011   Middletown School District 90249000456 831511 Keigwin Middle School Public Schools Regular School No Middle 06 06 2021   grade_6                                                   289                                             289
2747760 2747760 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   281                                             281
2748441 2748441 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   281                                             281
2747528 2747528 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   280                                             280
2747765 2747765 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   275                                             275
2748442 2748442 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   268                                             268
2747955 2747955 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   265                                             265
2747193 2747193 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   263                                             263
2748239 2748239 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   261                                             261
2747527 2747527 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   260                                             260
2747571 2747571 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   259                                             259
2747818 2747818 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   254                                             254
2747402 2747402 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   grade_6                                                   250                                             250
2748523 2748523 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   250                                             250
2748547 2748547 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_6                                                   247                                             247
2747595 2747595 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   241                                             241
2748208 2748208 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   241                                             241
2748206 2748206 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   239                                             239
2747209 2747209 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   237                                             237
2748326 2748326 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   237                                             237
2747987 2747987 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   234                                             234
2748313 2748313 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   233                                             233
2748312 2748312 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   231                                             231
2747294 2747294 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   224                                             224
2748241 2748241 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   224                                             224
2748007 2748007 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   223                                             223
2748145 2748145 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_6                                                   223                                             223
2747338 2747338 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_6                                                   220                                             220
2748237 2748237 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   220                                             220
2748008 2748008 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   215                                             215
2748006 2748006 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   214                                             214
2748421 2748421 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   214                                             214
2748344 2748344 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   213                                             213
2748005 2748005 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   211                                             211
2748509 2748509 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   211                                             211
2748346 2748346 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   204                                             204
2748240 2748240 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   203                                             203
2747529 2747529 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   199                                             199
2748238 2748238 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   199                                             199
2747572 2747572 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   197                                             197
2748292 2748292 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   197                                             197
2747202 2747202 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   195                                             195
2748028 2748028 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   194                                             194
2747310 2747310 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   193                                             193
2747229 2747229 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   189                                             189
2747570 2747570 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   188                                             188
2747453 2747453 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   182                                             182
2748415 2748415 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   181                                             181
2747459 2747459 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   179                                             179
2747712 2747712 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 06 10 2021   grade_6                                                   178                                             178
2748153 2748153 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   177                                             177
2747724 2747724 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   174                                             174
2748466 2748466 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   172                                             172
2748134 2748134 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   169                                             169
2748532 2748532 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   169                                             169
2747384 2747384 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   168                                             168
2747664 2747664 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2021   grade_6                                                   168                                             168
2748135 2748135 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   168                                             168
2748055 2748055 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2021   grade_6                                                   167                                             167
2747362 2747362 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   165                                             165
2747962 2747962 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   164                                             164
2747837 2747837 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   162                                             162
2747836 2747836 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   156                                             156
2747557 2747557 CT     school 901680 560011   Granby School District 90168000291 565111 Granby Memorial Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   153                                             153
2747808 2747808 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   153                                             153
2748083 2748083 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   grade_6                                                   151                                             151
2748110 2748110 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   grade_6                                                   149                                             149
2747979 2747979 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   145                                             145
2747825 2747825 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   143                                             143
2747878 2747878 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   143                                             143
2748030 2748030 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_6                                                   142                                             142
2748050 2748050 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   142                                             142
2748281 2748281 CT     school 904470 1390011   Suffield School District 90447000902 1395111 Suffield Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   141                                             141
2747693 2747693 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 09 2021   grade_6                                                   140                                             140
2748116 2748116 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   grade_6                                                   139                                             139
2747963 2747963 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   138                                             138
2747429 2747429 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   136                                             136
2748251 2748251 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   134                                             134

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