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 and (district_nces_id > :p2 or (district_nces_id = :p2 and rowid > :p1)) order by district_nces_id, 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
2543484	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	100	100
2543485	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1	0	0
2543486	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	110	110
2543487	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	107	107
2543488	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_1	0	0
2543489	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1	0	0
2543490	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	grade_1	137	137
2543491	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	151	151
2543493	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_1	0	0
2543494	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	93	93
2543495	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	grade_1	0	0
2543496	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	90	90
2543497	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_1	0	0
2543498	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_1	0	0
2543499	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1	120	120
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
2543501	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1	99	99
2544477	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	112	112
2544478	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_2	0	0
2544479	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	109	109
2544480	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2544481	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	125	125
2544482	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	120	120
2544483	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_2	0	0
2544484	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2544485	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	grade_2	133	133
2544486	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	166	166
2544488	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2544489	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	115	115
2544490	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	grade_2	0	0
2544491	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	105	105
2544492	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_2	0	0
2544493	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_2	0	0
2544494	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2	119	119
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
2544496	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2	111	111
2545472	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	131	131
2545473	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_3	0	0
2545474	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	138	138
2545475	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3	0	0
2545476	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	122	122
2545477	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	149	149
2545478	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_3	0	0
2545479	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3	0	0
2545480	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	grade_3	143	143
2545481	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	144	144
2545483	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_3	0	0
2545484	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	128	128
2545485	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	grade_3	0	0
2545486	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	92	92
2545487	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_3	0	0
2545488	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_3	0	0
2545489	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3	104	104
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
2545491	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3	133	133
2546467	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	148	148
2546468	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2546469	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	131	131
2546470	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4	0	0
2546471	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	137	137
2546472	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	136	136
2546473	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_4	0	0
2546474	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4	0	0
2546475	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	grade_4	171	171
2546476	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	160	160
2546478	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_4	0	0
2546479	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	113	113
2546480	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	grade_4	0	0
2546481	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	123	123
2546482	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_4	0	0
2546483	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_4	0	0
2546484	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4	105	105
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
2546486	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4	112	112
2547462	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	111	111
2547463	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_5	0	0
2547464	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	121	121
2547465	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5	0	0
2547466	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	161	161
2547467	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	148	148
2547468	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_5	0	0
2547469	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5	0	0
2547470	NM	school	3500010	83	RIO RANCHO	350001000952	12	MAGGIE CORDOVA ELEMENTARY SCHOOL	Public	Regular School	No	Elementary	KG	05	2020	grade_5	152	152
2547471	NM	school	3500010	83	RIO RANCHO	350001000710	375	MARTIN KING JR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	161	161
2547473	NM	school	3500010	83	RIO RANCHO	350001000739	105	MOUNTAIN VIEW MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_5	0	0
2547474	NM	school	3500010	83	RIO RANCHO	350001000650	319	PUESTA DEL SOL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	136	136
2547475	NM	school	3500010	83	RIO RANCHO	350001000954	18	RIO RANCHO CYBER ACADEMY	Public	Alternative School	No	High	06	12	2020	grade_5	0	0
2547476	NM	school	3500010	83	RIO RANCHO	350001000101	340	RIO RANCHO ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	106	106
2547477	NM	school	3500010	83	RIO RANCHO	350001000779	6	RIO RANCHO HIGH	Public	Regular School	No	High	09	12	2020	grade_5	0	0
2547478	NM	school	3500010	83	RIO RANCHO	350001000865	16	RIO RANCHO MIDDLE SCHOOL	Public	Regular School	No	Middle	06	08	2020	grade_5	0	0
2547479	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5	130	130
2547480	NM	school	3500010	83	RIO RANCHO	350001000953	17	SHINING STARS PRESCHOOL	Public	Special Education School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2547481	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5	140	140
2548457	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2548458	NM	school	3500010	83	RIO RANCHO	350001001024	11	CLEVELAND HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_6	0	0
2548459	NM	school	3500010	83	RIO RANCHO	350001000750	50	COLINAS DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2548460	NM	school	3500010	83	RIO RANCHO	350001000761	1	EAGLE RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6	329	329
2548461	NM	school	3500010	83	RIO RANCHO	350001030011	100	ENCHANTED HILLS ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2548462	NM	school	3500010	83	RIO RANCHO	350001000736	372	ERNEST STAPLETON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2548463	NM	school	3500010	83	RIO RANCHO	350001000805	13	INDEPENDENCE HIGH SCHOOL	Public	Alternative School	No	High	09	12	2020	grade_6	0	0
2548464	NM	school	3500010	83	RIO RANCHO	350001000682	481	LINCOLN MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_6	314	314