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 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
2540991	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	99	99
2541036	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	99	99
2947355	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public - Special Education	Special Education School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	96	96
2540881	NM	school	3500060	1	ALBUQUERQUE	350006000115	370	VALLE VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	95	95
2540910	NM	school	3500120	22	ARTESIA	350012000620	54	GRAND HEIGHTS EARLY CHILDHOOD	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	95	95
2947188	NM	school	3500240	66	BLOOMFIELD	350024000609	30	BLOOMFIELD EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	94	94
2541164	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	90	90
2541080	NM	school	3500810	54	DULCE	350081000252	44	DULCE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	9	9
2541104	NM	school		55	ESPANOLA		10	SAN JUAN HEADSTART	Off-Site						2020	pre_kindergarten	9	9
2541175	NM	school	3501080	19	GADSDEN	350108000905	9	SUNRISE ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	9	9
2541436	NM	school	3501920	28	MOSQUERO	350192000470	100	MOSQUERO ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	9	9
2541660	NM	school		47	TULAROSA		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	9	9
2947127	NM	school	3500060	1	ALBUQUERQUE	350006000120	376	WHERRY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	9	9
2947243	NM	school	3500420	53	CHAMA	350042000195	64	TIERRA AMARILLA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	9	9
2947244	NM	school	3500480	8	CIMARRON	350048000197	33	CIMARRON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	9	9
2947282	NM	school	3500600	24	COBRE CONS.	350060000229	143	SAN LORENZO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	9	9
2947447	NM	school		88	GRANTS		4	GRANTS HEAD START	Off-Site - Prekindergarten						2021	pre_kindergarten	9	9
2947646	NM	school	3501860	44	MORA	350186000636	59	HOLMAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	KG	2021	pre_kindergarten	9	9
2947662	NM	school	3501950	82	MOUNTAINAIR	350195000472	105	MOUNTAINAIR ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	9	9
2947710	NM	school	3500143	539	RED RIVER VALLEY CHARTER SCHOOL	350014300845	1	RED RIVER VALLEY CHARTER SCHOOL	Charter - Elementary School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten	9	9
2947751	NM	school	3502250	4	ROSWELL	350225000512	52	NANCY LOPEZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	9	9
2540829	NM	school		1	ALBUQUERQUE		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	88	88
2540849	NM	school	3500060	1	ALBUQUERQUE	350006000097	333	PAJARITO ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	88	88
2947120	NM	school	3500060	1	ALBUQUERQUE	350006000115	370	VALLE VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	88	88
2947392	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	88	88
2541070	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	85	85
2947090	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	85	85
2947269	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	83	83
2947522	NM	school	3501500	17	LAS CRUCES	350150000396	172	BOOKER T. WASHINGTON	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	80	80
2540903	NM	school	3500090	30	ANIMAS	350009000618	16	ANIMAS ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	8	8
2541073	NM	school	3500720	85	DES MOINES	350072000245	44	DES MOINES ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	8	8
2541083	NM	school		54	DULCE		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	8	8
2541354	NM	school		29	LORDSBURG		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	8	8
2541595	NM	school	3502430	23	SILVER CITY	350243000559	37	CLIFF ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	8	8
2541685	NM	school		89	ZUNI		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	8	8
2947230	NM	school	3500390	67	CENTRAL CONS.	350039000182	114	NASCHITTI ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2947231	NM	school	3500390	67	CENTRAL CONS.	350039000183	116	NEWCOMB ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2947240	NM	school	3500420	53	CHAMA	350042000192	36	CHAMA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2947304	NM	school	3500720	85	DES MOINES	350072000245	44	DES MOINES ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	8	8
2947316	NM	school	3500840	58	ELIDA	350084000255	47	ELIDA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	8	8
2947374	NM	school	3501050	16	FT SUMNER	350105000296	51	FORT SUMNER ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2947441	NM	school	3501140	15	GRADY	350114000325	55	GRADY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2947683	NM	school	3502040	77	PENASCO	350204000480	121	PENASCO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	8	8
2947699	NM	school	3502130	3	QUEMADO	350213000492	129	QUEMADO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	8	8
2947815	NM	school	3502430	23	SILVER CITY	350243000559	37	CLIFF ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	8	8
2947900	NM	school	3501560	68	WEST LAS VEGAS	350156000415	50	VALLEY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8	8
2540827	NM	school	3500060	1	ALBUQUERQUE	350006000085	307	MCCOLLUM ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	79	79
2541544	NM	school	3502310	36	RUIDOSO	350231000464	145	SIERRA VISTA PRIMARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	79	79
2947069	NM	school		1	ALBUQUERQUE		992	MISC PRESCHOOL PROGRAM	Off-Site - Prekindergarten						2021	pre_kindergarten	78	78
2541257	NM	school	3501260	33	HOBBS	350126001111	177	MURRAY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	76	76
2540736	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	75	75
2541156	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	74	74
2541427	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	70	70
2946978	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	70	70
2540940	NM	school	3500210	61	BERNALILLO	350021000150	20	COCHITI ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	7	7
2541007	NM	school	3500420	53	CHAMA	350042000195	64	TIERRA AMARILLA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	7	7
2541009	NM	school	3500480	8	CIMARRON	350048000197	33	CIMARRON ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	7	7
2541091	NM	school		55	ESPANOLA		20	CONJUNTO PRESCHOOL	Off-Site						2020	pre_kindergarten	7	7
2541338	NM	school	3501500	17	LAS CRUCES	350150000397	177	WHITE SANDS ELEMENTARY	Public	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	7	7
2541424	NM	school		44	MORA		992	MISC PRESCHOOL PROGRAM	Off-Site						2020	pre_kindergarten	7	7
2541455	NM	school	3500014	93	NM SCHOOL FOR THE DEAF	350001400972	150	NM SCHOOL FOR THE DEAF	State Supported	Special Education School	No	Other	PK	12	2020	pre_kindergarten	7	7
2947202	NM	school		20	CARLSBAD		4	CARLSBAD HEADSTART	Off-Site - Prekindergarten						2021	pre_kindergarten	7	7
2947473	NM	school	3501260	33	HOBBS	350126000347	46	EDISON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	7	7
2947573	NM	school	3501590	51	LOGAN	350159000420	80	LOGAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	7	7
2947580	NM	school		29	LORDSBURG		992	MISC PRESCHOOL PROGRAM	Off-Site - Prekindergarten						2021	pre_kindergarten	7	7
2947636	NM	school	3501980	78	MESA VISTA	350198000474	47	EL RITO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	7	7
2947660	NM	school	3501920	28	MOSQUERO	350192000470	100	MOSQUERO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	7	7
2947891	NM	school	3502730	45	WAGON MOUND	350273000611	172	WAGON MOUND ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	7	7
2947908	NM	school		89	ZUNI		992	MISC PRESCHOOL PROGRAM	Off-Site - Prekindergarten						2021	pre_kindergarten	7	7
2947542	NM	school	3501500	17	LAS CRUCES	350150000385	61	JORNADA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	69	69
2540790	NM	school	3500060	1	ALBUQUERQUE	350006000064	273	HODGIN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	68	68
2541604	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	68	68
2540755	NM	school	3500060	1	ALBUQUERQUE	350006000681	203	DENNIS CHAVEZ ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	67	67
2540824	NM	school	3500060	1	ALBUQUERQUE	350006000083	364	MARK TWAIN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	66	66
2541263	NM	school	3501260	33	HOBBS	350126000358	176	WILL ROGERS ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	66	66
2541464	NM	school	3502070	72	POJOAQUE	350207000482	123	PABLO ROYBAL ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	65	65
2541654	NM	school	3502610	73	TRUTH OR CONS.	350261000594	162	T OR C ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	65	65
2947531	NM	school	3501500	17	LAS CRUCES	350150000382	48	DONA ANA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	64	64
2947089	NM	school	3500060	1	ALBUQUERQUE	350006000097	333	PAJARITO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	62	62
2947148	NM	school	3500120	22	ARTESIA	350012000620	54	GRAND HEIGHTS EARLY CHILDHOOD	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	62	62
2541510	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	612	612
2540934	NM	school	3500180	87	BELEN	350018000146	45	RIO GRANDE ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	61	61
2540804	NM	school	3500060	1	ALBUQUERQUE	350006000072	279	KIRTLAND ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	60	60
2541012	NM	school	3500480	8	CIMARRON	350048000199	47	EAGLE NEST ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	6	6
2541171	NM	school	3501080	19	GADSDEN	350108000904	8	SANTA TERESA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	6	6
2541343	NM	school	3501530	69	LAS VEGAS CITY	350153000863	3	LVCS EARLY CHILDHOOD	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	6	6
2947141	NM	school	3500090	30	ANIMAS	350009000618	16	ANIMAS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	6	6
2947335	NM	school		55	ESPANOLA		10	SAN JUAN HEADSTART	Off-Site - Prekindergarten						2021	pre_kindergarten	6	6
2947767	NM	school	3502340	52	SAN JON	350234000532	144	SAN JON ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	6	6
2947860	NM	school	3502550	35	TATUM	350255000585	162	TATUM ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	6	6
2947889	NM	school	3500001	26	VAUGHN	350000100607	168	VAUGHN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	6	6
2541315	NM	school	3501500	17	LAS CRUCES	350150000385	61	JORNADA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	59	59
2541336	NM	school	3501500	17	LAS CRUCES	350150000395	166	VALLEY VIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	58	58
2947876	NM	school	3502610	73	TRUTH OR CONS.	350261000594	162	T OR C ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	58	58
2947734	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public - Special Education	Special Education School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	577	577
2540997	NM	school	3500390	67	CENTRAL CONS.	350039000184	152	NIZHONI ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	57	57
2541357	NM	school	3501650	41	LOS ALAMOS	350165000428	21	BARRANCA MESA ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	56	56
2947562	NM	school	3501500	17	LAS CRUCES	350150000395	166	VALLEY VIEW ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	56	56
2540787	NM	school	3500060	1	ALBUQUERQUE	350006001043	395	HELEN CORDERO PRIMARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	54	54
2541118	NM	school	3500960	32	EUNICE	350096000624	48	METTIE JORDAN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	54	54
2947044	NM	school	3500060	1	ALBUQUERQUE	350006000072	279	KIRTLAND ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	53	53