schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, district, school_nces_id, school_state_id, school, school_state_type, ccd_school_type, ccd_charter_school, ccd_school_lvl, ccd_school_low_grade, ccd_school_high_grade, year, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "grade" = :p0 and "state" = :p1 and "year" = :p2 and (school_nces_id > :p4 or (school_nces_id = :p4 and rowid > :p3)) order by school_nces_id, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2448857	CT	school	900420	140011	Branford School District	90042000043	141511	Mary R. Tisko School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448855	CT	school		140011	Branford School District	90042000177	148011	Indian Neck School	Program						2019	grade_11	0	0
2448856	CT	school	900420	140011	Branford School District	90042001119	141611	John B. Sliney School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448861	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2019	grade_11	10	10
2448879	CT	school	900450	150011	Bridgeport School District	90045000001	151011	Luis Munoz Marin School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448864	CT	school	900450	150011	Bridgeport School District	90045000049	150111	Barnum School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448894	CT	school	900450	150011	Bridgeport School District	90045000050	156111	Bassick High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	174	174
2448865	CT	school	900450	150011	Bridgeport School District	90045000051	150211	Beardsley School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2448866	CT	school	900450	150011	Bridgeport School District	90045000052	150311	Black Rock School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448867	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448868	CT	school	900450	150011	Bridgeport School District	90045000054	150411	Bryant School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2448897	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	397	397
2448871	CT	school	900450	150011	Bridgeport School District	90045000058	150511	Columbus School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448885	CT	school	900450	150011	Bridgeport School District	90045000059	153911	Wilbur Cross School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448888	CT	school	900450	150011	Bridgeport School District	90045000060	150711	Edison School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448889	CT	school	900450	150011	Bridgeport School District	90045000065	151111	Hall School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448874	CT	school	900450	150011	Bridgeport School District	90045000066	151211	Hallen School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2448899	CT	school	900450	150011	Bridgeport School District	90045000067	156311	Warren Harding High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	240	240
2448886	CT	school	900450	150011	Bridgeport School District	90045000069	151311	Thomas Hooker School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448869	CT	school	900450	150011	Bridgeport School District	90045000070	151411	Cesar Batalla School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448880	CT	school	900450	150011	Bridgeport School District	90045000071	151711	Park City Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448891	CT	school	900450	150011	Bridgeport School District	90045000074	152011	Madison School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448870	CT	school	900450	150011	Bridgeport School District	90045000075	152111	Classical Studies Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448877	CT	school	900450	150011	Bridgeport School District	90045000076	152211	Jettie S. Tisdale School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448882	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448883	CT	school	900450	150011	Bridgeport School District	90045000081	152611	Roosevelt School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448863	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11	0	0
2448884	CT	school	900450	150011	Bridgeport School District	90045000086	153011	Waltersville School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448873	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448878	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448892	CT	school	900450	150011	Bridgeport School District	90045001127	154611	Multicultural Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448881	CT	school	900450	150011	Bridgeport School District	90045001161	154111	Paul Laurence Dunbar School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448890	CT	school	900450	150011	Bridgeport School District	90045001162	154211	James J. Curiale School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448875	CT	school	900450	150011	Bridgeport School District	90045001163	154511	High Horizons Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448887	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_11	0	0
2448876	CT	school	900450	150011	Bridgeport School District	90045001590	153711	Interdistrict Discovery Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448896	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2019	grade_11	67	67
2448898	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_11	93	93
2448895	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_11	103	103
2448893	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_11	84	84
2448872	CT	school	900450	150011	Bridgeport School District	90045001918	153111	Geraldine Claytor Magnet Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448921	CT	school	900510	170011	Bristol School District	90051000089	175111	Chippens Hill Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448930	CT	school	900510	170011	Bristol School District	90051000092	176111	Bristol Central High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	275	275
2448931	CT	school	900510	170011	Bristol School District	90051000093	176211	Bristol Eastern High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	254	254
2448908	CT	school	900510	170011	Bristol School District	90051000096	170311	Edgewood School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2448903	CT	school	900510	170011	Bristol School District	90051000097	171411	Ellen P. Hubbell School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448904	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2448905	CT	school	900510	170011	Bristol School District	90051000099	171911	Ivy Drive School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448906	CT	school	900510	170011	Bristol School District	90051000103	171711	Mountain View School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448927	CT	school	900510	170011	Bristol School District	90051000104	175211	Northeast Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448907	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448912	CT	school	900510	170011	Bristol School District	90051000106	171211	Stafford School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2448919	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2019	grade_11	*
2448934	CT	school		170011	Bristol School District	90051001515	179211	Community/Vocational Program	Program						2019	grade_11	0	0
2448913	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448915	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2019	grade_11	0	0
2448926	CT	school		170011	Bristol School District	90051001651	172711	Northeast MS/Extended Resource	Program						2019	grade_11	0	0
2448928	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2019	grade_11	0	0
2448916	CT	school		170011	Bristol School District	90051001688	172611	Ivy Drive GOAL	Program						2019	grade_11	0	0
2448914	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2019	grade_11	0	0
2448911	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	grade_11	0	0
2448920	CT	school		170011	Bristol School District	90051001711	173111	South Side GOAL	Program						2019	grade_11	0	0
2448909	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2019	grade_11	0	0
2448901	CT	school		170011	Bristol School District	90051001728	172911	BECC Autism	Program						2019	grade_11	0	0
2448932	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2019	grade_11	*
2448922	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2019	grade_11	0	0
2448925	CT	school		170011	Bristol School District	90051001753	173411	Chms Goal	Program						2019	grade_11	0	0
2448910	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	grade_11	0	0
2448902	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_11	0	0
2448929	CT	school		170011	Bristol School District	90051001796	172811	Northeast MS/GOAL	Program						2019	grade_11	0	0
2448938	CT	school	900540	180011	Brookfield School District	90054000109	186111	Brookfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	208	208
2448935	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2019	grade_11	0	0
2448937	CT	school	900540	180011	Brookfield School District	90054000112	185311	Whisconier Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2448936	CT	school	900540	180011	Brookfield School District	90054001186	180411	Huckleberry Hill Elementary School	Public Schools	Regular School	No	Elementary	02	04	2019	grade_11	0	0
2448939	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448940	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2450176	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448942	CT	school	900660	220011	Canterbury School District	90066001187	225111	Dr. Helen Baldwin Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2448941	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448946	CT	school	900690	230011	Canton School District	90069000118	236111	Canton High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	112	112
2448944	CT	school	900690	230011	Canton School District	90069000119	230311	Canton Intermediate School	Public Schools	Regular School	No	Middle	04	06	2019	grade_11	0	0
2448943	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_11	0	0
2448945	CT	school	900690	230011	Canton School District	90069001376	235111	Canton Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_11	0	0
2448947	CT	school		230011	Canton School District	90069001695	230411	Canton Academy	Program						2019	grade_11	*
2448951	CT	school	900700	2410014	Capitol Region Education Council	90070000072	2410114	Glastonbury/East Hartford Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448953	CT	school	900700	2410014	Capitol Region Education Council	90070000210	2413114	Montessori Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2448967	CT	school	900700	2410014	Capitol Region Education Council	90070000880	2416114	Metropolitan Learning Center for Global and International Studies	Regional Education Service Center Schools	Regular School	No	High	06	12	2019	grade_11	81	81
2448961	CT	school		2410014	Capitol Region Education Council	90070001154	2419014	John J. Allison Polaris Center	Program						2019	grade_11	10	10
2448958	CT	school	900700	2410014	Capitol Region Education Council	90070001357	2410214	University of Hartford Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448968	CT	school	900700	2410014	Capitol Region Education Council	90070001364	2415014	Two Rivers Magnet Middle School	Regional Education Service Center Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448963	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2019	grade_11	*
2448957	CT	school		2410014	Capitol Region Education Council	90070001492	2419114	Soundbridge	Program						2019	grade_11	0	0
2448962	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2019	grade_11	11	11
2448971	CT	school	900700	2410014	Capitol Region Education Council	90070001497	2416414	Greater Hartford Academy of the Arts High School - Full Day	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_11	113	113
2448959	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2019	grade_11	*
2448952	CT	school	900700	2410014	Capitol Region Education Council	90070001511	2410414	International Magnet School for Global Citizenship	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448964	CT	school	900700	2410014	Capitol Region Education Council	90070001513	2415114	Academy of Aerospace and Engineering	Regional Education Service Center Schools	Regular School	No	High	06	12	2019	grade_11	112	112
2448955	CT	school	900700	2410014	Capitol Region Education Council	90070001516	2410314	Reggio Magnet School of the Arts	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448970	CT	school	900700	2410014	Capitol Region Education Council	90070001532	2415214	Civic Leadership High School	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_11	79	79
2448965	CT	school	900700	2410014	Capitol Region Education Council	90070001592	2416514	Academy of Science and Innovation	Regional Education Service Center Schools	Regular School	No	High	06	12	2019	grade_11	130	130
2448950	CT	school	900700	2410014	Capitol Region Education Council	90070001597	2418114	Discovery Academy	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0