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 district_state_id 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
2440916	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_5	0	0
2440917	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_5	129	129
2440918	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_5	0	0
2440919	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_5	0	0
2440920	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_5	0	0
2746533	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_5	0	0
2746534	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_5	109	109
2746535	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5	0	0
2746536	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2746537	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2021	grade_5	0	0
2766841	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_5	0	0
2766842	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_5	151	151
2766843	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766844	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766845	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2020	grade_5	0	0
2440915	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_5	15	15
2746532	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_5	15	15
2766840	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_5	10	10
2440906	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	grade_5	0	0
2440907	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_5	0	0
2440908	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_5	0	0
2440909	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_5	0	0
2440910	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_5	0	0
2440911	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_5	285	285
2440912	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_5	0	0
2440913	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_5	0	0
2440914	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2019	grade_5	0	0
2746521	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2021	grade_5	0	0
2746522	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2746523	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2746524	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2746525	CT	school		970011	Newtown School District		970811	Program for Adaptive Learning	Program						2021	grade_5	0	0
2746526	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
2746527	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2021	grade_5	291	291
2746528	CT	school		970011	Newtown School District		970711	Reaching Independence through Structured Education	Program						2021	grade_5	0	0
2746529	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5	0	0
2746530	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2746531	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2021	grade_5	0	0
2766831	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2020	grade_5	0	0
2766832	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766833	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766834	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766835	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
2766836	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_5	276	276
2766837	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_5	0	0
2766838	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766839	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2020	grade_5	0	0
2440893	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_5	0	0
2440894	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_5	0	0
2440895	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_5	288	288
2440896	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_5	0	0
2440897	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_5	0	0
2440898	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2019	grade_5	0	0
2746508	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_5	0	0
2746509	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_5	0	0
2746510	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_5	258	258
2746511	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5	0	0
2746512	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2746513	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2021	grade_5	0	0
2766818	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_5	0	0
2766819	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_5	0	0
2766820	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_5	266	266
2766821	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766822	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766823	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2020	grade_5	0	0
2440884	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5	97	97
2440885	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_5	16	16
2440886	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2019	grade_5	0	0
2440887	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5	99	99
2440888	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_5	78	78
2440889	CT	school	902820	950011	New London School District	90282000596	955111	Bennie Dover Jackson Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_5	0	0
2440890	CT	school	902820	950011	New London School District	90282001919	951411	New London Visual and Performing Arts Magnet School	Public Schools	Regular School	No	Middle	06	09	2019	grade_5	0	0
2440891	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2019	grade_5	0	0
2440892	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2019	grade_5	0	0
2746499	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5	79	79
2746500	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5	42	42
2746501	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2021	grade_5	0	0
2746502	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5	96	96
2746503	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5	77	77
2746504	CT	school	902820	950011	New London School District	90282000596	955111	Bennie Dover Jackson Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5	0	0
2746505	CT	school	902820	950011	New London School District	90282001919	951411	New London Visual and Performing Arts Magnet School	Public Schools	Regular School	No	Secondary	06	11	2021	grade_5	0	0
2746506	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2021	grade_5	0	0
2746507	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2021	grade_5	0	0
2766809	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	78	78
2766810	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	39	39
2766811	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2020	grade_5	0	0
2766812	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	96	96
2766813	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	84	84
2766814	CT	school	902820	950011	New London School District	90282000596	955111	Bennie Dover Jackson Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766815	CT	school	902820	950011	New London School District	90282001919	951411	New London Visual and Performing Arts Magnet School	Public Schools	Regular School	No	Middle	06	10	2020	grade_5	0	0
2766816	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2020	grade_5	0	0
2766817	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2440899	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_5	0	0
2440900	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_5	0	0
2440901	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_5	0	0
2440902	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_5	0	0
2440903	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_5	160	160
2440904	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_5	155	155
2440905	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2019	grade_5	0	0
2746514	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_5	0	0
2746515	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_5	0	0