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 and (ccd_school_low_grade > :p3 or (ccd_school_low_grade = :p3 and rowid > :p2)) order by ccd_school_low_grade, 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
3255440	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	05	2020	grade_10	0	0
3255446	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	01	05	2020	grade_10	0	0
3255740	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	Elementary	01	05	2018	grade_10	0	0
3255741	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	Elementary	01	05	2019	grade_10	0	0
3255941	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2015	grade_10	0	0
3255942	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2016	grade_10	0	0
3255943	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2017	grade_10	6	6
3255944	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2018	grade_10	0	0
3255945	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_10	5	5
3255946	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2020	grade_10	5	5
3256130	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2015	grade_10	0	0
3256131	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2016	grade_10	0	0
3256132	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2017	grade_10	0	0
3256133	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2018	grade_10	0	0
3256134	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2019	grade_10	0	0
3256135	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2020	grade_10	0	0
3256346	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	1	01	04	2015	grade_10	0	0
3256347	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	1	01	04	2016	grade_10	0	0
3256348	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2017	grade_10	0	0
3256349	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2018	grade_10	0	0
3256350	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2019	grade_10	0	0
3256351	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2020	grade_10	0	0
3256358	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	1	01	04	2015	grade_10	0	0
3256359	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	1	01	04	2016	grade_10	0	0
3256360	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	03	2017	grade_10	0	0
3256361	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	03	2018	grade_10	0	0
3256362	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	04	2019	grade_10	0	0
3256363	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	05	2020	grade_10	0	0
3256370	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	1	01	04	2015	grade_10	0	0
3256371	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	1	01	04	2016	grade_10	0	0
3256372	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2017	grade_10	0	0
3256373	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2018	grade_10	0	0
3256374	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2019	grade_10	0	0
3256375	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2020	grade_10	0	0
3256376	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	1	01	04	2015	grade_10	0	0
3256377	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	1	01	04	2016	grade_10	0	0
3256378	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2017	grade_10	0	0
3256379	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2018	grade_10	0	0
3256380	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2019	grade_10	0	0
3256381	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2020	grade_10	0	0
3257075	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	1	01	03	2015	grade_10	0	0
3257076	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	1	01	03	2016	grade_10	0	0
3257077	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2017	grade_10	0	0
3257078	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2018	grade_10	0	0
3257079	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2019	grade_10	0	0
3257080	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2020	grade_10	0	0
3260333	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	BURKE ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260334	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	BURKE ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260335	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	BURKE ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260336	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	COMPASS ELEMENTARY	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260337	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	COMPASS ELEMENTARY	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260339	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260340	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260341	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260342	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260343	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260345	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260346	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260347	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260348	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260349	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260350	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260351	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260352	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260353	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260354	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260355	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260356	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260357	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260358	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260359	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260361	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260362	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260363	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260364	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260365	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260367	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260368	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260369	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260370	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260371	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3260373	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	1	01	06	2015	grade_10	0	0
3260374	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	1	01	06	2016	grade_10	0	0
3260375	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	Elementary	01	06	2017	grade_10	0	0
3260376	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	Elementary	01	06	2018	grade_10	0	0
3260377	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	Elementary	01	06	2019	grade_10	0	0
3261336	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	1	01	02	2015	grade_10	0	0
3261337	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	1	01	02	2016	grade_10	0	0
3261338	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2017	grade_10	0	0
3261339	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2018	grade_10	0	0
3261340	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2019	grade_10	0	0
3261341	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2020	grade_10	0	0
3261534	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	01	12	2016	grade_10	0	0
3261535	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2017	grade_10	0	0
3261536	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2018	grade_10	5	5
3261537	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_10	0	0
3261538	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2020	grade_10	0	0
3263384	MO	school	2920490	74201	MARYVILLE R-II	292049001093	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	04	2019	grade_10	0	0
3263385	MO	school	2920490	74201	MARYVILLE R-II	292049001093	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	04	2020	grade_10	0	0
3265127	MO	school	2911910	94078	FARMINGTON R-VII	291191000442	4030	WASHINGTON-FRANKLIN ELEM.	Regular School	No	1	01	04	2015	grade_10	0	0
3265128	MO	school	2911910	94078	FARMINGTON R-VII	291191000442	4030	WASHINGTON-FRANKLIN ELEM.	Regular School	No	1	01	04	2016	grade_10	0	0