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 ccd_school_lvl 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	multiracial_int	total_int
2947145	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	pre_kindergarten								0						0
2947262	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	pre_kindergarten								0						0
2947289	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	pre_kindergarten								0						0
2947476	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	pre_kindergarten								0						0
2947591	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	pre_kindergarten								0						0
2947619	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	pre_kindergarten								0						0
2947827	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	pre_kindergarten								0						0
2948123	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	kindergarten_full_day								0						0
2948240	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	kindergarten_full_day								0						0
2948267	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	kindergarten_full_day								0						0
2948454	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	kindergarten_full_day								0						0
2948569	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	kindergarten_full_day								0						0
2948597	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	kindergarten_full_day								0						0
2948805	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	kindergarten_full_day								0						0
2949101	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_1								0						0
2949218	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_1								0						0
2949245	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_1								0						0
2949432	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_1								0						0
2949547	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_1								0						0
2949575	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_1								0						0
2949783	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_1								0						0
2950079	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_2								0						0
2950196	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_2								0						0
2950223	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_2								0						0
2950410	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_2								0						0
2950525	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_2								0						0
2950553	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_2								0						0
2950761	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_2								0						0
2951057	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_3								0						0
2951174	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_3								0						0
2951201	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_3								0						0
2951388	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_3								0						0
2951503	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_3								0						0
2951531	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_3								0						0
2951739	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_3								0						0
2952035	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_4								0						0
2952152	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_4								0						0
2952179	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_4								0						0
2952366	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_4								0						0
2952481	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_4								0						0
2952509	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_4								0						0
2952717	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_4								0						0
2953013	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_5								0						0
2953130	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_5								0						0
2953157	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_5								0						0
2953344	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_5								0						0
2953459	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_5								0						0
2953487	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_5								0						0
2953695	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_5								0						0
2953991	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_6								0						0
2954108	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_6								0						0
2954135	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_6								6						6
2954322	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_6								0						0
2954437	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_6								0						0
2954465	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_6								0						0
2954673	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_6								8						8
2954969	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_7								0						0
2955086	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_7								0						0
2955113	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_7								4						4
2955300	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_7								0						0
2955415	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_7								0						0
2955443	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_7								0						0
2955651	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_7								9						9
2955947	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_8								297						297
2956064	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_8								0						0
2956091	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_8								11						11
2956278	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_8								0						0
2956393	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_8								0						0
2956421	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_8								0						0
2956629	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_8								21						21
2956925	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_9								272						272
2957042	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_9								613						613
2957069	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_9								8						8
2957256	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_9								744						744
2957371	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_9								276						276
2957399	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_9								279						279
2957607	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_9								18						18
2957903	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_10								0						0
2958020	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_10								0						0
2958047	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_10								9						9
2958234	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_10								0						0
2958349	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_10								0						0
2958377	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_10								0						0
2958585	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_10								16						16
2958881	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_11								0						0
2958998	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_11								0						0
2959025	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_11								5						5
2959212	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_11								0						0
2959327	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_11								0						0
2959355	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_11								0						0
2959563	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_11								6						6
2959859	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	grade_12								0						0
2959976	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_12								0						0
2960003	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_12								3						3
2960190	NM	school	3501260	33	HOBBS	350126000348	55	HOBBS FRESHMAN HIGH	Public - High School	Regular School	No	Secondary	09	10	2021	grade_12								0						0
2960305	NM	school	3501650	41	LOS ALAMOS	350165001122	79	TOPPER FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_12								0						0
2960333	NM	school	3501740	31	LOVINGTON	350174001044	83	LOVINGTON FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	grade_12								0						0
2960541	NM	school	3500177	568	SIX DIRECTIONS INDIGENOUS SCHOOL	350017701126	1	SIX DIRECTIONS INDIGENOUS SCHOOL	Charter - High School	Regular School	Yes	Secondary	06	11	2021	grade_12								0						0
2960837	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public - Junior High	Regular School	No	Secondary	08	09	2021	pk_12_total	211	*	344	9	*	*	*	569	211		344	9		569
2960954	NM	school	3500570	12	CLOVIS	350057000222	56	CLOVIS HS FRESHMAN ACADEMY	Public - High School	Regular School	No	Secondary	09	09	2021	pk_12_total	170	41	377	*	*	*	17	613	170	41	377		17	613
2960981	NM	school	3500174	562	DEAP	350017401113	1	DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE	Charter - High School	Regular School	Yes	Secondary	06	11	2021	pk_12_total	*	*	*	45	*	*	*	46				45		46