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 ▼
2758741	2758741	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2020	kindergarten	*
2758742	2758742	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	kindergarten	*
2758760	2758760	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	kindergarten	*
2758777	2758777	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2020	kindergarten	*
2758843	2758843	CT	school		170011	Bristol School District		173811	Greene Hills Extended Resource	Program						2020	kindergarten	*
2758844	2758844	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2020	kindergarten	*
2758845	2758845	CT	school		170011	Bristol School District		172411	Mt. View Extended Resource	Program						2020	kindergarten	*
2758846	2758846	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2020	kindergarten	*
2758913	2758913	CT	school		250011	Cheshire School District		250711	Highland School Autism Program	Program						2020	kindergarten	*
2758932	2758932	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	kindergarten	*
2758935	2758935	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	kindergarten	*
2758936	2758936	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2020	kindergarten	*
2758970	2758970	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	kindergarten	*
2759012	2759012	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Elementary	PK	KG	2020	kindergarten	*
2759053	2759053	CT	school		490011	Enfield School District	90147001792	490311	Henry Barnard - Autism Spectrum Disorder (ASD)	Program						2020	kindergarten	*
2759054	2759054	CT	school		490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program						2020	kindergarten	*
2759204	2759204	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2020	kindergarten	*
2759211	2759211	CT	school		640011	Hartford School District		649511	iGOAL 1 - Breakthrough Magnet School, North	Program						2020	kindergarten	*
2759213	2759213	CT	school		640011	Hartford School District	90192001732	645711	iGOAL 1 - M.D. Fox School	Program						2020	kindergarten	*
2759214	2759214	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2020	kindergarten	*
2759215	2759215	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2020	kindergarten	*
2759257	2759257	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	kindergarten	*
2759319	2759319	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2020	kindergarten	*
2759321	2759321	CT	school		800011	Meriden School District		800911	STEP - ES	Program						2020	kindergarten	*
2759417	2759417	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2020	kindergarten	*
2759451	2759451	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	kindergarten	*
2759473	2759473	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2020	kindergarten	*
2759475	2759475	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	kindergarten	*
2759478	2759478	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2020	kindergarten	*
2759479	2759479	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2020	kindergarten	*
2759480	2759480	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2020	kindergarten	*
2759481	2759481	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2020	kindergarten	*
2759482	2759482	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2020	kindergarten	*
2759520	2759520	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2020	kindergarten	*
2759535	2759535	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	kindergarten	*
2759690	2759690	CT	school		1180011	Ridgefield School District		1181211	District Program FES	Program						2020	kindergarten	*
2759691	2759691	CT	school		1180011	Ridgefield School District		1180711	District Program RES	Program						2020	kindergarten	*
2759719	2759719	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	kindergarten	*
2759724	2759724	CT	school		1260011	Shelton School District		1260211	Alternative Learning Center 1	Program						2020	kindergarten	*
2759725	2759725	CT	school		1260011	Shelton School District		1261311	Alternative Learning Center 2	Program						2020	kindergarten	*
2759746	2759746	CT	school	904170	1320011	South Windsor School District	90417000821	1320111	Philip R. Smith School	Public Schools	Regular School	No	Elementary	PK	05	2020	kindergarten	*
2759760	2759760	CT	school		1310011	Southington School District		1312311	Language Based Classroom II	Program						2020	kindergarten	*
2759761	2759761	CT	school		1310011	Southington School District	90423001759	1311811	Language Based Classroom, Multihandicapped	Program						2020	kindergarten	*
2759822	2759822	CT	school		1380011	Stratford School District		1382311	DLC Whitney	Program						2020	kindergarten	*
2759826	2759826	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2020	kindergarten	*
2759880	2759880	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2020	kindergarten	*
2759885	2759885	CT	school		1460011	Vernon School District		1461111	Elementary Activities Based Learning Program	Program						2020	kindergarten	*
2759896	2759896	CT	school		1480011	Wallingford School District		1480711	STARS Primary Program	Program						2020	kindergarten	*
2759897	2759897	CT	school		1480011	Wallingford School District		1481611	WISE Primary Program	Program						2020	kindergarten	*
2759937	2759937	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	kindergarten	*
2759941	2759941	CT	school		1510011	Waterbury School District		1516911	Gilmartin Scope	Program						2020	kindergarten	*
2759945	2759945	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2020	kindergarten	*
2759947	2759947	CT	school		1510011	Waterbury School District	90483000958	1519011	State Street School	Program						2020	kindergarten	*
2759977	2759977	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2020	kindergarten	*
2759995	2759995	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	kindergarten	*
2759999	2759999	CT	school		1550011	West Hartford School District		1559711	Morley Learning Center	Program						2020	kindergarten	*
2760001	2760001	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2020	kindergarten	*
2760039	2760039	CT	school		1580011	Westport School District		1580211	GFS Intensive Resource	Program						2020	kindergarten	*
2760072	2760072	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2020	kindergarten	*
2760097	2760097	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2020	kindergarten	*
2760116	2760116	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2020	kindergarten	*
2760205	2760205	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_1	*
2760223	2760223	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	*
2760304	2760304	CT	school		170011	Bristol School District		173811	Greene Hills Extended Resource	Program						2020	grade_1	*
2760305	2760305	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2020	grade_1	*
2760307	2760307	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2020	grade_1	*
2760308	2760308	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2020	grade_1	*
2760311	2760311	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2020	grade_1	*
2760312	2760312	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2020	grade_1	*
2760356	2760356	CT	school		2410014	Capitol Region Education Council	90070001154	2419014	John J. Allison Polaris Center	Program						2020	grade_1	*
2760357	2760357	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2020	grade_1	*
2760358	2760358	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2020	grade_1	*
2760374	2760374	CT	school		250011	Cheshire School District		250711	Highland School Autism Program	Program						2020	grade_1	*
2760376	2760376	CT	school		250011	Cheshire School District		251111	Doolittle Bridges Program	Program						2020	grade_1	*
2760393	2760393	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	grade_1	*
2760396	2760396	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	grade_1	*
2760397	2760397	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2020	grade_1	*
2760466	2760466	CT	school		430011	East Hartford School District	90126000205	439011	Woodland School	Program						2020	grade_1	*
2760496	2760496	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2020	grade_1	*
2760514	2760514	CT	school		490011	Enfield School District	90147001792	490311	Henry Barnard - Autism Spectrum Disorder (ASD)	Program						2020	grade_1	*
2760515	2760515	CT	school		490011	Enfield School District	90147001743	490811	Henry Barnard - Primary Adaptive Learning (PAL)	Program						2020	grade_1	*
2760518	2760518	CT	school		490011	Enfield School District	90147001696	490611	Henry Barnard - Educational Counseling Program (ECP)	Program						2020	grade_1	*
2760623	2760623	CT	school		620011	Hamden School District		621711	Ridge Hill IIC	Program						2020	grade_1	*
2760628	2760628	CT	school		620011	Hamden School District		621611	Helen Street IIC	Program						2020	grade_1	*
2760629	2760629	CT	school		620011	Hamden School District		621911	Intensive Support Classroom	Program						2020	grade_1	*
2760665	2760665	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2020	grade_1	*
2760673	2760673	CT	school		640011	Hartford School District		644711	iGOAL 1 - Burns School	Program						2020	grade_1	*
2760675	2760675	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2020	grade_1	*
2760718	2760718	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	grade_1	*
2760720	2760720	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2020	grade_1	*
2760773	2760773	CT	school	902400	800011	Meriden School District	90240000445	800511	John Barry School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	*
2760809	2760809	CT	school		830011	Middletown School District	90249001758	830611	ICM - Farm Hill	Program						2020	grade_1	*
2760810	2760810	CT	school		830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program						2020	grade_1	*
2760878	2760878	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2020	grade_1	*
2760880	2760880	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2020	grade_1	*
2760881	2760881	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2020	grade_1	*
2760882	2760882	CT	school		890011	New Britain School District		891011	Lincoln SCS	Program						2020	grade_1	*
2760912	2760912	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_1	*
2760934	2760934	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2020	grade_1	*
2760936	2760936	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_1	*

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