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 order by district_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	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
2433676	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten												31											31
2435125	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_1												27											27
2436574	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2												37											37
2438023	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3												22											22
2439472	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4												18											18
2440921	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_5												28											28
2442370	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_6												38											38
2443819	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_7												20											20
2445268	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_8												28											28
2446717	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_9												0											0
2448166	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10												0											0
2449615	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11												0											0
2451064	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12												0											0
2452513	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	pk_12_total	213	*	28	0	*	0	9	127	128	7	42	255	213	28	0		0	9	127	128	7	42	255
2759541	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	kindergarten												28											28
2761002	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1												22											22
2762463	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_2												28											28
2763924	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3												36											36
2765385	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_4												23											23
2766846	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_5												16											16
2768307	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_6												28											28
2769768	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_7												40											40
2771229	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8												20											20
2772690	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_9												0											0
2774151	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_10												0											0
2775612	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11												0											0
2777073	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_12												0											0
2778534	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2020	pk_12_total	206	*	32	0	*	0	12	129	124	9	40	253	206	32	0		0	12	129	124	9	40	253
2739318	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	kindergarten												24											24
2740762	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1												19											19
2742206	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_2												21											21
2743650	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3												28											28
2745094	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_4												36											36
2746538	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_5												23											23
2747982	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_6												19											19
2749426	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_7												27											27
2750870	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_8												41											41
2752314	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_9												0											0
2753758	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10												0											0
2755202	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_11												0											0
2756646	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_12												0											0
2758090	CT	school	903000	1000011	North Canaan School District	90300000626	1000111	North Canaan Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	pk_12_total	204	*	32	0	*	0	9	125	123	8	40	248	204	32	0		0	9	125	123	8	40	248
2432861	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten												22											22
2434310	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_1												18											18
2435759	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2												16											16
2437208	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_3												22											22
2438657	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4												21											21
2440106	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_5												28											28
2441555	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_6												27											27
2443004	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_7												0											0
2444453	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_8												0											0
2445902	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_9												0											0
2447351	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_10												0											0
2448800	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11												0											0
2450249	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_12												0											0
2451698	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	pk_12_total	164	*	17	0	0	0	*	101	90	*	12	191	164	17	0	0	0		101	90		12	191
2758732	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	kindergarten												20											20
2760193	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1												23											23
2761654	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_2												20											20
2763115	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_3												18											18
2764576	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_4												23											23
2766037	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_5												22											22
2767498	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_6												27											27
2768959	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_7												0											0
2770420	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8												0											0
2771881	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_9												0											0
2773342	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_10												0											0
2774803	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_11												0											0
2776264	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_12												0											0
2777725	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	pk_12_total	158	*	24	0	0	0	*	99	96	*	21	195	158	24	0	0	0		99	96		21	195
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
2433677	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												55											55
2433678	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												48											48
2433679	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												36											36
2433680	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten												53											53
2433681	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2019	kindergarten												0											0
2433682	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2019	kindergarten												0											0
2433683	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2019	kindergarten												0											0
2435126	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												64											64
2435127	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												62											62
2435128	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												52											52
2435129	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_1												55											55
2435130	CT	school	903030	1010011	North Haven School District	90303000632	1015211	North Haven Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_1												0											0
2435131	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2019	grade_1												0											0
2435132	CT	school		1010011	North Haven School District	90303001733	1010111	North Haven Transition Partnership	Program						2019	grade_1												0											0
2436575	CT	school	903030	1010011	North Haven School District	90303000627	1010811	Clintonville Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2												63											63
2436576	CT	school	903030	1010011	North Haven School District	90303000628	1010711	Green Acres Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2												60											60
2436577	CT	school	903030	1010011	North Haven School District	90303000630	1010211	Montowese Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2												47											47