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 district_state_id 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
2550240	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported	Alternative School	No	High	09	12	2020	grade_8	0	0
2550241	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported	Alternative School	No	High	06	12	2020	grade_8	1	1
2550242	NM	school	3500011	99	JUVENILE JUSTICE	350001100985	3	FOOTHILL HIGH SCHOOL	State Supported	Alternative School	No	High	06	12	2020	grade_8	1	1
2956313	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported - State Supported	Alternative School	No	High	09	12	2021	grade_8	1	1
2956314	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_8	0	0
2956315	NM	school	3500011	99	JUVENILE JUSTICE	350001100985	3	FOOTHILL HIGH SCHOOL	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_8	0	0
2956316	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_8	0	0
2550549	NM	school	3500015	97	SEQUOYAH	350001500971	867	SEQUOYAH	State Supported	Alternative School	No	High	06	12	2020	grade_8	4	4
2956616	NM	school	3500015	97	SEQUOYAH	350001500971	867	SEQUOYAH	State Supported - State Supported	Alternative School	No	High	06	12	2021	grade_8	2	2
2549963	NM	school	3500016	95	CHILDRENS PSYC	350001600983	994	CHILDRENS PSYCHIATRY	State Supported	Alternative School	No	Other	PK	12	2020	grade_8	5	5
2956690	NM	school	3500016	95	UNM MIMBRES SCHOOL	350001600983	994	UNM MIMBRES SCHOOL	State Supported - State Supported	Alternative School	No	Other	PK	12	2021	grade_8	7	7
2550409	NM	school	3500013	94	NM SCHOOL FOR THE BLIND AND VISUALLY IMP	350001300980	15	NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED	State Supported	Special Education School	No	Other	PK	12	2020	grade_8	2	2
2956479	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_8	2	2
2550410	NM	school	3500014	93	NM SCHOOL FOR THE DEAF	350001400972	150	NM SCHOOL FOR THE DEAF	State Supported	Special Education School	No	Other	PK	12	2020	grade_8	9	9
2956480	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_8	13	13
2550398	NM	school	3500012	91	NM CORRECTIONS	350001200986	4	CENTRAL NM CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550399	NM	school	3500012	91	NM CORRECTIONS	350001200974	6	LAE COUNTY CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550400	NM	school	3500012	91	NM CORRECTIONS	350001201049	10	NORTHEASTERN NM CORRECTIONAL FACILITY	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550401	NM	school	3500012	91	NM CORRECTIONS	350001200987	3	NORTHWESTERN NM CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550402	NM	school	3500012	91	NM CORRECTIONS	350001201152	11	OTERO COUNTY PRISON	State Supported	Alternative School	No	Secondary	09	11	2020	grade_8	0	0
2550403	NM	school	3500012	91	NM CORRECTIONS	350001200977	1	PENITENTIARY OF NM-SANTA FE	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550404	NM	school	3500012	91	NM CORRECTIONS	350001200970	5	ROSWELL CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550405	NM	school	3500012	91	NM CORRECTIONS	350001200982	2	SOUTHERN NM CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550406	NM	school	3500012	91	NM CORRECTIONS	350001201046	9	SPRINGER CORRECTIONAL FACILITY	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2550407	NM	school	3500012	91	NM CORRECTIONS	350001200979	8	WESTERN NM CORRECTIONS	State Supported	Alternative School	No	High	08	12	2020	grade_8	0	0
2956469	NM	school	3500012	91	NM CORRECTIONS	350001200986	4	CENTRAL NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956470	NM	school	3500012	91	NM CORRECTIONS	350001200976	7	GUADALUPE COUNTY CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956471	NM	school	3500012	91	NM CORRECTIONS	350001200974	6	LAE COUNTY CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956472	NM	school	3500012	91	NM CORRECTIONS	350001201049	10	NORTHEASTERN NM CORRECTIONAL FACILITY	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956473	NM	school	3500012	91	NM CORRECTIONS	350001200987	3	NORTHWESTERN NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956474	NM	school	3500012	91	NM CORRECTIONS	350001201152	11	OTERO COUNTY PRISON	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956475	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_8	0	0
2956476	NM	school	3500012	91	NM CORRECTIONS	350001200982	2	SOUTHERN NM CORRECTIONS	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2956477	NM	school	3500012	91	NM CORRECTIONS	350001201046	9	SPRINGER CORRECTIONAL FACILITY	State Supported - State Supported	Alternative School	No	High	08	12	2021	grade_8	0	0
2550440	NM	school		9	RATON		998	HOMEBOUND	Off-Site						2020	grade_8	0	0
2550441	NM	school	3502190	9	RATON	350219000499	80	LONGFELLOW ELEMENTARY	Public	Regular School	No	Elementary	PK	02	2020	grade_8	0	0
2550442	NM	school	3502190	9	RATON	350219000500	136	RATON HIGH	Public	Regular School	No	High	07	12	2020	grade_8	66	66
2550443	NM	school	3502190	9	RATON	350219000501	135	RATON INTERMEDIATE	Public	Regular School	No	Elementary	03	06	2020	grade_8	0	0
2956509	NM	school	3502190	9	RATON	350219000499	80	LONGFELLOW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	grade_8	0	0
2956510	NM	school	3502190	9	RATON	350219000500	136	RATON HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_8	57	57
2956511	NM	school	3502190	9	RATON	350219000501	135	RATON INTERMEDIATE	Public - Middle School	Regular School	No	Elementary	03	06	2021	grade_8	0	0
2550639	NM	school		89	ZUNI		998	HOMEBOUND	Off-Site						2020	grade_8	0	0
2550640	NM	school		89	ZUNI		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_8	0	0
2550641	NM	school		89	ZUNI		997	MISC PRIVATE	Private						2020	grade_8	9	9
2550642	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2550643	NM	school	3502800	89	ZUNI	350280000677	192	TWIN BUTTES CYBER ACADEMY	Public	Regular School	No	High	07	12	2020	grade_8	0	0
2550644	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_8	0	0
2550645	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	83	83
2956709	NM	school		89	ZUNI		998	HOMEBOUND	Off-Site - Central Office						2021	grade_8	0	0
2956710	NM	school		89	ZUNI		992	MISC PRESCHOOL PROGRAM	Off-Site - Prekindergarten						2021	grade_8	0	0
2956711	NM	school		89	ZUNI		997	MISC PRIVATE	Private - Non-Accredited Private School						2021	grade_8	5	5
2956712	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_8	0	0
2956713	NM	school	3502800	89	ZUNI	350280000677	192	TWIN BUTTES CYBER ACADEMY	Public - High School	Regular School	No	High	07	12	2021	grade_8	0	0
2956714	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_8	0	0
2956715	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	105	105
2550173	NM	school	3501170	88	GRANTS	350117000327	915	BLUEWATER ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
2550174	NM	school	3501170	88	GRANTS	350117000328	38	CUBERO ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
2550175	NM	school	3501170	88	GRANTS	350117001153	60	GCCS EARLY COLLEGE HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_8	0	0
2550176	NM	school		88	GRANTS		4	GRANTS HEAD START	Off-Site						2020	grade_8	0	0
2550177	NM	school	3501170	88	GRANTS	350117000329	55	GRANTS HIGH	Public	Regular School	No	High	09	12	2020	grade_8	0	0
2550178	NM	school		88	GRANTS		998	HOMEBOUND	Off-Site						2020	grade_8	0	0
2550179	NM	school	3501170	88	GRANTS	350117000330	57	LAGUNA-ACOMA HIGH	Public	Regular School	No	High	09	12	2020	grade_8	0	0
2550180	NM	school	3501170	88	GRANTS	350117000665	58	LAGUNA-ACOMA MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	24	24
2550181	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	213	213
2550182	NM	school	3501170	88	GRANTS	350117000332	99	MESA VIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2550183	NM	school	3501170	88	GRANTS	350117000333	104	MILAN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2550184	NM	school		88	GRANTS		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_8	0	0
2550185	NM	school		88	GRANTS		997	MISC PRIVATE	Private						2020	grade_8	7	7
2550186	NM	school	3501170	88	GRANTS	350117000334	106	MOUNT TAYLOR ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2550187	NM	school	3501170	88	GRANTS	350117000336	152	SAN RAFAEL ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
2550188	NM	school	3501170	88	GRANTS	350117000337	155	SEBOYETA ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
2956246	NM	school	3501170	88	GRANTS	350117000327	915	BLUEWATER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
2956247	NM	school	3501170	88	GRANTS	350117000328	38	CUBERO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
2956248	NM	school	3501170	88	GRANTS	350117001153	60	GCCS EARLY COLLEGE HIGH SCHOOL	Public - High School	Regular School	No	High	09	12	2021	grade_8	0	0
2956249	NM	school		88	GRANTS		4	GRANTS HEAD START	Off-Site - Prekindergarten						2021	grade_8	0	0
2956250	NM	school	3501170	88	GRANTS	350117000329	55	GRANTS HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_8	0	0
2956251	NM	school		88	GRANTS		998	HOMEBOUND	Off-Site - Central Office						2021	grade_8	0	0
2956252	NM	school	3501170	88	GRANTS	350117000330	57	LAGUNA-ACOMA HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_8	0	0
2956253	NM	school	3501170	88	GRANTS	350117000665	58	LAGUNA-ACOMA MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	31	31
2956254	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	212	212
2956255	NM	school	3501170	88	GRANTS	350117000332	99	MESA VIEW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_8	0	0
2956256	NM	school	3501170	88	GRANTS	350117000333	104	MILAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_8	0	0
2956257	NM	school		88	GRANTS		992	MISC PRESCHOOL PROGRAM	Off-Site - Prekindergarten						2021	grade_8	0	0
2956258	NM	school		88	GRANTS		997	MISC PRIVATE	Private - Non-Accredited Private School						2021	grade_8	5	5
2956259	NM	school	3501170	88	GRANTS	350117000334	106	MOUNT TAYLOR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_8	0	0
2956260	NM	school	3501170	88	GRANTS	350117000336	152	SAN RAFAEL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
2956261	NM	school	3501170	88	GRANTS	350117000337	155	SEBOYETA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
2549880	NM	school	3500180	87	BELEN	350018000140	26	BELEN HIGH	Public	Regular School	No	High	09	12	2020	grade_8	0	0
2549881	NM	school	3500180	87	BELEN	350018000848	1	BELEN INFINITY HIGH	Public	Alternative School	No	High	09	12	2020	grade_8	0	0
2549882	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	281	281
2549883	NM	school	3500180	87	BELEN	350018000142	34	CENTRAL ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_8	0	0
2549884	NM	school	3500180	87	BELEN	350018000143	80	DENNIS CHAVEZ ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2549885	NM	school	3500180	87	BELEN	350018000144	66	GIL SANCHEZ ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2549886	NM	school	3500180	87	BELEN	350018000145	68	JARAMILLO ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	grade_8	0	0
2549887	NM	school	3500180	87	BELEN	350018030003	38	LA MERCED ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2549888	NM	school	3500180	87	BELEN	350018000849	3	LA PROMESA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2549889	NM	school	3500180	87	BELEN	350018000146	45	RIO GRANDE ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2549890	NM	school	3500180	87	BELEN	350018000867	6	THE FAMILY SCHOOL	Public	Alternative School	No	Elementary	01	08	2020	grade_8	26	26
2955965	NM	school	3500180	87	BELEN	350018000140	26	BELEN HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_8	0	0
2955966	NM	school	3500180	87	BELEN	350018000848	1	BELEN INFINITY HIGH	Public - High School	Alternative School	No	High	09	12	2021	grade_8	0	0
2955967	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	281	281