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

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_9", 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
2751518	2751518	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_9	*
2751519	2751519	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_9	*
2751543	2751543	CT	school		90011	Bethel School District		90311	TASK	Program						2021	grade_9	*
2751595	2751595	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2021	grade_9	*
2751623	2751623	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2021	grade_9	*
2751637	2751637	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2021	grade_9	*
2751660	2751660	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2021	grade_9	*
2751671	2751671	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2021	grade_9	*
2751672	2751672	CT	school		2410014	Capitol Region Education Council		2411914	CREC Impact Academy	Program						2021	grade_9	*
2751686	2751686	CT	school		250011	Cheshire School District	90075001682	250911	Humiston Alternative School	Program						2021	grade_9	*
2751699	2751699	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2021	grade_9	*
2751704	2751704	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2021	grade_9	*
2751763	2751763	CT	school		420011	East Hampton School District	90123001514	429011	The Learning Center at East Hampton	Program						2021	grade_9	*
2751792	2751792	CT	school		450011	East Lyme School District	90132001760	450611	Coastal Connections	Program						2021	grade_9	*
2751801	2751801	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	09	12	2021	grade_9	*
2751803	2751803	CT	school		2530014	Eastern Connecticut Regional Educational Service Center (EASTCONN)		2530214	Woodstock Academy Consortium Classroom	Program						2021	grade_9	*
2751810	2751810	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2021	grade_9	*
2751833	2751833	CT	school		490011	Enfield School District		492411	Eagle Academy	Program						2021	grade_9	*
2751841	2751841	CT	school		490011	Enfield School District		492311	Enfield Alternative Education Program	Program						2021	grade_9	*
2751864	2751864	CT	school		510011	Fairfield School District		510311	Walter Fitzgerald Campus	Program						2021	grade_9	*
2751882	2751882	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2021	grade_9	*
2751919	2751919	CT	school		590011	Groton School District		590611	Apex Academy	Program						2021	grade_9	*
2752003	2752003	CT	school		640011	Hartford School District		640910	New Visions	Program						2021	grade_9	*
2752008	2752008	CT	school		640011	Hartford School District	90192001770	648311	RISE - Bulkeley High School	Program						2021	grade_9	*
2752013	2752013	CT	school		640011	Hartford School District	90192001660	644911	iGOAL 1 - HPHS	Program						2021	grade_9	*
2752031	2752031	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2021	grade_9	*
2752032	2752032	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2021	grade_9	*
2752073	2752073	CT	school		770011	Manchester School District	90231001717	770711	New Horizons	Program						2021	grade_9	*
2752101	2752101	CT	school		800011	Meriden School District		801411	Success Academy	Program						2021	grade_9	*
2752103	2752103	CT	school		800011	Meriden School District		801911	TLC - PHS	Program						2021	grade_9	*
2752104	2752104	CT	school		800011	Meriden School District		801611	TSC - MHS	Program						2021	grade_9	*
2752126	2752126	CT	school		830011	Middletown School District	90249001765	831711	Virtual Learning Academy - MHS	Program						2021	grade_9	*
2752144	2752144	CT	school		840011	Milford School District	90252001679	840311	The Academy	Program						2021	grade_9	*
2752159	2752159	CT	school		860011	Montville School District	90258001481	869011	Palmer Academy	Program						2021	grade_9	*
2752263	2752263	CT	school		930011	New Haven School District		930110	Gateway to College Program	Program						2021	grade_9	*
2752267	2752267	CT	school		930011	New Haven School District		930210	James Hillhouse Self Contained MD	Program						2021	grade_9	*
2752343	2752343	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2021	grade_9	*
2752426	2752426	CT	school	903535	2130012	Regional School District 13	90353500737	2136112	Coginchaug Regional High School	Regional Schools	Regular School	No	High	08	12	2021	grade_9	*
2752470	2752470	CT	school		1180011	Ridgefield School District	90381001763	1188011	Alternative High School	Program						2021	grade_9	*
2752542	2752542	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2021	grade_9	*
2752544	2752544	CT	school		1310011	Southington School District	90423001665	1310111	The Karen Smith Academy	Program						2021	grade_9	*
2752585	2752585	CT	school		1370011	Stonington School District		1370911	The Learning Annex	Program						2021	grade_9	*
2752604	2752604	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2021	grade_9	*
2752605	2752605	CT	school		1380011	Stratford School District		1380111	BRIDGES 9-12	Program						2021	grade_9	*
2752608	2752608	CT	school		1380011	Stratford School District	90444001710	1382011	STEPS 9-12	Program						2021	grade_9	*
2752618	2752618	CT	school		1400011	Thomaston School District		1400311	PATHS	Program						2021	grade_9	*
2752679	2752679	CT	school		1480011	Wallingford School District		1481711	Inspire High School	Program						2021	grade_9	*
2752775	2752775	CT	school		1550011	West Hartford School District	90492001791	1557311	REACH	Program						2021	grade_9	*
2752778	2752778	CT	school		1550011	West Hartford School District	90492001600	1559211	Strive-West Hartford	Program						2021	grade_9	*
2752789	2752789	CT	school		1560011	West Haven School District		1560711	Blended	Program						2021	grade_9	*
2752790	2752790	CT	school		1560011	West Haven School District		1560511	Blended (Molloy)	Program						2021	grade_9	*
2752826	2752826	CT	school		1610011	Wilton School District		1610211	Genesis	Program						2021	grade_9	*
2752856	2752856	CT	school		1640011	Windsor School District		1640311	Spark	Program						2021	grade_9	*
2752865	2752865	CT	school		1660011	Wolcott School District	90528001772	1660411	Phoenix Program	Program						2021	grade_9	*
2752877	2752877	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2021	grade_9	*
2752898	2752898	CT	school		3470015	Unified School District #2	90000400475	3470115	Children's Place School	State Agency Facilities						2021	grade_9	*
2752908	2752908	CT	school		2070012	Regional School District 07	90372001401	2079212	Links	Program						2021	grade_9	*
2752909	2752909	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2021	grade_9	*
2752911	2752911	CT	school		2070012	Regional School District 07	90372001402	2079312	STEP	Program						2021	grade_9	*
2752919	2752919	CT	school		3360015	Unified School District #1	90000300844	3362415	Corrigan/Radgowski Correctional Institution	State Agency Facilities						2021	grade_9	*
2752920	2752920	CT	school		3360015	Unified School District #1	90000300849	3362515	York Correctional Institution	State Agency Facilities						2021	grade_9	*
2752946	2752946	CT	school		3370015	Department of Mental Health and Addiction Services	90002701922	3370915	Whiting Forensic Hospital	State Agency Facilities						2021	grade_9	*
2751512	2751512	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9	0	0
2751513	2751513	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_9	0	0
2751514	2751514	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9	0	0
2751515	2751515	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
2751516	2751516	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_9	0	0
2751520	2751520	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_9	0	0
2751521	2751521	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_9	0	0
2751522	2751522	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_9	0	0
2751523	2751523	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9	0	0
2751524	2751524	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9	0	0
2751525	2751525	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_9	0	0
2751526	2751526	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_9	0	0
2751528	2751528	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2021	grade_9	0	0
2751529	2751529	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
2751530	2751530	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2021	grade_9	0	0
2751531	2751531	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9	0	0
2751532	2751532	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9	0	0
2751533	2751533	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9	0	0
2751534	2751534	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_9	0	0
2751536	2751536	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_9	0	0
2751537	2751537	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9	0	0
2751538	2751538	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_9	0	0
2751539	2751539	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_9	0	0
2751540	2751540	CT	school	900270	90011	Bethel School District	90027001118	90511	Ralph M. T. Johnson School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_9	0	0
2751541	2751541	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_9	0	0
2751544	2751544	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2021	grade_9	0	0
2751545	2751545	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	0	0
2751546	2751546	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_9	0	0
2751547	2751547	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2021	grade_9	0	0
2751548	2751548	CT	school	900330	110011	Bloomfield School District	90033000033	110511	Metacomet School	Public Schools	Regular School	No	Elementary	03	04	2021	grade_9	0	0
2751549	2751549	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2021	grade_9	0	0
2751551	2751551	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_9	0	0
2751553	2751553	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_9	0	0
2751555	2751555	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2021	grade_9	0	0
2751556	2751556	CT	school	900390	130011	Bozrah School District	90039000038	130111	Fields Memorial School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_9	0	0
2751557	2751557	CT	school		140011	Branford School District	90042000177	148011	Indian Neck School	Program						2021	grade_9	0	0
2751558	2751558	CT	school	900420	140011	Branford School District	90042001119	141611	John B. Sliney School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9	0	0
2751559	2751559	CT	school	900420	140011	Branford School District	90042000043	141511	Mary R. Tisko School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9	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]);