enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_7", 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_7 · 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 ▲
2749900 2749900 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_7                                                   450                                             450
2749181 2749181 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   418                                             418
2749059 2749059 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   411                                             411
2749921 2749921 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   410                                             410
2748886 2748886 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   398                                             398
2749632 2749632 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   390                                             390
2748855 2748855 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   389                                             389
2748845 2748845 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   382                                             382
2749830 2749830 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2021   grade_7                                                   378                                             378
2749282 2749282 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   348                                             348
2748952 2748952 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   346                                             346
2748844 2748844 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   341                                             341
2749030 2749030 CT     school 901770 590011   Groton School District 90177001938 591111 Groton Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   333                                             333
2749746 2749746 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   331                                             331
2748984 2748984 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   330                                             330
2749317 2749317 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   318                                             318
2749015 2749015 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   306                                             306
2748971 2748971 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   303                                             303
2749886 2749886 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   303                                             303
2749236 2749236 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   301                                             301
2749885 2749885 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   300                                             300
2749842 2749842 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   299                                             299
2748796 2748796 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   298                                             298
2749621 2749621 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   298                                             298
2749834 2749834 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   297                                             297
2749712 2749712 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   295                                             295
2749936 2749936 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   293                                             293
2749209 2749209 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   288                                             288
2749417 2749417 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   285                                             285
2748972 2748972 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   283                                             283
2749930 2749930 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   283                                             283
2749399 2749399 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   282                                             282
2749307 2749307 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   281                                             281
2749309 2749309 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   281                                             281
2749204 2749204 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   280                                             280
2749757 2749757 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   279                                             279
2748653 2748653 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   270                                             270
2749756 2749756 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   264                                             264
2749683 2749683 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   262                                             262
2749262 2749262 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   259                                             259
2749713 2749713 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   253                                             253
2749652 2749652 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   252                                             252
2749452 2749452 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   247                                             247
2748846 2748846 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   grade_7                                                   246                                             246
2749967 2749967 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   243                                             243
2749650 2749650 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   241                                             241
2748782 2748782 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_7                                                   239                                             239
2749431 2749431 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   235                                             235
2749681 2749681 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   235                                             235
2748638 2748638 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   234                                             234
2749991 2749991 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_7                                                   234                                             234
2749450 2749450 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   230                                             230
2748973 2748973 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   223                                             223
2749472 2749472 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   223                                             223
2749040 2749040 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   222                                             222
2748738 2748738 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   221                                             221
2749953 2749953 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   220                                             220
2748903 2748903 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   217                                             217
2748930 2748930 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   215                                             215
2748673 2748673 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   213                                             213
2749682 2749682 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   213                                             213
2749684 2749684 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   212                                             212
2749770 2749770 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   212                                             212
2748646 2748646 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   208                                             208
2749589 2749589 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_7                                                   208                                             208
2749790 2749790 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   207                                             207
2749788 2749788 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   206                                             206
2749016 2749016 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   203                                             203
2749014 2749014 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   201                                             201
2749685 2749685 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   200                                             200
2749865 2749865 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   200                                             200
2749527 2749527 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   grade_7                                                   198                                             198
2749859 2749859 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   196                                             196
2749269 2749269 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   194                                             194
2750025 2750025 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   grade_7                                                   191                                             191
2749910 2749910 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   190                                             190
2748754 2748754 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   188                                             188
2749499 2749499 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2021   grade_7                                                   188                                             188
2749168 2749168 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   186                                             186
2750014 2750014 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2021   grade_7                                                   185                                             185
2749597 2749597 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   184                                             184
2749736 2749736 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   184                                             184
2749108 2749108 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2021   grade_7                                                   181                                             181
2749578 2749578 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   181                                             181
2749579 2749579 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   180                                             180
2749322 2749322 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   179                                             179
2748628 2748628 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   177                                             177
2749449 2749449 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   177                                             177
2749451 2749451 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   174                                             174
2749976 2749976 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   173                                             173
2749137 2749137 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 09 2021   grade_7                                                   172                                             172
2750015 2750015 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2021   grade_7                                                   170                                             170
2748897 2748897 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   169                                             169
2748806 2748806 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   168                                             168
2749494 2749494 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   168                                             168
2749554 2749554 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   166                                             166
2749407 2749407 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   165                                             165
2749406 2749406 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   159                                             159
2749548 2749548 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   156                                             156
2749560 2749560 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   150                                             150

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