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 order by school_state_id limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school	school_state_type	year	grade	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	hispanic_int	total_int
2540905	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	pre_kindergarten								3		3
2541238	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	pre_kindergarten								5		5
2541316	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	pre_kindergarten								23		23
2541360	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	pre_kindergarten								0		0
2541472	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	pre_kindergarten								1		1
2541900	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	kindergarten_full_day								0		0
2542233	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	kindergarten_full_day								0		0
2542311	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	kindergarten_full_day								0		0
2542355	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	kindergarten_full_day								0		0
2542467	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	kindergarten_full_day								0		0
2542895	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_1								0		0
2543228	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_1								0		0
2543306	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_1								0		0
2543350	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_1								0		0
2543462	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_1								0		0
2543890	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_2								0		0
2544223	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_2								0		0
2544301	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_2								0		0
2544345	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_2								0		0
2544457	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_2								0		0
2544885	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_3								0		0
2545218	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_3								0		0
2545296	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_3								0		0
2545340	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_3								0		0
2545452	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_3								0		0
2545880	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_4								0		0
2546213	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_4								0		0
2546291	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_4								0		0
2546335	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_4								0		0
2546447	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_4								0		0
2546875	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_5								0		0
2547208	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_5								0		0
2547286	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_5								0		0
2547330	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_5								0		0
2547442	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_5								0		0
2547870	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_6								0		0
2548203	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_6								0		0
2548281	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_6								0		0
2548325	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_6								0		0
2548437	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_6								0		0
2548865	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_7								0		0
2549198	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_7								0		0
2549276	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_7								0		0
2549320	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_7								0		0
2549432	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_7								0		0
2549860	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_8								0		0
2550193	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_8								0		0
2550271	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_8								0		0
2550315	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_8								0		0
2550427	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_8								0		0
2550855	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_9								0		0
2551188	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_9								0		0
2551266	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_9								0		0
2551310	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_9								1		1
2551422	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_9								0		0
2551850	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_10								0		0
2552183	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_10								0		0
2552261	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_10								0		0
2552305	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_10								0		0
2552417	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_10								0		0
2552845	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_11								0		0
2553178	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_11								0		0
2553256	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_11								0		0
2553300	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_11								0		0
2553412	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_11								0		0
2553840	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	grade_12								0		0
2554173	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	grade_12								0		0
2554251	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	grade_12								0		0
2554295	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	grade_12								0		0
2554407	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	grade_12								0		0
2554835	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office	2020	pk_12_total	*	*	*	*	*	*	*	3		3
2555168	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office	2020	pk_12_total	*	*	*	*	*	*	*	5		5
2555246	NM	school	17	LAS CRUCES	LAS CRUCES DIST OFFICE	Central Office	2020	pk_12_total	*	*	17	*	*	*	*	23	17	23
2555290	NM	school	41	LOS ALAMOS	LOS ALAMOS DIST OFFICE	Central Office	2020	pk_12_total	*	*	*	*	*	*	*	1		1
2555402	NM	school	57	PORTALES	PORTALES DIST OFFICE	Central Office	2020	pk_12_total	*	*	*	*	*	*	*	1		1
2947143	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office - Central Office	2021	pre_kindergarten								11		11
2947464	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office - Central Office	2021	pre_kindergarten								3		3
2947514	NM	school	99	JUVENILE JUSTICE	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office	2021	pre_kindergarten								0		0
2947823	NM	school	23	SILVER CITY	SILVER CITY DIST OFFICE	Central Office - Central Office	2021	pre_kindergarten								0		0
2947875	NM	school	73	TRUTH OR CONS.	T OR C DISTRICT OFFICE	Central Office - Central Office	2021	pre_kindergarten								1		1
2947902	NM	school	68	WEST LAS VEGAS	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office	2021	pre_kindergarten								0		0
2948121	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office - Central Office	2021	kindergarten_full_day								2		2
2948442	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office - Central Office	2021	kindergarten_full_day								0		0
2948492	NM	school	99	JUVENILE JUSTICE	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office	2021	kindergarten_full_day								0		0
2948801	NM	school	23	SILVER CITY	SILVER CITY DIST OFFICE	Central Office - Central Office	2021	kindergarten_full_day								0		0
2948853	NM	school	73	TRUTH OR CONS.	T OR C DISTRICT OFFICE	Central Office - Central Office	2021	kindergarten_full_day								0		0
2948880	NM	school	68	WEST LAS VEGAS	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office	2021	kindergarten_full_day								0		0
2949099	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office - Central Office	2021	grade_1								0		0
2949420	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office - Central Office	2021	grade_1								0		0
2949470	NM	school	99	JUVENILE JUSTICE	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office	2021	grade_1								0		0
2949779	NM	school	23	SILVER CITY	SILVER CITY DIST OFFICE	Central Office - Central Office	2021	grade_1								0		0
2949831	NM	school	73	TRUTH OR CONS.	T OR C DISTRICT OFFICE	Central Office - Central Office	2021	grade_1								0		0
2949858	NM	school	68	WEST LAS VEGAS	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office	2021	grade_1								0		0
2950077	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office - Central Office	2021	grade_2								0		0
2950398	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office - Central Office	2021	grade_2								0		0
2950448	NM	school	99	JUVENILE JUSTICE	JUVENILE JUSTICE DISTRICT OFFICE	Central Office - Central Office	2021	grade_2								0		0
2950757	NM	school	23	SILVER CITY	SILVER CITY DIST OFFICE	Central Office - Central Office	2021	grade_2								0		0
2950809	NM	school	73	TRUTH OR CONS.	T OR C DISTRICT OFFICE	Central Office - Central Office	2021	grade_2								0		0
2950836	NM	school	68	WEST LAS VEGAS	WEST LAS VEGAS DIST OFFICE	Central Office - Central Office	2021	grade_2								0		0
2951055	NM	school	22	ARTESIA	ARTESIA DISTRICT OFFICE	Central Office - Central Office	2021	grade_3								0		0
2951376	NM	school	18	HATCH	HATCH VALLEY DIST OFFICE	Central Office - Central Office	2021	grade_3								0		0