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 district_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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	hispanic_int	total_int
2541666	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten								5		5
2541667	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	pre_kindergarten								0		0
2542661	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day								6		6
2542662	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	kindergarten_full_day								0		0
2543656	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_1								0		0
2543657	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_1								0		0
2544651	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_2								6		6
2544652	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_2								0		0
2545646	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_3								8		8
2545647	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_3								0		0
2546641	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4								1		1
2546642	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_4								0		0
2547636	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_5								3		3
2547637	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_5								0		0
2548631	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_6								2		2
2548632	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_6								0		0
2549626	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_7								0		0
2549627	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_7								4		4
2550621	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8								0		0
2550622	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_8								4		4
2551616	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_9								0		0
2551617	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_9								3		3
2552611	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_10								0		0
2552612	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_10								7		7
2553606	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_11								0		0
2553607	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_11								1		1
2554601	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_12								0		0
2554602	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_12								8		8
2555596	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pk_12_total	*	*	28	*	*	*	*	31	28	31
2555597	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	pk_12_total	*	*	24	*	*	*	*	27	24	27
2947889	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten								6		6
2947890	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	pre_kindergarten								0		0
2948867	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day								6		6
2948868	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	kindergarten_full_day								0		0
2949845	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_1								6		6
2949846	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_1								0		0
2950823	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_2								0		0
2950824	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_2								0		0
2951801	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_3								6		6
2951802	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_3								0		0
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
2953757	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5								2		2
2953758	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_5								0		0
2954735	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_6								4		4
2954736	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_6								0		0
2955713	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_7								0		0
2955714	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_7								2		2
2956691	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_8								0		0
2956692	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_8								4		4
2957669	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_9								0		0
2957670	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_9								3		3
2958647	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_10								0		0
2958648	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_10								2		2
2959625	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_11								0		0
2959626	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_11								5		5
2960603	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_12								0		0
2960604	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	grade_12								3		3
2961581	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pk_12_total	*	*	29	*	*	*	*	36	29	36
2961582	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public - High School	Regular School	No	High	07	12	2021	pk_12_total	*	*	17	*	*	*	*	19	17	19
2541492	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541493	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	pre_kindergarten								0		0
2541494	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541495	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0		0
2541496	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541497	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541498	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	pre_kindergarten								0		0
2541499	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0		0
2541500	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541501	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541503	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0		0
2541504	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541505	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	pre_kindergarten								0		0
2541506	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2541507	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten								0		0
2541508	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0		0
2541509	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten								0		0
2541510	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten								612		612
2541511	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0		0
2542487	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								126		126
2542488	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	kindergarten_full_day								0		0
2542489	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								101		101
2542490	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0		0
2542491	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								109		109
2542492	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								122		122
2542493	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	kindergarten_full_day								0		0
2542494	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0		0
2542495	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								149		149
2542496	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								157		157
2542498	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0		0
2542499	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								120		120
2542500	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	kindergarten_full_day								0		0
2542501	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								102		102
2542502	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day								0		0
2542503	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0		0
2542504	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								110		110
2542505	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day								0		0
2542506	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								81		81
2543482	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								109		109
2543483	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_1								0		0
2543484	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								100		100