schools: enrollments: 1,444 rows where where grade = "grade_5", state = "CT" and year = 2021 sorted by total

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_5", state = "CT" and year = 2021 sorted by total_int

Search:

descending

Link	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 ▼
2745754	2745754	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2021	grade_5	*
2745836	2745836	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2021	grade_5	*
2745838	2745838	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2021	grade_5	*
2745842	2745842	CT	school		170011	Bristol School District		173811	Greene Hills Extended Resource	Program						2021	grade_5	*
2745844	2745844	CT	school		170011	Bristol School District		173711	Hubbell Autism Program	Program						2021	grade_5	*
2745847	2745847	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2021	grade_5	*
2745848	2745848	CT	school		170011	Bristol School District		172411	Mt. View Extended Resource	Program						2021	grade_5	*
2745849	2745849	CT	school		170011	Bristol School District	90051001711	173111	South Side GOAL	Program						2021	grade_5	*
2745888	2745888	CT	school		2410014	Capitol Region Education Council	90070001154	2419014	John J. Allison Polaris Center	Program						2021	grade_5	*
2745889	2745889	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2021	grade_5	*
2745904	2745904	CT	school		250011	Cheshire School District		250711	Highland School Autism Program	Program						2021	grade_5	*
2745906	2745906	CT	school		250011	Cheshire School District		251111	Doolittle Bridges Program	Program						2021	grade_5	*
2745923	2745923	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2021	grade_5	*
2745997	2745997	CT	school		430011	East Hartford School District	90126000205	439011	Woodland School	Program						2021	grade_5	*
2746034	2746034	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2021	grade_5	*
2746058	2746058	CT	school		490011	Enfield School District	90147001676	490511	Edgar H. Parkman - Autism Spectrum Disorder (ASD)	Program						2021	grade_5	*
2746060	2746060	CT	school		490011	Enfield School District		491411	Eli Whitney - Intermediate Adaptive Learning (IAL)	Program						2021	grade_5	*
2746061	2746061	CT	school		490011	Enfield School District	90147001702	490711	Prudence Crandall - Educational Counseling Program (ECP)	Program						2021	grade_5	*
2746095	2746095	CT	school	901560	520011	Farmington School District	90156001368	520511	West Woods Upper Elementary School	Public Schools	Regular School	No	Middle	04	06	2021	grade_5	*
2746106	2746106	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2021	grade_5	*
2746161	2746161	CT	school		620011	Hamden School District		621911	Intensive Support Classroom	Program						2021	grade_5	*
2746167	2746167	CT	school		620011	Hamden School District		621611	Helen Street IIC	Program						2021	grade_5	*
2746168	2746168	CT	school		620011	Hamden School District		621811	West Woods IIC	Program						2021	grade_5	*
2746170	2746170	CT	school		620011	Hamden School District		621311	Church Street IIC	Program						2021	grade_5	*
2746205	2746205	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2021	grade_5	*
2746212	2746212	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2021	grade_5	*
2746213	2746213	CT	school		640011	Hartford School District		644611	RISE - West Middle School	Program						2021	grade_5	*
2746214	2746214	CT	school		640011	Hartford School District		649511	iGOAL 1 - Breakthrough Magnet School, North	Program						2021	grade_5	*
2746217	2746217	CT	school		640011	Hartford School District		640210	iGOAL 2 - Kennelly School	Program						2021	grade_5	*
2746255	2746255	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2021	grade_5	*
2746256	2746256	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2021	grade_5	*
2746292	2746292	CT	school		770011	Manchester School District		771511	Manchester Middle Academy	Program						2021	grade_5	*
2746313	2746313	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2021	grade_5	*
2746344	2746344	CT	school		830011	Middletown School District	90249001652	830711	ICM - Moody 3-5	Program						2021	grade_5	*
2746345	2746345	CT	school		830011	Middletown School District		832011	ICM - Spencer	Program						2021	grade_5	*
2746405	2746405	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2021	grade_5	*
2746408	2746408	CT	school		890011	New Britain School District		892011	Lincoln KEY Elementary	Program						2021	grade_5	*
2746413	2746413	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2021	grade_5	*
2746417	2746417	CT	school		890011	New Britain School District		891011	Lincoln SCS	Program						2021	grade_5	*
2746470	2746470	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2021	grade_5	*
2746472	2746472	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2021	grade_5	*
2746474	2746474	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2021	grade_5	*
2746475	2746475	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2021	grade_5	*
2746476	2746476	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2021	grade_5	*
2746482	2746482	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2021	grade_5	*
2746483	2746483	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2021	grade_5	*
2746578	2746578	CT	school		1040011	Norwich School District		1040411	Strive Autism Program @ Huntington	Program						2021	grade_5	*
2746583	2746583	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2021	grade_5	*
2746634	2746634	CT	school	903515	2060012	Regional School District 06	90351500726	2060312	Warren Elementary School	Regional Schools	Regular School	No	Elementary	PK	06	2021	grade_5	*
2746688	2746688	CT	school		1180011	Ridgefield School District		1180711	District Program RES	Program						2021	grade_5	*
2746689	2746689	CT	school		1180011	Ridgefield School District		1180911	District Program SES	Program						2021	grade_5	*
2746755	2746755	CT	school		1310011	Southington School District	90423001759	1311811	Language Based Classroom, Multihandicapped	Program						2021	grade_5	*
2746761	2746761	CT	school		1310011	Southington School District	90423001786	1310411	Language Based Classroom at Hatton School	Program						2021	grade_5	*
2746820	2746820	CT	school		1380011	Stratford School District		1382311	DLC Whitney	Program						2021	grade_5	*
2746852	2746852	CT	school	904590	1430011	Torrington School District	90459000917	1430211	Forbes School	Public Schools	Regular School	No	Elementary	04	05	2021	grade_5	*
2746874	2746874	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_5	*
2746879	2746879	CT	school		1460011	Vernon School District		1461111	Elementary Activities Based Learning Program	Program						2021	grade_5	*
2746881	2746881	CT	school		1460011	Vernon School District		1460811	Renaissance Program	Program						2021	grade_5	*
2746897	2746897	CT	school		1480011	Wallingford School District		1481111	STARS Intermediate Program	Program						2021	grade_5	*
2746898	2746898	CT	school		1480011	Wallingford School District	90474001595	1489211	WISE Intermediate Program	Program						2021	grade_5	*
2746925	2746925	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2021	grade_5	*
2746932	2746932	CT	school		1510011	Waterbury School District		1513511	Generali Autism	Program						2021	grade_5	*
2746938	2746938	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2021	grade_5	*
2746941	2746941	CT	school		1510011	Waterbury School District		1511211	Woodrow Wilson BDLC	Program						2021	grade_5	*
2746968	2746968	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2021	grade_5	*
2746989	2746989	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2021	grade_5	*
2746991	2746991	CT	school		1550011	West Hartford School District	90492001780	1559511	Whiting Lane Learning Center	Program						2021	grade_5	*
2747029	2747029	CT	school		1580011	Westport School District		1580111	LLS Intensive Resource	Program						2021	grade_5	*
2747032	2747032	CT	school		1580011	Westport School District		1580211	GFS Intensive Resource	Program						2021	grade_5	*
2747035	2747035	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_5	*
2747060	2747060	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2021	grade_5	*
2745737	2745737	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_5	0	0
2745740	2745740	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5	0	0
2745741	2745741	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745742	2745742	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_5	0	0
2745743	2745743	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_5	0	0
2745744	2745744	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_5	0	0
2745746	2745746	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_5	0	0
2745747	2745747	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2745748	2745748	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2745750	2745750	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5	0	0
2745751	2745751	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745752	2745752	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2021	grade_5	0	0
2745758	2745758	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5	0	0
2745759	2745759	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745760	2745760	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_5	0	0
2745762	2745762	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_5	0	0
2745763	2745763	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_5	0	0
2745765	2745765	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5	0	0
2745766	2745766	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745767	2745767	CT	school		90011	Bethel School District		90311	TASK	Program						2021	grade_5	0	0
2745768	2745768	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2021	grade_5	0	0
2745769	2745769	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5	0	0
2745770	2745770	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_5	0	0
2745772	2745772	CT	school	900330	110011	Bloomfield School District	90033000033	110511	Metacomet School	Public Schools	Regular School	No	Elementary	03	04	2021	grade_5	0	0
2745774	2745774	CT	school	900330	110011	Bloomfield School District	90033001615	116311	Global Experience Magnet School	Public Schools	Regular School	No	High	06	12	2021	grade_5	0	0
2745775	2745775	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5	0	0
2745776	2745776	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745778	2745778	CT	school	900360	120011	Bolton School District	90036000037	126111	Bolton High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2745779	2745779	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2021	grade_5	0	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);