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 district_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	white_int	black_int	hispanic_int	multiracial_int	free_and_reduced_int	disability_int	total_int
3115018	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	pre_kindergarten											0							0
3115024	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	pre_kindergarten											0							0
3115030	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	pre_kindergarten											19							19
3128828	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	kindergarten											0							0
3128834	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	kindergarten											0							0
3128840	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	kindergarten											56							56
3142638	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_1											0							0
3142644	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_1											0							0
3142650	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_1											51							51
3156448	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_2											0							0
3156454	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_2											0							0
3156460	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_2											66							66
3170258	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_3											0							0
3170264	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_3											0							0
3170270	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_3											61							61
3184068	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_4											0							0
3184074	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_4											0							0
3184080	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_4											71							71
3197878	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_5											0							0
3197884	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_5											71							71
3197890	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_5											0							0
3211688	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_6											0							0
3211694	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_6											74							74
3211700	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_6											0							0
3225498	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_7											0							0
3225504	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_7											53							53
3225510	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_7											0							0
3239308	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_8											0							0
3239314	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_8											60							60
3239320	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_8											0							0
3253118	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_9											70							70
3253124	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_9											0							0
3253130	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_9											0							0
3266928	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_10											70							70
3266934	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_10											0							0
3266940	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_10											0							0
3280738	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_11											65							65
3280744	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_11											0							0
3280750	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_11											0							0
3294548	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_12											48							48
3294554	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_12											0							0
3294560	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_12											0							0
3308358	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	k_12_total	240	*	*	*	*	*	7	*	108	31	253	240			7	108	31	253
3308364	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	k_12_total	235	*	9	*	*	*	12	*	142	40	258	235		9	12	142	40	258
3308370	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	k_12_total	287	*	5	*	*	*	7	*	206	36	305	287		5	7	206	36	305
3322168	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	pk_12_total											253							253
3322174	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	pk_12_total											258							258
3322180	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	pk_12_total											324							324
3115036	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten											0							0
3115042	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten											29							29
3128846	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	kindergarten											0							0
3128852	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	kindergarten											60							60
3142656	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_1											0							0
3142662	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_1											36							36
3156466	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_2											0							0
3156472	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_2											51							51
3170276	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_3											0							0
3170282	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_3											38							38
3184086	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_4											0							0
3184092	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_4											64							64
3197896	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_5											0							0
3197902	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_5											37							37
3211706	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_6											0							0
3211712	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_6											54							54
3225516	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_7											63							63
3225522	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_7											0							0
3239326	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_8											46							46
3239332	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_8											0							0
3253136	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_9											51							51
3253142	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_9											0							0
3266946	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_10											45							45
3266952	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_10											0							0
3280756	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_11											50							50
3280762	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_11											0							0
3294566	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_12											56							56
3294572	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12											0							0
3308376	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	k_12_total	298	8	5	*	*	*	*	*	136	39	311	298	8	5		136	39	311
3308382	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	k_12_total	325	9	5	*	*	*	*	*	*	58	340	325	9	5			58	340
3322186	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	pk_12_total											311							311
3322192	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total											369							369
3115048	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	pre_kindergarten											0							0
3115054	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten											0							0
3115060	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten											40							40
3128858	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	kindergarten											0							0
3128864	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	kindergarten											0							0
3128870	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	kindergarten											62							62
3142668	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_1											0							0
3142674	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_1											0							0
3142680	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1											45							45
3156478	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_2											0							0
3156484	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_2											0							0
3156490	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_2											64							64
3170288	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_3											0							0
3170294	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_3											0							0
3170300	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_3											60							60
3184098	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_4											0							0
3184104	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_4											0							0
3184110	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_4											70							70
3197908	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_5											0							0
3197914	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_5											0							0
3197920	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_5											74							74