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

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_7", state = "CT" and year = 2019 sorted by school_state_type

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
2443020	2443020	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West							2019	grade_7	0	0
2443054	2443054	CT	school	900330	110011	Bloomfield School District	90033001619	116411	Learning Academy at Bloomfield		Alternative School	No	High	09	12	2019	grade_7	0	0
2443164	2443164	CT	school		2410014	Capitol Region Education Council		2411714	Soundbridge@Mountain View Elementary School							2019	grade_7	0	0
2443173	2443173	CT	school		2410014	Capitol Region Education Council		2411514	Soundbridge @ Chippens Hill MS Bristol							2019	grade_7	*
2443176	2443176	CT	school		2410014	Capitol Region Education Council		2419414	IPM @ Plainville High School							2019	grade_7	0	0
2443177	2443177	CT	school		2410014	Capitol Region Education Council		2419614	Lincoln Academy Regional Interdistrict Collaborative							2019	grade_7	0	0
2443191	2443191	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School		Regular School	No	Elementary	04	05	2019	grade_7	0	0
2443198	2443198	CT	school		280011	Colchester School District		280611	School Resilience Program							2019	grade_7	0	0
2443308	2443308	CT	school		2420014	EdAdvance		2420214	Torrington Alternative Program							2019	grade_7	*
2443412	2443412	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School		Regular School	No	Middle	06	08	2019	grade_7	161	161
2443413	2443413	CT	school	901770	590011	Groton School District	90177000326	595211	West Side Middle School		Regular School	No	Middle	06	08	2019	grade_7	175	175
2443464	2443464	CT	school		640011	Hartford School District		640310	Pre-K Integrated - Burr School							2019	grade_7	0	0
2443485	2443485	CT	school		640011	Hartford School District		649811	iGOAL 1 - Moylan School							2019	grade_7	0	0
2443487	2443487	CT	school		640011	Hartford School District		645911	RISE - M.D. Fox School							2019	grade_7	7	7
2443495	2443495	CT	school		640011	Hartford School District		648911	iGOAL 1 - McDonough Middle School							2019	grade_7	7	7
2443500	2443500	CT	school	901920	640011	Hartford School District	90192001574	647211	HPHS Engineering and Green Technology Academy		Regular School	No	High	09	12	2019	grade_7	0	0
2443501	2443501	CT	school	901920	640011	Hartford School District	90192001576	647411	HPHS Law and Government Academy		Regular School	No	High	09	12	2019	grade_7	0	0
2443502	2443502	CT	school	901920	640011	Hartford School District	90192001559	647511	HPHS Nursing and Health Sciences Academy		Regular School	No	High	09	12	2019	grade_7	0	0
2443503	2443503	CT	school	901920	640011	Hartford School District	90192001552	647611	High School, Inc.		Regular School	No	High	09	12	2019	grade_7	0	0
2443504	2443504	CT	school	901920	640011	Hartford School District	90192001562	647711	Journalism and Media Academy		Regular School	No	High	09	12	2019	grade_7	0	0
2443510	2443510	CT	school		640011	Hartford School District		645011	iGOAL 2 - Weaver High School							2019	grade_7	0	0
2443511	2443511	CT	school	901920	640011	Hartford School District	90192001522	646011	Culinary Arts Academy at Weaver High School		Regular School	No	High	11	12	2019	grade_7	0	0
2443512	2443512	CT	school	901920	640011	Hartford School District	90192001650	643911	Capital Community College Magnet Academy		Regular School	No	High	12	12	2019	grade_7	0	0
2443533	2443533	CT	school		2450014	Learn		2450814	Learn SAILS Middle School Program							2019	grade_7	*
2443534	2443534	CT	school	903450	2450014	Learn	90345001556	2455014	Dual Language & Arts Magnet Middle School		Regular School	No	Middle	06	08	2019	grade_7	43	43
2443535	2443535	CT	school		2450014	Learn		2451214	Learn ABA Program at Center School							2019	grade_7	*
2443536	2443536	CT	school		2450014	Learn		2450514	Learn Pathways Program							2019	grade_7	0	0
2443547	2443547	CT	school	902160	720011	Ledyard School District	90216000400	720111	Ledyard Center School		Regular School	No	Elementary	KG	06	2019	grade_7	0	0
2443558	2443558	CT	school	902280	760011	Madison School District	90228000414	760211	Island Avenue Elementary School		Regular School	No	Elementary	KG	04	2019	grade_7	0	0
2443568	2443568	CT	school	902310	770011	Manchester School District	90231000431	771411	Washington School		Regular School	No	Elementary	KG	04	2019	grade_7	0	0
2443574	2443574	CT	school		770011	Manchester School District		771111	Elementary Site 2							2019	grade_7	0	0
2443601	2443601	CT	school		800011	Meriden School District		802311	SOAR - LMS							2019	grade_7	*
2443743	2443743	CT	school		930011	New Haven School District		938011	Lulac							2019	grade_7	0	0
2443952	2443952	CT	school	903539	2170012	Regional School District 17	90353900758	2170112	Haddam Elementary School		Regular School	No	Elementary	KG	04	2019	grade_7	0	0
2444056	2444056	CT	school		1340011	Stafford School District		1340211	Stafford Tutoring Program							2019	grade_7	0	0
2444084	2444084	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_7	0	0
2444085	2444085	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_7	0	0
2444088	2444088	CT	school	904380	1370011	Stonington School District	90438000882	1370411	West Broad Street School		Regular School	No	Elementary	03	04	2019	grade_7	0	0
2444089	2444089	CT	school	904380	1370011	Stonington School District	90438000879	1375111	Pawcatuck Middle School		Regular School	No	Middle	05	08	2019	grade_7	73	73
2444132	2444132	CT	school		1430011	Torrington School District		1432211	East TPS - PreK - Reg Ed							2019	grade_7	0	0
2444162	2444162	CT	school		1460011	Vernon School District		1460911	First Step							2019	grade_7	0	0
2444180	2444180	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_7	*
2444184	2444184	CT	school		1480011	Wallingford School District		1480511	Education Enhancement Program							2019	grade_7	0	0
2444219	2444219	CT	school		1510011	Waterbury School District		1510411	B.W. Tinker BDLC							2019	grade_7	0	0
2444225	2444225	CT	school		1510011	Waterbury School District		1516811	Duggan Scope							2019	grade_7	*
2444262	2444262	CT	school		1530011	Watertown School District		1530711	Watertown Transition Program at Post University							2019	grade_7	0	0
2444294	2444294	CT	school		1560011	West Haven School District		1561111	ASD Lab							2019	grade_7	*
2444350	2444350	CT	school	905190	1630011	Windham School District	90519001920	1631311	Windham STEPS Academy		Alternative School	No	High	09	12	2019	grade_7	0	0
2444392	2444392	CT	school	900023	2780013	Trailblazers Academy District	90002300965	2785113	Trailblazers Academy		Regular School	Yes	Middle	06	08	2019	grade_7	44	44
2444448	2444448	CT	school		2190012	Regional School District 19		2190212	PM Panthers							2019	grade_7	0	0
2444450	2444450	CT	school	900031	2820013	Stamford Academy District	90003101405	2826013	Stamford Academy		Regular School	Yes	High	09	12	2019	grade_7	0	0
2444424	2444424	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_7	0	0
2444425	2444425	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_7	0	0
2444426	2444426	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_7	0	0
2444427	2444427	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_7	0	0
2444428	2444428	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_7	0	0
2444429	2444429	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_7	0	0
2444430	2444430	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_7	0	0
2444431	2444431	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_7	0	0
2444432	2444432	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_7	0	0
2444433	2444433	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_7	0	0
2444434	2444434	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_7	0	0
2444435	2444435	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_7	0	0
2444436	2444436	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_7	0	0
2444437	2444437	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_7	0	0
2444438	2444438	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_7	0	0
2444439	2444439	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_7	0	0
2444440	2444440	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_7	0	0
2444411	2444411	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_7	67	67
2444442	2444442	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_7	0	0
2444451	2444451	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_7	0	0
2443005	2443005	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_7	0	0
2443010	2443010	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2019	grade_7	0	0
2443011	2443011	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2019	grade_7	0	0
2443012	2443012	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2019	grade_7	23	23
2443013	2443013	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_7	0	0
2443015	2443015	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2019	grade_7	37	37
2443017	2443017	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2019	grade_7	*
2443018	2443018	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2019	grade_7	0	0
2443019	2443019	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2019	grade_7	0	0
2443021	2443021	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2019	grade_7	0	0
2443023	2443023	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2019	grade_7	0	0
2443030	2443030	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2019	grade_7	0	0
2443031	2443031	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2019	grade_7	0	0
2443037	2443037	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_7	0	0
2443044	2443044	CT	school		90011	Bethel School District		90311	TASK	Program						2019	grade_7	0	0
2443045	2443045	CT	school		90011	Bethel School District		90211	Community Partnership Program	Program						2019	grade_7	0	0
2443048	2443048	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2019	grade_7	*
2443057	2443057	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2019	grade_7	0	0
2443059	2443059	CT	school		140011	Branford School District	90042000177	148011	Indian Neck School	Program						2019	grade_7	0	0
2443065	2443065	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2019	grade_7	0	0
2443091	2443091	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_7	6	6
2443104	2443104	CT	school		150011	Bridgeport School District		152811	The Transition Academy	Program						2019	grade_7	0	0
2443105	2443105	CT	school		170011	Bristol School District	90051001728	172911	BECC Autism	Program						2019	grade_7	0	0
2443113	2443113	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2019	grade_7	0	0
2443114	2443114	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	grade_7	0	0
2443115	2443115	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	grade_7	0	0
2443118	2443118	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2019	grade_7	0	0
2443119	2443119	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2019	grade_7	0	0
2443120	2443120	CT	school		170011	Bristol School District	90051001688	172611	Ivy Drive GOAL	Program						2019	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]);