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 "year" = :p2 and (ccd_school_low_grade > :p4 or (ccd_school_low_grade = :p4 and rowid > :p3)) order by ccd_school_low_grade, 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
2544584	NM	school		23	SILVER CITY		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544587	NM	school		23	SILVER CITY		997	MISC PRIVATE	Private						2020	grade_2	7	7
2544593	NM	school		74	SOCORRO		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544595	NM	school		74	SOCORRO		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_2	0	0
2544605	NM	school		10	SPRINGER		3	HIGH PLNS REC HEADSTART	Off-Site						2020	grade_2	0	0
2544613	NM	school		76	TAOS		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544614	NM	school		76	TAOS		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_2	0	0
2544637	NM	school		73	TRUTH OR CONS.		3	MANZANO CHRISTIAN	Private						2020	grade_2	0	0
2544641	NM	school		49	TUCUMCARI		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544645	NM	school		47	TULAROSA		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_2	0	0
2544656	NM	school		68	WEST LAS VEGAS		25	CARE	Off-Site						2020	grade_2	0	0
2544658	NM	school		68	WEST LAS VEGAS		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544665	NM	school		68	WEST LAS VEGAS		1	WEST LAS VEGAS HEAD START	Off-Site						2020	grade_2	0	0
2544669	NM	school		89	ZUNI		998	HOMEBOUND	Off-Site						2020	grade_2	0	0
2544670	NM	school		89	ZUNI		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	grade_2	0	0
2544671	NM	school		89	ZUNI		997	MISC PRIVATE	Private						2020	grade_2	14	14
2543681	NM	school	3500122	516	ABQ SCHOOL OF EXCELLENCE	350012201071	1	ABQ SCHOOL OF EXCELLENCE	Charter	Regular School	Yes	Other	01	12	2020	grade_2	55	55
2543896	NM	school	3500120	22	ARTESIA	350012000129	56	HERMOSA ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	61	61
2543899	NM	school	3500120	22	ARTESIA	350012000672	1	YESO ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	89	89
2543900	NM	school	3500120	22	ARTESIA	350012000133	183	YUCCA ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	70	70
2543920	NM	school	3500180	87	BELEN	350018000867	6	THE FAMILY SCHOOL	Public	Alternative School	No	Elementary	01	08	2020	grade_2	14	14
2543934	NM	school	3500240	66	BLOOMFIELD	350024000155	25	BLANCO ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	23	23
2543937	NM	school	3500240	66	BLOOMFIELD	350024000157	33	CENTRAL PRIMARY	Public	Regular School	No	Elementary	01	03	2020	grade_2	177	177
2543951	NM	school	3500300	20	CARLSBAD	350030000463	38	CRAFT ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	32	32
2543952	NM	school	3500300	20	CARLSBAD	350030001118	160	DESERT WILLOW ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	153	153
2543954	NM	school	3500300	20	CARLSBAD	350030001154	162	EDISON ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	30	30
2543958	NM	school	3500300	20	CARLSBAD	350030000174	144	JOE STANLEY SMITH ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	67	67
2543959	NM	school	3500300	20	CARLSBAD	350030000170	100	MONTERREY ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	66	66
2543960	NM	school	3500300	20	CARLSBAD	350030001123	161	OCOTILLO ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	127	127
2543962	NM	school	3500300	20	CARLSBAD	350030000175	158	SUNSET ELEMENTARY	Public	Regular School	No	Elementary	01	05	2020	grade_2	80	80
2544085	NM	school	3500900	55	ESPANOLA	350090000266	48	JAMES RODRIGUEZ ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	51	51
2544096	NM	school	3500930	80	ESTANCIA	350093000278	169	LOWER ELEMENTARY	Public	Regular School	No	Elementary	01	03	2020	grade_2	49	49
2544360	NM	school	3501680	86	LOS LUNAS	350168000866	18	LOS LUNAS FAMILY SCHOOL	Public	Alternative School	No	Elementary	01	08	2020	grade_2	1	1
2544377	NM	school	3501740	31	LOVINGTON	350174000446	76	LEA ELEMENTARY	Public	Regular School	No	Elementary	01	01	2020	grade_2	0	0
2544410	NM	school	3501860	44	MORA	350186000637	104	MORA ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	32	32
2544455	NM	school	3502100	57	PORTALES	350210000486	32	JAMES ELEMENTARY	Public	Regular School	No	Elementary	01	02	2020	grade_2	184	184
2544582	NM	school	3502430	23	SILVER CITY	350243000566	123	G.W.STOUT ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	69	69
2544583	NM	school	3502430	23	SILVER CITY	350243000561	157	HARRISON SCHMITT ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	55	55
2544585	NM	school	3502430	23	SILVER CITY	350243000562	115	JOSE BARRIOS ELEMENTARY	Public	Regular School	No	Elementary	01	06	2020	grade_2	42	42
2544015	NM	school	3500570	12	CLOVIS	350057001155	81	CMS IACADEMY AT LINCOLN JACKSON	Public	Regular School	No	Other	02	12	2020	grade_2	6	6
2544373	NM	school	3501740	31	LOVINGTON	350174000449	123	BEN ALEXANDER ELEMENTARY	Public	Regular School	No	Elementary	02	02	2020	grade_2	246	246
2544657	NM	school	3501560	68	WEST LAS VEGAS	350156000411	112	DON CECILIO MARTINEZ ELEMENTARY	Public	Regular School	No	Elementary	02	03	2020	grade_2	103	103
2543752	NM	school	3500060	1	ALBUQUERQUE	350006000896	262	EDWARD GONZALES ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_2	0	0
2543922	NM	school	3500210	61	BERNALILLO	350021000152	136	BERNALILLO ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_2	0	0
2544227	NM	school	3501230	18	HATCH	350123000753	1	RIO GRANDE ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_2	0	0
2544318	NM	school	3501500	17	LAS CRUCES	350150000730	140	SUNRISE ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_2	0	0
2544375	NM	school	3501740	31	LOVINGTON	350174000445	68	JEFFERSON ELEMENTARY	Public	Regular School	No	Elementary	03	03	2020	grade_2	0	0
2544460	NM	school	3502100	57	PORTALES	350210000417	160	VALENCIA ELEMENTARY	Public	Regular School	No	Elementary	03	04	2020	grade_2	0	0
2544473	NM	school	3502190	9	RATON	350219000501	135	RATON INTERMEDIATE	Public	Regular School	No	Elementary	03	06	2020	grade_2	0	0
2544530	NM	school	3502310	36	RUIDOSO	350231000530	160	WHITE MOUNTAIN ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_2	0	0
2544607	NM	school	3502490	10	SPRINGER	350249000576	58	WILFERTH ELEMENTARY	Public	Regular School	No	Elementary	03	06	2020	grade_2	0	0
2544648	NM	school	3502670	47	TULAROSA	350267000968	160	TULAROSA INTERMEDIATE	Public	Regular School	No	Elementary	03	06	2020	grade_2	0	0
2543908	NM	school	3500150	64	AZTEC	350015000138	123	PARK AVENUE ELEMENTARY	Public	Regular School	No	Elementary	04	05	2020	grade_2	0	0
2543913	NM	school	3500180	87	BELEN	350018000142	34	CENTRAL ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2543940	NM	school	3500240	66	BLOOMFIELD	350024000651	125	NAABA ANI ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2544098	NM	school	3500930	80	ESTANCIA	350093000791	1	UPPER ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2544331	NM	school	3501530	69	LAS VEGAS CITY	350153000721	54	SIERRA VISTA ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2544384	NM	school	3501740	31	LOVINGTON	350174000451	181	YARBRO ELEMENTARY	Public	Regular School	No	Elementary	04	05	2020	grade_2	0	0
2544401	NM	school	3501980	78	MESA VISTA	350198000476	118	OJO CALIENTE ELEMENTARY	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2544427	NM	school	3500160	554	NEW MEXICO CONNECTIONS ACADEMY	350016001096	1	NEW MEXICO CONNECTIONS ACADEMY	Charter	Regular School	Yes	Other	04	12	2020	grade_2	0	0
2544451	NM	school	3502070	72	POJOAQUE	350207000723	128	POJOAQUE INTERMEDIATE	Public	Regular School	No	Elementary	04	05	2020	grade_2	0	0
2544465	NM	school	3502160	79	QUESTA	350216000495	3	ALTA VISTA INTERMEDIATE	Public	Regular School	No	Middle	04	06	2020	grade_2	0	0
2544602	NM	school	3500136	530	SOUTHWEST PREPARATORY LEARNING CENTER	350013600927	1	SOUTHWEST PREPARATORY LEARNING CENTER	Charter	Regular School	Yes	Middle	04	08	2020	grade_2	0	0
2544638	NM	school	3502610	73	TRUTH OR CONS.	350261000435	60	SIERRA ELEMENTARY	Public	Regular School	No	Elementary	04	05	2020	grade_2	0	0
2544661	NM	school	3501560	68	WEST LAS VEGAS	350156000412	125	TONY SERNA JR. ELEMENTARY	Public	Regular School	No	Elementary	04	04	2020	grade_2	0	0
2543865	NM	school	3500060	1	ALBUQUERQUE	350006000811	27	TWENTY-FIRST CENTURY	Charter	Regular School	Yes	Middle	05	08	2020	grade_2	0	0
2543889	NM	school	3500090	30	ANIMAS	350009030019	20	ANIMAS MIDDLE	Public	Regular School	No	Middle	05	06	2020	grade_2	0	0
2543996	NM	school	3500480	8	CIMARRON	350048000699	36	CIMARRON MIDDLE	Public	Regular School	No	Middle	05	08	2020	grade_2	0	0
2543998	NM	school	3500480	8	CIMARRON	350048000302	48	EAGLE NEST MIDDLE	Public	Regular School	No	Middle	05	08	2020	grade_2	0	0
2544003	NM	school	3500510	84	CLAYTON	350051000205	45	KISER ELEMENTARY	Public	Regular School	No	Middle	05	06	2020	grade_2	0	0
2544130	NM	school	3501020	59	FLOYD	350102000770	1	FLOYD MIDDLE	Public	Regular School	No	Middle	05	08	2020	grade_2	0	0
2544336	NM	school	3501620	29	LORDSBURG	350162000422	34	CENTRAL ELEMENTARY	Public	Regular School	No	Middle	05	06	2020	grade_2	0	0
2544456	NM	school	3502100	57	PORTALES	350210001073	155	LINDSEY-STEINER ELEMENTARY	Public	Regular School	No	Middle	05	06	2020	grade_2	0	0
2544600	NM	school	3500183	576	SOLARE COLLEGIATE CHARTER SCHOOL	350018301143	1	SOLARE COLLEGIATE CHARTER SCHOOL	Charter	Regular School	Yes	Middle	05	06	2020	grade_2	0	0
2544621	NM	school	3500118	510	TAOS ACADEMY	350011801055	1	TAOS ACADEMY	Charter	Regular School	Yes	High	05	12	2020	grade_2	0	0
2544662	NM	school	3501560	68	WEST LAS VEGAS	350156000635	157	UNION ELEMENTARY	Public	Regular School	No	Middle	05	05	2020	grade_2	0	0
2543686	NM	school	3500030	46	ALAMOGORDO	350003000003	33	CHAPARRAL MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543690	NM	school	3500030	46	ALAMOGORDO	350003000007	37	HOLLOMAN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543694	NM	school	3500030	46	ALAMOGORDO	350003000798	3	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543727	NM	school	3500060	1	ALBUQUERQUE	350006000617	407	CLEVELAND MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543737	NM	school	3500060	1	ALBUQUERQUE	350006001031	769	COTTONWOOD CLASSICAL PREP	Charter	Regular School	Yes	High	06	12	2020	grade_2	0	0
2543741	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543753	NM	school	3500060	1	ALBUQUERQUE	350006000049	480	EISENHOWER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543757	NM	school	3500060	1	ALBUQUERQUE	350006000052	450	ERNIE PYLE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543760	NM	school	3500060	1	ALBUQUERQUE	350006000056	410	GARFIELD MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543766	NM	school	3500060	1	ALBUQUERQUE	350006000058	413	GRANT MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543768	NM	school	3500060	1	ALBUQUERQUE	350006000060	415	HARRISON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543770	NM	school	3500060	1	ALBUQUERQUE	350006000062	416	HAYES MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543777	NM	school	3500060	1	ALBUQUERQUE	350006000066	418	HOOVER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543781	NM	school	3500060	1	ALBUQUERQUE	350006000068	420	JACKSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543782	NM	school	3500060	1	ALBUQUERQUE	350006000825	490	JAMES MONROE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543784	NM	school	3500060	1	ALBUQUERQUE	350006000069	425	JEFFERSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543785	NM	school	3500060	1	ALBUQUERQUE	350006000812	445	JIMMY CARTER MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543786	NM	school	3500060	1	ALBUQUERQUE	350006000019	405	JOHN ADAMS MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543788	NM	school	3500060	1	ALBUQUERQUE	350006000071	427	KENNEDY MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543791	NM	school	3500060	1	ALBUQUERQUE	350006000065	485	L.B. JOHNSON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543792	NM	school	3500060	1	ALBUQUERQUE	350006000875	61	LA ACADEMIA DE ESPERANZA	Charter	Regular School	Yes	High	06	12	2020	grade_2	0	0
2543804	NM	school	3500060	1	ALBUQUERQUE	350006000081	435	MADISON MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543813	NM	school	3500060	1	ALBUQUERQUE	350006000615	440	MCKINLEY MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543836	NM	school	3500060	1	ALBUQUERQUE	350006000098	448	POLK MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2543837	NM	school	3500060	1	ALBUQUERQUE	350006000822	47	PUBLIC ACADEMY FOR PERFORMING ARTS	Charter	Regular School	Yes	High	06	12	2020	grade_2	0	0