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 school 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
2436177	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_2	0	0
2741819	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_2	0	0
2762075	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_2	0	0
2437179	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_2	0	0
2742821	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	2021	grade_2	0	0
2763085	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	2020	grade_2	0	0
2436174	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	58	58
2741816	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2	56	56
2762072	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2	41	41
2436871	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2	133	133
2742503	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_2	141	141
2762763	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_2	130	130
2435822	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2	0	0
2741458	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2	0	0
2761719	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2436935	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_2	0	0
2762828	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2020	grade_2	0	0
2437080	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_2	*
2742703	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_2	*
2762969	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2020	grade_2	*
2436851	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_2	*
2742482	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_2	*
2762742	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2020	grade_2	*
2437122	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_2	*
2742755	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_2	*
2763019	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2020	grade_2	*
2435892	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_2	0	0
2741530	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_2	0	0
2761791	CT	school		170011	Bristol School District		170211	ACCESS	Program						2020	grade_2	0	0
2436064	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_2	0	0
2741705	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_2	0	0
2761960	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2020	grade_2	0	0
2435768	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_2	14	14
2742765	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_2	16	16
2761664	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_2	*
2742768	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2021	grade_2	*
2761666	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_2	0	0
2437158	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2019	grade_2	0	0
2742801	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2021	grade_2	0	0
2763063	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2020	grade_2	0	0
2436860	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2019	grade_2	0	0
2742491	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2021	grade_2	0	0
2762751	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2020	grade_2	0	0
2436865	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2019	grade_2	0	0
2742496	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2021	grade_2	0	0
2762756	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2020	grade_2	0	0
2437049	CT	school		1560011	West Haven School District		1561111	ASD Lab							2019	grade_2	0	0
2762944	CT	school		1560011	West Haven School District		1561111	ASD Lab							2020	grade_2	0	0
2436048	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2019	grade_2	0	0
2741686	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2021	grade_2	0	0
2761948	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2020	grade_2	0	0
2435946	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School		Regular School	No	Elementary	04	05	2019	grade_2	0	0
2435923	CT	school	900700	2410014	Capitol Region Education Council	90070001513	2415114	Academy of Aerospace and Engineering	Regional Education Service Center Schools	Regular School	No	High	06	12	2019	grade_2	0	0
2741558	CT	school	900700	2410014	Capitol Region Education Council	90070001513	2415114	Academy of Aerospace and Engineering	Regional Education Service Center Schools	Regular School	No	High	06	12	2021	grade_2	0	0
2761820	CT	school	900700	2410014	Capitol Region Education Council	90070001513	2415114	Academy of Aerospace and Engineering	Regional Education Service Center Schools	Regular School	No	High	06	12	2020	grade_2	0	0
2435907	CT	school	900700	2410014	Capitol Region Education Council	90070001629	2410714	Academy of Aerospace and Engineering Elementary	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	grade_2	68	68
2741544	CT	school	900700	2410014	Capitol Region Education Council	90070001629	2410714	Academy of Aerospace and Engineering Elementary	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2021	grade_2	67	67
2761806	CT	school	900700	2410014	Capitol Region Education Council	90070001629	2410714	Academy of Aerospace and Engineering Elementary	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2020	grade_2	69	69
2435924	CT	school	900700	2410014	Capitol Region Education Council	90070001592	2416514	Academy of Science and Innovation	Regional Education Service Center Schools	Regular School	No	High	06	12	2019	grade_2	0	0
2741559	CT	school	900700	2410014	Capitol Region Education Council	90070001592	2416514	Academy of Science and Innovation	Regional Education Service Center Schools	Regular School	No	High	06	12	2021	grade_2	0	0
2761821	CT	school	900700	2410014	Capitol Region Education Council	90070001592	2416514	Academy of Science and Innovation	Regional Education Service Center Schools	Regular School	No	High	06	12	2020	grade_2	0	0
2741456	CT	school		140011	Branford School District		140311	Access Transition Program	Program						2021	grade_2	0	0
2761717	CT	school		140011	Branford School District		140311	Access Transition Program	Program						2020	grade_2	0	0
2436800	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2019	grade_2	0	0
2742434	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2021	grade_2	0	0
2762693	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2020	grade_2	0	0
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
2435852	CT	school	900450	150011	Bridgeport School District	90045001639	150811	Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School	Public Schools	Regular School	No	High	09	12	2019	grade_2	0	0
2741488	CT	school	900450	150011	Bridgeport School District	90045001639	150811	Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School	Public Schools	Regular School	No	High	09	12	2021	grade_2	0	0
2761749	CT	school	900450	150011	Bridgeport School District	90045001639	150811	Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2437018	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	54	54
2742648	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_2	73	73
2762912	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	60	60
2436736	CT	school	903840	1190011	Rocky Hill School District	90384000782	1195111	Albert D. Griswold Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_2	0	0
2742369	CT	school	903840	1190011	Rocky Hill School District	90384000782	1195111	Albert D. Griswold Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_2	0	0
2762628	CT	school	903840	1190011	Rocky Hill School District	90384000782	1195111	Albert D. Griswold Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_2	0	0
2437121	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	41	41
2742752	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_2	37	37
2763018	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	34	34
2437075	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	52	52
2742708	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_2	40	40
2762973	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_2	46	46
2436184	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2019	grade_2	7	7
2741826	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2021	grade_2	8	8
2762082	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2020	grade_2	*
2436180	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2019	grade_2	0	0
2741822	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2021	grade_2	0	0
2762078	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2020	grade_2	0	0
2436006	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2	57	57
2741643	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_2	59	59
2761906	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_2	71	71
2437043	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	66	66
2742673	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_2	78	78
2762938	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_2	81	81
2435990	CT	school	901020	340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program	Alternative School	No	Not reported	M	M	2019	grade_2	0	0
2741627	CT	school		340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program						2021	grade_2	0	0