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 order by school_state_id 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
2738516	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	kindergarten												23												23
2739960	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1												22												22
2741404	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_2												20												20
2742848	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_3												18												18
2744292	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_4												18												18
2745736	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_5												22												22
2747180	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_6												20												20
2748624	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_7												0												0
2750068	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_8												0												0
2751512	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9												0												0
2752956	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_10												0												0
2754400	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_11												0												0
2755844	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_12												0												0
2757288	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	pk_12_total	141	*	22	0	0	0	*	86	87	*	22	173	141		22	0	0	0		86	87		22	173
2738522	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	kindergarten												0												0
2739966	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_1												0												0
2741410	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_2												0												0
2742854	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_3												0												0
2744298	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_4												0												0
2745742	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_5												0												0
2747186	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_6												0												0
2748630	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_7												0												0
2750074	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_8												0												0
2751518	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_9												*
2752962	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_10												7												7
2754406	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_11												12												12
2755850	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	grade_12												*
2757294	CT	school		20011	Ansonia School District	90006001678	20111	P.A.C.E. (Positive And Creative Education)	Program						2021	pk_12_total	*	8	14	0	0	0	*	18	10	*	8	28		8	14	0	0	0		18	10		8	28
2738518	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	kindergarten												92												92
2739962	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1												85												85
2741406	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_2												79												79
2742850	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_3												96												96
2744294	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_4												88												88
2745738	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_5												84												84
2747182	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_6												91												91
2748626	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_7												0												0
2750070	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_8												0												0
2751514	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_9												0												0
2752958	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_10												0												0
2754402	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_11												0												0
2755846	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_12												0												0
2757290	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	pk_12_total	140	134	310	0	*	*	33	320	303	42	113	623	140	134	310	0			33	320	303	42	113	623
2738523	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	kindergarten												0												0
2739967	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_1												0												0
2741411	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_2												0												0
2742855	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_3												0												0
2744299	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_4												0												0
2745743	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_5												0												0
2747187	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_6												0												0
2748631	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_7												0												0
2750075	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_8												0												0
2751519	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_9												*
2752963	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_10												*
2754407	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_11												*
2755851	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	grade_12												0												0
2757295	CT	school		20011	Ansonia School District		20411	P.A.C.E. - PM (Positive And Creative Education - PM)	Program						2021	pk_12_total	*	*	0	0	0	0	*	6	0	0	*	6			0	0	0	0		6	0	0		6
2738519	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	kindergarten												88												88
2739963	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_1												93												93
2741407	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_2												83												83
2742851	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_3												93												93
2744295	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_4												104												104
2745739	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_5												93												93
2747183	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_6												82												82
2748627	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_7												0												0
2750071	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_8												0												0
2751515	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_9												0												0
2752959	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_10												0												0
2754403	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_11												0												0
2755847	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_12												0												0
2757291	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	pk_12_total	204	98	273	0	15	0	46	334	302	44	102	636	204	98	273	0	15	0	46	334	302	44	102	636
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
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
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