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_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	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	multiracial_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
2542661	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day								6							6
2543656	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	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
2545646	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_3								8							8
2546641	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4								1							1
2547636	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_5								3							3
2548631	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_6								2							2
2549626	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_7								0							0
2550621	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_8								0							0
2551616	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_9								0							0
2552611	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_10								0							0
2553606	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_11								0							0
2554601	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_12								0							0
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
2541667	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	pre_kindergarten								0							0
2542662	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	kindergarten_full_day								0							0
2543657	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_1								0							0
2544652	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_2								0							0
2545647	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_3								0							0
2546642	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_4								0							0
2547637	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_5								0							0
2548632	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_6								0							0
2549627	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_7								4							4
2550622	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_8								4							4
2551617	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_9								3							3
2552612	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_10								7							7
2553607	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_11								1							1
2554602	NM	school	3500001	26	VAUGHN	350000100608	169	VAUGHN HIGH	Public	Regular School	No	High	07	12	2020	grade_12								8							8
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
2541506	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								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
2543496	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								90							90
2544491	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								105							105
2545486	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								92							92
2546481	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								123							123
2547476	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								106							106
2548471	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0							0
2549466	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0							0
2550461	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0							0
2551456	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0							0
2552451	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0							0
2553446	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0							0
2554441	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0							0
2555436	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	181	11	359	39	*	*	23	618	181	11	359	39		23	618
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
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
2543494	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								93							93
2544489	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								115							115
2545484	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								128							128
2546479	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								113							113
2547474	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								136							136
2548469	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0							0
2549464	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0							0
2550459	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0							0
2551454	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0							0
2552449	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0							0
2553444	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0							0
2554439	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0							0
2555434	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	190	*	463	15	*	*	31	705	190		463	15		31	705
2541499	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								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
2543489	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1								0							0
2544484	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2								0							0
2545479	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3								0							0
2546474	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4								0							0
2547469	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5								0							0
2548464	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6								314							314
2549459	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								313							313
2550454	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8								326							326
2551449	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_9								0							0
2552444	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_10								0							0
2553439	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_11								0							0
2554434	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_12								0							0
2555429	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	309	18	539	25	*	*	46	953	309	18	539	25		46	953
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
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
2543491	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								151							151
2544486	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								166							166
2545481	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								144							144
2546476	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								160							160
2547471	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								161							161
2548466	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0							0
2549461	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0							0
2550456	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0							0
2551451	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0							0
2552446	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0							0
2553441	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0							0
2554436	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0							0
2555431	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	301	*	509	*	27	*	58	939	301		509		27	58	939
2541497	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0							0
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
2543487	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								107							107
2544482	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								120							120
2545477	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								149							149
2546472	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								136							136
2547467	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								148							148
2548462	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0							0
2549457	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0							0
2550452	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0							0
2551447	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0							0