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_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
2739615	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	kindergarten												134												134
2741059	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1												137												137
2742503	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_2												141												141
2743947	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_3												0												0
2745391	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_4												0												0
2746835	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_5												0												0
2748279	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_6												0												0
2749723	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_7												0												0
2751167	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_8												0												0
2752611	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_9												0												0
2754055	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_10												0												0
2755499	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_11												0												0
2756943	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_12												0												0
2758387	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2021	pk_12_total	376	15	32	0	20	0	10	237	216	29	67	453	376	15	32	0	20	0	10	237	216	29	67	453
2738570	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten												0												0
2740014	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_1												0												0
2741458	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_2												0												0
2742902	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3												0												0
2744346	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_4												0												0
2745790	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_5												0												0
2747234	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_6												0												0
2748678	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_7												0												0
2750122	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_8												0												0
2751566	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_9												0												0
2753010	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_10												0												0
2754454	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_11												0												0
2755898	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_12												0												0
2757342	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	20	58	117	*	6	0	*	125	80	0	126	205	20	58	117		6	0		125	80	0	126	205
2739815	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	kindergarten												*
2741259	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_1												*
2742703	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_2												*
2744147	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_3												*
2745591	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_4												*
2747035	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_5												*
2748479	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_6												*
2749923	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_7												0												0
2751367	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_8												0												0
2752811	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_9												0												0
2754255	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_10												0												0
2755699	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_11												0												0
2757143	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	grade_12												0												0
2758587	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2021	pk_12_total	*	*	10	0	*	0	*	9	9	6	18	18			10	0		0		9	9	6	18	18
2739594	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	kindergarten												*
2741038	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_1												8												8
2742482	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_2												*
2743926	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_3												*
2745370	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_4												*
2746814	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_5												8												8
2748258	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_6												0												0
2749702	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_7												0												0
2751146	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_8												0												0
2752590	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_9												0												0
2754034	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_10												0												0
2755478	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_11												0												0
2756922	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_12												0												0
2758366	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	pk_12_total	11	7	9	0	*	0	*	23	8	0	31	31	11	7	9	0		0		23	8	0	31	31
2739867	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	kindergarten												0												0
2741311	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_1												*
2742755	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_2												*
2744199	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_3												*
2745643	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_4												0												0
2747087	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_5												0												0
2748531	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_6												0												0
2749975	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_7												0												0
2751419	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_8												0												0
2752863	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_9												0												0
2754307	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_10												0												0
2755751	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_11												0												0
2757195	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	grade_12												0												0
2758639	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2021	pk_12_total	*	0	0	0	0	0	*	*	*	0	7	7		0	0	0	0	0				0	7	7
2738642	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	kindergarten												0												0
2740086	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_1												0												0
2741530	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_2												0												0
2742974	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_3												0												0
2744418	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_4												0												0
2745862	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_5												0												0
2747306	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_6												0												0
2748750	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_7												0												0
2750194	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_8												0												0
2751638	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_9												0												0
2753082	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_10												*
2754526	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_11												*
2755970	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_12												8												8
2757414	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	pk_12_total	*	0	8	0	0	0	*	8	*	0	11	11		0	8	0	0	0		8		0	11	11
2738817	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	kindergarten												0												0
2740261	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_1												0												0
2741705	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_2												0												0
2743149	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_3												0												0
2744593	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_4												0												0
2746037	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_5												0												0
2747481	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_6												0												0
2748925	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_7												0												0
2750369	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_8												0												0
2751813	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_9												0												0
2753257	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_10												*
2754701	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_11												*
2756145	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	grade_12												0												0
2757589	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2021	pk_12_total	*	0	*	0	0	0	0	*	0	0	*	*		0		0	0	0	0		0	0
2739877	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	kindergarten												*
2741321	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_1												*
2742765	CT	school		2440014	Area Cooperative Educational Services		2440214	ACES Mill Elementary School	Program						2021	grade_2												16												16