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 "state" = :p0 and "year" = :p1 and (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2741408	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_2												0												0
2742852	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_3												0												0
2744296	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_4												0												0
2745740	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5												0												0
2747184	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_6												0												0
2748628	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_7												177												177
2750072	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_8												188												188
2751516	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_9												0												0
2752960	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_10												0												0
2754404	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_11												0												0
2755848	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_12												0												0
2757292	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	pk_12_total	109	63	164	0	7	0	22	192	173	17	63	365	109	63	164	0	7	0	22	192	173	17	63	365
2738521	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	kindergarten												0												0
2739965	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_1												0												0
2741409	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_2												0												0
2742853	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_3												0												0
2744297	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_4												0												0
2745741	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_5												0												0
2747185	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_6												0												0
2748629	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_7												0												0
2750073	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_8												0												0
2751517	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_9												157												157
2752961	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_10												122												122
2754405	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												132												132
2755849	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	grade_12												92												92
2757293	CT	school	900060	20011	Ansonia School District	90006010002	26111	Ansonia High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	159	115	196	*	13	*	18	262	241	20	88	503	159	115	196		13		18	262	241	20	88	503
2738525	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	kindergarten												35												35
2739969	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1												40												40
2741413	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_2												41												41
2742857	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3												39												39
2744301	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_4												30												30
2745745	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_5												41												41
2747189	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_6												37												37
2748633	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_7												42												42
2750077	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_8												35												35
2751521	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_9												0												0
2752965	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10												0												0
2754409	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_11												0												0
2755853	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_12												0												0
2757297	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2021	pk_12_total	314	10	26	0	*	*	14	200	170	6	53	370	314	10	26	0			14	200	170	6	53	370
2738526	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	kindergarten												0												0
2739970	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_1												0												0
2741414	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_2												0												0
2742858	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_3												0												0
2744302	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_4												0												0
2745746	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_5												0												0
2747190	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_6												0												0
2748634	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_7												0												0
2750078	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_8												0												0
2751522	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_9												0												0
2752966	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_10												0												0
2754410	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_11												0												0
2755854	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	grade_12												0												0
2757298	CT	school		40011	Avon School District	90012001737	40111	Avon Early Learning Center at Roaring Brook School	Program						2021	pk_12_total	21	7	7	0	*	0	*	22	21	0	17	43	21	7	7	0		0		22	21	0	17	43
2738528	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	kindergarten												90												90
2739972	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1												94												94
2741416	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2												109												109
2742860	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3												78												78
2744304	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_4												118												118
2745748	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5												0												0
2747192	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_6												0												0
2748636	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_7												0												0
2750080	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_8												0												0
2751524	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9												0												0
2752968	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_10												0												0
2754412	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_11												0												0
2755856	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_12												0												0
2757300	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	pk_12_total	320	23	34	*	86	*	21	239	250	13	39	489	320	23	34		86		21	239	250	13	39	489
2738527	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	kindergarten												108												108
2739971	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1												142												142
2741415	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_2												109												109
2742859	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_3												115												115
2744303	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_4												130												130
2745747	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_5												0												0
2747191	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_6												0												0
2748635	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_7												0												0
2750079	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_8												0												0
2751523	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_9												0												0
2752967	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_10												0												0
2754411	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_11												0												0
2755855	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_12												0												0
2757299	CT	school	900120	40011	Avon School District	90012010010	40411	Pine Grove School	Public Schools	Regular School	No	Elementary	KG	04	2021	pk_12_total	373	37	38	0	133	0	23	276	328	63	51	604	373	37	38	0	133	0	23	276	328	63	51	604
2738529	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	kindergarten												0												0
2739973	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_1												0												0
2741417	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_2												0												0
2742861	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_3												0												0
2744305	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_4												0												0
2745749	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_5												240												240
2747193	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_6												263												263
2748637	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_7												0												0
2750081	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_8												0												0
2751525	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_9												0												0
2752969	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_10												0												0
2754413	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_11												0												0
2755857	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	grade_12												0												0
2757301	CT	school	900120	40011	Avon School District	90012001367	40511	Thompson Brook School	Public Schools	Regular School	No	Middle	05	06	2021	pk_12_total	296	28	38	*	122	0	*	255	248	8	53	503	296	28	38		122	0		255	248	8	53	503
2738530	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	kindergarten												0												0
2739974	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_1												0												0
2741418	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_2												0												0
2742862	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_3												0												0
2744306	CT	school	900120	40011	Avon School District	90012000012	45111	Avon Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_4												0												0