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 and (school_nces_id > :p3 or (school_nces_id = :p3 and rowid > :p2)) order by school_nces_id, rowid 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	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
2551447	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0								0
2552442	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0								0
2553437	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0								0
2554432	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0								0
2555427	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	311	9	400	23	*	*	35	782	311	9	400	23			35	782
2541503	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0								0
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
2543493	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1								0								0
2544488	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2								0								0
2545483	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3								0								0
2546478	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4								0								0
2547473	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5								0								0
2548468	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6								301								301
2549463	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								314								314
2550458	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8								297								297
2551453	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_9								0								0
2552448	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_10								0								0
2553443	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_11								0								0
2554438	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_12								0								0
2555433	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	260	*	524	51	*	*	52	912	260		524	51			52	912
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
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
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
2544479	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								109								109
2545474	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								138								138
2546469	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								131								131
2547464	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								121								121
2548459	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0								0
2549454	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0								0
2550449	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0								0
2551444	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0								0
2552439	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0								0
2553434	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0								0
2554429	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0								0
2555424	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	176	16	437	23	*	*	44	700	176	16	437	23			44	700
2541495	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0								0
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
2543485	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1								0								0
2544480	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2								0								0
2545475	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3								0								0
2546470	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4								0								0
2547465	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5								0								0
2548460	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6								329								329
2549455	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								303								303
2550450	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8								305								305
2551445	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_9								0								0
2552440	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_10								0								0
2553435	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_11								0								0
2554430	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_12								0								0
2555425	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	271	14	562	40	*	*	41	937	271	14	562	40			41	937
2541507	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten								0								0
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
2543497	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_1								0								0
2544492	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_2								0								0
2545487	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_3								0								0
2546482	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_4								0								0
2547477	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_5								0								0
2548472	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_6								0								0
2549467	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_7								0								0
2550462	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_8								0								0
2551457	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_9								725								725
2552452	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_10								668								668
2553447	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_11								589								589
2554442	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_12								576								576
2555437	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	pk_12_total	802	54	1447	81	44	8	122	2558	802	54	1447	81	44	8	122	2558
2541498	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	pre_kindergarten								0								0
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
2543488	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_1								0								0
2544483	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_2								0								0
2545478	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_3								0								0
2546473	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_4								0								0
2547468	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_5								0								0
2548463	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_6								0								0
2549458	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_7								0								0
2550453	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_8								0								0
2551448	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_9								0								0
2552443	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_10								0								0
2553438	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_11								40								40
2554433	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_12								147								147
2555428	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	pk_12_total	32	*	126	19	*	*	9	187	32		126	19			9	187
2541511	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								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
2543501	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								99								99
2544496	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								111								111
2545491	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								133								133
2546486	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								112								112
2547481	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								140								140
2548476	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0								0
2549471	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0								0
2550466	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0								0
2551461	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0								0
2552456	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0								0
2553451	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0								0
2554446	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0								0
2555441	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	174	11	396	44	*	*	41	676	174	11	396	44			41	676
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
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
2543498	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_1								0								0
2544493	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_2								0								0
2545488	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_3								0								0
2546483	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_4								0								0