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 order by district_nces_id 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
1735362	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total				1.0				109				1				109
1735378	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12.0	2020	pk_12_total								98								98
1735394	AK	school	200001	31	Lower Kuskokwim Schools	20000100436	310050	Mikelnguut Elitnaurviat	Regular School	No	Elementary	PK	2.0	2020	pk_12_total	44.0	1.0	2.0	4.0	2.0		3.0	328	44	1	2	4	2		3	328
1735410	AK	school	200001	31	Lower Kuskokwim Schools	20000100207	310060	Gladys Jung Elementary	Regular School	No	Elementary	03	6.0	2020	pk_12_total	40.0	1.0	5.0	6.0	5.0		2.0	341	40	1	5	6	5		2	341
1735426	AK	school	200001	31	Lower Kuskokwim Schools	20000100208	310070	Bethel Regional High School	Regular School	No	High	07	12.0	2020	pk_12_total	46.0	1.0	7.0	7.0	9.0		5.0	493	46	1	7	7	9		5	493
1735442	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0							153	2							153
1735458	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12.0	2020	pk_12_total								124								124
1735474	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12.0	2020	pk_12_total								73								73
1735490	AK	school	200001	31	Lower Kuskokwim Schools	20000100391	310110	Akula Elitnaurvik School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0							111	1							111
1735506	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total								205								205
1735522	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12.0	2020	pk_12_total								163								163
1735538	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total								254								254
1735554	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12.0	2020	pk_12_total							1.0	138							1	138
1735570	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12.0	2020	pk_12_total							2.0	42							2	42
1735586	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0							91	2							91
1735602	AK	school	200001	31	Lower Kuskokwim Schools	20000100439	310180	Z. John Williams Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0							156	1							156
1735618	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12.0	2020	pk_12_total								108								108
1735634	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total								143								143
1735650	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0							205	1							205
1735666	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12.0	2020	pk_12_total								218								218
1735682	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12.0	2020	pk_12_total		1.0					1.0	13		1					1	13
1735698	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0							124	2							124
1735714	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12.0	2020	pk_12_total	3.0							190	3							190
1735730	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total								13								13
1735746	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12.0	2020	pk_12_total								108								108
1735762	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12.0	2020	pk_12_total	2.0		1.0					53	2		1					53
1735778	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12.0	2020	pk_12_total								24								24
1735794	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6.0	2020	pk_12_total	5.0							169	5							169
1817649	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total				1.0				98.0				1				98
1817665	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12	2021	pk_12_total								99.0								99
1817681	AK	school	200001	31	Lower Kuskokwim Schools	20000100436	310050	Mikelnguut Elitnaurviat	Regular School	No	Elementary	PK	2	2021	pk_12_total	32.0		2.0	1.0	1.0		5.0	276.0	32		2	1	1		5	276
1817697	AK	school	200001	31	Lower Kuskokwim Schools	20000100207	310060	Gladys Jung Elementary	Regular School	No	Elementary	03	6	2021	pk_12_total	39.0	2.0	5.0	3.0	2.0		2.0	344.0	39	2	5	3	2		2	344
1817713	AK	school	200001	31	Lower Kuskokwim Schools	20000100208	310070	Bethel Regional High School	Regular School	No	High	07	12	2021	pk_12_total	43.0	4.0	5.0	5.0	8.0		2.0	490.0	43	4	5	5	8		2	490
1817729	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12	2021	pk_12_total								147.0								147
1817745	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12	2021	pk_12_total								116.0								116
1817761	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12	2021	pk_12_total								68.0								68
1817777	AK	school	200001	31	Lower Kuskokwim Schools	20000100391	310110	Akula Elitnaurvik School	Regular School	No	Other	PK	12	2021	pk_12_total	5.0							113.0	5							113
1817793	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								214.0								214
1817809	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12	2021	pk_12_total								156.0								156
1817825	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								248.0								248
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
1817857	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12	2021	pk_12_total								50.0								50
1817873	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								105.0								105
1817889	AK	school	200001	31	Lower Kuskokwim Schools	20000100439	310180	Z. John Williams Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							142.0	1							142
1817905	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12	2021	pk_12_total								73.0								73
1817921	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								153.0								153
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
1817953	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12	2021	pk_12_total								216.0								216
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
1817985	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								94.0								94
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
1818017	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								17.0								17
1818033	AK	school	200001	31	Lower Kuskokwim Schools	20000100765	310290	Mertarvik School	Regular School	No	Other	PK	12	2021	pk_12_total								35.0								35
1818049	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								113.0								113
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
1818081	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12	2021	pk_12_total				1.0				11.0				1				11
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
1735810	AK	school	200003	32	Lower Yukon Schools	20000300216	320010	Alakanuk School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0							229	1							229
1735826	AK	school	200003	32	Lower Yukon Schools	20000300217	320040	Emmonak School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0						1.0	212	2						1	212
1735842	AK	school	200003	32	Lower Yukon Schools	20000300218	320050	Marshall School	Regular School	No	Other	PK	12.0	2020	pk_12_total							1.0	120							1	120
1735858	AK	school	200003	32	Lower Yukon Schools	20000300219	320070	Hooper Bay School	Regular School	No	Other	PK	12.0	2020	pk_12_total	3.0	2.0					4.0	482	3	2					4	482
1735874	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12.0	2020	pk_12_total		1.0						174		1						174
1735890	AK	school	200003	32	Lower Yukon Schools	20000300220	320090	Mountain Village School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0							214	2							214
1735906	AK	school	200003	32	Lower Yukon Schools	20000300410	320110	Pilot Station School	Regular School	No	Other	PK	12.0	2020	pk_12_total	1.0							189	1							189
1735922	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12.0	2020	pk_12_total							3.0	123							3	123
1735938	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12.0	2020	pk_12_total		1.0						218		1						218
1735954	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12.0	2020	pk_12_total								67								67
1818113	AK	school	200003	32	Lower Yukon Schools	20000300216	320010	Alakanuk School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0						2.0	234.0	2						2	234
1818129	AK	school	200003	32	Lower Yukon Schools	20000300217	320040	Emmonak School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						11.0	238.0	1						11	238
1818145	AK	school	200003	32	Lower Yukon Schools	20000300218	320050	Marshall School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						2.0	129.0	1						2	129
1818161	AK	school	200003	32	Lower Yukon Schools	20000300219	320070	Hooper Bay School	Regular School	No	Other	PK	12	2021	pk_12_total	6.0						7.0	443.0	6						7	443
1818177	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12	2021	pk_12_total								171.0								171
1818193	AK	school	200003	32	Lower Yukon Schools	20000300220	320090	Mountain Village School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0			1.0			1.0	216.0	2			1			1	216
1818209	AK	school	200003	32	Lower Yukon Schools	20000300410	320110	Pilot Station School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							203.0	1							203
1818225	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12	2021	pk_12_total							3.0	129.0							3	129
1818241	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12	2021	pk_12_total		1.0					2.0	230.0		1					2	230
1818257	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12	2021	pk_12_total								65.0								65
1818273	AK	school	200003	32	Lower Yukon Schools	20000300767	329010	Hooper Bay Charter School	Regular School	Yes	Middle	04	8	2021	pk_12_total								45.0								45
1738130	AK	school	200004	54	Yupiit Schools	20000400624	540030	Akiak School	Regular School	No	Other	KG	12.0	2020	pk_12_total	1.0							131	1							131
1738146	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12.0	2020	pk_12_total								119								119
1820449	AK	school	200004	54	Yupiit Schools	20000400624	540030	Akiak School	Regular School	No	Other	KG	12	2021	pk_12_total	4.0							148.0	4							148
1820465	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12	2021	pk_12_total		2.0					2.0	144.0		2					2	144
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
1738178	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0				2.0			313	2				2			313
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
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
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
1738194	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12.0	2020	pk_12_total	5.0		1.0	1.0	4.0			87	5		1	1	4			87
1738210	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	pk_12_total	11.0		2.0		10.0	8.0	5.0	120	11		2		10	8	5	120
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
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
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
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
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
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
1730498	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12.0	2020	pk_12_total								10								10
1730514	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0		8.0		1.0	4.0		19	2		8		1	4		19
1812833	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12	2021	pk_12_total							3.0	10.0							3	10
1812849	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	pk_12_total	1.0		5.0		1.0	4.0		15.0	1		5		1	4		15
1732130	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12.0	2020	pk_12_total								154								154
1732146	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12.0	2020	pk_12_total	2.0	2.0						127	2	2						127