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 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	white	black	hispanic	native_american	asian	pacific_islander	multiracial	ell	free_and_reduced	disability	total	total_int
3103625	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	pre_kindergarten											54	54
3103697	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	pre_kindergarten											34	34
3105260	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten											73	73
3106798	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	pre_kindergarten											133	133
3115576	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	pre_kindergarten											68	68
3116921	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	pre_kindergarten											0	0
3117435	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	kindergarten											0	0
3117507	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	kindergarten											0	0
3119070	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten											0	0
3120608	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	kindergarten											0	0
3129386	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	kindergarten											0	0
3130731	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	kindergarten											0	0
3131245	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_1											0	0
3131317	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_1											0	0
3132880	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_1											0	0
3134418	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_1											0	0
3143196	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_1											0	0
3144541	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_1											0	0
3145055	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_2											0	0
3145127	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_2											0	0
3146690	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_2											0	0
3148228	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_2											0	0
3157006	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_2											0	0
3158351	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_2											0	0
3158865	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_3											0	0
3158937	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_3											0	0
3160500	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_3											0	0
3162038	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_3											0	0
3170816	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_3											0	0
3172161	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_3											0	0
3172675	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_4											0	0
3172747	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_4											0	0
3174310	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_4											0	0
3175848	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_4											0	0
3184626	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_4											0	0
3185971	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_4											0	0
3186485	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_5											0	0
3186557	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_5											0	0
3188120	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_5											0	0
3189658	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_5											0	0
3198436	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_5											0	0
3199781	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_5											0	0
3200295	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_6											0	0
3200367	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_6											0	0
3201930	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_6											0	0
3203468	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_6											0	0
3212246	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_6											0	0
3213591	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_6											0	0
3214105	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_7											0	0
3214177	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_7											0	0
3215740	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_7											0	0
3217278	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_7											0	0
3226056	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_7											0	0
3227401	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_7											0	0
3227915	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_8											0	0
3227987	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_8											0	0
3229550	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_8											0	0
3231088	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_8											0	0
3239866	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_8											0	0
3241211	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_8											0	0
3241725	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_9											0	0
3241797	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_9											0	0
3243360	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_9											0	0
3244898	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_9											0	0
3253676	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_9											0	0
3255021	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_9											0	0
3255535	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_10											0	0
3255607	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_10											0	0
3257170	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_10											0	0
3258708	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_10											0	0
3267486	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_10											0	0
3268831	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_10											7	7
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
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
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
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
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
3283155	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	grade_12											0	0
3283227	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	grade_12											0	0
3284790	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	grade_12											0	0
3286328	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	grade_12											0	0
3295106	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	grade_12											0	0
3296451	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_12											0	0
3296965	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	0	0
3297037	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	0	0
3298600	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	0	0
3300138	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	0	0
3308916	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	0	0
3310261	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	k_12_total	*	*	*	*	*	*	*	*	*	*	9	9
3310775	MO	school	2928200	5127	SHELL KNOB 78	292820003350	1010	TRI-LAKES SPECL. EDUC. COOP.	Regular School	No	Other	PK	12	2020	pk_12_total											54	54
3310847	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2020	pk_12_total											34	34
3312410	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total											73	73
3313948	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2020	pk_12_total											133	133
3322726	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2020	pk_12_total											68	68
3324071	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	pk_12_total											9	9
3104036	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2020	pre_kindergarten											0	0
3104707	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CENTER	Alternative School	No	High	05	12	2020	pre_kindergarten											0	0
3108255	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2020	pre_kindergarten											0	0
3109628	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2020	pre_kindergarten											0	0
3113198	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2020	pre_kindergarten											0	0