schools: enrollments: 20,216 rows where where state = "CT" and year = 2021 sorted by total descending

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by total descending

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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total ▲	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2755933	2755933	CT	school	900450	150011	Bridgeport School District	90045001633	151511	Information Technology & Software Engineering Magnet High School	Public Schools	Regular School	No	High	09	12	2021	grade_12												96												96
2757277	2757277	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201152	9002416	Windham Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_12												96												96
2757381	2757381	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	pk_12_total	46	*	38	0	*	0	10	63	33	0	71	96	46		38	0		0	10	63	33	0	71	96
2757554	2757554	CT	school		430011	East Hartford School District	90126001377	436411	Synergy Alternative Program	Program						2021	pk_12_total	*	24	58	0	0	0	*	64	32	11	26	96		24	58	0	0	0		64	32	11	26	96
2758350	2758350	CT	school		1350011	Stamford School District	90432001744	1350411	Anchor	Program						2021	pk_12_total	*	30	46	0	0	0	*	56	40	20	51	96		30	46	0	0	0		56	40	20	51	96
2757833	2757833	CT	school	902280	760011	Madison School District	90228000411	766111	Daniel Hand High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	829	*	51	*	35	0	37	535	*	*	113	958	829		51		35	0	37	535			113	958
2757303	2757303	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	634	53	65	*	166	0	*	500	457	8	97	957	634	53	65		166	0		500	457	8	97	957
2738611	2738611	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2021	kindergarten												95												95
2738652	2738652	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2021	kindergarten												95												95
2740024	2740024	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1												95												95
2740513	2740513	CT	school	902310	770011	Manchester School District	90231000429	771211	Verplanck School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1												95												95
2740514	2740514	CT	school	902310	770011	Manchester School District	90231000430	771311	Waddell School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1												95												95
2740534	2740534	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												95												95
2741320	2741320	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_1												95												95
2742448	2742448	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												95												95
2742764	2742764	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_2												95												95
2743501	2743501	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3												95												95
2743899	2743899	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												95												95
2744633	2744633	CT	school	901530	510011	Fairfield School District	90153000262	510611	McKinley School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												95												95
2745292	2745292	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												95												95
2745341	2745341	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_4												95												95
2745347	2745347	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												95												95
2745452	2745452	CT	school	904740	1480011	Wallingford School District	90474000961	1480411	Rock Hill School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_4												95												95
2745560	2745560	CT	school	904950	1560011	West Haven School District	90495001040	1561211	Washington School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_4												95												95
2746406	2746406	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_5												95												95
2746894	2746894	CT	school	904740	1480011	Wallingford School District	90474001213	1480311	Parker Farms School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_5												95												95
2747850	2747850	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_6												95												95
2748539	2748539	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_6												95												95
2748562	2748562	CT	school	900033	2830013	Park City Prep Charter School District	90003301449	2835113	Park City Prep Charter School	Public Charter Schools	Regular School	Yes	Middle	05	08	2021	grade_6												95												95
2750986	2750986	CT	school	903536	2140012	Regional School District 14	90353600746	2145112	Woodbury Middle School	Regional Schools	Regular School	No	Middle	06	08	2021	grade_8												95												95
2752454	2752454	CT	school	903540	2180012	Regional School District 18	90354000763	2186112	Lyme-Old Lyme High School	Regional Schools	Regular School	No	High	09	12	2021	grade_9												95												95
2753715	2753715	CT	school	902790	930011	New Haven School District	90279001216	936711	Sound School	Public Schools	Regular School	No	High	09	12	2021	grade_10												95												95
2755156	2755156	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2021	grade_11												95												95
2755781	2755781	CT	school	903600	2010012	Regional School District 01	90360000766	2016112	Housatonic Valley Regional High School	Regional Schools	Regular School	No	High	09	12	2021	grade_11												95												95
2756089	2756089	CT	school	901200	410011	East Haddam School District	90120000185	416111	Nathan Hale-Ray High School	Public Schools	Regular School	No	High	09	12	2021	grade_12												95												95
2758226	2758226	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	pk_12_total	85	*	*	0	*	0	*	52	43	0	17	95	85			0		0		52	43	0	17	95
2758096	2758096	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	723	40	87	0	68	0	31	485	464	11	113	949	723	40	87	0	68	0	31	485	464	11	113	949
2739531	2739531	CT	school	904230	1310011	Southington School District	90423000829	1311511	Derynoski Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	kindergarten												94												94
2739562	2739562	CT	school	904320	1350011	Stamford School District	90432000859	1350511	K. T. Murphy School	Public Schools	Regular School	No	Elementary	KG	05	2021	kindergarten												94												94
2739972	2739972	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1												94												94
2740727	2740727	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												94												94
2740967	2740967	CT	school	904170	1320011	South Windsor School District	90417000824	1320611	Orchard Hill School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												94												94
2741007	2741007	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												94												94
2741011	2741011	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												94												94
2741318	2741318	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_1												94												94
2741957	2741957	CT	school	902310	770011	Manchester School District	90231000429	771211	Verplanck School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2												94												94
2742057	2742057	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2												94												94
2742442	2742442	CT	school	904290	1340011	Stafford School District	90429001503	1340611	Stafford Elementary School	Public Schools	Regular School	No	Elementary	02	05	2021	grade_2												94												94
2742452	2742452	CT	school	904320	1350011	Stamford School District	90432000861	1351811	Northeast School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												94												94
2742762	2742762	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_2												94												94
2743776	2743776	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2021	grade_3												94												94
2743811	2743811	CT	school	903840	1190011	Rocky Hill School District	90384000786	1190511	West Hill School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_3												94												94
2743892	2743892	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												94												94
2744019	2744019	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3												94												94
2745186	2745186	CT	school	903510	1170011	Redding School District	90351000722	1170111	Redding Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_4												94												94
2745348	2745348	CT	school	904320	1350011	Stamford School District	90432000872	1351411	Westover School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												94												94
2745869	2745869	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2021	grade_5												94												94
2745951	2745951	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												94												94
2746774	2746774	CT	school	904290	1340011	Stafford School District	90429001503	1340611	Stafford Elementary School	Public Schools	Regular School	No	Elementary	02	05	2021	grade_5												94												94
2746790	2746790	CT	school	904320	1350011	Stamford School District	90432001916	1350711	Strawberry Hill an ext. of Rogers International	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												94												94
2748065	2748065	CT	school	903390	1130011	Portland School District	90339001393	1130511	Brownstone Intermediate School	Public Schools	Regular School	No	Middle	05	06	2021	grade_6												94												94
2748564	2748564	CT	school	900011	2650013	Interdistrict School for Arts and Comm District	90001100797	2655113	Interdistrict School For Arts And Communication	Public Charter Schools	Regular School	Yes	Middle	06	08	2021	grade_6												94												94
2748729	2748729	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_7												94												94
2751452	2751452	CT	school	900011	2650013	Interdistrict School for Arts and Comm District	90001100797	2655113	Interdistrict School For Arts And Communication	Public Charter Schools	Regular School	Yes	Middle	06	08	2021	grade_8												94												94
2753156	2753156	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2021	grade_10												94												94
2755287	2755287	CT	school	903390	1130011	Portland School District	90339000712	1136111	Portland High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												94												94
2755998	2755998	CT	school	900700	2410014	Capitol Region Education Council	90070001513	2415114	Academy of Aerospace and Engineering	Regional Education Service Center Schools	Regular School	No	High	06	12	2021	grade_12												94												94
2756677	2756677	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2021	grade_12												94												94
2757318	2757318	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	628	32	183	*	79	*	10	485	450	27	129	935	628	32	183		79		10	485	450	27	129	935
2758506	2758506	CT	school	904830	1510011	Waterbury School District	90483000991	1515211	West Side Middle School	Public Schools	Regular School	No	Middle	06	08	2021	pk_12_total	152	206	510	8	16	0	43	483	452	102	170	935	152	206	510	8	16	0	43	483	452	102	170	935
2739567	2739567	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2021	kindergarten												93												93
2739963	2739963	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_1												93												93
2741161	2741161	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												93												93
2741499	2741499	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_2												93												93
2742366	2742366	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_2												93												93
2742453	2742453	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_2												93												93
2742531	2742531	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												93												93
2742851	2742851	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_3												93												93
2743886	2743886	CT	school	904290	1340011	Stafford School District	90429001503	1340611	Stafford Elementary School	Public Schools	Regular School	No	Elementary	02	05	2021	grade_3												93												93
2744189	2744189	CT	school	905220	1640011	Windsor School District	90522001087	1640111	Clover Street School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3												93												93
2744575	2744575	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_4												93												93
2744863	2744863	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												93												93
2745284	2745284	CT	school	904110	1280011	Simsbury School District	90411000814	1280711	Squadron Line School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_4												93												93
2745652	2745652	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_4												93												93
2745739	2745739	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_5												93												93
2746030	2746030	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												93												93
2746241	2746241	CT	school	902010	670011	Hebron School District	90201000388	670111	Hebron Elementary School	Public Schools	Regular School	No	Elementary	03	06	2021	grade_5												93												93
2746863	2746863	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												93												93
2748266	2748266	CT	school	904440	1380011	Stratford School District	90444000892	1381511	Stratford Academy - Johnson House	Public Schools	Regular School	No	Elementary	02	06	2021	grade_6												93												93
2748757	2748757	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2021	grade_7												93												93
2750008	2750008	CT	school	900011	2650013	Interdistrict School for Arts and Comm District	90001100797	2655113	Interdistrict School For Arts And Communication	Public Charter Schools	Regular School	Yes	Middle	06	08	2021	grade_7												93												93
2750141	2750141	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_8												93												93
2751473	2751473	CT	school	905372	9020022	The Gilbert School District	90537201222	9026122	The Gilbert School	Endowed and Incorporated Academies Schools	Regular School	No	High	07	12	2021	grade_8												93												93
2754293	2754293	CT	school	905250	1650011	Windsor Locks School District	90525001100	1656111	Windsor Locks High School	Public Schools	Regular School	No	High	09	12	2021	grade_10												93												93
2754486	2754486	CT	school	900450	150011	Bridgeport School District	90045001636	150611	Biotechnology, Research & Zoological Studies Magnet High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												93												93
2754895	2754895	CT	school	901920	640011	Hartford School District	90192001479	646611	Pathways Academy of Technology and Design	Public Schools	Regular School	No	High	09	12	2021	grade_11												93												93
2755737	2755737	CT	school	905250	1650011	Windsor Locks School District	90525001100	1656111	Windsor Locks High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												93												93
2755999	2755999	CT	school	900700	2410014	Capitol Region Education Council	90070001592	2416514	Academy of Science and Innovation	Regional Education Service Center Schools	Regular School	No	High	06	12	2021	grade_12												93												93
2756614	2756614	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2021	grade_12												93												93
2757952	2757952	CT	school		890011	New Britain School District		891611	Gaffney KEY Elementary	Program						2021	pk_12_total	7	15	61	0	*	0	*	70	23	0	82	93	7	15	61	0		0		70	23	0	82	93

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