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 (school_state_id > :p4 or (school_state_id = :p4 and rowid > :p3)) order by school_state_id, 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
2448923	CT	school		170011	Bristol School District		171611	Chippens Hill Middle School Medically Fragile	Program						2019	grade_11	0	0
2448906	CT	school	900510	170011	Bristol School District	90051000103	171711	Mountain View School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448905	CT	school	900510	170011	Bristol School District	90051000099	171911	Ivy Drive School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2448913	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448915	CT	school		170011	Bristol School District	90051001646	172111	Hubbell/Extended Resource	Program						2019	grade_11	0	0
2448914	CT	school		170011	Bristol School District	90051001692	172311	Ivy Drive Medically Fragile	Program						2019	grade_11	0	0
2448918	CT	school		170011	Bristol School District		172411	Mt. View Extended Resource	Program						2019	grade_11	0	0
2448909	CT	school		170011	Bristol School District	90051001726	172511	Mt. View GOAL	Program						2019	grade_11	0	0
2448916	CT	school		170011	Bristol School District	90051001688	172611	Ivy Drive GOAL	Program						2019	grade_11	0	0
2448926	CT	school		170011	Bristol School District	90051001651	172711	Northeast MS/Extended Resource	Program						2019	grade_11	0	0
2448929	CT	school		170011	Bristol School District	90051001796	172811	Northeast MS/GOAL	Program						2019	grade_11	0	0
2448901	CT	school		170011	Bristol School District	90051001728	172911	BECC Autism	Program						2019	grade_11	0	0
2448910	CT	school		170011	Bristol School District	90051001755	173011	South Side Extended Resource	Program						2019	grade_11	0	0
2448920	CT	school		170011	Bristol School District	90051001711	173111	South Side GOAL	Program						2019	grade_11	0	0
2448911	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2019	grade_11	0	0
2448932	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2019	grade_11	*
2448925	CT	school		170011	Bristol School District	90051001753	173411	Chms Goal	Program						2019	grade_11	0	0
2448917	CT	school		170011	Bristol School District		173711	Hubbell Autism Program	Program						2019	grade_11	0	0
2448921	CT	school	900510	170011	Bristol School District	90051000089	175111	Chippens Hill Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448927	CT	school	900510	170011	Bristol School District	90051000104	175211	Northeast Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448930	CT	school	900510	170011	Bristol School District	90051000092	176111	Bristol Central High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	275	275
2448931	CT	school	900510	170011	Bristol School District	90051000093	176211	Bristol Eastern High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	254	254
2448919	CT	school		170011	Bristol School District	90051001429	179011	Alternative Special Education Program (ASEP)	Program						2019	grade_11	*
2448934	CT	school		170011	Bristol School District	90051001515	179211	Community/Vocational Program	Program						2019	grade_11	0	0
2448935	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2019	grade_11	0	0
2448936	CT	school	900540	180011	Brookfield School District	90054001186	180411	Huckleberry Hill Elementary School	Public Schools	Regular School	No	Elementary	02	04	2019	grade_11	0	0
2448937	CT	school	900540	180011	Brookfield School District	90054000112	185311	Whisconier Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2448938	CT	school	900540	180011	Brookfield School District	90054000109	186111	Brookfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	208	208
2448939	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448940	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2450176	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2448941	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448942	CT	school	900660	220011	Canterbury School District	90066001187	225111	Dr. Helen Baldwin Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2448943	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_11	0	0
2448944	CT	school	900690	230011	Canton School District	90069000119	230311	Canton Intermediate School	Public Schools	Regular School	No	Middle	04	06	2019	grade_11	0	0
2448947	CT	school		230011	Canton School District	90069001695	230411	Canton Academy	Program						2019	grade_11	*
2448945	CT	school	900690	230011	Canton School District	90069001376	235111	Canton Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_11	0	0
2448946	CT	school	900690	230011	Canton School District	90069000118	236111	Canton High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	112	112
2448975	CT	school	900720	240011	Chaplin School District	90072000121	240211	Chaplin Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2448978	CT	school	900750	250011	Cheshire School District	90075000122	250111	Chapman School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448976	CT	school	900750	250011	Cheshire School District	90075011188	250211	Darcey School	Public Schools	Regular School	No	Elementary	PK	KG	2019	grade_11	0	0
2448984	CT	school		250011	Cheshire School District	90075001766	250311	Cheshire Quinnipiac University Transition Collaborative	Program						2019	grade_11	0	0
2448977	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448979	CT	school	900750	250011	Cheshire School District	90075000129	250511	Norton School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448980	CT	school	900750	250011	Cheshire School District	90075000126	250611	Doolittle School	Public Schools	Regular School	No	Elementary	01	06	2019	grade_11	0	0
2448983	CT	school		250011	Cheshire School District	90075001682	250911	Humiston Alternative School	Program						2019	grade_11	*
2448985	CT	school		250011	Cheshire School District		251011	QU College Life	Program						2019	grade_11	0	0
2448981	CT	school	900750	250011	Cheshire School District	90075000125	255111	Dodd Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_11	0	0
2448982	CT	school	900750	250011	Cheshire School District	90075000123	256111	Cheshire High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	343	343
2450178	CT	school	900780	260011	Chester School District	90078000130	260111	Chester Elementary School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448987	CT	school	900810	270011	Clinton School District	90081000131	270111	Abraham Pierson School		Regular School	No	Elementary	04	05	2019	grade_11	0	0
2448986	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2448988	CT	school	900810	270011	Clinton School District	90081000133	275111	Jared Eliot School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2448989	CT	school	900810	270011	Clinton School District	90081000134	276111	The Morgan School	Public Schools	Regular School	No	High	09	12	2019	grade_11	162	162
2448991	CT	school	900840	280011	Colchester School District	90084000137	280211	Jack Jackter Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11	0	0
2448990	CT	school	900840	280011	Colchester School District	90084001444	280411	Colchester Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2448995	CT	school		280011	Colchester School District		280511	Bacon Academy Alternative Education	Program						2019	grade_11	0	0
2448994	CT	school		280011	Colchester School District		280611	School Resilience Program							2019	grade_11	*
2448992	CT	school	900840	280011	Colchester School District	90084000136	285111	William J. Johnston Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2448993	CT	school	900840	280011	Colchester School District	90084000135	286111	Bacon Academy	Public Schools	Regular School	No	High	09	12	2019	grade_11	173	173
2450179	CT	school	900870	290011	Colebrook School District	90087000138	290111	Colebrook Consolidated School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
2448996	CT	school	900900	300011	Columbia School District	90090000139	300111	Horace W. Porter School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2450180	CT	school	900930	310011	Cornwall School District	90093000140	310111	Cornwall Consolidated School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2449008	CT	school		320011	Coventry School District	90096001787	320111	Coventry Academy	Public Schools						2019	grade_11	*
2449005	CT	school	900960	320011	Coventry School District	90096000142	320211	Coventry Grammar School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_11	0	0
2449004	CT	school		320011	Coventry School District		320311	Hale Early Education Center	Program						2019	grade_11	0	0
2449006	CT	school	900960	320011	Coventry School District	90096000144	320411	George Hersey Robertson School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11	0	0
2449007	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449009	CT	school	900960	320011	Coventry School District	90096000143	326111	Coventry High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	118	118
2449010	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2449011	CT	school	900990	330011	Cromwell School District	90099001432	330311	Woodside Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11	0	0
2449012	CT	school	900990	330011	Cromwell School District	90099000147	335111	Cromwell Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449013	CT	school	900990	330011	Cromwell School District	90099000145	336111	Cromwell High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	129	129
2449014	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11	0	0
2449016	CT	school	901020	340011	Danbury School District	90102000152	340211	Hayestown Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449030	CT	school	901020	340011	Danbury School District	90102001691	340311	Westside Middle School Academy	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449017	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_11	0	0
2449024	CT	school	901020	340011	Danbury School District	90102000156	340611	Morris Street School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449033	CT	school		340011	Danbury School District		340711	Western Connection	Program						2019	grade_11	0	0
2449018	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449025	CT	school	901020	340011	Danbury School District	90102000162	341011	South Street School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449015	CT	school	901020	340011	Danbury School District	90102000151	341111	Great Plain School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449020	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449023	CT	school	901020	340011	Danbury School District	90102000153	341311	King Street Primary School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_11	0	0
2449022	CT	school	901020	340011	Danbury School District	90102000159	341411	Ellsworth Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449019	CT	school	901020	340011	Danbury School District	90102000158	341511	Pembroke School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449021	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449027	CT	school	901020	340011	Danbury School District	90102001166	341711	King Street Intermediate School	Public Schools	Regular School	No	Elementary	04	05	2019	grade_11	0	0
2449026	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	2019	grade_11	0	0
2449028	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449029	CT	school	901020	340011	Danbury School District	90102000160	345211	Rogers Park Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449032	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	754	754
2449031	CT	school	901020	340011	Danbury School District	90102001129	346211	Alternative Center For Excellence	Program	Alternative School	No	Not reported	M	M	2019	grade_11	28	28
2449034	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449036	CT	school	901050	350011	Darien School District	90105000171	350511	Royle Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449037	CT	school	901050	350011	Darien School District	90105000172	350611	Tokeneke Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449038	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449035	CT	school	901050	350011	Darien School District	90105000170	351311	Ox Ridge Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449039	CT	school	901050	350011	Darien School District	90105000169	355111	Middlesex Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449040	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	358	358
2450181	CT	school	901080	360011	Deep River School District	90108000173	360111	Deep River Elementary School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_11	0	0