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 "state" = :p0 and (school_state_type > :p2 or (school_state_type = :p2 and rowid > :p1)) order by school_state_type, 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2435754	CT	school		2190012	Regional School District 19		2190212	PM Panthers						2019	grade_1	0	0
2435756	CT	school	900031	2820013	Stamford Academy District	90003101405	2826013	Stamford Academy	Regular School	Yes	High	09	12	2019	grade_1	0	0
2435775	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West						2019	grade_2	0	0
2435809	CT	school	900330	110011	Bloomfield School District	90033001619	116411	Learning Academy at Bloomfield	Alternative School	No	High	09	12	2019	grade_2	0	0
2435919	CT	school		2410014	Capitol Region Education Council		2411714	Soundbridge@Mountain View Elementary School						2019	grade_2	*
2435928	CT	school		2410014	Capitol Region Education Council		2411514	Soundbridge @ Chippens Hill MS Bristol						2019	grade_2	0	0
2435931	CT	school		2410014	Capitol Region Education Council		2419414	IPM @ Plainville High School						2019	grade_2	0	0
2435932	CT	school		2410014	Capitol Region Education Council		2419614	Lincoln Academy Regional Interdistrict Collaborative						2019	grade_2	0	0
2435946	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School	Regular School	No	Elementary	04	05	2019	grade_2	0	0
2435953	CT	school		280011	Colchester School District		280611	School Resilience Program						2019	grade_2	0	0
2436063	CT	school		2420014	EdAdvance		2420214	Torrington Alternative Program						2019	grade_2	0	0
2436167	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School	Regular School	No	Middle	06	08	2019	grade_2	0	0
2436168	CT	school	901770	590011	Groton School District	90177000326	595211	West Side Middle School	Regular School	No	Middle	06	08	2019	grade_2	0	0
2436219	CT	school		640011	Hartford School District		640310	Pre-K Integrated - Burr School						2019	grade_2	0	0
2436240	CT	school		640011	Hartford School District		649811	iGOAL 1 - Moylan School						2019	grade_2	0	0
2436242	CT	school		640011	Hartford School District		645911	RISE - M.D. Fox School						2019	grade_2	0	0
2436250	CT	school		640011	Hartford School District		648911	iGOAL 1 - McDonough Middle School						2019	grade_2	0	0
2436255	CT	school	901920	640011	Hartford School District	90192001574	647211	HPHS Engineering and Green Technology Academy	Regular School	No	High	09	12	2019	grade_2	0	0
2436256	CT	school	901920	640011	Hartford School District	90192001576	647411	HPHS Law and Government Academy	Regular School	No	High	09	12	2019	grade_2	0	0
2436257	CT	school	901920	640011	Hartford School District	90192001559	647511	HPHS Nursing and Health Sciences Academy	Regular School	No	High	09	12	2019	grade_2	0	0
2436258	CT	school	901920	640011	Hartford School District	90192001552	647611	High School, Inc.	Regular School	No	High	09	12	2019	grade_2	0	0
2436259	CT	school	901920	640011	Hartford School District	90192001562	647711	Journalism and Media Academy	Regular School	No	High	09	12	2019	grade_2	0	0
2436265	CT	school		640011	Hartford School District		645011	iGOAL 2 - Weaver High School						2019	grade_2	0	0
2436266	CT	school	901920	640011	Hartford School District	90192001522	646011	Culinary Arts Academy at Weaver High School	Regular School	No	High	11	12	2019	grade_2	0	0
2436267	CT	school	901920	640011	Hartford School District	90192001650	643911	Capital Community College Magnet Academy	Regular School	No	High	12	12	2019	grade_2	0	0
2436288	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program						2019	grade_2	0	0
2436289	CT	school	903450	2450014	Learn	90345001556	2455014	Dual Language & Arts Magnet Middle School	Regular School	No	Middle	06	08	2019	grade_2	0	0
2436290	CT	school		2450014	Learn		2451214	Learn ABA Program at Center School						2019	grade_2	0	0
2436291	CT	school		2450014	Learn		2450514	Learn Pathways Program						2019	grade_2	0	0
2436302	CT	school	902160	720011	Ledyard School District	90216000400	720111	Ledyard Center School	Regular School	No	Elementary	KG	06	2019	grade_2	56	56
2436313	CT	school	902280	760011	Madison School District	90228000414	760211	Island Avenue Elementary School	Regular School	No	Elementary	KG	04	2019	grade_2	48	48
2436323	CT	school	902310	770011	Manchester School District	90231000431	771411	Washington School	Regular School	No	Elementary	KG	04	2019	grade_2	41	41
2436329	CT	school		770011	Manchester School District		771111	Elementary Site 2						2019	grade_2	0	0
2436356	CT	school		800011	Meriden School District		802311	SOAR - LMS						2019	grade_2	0	0
2436498	CT	school		930011	New Haven School District		938011	Lulac						2019	grade_2	0	0
2436707	CT	school	903539	2170012	Regional School District 17	90353900758	2170112	Haddam Elementary School	Regular School	No	Elementary	KG	04	2019	grade_2	32	32
2436811	CT	school		1340011	Stafford School District		1340211	Stafford Tutoring Program						2019	grade_2	0	0
2436839	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School	Special Education School	No	Prekindergarten	PK	PK	2019	grade_2	0	0
2436840	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK	Special Education School	No	Prekindergarten	PK	PK	2019	grade_2	0	0
2436843	CT	school	904380	1370011	Stonington School District	90438000882	1370411	West Broad Street School	Regular School	No	Elementary	03	04	2019	grade_2	0	0
2436844	CT	school	904380	1370011	Stonington School District	90438000879	1375111	Pawcatuck Middle School	Regular School	No	Middle	05	08	2019	grade_2	0	0
2436887	CT	school		1430011	Torrington School District		1432211	East TPS - PreK - Reg Ed						2019	grade_2	0	0
2436917	CT	school		1460011	Vernon School District		1460911	First Step						2019	grade_2	*
2436935	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy						2019	grade_2	0	0
2436939	CT	school		1480011	Wallingford School District		1480511	Education Enhancement Program						2019	grade_2	0	0
2436974	CT	school		1510011	Waterbury School District		1510411	B.W. Tinker BDLC						2019	grade_2	*
2436980	CT	school		1510011	Waterbury School District		1516811	Duggan Scope						2019	grade_2	0	0
2437017	CT	school		1530011	Watertown School District		1530711	Watertown Transition Program at Post University						2019	grade_2	0	0
2437049	CT	school		1560011	West Haven School District		1561111	ASD Lab						2019	grade_2	0	0
2437105	CT	school	905190	1630011	Windham School District	90519001920	1631311	Windham STEPS Academy	Alternative School	No	High	09	12	2019	grade_2	0	0
2437147	CT	school	900023	2780013	Trailblazers Academy District	90002300965	2785113	Trailblazers Academy	Regular School	Yes	Middle	06	08	2019	grade_2	0	0
2437203	CT	school		2190012	Regional School District 19		2190212	PM Panthers						2019	grade_2	0	0
2437205	CT	school	900031	2820013	Stamford Academy District	90003101405	2826013	Stamford Academy	Regular School	Yes	High	09	12	2019	grade_2	0	0
2437224	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West						2019	grade_3	0	0
2437258	CT	school	900330	110011	Bloomfield School District	90033001619	116411	Learning Academy at Bloomfield	Alternative School	No	High	09	12	2019	grade_3	0	0
2437368	CT	school		2410014	Capitol Region Education Council		2411714	Soundbridge@Mountain View Elementary School						2019	grade_3	*
2437377	CT	school		2410014	Capitol Region Education Council		2411514	Soundbridge @ Chippens Hill MS Bristol						2019	grade_3	0	0
2437380	CT	school		2410014	Capitol Region Education Council		2419414	IPM @ Plainville High School						2019	grade_3	0	0
2437381	CT	school		2410014	Capitol Region Education Council		2419614	Lincoln Academy Regional Interdistrict Collaborative						2019	grade_3	0	0
2437395	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School	Regular School	No	Elementary	04	05	2019	grade_3	0	0
2437402	CT	school		280011	Colchester School District		280611	School Resilience Program						2019	grade_3	0	0
2437512	CT	school		2420014	EdAdvance		2420214	Torrington Alternative Program						2019	grade_3	0	0
2437616	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School	Regular School	No	Middle	06	08	2019	grade_3	0	0
2437617	CT	school	901770	590011	Groton School District	90177000326	595211	West Side Middle School	Regular School	No	Middle	06	08	2019	grade_3	0	0
2437668	CT	school		640011	Hartford School District		640310	Pre-K Integrated - Burr School						2019	grade_3	0	0
2437689	CT	school		640011	Hartford School District		649811	iGOAL 1 - Moylan School						2019	grade_3	*
2437691	CT	school		640011	Hartford School District		645911	RISE - M.D. Fox School						2019	grade_3	0	0
2437699	CT	school		640011	Hartford School District		648911	iGOAL 1 - McDonough Middle School						2019	grade_3	0	0
2437704	CT	school	901920	640011	Hartford School District	90192001574	647211	HPHS Engineering and Green Technology Academy	Regular School	No	High	09	12	2019	grade_3	0	0
2437705	CT	school	901920	640011	Hartford School District	90192001576	647411	HPHS Law and Government Academy	Regular School	No	High	09	12	2019	grade_3	0	0
2437706	CT	school	901920	640011	Hartford School District	90192001559	647511	HPHS Nursing and Health Sciences Academy	Regular School	No	High	09	12	2019	grade_3	0	0
2437707	CT	school	901920	640011	Hartford School District	90192001552	647611	High School, Inc.	Regular School	No	High	09	12	2019	grade_3	0	0
2437708	CT	school	901920	640011	Hartford School District	90192001562	647711	Journalism and Media Academy	Regular School	No	High	09	12	2019	grade_3	0	0
2437714	CT	school		640011	Hartford School District		645011	iGOAL 2 - Weaver High School						2019	grade_3	0	0
2437715	CT	school	901920	640011	Hartford School District	90192001522	646011	Culinary Arts Academy at Weaver High School	Regular School	No	High	11	12	2019	grade_3	0	0
2437716	CT	school	901920	640011	Hartford School District	90192001650	643911	Capital Community College Magnet Academy	Regular School	No	High	12	12	2019	grade_3	0	0
2437737	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program						2019	grade_3	0	0
2437738	CT	school	903450	2450014	Learn	90345001556	2455014	Dual Language & Arts Magnet Middle School	Regular School	No	Middle	06	08	2019	grade_3	0	0
2437739	CT	school		2450014	Learn		2451214	Learn ABA Program at Center School						2019	grade_3	0	0
2437740	CT	school		2450014	Learn		2450514	Learn Pathways Program						2019	grade_3	0	0
2437751	CT	school	902160	720011	Ledyard School District	90216000400	720111	Ledyard Center School	Regular School	No	Elementary	KG	06	2019	grade_3	53	53
2437762	CT	school	902280	760011	Madison School District	90228000414	760211	Island Avenue Elementary School	Regular School	No	Elementary	KG	04	2019	grade_3	57	57
2437772	CT	school	902310	770011	Manchester School District	90231000431	771411	Washington School	Regular School	No	Elementary	KG	04	2019	grade_3	61	61
2437778	CT	school		770011	Manchester School District		771111	Elementary Site 2						2019	grade_3	*
2437805	CT	school		800011	Meriden School District		802311	SOAR - LMS						2019	grade_3	0	0
2437947	CT	school		930011	New Haven School District		938011	Lulac						2019	grade_3	0	0
2438156	CT	school	903539	2170012	Regional School District 17	90353900758	2170112	Haddam Elementary School	Regular School	No	Elementary	KG	04	2019	grade_3	32	32
2438260	CT	school		1340011	Stafford School District		1340211	Stafford Tutoring Program						2019	grade_3	0	0
2438288	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School	Special Education School	No	Prekindergarten	PK	PK	2019	grade_3	0	0
2438289	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK	Special Education School	No	Prekindergarten	PK	PK	2019	grade_3	0	0
2438292	CT	school	904380	1370011	Stonington School District	90438000882	1370411	West Broad Street School	Regular School	No	Elementary	03	04	2019	grade_3	53	53
2438293	CT	school	904380	1370011	Stonington School District	90438000879	1375111	Pawcatuck Middle School	Regular School	No	Middle	05	08	2019	grade_3	0	0
2438336	CT	school		1430011	Torrington School District		1432211	East TPS - PreK - Reg Ed						2019	grade_3	0	0
2438366	CT	school		1460011	Vernon School District		1460911	First Step						2019	grade_3	*
2438384	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy						2019	grade_3	0	0
2438388	CT	school		1480011	Wallingford School District		1480511	Education Enhancement Program						2019	grade_3	0	0
2438423	CT	school		1510011	Waterbury School District		1510411	B.W. Tinker BDLC						2019	grade_3	0	0
2438429	CT	school		1510011	Waterbury School District		1516811	Duggan Scope						2019	grade_3	0	0
2438466	CT	school		1530011	Watertown School District		1530711	Watertown Transition Program at Post University						2019	grade_3	0	0
2438498	CT	school		1560011	West Haven School District		1561111	ASD Lab						2019	grade_3	0	0
2438554	CT	school	905190	1630011	Windham School District	90519001920	1631311	Windham STEPS Academy	Alternative School	No	High	09	12	2019	grade_3	0	0