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
2451697 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2019   grade_12                                                   *                                              
2450249 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450250 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2019   grade_12                                                   0                                             0
2450251 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450252 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_12                                                   0                                             0
2450253 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   grade_12                                                   0                                             0
2450257 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   grade_12                                                   0                                             0
2450258 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2019   grade_12                                                   0                                             0
2450259 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2019   grade_12                                                   0                                             0
2450260 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   grade_12                                                   0                                             0
2450261 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2450267 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450268 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_12                                                   0                                             0
2450269 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2450270 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2450271 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_12                                                   0                                             0
2450272 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_12                                                   0                                             0
2450274 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450275 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   grade_12                                                   0                                             0
2450276 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   grade_12                                                   0                                             0
2450277 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450278 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450279 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2019   grade_12                                                   0                                             0
2450280 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2450283 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450284 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2019   grade_12                                                   0                                             0
2450285 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2019   grade_12                                                   0                                             0
2450286 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2019   grade_12                                                   0                                             0
2450287 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2450291 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   grade_12                                                   0                                             0
2450292 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2019   grade_12                                                   0                                             0
2450293 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2019   grade_12                                                   0                                             0
2450294 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   grade_12                                                   0                                             0
2450295 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_12                                                   0                                             0
2450297 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   grade_12                                                   0                                             0
2450300 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450303 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450304 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2019   grade_12                                                   0                                             0
2450305 CT     school 900420 140011   Branford School District 90042001119 141611 John B. Sliney School Public Schools Regular School No Elementary PK 04 2019   grade_12                                                   0                                             0
2450306 CT     school 900420 140011   Branford School District 90042000043 141511 Mary R. Tisko School Public Schools Regular School No Elementary PK 04 2019   grade_12                                                   0                                             0
2450307 CT     school 900420 140011   Branford School District 90042000042 141411 Mary T. Murphy School Public Schools Regular School No Elementary PK 04 2019   grade_12                                                   0                                             0
2450308 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   grade_12                                                   0                                             0
2450311 CT     school 900215 2900013   Brass City Charter School District 90021501644 2900113 Brass City Charter School Public Charter Schools Regular School Yes Elementary PK 06 2019   grade_12                                                   0                                             0
2450312 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_12                                                   0                                             0
2450313 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450314 CT     school 900450 150011   Bridgeport School District 90045000051 150211 Beardsley School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450315 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450316 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450317 CT     school 900450 150011   Bridgeport School District 90045000054 150411 Bryant School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450318 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450319 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450320 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450321 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450322 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450323 CT     school 900450 150011   Bridgeport School District 90045000066 151211 Hallen School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2450324 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450325 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450326 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450327 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450328 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450329 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450330 CT     school 900450 150011   Bridgeport School District 90045001161 154111 Paul Laurence Dunbar School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450331 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450332 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450333 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450334 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450335 CT     school 900450 150011   Bridgeport School District 90045000069 151311 Thomas Hooker School Public Schools Regular School No Elementary KG 08 2019   grade_12                                                   0                                             0
2450337 CT     school 900450 150011   Bridgeport School District 90045000060 150711 Edison School Public Schools Regular School No Elementary KG 06 2019   grade_12                                                   0                                             0
2450338 CT     school 900450 150011   Bridgeport School District 90045000065 151111 Hall School Public Schools Regular School No Elementary KG 06 2019   grade_12                                                   0                                             0
2450339 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2019   grade_12                                                   0                                             0
2450340 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2019   grade_12                                                   0                                             0
2450341 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2019   grade_12                                                   0                                             0
2450350 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2019   grade_12                                                   0                                             0
2450351 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2019   grade_12                                                   0                                             0
2450352 CT     school 900510 170011   Bristol School District 90051000097 171411 Ellen P. Hubbell School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450353 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2450354 CT     school 900510 170011   Bristol School District 90051000099 171911 Ivy Drive School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450355 CT     school 900510 170011   Bristol School District 90051000103 171711 Mountain View School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450356 CT     school 900510 170011   Bristol School District 90051000105 171111 South Side School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2450357 CT     school 900510 170011   Bristol School District 90051000096 170311 Edgewood School Public Schools Regular School No Elementary KG 05 2019   grade_12                                                   0                                             0
2450358 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2019   grade_12                                                   0                                             0
2450359 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2019   grade_12                                                   0                                             0
2450360 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2019   grade_12                                                   0                                             0
2450361 CT     school 900510 170011   Bristol School District 90051000106 171211 Stafford School Public Schools Regular School No Elementary KG 05 2019   grade_12                                                   0                                             0
2450362 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2019   grade_12                                                   0                                             0
2450363 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2019   grade_12                                                   0                                             0
2450364 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2019   grade_12                                                   0                                             0
2450365 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2019   grade_12                                                   0                                             0
2450366 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2019   grade_12                                                   0                                             0
2450367 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2019   grade_12                                                   0                                             0
2450369 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2019   grade_12                                                   0                                             0
2450370 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2450371 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2019   grade_12                                                   0                                             0
2450372 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2019   grade_12                                                   0                                             0
2450373 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2019   grade_12                                                   0                                             0
2450374 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2019   grade_12                                                   0                                             0
2450375 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2019   grade_12                                                   0                                             0
2450376 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2450377 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2019   grade_12                                                   0                                             0
2450378 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2019   grade_12                                                   0                                             0
2450384 CT     school 900540 180011   Brookfield School District 90054000110 180311 Center Elementary School Public Schools Regular School No Elementary PK 01 2019   grade_12                                                   0                                             0