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 (district_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_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
2742211	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_2												0												0
2742212	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_2												0												0
2742213	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_2												0												0
2743651	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3												70												70
2743652	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3												57												57
2743653	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												65												65
2743654	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												55												55
2743655	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_3												0												0
2743656	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_3												0												0
2743657	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_3												0												0
2745095	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												64												64
2745096	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												61												61
2745097	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												62												62
2745098	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												52												52
2745099	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_4												0												0
2745100	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_4												0												0
2745101	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_4												0												0
2746539	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												52												52
2746540	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												67												67
2746541	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												48												48
2746542	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												40												40
2746543	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5												0												0
2746544	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_5												0												0
2746545	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_5												0												0
2747983	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_6												0												0
2747984	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_6												0												0
2747985	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_6												0												0
2747986	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_6												0												0
2747987	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_6												234												234
2747988	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_6												0												0
2747989	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_6												0												0
2749427	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_7												0												0
2749428	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_7												0												0
2749429	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_7												0												0
2749430	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_7												0												0
2749431	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_7												235												235
2749432	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_7												0												0
2749433	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_7												0												0
2750871	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_8												0												0
2750872	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_8												0												0
2750873	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_8												0												0
2750874	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_8												0												0
2750875	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_8												270												270
2750876	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_8												0												0
2750877	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_8												0												0
2752315	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9												0												0
2752316	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9												0												0
2752317	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9												0												0
2752318	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9												0												0
2752319	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_9												0												0
2752320	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_9												232												232
2752321	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_9												0												0
2753759	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_10												0												0
2753760	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_10												0												0
2753761	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_10												0												0
2753762	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_10												0												0
2753763	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_10												0												0
2753764	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_10												218												218
2753765	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_10												0												0
2755203	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_11												0												0
2755204	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_11												0												0
2755205	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_11												0												0
2755206	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_11												0												0
2755207	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_11												0												0
2755208	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												262												262
2755209	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_11												0												0
2756647	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_12												0												0
2756648	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_12												0												0
2756649	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_12												0												0
2756650	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_12												0												0
2756651	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_12												0												0
2756652	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_12												237												237
2756653	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	grade_12												10												10
2758091	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	pk_12_total	261	22	45	0	39	0	13	179	201	36	53	380	261	22	45	0	39	0	13	179	201	36	53	380
2758092	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	pk_12_total	258	31	41	*	27	0	*	192	187	13	47	379	258	31	41		27	0		192	187	13	47	379
2758093	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	pk_12_total	265	15	36	*	9	0	*	178	157	11	16	335	265	15	36		9	0		178	157	11	16	335
2758094	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	pk_12_total	200	*	28	*	30	0	13	149	128	20	34	277	200		28		30	0	13	149	128	20	34	277
2758095	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2021	pk_12_total	551	26	72	0	57	0	33	369	370	16	95	739	551	26	72	0	57	0	33	369	370	16	95	739
2758096	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2021	pk_12_total	723	40	87	0	68	0	31	485	464	11	113	949	723	40	87	0	68	0	31	485	464	11	113	949
2758097	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2021	pk_12_total	7	*	*	0	*	0	0	*	*	0	10	10	7			0		0	0			0	10	10
2739326	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	kindergarten												48												48
2739327	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	kindergarten												0												0
2740770	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1												48												48
2740771	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_1												0												0
2742214	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_2												50												50
2742215	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_2												0												0
2743658	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_3												52												52
2743659	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_3												0												0
2745102	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_4												52												52
2745103	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_4												0												0
2746546	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_5												59												59
2746547	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_5												0												0
2747990	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_6												58												58
2747991	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_6												0												0
2749434	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_7												0												0
2749435	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_7												53												53
2750878	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_8												0												0
2750879	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_8												67												67
2752322	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9												0												0
2752323	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	07	12	2021	grade_9												47												47
2753766	CT	school	903060	1020011	North Stonington School District	90306000634	1020111	North Stonington Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_10												0												0