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_nces_id 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
2952779	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	6	6
2952780	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_4	0	0
2952620	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	85	85
2952618	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	125	125
2952613	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2952615	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	109	109
2952609	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	152	152
2952617	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2952606	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	116	116
2952607	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2952621	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2952611	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public - High School	Alternative School	No	High	09	12	2021	grade_4	0	0
2952625	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	132	132
2952622	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2952614	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	104	104
2952624	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public - Special Education	Special Education School	No	Prekindergarten	PK	PK	2021	grade_4	0	0
2952619	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public - High School	Alternative School	No	High	06	12	2021	grade_4	0	0
2952605	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2952604	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	116	116
2952623	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	99	99
2952612	NM	school	3500010	83	RIO RANCHO	350001001159	25	JOE HARRIS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	56	56
2952608	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	107	107
2952401	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported - State Supported	Alternative School	No	High	09	12	2021	grade_4	0	0
2952403	NM	school	3500011	99	JUVENILE JUSTICE	350001100985	3	FOOTHILL HIGH SCHOOL	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_4	0	0
2952402	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_4	0	0
2952559	NM	school	3500012	91	NM CORRECTIONS	350001200974	6	LAE COUNTY CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952558	NM	school	3500012	91	NM CORRECTIONS	350001200976	7	GUADALUPE COUNTY CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952563	NM	school	3500012	91	NM CORRECTIONS	350001200977	1	PENITENTIARY OF NM-SANTA FE	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952564	NM	school	3500012	91	NM CORRECTIONS	350001200982	2	SOUTHERN NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952557	NM	school	3500012	91	NM CORRECTIONS	350001200986	4	CENTRAL NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952561	NM	school	3500012	91	NM CORRECTIONS	350001200987	3	NORTHWESTERN NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952565	NM	school	3500012	91	NM CORRECTIONS	350001201046	9	SPRINGER CORRECTIONAL FACILITY	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952560	NM	school	3500012	91	NM CORRECTIONS	350001201049	10	NORTHEASTERN NM CORRECTIONAL FACILITY	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952562	NM	school	3500012	91	NM CORRECTIONS	350001201152	11	OTERO COUNTY PRISON	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_4	0	0
2952567	NM	school	3500013	94	NM SCHOOL FOR THE BLIND AND VISUALLY IMP	350001300980	15	NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED	State Supported - State Supported	Special Education School	No	Other	PK	12	2021	grade_4	4	4
2952568	NM	school	3500014	93	NM SCHOOL FOR THE DEAF	350001400972	150	NM SCHOOL FOR THE DEAF	State Supported - State Supported	Special Education School	No	Other	PK	12	2021	grade_4	12	12
2952704	NM	school	3500015	97	SEQUOYAH	350001500971	867	SEQUOYAH	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_4	0	0
2952778	NM	school	3500016	95	UNM MIMBRES SCHOOL	350001600983	994	UNM MIMBRES SCHOOL	State Supported - State Supported	Alternative School	No	Other	PK	12	2021	grade_4	1	1
2951831	NM	school	3500030	46	ALAMOGORDO	350003000001	15	ALAMOGORDO HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2951832	NM	school	3500030	46	ALAMOGORDO	350003000002	28	BUENA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	28	28
2951833	NM	school	3500030	46	ALAMOGORDO	350003000003	33	CHAPARRAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951844	NM	school	3500030	46	ALAMOGORDO	350003000004	56	SUNSET HILLS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	72	72
2951835	NM	school	3500030	46	ALAMOGORDO	350003000005	57	HIGH ROLLS MOUNTAIN PARK ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	4	4
2951836	NM	school	3500030	46	ALAMOGORDO	350003000006	58	HOLLOMAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	44	44
2951837	NM	school	3500030	46	ALAMOGORDO	350003000007	37	HOLLOMAN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951838	NM	school	3500030	46	ALAMOGORDO	350003000008	72	LA LUZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	34	34
2951841	NM	school	3500030	46	ALAMOGORDO	350003000010	114	NORTH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	35	35
2951834	NM	school	3500030	46	ALAMOGORDO	350003000012	144	DESERT STAR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	92	92
2951842	NM	school	3500030	46	ALAMOGORDO	350003000013	150	SIERRA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	55	55
2951845	NM	school	3500030	46	ALAMOGORDO	350003000016	181	YUCCA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	40	40
2951840	NM	school	3500030	46	ALAMOGORDO	350003000798	3	MOUNTAIN VIEW MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	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
2951843	NM	school	3500030	46	ALAMOGORDO	350003001158	182	STEPPING STONES PRESCHOOL	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	0	0
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
2951931	NM	school	3500060	1	ALBUQUERQUE	350006000019	405	JOHN ADAMS MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
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
2951850	NM	school	3500060	1	ALBUQUERQUE	350006000021	207	ALAMEDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	24	24
2951851	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	58	58
2951852	NM	school	3500060	1	ALBUQUERQUE	350006000024	590	ALBUQUERQUE HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2951854	NM	school	3500060	1	ALBUQUERQUE	350006000025	213	ALVARADO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	48	48
2951855	NM	school	3500060	1	ALBUQUERQUE	350006000026	214	APACHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	41	41
2951856	NM	school	3500060	1	ALBUQUERQUE	350006000027	215	ARMIJO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	32	32
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
2951858	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	36	36
2951860	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	64	64
2951861	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	52	52
2951862	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	49	49
2951863	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	41	41
2951866	NM	school	3500060	1	ALBUQUERQUE	350006000035	339	CARLOS REY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	94	94
2951868	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	105	105
2951869	NM	school	3500060	1	ALBUQUERQUE	350006000037	236	CHELWOOD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	58	58
2951871	NM	school	3500060	1	ALBUQUERQUE	350006000038	580	CIBOLA HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2951980	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	83	83
2951874	NM	school	3500060	1	ALBUQUERQUE	350006000040	237	COCHITI ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	37	37
2951876	NM	school	3500060	1	ALBUQUERQUE	350006000041	240	COLLET PARK ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	54	54
2951877	NM	school	3500060	1	ALBUQUERQUE	350006000042	241	COMANCHE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	51	51
2951942	NM	school	3500060	1	ALBUQUERQUE	350006000043	373	LEW WALLACE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	32	32
2951884	NM	school	3500060	1	ALBUQUERQUE	350006000044	514	DEL NORTE HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2951889	NM	school	3500060	1	ALBUQUERQUE	350006000045	244	DOLORES GONZALES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	50	50
2951948	NM	school	3500060	1	ALBUQUERQUE	350006000046	303	MACARTHUR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	34	34
2951891	NM	school	3500060	1	ALBUQUERQUE	350006000047	249	DURANES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_4	27	27
2951894	NM	school	3500060	1	ALBUQUERQUE	350006000048	252	EAST SAN JOSE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	57	57
2951898	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951900	NM	school	3500060	1	ALBUQUERQUE	350006000050	515	ELDORADO HIGH	Public - High School	Regular School	No	Other	PK	12	2021	grade_4	0	0
2951901	NM	school	3500060	1	ALBUQUERQUE	350006000051	255	EMERSON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	61	61
2951902	NM	school	3500060	1	ALBUQUERQUE	350006000052	450	ERNIE PYLE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951928	NM	school	3500060	1	ALBUQUERQUE	350006000053	258	JANET KAHN FINE ARTS ACADEMY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	57	57
2951903	NM	school	3500060	1	ALBUQUERQUE	350006000054	261	EUGENE FIELD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	22	22
2951904	NM	school	3500060	1	ALBUQUERQUE	350006000055	596	FREEDOM HIGH	Public - High School	Alternative School	No	High	09	12	2021	grade_4	0	0
2951905	NM	school	3500060	1	ALBUQUERQUE	350006000056	410	GARFIELD MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951910	NM	school	3500060	1	ALBUQUERQUE	350006000057	230	GOV BENT ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	62	62
2951911	NM	school	3500060	1	ALBUQUERQUE	350006000058	413	GRANT MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951912	NM	school	3500060	1	ALBUQUERQUE	350006000059	267	GRIEGOS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_4	51	51
2951913	NM	school	3500060	1	ALBUQUERQUE	350006000060	415	HARRISON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951914	NM	school	3500060	1	ALBUQUERQUE	350006000061	270	HAWTHORNE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	50	50
2951915	NM	school	3500060	1	ALBUQUERQUE	350006000062	416	HAYES MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951919	NM	school	3500060	1	ALBUQUERQUE	350006000063	520	HIGHLAND HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_4	0	0
2951920	NM	school	3500060	1	ALBUQUERQUE	350006000064	273	HODGIN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	52	52
2951936	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951922	NM	school	3500060	1	ALBUQUERQUE	350006000066	418	HOOVER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_4	0	0
2951924	NM	school	3500060	1	ALBUQUERQUE	350006000067	276	INEZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4	52	52