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 district_state_id 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
92184	AZ	school	400967	934316	BASIS Charter Schools, Inc.	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2021	grade_11	*
157961	AZ	school	400967	934316	BASIS Charter Schools, Inc.	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2020	grade_11	*
588905	AZ	school	400967	934316	BASIS Charter Schools, Inc	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2019	grade_11	*
92172	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2021	grade_11	*
157949	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2020	grade_11	*
559329	AZ	school	400958	92997	BASIS Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2018	grade_11	*
588923	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2019	grade_11	*
92980	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2021	grade_11	*
158746	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2020	grade_11	*
560017	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	04	2018	grade_11	*
589588	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2019	grade_11	*
92668	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	High	09	12	2021	grade_11	58	58
158433	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2020	grade_11	50	50
559740	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	High	09	12	2018	grade_11	*
589313	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2019	grade_11	24	24
92136	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2021	grade_11	53	53
157913	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2020	grade_11	54	54
559164	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2018	grade_11	32	32
588876	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2019	grade_11	47	47
94123	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
159862	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
561021	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	06	2018	grade_11	*
590595	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2019	grade_11	*
93471	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2021	grade_11	33	33
159222	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2020	grade_11	31	31
590023	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2019	grade_11	55	55
92896	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	High	09	12	2021	grade_11	105	105
158660	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2020	grade_11	84	84
559937	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	09	2018	grade_11	*
589509	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2019	grade_11	*
93901	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
159644	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2020	grade_11	*
560817	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2018	grade_11	*
590387	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2019	grade_11	*
92077	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
157840	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	07	2020	grade_11	*
93953	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
159695	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
560864	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2018	grade_11	*
590435	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2019	grade_11	*
93959	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2021	grade_11	19	19
159702	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2020	grade_11	24	24
590442	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2019	grade_11	12	12
93495	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2021	grade_11	*
159245	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2020	grade_11	*
560477	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2018	grade_11	*
590046	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2019	grade_11	*
92123	AZ	school		92932	Assist Enterprises, LLC		648314	AZ Aspire Academy - Goodyear						2021	grade_11	*
92124	AZ	school		92932	Assist Enterprises, LLC		339186	AZ Aspire Academy - Queen Creek						2021	grade_11	*
92125	AZ	school		92932	Assist Enterprises, LLC		996075	AZ Aspire Academy - Scottsdale						2021	grade_11	*
92126	AZ	school		92932	Assist Enterprises, LLC		92933	AZ Aspire Academy - Tempe						2021	grade_11	*
157899	AZ	school		92932	Assist Enterprises, LLC		648314	AZ Aspire Academy - Goodyear						2020	grade_11	*
157900	AZ	school		92932	Assist Enterprises, LLC		339186	AZ Aspire Academy - Queen Creek						2020	grade_11	*
157901	AZ	school		92932	Assist Enterprises, LLC		996075	AZ Aspire Academy - Scottsdale						2020	grade_11	*
157902	AZ	school		92932	Assist Enterprises, LLC		92933	AZ Aspire Academy - Tempe						2020	grade_11	*
92336	AZ	school		92918	Center for Autism and Related Disorders		539264	CARD Academy Chandler						2021	grade_11	*
158118	AZ	school		92918	Center for Autism and Related Disorders		539264	CARD Academy Chandler						2020	grade_11	*
92667	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2021	grade_11	*
158432	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2020	grade_11	*
559739	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2018	grade_11	*
589312	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2019	grade_11	*
93086	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
158848	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
560116	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2018	grade_11	*
589689	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2019	grade_11	*
92173	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2021	grade_11	*
157950	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2020	grade_11	*
559328	AZ	school	400936	92865	BASIS Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2018	grade_11	*
588922	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2019	grade_11	*
92188	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	04	2021	grade_11	*
157965	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	04	2020	grade_11	*
559327	AZ	school	400937	92863	BASIS Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary	Regular School	Yes	Elementary	KG	05	2018	grade_11	*
588921	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	03	2019	grade_11	*
91977	AZ	school	400940	92768	Academy of Mathematics and Science, Inc.	40094003499	92769	Academy of Math and Science Camelback	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
157740	AZ	school	400940	92768	Academy of Mathematics and Science, Inc.	40094003499	92769	Academy of Math and Science Camelback	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
559173	AZ	school	400940	92768	Academy of Mathematics and Science, Inc.	40094003499	92769	Academy of Math and Science Camelback	Regular School	Yes	Elementary	KG	08	2018	grade_11	*
588735	AZ	school	400940	92768	Academy of Mathematics and Science, Inc.	40094003499	92769	Academy of Math and Science Camelback	Regular School	Yes	Elementary	KG	08	2019	grade_11	*
92176	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2021	grade_11	*
157953	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2020	grade_11	*
559326	AZ	school	400943	92736	BASIS Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2018	grade_11	*
588920	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2019	grade_11	*
92175	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2021	grade_11	11	11
157952	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2020	grade_11	*
559325	AZ	school	400941	92734	BASIS Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	Middle	05	10	2018	grade_11	*
588919	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2019	grade_11	14	14
93088	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
93089	AZ	school		92730	Leman Academy of Excellence, Inc.		1000267	Leman Academy of Excellence - Central Tucson						2021	grade_11	*
93090	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403584	573453	Leman Academy of Excellence East Mesa	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
93091	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403586	734680	Leman Academy of Excellence East Tucson	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
93092	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403504	926143	Leman Academy of Excellence-Oro Valley Arizona	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
93093	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403542	225365	Leman Academy of Excellence-Sierra Vista	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
93094	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403547	271268	Leman Virtual Academy	Regular School	Yes	Elementary	KG	08	2021	grade_11	*
158849	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
158850	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403584	573453	Leman Academy of Excellence East Mesa	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
158851	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403586	734680	Leman Academy of Excellence East Tucson	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
158852	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403504	926143	Leman Academy of Excellence-Oro Valley Arizona	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
158853	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403542	225365	Leman Academy of Excellence-Sierra Vista	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
158854	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403547	271268	Leman Virtual Academy	Regular School	Yes	Elementary	KG	08	2020	grade_11	*
560117	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2018	grade_11	*
560118	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403504	926143	Leman Academy of Excellence-Oro Valley Arizona	Regular School	Yes	Elementary	KG	08	2018	grade_11	*
560119	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403542	225365	Leman Academy of Excellence-Sierra Vista	Regular School	Yes	Elementary	KG	08	2018	grade_11	*