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
2756745 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2021   grade_12                                                   0                                             0
2756746 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2021   grade_12                                                   0                                             0
2756747 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   grade_12                                                   0                                             0
2756748 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   206                                             206
2756749 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756750 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756751 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756752 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   grade_12                                                   56                                             56
2756754 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 02 2021   grade_12                                                   0                                             0
2756755 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2021   grade_12                                                   0                                             0
2756756 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Elementary 03 05 2021   grade_12                                                   0                                             0
2756757 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756758 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 08 12 2021   grade_12                                                   132                                             132
2756760 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756761 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756762 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756763 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   171                                             171
2756764 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756765 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756766 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756767 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756768 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756769 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756770 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   290                                             290
2756772 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756773 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756774 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756775 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   168                                             168
2756777 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary PK 03 2021   grade_12                                                   0                                             0
2756778 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary KG 03 2021   grade_12                                                   0                                             0
2756779 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2021   grade_12                                                   0                                             0
2756780 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756781 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   176                                             176
2756782 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756783 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756784 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756785 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756786 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   117                                             117
2757225 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   81                                             81
2757231 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
2757232 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   139                                             139
2757234 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
2757235 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
2757236 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   367                                             367
2757239 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
2757242 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   169                                             169
2757245 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
2757246 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   247                                             247
2757247 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2021   grade_12                                                   32                                             32
2757283 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   209                                             209
2757284 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2021   grade_12                                                   265                                             265
2777168 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2020   grade_12                                                   0                                             0
2777169 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2020   grade_12                                                   0                                             0
2777170 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2020   grade_12                                                   0                                             0
2777171 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   grade_12                                                   108                                             108
2777173 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2020   grade_12                                                   0                                             0
2777174 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2020   grade_12                                                   0                                             0
2777175 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   grade_12                                                   0                                             0
2777176 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   167                                             167
2777177 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777178 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777179 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777180 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   grade_12                                                   76                                             76
2777182 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2020   grade_12                                                   0                                             0
2777183 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2020   grade_12                                                   0                                             0
2777184 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2020   grade_12                                                   0                                             0
2777185 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 05 08 2020   grade_12                                                   0                                             0
2777186 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   126                                             126
2777188 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777189 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777190 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777191 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   145                                             145
2777193 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777194 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777195 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777196 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777197 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777198 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777199 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   333                                             333
2777201 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777202 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777203 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777205 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   181                                             181
2777206 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 03 2020   grade_12                                                   0                                             0
2777207 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 03 2020   grade_12                                                   0                                             0
2777208 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2020   grade_12                                                   0                                             0
2777209 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777210 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   158                                             158
2777212 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2777213 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777214 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
2777215 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777216 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   127                                             127
2777657 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   96                                             96
2777663 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2020   grade_12                                                   0                                             0
2777664 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   150                                             150
2777666 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2020   grade_12                                                   0                                             0
2777667 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2020   grade_12                                                   0                                             0
2777668 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   374                                             374
2777671 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2020   grade_12                                                   0                                             0
2777674 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   147                                             147