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 desc 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
2541690	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0								0
2542685	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0								0
2543680	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1								0								0
2544675	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2								0								0
2545670	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3								0								0
2546665	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4								0								0
2547660	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5								0								0
2548655	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6								80								80
2549650	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								108								108
2550645	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8								83								83
2551640	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_9								0								0
2552635	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_10								0								0
2553630	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_11								0								0
2554625	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_12								0								0
2555620	NM	school	3502800	89	ZUNI	350280000678	195	ZUNI MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	*	*	*	267	*	*	*	271				267				271
2541689	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	pre_kindergarten								0								0
2542684	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day								0								0
2543679	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_1								0								0
2544674	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_2								0								0
2545669	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_3								0								0
2546664	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_4								0								0
2547659	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_5								0								0
2548654	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_6								0								0
2549649	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_7								0								0
2550644	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_8								0								0
2551639	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_9								80								80
2552634	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_10								88								88
2553629	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_11								82								82
2554624	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	grade_12								56								56
2555619	NM	school	3502800	89	ZUNI	350280000676	190	ZUNI HIGH	Public	Regular School	No	High	09	12	2020	pk_12_total	*	*	*	305	*	*	*	306				305				306
2540894	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pre_kindergarten								0								0
2541889	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								49								49
2542884	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								36								36
2543879	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								51								51
2544874	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								46								46
2545869	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								55								55
2546864	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								64								64
2547859	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6								0								0
2548854	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_7								0								0
2549849	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_8								0								0
2550844	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_9								0								0
2551839	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_10								0								0
2552834	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_11								0								0
2553829	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_12								0								0
2554824	NM	school	3500060	1	ALBUQUERQUE	350006000125	388	ZUNI ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	80	*	182	20	8	*	6	301	80		182	20	8		6	301
2541339	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	pre_kindergarten								0								0
2542334	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day								0								0
2543329	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1								0								0
2544324	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2								0								0
2545319	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3								0								0
2546314	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4								0								0
2547309	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5								0								0
2548304	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6								214								214
2549299	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								265								265
2550294	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8								232								232
2551289	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_9								0								0
2552284	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_10								0								0
2553279	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_11								0								0
2554274	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_12								0								0
2555269	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	141	13	543	*	*	6	*	711	141	13	543			6		711
2540893	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten								0								0
2541043	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten								30								30
2541888	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								44								44
2542038	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								69								69
2542883	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1								55								55
2543033	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1								63								63
2543878	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2								47								47
2544028	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2								68								68
2544873	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								43								43
2545023	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								79								79
2545868	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4								46								46
2546018	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4								61								61
2546863	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								48								48
2547013	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								77								77
2547858	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_6								0								0
2548008	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_6								0								0
2548853	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_7								0								0
2549003	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_7								0								0
2549848	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_8								0								0
2549998	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_8								0								0
2550843	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_9								0								0
2550993	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_9								0								0
2551838	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_10								0								0
2551988	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_10								0								0
2552833	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_11								0								0
2552983	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_11								0								0
2553828	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_12								0								0
2553978	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_12								0								0
2554823	NM	school	3500060	1	ALBUQUERQUE	350006000124	385	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pk_12_total	95	10	137	18	*	*	18	283	95	10	137	18			18	283
2554973	NM	school	3500570	12	CLOVIS	350057000224	155	ZIA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pk_12_total	240	20	153	*	8	*	23	447	240	20	153		8		23	447
2541585	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	pre_kindergarten								0								0
2542580	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	kindergarten_full_day								0								0
2543575	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_1								0								0
2544570	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_2								1								1
2545565	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_3								1								1
2546560	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_4								0								0
2547555	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_5								1								1
2548550	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_6								2								2
2549545	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_7								4								4
2550540	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_8								0								0
2551535	NM	school		71	SANTA FE		53	ZIA BEHAVIOR PROGRAM	Off-Site						2020	grade_9								0								0