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 order by total_int 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	total	total_int
2955028	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	530	530
2548924	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public	Regular School	No	Middle	07	08	2020	grade_7	502	502
2955126	NM	school	3500690	42	DEMING	350069001023	7	RED MOUNTAIN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	443	443
2955425	NM	school	3501680	86	LOS LUNAS	350168000440	84	LOS LUNAS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	424	424
2549031	NM	school	3500690	42	DEMING	350069001023	7	RED MOUNTAIN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	414	414
2549468	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	411	411
2549337	NM	school	3501680	86	LOS LUNAS	350168000440	84	LOS LUNAS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	408	408
2955556	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	407	407
2548836	NM	school	3500060	1	ALBUQUERQUE	350006001047	492	TONY HILLERMAN MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	406	406
2955214	NM	school	3501080	19	GADSDEN	350108000631	52	GADSDEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	382	382
2549122	NM	school	3501080	19	GADSDEN	350108000631	52	GADSDEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	379	379
2548757	NM	school	3500060	1	ALBUQUERQUE	350006000825	490	JAMES MONROE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	373	373
2954940	NM	school	3500060	1	ALBUQUERQUE	350006001047	492	TONY HILLERMAN MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	359	359
2548839	NM	school	3500060	1	ALBUQUERQUE	350006000114	475	TRUMAN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	342	342
2549209	NM	school	3501260	33	HOBBS	350126000349	57	HIGHLAND MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	342	342
2549133	NM	school	3501080	19	GADSDEN	350108000660	175	SANTA TERESA MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	335	335
2549256	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	333	333
2549358	NM	school	3501740	31	LOVINGTON	350174000450	82	TAYLOR MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	333	333
2954943	NM	school	3500060	1	ALBUQUERQUE	350006000114	475	TRUMAN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	332	332
2548716	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	330	330
2549213	NM	school	3501260	33	HOBBS	350126000351	59	HOUSTON MIDDLE SCHOOL	Public	Regular School	No	Middle	06	09	2020	grade_7	318	318
2955446	NM	school	3501740	31	LOVINGTON	350174000450	82	TAYLOR MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	317	317
2955347	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	316	316
2549463	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	314	314
2954861	NM	school	3500060	1	ALBUQUERQUE	350006000825	490	JAMES MONROE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	314	314
2549459	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	313	313
2548736	NM	school	3500060	1	ALBUQUERQUE	350006001114	496	GEORGE I SANCHEZ	Public	Regular School	No	Elementary	PK	08	2020	grade_7	311	311
2548868	NM	school	3500120	22	ARTESIA	350012000134	189	ARTESIA ZIA INTERMEDIATE	Public	Regular School	No	Middle	06	07	2020	grade_7	311	311
2955207	NM	school	3501080	19	GADSDEN	350108000202	32	CHAPARRAL MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	310	310
2955541	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	310	310
2549455	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	303	303
2955381	NM	school	3501500	17	LAS CRUCES	350150000455	144	SIERRA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	301	301
2954820	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	300	300
2955411	NM	school	3501650	41	LOS ALAMOS	350165000430	124	LOS ALAMOS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	299	299
2549291	NM	school	3501500	17	LAS CRUCES	350150000455	144	SIERRA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	298	298
2955547	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	298	298
2955551	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	296	296
2549322	NM	school	3501650	41	LOS ALAMOS	350165000430	124	LOS ALAMOS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	294	294
2548728	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	293	293
2954970	NM	school	3500120	22	ARTESIA	350012000134	189	ARTESIA ZIA INTERMEDIATE	Public - Middle School	Regular School	No	Middle	06	07	2021	grade_7	292	292
2549115	NM	school	3501080	19	GADSDEN	350108000202	32	CHAPARRAL MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	287	287
2548887	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	282	282
2955299	NM	school	3501260	33	HOBBS	350126000349	57	HIGHLAND MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	277	277
2955304	NM	school	3501260	33	HOBBS	350126000351	59	HOUSTON MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	09	2021	grade_7	276	276
2549289	NM	school	3501500	17	LAS CRUCES	350150000669	35	PICACHO MIDDLE	Public	Regular School	No	Middle	06	09	2020	grade_7	275	275
2954832	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	273	273
2955379	NM	school	3501500	17	LAS CRUCES	350150000669	35	PICACHO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	272	272
2954989	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	271	271
2955225	NM	school	3501080	19	GADSDEN	350108000660	175	SANTA TERESA MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	271	271
2955432	NM	school	3501680	86	LOS LUNAS	350168000614	25	VALENCIA MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	267	267
2549299	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	265	265
2549530	NM	school	3502370	71	SANTA FE	350237001139	189	MILAGRO MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	264	264
2549344	NM	school	3501680	86	LOS LUNAS	350168000614	25	VALENCIA MIDDLE SCHOOL	Public	Regular School	No	Middle	07	08	2020	grade_7	259	259
2955372	NM	school	3501500	17	LAS CRUCES	350150001063	15	MESA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	259	259
2548759	NM	school	3500060	1	ALBUQUERQUE	350006000069	425	JEFFERSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	255	255
2549474	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	253	253
2955182	NM	school	3500990	65	FARMINGTON	350099000286	58	HERMOSA MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	253	253
2955194	NM	school	3500990	65	FARMINGTON	350099000293	162	TIBBETTS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	253	253
2548760	NM	school	3500060	1	ALBUQUERQUE	350006000812	445	JIMMY CARTER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	250	250
2549088	NM	school	3500990	65	FARMINGTON	350099000285	59	HEIGHTS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	09	2020	grade_7	246	246
2954840	NM	school	3500060	1	ALBUQUERQUE	350006001114	496	GEORGE I SANCHEZ	Public - Elementary School	Regular School	No	Elementary	PK	08	2021	grade_7	246	246
2549049	NM	school	3500900	55	ESPANOLA	350090000814	19	CARLOS F. VIGIL MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	245	245
2955181	NM	school	3500990	65	FARMINGTON	350099000285	59	HEIGHTS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	243	243
2955144	NM	school	3500900	55	ESPANOLA	350090000814	19	CARLOS F. VIGIL MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	242	242
2954863	NM	school	3500060	1	ALBUQUERQUE	350006000069	425	JEFFERSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	236	236
2548766	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	233	233
2549102	NM	school	3500990	65	FARMINGTON	350099000293	162	TIBBETTS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	233	233
2954829	NM	school	3500060	1	ALBUQUERQUE	350006001099	517	ECADEMY	Public - High School	Regular School	No	Other	KG	12	2021	grade_7	233	233
2955276	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	233	233
2548950	NM	school	3500390	67	CENTRAL CONS.	350039000180	34	KIRTLAND MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	231	231
2549297	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	231	231
2954870	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	231	231
2548779	NM	school	3500060	1	ALBUQUERQUE	350006000081	435	MADISON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	230	230
2549153	NM	school	3501110	43	GALLUP	350111000661	190	JOHN F. KENNEDY MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	230	230
2549282	NM	school	3501500	17	LAS CRUCES	350150001063	15	MESA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	230	230
2955562	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	230	230
2549493	NM	school	3502250	4	ROSWELL	350225000522	125	SIERRA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	229	229
2549208	NM	school	3501260	33	HOBBS	350126001067	8	HEIZER MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	228	228
2549089	NM	school	3500990	65	FARMINGTON	350099000286	58	HERMOSA MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_7	226	226
2549002	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	225	225
2955387	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	225	225
2955017	NM	school	3500240	66	BLOOMFIELD	350024000158	95	MESA ALTA JR HIGH	Public - Junior High	Regular School	No	Middle	07	08	2021	grade_7	224	224
2955298	NM	school	3501260	33	HOBBS	350126001067	8	HEIZER MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	224	224
2549434	NM	school	3502100	57	PORTALES	350210000489	123	PORTALES JR HIGH	Public	Regular School	No	Middle	07	08	2020	grade_7	222	222
2549186	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_7	221	221
2955244	NM	school	3501110	43	GALLUP	350111000661	190	JOHN F. KENNEDY MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	220	220
2955389	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	218	218
2548877	NM	school	3500150	64	AZTEC	350015000136	17	C.V. KOOGLER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	217	217
2954767	NM	school	3500030	46	ALAMOGORDO	350003000003	33	CHAPARRAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	217	217
2954864	NM	school	3500060	1	ALBUQUERQUE	350006000812	445	JIMMY CARTER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	217	217
2548838	NM	school	3500060	1	ALBUQUERQUE	350006001142	497	TRES VOLCANES COMMUNITY COLLABORATIVE SCHOOL	Public	Regular School	No	Elementary	KG	08	2020	grade_7	216	216
2955051	NM	school	3500390	67	CENTRAL CONS.	350039000180	34	KIRTLAND MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	214	214
2549279	NM	school	3501500	17	LAS CRUCES	350150000388	86	LYNN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	213	213
2955232	NM	school	3501110	43	GALLUP	350111001027	3	CHIEF MANUELITO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	213	213
2955615	NM	school	3502370	71	SANTA FE	350237001139	189	MILAGRO MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7	211	211
2548702	NM	school	3500060	1	ALBUQUERQUE	350006000617	407	CLEVELAND MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7	209	209
2955094	NM	school	3500570	12	CLOVIS	350057000218	91	MARSHALL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	209	209
2955580	NM	school	3502250	4	ROSWELL	350225000522	125	SIERRA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	209	209
2954883	NM	school	3500060	1	ALBUQUERQUE	350006000081	435	MADISON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	208	208
2955099	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	208	208
2955369	NM	school	3501500	17	LAS CRUCES	350150000388	86	LYNN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7	208	208