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 "year" = :p1 and (ccd_school_type > :p3 or (ccd_school_type = :p3 and rowid > :p2)) order by ccd_school_type, 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	white	black	hispanic	native_american	asian	pacific_islander	multiracial	ell	free_and_reduced	disability	total	white_int	black_int	hispanic_int	asian_int	multiracial_int	ell_int	free_and_reduced_int	disability_int	total_int
3201376	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_6											0									0
3201822	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_6											0									0
3204924	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_6											0									0
3206297	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_6											0									0
3209867	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_6											0									0
3211504	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_6											0									0
3211931	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_6											0									0
3212688	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_6											0									0
3212736	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_6											0									0
3213162	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_6											0									0
3213765	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_6											0									0
3213814	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_6											0									0
3214515	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_7											0									0
3214521	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_7											0									0
3215186	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_7											0									0
3215632	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_7											0									0
3218734	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_7											0									0
3220107	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_7											0									0
3223677	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_7											0									0
3225314	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_7											0									0
3225741	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_7											0									0
3226498	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_7											0									0
3226546	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_7											0									0
3226972	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_7											0									0
3227575	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_7											0									0
3227624	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_7											0									0
3228325	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_8											0									0
3228331	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_8											0									0
3228996	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_8											0									0
3229442	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_8											0									0
3232544	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_8											0									0
3233917	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_8											0									0
3237487	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_8											0									0
3239124	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_8											0									0
3239551	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_8											0									0
3240308	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_8											0									0
3240356	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_8											0									0
3240782	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_8											0									0
3241385	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_8											0									0
3241434	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_8											0									0
3242135	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_9											0									0
3242141	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_9											23									23
3242806	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_9											0									0
3243252	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_9											0									0
3246354	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_9											9									9
3247727	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_9											0									0
3251297	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_9											0									0
3252934	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_9											7									7
3253361	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_9											0									0
3254118	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_9											0									0
3254166	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_9											8									8
3254592	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_9											0									0
3255195	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_9											0									0
3255244	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_9											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
3255951	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_10											27									27
3256616	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_10											0									0
3257062	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_10											0									0
3260164	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_10											0									0
3261537	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_10											0									0
3265107	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_10											0									0
3266744	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_10											13									13
3267171	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_10											0									0
3267928	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_10											0									0
3267976	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_10											5									5
3268402	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_10											0									0
3269005	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_10											0									0
3269054	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_10											19									19
3269755	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_11											0									0
3269761	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_11											35									35
3270426	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	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
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
3275347	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	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
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
3280981	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_11											0									0
3281738	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_11											0									0
3281786	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_11											0									0
3282212	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_11											0									0
3282815	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_11											0									0
3282864	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_11											22									22
3283565	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_12											0									0
3283571	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_12											45									45
3284236	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	grade_12											0									0
3284682	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	grade_12											0									0
3287784	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	grade_12											0									0
3289157	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	grade_12											0									0
3292727	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_12											0									0
3294364	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	grade_12											0									0
3294791	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	grade_12											0									0
3295548	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	grade_12											0									0
3295596	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	grade_12											0									0
3296022	MO	school	2929280	115115	ST. LOUIS CITY	292928002005	6340	ST. LOUIS CHILDREN'S HOSPITAL	Alternative School	No	Other	KG	12	2019	grade_12											0									0
3296625	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_12											0									0
3296674	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_12											8									8
3297375	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	k_12_total	5	7	*	*	*	*	*	*	*	*	14	5	7							14
3297381	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	k_12_total	36	68	11	*	5	*	10	52	*	7	130	36	68	11	5	10	52		7	130
3298046	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	k_12_total	*	*	*	*	*	*	*	*	*	*	0									0
3298492	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	k_12_total	*	*	*	*	*	*	*	*	*	*	0									0
3301594	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	k_12_total	9	13	*	*	*	*	*	*	5	7	23	9	13					5	7	23