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
3115016	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	pre_kindergarten											0							0
3115022	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	pre_kindergarten											0							0
3115028	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	pre_kindergarten											19							19
3128826	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	kindergarten											0							0
3128832	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	kindergarten											0							0
3128838	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	kindergarten											65							65
3142636	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_1											0							0
3142642	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_1											0							0
3142648	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_1											66							66
3156446	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_2											0							0
3156452	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_2											0							0
3156458	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_2											64							64
3170256	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_3											0							0
3170262	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_3											0							0
3170268	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_3											69							69
3184066	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_4											0							0
3184072	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_4											0							0
3184078	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_4											79							79
3197876	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_5											0							0
3197882	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_5											55							55
3197888	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_5											0							0
3211686	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_6											0							0
3211692	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_6											68							68
3211698	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_6											0							0
3225496	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_7											0							0
3225502	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_7											67							67
3225508	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_7											0							0
3239306	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_8											0							0
3239312	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_8											57							57
3239318	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_8											0							0
3253116	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_9											64							64
3253122	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_9											0							0
3253128	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_9											0							0
3266926	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_10											53							53
3266932	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_10											0							0
3266938	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_10											0							0
3280736	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_11											54							54
3280742	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_11											0							0
3280748	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_11											0							0
3294546	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	grade_12											53							53
3294552	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	grade_12											0							0
3294558	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	grade_12											0							0
3308356	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	k_12_total	219	*	*	*	*	*	*	*	92.3	29	224	219					29	224
3308362	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	k_12_total	230	*	6	*	*	*	10	*	131	33	247	230		6	10	131	33	247
3308368	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	k_12_total	320	*	7	*	*	*	12	*	227	49	343	320		7	12	227	49	343
3322166	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2017	pk_12_total											224							224
3322172	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2017	pk_12_total											247							247
3322178	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2017	pk_12_total											362							362
3115034	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	pre_kindergarten											0							0
3115040	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten											33							33
3128844	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	kindergarten											0							0
3128850	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	kindergarten											62							62
3142654	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_1											0							0
3142660	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_1											45							45
3156464	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_2											0							0
3156470	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_2											69							69
3170274	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_3											0							0
3170280	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_3											45							45
3184084	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_4											0							0
3184090	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_4											59							59
3197894	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_5											0							0
3197900	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_5											62							62
3211704	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_6											0							0
3211710	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_6											46							46
3225514	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_7											48							48
3225520	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_7											0							0
3239324	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_8											51							51
3239330	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_8											0							0
3253134	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_9											50							50
3253140	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_9											0							0
3266944	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_10											60							60
3266950	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_10											0							0
3280754	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_11											43							43
3280760	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_11											0							0
3294564	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	grade_12											39							39
3294570	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_12											0							0
3308374	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	k_12_total	276	10	*	*	*	*	*	*	150	31	291	276	10			150	31	291
3308380	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	k_12_total	374	12	*	*	*	*	*	*	*	65	388	374	12				65	388
3322184	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2017	pk_12_total											291							291
3322190	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	pk_12_total											421							421
3115046	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	pre_kindergarten											0							0
3115052	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten											0							0
3115058	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten											40							40
3128856	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	kindergarten											0							0
3128862	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	kindergarten											0							0
3128868	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	kindergarten											67							67
3142666	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	grade_1											0							0
3142672	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	grade_1											0							0
3142678	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1											66							66
3156476	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	grade_2											0							0
3156482	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	grade_2											0							0
3156488	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	grade_2											63							63
3170286	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	grade_3											0							0
3170292	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	grade_3											0							0
3170298	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3											74							74
3184096	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	grade_4											0							0
3184102	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	grade_4											0							0
3184108	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	grade_4											70							70
3197906	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2017	grade_5											0							0
3197912	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2017	grade_5											0							0
3197918	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2017	grade_5											87							87