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 "state" = :p0 and (ccd_school_lvl < :p2 or ccd_school_lvl is null or (ccd_school_lvl = :p2 and rowid > :p1)) order by ccd_school_lvl desc, rowid 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2448375	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_10												0												0
2448376	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_10												0												0
2448431	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_10												0												0
2448432	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_10												0												0
2448842	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2448863	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2448902	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449014	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449041	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449075	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449115	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449116	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449251	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449628	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449646	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449753	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449824	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449825	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449880	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2449881	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2450291	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450312	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450351	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450463	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450490	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450524	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450564	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450565	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2450700	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451077	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451095	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451202	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451273	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451274	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451329	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451330	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451740	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	115	120	37	*	25	0	*	170	149	0	44	319	115	120	37		25	0		170	149	0	44	319
2451761	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	41	63	107	0	*	0	*	145	81	0	127	226	41	63	107	0		0		145	81	0	127	226
2451800	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	pk_12_total	66	*	29	0	*	0	8	62	45	0	65	107	66		29	0		0	8	62	45	0	65	107
2451912	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	49	8	73	*	12	0	*	90	60	0	72	150	49	8	73		12	0		90	60	0	72	150
2451939	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	16	10	13	0	0	*	*	31	13	0	15	44	16	10	13	0	0			31	13	0	15	44
2451973	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	74	9	55	0	9	0	12	69	90	0	7	159	74	9	55	0	9	0	12	69	90	0	7	159
2452013	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	pk_12_total	62	*	*	0	*	0	*	48	26	0	46	74	62			0		0		48	26	0	46	74
2452014	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	31	17	14	0	*	0	*	39	29	0	10	68	31	17	14	0		0		39	29	0	10	68
2452149	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	12	50	23	*	57	0	*	71	80	0	6	151	12	50	23		57	0		71	80	0	6	151
2452526	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	74	14	54	0	15	0	6	100	63	0	104	163	74	14	54	0	15	0	6	100	63	0	104	163
2452544	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	61	33	54	*	15	0	*	90	85	0	74	175	61	33	54		15	0		90	85	0	74	175
2452651	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	pk_12_total	40	*	*	0	0	0	*	26	23	0	13	49	40			0	0	0		26	23	0	13	49
2452722	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	*	*	0	0	0	0	0	9	10	0	11	19			0	0	0	0	0	9	10	0	11	19
2452723	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	56	*	7	0	*	0	*	52	18	0	46	70	56		7	0		0		52	18	0	46	70
2452778	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	pk_12_total	22	0	*	0	*	0	0	15	11	0	16	26	22	0		0		0	0	15	11	0	16	26
2452779	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	pk_12_total	22	0	*	0	0	0	*	17	9	0	17	26	22	0		0	0	0		17	9	0	17	26
2738549	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738570	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738609	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738722	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738749	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738784	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2738965	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2739333	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2739352	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2739454	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2739529	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2739993	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740014	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740053	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740166	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740193	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740228	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740409	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740777	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740796	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740898	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2740973	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2741437	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	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
2741497	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2741610	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2741637	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2741672	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2741853	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742221	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742240	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742342	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742417	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742881	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2742902	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2742941	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743054	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743081	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743116	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743297	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743665	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743684	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743786	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2743861	CT	school	904230	1310011	Southington School District	90423001808	1312011	Southington Public Schools Preschool Program at Hatton School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2744325	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4												0												0
2744346	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4												0												0
2744385	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4												0												0
2744498	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4												0												0
2744525	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4												0												0