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

Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_5", state = "CT" and year = 2020 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 ▼
2766049	2766049	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_5	*
2766082	2766082	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2020	grade_5	*
2766151	2766151	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2020	grade_5	*
2766158	2766158	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2020	grade_5	*
2766159	2766159	CT	school		170011	Bristol School District		173711	Hubbell Autism Program	Program						2020	grade_5	*
2766160	2766160	CT	school		170011	Bristol School District	90051001711	173111	South Side GOAL	Program						2020	grade_5	*
2766201	2766201	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2020	grade_5	*
2766218	2766218	CT	school		250011	Cheshire School District		250711	Highland School Autism Program	Program						2020	grade_5	*
2766340	2766340	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2020	grade_5	*
2766366	2766366	CT	school		490011	Enfield School District		491411	Eli Whitney - Intermediate Adaptive Learning (IAL)	Program						2020	grade_5	*
2766368	2766368	CT	school		490011	Enfield School District	90147001702	490711	Prudence Crandall - Educational Counseling Program (ECP)	Program						2020	grade_5	*
2766401	2766401	CT	school	901560	520011	Farmington School District	90156001368	520511	West Woods Upper Elementary School	Public Schools	Regular School	No	Middle	04	06	2020	grade_5	*
2766412	2766412	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2020	grade_5	*
2766465	2766465	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2020	grade_5	*
2766475	2766475	CT	school		620011	Hamden School District		621311	Church Street IIC	Program						2020	grade_5	*
2766517	2766517	CT	school		640011	Hartford School District		644711	iGOAL 1 - Burns School	Program						2020	grade_5	*
2766520	2766520	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2020	grade_5	*
2766526	2766526	CT	school		640011	Hartford School District		640210	iGOAL 2 - Kennelly School	Program						2020	grade_5	*
2766562	2766562	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	grade_5	*
2766564	2766564	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2020	grade_5	*
2766624	2766624	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2020	grade_5	*
2766625	2766625	CT	school		800011	Meriden School District		800611	STARS - ES	Program						2020	grade_5	*
2766655	2766655	CT	school		830011	Middletown School District	90249001652	830711	ICM - Moody 3-5	Program						2020	grade_5	*
2766656	2766656	CT	school		830011	Middletown School District		832011	ICM - Spencer	Program						2020	grade_5	*
2766724	2766724	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2020	grade_5	*
2766725	2766725	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2020	grade_5	*
2766726	2766726	CT	school		890011	New Britain School District		891011	Lincoln SCS	Program						2020	grade_5	*
2766727	2766727	CT	school		890011	New Britain School District	90267001566	899011	New Britain Transition Center	Program						2020	grade_5	*
2766756	2766756	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_5	*
2766780	2766780	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_5	*
2766781	2766781	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2020	grade_5	*
2766783	2766783	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2020	grade_5	*
2766784	2766784	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2020	grade_5	*
2766785	2766785	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2020	grade_5	*
2766793	2766793	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2020	grade_5	*
2766849	2766849	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	*
2766889	2766889	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2020	grade_5	*
2766890	2766890	CT	school		1040011	Norwich School District		1040911	Stanton Special Learning Center	Program						2020	grade_5	*
2766958	2766958	CT	school	903535	2130012	Regional School District 13	90353500739	2135112	Frank Ward Strong School	Regional Schools	Regular School	No	Middle	05	08	2020	grade_5	*
2767125	2767125	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2020	grade_5	*
2767127	2767127	CT	school		1380011	Stratford School District		1382311	DLC Whitney	Program						2020	grade_5	*
2767131	2767131	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2020	grade_5	*
2767134	2767134	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2020	grade_5	*
2767185	2767185	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_5	*
2767192	2767192	CT	school		1460011	Vernon School District		1460811	Renaissance Program	Program						2020	grade_5	*
2767204	2767204	CT	school		1480011	Wallingford School District		1480611	Benhaven ABC Intermediate Program	Program						2020	grade_5	*
2767209	2767209	CT	school		1480011	Wallingford School District		1481111	STARS Intermediate Program	Program						2020	grade_5	*
2767210	2767210	CT	school		1480011	Wallingford School District	90474001595	1489211	WISE Intermediate Program	Program						2020	grade_5	*
2767240	2767240	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_5	*
2767242	2767242	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_5	*
2767245	2767245	CT	school		1510011	Waterbury School District		1513511	Generali Autism	Program						2020	grade_5	*
2767246	2767246	CT	school		1510011	Waterbury School District		1516911	Gilmartin Scope	Program						2020	grade_5	*
2767250	2767250	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2020	grade_5	*
2767256	2767256	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2020	grade_5	*
2767282	2767282	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2020	grade_5	*
2767300	2767300	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	grade_5	*
2767306	2767306	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2020	grade_5	*
2767308	2767308	CT	school		1550011	West Hartford School District	90492001780	1559511	Whiting Lane Learning Center	Program						2020	grade_5	*
2767326	2767326	CT	school		1560011	West Haven School District	90495001799	1560111	Life Skills	Program						2020	grade_5	*
2767327	2767327	CT	school		1560011	West Haven School District		1561111	ASD Lab							2020	grade_5	*
2767349	2767349	CT	school		1580011	Westport School District		1580111	LLS Intensive Resource	Program						2020	grade_5	*
2767352	2767352	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2020	grade_5	*
2767377	2767377	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2020	grade_5	*
2767380	2767380	CT	school		1630011	Windham School District		1630911	Sweeney Medically Fragile Program	Program						2020	grade_5	*
2767418	2767418	CT	school	900870	290011	Colebrook School District	90087000138	290111	Colebrook Consolidated School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_5	*
2767419	2767419	CT	school	900930	310011	Cornwall School District	90093000140	310111	Cornwall Consolidated School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_5	*
2766038	2766038	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_5	0	0
2766041	2766041	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_5	0	0
2766042	2766042	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766043	2766043	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2020	grade_5	0	0
2766044	2766044	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2020	grade_5	0	0
2766045	2766045	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_5	0	0
2766050	2766050	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2020	grade_5	0	0
2766051	2766051	CT	school	900070	2440014	Area Cooperative Educational Services	90007001358	2445114	Thomas Edison Magnet Middle School	Regional Education Service Center Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766052	2766052	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2020	grade_5	0	0
2766053	2766053	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2020	grade_5	0	0
2766054	2766054	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2020	grade_5	0	0
2766055	2766055	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_5	0	0
2766057	2766057	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2020	grade_5	0	0
2766058	2766058	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766059	2766059	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766061	2766061	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_5	0	0
2766062	2766062	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766064	2766064	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2020	grade_5	0	0
2766065	2766065	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_5	0	0
2766069	2766069	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766070	2766070	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766071	2766071	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2020	grade_5	0	0
2766073	2766073	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_5	0	0
2766074	2766074	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_5	0	0
2766076	2766076	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766077	2766077	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766078	2766078	CT	school		90011	Bethel School District		90311	TASK	Program						2020	grade_5	0	0
2766079	2766079	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2020	grade_5	0	0
2766080	2766080	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2766081	2766081	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_5	0	0
2766083	2766083	CT	school	900330	110011	Bloomfield School District	90033000033	110511	Metacomet School	Public Schools	Regular School	No	Elementary	03	04	2020	grade_5	0	0
2766085	2766085	CT	school	900330	110011	Bloomfield School District	90033001615	116311	Global Experience Magnet School	Public Schools	Regular School	No	High	06	12	2020	grade_5	0	0
2766086	2766086	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_5	0	0
2766087	2766087	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2020	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]);