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 (hispanic_int > :p3 or (hispanic_int = :p3 and rowid > :p2)) order by hispanic_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	native_american_alaskan_native	pacific_islander	multiracial	male	female	total	white_int	black_int	native_american_alaskan_native_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
1841779	NV	school	3200210	7	Humboldt	320021000155	7104	Orovada ES	Regular School	No	Elementary	PK	08	2021	grade_7	2	0	0	0	1	2	1	3	2	0	0	0	1	2	1	3
1841780	NV	school	3200210	7	Humboldt	320021000155	7104	Orovada ES	Regular School	No	Elementary	PK	08	2021	grade_8	3	0	0	0	0	2	1	3	3	0	0	0	0	2	1	3
1841782	NV	school	3200210	7	Humboldt	320021000156	7105	Paradise Valley ES	Regular School	No	Elementary	PK	08	2021	grade_1	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1841785	NV	school	3200210	7	Humboldt	320021000156	7105	Paradise Valley ES	Regular School	No	Elementary	PK	08	2021	grade_4	3	0	0	0	0	3	0	3	3	0	0	0	0	3	0	3
1841788	NV	school	3200210	7	Humboldt	320021000156	7105	Paradise Valley ES	Regular School	No	Elementary	PK	08	2021	grade_8	2	0	0	0	0	1	1	2	2	0	0	0	0	1	1	2
1841800	NV	school	3200210	7	Humboldt	320021000153	7203	McDermitt ES	Regular School	No	Elementary	PK	06	2021	grade_1	0	0	3	0	0	3	0	3	0	0	3	0	0	3	0	3
1841801	NV	school	3200210	7	Humboldt	320021000153	7203	McDermitt ES	Regular School	No	Elementary	PK	06	2021	grade_2	1	0	3	0	0	3	1	4	1	0	3	0	0	3	1	4
1841802	NV	school	3200210	7	Humboldt	320021000153	7203	McDermitt ES	Regular School	No	Elementary	PK	06	2021	grade_3	0	0	8	0	1	4	5	9	0	0	8	0	1	4	5	9
1841804	NV	school	3200210	7	Humboldt	320021000153	7203	McDermitt ES	Regular School	No	Elementary	PK	06	2021	grade_5	0	0	13	0	0	8	5	13	0	0	13	0	0	8	5	13
1841805	NV	school	3200210	7	Humboldt	320021000153	7203	McDermitt ES	Regular School	No	Elementary	PK	06	2021	grade_6	0	0	8	0	0	6	2	8	0	0	8	0	0	6	2	8
1841817	NV	school	3200210	7	Humboldt	320021000708	7302	McDermitt JHS	Regular School	No	Middle	07	08	2021	grade_7	0	0	13	0	0	7	6	13	0	0	13	0	0	7	6	13
1841818	NV	school	3200210	7	Humboldt	320021000708	7302	McDermitt JHS	Regular School	No	Middle	07	08	2021	grade_8	0	0	4	0	0	0	4	4	0	0	4	0	0	0	4	4
1841843	NV	school	3200240	8	Lander	320024000162	8602	Austin Combined	Regular School	No	Other	01	12	2021	grade_1	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1841844	NV	school	3200240	8	Lander	320024000162	8602	Austin Combined	Regular School	No	Other	01	12	2021	grade_2	2	0	0	0	0	2	0	2	2	0	0	0	0	2	0	2
1841845	NV	school	3200240	8	Lander	320024000162	8602	Austin Combined	Regular School	No	Other	01	12	2021	grade_3	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1841846	NV	school	3200240	8	Lander	320024000162	8602	Austin Combined	Regular School	No	Other	01	12	2021	grade_6	2	0	0	0	0	1	1	2	2	0	0	0	0	1	1	2
1841849	NV	school	3200270	9	Lincoln	320027000170	9102	Pahranagat Valley ES	Regular School	No	Elementary	PK	05	2021	grade_2	17	0	0	0	1	8	10	18	17	0	0	0	1	8	10	18
1841851	NV	school	3200270	9	Lincoln	320027000170	9102	Pahranagat Valley ES	Regular School	No	Elementary	PK	05	2021	grade_4	11	0	1	1	1	7	7	14	11	0	1	1	1	7	7	14
1841852	NV	school	3200270	9	Lincoln	320027000170	9102	Pahranagat Valley ES	Regular School	No	Elementary	PK	05	2021	grade_5	14	1	0	1	1	10	7	17	14	1	0	1	1	10	7	17
1841855	NV	school	3200270	9	Lincoln	320027000166	9201	Caliente ES	Regular School	No	Elementary	PK	06	2021	grade_1	10	0	0	0	0	7	3	10	10	0	0	0	0	7	3	10
1841856	NV	school	3200270	9	Lincoln	320027000166	9201	Caliente ES	Regular School	No	Elementary	PK	06	2021	grade_2	9	0	0	0	0	3	6	9	9	0	0	0	0	3	6	9
1841863	NV	school	3200270	9	Lincoln	320027000172	9202	Panaca ES	Regular School	No	Elementary	PK	06	2021	grade_1	19	0	0	0	1	10	10	20	19	0	0	0	1	10	10	20
1841864	NV	school	3200270	9	Lincoln	320027000172	9202	Panaca ES	Regular School	No	Elementary	PK	06	2021	grade_2	16	0	0	0	0	11	5	16	16	0	0	0	0	11	5	16
1841870	NV	school	3200270	9	Lincoln	320027000172	9202	Panaca ES	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	34	0	0	0	0	18	16	34	34	0	0	0	0	18	16	34
1841872	NV	school	3200270	9	Lincoln	320027000173	9203	Pioche ES	Regular School	No	Elementary	PK	06	2021	grade_2	3	0	0	0	0	1	2	3	3	0	0	0	0	1	2	3
1841874	NV	school	3200270	9	Lincoln	320027000173	9203	Pioche ES	Regular School	No	Elementary	PK	06	2021	grade_4	7	0	0	0	0	7	0	7	7	0	0	0	0	7	0	7
1841876	NV	school	3200270	9	Lincoln	320027000173	9203	Pioche ES	Regular School	No	Elementary	PK	06	2021	grade_6	7	0	0	0	0	2	5	7	7	0	0	0	0	2	5	7
1841877	NV	school	3200270	9	Lincoln	320027000173	9203	Pioche ES	Regular School	No	Elementary	PK	06	2021	kindergarten	7	0	0	0	0	3	4	7	7	0	0	0	0	3	4	7
1841892	NV	school	3200270	9	Lincoln	320027000169	9602	C O Bastian	Alternative School	No	High	07	12	2021	grade_8	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1841928	NV	school	3200300	10	Lyon	320030000704	10206	East Valley ES	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	2	0	0	0	1	1	2	3	2	0	0	0	1	1	2	3
1841997	NV	school	3200300	10	Lyon	320030000768	10902	Eagle Ridge HS	Alternative School	No	High	07	12	2021	grade_8	0	1	0	0	0	1	0	1	0	1	0	0	0	1	0	1
1841999	NV	school	3200300	10	Lyon	320030000768	10902	Eagle Ridge HS	Alternative School	No	High	07	12	2021	grade_10	1	0	1	0	2	3	1	4	1	0	1	0	2	3	1	4
1842002	NV	school	3200300	10	Lyon	320030000860	10907	Lyon Adult Ed	Alternative School	No	Adult Education	AE	AE	2021	adult	4	0	1	0	1	3	3	6	4	0	1	0	1	3	3	6
1842017	NV	school	3200330	11	Mineral	320033000184	11202	Schurz ES	Regular School	No	Elementary	PK	06	2021	kindergarten	0	0	14	0	1	3	12	15	0	0	14	0	1	3	12	15
1842024	NV	school	3200330	11	Mineral	320033000183	11601	Mineral HS	Regular School	No	High	09	12	2021	ungraded	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842025	NV	school	3200360	12	Nye	320036000188	12101	Duckwater ES	Regular School	No	Elementary	PK	05	2021	grade_1	1	0	0	0	1	2	0	2	1	0	0	0	1	2	0	2
1842026	NV	school	3200360	12	Nye	320036000188	12101	Duckwater ES	Regular School	No	Elementary	PK	05	2021	grade_2	0	0	1	0	1	0	2	2	0	0	1	0	1	0	2	2
1842028	NV	school	3200360	12	Nye	320036000188	12101	Duckwater ES	Regular School	No	Elementary	PK	05	2021	kindergarten	0	0	0	0	2	1	1	2	0	0	0	0	2	1	1	2
1842041	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2021	grade_1	3	0	2	0	1	4	2	6	3	0	2	0	1	4	2	6
1842044	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2021	grade_4	1	0	0	0	2	1	2	3	1	0	0	0	2	1	2	3
1842046	NV	school	3200360	12	Nye	320036000189	12105	Gabbs ES	Regular School	No	Elementary	PK	05	2021	kindergarten	1	0	2	0	0	0	3	3	1	0	2	0	0	0	3	3
1842087	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_1	3	0	0	0	0	3	0	3	3	0	0	0	0	3	0	3
1842088	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_2	2	0	0	0	0	0	2	2	2	0	0	0	0	0	2	2
1842089	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_3	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842090	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_4	5	0	0	0	0	5	0	5	5	0	0	0	0	5	0	5
1842091	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_6	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842092	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_7	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842093	NV	school	3200360	12	Nye	320036000871	12211	Warm Springs Combined	Regular School	No	Elementary	01	08	2021	grade_8	2	0	0	0	0	2	0	2	2	0	0	0	0	2	0	2
1842103	NV	school	3200360	12	Nye	320036000611	12313	Round Mtn MS	Regular School	No	Middle	06	08	2021	grade_6	11	0	3	1	0	6	9	15	11	0	3	1	0	6	9	15
1842106	NV	school	3200360	12	Nye	320036000575	12315	Gabbs MS	Regular School	No	Middle	06	08	2021	grade_6	1	0	1	0	1	0	3	3	1	0	1	0	1	0	3	3
1842107	NV	school	3200360	12	Nye	320036000575	12315	Gabbs MS	Regular School	No	Middle	06	08	2021	grade_7	3	0	2	0	0	2	3	5	3	0	2	0	0	2	3	5
1842108	NV	school	3200360	12	Nye	320036000575	12315	Gabbs MS	Regular School	No	Middle	06	08	2021	grade_8	1	0	0	0	1	1	1	2	1	0	0	0	1	1	1	2
1842114	NV	school	3200360	12	Nye	320036000729	12317	Duckwater MS	Regular School	No	Middle	06	08	2021	grade_8	0	0	2	0	0	1	1	2	0	0	2	0	0	1	1	2
1842120	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2021	grade_9	3	0	0	0	0	0	3	3	3	0	0	0	0	0	3	3
1842121	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2021	grade_10	0	0	1	0	0	1	0	1	0	0	1	0	0	1	0	1
1842122	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2021	grade_11	1	0	1	0	1	2	1	3	1	0	1	0	1	2	1	3
1842123	NV	school	3200360	12	Nye	320036000190	12602	Gabbs HS	Regular School	No	High	09	12	2021	grade_12	0	0	2	0	0	0	2	2	0	0	2	0	0	0	2	2
1842141	NV	school	3200360	12	Nye	320036000557	12606	Pathways HS	Alternative School	No	High	09	12	2021	ungraded	0	1	0	0	0	1	0	1	0	1	0	0	0	1	0	1
1842145	NV	school	3200360	12	Nye	320036000852	12609	Pathways ES	Alternative School	No	Elementary	03	05	2021	grade_3	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842146	NV	school	3200360	12	Nye	320036000852	12609	Pathways ES	Alternative School	No	Elementary	03	05	2021	grade_4	4	1	0	0	0	4	1	5	4	1	0	0	0	4	1	5
1842147	NV	school	3200360	12	Nye	320036000852	12609	Pathways ES	Alternative School	No	Elementary	03	05	2021	grade_5	1	1	0	0	0	1	1	2	1	1	0	0	0	1	1	2
1842155	NV	school	3200390	13	Carson City	320039000288	13201	Bordewich Bray ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842163	NV	school	3200390	13	Carson City	320039000286	13203	Fritsch ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	3	0	0	0	0	2	1	3	3	0	0	0	0	2	1	3
1842214	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	grade_1	4	0	0	0	0	1	3	4	4	0	0	0	0	1	3	4
1842215	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	grade_2	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842216	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	grade_3	3	0	0	0	0	2	1	3	3	0	0	0	0	2	1	3
1842217	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	grade_4	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842218	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	grade_5	2	0	0	0	0	0	2	2	2	0	0	0	0	0	2	2
1842219	NV	school	3200420	14	Pershing	320042000196	14101	Imlay ES	Regular School	No	Elementary	PK	05	2021	kindergarten	2	0	0	0	2	3	1	4	2	0	0	0	2	3	1	4
1842234	NV	school	3200420	14	Pershing	320042000198	14601	Pershing HS	Regular School	No	High	09	12	2021	ungraded	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842235	NV	school	3200420	14	Pershing	320042000867	14903	Pershing Adult Ed	Alternative School	No	Adult Education	AE	AE	2021	adult	2	2	1	0	0	4	1	5	2	2	1	0	0	4	1	5
1842240	NV	school	3200450	15	Storey	320045000200	15101	Gallagher ES	Regular School	No	Elementary	PK	05	2021	grade_4	19	0	0	0	0	9	10	19	19	0	0	0	0	9	10	19
1842243	NV	school	3200450	15	Storey	320045000200	15101	Gallagher ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	2	0	0	0	0	1	1	2	2	0	0	0	0	1	1	2
1842246	NV	school	3200450	15	Storey	320045000413	15102	Hillside ES	Regular School	No	Elementary	PK	05	2021	grade_3	6	0	0	0	1	4	3	7	6	0	0	0	1	4	3	7
1842305	NV	school	3200480	16	Washoe County	320048000226	16207	Beck ES	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	0	0	0	0	1	1	0	1	0	0	0	0	1	1	0	1
1842341	NV	school	3200480	16	Washoe County	320048000559	16212	Double Diamond ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842492	NV	school	3200480	16	Washoe County	320048000234	16237	Natchez ES	Regular School	No	Elementary	PK	06	2021	grade_4	0	0	20	0	1	11	10	21	0	0	20	0	1	11	10	21
1842494	NV	school	3200480	16	Washoe County	320048000234	16237	Natchez ES	Regular School	No	Elementary	PK	06	2021	kindergarten	1	0	12	0	1	4	10	14	1	0	12	0	1	4	10	14
1842533	NV	school	3200480	16	Washoe County	320048000936	16243	Poulakidas ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842606	NV	school	3200480	16	Washoe County	320048000368	16264	Westergard ES	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842789	NV	school	3200480	16	Washoe County	320048000239	16502	Reno HS	Regular School	No	High	09	12	2021	ungraded	5	0	0	0	0	3	2	5	5	0	0	0	0	3	2	5
1842805	NV	school	3200480	16	Washoe County	320048000822	16507	Inspire Academy	Alternative School	No	Other	01	12	2021	grade_6	0	0	0	0	1	1	0	1	0	0	0	0	1	1	0	1
1842822	NV	school	3200480	16	Washoe County	320048000869	16510	Innovations HS	Alternative School	No	High	09	12	2021	grade_9	4	0	0	0	0	4	0	4	4	0	0	0	0	4	0	4
1842827	NV	school	3200480	16	Washoe County	320048000217	16601	Gerlach K 12	Regular School	No	Other	PK	12	2021	grade_3	3	0	0	0	0	2	1	3	3	0	0	0	0	2	1	3
1842830	NV	school	3200480	16	Washoe County	320048000217	16601	Gerlach K 12	Regular School	No	Other	PK	12	2021	grade_6	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842831	NV	school	3200480	16	Washoe County	320048000217	16601	Gerlach K 12	Regular School	No	Other	PK	12	2021	grade_8	2	0	0	0	0	0	2	2	2	0	0	0	0	0	2	2
1842833	NV	school	3200480	16	Washoe County	320048000217	16601	Gerlach K 12	Regular School	No	Other	PK	12	2021	grade_11	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842858	NV	school	3200480	16	Washoe County	320048000545	16606	Spanish Springs HS	Regular School	No	High	09	12	2021	ungraded	1	0	0	0	1	2	0	2	1	0	0	0	1	2	0	2
1842872	NV	school	3200480	16	Washoe County	320048000602	16609	Damonte Ranch HS	Regular School	No	High	09	12	2021	ungraded	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842884	NV	school	3200480	16	Washoe County	320048000233	16911	Picollo K 12	Special Education School	No	Other	PK	12	2021	grade_3	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842885	NV	school	3200480	16	Washoe County	320048000233	16911	Picollo K 12	Special Education School	No	Other	PK	12	2021	grade_4	4	0	0	0	2	2	4	6	4	0	0	0	2	2	4	6
1842894	NV	school	3200480	16	Washoe County	320048000233	16911	Picollo K 12	Special Education School	No	Other	PK	12	2021	kindergarten	1	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1
1842902	NV	school	3200480	16	Washoe County	320048000766	16917	Turning Point	Alternative School	No	Other	02	12	2021	grade_8	1	0	0	0	0	1	0	1	1	0	0	0	0	1	0	1
1842903	NV	school	3200480	16	Washoe County	320048000766	16917	Turning Point	Alternative School	No	Other	02	12	2021	grade_9	4	0	0	0	0	1	3	4	4	0	0	0	0	1	3	4
1842904	NV	school	3200480	16	Washoe County	320048000766	16917	Turning Point	Alternative School	No	Other	02	12	2021	grade_10	5	0	0	0	1	5	1	6	5	0	0	0	1	5	1	6
1842923	NV	school	3200510	17	White Pine	320051000720	17101	Lund ES	Regular School	No	Elementary	KG	05	2021	grade_3	10	0	0	0	0	6	4	10	10	0	0	0	0	6	4	10
1842925	NV	school	3200510	17	White Pine	320051000720	17101	Lund ES	Regular School	No	Elementary	KG	05	2021	grade_5	10	0	0	0	0	5	5	10	10	0	0	0	0	5	5	10
1842926	NV	school	3200510	17	White Pine	320051000720	17101	Lund ES	Regular School	No	Elementary	KG	05	2021	kindergarten	8	0	0	0	0	2	6	8	8	0	0	0	0	2	6	8
1842930	NV	school	3200510	17	White Pine	320051000254	17103	Baker ES	Regular School	No	Elementary	03	06	2021	grade_6	3	0	0	0	0	1	2	3	3	0	0	0	0	1	2	3
1842943	NV	school	3200510	17	White Pine	320051000263	17203	McGill ES	Regular School	No	Elementary	PK	05	2021	kindergarten	13	0	0	1	2	8	8	16	13	0	0	1	2	8	8	16
1842954	NV	school	3200510	17	White Pine	320051000606	17601	Lund JSHS	Regular School	No	High	06	12	2021	grade_6	6	0	0	0	0	3	3	6	6	0	0	0	0	3	3	6