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
94500	AZ	school	400967	934316	BASIS Charter Schools, Inc.	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2021	grade_12	*
160211	AZ	school	400967	934316	BASIS Charter Schools, Inc.	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2020	grade_12	*
590876	AZ	school	400967	934316	BASIS Charter Schools, Inc	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2019	grade_12	*
94488	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2021	grade_12	*
160199	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2020	grade_12	*
561304	AZ	school	400958	92997	BASIS Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2018	grade_12	*
590894	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2019	grade_12	*
95296	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2021	grade_12	*
160996	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2020	grade_12	*
561992	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	04	2018	grade_12	*
591559	AZ	school	400952	92989	Kaizen Education Foundation dba Colegio Petite Phoenix	40095203514	766437	Colegio Petite Arizona	Regular School	Yes	Elementary	KG	05	2019	grade_12	*
94984	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	High	09	12	2021	grade_12	47	47
160683	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2020	grade_12	24	24
561715	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	High	09	12	2018	grade_12	*
591284	AZ	school	400955	92988	Estrella Educational Foundation	40095503519	181823	Maricopa Institute of Technology	Regular School	Yes	Secondary	09	11	2019	grade_12	*
94452	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_12	52	52
160163	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_12	35	35
561139	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_12	24	24
590847	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_12	35	35
96439	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
162112	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2020	grade_12	*
562996	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	06	2018	grade_12	*
592566	AZ	school	400968	92985	Victory Collegiate Academy Corporation	40096803562	829726	Victory Collegiate Academy	Regular School	Yes	Elementary	KG	08	2019	grade_12	*
95787	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2021	grade_12	12	12
161472	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2020	grade_12	17	17
591994	AZ	school	400950	92983	Pathways In Education-Arizona, Inc.	40095003508	850102	Pathways in Education	Regular School	Yes	High	09	12	2019	grade_12	24	24
95212	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	High	09	12	2021	grade_12	75	75
160910	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2020	grade_12	*
561912	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	09	2018	grade_12	*
591480	AZ	school	400966	92982	Highland Prep	40096603572	703390	Highland Prep	Regular School	Yes	Secondary	09	11	2019	grade_12	*
96217	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
161894	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2020	grade_12	*
562792	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2018	grade_12	*
592358	AZ	school	400964	92981	Synergy Public School, Inc.	40096403553	962403	Synergy Public School	Regular School	Yes	Elementary	KG	05	2019	grade_12	*
94393	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
160090	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	07	2020	grade_12	*
96269	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
161945	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2020	grade_12	*
562839	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2018	grade_12	*
592406	AZ	school	400953	92978	The Grande Innovation Academy	40095303527	649230	The Grande Innovation	Regular School	Yes	Elementary	KG	08	2019	grade_12	*
96275	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2021	grade_12	17	17
161952	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2020	grade_12	19	19
592413	AZ	school	400976	92976	Think Through Academy	40097603624	1000047	Think Through Academy	Regular School	Yes	High	09	12	2019	grade_12	17	17
95811	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2021	grade_12	*
161495	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2020	grade_12	*
562452	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2018	grade_12	*
592017	AZ	school	400945	92972	Pensar Academy	40094503518	126443	Pensar Academy	Regular School	Yes	Middle	04	08	2019	grade_12	*
94439	AZ	school		92932	Assist Enterprises, LLC		648314	AZ Aspire Academy - Goodyear						2021	grade_12	*
94440	AZ	school		92932	Assist Enterprises, LLC		339186	AZ Aspire Academy - Queen Creek						2021	grade_12	*
94441	AZ	school		92932	Assist Enterprises, LLC		996075	AZ Aspire Academy - Scottsdale						2021	grade_12	*
94442	AZ	school		92932	Assist Enterprises, LLC		92933	AZ Aspire Academy - Tempe						2021	grade_12	*
160149	AZ	school		92932	Assist Enterprises, LLC		648314	AZ Aspire Academy - Goodyear						2020	grade_12	*
160150	AZ	school		92932	Assist Enterprises, LLC		339186	AZ Aspire Academy - Queen Creek						2020	grade_12	*
160151	AZ	school		92932	Assist Enterprises, LLC		996075	AZ Aspire Academy - Scottsdale						2020	grade_12	*
160152	AZ	school		92932	Assist Enterprises, LLC		92933	AZ Aspire Academy - Tempe						2020	grade_12	*
94652	AZ	school		92918	Center for Autism and Related Disorders		539264	CARD Academy Chandler						2021	grade_12	*
160368	AZ	school		92918	Center for Autism and Related Disorders		539264	CARD Academy Chandler						2020	grade_12	*
94983	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2021	grade_12	*
160682	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2020	grade_12	*
561714	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2018	grade_12	*
591283	AZ	school	400939	92902	Espiritu Schools	40093903495	92903	AIM Higher College Prep Academy	Regular School	Yes	High	07	12	2019	grade_12	*
95402	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
161098	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2020	grade_12	*
562091	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2018	grade_12	*
591660	AZ	school	400933	92879	Legacy Traditional School - Surprise	40093303496	92880	Legacy Traditional School - Surprise	Regular School	Yes	Elementary	KG	08	2019	grade_12	*
94489	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2021	grade_12	*
160200	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2020	grade_12	*
561303	AZ	school	400936	92865	BASIS Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2018	grade_12	*
590893	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2019	grade_12	*
94504	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	04	2021	grade_12	*
160215	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	04	2020	grade_12	*
561302	AZ	school	400937	92863	BASIS Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary	Regular School	Yes	Elementary	KG	05	2018	grade_12	*
590892	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	03	2019	grade_12	*
94293	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_12	*
159990	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_12	*
561148	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_12	*
590706	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_12	*
94492	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2021	grade_12	*
160203	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2020	grade_12	*
561301	AZ	school	400943	92736	BASIS Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2018	grade_12	*
590891	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2019	grade_12	*
94491	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2021	grade_12	*
160202	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2020	grade_12	*
561300	AZ	school	400941	92734	BASIS Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	Middle	05	10	2018	grade_12	*
590890	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2019	grade_12	*
95404	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
95405	AZ	school		92730	Leman Academy of Excellence, Inc.		1000267	Leman Academy of Excellence - Central Tucson						2021	grade_12	*
95406	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_12	*
95407	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_12	*
95408	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_12	*
95409	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_12	*
95410	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403547	271268	Leman Virtual Academy	Regular School	Yes	Elementary	KG	08	2021	grade_12	*
161099	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2020	grade_12	*
161100	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_12	*
161101	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_12	*
161102	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_12	*
161103	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_12	*
161104	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403547	271268	Leman Virtual Academy	Regular School	Yes	Elementary	KG	08	2020	grade_12	*
562092	AZ	school	400944	92730	Leman Academy of Excellence, Inc.	40094403503	92731	Leman Academy of Excellence	Regular School	Yes	Elementary	KG	08	2018	grade_12	*
562093	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_12	*
562094	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_12	*