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
76532	AZ	school	400999	1000979	Freedom Preparatory Academy	40099903682	1000980	Freedom Prep Academy - Mesa	Regular School	Yes	Secondary	07	11	2021	grade_4	*
77114	AZ	school	405460	4252	Nadaburg Unified School District	40546003690	1001155	Mountainside High School	Regular School	No	Secondary	09	09	2021	grade_4	*
77438	AZ	school	406810	4245	Queen Creek Unified District	40681003606	1000117	Eastmark High School	Regular School	No	Secondary	07	11	2021	grade_4	*
77758	AZ	school	408520	4288	Tolleson Union High School District	40852002975	90085	West Point High School	Regular School	No	Secondary	09	11	2021	grade_4	*
142683	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2020	grade_4	*
142904	AZ	school	400053	4336	Heritage Academy, Inc.	40005303602	1000169	Heritage Academy Maricopa	Regular School	Yes	Secondary	06	11	2020	grade_4	*
142910	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2020	grade_4	*
143962	AZ	school	408520	4288	Tolleson Union High School District	40852002975	90085	West Point High School	Regular School	No	Secondary	09	10	2020	grade_4	*
545911	AZ	school	400877	91277	Empower College Prep	40087703522	92975	Empower Collegiate Academy	Regular School	Yes	Secondary	08	10	2018	grade_4	*
546112	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	09	2018	grade_4	*
575512	AZ	school	400877	91277	Empower College Prep	40087703522	92975	Empower Collegiate Academy	Regular School	Yes	Secondary	07	11	2019	grade_4	*
575516	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2019	grade_4	*
575712	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2019	grade_4	*
575910	AZ	school	400919	92657	Lincoln Preparatory Academy	40091903472	92732	Great Hearts Academies - Lincoln Prep	Regular School	Yes	Secondary	06	11	2019	grade_4	*
75790	AZ	school	400600	4280	Alhambra Elementary District	40060003660	1000261	Alhambra Preschool Academy	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
75955	AZ	school	401050	4268	Balsz Elementary District	40105003374	92301	Orangedale Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4	*
76056	AZ	school	401680	4282	Cartwright Elementary District	40168001054	5414	Byron A. Barry School	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76082	AZ	school	401710	4446	Casa Grande Elementary District	40171003201	90899	Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76094	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_4	*
76358	AZ	school	402530	4174	Douglas Unified District	40253000184	4764	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76497	AZ	school	403010	4405	Flowing Wells Unified District	40301002065	79249	Emily Meschter Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76541	AZ	school	403240	4505	Gadsden Elementary District	40324001108	6186	San Luis Pre-School	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76691	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_4	*
76698	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_4	*
76714	AZ	school	403870	4469	Humboldt Unified District	40387002926	89839	Bright Futures Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76744	AZ	school	403960	4259	Isaac Elementary District	40396001543	5241	Bret Tarver Education Complex	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
76946	AZ	school	404630	4404	Marana Unified District	40463003663	1000279	MUSD Early Learning and Resource Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4	*
76997	AZ	school	404970	4235	Mesa Unified District	40497002337	80046	Early Education Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
77042	AZ	school	404970	4235	Mesa Unified District	40497002109	79687	Red Mountain Center for Early Education	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4	*
77072	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_4	*
77299	AZ	school	406250	4237	Peoria Unified School District	40625003643	1000302	GCC Early Childhood Learning Lab	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
77332	AZ	school	406300	4256	Phoenix Elementary District	40630003554	286779	Faith North Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
77426	AZ	school	406730	4466	Prescott Unified District	40673000352	8126	Discovery Gardens Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
77588	AZ	school	407700	4393	Show Low Unified District	40770003615	7673	Show Low Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
77608	AZ	school	407820	4391	Snowflake Unified District	40782002543	87577	Snowflake Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4	*
77900	AZ	school	408850	4413	Vail Unified District	40885003665	1000286	Vail Inclusive Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
78021	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	*
142016	AZ	school	400600	4280	Alhambra Elementary District	40060003660	1000261	Alhambra Preschool Academy	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142137	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_4	*
142139	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_4	*
142142	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_4	*
142194	AZ	school	401050	4268	Balsz Elementary District	40105003374	92301	Orangedale Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	*
142299	AZ	school	401680	4282	Cartwright Elementary District	40168001054	5414	Byron A. Barry School	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142325	AZ	school	401710	4446	Casa Grande Elementary District	40171003201	90899	Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142337	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_4	*
142501	AZ	school	402400	4501	Crane Elementary District	40240002882	87486	Great Beginnings Pre-School	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142593	AZ	school	402530	4174	Douglas Unified District	40253000184	4764	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142723	AZ	school	403010	4405	Flowing Wells Unified District	40301002065	79249	Emily Meschter Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142769	AZ	school	403240	4505	Gadsden Elementary District	40324001108	6186	San Luis Pre-School	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142917	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_4	*
142924	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_4	*
142941	AZ	school	403870	4469	Humboldt Unified District	40387002926	89839	Bright Futures Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
142972	AZ	school	403960	4259	Isaac Elementary District	40396001543	5241	Bret Tarver Education Complex	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
143170	AZ	school	404630	4404	Marana Unified District	40463003663	1000279	MUSD Early Learning and Resource Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	*
143222	AZ	school	404970	4235	Mesa Unified District	40497002337	80046	Early Education Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
143267	AZ	school	404970	4235	Mesa Unified District	40497002109	79687	Red Mountain Center for Early Education	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	*
143297	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_4	*
143511	AZ	school	406250	4237	Peoria Unified School District	40625003643	1000302	GCC Early Childhood Learning Lab	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
143544	AZ	school	406300	4256	Phoenix Elementary District	40630003554	286779	Faith North Early Childhood Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
143633	AZ	school	406730	4466	Prescott Unified District	40673000352	8126	Discovery Gardens Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
143792	AZ	school	407700	4393	Show Low Unified District	40770003615	7673	Show Low Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	*
143813	AZ	school	407820	4391	Snowflake Unified District	40782002543	87577	Snowflake Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	*
144101	AZ	school	408850	4413	Vail Unified District	40885003665	1000286	Vail Inclusive Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
144185	AZ	school	409430	4154	Window Rock Unified District	40943000155	4713	Integrated Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	*
546568	AZ	school	405880	4180	Palominas Elementary District	40588001818	78914	Valley View Elementary School	Regular School	No	Prekindergarten	PK	PK	2018	grade_4	*
75764	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_4	68	68
75773	AZ	school	400129	6364	Accelerated Elementary and Secondary Schools	40012901790	5891	Accelerated Learning Laboratory	Regular School	Yes	Other	KG	12	2021	grade_4	19	19
75826	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_4	116	116
75828	AZ	school	400112	4348	American Leadership Academy, Inc.	40011203475	92885	American Leadership Academy, Ironwood K12	Regular School	Yes	Other	KG	12	2021	grade_4	122	122
75830	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_4	156	156
75833	AZ	school	400680	4406	Amphitheater Unified District	40068003330	91755	Amphi Academy Online	Regular School	No	Other	KG	12	2021	grade_4	58	58
75851	AZ	school	400680	4406	Amphitheater Unified District	40068000030	5803	Rillito Center	Special Education School	No	Other	PK	12	2021	grade_4	*
75857	AZ	school	400819	90532	Anthem Preparatory Academy	40081903187	90635	Great Hearts Academies - Anthem Prep	Regular School	Yes	Other	KG	12	2021	grade_4	59	59
75864	AZ	school	400318	79426	Aprender Tucson	40031802203	79432	Southside Community School	Regular School	Yes	Other	KG	09	2021	grade_4	27	27
75867	AZ	school	400834	90917	Archway Classical Academy Chandler	40083403244	90999	Great Hearts Academies - Archway Chandler	Regular School	Yes	Other	KG	12	2021	grade_4	90	90
75874	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_4	86	86
75875	AZ	school	400833	90916	Archway Classical Academy Veritas	40083303283	91000	Great Hearts Academies - Archway Veritas	Regular School	Yes	Other	KG	12	2021	grade_4	120	120
75889	AZ	school	400427	87407	Arizona Connections Academy Charter School, Inc.	40042703160	81179	Arizona Connections Academy	Regular School	Yes	Other	KG	12	2021	grade_4	206	206
75903	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_4	47	47
75925	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	Other	KG	12	2021	grade_4	163	163
75958	AZ	school	400897	91339	BASIS Charter Schools, Inc.	40089703376	92030	BASIS Ahwatukee	Regular School	Yes	Other	04	12	2021	grade_4	92	92
75962	AZ	school	400831	90862	BASIS Charter Schools, Inc.	40083103196	90863	BASIS Flagstaff	Regular School	Yes	Other	KG	12	2021	grade_4	89	89
75965	AZ	school	400898	91949	BASIS Charter Schools, Inc.	40089803393	91997	BASIS Mesa	Regular School	Yes	Other	KG	12	2021	grade_4	75	75
75974	AZ	school	400903	92320	BASIS Charter Schools, Inc.	40090303418	92321	BASIS Prescott	Regular School	Yes	Other	KG	12	2021	grade_4	64	64
75975	AZ	school	400608	81078	BASIS Charter Schools, Inc.	40060803115	81079	BASIS Scottsdale	Regular School	Yes	Other	04	12	2021	grade_4	*
75979	AZ	school	400134	6361	BASIS Charter Schools, Inc.	40013401786	6065	BASIS Tucson Primary	Regular School	Yes	Other	KG	12	2021	grade_4	158	158
75988	AZ	school	400212	79226	Benson Unified School District	40021203232	90775	Benson Digital Learning Center Online	Regular School	No	Other	KG	12	2021	grade_4	*
75997	AZ	school	401230	4231	Blue Elementary District	40123000069	4908	Blue Elementary School	Regular School	No	Other	KG	12	2021	grade_4	*
76032	AZ	school	400397	79971	CAFA, Inc. dba Learning Foundation Performing Arts School	40039703119	81102	Learning Foundation	Regular School	Yes	Other	KG	12	2021	grade_4	24	24
76041	AZ	school	401600	4470	Camp Verde Unified District	40160003666	1000257	Camp Verde Online	Regular School	No	Other	KG	12	2021	grade_4	*
76112	AZ	school	400001	4244	Cave Creek Unified District	40000103687	1001171	Cave Creek Academy of Excellence	Regular School	No	Other	KG	12	2021	grade_4	31	31
76133	AZ	school	400440	88299	Chandler Preparatory Academy	40044002681	88300	Great Hearts Academies - Chandler Prep	Regular School	Yes	Other	KG	12	2021	grade_4	*
76199	AZ	school	400402	5186	Cholla Academy	40040201860	10801	Westland School	Regular School	Yes	Other	KG	12	2021	grade_4	16	16
76200	AZ	school	400402	5186	Cholla Academy	40040203429	92637	Westland School Brighton Campus	Regular School	Yes	Other	KG	12	2021	grade_4	25	25
76221	AZ	school	400632	81027	Cochise Community Development Corporation	40063203105	81028	Bereran Academy	Regular School	Yes	Other	KG	12	2021	grade_4	37	37
76258	AZ	school	402370	4487	Cottonwood-Oak Creek Elementary District	40237000166	6123	Cottonwood Education Services	Regular School	No	Other	PK	12	2021	grade_4	*
76262	AZ	school	400429	79074	Country Gardens Charter Schools	40042901994	79102	Country Gardens Charter School	Regular School	Yes	Other	KG	12	2021	grade_4	42	42
76288	AZ	school	400778	89917	Daisy Education Corporation dba Paragon Science Academy	40077802902	89918	Paragon Science Academy	Regular School	Yes	Other	KG	12	2021	grade_4	53	53
76289	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_4	54	54
76290	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_4	39	39
76305	AZ	school	407750	4246	Deer Valley Unified District	40775002591	79414	Deer Valley Online Learning Program	Regular School	No	Other	KG	12	2021	grade_4	*