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 and "year" = :p2 and (school > :p4 or (school = :p4 and rowid > :p3)) order by school, 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	total	total_int
573056	AZ	school	400750	4178	Apache Elementary District	40075000039	4786	Apache Elementary School	Regular School	No	Elementary	KG	08	2019	grade_3	*
574296	AZ	school	406250	4237	Peoria Unified School District	40625001501	5006	Apache Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	75	75
573060	AZ	school	400790	4443	Apache Junction Unified District	40079000043	5925	Apache Junction High School	Regular School	No	High	09	12	2019	grade_3	*
573010	AZ	school	400357	79883	American Charter Schools Foundation d.b.a. Apache Trail High School	40035701732	6346	Apache Trail High School	Regular School	Yes	High	09	12	2019	grade_3	*
573704	AZ	school	403450	4285	Glendale Union High School District	40345000275	5431	Apollo High School	Regular School	No	High	09	12	2019	grade_3	*
574595	AZ	school	408170	4407	Sunnyside Unified District	40817000706	5809	Apollo Middle School	Regular School	No	Middle	06	08	2019	grade_3	*
574525	AZ	school	407570	4240	Scottsdale Unified District	40757000640	5066	Arcadia High School	Regular School	No	High	09	12	2019	grade_3	*
573074	AZ	school	400164	6378	Arizona Academy of Science And Technology, Inc.	40016401726	10755	Arizona Academy of Science and Technology	Regular School	Yes	Elementary	KG	08	2019	grade_3	*
573079	AZ	school	400828	90779	Arizona Agribusiness & Equine Center, Inc.	40082803199	90780	Arizona Agribusiness & Equine Center - Estrella	Regular School	Yes	High	09	12	2019	grade_3	*
573075	AZ	school	400969	134379	Arizona Agribusiness & Equine Center INC.	40096903543	156568	Arizona Agribusiness & Equine Center, Inc. - Mesa	Regular School	Yes	High	09	12	2019	grade_3	*
573080	AZ	school	400838	91131	Arizona Agribusiness & Equine Center, Inc.	40083803243	91132	Arizona Agribusiness & Equine Center, Inc. - Prescott Valley	Regular School	Yes	High	09	12	2019	grade_3	*
573078	AZ	school	400426	87403	Arizona Agribusiness & Equine Center, Inc.	40042602528	87404	Arizona Agribusiness & Equine Center, Inc. - Red Mountain	Regular School	Yes	High	09	12	2019	grade_3	*
573081	AZ	school	400913	91958	Arizona Autism Charter Schools, Inc.	40091303455	92598	Arizona Autism Charter School	Regular School	Yes	Elementary	KG	06	2019	grade_3	23	23
573082	AZ	school	400913	91958	Arizona Autism Charter Schools, Inc.	40091303512	92984	Arizona Autism Charter School, Upper School Campus	Regular School	Yes	High	05	12	2019	grade_3	*
574594	AZ	school	400326	79453	Success School	40032602162	79454	Arizona Charter Academy	Regular School	Yes	Elementary	KG	08	2019	grade_3	96	96
574686	AZ	school	408550	4450	Toltec School District	40855003405	92244	Arizona City Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	60	60
573357	AZ	school	400862	91773	Collaborative Pathways, Inc.	40086201783	10733	Arizona College Prep Academy	Regular School	Yes	High	09	12	2019	grade_3	*
573321	AZ	school	401870	4242	Chandler Unified District #80	40187002822	89591	Arizona College Prep Erie Campus	Regular School	No	High	07	12	2019	grade_3	*
573325	AZ	school	401870	4242	Chandler Unified District #80	40187002995	90302	Arizona College Prep Oakland Campus	Regular School	No	Middle	06	08	2019	grade_3	*
574361	AZ	school	400821	90536	Pima Prevention Partnership	40082103226	90907	Arizona Collegiate High School	Regular School	Yes	High	09	12	2019	grade_3	*
573087	AZ	school	400427	87407	Arizona Connections Academy Charter School, Inc.	40042703160	81179	Arizona Connections Academy	Regular School	Yes	Other	KG	12	2019	grade_3	98	98
573506	AZ	school	400653	79981	Edkey, Inc. - Arizona Conservatory for Arts and Academics	40065303069	79982	Arizona Conservatory for Arts and Academics	Regular School	Yes	High	09	12	2019	grade_3	*
573511	AZ	school	400637	81043	Edkey, Inc. - Redwood Academy	40063702032	79263	Arizona Conservatory for Arts and Academics Elementary School	Regular School	Yes	Elementary	KG	05	2019	grade_3	47	47
573507	AZ	school	400653	79981	Edkey, Inc. - Arizona Conservatory for Arts and Academics	40065303004	90349	Arizona Conservatory for Arts and Academics Middle School	Regular School	Yes	Middle	06	08	2019	grade_3	*
573625	AZ	school	403240	4505	Gadsden Elementary District	40324001806	6187	Arizona Desert Elementary School	Regular School	No	Elementary	KG	06	2019	grade_3	90	90
574676	AZ	school	408490	4264	Tolleson Elementary District	40849001705	10869	Arizona Desert Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	78	78
574394	AZ	school	400432	87405	Portable Practical Educational Preparation, Inc. (PPEP, Inc.)	40043203324	91830	Arizona Insight Academy	Regular School	Yes	High	07	12	2019	grade_3	*
573090	AZ	school	400918	92566	Arizona Language Preparatory	40091803426	92567	Arizona Language Preparatory	Regular School	Yes	Elementary	KG	06	2019	grade_3	*
574159	AZ	school	400303	79701	North Star Charter School, Inc.	40030302181	79702	Arizona Preparatory Academy	Regular School	Yes	High	09	12	2019	grade_3	*
573092	AZ	school	400056	4345	Arizona School For The Arts	40005600781	5519	Arizona School For The Arts	Regular School	Yes	High	05	12	2019	grade_3	*
574393	AZ	school	400432	87405	Portable Practical Educational Preparation, Inc. (PPEP, Inc.)	40043202200	79705	Arizona Virtual Academy	Regular School	Yes	Other	KG	12	2019	grade_3	237	237
573093	AZ	school	400840	4274	Arlington Elementary District	40084000044	5354	Arlington Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	24	24
574638	AZ	school	408310	4258	Tempe School District	40831000764	5222	Arredondo Elementary School	Regular School	No	Elementary	PK	05	2019	grade_3	54	54
573423	AZ	school	407750	4246	Deer Valley Unified District	40775001436	5154	Arrowhead Elementary School	Regular School	No	Elementary	PK	06	2019	grade_3	65	65
574194	AZ	school	405930	4241	Paradise Valley Unified District	40593000473	5073	Arrowhead Elementary School	Regular School	No	Elementary	PK	06	2019	grade_3	34	34
574836	AZ	school	409060	4260	Washington Elementary School District	40906000917	5246	Arroyo Elementary School	Regular School	No	Elementary	KG	08	2019	grade_3	57	57
574134	AZ	school	405400	4265	Murphy Elementary District	40540000446	5290	Arthur M Hamilton School	Regular School	No	Elementary	PK	08	2019	grade_3	24	24
574178	AZ	school	400239	6235	P.L.C. Charter Schools	40023902533	87413	Arts Academy at Estrella Mountain	Regular School	Yes	Elementary	KG	08	2019	grade_3	137	137
573094	AZ	school	400870	4187	Ash Creek Elementary District	40087000046	4797	Ash Creek Elementary	Regular School	No	Elementary	PK	08	2019	grade_3	*
573095	AZ	school	400910	4471	Ash Fork Joint Unified District	40091000047	6101	Ash Fork Elementary School	Regular School	No	Elementary	KG	05	2019	grade_3	14	14
573097	AZ	school	400910	4471	Ash Fork Joint Unified District	40091000048	6103	Ash Fork High School	Regular School	No	High	09	12	2019	grade_3	*
573096	AZ	school	400910	4471	Ash Fork Joint Unified District	40091001059	6102	Ash Fork Middle School	Regular School	No	Middle	06	08	2019	grade_3	*
573668	AZ	school	403400	4239	Gilbert Unified District	40340001986	79181	Ashland Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	117	117
573479	AZ	school	402690	4243	Dysart Unified District	40269003124	81111	Ashton Ranch Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	52	52
574901	AZ	school	400315	79379	Yavapai Accommodation School District	40031503318	91815	Aspire High School	Regular School	No	High	07	12	2019	grade_3	*
573315	AZ	school	401870	4242	Chandler Unified District #80	40187002587	85838	Audrey & Robert Ryan Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	119	119
573670	AZ	school	403400	4239	Gilbert Unified District	40340002114	79630	Augusta Ranch Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	125	125
574336	AZ	school	406300	4256	Phoenix Elementary District	40630002129	79616	Augustus H. Shaw Montessori	Regular School	No	Elementary	PK	08	2019	grade_3	42	42
573547	AZ	school	400235	79214	Excalibur Charter Schools, Inc.	40023503157	81173	Avalon Elementary	Regular School	Yes	Elementary	KG	08	2019	grade_3	35	35
573118	AZ	school	400960	4272	Avondale Elementary District	40096003387	91985	Avondale Middle School	Regular School	No	Middle	06	08	2019	grade_3	*
573146	AZ	school	400897	91339	BASIS Charter Schools, Inc.	40089703376	92030	BASIS Ahwatukee	Regular School	Yes	Other	04	12	2019	grade_3	*
573142	AZ	school	400830	90842	BASIS Charter Schools, Inc.	40083003253	91056	BASIS Chandler	Regular School	Yes	High	05	12	2019	grade_3	*
573155	AZ	school	400958	92997	BASIS Charter Schools, Inc.	40095803534	93010	BASIS Chandler Primary - North Campus	Regular School	Yes	Elementary	KG	04	2019	grade_3	127	127
573154	AZ	school	400936	92865	BASIS Charter Schools, Inc.	40093603484	92866	BASIS Chandler Primary- South Campus	Regular School	Yes	Elementary	KG	05	2019	grade_3	104	104
573143	AZ	school	400831	90862	BASIS Charter Schools, Inc.	40083103196	90863	BASIS Flagstaff	Regular School	Yes	Other	KG	12	2019	grade_3	66	66
573151	AZ	school	400941	92734	BASIS Charter Schools, Inc.	40094103502	92735	BASIS Goodyear	Regular School	Yes	High	05	12	2019	grade_3	*
573152	AZ	school	400943	92736	BASIS Charter Schools, Inc.	40094303498	92737	BASIS Goodyear Primary	Regular School	Yes	Elementary	KG	05	2019	grade_3	97	97
573147	AZ	school	400898	91949	BASIS Charter Schools, Inc.	40089803393	91997	BASIS Mesa	Regular School	Yes	Other	KG	12	2019	grade_3	64	64
573140	AZ	school	400818	90508	BASIS Charter Schools, Inc.	40081803197	90509	BASIS Oro Valley	Regular School	Yes	High	05	12	2019	grade_3	*
573148	AZ	school	400905	92318	BASIS Charter Schools, Inc.	40090503419	92319	BASIS Oro Valley Primary	Regular School	Yes	Elementary	KG	06	2019	grade_3	126	126
573141	AZ	school	400829	90841	BASIS Charter Schools, Inc.	40082903278	91055	BASIS Peoria	Regular School	Yes	High	05	12	2019	grade_3	*
573156	AZ	school	400963	273398	BASIS Charter Schools, Inc.	40096303558	103670	BASIS Peoria Primary	Regular School	Yes	Elementary	KG	04	2019	grade_3	134	134
573144	AZ	school	400843	91280	BASIS Charter Schools, Inc.	40084303351	91343	BASIS Phoenix	Regular School	Yes	High	05	12	2019	grade_3	*
573150	AZ	school	400881	92349	BASIS Charter Schools, Inc.	40088103394	92350	BASIS Phoenix Central Primary	Regular School	Yes	Other	KG	12	2019	grade_3	116	116
573137	AZ	school	400967	934316	BASIS Charter Schools, Inc	40096703560	469376	BASIS Phoenix Primary	Regular School	Yes	Elementary	KG	05	2019	grade_3	125	125
573157	AZ	school	400961	549803	BASIS Charter Schools, Inc.	40096103550	139682	BASIS Phoenix South Primary	Regular School	Yes	Elementary	KG	04	2019	grade_3	48	48
573149	AZ	school	400903	92320	BASIS Charter Schools, Inc.	40090303418	92321	BASIS Prescott	Regular School	Yes	Other	KG	12	2019	grade_3	57	57
573139	AZ	school	400608	81078	BASIS Charter Schools, Inc.	40060803115	81079	BASIS Scottsdale	Regular School	Yes	Other	04	12	2019	grade_3	*
573153	AZ	school	400937	92863	BASIS Charter Schools, Inc.	40093703482	92864	BASIS Scottsdale Primary - East Campus	Regular School	Yes	Elementary	KG	03	2019	grade_3	145	145
573158	AZ	school	400980	783027	BASIS Charter Schools, Inc.	40098003607	893297	BASIS Scottsdale Primary - West Campus	Regular School	Yes	Elementary	KG	04	2019	grade_3	71	71
573145	AZ	school	400878	91309	BASIS Charter Schools, Inc.	40087803350	91766	BASIS Tucson North	Regular School	Yes	High	05	12	2019	grade_3	*
573138	AZ	school	400134	6361	BASIS Charter Schools, Inc.	40013401786	6065	BASIS Tucson Primary	Regular School	Yes	Other	KG	12	2019	grade_3	164	164
573124	AZ	school	403950	4412	Baboquivari Unified School District #40	40395000310	5847	Baboquivari High School	Regular School	No	High	09	12	2019	grade_3	*
573123	AZ	school	403950	4412	Baboquivari Unified School District #40	40395000311	5846	Baboquivari Middle School	Regular School	No	Middle	07	08	2019	grade_3	*
573128	AZ	school	401000	4468	Bagdad Unified District	40100000052	6088	Bagdad Elementary School	Regular School	No	Elementary	PK	05	2019	grade_3	33	33
573129	AZ	school	401000	4468	Bagdad Unified District	40100000053	6089	Bagdad Middle / Senior High School	Regular School	No	High	06	12	2019	grade_3	*
573189	AZ	school	401380	4269	Buckeye Elementary District	40138003123	81110	Bales Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	90	90
573132	AZ	school	400867	90885	Ball Charter Schools (Val Vista)	40086703342	91791	Ball Charter Schools (Val Vista)	Regular School	Yes	Elementary	KG	08	2019	grade_3	32	32
573950	AZ	school	404380	4281	Litchfield Elementary District	40438002499	87522	Barbara B. Robey Elementary School	Regular School	No	Elementary	PK	05	2019	grade_3	107	107
572991	AZ	school	400600	4280	Alhambra Elementary District	40060000008	5384	Barcelona Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	126	126
573431	AZ	school	407750	4246	Deer Valley Unified District	40775001331	5162	Barry Goldwater High School	Regular School	No	High	07	12	2019	grade_3	*
573307	AZ	school	401870	4242	Chandler Unified District #80	40187001996	79247	Basha Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	92	92
573308	AZ	school	401870	4242	Chandler Unified District #80	40187002250	79633	Basha High School	Regular School	No	High	06	12	2019	grade_3	*
573159	AZ	school	401080	4481	Beaver Creek Elementary District	40108000059	6116	Beaver Creek School	Regular School	No	Elementary	PK	08	2019	grade_3	40	40
573956	AZ	school	404410	4374	Littlefield Unified District	40441001302	5579	Beaver Dam Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	40	40
573957	AZ	school	404410	4374	Littlefield Unified District	40441002418	85821	Beaver Dam High School	Regular School	No	High	07	12	2019	grade_3	*
574256	AZ	school	400344	78890	Pathways KM Charter Schools, Inc	40034403467	92883	Bella Vista Academy	Regular School	Yes	Middle	06	08	2019	grade_3	*
574551	AZ	school	401460	4175	Sierra Vista Unified District	40146003062	4775	Bella Vista Elementary School	Regular School	No	Elementary	KG	06	2019	grade_3	54	54
573420	AZ	school	407750	4246	Deer Valley Unified District	40775001146	5151	Bellair Elementary School	Regular School	No	Elementary	PK	06	2019	grade_3	64	64
573161	AZ	school	400181	10972	Benchmark School, Inc.	40018101889	78803	Benchmark School	Regular School	Yes	Elementary	KG	06	2019	grade_3	66	66
573162	AZ	school	400065	4355	Benjamin Franklin Charter School	40006501599	5537	Benjamin Franklin Charter School - Crismon	Regular School	Yes	Elementary	KG	06	2019	grade_3	101	101
573163	AZ	school	400065	4355	Benjamin Franklin Charter School	40006501600	5538	Benjamin Franklin Charter School - Gilbert	Regular School	Yes	Elementary	KG	06	2019	grade_3	72	72
573164	AZ	school	400065	4355	Benjamin Franklin Charter School	40006502685	88341	Benjamin Franklin Charter School - Power	Regular School	Yes	Elementary	KG	06	2019	grade_3	94	94
573165	AZ	school	400065	4355	Benjamin Franklin Charter School	40006503395	92270	Benjamin Franklin High School	Regular School	Yes	High	07	12	2019	grade_3	*
574794	AZ	school	400037	4310	Twenty First Century Charter School, Inc. Bennett Academy	40003700712	5475	Bennett Academy	Regular School	Yes	Elementary	KG	08	2019	grade_3	*
574795	AZ	school	400037	4310	Twenty First Century Charter School, Inc. Bennett Academy	40003703168	81200	Bennett Academy - Venture Site	Regular School	Yes	Elementary	KG	07	2019	grade_3	24	24
573168	AZ	school	400212	79226	Benson Unified School District	40021200061	4799	Benson High School	Regular School	No	High	09	12	2019	grade_3	*
573167	AZ	school	400212	79226	Benson Unified School District	40021201120	4794	Benson Middle School	Regular School	No	Middle	05	08	2019	grade_3	*
573166	AZ	school	400212	79226	Benson Unified School District	40021200060	4793	Benson Primary School	Regular School	No	Elementary	PK	05	2019	grade_3	83	83
573351	AZ	school	400632	81027	Cochise Community Development Corporation	40063203105	81028	Bereran Academy	Regular School	Yes	Other	KG	12	2019	grade_3	21	21
574449	AZ	school	407080	4279	Roosevelt Elementary District	40708002498	87883	Bernard Black Elementary School	Regular School	No	Elementary	PK	08	2019	grade_3	70	70