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 order by total_int 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
2432869	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2019	kindergarten	*
2432870	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	kindergarten	*
2432888	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2019	kindergarten	*
2432948	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	kindergarten	*
2432970	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2019	kindergarten	*
2432971	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	kindergarten	*
2432972	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	kindergarten	*
2433058	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2019	kindergarten	*
2433081	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2433155	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2019	kindergarten	*
2433181	CT	school		490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program						2019	kindergarten	*
2433288	CT	school		620011	Hamden School District		621511	Dunbar Hill IIC	Program						2019	kindergarten	*
2433289	CT	school		620011	Hamden School District		621611	Helen Street IIC	Program						2019	kindergarten	*
2433330	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2019	kindergarten	*
2433337	CT	school		640011	Hartford School District		649511	iGOAL 1 - Breakthrough Magnet School, North	Program						2019	kindergarten	*
2433338	CT	school		640011	Hartford School District		644711	iGOAL 1 - Burns School	Program						2019	kindergarten	*
2433339	CT	school		640011	Hartford School District	90192001732	645711	iGOAL 1 - M.D. Fox School	Program						2019	kindergarten	*
2433340	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2019	kindergarten	*
2433341	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2019	kindergarten	*
2433451	CT	school		800011	Meriden School District		800611	STARS - ES	Program						2019	kindergarten	*
2433455	CT	school		800011	Meriden School District		800911	STEP - ES	Program						2019	kindergarten	*
2433478	CT	school		830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program						2019	kindergarten	*
2433547	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2019	kindergarten	*
2433548	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2019	kindergarten	*
2433550	CT	school		890011	New Britain School District		891011	Lincoln SCS	Program						2019	kindergarten	*
2433592	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2019	kindergarten	*
2433609	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	kindergarten	*
2433611	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	kindergarten	*
2433612	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	kindergarten	*
2433614	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2019	kindergarten	*
2433657	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	*
2433709	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2019	kindergarten	*
2433714	CT	school		1040011	Norwich School District		1040911	Stanton Special Learning Center	Program						2019	kindergarten	*
2433716	CT	school		1040011	Norwich School District		1041211	Strive Program @ Stanton	Program						2019	kindergarten	*
2433821	CT	school	903810	1180011	Ridgefield School District	90381000525	1180611	Branchville Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2433824	CT	school	903810	1180011	Ridgefield School District	90381000781	1180211	Veterans Park Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2433825	CT	school		1180011	Ridgefield School District		1180111	District Program BMES	Program						2019	kindergarten	*
2433855	CT	school		1260011	Shelton School District		1260311	Life Skills	Program						2019	kindergarten	*
2433856	CT	school		1260011	Shelton School District		1261211	Therapeutic Learning Center	Program						2019	kindergarten	*
2433876	CT	school	904170	1320011	South Windsor School District	90417000822	1320711	Eli Terry School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2433891	CT	school		1310011	Southington School District		1312311	Language Based Classroom II	Program						2019	kindergarten	*
2433892	CT	school		1310011	Southington School District	90423001759	1311811	Language Based Classroom, Multihandicapped	Program						2019	kindergarten	*
2433953	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	kindergarten	*
2433958	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2019	kindergarten	*
2434012	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	*
2434017	CT	school		1460011	Vernon School District		1461111	Elementary Activities Based Learning Program	Program						2019	kindergarten	*
2434029	CT	school		1480011	Wallingford School District		1480711	STARS Primary Program	Program						2019	kindergarten	*
2434063	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2019	kindergarten	*
2434066	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2019	kindergarten	*
2434070	CT	school		1510011	Waterbury School District		1516911	Gilmartin Scope	Program						2019	kindergarten	*
2434104	CT	school	904860	1520011	Waterford School District	90486000998	1520611	Oswegatchie Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2434106	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2019	kindergarten	*
2434128	CT	school		1550011	West Hartford School District		1559711	Morley Learning Center	Program						2019	kindergarten	*
2434130	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2019	kindergarten	*
2434168	CT	school		1580011	Westport School District		1580211	GFS Intensive Resource	Program						2019	kindergarten	*
2434201	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2019	kindergarten	*
2434202	CT	school		1630011	Windham School District		1630911	Sweeney Medically Fragile Program	Program						2019	kindergarten	*
2434224	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	kindergarten	*
2434354	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2019	grade_1	*
2434397	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_1	*
2434419	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2019	grade_1	*
2434420	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	grade_1	*
2434421	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	grade_1	*
2434424	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2019	grade_1	*
2434470	CT	school		2410014	Capitol Region Education Council		2411714	Soundbridge@Mountain View Elementary School							2019	grade_1	*
2434510	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2019	grade_1	*
2434544	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	*
2434604	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2019	grade_1	*
2434630	CT	school		490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program						2019	grade_1	*
2434633	CT	school		490011	Enfield School District	90147001792	490311	Henry Barnard - Autism Spectrum Disorder (ASD)	Program						2019	grade_1	*
2434682	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2019	grade_1	*
2434735	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2019	grade_1	*
2434738	CT	school		620011	Hamden School District		621611	Helen Street IIC	Program						2019	grade_1	*
2434786	CT	school		640011	Hartford School District		649511	iGOAL 1 - Breakthrough Magnet School, North	Program						2019	grade_1	*
2434789	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2019	grade_1	*
2434790	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2019	grade_1	*
2434791	CT	school		640011	Hartford School District		649811	iGOAL 1 - Moylan School							2019	grade_1	*
2434836	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2019	grade_1	*
2434880	CT	school		770011	Manchester School District		771111	Elementary Site 2							2019	grade_1	*
2434896	CT	school	902400	800011	Meriden School District	90240000445	800511	John Barry School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	*
2434897	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	*
2434899	CT	school	902400	800011	Meriden School District	90240000450	800811	Roger Sherman School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	*
2434904	CT	school		800011	Meriden School District		800911	STEP - ES	Program						2019	grade_1	*
2434905	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2019	grade_1	*
2434927	CT	school		830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program						2019	grade_1	*
2434933	CT	school		830011	Middletown School District	90249001758	830611	ICM - Farm Hill	Program						2019	grade_1	*
2434996	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2019	grade_1	*
2434997	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2019	grade_1	*
2434999	CT	school		890011	New Britain School District		891011	Lincoln SCS	Program						2019	grade_1	*
2435058	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	grade_1	*
2435060	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	grade_1	*
2435061	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	grade_1	*
2435067	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2019	grade_1	*
2435068	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2019	grade_1	*
2435069	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2019	grade_1	*
2435070	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2019	grade_1	*
2435071	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2019	grade_1	*
2435164	CT	school		1040011	Norwich School District		1040411	Strive Autism Program @ Huntington	Program						2019	grade_1	*
2435165	CT	school		1040011	Norwich School District		1041211	Strive Program @ Stanton	Program						2019	grade_1	*
2435216	CT	school		2010012	Regional School District 01		2010412	LEAPSS	Program						2019	grade_1	*
2435272	CT	school	903810	1180011	Ridgefield School District	90381000780	1180511	Scotland Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	*