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 (school_state_id > :p2 or (school_state_id = :p2 and rowid > :p1)) order by school_state_id, 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
3115384	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	pre_kindergarten	67	67
3115385	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	pre_kindergarten	76	76
3115386	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	pre_kindergarten	64	64
3115387	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	47	47
3115571	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2015	pre_kindergarten	30	30
3115572	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2016	pre_kindergarten	31	31
3115573	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2017	pre_kindergarten	32	32
3115574	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2018	pre_kindergarten	74	74
3115575	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	57	57
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
3116916	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2015	pre_kindergarten	0	0
3116917	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2016	pre_kindergarten	0	0
3116918	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	Other	06	12	2017	pre_kindergarten	0	0
3116919	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2018	pre_kindergarten	0	0
3116920	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	pre_kindergarten	0	0
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
3117502	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	kindergarten	0	0
3117503	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	kindergarten	0	0
3117504	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	kindergarten	0	0
3117505	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	kindergarten	0	0
3117506	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	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
3120603	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2015	kindergarten	0	0
3120604	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2016	kindergarten	0	0
3120605	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2017	kindergarten	0	0
3120606	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2018	kindergarten	0	0
3120607	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2019	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
3126001	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2015	kindergarten	0	0
3126002	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2016	kindergarten	0	0
3126003	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2017	kindergarten	0	0
3126004	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2018	kindergarten	0	0
3126005	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2019	kindergarten	0	0
3129193	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	kindergarten	0	0
3129194	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	kindergarten	0	0
3129195	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	kindergarten	0	0
3129196	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	kindergarten	0	0
3129197	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	kindergarten	0	0
3129381	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2015	kindergarten	0	0
3129382	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2016	kindergarten	0	0
3129383	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2017	kindergarten	0	0
3129384	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2018	kindergarten	0	0
3129385	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2019	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
3130726	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2015	kindergarten	0	0
3130727	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2016	kindergarten	0	0
3130728	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	Other	06	12	2017	kindergarten	0	0
3130729	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2018	kindergarten	0	0
3130730	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	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
3131312	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_1	0	0
3131313	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	grade_1	0	0
3131314	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	grade_1	0	0
3131315	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	grade_1	0	0
3131316	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	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
3134413	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2015	grade_1	0	0
3134414	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2016	grade_1	0	0
3134415	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2017	grade_1	0	0
3134416	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2018	grade_1	0	0
3134417	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2019	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
3139811	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2015	grade_1	0	0
3139812	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	4	PK	12	2016	grade_1	0	0
3139813	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2017	grade_1	0	0
3139814	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2018	grade_1	0	0
3139815	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2019	grade_1	0	0
3143003	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_1	0	0
3143004	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	grade_1	0	0
3143005	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	grade_1	0	0
3143006	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	grade_1	0	0
3143007	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	grade_1	0	0
3143191	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2015	grade_1	0	0
3143192	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	4	PK	12	2016	grade_1	0	0
3143193	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2017	grade_1	0	0
3143194	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2018	grade_1	0	0
3143195	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2019	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
3144536	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2015	grade_1	0	0
3144537	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2016	grade_1	0	0
3144538	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	Other	06	12	2017	grade_1	0	0
3144539	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2018	grade_1	0	0
3144540	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	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
3145122	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_2	0	0
3145123	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2016	grade_2	0	0
3145124	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	grade_2	0	0
3145125	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2018	grade_2	0	0
3145126	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	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
3148223	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2015	grade_2	0	0
3148224	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	4	PK	12	2016	grade_2	0	0
3148225	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2017	grade_2	0	0
3148226	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2018	grade_2	0	0
3148227	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2019	grade_2	0	0