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 (school > :p2 or (school = :p2 and rowid > :p1)) 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
2762072	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2												41												41
2763533	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_3												57												57
2764994	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_4												54												54
2766455	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_5												0												0
2767916	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_6												0												0
2769377	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_7												0												0
2770838	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_8												0												0
2772299	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_9												0												0
2773760	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_10												0												0
2775221	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11												0												0
2776682	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_12												0												0
2778143	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	pk_12_total	206	*	22	0	16	0	*	129	123	13	14	252	206		22	0	16	0		129	123	13	14	252
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
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
2759841	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	kindergarten												138												138
2761302	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1												139												139
2762763	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_2												130												130
2764224	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_3												0												0
2765685	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_4												0												0
2767146	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_5												0												0
2768607	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_6												0												0
2770068	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_7												0												0
2771529	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_8												0												0
2772990	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_9												0												0
2774451	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_10												0												0
2775912	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11												0												0
2777373	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_12												0												0
2778834	CT	school	904470	1390011	Suffield School District	90447000903	1390411	A. Ward Spaulding School	Public Schools	Regular School	No	Elementary	PK	02	2020	pk_12_total	373	12	35	0	18	0	16	240	214	24	77	454	373	12	35	0	18	0	16	240	214	24	77	454
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
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
2758797	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten												0												0
2760258	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1												0												0
2761719	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2												0												0
2763180	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3												0												0
2764641	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4												0												0
2766102	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5												0												0
2767563	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6												0												0
2769024	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7												0												0
2770485	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8												0												0
2771946	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_9												0												0
2773407	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_10												0												0
2774868	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_11												0												0
2776329	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_12												0												0
2777790	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	36	46	121	0	*	0	*	141	69	0	137	210	36	46	121	0		0		141	69	0	137	210
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