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 "year" = :p1 and (ccd_school_lvl < :p3 or ccd_school_lvl is null or (ccd_school_lvl = :p3 and rowid > :p2)) 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
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
2738570	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten
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
2738722	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten
2738749	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten
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
2738965	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten
2739333	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten
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
2739454	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	kindergarten
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
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
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
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
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
2740193	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
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
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
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
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
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
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
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
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
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
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
2741637	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2
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
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
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
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
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
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
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
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
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
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
2743081	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
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
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
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
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
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
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
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
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
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
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
2744525	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4
2744560	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4
2744741	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4
2745109	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4
2745128	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4
2745230	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4
2745305	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_4
2745769	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2745790	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2745829	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_5
2745942	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2745969	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2746004	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2746185	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2746553	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2746572	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5
2746674	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_5
2746749	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_5
2747213	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747234	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747273	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_6
2747386	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747413	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747448	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747629	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2747997	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2748016	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6
2748118	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6
2748193	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_6
2748657	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2748678	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2748717	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_7
2748830	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2748857	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2748892	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2749073	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2749441	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2749460	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7
2749562	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_7
2749637	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_7
2750101	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750122	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750161	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_8
2750274	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750301	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750336	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750517	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750885	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2750904	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
2751006	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_8
2751081	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_8
2751545	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_9
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