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

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" 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
2742225	2742225	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												97												97
2743171	2743171	CT	school	901470	490011	Enfield School District	90147000241	491311	Edgar H. Parkman School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3												97												97
2744008	2744008	CT	school	904740	1480011	Wallingford School District	90474000961	1480411	Rock Hill School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3												97												97
2744208	2744208	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_3												97												97
2745220	2745220	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2021	grade_4												97												97
2745626	2745626	CT	school	905250	1650011	Windsor Locks School District	90525001098	1650411	South Elementary School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_4												97												97
2746307	2746307	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												97												97
2746664	2746664	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2021	grade_5												97												97
2746741	2746741	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												97												97
2746784	2746784	CT	school	904320	1350011	Stamford School District	90432000861	1351811	Northeast School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												97												97
2747095	2747095	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_5												97												97
2752001	2752001	CT	school	901920	640011	Hartford School District	90192001370	646511	Sport and Medical Sciences Academy	Public Schools	Regular School	No	High	06	12	2021	grade_9												97												97
2757623	2757623	CT	school		510011	Fairfield School District	90153000989	518011	Early Childhood Center(0518011)	Program						2021	pk_12_total	68	0	11	0	11	0	7	62	35	0	66	97	68	0	11	0	11	0	7	62	35	0	66	97
2757642	2757642	CT	school		520011	Farmington School District	90156001441	528011	Farmington Collaborative PK	Program						2021	pk_12_total	63	7	9	0	12	0	6	57	40	0	40	97	63	7	9	0	12	0	6	57	40	0	40	97
2757990	2757990	CT	school	902760	920011	New Hartford School District	90276000539	920111	Bakerville Consolidated School	Public Schools	Regular School	No	Elementary	KG	02	2021	pk_12_total	93	0	*	0	0	0	*	50	47	*	9	97	93	0		0	0	0		50	47		9	97
2758911	2758911	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2020	kindergarten												97												97
2759793	2759793	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2020	kindergarten												97												97
2759923	2759923	CT	school	904830	1510011	Waterbury School District	90483000977	1510711	H. S. Chase School	Public Schools	Regular School	No	Elementary	PK	05	2020	kindergarten												97												97
2760262	2760262	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1												97												97
2760372	2760372	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_1												97												97
2760857	2760857	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1												97												97
2761130	2761130	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_1												97												97
2761568	2761568	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_1												97												97
2761569	2761569	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_1												97												97
2761877	2761877	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_2												97												97
2762015	2762015	CT	school	901560	520011	Farmington School District	90156001206	520411	East Farms School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2												97												97
2762552	2762552	CT	school	903480	1160011	Putnam School District	90348000718	1160311	Putnam Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2												97												97
2762635	2762635	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2												97												97
2762866	2762866	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2												97												97
2764162	2764162	CT	school	904290	1340011	Stafford School District	90429001503	1340611	Stafford Elementary School	Public Schools	Regular School	No	Elementary	02	05	2020	grade_3												97												97
2764490	2764490	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_3												97												97
2764803	2764803	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4												97												97
2765139	2765139	CT	school	902310	770011	Manchester School District	90231000429	771211	Verplanck School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_4												97												97
2765240	2765240	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_4												97												97
2765513	2765513	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_4												97												97
2765863	2765863	CT	school	904950	1560011	West Haven School District	90495001038	1561411	Savin Rock Community School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_4												97												97
2766858	2766858	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5												97												97
2767053	2767053	CT	school	904170	1320011	South Windsor School District	90417000824	1320611	Orchard Hill School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5												97												97
2767208	2767208	CT	school	904740	1480011	Wallingford School District	90474000961	1480411	Rock Hill School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_5												97												97
2767394	2767394	CT	school	905220	1640011	Windsor School District	90522001087	1640111	Clover Street School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_5												97												97
2767413	2767413	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_5												97												97
2767431	2767431	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	2020	grade_5												97												97
2767567	2767567	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_6												97												97
2767642	2767642	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_6												97												97
2774205	2774205	CT	school	903180	1060011	Old Saybrook School District	90318000684	1066111	Old Saybrook Senior High School	Public Schools	Regular School	No	High	09	12	2020	grade_10												97												97
2774237	2774237	CT	school	903390	1130011	Portland School District	90339000712	1136111	Portland High School	Public Schools	Regular School	No	High	09	12	2020	grade_10												97												97
2774787	2774787	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201150	9001816	Vinal Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_10												97												97
2776430	2776430	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	2020	grade_12												97												97
2777027	2777027	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2020	grade_12												97												97
2778490	2778490	CT	school		930011	New Haven School District	90279001550	939111	Riverside Education Academy	Program						2020	pk_12_total	*	60	*	0	0	0	0	57	40	6	46	97		60		0	0	0	0	57	40	6	46	97
2751736	2751736	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2021	grade_9												965												965
2452990	2452990	CT	school	904950	1560011	West Haven School District	90495001036	1565111	Harry M. Bailey Middle School	Public Schools	Regular School	No	Middle	07	08	2019	pk_12_total	315	234	352	*	26	*	29	466	494	87	144	960	315	234	352		26		29	466	494	87	144	960
2432934	2432934	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten												96												96
2433000	2433000	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten												96												96
2434073	2434073	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	kindergarten												96												96
2434148	2434148	CT	school	904950	1560011	West Haven School District	90495001038	1561411	Savin Rock Community School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten												96												96
2434233	2434233	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	kindergarten												96												96
2434377	2434377	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_1												96												96
2434573	2434573	CT	school	901260	430011	East Hartford School District	90126000196	431011	Dr. Thomas S. O'Connell School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_1												96												96
2435187	2435187	CT	school	903270	1090011	Plainfield School District	90327000047	1090411	Shepard Hill Elementary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1												96												96
2435293	2435293	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												96												96
2435321	2435321	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												96												96
2435476	2435476	CT	school	904740	1480011	Wallingford School District	90474000953	1480211	Highland School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1												96												96
2435945	2435945	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2												96												96
2436701	2436701	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2019	grade_2												96												96
2436819	2436819	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2												96												96
2436859	2436859	CT	school	904440	1380011	Stratford School District	90444000892	1381511	Stratford Academy - Johnson House	Public Schools	Regular School	No	Elementary	02	06	2019	grade_2												96												96
2437312	2437312	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3												96												96
2438150	2438150	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2019	grade_3												96												96
2439107	2439107	CT	school	901920	640011	Hartford School District	90192000636	643211	Expeditionary Learning Academy at Moylan School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4												96												96
2439851	2439851	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4												96												96
2440691	2440691	CT	school	902400	800011	Meriden School District	90240000443	800411	Israel Putnam School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5												96												96
2441300	2441300	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5												96												96
2441557	2441557	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_6												96												96
2444942	2444942	CT	school	901920	640011	Hartford School District	90192000371	641211	McDonough Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_8												96												96
2447275	2447275	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_9												96												96
2448136	2448136	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	2019	grade_10												96												96
2448264	2448264	CT	school	903515	2060012	Regional School District 06	90351500725	2066112	Wamogo Regional High School	Regional Schools	Regular School	No	High	07	12	2019	grade_10												96												96
2450739	2450739	CT	school	901920	640011	Hartford School District	90192001370	646511	Sport and Medical Sciences Academy	Public Schools	Regular School	No	High	06	12	2019	grade_12												96												96
2452413	2452413	CT	school	902760	920011	New Hartford School District	90276000540	920211	New Hartford Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	pk_12_total	85	*	*	0	*	0	*	53	43	*	10	96	85			0		0		53	43		10	96
2739478	2739478	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	03	2021	kindergarten												96												96
2739636	2739636	CT	school	904590	1430011	Torrington School District	90459001211	1431311	Vogel-Wetmore School	Public Schools	Regular School	No	Elementary	KG	03	2021	kindergarten												96												96
2739874	2739874	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	kindergarten												96												96
2740952	2740952	CT	school	904110	1280011	Simsbury School District	90411000814	1280711	Squadron Line School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1												96												96
2740965	2740965	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1												96												96
2742075	2742075	CT	school	902670	890011	New Britain School District	90267000515	890811	Lincoln Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												96												96
2742288	2742288	CT	school	903390	1130011	Portland School District	90339000711	1130411	Gildersleeve School	Public Schools	Regular School	No	Elementary	02	04	2021	grade_2												96												96
2742460	2742460	CT	school	904320	1350011	Stamford School District	90432000872	1351411	Westover School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												96												96
2742850	2742850	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_3												96												96
2743025	2743025	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_3												96												96
2743900	2743900	CT	school	904320	1350011	Stamford School District	90432000868	1352111	Stillmeadow School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												96												96
2744005	2744005	CT	school	904740	1480011	Wallingford School District	90474000536	1480811	Mary G. Fritz Elementary School of Yalesville	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3												96												96
2744207	2744207	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_3												96												96
2744928	2744928	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												96												96
2745335	2745335	CT	school	904320	1350011	Stamford School District	90432000852	1352011	Davenport Ridge School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												96												96
2745342	2745342	CT	school	904320	1350011	Stamford School District	90432000865	1350911	Roxbury School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												96												96
2745473	2745473	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												96												96
2745841	2745841	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_5												96												96
2746410	2746410	CT	school	902670	890011	New Britain School District	90267000523	891211	Smalley Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												96												96
2746502	2746502	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												96												96

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