schools: enrollments: 1,444 rows where where grade = "grade_1", state = "CT" and year = 2021 sorted by total

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_1", state = "CT" and year = 2021 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 ▼	total_int
2740330	2740330	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2021	grade_1	*
2740341	2740341	CT	school	901710	570011	Greenwich School District	90171001288	571311	International School At Dundee	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	*
2740383	2740383	CT	school		620011	Hamden School District		620911	Bear Path IIC	Program						2021	grade_1	*
2740391	2740391	CT	school		620011	Hamden School District		621611	Helen Street IIC	Program						2021	grade_1	*
2740428	2740428	CT	school		640011	Hartford School District		648711	iGOAL 1 - Parkville School	Program						2021	grade_1	*
2740429	2740429	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2021	grade_1	*
2740435	2740435	CT	school		640011	Hartford School District	90192001732	645711	iGOAL 1 - M.D. Fox School	Program						2021	grade_1	*
2740436	2740436	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2021	grade_1	*
2740437	2740437	CT	school		640011	Hartford School District		644611	RISE - West Middle School	Program						2021	grade_1	*
2740438	2740438	CT	school		640011	Hartford School District		649511	iGOAL 1 - Breakthrough Magnet School, North	Program						2021	grade_1	*
2740479	2740479	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2021	grade_1	*
2740537	2740537	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2021	grade_1	*
2740539	2740539	CT	school		800011	Meriden School District		800911	STEP - ES	Program						2021	grade_1	*
2740567	2740567	CT	school		830011	Middletown School District	90249001719	830811	ICM - Moody K-2	Program						2021	grade_1	*
2740601	2740601	CT	school	902580	860011	Montville School District	90258000494	860111	Mohegan School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	*
2740629	2740629	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2021	grade_1	*
2740632	2740632	CT	school		890011	New Britain School District		892011	Lincoln KEY Elementary	Program						2021	grade_1	*
2740636	2740636	CT	school		890011	New Britain School District		892111	Smith KEY Elementary	Program						2021	grade_1	*
2740637	2740637	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2021	grade_1	*
2740639	2740639	CT	school		890011	New Britain School District	90267001566	899011	New Britain Transition Center	Program						2021	grade_1	*
2740684	2740684	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2021	grade_1	*
2740692	2740692	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2021	grade_1	*
2740694	2740694	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2021	grade_1	*
2740695	2740695	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2021	grade_1	*
2740698	2740698	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2021	grade_1	*
2740699	2740699	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2021	grade_1	*
2740700	2740700	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2021	grade_1	*
2740706	2740706	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2021	grade_1	*
2740756	2740756	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	*
2740802	2740802	CT	school		1040011	Norwich School District		1040411	Strive Autism Program @ Huntington	Program						2021	grade_1	*
2740803	2740803	CT	school		1040011	Norwich School District		1041211	Strive Program @ Stanton	Program						2021	grade_1	*
2740911	2740911	CT	school		1180011	Ridgefield School District		1181211	District Program FES	Program						2021	grade_1	*
2740937	2740937	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	*
2740941	2740941	CT	school		1260011	Shelton School District		1261311	Alternative Learning Center 2	Program						2021	grade_1	*
2740943	2740943	CT	school		1260011	Shelton School District		1260211	Alternative Learning Center 1	Program						2021	grade_1	*
2740964	2740964	CT	school	904170	1320011	South Windsor School District	90417000821	1320111	Philip R. Smith School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	*
2740978	2740978	CT	school		1310011	Southington School District		1312311	Language Based Classroom II	Program						2021	grade_1	*
2740979	2740979	CT	school		1310011	Southington School District	90423001759	1311811	Language Based Classroom, Multihandicapped	Program						2021	grade_1	*
2740981	2740981	CT	school		1310011	Southington School District		1311111	SPACE	Program						2021	grade_1	*
2741013	2741013	CT	school		1350011	Stamford School District		1351011	Strawberry Hill Special	Program						2021	grade_1	*
2741044	2741044	CT	school		1380011	Stratford School District		1382311	DLC Whitney	Program						2021	grade_1	*
2741045	2741045	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2021	grade_1	*
2741098	2741098	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	*
2741103	2741103	CT	school		1460011	Vernon School District		1461111	Elementary Activities Based Learning Program	Program						2021	grade_1	*
2741114	2741114	CT	school		1480011	Wallingford School District		1480711	STARS Primary Program	Program						2021	grade_1	*
2741115	2741115	CT	school		1480011	Wallingford School District		1481611	WISE Primary Program	Program						2021	grade_1	*
2741152	2741152	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2021	grade_1	*
2741153	2741153	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2021	grade_1	*
2741157	2741157	CT	school		1510011	Waterbury School District		1516911	Gilmartin Scope	Program						2021	grade_1	*
2741164	2741164	CT	school		1510011	Waterbury School District	90483000958	1519011	State Street School	Program						2021	grade_1	*
2741189	2741189	CT	school	904860	1520011	Waterford School District	90486001512	1520711	Quaker Hill Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	*
2741192	2741192	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2021	grade_1	*
2741213	2741213	CT	school		1550011	West Hartford School District	90492001681	1559411	Norfeldt Learning Center	Program						2021	grade_1	*
2741216	2741216	CT	school		1550011	West Hartford School District	90492001790	1559611	Wolcott Learning Center	Program						2021	grade_1	*
2741218	2741218	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2021	grade_1	*
2741219	2741219	CT	school		1550011	West Hartford School District		1559711	Morley Learning Center	Program						2021	grade_1	*
2741256	2741256	CT	school		1580011	Westport School District		1580211	GFS Intensive Resource	Program						2021	grade_1	*
2741259	2741259	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_1	*
2741260	2741260	CT	school	905070	1590011	Wethersfield School District	90507001060	1591011	Charles Wright School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	*
2741284	2741284	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2021	grade_1	*
2741311	2741311	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_1	*
2741321	2741321	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_1	*
2741322	2741322	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2021	grade_1	*
2741324	2741324	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2021	grade_1	*
2739961	2739961	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_1	0	0
2739964	2739964	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_1	0	0
2739965	2739965	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2739966	2739966	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_1	0	0
2739967	2739967	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_1	0	0
2739968	2739968	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_1	0	0
2739970	2739970	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_1	0	0
2739973	2739973	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_1	0	0
2739974	2739974	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_1	0	0
2739975	2739975	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2739976	2739976	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2021	grade_1	0	0
2739982	2739982	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_1	0	0
2739983	2739983	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2739984	2739984	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_1	0	0
2739988	2739988	CT	school	900270	90011	Bethel School District	90027001118	90511	Ralph M. T. Johnson School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_1	0	0
2739989	2739989	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_1	0	0
2739990	2739990	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2739991	2739991	CT	school		90011	Bethel School District		90311	TASK	Program						2021	grade_1	0	0
2739992	2739992	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2021	grade_1	0	0
2739993	2739993	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1	0	0
2739996	2739996	CT	school	900330	110011	Bloomfield School District	90033000033	110511	Metacomet School	Public Schools	Regular School	No	Elementary	03	04	2021	grade_1	0	0
2739997	2739997	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2021	grade_1	0	0
2739998	2739998	CT	school	900330	110011	Bloomfield School District	90033001615	116311	Global Experience Magnet School	Public Schools	Regular School	No	High	06	12	2021	grade_1	0	0
2739999	2739999	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_1	0	0
2740000	2740000	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2740002	2740002	CT	school	900360	120011	Bolton School District	90036000037	126111	Bolton High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2740003	2740003	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2021	grade_1	0	0
2740005	2740005	CT	school		140011	Branford School District	90042000177	148011	Indian Neck School	Program						2021	grade_1	0	0
2740009	2740009	CT	school	900420	140011	Branford School District	90042000041	145111	Francis Walsh Intermediate School	Public Schools	Regular School	No	Middle	05	08	2021	grade_1	0	0
2740010	2740010	CT	school	900420	140011	Branford School District	90042000039	146111	Branford High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2740011	2740011	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2021	grade_1	0	0
2740012	2740012	CT	school		140011	Branford School District		140311	Access Transition Program	Program						2021	grade_1	0	0
2740014	2740014	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1	0	0
2740044	2740044	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	2021	grade_1	0	0
2740045	2740045	CT	school	900450	150011	Bridgeport School District	90045000050	156111	Bassick High School	Public Schools	Regular School	No	High	09	12	2021	grade_1	0	0
2740046	2740046	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_1	0	0

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