schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
2769336 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   477                                             477
2770251 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_7                                                   471                                             471
2444296 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_7                                                   462                                             462
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
2769526 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   436                                             436
2443441 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   428                                             428
2769400 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   426                                             426
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 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
2770272 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   411                                             411
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 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
2769956 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   397                                             397
2443577 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   395                                             395
2769202 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   394                                             394
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 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 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
2769233 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   380                                             380
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
2769292 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   373                                             373
2444002 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   372                                             372
2443335 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   370                                             370
2443243 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   366                                             366
2770179 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2020   grade_7                                                   366                                             366
2769192 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   363                                             363
2769661 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   357                                             357
2444227 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   356                                             356
2443273 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   354                                             354
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
2769324 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   348                                             348
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
2444333 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   345                                             345
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
2769628 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   340                                             340
2769759 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   339                                             339
2770091 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   338                                             338
2443353 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   337                                             337
2443810 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   337                                             337
2443679 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   336                                             336
2770180 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   336                                             336
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
2769144 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   333                                             333
2769977 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   333                                             333
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
2443711 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   330                                             330
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
2443366 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   329                                             329
2444139 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   327                                             327
2769191 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   326                                             326
2443354 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   324                                             324
2443794 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   323                                             323
2769651 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   323                                             323
2769743 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   323                                             323
2443232 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   321                                             321
2444281 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   320                                             320
2769966 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   320                                             320
2769581 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   319                                             319
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
2444224 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   315                                             315
2444024 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   314                                             314
2443185 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   313                                             313
2770287 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   312                                             312
2770186 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   307                                             307
2444150 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   306                                             306
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
2770057 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   306                                             306
2443632 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   305                                             305
2443233 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   303                                             303
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 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 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
2444012 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   300                                             300
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 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
2444280 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   298                                             298
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 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 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 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
2770235 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   295                                             295
2770281 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   294                                             294
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
2770234 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   291                                             291
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
2444107 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   286                                             286
2444231 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   286                                             286
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
2770029 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   284                                             284
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 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
2768998 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   283                                             283
2769355 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   283                                             283
2444317 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   282                                             282
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 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 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 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 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
2769554 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   279                                             279
2443703 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   278                                             278