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_state_id > :p2 or (school_state_id = :p2 and rowid > :p1)) order by school_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
2438658	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_4												0												0
2440107	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_5												0												0
2441556	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_6												0												0
2443005	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_7												0												0
2444454	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_8												0												0
2445903	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_9												0												0
2447352	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_10												0												0
2448801	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_11												0												0
2450250	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	grade_12												0												0
2451699	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2019	pk_12_total	27	16	43	0	*	0	*	58	36	0	18	94	27	16	43	0		0		58	36	0	18	94
2738517	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	kindergarten												0												0
2739961	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_1												0												0
2741405	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_2												0												0
2742849	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_3												0												0
2744293	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_4												0												0
2745737	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_5												0												0
2747181	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_6												0												0
2748625	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_7												0												0
2750069	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_8												0												0
2751513	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_9												0												0
2752957	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_10												0												0
2754401	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_11												0												0
2755845	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	grade_12												0												0
2757289	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2021	pk_12_total	14	*	26	0	0	0	*	28	23	0	15	51	14		26	0	0	0		28	23	0	15	51
2758733	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	kindergarten												0												0
2760194	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_1												0												0
2761655	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_2												0												0
2763116	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_3												0												0
2764577	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_4												0												0
2766038	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_5												0												0
2767499	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_6												0												0
2768960	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_7												0												0
2770421	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_8												0												0
2771882	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_9												0												0
2773343	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_10												0												0
2774804	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_11												0												0
2776265	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	grade_12												0												0
2777726	CT	school		20011	Ansonia School District		20911	Ansonia Public Schools Pre-K Program	Program						2020	pk_12_total	32	16	41	0	*	0	*	58	35	0	30	93	32	16	41	0		0		58	35	0	30	93
2738524	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	kindergarten												0												0
2739968	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_1												0												0
2741412	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_2												0												0
2742856	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_3												0												0
2744300	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_4												0												0
2745744	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_5												0												0
2747188	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_6												0												0
2748632	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_7												0												0
2750076	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_8												0												0
2751520	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_9												0												0
2752964	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_10												0												0
2754408	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_11												0												0
2755852	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	grade_12												*
2757296	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2021	pk_12_total	*	0	*	0	0	0	0	*	0	*	*	*		0		0	0	0	0		0
2758740	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	kindergarten												0												0
2760201	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_1												0												0
2761662	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_2												0												0
2763123	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_3												0												0
2764584	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_4												0												0
2766045	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_5												0												0
2767506	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_6												0												0
2768967	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_7												0												0
2770428	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_8												0												0
2771889	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_9												0												0
2773350	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_10												0												0
2774811	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_11												0												0
2776272	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	grade_12												7												7
2777733	CT	school		20011	Ansonia School District		21011	Ansonia 18-21 Transition Program	Program						2020	pk_12_total	*	0	*	0	0	0	*	*	*	*	7	7		0		0	0	0					7	7
2432865	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	kindergarten												0												0
2434314	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_1												0												0
2435763	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_2												0												0
2437212	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_3												0												0
2438661	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_4												0												0
2440110	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_5												0												0
2441559	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_6												0												0
2443008	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_7												166												166
2444457	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_8												169												169
2445906	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_9												0												0
2447355	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_10												0												0
2448804	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_11												0												0
2450253	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_12												0												0
2451702	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2019	pk_12_total	121	64	130	0	*	*	13	173	162	12	72	335	121	64	130	0			13	173	162	12	72	335
2738520	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	kindergarten												0												0
2739964	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_1												0												0
2741408	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_2												0												0
2742852	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_3												0												0
2744296	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_4												0												0
2745740	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_5												0												0
2747184	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_6												0												0
2748628	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_7												177												177
2750072	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_8												188												188
2751516	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_9												0												0
2752960	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_10												0												0
2754404	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_11												0												0
2755848	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	grade_12												0												0
2757292	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2021	pk_12_total	109	63	164	0	7	0	22	192	173	17	63	365	109	63	164	0	7	0	22	192	173	17	63	365
2758736	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	kindergarten												0												0
2760197	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_1												0												0
2761658	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_2												0												0
2763119	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_3												0												0
2764580	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_4												0												0
2766041	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_5												0												0
2767502	CT	school	900060	20011	Ansonia School District	90006010008	25111	Ansonia Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_6												0												0