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

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_9", state = "CT" and year = 2019 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
2445908	2445908	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2019	grade_9	*
2445909	2445909	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2019	grade_9	*
2445915	2445915	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2019	grade_9	*
2445918	2445918	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West							2019	grade_9	*
2445952	2445952	CT	school	900330	110011	Bloomfield School District	90033001619	116411	Learning Academy at Bloomfield		Alternative School	No	High	09	12	2019	grade_9	*
2445963	2445963	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2019	grade_9	*
2445989	2445989	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_9	*
2446034	2446034	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2019	grade_9	*
2446061	2446061	CT	school		2410014	Capitol Region Education Council	90070001510	2419514	River Street School Birken Campus	Program						2019	grade_9	*
2446065	2446065	CT	school		2410014	Capitol Region Education Council	90070001489	2419214	Farmington Valley Regional Diagnostic Center	Program						2019	grade_9	*
2446074	2446074	CT	school		2410014	Capitol Region Education Council		2419414	IPM @ Plainville High School							2019	grade_9	*
2446085	2446085	CT	school		250011	Cheshire School District	90075001682	250911	Humiston Alternative School	Program						2019	grade_9	*
2446096	2446096	CT	school		280011	Colchester School District		280611	School Resilience Program							2019	grade_9	*
2446147	2446147	CT	school		370011	Derby School District		370511	RAISE Academy	Program						2019	grade_9	*
2446160	2446160	CT	school		420011	East Hampton School District	90123001514	429011	The Learning Center at East Hampton	Program						2019	grade_9	*
2446189	2446189	CT	school		450011	East Lyme School District	90132001760	450611	Coastal Connections	Program						2019	grade_9	*
2446204	2446204	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2019	grade_9	*
2446205	2446205	CT	school		2420014	EdAdvance		2420114	Steps	Program						2019	grade_9	*
2446206	2446206	CT	school		2420014	EdAdvance		2420214	Torrington Alternative Program							2019	grade_9	*
2446207	2446207	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_9	*
2446256	2446256	CT	school		510011	Fairfield School District		510311	Walter Fitzgerald Campus	Program						2019	grade_9	*
2446274	2446274	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2019	grade_9	*
2446302	2446302	CT	school	901740	580011	Griswold School District	90174001721	580111	Griswold Alternative School	Public Schools	Alternative School	No	High	09	12	2019	grade_9	*
2446312	2446312	CT	school		590011	Groton School District		590611	Apex Academy	Program						2019	grade_9	*
2446313	2446313	CT	school		590011	Groton School District		590211	New Beginnings Alternative Program	Program						2019	grade_9	*
2446321	2446321	CT	school	901800	600011	Guilford School District	90180000331	605111	E. C. Adams Middle School	Public Schools	Regular School	No	Middle	07	09	2019	grade_9	*
2446408	2446408	CT	school		640011	Hartford School District		645011	iGOAL 2 - Weaver High School							2019	grade_9	*
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	*
2446433	2446433	CT	school		2450014	Learn		2451214	Learn ABA Program at Center School							2019	grade_9	*
2446434	2446434	CT	school		2450014	Learn		2450514	Learn Pathways Program							2019	grade_9	*
2446499	2446499	CT	school		800011	Meriden School District		802311	SOAR - LMS							2019	grade_9	*
2446507	2446507	CT	school		800011	Meriden School District		802511	SOAR - PHS	Program						2019	grade_9	*
2446508	2446508	CT	school		800011	Meriden School District		801911	TLC - PHS	Program						2019	grade_9	*
2446531	2446531	CT	school		830011	Middletown School District	90249001722	831811	MHS - Alternative Education Program 1	Program						2019	grade_9	*
2446532	2446532	CT	school		830011	Middletown School District		832211	MHS- Alternative Education Program 3	Program						2019	grade_9	*
2446534	2446534	CT	school		830011	Middletown School District	90249001765	831711	Virtual Learning Academy - MHS	Program						2019	grade_9	*
2446668	2446668	CT	school		930011	New Haven School District		930110	Gateway to College Program	Program						2019	grade_9	*
2446672	2446672	CT	school		930011	New Haven School District		930210	James Hillhouse Self Contained MD	Program						2019	grade_9	*
2446764	2446764	CT	school		1040011	Norwich School District	90312001622	1049211	Virtual Learning Academy	Program						2019	grade_9	*
2446847	2446847	CT	school		2160012	Regional School District 16	90353801747	2160412	WRHS Alternative Education Program	Program						2019	grade_9	*
2446874	2446874	CT	school		1180011	Ridgefield School District	90381001763	1188011	Alternative High School	Program						2019	grade_9	*
2446923	2446923	CT	school	904170	1320011	South Windsor School District	90417000826	1320311	Alternative Education Program	Program	Regular School	No	High	09	12	2019	grade_9	*
2446944	2446944	CT	school		1310011	Southington School District	90423001649	1311211	Collaborative Learning Program (CLP)	Program						2019	grade_9	*
2446954	2446954	CT	school		1340011	Stafford School District		1340211	Stafford Tutoring Program							2019	grade_9	*
2447008	2447008	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2019	grade_9	*
2447010	2447010	CT	school		1380011	Stratford School District	90444001671	1380711	High School Sails	Program						2019	grade_9	*
2447011	2447011	CT	school		1380011	Stratford School District	90444001710	1382011	STEPS 9-12	Program						2019	grade_9	*
2447021	2447021	CT	school		1400011	Thomaston School District		1400311	PATHS	Program						2019	grade_9	*
2447049	2447049	CT	school		1440011	Trumbull School District	90462001762	1440511	REACH	Program						2019	grade_9	*
2447050	2447050	CT	school		1440011	Trumbull School District	90462001669	1440211	Trumbull Alternative School	Program						2019	grade_9	*
2447078	2447078	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_9	*
2447082	2447082	CT	school		1480011	Wallingford School District		1480511	Education Enhancement Program							2019	grade_9	*
2447142	2447142	CT	school		1510011	Waterbury School District		1514511	Wilby Autism	Program						2019	grade_9	*
2447180	2447180	CT	school		1550011	West Hartford School District	90492001791	1557311	REACH	Program						2019	grade_9	*
2447197	2447197	CT	school		1560011	West Haven School District		1560511	Blended (Molloy)	Program						2019	grade_9	*
2447248	2447248	CT	school	905190	1630011	Windham School District	90519001920	1631311	Windham STEPS Academy		Alternative School	No	High	09	12	2019	grade_9	*
2447299	2447299	CT	school		2070012	Regional School District 07	90372001401	2079212	Links	Program						2019	grade_9	*
2447314	2447314	CT	school		3360015	Unified School District #1	90000300849	3362515	York Correctional Institution	State Agency Facilities						2019	grade_9	*
2447345	2447345	CT	school		2190012	Regional School District 19	90000501729	2190112	E.O. Smith High School at the Depot Campus	Program						2019	grade_9	*
2445902	2445902	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9	0	0
2445903	2445903	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_9	0	0
2445904	2445904	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9	0	0
2445905	2445905	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_9	0	0
2445906	2445906	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_9	0	0
2445910	2445910	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						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
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
2445913	2445913	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2019	grade_9	0	0
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
2445919	2445919	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2019	grade_9	0	0
2445920	2445920	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_9	0	0
2445921	2445921	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2019	grade_9	0	0
2445922	2445922	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_9	0	0
2445923	2445923	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_9	0	0
2445924	2445924	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2019	grade_9	0	0
2445925	2445925	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_9	0	0
2445927	2445927	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9	0	0
2445928	2445928	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2019	grade_9	0	0
2445929	2445929	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2019	grade_9	0	0
2445930	2445930	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_9	0	0
2445931	2445931	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_9	0	0
2445932	2445932	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_9	0	0
2445933	2445933	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_9	0	0
2445935	2445935	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_9	0	0
2445936	2445936	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9	0	0
2445937	2445937	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_9	0	0
2445938	2445938	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_9	0	0
2445939	2445939	CT	school	900270	90011	Bethel School District	90027001118	90511	Ralph M. T. Johnson School	Public Schools	Regular School	No	Elementary	04	05	2019	grade_9	0	0
2445940	2445940	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_9	0	0
2445942	2445942	CT	school		90011	Bethel School District		90311	TASK	Program						2019	grade_9	0	0
2445943	2445943	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2019	grade_9	0	0
2445944	2445944	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_9	0	0
2445945	2445945	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_9	0	0
2445946	2445946	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2019	grade_9	0	0
2445947	2445947	CT	school	900330	110011	Bloomfield School District	90033000033	110511	Metacomet School	Public Schools	Regular School	No	Elementary	03	04	2019	grade_9	0	0
2445948	2445948	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_9	0	0
2445950	2445950	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_9	0	0
2445953	2445953	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_9	0	0
2445955	2445955	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2019	grade_9	0	0
2445956	2445956	CT	school	900390	130011	Bozrah School District	90039000038	130111	Fields Memorial School	Public Schools	Regular School	No	Elementary	PK	08	2019	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]);