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 order by total limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	year	grade	white	black	hispanic	native_american_alaskan_native	asian	multiracial	male	female	ell	disability	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2777737	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	pk_12_total	0	*	*	0	0	*	*	*	0	*	*	0			0	0				0
2777753	CT	school	50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program	2020	pk_12_total	*	0	0	0	0	*	*	*	0	*	*		0	0	0	0				0
2777759	CT	school	70011	Berlin School District		70311	Transition Academy	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2777779	CT	school	120011	Bolton School District		120211	Bolton Transition Program	Program	2020	pk_12_total	*	0	0	0	0	0	0	*	0	*	*		0	0	0	0	0	0		0
2777837	CT	school	170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	*				0	0	0			0
2777838	CT	school	170011	Bristol School District		172411	Mt. View Extended Resource	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	*	*	*				0	0	0
2777843	CT	school	170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program	2020	pk_12_total	0	0	*	0	*	0	*	*	0	*	*	0	0		0		0			0
2777844	CT	school	170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	0	*	*	0			0	0	0			0
2777848	CT	school	170011	Bristol School District	90051001711	173111	South Side GOAL	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2777849	CT	school	170011	Bristol School District		173611	West bristol Extended Resource	Program	2020	pk_12_total	0	0	*	0	0	0	*	0	0	*	*	0	0		0	0	0		0	0
2777852	CT	school	170011	Bristol School District		171611	Chippens Hill Middle School Medically Fragile	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2777857	CT	school	170011	Bristol School District	90051001796	172811	Northeast MS/GOAL	Program	2020	pk_12_total	*	*	0	0	0	0	*	*	0	*	*			0	0	0	0			0
2777876	CT	school	230011	Canton School District	90069001695	230411	Canton Academy	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2777900	CT	school	2410014	Capitol Region Education Council		2419414	IPM @ Plainville High School		2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2777908	CT	school	250011	Cheshire School District		251111	Doolittle Bridges Program	Program	2020	pk_12_total	*	*	*	0	0	0	*	0	0	*	*				0	0	0		0	0
2777914	CT	school	250011	Cheshire School District		251011	QU College Life	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2777923	CT	school	280011	Colchester School District		280711	Community Transition Academy of Colchester	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2777928	CT	school	2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2777975	CT	school	370011	Derby School District		370211	Alternative Education Program	Program	2020	pk_12_total	0	0	0	0	0	*	*	0	0	*	*	0	0	0	0	0			0	0
2778030	CT	school	2420014	EdAdvance		2420314	Steps-North Expelled Student	Program	2020	pk_12_total	0	0	*	0	0	0	*	0	*	*	*	0	0		0	0	0		0
2778031	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	0	*		0	0	0	0	0		0	0	0
2778038	CT	school	480011	Ellington School District		480511	The Ellington Public Schools Expulsion Program (TEPSEP)	Program	2020	pk_12_total	*	0	0	0	0	*	*	0	0	*	*		0	0	0	0			0	0
2778039	CT	school	480011	Ellington School District		480411	Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE)	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778046	CT	school	490011	Enfield School District	90147001792	490311	Henry Barnard - Autism Spectrum Disorder (ASD)	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778047	CT	school	490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program	2020	pk_12_total	*	*	*	0	0	*	*	*	0	*	*				0	0				0
2778050	CT	school	490011	Enfield School District	90147001696	490611	Henry Barnard - Educational Counseling Program (ECP)	Program	2020	pk_12_total	*	*	*	0	0	*	*	0	0	*	*				0	0			0	0
2778052	CT	school	490011	Enfield School District	90147001676	490511	Edgar H. Parkman - Autism Spectrum Disorder (ASD)	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778054	CT	school	490011	Enfield School District		491411	Eli Whitney - Intermediate Adaptive Learning (IAL)	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	*				0	0	0			0
2778139	CT	school	590011	Groton School District		590611	Apex Academy	Program	2020	pk_12_total	*	*	0	0	0	*	*	*	0	*	*			0	0	0				0
2778161	CT	school	620011	Hamden School District		621911	Intensive Support Classroom	Program	2020	pk_12_total	*	*	*	0	0	0	*	0	0	*	*				0	0	0		0	0
2778209	CT	school	640011	Hartford School District		644611	RISE - West Middle School	Program	2020	pk_12_total	0	*	*	0	0	0	*	0	*	*	*	0			0	0	0		0
2778247	CT	school	2450014	Learn		2451514	LEARN Integrated Program at TFS	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778254	CT	school	2450014	Learn		2451414	LEARN Diagnostic and Wellness Center	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778255	CT	school	2450014	Learn		2450814	Learn SAILS Middle School Program		2020	pk_12_total	*	*	*	0	0	*	*	0	0	*	*				0	0			0	0
2778259	CT	school	2450014	Learn	90345001757	2450414	LEARN Transition Academy	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778260	CT	school	2450014	Learn	90345001795	2450614	Learn High School	Program	2020	pk_12_total	*	0	*	0	*	0	*	*	0	*	*		0		0		0			0
2778329	CT	school	800011	Meriden School District		802511	SOAR - PHS	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778342	CT	school	830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	0	*	*	0			0	0	0			0
2778343	CT	school	830011	Middletown School District	90249001652	830711	ICM - Moody 3-5	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	*				0	0	0			0
2778353	CT	school	830011	Middletown School District		832211	MHS- Alternative Education Program 3	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	*				0	0	0			0
2778578	CT	school	1040011	Norwich School District		1040911	Stanton Special Learning Center	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778580	CT	school	1040011	Norwich School District		1041211	Strive Program @ Stanton	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	*	*	*	0			0	0	0
2778598	CT	school	1080011	Oxford School District		1080511	Community Explorations	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778610	CT	school	1100011	Plainville School District		1100111	Plainville Transition Program	Program	2020	pk_12_total	*	*	0	0	0	0	*	*	0	*	*			0	0	0	0			0
2778633	CT	school	2060012	Regional School District 06		2060412	Wamogo Transition Program	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778642	CT	school	2120012	Regional School District 12		2120512	Shepaug Valley Partnership	Program	2020	pk_12_total	*	0	0	0	*	0	*	*	0	*	*		0	0	0		0			0
2778653	CT	school	2140012	Regional School District 14		2140412	Region 14 Transition Academy	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778661	CT	school	2150012	Regional School District 15		2150112	MIJ Program	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778665	CT	school	2160012	Regional School District 16	90353801747	2160412	WRHS Alternative Education Program	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778672	CT	school	2170012	Regional School District 17		2170412	RSD17 Transition Program	Program	2020	pk_12_total	0	0	0	0	*	0	*	0	0	*	*	0	0	0	0		0		0	0
2778678	CT	school	2180012	Regional School District 18		2180412	Alternative Program	Program	2020	pk_12_total	0	0	*	0	0	0	*	0	0	0	*	0	0		0	0	0		0	0	0
2778683	CT	school	1180011	Ridgefield School District		1181211	District Program FES	Program	2020	pk_12_total	0	0	0	0	*	0	*	0	0	*	*	0	0	0	0		0		0	0
2778684	CT	school	1180011	Ridgefield School District		1180711	District Program RES	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778687	CT	school	1180011	Ridgefield School District		1180911	District Program SES	Program	2020	pk_12_total	*	0	*	0	*	0	*	*	0	*	*		0		0		0			0
2778688	CT	school	1180011	Ridgefield School District		1181011	District Program ERMS	Program	2020	pk_12_total	*	0	0	0	0	*	*	*	0	*	*		0	0	0	0				0
2778689	CT	school	1180011	Ridgefield School District		1181111	District Program SRMS	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778701	CT	school	1190011	Rocky Hill School District		1190311	Pathways	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778702	CT	school	1190011	Rocky Hill School District		1190711	Rocky Hill DREAM Transition Academy	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778719	CT	school	1260011	Shelton School District		1261211	Therapeutic Learning Center	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778720	CT	school	1260011	Shelton School District		1260311	Life Skills	Program	2020	pk_12_total	*	0	0	0	0	*	*	*	0	*	*		0	0	0	0				0
2778807	CT	school	1370011	Stonington School District		1370911	The Learning Annex	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2778809	CT	school	1370011	Stonington School District		1370711	SAILS	Program	2020	pk_12_total	*	*	0	0	0	0	*	0	0	0	*			0	0	0	0		0	0	0
2778822	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	pk_12_total	*	*	*	0	0	0	*	0	0	*	*				0	0	0		0	0
2778850	CT	school	1420011	Tolland School District		1420611	Tolland Transition Academy	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2778891	CT	school	1480011	Wallingford School District		1481411	Ben Haven ABC Primary Program		2020	pk_12_total	*	0	0	0	*	0	*	*	*	*	*		0	0	0		0
2778892	CT	school	1480011	Wallingford School District		1480611	Benhaven ABC Intermediate Program	Program	2020	pk_12_total	*	0	*	0	0	0	*	*	*	*	*		0		0	0	0
2778900	CT	school	1480011	Wallingford School District		1481511	Ben Haven ABC Middle School Program	Program	2020	pk_12_total	*	0	*	0	0	0	*	*	*	*	*		0		0	0	0
2778943	CT	school	1510011	Waterbury School District		1517211	Hearing Lab	Program	2020	pk_12_total	0	0	*	*	0	0	*	0	0	*	*	0	0			0	0		0	0
2778976	CT	school	1520011	Waterford School District		1520311	Avery Point Transition Program	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2778982	CT	school	1530011	Watertown School District		1530811	Watertown Transition Academy	Program	2020	pk_12_total	*	0	0	0	*	0	*	0	0	*	*		0	0	0		0		0	0
2778992	CT	school	1550011	West Hartford School District		1559711	Morley Learning Center	Program	2020	pk_12_total	*	0	0	0	0	*	*	0	0	*	*		0	0	0	0			0	0
2779006	CT	school	1550011	West Hartford School District		1550111	Alternative Educational Program	Program	2020	pk_12_total	0	0	*	0	0	0	*	0	0	0	*	0	0		0	0	0		0	0	0
2779015	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	pk_12_total	*	0	*	0	*	0	*	*	0	*	*		0		0		0			0
2779029	CT	school	1570011	Weston School District		1570311	Post-High School Community Class Transition Program	Program	2020	pk_12_total	0	0	0	0	0	*	0	*	0	*	*	0	0	0	0	0		0		0
2779037	CT	school	1580011	Westport School District		1580111	LLS Intensive Resource	Program	2020	pk_12_total	*	0	*	0	*	0	*	0	0	*	*		0		0		0		0	0
2779046	CT	school	1590011	Wethersfield School District		1590311	STRIVE	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2779068	CT	school	1630011	Windham School District		1630911	Sweeney Medically Fragile Program	Program	2020	pk_12_total	*	0	*	0	0	0	*	0	0	*	*		0		0	0	0		0	0
2779069	CT	school	1630011	Windham School District		1630711	Natchaug Emotional Disturbance Program	Program	2020	pk_12_total	*	*	*	0	0	0	*	0	*	*	*				0	0	0		0
2779073	CT	school	1630011	Windham School District		1631411	Assisted Work Program at WHS	Program	2020	pk_12_total	*	0	*	0	0	0	*	*	*	*	*		0		0	0	0
2779085	CT	school	1640011	Windsor School District		1640411	Expulsion	Program	2020	pk_12_total	0	*	0	0	0	0	*	0	0	0	*	0		0	0	0	0		0	0	0
2779090	CT	school	1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2779117	CT	school	2010012	Regional School District 01		2010312	SELC	Program	2020	pk_12_total	*	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0			0
2779133	CT	school	2070012	Regional School District 07	90372001399	2079012	FLEX	Program	2020	pk_12_total	*	0	0	0	0	0	*	0	0	*	*		0	0	0	0	0		0	0
2779146	CT	school	3360015	Unified School District #1	90000300343	3360115	Bridgeport Correctional Center	State Agency Facilities	2020	pk_12_total	0	0	*	0	0	0	*	0	0	*	*	0	0		0	0	0		0	0
2779149	CT	school	3360015	Unified School District #1	90000301349	3362615	Northern Correctional Institution	State Agency Facilities	2020	pk_12_total	0	*	0	0	0	0	*	0	0	*	*	0		0	0	0	0		0	0
2779150	CT	school	3360015	Unified School District #1	90000300454	3361915	Garner Correctional Institution	State Agency Facilities	2020	pk_12_total	0	*	0	0	0	0	*	0	0	*	*	0		0	0	0	0		0	0
2779151	CT	school	3360015	Unified School District #1	90000300361	3360615	Hartford Correctional Center	State Agency Facilities	2020	pk_12_total	0	0	*	0	0	0	*	0	0	*	*	0	0		0	0	0		0	0
2779152	CT	school	3360015	Unified School District #1	90000300408	3361215	Osborn Correctional Institution	State Agency Facilities	2020	pk_12_total	0	*	*	0	0	0	*	0	0	*	*	0			0	0	0		0	0
2779153	CT	school	3360015	Unified School District #1	90000300436	3361515	Willard/Cybulski Correctional Institution	State Agency Facilities	2020	pk_12_total	0	*	0	0	0	0	*	0	0	*	*	0		0	0	0	0		0	0
2779154	CT	school	3360015	Unified School District #1	90000300419	3361315	Robinson Correctional Institution	State Agency Facilities	2020	pk_12_total	0	*	0	0	0	0	*	0	0	*	*	0		0	0	0	0		0	0
2779183	CT	school	3370015	Department of Mental Health and Addiction Services	90002701539	3370215	Connecticut Valley Hospital	State Agency Facilities	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	*				0	0	0			0
2779184	CT	school	3370015	Department of Mental Health and Addiction Services	90002701537	3370515	Greater Bridgeport Community Mental Health Center	State Agency Facilities	2020	pk_12_total	0	0	*	0	0	0	*	0	0	*	*	0	0		0	0	0		0	0
2779185	CT	school	3370015	Department of Mental Health and Addiction Services	90002701922	3370915	Whiting Forensic Hospital	State Agency Facilities	2020	pk_12_total	0	0	*	0	0	0	0	*	0	*	*	0	0		0	0	0	0		0
2777862	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	pk_12_total	*	*	*	0	0	*	*	*	0	10	10				0	0				0	10	10
2778019	CT	school	450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program	2020	pk_12_total	*	*	0	0	0	0	*	*	*	10	10			0	0	0	0				10	10
2778169	CT	school	620011	Hamden School District		620611	Hamden Transition Academy @ SCSU (AACPB)	Program	2020	pk_12_total	*	7	0	0	*	0	*	*	*	10	10		7	0	0		0				10	10
2778312	CT	school	800011	Meriden School District		802211	SOAR- ES	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	0	*	10				0	0	0			0		10
2778318	CT	school	800011	Meriden School District		801511	STARS-MS	Program	2020	pk_12_total	*	*	*	0	0	*	*	*	*	10	10				0	0					10	10
2778348	CT	school	830011	Middletown School District	90249001722	831811	MHS - Alternative Education Program 1	Program	2020	pk_12_total	*	*	*	0	0	*	*	*	0	*	10				0	0				0		10
2778456	CT	school	930011	New Haven School District		930510	Lincoln Bassett Integrated PK	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	0	10	10	0			0	0	0			0	10	10
2778474	CT	school	930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	0	10	10	0			0	0	0			0	10	10