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
2446320	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_9	0	0
2751927	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_9	0	0
2772302	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_9	0	0
2447322	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_9	183	183
2752929	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_9	227	227
2773312	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_9	215	215
2446317	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_9	0	0
2751924	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9	0	0
2772299	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_9	0	0
2447014	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_9	0	0
2752611	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_9	0	0
2772990	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_9	0	0
2445965	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_9	0	0
2751566	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	0	0
2771946	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0	0
2447078	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_9	*
2773055	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2020	grade_9	*
2447223	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_9	0	0
2752811	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_9	0	0
2773196	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2020	grade_9	0	0
2446994	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_9	0	0
2752590	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_9	0	0
2772969	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2020	grade_9	0	0
2447265	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_9	0	0
2752863	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_9	0	0
2773246	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2020	grade_9	0	0
2446035	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_9	0	0
2751638	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_9	0	0
2772018	CT	school		170011	Bristol School District		170211	ACCESS	Program						2020	grade_9	0	0
2446207	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_9	*
2751813	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_9	0	0
2772187	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2020	grade_9	0	0
2445911	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2019	grade_9	0	0
2752873	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_9	0	0
2771891	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2020	grade_9	0	0
2752876	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2021	grade_9	0	0
2771893	CT	school		2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program						2020	grade_9	0	0
2447301	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2019	grade_9	9	9
2752909	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2021	grade_9	*
2773290	CT	school		2070012	Regional School District 07	90372001400	2079112	AIM	Program						2020	grade_9	6	6
2447003	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2019	grade_9	0	0
2752599	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2021	grade_9	0	0
2772978	CT	school		1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program						2020	grade_9	0	0
2447008	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2019	grade_9	*
2752604	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2021	grade_9	*
2772983	CT	school		1380011	Stratford School District	90444001701	1380511	ALPHA	Program						2020	grade_9	6	6
2447192	CT	school		1560011	West Haven School District		1561111	ASD Lab							2019	grade_9	0	0
2773171	CT	school		1560011	West Haven School District		1561111	ASD Lab							2020	grade_9	0	0
2446191	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2019	grade_9	0	0
2751794	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2021	grade_9	0	0
2772175	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2020	grade_9	0	0
2446089	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School		Regular School	No	Elementary	04	05	2019	grade_9	0	0
2446066	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_9	134	134
2751666	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_9	114	114
2772047	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_9	109	109
2446050	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_9	0	0
2751652	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_9	0	0
2772033	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_9	0	0
2446067	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_9	115	115
2751667	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_9	107	107
2772048	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_9	112	112
2751564	CT	school		140011	Branford School District		140311	Access Transition Program	Program						2021	grade_9	0	0
2771944	CT	school		140011	Branford School District		140311	Access Transition Program	Program						2020	grade_9	0	0
2446943	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2019	grade_9	7	7
2752542	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2021	grade_9	*
2772920	CT	school		1310011	Southington School District	90423001694	1311711	Achieve	Program						2020	grade_9	*
2447274	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_9	79	79
2752870	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_9	71	71
2773255	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_9	85	85
2447275	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_9	96	96
2752871	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_9	96	96
2773256	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_9	95	95
2445995	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_9	145	145
2751596	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_9	81	81
2771976	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_9	85	85
2447161	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_9	0	0
2752756	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9	0	0
2773139	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_9	0	0
2446879	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_9	0	0
2752477	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_9	0	0
2772855	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_9	0	0
2447264	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_9	0	0
2752860	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9	0	0
2773245	CT	school	905280	1660011	Wolcott School District	90528001105	1660611	Alcott School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_9	0	0
2447218	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9	0	0
2752816	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
2773200	CT	school	905070	1590011	Wethersfield School District	90507001059	1590811	Alfred W. Hanmer School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_9	0	0
2446327	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2019	grade_9	0	0
2751934	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2021	grade_9	0	0
2772309	CT	school		620011	Hamden School District		620711	Alice Peck IIC	Program						2020	grade_9	0	0
2446323	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2019	grade_9	0	0
2751930	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2021	grade_9	0	0
2772305	CT	school		620011	Hamden School District	90186001433	628011	Alice Peck Learning Center	Program						2020	grade_9	0	0
2446149	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_9	0	0
2751751	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_9	0	0
2772133	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_9	0	0
2447186	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_9	0	0
2752781	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_9	0	0
2773165	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_9	0	0
2446133	CT	school	901020	340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program	Alternative School	No	Not reported	M	M	2019	grade_9	18	18
2751735	CT	school		340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program						2021	grade_9	23	23