schools: enrollments: 1,461 rows where where grade = "grade_7", state = "CT" and year = 2020 sorted by school_state

Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_7", state = "CT" and year = 2020 sorted by school_state_id 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	total	total_int
2770416	2770416	CT	school	905373	9030022	The Woodstock Academy District	90537311223	9036122	The Woodstock Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2770376	2770376	CT	school	905372	9020022	The Gilbert School District	90537201222	9026122	The Gilbert School	Endowed and Incorporated Academies Schools	Regular School	No	High	07	12	2020	grade_7	85	85
2770408	2770408	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9016122	Norwich Free Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2770409	2770409	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9010322	Alternative Pathways to Success	Program	Regular School	No	High	09	12	2020	grade_7	0	0
2770410	2770410	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9010222	Night School	Program	Regular School	No	High	09	12	2020	grade_7	0	0
2770394	2770394	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201139	9002716	Ella T. Grasso Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770403	2770403	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201149	9002616	Platt Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770395	2770395	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201141	9002516	Emmett O'Brien Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770406	2770406	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	2020	grade_7	0	0
2770405	2770405	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201151	9002316	W. F. Kaynor Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770402	2770402	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201148	9002216	Oliver Wolcott Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770400	2770400	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201672	9002116	J. M. Wright Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770401	2770401	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201147	9002016	Norwich Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770392	2770392	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201138	9001916	E. C. Goodwin Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770404	2770404	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_7	0	0
2770396	2770396	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201142	9001716	H. C. Wilcox Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770399	2770399	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201145	9001616	Howell Cheney Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770390	2770390	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770393	2770393	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201140	9001416	Eli Whitney Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770397	2770397	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201143	9001316	H. H. Ellis Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770398	2770398	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201144	9001216	Henry Abbott Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770391	2770391	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201137	9001116	Bullard-Havens Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7	0	0
2770357	2770357	CT	school		3470015	Unified School District #2	90000400479	3470315	Riverview School	State Agency Facilities						2020	grade_7	0	0
2770356	2770356	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2020	grade_7	0	0
2770419	2770419	CT	school		3370015	Department of Mental Health and Addiction Services	90002701922	3370915	Whiting Forensic Hospital	State Agency Facilities						2020	grade_7	0	0
2770418	2770418	CT	school		3370015	Department of Mental Health and Addiction Services	90002701537	3370515	Greater Bridgeport Community Mental Health Center	State Agency Facilities						2020	grade_7	0	0
2770417	2770417	CT	school		3370015	Department of Mental Health and Addiction Services	90002701539	3370215	Connecticut Valley Hospital	State Agency Facilities						2020	grade_7	0	0
2770383	2770383	CT	school		3360015	Unified School District #1	90000301349	3362615	Northern Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770379	2770379	CT	school		3360015	Unified School District #1	90000300849	3362515	York Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770378	2770378	CT	school		3360015	Unified School District #1	90000300844	3362415	Corrigan/Radgowski Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770382	2770382	CT	school		3360015	Unified School District #1	90000300469	3362215	MacDougall/Walker Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770384	2770384	CT	school		3360015	Unified School District #1	90000300454	3361915	Garner Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770387	2770387	CT	school		3360015	Unified School District #1	90000300436	3361515	Willard/Cybulski Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770388	2770388	CT	school		3360015	Unified School District #1	90000300419	3361315	Robinson Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770386	2770386	CT	school		3360015	Unified School District #1	90000300408	3361215	Osborn Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770377	2770377	CT	school		3360015	Unified School District #1	90000300404	3361115	Manson Youth Institution	State Agency Facilities						2020	grade_7	0	0
2770385	2770385	CT	school		3360015	Unified School District #1	90000300361	3360615	Hartford Correctional Center	State Agency Facilities						2020	grade_7	0	0
2770381	2770381	CT	school		3360015	Unified School District #1	90000300347	3360315	Cheshire Correctional Institution	State Agency Facilities						2020	grade_7	0	0
2770380	2770380	CT	school		3360015	Unified School District #1	90000300343	3360115	Bridgeport Correctional Center	State Agency Facilities						2020	grade_7	0	0
2770338	2770338	CT	school	900221	2970013	Capital Preparatory Harbor School District	90022101803	2970113	Capital Preparatory Harbor School	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_7	54	54
2770009	2770009	CT	school	900220	2960013	Stamford Charter School for Excellence District	90022001807	2960113	Stamford Charter School for Excellence	Public Charter Schools	Regular School	Yes	Elementary	PK	05	2020	grade_7	0	0
2770336	2770336	CT	school	900217	2950013	Booker T. Washington Academy District	90021701750	2950113	Booker T. Washington Academy	Public Charter Schools	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
2770354	2770354	CT	school	900219	2940013	Great Oaks Charter School District	90021901782	2940113	Great Oaks Charter School	Public Charter Schools	Regular School	Yes	Secondary	06	11	2020	grade_7	135	135
2769274	2769274	CT	school	900216	2910013	Elm City Montessori School District	90021601683	2910113	Elm City Montessori School	Public Charter Schools	Regular School	Yes	Elementary	PK	05	2020	grade_7	0	0
2769023	2769023	CT	school	900215	2900013	Brass City Charter School District	90021501644	2900113	Brass City Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	07	2020	grade_7	33	33
2770349	2770349	CT	school	900214	2890013	Elm City College Preparatory School District	90021401548	2890113	Elm City College Preparatory School	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_7	68	68
2770334	2770334	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_7	113	113
2769472	2769472	CT	school	900207	2860013	Highville Charter School District	90020700907	2860113	Highville Charter School	Public Charter Schools	Regular School	Yes	Other	PK	12	2020	grade_7	38	38
2770333	2770333	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_7	96	96
2770353	2770353	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_7	84	84
2770415	2770415	CT	school	900031	2820013	Stamford Academy District	90003101405	2826013	Stamford Academy		Regular School	Yes	High	09	12	2020	grade_7	0	0
2769632	2769632	CT	school	900028	2800013	New Beginnings Inc Family Academy District	90002801366	2800113	New Beginnings Inc Family Academy	Public Charter Schools	Regular School	Yes	Elementary	PK	08	2020	grade_7	40	40
2770335	2770335	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_7	91	91
2770407	2770407	CT	school	900018	2720013	Explorations District	90001800834	2726113	Explorations	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_7	0	0
2769960	2769960	CT	school	900016	2700013	Side By Side Charter School District	90001600823	2700113	Side By Side Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	08	2020	grade_7	22	22
2770375	2770375	CT	school	900015	2690013	The Bridge Academy District	90001500809	2696113	The Bridge Academy	Public Charter Schools	Regular School	Yes	High	07	12	2020	grade_7	50	50
2770389	2770389	CT	school	900014	2680013	Common Ground High School District	90001400807	2686113	Common Ground High School	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_7	0	0
2770355	2770355	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	2020	grade_7	95	95
2769473	2769473	CT	school	900010	2640013	Integrated Day Charter School District	90001000775	2640113	Integrated Day Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	08	2020	grade_7	40	40
2770350	2770350	CT	school	900009	2630013	Odyssey Community School District	90000900774	2635113	Odyssey Community School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_7	38	38
2769474	2769474	CT	school	900007	2610013	Jumoke Academy District	90000700747	2610113	Jumoke Academy	Public Charter Schools	Regular School	Yes	Other	PK	12	2020	grade_7	66	66
2770343	2770343	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2020	grade_7	*
2770345	2770345	CT	school	901360	2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001530	2536114	Quinebaug Middle College	Regional Education Service Center Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2770344	2770344	CT	school	901360	2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001507	2536014	Arts at the Capitol Theater Magnet School (ACT)	Regional Education Service Center Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2770347	2770347	CT	school	901360	2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001937	2530314	LEAP Alternative High School	Regional Education Service Center Schools	Alternative School	No	High	10	12	2020	grade_7	0	0
2770346	2770346	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)		2530214	Woodstock Academy Consortium Classroom	Program						2020	grade_7	0	0
2770348	2770348	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)		2530114	Regional Transitional Services	Program						2020	grade_7	0	0
2769492	2769492	CT	school	903450	2450014	Learn	90345001617	2456214	Three Rivers Middle College Magnet School	Regional Education Service Center Schools	Regular School	No	High	11	12	2020	grade_7	0	0
2769491	2769491	CT	school	903450	2450014	Learn	90345001606	2456114	Marine Science Magnet High School	Regional Education Service Center Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769490	2769490	CT	school	903450	2450014	Learn	90345001581	2456014	Connecticut River Academy at Goodwin University	Regional Education Service Center Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769487	2769487	CT	school	903450	2450014	Learn	90345001556	2455014	Dual Language & Arts Magnet Middle School		Regular School	No	Middle	06	08	2020	grade_7	50	50
2769486	2769486	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2020	grade_7	0	0
2769481	2769481	CT	school		2450014	Learn		2451514	LEARN Integrated Program at TFS	Program						2020	grade_7	0	0
2769488	2769488	CT	school		2450014	Learn		2451414	LEARN Diagnostic and Wellness Center	Program						2020	grade_7	0	0
2769484	2769484	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2020	grade_7	*
2769489	2769489	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program							2020	grade_7	*
2769494	2769494	CT	school		2450014	Learn	90345001795	2450614	Learn High School	Program						2020	grade_7	0	0
2769493	2769493	CT	school		2450014	Learn	90345001757	2450414	LEARN Transition Academy	Program						2020	grade_7	0	0
2769482	2769482	CT	school	903450	2450014	Learn	90345001627	2450314	Riverside Magnet School at Goodwin University	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769483	2769483	CT	school	903450	2450014	Learn	90345001430	2450214	The Friendship School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	KG	2020	grade_7	0	0
2769485	2769485	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2768974	2768974	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2020	grade_7	*
2768968	2768968	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2020	grade_7	20	20
2768972	2768972	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2020	grade_7	27	27
2768975	2768975	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2020	grade_7	0	0
2768976	2768976	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2020	grade_7	0	0
2768973	2768973	CT	school	900070	2440014	Area Cooperative Educational Services	90007001358	2445114	Thomas Edison Magnet Middle School	Regional Education Service Center Schools	Regular School	No	Middle	06	08	2020	grade_7	240	240
2768971	2768971	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_7	0	0
2768970	2768970	CT	school	900070	2440014	Area Cooperative Educational Services	90007000884	2440314	Wintergreen Interdistrict Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	08	2020	grade_7	47	47
2768969	2768969	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_7	0	0
2768977	2768977	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_7	0	0
2769163	2769163	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2020	grade_7	10	10
2769165	2769165	CT	school		2430014	Cooperative Educational Services	90091001555	2439314	RISE Transitional Program	Program						2020	grade_7	0	0
2769164	2769164	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2020	grade_7	0	0
2769159	2769159	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	grade_7	6	6
2769160	2769160	CT	school		2430014	Cooperative Educational Services	90091001520	2438014	School Readiness	Program						2020	grade_7	0	0
2769162	2769162	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	grade_7	0	0
2769166	2769166	CT	school		2430014	Cooperative Educational Services		2430214	Transition Learning Center	Program						2020	grade_7	0	0
2769161	2769161	CT	school	900910	2430014	Cooperative Educational Services	90091000340	2430114	Six-Six Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	08	2020	grade_7	37	37
2769262	2769262	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2020	grade_7	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]);