schools: enrollments: 4,354 rows where where grade = "grade_9" and state = "CT" sorted by total

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_9" and state = "CT" sorted by total_int

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
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	*
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	*

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