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
2753735 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753736 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753737 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753738 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753739 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2021   grade_10                                                   0                                             0
2753740 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2021   grade_10                                                   321                                             321
2774129 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2020   grade_10                                                   0                                             0
2774130 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2020   grade_10                                                   0                                             0
2774131 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2020   grade_10                                                   0                                             0
2774132 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2020   grade_10                                                   0                                             0
2774133 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2020   grade_10                                                   0                                             0
2774134 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2020   grade_10                                                   0                                             0
2774135 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2020   grade_10                                                   322                                             322
2448069 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448070 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448071 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448072 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448073 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2019   grade_10                                                   0                                             0
2448074 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448075 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448076 CT     school 902790 930011   New Haven School District 90279001484 934811 Celentano BioTech, Health and Medical Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448077 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448078 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448079 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448080 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2019   grade_10                                                   0                                             0
2448081 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448082 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   grade_10                                                   0                                             0
2448083 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448084 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448085 CT     school 902790 930011   New Haven School District 90279001443 931311 John C. Daniels Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448086 CT     school 902790 930011   New Haven School District 90279001386 930811 John S. Martinez Sea and Sky STEM School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448087 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448088 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2019   grade_10                                                   0                                             0
2448089 CT     school 902790 930011   New Haven School District 90279000566 932011 Lincoln-Bassett School Public Schools Regular School No Elementary PK 06 2019   grade_10                                                   0                                             0
2448090 CT     school   930011   New Haven School District   938011 Lulac             2019   grade_10                                                   0                                             0
2448091 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448092 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448093 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448094 CT     school 902790 930011   New Haven School District 90279000647 934911 West Rock Authors Academy Public Schools Regular School No Elementary PK 04 2019   grade_10                                                   0                                             0
2448095 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2019   grade_10                                                   0                                             0
2448096 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448097 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2019   grade_10                                                   0                                             0
2448098 CT     school 902790 930011   New Haven School District 90279001509 932811 Barack H. Obama Magnet University School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2448099 CT     school   930011   New Haven School District   937611 Barack H. Obama Self Contained Autism Program           2019   grade_10                                                   0                                             0
2448100 CT     school 902790 930011   New Haven School District 90279000546 934311 Bishop Woods Architecture and Design Magnet School Public Schools Regular School No Elementary KG 08 2019   grade_10                                                   0                                             0
2448101 CT     school   930011   New Haven School District   937911 Bishop Woods Self Contained Autism Program           2019   grade_10                                                   0                                             0
2448102 CT     school   930011   New Haven School District   937211 Brennan Rogers Self Contained Autism Program           2019   grade_10                                                   0                                             0
2448103 CT     school 902790 930011   New Haven School District 90279000550 930611 Clinton Avenue School Public Schools Regular School No Elementary KG 08 2019   grade_10                                                   0                                             0
2448104 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2019   grade_10                                                   0                                             0
2448105 CT     school 902790 930011   New Haven School District 90279001612 933511 Quinnipiac Real World Math STEM School Public Schools Regular School No Elementary KG 05 2019   grade_10                                                   0                                             0
2448106 CT     school 902790 930011   New Haven School District 90279001483 934211 Roberto Clemente Leadership Academy for Global Awareness Public Schools Regular School No Elementary KG 08 2019   grade_10                                                   0                                             0
2448107 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2019   grade_10                                                   0                                             0
2448108 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   grade_10                                                   0                                             0
2448109 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2019   grade_10                                                   0                                             0
2448110 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2019   grade_10                                                   0                                             0
2448111 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2019   grade_10                                                   0                                             0
2448112 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2019   grade_10                                                   0                                             0
2448113 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2019   grade_10                                                   0                                             0
2448114 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2019   grade_10                                                   0                                             0
2448115 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2019   grade_10                                                   88                                             88
2448116 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2019   grade_10                                                   162                                             162
2448117 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2019   grade_10                                                   *                                              
2448118 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2019   grade_10                                                   60                                             60
2448119 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2019   grade_10                                                   185                                             185
2448120 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2019   grade_10                                                   257                                             257
2448121 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   grade_10                                                   *                                              
2448122 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2019   grade_10                                                   118                                             118
2448123 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   grade_10                                                   89                                             89
2448124 CT     school   930011   New Haven School District 90279001550 939111 Riverside Education Academy Program           2019   grade_10                                                   34                                             34
2448125 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2019   grade_10                                                   67                                             67
2448126 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2019   grade_10                                                   433                                             433
2448127 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2019   grade_10                                                   *                                              
2448128 CT     school   930011   New Haven School District   937311 Off-Campus Classroom Program (OCC) Program           2019   grade_10                                                   0                                             0
2753660 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753661 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753662 CT     school 902790 930011   New Haven School District 90279001509 932811 Barack H. Obama Magnet University School Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753663 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753664 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753665 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2021   grade_10                                                   0                                             0
2753666 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753667 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753668 CT     school 902790 930011   New Haven School District 90279001484 934811 Celentano BioTech, Health and Medical Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753669 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753670 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753671 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753672 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2021   grade_10                                                   0                                             0
2753673 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753674 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753675 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753676 CT     school 902790 930011   New Haven School District 90279001443 931311 John C. Daniels Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753677 CT     school 902790 930011   New Haven School District 90279001386 930811 John S. Martinez Sea and Sky STEM School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753678 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753679 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2021   grade_10                                                   0                                             0
2753680 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2021   grade_10                                                   0                                             0
2753681 CT     school 902790 930011   New Haven School District 90279000566 932011 Lincoln-Bassett School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753682 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753683 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753684 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
2753685 CT     school 902790 930011   New Haven School District 90279000647 934911 West Rock Authors Academy Public Schools Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
2753686 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2021   grade_10                                                   0                                             0
2753687 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0