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 "state" = :p0 and "year" = :p1 and (district > :p3 or (district = :p3 and rowid > :p2)) order by district, rowid 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total	black_int	hispanic_int	male_int	female_int	total_int
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												*
567070	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	kindergarten												*
569041	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_1												*
571012	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_2												*
572983	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_3												*
574954	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_4												*
576925	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_5												*
578896	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_6												*
580867	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_7												*
582838	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_8												*
584809	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_9												*
586780	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_10												22					22
588751	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_11												29					29
590722	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	grade_12												45					45
592693	AZ	school	400274	79053	AIBT Non-Profit Charter High School - Phoenix	40027402020	79123	RCB Medical Arts Academy	Regular School	Yes	High	07	12	2019	pk_12_total	*	12	78	*	*	*	*	59	42	*	*	101	12	78	59	42	101
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												*
567071	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	kindergarten												*
569042	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_1												*
571013	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_2												*
572984	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_3												*
574955	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_4												*
576926	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_5												*
578897	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_6												*
580868	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_7												*
582839	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_8												*
584810	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_9												*
586781	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_10												*
588752	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_11												*
590723	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_12												*
592694	AZ	school	400970	449790	AIBT Non-Profit Charter High School, Inc.	40097003546	742847	RCB College Preparatory Academy	Regular School	Yes	High	09	12	2019	pk_12_total	*	*	*	*	*	*	*	*	*	*	*	14					14
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												*
567185	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	kindergarten												68					68
567186	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	kindergarten												*
567187	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	kindergarten												*
567188	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	kindergarten												*
567189	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	kindergarten												73					73
567190	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	kindergarten												*
567191	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	kindergarten												*
567192	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	kindergarten												48					48
567193	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	kindergarten												*
567194	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	kindergarten												*
569156	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_1												70					70
569157	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	grade_1												*
569158	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	grade_1												*
569159	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	grade_1												*
569160	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_1												74					74
569161	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	grade_1												*
569162	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	grade_1												*
569163	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	grade_1												56					56
569164	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_1												*
569165	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	grade_1												*
571127	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_2												74					74
571128	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	grade_2												*
571129	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	grade_2												*
571130	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	grade_2												*
571131	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_2												73					73
571132	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	grade_2												*
571133	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	grade_2												*
571134	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	grade_2												45					45
571135	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_2												*
571136	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	grade_2												*
573098	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_3												71					71
573099	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	grade_3												37					37
573100	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	grade_3												*
573101	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	grade_3												*
573102	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_3												75					75
573103	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	grade_3												*
573104	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	grade_3												*
573105	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	grade_3												*
573106	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_3												*
573107	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	grade_3												*
575069	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_4												84					84
575070	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	grade_4												45					45
575071	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	grade_4												*
575072	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	grade_4												*
575073	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_4												75					75
575074	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	grade_4												*
575075	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	grade_4												*
575076	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	grade_4												*
575077	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_4												*
575078	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	grade_4												*
577040	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_5												*
577041	AZ	school	400788	90273	ASU Preparatory Academy	40078802999	90274	ASU Preparatory Academy - South Phoenix Intermediate	Regular School	Yes	Middle	03	07	2019	grade_5												41					41
577042	AZ	school	400858	91303	ASU Preparatory Academy	40085803286	91304	ASU Preparatory Academy- Phoenix High School	Regular School	Yes	High	09	12	2019	grade_5												*
577043	AZ	school	400859	91305	ASU Preparatory Academy	40085903251	91306	ASU Preparatory Academy-Polytechnic High School	Regular School	Yes	High	09	12	2019	grade_5												*
577044	AZ	school	400857	91307	ASU Preparatory Academy	40085703260	91308	ASU Preparatory Academy-Polytechnic Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_5												*
577045	AZ	school	400890	92325	ASU Preparatory Academy	40089003367	92326	ASU Preparatory Academy - Phoenix Middle School	Regular School	Yes	Middle	05	08	2019	grade_5												87					87
577046	AZ	school	400884	92327	ASU Preparatory Academy	40088403264	91323	ASU Preparatory Academy-Polytechnic Middle School	Regular School	Yes	Middle	05	08	2019	grade_5												74					74
577047	AZ	school	400956	92716	ASU Preparatory Academy	40095603505	70692	ASU Preparatory Academy - South Phoenix Primary	Regular School	Yes	Elementary	PK	04	2019	grade_5												*
577048	AZ	school	400946	346763	ASU Preparatory Academy	40094603375	92248	ASU Preparatory Academy - South Phoenix High School	Regular School	Yes	High	08	12	2019	grade_5												*
577049	AZ	school	400971	631426	ASU Preparatory Academy	40097103567	338609	ASU Preparatory Academy - Tempe	Regular School	Yes	High	09	12	2019	grade_5												*
579011	AZ	school	400764	89949	ASU Preparatory Academy	40076403051	90271	ASU Preparatory Academy- Phoenix Elementary	Regular School	Yes	Elementary	KG	04	2019	grade_6												*