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 "year" = :p2 and rowid > :p3 order by 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
2775003	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	grade_11	0	0
2775004	CT	school		2430014	Cooperative Educational Services	90091001520	2438014	School Readiness	Program						2020	grade_11	0	0
2775005	CT	school	900910	2430014	Cooperative Educational Services	90091000340	2430114	Six-Six Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775006	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	grade_11	0	0
2775007	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2020	grade_11	16	16
2775008	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2020	grade_11	13	13
2775009	CT	school		2430014	Cooperative Educational Services	90091001555	2439314	RISE Transitional Program	Program						2020	grade_11	0	0
2775010	CT	school		2430014	Cooperative Educational Services		2430214	Transition Learning Center	Program						2020	grade_11	0	0
2775011	CT	school		320011	Coventry School District		320311	Hale Early Education Center	Program						2020	grade_11	0	0
2775012	CT	school	900960	320011	Coventry School District	90096000142	320211	Coventry Grammar School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_11	0	0
2775013	CT	school	900960	320011	Coventry School District	90096000144	320411	George Hersey Robertson School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775014	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775015	CT	school		320011	Coventry School District	90096001787	320111	Coventry Academy	Public Schools						2020	grade_11	*
2775016	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	115	115
2775017	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775018	CT	school	900990	330011	Cromwell School District	90099001432	330311	Woodside Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775019	CT	school	900990	330011	Cromwell School District	90099000147	335111	Cromwell Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775020	CT	school	900990	330011	Cromwell School District	90099000145	336111	Cromwell High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	144	144
2775021	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_11	0	0
2775022	CT	school	901020	340011	Danbury School District	90102000151	341111	Great Plain School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775023	CT	school	901020	340011	Danbury School District	90102000152	340211	Hayestown Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775024	CT	school	901020	340011	Danbury School District	90102000159	341411	Ellsworth Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775025	CT	school	901020	340011	Danbury School District	90102000153	341311	King Street Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_11	0	0
2775026	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_11	0	0
2775027	CT	school	901020	340011	Danbury School District	90102000156	340611	Morris Street School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775028	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775029	CT	school	901020	340011	Danbury School District	90102000158	341511	Pembroke School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775030	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775031	CT	school	901020	340011	Danbury School District	90102000162	341011	South Street School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775032	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775033	CT	school	901020	340011	Danbury School District	90102001438	341911	Western CT Academy of International Studies Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775034	CT	school	901020	340011	Danbury School District	90102001166	341711	King Street Intermediate School	Public Schools	Regular School	No	Elementary	04	05	2020	grade_11	0	0
2775035	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775036	CT	school	901020	340011	Danbury School District	90102000160	345211	Rogers Park Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775037	CT	school	901020	340011	Danbury School District	90102001691	340311	Westside Middle School Academy	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775038	CT	school		340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program						2020	grade_11	17	17
2775039	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	827	827
2775040	CT	school		340011	Danbury School District		340711	Western Connection	Program						2020	grade_11	0	0
2775041	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775042	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775043	CT	school	901050	350011	Darien School District	90105000170	351311	Ox Ridge Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775044	CT	school	901050	350011	Darien School District	90105000171	350511	Royle Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775045	CT	school	901050	350011	Darien School District	90105000172	350611	Tokeneke Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775046	CT	school	901050	350011	Darien School District	90105000169	355111	Middlesex Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775047	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	321	321
2775048	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_11	0	0
2775049	CT	school	901110	370011	Derby School District	90111000174	370611	Bradley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775050	CT	school	901110	370011	Derby School District	90111000178	370411	Irving School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775051	CT	school	901110	370011	Derby School District	90111001578	375011	Derby Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775052	CT	school		370011	Derby School District		370511	RAISE Academy	Program						2020	grade_11	*
2775053	CT	school		370011	Derby School District		370211	Alternative Education Program	Program						2020	grade_11	*
2775054	CT	school	901110	370011	Derby School District	90111000175	376111	Derby High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	92	92
2775055	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775056	CT	school	901170	400011	East Granby School District	90117000183	400211	R. Dudley Seymour School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775057	CT	school	901170	400011	East Granby School District	90117000182	405111	East Granby Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775058	CT	school	901170	400011	East Granby School District	90117000181	406111	East Granby High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	67	67
2775059	CT	school	901200	410011	East Haddam School District	90120000184	410111	East Haddam Elementary School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_11	0	0
2775060	CT	school	901200	410011	East Haddam School District	90120000198	415111	Nathan Hale-Ray Middle School	Public Schools	Regular School	No	Middle	04	08	2020	grade_11	0	0
2775061	CT	school	901200	410011	East Haddam School District	90120000185	416111	Nathan Hale-Ray High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	90	90
2775062	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_11	0	0
2775063	CT	school	901230	420011	East Hampton School District	90123000186	420311	Center School	Public Schools	Regular School	No	Elementary	04	05	2020	grade_11	0	0
2775064	CT	school	901230	420011	East Hampton School District	90123000188	425111	East Hampton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775065	CT	school	901230	420011	East Hampton School District	90123000187	426111	East Hampton High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	127	127
2775066	CT	school		420011	East Hampton School District	90123001514	429011	The Learning Center at East Hampton	Program						2020	grade_11	*
2775067	CT	school		430011	East Hartford School District		430211	Early Childhood Learning Center at Hockanum School	Program						2020	grade_11	0	0
2775068	CT	school	901260	430011	East Hartford School District	90126000191	430911	Anna E. Norris School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775069	CT	school	901260	430011	East Hartford School District	90126000194	430611	Dr. Franklin H. Mayberry School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775070	CT	school	901260	430011	East Hartford School District	90126000195	432211	Dr. John A. Langford School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775071	CT	school	901260	430011	East Hartford School District	90126000196	431011	Dr. Thomas S. O'Connell School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775072	CT	school	901260	430011	East Hartford School District	90126000201	432011	Governor William Pitkin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775073	CT	school	901260	430011	East Hartford School District	90126000204	430411	Joseph O. Goodwin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775074	CT	school	901260	430011	East Hartford School District	90126000206	431811	Robert J. O'Brien School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775075	CT	school	901260	430011	East Hartford School District	90126000208	431211	Silver Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775076	CT	school		430011	East Hartford School District	90126000205	439011	Woodland School	Program						2020	grade_11	29	29
2775077	CT	school	901260	430011	East Hartford School District	90126000197	435111	East Hartford Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775078	CT	school	901260	430011	East Hartford School District	90126001275	432411	Sunset Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775079	CT	school	901260	430011	East Hartford School District	90126001477	436311	Connecticut IB Academy	Public Schools	Regular School	No	High	09	12	2020	grade_11	42	42
2775080	CT	school	901260	430011	East Hartford School District	90126000200	436211	East Hartford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	455	455
2775081	CT	school		430011	East Hartford School District	90126001377	436411	Synergy Alternative Program	Program						2020	grade_11	31	31
2775082	CT	school	901290	440011	East Haven School District	90129000214	440111	Deer Run School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775083	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Elementary	PK	KG	2020	grade_11	0	0
2775084	CT	school	901290	440011	East Haven School District	90129000218	441011	Grove J. Tuttle School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775085	CT	school	901290	440011	East Haven School District	90129000219	440711	Momauguin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775086	CT	school	901290	440011	East Haven School District	90129000605	441711	Carbone School/East Haven Academy	Public Schools	Regular School	No	Elementary	01	08	2020	grade_11	0	0
2775087	CT	school	901290	440011	East Haven School District	90129000215	441311	Dominick H. Ferrara School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_11	0	0
2775088	CT	school	901290	440011	East Haven School District	90129000217	445111	Joseph Melillo Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775089	CT	school	901290	440011	East Haven School District	90129000216	446111	East Haven High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	226	226
2775090	CT	school		450011	East Lyme School District	90132001450	458011	Integrated Preschool	Program						2020	grade_11	0	0
2775091	CT	school	901320	450011	East Lyme School District	90132000225	450111	Flanders School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11	0	0
2775092	CT	school	901320	450011	East Lyme School District	90132000226	450411	Lillie B. Haynes School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11	0	0
2775093	CT	school	901320	450011	East Lyme School District	90132000227	450211	Niantic Center School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11	0	0
2775094	CT	school	901320	450011	East Lyme School District	90132000224	455111	East Lyme Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_11	0	0
2775095	CT	school		450011	East Lyme School District	90132001760	450611	Coastal Connections	Program						2020	grade_11	6	6
2775096	CT	school	901320	450011	East Lyme School District	90132000223	456111	East Lyme High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	261	261
2775097	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2020	grade_11	0	0
2775098	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2775099	CT	school	901350	470011	East Windsor School District	90135000230	475411	East Windsor Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_11	0	0
2775100	CT	school	901350	470011	East Windsor School District	90135000229	476111	East Windsor High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	57	57
2775101	CT	school		470011	East Windsor School District		470411	East Windsor Transition Program	Program						2020	grade_11	0	0
2775102	CT	school	901380	390011	Eastford School District	90138000232	390111	Eastford Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775103	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0