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 order by school 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	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2952804	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_5	39	39
2953435	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_5	0	0
2952824	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	51	51
2953186	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	7	7
2952825	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter - High School	Regular School	Yes	High	09	12	2021	grade_5	0	0
2952805	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter - High School	Regular School	Yes	Other	KG	12	2021	grade_5	76	76
2952806	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter - High School	Regular School	Yes	Other	KG	12	2021	grade_5	13	13
2952808	NM	school	3500030	46	ALAMOGORDO	350003000799	4	ACADEMY DEL SOL ALT.	Public - High School	Alternative School	No	High	10	12	2021	grade_5	0	0
2953639	NM	school	3502370	71	SANTA FE	350237000841	24	ACADEMY FOR TECHNOLOGY & CLASSICS	Charter - High School	Regular School	Yes	High	07	12	2021	grade_5	0	0
2952826	NM	school	3500060	1	ALBUQUERQUE	350006001074	749	ACE LEADERSHIP HIGH SCHOOL	Charter - High School	Regular School	Yes	High	09	12	2021	grade_5	0	0
2953640	NM	school	3502370	71	SANTA FE	350237000534	8	ACEQUIA MADRE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	22	22
2952807	NM	school	3500185	579	ACES TECHNICAL CHARTER SCHOOL	350018501150	1	ACES TECHNICAL HIGH SCHOOL	Charter - High School	Regular School	Yes	Middle	06	06	2021	grade_5	0	0
2953460	NM	school		86	LOS LUNAS		11	ADELINO HEADSTART	Off-Site - Prekindergarten						2021	grade_5	0	0
2952827	NM	school	3500060	1	ALBUQUERQUE	350006000020	206	ADOBE ACRES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	71	71
2952828	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	34	34
2953388	NM	school	3501500	17	LAS CRUCES	350150000376	10	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	66	66
2952809	NM	school	3500030	46	ALAMOGORDO	350003000001	15	ALAMOGORDO HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2952829	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	66	66
2953001	NM	school	3500134	528	ALBUQUERQUE BILINGUAL ACADEMY	350013400923	1	ALBUQUERQUE BILINGUAL ACADEMY	Charter - Elementary School	Regular School	Yes	Elementary	PK	08	2021	grade_5	49	49
2953002	NM	school	3500181	574	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	350018101134	1	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	03	2021	grade_5	0	0
2952830	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953003	NM	school	3500130	524	ALBUQUERQUE INSTITUTE OF MATH & SCIENCE	350013000921	1	ALBUQUERQUE INSTITUTE OF MATH & SCIENCE	Charter - High School	Regular School	Yes	High	06	12	2021	grade_5	0	0
2953187	NM	school	3500900	55	ESPANOLA	350090000260	15	ALCALDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	33	33
2953004	NM	school	3500138	532	ALDO LEOPOLD CHARTER	350013800938	1	ALDO LEOPOLD CHARTER	Charter - High School	Regular School	Yes	High	06	12	2021	grade_5	0	0
2953042	NM	school	3500210	61	BERNALILLO	350021000147	16	ALGODONES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	0	0
2952831	NM	school	3500060	1	ALBUQUERQUE	350006000924	116	ALICE KING COMMUNITY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	08	2021	grade_5	55	55
2953005	NM	school	3500116	511	ALMA D'ARTE CHARTER	350011600900	1	ALMA D'ARTE CHARTER	Charter - High School	Regular School	Yes	High	09	12	2021	grade_5	0	0
2953245	NM	school	3501080	19	GADSDEN	350108001104	18	ALTA VISTA EARLY COLLEGE HIGH SCHOOL	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953569	NM	school	3502160	79	QUESTA	350216000804	1	ALTA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	03	2021	grade_5	0	0
2953570	NM	school	3502160	79	QUESTA	350216000495	3	ALTA VISTA INTERMEDIATE	Public - Elementary School	Regular School	No	Middle	04	06	2021	grade_5	16	16
2953006	NM	school	3500178	575	ALTURA PREPARATORY SCHOOL	350017801138	1	ALTURA PREPARATORY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	04	2021	grade_5	0	0
2952832	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	55	55
2953118	NM	school	3500510	84	CLAYTON	350051000200	37	ALVIS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	grade_5	0	0
2953007	NM	school	3500131	525	AMY BIEHL CHARTER HIGH SCHOOL	350013100810	1	AMY BIEHL CHARTER HIGH SCHOOL	Charter - High School	Regular School	Yes	High	09	12	2021	grade_5	0	0
2953641	NM	school	3502370	71	SANTA FE	350237001061	141	AMY BIEHL COMMUNITY SCHOOL AT RANCHO VIEJO	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	57	57
2953713	NM	school	3502520	76	TAOS	350252000844	6	ANANSI CHARTER SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	08	2021	grade_5	23	23
2953008	NM	school	3500090	30	ANIMAS	350009000619	17	ANIMAS 7-12 SCHOOL	Public - High School	Regular School	No	High	07	12	2021	grade_5	0	0
2953009	NM	school	3500090	30	ANIMAS	350009000618	16	ANIMAS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	grade_5	0	0
2953217	NM	school	3500990	65	FARMINGTON	350099000280	15	ANIMAS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	76	76
2953010	NM	school	3500090	30	ANIMAS	350009030019	20	ANIMAS MIDDLE	Public - Middle School	Regular School	No	Middle	05	06	2021	grade_5	12	12
2953461	NM	school	3501680	86	LOS LUNAS	350168000703	150	ANN PARISH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	67	67
2953246	NM	school	3501080	19	GADSDEN	350108000625	16	ANTHONY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	42	42
2953247	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	grade_5	0	0
2953674	NM	school	3502400	25	SANTA ROSA	350240000324	20	ANTON CHICO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
2952833	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	59	59
2953218	NM	school	3500990	65	FARMINGTON	350099000281	17	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	76	76
2952834	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	47	47
2953740	NM	school	3502610	73	TRUTH OR CONS.	350261000591	16	ARREY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	12	12
2953389	NM	school	3501500	17	LAS CRUCES	350150001105	19	ARROWHEAD PARK MEDICAL ACADEMY	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953714	NM	school	3502520	76	TAOS	350252000790	4	ARROYO DEL NORTE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	20	20
2952835	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	55	55
2953011	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_5	0	0
2953012	NM	school	3500120	22	ARTESIA	350012000127	14	ARTESIA HIGH	Public - High School	Regular School	No	High	10	12	2021	grade_5	0	0
2953013	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_5	0	0
2953014	NM	school	3500120	22	ARTESIA	350012000134	189	ARTESIA ZIA INTERMEDIATE	Public - Middle School	Regular School	No	Middle	06	07	2021	grade_5	0	0
2953126	NM	school	3500570	12	CLOVIS	350057000209	42	ARTS ACADEMY AT BELLA VISTA	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	55	55
2953642	NM	school	3502370	71	SANTA FE	350237001059	54	ASPEN COMMUNITY SCHOOL	Public - Elementary School	Regular School	No	Elementary	PK	08	2021	grade_5	45	45
2953450	NM	school	3501650	41	LOS ALAMOS	350165000427	17	ASPEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	69	69
2953643	NM	school	3502370	71	SANTA FE	350237000537	33	ATALAYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	37	37
2952836	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	45	45
2952837	NM	school	3500060	1	ALBUQUERQUE	350006001037	576	ATRISCO HERITAGE ACADEMY HS	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953024	NM	school	3500150	64	AZTEC	350015000135	18	AZTEC HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953379	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported - State Supported	Alternative School	No	High	09	12	2021	grade_5	0	0
2952838	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	75	75
2952839	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	61	61
2953451	NM	school	3501650	41	LOS ALAMOS	350165000428	21	BARRANCA MESA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	61	61
2953127	NM	school	3500570	12	CLOVIS	350057000208	40	BARRY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	51	51
2953158	NM	school	3500690	42	DEMING	350069000941	5	BATAAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	56	56
2953145	NM	school	3500600	24	COBRE CONS.	350060000225	23	BAYARD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	30	30
2952840	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	38	38
2953031	NM	school	3500180	87	BELEN	350018000140	26	BELEN HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953032	NM	school	3500180	87	BELEN	350018000848	1	BELEN INFINITY HIGH	Public - High School	Alternative School	No	High	09	12	2021	grade_5	0	0
2953033	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_5	0	0
2953159	NM	school	3500690	42	DEMING	350069000236	24	BELL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	30	30
2952841	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	50	50
2953480	NM	school	3501740	31	LOVINGTON	350174000449	123	BEN ALEXANDER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	02	02	2021	grade_5	0	0
2953248	NM	school	3501080	19	GADSDEN	350108030017	20	BERINO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	53	53
2952842	NM	school		1	ALBUQUERQUE		974	BERNALILLO ACADEMY	Off-Site - Special Education						2021	grade_5	1	1
2952843	NM	school		1	ALBUQUERQUE		48	BERNALILLO COUNTY JUVENILE DETENTION	Off-Site - High School						2021	grade_5	0	0
2953043	NM	school	3500210	61	BERNALILLO	350021000152	136	BERNALILLO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	03	05	2021	grade_5	139	139
2953044	NM	school	3500210	61	BERNALILLO	350021000148	27	BERNALILLO HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953045	NM	school	3500210	61	BERNALILLO	350021000149	26	BERNALILLO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
2953605	NM	school	3502250	4	ROSWELL	350225000505	24	BERRENDO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	48	48
2953606	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
2953055	NM	school	3500240	66	BLOOMFIELD	350024000155	25	BLANCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	01	06	2021	grade_5	38	38
2953056	NM	school	3500240	66	BLOOMFIELD	350024000609	30	BLOOMFIELD EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	grade_5	0	0
2953057	NM	school	3500240	66	BLOOMFIELD	350024000156	26	BLOOMFIELD HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953312	NM	school	3501170	88	GRANTS	350117000327	915	BLUEWATER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	13	13
2953219	NM	school	3500990	65	FARMINGTON	350099000282	19	BLUFFVIEW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	64	64
2953390	NM	school	3501500	17	LAS CRUCES	350150000396	172	BOOKER T. WASHINGTON	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	31	31
2953337	NM	school	3501260	33	HOBBS	350126000357	172	BOOKER T. WASHINGTON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	13	13
2953462	NM	school	3501680	86	LOS LUNAS	350168000436	28	BOSQUE FARMS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	72	72
2953338	NM	school	3501260	33	HOBBS	350126000345	28	BROADMOOR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	60	60
2953560	NM	school	3502100	57	PORTALES	350210000485	28	BROWN EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	grade_5	0	0
2952810	NM	school	3500030	46	ALAMOGORDO	350003000002	28	BUENA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	36	36
2953025	NM	school	3500150	64	AZTEC	350015000136	17	C.V. KOOGLER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
2953128	NM	school	3500570	12	CLOVIS	350057000211	68	CAMEO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	33	33
2953380	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_5	0	0
2953391	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
2953644	NM	school	3502370	71	SANTA FE	350237000724	20	CAPITAL HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_5	0	0
2953063	NM	school	3500270	40	CAPITAN	350027000160	33	CAPITAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	27	27