schools: enrollments: 1,449 rows where where grade = "grade_9", state = "CT" and year = 2019 sorted by school_state

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_9", state = "CT" and year = 2019 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
2447349	2447349	CT	school	905373	9030022	The Woodstock Academy District	90537311223	9036122	The Woodstock Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2019	grade_9	238	238
2447309	2447309	CT	school	905372	9020022	The Gilbert School District	90537201222	9026122	The Gilbert School	Endowed and Incorporated Academies Schools	Regular School	No	High	07	12	2019	grade_9	62	62
2447340	2447340	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9016122	Norwich Free Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2019	grade_9	521	521
2447341	2447341	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9010322	Alternative Pathways to Success	Program	Regular School	No	High	09	12	2019	grade_9	0	0
2447342	2447342	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9010222	Night School	Program	Regular School	No	High	09	12	2019	grade_9	0	0
2447326	2447326	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	2019	grade_9	144	144
2447335	2447335	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	2019	grade_9	236	236
2447327	2447327	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	2019	grade_9	180	180
2447338	2447338	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	2019	grade_9	139	139
2447337	2447337	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	2019	grade_9	216	216
2447334	2447334	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	2019	grade_9	168	168
2447332	2447332	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	2019	grade_9	118	118
2447333	2447333	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	2019	grade_9	169	169
2447324	2447324	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	2019	grade_9	198	198
2447336	2447336	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	2019	grade_9	94	94
2447328	2447328	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	2019	grade_9	211	211
2447331	2447331	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	2019	grade_9	180	180
2447322	2447322	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	2019	grade_9	183	183
2447325	2447325	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	2019	grade_9	192	192
2447329	2447329	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	2019	grade_9	167	167
2447330	2447330	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	2019	grade_9	181	181
2447323	2447323	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	2019	grade_9	205	205
2447311	2447311	CT	school		3470015	Unified School District #2	90000400479	3470315	Riverview School	State Agency Facilities						2019	grade_9	10	10
2447312	2447312	CT	school		3470015	Unified School District #2		3470215	Virtual Academy	Program						2019	grade_9	0	0
2447310	2447310	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2019	grade_9	6	6
2447350	2447350	CT	school		3370015	Department of Mental Health and Addiction Services	90002701539	3370215	Connecticut Valley Hospital	State Agency Facilities						2019	grade_9	0	0
2447317	2447317	CT	school		3360015	Unified School District #1	90000301349	3362615	Northern Correctional Institution	State Agency Facilities						2019	grade_9	0	0
2447314	2447314	CT	school		3360015	Unified School District #1	90000300849	3362515	York Correctional Institution	State Agency Facilities						2019	grade_9	*
2447316	2447316	CT	school		3360015	Unified School District #1	90000300844	3362415	Corrigan/Radgowski Correctional Institution	State Agency Facilities						2019	grade_9	0	0
2447319	2447319	CT	school		3360015	Unified School District #1	90000300469	3362215	MacDougall/Walker Correctional Institution	State Agency Facilities						2019	grade_9	0	0
2447320	2447320	CT	school		3360015	Unified School District #1	90000300436	3361515	Willard/Cybulski Correctional Institution	State Agency Facilities						2019	grade_9	0	0
2447313	2447313	CT	school		3360015	Unified School District #1	90000300404	3361115	Manson Youth Institution	State Agency Facilities						2019	grade_9	54	54
2447318	2447318	CT	school		3360015	Unified School District #1	90000300361	3360615	Hartford Correctional Center	State Agency Facilities						2019	grade_9	0	0
2447315	2447315	CT	school		3360015	Unified School District #1	90000300347	3360315	Cheshire Correctional Institution	State Agency Facilities						2019	grade_9	0	0
2447279	2447279	CT	school	900221	2970013	Capital Preparatory Harbor School District	90022101803	2970113	Capital Preparatory Harbor School	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_9	37	37
2446955	2446955	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	04	2019	grade_9	0	0
2447277	2447277	CT	school	900217	2950013	Booker T. Washington Academy District	90021701750	2950113	Booker T. Washington Academy	Public Charter Schools	Regular School	Yes	Elementary	KG	05	2019	grade_9	0	0
2447288	2447288	CT	school	900219	2940013	Great Oaks Charter School District	90021901782	2940113	Great Oaks Charter School	Public Charter Schools	Regular School	Yes	Middle	06	10	2019	grade_9	68	68
2446216	2446216	CT	school	900216	2910013	Elm City Montessori School District	90021601683	2910113	Elm City Montessori School	Public Charter Schools	Regular School	Yes	Elementary	PK	04	2019	grade_9	0	0
2445964	2445964	CT	school	900215	2900013	Brass City Charter School District	90021501644	2900113	Brass City Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	06	2019	grade_9	0	0
2447284	2447284	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	2019	grade_9	47	47
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
2446415	2446415	CT	school	900207	2860013	Highville Charter School District	90020700907	2860113	Highville Charter School	Public Charter Schools	Regular School	Yes	Other	PK	12	2019	grade_9	19	19
2447274	2447274	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_9	79	79
2447287	2447287	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	2019	grade_9	0	0
2447348	2447348	CT	school	900031	2820013	Stamford Academy District	90003101405	2826013	Stamford Academy		Regular School	Yes	High	09	12	2019	grade_9	38	38
2446580	2446580	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	2019	grade_9	0	0
2447276	2447276	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_9	72	72
2447290	2447290	CT	school	900023	2780013	Trailblazers Academy District	90002300965	2785113	Trailblazers Academy		Regular School	Yes	Middle	06	08	2019	grade_9	0	0
2447339	2447339	CT	school	900018	2720013	Explorations District	90001800834	2726113	Explorations	Public Charter Schools	Regular School	Yes	High	09	12	2019	grade_9	16	16
2446904	2446904	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	2019	grade_9	0	0
2447308	2447308	CT	school	900015	2690013	The Bridge Academy District	90001500809	2696113	The Bridge Academy	Public Charter Schools	Regular School	Yes	High	07	12	2019	grade_9	58	58
2447321	2447321	CT	school	900014	2680013	Common Ground High School District	90001400807	2686113	Common Ground High School	Public Charter Schools	Regular School	Yes	High	09	12	2019	grade_9	70	70
2447289	2447289	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	2019	grade_9	0	0
2446416	2446416	CT	school	900010	2640013	Integrated Day Charter School District	90001000775	2640113	Integrated Day Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	08	2019	grade_9	0	0
2447285	2447285	CT	school	900009	2630013	Odyssey Community School District	90000900774	2635113	Odyssey Community School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2019	grade_9	0	0
2446417	2446417	CT	school	900007	2610013	Jumoke Academy District	90000700747	2610113	Jumoke Academy	Public Charter Schools	Regular School	Yes	Other	PK	12	2019	grade_9	*
2446196	2446196	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)	90136001156	2539014	EastConn Special Education	Program						2019	grade_9	19	19
2446198	2446198	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	2019	grade_9	49	49
2446197	2446197	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	2019	grade_9	31	31
2446199	2446199	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)		2530114	Regional Transitional Services	Program						2019	grade_9	0	0
2446438	2446438	CT	school	903450	2450014	Learn	90345001617	2456214	Three Rivers Middle College Magnet School	Regional Education Service Center Schools	Regular School	No	High	11	12	2019	grade_9	0	0
2446436	2446436	CT	school	903450	2450014	Learn	90345001606	2456114	Marine Science Magnet High School	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_9	67	67
2446435	2446435	CT	school	903450	2450014	Learn	90345001581	2456014	Connecticut River Academy at Goodwin University	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_9	127	127
2446432	2446432	CT	school	903450	2450014	Learn	90345001556	2455014	Dual Language & Arts Magnet Middle School		Regular School	No	Middle	06	08	2019	grade_9	0	0
2446429	2446429	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2019	grade_9	0	0
2446424	2446424	CT	school		2450014	Learn		2451514	LEARN Integrated Program at TFS	Program						2019	grade_9	0	0
2446430	2446430	CT	school		2450014	Learn		2451414	LEARN Diagnostic and Wellness Center	Program						2019	grade_9	0	0
2446433	2446433	CT	school		2450014	Learn		2451214	Learn ABA Program at Center School							2019	grade_9	*
2446428	2446428	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2019	grade_9	0	0
2446431	2446431	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program							2019	grade_9	0	0
2446437	2446437	CT	school		2450014	Learn	90345001795	2450614	Learn High School	Program						2019	grade_9	0	0
2446434	2446434	CT	school		2450014	Learn		2450514	Learn Pathways Program							2019	grade_9	*
2446439	2446439	CT	school		2450014	Learn	90345001757	2450414	LEARN Transition Academy	Program						2019	grade_9	0	0
2446425	2446425	CT	school	903450	2450014	Learn	90345001627	2450314	Riverside Magnet School at Goodwin University	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_9	0	0
2446426	2446426	CT	school	903450	2450014	Learn	90345001430	2450214	The Friendship School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	KG	2019	grade_9	0	0
2446427	2446427	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2019	grade_9	0	0
2445915	2445915	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2019	grade_9	*
2445910	2445910	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2019	grade_9	0	0
2445913	2445913	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2019	grade_9	0	0
2445918	2445918	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West							2019	grade_9	*
2445916	2445916	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2019	grade_9	17	17
2445917	2445917	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2019	grade_9	29	29
2445914	2445914	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	2019	grade_9	0	0
2445912	2445912	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	2019	grade_9	0	0
2445911	2445911	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_9	0	0
2445919	2445919	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2019	grade_9	0	0
2446102	2446102	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2019	grade_9	22	22
2446104	2446104	CT	school		2430014	Cooperative Educational Services	90091001555	2439314	RISE Transitional Program	Program						2019	grade_9	0	0
2446103	2446103	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2019	grade_9	14	14
2446099	2446099	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2019	grade_9	0	0
2446100	2446100	CT	school		2430014	Cooperative Educational Services	90091001520	2438014	School Readiness	Program						2019	grade_9	0	0
2446105	2446105	CT	school		2430014	Cooperative Educational Services		2430214	Transition Learning Center	Program						2019	grade_9	0	0
2446101	2446101	CT	school	900910	2430014	Cooperative Educational Services	90091000340	2430114	Six-Six Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	08	2019	grade_9	0	0
2446204	2446204	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2019	grade_9	*
2446203	2446203	CT	school		2420014	EdAdvance	90351200575	2428014	EdAdvance Headstart	Program						2019	grade_9	0	0
2446207	2446207	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_9	*
2446208	2446208	CT	school		2420014	EdAdvance		2420314	Steps-North Expelled Student	Program						2019	grade_9	0	0
2446206	2446206	CT	school		2420014	EdAdvance		2420214	Torrington Alternative Program							2019	grade_9	*
2446205	2446205	CT	school		2420014	EdAdvance		2420114	Steps	Program						2019	grade_9	*

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