schools: enrollments: 20,454 rows where where state = "CT" and year = 2020 sorted by total

Data source: Big Local News · About: Big Local

20,454 rows where 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 ▼
2760939	2760939	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2020	grade_1	*
2760940	2760940	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2020	grade_1	*
2760942	2760942	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2020	grade_1	*
2760943	2760943	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2020	grade_1	*
2760949	2760949	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2020	grade_1	*
2761006	2761006	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	*
2761045	2761045	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2020	grade_1	*
2761046	2761046	CT	school		1040011	Norwich School District		1040911	Stanton Special Learning Center	Program						2020	grade_1	*
2761047	2761047	CT	school		1040011	Norwich School District		1040411	Strive Autism Program @ Huntington	Program						2020	grade_1	*
2761048	2761048	CT	school		1040011	Norwich School District		1041211	Strive Program @ Stanton	Program						2020	grade_1	*
2761108	2761108	CT	school	903530	2120012	Regional School District 12	90353000734	2120112	The Burnham School	Regional Schools	Regular School	No	Elementary	KG	05	2020	grade_1	*
2761186	2761186	CT	school		1260011	Shelton School District		1261311	Alternative Learning Center 2	Program						2020	grade_1	*
2761187	2761187	CT	school		1260011	Shelton School District		1261211	Therapeutic Learning Center	Program						2020	grade_1	*
2761217	2761217	CT	school	904230	1310011	Southington School District	90423000841	1311411	Urbin T. Kelley School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	*
2761221	2761221	CT	school		1310011	Southington School District		1312311	Language Based Classroom II	Program						2020	grade_1	*
2761222	2761222	CT	school		1310011	Southington School District	90423001759	1311811	Language Based Classroom, Multihandicapped	Program						2020	grade_1	*
2761281	2761281	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2020	grade_1	*
2761287	2761287	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2020	grade_1	*
2761341	2761341	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	*
2761343	2761343	CT	school	904680	1460011	Vernon School District	90468000941	1460211	Maple Street School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	*
2761346	2761346	CT	school		1460011	Vernon School District		1461111	Elementary Activities Based Learning Program	Program						2020	grade_1	*
2761357	2761357	CT	school		1480011	Wallingford School District		1480711	STARS Primary Program	Program						2020	grade_1	*
2761358	2761358	CT	school		1480011	Wallingford School District		1481611	WISE Primary Program	Program						2020	grade_1	*
2761359	2761359	CT	school		1480011	Wallingford School District		1481411	Ben Haven ABC Primary Program							2020	grade_1	*
2761396	2761396	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_1	*
2761406	2761406	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2020	grade_1	*
2761409	2761409	CT	school		1510011	Waterbury School District		1510411	B.W. Tinker BDLC							2020	grade_1	*
2761410	2761410	CT	school		1510011	Waterbury School District		1511211	Woodrow Wilson BDLC	Program						2020	grade_1	*
2761438	2761438	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2020	grade_1	*
2761456	2761456	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	grade_1	*
2761460	2761460	CT	school		1550011	West Hartford School District		1559711	Morley Learning Center	Program						2020	grade_1	*
2761462	2761462	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2020	grade_1	*
2761466	2761466	CT	school		1550011	West Hartford School District	90492001790	1559611	Wolcott Learning Center	Program						2020	grade_1	*
2761500	2761500	CT	school		1580011	Westport School District		1580211	GFS Intensive Resource	Program						2020	grade_1	*
2761508	2761508	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2020	grade_1	*
2761533	2761533	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2020	grade_1	*
2761536	2761536	CT	school		1630011	Windham School District		1630911	Sweeney Medically Fragile Program	Program						2020	grade_1	*
2761558	2761558	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2020	grade_1	*
2761574	2761574	CT	school	900870	290011	Colebrook School District	90087000138	290111	Colebrook Consolidated School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_1	*
2761577	2761577	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2020	grade_1	*
2761664	2761664	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_2	*
2761748	2761748	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2020	grade_2	*
2761765	2761765	CT	school		170011	Bristol School District		173811	Greene Hills Extended Resource	Program						2020	grade_2	*
2761766	2761766	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2020	grade_2	*
2761768	2761768	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2020	grade_2	*
2761769	2761769	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2020	grade_2	*
2761774	2761774	CT	school		170011	Bristol School District	90051001688	172611	Ivy Drive GOAL	Program						2020	grade_2	*
2761817	2761817	CT	school		2410014	Capitol Region Education Council	90070001154	2419014	John J. Allison Polaris Center	Program						2020	grade_2	*
2761818	2761818	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2020	grade_2	*
2761835	2761835	CT	school		250011	Cheshire School District		250711	Highland School Autism Program	Program						2020	grade_2	*
2761857	2761857	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	grade_2	*
2761957	2761957	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2020	grade_2	*
2761975	2761975	CT	school		490011	Enfield School District	90147001792	490311	Henry Barnard - Autism Spectrum Disorder (ASD)	Program						2020	grade_2	*
2761976	2761976	CT	school		490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program						2020	grade_2	*
2761979	2761979	CT	school		490011	Enfield School District	90147001696	490611	Henry Barnard - Educational Counseling Program (ECP)	Program						2020	grade_2	*
2762029	2762029	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2020	grade_2	*
2762082	2762082	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2020	grade_2	*
2762084	2762084	CT	school		620011	Hamden School District		621711	Ridge Hill IIC	Program						2020	grade_2	*
2762090	2762090	CT	school		620011	Hamden School District		621911	Intensive Support Classroom	Program						2020	grade_2	*
2762091	2762091	CT	school		620011	Hamden School District		621811	West Woods IIC	Program						2020	grade_2	*
2762092	2762092	CT	school		620011	Hamden School District		621311	Church Street IIC	Program						2020	grade_2	*
2762134	2762134	CT	school		640011	Hartford School District		644711	iGOAL 1 - Burns School	Program						2020	grade_2	*
2762135	2762135	CT	school		640011	Hartford School District	90192001732	645711	iGOAL 1 - M.D. Fox School	Program						2020	grade_2	*
2762136	2762136	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2020	grade_2	*
2762137	2762137	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2020	grade_2	*
2762138	2762138	CT	school		640011	Hartford School District		644611	RISE - West Middle School	Program						2020	grade_2	*
2762139	2762139	CT	school		640011	Hartford School District		649811	iGOAL 1 - Moylan School							2020	grade_2	*
2762179	2762179	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	grade_2	*
2762232	2762232	CT	school	902400	800011	Meriden School District	90240000439	800111	Benjamin Franklin School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	*
2762236	2762236	CT	school	902400	800011	Meriden School District	90240000450	800811	Roger Sherman School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	*
2762241	2762241	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2020	grade_2	*
2762270	2762270	CT	school		830011	Middletown School District	90249001758	830611	ICM - Farm Hill	Program						2020	grade_2	*
2762271	2762271	CT	school		830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program						2020	grade_2	*
2762306	2762306	CT	school	902580	860011	Montville School District	90258000492	860711	Dr. Charles E. Murphy School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	*
2762339	2762339	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2020	grade_2	*
2762341	2762341	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2020	grade_2	*
2762342	2762342	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2020	grade_2	*
2762344	2762344	CT	school		890011	New Britain School District	90267001566	899011	New Britain Transition Center	Program						2020	grade_2	*
2762373	2762373	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_2	*
2762395	2762395	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2020	grade_2	*
2762397	2762397	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_2	*
2762398	2762398	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2020	grade_2	*
2762400	2762400	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2020	grade_2	*
2762402	2762402	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2020	grade_2	*
2762404	2762404	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2020	grade_2	*
2762407	2762407	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2020	grade_2	*
2762410	2762410	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2020	grade_2	*
2762444	2762444	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_2	*
2762506	2762506	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2020	grade_2	*
2762508	2762508	CT	school		1040011	Norwich School District		1040411	Strive Autism Program @ Huntington	Program						2020	grade_2	*
2762509	2762509	CT	school		1040011	Norwich School District		1041211	Strive Program @ Stanton	Program						2020	grade_2	*
2762613	2762613	CT	school		1180011	Ridgefield School District		1180711	District Program RES	Program						2020	grade_2	*
2762639	2762639	CT	school	904020	1250011	Sharon School District	90402000795	1250111	Sharon Center School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_2	*
2762643	2762643	CT	school	904050	1260011	Shelton School District	90405000803	1260811	Long Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_2	*
2762646	2762646	CT	school		1260011	Shelton School District		1260211	Alternative Learning Center 1	Program						2020	grade_2	*
2762647	2762647	CT	school		1260011	Shelton School District		1261311	Alternative Learning Center 2	Program						2020	grade_2	*
2762648	2762648	CT	school		1260011	Shelton School District		1261211	Therapeutic Learning Center	Program						2020	grade_2	*
2762682	2762682	CT	school		1310011	Southington School District		1312311	Language Based Classroom II	Program						2020	grade_2	*
2762742	2762742	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2020	grade_2	*
2762748	2762748	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2020	grade_2	*

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