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 "grade" = :p0 and "state" = :p1 and (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_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	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
1732135	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0	0.0						4	0	0						4
1732151	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12.0	2020	grade_12								0								0
1732167	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							2	0							2
1732183	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12.0	2020	grade_12								4								4
1732199	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							9	0							9
1732215	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							7	0							7
1732231	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12.0	2020	grade_12								13								13
1732247	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0	0.0						13	0	0						13
1732263	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12.0	2020	grade_12								4								4
1732279	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12.0	2020	grade_12					0.0			0					0			0
1732295	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12.0	2020	grade_12								1								1
1732311	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							18	0							18
1732327	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12.0	2020	grade_12								20								20
1732343	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0				0.0		0.0	9	0				0		0	9
1814438	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12	2021	grade_12	0.0							6.0	0							6
1814454	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12	2021	grade_12	0.0	0.0						9.0	0	0						9
1814470	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12	2021	grade_12								0.0								0
1814486	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12	2021	grade_12	0.0							2.0	0							2
1814502	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12	2021	grade_12								5.0								5
1814518	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12	2021	grade_12	0.0	0.0	0.0					11.0	0	0	0					11
1814534	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12	2021	grade_12	0.0							5.0	0							5
1814550	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12	2021	grade_12	0.0							7.0	0							7
1814566	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12	2021	grade_12	0.0	0.0						9.0	0	0						9
1814582	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12	2021	grade_12								8.0								8
1814598	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12	2021	grade_12					0.0			2.0					0			2
1814614	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12	2021	grade_12								4.0								4
1814630	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12	2021	grade_12	0.0							9.0	0							9
1814646	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12	2021	grade_12								23.0								23
1814662	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12	2021	grade_12	0.0		0.0				2.0	9.0	0		0				2	9
1732359	AK	school	200030	8	Bristol Bay Borough Schools	20003000020	80010	Bristol Bay Middle/High School	Regular School	No	High	07	12.0	2020	grade_12	0.0	0.0	0.0		1.0		1.0	6	0	0	0		1		1	6
1732375	AK	school	200030	8	Bristol Bay Borough Schools	20003000626	80020	Naknek Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0		0.0		0.0		0.0	0	0		0		0		0	0
1732391	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12.0	2020	grade_12	1.0							2	1							2
1814678	AK	school	200030	8	Bristol Bay Borough Schools	20003000020	80010	Bristol Bay Middle/High School	Regular School	No	High	07	12	2021	grade_12	2.0				0.0	0.0	1.0	6.0	2				0	0	1	6
1814694	AK	school	200030	8	Bristol Bay Borough Schools	20003000626	80020	Naknek 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
1814710	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12	2021	grade_12	0.0							0.0	0							0
1730359	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							0	0							0
1730375	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	grade_12	1.0						0.0	1	1						0	1
1730391	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12.0	2020	grade_12								2								2
1730407	AK	school	200050	3	Alaska Gateway Schools	20005000027	30040	Walter Northway School	Regular School	No	Other	PK	12.0	2020	grade_12							0.0	3							0	3
1730423	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8.0	2020	grade_12		0.0					0.0	0		0					0	0
1730439	AK	school	200050	3	Alaska Gateway Schools	20005000028	30060	Tok School	Regular School	No	Other	PK	12.0	2020	grade_12	5.0			0.0	0.0		0.0	16	5			0	0		0	16
1730455	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_12	0.0							1	0							1
1730471	AK	school	200050	3	Alaska Gateway Schools	20005000023	38010	Alaska REACH Academy	Regular School	No	Other	PK	12.0	2020	grade_12	4.0		0.0		1.0		0.0	7	4		0		1		0	7
1812694	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_12	0.0						0.0	1.0	0						0	1
1812710	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_12	2.0						0.0	2.0	2						0	2
1812726	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12	2021	grade_12								2.0								2
1812742	AK	school	200050	3	Alaska Gateway Schools	20005000027	30040	Walter Northway School	Regular School	No	Other	PK	12	2021	grade_12							0.0	3.0							0	3
1812758	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8	2021	grade_12							0.0	0.0							0	0
1812774	AK	school	200050	3	Alaska Gateway Schools	20005000028	30060	Tok School	Regular School	No	Other	PK	12	2021	grade_12	6.0			0.0	1.0		1.0	20.0	6			0	1		1	20
1812790	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12	2021	grade_12								3.0								3
1812806	AK	school	200050	3	Alaska Gateway Schools	20005000023	38010	Alaska REACH Academy	Regular School	No	Other	PK	12	2021	grade_12	3.0		0.0		0.0		0.0	4.0	3		0		0		0	4
1732615	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12.0	2020	grade_12	18.0		1.0	0.0	5.0	0.0	0.0	30	18		1	0	5	0	0	30
1732631	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0		0.0	0.0	0.0		0.0	0	0		0	0	0		0	0
1732647	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12.0	2020	grade_12	1.0				1.0			2	1				1			2
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
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
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
1732535	AK	school	200070	11	Copper River Schools	20007000034	110060	Glennallen Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0		0.0	0.0	0.0	0.0	0.0	0	0		0	0	0	0	0	0
1732551	AK	school	200070	11	Copper River Schools	20007000039	110070	Glennallen Jr/Sr High School	Regular School	No	High	07	12.0	2020	grade_12	14.0		0.0		1.0	2.0	1.0	25	14		0		1	2	1	25
1732567	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12.0	2020	grade_12	2.0						0.0	3	2						0	3
1732583	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12.0	2020	grade_12	2.0							2	2							2
1732599	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12.0	2020	grade_12	6.0		0.0	0.0			0.0	6	6		0	0			0	6
1814838	AK	school	200070	11	Copper River Schools	20007000034	110060	Glennallen 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
1814854	AK	school	200070	11	Copper River Schools	20007000039	110070	Glennallen Jr/Sr High School	Regular School	No	High	07	12	2021	grade_12	8.0		0.0			0.0	1.0	14.0	8		0			0	1	14
1814870	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_12	4.0	0.0					3.0	7.0	4	0					3	7
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
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
1732663	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12.0	2020	grade_12	11.0				1.0		1.0	21	11				1		1	21
1732679	AK	school	200090	13	Craig City Schools	20009000629	130020	Craig Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_12	0.0				0.0		0.0	0	0				0		0	0
1732695	AK	school	200090	13	Craig City Schools	20009000433	130030	Craig Middle School	Regular School	No	Middle	06	8.0	2020	grade_12	0.0						0.0	0	0						0	0
1732711	AK	school	200090	13	Craig City Schools	20009000160	138010	PACE Correspondence	Regular School	No	Other	KG	12.0	2020	grade_12	8.0	1.0	0.0	0.0	0.0	0.0	6.0	17	8	1	0	0	0	0	6	17
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
1814982	AK	school	200090	13	Craig City Schools	20009000629	130020	Craig Elementary	Regular School	No	Elementary	PK	5	2021	grade_12	0.0				0.0		0.0	0.0	0				0		0	0
1814998	AK	school	200090	13	Craig City Schools	20009000433	130030	Craig Middle School	Regular School	No	Middle	06	8	2021	grade_12	0.0						0.0	0.0	0						0	0
1815014	AK	school	200090	13	Craig City Schools	20009000160	138010	PACE Correspondence	Regular School	No	Other	KG	12	2021	grade_12	18.0	0.0	0.0	0.0	2.0	0.0	6.0	30.0	18	0	0	0	2	0	6	30
1732727	AK	school	200100	14	Delta/Greely Schools	20010000559	140020	Delta Junction Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1732743	AK	school	200100	14	Delta/Greely Schools	20010000630	140030	Delta Junction Senior High School	Regular School	No	High	09	12.0	2020	grade_12	37.0	1.0	5.0	1.0	0.0	0.0	3.0	48	37	1	5	1	0	0	3	48
1732759	AK	school	200100	14	Delta/Greely Schools	20010000510	140090	Gerstle River School	Regular School	No	Other	KG	12.0	2020	grade_12	0.0							0	0							0
1732775	AK	school	200100	14	Delta/Greely Schools	20010000764	140100	Delta Junction Junior High School	Regular School	No	Middle	06	8.0	2020	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0	0	0	0	0		0	0	0
1732791	AK	school	200100	14	Delta/Greely Schools	20010000599	148010	Alaska Homeschool	Regular School	No	Other	KG	12.0	2020	grade_12	6.0		0.0				0.0	6	6		0				0	6
1815030	AK	school	200100	14	Delta/Greely Schools	20010000559	140020	Delta Junction Elementary	Regular School	No	Elementary	PK	5	2021	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1815046	AK	school	200100	14	Delta/Greely Schools	20010000630	140030	Delta Junction Senior High School	Regular School	No	High	09	12	2021	grade_12	19.0	0.0	1.0		0.0	3.0	1.0	25.0	19	0	1		0	3	1	25
1815062	AK	school	200100	14	Delta/Greely Schools	20010000510	140090	Gerstle River School	Regular School	No	Other	KG	12	2021	grade_12	2.0							2.0	2							2
1815078	AK	school	200100	14	Delta/Greely Schools	20010000764	140100	Delta Junction Junior High School	Regular School	No	Middle	06	8	2021	grade_12	0.0		0.0			0.0	0.0	0.0	0		0			0	0	0
1815094	AK	school	200100	14	Delta/Greely Schools	20010000599	148010	Alaska Homeschool	Regular School	No	Other	PK	12	2021	grade_12	14.0	0.0	1.0	0.0			1.0	17.0	14	0	1	0			1	17
1732807	AK	school	200120	15	Dillingham City Schools	20012000042	150010	Dillingham Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_12	0.0	0.0	0.0		0.0		0.0	0	0	0	0		0		0	0
1732823	AK	school	200120	15	Dillingham City Schools	20012000634	150020	Dillingham Middle/High School	Regular School	No	High	06	12.0	2020	grade_12	4.0		1.0			1.0	7.0	23	4		1			1	7	23
1815110	AK	school	200120	15	Dillingham City Schools	20012000042	150010	Dillingham Elementary	Regular School	No	Elementary	PK	5	2021	grade_12	0.0		0.0				0.0	0.0	0		0				0	0
1815126	AK	school	200120	15	Dillingham City Schools	20012000634	150020	Dillingham Middle/High School	Regular School	No	High	06	12	2021	grade_12	5.0		0.0				13.0	32.0	5		0				13	32
1733431	AK	school	200130	17	Galena City Schools	20013000044	170010	Sidney C. Huntington Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0				0.0		0.0	0	0				0		0	0
1733447	AK	school	200130	17	Galena City Schools	20013000635	170020	Sidney C. Huntington Jr/Sr High School	Regular School	No	High	07	12.0	2020	grade_12	3.0							7	3							7
1733463	AK	school	200130	17	Galena City Schools	20013000253	178010	Interior Distance Education of Alaska (IDEA)	Regular School	No	Other	PK	12.0	2020	grade_12	291.0	6.0	17.0	7.0	12.0	9.0	36.0	449	291	6	17	7	12	9	36	449
1733479	AK	school	200130	17	Galena City Schools	20013000252	179010	Galena Interior Learning Academy (GILA)	Regular School	No	High	09	12.0	2020	grade_12	3.0			0.0	0.0	0.0	1.0	52	3			0	0	0	1	52
1815718	AK	school	200130	17	Galena City Schools	20013000044	170010	Sidney C. Huntington 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
1815734	AK	school	200130	17	Galena City Schools	20013000635	170020	Sidney C. Huntington Jr/Sr High School	Regular School	No	High	07	12	2021	grade_12	0.0			1.0				8.0	0			1				8
1815750	AK	school	200130	17	Galena City Schools	20013000253	178010	Interior Distance Education of Alaska (IDEA)	Regular School	No	Other	PK	12	2021	grade_12	358.0	11.0	18.0	12.0	6.0	7.0	46.0	536.0	358	11	18	12	6	7	46	536
1815766	AK	school	200130	17	Galena City Schools	20013000252	179010	Galena Interior Learning Academy (GILA)	Regular School	No	High	09	12	2021	grade_12	0.0				1.0		1.0	20.0	0				1		1	20
1734647	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000046	250010	Houghtaling Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0		0.0	0.0	0.0	0.0	0.0	0	0		0	0	0	0	0	0
1734663	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000047	250020	Ketchikan High School	Regular School	No	High	09	12.0	2020	grade_12	58.0	2.0	2.0	3.0	15.0	1.0	4.0	113	58	2	2	3	15	1	4	113
1734679	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000050	250040	Schoenbar Middle School	Regular School	No	Middle	07	8.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1734695	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000052	250050	Fawn Mountain Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0	0	0	0	0	0		0	0