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 desc 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
2541690	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947913	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541689	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
2947912	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public - High School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
2540894	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
2947132	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten	19	19
2541339	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947565	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2540893	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	0	0
2541043	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	30	30
2947131	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	0	0
2947276	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	35	35
2541585	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	pre_kindergarten	0	0
2947805	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site - Elementary School						2021	pre_kindergarten	0	0
2541042	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947275	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541177	NM	school	3501080	19	GADSDEN	350108001125	25	YUCCA HEIGHTS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	10	10
2947405	NM	school	3501080	19	GADSDEN	350108001125	25	YUCCA HEIGHTS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	pre_kindergarten	0	0
2540713	NM	school	3500030	46	ALAMOGORDO	350003000016	181	YUCCA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	35	35
2540915	NM	school	3500120	22	ARTESIA	350012000133	183	YUCCA ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	pre_kindergarten	0	0
2946955	NM	school	3500030	46	ALAMOGORDO	350003000016	181	YUCCA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	0	0
2947155	NM	school	3500120	22	ARTESIA	350012000133	183	YUCCA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	01	05	2021	pre_kindergarten	0	0
2540914	NM	school	3500120	22	ARTESIA	350012000672	1	YESO ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	pre_kindergarten	0	0
2947154	NM	school	3500120	22	ARTESIA	350012000672	1	YESO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	01	05	2021	pre_kindergarten	0	0
2541399	NM	school	3501740	31	LOVINGTON	350174000451	181	YARBRO ELEMENTARY	Public	Regular School	No	Elementary	04	05	2020	pre_kindergarten	0	0
2947623	NM	school	3501740	31	LOVINGTON	350174000451	181	YARBRO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	04	05	2021	pre_kindergarten	0	0
2541584	NM	school	3502370	71	SANTA FE	350237000553	176	WOOD-GORMLEY ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
2947804	NM	school	3502370	71	SANTA FE	350237000553	176	WOOD-GORMLEY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	pre_kindergarten	0	0
2541683	NM	school	3501560	68	WEST LAS VEGAS	350156000815	3	WLV FAMILY PARTNERSHIP	Public	Alternative School	No	High	07	12	2020	pre_kindergarten	0	0
2947906	NM	school	3501560	68	WEST LAS VEGAS	350156000815	3	WLV FAMILY PARTNERSHIP	Public - High School	Alternative School	No	High	07	12	2021	pre_kindergarten	0	0
2540892	NM	school	3500060	1	ALBUQUERQUE	350006000122	470	WILSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947130	NM	school	3500060	1	ALBUQUERQUE	350006000122	470	WILSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2540891	NM	school	3500060	1	ALBUQUERQUE	350006001087	782	WILLIAM W & JOSEPHINE DORN CHARTER COMMUNITY SCHOOL	Charter	Regular School	Yes	Elementary	KG	05	2020	pre_kindergarten	0	0
2947129	NM	school	3500060	1	ALBUQUERQUE	350006001087	782	WILLIAM W & JOSEPHINE DORN CHARTER COMMUNITY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	05	2021	pre_kindergarten	0	0
2541263	NM	school	3501260	33	HOBBS	350126000358	176	WILL ROGERS ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	66	66
2947490	NM	school	3501260	33	HOBBS	350126000358	176	WILL ROGERS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	39	39
2541622	NM	school	3502490	10	SPRINGER	350249000576	58	WILFERTH ELEMENTARY	Public	Regular School	No	Elementary	03	06	2020	pre_kindergarten	0	0
2947843	NM	school	3502490	10	SPRINGER	350249000576	58	WILFERTH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	03	06	2021	pre_kindergarten	0	0
2540890	NM	school	3500060	1	ALBUQUERQUE	350006000121	379	WHITTIER ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	35	35
2947128	NM	school	3500060	1	ALBUQUERQUE	350006000121	379	WHITTIER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	18	18
2541338	NM	school	3501500	17	LAS CRUCES	350150000397	177	WHITE SANDS ELEMENTARY	Public	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	7	7
2947564	NM	school	3501500	17	LAS CRUCES	350150000397	177	WHITE SANDS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten	10	10
2541545	NM	school	3502310	36	RUIDOSO	350231000530	160	WHITE MOUNTAIN ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0	0
2947766	NM	school	3502310	36	RUIDOSO	350231000530	160	WHITE MOUNTAIN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	03	05	2021	pre_kindergarten	0	0
2540889	NM	school	3500060	1	ALBUQUERQUE	350006000120	376	WHERRY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	0	0
2947127	NM	school	3500060	1	ALBUQUERQUE	350006000120	376	WHERRY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	9	9
2541452	NM	school	3500012	91	NM CORRECTIONS	350001200979	8	WESTERN NM CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	pre_kindergarten	0	0
2540888	NM	school	3500060	1	ALBUQUERQUE	350006000119	570	WEST MESA HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
2947126	NM	school	3500060	1	ALBUQUERQUE	350006000119	570	WEST MESA HIGH	Public - High School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
2541682	NM	school	3501560	68	WEST LAS VEGAS	350156000419	172	WEST LAS VEGAS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947905	NM	school	3501560	68	WEST LAS VEGAS	350156000419	172	WEST LAS VEGAS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541681	NM	school	3501560	68	WEST LAS VEGAS	350156000418	173	WEST LAS VEGAS HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
2947904	NM	school	3501560	68	WEST LAS VEGAS	350156000418	173	WEST LAS VEGAS HIGH SCHOOL	Public - High School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
2541680	NM	school		68	WEST LAS VEGAS		1	WEST LAS VEGAS HEAD START	Off-Site						2020	pre_kindergarten	10	10
2947903	NM	school		68	WEST LAS VEGAS		1	WEST LAS VEGAS HEAD START	Off-Site - Prekindergarten						2021	pre_kindergarten	2	2
2947902	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	pre_kindergarten	0	0
2540948	NM	school	3500210	61	BERNALILLO	350021000728	140	WD CARROLL ELEMENTARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	0	0
2947186	NM	school	3500210	61	BERNALILLO	350021000728	140	WD CARROLL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	0	0
2540887	NM	school	3500060	1	ALBUQUERQUE	350006000118	465	WASHINGTON MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947125	NM	school	3500060	1	ALBUQUERQUE	350006000118	465	WASHINGTON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541537	NM	school	3502250	4	ROSWELL	350225000525	175	WASHINGTON AVE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	18	18
2947760	NM	school	3502250	4	ROSWELL	350225000525	175	WASHINGTON AVE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	18	18
2541284	NM	school		63	JEMEZ VALLEY		5	WALATOWA HEAD START	Off-Site						2020	pre_kindergarten	2	2
2947510	NM	school		63	JEMEZ VALLEY		5	WALATOWA HEAD START	Off-Site - Prekindergarten						2021	pre_kindergarten	5	5
2541670	NM	school	3500158	552	WALATOWA CHARTER HIGH	350015800883	1	WALATOWA CHARTER HIGH	Charter	Regular School	Yes	High	09	12	2020	pre_kindergarten	0	0
2947893	NM	school	3500158	552	WALATOWA CHARTER HIGH	350015800883	1	WALATOWA CHARTER HIGH	Charter - High School	Regular School	Yes	High	09	12	2021	pre_kindergarten	0	0
2541669	NM	school	3502730	45	WAGON MOUND	350273000612	173	WAGON MOUND HIGH	Public	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
2947892	NM	school	3502730	45	WAGON MOUND	350273000612	173	WAGON MOUND HIGH	Public - High School	Regular School	No	High	07	12	2021	pre_kindergarten	0	0
2541668	NM	school	3502730	45	WAGON MOUND	350273000611	172	WAGON MOUND ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	5	5
2947891	NM	school	3502730	45	WAGON MOUND	350273000611	172	WAGON MOUND ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	7	7
2541041	NM	school	3500570	12	CLOVIS	350057001097	156	W D GATTIS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947274	NM	school	3500570	12	CLOVIS	350057001097	156	W D GATTIS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2540886	NM	school	3500060	1	ALBUQUERQUE	350006000966	575	VOLCANO VISTA HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
2947124	NM	school	3500060	1	ALBUQUERQUE	350006000966	575	VOLCANO VISTA HIGH	Public - High School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
2540924	NM	school	3500150	64	AZTEC	350015000801	2	VISTA NUEVA HIGH	Public	Alternative School	No	High	09	12	2020	pre_kindergarten	0	0
2947162	NM	school	3500150	64	AZTEC	350015000801	2	VISTA NUEVA HIGH	Public - High School	Alternative School	No	High	09	12	2021	pre_kindergarten	0	0
2541337	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947563	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541635	NM	school	3502520	76	TAOS	350252001021	12	VISTA GRANDE HIGH SCHOOL	Charter	Regular School	Yes	High	09	12	2020	pre_kindergarten	0	0
2947856	NM	school	3502520	76	TAOS	350252001021	12	VISTA GRANDE HIGH SCHOOL	Charter - High School	Regular School	Yes	High	09	12	2021	pre_kindergarten	0	0
2541511	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
2947735	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten	0	0
2540885	NM	school	3500060	1	ALBUQUERQUE	350006000856	840	VISION QUEST ALTERNATIVE MIDDLE	Public	Alternative School	No	Middle	06	08	2020	pre_kindergarten	0	0
2541108	NM	school		55	ESPANOLA		188	VICTORY CHRISTIAN	Private						2020	pre_kindergarten	0	0
2947338	NM	school		55	ESPANOLA		188	VICTORY CHRISTIAN	Private - Accredited Private School						2021	pre_kindergarten	0	0
2540884	NM	school	3500060	1	ALBUQUERQUE	350006000897	264	VENTANA RANCH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	34	34
2947123	NM	school	3500060	1	ALBUQUERQUE	350006000897	264	VENTANA RANCH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	35	35
2541107	NM	school		55	ESPANOLA		6	VELARDE HEADSTART	Off-Site						2020	pre_kindergarten	1	1
2541106	NM	school	3500900	55	ESPANOLA	350090000277	169	VELARDE ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
2947337	NM	school	3500900	55	ESPANOLA	350090000277	169	VELARDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	pre_kindergarten	0	0
2541667	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
2947890	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	pre_kindergarten	0	0
2541666	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	5	5
2947889	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	6	6
2541114	NM	school	3500930	80	ESTANCIA	350093000613	185	VANSTONE ELEMENTARY	Public	Regular School	No	Elementary	KG	KG	2020	pre_kindergarten	0	0
2947343	NM	school	3500930	80	ESTANCIA	350093000613	185	VANSTONE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	KG	2021	pre_kindergarten	0	0
2540883	NM	school	3500060	1	ALBUQUERQUE	350006000117	460	VAN BUREN MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
2947122	NM	school	3500060	1	ALBUQUERQUE	350006000117	460	VAN BUREN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0
2541336	NM	school	3501500	17	LAS CRUCES	350150000395	166	VALLEY VIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	58	58
2541536	NM	school	3502250	4	ROSWELL	350225000524	161	VALLEY VIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	19	19
2947562	NM	school	3501500	17	LAS CRUCES	350150000395	166	VALLEY VIEW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	56	56