schools: enrollments: 60,956 rows where where state = "CT" sorted by total

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" 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 ▼
2749475	2749475	CT	school		1040011	Norwich School District	90312001622	1049211	Virtual Learning Academy	Program						2021	grade_7	*
2749580	2749580	CT	school		1180011	Ridgefield School District		1181011	District Program ERMS	Program						2021	grade_7	*
2749581	2749581	CT	school		1180011	Ridgefield School District		1181111	District Program SRMS	Program						2021	grade_7	*
2749611	2749611	CT	school	904050	1260011	Shelton School District	90405000801	1265111	Intermediate School	Public Schools	Regular School	No	Middle	06	08	2021	grade_7	*
2749651	2749651	CT	school		1310011	Southington School District	90423001668	1310511	EASE	Program						2021	grade_7	*
2749653	2749653	CT	school		1310011	Southington School District	90423001720	1311611	Therapeutic Educational Alternative Model (TEAM)	Program						2021	grade_7	*
2749686	2749686	CT	school		1350011	Stamford School District	90432001744	1350411	Anchor	Program						2021	grade_7	*
2749714	2749714	CT	school		1380011	Stratford School District	90444001756	1381811	Middle School Sails	Program						2021	grade_7	*
2749715	2749715	CT	school		1380011	Stratford School District	90444001706	1381911	STEPS 7-8	Program						2021	grade_7	*
2749787	2749787	CT	school		1480011	Wallingford School District		1481511	Ben Haven ABC Middle School Program	Program						2021	grade_7	*
2749789	2749789	CT	school		1480011	Wallingford School District		1481311	Inspire Middle School	Program						2021	grade_7	*
2749826	2749826	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2021	grade_7	*
2749831	2749831	CT	school		1510011	Waterbury School District		1512911	North End Autism	Program						2021	grade_7	*
2749835	2749835	CT	school		1510011	Waterbury School District		1514811	North End SCOPE	Program						2021	grade_7	*
2749836	2749836	CT	school		1510011	Waterbury School District		1514411	Wallace BDLC	Program						2021	grade_7	*
2749838	2749838	CT	school		1510011	Waterbury School District		1514911	Wallace SCOPE	Program						2021	grade_7	*
2749840	2749840	CT	school		1510011	Waterbury School District		1514711	West Side BDLC	Program						2021	grade_7	*
2749843	2749843	CT	school		1510011	Waterbury School District		1515511	West Side SCOPE	Program						2021	grade_7	*
2749844	2749844	CT	school		1510011	Waterbury School District	90483001418	1519111	Enlightenment School	Program						2021	grade_7	*
2749845	2749845	CT	school		1510011	Waterbury School District		1511811	North End ESC	Program						2021	grade_7	*
2749898	2749898	CT	school		1560011	West Haven School District	90495001799	1560111	Life Skills	Program						2021	grade_7	*
2749938	2749938	CT	school		1610011	Wilton School District		1610211	Genesis	Program						2021	grade_7	*
2749989	2749989	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2021	grade_7	*
2750010	2750010	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2021	grade_7	*
2750018	2750018	CT	school		2070012	Regional School District 07	90372001399	2079012	FLEX	Program						2021	grade_7	*
2750103	2750103	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2021	grade_8	*
2750179	2750179	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2021	grade_8	*
2750183	2750183	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2021	grade_8	*
2750184	2750184	CT	school		170011	Bristol School District		171611	Chippens Hill Middle School Medically Fragile	Program						2021	grade_8	*
2750185	2750185	CT	school		170011	Bristol School District		170811	Chippens Hilll Middle School Extended Resource	Program						2021	grade_8	*
2750186	2750186	CT	school		170011	Bristol School District	90051001753	173411	Chms Goal	Program						2021	grade_8	*
2750187	2750187	CT	school		170011	Bristol School District	90051001651	172711	Northeast MS/Extended Resource	Program						2021	grade_8	*
2750188	2750188	CT	school		170011	Bristol School District	90051001796	172811	Northeast MS/GOAL	Program						2021	grade_8	*
2750190	2750190	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2021	grade_8	*
2750227	2750227	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2021	grade_8	*
2750305	2750305	CT	school		370011	Derby School District		370511	RAISE Academy	Program						2021	grade_8	*
2750366	2750366	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2021	grade_8	*
2750368	2750368	CT	school		2420014	EdAdvance		2420314	Steps-North Expelled Student	Program						2021	grade_8	*
2750395	2750395	CT	school		490011	Enfield School District		490911	John F. Kennedy - Adaptive Learning Program (ALP)	Program						2021	grade_8	*
2750438	2750438	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2021	grade_8	*
2750466	2750466	CT	school	901740	580011	Griswold School District	90174001721	580111	Griswold Alternative School	Public Schools	Alternative School	No	High	08	12	2021	grade_8	*
2750504	2750504	CT	school		620011	Hamden School District		622011	Intensive Support Classroom 7-8	Program						2021	grade_8	*
2750549	2750549	CT	school		640011	Hartford School District		640210	iGOAL 2 - Kennelly School	Program						2021	grade_8	*
2750556	2750556	CT	school		640011	Hartford School District		641310	RISE - M.L. King Middle School	Program						2021	grade_8	*
2750559	2750559	CT	school		640011	Hartford School District		640910	New Visions	Program						2021	grade_8	*
2750587	2750587	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2021	grade_8	*
2750588	2750588	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2021	grade_8	*
2750626	2750626	CT	school		770011	Manchester School District	90231000427	779011	Manchester Regional Academy	Program						2021	grade_8	*
2750649	2750649	CT	school		800011	Meriden School District		802311	SOAR - LMS							2021	grade_8	*
2750650	2750650	CT	school		800011	Meriden School District		802411	SOAR - WMS	Program						2021	grade_8	*
2750654	2750654	CT	school		800011	Meriden School District		801311	Venture Academy	Program						2021	grade_8	*
2750678	2750678	CT	school		830011	Middletown School District	90249001793	830411	ICM- Woodrow Wilson Middle School	Program						2021	grade_8	*
2750752	2750752	CT	school		890011	New Britain School District		891711	Slade KEY Middle	Program						2021	grade_8	*
2750754	2750754	CT	school		890011	New Britain School District	90267001557	899111	Brookside School	Program						2021	grade_8	*
2750802	2750802	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2021	grade_8	*
2750803	2750803	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2021	grade_8	*
2750804	2750804	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2021	grade_8	*
2750808	2750808	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2021	grade_8	*
2750860	2750860	CT	school		970011	Newtown School District		970711	Reaching Independence through Structured Education	Program						2021	grade_8	*
2750917	2750917	CT	school		1040011	Norwich School District		1041111	Strive Program @ Kelly	Program						2021	grade_8	*
2750982	2750982	CT	school	903535	2130012	Regional School District 13	90353500737	2136112	Coginchaug Regional High School	Regional Schools	Regular School	No	High	08	12	2021	grade_8	*
2751024	2751024	CT	school		1180011	Ridgefield School District		1181011	District Program ERMS	Program						2021	grade_8	*
2751025	2751025	CT	school		1180011	Ridgefield School District		1181111	District Program SRMS	Program						2021	grade_8	*
2751095	2751095	CT	school		1310011	Southington School District	90423001668	1310511	EASE	Program						2021	grade_8	*
2751097	2751097	CT	school		1310011	Southington School District	90423001720	1311611	Therapeutic Educational Alternative Model (TEAM)	Program						2021	grade_8	*
2751130	2751130	CT	school		1350011	Stamford School District	90432001744	1350411	Anchor	Program						2021	grade_8	*
2751158	2751158	CT	school		1380011	Stratford School District	90444001756	1381811	Middle School Sails	Program						2021	grade_8	*
2751159	2751159	CT	school		1380011	Stratford School District	90444001706	1381911	STEPS 7-8	Program						2021	grade_8	*
2751174	2751174	CT	school		1400011	Thomaston School District		1400311	PATHS	Program						2021	grade_8	*
2751202	2751202	CT	school		1440011	Trumbull School District	90462001762	1440511	REACH	Program						2021	grade_8	*
2751206	2751206	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_8	*
2751231	2751231	CT	school		1480011	Wallingford School District		1481511	Ben Haven ABC Middle School Program	Program						2021	grade_8	*
2751233	2751233	CT	school		1480011	Wallingford School District		1481311	Inspire Middle School	Program						2021	grade_8	*
2751261	2751261	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2021	grade_8	*
2751270	2751270	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2021	grade_8	*
2751280	2751280	CT	school		1510011	Waterbury School District		1514411	Wallace BDLC	Program						2021	grade_8	*
2751287	2751287	CT	school		1510011	Waterbury School District		1515511	West Side SCOPE	Program						2021	grade_8	*
2751289	2751289	CT	school		1510011	Waterbury School District		1511811	North End ESC	Program						2021	grade_8	*
2751342	2751342	CT	school		1560011	West Haven School District	90495001799	1560111	Life Skills	Program						2021	grade_8	*
2751433	2751433	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2021	grade_8	*
2751448	2751448	CT	school		2010012	Regional School District 01		2010312	SELC	Program						2021	grade_8	*
2751453	2751453	CT	school		3470015	Unified School District #2	90000400479	3470315	Riverview School	State Agency Facilities						2021	grade_8	*
2751454	2751454	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2021	grade_8	*
2751464	2751464	CT	school		2070012	Regional School District 07	90372001401	2079212	Links	Program						2021	grade_8	*
2751474	2751474	CT	school		3360015	Unified School District #1	90000300404	3361115	Manson Youth Institution	State Agency Facilities						2021	grade_8	*
2751518	2751518	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_9	*
2751519	2751519	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_9	*
2751543	2751543	CT	school		90011	Bethel School District		90311	TASK	Program						2021	grade_9	*
2751595	2751595	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2021	grade_9	*
2751623	2751623	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2021	grade_9	*
2751637	2751637	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2021	grade_9	*
2751660	2751660	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2021	grade_9	*
2751671	2751671	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2021	grade_9	*
2751672	2751672	CT	school		2410014	Capitol Region Education Council		2411914	CREC Impact Academy	Program						2021	grade_9	*
2751686	2751686	CT	school		250011	Cheshire School District	90075001682	250911	Humiston Alternative School	Program						2021	grade_9	*
2751699	2751699	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2021	grade_9	*
2751704	2751704	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2021	grade_9	*
2751763	2751763	CT	school		420011	East Hampton School District	90123001514	429011	The Learning Center at East Hampton	Program						2021	grade_9	*
2751792	2751792	CT	school		450011	East Lyme School District	90132001760	450611	Coastal Connections	Program						2021	grade_9	*
2751801	2751801	CT	school	901360	2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001937	2530314	LEAP Alternative High School	Regional Education Service Center Schools	Alternative School	No	High	09	12	2021	grade_9	*

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]);