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
2433973	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten												129												129
2435422	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1												129												129
2436871	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2												133												133
2438320	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_3												0												0
2439769	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_4												0												0
2441218	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_5												0												0
2442667	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_6												0												0
2444116	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_7												0												0
2445565	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_8												0												0
2447014	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_9												0												0
2448463	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_10												0												0
2449912	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11												0												0
2451361	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12												0												0
2452810	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2019	pk_12_total	367	10	25	0	16	0	12	226	204	14	67	430	367	10	25	0	16	0	12	226	204	14	67	430
2432924	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten												0												0
2434373	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_1												0												0
2435822	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_2												0												0
2437271	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3												0												0
2438720	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_4												0												0
2440169	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_5												0												0
2441618	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_6												0												0
2443067	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_7												0												0
2444516	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_8												0												0
2445965	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_9												0												0
2447414	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_10												0												0
2448863	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_11												0												0
2450312	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_12												0												0
2451761	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	41	63	107	0	*	0	*	145	81	0	127	226	41	63	107	0		0		145	81	0	127	226
2434037	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	kindergarten												0												0
2435486	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_1												0												0
2436935	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_2												0												0
2438384	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_3												0												0
2439833	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_4												0												0
2441282	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_5												0												0
2442731	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_6												*
2444180	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_7												*
2445629	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_8												*
2447078	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_9												*
2448527	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_10												8												8
2449976	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_11												*
2451425	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	grade_12												*
2452874	CT	school		1480011	Wallingford School District		1489011	A.R.T.S. Academy							2019	pk_12_total	16	0	*	0	0	0	*	*	*	0	21	21	16	0		0	0	0				0	21	21
2434182	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	kindergarten												0												0
2435631	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_1												*
2437080	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_2												*
2438529	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_3												0												0
2439978	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_4												*
2441427	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_5												0												0
2442876	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_6												0												0
2444325	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_7												0												0
2445774	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_8												0												0
2447223	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_9												0												0
2448672	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_10												0												0
2450121	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_11												0												0
2451570	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	grade_12												0												0
2453019	CT	school		1590011	Wethersfield School District		1590411	ABA	Program						2019	pk_12_total	0	*	*	0	0	0	*	*	*	*	7	7	0			0	0	0					7	7
2433953	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	kindergarten												*
2435402	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_1												*
2436851	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_2												*
2438300	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_3												8												8
2439749	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_4												*
2441198	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_5												0												0
2442647	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_6												0												0
2444096	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_7												0												0
2445545	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_8												0												0
2446994	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_9												0												0
2448443	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_10												0												0
2449892	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_11												0												0
2451341	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	grade_12												0												0
2452790	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2019	pk_12_total	12	*	*	0	*	0	*	15	6	0	21	21	12			0		0		15	6	0	21	21
2434224	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	kindergarten												*
2435673	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_1												*
2437122	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_2												*
2438571	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_3												0												0
2440020	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_4												0												0
2441469	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_5												*
2442918	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_6												0												0
2444367	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_7												0												0
2445816	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_8												0												0
2447265	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_9												0												0
2448714	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_10												0												0
2450163	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_11												0												0
2451612	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	grade_12												0												0
2453061	CT	school		1660011	Wolcott School District	90528001783	1660311	ABC Classroom	Program						2019	pk_12_total	*	0	*	0	0	0	0	*	*	0	*	*		0		0	0	0	0			0
2432994	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	kindergarten												0												0
2434443	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_1												0												0
2435892	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_2												0												0
2437341	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_3												0												0
2438790	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_4												0												0
2440239	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_5												0												0
2441688	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_6												0												0
2443137	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_7												0												0
2444586	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_8												0												0
2446035	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_9												0												0
2447484	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_10												0												0
2448933	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_11												0												0
2450382	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_12												10												10
2451831	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	pk_12_total	*	0	*	0	0	0	0	*	*	*	10	10		0		0	0	0	0				10	10
2433166	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	kindergarten												0												0
2434615	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_1												0												0
2436064	CT	school		2420014	EdAdvance		2420414	ACCESS-South Expelled Student	Program						2019	grade_2												0												0