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 and (district_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1814871	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_2	5.0	0.0					0.0	5.0	5	0					0	5
1814872	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_3	1.0	0.0					2.0	4.0	1	0					2	4
1814873	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_4	0.0	1.0					0.0	2.0	0	1					0	2
1814874	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_5	2.0	0.0					0.0	5.0	2	0					0	5
1814875	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_6	0.0	0.0					0.0	0.0	0	0					0	0
1814876	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_7	2.0	0.0					0.0	5.0	2	0					0	5
1814877	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_8	1.0	0.0					1.0	3.0	1	0					1	3
1814878	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_9	0.0	0.0					0.0	2.0	0	0					0	2
1814879	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	k_12_total	26.0	1.0					9.0	51.0	26	1					9	51
1814880	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	kindergarten	0.0	0.0					1.0	2.0	0	0					1	2
1814881	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	pk_12_total	26.0	1.0					9.0	51.0	26	1					9	51
1814882	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0	0.0					0.0	0.0	0	0					0	0
1814883	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_1	0.0							2.0	0							2
1814884	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_10	1.0							2.0	1							2
1814885	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_11	0.0							0.0	0							0
1814886	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_12	0.0							0.0	0							0
1814887	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_2	0.0							0.0	0							0
1814888	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_3	0.0							1.0	0							1
1814889	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_4	0.0							2.0	0							2
1814890	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_5	0.0							0.0	0							0
1814891	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_6	0.0							0.0	0							0
1814892	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_7	0.0							1.0	0							1
1814893	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_8	0.0							1.0	0							1
1814894	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_9	0.0							0.0	0							0
1814895	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	k_12_total	1.0							9.0	1							9
1814896	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	kindergarten	0.0							0.0	0							0
1814897	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							10.0	1							10
1814898	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0							1.0	0							1
1814899	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_1	10.0		1.0	0.0			0.0	13.0	10		1	0			0	13
1814900	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_10	4.0		0.0	0.0			0.0	4.0	4		0	0			0	4
1814901	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_11	2.0		0.0	0.0			0.0	2.0	2		0	0			0	2
1814902	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_12	6.0		0.0	0.0			0.0	6.0	6		0	0			0	6
1814903	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_2	9.0		0.0	0.0			1.0	11.0	9		0	0			1	11
1814904	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_3	14.0		0.0	0.0			0.0	14.0	14		0	0			0	14
1814905	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_4	10.0		0.0	1.0			2.0	13.0	10		0	1			2	13
1814906	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_5	11.0		0.0	1.0			1.0	15.0	11		0	1			1	15
1814907	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_6	11.0		0.0	1.0			3.0	16.0	11		0	1			3	16
1814908	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_7	9.0		0.0	0.0			0.0	10.0	9		0	0			0	10
1814909	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_8	5.0		0.0	0.0			2.0	8.0	5		0	0			2	8
1814910	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_9	7.0		0.0	0.0			1.0	10.0	7		0	0			1	10
1814911	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	k_12_total	108.0		1.0	3.0			10.0	133.0	108		1	3			10	133
1814912	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	kindergarten	10.0		0.0	0.0			0.0	11.0	10		0	0			0	11
1814913	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	pk_12_total	108.0		1.0	3.0			10.0	133.0	108		1	3			10	133
1814914	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0		0.0	0.0			0.0	0.0	0		0	0			0	0
1814915	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_1	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814916	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_10	11.0		0.0	0.0	2.0	0.0	0.0	18.0	11		0	0	2	0	0	18
1814917	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_11	13.0		0.0	0.0	2.0	2.0	1.0	19.0	13		0	0	2	2	1	19
1814918	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_12	7.0		2.0	0.0	5.0	2.0	2.0	19.0	7		2	0	5	2	2	19
1814919	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_2	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814920	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_3	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814921	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_4	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814922	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_5	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814923	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_6	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814924	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_7	9.0		0.0	1.0	5.0	0.0	1.0	23.0	9		0	1	5	0	1	23
1814925	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_8	9.0		1.0	0.0	7.0	0.0	0.0	19.0	9		1	0	7	0	0	19
1814926	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_9	11.0		1.0	1.0	5.0	1.0	0.0	23.0	11		1	1	5	1	0	23
1814927	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	k_12_total	60.0		4.0	2.0	26.0	5.0	4.0	121.0	60		4	2	26	5	4	121
1814928	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	kindergarten	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814929	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	pk_12_total	60.0		4.0	2.0	26.0	5.0	4.0	121.0	60		4	2	26	5	4	121
1814930	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	pre_kindergarten	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814931	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_1	11.0		0.0	1.0	4.0		1.0	22.0	11		0	1	4		1	22
1814932	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814933	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814934	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814935	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_2	7.0		0.0	0.0	4.0		3.0	21.0	7		0	0	4		3	21
1814936	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_3	9.0		2.0	0.0	4.0		0.0	17.0	9		2	0	4		0	17
1814937	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_4	9.0		0.0	0.0	2.0		0.0	15.0	9		0	0	2		0	15
1814938	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	6.0		1.0	0.0	0.0		2.0	13.0	6		1	0	0		2	13
1814939	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	9.0		1.0	0.0	9.0		0.0	26.0	9		1	0	9		0	26
1814940	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814941	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814942	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1814943	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	k_12_total	64.0		6.0	1.0	28.0		7.0	143.0	64		6	1	28		7	143
1814944	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	kindergarten	13.0		2.0	0.0	5.0		1.0	29.0	13		2	0	5		1	29
1814945	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	pk_12_total	64.0		7.0	1.0	28.0		7.0	146.0	64		7	1	28		7	146
1814946	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0		1.0	0.0	0.0		0.0	3.0	0		1	0	0		0	3
1814947	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_1	2.0				0.0		1.0	4.0	2				0		1	4
1814948	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_10	0.0				1.0		0.0	1.0	0				1		0	1
1814949	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_11	1.0				0.0		0.0	1.0	1				0		0	1
1814950	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_12	0.0				0.0		0.0	0.0	0				0		0	0
1814951	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_2	3.0				0.0		0.0	3.0	3				0		0	3
1814952	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_3	2.0				0.0		0.0	2.0	2				0		0	2
1814953	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_4	1.0				0.0		1.0	2.0	1				0		1	2
1814954	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_5	1.0				0.0		0.0	1.0	1				0		0	1
1814955	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_6	1.0				0.0		1.0	2.0	1				0		1	2
1814956	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_7	1.0				0.0		0.0	1.0	1				0		0	1
1814957	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_8	1.0				0.0		0.0	2.0	1				0		0	2
1814958	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_9	0.0				0.0		0.0	1.0	0				0		0	1
1814959	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	k_12_total	19.0				1.0		3.0	26.0	19				1		3	26
1814960	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	kindergarten	6.0				0.0		0.0	6.0	6				0		0	6
1814961	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	pk_12_total	19.0				1.0		3.0	26.0	19				1		3	26
1814962	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	pre_kindergarten	0.0				0.0		0.0	0.0	0				0		0	0
1814963	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_1	0.0						0.0	0.0	0						0	0
1814964	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_10	6.0						7.0	14.0	6						7	14
1814965	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_11	4.0						5.0	14.0	4						5	14
1814966	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_12	12.0						3.0	19.0	12						3	19
1814967	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_2	0.0						0.0	0.0	0						0	0
1814968	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_3	0.0						0.0	0.0	0						0	0
1814969	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_4	0.0						0.0	0.0	0						0	0
1814970	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_5	0.0						0.0	0.0	0						0	0
1814971	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_6	0.0						0.0	0.0	0						0	0