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 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
2951826	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_4	26	26
2546316	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_4	0	0
2952457	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_4	0	0
2545689	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	70	70
2951846	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	45	45
2546062	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_4	11	11
2952208	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_4	13	13
2545690	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_4	0	0
2951847	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter - High School	Regular School	Yes	High	09	12	2021	grade_4	0	0
2545671	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_4	58	58
2951827	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_4	78	78
2545672	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_4	11	11
2951828	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_4	8	8
2546525	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_4	0	0
2545673	NM	school	3500030	46	ALAMOGORDO	350003000799	4	ACADEMY DEL SOL ALT.	Public	Alternative School	No	High	10	12	2020	grade_4	0	0
2951830	NM	school	3500030	46	ALAMOGORDO	350003000799	4	ACADEMY DEL SOL ALT.	Public - High School	Alternative School	No	High	10	12	2021	grade_4	0	0
2546526	NM	school	3502370	71	SANTA FE	350237000841	24	ACADEMY FOR TECHNOLOGY & CLASSICS	Charter	Regular School	Yes	High	07	12	2020	grade_4	0	0
2952661	NM	school	3502370	71	SANTA FE	350237000841	24	ACADEMY FOR TECHNOLOGY & CLASSICS	Charter - High School	Regular School	Yes	High	07	12	2021	grade_4	0	0
2545691	NM	school	3500060	1	ALBUQUERQUE	350006001074	749	ACE LEADERSHIP HIGH SCHOOL	Charter	Regular School	Yes	High	09	12	2020	grade_4	0	0
2951848	NM	school	3500060	1	ALBUQUERQUE	350006001074	749	ACE LEADERSHIP HIGH SCHOOL	Charter - High School	Regular School	Yes	High	09	12	2021	grade_4	0	0
2546527	NM	school	3502370	71	SANTA FE	350237000534	8	ACEQUIA MADRE ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_4	25	25
2952662	NM	school	3502370	71	SANTA FE	350237000534	8	ACEQUIA MADRE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_4	21	21
2951829	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_4	0	0
2546342	NM	school		86	LOS LUNAS		11	ADELINO HEADSTART	Off-Site						2020	grade_4	0	0
2952482	NM	school		86	LOS LUNAS		11	ADELINO HEADSTART	Off-Site - Prekindergarten						2021	grade_4	0	0
2545692	NM	school	3500060	1	ALBUQUERQUE	350006000020	206	ADOBE ACRES ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	80	80
2951849	NM	school	3500060	1	ALBUQUERQUE	350006000020	206	ADOBE ACRES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	76	76
2545693	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	39	39
2546268	NM	school	3501500	17	LAS CRUCES	350150000376	10	ALAMEDA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	69	69
2951850	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	24	24
2952410	NM	school	3501500	17	LAS CRUCES	350150000376	10	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	73	73
2545674	NM	school	3500030	46	ALAMOGORDO	350003000001	15	ALAMOGORDO HIGH	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2951831	NM	school	3500030	46	ALAMOGORDO	350003000001	15	ALAMOGORDO HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2545694	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	72	72
2951851	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	58	58
2545870	NM	school	3500134	528	ALBUQUERQUE BILINGUAL ACADEMY	350013400923	1	ALBUQUERQUE BILINGUAL ACADEMY	Charter	Regular School	Yes	Elementary	PK	08	2020	grade_4	50	50
2952023	NM	school	3500134	528	ALBUQUERQUE BILINGUAL ACADEMY	350013400923	1	ALBUQUERQUE BILINGUAL ACADEMY	Charter - Elementary School	Regular School	Yes	Elementary	PK	08	2021	grade_4	37	37
2545871	NM	school	3500181	574	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	350018101134	1	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	Charter	Regular School	Yes	Elementary	KG	02	2020	grade_4	0	0
2952024	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_4	0	0
2545695	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2951852	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2545872	NM	school	3500130	524	ALBUQUERQUE INSTITUTE OF MATH & SCIENCE	350013000921	1	ALBUQUERQUE INSTITUTE OF MATH & SCIENCE	Charter	Regular School	Yes	High	06	12	2020	grade_4	0	0
2952025	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_4	0	0
2546063	NM	school	3500900	55	ESPANOLA	350090000260	15	ALCALDE ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4	34	34
2952209	NM	school	3500900	55	ESPANOLA	350090000260	15	ALCALDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	19	19
2545873	NM	school	3500138	532	ALDO LEOPOLD CHARTER	350013800938	1	ALDO LEOPOLD CHARTER	Charter	Regular School	Yes	High	06	12	2020	grade_4	0	0
2952026	NM	school	3500138	532	ALDO LEOPOLD CHARTER	350013800938	1	ALDO LEOPOLD CHARTER	Charter - High School	Regular School	Yes	High	06	12	2021	grade_4	0	0
2545911	NM	school	3500210	61	BERNALILLO	350021000147	16	ALGODONES ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	32	32
2952064	NM	school	3500210	61	BERNALILLO	350021000147	16	ALGODONES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	22	22
2545696	NM	school	3500060	1	ALBUQUERQUE	350006000924	116	ALICE KING COMMUNITY SCHOOL	Charter	Regular School	Yes	Elementary	KG	08	2020	grade_4	59	59
2951853	NM	school	3500060	1	ALBUQUERQUE	350006000924	116	ALICE KING COMMUNITY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	08	2021	grade_4	64	64
2545874	NM	school	3500116	511	ALMA D'ARTE CHARTER	350011600900	1	ALMA D'ARTE CHARTER	Charter	Regular School	Yes	High	09	12	2020	grade_4	0	0
2952027	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_4	0	0
2546124	NM	school	3501080	19	GADSDEN	350108001104	18	ALTA VISTA EARLY COLLEGE HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2952267	NM	school	3501080	19	GADSDEN	350108001104	18	ALTA VISTA EARLY COLLEGE HIGH SCHOOL	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2546454	NM	school	3502160	79	QUESTA	350216000804	1	ALTA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	grade_4	0	0
2952591	NM	school	3502160	79	QUESTA	350216000804	1	ALTA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	03	2021	grade_4	0	0
2546455	NM	school	3502160	79	QUESTA	350216000495	3	ALTA VISTA INTERMEDIATE	Public	Regular School	No	Middle	04	06	2020	grade_4	17	17
2952592	NM	school	3502160	79	QUESTA	350216000495	3	ALTA VISTA INTERMEDIATE	Public - Elementary School	Regular School	No	Middle	04	06	2021	grade_4	19	19
2545875	NM	school	3500178	575	ALTURA PREPARATORY SCHOOL	350017801138	1	ALTURA PREPARATORY SCHOOL	Charter	Regular School	Yes	Elementary	KG	03	2020	grade_4	0	0
2952028	NM	school	3500178	575	ALTURA PREPARATORY SCHOOL	350017801138	1	ALTURA PREPARATORY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	04	2021	grade_4	11	11
2545697	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	60	60
2951854	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	48	48
2545990	NM	school	3500510	84	CLAYTON	350051000200	37	ALVIS ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	grade_4	32	32
2952140	NM	school	3500510	84	CLAYTON	350051000200	37	ALVIS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	grade_4	31	31
2545876	NM	school	3500131	525	AMY BIEHL CHARTER HIGH SCHOOL	350013100810	1	AMY BIEHL CHARTER HIGH SCHOOL	Charter	Regular School	Yes	High	09	12	2020	grade_4	0	0
2952029	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_4	0	0
2546528	NM	school	3502370	71	SANTA FE	350237001061	141	AMY BIEHL COMMUNITY SCHOOL AT RANCHO VIEJO	Public	Regular School	No	Elementary	KG	06	2020	grade_4	60	60
2952663	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_4	51	51
2546599	NM	school	3502520	76	TAOS	350252000844	6	ANANSI CHARTER SCHOOL	Charter	Regular School	Yes	Elementary	KG	08	2020	grade_4	23	23
2952735	NM	school	3502520	76	TAOS	350252000844	6	ANANSI CHARTER SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	08	2021	grade_4	21	21
2545877	NM	school	3500090	30	ANIMAS	350009000619	17	ANIMAS 7-12 SCHOOL	Public	Regular School	No	High	07	12	2020	grade_4	0	0
2952030	NM	school	3500090	30	ANIMAS	350009000619	17	ANIMAS 7-12 SCHOOL	Public - High School	Regular School	No	High	07	12	2021	grade_4	0	0
2545878	NM	school	3500090	30	ANIMAS	350009000618	16	ANIMAS ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	grade_4	11	11
2546095	NM	school	3500990	65	FARMINGTON	350099000280	15	ANIMAS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	72	72
2952031	NM	school	3500090	30	ANIMAS	350009000618	16	ANIMAS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	grade_4	9	9
2952239	NM	school	3500990	65	FARMINGTON	350099000280	15	ANIMAS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	63	63
2545879	NM	school	3500090	30	ANIMAS	350009030019	20	ANIMAS MIDDLE	Public	Regular School	No	Middle	05	06	2020	grade_4	0	0
2952032	NM	school	3500090	30	ANIMAS	350009030019	20	ANIMAS MIDDLE	Public - Middle School	Regular School	No	Middle	05	06	2021	grade_4	0	0
2546343	NM	school	3501680	86	LOS LUNAS	350168000703	150	ANN PARISH ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4	75	75
2952483	NM	school	3501680	86	LOS LUNAS	350168000703	150	ANN PARISH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	53	53
2546125	NM	school	3501080	19	GADSDEN	350108000625	16	ANTHONY ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4	50	50
2952268	NM	school	3501080	19	GADSDEN	350108000625	16	ANTHONY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	43	43
2546126	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2952269	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	0	0
2546561	NM	school	3502400	25	SANTA ROSA	350240000324	20	ANTON CHICO MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4	0	0
2952696	NM	school	3502400	25	SANTA ROSA	350240000324	20	ANTON CHICO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2545698	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	60	60
2546096	NM	school	3500990	65	FARMINGTON	350099000281	17	APACHE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	80	80
2951855	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	41	41
2952240	NM	school	3500990	65	FARMINGTON	350099000281	17	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	75	75
2545699	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	48	48
2951856	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	32	32
2546625	NM	school	3502610	73	TRUTH OR CONS.	350261000591	16	ARREY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	13	13
2952762	NM	school	3502610	73	TRUTH OR CONS.	350261000591	16	ARREY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	14	14
2546269	NM	school	3501500	17	LAS CRUCES	350150001105	19	ARROWHEAD PARK MEDICAL ACADEMY	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2952411	NM	school	3501500	17	LAS CRUCES	350150001105	19	ARROWHEAD PARK MEDICAL ACADEMY	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2546600	NM	school	3502520	76	TAOS	350252000790	4	ARROYO DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	19	19
2952736	NM	school	3502520	76	TAOS	350252000790	4	ARROYO DEL NORTE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	22	22
2545700	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	55	55
2951857	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	51	51