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 district 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
3055476	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2021	grade_7	7	7
3055477	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3214373	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	3	07	12	2015	grade_7	24	24
3214374	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	3	07	12	2016	grade_7	19	19
3214375	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2017	grade_7	17	17
3214376	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_7	20	20
3214377	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2019	grade_7	25	25
3214378	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2020	grade_7	20	20
3214379	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2015	grade_7	0	0
3214380	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2016	grade_7	0	0
3214381	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2017	grade_7	0	0
3214382	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_7	0	0
3214383	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2019	grade_7	0	0
3214384	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2020	grade_7	0	0
3057469	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2021	grade_7	0	0
3057470	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	120	120
3057471	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2021	grade_7	0	0
3057472	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2021	grade_7	0	0
3057473	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3226201	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2015	grade_7	0	0
3226202	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2016	grade_7	0	0
3226203	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2017	grade_7	0	0
3226204	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	grade_7	0	0
3226205	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2019	grade_7	0	0
3226206	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2020	grade_7	0	0
3226207	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	2	06	08	2015	grade_7	113	113
3226208	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	2	06	08	2016	grade_7	109	109
3226209	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2017	grade_7	121	121
3226210	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_7	120	120
3226211	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2019	grade_7	127	127
3226212	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2020	grade_7	154	154
3226213	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	1	02	05	2015	grade_7	0	0
3226214	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	1	02	05	2016	grade_7	0	0
3226215	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2017	grade_7	0	0
3226216	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2018	grade_7	0	0
3226217	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2019	grade_7	0	0
3226218	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2020	grade_7	0	0
3226219	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	1	KG	01	2015	grade_7	0	0
3226220	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	1	KG	01	2016	grade_7	0	0
3226221	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2017	grade_7	0	0
3226222	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_7	0	0
3226223	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2019	grade_7	0	0
3226224	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2020	grade_7	0	0
3226225	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	1	PK	PK	2016	grade_7	0	0
3226226	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Elementary	PK	PK	2017	grade_7	0	0
3226227	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_7	0	0
3226228	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	grade_7	0	0
3226229	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0	0
3057512	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2021	grade_7	25	25
3057513	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3226452	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	3	07	12	2015	grade_7	32	32
3226453	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	3	07	12	2016	grade_7	25	25
3226454	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2017	grade_7	25	25
3226455	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2018	grade_7	27	27
3226456	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2019	grade_7	16	16
3226457	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2020	grade_7	17	17
3226458	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	1	PK	06	2015	grade_7	0	0
3226459	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	1	PK	06	2016	grade_7	0	0
3226460	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	Elementary	PK	06	2017	grade_7	0	0
3226461	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2018	grade_7	0	0
3226462	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2019	grade_7	0	0
3226463	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_7	0	0
3055478	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2021	grade_7	0	0
3055479	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2021	grade_7	71	71
3055480	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3214385	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2015	grade_7	0	0
3214386	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2016	grade_7	0	0
3214387	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2017	grade_7	0	0
3214388	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2018	grade_7	0	0
3214389	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2019	grade_7	0	0
3214390	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2020	grade_7	0	0
3214391	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	2	05	08	2015	grade_7	70	70
3214392	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	2	05	08	2016	grade_7	67	67
3214393	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2017	grade_7	70	70
3214394	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2018	grade_7	60	60
3214395	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2019	grade_7	62	62
3214396	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2020	grade_7	74	74
3214397	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2015	grade_7	0	0
3214398	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2016	grade_7	0	0
3214399	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2017	grade_7	0	0
3214400	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2018	grade_7	0	0
3214401	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2019	grade_7	0	0
3214402	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2020	grade_7	0	0
3055898	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2021	grade_7	11	11
3055899	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3216874	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	3	07	12	2015	grade_7	9	9
3216875	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	3	07	12	2016	grade_7	15	15
3216876	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2017	grade_7	13	13
3216877	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2018	grade_7	17	17
3216878	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2019	grade_7	11	11
3216879	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2020	grade_7	12	12
3216880	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	1	PK	06	2015	grade_7	0	0
3216881	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	1	PK	06	2016	grade_7	0	0
3216882	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2017	grade_7	0	0
3216883	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2018	grade_7	0	0
3216884	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2019	grade_7	0	0
3216885	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2020	grade_7	0	0
3057371	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	High	09	12	2021	grade_7	0	0
3057372	MO	school	2932220	101105	WINONA R-III	293222002259	4020	WINONA ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	39	39
3225615	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	3	09	12	2015	grade_7	0	0
3225616	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	3	09	12	2016	grade_7	0	0