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
2549919	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public	Regular School	No	Middle	07	08	2020	grade_8	482	482
2956006	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	465	465
2550332	NM	school	3501680	86	LOS LUNAS	350168000440	84	LOS LUNAS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	441	441
2549831	NM	school	3500060	1	ALBUQUERQUE	350006001047	492	TONY HILLERMAN MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	429	429
2550463	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	420	420
2550117	NM	school	3501080	19	GADSDEN	350108000631	52	GADSDEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	411	411
2956403	NM	school	3501680	86	LOS LUNAS	350168000440	84	LOS LUNAS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	400	400
2956534	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	400	400
2550026	NM	school	3500690	42	DEMING	350069001023	7	RED MOUNTAIN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	391	391
2956104	NM	school	3500690	42	DEMING	350069001023	7	RED MOUNTAIN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	390	390
2956192	NM	school	3501080	19	GADSDEN	350108000631	52	GADSDEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	376	376
2955918	NM	school	3500060	1	ALBUQUERQUE	350006001047	492	TONY HILLERMAN MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	372	372
2549755	NM	school	3500060	1	ALBUQUERQUE	350006000812	445	JIMMY CARTER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	352	352
2549711	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	351	351
2956203	NM	school	3501080	19	GADSDEN	350108000660	175	SANTA TERESA MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	345	345
2956325	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	337	337
2955839	NM	school	3500060	1	ALBUQUERQUE	350006000825	490	JAMES MONROE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	333	333
2549731	NM	school	3500060	1	ALBUQUERQUE	350006001114	496	GEORGE I SANCHEZ	Public	Regular School	No	Elementary	PK	08	2020	grade_8	327	327
2550454	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	326	326
2549834	NM	school	3500060	1	ALBUQUERQUE	350006000114	475	TRUMAN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	324	324
2956424	NM	school	3501740	31	LOVINGTON	350174000450	82	TAYLOR MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	322	322
2956277	NM	school	3501260	33	HOBBS	350126000349	57	HIGHLAND MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	321	321
2550251	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	319	319
2955921	NM	school	3500060	1	ALBUQUERQUE	350006000114	475	TRUMAN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	314	314
2550110	NM	school	3501080	19	GADSDEN	350108000202	32	CHAPARRAL MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	313	313
2956529	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	310	310
2550450	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	305	305
2549752	NM	school	3500060	1	ALBUQUERQUE	350006000825	490	JAMES MONROE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	304	304
2956525	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	304	304
2550128	NM	school	3501080	19	GADSDEN	350108000660	175	SANTA TERESA MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	303	303
2550204	NM	school	3501260	33	HOBBS	350126000349	57	HIGHLAND MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	302	302
2956185	NM	school	3501080	19	GADSDEN	350108000202	32	CHAPARRAL MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	300	300
2550458	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	297	297
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
2956389	NM	school	3501650	41	LOS ALAMOS	350165000430	124	LOS ALAMOS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	295	295
2956519	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	293	293
2955818	NM	school	3500060	1	ALBUQUERQUE	350006001114	496	GEORGE I SANCHEZ	Public - Elementary School	Regular School	No	Elementary	PK	08	2021	grade_8	292	292
2550208	NM	school	3501260	33	HOBBS	350126000351	59	HOUSTON MIDDLE SCHOOL	Public	Regular School	No	Middle	06	09	2020	grade_8	289	289
2550286	NM	school	3501500	17	LAS CRUCES	350150000455	144	SIERRA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	289	289
2955798	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	289	289
2956359	NM	school	3501500	17	LAS CRUCES	350150000455	144	SIERRA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	287	287
2956282	NM	school	3501260	33	HOBBS	350126000351	59	HOUSTON MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	09	2021	grade_8	283	283
2549862	NM	school	3500120	22	ARTESIA	350012000130	187	ARTESIA PARK JUNIOR HIGH	Public	Regular School	No	Secondary	08	09	2020	grade_8	281	281
2549882	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	281	281
2955967	NM	school	3500180	87	BELEN	350018000141	25	BELEN MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	281	281
2549723	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	280	280
2956367	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	276	276
2550317	NM	school	3501650	41	LOS ALAMOS	350165000430	124	LOS ALAMOS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	275	275
2550353	NM	school	3501740	31	LOVINGTON	350174000450	82	TAYLOR MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	274	274
2956357	NM	school	3501500	17	LAS CRUCES	350150000669	35	PICACHO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	274	274
2955810	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	273	273
2549774	NM	school	3500060	1	ALBUQUERQUE	350006000081	435	MADISON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	270	270
2549754	NM	school	3500060	1	ALBUQUERQUE	350006000069	425	JEFFERSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	269	269
2550277	NM	school	3501500	17	LAS CRUCES	350150001063	15	MESA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	260	260
2549761	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	259	259
2550083	NM	school	3500990	65	FARMINGTON	350099000285	59	HEIGHTS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	09	2020	grade_8	258	258
2550284	NM	school	3501500	17	LAS CRUCES	350150000669	35	PICACHO MIDDLE	Public	Regular School	No	Middle	06	09	2020	grade_8	252	252
2550525	NM	school	3502370	71	SANTA FE	350237001139	189	MILAGRO MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	249	249
2955842	NM	school	3500060	1	ALBUQUERQUE	350006000812	445	JIMMY CARTER MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	246	246
2956172	NM	school	3500990	65	FARMINGTON	350099000293	162	TIBBETTS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	246	246
2956159	NM	school	3500990	65	FARMINGTON	350099000285	59	HEIGHTS MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	240	240
2549945	NM	school	3500390	67	CENTRAL CONS.	350039000180	34	KIRTLAND MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	239	239
2956593	NM	school	3502370	71	SANTA FE	350237001139	189	MILAGRO MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	238	238
2955807	NM	school	3500060	1	ALBUQUERQUE	350006001099	517	ECADEMY	Public - High School	Regular School	No	Other	KG	12	2021	grade_8	237	237
2550044	NM	school	3500900	55	ESPANOLA	350090000814	19	CARLOS F. VIGIL MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	235	235
2956410	NM	school	3501680	86	LOS LUNAS	350168000614	25	VALENCIA MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	234	234
2956540	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	233	233
2550294	NM	school	3501500	17	LAS CRUCES	350150000399	184	ZIA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	232	232
2956122	NM	school	3500900	55	ESPANOLA	350090000814	19	CARLOS F. VIGIL MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	232	232
2956350	NM	school	3501500	17	LAS CRUCES	350150001063	15	MESA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	232	232
2550097	NM	school	3500990	65	FARMINGTON	350099000293	162	TIBBETTS MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	230	230
2956365	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	230	230
2550469	NM	school	3502250	4	ROSWELL	350225000506	25	BERRENDO MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	228	228
2955841	NM	school	3500060	1	ALBUQUERQUE	350006000069	425	JEFFERSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	228	228
2956347	NM	school	3501500	17	LAS CRUCES	350150000388	86	LYNN MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	228	228
2956558	NM	school	3502250	4	ROSWELL	350225000522	125	SIERRA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	227	227
2550274	NM	school	3501500	17	LAS CRUCES	350150000388	86	LYNN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	226	226
2550488	NM	school	3502250	4	ROSWELL	350225000522	125	SIERRA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	226	226
2550084	NM	school	3500990	65	FARMINGTON	350099000286	58	HERMOSA MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	225	225
2956222	NM	school	3501110	43	GALLUP	350111000661	190	JOHN F. KENNEDY MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	225	225
2956276	NM	school	3501260	33	HOBBS	350126001067	8	HEIZER MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	223	223
2550292	NM	school	3501500	17	LAS CRUCES	350150000377	170	VISTA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	222	222
2550339	NM	school	3501680	86	LOS LUNAS	350168000614	25	VALENCIA MIDDLE SCHOOL	Public	Regular School	No	Middle	07	08	2020	grade_8	221	221
2549992	NM	school	3500570	12	CLOVIS	350057000218	91	MARSHALL MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	220	220
2550517	NM	school	3502370	71	SANTA FE	350237000610	110	EDWARD ORTIZ MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	219	219
2956029	NM	school	3500390	67	CENTRAL CONS.	350039000180	34	KIRTLAND MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	218	218
2956160	NM	school	3500990	65	FARMINGTON	350099000286	58	HERMOSA MIDDLE SCHOOL	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	217	217
2550203	NM	school	3501260	33	HOBBS	350126001067	8	HEIZER MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_8	216	216
2955848	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	215	215
2550181	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public	Regular School	No	Middle	07	08	2020	grade_8	213	213
2549872	NM	school	3500150	64	AZTEC	350015000136	17	C.V. KOOGLER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	212	212
2956077	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	212	212
2956254	NM	school	3501170	88	GRANTS	350117000331	56	LOS ALAMITOS MIDDLE	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_8	212	212
2549697	NM	school	3500060	1	ALBUQUERQUE	350006000617	407	CLEVELAND MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	211	211
2956498	NM	school	3502100	57	PORTALES	350210000489	123	PORTALES JR HIGH	Public - Junior High	Regular School	No	Middle	07	08	2021	grade_8	211	211
2955861	NM	school	3500060	1	ALBUQUERQUE	350006000081	435	MADISON MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_8	208	208
2550429	NM	school	3502100	57	PORTALES	350210000489	123	PORTALES JR HIGH	Public	Regular School	No	Middle	07	08	2020	grade_8	207	207
2550148	NM	school	3501110	43	GALLUP	350111000661	190	JOHN F. KENNEDY MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	206	206
2549997	NM	school	3500570	12	CLOVIS	350057000223	98	YUCCA MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_8	204	204
2955995	NM	school	3500240	66	BLOOMFIELD	350024000158	95	MESA ALTA JR HIGH	Public - Junior High	Regular School	No	Middle	07	08	2021	grade_8	203	203
2549909	NM	school	3500240	66	BLOOMFIELD	350024000158	95	MESA ALTA JR HIGH	Public	Regular School	No	Middle	07	08	2020	grade_8	201	201