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 (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_int, 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_alaskan_native	asian	pacific_islander	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
1875229	NV	school	3200060	2	Clark	320006000080	2103	Lundy	Regular School	No	Elementary	PK	05	2019	grade_4	2.0							1.0	1.0	2	2							1	1	2
1876824	NV	school	3200060	2	Clark	320006000018	2409	Chaparral	Regular School	No	High	09	12	2019	ungraded		1.0	1.0					2.0		2		1	1					2		2
1876854	NV	school	3200060	2	Clark	320006000407	2416	Green Valley	Regular School	No	High	09	12	2019	ungraded	1.0				1.0			2.0		2	1				1			2		2
1877039	NV	school	3200060	2	Clark	320006000774	2910	Stewart Sch	Special Education School	No	Other	PK	12	2019	grade_2			1.0		1.0			2.0		2			1		1			2		2
1877060	NV	school	3200060	2	Clark	320006000020	2912	Juvenile Court	Alternative School	No	High	06	12	2019	grade_7	1.0		1.0					2.0		2	1		1					2		2
1877084	NV	school	3200060	2	Clark	320006000518	2919	Summit View JSHS	Alternative School	No	High	06	12	2019	grade_9			2.0					2.0		2			2					2		2
1877088	NV	school	3200060	2	Clark	320006000313	2922	Burk Horizon SW	Alternative School	No	High	09	12	2019	grade_9	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877102	NV	school	3200060	2	Clark	320006000683	2927	Desert Willow	Special Education School	No	High	06	12	2019	grade_10	1.0				1.0			1.0	1.0	2	1				1			1	1	2
1877129	NV	school	3200060	2	Clark	320006000795	2941	Adult Ed	Alternative School	No	High	12	12	2019	grade_12			2.0					1.0	1.0	2			2					1	1	2
1877131	NV	school	3200060	2	Clark	320006000767	2955	Desert Rose ALT	Alternative School	No	High	09	12	2019	grade_9		1.0	1.0						2.0	2		1	1						2	2
1877135	NV	school	3200060	2	Clark	320006000878	2957	Mission HS	Alternative School	No	High	06	12	2019	grade_9			2.0					2.0		2			2					2		2
1877205	NV	school	3200090	3	Douglas	320009000348	3503	Jacobsen HS	Alternative School	No	High	07	12	2019	grade_7	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877215	NV	school	3200090	3	Douglas	320009000832	3504	ASPIRE HS	Alternative School	No	High	09	12	2019	ungraded	2.0							2.0		2	2							2		2
1877216	NV	school	3200090	3	Douglas	320009000764	3901	Douglas ALT ALT	Alternative School	No	Other	04	12	2019	grade_8	2.0								2.0	2	2								2	2
1877218	NV	school	3200090	3	Douglas	320009000764	3901	Douglas ALT ALT	Alternative School	No	Other	04	12	2019	grade_10				1.0			1.0		2.0	2				1			1		2	2
1877220	NV	school	3200120	4	Elko	320012000131	4104	Independence Vly ES	Regular School	No	Elementary	KG	08	2019	grade_1	2.0							2.0		2	2							2		2
1877234	NV	school	3200120	4	Elko	320012000134	4108	Mound Vly ES	Regular School	No	Elementary	KG	08	2019	grade_3	2.0							1.0	1.0	2	2							1	1	2
1877235	NV	school	3200120	4	Elko	320012000134	4108	Mound Vly ES	Regular School	No	Elementary	KG	08	2019	grade_4	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877239	NV	school	3200120	4	Elko	320012000134	4108	Mound Vly ES	Regular School	No	Elementary	KG	08	2019	kindergarten	2.0								2.0	2	2								2	2
1877241	NV	school	3200120	4	Elko	320012000139	4111	Ruby Vly ES	Regular School	No	Elementary	KG	08	2019	grade_2	2.0								2.0	2	2								2	2
1877243	NV	school	3200120	4	Elko	320012000139	4111	Ruby Vly ES	Regular School	No	Elementary	KG	08	2019	grade_4	2.0							1.0	1.0	2	2							1	1	2
1877246	NV	school	3200120	4	Elko	320012000139	4111	Ruby Vly ES	Regular School	No	Elementary	KG	08	2019	kindergarten	2.0							2.0		2	2							2		2
1877377	NV	school	3200120	4	Elko	320012000839	4610	NNVVirtual	Regular School	No	Other	KG	12	2019	kindergarten	2.0							1.0	1.0	2	2							1	1	2
1877378	NV	school	3200120	4	Elko	320012000854	4902	Elko Adult	Alternative School	No	Ungraded	UG	UG	2019	ungraded			2.0						2.0	2			2						2	2
1877393	NV	school	3200150	5	Esmeralda	320015000144	5102	Goldfield ES	Regular School	No	Elementary	PK	08	2019	grade_4	1.0						1.0		2.0	2	1						1		2	2
1877433	NV	school	3200210	7	Humboldt	320021000150	7101	Denio ES	Regular School	No	Elementary	PK	08	2019	grade_8	2.0							1.0	1.0	2	2							1	1	2
1877436	NV	school	3200210	7	Humboldt	320021000151	7103	Kings River ES	Regular School	No	Elementary	PK	08	2019	grade_5	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877437	NV	school	3200210	7	Humboldt	320021000151	7103	Kings River ES	Regular School	No	Elementary	PK	08	2019	grade_6	1.0		1.0					2.0		2	1		1					2		2
1877440	NV	school	3200210	7	Humboldt	320021000151	7103	Kings River ES	Regular School	No	Elementary	PK	08	2019	kindergarten			2.0					1.0	1.0	2			2					1	1	2
1877443	NV	school	3200210	7	Humboldt	320021000155	7104	Orovada ES	Regular School	No	Elementary	PK	08	2019	grade_4			2.0					1.0	1.0	2			2					1	1	2
1877446	NV	school	3200210	7	Humboldt	320021000155	7104	Orovada ES	Regular School	No	Elementary	PK	08	2019	grade_7	1.0		1.0						2.0	2	1		1						2	2
1877452	NV	school	3200210	7	Humboldt	320021000156	7105	Paradise Vly ES	Regular School	No	Elementary	PK	08	2019	grade_4	2.0							2.0		2	2							2		2
1877515	NV	school	3200240	8	Lander	320024000162	8602	Austin School	Regular School	No	Other	PK	12	2019	grade_7	2.0							1.0	1.0	2	2							1	1	2
1877670	NV	school	3200300	10	Lyon	320030000555	10605	Silver Stage	Regular School	No	High	09	12	2019	ungraded	2.0							1.0	1.0	2	2							1	1	2
1877671	NV	school	3200300	10	Lyon	320030000768	10902	Western NV Yth Ct	Alternative School	No	High	07	12	2019	grade_9	1.0		1.0					2.0		2	1		1					2		2
1877673	NV	school	3200300	10	Lyon	320030000768	10902	Western NV Yth Ct	Alternative School	No	High	07	12	2019	grade_11	1.0						1.0	2.0		2	1						1	2		2
1877674	NV	school	3200300	10	Lyon	320030000768	10902	Western NV Yth Ct	Alternative School	No	High	07	12	2019	grade_12	1.0			1.0				1.0	1.0	2	1			1				1	1	2
1877687	NV	school	3200330	11	Mineral	320033000184	11202	Schurz ES	Regular School	No	Elementary	PK	06	2019	grade_4			1.0	1.0				1.0	1.0	2			1	1				1	1	2
1877701	NV	school	3200360	12	Nye	320036000188	12101	Duckwater ES	Regular School	No	Elementary	PK	05	2019	grade_2	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877702	NV	school	3200360	12	Nye	320036000188	12101	Duckwater ES	Regular School	No	Elementary	PK	05	2019	grade_4			1.0				1.0		2.0	2			1				1		2	2
1877720	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2019	grade_1			1.0			1.0		1.0	1.0	2			1			1		1	1	2
1877721	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2019	grade_2	1.0						1.0	1.0	1.0	2	1						1	1	1	2
1877723	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2019	grade_4	1.0			1.0					2.0	2	1			1					2	2
1877768	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs	Regular School	No	Elementary	PK	08	2019	grade_2	2.0							2.0		2	2							2		2
1877770	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs	Regular School	No	Elementary	PK	08	2019	grade_5	2.0							2.0		2	2							2		2
1877791	NV	school	3200360	12	Nye	320036000729	12317	Duckwater MS	Regular School	No	Middle	06	08	2019	grade_6	1.0			1.0				1.0	1.0	2	1			1				1	1	2
1877798	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2019	grade_10				2.0				1.0	1.0	2				2				1	1	2
1877800	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2019	grade_12	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877821	NV	school	3200360	12	Nye	320036000852	12609	Pathways Elem ALT	Alternative School	No	Elementary	03	05	2019	grade_4			2.0						2.0	2			2						2	2
1877891	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2019	grade_2	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1877893	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2019	grade_4	2.0							1.0	1.0	2	2							1	1	2
1877924	NV	school	3200450	15	Storey	320045000413	15102	Hillside ES	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1.0					1.0		2.0		2	1					1		2		2
1877946	NV	school	3200480	16	Washoe	320048000209	16202	Loder ES	Regular School	No	Elementary	PK	06	2019	pre_kindergarten			2.0						2.0	2			2						2	2
1877976	NV	school	3200480	16	Washoe	320048000223	16206	Hunter Lake	Regular School	No	Elementary	PK	06	2019	pre_kindergarten			1.0				1.0	2.0		2			1				1	2		2
1878131	NV	school	3200480	16	Washoe	320048000241	16228	Mitchell ES	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1878190	NV	school	3200480	16	Washoe	320048000234	16237	Natchez ES	Regular School	No	Elementary	PK	06	2019	pre_kindergarten				2.0				2.0		2				2				2		2
1878214	NV	school	3200480	16	Washoe	320048000324	16240	Palmer ES	Regular School	No	Elementary	PK	06	2019	pre_kindergarten			2.0					2.0		2			2					2		2
1878230	NV	school	3200480	16	Washoe	320048000706	16242	Sepulveda	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	2.0							2.0		2	2							2		2
1878243	NV	school	3200480	16	Washoe	320048000322	16256	Gomes	Regular School	No	Elementary	PK	04	2019	pre_kindergarten	2.0							2.0		2	2							2		2
1878479	NV	school	3200480	16	Washoe	320048000208	16501	Wooster	Regular School	No	High	09	12	2019	ungraded	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1878502	NV	school	3200480	16	Washoe	320048000822	16507	Inspire	Alternative School	No	Other	PK	12	2019	grade_6	1.0		1.0					2.0		2	1		1					2		2
1878527	NV	school	3200480	16	Washoe	320048000217	16601	Gerlach K-12	Regular School	No	Other	PK	12	2019	grade_3	2.0							2.0		2	2							2		2
1878528	NV	school	3200480	16	Washoe	320048000217	16601	Gerlach K-12	Regular School	No	Other	PK	12	2019	grade_4	2.0							1.0	1.0	2	2							1	1	2
1878532	NV	school	3200480	16	Washoe	320048000217	16601	Gerlach K-12	Regular School	No	Other	PK	12	2019	grade_9	1.0		1.0					2.0		2	1		1					2		2
1878566	NV	school	3200480	16	Washoe	320048000546	16607	North Valleys	Regular School	No	High	09	12	2019	ungraded	2.0							1.0	1.0	2	2							1	1	2
1878575	NV	school	3200480	16	Washoe	320048000602	16609	Damonte Ranch HS	Regular School	No	High	09	12	2019	ungraded	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1878601	NV	school	3200480	16	Washoe	320048000766	16917	Turning Point	Alternative School	No	Other	01	12	2019	grade_1		1.0	1.0					2.0		2		1	1					2		2
1878602	NV	school	3200480	16	Washoe	320048000766	16917	Turning Point	Alternative School	No	Other	01	12	2019	grade_3	1.0		1.0					2.0		2	1		1					2		2
1878605	NV	school	3200480	16	Washoe	320048000766	16917	Turning Point	Alternative School	No	Other	01	12	2019	grade_6	2.0							2.0		2	2							2		2
1878609	NV	school	3200480	16	Washoe	320048000766	16917	Turning Point	Alternative School	No	Other	01	12	2019	grade_10	1.0		1.0					1.0	1.0	2	1		1					1	1	2
1878665	NV	school	3200510	17	White Pine	320051000483	17903	Steptoe Vly HS	Alternative School	No	High	09	12	2019	grade_9	1.0	1.0						1.0	1.0	2	1	1						1	1	2
1879496	NV	school	3200060	2	Clark	320006000795	2941	Adult Ed	Alternative School	No	High	12	12	2019	k_12_total	0.0	0.0	2.0	0.0	0.0	0.0	0.0	1.0	1.0	2	0	0	2	0	0	0	0	1	1	2
1879543	NV	school	3200120	4	Elko	320012000854	4902	Elko Adult	Alternative School	No	Ungraded	UG	UG	2019	k_12_total	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	2.0	2	0	0	2	0	0	0	0	0	2	2
1879624	NV	school	3200360	12	Nye	320036000852	12609	Pathways Elem ALT	Alternative School	No	Elementary	03	05	2019	k_12_total	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	2.0	2	0	0	2	0	0	0	0	0	2	2
1875214	NV	school	3200060	2	Clark	320006000010	2101	Blue Diamond	Regular School	No	Elementary	PK	05	2019	grade_1	2.0				1.0			2.0	1.0	3	2				1			2	1	3
1875223	NV	school	3200060	2	Clark	320006000037	2102	Goodsprings	Regular School	No	Elementary	PK	05	2019	grade_4	1.0	1.0	1.0					1.0	2.0	3	1	1	1					1	2	3
1875227	NV	school	3200060	2	Clark	320006000080	2103	Lundy	Regular School	No	Elementary	PK	05	2019	grade_2	3.0							2.0	1.0	3	3							2	1	3
1875230	NV	school	3200060	2	Clark	320006000080	2103	Lundy	Regular School	No	Elementary	PK	05	2019	grade_5	2.0		1.0					2.0	1.0	3	2		1					2	1	3
1875231	NV	school	3200060	2	Clark	320006000080	2103	Lundy	Regular School	No	Elementary	PK	05	2019	kindergarten	3.0								3.0	3	3								3	3
1875232	NV	school	3200060	2	Clark	320006000099	2104	Reid ES	Regular School	No	Elementary	PK	05	2019	grade_1	3.0							1.0	2.0	3	3							1	2	3
1875237	NV	school	3200060	2	Clark	320006000099	2104	Reid ES	Regular School	No	Elementary	PK	05	2019	kindergarten	2.0						1.0	1.0	2.0	3	2						1	1	2	3
1876816	NV	school	3200060	2	Clark	320006000103	2408	Morris Sunset	Alternative School	No	High	09	12	2019	grade_9	1.0		2.0					2.0	1.0	3	1		2					2	1	3
1877061	NV	school	3200060	2	Clark	320006000020	2912	Juvenile Court	Alternative School	No	High	06	12	2019	grade_8	1.0	2.0						3.0		3	1	2						3		3
1877099	NV	school	3200060	2	Clark	320006000683	2927	Desert Willow	Special Education School	No	High	06	12	2019	grade_7	1.0	2.0						1.0	2.0	3	1	2						1	2	3
1877153	NV	school	3200090	3	Douglas	320009000124	3202	Zephyr Cove	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	2.0						1.0	1.0	2.0	3	2						1	1	2	3
1877224	NV	school	3200120	4	Elko	320012000131	4104	Independence Vly ES	Regular School	No	Elementary	KG	08	2019	grade_6	1.0		2.0					2.0	1.0	3	1		2					2	1	3
1877236	NV	school	3200120	4	Elko	320012000134	4108	Mound Vly ES	Regular School	No	Elementary	KG	08	2019	grade_5	3.0								3.0	3	3								3	3
1877238	NV	school	3200120	4	Elko	320012000134	4108	Mound Vly ES	Regular School	No	Elementary	KG	08	2019	grade_8	2.0		1.0					2.0	1.0	3	2		1					2	1	3
1877242	NV	school	3200120	4	Elko	320012000139	4111	Ruby Vly ES	Regular School	No	Elementary	KG	08	2019	grade_3	3.0							3.0		3	3							3		3
1877313	NV	school	3200120	4	Elko	320012000385	4211	Sage ES	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	2.0						1.0	2.0	1.0	3	2						1	2	1	3
1877360	NV	school	3200120	4	Elko	320012000330	4606	Spring Creek	Regular School	No	High	09	12	2019	ungraded	3.0							2.0	1.0	3	3							2	1	3
1877367	NV	school	3200120	4	Elko	320012000839	4610	NNVVirtual	Regular School	No	Other	KG	12	2019	grade_2	3.0							2.0	1.0	3	3							2	1	3
1877369	NV	school	3200120	4	Elko	320012000839	4610	NNVVirtual	Regular School	No	Other	KG	12	2019	grade_5	3.0								3.0	3	3								3	3
1877372	NV	school	3200120	4	Elko	320012000839	4610	NNVVirtual	Regular School	No	Other	KG	12	2019	grade_8	3.0							3.0		3	3							3		3
1877381	NV	school	3200150	5	Esmeralda	320015000143	5101	Dyer ES	Regular School	No	Elementary	PK	08	2019	grade_2	1.0		2.0					3.0		3	1		2					3		3
1877386	NV	school	3200150	5	Esmeralda	320015000143	5101	Dyer ES	Regular School	No	Elementary	PK	08	2019	grade_7	1.0		2.0					3.0		3	1		2					3		3
1877394	NV	school	3200150	5	Esmeralda	320015000144	5102	Goldfield ES	Regular School	No	Elementary	PK	08	2019	grade_5	3.0							2.0	1.0	3	3							2	1	3
1877397	NV	school	3200150	5	Esmeralda	320015000144	5102	Goldfield ES	Regular School	No	Elementary	PK	08	2019	grade_8	2.0					1.0		1.0	2.0	3	2					1		1	2	3
1877398	NV	school	3200150	5	Esmeralda	320015000144	5102	Goldfield ES	Regular School	No	Elementary	PK	08	2019	kindergarten	2.0						1.0		3.0	3	2						1		3	3
1877399	NV	school	3200150	5	Esmeralda	320015000144	5102	Goldfield ES	Regular School	No	Elementary	PK	08	2019	pre_kindergarten	2.0						1.0	1.0	2.0	3	2						1	1	2	3
1877407	NV	school	3200180	6	Eureka	320018000146	6101	Crescent Vly	Regular School	No	Elementary	PK	06	2019	grade_1	2.0						1.0		3.0	3	2						1		3	3