schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, 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, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "grade" = :p0 and "state" = :p1 order by district limit 101

Query parameters

This data as json, CSV

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
2437131	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_2	95	95
2742762	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_2	94	94
2763028	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_2	95	95
2437132	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_2	89	89
2742763	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_2	107	107
2763029	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_2	89	89
2437133	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_2	95	95
2742764	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_2	95	95
2763030	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_2	96	96
2435759	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	16	16
2741404	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_2	20	20
2761654	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_2	20	20
2435760	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_2	0	0
2435761	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	79	79
2435762	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_2	95	95
2435763	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_2	0	0
2435764	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2019	grade_2	0	0
2435765	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2019	grade_2	0	0
2435766	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2019	grade_2	0	0
2741405	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_2	0	0
2741406	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_2	79	79
2741407	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_2	83	83
2741408	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_2	0	0
2741409	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_2	0	0
2741410	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_2	0	0
2741411	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_2	0	0
2741412	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_2	0	0
2761655	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_2	0	0
2761656	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_2	89	89
2761657	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_2	102	102
2761658	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_2	0	0
2761659	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2761660	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2020	grade_2	0	0
2761661	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2020	grade_2	0	0
2761662	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_2	0	0
2435767	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2019	grade_2	16	16
2435768	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_2	14	14
2435769	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_2	66	66
2435770	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2019	grade_2	0	0
2435771	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_2	0	0
2435772	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2019	grade_2	0	0
2435773	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2019	grade_2	0	0
2435774	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2019	grade_2	0	0
2435775	CT	school		2440014	Area Cooperative Educational Services		2449314	Whitney High School West							2019	grade_2	0	0
2435776	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2019	grade_2	0	0
2742765	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_2	16	16
2742766	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2021	grade_2	12	12
2742767	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	2021	grade_2	51	51
2742768	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2021	grade_2	*
2742769	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2021	grade_2	0	0
2742770	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2021	grade_2	0	0
2742771	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	2021	grade_2	0	0
2742772	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2021	grade_2	0	0
2742773	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2021	grade_2	0	0
2742774	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2021	grade_2	0	0
2761663	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2020	grade_2	14	14
2761664	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_2	*
2761665	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	2020	grade_2	68	68
2761666	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_2	0	0
2761667	CT	school		2440014	Area Cooperative Educational Services	90007001505	2449414	Mill Academy	Program						2020	grade_2	0	0
2761668	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	2020	grade_2	0	0
2761669	CT	school		2440014	Area Cooperative Educational Services	90007001588	2449614	Center for Autism Spectrum and Development Disorders	Program						2020	grade_2	0	0
2761670	CT	school		2440014	Area Cooperative Educational Services	90007001502	2449214	Whitney Academy	Program						2020	grade_2	0	0
2761671	CT	school		2440014	Area Cooperative Educational Services	90007001490	2449114	Whitney High School North	Program						2020	grade_2	0	0
2761672	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_2	0	0
2435777	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	35	35
2741413	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_2	41	41
2761673	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_2	41	41
2435778	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2019	grade_2	0	0
2435779	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	122	122
2435780	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	114	114
2435781	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2019	grade_2	0	0
2435782	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_2	0	0
2435783	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2019	grade_2	0	0
2741414	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_2	0	0
2741415	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2	109	109
2741416	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2	109	109
2741417	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_2	0	0
2741418	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_2	0	0
2741419	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2021	grade_2	0	0
2761674	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2020	grade_2	0	0
2761675	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2	117	117
2761676	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2	75	75
2761677	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2020	grade_2	0	0
2761678	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_2	0	0
2761679	CT	school	900120	40011	Avon School District	90012000011	46111	Avon High School	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2435784	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	*
2435785	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2019	grade_2	0	0
2435786	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2019	grade_2	*
2741420	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2021	grade_2	0	0
2741421	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_2	20	20
2741422	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2021	grade_2	0	0
2761680	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_2	28	28
2761681	CT	school		50011	Barkhamsted School District	90015001373	58011	Shared Services Integrated Preschool	Program						2020	grade_2	0	0
2761682	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_2	0	0
2435787	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	64	64
2435788	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	80	80
2435789	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	31	31
2435790	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_2	0	0
2435791	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	grade_2	0	0
2435792	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_2	0	0