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

Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_8", state = "CT" and year = 2020 sorted by total

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
2770435	2770435	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2020	grade_8	*
2770465	2770465	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2020	grade_8	*
2770541	2770541	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2020	grade_8	*
2770546	2770546	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2020	grade_8	*
2770547	2770547	CT	school		170011	Bristol School District		171611	Chippens Hill Middle School Medically Fragile	Program						2020	grade_8	*
2770549	2770549	CT	school		170011	Bristol School District	90051001753	173411	Chms Goal	Program						2020	grade_8	*
2770550	2770550	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2020	grade_8	*
2770551	2770551	CT	school		170011	Bristol School District	90051001651	172711	Northeast MS/Extended Resource	Program						2020	grade_8	*
2770583	2770583	CT	school		2410014	Capitol Region Education Council	90070001154	2419014	John J. Allison Polaris Center	Program						2020	grade_8	*
2770585	2770585	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2020	grade_8	*
2770591	2770591	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2020	grade_8	*
2770620	2770620	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	grade_8	*
2770625	2770625	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2020	grade_8	*
2770723	2770723	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2020	grade_8	*
2770724	2770724	CT	school		2420014	EdAdvance		2420114	Steps	Program						2020	grade_8	*
2770752	2770752	CT	school		490011	Enfield School District		490911	John F. Kennedy - Adaptive Learning Program (ALP)	Program						2020	grade_8	*
2770795	2770795	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2020	grade_8	*
2770797	2770797	CT	school	901620	540011	Glastonbury School District	90162000282	545211	Smith Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	*
2770823	2770823	CT	school	901740	580011	Griswold School District	90174001721	580111	Griswold Alternative School	Public Schools	Alternative School	No	High	08	12	2020	grade_8	*
2770843	2770843	CT	school	901800	600011	Guilford School District	90180000332	606111	Guilford High School	Public Schools	Regular School	No	High	08	12	2020	grade_8	*
2770916	2770916	CT	school		640011	Hartford School District		648911	iGOAL 1 - McDonough Middle School							2020	grade_8	*
2770917	2770917	CT	school		640011	Hartford School District		640110	iGOAL 1 - Milner School	Program						2020	grade_8	*
2770945	2770945	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	grade_8	*
2770950	2770950	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program							2020	grade_8	*
2770987	2770987	CT	school	902310	770011	Manchester School District	90231000421	775311	Illing Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	*
2771011	2771011	CT	school		800011	Meriden School District		802311	SOAR - LMS							2020	grade_8	*
2771012	2771012	CT	school		800011	Meriden School District		802411	SOAR - WMS	Program						2020	grade_8	*
2771013	2771013	CT	school		800011	Meriden School District		801511	STARS-MS	Program						2020	grade_8	*
2771016	2771016	CT	school		800011	Meriden School District		801311	Venture Academy	Program						2020	grade_8	*
2771040	2771040	CT	school		830011	Middletown School District	90249001793	830411	ICM- Woodrow Wilson Middle School	Program						2020	grade_8	*
2771110	2771110	CT	school		890011	New Britain School District	90267001566	899011	New Britain Transition Center	Program						2020	grade_8	*
2771115	2771115	CT	school		890011	New Britain School District	90267001557	899111	Brookside School	Program						2020	grade_8	*
2771139	2771139	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_8	*
2771164	2771164	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2020	grade_8	*
2771166	2771166	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2020	grade_8	*
2771168	2771168	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2020	grade_8	*
2771170	2771170	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2020	grade_8	*
2771277	2771277	CT	school		1040011	Norwich School District		1041111	Strive Program @ Kelly	Program						2020	grade_8	*
2771279	2771279	CT	school		1040011	Norwich School District	90312001622	1049211	Virtual Learning Academy	Program						2020	grade_8	*
2771341	2771341	CT	school	903535	2130012	Regional School District 13	90353500739	2135112	Frank Ward Strong School	Regional Schools	Regular School	No	Middle	05	08	2020	grade_8	*
2771360	2771360	CT	school		2160012	Regional School District 16	90353801747	2160412	WRHS Alternative Education Program	Program						2020	grade_8	*
2771383	2771383	CT	school		1180011	Ridgefield School District		1181011	District Program ERMS	Program						2020	grade_8	*
2771384	2771384	CT	school		1180011	Ridgefield School District		1181111	District Program SRMS	Program						2020	grade_8	*
2771456	2771456	CT	school		1310011	Southington School District	90423001668	1310511	EASE	Program						2020	grade_8	*
2771458	2771458	CT	school		1310011	Southington School District	90423001720	1311611	Therapeutic Educational Alternative Model (TEAM)	Program						2020	grade_8	*
2771487	2771487	CT	school		1350011	Stamford School District	90432001744	1350411	Anchor	Program						2020	grade_8	*
2771502	2771502	CT	school		1370011	Stonington School District		1370911	The Learning Annex	Program						2020	grade_8	*
2771520	2771520	CT	school		1380011	Stratford School District	90444001756	1381811	Middle School Sails	Program						2020	grade_8	*
2771521	2771521	CT	school		1380011	Stratford School District	90444001706	1381911	STEPS 7-8	Program						2020	grade_8	*
2771535	2771535	CT	school		1400011	Thomaston School District		1400311	PATHS	Program						2020	grade_8	*
2771568	2771568	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	*
2771598	2771598	CT	school		1480011	Wallingford School District		1481311	Inspire Middle School	Program						2020	grade_8	*
2771625	2771625	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_8	*
2771633	2771633	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2020	grade_8	*
2771643	2771643	CT	school		1510011	Waterbury School District		1512911	North End Autism	Program						2020	grade_8	*
2771648	2771648	CT	school		1510011	Waterbury School District		1514811	North End SCOPE	Program						2020	grade_8	*
2771649	2771649	CT	school		1510011	Waterbury School District		1514411	Wallace BDLC	Program						2020	grade_8	*
2771651	2771651	CT	school		1510011	Waterbury School District		1514911	Wallace SCOPE	Program						2020	grade_8	*
2771655	2771655	CT	school		1510011	Waterbury School District		1515511	West Side SCOPE	Program						2020	grade_8	*
2771709	2771709	CT	school		1560011	West Haven School District	90495001799	1560111	Life Skills	Program						2020	grade_8	*
2771750	2771750	CT	school		1610011	Wilton School District		1610211	Genesis	Program						2020	grade_8	*
2771798	2771798	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_8	*
2771812	2771812	CT	school		2010012	Regional School District 01		2010312	SELC	Program						2020	grade_8	*
2771817	2771817	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2020	grade_8	*
2771818	2771818	CT	school		3470015	Unified School District #2	90000400479	3470315	Riverview School	State Agency Facilities						2020	grade_8	*
2771826	2771826	CT	school		2070012	Regional School District 07	90372001401	2079212	Links	Program						2020	grade_8	*
2771828	2771828	CT	school		2070012	Regional School District 07	90372001399	2079012	FLEX	Program						2020	grade_8	*
2770420	2770420	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770421	2770421	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_8	0	0
2770422	2770422	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770423	2770423	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
2770425	2770425	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770426	2770426	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2020	grade_8	0	0
2770427	2770427	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2020	grade_8	0	0
2770428	2770428	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_8	0	0
2770430	2770430	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_8	0	0
2770432	2770432	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_8	0	0
2770436	2770436	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2020	grade_8	0	0
2770437	2770437	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2020	grade_8	0	0
2770438	2770438	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_8	0	0
2770440	2770440	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2020	grade_8	0	0
2770441	2770441	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
2770442	2770442	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
2770443	2770443	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2020	grade_8	0	0
2770445	2770445	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770446	2770446	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770447	2770447	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2020	grade_8	0	0
2770448	2770448	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_8	0	0
2770449	2770449	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2770450	2770450	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2770451	2770451	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770453	2770453	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770454	2770454	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2020	grade_8	0	0
2770455	2770455	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770456	2770456	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_8	0	0
2770457	2770457	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_8	0	0
2770458	2770458	CT	school	900270	90011	Bethel School District	90027001118	90511	Ralph M. T. Johnson School	Public Schools	Regular School	No	Elementary	04	05	2020	grade_8	0	0
2770460	2770460	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770461	2770461	CT	school		90011	Bethel School District		90311	TASK	Program						2020	grade_8	0	0
2770462	2770462	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2020	grade_8	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]);