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
3064728	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2021	grade_11	16	16
3064729	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	PK	06	2021	grade_11	0	0
3269613	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	3	07	12	2015	grade_11	18	18
3269614	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	3	07	12	2016	grade_11	23	23
3269615	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2017	grade_11	14	14
3269616	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_11	19	19
3269617	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2019	grade_11	19	19
3269618	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2020	grade_11	20	20
3269619	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2015	grade_11	0	0
3269620	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2016	grade_11	0	0
3269621	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2017	grade_11	0	0
3269622	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_11	0	0
3269623	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2019	grade_11	0	0
3269624	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2020	grade_11	0	0
3066721	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2021	grade_11	110	110
3066722	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2021	grade_11	0	0
3066723	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_11	0	0
3066724	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_11	0	0
3066725	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_11	0	0
3281441	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2015	grade_11	100	100
3281442	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2016	grade_11	92	92
3281443	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2017	grade_11	106	106
3281444	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	grade_11	97	97
3281445	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2019	grade_11	114	114
3281446	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2020	grade_11	105	105
3281447	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	2	06	08	2015	grade_11	0	0
3281448	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	2	06	08	2016	grade_11	0	0
3281449	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2017	grade_11	0	0
3281450	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_11	0	0
3281451	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2019	grade_11	0	0
3281452	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2020	grade_11	0	0
3281453	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_11	0	0
3281454	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_11	0	0
3281455	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_11	0	0
3281456	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_11	0	0
3281457	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_11	0	0
3281458	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_11	0	0
3281459	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_11	0	0
3281460	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_11	0	0
3281461	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_11	0	0
3281462	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_11	0	0
3281463	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_11	0	0
3281464	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_11	0	0
3281465	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	1	PK	PK	2016	grade_11	0	0
3281466	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Elementary	PK	PK	2017	grade_11	0	0
3281467	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_11	0	0
3281468	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	grade_11	0	0
3281469	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_11	0	0
3066764	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2021	grade_11	20	20
3066765	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2021	grade_11	0	0
3281692	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	3	07	12	2015	grade_11	26	26
3281693	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	3	07	12	2016	grade_11	23	23
3281694	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2017	grade_11	35	35
3281695	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2018	grade_11	25	25
3281696	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2019	grade_11	31	31
3281697	MO	school	2932300	113001	WORTH CO. R-III	293230002264	1050	WORTH CO. HIGH	Regular School	No	High	07	12	2020	grade_11	27	27
3281698	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	1	PK	06	2015	grade_11	0	0
3281699	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	1	PK	06	2016	grade_11	0	0
3281700	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEM.	Regular School	No	Elementary	PK	06	2017	grade_11	0	0
3281701	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2018	grade_11	0	0
3281702	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
3281703	MO	school	2932300	113001	WORTH CO. R-III	293230002263	4020	WORTH CO. ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_11	0	0
3064730	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2021	grade_11	61	61
3064731	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2021	grade_11	0	0
3064732	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2021	grade_11	0	0
3269625	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2015	grade_11	63	63
3269626	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2016	grade_11	74	74
3269627	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2017	grade_11	74	74
3269628	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2018	grade_11	53	53
3269629	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2019	grade_11	68	68
3269630	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2020	grade_11	58	58
3269631	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	2	05	08	2015	grade_11	0	0
3269632	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	2	05	08	2016	grade_11	0	0
3269633	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2017	grade_11	0	0
3269634	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2018	grade_11	0	0
3269635	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2019	grade_11	0	0
3269636	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	Middle	05	08	2020	grade_11	0	0
3269637	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2015	grade_11	0	0
3269638	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2016	grade_11	0	0
3269639	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2017	grade_11	0	0
3269640	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2018	grade_11	0	0
3269641	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
3269642	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
3065150	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2021	grade_11	15	15
3065151	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2021	grade_11	0	0
3272114	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	3	07	12	2015	grade_11	16	16
3272115	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	3	07	12	2016	grade_11	14	14
3272116	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2017	grade_11	10	10
3272117	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2018	grade_11	20	20
3272118	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2019	grade_11	12	12
3272119	MO	school	2932250	31117	WINSTON R-VI	293225002262	1050	WINSTON HIGH	Regular School	No	High	07	12	2020	grade_11	16	16
3272120	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	1	PK	06	2015	grade_11	0	0
3272121	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	1	PK	06	2016	grade_11	0	0
3272122	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2017	grade_11	0	0
3272123	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2018	grade_11	0	0
3272124	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
3272125	MO	school	2932250	31117	WINSTON R-VI	293225002261	4020	WINSTON ELEM.	Regular School	No	Elementary	PK	06	2020	grade_11	0	0
3066623	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	High	09	12	2021	grade_11	38	38
3066624	MO	school	2932220	101105	WINONA R-III	293222002259	4020	WINONA ELEM.	Regular School	No	Elementary	PK	08	2021	grade_11	0	0
3280855	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	3	09	12	2015	grade_11	32	32
3280856	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	3	09	12	2016	grade_11	41	41