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
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
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
2540970	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	339	339
2541529	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	326	326
2947209	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	227	227
2541393	NM	school	3501740	31	LOVINGTON	350174000447	78	LLANO ELEMENTARY	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	199	199
2947752	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	197	197
2541151	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	163	163
2947384	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	162	162
2541574	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	160	160
2947387	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	157	157
2541127	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	155	155
2541126	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	151	151
2541469	NM	school	3502100	57	PORTALES	350210000485	28	BROWN EARLY CHILDHOOD CENTER	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	151	151
2541299	NM	school	3501500	17	LAS CRUCES	350150000794	6	CESAR CHAVEZ ELEMENTARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	144	144
2540943	NM	school		61	BERNALILLO		29	LA ESCUELITA EARLY CHILDHOOD	Off-Site						2020	pre_kindergarten	140	140
2947795	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	136	136
2541159	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	130	130
2946953	NM	school	3500030	46	ALAMOGORDO	350003001158	182	STEPPING STONES PRESCHOOL	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	128	128
2947379	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	126	126
2947692	NM	school	3502100	57	PORTALES	350210000485	28	BROWN EARLY CHILDHOOD CENTER	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	124	124
2540950	NM	school	3500240	66	BLOOMFIELD	350024000609	30	BLOOMFIELD EARLY CHILDHOOD CENTER	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	123	123
2947526	NM	school	3501500	17	LAS CRUCES	350150000794	6	CESAR CHAVEZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	120	120
2947181	NM	school		61	BERNALILLO		29	LA ESCUELITA EARLY CHILDHOOD	Off-Site - Prekindergarten						2021	pre_kindergarten	119	119
2947617	NM	school	3501740	31	LOVINGTON	350174000447	78	LLANO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	112	112
2540850	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	109	109
2540710	NM	school	3500030	46	ALAMOGORDO	350003000010	114	NORTH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	106	106
2541295	NM	school	3501500	17	LAS CRUCES	350150000396	172	BOOKER T. WASHINGTON	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	104	104
2947356	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	102	102
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
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
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
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
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
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
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
2947765	NM	school	3502310	36	RUIDOSO	350231000464	145	SIERRA VISTA PRIMARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	53	53
2541486	NM	school	3502190	9	RATON	350219000499	80	LONGFELLOW ELEMENTARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	52	52
2947484	NM	school	3501260	33	HOBBS	350126001111	177	MURRAY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	52	52
2540821	NM	school	3500060	1	ALBUQUERQUE	350006000895	260	MANZANO MESA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	51	51
2540857	NM	school	3500060	1	ALBUQUERQUE	350006001033	392	RUDOLFO ANAYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	51	51
2541243	NM	school	3501260	33	HOBBS	350126000357	172	BOOKER T. WASHINGTON ELEMENTARY	Public	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	51	51
2541369	NM	school	3501680	86	LOS LUNAS	350168000436	28	BOSQUE FARMS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	50	50
2946995	NM	school	3500060	1	ALBUQUERQUE	350006000681	203	DENNIS CHAVEZ ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	50	50
2540714	NM	school	3500060	1	ALBUQUERQUE	350006000017	321	A. MONTOYA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	49	49
2947561	NM	school	3501500	17	LAS CRUCES	350150000394	150	UNIVERSITY HILLS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	49	49
2947813	NM	school	3500112	505	SCHOOL OF DREAMS ACADEMY	350011201051	1	SCHOOL OF DREAMS ACADEMY	Charter - High School	Regular School	Yes	Other	PK	12	2021	pre_kindergarten	49	49
2540743	NM	school	3500060	1	ALBUQUERQUE	350006000040	237	COCHITI ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	48	48
2540921	NM	school	3500150	64	AZTEC	350015000137	99	MCCOY AVENUE ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	48	48
2541323	NM	school	3501500	17	LAS CRUCES	350150000392	97	MESILLA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	48	48
2947687	NM	school	3502070	72	POJOAQUE	350207000482	123	PABLO ROYBAL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	48	48
2540920	NM	school	3500150	64	AZTEC	350015000139	136	LYDIA RIPPEY ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	47	47
2541611	NM	school	3502460	74	SOCORRO	350246000789	1	PARKVIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	47	47
2541237	NM	school	3501230	18	HATCH	350123000342	53	GARFIELD ELEMENTARY	Public	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	46	46
2541365	NM	school	3501650	41	LOS ALAMOS	350165000434	127	PINON ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	46	46
2947027	NM	school	3500060	1	ALBUQUERQUE	350006001043	395	HELEN CORDERO PRIMARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	46	46
2947228	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public - Prekindergarten	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	46	46
2541374	NM	school	3501680	86	LOS LUNAS	350168000258	82	LOS LUNAS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	45	45
2946946	NM	school	3500030	46	ALAMOGORDO	350003000006	58	HOLLOMAN ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	45	45
2947028	NM	school	3500060	1	ALBUQUERQUE	350006001079	611	HIGHLAND AUTISM CENTER	Public - Special Education	Special Education School	No	Other	PK	12	2021	pre_kindergarten	45	45
2540704	NM	school	3500030	46	ALAMOGORDO	350003000006	58	HOLLOMAN ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	44	44
2541045	NM	school	3500600	24	COBRE CONS.	350060000226	33	CENTRAL ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	44	44
2541101	NM	school	3500900	55	ESPANOLA	350090000685	142	LOS NINOS ELEMENTARY	Public	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	44	44