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 and (rowid < :p3 or rowid is null or (rowid = :p3 and rowid > :p2)) order by rowid 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	total	total_int
2776063	CT	school	904920	1550011	West Hartford School District	90492001217	1551711	Smith School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776062	CT	school	904920	1550011	West Hartford School District	90492001012	1550511	Charter Oak International Academy	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776061	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776060	CT	school		1530011	Watertown School District		1530811	Watertown Transition Academy	Program						2020	grade_11	0	0
2776059	CT	school	904890	1530011	Watertown School District	90489001008	1536111	Watertown High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	182	182
2776058	CT	school	904890	1530011	Watertown School District	90489001007	1535111	Swift Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2776057	CT	school	904890	1530011	Watertown School District	90489001005	1530411	Polk School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2776056	CT	school	904890	1530011	Watertown School District	90489001003	1530311	Fletcher W. Judson School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2776055	CT	school	904890	1530011	Watertown School District	90489001135	1530211	John Trumbull Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2776054	CT	school		1520011	Waterford School District		1520311	Avery Point Transition Program	Program						2020	grade_11	0	0
2776053	CT	school	904860	1520011	Waterford School District	90486001001	1526111	Waterford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	215	215
2776052	CT	school	904860	1520011	Waterford School District	90486000994	1525111	Clark Lane Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2776051	CT	school	904860	1520011	Waterford School District	90486001512	1520711	Quaker Hill Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776050	CT	school	904860	1520011	Waterford School District	90486000998	1520611	Oswegatchie Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776049	CT	school	904860	1520011	Waterford School District	90486001593	1520211	Great Neck Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776048	CT	school		1520011	Waterford School District		1521111	Autism Class	Program						2020	grade_11	0	0
2776047	CT	school		1520011	Waterford School District		1521011	The Early Learning Center II	Program						2020	grade_11	0	0
2776046	CT	school		1520011	Waterford School District		1520811	The Early Childhood Center	Program						2020	grade_11	0	0
2776045	CT	school		1510011	Waterbury School District		1517111	School to Work Transition Academy	Program						2020	grade_11	0	0
2776044	CT	school	904830	1510011	Waterbury School District	90483000992	1516311	Wilby High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	207	207
2776043	CT	school		1510011	Waterbury School District		1511711	Wilby ESC	Program						2020	grade_11	0	0
2776042	CT	school		1510011	Waterbury School District		1514511	Wilby Autism	Program						2020	grade_11	*
2776041	CT	school	904830	1510011	Waterbury School District	90483001396	1516011	Waterbury Arts Magnet School (High)	Public Schools	Regular School	No	High	09	12	2020	grade_11	108	108
2776040	CT	school	904830	1510011	Waterbury School District	90483000979	1516411	John F. Kennedy High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	214	214
2776039	CT	school	904830	1510011	Waterbury School District	90483000971	1516211	Crosby High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	218	218
2776038	CT	school		1510011	Waterbury School District		1515511	West Side SCOPE	Program						2020	grade_11	0	0
2776037	CT	school		1510011	Waterbury School District		1515611	West Side Bilingual	Program						2020	grade_11	0	0
2776036	CT	school		1510011	Waterbury School District		1514711	West Side BDLC	Program						2020	grade_11	0	0
2776035	CT	school	904830	1510011	Waterbury School District	90483001395	1515011	Waterbury Arts Magnet School (Middle)	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2776034	CT	school		1510011	Waterbury School District		1514911	Wallace SCOPE	Program						2020	grade_11	0	0
2776033	CT	school		1510011	Waterbury School District		1515811	Wallace Bilingual	Program						2020	grade_11	0	0
2776032	CT	school		1510011	Waterbury School District		1514411	Wallace BDLC	Program						2020	grade_11	0	0
2776031	CT	school		1510011	Waterbury School District		1514811	North End SCOPE	Program						2020	grade_11	0	0
2776030	CT	school	904830	1510011	Waterbury School District	90483001115	1515311	North End Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2776029	CT	school		1510011	Waterbury School District		1511811	North End ESC	Program						2020	grade_11	0	0
2776028	CT	school		1510011	Waterbury School District		1515711	North End Bilingual	Program						2020	grade_11	0	0
2776027	CT	school		1510011	Waterbury School District		1513711	North End BDLC	Program						2020	grade_11	0	0
2776026	CT	school		1510011	Waterbury School District		1512911	North End Autism	Program						2020	grade_11	0	0
2776025	CT	school		1510011	Waterbury School District	90483001418	1519111	Enlightenment School	Program						2020	grade_11	*
2776024	CT	school	904830	1510011	Waterbury School District	90483000991	1515211	West Side Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2776023	CT	school	904830	1510011	Waterbury School District	90483000983	1515111	Michael F. Wallace Middle School	Public Schools	Regular School	No	Middle	04	08	2020	grade_11	0	0
2776022	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2020	grade_11	0	0
2776021	CT	school		1510011	Waterbury School District		1517211	Hearing Lab	Program						2020	grade_11	0	0
2776020	CT	school		1510011	Waterbury School District		1511211	Woodrow Wilson BDLC	Program						2020	grade_11	0	0
2776019	CT	school		1510011	Waterbury School District		1510411	B.W. Tinker BDLC							2020	grade_11	0	0
2776018	CT	school		1510011	Waterbury School District	90483000958	1519011	State Street School	Program						2020	grade_11	7	7
2776017	CT	school	904830	1510011	Waterbury School District	90483000984	1512811	Regan School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776016	CT	school		1510011	Waterbury School District		1512411	Reed ESC	Program						2020	grade_11	0	0
2776015	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776014	CT	school	904830	1510011	Waterbury School District	90483000978	1511311	Hopeville School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776013	CT	school		1510011	Waterbury School District		1514211	Hopeville Bilingual	Program						2020	grade_11	0	0
2776012	CT	school		1510011	Waterbury School District		1516911	Gilmartin Scope	Program						2020	grade_11	0	0
2776011	CT	school		1510011	Waterbury School District		1513511	Generali Autism	Program						2020	grade_11	0	0
2776010	CT	school	904830	1510011	Waterbury School District	90483000975	1511411	F. J. Kingsbury School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776009	CT	school		1510011	Waterbury School District		1514111	Chase Bilingual	Program						2020	grade_11	0	0
2776008	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_11	0	0
2776007	CT	school		1510011	Waterbury School District		1514311	Bucks Hill Bilingual	Program						2020	grade_11	0	0
2776006	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_11	0	0
2776005	CT	school	904830	1510011	Waterbury School District	90483000685	1513211	Woodrow Wilson School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776004	CT	school	904830	1510011	Waterbury School District	90483000990	1510811	Wendell L. Cross School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776003	CT	school	904830	1510011	Waterbury School District	90483001638	1516711	Waterbury Career Academy	Public Schools	Regular School	No	High	09	12	2020	grade_11	193	193
2776002	CT	school	904830	1510011	Waterbury School District	90483000988	1512311	Washington School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776001	CT	school	904830	1510011	Waterbury School District	90483000987	1512211	Walsh School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776000	CT	school	904830	1510011	Waterbury School District	90483000986	1512011	Sprague School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775999	CT	school		1510011	Waterbury School District	90483000548	1518011	Special Education Preschool	Program						2020	grade_11	0	0
2775998	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775997	CT	school	904830	1510011	Waterbury School District	90483001613	1513411	Reed School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775996	CT	school		1510011	Waterbury School District		1519811	Maloney Prek	Program						2020	grade_11	0	0
2775995	CT	school	904830	1510011	Waterbury School District	90483000541	1513111	Maloney Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775994	CT	school	904830	1510011	Waterbury School District	90483000977	1510711	H. S. Chase School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775993	CT	school	904830	1510011	Waterbury School District	90483000976	1512611	Gilmartin School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775992	CT	school	904830	1510011	Waterbury School District	90483001602	1511611	Duggan School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775991	CT	school	904830	1510011	Waterbury School District	90483000972	1510911	Driggs School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775990	CT	school	904830	1510011	Waterbury School District	90483000970	1512711	Carrington School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775989	CT	school	904830	1510011	Waterbury School District	90483000969	1510611	Bunker Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775988	CT	school	904830	1510011	Waterbury School District	90483000968	1510511	Bucks Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775987	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775986	CT	school		1480011	Wallingford School District	90474001594	1489111	Wallingford Transition Academy	Program						2020	grade_11	0	0
2775985	CT	school	904740	1480011	Wallingford School District	90474000956	1486211	Mark T. Sheehan High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	179	179
2775984	CT	school	904740	1480011	Wallingford School District	90474000955	1486111	Lyman Hall High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	299	299
2775983	CT	school		1480011	Wallingford School District		1481711	Inspire High School	Program						2020	grade_11	*
2775982	CT	school		1480011	Wallingford School District		1480511	Education Enhancement Program							2020	grade_11	12	12
2775981	CT	school		1480011	Wallingford School District		1481311	Inspire Middle School	Program						2020	grade_11	0	0
2775980	CT	school	904740	1480011	Wallingford School District	90474000954	1485311	James H. Moran Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775979	CT	school	904740	1480011	Wallingford School District	90474000951	1485211	Dag Hammarskjold Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775978	CT	school		1480011	Wallingford School District		1481511	Ben Haven ABC Middle School Program	Program						2020	grade_11	0	0
2775977	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2020	grade_11	*
2775976	CT	school		1480011	Wallingford School District	90474001595	1489211	WISE Intermediate Program	Program						2020	grade_11	0	0
2775975	CT	school		1480011	Wallingford School District		1481111	STARS Intermediate Program	Program						2020	grade_11	0	0
2775974	CT	school	904740	1480011	Wallingford School District	90474000961	1480411	Rock Hill School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775973	CT	school	904740	1480011	Wallingford School District	90474000959	1481211	Pond Hill School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775972	CT	school	904740	1480011	Wallingford School District	90474001213	1480311	Parker Farms School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775971	CT	school	904740	1480011	Wallingford School District	90474000536	1480811	Mary G. Fritz Elementary School of Yalesville	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775970	CT	school		1480011	Wallingford School District		1480611	Benhaven ABC Intermediate Program	Program						2020	grade_11	0	0
2775969	CT	school		1480011	Wallingford School District		1481411	Ben Haven ABC Primary Program							2020	grade_11	0	0
2775968	CT	school		1480011	Wallingford School District		1481611	WISE Primary Program	Program						2020	grade_11	0	0
2775967	CT	school		1480011	Wallingford School District		1480711	STARS Primary Program	Program						2020	grade_11	0	0
2775966	CT	school	904740	1480011	Wallingford School District	90474000957	1480111	Moses Y. Beach School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775965	CT	school	904740	1480011	Wallingford School District	90474000953	1480211	Highland School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775964	CT	school	904740	1480011	Wallingford School District	90474000952	1480911	Evarts C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775963	CT	school	904740	1480011	Wallingford School District	90474000950	1481011	Cook Hill School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0