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 school_state_id 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
3276099	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_11	0	0
3276100	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_11	0	0
3276101	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_11	0	0
3276102	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_11	0	0
3276311	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_11	0	0
3280782	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_11	0	0
3064694	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2021	grade_11	0	0
3064954	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2021	grade_11	0	0
3065217	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2021	grade_11	0	0
3066677	MO	school	2912240	106003	FORSYTH R-III	291224003391	1010	TRI LAKES SPECIAL SERV CO-OP	Regular School	No	Other	PK	12	2021	grade_11	0	0
3066696	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2021	grade_11	0	0
3269345	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_11	0	0
3269412	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_11	0	0
3269413	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	grade_11	0	0
3269414	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	grade_11	0	0
3269415	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	grade_11	0	0
3269416	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	grade_11	0	0
3269417	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_11	0	0
3270980	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_11	0	0
3272513	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2015	grade_11	0	0
3272514	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2016	grade_11	0	0
3272515	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2017	grade_11	0	0
3272516	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2018	grade_11	0	0
3272517	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2019	grade_11	0	0
3272518	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_11	0	0
3277911	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2015	grade_11	0	0
3277912	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2016	grade_11	0	0
3277913	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2017	grade_11	0	0
3277914	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2018	grade_11	0	0
3277915	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2019	grade_11	0	0
3281103	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_11	0	0
3281104	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	grade_11	0	0
3281105	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	grade_11	0	0
3281106	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	grade_11	0	0
3281107	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	grade_11	0	0
3281291	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2015	grade_11	0	0
3281292	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2016	grade_11	0	0
3281293	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2017	grade_11	0	0
3281294	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2018	grade_11	0	0
3281295	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2019	grade_11	0	0
3281296	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_11	0	0
3282636	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2015	grade_11	0	0
3282637	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2016	grade_11	0	0
3282638	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	Other	06	12	2017	grade_11	5	5
3282639	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2018	grade_11	0	0
3282640	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	grade_11	0	0
3282641	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_11	0	0
3064751	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2021	grade_11	5	5
3064936	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2021	grade_11	0	0
3065461	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2021	grade_11	0	0
3066300	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2021	grade_11	0	0
3066573	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2021	grade_11	8	8
3066643	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2021	grade_11	0	0
3066771	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2021	grade_11	0	0
3066779	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2021	grade_11	0	0
3269751	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2015	grade_11	7	7
3269752	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2016	grade_11	0	0
3269753	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2017	grade_11	0	0
3269754	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2018	grade_11	0	0
3269755	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_11	0	0
3269756	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2020	grade_11	0	0
3270422	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	05	12	2015	grade_11	0	0
3270423	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	05	12	2016	grade_11	0	0
3270424	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	05	12	2017	grade_11	0	0
3270425	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2018	grade_11	0	0
3270426	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_11	0	0
3270427	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CENTER	Alternative School	No	High	05	12	2020	grade_11	0	0
3270868	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative Education School	No	4	KG	12	2015	grade_11	0	0
3270869	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative Education School	No	4	KG	12	2016	grade_11	0	0
3270870	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2017	grade_11	0	0
3270871	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2018	grade_11	0	0
3270872	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_11	0	0
3273970	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative Education School	No	4	05	12	2015	grade_11	0	0
3273971	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative Education School	No	4	05	12	2016	grade_11	0	0
3273972	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	Other	05	12	2017	grade_11	6	6
3273973	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2018	grade_11	5	5
3273974	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_11	0	0
3273975	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2020	grade_11	7	7
3275344	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	01	12	2016	grade_11	0	0
3275345	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2017	grade_11	0	0
3275346	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2018	grade_11	0	0
3275347	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_11	0	0
3275348	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2020	grade_11	0	0
3278913	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	KG	12	2015	grade_11	0	0
3278914	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	KG	12	2016	grade_11	0	0
3278915	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2017	grade_11	0	0
3278916	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2018	grade_11	0	0
3278917	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_11	0	0
3278918	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2020	grade_11	0	0
3280550	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	KG	12	2015	grade_11	13	13
3280551	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	KG	12	2016	grade_11	21	21
3280552	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2017	grade_11	16	16
3280553	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2018	grade_11	9	9
3280554	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_11	17	17
3280555	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2020	grade_11	10	10
3280977	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative Education School	No	4	02	12	2015	grade_11	0	0
3280978	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative Education School	No	4	02	12	2016	grade_11	0	0
3280979	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2017	grade_11	0	0
3280980	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2018	grade_11	0	0
3280981	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_11	0	0
3280982	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2020	grade_11	0	0