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
68929	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_1	*
135352	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_1	*
539528	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_1	*
569133	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_1	*
69021	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2021	grade_1	127	127
135458	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2020	grade_1	126	126
539580	AZ	school	400963	273398	BASIS Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2018	grade_1	124	124
569214	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2019	grade_1	124	124
70631	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2021	grade_1	16	16
137033	AZ	school	400995	308420	Self Development Scottsdale Academy	40099503648	905186	Self Development Scottsdale Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	*
70174	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	06	2021	grade_1	23	23
136596	AZ	school	400990	320470	New Learning Ventures, Inc.	40099003649	117994	Phoenix Modern	Regular School	Yes	Elementary	KG	05	2020	grade_1	14	14
70173	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2021	grade_1	*
136595	AZ	school		32051	New Horizons Academy, LLC		837053	New Horizon Academy						2020	grade_1	*
68968	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2021	grade_1	*
135404	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2020	grade_1	*
539412	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	Phoenix Collegiate Academy High School	Regular School	Yes	High	09	12	2018	grade_1	*
569164	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_1	*
70792	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_1	11	11
137194	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_1	*
570724	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_1	13	13
70706	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2021	grade_1	56	56
70707	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2021	grade_1	*
70708	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2021	grade_1	*
70709	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2021	grade_1	*
137109	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2020	grade_1	55	55
137110	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2020	grade_1	*
137111	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2020	grade_1	*
137112	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Alternative School	No	High	09	12	2020	grade_1	*
541033	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2018	grade_1	52	52
541034	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2018	grade_1	*
541035	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2018	grade_1	*
541036	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2018	grade_1	*
570644	AZ	school	408080	4153	St Johns Unified District	40808000702	4517	Coronado Elementary School	Regular School	No	Elementary	PK	03	2019	grade_1	50	50
570645	AZ	school	408080	4153	St Johns Unified District	40808001105	4710	St Johns Middle School	Regular School	No	Middle	04	08	2019	grade_1	*
570646	AZ	school	408080	4153	St Johns Unified District	40808001049	4711	St Johns High School	Regular School	No	High	09	12	2019	grade_1	*
570647	AZ	school	408080	4153	St Johns Unified District	40808002871	89607	St. Johns Learning Center	Regular School	No	High	09	12	2019	grade_1	*
71073	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_1	*
71074	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2021	grade_1	18	18
71075	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2021	grade_1	*
71076	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2021	grade_1	*
71077	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2021	grade_1	96	96
71078	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2021	grade_1	*
137435	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	*
137436	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2020	grade_1	15	15
137437	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2020	grade_1	*
137438	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2020	grade_1	*
137439	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2020	grade_1	105	105
137440	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2020	grade_1	*
541333	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2018	grade_1	26	26
541334	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2018	grade_1	*
541335	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2018	grade_1	*
541336	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2018	grade_1	116	116
541337	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2018	grade_1	*
570947	AZ	school	409430	4154	Window Rock Unified District	40943000967	4714	Tsehootsooi Intermediate Learning Center	Regular School	No	Middle	04	06	2019	grade_1	*
570948	AZ	school	409430	4154	Window Rock Unified District	40943001648	4715	Tsehootsooi Primary Learning Center	Regular School	No	Elementary	KG	03	2019	grade_1	100	100
570949	AZ	school	409430	4154	Window Rock Unified District	40943000968	4716	Tsehootsooi Middle School	Regular School	No	Middle	07	08	2019	grade_1	*
570950	AZ	school	409430	4154	Window Rock Unified District	40943000970	4717	Window Rock High School	Regular School	No	High	09	12	2019	grade_1	*
570951	AZ	school	409430	4154	Window Rock Unified District	40943002447	85882	Tsehootsooi Dine Bi'Olta	Regular School	No	Elementary	KG	06	2019	grade_1	13	13
70539	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2021	grade_1	94	94
70540	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2021	grade_1	*
70541	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2021	grade_1	*
70542	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	07	12	2021	grade_1	*
136941	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1	85	85
136942	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2020	grade_1	*
136943	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2020	grade_1	*
136944	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2020	grade_1	*
540899	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2018	grade_1	114	114
540900	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2018	grade_1	*
540901	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2018	grade_1	*
540902	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2018	grade_1	*
570509	AZ	school	407130	4155	Round Valley Unified District	40713001484	4719	Round Valley Elementary School	Regular School	No	Elementary	PK	04	2019	grade_1	85	85
570510	AZ	school	407130	4155	Round Valley Unified District	40713000617	4720	Round Valley Middle School	Regular School	No	Middle	05	08	2019	grade_1	*
570511	AZ	school	407130	4155	Round Valley Unified District	40713001044	4721	Round Valley High School	Regular School	No	High	09	12	2019	grade_1	*
570512	AZ	school	407130	4155	Round Valley Unified District	40713003442	92686	White Mountain Academy	Regular School	No	High	09	12	2019	grade_1	*
70576	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2021	grade_1	38	38
70577	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2021	grade_1	*
70578	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2021	grade_1	*
136979	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2020	grade_1	38	38
136980	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2020	grade_1	*
136981	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2020	grade_1	*
540935	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2018	grade_1	48	48
540936	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2018	grade_1	*
540937	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2018	grade_1	*
570545	AZ	school	406740	4156	Sanders Unified District	40674000572	4722	Sanders Elementary School	Regular School	No	Elementary	PK	07	2019	grade_1	49	49
570546	AZ	school	406740	4156	Sanders Unified District	40674001043	4723	Sanders Middle School	Regular School	No	Middle	06	08	2019	grade_1	*
570547	AZ	school	406740	4156	Sanders Unified District	40674001142	4724	Valley High School	Regular School	No	High	09	12	2019	grade_1	*
69595	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2021	grade_1	*
69596	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2021	grade_1	*
69597	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2021	grade_1	*
69598	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2021	grade_1	75	75
136021	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2020	grade_1	*
136022	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2020	grade_1	*
136023	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2020	grade_1	*
136024	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2020	grade_1	58	58
540076	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Elementary School	Regular School	No	Elementary	PK	02	2018	grade_1	72	72
540077	AZ	school	403290	4157	Ganado Unified School District	40329000252	4728	Ganado High School	Regular School	No	High	09	12	2018	grade_1	*
540078	AZ	school		4157	Ganado Unified School District		4726	Ganado Intermediate School						2018	grade_1	*
540079	AZ	school	403290	4157	Ganado Unified School District	40329000254	4727	Ganado Middle School	Regular School	No	Middle	06	08	2018	grade_1	*
569688	AZ	school	403290	4157	Ganado Unified School District	40329000251	4725	Ganado Primary School	Regular School	No	Elementary	PK	02	2019	grade_1	75	75
569689	AZ	school	403290	4157	Ganado Unified School District	40329000253	4726	Ganado Intermediate School	Regular School	No	Elementary	03	05	2019	grade_1	*