enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,254 ✖
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
2444709 2444709 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   142                                             142
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
2444723 2444723 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   102                                             102
2444733 2444733 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   173                                             173
2444739 2444739 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   208                                             208
2444744 2444744 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   86                                             86
2444753 2444753 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   121                                             121
2444763 2444763 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   219                                             219
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
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
2444803 2444803 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   247                                             247
2444804 2444804 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   223                                             223
2444814 2444814 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2019   grade_8                                                   0                                             0
2444815 2444815 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   *                                              
2444826 2444826 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2019   grade_8                                                   0                                             0
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
2444832 2444832 CT     school 901680 560011   Granby School District 90168000291 565111 Granby Memorial Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   130                                             130
2444845 2444845 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   202                                             202
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
2444847 2444847 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   216                                             216
2444852 2444852 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   117                                             117
2444861 2444861 CT     school 901770 590011   Groton School District 90177000312 595311 Carl C. Cutler Middle School   Regular School No Middle 06 08 2019   grade_8                                                   146                                             146
2444862 2444862 CT     school 901770 590011   Groton School District 90177000326 595211 West Side Middle School   Regular School No Middle 06 08 2019   grade_8                                                   139                                             139
2444871 2444871 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
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
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
2444937 2444937 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2019   grade_8                                                   30                                             30
2444938 2444938 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   71                                             71
2444941 2444941 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   56                                             56
2444942 2444942 CT     school 901920 640011   Hartford School District 90192000371 641211 McDonough Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   96                                             96
2444973 2444973 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   166                                             166
2444983 2444983 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2019   grade_8                                                   50                                             50
2444992 2444992 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   74                                             74
2444998 2444998 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   196                                             196
2445003 2445003 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2019   grade_8                                                   0                                             0
2445004 2445004 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   70                                             70
2445010 2445010 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2445011 2445011 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   214                                             214
2445024 2445024 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
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
2445035 2445035 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   131                                             131
2445049 2445049 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   252                                             252
2445053 2445053 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   248                                             248
2445080 2445080 CT     school 902490 830011   Middletown School District 90249000456 831511 Keigwin Middle School Public Schools Regular School No Middle 06 06 2019   grade_8                                                   0                                             0
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
2445097 2445097 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   147                                             147
2445098 2445098 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   159                                             159
2445099 2445099 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   155                                             155
2445108 2445108 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   249                                             249
2445115 2445115 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   175                                             175
2445126 2445126 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2445127 2445127 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
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
2445149 2445149 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2019   grade_8                                                   46                                             46
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
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
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
2445165 2445165 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   156                                             156
2445216 2445216 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   122                                             122
2445236 2445236 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   107                                             107
2445237 2445237 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   grade_8                                                   52                                             52
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
2445250 2445250 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   168                                             168
2445251 2445251 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   160                                             160
2445258 2445258 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
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
2445265 2445265 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   151                                             151
2445273 2445273 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   236                                             236
2445291 2445291 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   217                                             217
2445292 2445292 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   249                                             249
2445293 2445293 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   159                                             159
2445294 2445294 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   216                                             216
2445312 2445312 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   216                                             216
2445314 2445314 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   120                                             120
2445318 2445318 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 04 08 2019   grade_8                                                   97                                             97
2445326 2445326 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   174                                             174
2445333 2445333 CT     school 903270 1090011   Plainfield School District 90327000693 1095111 Plainfield Central School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   168                                             168
2445338 2445338 CT     school 903300 1100011   Plainville School District 90330000048 1105211 Middle School of Plainville Public Schools Regular School No Middle 06 08 2019   grade_8                                                   184                                             184
2445343 2445343 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   112                                             112
2445348 2445348 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2445349 2445349 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   114                                             114
2445352 2445352 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   48                                             48
2445354 2445354 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   105                                             105
2445358 2445358 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   107                                             107
2445369 2445369 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   grade_8                                                   182                                             182
2445378 2445378 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2019   grade_8                                                   0                                             0
2445379 2445379 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 07 08 2019   grade_8                                                   148                                             148
2445384 2445384 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   grade_8                                                   135                                             135
2445391 2445391 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2019   grade_8                                                   155                                             155
2445392 2445392 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2019   grade_8                                                   146                                             146
2445397 2445397 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2019   grade_8                                                   186                                             186
2445403 2445403 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   grade_8                                                   185                                             185
2445409 2445409 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2019   grade_8                                                   102                                             102
2445422 2445422 CT     school 903810 1180011   Ridgefield School District 90381000776 1185111 East Ridge Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   253                                             253
2445423 2445423 CT     school 903810 1180011   Ridgefield School District 90381001361 1185211 Scotts Ridge Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   170                                             170
2445430 2445430 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   197                                             197
2445438 2445438 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   174                                             174
2445450 2445450 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
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
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

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