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 rowid 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1820530	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	pre_kindergarten	4.0	0.0		0.0	0.0	1.0	13.0	4	0		0	0	1	13
1820529	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	pk_12_total	15.0	2.0		9.0	7.0	9.0	117.0	15	2		9	7	9	117
1820528	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	kindergarten	1.0	0.0		0.0	0.0	2.0	6.0	1	0		0	0	2	6
1820527	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	k_12_total	11.0	2.0		9.0	7.0	8.0	104.0	11	2		9	7	8	104
1820526	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_9	1.0	0.0		0.0	0.0	0.0	7.0	1	0		0	0	0	7
1820525	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_8	0.0	0.0		2.0	1.0	0.0	9.0	0	0		2	1	0	9
1820524	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_7	0.0	0.0		2.0	1.0	0.0	6.0	0	0		2	1	0	6
1820523	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_6	2.0	0.0		1.0	2.0	1.0	14.0	2	0		1	2	1	14
1820522	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_5	3.0	0.0		1.0	0.0	1.0	10.0	3	0		1	0	1	10
1820521	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_4	0.0	0.0		1.0	1.0	3.0	10.0	0	0		1	1	3	10
1820520	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_3	0.0	0.0		0.0	0.0	0.0	7.0	0	0		0	0	0	7
1820519	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_2	0.0	0.0		1.0	1.0	1.0	8.0	0	0		1	1	1	8
1820518	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_12	0.0	0.0		0.0	0.0	0.0	5.0	0	0		0	0	0	5
1820517	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_11	1.0	1.0		1.0	0.0	0.0	5.0	1	1		1	0	0	5
1820516	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_10	3.0	1.0		0.0	1.0	0.0	10.0	3	1		0	1	0	10
1820515	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_1	0.0	0.0		0.0	0.0	0.0	7.0	0	0		0	0	0	7
1820514	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0			0.0			8.0	0			0			8
1820513	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	pk_12_total	6.0			2.0			83.0	6			2			83
1820512	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	kindergarten	0.0			0.0			2.0	0			0			2
1820511	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	k_12_total	6.0			2.0			75.0	6			2			75
1820510	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_9	0.0			1.0			11.0	0			1			11
1820509	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_8	1.0			0.0			7.0	1			0			7
1820508	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_7	1.0			1.0			9.0	1			1			9
1820507	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_6	1.0			0.0			4.0	1			0			4
1820506	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_5	0.0			0.0			7.0	0			0			7
1820505	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_4	0.0			0.0			6.0	0			0			6
1820504	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_3	1.0			0.0			3.0	1			0			3
1820503	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_2	0.0			0.0			3.0	0			0			3
1820502	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_12	1.0			0.0			7.0	1			0			7
1820501	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_11	1.0			0.0			3.0	1			0			3
1820500	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_10	0.0			0.0			8.0	0			0			8
1820499	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_1	0.0			0.0			5.0	0			0			5
1820498	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0						15.0	0						15
1820497	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						332.0	1						332
1820496	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	kindergarten	0.0						17.0	0						17
1820495	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	k_12_total	1.0						317.0	1						317
1820494	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_9	0.0						25.0	0						25
1820493	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_8	1.0						29.0	1						29
1820492	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_7	0.0						26.0	0						26
1820491	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_6	0.0						23.0	0						23
1820490	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_5	0.0						36.0	0						36
1820489	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_4	0.0						32.0	0						32
1820488	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_3	0.0						10.0	0						10
1820487	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_2	0.0						27.0	0						27
1820486	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_12	0.0						21.0	0						21
1820485	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_11	0.0						17.0	0						17
1820484	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_10	0.0						29.0	0						29
1820483	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_1	0.0						25.0	0						25
1820482	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	pre_kindergarten						0.0	0.0						0	0
1820481	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	pk_12_total						2.0	214.0						2	214
1820480	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	kindergarten						0.0	16.0						0	16
1820479	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	k_12_total						2.0	214.0						2	214
1820478	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	grade_9						0.0	8.0						0	8