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
3115015	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	pre_kindergarten											0							0
3115021	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	pre_kindergarten											0							0
3115027	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	pre_kindergarten											0							0
3128825	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	kindergarten											0							0
3128831	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	kindergarten											0							0
3128837	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	kindergarten											75							75
3142635	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_1											0							0
3142641	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_1											0							0
3142647	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_1											66							66
3156445	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_2											0							0
3156451	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_2											0							0
3156457	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_2											64							64
3170255	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_3											0							0
3170261	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_3											0							0
3170267	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_3											74							74
3184065	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_4											0							0
3184071	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_4											0							0
3184077	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_4											60							60
3197875	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_5											0							0
3197881	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_5											66							66
3197887	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_5											0							0
3211685	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_6											0							0
3211691	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_6											71							71
3211697	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_6											0							0
3225495	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_7											0							0
3225501	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_7											61							61
3225507	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_7											0							0
3239305	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_8											0							0
3239311	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_8											69							69
3239317	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_8											0							0
3253115	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_9											62							62
3253121	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_9											0							0
3253127	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_9											0							0
3266925	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_10											55							55
3266931	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_10											0							0
3266937	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_10											0							0
3280735	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_11											57							57
3280741	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_11											0							0
3280747	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_11											0							0
3294545	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	grade_12											52							52
3294551	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	grade_12											0							0
3294557	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	grade_12											0							0
3308355	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	k_12_total	221	*	*	*	*	*	*	*	101	24	226	221				101	24	226
3308361	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	k_12_total	257	*	5	*	*	*	*	*	169.1	37	267	257		5			37	267
3308367	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	k_12_total	317	*	*	*	*	*	15	*	199	42	339	317			15	199	42	339
3322165	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2016	pk_12_total											226							226
3322171	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2016	pk_12_total											267							267
3322177	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2016	pk_12_total											339							339
3115033	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	pre_kindergarten											0							0
3115039	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten											29							29
3128843	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	kindergarten											0							0
3128849	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	kindergarten											45							45
3142653	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_1											0							0
3142659	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_1											69							69
3156463	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_2											0							0
3156469	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_2											48							48
3170273	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_3											0							0
3170279	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_3											58							58
3184083	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_4											0							0
3184089	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_4											61							61
3197893	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_5											0							0
3197899	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_5											50							50
3211703	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_6											0							0
3211709	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_6											48							48
3225513	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_7											52							52
3225519	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_7											0							0
3239323	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_8											49							49
3239329	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_8											0							0
3253133	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_9											59							59
3253139	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_9											0							0
3266943	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_10											43							43
3266949	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_10											0							0
3280753	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_11											43							43
3280759	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_11											0							0
3294563	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_12											43							43
3294569	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_12											0							0
3308373	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	k_12_total	278	8	*	*	*	*	*	*	139	35	289	278	8			139	35	289
3308379	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	k_12_total	362	13	*	*	*	*	*	*	347	54	379	362	13			347	54	379
3322183	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2016	pk_12_total											289							289
3322189	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	pk_12_total											408							408
3115045	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	pre_kindergarten											0							0
3115051	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten											0							0
3115057	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten											40							40
3128855	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	kindergarten											0							0
3128861	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	kindergarten											0							0
3128867	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	kindergarten											64							64
3142665	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_1											0							0
3142671	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	grade_1											0							0
3142677	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	grade_1											62							62
3156475	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_2											0							0
3156481	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	grade_2											0							0
3156487	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	grade_2											69							69
3170285	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_3											0							0
3170291	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	grade_3											0							0
3170297	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	grade_3											76							76
3184095	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_4											0							0
3184101	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	grade_4											0							0
3184107	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	grade_4											82							82
3197905	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_5											0							0
3197911	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2016	grade_5											0							0
3197917	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2016	grade_5											90							90