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 (school_nces_id > :p3 or (school_nces_id = :p3 and rowid > :p2)) order by school_nces_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	hispanic	asian	total	white_int	hispanic_int	asian_int	total_int
1817831	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_2				12.0				12
1817832	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_3				8.0				8
1817833	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_4				9.0				9
1817834	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_5				10.0				10
1817835	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_6				8.0				8
1817836	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_7				10.0				10
1817837	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_8				8.0				8
1817838	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_9				19.0				19
1817839	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	k_12_total				134.0				134
1817840	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	kindergarten				12.0				12
1817841	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	pk_12_total				148.0				148
1817842	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	pre_kindergarten				14.0				14
1817987	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_1	0.0		0.0	13.0	0		0	13
1817988	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_10	0.0		0.0	15.0	0		0	15
1817989	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_11	0.0		0.0	18.0	0		0	18
1817990	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_12	1.0		0.0	23.0	1		0	23
1817991	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_2	0.0		0.0	13.0	0		0	13
1817992	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_3	0.0		1.0	8.0	0		1	8
1817993	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_4	0.0		0.0	12.0	0		0	12
1817994	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_5	0.0		0.0	7.0	0		0	7
1817995	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_6	0.0		0.0	13.0	0		0	13
1817996	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_7	0.0		0.0	13.0	0		0	13
1817997	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_8	0.0		0.0	8.0	0		0	8
1817998	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_9	0.0		0.0	11.0	0		0	11
1817999	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	k_12_total	1.0		1.0	173.0	1		1	173
1818000	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	kindergarten	0.0		0.0	19.0	0		0	19
1818001	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0		1.0	174.0	1		1	174
1818002	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	pre_kindergarten	0.0		0.0	1.0	0		0	1
1817923	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_1				15.0				15
1817924	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_10				13.0				13
1817925	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_11				14.0				14
1817926	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_12				9.0				9
1817927	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_2				16.0				16
1817928	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_3				14.0				14
1817929	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_4				15.0				15
1817930	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_5				18.0				18
1817931	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_6				16.0				16
1817932	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_7				8.0				8
1817933	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_8				17.0				17
1817934	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_9				27.0				27
1817935	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	k_12_total				191.0				191
1817936	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	kindergarten				9.0				9
1817937	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total				192.0				192
1817938	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	pre_kindergarten				1.0				1
1817955	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_1				2.0				2
1817956	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_10				1.0				1
1817957	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_11				0.0				0
1817958	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_12				0.0				0
1817959	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_2				1.0				1
1817960	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_3				3.0				3
1817961	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_4				1.0				1
1817962	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_5				0.0				0
1817963	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_6				1.0				1
1817964	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_7				1.0				1
1817965	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_8				0.0				0
1817966	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_9				1.0				1
1817967	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	k_12_total				11.0				11
1817968	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	kindergarten				0.0				0
1817969	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	pk_12_total				11.0				11
1817970	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	pre_kindergarten				0.0				0
1818051	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_1	0.0	0.0		0.0	0	0		0
1818052	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_10	0.0	0.0		7.0	0	0		7
1818053	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_11	1.0	0.0		5.0	1	0		5
1818054	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_12	1.0	1.0		12.0	1	1		12
1818055	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_2	0.0	0.0		0.0	0	0		0
1818056	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_3	0.0	0.0		0.0	0	0		0
1818057	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_4	0.0	0.0		0.0	0	0		0
1818058	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_5	0.0	0.0		0.0	0	0		0
1818059	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_6	0.0	0.0		0.0	0	0		0
1818060	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_7	0.0	0.0		0.0	0	0		0
1818061	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_8	0.0	0.0		0.0	0	0		0
1818062	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_9	0.0	0.0		3.0	0	0		3
1818063	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	k_12_total	2.0	1.0		27.0	2	1		27
1818064	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	kindergarten	0.0	0.0		0.0	0	0		0
1818065	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	pk_12_total	2.0	1.0		27.0	2	1		27
1818066	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	pre_kindergarten	0.0	0.0		0.0	0	0		0
1818083	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_1	1.0			32.0	1			32
1818084	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_10	0.0			0.0	0			0
1818085	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_11	0.0			0.0	0			0
1818086	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_12	0.0			0.0	0			0
1818087	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_2	2.0			32.0	2			32
1818088	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_3	0.0			17.0	0			17
1818089	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_4	0.0			16.0	0			16
1818090	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_5	2.0			19.0	2			19
1818091	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_6	0.0			15.0	0			15
1818092	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_7	0.0			0.0	0			0
1818093	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_8	0.0			0.0	0			0
1818094	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_9	0.0			0.0	0			0
1818095	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	k_12_total	6.0			157.0	6			157
1818096	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	kindergarten	1.0			26.0	1			26
1818097	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	pk_12_total	6.0			157.0	6			157
1818098	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	pre_kindergarten	0.0			0.0	0			0
1818035	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_1				9.0				9
1818036	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_10				10.0				10
1818037	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_11				9.0				9
1818038	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_12				2.0				2
1818039	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_2				13.0				13
1818040	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_3				4.0				4
1818041	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_4				7.0				7
1818042	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_5				14.0				14
1818043	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_6				6.0				6