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 order by ccd_school_lvl desc 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
88112	AZ	school	400999	1000979	Freedom Preparatory Academy	40099903682	1000980	Freedom Prep Academy - Mesa	Regular School	Yes	Secondary	07	11	2021	grade_9	*
88694	AZ	school	405460	4252	Nadaburg Unified School District	40546003690	1001155	Mountainside High School	Regular School	No	Secondary	09	09	2021	grade_9	27	27
89018	AZ	school	406810	4245	Queen Creek Unified District	40681003606	1000117	Eastmark High School	Regular School	No	Secondary	07	11	2021	grade_9	327	327
89338	AZ	school	408520	4288	Tolleson Union High School District	40852002975	90085	West Point High School	Regular School	No	Secondary	09	11	2021	grade_9	781	781
153933	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2020	grade_9	66	66
154154	AZ	school	400053	4336	Heritage Academy, Inc.	40005303602	1000169	Heritage Academy Maricopa	Regular School	Yes	Secondary	06	11	2020	grade_9	98	98
154160	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2020	grade_9	140	140
155212	AZ	school	408520	4288	Tolleson Union High School District	40852002975	90085	West Point High School	Regular School	No	Secondary	09	10	2020	grade_9	778	778
555786	AZ	school	400877	91277	Empower College Prep	40087703522	92975	Empower Collegiate Academy	Regular School	Yes	Secondary	08	10	2018	grade_9	92	92
555987	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	09	2018	grade_9	75	75
585367	AZ	school	400877	91277	Empower College Prep	40087703522	92975	Empower Collegiate Academy	Regular School	Yes	Secondary	07	11	2019	grade_9	82	82
585371	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2019	grade_9	74	74
585567	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2019	grade_9	117	117
585765	AZ	school	400919	92657	Lincoln Preparatory Academy	40091903472	92732	Great Hearts Academies - Lincoln Prep	Regular School	Yes	Secondary	06	11	2019	grade_9	71	71
87370	AZ	school	400600	4280	Alhambra Elementary District	40060003660	1000261	Alhambra Preschool Academy	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
87535	AZ	school	401050	4268	Balsz Elementary District	40105003374	92301	Orangedale Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
87636	AZ	school	401680	4282	Cartwright Elementary District	40168001054	5414	Byron A. Barry School	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
87662	AZ	school	401710	4446	Casa Grande Elementary District	40171003201	90899	Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
87674	AZ	school	401760	4410	Catalina Foothills Unified District	40176001531	5836	Catalina Foothills Valley View Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
87938	AZ	school	402530	4174	Douglas Unified District	40253000184	4764	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88077	AZ	school	403010	4405	Flowing Wells Unified District	40301002065	79249	Emily Meschter Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88121	AZ	school	403240	4505	Gadsden Elementary District	40324001108	6186	San Luis Pre-School	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88271	AZ	school	403780	4248	Higley Unified School District	40378003417	92252	Elona P. Cooley Early Child Development Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
88278	AZ	school	403780	4248	Higley Unified School District	40378003361	92264	Sue Sossaman Early Childhood Development Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
88294	AZ	school	403870	4469	Humboldt Unified District	40387002926	89839	Bright Futures Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88324	AZ	school	403960	4259	Isaac Elementary District	40396001543	5241	Bret Tarver Education Complex	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88526	AZ	school	404630	4404	Marana Unified District	40463003663	1000279	MUSD Early Learning and Resource Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
88577	AZ	school	404970	4235	Mesa Unified District	40497002337	80046	Early Education Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88622	AZ	school	404970	4235	Mesa Unified District	40497002109	79687	Red Mountain Center for Early Education	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
88652	AZ	school	405030	4211	Miami Unified District	40503002789	89583	M.U.S.D. #40 - Little Vandal Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
88879	AZ	school	406250	4237	Peoria Unified School District	40625003643	1000302	GCC Early Childhood Learning Lab	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
88912	AZ	school	406300	4256	Phoenix Elementary District	40630003554	286779	Faith North Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
89006	AZ	school	406730	4466	Prescott Unified District	40673000352	8126	Discovery Gardens Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
89168	AZ	school	407700	4393	Show Low Unified District	40770003615	7673	Show Low Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
89188	AZ	school	407820	4391	Snowflake Unified District	40782002543	87577	Snowflake Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_9	*
89480	AZ	school	408850	4413	Vail Unified District	40885003665	1000286	Vail Inclusive Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
89601	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_9	*
153266	AZ	school	400600	4280	Alhambra Elementary District	40060003660	1000261	Alhambra Preschool Academy	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153387	AZ	school	400463	6393	Arizona State School for the Deaf and Blind	40046303359	90801	FBC-Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
153389	AZ	school	400463	6393	Arizona State School for the Deaf and Blind	40046303237	90802	Phoenix CHIC - Morton Ave	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
153392	AZ	school	400463	6393	Arizona State School for the Deaf and Blind	40046303236	90798	Tucson CHIC Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
153444	AZ	school	401050	4268	Balsz Elementary District	40105003374	92301	Orangedale Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
153549	AZ	school	401680	4282	Cartwright Elementary District	40168001054	5414	Byron A. Barry School	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153575	AZ	school	401710	4446	Casa Grande Elementary District	40171003201	90899	Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153587	AZ	school	401760	4410	Catalina Foothills Unified District	40176001531	5836	Catalina Foothills Valley View Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153751	AZ	school	402400	4501	Crane Elementary District	40240002882	87486	Great Beginnings Pre-School	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153843	AZ	school	402530	4174	Douglas Unified District	40253000184	4764	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
153973	AZ	school	403010	4405	Flowing Wells Unified District	40301002065	79249	Emily Meschter Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154019	AZ	school	403240	4505	Gadsden Elementary District	40324001108	6186	San Luis Pre-School	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154167	AZ	school	403780	4248	Higley Unified School District	40378003417	92252	Elona P. Cooley Early Child Development Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
154174	AZ	school	403780	4248	Higley Unified School District	40378003361	92264	Sue Sossaman Early Childhood Development Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
154191	AZ	school	403870	4469	Humboldt Unified District	40387002926	89839	Bright Futures Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154222	AZ	school	403960	4259	Isaac Elementary District	40396001543	5241	Bret Tarver Education Complex	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154420	AZ	school	404630	4404	Marana Unified District	40463003663	1000279	MUSD Early Learning and Resource Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
154472	AZ	school	404970	4235	Mesa Unified District	40497002337	80046	Early Education Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154517	AZ	school	404970	4235	Mesa Unified District	40497002109	79687	Red Mountain Center for Early Education	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
154547	AZ	school	405030	4211	Miami Unified District	40503002789	89583	M.U.S.D. #40 - Little Vandal Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154761	AZ	school	406250	4237	Peoria Unified School District	40625003643	1000302	GCC Early Childhood Learning Lab	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154794	AZ	school	406300	4256	Phoenix Elementary District	40630003554	286779	Faith North Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
154883	AZ	school	406730	4466	Prescott Unified District	40673000352	8126	Discovery Gardens Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
155042	AZ	school	407700	4393	Show Low Unified District	40770003615	7673	Show Low Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
155063	AZ	school	407820	4391	Snowflake Unified District	40782002543	87577	Snowflake Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_9	*
155351	AZ	school	408850	4413	Vail Unified District	40885003665	1000286	Vail Inclusive Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
155435	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	*
556443	AZ	school	405880	4180	Palominas Elementary District	40588001818	78914	Valley View Elementary School	Regular School	No	Prekindergarten	PK	PK	2018	grade_9	*
87344	AZ	school	400368	79961	Academy of Mathematics and Science, Inc.	40036802037	79094	Academy of Math and Science	Regular School	Yes	Other	KG	12	2021	grade_9	*
87353	AZ	school	400129	6364	Accelerated Elementary and Secondary Schools	40012901790	5891	Accelerated Learning Laboratory	Regular School	Yes	Other	KG	12	2021	grade_9	24	24
87406	AZ	school	400112	4348	American Leadership Academy, Inc.	40011203573	509281	American Leadership Academy, Gilbert North K-12	Regular School	Yes	Other	KG	12	2021	grade_9	386	386
87408	AZ	school	400112	4348	American Leadership Academy, Inc.	40011203475	92885	American Leadership Academy, Ironwood K12	Regular School	Yes	Other	KG	12	2021	grade_9	341	341
87410	AZ	school	400112	4348	American Leadership Academy, Inc.	40011203179	90769	American Leadership Academy, Queen Creek K-12	Regular School	Yes	Other	KG	12	2021	grade_9	280	280
87413	AZ	school	400680	4406	Amphitheater Unified District	40068003330	91755	Amphi Academy Online	Regular School	No	Other	KG	12	2021	grade_9	38	38
87431	AZ	school	400680	4406	Amphitheater Unified District	40068000030	5803	Rillito Center	Special Education School	No	Other	PK	12	2021	grade_9	*
87437	AZ	school	400819	90532	Anthem Preparatory Academy	40081903187	90635	Great Hearts Academies - Anthem Prep	Regular School	Yes	Other	KG	12	2021	grade_9	54	54
87444	AZ	school	400318	79426	Aprender Tucson	40031802203	79432	Southside Community School	Regular School	Yes	Other	KG	09	2021	grade_9	*
87447	AZ	school	400834	90917	Archway Classical Academy Chandler	40083403244	90999	Great Hearts Academies - Archway Chandler	Regular School	Yes	Other	KG	12	2021	grade_9	*
87454	AZ	school	400832	90915	Archway Classical Academy Trivium West	40083203290	91001	Great Hearts Academies - Archway Trivium West	Regular School	Yes	Other	KG	12	2021	grade_9	*
87455	AZ	school	400833	90916	Archway Classical Academy Veritas	40083303283	91000	Great Hearts Academies - Archway Veritas	Regular School	Yes	Other	KG	12	2021	grade_9	*
87469	AZ	school	400427	87407	Arizona Connections Academy Charter School, Inc.	40042703160	81179	Arizona Connections Academy	Regular School	Yes	Other	KG	12	2021	grade_9	293	293
87483	AZ	school	400415	85749	Arizona Montessori Charter School at Anthem	40041502414	85750	AMCS at Anthem dba Caurus Academy	Regular School	Yes	Other	KG	12	2021	grade_9	46	46
87505	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	Other	KG	12	2021	grade_9	650	650
87538	AZ	school	400897	91339	BASIS Charter Schools, Inc.	40089703376	92030	BASIS Ahwatukee	Regular School	Yes	Other	04	12	2021	grade_9	47	47
87542	AZ	school	400831	90862	BASIS Charter Schools, Inc.	40083103196	90863	BASIS Flagstaff	Regular School	Yes	Other	KG	12	2021	grade_9	47	47
87545	AZ	school	400898	91949	BASIS Charter Schools, Inc.	40089803393	91997	BASIS Mesa	Regular School	Yes	Other	KG	12	2021	grade_9	58	58
87554	AZ	school	400903	92320	BASIS Charter Schools, Inc.	40090303418	92321	BASIS Prescott	Regular School	Yes	Other	KG	12	2021	grade_9	48	48
87555	AZ	school	400608	81078	BASIS Charter Schools, Inc.	40060803115	81079	BASIS Scottsdale	Regular School	Yes	Other	04	12	2021	grade_9	111	111
87559	AZ	school	400134	6361	BASIS Charter Schools, Inc.	40013401786	6065	BASIS Tucson Primary	Regular School	Yes	Other	KG	12	2021	grade_9	*
87568	AZ	school	400212	79226	Benson Unified School District	40021203232	90775	Benson Digital Learning Center Online	Regular School	No	Other	KG	12	2021	grade_9	*
87577	AZ	school	401230	4231	Blue Elementary District	40123000069	4908	Blue Elementary School	Regular School	No	Other	KG	12	2021	grade_9	*
87612	AZ	school	400397	79971	CAFA, Inc. dba Learning Foundation Performing Arts School	40039703119	81102	Learning Foundation	Regular School	Yes	Other	KG	12	2021	grade_9	*
87621	AZ	school	401600	4470	Camp Verde Unified District	40160003666	1000257	Camp Verde Online	Regular School	No	Other	KG	12	2021	grade_9	30	30
87692	AZ	school	400001	4244	Cave Creek Unified District	40000103687	1001171	Cave Creek Academy of Excellence	Regular School	No	Other	KG	12	2021	grade_9	*
87713	AZ	school	400440	88299	Chandler Preparatory Academy	40044002681	88300	Great Hearts Academies - Chandler Prep	Regular School	Yes	Other	KG	12	2021	grade_9	96	96
87779	AZ	school	400402	5186	Cholla Academy	40040201860	10801	Westland School	Regular School	Yes	Other	KG	12	2021	grade_9	13	13
87780	AZ	school	400402	5186	Cholla Academy	40040203429	92637	Westland School Brighton Campus	Regular School	Yes	Other	KG	12	2021	grade_9	25	25
87801	AZ	school	400632	81027	Cochise Community Development Corporation	40063203105	81028	Bereran Academy	Regular School	Yes	Other	KG	12	2021	grade_9	46	46
87838	AZ	school	402370	4487	Cottonwood-Oak Creek Elementary District	40237000166	6123	Cottonwood Education Services	Regular School	No	Other	PK	12	2021	grade_9	*
87842	AZ	school	400429	79074	Country Gardens Charter Schools	40042901994	79102	Country Gardens Charter School	Regular School	Yes	Other	KG	12	2021	grade_9	22	22
87868	AZ	school	400778	89917	Daisy Education Corporation dba Paragon Science Academy	40077802902	89918	Paragon Science Academy	Regular School	Yes	Other	KG	12	2021	grade_9	50	50
87869	AZ	school	400223	79049	Daisy Education Corporation dba Sonoran Science Academy	40022302199	79127	Sonoran Science Academy - Tucson	Regular School	Yes	Other	KG	12	2021	grade_9	66	66
87870	AZ	school	400776	89914	Daisy Education Corporation dba Sonoran Science Academy - Phoenix	40077602387	80974	Sonoran Science Academy - Phoenix	Regular School	Yes	Other	KG	12	2021	grade_9	50	50
87885	AZ	school	407750	4246	Deer Valley Unified District	40775002591	79414	Deer Valley Online Learning Program	Regular School	No	Other	KG	12	2021	grade_9	114	114