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
2452354	2452354	CT	school	902550	850011	Monroe School District	90255000489	856111	Masuk High School	Public Schools	Regular School	No	High	09	12	2019	pk_12_total	801	22	88	0	52	0	34	503	494	6	112	997	801	22	88	0	52	0	34	503	494	6	112	997
2778375	2778375	CT	school	902550	850011	Monroe School District	90255000489	856111	Masuk High School	Public Schools	Regular School	No	High	09	12	2020	pk_12_total	798	*	102	*	48	0	29	492	505	9	116	997	798		102		48	0	29	492	505	9	116	997
2778018	2778018	CT	school	901320	450011	East Lyme School District	90132000223	456111	East Lyme High School	Public Schools	Regular School	No	High	09	12	2020	pk_12_total	767	12	70	*	87	*	57	498	498	6	115	996	767	12	70		87		57	498	498	6	115	996
2452488	2452488	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2019	pk_12_total	729	*	153	*	40	0	44	537	*	29	150	991	729		153		40	0	44	537		29	150	991
2433648	2433648	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten												99												99
2434026	2434026	CT	school	904740	1480011	Wallingford School District	90474000952	1480911	Evarts C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten												99												99
2434423	2434423	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_1												99												99
2434527	2434527	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1												99												99
2435299	2435299	CT	school	904050	1260011	Shelton School District	90405000798	1260511	Elizabeth Shelton School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_1												99												99
2436346	2436346	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2												99												99
2436734	2436734	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2												99												99
2438462	2438462	CT	school	904890	1530011	Watertown School District	90489001005	1530411	Polk School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_3												99												99
2438518	2438518	CT	school	905040	1580011	Westport School District	90504001056	1580711	Long Lots School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_3												99												99
2440405	2440405	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5												99												99
2440446	2440446	CT	school	901530	510011	Fairfield School District	90153000269	511311	Sherman School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5												99												99
2440887	2440887	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5												99												99
2441372	2441372	CT	school	904920	1550011	West Hartford School District	90492001014	1550611	Duffy School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5												99												99
2441477	2441477	CT	school	905370	1690011	Woodstock School District	90537000573	1695111	Woodstock Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_5												99												99
2441478	2441478	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	grade_5												99												99
2442287	2442287	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_6												99												99
2443869	2443869	CT	school	903180	1060011	Old Saybrook School District	90318000007	1065211	Old Saybrook Middle School	Public Schools	Regular School	No	Middle	04	08	2019	grade_7												99												99
2444697	2444697	CT	school	901110	370011	Derby School District	90111001578	375011	Derby Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_8												99												99
2450342	2450342	CT	school	900450	150011	Bridgeport School District	90045001639	150811	Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School	Public Schools	Regular School	No	High	09	12	2019	grade_12												99												99
2450458	2450458	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2019	grade_12												99												99
2452286	2452286	CT	school		800011	Meriden School District		802611	PRIDE	Program						2019	pk_12_total	33	8	50	0	*	0	*	77	22	0	*	99	33	8	50	0		0		77	22	0		99
2759749	2759749	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	KG	05	2020	kindergarten												99												99
2760757	2760757	CT	school	902310	770011	Manchester School District	90231000430	771311	Waddell School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1												99												99
2761255	2761255	CT	school	904320	1350011	Stamford School District	90432000868	1352111	Stillmeadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1												99												99
2761354	2761354	CT	school	904740	1480011	Wallingford School District	90474000952	1480911	Evarts C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1												99												99
2761844	2761844	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_2												99												99
2762664	2762664	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2												99												99
2762716	2762716	CT	school	904320	1350011	Stamford School District	90432000868	1352111	Stillmeadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2												99												99
2762794	2762794	CT	school	904620	1440011	Trumbull School District	90462000934	1440311	Middlebrook School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2												99												99
2763118	2763118	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_3												99												99
2763294	2763294	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_3												99												99
2763305	2763305	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_3												99												99
2763701	2763701	CT	school	902400	800011	Meriden School District	90240000443	800411	Israel Putnam School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3												99												99
2764007	2764007	CT	school	903390	1130011	Portland School District	90339000711	1130411	Gildersleeve School	Public Schools	Regular School	No	Elementary	02	04	2020	grade_3												99												99
2764645	2764645	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_4												99												99
2764801	2764801	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4												99												99
2765275	2765275	CT	school	902700	900011	New Canaan School District	90270000534	900311	West School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_4												99												99
2765398	2765398	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4												99												99
2765640	2765640	CT	school	904320	1350011	Stamford School District	90432001916	1350711	Strawberry Hill an ext. of Rogers International	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_4												99												99
2766143	2766143	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_5												99												99
2768224	2768224	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_6												99												99
2768391	2768391	CT	school	903390	1130011	Portland School District	90339001393	1130511	Brownstone Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_6												99												99
2768418	2768418	CT	school	903535	2130012	Regional School District 13	90353500742	2130412	Middlefield Memorial School	Regional Schools	Regular School	No	Middle	04	06	2020	grade_6												99												99
2768872	2768872	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_6												99												99
2768873	2768873	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_6												99												99
2769043	2769043	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_7												99												99
2771146	2771146	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8												99												99
2771979	2771979	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2020	grade_9												99												99
2773509	2773509	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	2020	grade_10												99												99
2773555	2773555	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2020	grade_10												99												99
2774695	2774695	CT	school	905250	1650011	Windsor Locks School District	90525001100	1656111	Windsor Locks High School	Public Schools	Regular School	No	High	09	12	2020	grade_10												99												99
2774903	2774903	CT	school	900450	150011	Bridgeport School District	90045001633	151511	Information Technology & Software Engineering Magnet High School	Public Schools	Regular School	No	High	09	12	2020	grade_11												99												99
2775698	2775698	CT	school	903390	1130011	Portland School District	90339000712	1136111	Portland High School	Public Schools	Regular School	No	High	09	12	2020	grade_11												99												99
2777313	2777313	CT	school	904290	1340011	Stafford School District	90429000845	1346111	Stafford High School	Public Schools	Regular School	No	High	09	12	2020	grade_12												99												99
2739871	2739871	CT	school	905310	1670011	Woodbridge School District	90531001611	1670311	Beecher Road School	Public Schools	Regular School	No	Elementary	PK	06	2021	kindergarten												99												99
2741088	2741088	CT	school	904620	1440011	Trumbull School District	90462001469	1441011	Frenchtown Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												99												99
2741787	2741787	CT	school	901710	570011	Greenwich School District	90171000304	570711	North Mianus School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_2												99												99
2741973	2741973	CT	school	902400	800011	Meriden School District	90240000442	800311	Hanover School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_2												99												99
2742332	2742332	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2021	grade_2												99												99
2742557	2742557	CT	school	904740	1480011	Wallingford School District	90474000957	1480111	Moses Y. Beach School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_2												99												99
2743422	2743422	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												99												99
2743539	2743539	CT	school	902700	900011	New Canaan School District	90270000530	900411	East School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3												99												99
2743904	2743904	CT	school	904320	1350011	Stamford School District	90432000872	1351411	Westover School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												99												99
2743978	2743978	CT	school	904620	1440011	Trumbull School District	90462000934	1440311	Middlebrook School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												99												99
2746105	2746105	CT	school	901620	540011	Glastonbury School District	90162001447	540911	Nayaug Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												99												99
2747250	2747250	CT	school	900450	150011	Bridgeport School District	90045000001	151011	Luis Munoz Marin School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_6												99												99
2747275	2747275	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_6												99												99
2749111	2749111	CT	school	901920	640011	Hartford School District	90192000381	641911	Milner Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_7												99												99
2749984	2749984	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_7												99												99
2777957	2777957	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	pk_12_total	335	88	484	*	45	0	*	506	483	154	170	989	335	88	484		45	0		506	483	154	170	989
2758410	2758410	CT	school	904590	1430011	Torrington School District	90459000925	1435111	Torrington Middle School	Public Schools	Regular School	No	Middle	06	08	2021	pk_12_total	550	40	318	*	44	*	34	516	*	77	170	988	550	40	318		44		34	516		77	170	988
2452833	2452833	CT	school	904590	1430011	Torrington School District	90459000925	1435111	Torrington Middle School	Public Schools	Regular School	No	Middle	06	08	2019	pk_12_total	601	42	259	*	42	*	37	516	469	64	185	985	601	42	259		42		37	516	469	64	185	985
2757697	2757697	CT	school	901770	590011	Groton School District	90177000318	596111	Robert E. Fitch High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	515	92	205	*	62	*	94	509	473	29	149	982	515	92	205		62		94	509	473	29	149	982
2452718	2452718	CT	school	904170	1320011	South Windsor School District	90417000827	1325111	Timothy Edwards School	Public Schools	Regular School	No	Middle	06	08	2019	pk_12_total	563	62	80	0	220	*	*	499	482	14	124	981	563	62	80	0	220			499	482	14	124	981
2778138	2778138	CT	school	901770	590011	Groton School District	90177000318	596111	Robert E. Fitch High School	Public Schools	Regular School	No	High	09	12	2020	pk_12_total	532	89	200	*	62	*	83	509	472	28	150	981	532	89	200		62		83	509	472	28	150	981
2778323	2778323	CT	school	902400	800011	Meriden School District	90240000449	806211	Orville H. Platt High School	Public Schools	Regular School	No	High	09	12	2020	pk_12_total	227	122	578	*	*	0	28	488	492	124	165	980	227	122	578			0	28	488	492	124	165	980
2433124	2433124	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	kindergarten												98												98
2433921	2433921	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2019	kindergarten												98												98
2434045	2434045	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												98												98
2434051	2434051	CT	school	904830	1510011	Waterbury School District	90483000977	1510711	H. S. Chase School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												98												98
2434312	2434312	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_1												98												98
2434414	2434414	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_1												98												98
2434901	2434901	CT	school	902400	800011	Meriden School District	90240000451	801011	Thomas Hooker School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												98												98
2434963	2434963	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_1												98												98
2436429	2436429	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2												98												98
2436820	2436820	CT	school	904320	1350011	Stamford School District	90432000858	1351211	Julia A. Stark School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2												98												98
2436899	2436899	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2												98												98
2438275	2438275	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_3												98												98
2439646	2439646	CT	school	904050	1260011	Shelton School District	90405000798	1260511	Elizabeth Shelton School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4												98												98
2439719	2439719	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4												98												98
2439841	2439841	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4												98												98
2440013	2440013	CT	school	905220	1640011	Windsor School District	90522001087	1640111	Clover Street School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_4												98												98
2440631	2440631	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2019	grade_5												98												98
2441121	2441121	CT	school	904170	1320011	South Windsor School District	90417000822	1320711	Eli Terry School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5												98												98
2441133	2441133	CT	school	904230	1310011	Southington School District	90423000829	1311511	Derynoski Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5												98												98
2442044	2442044	CT	school	901920	640011	Hartford School District	90192000371	641211	McDonough Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_6												98												98

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