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 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	multiracial_int	total_int
2946936	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	pre_kindergarten								0						0
2947914	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	kindergarten_full_day								0						0
2948892	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_1								0						0
2949870	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_2								0						0
2950848	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_3								0						0
2951826	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_4								26						26
2952804	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_5								39						39
2953782	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_6								85						85
2954760	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_7								104						104
2955738	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_8								97						97
2956716	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_9								0						0
2957694	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_10								0						0
2958672	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_11								0						0
2959650	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_12								0						0
2960628	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	pk_12_total	136	14	181	7	*	*	9	351	136	14	181	7	9	351
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
2947567	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	pre_kindergarten								0						0
2948545	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	kindergarten_full_day								0						0
2949523	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_1								0						0
2950501	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_2								0						0
2951479	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_3								0						0
2952457	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_4								0						0
2953435	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_5								0						0
2954413	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_6								0						0
2955391	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7								98						98
2956369	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8								123						123
2957347	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_9								0						0
2958325	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_10								0						0
2959303	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_11								0						0
2960281	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_12								0						0
2961259	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	pk_12_total	9	*	209	*	*	*	*	221	9		209			221
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
2946956	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten								40						40
2947934	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day								43						43
2948912	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1								63						63
2949890	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_2								57						57
2950868	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_3								65						65
2951846	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								45						45
2952824	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5								51						51
2953802	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_6								0						0
2954780	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_7								0						0
2955758	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_8								0						0
2956736	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_9								0						0
2957714	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_10								0						0
2958692	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_11								0						0
2959670	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_12								0						0
2960648	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	171	*	168	*	*	*	17	364	171		168		17	364
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
2947318	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	pre_kindergarten								0						0
2948296	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	kindergarten_full_day								16						16
2949274	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_1								16						16
2950252	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_2								6						6
2951230	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_3								17						17
2952208	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_4								13						13
2953186	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5								7						7
2954164	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_6								9						9
2955142	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_7								0						0
2956120	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8								0						0
2957098	NM	school	3500900	55	ESPANOLA	350090000259	5	ABIQUIU ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	grade_9								0						0