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 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
2541341	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	pre_kindergarten								0							0
2542336	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	kindergarten_full_day								0							0
2543331	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_1								0							0
2544326	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_2								0							0
2545321	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_3								0							0
2546316	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_4								0							0
2547311	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_5								0							0
2548306	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_6								0							0
2549301	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_7								129							129
2550296	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_8								95							95
2551291	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_9								0							0
2552286	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_10								0							0
2553281	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_11								0							0
2554276	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	grade_12								0							0
2555271	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public	Regular School	No	Middle	07	08	2020	pk_12_total	14	*	206	*	*	*	*	224	14		206				224
2540714	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten								49							49
2541709	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								76							76
2542704	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1								78							78
2543699	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2								77							77
2544694	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								63							63
2545689	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4								70							70
2546684	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								83							83
2547679	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_6								0							0
2548674	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_7								0							0
2549669	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_8								0							0
2550664	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_9								0							0
2551659	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_10								0							0
2552654	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_11								0							0
2553649	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_12								0							0
2554644	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pk_12_total	247	*	219	7	*	*	17	496	247		219	7		17	496
2541087	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	pre_kindergarten								0							0
2542082	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	kindergarten_full_day								19							19
2543077	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_1								10							10
2544072	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_2								15							15
2545067	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_3								14							14
2546062	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_4								11							11
2547057	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_5								10							10
2548052	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_6								14							14
2549047	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_7								0							0
2550042	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_8								0							0
2551037	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_9								0							0
2552032	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_10								0							0
2553027	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_11								0							0
2554022	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_12								0							0
2555017	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	pk_12_total	*	*	87	*	*	*	*	93			87				93
2540715	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	pre_kindergarten								0							0
2541710	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	kindergarten_full_day								0							0
2542705	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_1								0							0
2543700	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_2								0							0
2544695	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_3								0							0
2545690	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_4								0							0
2546685	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_5								0							0
2547680	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_6								0							0
2548675	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_7								0							0
2549670	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_8								0							0
2550665	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_9								78							78
2551660	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_10								96							96
2552655	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_11								80							80
2553650	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_12								96							96
2554645	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	pk_12_total	26	13	282	20	*	*	*	350	26	13	282	20			350
2540696	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	pre_kindergarten								0							0
2541691	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	kindergarten_full_day								0							0
2542686	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_1								57							57
2543681	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_2								55							55
2544676	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_3								52							52
2545671	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_4								58							58
2546666	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_5								59							59
2547661	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_6								115							115
2548656	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_7								95							95
2549651	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_8								88							88
2550646	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_9								37							37
2551641	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_10								35							35
2552636	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_11								19							19
2553631	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_12								19							19
2554626	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	pk_12_total	341	32	256	23	35	*	*	689	341	32	256	23	35		689
2540697	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	pre_kindergarten								0							0
2541692	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	kindergarten_full_day								5							5
2542687	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_1								10							10
2543682	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_2								9							9
2544677	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_3								7							7
2545672	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_4								11							11
2546667	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_5								14							14
2547662	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_6								9							9
2548657	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_7								11							11
2549652	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_8								15							15
2550647	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_9								2							2
2551642	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_10								1							1
2552637	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_11								3							3
2553632	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	grade_12								6							6
2554627	NM	school	3500123	517	ABQ SIGN LANGUAGE ACADEMY	350012301066	1	ABQ SIGN LANGUAGE ACADEMY	Charter	Regular School	Yes	Other	KG	12	2020	pk_12_total	21	*	74	*	*	*	*	103	21		74				103
2541550	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	pre_kindergarten								0							0
2542545	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	kindergarten_full_day								0							0
2543540	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_1								0							0
2544535	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_2								0							0
2545530	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_3								0							0
2546525	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_4								0							0
2547520	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_5								0							0
2548515	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_6								0							0
2549510	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_7								0							0
2550505	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_8								0							0
2551500	NM	school	3502370	71	SANTA FE	350237000788	12	ACADEMY AT LARRAGOITE	Public	Alternative School	No	High	09	12	2020	grade_9								6							6