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 district_state_id desc 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
2433671	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten												103												103
2433672	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	kindergarten												0												0
2433673	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	kindergarten												0												0
2433674	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	kindergarten												0												0
2433675	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	kindergarten												0												0
2435120	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_1												111												111
2435121	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_1												0												0
2435122	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_1												0												0
2435123	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1												0												0
2435124	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_1												0												0
2436569	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2												123												123
2436570	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_2												0												0
2436571	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_2												0												0
2436572	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_2												0												0
2436573	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_2												0												0
2438018	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_3												0												0
2438019	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_3												120												120
2438020	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_3												0												0
2438021	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_3												0												0
2438022	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_3												0												0
2439467	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_4												0												0
2439468	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_4												151												151
2439469	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_4												0												0
2439470	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_4												0												0
2439471	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_4												0												0
2440916	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_5												0												0
2440917	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_5												129												129
2440918	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_5												0												0
2440919	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_5												0												0
2440920	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_5												0												0
2442365	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_6												0												0
2442366	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_6												0												0
2442367	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_6												125												125
2442368	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_6												0												0
2442369	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_6												0												0
2443814	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_7												0												0
2443815	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_7												0												0
2443816	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_7												139												139
2443817	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_7												0												0
2443818	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_7												0												0
2445263	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_8												0												0
2445264	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_8												0												0
2445265	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_8												151												151
2445266	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_8												0												0
2445267	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_8												0												0
2446712	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_9												0												0
2446713	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_9												0												0
2446714	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_9												0												0
2446715	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_9												129												129
2446716	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_9												0												0
2448161	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_10												0												0
2448162	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_10												0												0
2448163	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_10												0												0
2448164	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_10												145												145
2448165	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_10												0												0
2449610	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11												0												0
2449611	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11												0												0
2449612	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11												0												0
2449613	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11												138												138
2449614	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_11												0												0
2451059	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12												0												0
2451060	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_12												0												0
2451061	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_12												0												0
2451062	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_12												132												132
2451063	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_12												*
2452508	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	pk_12_total	333	*	23	0	*	0	0	188	180	7	40	368	333		23	0		0	0	188	180	7	40	368
2452509	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	pk_12_total	352	*	29	*	11	0	0	222	178	*	48	400	352		29		11	0	0	222	178		48	400
2452510	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	pk_12_total	355	15	31	0	14	0	0	226	189	*	58	415	355	15	31	0	14	0	0	226	189		58	415
2452511	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	pk_12_total	476	*	38	*	15	0	0	242	302	*	88	544	476		38		15	0	0	242	302		88	544
2452512	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	pk_12_total	*	0	0	0	0	0	0	*	*	0	*	*		0	0	0	0	0	0			0
2433670	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten												10												10
2435119	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_1												9												9
2436568	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2												12												12
2438017	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_3												15												15
2439466	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4												12												12
2440915	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_5												15												15
2442364	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_6												14												14
2443813	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_7												0												0
2445262	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_8												0												0
2446711	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9												0												0
2448160	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_10												0												0
2449609	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11												0												0
2451058	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_12												0												0
2452507	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	pk_12_total	82	0	*	0	0	0	*	54	41	*	18	95	82	0		0	0	0		54	41		18	95
2433661	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	kindergarten												0												0
2433662	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	kindergarten												60												60
2433663	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	kindergarten												64												64
2433664	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	kindergarten												61												61
2433665	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	kindergarten												62												62
2433666	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	kindergarten												0												0
2433667	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	kindergarten												0												0
2433668	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	kindergarten												0												0
2433669	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2019	kindergarten												0												0
2435110	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	grade_1												0												0
2435111	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1												58												58
2435112	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1												57												57
2435113	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1												67												67
2435114	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1												75												75
2435115	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_1												0												0
2435116	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_1												0												0
2435117	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_1												0												0