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
2435272 CT     school 903810 1180011   Ridgefield School District 90381000780 1180511 Scotland Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   *                                              
2435276 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2019   grade_1                                                   *                                              
2435298 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   *                                              
2435300 CT     school 904050 1260011   Shelton School District 90405000803 1260811 Long Hill School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   *                                              
2435302 CT     school 904050 1260011   Shelton School District 90405000003 1260611 Sunnyside School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   *                                              
2435303 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2019   grade_1                                                   *                                              
2435306 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   grade_1                                                   *                                              
2435336 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   *                                              
2435340 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2019   grade_1                                                   *                                              
2435402 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2019   grade_1                                                   *                                              
2435407 CT     school   1380011   Stratford School District   1382811 STEPS K-6 Program           2019   grade_1                                                   *                                              
2435461 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   grade_1                                                   *                                              
2435466 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2019   grade_1                                                   *                                              
2435468 CT     school   1460011   Vernon School District   1460911 First Step             2019   grade_1                                                   *                                              
2435469 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   grade_1                                                   *                                              
2435479 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   grade_1                                                   *                                              
2435515 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   grade_1                                                   *                                              
2435525 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   grade_1                                                   *                                              
2435526 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   grade_1                                                   *                                              
2435527 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   grade_1                                                   *                                              
2435528 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   grade_1                                                   *                                              
2435555 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2019   grade_1                                                   *                                              
2435577 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2019   grade_1                                                   *                                              
2435581 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2019   grade_1                                                   *                                              
2435583 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2019   grade_1                                                   *                                              
2435617 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2019   grade_1                                                   *                                              
2435622 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2019   grade_1                                                   *                                              
2435627 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2019   grade_1                                                   *                                              
2435631 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_1                                                   *                                              
2435650 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2019   grade_1                                                   *                                              
2435673 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2019   grade_1                                                   *                                              
2435686 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2019   grade_1                                                   *                                              
2434311 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2019   grade_1                                                   0                                             0
2434314 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   grade_1                                                   0                                             0
2434315 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434316 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2019   grade_1                                                   0                                             0
2434317 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   grade_1                                                   0                                             0
2434321 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   grade_1                                                   0                                             0
2434322 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_1                                                   0                                             0
2434323 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2019   grade_1                                                   0                                             0
2434324 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2019   grade_1                                                   0                                             0
2434325 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2019   grade_1                                                   0                                             0
2434326 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   grade_1                                                   0                                             0
2434327 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2019   grade_1                                                   0                                             0
2434329 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_1                                                   0                                             0
2434332 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_1                                                   0                                             0
2434333 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_1                                                   0                                             0
2434334 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434336 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   grade_1                                                   0                                             0
2434337 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   grade_1                                                   0                                             0
2434341 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2434342 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434343 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   grade_1                                                   0                                             0
2434347 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2019   grade_1                                                   0                                             0
2434348 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2434349 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434350 CT     school   90011   Bethel School District   90311 TASK Program           2019   grade_1                                                   0                                             0
2434351 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   grade_1                                                   0                                             0
2434352 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   grade_1                                                   0                                             0
2434355 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   grade_1                                                   0                                             0
2434356 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_1                                                   0                                             0
2434357 CT     school 900330 110011   Bloomfield School District 90033001615 116311 Global Experience Magnet School Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2434358 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   grade_1                                                   0                                             0
2434359 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434360 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 09 12 2019   grade_1                                                   0                                             0
2434362 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434363 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2019   grade_1                                                   0                                             0
2434365 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2019   grade_1                                                   0                                             0
2434369 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   grade_1                                                   0                                             0
2434370 CT     school 900420 140011   Branford School District 90042000039 146111 Branford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434371 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2019   grade_1                                                   0                                             0
2434373 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_1                                                   0                                             0
2434403 CT     school 900450 150011   Bridgeport School District 90045001639 150811 Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434404 CT     school 900450 150011   Bridgeport School District 90045000050 156111 Bassick High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434405 CT     school 900450 150011   Bridgeport School District 90045001636 150611 Biotechnology, Research & Zoological Studies Magnet High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434406 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434407 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434408 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434409 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434410 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2019   grade_1                                                   0                                             0
2434411 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2019   grade_1                                                   0                                             0
2434412 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_1                                                   0                                             0
2434425 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2019   grade_1                                                   0                                             0
2434426 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2019   grade_1                                                   0                                             0
2434427 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2019   grade_1                                                   0                                             0
2434428 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2019   grade_1                                                   0                                             0
2434429 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2019   grade_1                                                   0                                             0
2434430 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2019   grade_1                                                   0                                             0
2434431 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2434432 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2019   grade_1                                                   0                                             0
2434433 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2019   grade_1                                                   0                                             0
2434434 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2019   grade_1                                                   0                                             0
2434435 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2019   grade_1                                                   0                                             0
2434436 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2019   grade_1                                                   0                                             0
2434437 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2434438 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2019   grade_1                                                   0                                             0
2434439 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2019   grade_1                                                   0                                             0
2434440 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434441 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434442 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2019   grade_1                                                   0                                             0
2434443 CT     school   170011   Bristol School District   170211 ACCESS Program           2019   grade_1                                                   0                                             0