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 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
130733	AZ	school	400328	79457	A Center for Creative Education	40032802228	79458	Verde Valley Montessori School - A Center for Creative Education	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	*
535451	AZ	school	400328	79457	A Center for Creative Education	40032802228	79458	Verde Valley Montessori School - A Center for Creative Education	Regular School	Yes	Elementary	KG	08	2018	pre_kindergarten	*
565076	AZ	school	400328	79457	A Center for Creative Education	40032802228	79458	Verde Valley Montessori School - A Center for Creative Education	Regular School	Yes	Elementary	KG	08	2019	pre_kindergarten	*
64174	AZ	school	400998	1000166	A+ Charter Schools	40099803681	1000972	A+ Charter Schools	Regular School	Yes	High	07	12	2021	pre_kindergarten	*
64190	AZ	school		7355	ACCEL		91260	ACCEL Buckeye Learning Center						2021	pre_kindergarten	*
64191	AZ	school		7355	ACCEL		7360	ACCEL East Campus						2021	pre_kindergarten	*
64192	AZ	school		7355	ACCEL		7356	ACCEL Metro Campus						2021	pre_kindergarten	*
130745	AZ	school		7355	ACCEL		91260	ACCEL Buckeye Learning Center						2020	pre_kindergarten	*
130746	AZ	school		7355	ACCEL		7360	ACCEL East Campus						2020	pre_kindergarten	*
130747	AZ	school		7355	ACCEL		7356	ACCEL Metro Campus						2020	pre_kindergarten	*
130748	AZ	school		7355	ACCEL		1000307	ACCEL Ruth Fisher Campus						2020	pre_kindergarten	*
64204	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	Career and College Prep	Alternative School	Yes	High	07	12	2021	pre_kindergarten	*
130760	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Alternative School	Yes	High	07	12	2020	pre_kindergarten	*
535452	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2018	pre_kindergarten	*
565099	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	pre_kindergarten	*
64205	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2021	pre_kindergarten	*
130761	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2020	pre_kindergarten	*
535453	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
565100	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
64285	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
130840	AZ	school	400989	92980	ARCHES Academy	40098903642	1000276	ARCHES Academy	Regular School	Yes	Elementary	KG	07	2020	pre_kindergarten	*
64326	AZ	school		89922	ASCEND (Autism Spectrum Center for Educational and Neurological Development)		89923	ASCEND (Autism Spectrum Center for Educational and Neurological Development)						2021	pre_kindergarten	*
130894	AZ	school		89922	ASCEND (Autism Spectrum Center for Educational and Neurological Development)		89923	ASCEND (Autism Spectrum Center for Educational and Neurological Development)						2020	pre_kindergarten	*
64335	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2021	pre_kindergarten	*
64336	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2021	pre_kindergarten	*
64337	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Elementary	03	06	2021	pre_kindergarten	*
64338	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2021	pre_kindergarten	*
64339	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten	*
64340	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2021	pre_kindergarten	*
64341	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten	*
64342	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	08	12	2021	pre_kindergarten	*
64343	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	07	2021	pre_kindergarten	*
130903	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2020	pre_kindergarten	*
130904	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	07	12	2020	pre_kindergarten	*
130905	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Elementary	03	06	2020	pre_kindergarten	*
130906	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2020	pre_kindergarten	*
130907	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2020	pre_kindergarten	*
130908	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2020	pre_kindergarten	*
130909	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2020	pre_kindergarten	*
130910	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2020	pre_kindergarten	*
130911	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	08	12	2020	pre_kindergarten	*
130912	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	07	2020	pre_kindergarten	*
535454	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2018	pre_kindergarten	*
535455	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	Phoenix Collegiate Academy Charter School	Regular School	Yes	Other	PK	12	2018	pre_kindergarten	*
535456	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
535457	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
535458	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2018	pre_kindergarten	*
535459	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2018	pre_kindergarten	*
535460	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2018	pre_kindergarten	*
535461	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	Phoenix Collegiate Academy Elementary, LLC	Regular School	Yes	Elementary	KG	04	2018	pre_kindergarten	*
535462	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	Phoenix Collegiate Academy High School	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
535463	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
565214	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	pre_kindergarten	*
565215	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	pre_kindergarten	*
565216	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
565217	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
565218	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	pre_kindergarten	*
565219	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	pre_kindergarten	*
565220	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	pre_kindergarten	*
565221	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	pre_kindergarten	*
565222	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	pre_kindergarten	*
565223	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
64344	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2021	pre_kindergarten	*
130913	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2020	pre_kindergarten	*
535464	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
565224	AZ	school	400947	92987	ASU Preparatory Academy - Casa Grande	40094703526	635758	ASU Preparatory Academy - Casa Grande HS	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
64345	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	Other	KG	12	2021	pre_kindergarten	*
130914	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	Other	KG	12	2020	pre_kindergarten	*
535465	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
565225	AZ	school	400965	522074	ASU Preparatory Academy Digital	40096503556	860177	ASU Preparatory Academy Digital	Regular School	Yes	High	07	12	2019	pre_kindergarten	*
64359	AZ	school	400785	89869	AZ Compass Schools, Inc.	40078502929	89870	AZ Compass Prep School	Alternative School	Yes	High	07	12	2021	pre_kindergarten	*
130928	AZ	school	400785	89869	AZ Compass Schools, Inc.	40078502929	89870	AZ Compass Prep School	Alternative School	Yes	High	07	12	2020	pre_kindergarten	*
535466	AZ	school	400785	89869	AZ Compass Schools, Inc.	40078502929	89870	AZ Compass Prep School	Regular School	Yes	High	07	12	2018	pre_kindergarten	*
565236	AZ	school	400785	89869	AZ Compass Schools, Inc.	40078502929	89870	AZ Compass Prep School	Regular School	Yes	High	07	12	2019	pre_kindergarten	*
64175	AZ	school	400797	90199	Academy Del Sol, Inc.	40079702994	90200	Academy Del Sol	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64176	AZ	school	400797	90199	Academy Del Sol, Inc.	40079703230	90770	Academy Del Sol - Hope	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
130734	AZ	school	400797	90199	Academy Del Sol, Inc.	40079702994	90200	Academy Del Sol	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	*
130735	AZ	school	400797	90199	Academy Del Sol, Inc.	40079703230	90770	Academy Del Sol - Hope	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	*
535467	AZ	school	400797	90199	Academy Del Sol, Inc.	40079702994	90200	Academy Del Sol	Regular School	Yes	Elementary	KG	08	2018	pre_kindergarten	*
535468	AZ	school	400797	90199	Academy Del Sol, Inc.	40079703230	90770	Academy Del Sol - Hope	Regular School	Yes	Elementary	KG	08	2018	pre_kindergarten	*
565077	AZ	school	400797	90199	Academy Del Sol, Inc.	40079702994	90200	Academy Del Sol	Regular School	Yes	Elementary	KG	08	2019	pre_kindergarten	*
565078	AZ	school	400797	90199	Academy Del Sol, Inc.	40079703230	90770	Academy Del Sol - Hope	Regular School	Yes	Elementary	KG	08	2019	pre_kindergarten	*
535469	AZ	school	400128	4296	Academy Of Excellence, Inc.	40012801715	5461	Academy Of Excellence	Regular School	Yes	Elementary	KG	08	2018	pre_kindergarten	*
64177	AZ	school	400414	85540	Academy of Building Industries, Inc.	40041402412	85541	Academy of Building Industries	Alternative School	Yes	High	09	12	2021	pre_kindergarten	*
130736	AZ	school	400414	85540	Academy of Building Industries, Inc.	40041402412	85541	Academy of Building Industries	Alternative School	Yes	High	09	12	2020	pre_kindergarten	*
535470	AZ	school	400414	85540	Academy of Building Industries, Inc.	40041402412	85541	Academy of Building Industries	Regular School	Yes	High	09	12	2018	pre_kindergarten	*
565079	AZ	school	400414	85540	Academy of Building Industries, Inc.	40041402412	85541	Academy of Building Industries	Regular School	Yes	High	09	12	2019	pre_kindergarten	*
64178	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103676	1000378	Academy of Math and Science Avondale	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64179	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103581	911531	Academy of Math and Science Desert Sky	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64180	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103618	1000119	Academy of Math and Science Glendale	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64181	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103604	1000118	Academy of Math and Science Peoria Advanced	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64182	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103677	1000379	Academy of Math and Science South Mountain	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
64183	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103399	92197	Academy of Mathematics and Science South	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	*
130737	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103581	911531	Academy of Math and Science Desert Sky	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	*
130738	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103399	92197	Academy of Mathematics and Science South	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	*
535471	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103399	92197	Academy of Mathematics and Science South	Regular School	Yes	Elementary	KG	08	2018	pre_kindergarten	*
565080	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103399	92197	Academy of Mathematics and Science South	Regular School	Yes	Elementary	KG	08	2019	pre_kindergarten	*
565081	AZ	school	400891	90878	Academy of Mathematics and Science South, Inc.	40089103581	911531	Academy of Math and Science Desert Sky	Regular School	Yes	Elementary	KG	08	2019	pre_kindergarten	*
64184	AZ	school	400368	79961	Academy of Mathematics and Science, Inc.	40036802037	79094	Academy of Math and Science	Regular School	Yes	Other	KG	12	2021	pre_kindergarten	*
64185	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	pre_kindergarten	*
130739	AZ	school	400368	79961	Academy of Mathematics and Science, Inc.	40036802037	79094	Academy of Math and Science	Regular School	Yes	Other	KG	12	2020	pre_kindergarten	*