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 "state" = :p0 and "year" = :p1 order by school_state_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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	hispanic_int	total_int
2947143	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	pre_kindergarten								11		11
2947464	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	pre_kindergarten								3		3
2947514	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	pre_kindergarten								0		0
2947823	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	pre_kindergarten								0		0
2947875	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	pre_kindergarten								1		1
2947902	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	pre_kindergarten								0		0
2948121	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	kindergarten_full_day								2		2
2948442	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	kindergarten_full_day								0		0
2948492	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	kindergarten_full_day								0		0
2948801	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	kindergarten_full_day								0		0
2948853	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	kindergarten_full_day								0		0
2948880	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	kindergarten_full_day								0		0
2949099	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_1								0		0
2949420	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_1								0		0
2949470	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_1								0		0
2949779	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_1								0		0
2949831	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_1								0		0
2949858	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_1								0		0
2950077	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_2								0		0
2950398	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_2								0		0
2950448	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_2								0		0
2950757	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_2								0		0
2950809	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_2								0		0
2950836	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_2								0		0
2951055	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_3								0		0
2951376	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_3								0		0
2951426	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_3								0		0
2951735	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_3								0		0
2951787	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_3								0		0
2951814	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_3								0		0
2952033	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_4								0		0
2952354	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_4								0		0
2952404	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_4								0		0
2952713	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_4								1		1
2952765	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_4								0		0
2952792	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_4								0		0
2953011	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_5								0		0
2953332	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_5								0		0
2953382	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_5								0		0
2953691	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_5								0		0
2953743	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_5								0		0
2953770	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_5								1		1
2953989	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954310	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954360	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954669	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954721	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954748	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_6								0		0
2954967	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955288	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955338	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955647	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955699	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955726	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_7								0		0
2955945	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_8								0		0
2956266	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						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
2956625	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_8								0		0
2956677	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_8								0		0
2956704	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_8								0		0
2956923	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_9								0		0
2957244	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_9								0		0
2957294	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_9								1		1
2957603	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_9								0		0
2957655	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_9								0		0
2957682	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_9								0		0
2957901	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958222	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958272	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958581	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958633	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958660	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_10								0		0
2958879	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959200	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959250	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959559	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959611	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959638	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_11								0		0
2959857	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960178	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960228	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960537	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960589	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960616	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	grade_12								0		0
2960835	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	8	*	*	*	*	13	8	13
2961156	NM	school		18	HATCH		0	HATCH VALLEY DIST OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	*	*	*	*	*	3		3
2961206	NM	school		99	JUVENILE JUSTICE		0	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	*	*	*	*	*	1		1
2961515	NM	school		23	SILVER CITY		0	SILVER CITY DIST OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	*	*	*	*	*	1		1
2961567	NM	school		73	TRUTH OR CONS.		0	T OR C DISTRICT OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	*	*	*	*	*	1		1
2961594	NM	school		68	WEST LAS VEGAS		0	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office						2021	pk_12_total	*	*	*	*	*	*	*	1		1
2946936	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	pre_kindergarten								0		0
2946937	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter - High School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten								0		0
2946938	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter - High School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten								0		0
2946939	NM	school	3500185	579	ACES TECHNICAL CHARTER SCHOOL	350018501150	1	ACES TECHNICAL HIGH SCHOOL	Charter - High School	Regular School	Yes	Middle	06	06	2021	pre_kindergarten								0		0
2947133	NM	school	3500134	528	ALBUQUERQUE BILINGUAL ACADEMY	350013400923	1	ALBUQUERQUE BILINGUAL ACADEMY	Charter - Elementary School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten								17		17
2947134	NM	school	3500181	574	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	350018101134	1	ALBUQUERQUE COLLEGIATE CHARTER SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	03	2021	pre_kindergarten								0		0
2947135	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	pre_kindergarten								0		0
2947136	NM	school	3500138	532	ALDO LEOPOLD CHARTER	350013800938	1	ALDO LEOPOLD CHARTER	Charter - High School	Regular School	Yes	High	06	12	2021	pre_kindergarten								0		0
2947137	NM	school	3500116	511	ALMA D'ARTE CHARTER	350011600900	1	ALMA D'ARTE CHARTER	Charter - High School	Regular School	Yes	High	09	12	2021	pre_kindergarten								0		0
2947138	NM	school	3500178	575	ALTURA PREPARATORY SCHOOL	350017801138	1	ALTURA PREPARATORY SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten								0		0
2947139	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	pre_kindergarten								0		0