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

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_4", 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
2438666	2438666	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_4	*
2438701	2438701	CT	school		110011	Bloomfield School District		110111	Steps to Success	Program						2019	grade_4	*
2438767	2438767	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	grade_4	*
2438768	2438768	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	grade_4	*
2438772	2438772	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2019	grade_4	*
2438774	2438774	CT	school		170011	Bristol School District		173711	Hubbell Autism Program	Program						2019	grade_4	*
2438776	2438776	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2019	grade_4	*
2438777	2438777	CT	school		170011	Bristol School District	90051001711	173111	South Side GOAL	Program						2019	grade_4	*
2438819	2438819	CT	school		2410014	Capitol Region Education Council	90070001495	2419314	River Street School	Program						2019	grade_4	*
2438843	2438843	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	*
2438854	2438854	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2019	grade_4	*
2438959	2438959	CT	school		2420014	EdAdvance	90351201476	2429014	The ACCESS School at The Danuta M. Thibodeau Education Center	Program						2019	grade_4	*
2438984	2438984	CT	school		490011	Enfield School District		491411	Eli Whitney - Intermediate Adaptive Learning (IAL)	Program						2019	grade_4	*
2438985	2438985	CT	school		490011	Enfield School District	90147001702	490711	Prudence Crandall - Educational Counseling Program (ECP)	Program						2019	grade_4	*
2439018	2439018	CT	school	901560	520011	Farmington School District	90156001368	520511	West Woods Upper Elementary School	Public Schools	Regular School	No	Middle	04	06	2019	grade_4	*
2439029	2439029	CT	school		540011	Glastonbury School District	90162001801	540111	Links Academy	Program						2019	grade_4	*
2439082	2439082	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2019	grade_4	*
2439090	2439090	CT	school		620011	Hamden School District		621311	Church Street IIC	Program						2019	grade_4	*
2439091	2439091	CT	school		620011	Hamden School District		620911	Bear Path IIC	Program						2019	grade_4	*
2439092	2439092	CT	school		620011	Hamden School District		621711	Ridge Hill IIC	Program						2019	grade_4	*
2439126	2439126	CT	school		640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program						2019	grade_4	*
2439134	2439134	CT	school		640011	Hartford School District		644711	iGOAL 1 - Burns School	Program						2019	grade_4	*
2439137	2439137	CT	school		640011	Hartford School District	90192001673	644411	iGOAL 1 - Rawson School	Program						2019	grade_4	*
2439140	2439140	CT	school		640011	Hartford School District		645911	RISE - M.D. Fox School							2019	grade_4	*
2439183	2439183	CT	school		2450014	Learn	90345001680	2451114	Learn Intensive Program	Program						2019	grade_4	*
2439184	2439184	CT	school		2450014	Learn		2451614	LEARN SAILS Program	Program						2019	grade_4	*
2439185	2439185	CT	school		2450014	Learn		2451414	LEARN Diagnostic and Wellness Center	Program						2019	grade_4	*
2439242	2439242	CT	school	902400	800011	Meriden School District	90240000443	800411	Israel Putnam School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439247	2439247	CT	school		800011	Meriden School District		800611	STARS - ES	Program						2019	grade_4	*
2439252	2439252	CT	school		800011	Meriden School District		802211	SOAR- ES	Program						2019	grade_4	*
2439281	2439281	CT	school		830011	Middletown School District	90249001652	830711	ICM - Moody 3-5	Program						2019	grade_4	*
2439282	2439282	CT	school		830011	Middletown School District		832011	ICM - Spencer	Program						2019	grade_4	*
2439343	2439343	CT	school		890011	New Britain School District		890211	Chamberlain Bridges	Program						2019	grade_4	*
2439344	2439344	CT	school		890011	New Britain School District		890411	Holmes Bridges	Program						2019	grade_4	*
2439351	2439351	CT	school		890011	New Britain School District	90267001566	899011	New Britain Transition Center	Program						2019	grade_4	*
2439352	2439352	CT	school		890011	New Britain School District		891911	Smith Pathways	Program						2019	grade_4	*
2439388	2439388	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2019	grade_4	*
2439405	2439405	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	grade_4	*
2439407	2439407	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	grade_4	*
2439408	2439408	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	grade_4	*
2439414	2439414	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2019	grade_4	*
2439415	2439415	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2019	grade_4	*
2439416	2439416	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2019	grade_4	*
2439417	2439417	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2019	grade_4	*
2439419	2439419	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2019	grade_4	*
2439473	2439473	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439475	2439475	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439505	2439505	CT	school		1040011	Norwich School District		1040511	Special Needs Program @ Mahan	Program						2019	grade_4	*
2439510	2439510	CT	school		1040011	Norwich School District		1040911	Stanton Special Learning Center	Program						2019	grade_4	*
2439564	2439564	CT	school		2010012	Regional School District 01		2010312	SELC	Program						2019	grade_4	*
2439618	2439618	CT	school	903810	1180011	Ridgefield School District	90381000778	1180311	Ridgebury Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439652	2439652	CT	school		1260011	Shelton School District		1261211	Therapeutic Learning Center	Program						2019	grade_4	*
2439673	2439673	CT	school	904170	1320011	South Windsor School District	90417000824	1320611	Orchard Hill School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439674	2439674	CT	school	904170	1320011	South Windsor School District	90417000821	1320111	Philip R. Smith School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	*
2439693	2439693	CT	school		1310011	Southington School District	90423001786	1310411	Language Based Classroom at Hatton School	Program						2019	grade_4	*
2439749	2439749	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_4	*
2439754	2439754	CT	school		1380011	Stratford School District		1382811	STEPS K-6	Program						2019	grade_4	*
2439756	2439756	CT	school		1380011	Stratford School District		1382311	DLC Whitney	Program						2019	grade_4	*
2439758	2439758	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2019	grade_4	*
2439808	2439808	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	*
2439816	2439816	CT	school		1460011	Vernon School District		1460811	Renaissance Program	Program						2019	grade_4	*
2439826	2439826	CT	school		1480011	Wallingford School District	90474001595	1489211	WISE Intermediate Program	Program						2019	grade_4	*
2439831	2439831	CT	school		1480011	Wallingford School District		1481111	STARS Intermediate Program	Program						2019	grade_4	*
2439832	2439832	CT	school		1480011	Wallingford School District		1480611	Benhaven ABC Intermediate Program	Program						2019	grade_4	*
2439859	2439859	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2019	grade_4	*
2439862	2439862	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2019	grade_4	*
2439865	2439865	CT	school		1510011	Waterbury School District		1513511	Generali Autism	Program						2019	grade_4	*
2439871	2439871	CT	school		1510011	Waterbury School District	90483000958	1519011	State Street School	Program						2019	grade_4	*
2439874	2439874	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2019	grade_4	*
2439902	2439902	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2019	grade_4	*
2439928	2439928	CT	school		1550011	West Hartford School District	90492001790	1559611	Wolcott Learning Center	Program						2019	grade_4	*
2439930	2439930	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2019	grade_4	*
2439931	2439931	CT	school		1550011	West Hartford School District	90492001780	1559511	Whiting Lane Learning Center	Program						2019	grade_4	*
2439969	2439969	CT	school		1580011	Westport School District		1580111	LLS Intensive Resource	Program						2019	grade_4	*
2439973	2439973	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4	*
2439978	2439978	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_4	*
2439997	2439997	CT	school		1630011	Windham School District		1631111	Sweeney ASD Program	Program						2019	grade_4	*
2439998	2439998	CT	school		1630011	Windham School District		1630911	Sweeney Medically Fragile Program	Program						2019	grade_4	*
2440033	2440033	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_4	*
2440037	2440037	CT	school	900930	310011	Cornwall School District	90093000140	310111	Cornwall Consolidated School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_4	*
2438658	2438658	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_4	0	0
2438661	2438661	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_4	0	0
2438662	2438662	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2019	grade_4	0	0
2438663	2438663	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2019	grade_4	0	0
2438664	2438664	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2019	grade_4	0	0
2438669	2438669	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_4	0	0
2438670	2438670	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2019	grade_4	0	0
2438671	2438671	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2019	grade_4	0	0
2438672	2438672	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2019	grade_4	0	0
2438673	2438673	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West							2019	grade_4	0	0
2438674	2438674	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2019	grade_4	0	0
2438676	2438676	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2019	grade_4	0	0
2438679	2438679	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2019	grade_4	0	0
2438680	2438680	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_4	0	0
2438681	2438681	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2019	grade_4	0	0
2438683	2438683	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2019	grade_4	0	0
2438684	2438684	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2019	grade_4	0	0
2438688	2438688	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_4	0	0
2438689	2438689	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	grade_4	0	0
2438690	2438690	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_4	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]);