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 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
2758775	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2758797	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2758836	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten
2758950	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2758977	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2759187	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2759556	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2759575	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten
2759680	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten
2759755	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	2020	kindergarten
2760236	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2760258	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2760297	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_1
2760411	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2760438	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2760648	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2761017	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2761036	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1
2761141	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_1
2761216	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	2020	grade_1
2761697	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
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
2761758	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_2
2761872	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
2761899	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
2762109	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
2762478	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
2762497	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2
2762602	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_2
2762677	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	2020	grade_2
2763158	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763180	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763219	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3
2763333	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763360	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763570	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763939	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2763958	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3
2764063	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3
2764138	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	2020	grade_3
2764619	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2764641	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2764680	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4
2764794	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2764821	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2765031	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2765400	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2765419	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4
2765524	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4
2765599	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	2020	grade_4
2766080	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766102	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766141	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_5
2766255	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766282	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766492	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766861	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766880	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5
2766985	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_5
2767060	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	2020	grade_5
2767541	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2767563	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2767602	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6
2767716	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2767743	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2767953	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2768322	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2768341	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6
2768446	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6
2768521	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	2020	grade_6
2769002	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769024	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769063	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_7
2769177	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769204	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769414	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769783	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769802	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7
2769907	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_7
2769982	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	2020	grade_7
2770463	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2770485	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2770524	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_8
2770638	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2770665	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2770875	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2771244	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2771263	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
2771368	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_8
2771443	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	2020	grade_8
2771924	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
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
2771985	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9
2772099	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
2772126	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
2772336	CT	school	901920	640011	Hartford School District	90192001643	641311	Hartford PreKindergarten Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
2772705	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
2772724	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9
2772829	CT	school	903540	2180012	Regional School District 18	90354000761	2180312	Center School	Regional Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9
2772904	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	2020	grade_9
2773385	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_10