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 school_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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1738244	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_1	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738245	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_10	11.0		2.0	0.0	2.0	2.0	113	11		2	0	2	2	113
1738246	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_11	9.0		1.0	3.0	0.0	0.0	100	9		1	3	0	0	100
1738247	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_12	11.0		2.0	0.0	0.0	1.0	98	11		2	0	0	1	98
1738248	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_2	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738249	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_3	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738250	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_4	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738251	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_5	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738252	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_6	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738253	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_7	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738254	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_8	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738255	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_9	7.0		0.0	1.0	1.0	5.0	120	7		0	1	1	5	120
1738256	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	k_12_total	38.0		5.0	4.0	3.0	8.0	431	38		5	4	3	8	431
1738257	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	kindergarten	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1738258	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	pk_12_total	38.0		5.0	4.0	3.0	8.0	431	38		5	4	3	8	431
1738259	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	pre_kindergarten	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1820563	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820564	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_10	10.0	0.0	0.0	1.0	0.0	5.0	108.0	10	0	0	1	0	5	108
1820565	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_11	7.0	1.0	1.0	0.0	2.0	2.0	93.0	7	1	1	0	2	2	93
1820566	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_12	4.0	0.0	2.0	1.0	0.0	0.0	78.0	4	0	2	1	0	0	78
1820567	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820568	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820569	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820570	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820571	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1820572	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1820573	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1820574	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_9	14.0	1.0	1.0	1.0	0.0	2.0	95.0	14	1	1	1	0	2	95
1820575	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	k_12_total	35.0	2.0	4.0	3.0	2.0	9.0	374.0	35	2	4	3	2	9	374
1820576	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1820577	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	pk_12_total	35.0	2.0	4.0	3.0	2.0	9.0	374.0	35	2	4	3	2	9	374
1820578	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	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
1738228	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_1	0.0						1	0						1
1738229	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0						0	0						0
1738230	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_11	1.0						1	1						1
1738231	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0						0	0						0
1738232	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_2	0.0						0	0						0
1738233	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_3	0.0						0	0						0
1738234	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_4	0.0						1	0						1
1738235	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_5	0.0						1	0						1
1738236	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_6	0.0						0	0						0
1738237	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						1	0						1
1738238	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_8	0.0						0	0						0
1738239	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_9	0.0						1	0						1
1738240	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	k_12_total	1.0						6	1						6
1738241	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	kindergarten	0.0						0	0						0
1738242	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0						7	1						7
1738243	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	pre_kindergarten	0.0						1	0						1
1820547	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_1	1.0					0.0	1.0	1					0	1
1820548	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_10	0.0					0.0	0.0	0					0	0
1820549	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_11	0.0					0.0	0.0	0					0	0
1820550	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_12	1.0					0.0	1.0	1					0	1
1820551	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_2	0.0					0.0	2.0	0					0	2
1820552	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_3	0.0					0.0	0.0	0					0	0
1820553	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_4	0.0					0.0	0.0	0					0	0
1820554	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_5	0.0					0.0	1.0	0					0	1
1820555	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_6	0.0					0.0	1.0	0					0	1
1820556	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_7	0.0					0.0	0.0	0					0	0
1820557	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_8	1.0					0.0	2.0	1					0	2
1820558	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_9	0.0					0.0	0.0	0					0	0
1820559	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	k_12_total	3.0					0.0	10.0	3					0	10
1820560	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	kindergarten	0.0					0.0	2.0	0					0	2
1820561	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	pk_12_total	3.0					1.0	11.0	3					1	11
1820562	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0					1.0	1.0	0					1	1
1738212	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_1	0.0					0.0	0	0					0	0
1738213	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0					0.0	0	0					0	0
1738214	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_11	0.0					0.0	0	0					0	0
1738215	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0					0.0	1	0					0	1
1738216	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_2	0.0					0.0	4	0					0	4
1738217	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_3	0.0					0.0	0	0					0	0
1738218	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_4	1.0					0.0	4	1					0	4
1738219	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_5	0.0					1.0	2	0					1	2
1738220	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_6	1.0					1.0	2	1					1	2
1738221	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					0.0	1	0					0	1
1738222	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_8	0.0					0.0	3	0					0	3
1738223	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_9	0.0					0.0	0	0					0	0
1738224	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	k_12_total	2.0					3.0	20	2					3	20
1738225	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	kindergarten	0.0					1.0	3	0					1	3
1738226	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0					3.0	20	2					3	20
1738227	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	pre_kindergarten	0.0					0.0	0	0					0	0
1820531	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_1	0.0					1.0	2.0	0					1	2
1820532	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_10	0.0					0.0	0.0	0					0	0
1820533	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_11	0.0					0.0	0.0	0					0	0
1820534	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_12	0.0					0.0	0.0	0					0	0
1820535	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_2	0.0					0.0	0.0	0					0	0
1820536	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_3	0.0					0.0	4.0	0					0	4
1820537	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_4	0.0					0.0	0.0	0					0	0
1820538	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_5	0.0					0.0	3.0	0					0	3
1820539	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_6	0.0					1.0	2.0	0					1	2
1820540	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_7	1.0					1.0	2.0	1					1	2
1820541	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_8	0.0					0.0	1.0	0					0	1
1820542	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_9	0.0					0.0	3.0	0					0	3
1820543	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	k_12_total	1.0					3.0	17.0	1					3	17
1820544	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	kindergarten	0.0					0.0	0.0	0					0	0
1820545	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0					3.0	17.0	1					3	17
1820546	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0					0.0	0.0	0					0	0
1738196	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_1	0.0	0.0		1.0	1.0	1.0	10	0	0		1	1	1	10
1738197	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_10	1.0	1.0		1.0	0.0	0.0	5	1	1		1	0	0	5
1738198	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_11	0.0	0.0		0.0	0.0	0.0	5	0	0		0	0	0	5
1738199	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0	0.0		0.0	1.0	0.0	9	0	0		0	1	0	9
1738200	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_2	0.0	0.0		0.0	0.0	0.0	6	0	0		0	0	0	6