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_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_state_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	total	total_int
78193	AZ	school	400969	134379	Arizona Agribusiness & Equine Center INC.	40096903543	156568	Arizona Agribusiness & Equine Center, Inc. - Mesa	Regular School	Yes	High	09	12	2021	grade_5	*
144352	AZ	school	400969	134379	Arizona Agribusiness & Equine Center INC.	40096903543	156568	Arizona Agribusiness & Equine Center, Inc. - Mesa	Regular School	Yes	High	09	12	2020	grade_5	*
547428	AZ	school	400969	134379	Arizona Agribusiness & Equine Center INC.	40096903543	156568	Arizona Agribusiness & Equine Center, Inc. - Mesa	Regular School	Yes	Not Applicable	N	N	2018	grade_5	*
577017	AZ	school	400969	134379	Arizona Agribusiness & Equine Center INC.	40096903543	156568	Arizona Agribusiness & Equine Center, Inc. - Mesa	Regular School	Yes	High	09	12	2019	grade_5	*
78285	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2021	grade_5	*
144458	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2020	grade_5	*
547480	AZ	school	400963	273398	BASIS Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2018	grade_5	*
577098	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2019	grade_5	*
79895	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2021	grade_5	*
146033	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2020	grade_5	*
79438	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	06	2021	grade_5	12	12
145596	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	05	2020	grade_5	*
79437	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2021	grade_5	*
145595	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2020	grade_5	*
78232	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2021	grade_5	*
144404	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2020	grade_5	*
547312	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	Phoenix Collegiate Academy High School	Regular School	Yes	High	09	12	2018	grade_5	*
577048	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_5	*
80056	AZ	school	400977	395879	The French American School of Arizona	40097703580	769544	The French American Academy of Arizona	Regular School	Yes	Elementary	KG	05	2021	grade_5	*
146194	AZ	school	400977	395879	The French American School of Arizona	40097703580	769544	The French American Academy of Arizona	Regular School	Yes	Elementary	KG	05	2020	grade_5	*
578608	AZ	school	400977	395879	The French American Academy of Arizona	40097703580	769544	The French American Academy of Arizona	Regular School	Yes	Elementary	KG	05	2019	grade_5	*
79970	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2021	grade_5	*
79971	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2021	grade_5	*
79972	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2021	grade_5	67	67
79973	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2021	grade_5	*
146109	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2020	grade_5	*
146110	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2020	grade_5	*
146111	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2020	grade_5	65	65
146112	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2020	grade_5	*
548933	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2018	grade_5	*
548934	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2018	grade_5	*
548935	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2018	grade_5	68	68
548936	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2018	grade_5	*
578528	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2019	grade_5	*
578529	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2019	grade_5	52	52
578530	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2019	grade_5	*
578531	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2019	grade_5	*
80337	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_5	*
80338	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2021	grade_5	14	14
80339	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2021	grade_5	100	100
80340	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2021	grade_5	*
80341	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2021	grade_5	*
80342	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2021	grade_5	*
146435	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	*
146436	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2020	grade_5	14	14
146437	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2020	grade_5	117	117
146438	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2020	grade_5	*
146439	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2020	grade_5	*
146440	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2020	grade_5	*
549233	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2018	grade_5	13	13
549234	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2018	grade_5	132	132
549235	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2018	grade_5	*
549236	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2018	grade_5	*
549237	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2018	grade_5	*
578831	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2019	grade_5	113	113
578832	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2019	grade_5	*
578833	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2019	grade_5	*
578834	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2019	grade_5	*
578835	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2019	grade_5	11	11
79803	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2021	grade_5	*
79804	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2021	grade_5	*
79805	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2021	grade_5	108	108
79806	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	07	12	2021	grade_5	*
145941	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2020	grade_5	*
145942	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2020	grade_5	*
145943	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2020	grade_5	110	110
145944	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2020	grade_5	*
548799	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2018	grade_5	*
548800	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2018	grade_5	*
548801	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2018	grade_5	105	105
548802	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2018	grade_5	*
578393	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2019	grade_5	*
578394	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2019	grade_5	92	92
578395	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2019	grade_5	*
578396	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2019	grade_5	*
79840	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2021	grade_5	36	36
79841	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2021	grade_5	*
79842	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2021	grade_5	*
145979	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2020	grade_5	55	55
145980	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2020	grade_5	*
145981	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2020	grade_5	*
548835	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2018	grade_5	58	58
548836	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2018	grade_5	*
548837	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2018	grade_5	*
578429	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2019	grade_5	48	48
578430	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2019	grade_5	*
578431	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2019	grade_5	*
78859	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2021	grade_5	*
78860	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2021	grade_5	72	72
78861	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2021	grade_5	*
78862	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2021	grade_5	*
145021	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2020	grade_5	*
145022	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2020	grade_5	106	106
145023	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2020	grade_5	*
145024	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2020	grade_5	*
547976	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Elementary School	Regular School	No	Elementary	PK	02	2018	grade_5	*
547977	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2018	grade_5	*
547978	AZ	school		4157	Ganado Unified School District		4726	Ganado Intermediate School						2018	grade_5	98	98
547979	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2018	grade_5	*
577572	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2019	grade_5	*
577573	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2019	grade_5	100	100