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 total_int 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	total	total_int
2761520	CT	school	905130	1610011	Wilton School District	90513001075	1610511	Miller-Driscoll School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	251	251
2435638	CT	school	905130	1610011	Wilton School District	90513001075	1610511	Miller-Driscoll School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	230	230
2741271	CT	school	905130	1610011	Wilton School District	90513001075	1610511	Miller-Driscoll School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	200	200
2435562	CT	school	904890	1530011	Watertown School District	90489001135	1530211	John Trumbull Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1	197	197
2741198	CT	school	904890	1530011	Watertown School District	90489001135	1530211	John Trumbull Primary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	191	191
2434828	CT	school	902070	690011	Killingly School District	90207000391	690111	Killingly Central School	Public Schools	Regular School	No	Elementary	PK	01	2019	grade_1	187	187
2761445	CT	school	904890	1530011	Watertown School District	90489001135	1530211	John Trumbull Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	185	185
2760711	CT	school	902070	690011	Killingly School District	90207000391	690111	Killingly Central School	Public Schools	Regular School	No	Elementary	PK	01	2020	grade_1	182	182
2740088	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2021	grade_1	175	175
2435441	CT	school	904590	1430011	Torrington School District	90459000923	1430911	Torringford School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_1	174	174
2740471	CT	school	902070	690011	Killingly School District	90207000391	690111	Killingly Central School	Public Schools	Regular School	No	Elementary	PK	01	2021	grade_1	162	162
2434500	CT	school	900840	280011	Colchester School District	90084001444	280411	Colchester Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	160	160
2760332	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2020	grade_1	160	160
2434445	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2019	grade_1	157	157
2435020	CT	school	902730	910011	New Fairfield School District	90273000535	910111	Consolidated School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	157	157
2435442	CT	school	904590	1430011	Torrington School District	90459001211	1431311	Vogel-Wetmore School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_1	157	157
2761321	CT	school	904590	1430011	Torrington School District	90459000923	1430911	Torringford School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	153	153
2741070	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	150	150
2435433	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	149	149
2740656	CT	school	902730	910011	New Fairfield School District	90273000535	910111	Consolidated School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	149	149
2741079	CT	school	904590	1430011	Torrington School District	90459000923	1430911	Torringford School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_1	148	148
2761322	CT	school	904590	1430011	Torrington School District	90459001211	1431311	Vogel-Wetmore School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_1	147	147
2434564	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1	145	145
2740162	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	145	145
2760975	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	145	145
2740140	CT	school	900840	280011	Colchester School District	90084001444	280411	Colchester Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	144	144
2434520	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	143	143
2741080	CT	school	904590	1430011	Torrington School District	90459001211	1431311	Vogel-Wetmore School	Public Schools	Regular School	No	Elementary	KG	03	2021	grade_1	143	143
2434631	CT	school	901470	490011	Enfield School District	90147000248	491811	Henry Barnard School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_1	142	142
2739971	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	142	142
2741244	CT	school	905010	1570011	Weston School District	90501001045	1570111	Hurlbutt Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	141	141
2760407	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	140	140
2761302	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	139	139
2741059	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	137	137
2760594	CT	school	901740	580011	Griswold School District	90174000310	580311	Griswold Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	137	137
2740733	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	135	135
2434687	CT	school	901680	560011	Granby School District	90168000290	560411	Kelly Lane Primary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	133	133
2741299	CT	school	905220	1640011	Windsor School District	90522001092	1640911	Oliver Ellsworth School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	132	132
2435098	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	131	131
2761313	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	131	131
2435422	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	129	129
2434533	CT	school	901020	340011	Danbury School District	90102000153	341311	King Street Primary School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_1	128	128
2435610	CT	school	905010	1570011	Weston School District	90501001045	1570111	Hurlbutt Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	128	128
2760386	CT	school	900840	280011	Colchester School District	90084001444	280411	Colchester Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	128	128
2761542	CT	school	905250	1650011	Windsor Locks School District	90525001097	1650111	North Street School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	128	128
2760418	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	126	126
2741012	CT	school	904320	1350011	Stamford School District	90432000868	1352111	Stillmeadow School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	125	125
2761165	CT	school	903840	1190011	Rocky Hill School District	90384000786	1190511	West Hill School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	125	125
2761548	CT	school	905220	1640011	Windsor School District	90522001092	1640911	Oliver Ellsworth School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	125	125
2740207	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_1	124	124
2740757	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	124	124
2760516	CT	school	901470	490011	Enfield School District	90147000248	491811	Henry Barnard School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_1	124	124
2434515	CT	school	900960	320011	Coventry School District	90096000142	320211	Coventry Grammar School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_1	122	122
2739994	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	122	122
2740923	CT	school	903840	1190011	Rocky Hill School District	90384000786	1190511	West Hill School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_1	122	122
2434353	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_1	121	121
2435286	CT	school	903840	1190011	Rocky Hill School District	90384000786	1190511	West Hill School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1	121	121
2435664	CT	school	905220	1640011	Windsor School District	90522001092	1640911	Oliver Ellsworth School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	120	120
2740157	CT	school	900960	320011	Coventry School District	90096000142	320211	Coventry Grammar School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	120	120
2760416	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_1	120	120
2761549	CT	school	905220	1640011	Windsor School District	90522001093	1640511	Poquonock Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	120	120
2434330	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1	119	119
2434629	CT	school	901470	490011	Enfield School District	90147000247	490411	Hazardville Memorial School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_1	119	119
2740651	CT	school	902700	900011	New Canaan School District	90270000530	900411	East School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	119	119
2740335	CT	school	901680	560011	Granby School District	90168000290	560411	Kelly Lane Primary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	118	118
2740652	CT	school	902700	900011	New Canaan School District	90270000533	900211	South School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	118	118
2740096	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_1	117	117
2760756	CT	school	902310	770011	Manchester School District	90231000429	771211	Verplanck School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	117	117
2761209	CT	school	904170	1320011	South Windsor School District	90417000824	1320611	Orchard Hill School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	117	117
2761258	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	117	117
2761493	CT	school	905010	1570011	Weston School District	90501001045	1570111	Hurlbutt Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	117	117
2434708	CT	school	901740	580011	Griswold School District	90174000310	580311	Griswold Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_1	116	116
2760898	CT	school	902730	910011	New Fairfield School District	90273000535	910111	Consolidated School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	115	115
2435679	CT	school	905310	1670011	Woodbridge School District	90531001611	1670311	Beecher Road School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_1	114	114
2761280	CT	school	904440	1380011	Stratford School District	90444001805	1382211	Stratford Academy - Victoria Soto School	Public Schools	Regular School	No	Elementary	PK	01	2020	grade_1	114	114
2435001	CT	school	902670	890011	New Britain School District	90267000523	891211	Smalley Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_1	113	113
2740278	CT	school	901470	490011	Enfield School District	90147000248	491811	Henry Barnard School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	113	113
2740356	CT	school	901740	580011	Griswold School District	90174000310	580311	Griswold Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	113	113
2435181	CT	school	903240	1080011	Oxford School District	90324000002	1080311	Quaker Farms School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	112	112
2435377	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_1	112	112
2435401	CT	school	904440	1380011	Stratford School District	90444001805	1382211	Stratford Academy - Victoria Soto School	Public Schools	Regular School	No	Elementary	PK	01	2019	grade_1	112	112
2741015	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	112	112
2761061	CT	school	903240	1080011	Oxford School District	90324000002	1080311	Quaker Farms School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	112	112
2434346	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_1	111	111
2435120	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	111	111
2435378	CT	school	904320	1350011	Stamford School District	90432000872	1351411	Westover School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_1	111	111
2740275	CT	school	901470	490011	Enfield School District	90147000247	490411	Hazardville Memorial School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	111	111
2760237	CT	school	900330	110011	Bloomfield School District	90033000032	110611	Laurel School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_1	111	111
2760573	CT	school	901680	560011	Granby School District	90168000290	560411	Kelly Lane Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	111	111
2760974	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	111	111
2434345	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1	110	110
2434453	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_1	110	110
2435376	CT	school	904320	1350011	Stamford School District	90432001916	1350711	Strawberry Hill an ext. of Rogers International	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_1	110	110
2435477	CT	school	904740	1480011	Wallingford School District	90474000957	1480111	Moses Y. Beach School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1	110	110
2740843	CT	school	903390	1130011	Portland School District	90339000714	1130211	Valley View School	Public Schools	Regular School	No	Elementary	PK	01	2021	grade_1	110	110
2760214	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	110	110
2760452	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	110	110
2760874	CT	school	902670	890011	New Britain School District	90267000515	890811	Lincoln Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	110	110
2760997	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	110	110
2761210	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	110	110
2435016	CT	school	902700	900011	New Canaan School District	90270000533	900211	South School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1	109	109