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 (school_nces_id > :p3 or (school_nces_id = :p3 and rowid > :p2)) order by school_nces_id, 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	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
2541704	NM	school	3500030	46	ALAMOGORDO	350003000798	3	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2947928	NM	school	3500030	46	ALAMOGORDO	350003000798	3	MOUNTAIN VIEW MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541693	NM	school	3500030	46	ALAMOGORDO	350003000799	4	ACADEMY DEL SOL ALT.	Public	Alternative School	No	High	10	12	2020	kindergarten_full_day	0	0
2947918	NM	school	3500030	46	ALAMOGORDO	350003000799	4	ACADEMY DEL SOL ALT.	Public - High School	Alternative School	No	High	10	12	2021	kindergarten_full_day	0	0
2947931	NM	school	3500030	46	ALAMOGORDO	350003001158	182	STEPPING STONES PRESCHOOL	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_full_day	0	0
2541709	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	76	76
2947934	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	43	43
2541796	NM	school	3500060	1	ALBUQUERQUE	350006000019	405	JOHN ADAMS MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948019	NM	school	3500060	1	ALBUQUERQUE	350006000019	405	JOHN ADAMS MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541712	NM	school	3500060	1	ALBUQUERQUE	350006000020	206	ADOBE ACRES ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	61	61
2947937	NM	school	3500060	1	ALBUQUERQUE	350006000020	206	ADOBE ACRES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	52	52
2541713	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	36	36
2947938	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	26	26
2541714	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	65	65
2947939	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	60	60
2541715	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2947940	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541717	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	52	52
2947942	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	30	30
2541718	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	62	62
2947943	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	53	53
2541719	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	38	38
2947944	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	40	40
2541720	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	57	57
2947945	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	43	43
2541721	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	36	36
2947946	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	27	27
2541723	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	77	77
2947948	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	63	63
2541724	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	52	52
2947949	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	38	38
2541725	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	42	42
2947950	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	46	46
2541726	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	50	50
2947951	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	34	34
2541729	NM	school	3500060	1	ALBUQUERQUE	350006000035	339	CARLOS REY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	87	87
2947954	NM	school	3500060	1	ALBUQUERQUE	350006000035	339	CARLOS REY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	82	82
2541731	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	81	81
2947956	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	70	70
2541732	NM	school	3500060	1	ALBUQUERQUE	350006000037	236	CHELWOOD ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	98	98
2947957	NM	school	3500060	1	ALBUQUERQUE	350006000037	236	CHELWOOD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	48	48
2541735	NM	school	3500060	1	ALBUQUERQUE	350006000038	580	CIBOLA HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2947959	NM	school	3500060	1	ALBUQUERQUE	350006000038	580	CIBOLA HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541845	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	92	92
2948068	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	74	74
2541738	NM	school	3500060	1	ALBUQUERQUE	350006000040	237	COCHITI ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	33	33
2947962	NM	school	3500060	1	ALBUQUERQUE	350006000040	237	COCHITI ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	36	36
2541740	NM	school	3500060	1	ALBUQUERQUE	350006000041	240	COLLET PARK ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	66	66
2947964	NM	school	3500060	1	ALBUQUERQUE	350006000041	240	COLLET PARK ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	48	48
2541741	NM	school	3500060	1	ALBUQUERQUE	350006000042	241	COMANCHE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	55	55
2947965	NM	school	3500060	1	ALBUQUERQUE	350006000042	241	COMANCHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	42	42
2541807	NM	school	3500060	1	ALBUQUERQUE	350006000043	373	LEW WALLACE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	35	35
2948030	NM	school	3500060	1	ALBUQUERQUE	350006000043	373	LEW WALLACE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	25	25
2541749	NM	school	3500060	1	ALBUQUERQUE	350006000044	514	DEL NORTE HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2947972	NM	school	3500060	1	ALBUQUERQUE	350006000044	514	DEL NORTE HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541754	NM	school	3500060	1	ALBUQUERQUE	350006000045	244	DOLORES GONZALES ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	56	56
2947977	NM	school	3500060	1	ALBUQUERQUE	350006000045	244	DOLORES GONZALES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	40	40
2541813	NM	school	3500060	1	ALBUQUERQUE	350006000046	303	MACARTHUR ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	32	32
2948036	NM	school	3500060	1	ALBUQUERQUE	350006000046	303	MACARTHUR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	23	23
2541756	NM	school	3500060	1	ALBUQUERQUE	350006000047	249	DURANES ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	20	20
2947979	NM	school	3500060	1	ALBUQUERQUE	350006000047	249	DURANES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	12	12
2541759	NM	school	3500060	1	ALBUQUERQUE	350006000048	252	EAST SAN JOSE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	60	60
2947982	NM	school	3500060	1	ALBUQUERQUE	350006000048	252	EAST SAN JOSE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	41	41
2541763	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2947986	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541765	NM	school	3500060	1	ALBUQUERQUE	350006000050	515	ELDORADO HIGH	Public	Regular School	No	Other	PK	12	2020	kindergarten_full_day	0	0
2947988	NM	school	3500060	1	ALBUQUERQUE	350006000050	515	ELDORADO HIGH	Public - High School	Regular School	No	Other	PK	12	2021	kindergarten_full_day	0	0
2541766	NM	school	3500060	1	ALBUQUERQUE	350006000051	255	EMERSON ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	77	77
2947989	NM	school	3500060	1	ALBUQUERQUE	350006000051	255	EMERSON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	58	58
2541767	NM	school	3500060	1	ALBUQUERQUE	350006000052	450	ERNIE PYLE MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2947990	NM	school	3500060	1	ALBUQUERQUE	350006000052	450	ERNIE PYLE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541793	NM	school	3500060	1	ALBUQUERQUE	350006000053	258	JANET KAHN FINE ARTS ACADEMY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	67	67
2948016	NM	school	3500060	1	ALBUQUERQUE	350006000053	258	JANET KAHN FINE ARTS ACADEMY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	52	52
2541768	NM	school	3500060	1	ALBUQUERQUE	350006000054	261	EUGENE FIELD ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	33	33
2947991	NM	school	3500060	1	ALBUQUERQUE	350006000054	261	EUGENE FIELD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	20	20
2541769	NM	school	3500060	1	ALBUQUERQUE	350006000055	596	FREEDOM HIGH	Public	Alternative School	No	High	09	12	2020	kindergarten_full_day	0	0
2947992	NM	school	3500060	1	ALBUQUERQUE	350006000055	596	FREEDOM HIGH	Public - High School	Alternative School	No	High	09	12	2021	kindergarten_full_day	0	0
2541770	NM	school	3500060	1	ALBUQUERQUE	350006000056	410	GARFIELD MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2947993	NM	school	3500060	1	ALBUQUERQUE	350006000056	410	GARFIELD MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541775	NM	school	3500060	1	ALBUQUERQUE	350006000057	230	GOV BENT ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	69	69
2947998	NM	school	3500060	1	ALBUQUERQUE	350006000057	230	GOV BENT ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	55	55
2541776	NM	school	3500060	1	ALBUQUERQUE	350006000058	413	GRANT MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2947999	NM	school	3500060	1	ALBUQUERQUE	350006000058	413	GRANT MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541777	NM	school	3500060	1	ALBUQUERQUE	350006000059	267	GRIEGOS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	48	48
2948000	NM	school	3500060	1	ALBUQUERQUE	350006000059	267	GRIEGOS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	40	40
2541778	NM	school	3500060	1	ALBUQUERQUE	350006000060	415	HARRISON MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948001	NM	school	3500060	1	ALBUQUERQUE	350006000060	415	HARRISON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541779	NM	school	3500060	1	ALBUQUERQUE	350006000061	270	HAWTHORNE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	60	60
2948002	NM	school	3500060	1	ALBUQUERQUE	350006000061	270	HAWTHORNE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	57	57
2541780	NM	school	3500060	1	ALBUQUERQUE	350006000062	416	HAYES MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948003	NM	school	3500060	1	ALBUQUERQUE	350006000062	416	HAYES MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541784	NM	school	3500060	1	ALBUQUERQUE	350006000063	520	HIGHLAND HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948007	NM	school	3500060	1	ALBUQUERQUE	350006000063	520	HIGHLAND HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541785	NM	school	3500060	1	ALBUQUERQUE	350006000064	273	HODGIN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	74	74
2948008	NM	school	3500060	1	ALBUQUERQUE	350006000064	273	HODGIN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	60	60
2541801	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948024	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541787	NM	school	3500060	1	ALBUQUERQUE	350006000066	418	HOOVER MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948010	NM	school	3500060	1	ALBUQUERQUE	350006000066	418	HOOVER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541789	NM	school	3500060	1	ALBUQUERQUE	350006000067	276	INEZ ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	48	48
2948012	NM	school	3500060	1	ALBUQUERQUE	350006000067	276	INEZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	47	47