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 "state" = :p0 order by ccd_school_high_grade 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
2540970	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	339	339
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
2541070	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	85	85
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
2541127	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	155	155
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
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
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
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
2541427	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	70	70
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
2541529	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	326	326
2541574	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	160	160
2541604	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	68	68
2541965	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2541986	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542031	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542065	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542121	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542122	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542146	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542151	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542154	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542159	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542422	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542505	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542524	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542569	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542599	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_full_day	0	0
2542960	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2542981	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543026	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543060	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543116	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543117	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543141	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543146	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543149	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543154	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543417	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543500	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543519	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543564	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543594	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2543955	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2543976	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544021	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544055	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544111	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544112	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544136	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544141	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544144	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544149	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544412	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544495	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544514	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544559	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544589	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2544950	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2544971	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545016	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545050	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545106	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545107	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545131	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545136	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545139	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545144	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545407	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545490	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545509	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545554	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545584	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2545945	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2545966	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546011	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546045	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546101	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546102	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546126	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546131	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546134	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546139	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546402	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546485	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546504	NM	school	3502250	4	ROSWELL	350225000519	122	PARKVIEW EARLY LITERACY CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546549	NM	school	3502370	71	SANTA FE	350237030025	168	NYE EARLY CHILDHOOD	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546579	NM	school	3502430	23	SILVER CITY	350243001141	12	SILVER SCHOLARS ACADEMY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2546940	NM	school	3500300	20	CARLSBAD	350030001148	58	HILLCREST PRESCHOOL	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2546961	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547006	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547040	NM	school	3500690	42	DEMING	350069000758	1	MY LITTLE SCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547096	NM	school	3500990	65	FARMINGTON	350099030006	55	FARMINGTON PRESCHOOL ACADEMY EAST	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547097	NM	school	3500990	65	FARMINGTON	350099001091	56	FARMINGTON PRESCHOOL ACADEMY WEST	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547121	NM	school	3501080	19	GADSDEN	350108001132	60	ANTHONY ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547126	NM	school	3501080	19	GADSDEN	350108001131	61	CHAPARRAL ON-TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547129	NM	school	3501080	19	GADSDEN	350108001129	62	GADSDEN ADMIN COMPLEX PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547134	NM	school	3501080	19	GADSDEN	350108001130	63	LA MESA ON TRACK PREK CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547397	NM	school	3501890	81	MORIARTY-EDGEWOOD	350189001145	151	EARLY CHILDHOOD CENTER	Public	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0