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 order by ccd_school_high_grade desc 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
2432903	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2432924	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2432963	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten
2433075	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433102	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433136	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433176	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten
2433177	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433312	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433689	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433707	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433814	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten
2433885	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten
2433886	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	kindergarten
2433941	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten
2433942	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten
2434352	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434373	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434412	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_1
2434524	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434551	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434585	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434625	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_1
2434626	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2434761	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2435138	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2435156	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2435263	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_1
2435334	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1
2435335	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_1
2435390	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_1
2435391	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_1
2435801	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
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
2435861	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_2
2435973	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436000	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436034	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436074	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_2
2436075	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436210	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436587	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436605	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436712	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_2
2436783	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2
2436784	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_2
2436839	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_2
2436840	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_2
2437250	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437271	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437310	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_3
2437422	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437449	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437483	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437523	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_3
2437524	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2437659	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2438036	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2438054	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2438161	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_3
2438232	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
2438233	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_3
2438288	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_3
2438289	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_3
2438699	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2438720	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2438759	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_4
2438871	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2438898	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2438932	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2438972	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_4
2438973	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2439108	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2439485	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2439503	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2439610	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_4
2439681	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4
2439682	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_4
2439737	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_4
2439738	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_4
2440148	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440169	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440208	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_5
2440320	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440347	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440381	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440421	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	grade_5
2440422	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440557	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440934	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2440952	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2441059	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_5
2441130	CT	school	904230	1310011	Southington School District	90423001804	1312111	Southington Public Schools Preschool Program	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5
2441131	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_5
2441186	CT	school	904380	1370011	Stonington School District	90438001637	1370111	Stonington BOE Pre-School		Special Education School	No	Prekindergarten	PK	PK	2019	grade_5
2441187	CT	school	904380	1370011	Stonington School District	90438001635	1370211	Stonington HS PreK		Special Education School	No	Prekindergarten	PK	PK	2019	grade_5
2441597	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_6
2441618	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_6
2441657	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_6
2441769	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_6
2441796	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_6