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
2438018	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_3	0	0
2438019	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_3	120	120
2438020	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_3	0	0
2438021	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2438022	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_3	0	0
2743645	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_3	0	0
2743646	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3	110	110
2743647	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2021	grade_3	0	0
2743648	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2743649	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2021	grade_3	0	0
2763919	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_3	0	0
2763920	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_3	127	127
2763921	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763922	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763923	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2020	grade_3	0	0
2438017	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_3	15	15
2743644	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_3	8	8
2763918	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_3	11	11
2438008	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	grade_3	0	0
2438009	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_3	71	71
2438010	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_3	65	65
2438011	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_3	72	72
2438012	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_3	78	78
2438013	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_3	0	0
2438014	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_3	0	0
2438015	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2438016	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2019	grade_3	0	0
2743633	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2021	grade_3	0	0
2743634	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3	61	61
2743635	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3	59	59
2743636	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3	72	72
2743637	CT	school		970011	Newtown School District		970811	Program for Adaptive Learning	Program						2021	grade_3	0	0
2743638	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3	77	77
2743639	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2021	grade_3	0	0
2743640	CT	school		970011	Newtown School District		970711	Reaching Independence through Structured Education	Program						2021	grade_3	0	0
2743641	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_3	0	0
2743642	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2743643	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2021	grade_3	0	0
2763909	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2020	grade_3	0	0
2763910	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_3	57	57
2763911	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_3	50	50
2763912	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_3	79	79
2763913	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_3	77	77
2763914	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_3	0	0
2763915	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_3	0	0
2763916	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763917	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2020	grade_3	0	0
2437995	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_3	0	0
2437996	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_3	0	0
2437997	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_3	260	260
2437998	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_3	0	0
2437999	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2438000	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2019	grade_3	0	0
2743620	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_3	0	0
2743621	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_3	0	0
2743622	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2021	grade_3	219	219
2743623	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_3	0	0
2743624	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2743625	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2021	grade_3	0	0
2763896	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_3	0	0
2763897	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_3	0	0
2763898	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_3	271	271
2763899	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763900	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763901	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2020	grade_3	0	0
2437986	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_3	72	72
2437987	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_3	45	45
2437988	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2019	grade_3	0	0
2437989	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_3	90	90
2437990	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_3	88	88
2437991	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_3	0	0
2437992	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_3	0	0
2437993	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_3	0	0
2437994	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2743611	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_3	73	73
2743612	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3	30	30
2743613	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2021	grade_3	0	0
2743614	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_3	86	86
2743615	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_3	87	87
2743616	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_3	0	0
2743617	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_3	0	0
2743618	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_3	0	0
2743619	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2763887	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_3	89	89
2763888	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	56	56
2763889	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2020	grade_3	0	0
2763890	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_3	95	95
2763891	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_3	82	82
2763892	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_3	0	0
2763893	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_3	0	0
2763894	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_3	0	0
2763895	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2438001	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_3	95	95
2438002	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_3	53	53
2438003	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_3	67	67
2438004	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_3	61	61
2438005	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_3	0	0
2438006	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_3	0	0
2438007	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2743626	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_3	69	69
2743627	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_3	62	62