enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_8" and state = "CT" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,354 ✖
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 ▲
2445745 2445745 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   498                                             498
2444827 2444827 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   486                                             486
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
2750440 2750440 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   475                                             475
2444890 2444890 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   472                                             472
2771712 2771712 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   463                                             463
2770861 2770861 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   450                                             450
2750625 2750625 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   434                                             434
2771733 2771733 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   428                                             428
2750503 2750503 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   425                                             425
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
2445026 2445026 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   408                                             408
2444784 2444784 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   398                                             398
2445451 2445451 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   398                                             398
2750330 2750330 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   397                                             397
2750299 2750299 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   395                                             395
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
2771417 2771417 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   380                                             380
2750396 2750396 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   376                                             376
2770753 2770753 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   376                                             376
2770694 2770694 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   373                                             373
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
2444634 2444634 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   369                                             369
2750289 2750289 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   369                                             369
2770663 2770663 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   367                                             367
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
2445473 2445473 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   354                                             354
2750428 2750428 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   352                                             352
2444692 2444692 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   351                                             351
2445782 2445782 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   351                                             351
2445160 2445160 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   350                                             350
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
2771089 2771089 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   347                                             347
2444682 2444682 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   345                                             345
2445243 2445243 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   345                                             345
2445259 2445259 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   344                                             344
2771640 2771640 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   grade_8                                                   344                                             344
2771220 2771220 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   341                                             341
2771748 2771748 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   340                                             340
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
2770653 2770653 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   338                                             338
2770772 2770772 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   337                                             337
2444681 2444681 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   336                                             336
2750240 2750240 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   335                                             335
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
2770785 2770785 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   335                                             335
2445588 2445588 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   333                                             333
2445676 2445676 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   333                                             333
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
2771438 2771438 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   333                                             333
2445128 2445128 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   332                                             332
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
2771552 2771552 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   331                                             331
2444722 2444722 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   330                                             330
2770652 2770652 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   326                                             326
2750288 2750288 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   325                                             325
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
2771122 2771122 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2020   grade_8                                                   325                                             325
2750680 2750680 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   324                                             324
2771204 2771204 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   324                                             324
2445680 2445680 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   321                                             321
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
2771696 2771696 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   321                                             321
2445673 2445673 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   320                                             320
2770605 2770605 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   318                                             318
2445729 2445729 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   317                                             317
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
2750474 2750474 CT     school 901770 590011   Groton School District 90177001938 591111 Groton Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   313                                             313
2771563 2771563 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   312                                             312
2771641 2771641 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   312                                             312
2444802 2444802 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   311                                             311
2770773 2770773 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   311                                             311
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
2444872 2444872 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 09 2019   grade_8                                                   308                                             308
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
2445152 2445152 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   306                                             306
2445461 2445461 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   306                                             306
2771427 2771427 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   306                                             306
2445081 2445081 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   305                                             305
2771695 2771695 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   300                                             300
2771042 2771042 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   299                                             299
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
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
2445766 2445766 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   294                                             294
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
2771519 2771519 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   291                                             291
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
2750097 2750097 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   288                                             288
2750653 2750653 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   288                                             288
2771114 2771114 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   288                                             288
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
2771518 2771518 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   285                                             285
2445492 2445492 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   284                                             284
2445556 2445556 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   282                                             282
2444846 2444846 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   281                                             281
2445150 2445150 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   280                                             280
2445730 2445730 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   279                                             279
2750082 2750082 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   277                                             277
2771112 2771112 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   276                                             276
2771647 2771647 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   276                                             276

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