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 > :p3 or (school = :p3 and rowid > :p2)) order by school, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	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
2764713	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_4												0												0
2766174	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_5												0												0
2767635	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_6												0												0
2769096	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_7												0												0
2770557	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_8												0												0
2772018	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_9												0												0
2773479	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_10												*
2774940	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_11												0												0
2776401	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	grade_12												*
2777862	CT	school	170011	Bristol School District		170211	ACCESS	Program	2020	pk_12_total	*	*	*	0	0	0	*	*	*	0	10	10				0	0	0				0	10	10
2759038	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	kindergarten												0												0
2760499	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_1												0												0
2761960	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_2												0												0
2763421	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_3												0												0
2764882	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_4												0												0
2766343	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_5												0												0
2767804	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_6												0												0
2769265	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_7												0												0
2770726	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_8												0												0
2772187	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_9												0												0
2773648	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_10												0												0
2775109	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_11												0												0
2776570	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	grade_12												*
2778031	CT	school	2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program	2020	pk_12_total	*	0	0	0	0	0	0	*	0	0	0	*		0	0	0	0	0	0		0	0	0
2758742	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	kindergarten												*
2760203	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_1												13												13
2761664	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_2												*
2763125	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_3												16												16
2764586	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_4												17												17
2766047	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_5												27												27
2767508	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_6												0												0
2768969	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_7												0												0
2770430	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_8												0												0
2771891	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_9												0												0
2773352	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_10												0												0
2774813	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_11												0												0
2776274	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	grade_12												0												0
2777735	CT	school	2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program	2020	pk_12_total	*	44	22	0	0	0	*	71	15	*	*	86		44	22	0	0	0		71	15			86
2758744	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	kindergarten												0												0
2760205	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_1												*
2761666	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_2												0												0
2763127	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_3												*
2764588	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_4												0												0
2766049	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_5												*
2767510	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_6												0												0
2768971	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_7												0												0
2770432	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_8												0												0
2771893	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_9												0												0
2773354	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_10												0												0
2774815	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_11												0												0
2776276	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	grade_12												0												0
2777737	CT	school	2440014	Area Cooperative Educational Services		2440414	ACES at Mead Elementary School	Program	2020	pk_12_total	0	*	*	0	0	0	*	*	*	0	*	*	0			0	0	0				0
2760141	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	kindergarten												0												0
2761602	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_1												0												0
2763063	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_2												0												0
2764524	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_3												0												0
2765985	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_4												0												0
2767446	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_5												0												0
2768907	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_6												0												0
2770368	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_7												0												0
2771829	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_8												0												0
2773290	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_9												6												6
2774751	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_10												8												8
2776212	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_11												*
2777673	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	grade_12												*
2779134	CT	school	2070012	Regional School District 07	90372001400	2079112	AIM	Program	2020	pk_12_total	18	*	*	0	0	0	*	11	11	0	22	22	18			0	0	0		11	11	0	22	22
2759829	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	kindergarten												0												0
2761290	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_1												0												0
2762751	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_2												0												0
2764212	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_3												0												0
2765673	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_4												0												0
2767134	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_5												*
2768595	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_6												*
2770056	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_7												0												0
2771517	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_8												0												0
2772978	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_9												0												0
2774439	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_10												0												0
2775900	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_11												0												0
2777361	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	grade_12												0												0
2778822	CT	school	1380011	Stratford School District		1382711	ALL Class Room - Second Hill Lane	Program	2020	pk_12_total	*	*	*	0	0	0	0	*	0	0	*	*				0	0	0	0		0	0
2759834	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	kindergarten												0												0
2761295	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_1												0												0
2762756	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_2												0												0
2764217	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_3												0												0
2765678	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_4												0												0
2767139	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_5												0												0
2768600	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_6												0												0
2770061	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_7												0												0
2771522	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_8												0												0
2772983	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_9												6												6
2774444	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_10												19												19
2775905	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_11												6												6
2777366	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	grade_12												8												8
2778827	CT	school	1380011	Stratford School District	90444001701	1380511	ALPHA	Program	2020	pk_12_total	7	16	13	0	*	0	*	23	16	*	11	39	7	16	13	0		0		23	16		11	39
2760022	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	kindergarten												0												0
2761483	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_1												0												0
2762944	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_2												0												0
2764405	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_3												0												0
2765866	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_4												0												0
2767327	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_5												*
2768788	CT	school	1560011	West Haven School District		1561111	ASD Lab		2020	grade_6												*