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
2776464	CT	school		2430014	Cooperative Educational Services	90091001561	2439114	Preschool-Primary Learning Center (PLC)	Program						2020	grade_12	0	0
2776465	CT	school		2430014	Cooperative Educational Services	90091001520	2438014	School Readiness	Program						2020	grade_12	0	0
2776466	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_12	0	0
2776467	CT	school		2430014	Cooperative Educational Services		2430314	Eastern Fairfield County Diagnostic Center	Program						2020	grade_12	0	0
2776468	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2020	grade_12	17	17
2776469	CT	school		2430014	Cooperative Educational Services	90091001554	2439214	Developmental Learning Center (DLC)	Program						2020	grade_12	*
2776470	CT	school		2430014	Cooperative Educational Services	90091001555	2439314	RISE Transitional Program	Program						2020	grade_12	12	12
2776471	CT	school		2430014	Cooperative Educational Services		2430214	Transition Learning Center	Program						2020	grade_12	33	33
2776472	CT	school		320011	Coventry School District		320311	Hale Early Education Center	Program						2020	grade_12	0	0
2776473	CT	school	900960	320011	Coventry School District	90096000142	320211	Coventry Grammar School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_12	0	0
2776474	CT	school	900960	320011	Coventry School District	90096000144	320411	George Hersey Robertson School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_12	0	0
2776475	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776476	CT	school		320011	Coventry School District	90096001787	320111	Coventry Academy	Public Schools						2020	grade_12	8	8
2776477	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	124	124
2776478	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_12	0	0
2776479	CT	school	900990	330011	Cromwell School District	90099001432	330311	Woodside Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_12	0	0
2776480	CT	school	900990	330011	Cromwell School District	90099000147	335111	Cromwell Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776481	CT	school	900990	330011	Cromwell School District	90099000145	336111	Cromwell High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	123	123
2776482	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_12	0	0
2776483	CT	school	901020	340011	Danbury School District	90102000151	341111	Great Plain School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776484	CT	school	901020	340011	Danbury School District	90102000152	340211	Hayestown Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776485	CT	school	901020	340011	Danbury School District	90102000159	341411	Ellsworth Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776486	CT	school	901020	340011	Danbury School District	90102000153	341311	King Street Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_12	0	0
2776487	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_12	0	0
2776488	CT	school	901020	340011	Danbury School District	90102000156	340611	Morris Street School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776489	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776490	CT	school	901020	340011	Danbury School District	90102000158	341511	Pembroke School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776491	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776492	CT	school	901020	340011	Danbury School District	90102000162	341011	South Street School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776493	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776494	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_12	0	0
2776495	CT	school	901020	340011	Danbury School District	90102001166	341711	King Street Intermediate School	Public Schools	Regular School	No	Elementary	04	05	2020	grade_12	0	0
2776496	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776497	CT	school	901020	340011	Danbury School District	90102000160	345211	Rogers Park Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776498	CT	school	901020	340011	Danbury School District	90102001691	340311	Westside Middle School Academy	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776499	CT	school		340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program						2020	grade_12	24	24
2776500	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	745	745
2776501	CT	school		340011	Danbury School District		340711	Western Connection	Program						2020	grade_12	11	11
2776502	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776503	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776504	CT	school	901050	350011	Darien School District	90105000170	351311	Ox Ridge Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776505	CT	school	901050	350011	Darien School District	90105000171	350511	Royle Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776506	CT	school	901050	350011	Darien School District	90105000172	350611	Tokeneke Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0
2776507	CT	school	901050	350011	Darien School District	90105000169	355111	Middlesex Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776508	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	359	359
2776509	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_12	0	0
2776510	CT	school	901110	370011	Derby School District	90111000174	370611	Bradley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776511	CT	school	901110	370011	Derby School District	90111000178	370411	Irving School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776512	CT	school	901110	370011	Derby School District	90111001578	375011	Derby Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776513	CT	school		370011	Derby School District		370511	RAISE Academy	Program						2020	grade_12	*
2776514	CT	school		370011	Derby School District		370211	Alternative Education Program	Program						2020	grade_12	0	0
2776515	CT	school	901110	370011	Derby School District	90111000175	376111	Derby High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	71	71
2776516	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_12	0	0
2776517	CT	school	901170	400011	East Granby School District	90117000183	400211	R. Dudley Seymour School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_12	0	0
2776518	CT	school	901170	400011	East Granby School District	90117000182	405111	East Granby Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776519	CT	school	901170	400011	East Granby School District	90117000181	406111	East Granby High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	54	54
2776520	CT	school	901200	410011	East Haddam School District	90120000184	410111	East Haddam Elementary School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_12	0	0
2776521	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_12	0	0
2776522	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_12	76	76
2776523	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_12	0	0
2776524	CT	school	901230	420011	East Hampton School District	90123000186	420311	Center School	Public Schools	Regular School	No	Elementary	04	05	2020	grade_12	0	0
2776525	CT	school	901230	420011	East Hampton School District	90123000188	425111	East Hampton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776526	CT	school	901230	420011	East Hampton School District	90123000187	426111	East Hampton High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	116	116
2776527	CT	school		420011	East Hampton School District	90123001514	429011	The Learning Center at East Hampton	Program						2020	grade_12	*
2776528	CT	school		430011	East Hartford School District		430211	Early Childhood Learning Center at Hockanum School	Program						2020	grade_12	0	0
2776529	CT	school	901260	430011	East Hartford School District	90126000191	430911	Anna E. Norris School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776530	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_12	0	0
2776531	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_12	0	0
2776532	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_12	0	0
2776533	CT	school	901260	430011	East Hartford School District	90126000201	432011	Governor William Pitkin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776534	CT	school	901260	430011	East Hartford School District	90126000204	430411	Joseph O. Goodwin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776535	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_12	0	0
2776536	CT	school	901260	430011	East Hartford School District	90126000208	431211	Silver Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776537	CT	school		430011	East Hartford School District	90126000205	439011	Woodland School	Program						2020	grade_12	33	33
2776538	CT	school	901260	430011	East Hartford School District	90126000197	435111	East Hartford Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776539	CT	school	901260	430011	East Hartford School District	90126001275	432411	Sunset Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776540	CT	school	901260	430011	East Hartford School District	90126001477	436311	Connecticut IB Academy	Public Schools	Regular School	No	High	09	12	2020	grade_12	43	43
2776541	CT	school	901260	430011	East Hartford School District	90126000200	436211	East Hartford High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	416	416
2776542	CT	school		430011	East Hartford School District	90126001377	436411	Synergy Alternative Program	Program						2020	grade_12	70	70
2776543	CT	school	901290	440011	East Haven School District	90129000214	440111	Deer Run School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_12	0	0
2776544	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Elementary	PK	KG	2020	grade_12	0	0
2776545	CT	school	901290	440011	East Haven School District	90129000218	441011	Grove J. Tuttle School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776546	CT	school	901290	440011	East Haven School District	90129000219	440711	Momauguin School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_12	0	0
2776547	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_12	0	0
2776548	CT	school	901290	440011	East Haven School District	90129000215	441311	Dominick H. Ferrara School	Public Schools	Regular School	No	Elementary	03	05	2020	grade_12	0	0
2776549	CT	school	901290	440011	East Haven School District	90129000217	445111	Joseph Melillo Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_12	0	0
2776550	CT	school	901290	440011	East Haven School District	90129000216	446111	East Haven High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	229	229
2776551	CT	school		450011	East Lyme School District	90132001450	458011	Integrated Preschool	Program						2020	grade_12	0	0
2776552	CT	school	901320	450011	East Lyme School District	90132000225	450111	Flanders School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_12	0	0
2776553	CT	school	901320	450011	East Lyme School District	90132000226	450411	Lillie B. Haynes School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_12	0	0
2776554	CT	school	901320	450011	East Lyme School District	90132000227	450211	Niantic Center School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_12	0	0
2776555	CT	school	901320	450011	East Lyme School District	90132000224	455111	East Lyme Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_12	0	0
2776556	CT	school		450011	East Lyme School District	90132001760	450611	Coastal Connections	Program						2020	grade_12	6	6
2776557	CT	school	901320	450011	East Lyme School District	90132000223	456111	East Lyme High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	236	236
2776558	CT	school		450011	East Lyme School District	90132001730	450511	Abilities in Motion (AIM) Program	Program						2020	grade_12	10	10
2776559	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_12	0	0
2776560	CT	school	901350	470011	East Windsor School District	90135000230	475411	East Windsor Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_12	0	0
2776561	CT	school	901350	470011	East Windsor School District	90135000229	476111	East Windsor High School	Public Schools	Regular School	No	High	09	12	2020	grade_12	66	66
2776562	CT	school		470011	East Windsor School District		470411	East Windsor Transition Program	Program						2020	grade_12	8	8
2776563	CT	school	901380	390011	Eastford School District	90138000232	390111	Eastford Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_12	0	0
2776564	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_12	0	0