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
89773	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_10	26	26
155602	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_10	22	22
557303	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_10	12	12
586872	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_10	25	25
89865	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2021	grade_10	*
155708	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2020	grade_10	*
557355	AZ	school	400963	273398	BASIS Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2018	grade_10	*
586953	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2019	grade_10	*
91475	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2021	grade_10	*
157283	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2020	grade_10	*
91018	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	06	2021	grade_10	*
156846	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	05	2020	grade_10	*
91017	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2021	grade_10	*
156845	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2020	grade_10	*
89812	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2021	grade_10	36	36
155654	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2020	grade_10	32	32
557187	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	Phoenix Collegiate Academy High School	Regular School	Yes	High	09	12	2018	grade_10	35	35
586903	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_10	39	39
91636	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_10	*
157444	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_10	*
588463	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_10	*
91550	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2021	grade_10	*
91551	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2021	grade_10	74	74
91552	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2021	grade_10	*
91553	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2021	grade_10	*
157359	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2020	grade_10	*
157360	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2020	grade_10	65	65
157361	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2020	grade_10	*
157362	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2020	grade_10	*
558808	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2018	grade_10	*
558809	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2018	grade_10	87	87
558810	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2018	grade_10	*
558811	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2018	grade_10	*
588383	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2019	grade_10	*
588384	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2019	grade_10	*
588385	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2019	grade_10	75	75
588386	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2019	grade_10	*
91917	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_10	*
91918	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2021	grade_10	*
91919	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2021	grade_10	*
91920	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2021	grade_10	*
91921	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2021	grade_10	*
91922	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2021	grade_10	165	165
157685	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_10	*
157686	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2020	grade_10	*
157687	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2020	grade_10	*
157688	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2020	grade_10	*
157689	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2020	grade_10	*
157690	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2020	grade_10	158	158
559108	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2018	grade_10	*
559109	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2018	grade_10	*
559110	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2018	grade_10	*
559111	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2018	grade_10	*
559112	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2018	grade_10	149	149
588686	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2019	grade_10	*
588687	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2019	grade_10	*
588688	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2019	grade_10	*
588689	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2019	grade_10	137	137
588690	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2019	grade_10	*
91383	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2021	grade_10	*
91384	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2021	grade_10	103	103
91385	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2021	grade_10	*
91386	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	07	12	2021	grade_10	*
157191	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2020	grade_10	*
157192	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2020	grade_10	100	100
157193	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2020	grade_10	*
157194	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2020	grade_10	*
558674	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2018	grade_10	*
558675	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2018	grade_10	96	96
558676	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2018	grade_10	*
558677	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2018	grade_10	*
588248	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2019	grade_10	*
588249	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2019	grade_10	*
588250	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2019	grade_10	90	90
588251	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2019	grade_10	*
91420	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2021	grade_10	*
91421	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2021	grade_10	*
91422	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2021	grade_10	48	48
157229	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2020	grade_10	*
157230	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2020	grade_10	*
157231	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2020	grade_10	60	60
558710	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2018	grade_10	*
558711	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2018	grade_10	*
558712	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2018	grade_10	49	49
588284	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2019	grade_10	*
588285	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2019	grade_10	*
588286	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2019	grade_10	56	56
90439	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2021	grade_10	129	129
90440	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2021	grade_10	*
90441	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2021	grade_10	*
90442	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2021	grade_10	*
156271	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2020	grade_10	108	108
156272	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2020	grade_10	*
156273	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2020	grade_10	*
156274	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2020	grade_10	*
557851	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Elementary School	Regular School	No	Elementary	PK	02	2018	grade_10	*
557852	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2018	grade_10	133	133
557853	AZ	school		4157	Ganado Unified School District		4726	Ganado Intermediate School						2018	grade_10	*
557854	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2018	grade_10	*
587427	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2019	grade_10	*
587428	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2019	grade_10	*