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 "grade" = :p0 and "state" = :p1 and (school > :p3 or (school = :p3 and rowid > :p2)) order by school, rowid 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	total	total_int
2947945	NM	school	3500060	1	ALBUQUERQUE	350006000028	329	ARROYO DEL OSO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	43	43
2541900	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office						2020	kindergarten_full_day	0	0
2948121	NM	school		22	ARTESIA		0	ARTESIA DISTRICT OFFICE	Central Office - Central Office						2021	kindergarten_full_day	2	2
2541901	NM	school	3500120	22	ARTESIA	350012000127	14	ARTESIA HIGH	Public	Regular School	No	High	10	12	2020	kindergarten_full_day	0	0
2948122	NM	school	3500120	22	ARTESIA	350012000127	14	ARTESIA HIGH	Public - High School	Regular School	No	High	10	12	2021	kindergarten_full_day	0	0
2541902	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public	Regular School	No	Secondary	08	09	2020	kindergarten_full_day	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
2541903	NM	school	3500120	22	ARTESIA	350012000134	189	ARTESIA ZIA INTERMEDIATE	Public	Regular School	No	Middle	06	07	2020	kindergarten_full_day	0	0
2948124	NM	school	3500120	22	ARTESIA	350012000134	189	ARTESIA ZIA INTERMEDIATE	Public - Middle School	Regular School	No	Middle	06	07	2021	kindergarten_full_day	0	0
2542019	NM	school	3500570	12	CLOVIS	350057000209	42	ARTS ACADEMY AT BELLA VISTA	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	55	55
2948236	NM	school	3500570	12	CLOVIS	350057000209	42	ARTS ACADEMY AT BELLA VISTA	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	54	54
2542549	NM	school	3502370	71	SANTA FE	350237001059	54	ASPEN COMMUNITY SCHOOL	Public	Regular School	No	Elementary	KG	08	2020	kindergarten_full_day	29	29
2948752	NM	school	3502370	71	SANTA FE	350237001059	54	ASPEN COMMUNITY SCHOOL	Public - Elementary School	Regular School	No	Elementary	PK	08	2021	kindergarten_full_day	19	19
2542351	NM	school	3501650	41	LOS ALAMOS	350165000427	17	ASPEN ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	kindergarten_full_day	51	51
2948560	NM	school	3501650	41	LOS ALAMOS	350165000427	17	ASPEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	kindergarten_full_day	44	44
2542550	NM	school	3502370	71	SANTA FE	350237000537	33	ATALAYA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	37	37
2948753	NM	school	3502370	71	SANTA FE	350237000537	33	ATALAYA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	41	41
2541721	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	36	36
2947946	NM	school	3500060	1	ALBUQUERQUE	350006000029	216	ATRISCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	27	27
2541722	NM	school	3500060	1	ALBUQUERQUE	350006001037	576	ATRISCO HERITAGE ACADEMY HS	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2947947	NM	school	3500060	1	ALBUQUERQUE	350006001037	576	ATRISCO HERITAGE ACADEMY HS	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541911	NM	school	3500150	64	AZTEC	350015000135	18	AZTEC HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948134	NM	school	3500150	64	AZTEC	350015000135	18	AZTEC HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2542280	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported	Alternative School	No	High	09	12	2020	kindergarten_full_day	0	0
2948489	NM	school	3500011	99	JUVENILE JUSTICE	350001100973	4	AZTEC YOUTH ACADEMY	State Supported - State Supported	Alternative School	No	High	09	12	2021	kindergarten_full_day	0	0
2541723	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	77	77
2947948	NM	school	3500060	1	ALBUQUERQUE	350006000030	222	BANDELIER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	63	63
2541724	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	52	52
2947949	NM	school	3500060	1	ALBUQUERQUE	350006000031	225	BARCELONA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	38	38
2542352	NM	school	3501650	41	LOS ALAMOS	350165000428	21	BARRANCA MESA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	56	56
2948561	NM	school	3501650	41	LOS ALAMOS	350165000428	21	BARRANCA MESA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	50	50
2542020	NM	school	3500570	12	CLOVIS	350057000208	40	BARRY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	64	64
2948237	NM	school	3500570	12	CLOVIS	350057000208	40	BARRY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	73	73
2542053	NM	school	3500690	42	DEMING	350069000941	5	BATAAN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	84	84
2948268	NM	school	3500690	42	DEMING	350069000941	5	BATAAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	66	66
2542039	NM	school	3500600	24	COBRE CONS.	350060000225	23	BAYARD ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	30	30
2948255	NM	school	3500600	24	COBRE CONS.	350060000225	23	BAYARD ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	27	27
2541725	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	42	42
2947950	NM	school	3500060	1	ALBUQUERQUE	350006000032	228	BEL-AIR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	46	46
2541920	NM	school	3500180	87	BELEN	350018000140	26	BELEN HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948141	NM	school	3500180	87	BELEN	350018000140	26	BELEN HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541921	NM	school	3500180	87	BELEN	350018000848	1	BELEN INFINITY HIGH	Public	Alternative School	No	High	09	12	2020	kindergarten_full_day	0	0
2948142	NM	school	3500180	87	BELEN	350018000848	1	BELEN INFINITY HIGH	Public - High School	Alternative School	No	High	09	12	2021	kindergarten_full_day	0	0
2541922	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	kindergarten_full_day	0	0
2948143	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	kindergarten_full_day	0	0
2542054	NM	school	3500690	42	DEMING	350069000236	24	BELL ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	47	47
2948269	NM	school	3500690	42	DEMING	350069000236	24	BELL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	34	34
2541726	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	50	50
2947951	NM	school	3500060	1	ALBUQUERQUE	350006000033	229	BELLEHAVEN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	34	34
2542383	NM	school	3501740	31	LOVINGTON	350174000449	123	BEN ALEXANDER ELEMENTARY	Public	Regular School	No	Elementary	02	02	2020	kindergarten_full_day	0	0
2948590	NM	school	3501740	31	LOVINGTON	350174000449	123	BEN ALEXANDER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	02	02	2021	kindergarten_full_day	0	0
2542147	NM	school	3501080	19	GADSDEN	350108030017	20	BERINO ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	58	58
2948358	NM	school	3501080	19	GADSDEN	350108030017	20	BERINO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	37	37
2541727	NM	school		1	ALBUQUERQUE		974	BERNALILLO ACADEMY	Off-Site						2020	kindergarten_full_day	0	0
2947952	NM	school		1	ALBUQUERQUE		974	BERNALILLO ACADEMY	Off-Site - Special Education						2021	kindergarten_full_day	0	0
2947953	NM	school		1	ALBUQUERQUE		48	BERNALILLO COUNTY JUVENILE DETENTION	Off-Site - High School						2021	kindergarten_full_day	0	0
2541728	NM	school		1	ALBUQUERQUE		48	BERNALILLO CTY JDC	Off-Site						2020	kindergarten_full_day	0	0
2541932	NM	school	3500210	61	BERNALILLO	350021000152	136	BERNALILLO ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	kindergarten_full_day	0	0
2948153	NM	school	3500210	61	BERNALILLO	350021000152	136	BERNALILLO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	03	05	2021	kindergarten_full_day	0	0
2541933	NM	school	3500210	61	BERNALILLO	350021000148	27	BERNALILLO HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948154	NM	school	3500210	61	BERNALILLO	350021000148	27	BERNALILLO HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541934	NM	school	3500210	61	BERNALILLO	350021000149	26	BERNALILLO MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948155	NM	school	3500210	61	BERNALILLO	350021000149	26	BERNALILLO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2542508	NM	school	3502250	4	ROSWELL	350225000505	24	BERRENDO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	68	68
2948715	NM	school	3502250	4	ROSWELL	350225000505	24	BERRENDO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	33	33
2542509	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948716	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2541944	NM	school	3500240	66	BLOOMFIELD	350024000155	25	BLANCO ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	kindergarten_full_day	0	0
2948165	NM	school	3500240	66	BLOOMFIELD	350024000155	25	BLANCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	01	06	2021	kindergarten_full_day	0	0
2541945	NM	school	3500240	66	BLOOMFIELD	350024000609	30	BLOOMFIELD EARLY CHILDHOOD CENTER	Public	Regular School	No	Elementary	PK	KG	2020	kindergarten_full_day	169	169
2948166	NM	school	3500240	66	BLOOMFIELD	350024000609	30	BLOOMFIELD EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	kindergarten_full_day	138	138
2541946	NM	school	3500240	66	BLOOMFIELD	350024000156	26	BLOOMFIELD HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948167	NM	school	3500240	66	BLOOMFIELD	350024000156	26	BLOOMFIELD HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2542213	NM	school	3501170	88	GRANTS	350117000327	915	BLUEWATER ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	kindergarten_full_day	12	12
2948422	NM	school	3501170	88	GRANTS	350117000327	915	BLUEWATER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	06	2021	kindergarten_full_day	11	11
2542117	NM	school	3500990	65	FARMINGTON	350099000282	19	BLUFFVIEW ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	62	62
2948329	NM	school	3500990	65	FARMINGTON	350099000282	19	BLUFFVIEW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	56	56
2542290	NM	school	3501500	17	LAS CRUCES	350150000396	172	BOOKER T. WASHINGTON	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	43	43
2948500	NM	school	3501500	17	LAS CRUCES	350150000396	172	BOOKER T. WASHINGTON	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	31	31
2542238	NM	school	3501260	33	HOBBS	350126000357	172	BOOKER T. WASHINGTON ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	kindergarten_full_day	117	117
2948447	NM	school	3501260	33	HOBBS	350126000357	172	BOOKER T. WASHINGTON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	35	35
2542364	NM	school	3501680	86	LOS LUNAS	350168000436	28	BOSQUE FARMS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	64	64
2948572	NM	school	3501680	86	LOS LUNAS	350168000436	28	BOSQUE FARMS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	kindergarten_full_day	56	56
2542239	NM	school	3501260	33	HOBBS	350126000345	28	BROADMOOR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	59	59
2948448	NM	school	3501260	33	HOBBS	350126000345	28	BROADMOOR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	56	56
2542464	NM	school	3502100	57	PORTALES	350210000485	28	BROWN EARLY CHILDHOOD CENTER	Public	Regular School	No	Elementary	PK	KG	2020	kindergarten_full_day	187	187
2948670	NM	school	3502100	57	PORTALES	350210000485	28	BROWN EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	kindergarten_full_day	165	165
2541695	NM	school	3500030	46	ALAMOGORDO	350003000002	28	BUENA VISTA ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day	32	32
2947920	NM	school	3500030	46	ALAMOGORDO	350003000002	28	BUENA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day	24	24
2541912	NM	school	3500150	64	AZTEC	350015000136	17	C.V. KOOGLER MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948135	NM	school	3500150	64	AZTEC	350015000136	17	C.V. KOOGLER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2542021	NM	school	3500570	12	CLOVIS	350057000211	68	CAMEO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	55	55
2948238	NM	school	3500570	12	CLOVIS	350057000211	68	CAMEO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	37	37
2542281	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported	Alternative School	No	High	06	12	2020	kindergarten_full_day	0	0
2948490	NM	school	3500011	99	JUVENILE JUSTICE	350001101108	6	CAMINO NUEVO YOUTH	State Supported - State Supported	Alternative School	No	High	06	12	2021	kindergarten_full_day	0	0
2542291	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public	Regular School	No	Middle	06	08	2020	kindergarten_full_day	0	0
2948501	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	kindergarten_full_day	0	0
2542551	NM	school	3502370	71	SANTA FE	350237000724	20	CAPITAL HIGH	Public	Regular School	No	High	09	12	2020	kindergarten_full_day	0	0
2948754	NM	school	3502370	71	SANTA FE	350237000724	20	CAPITAL HIGH	Public - High School	Regular School	No	High	09	12	2021	kindergarten_full_day	0	0
2541951	NM	school	3500270	40	CAPITAN	350027000160	33	CAPITAN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day	28	28
2948173	NM	school	3500270	40	CAPITAN	350027000160	33	CAPITAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day	24	24