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 order by school_nces_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	free_and_reduced_int	disability_int	total_int
3110786	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten											0				0
3124596	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	kindergarten											46				46
3138406	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_1											65				65
3152216	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_2											63				63
3166026	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_3											70				70
3179836	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_4											73				73
3193646	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_5											0				0
3207456	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_6											0				0
3221266	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_7											0				0
3235076	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_8											0				0
3248886	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_9											0				0
3262696	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_10											0				0
3276506	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_11											0				0
3290316	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_12											0				0
3304126	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	k_12_total	314	*	*	*	*	*	*	*	209	49	317	314	209	49	317
3317936	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	pk_12_total											319				319
3110787	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten											40				40
3124597	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	kindergarten											48				48
3138407	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_1											47				47
3152217	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_2											61				61
3166027	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_3											61				61
3179837	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_4											58				58
3193647	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_5											0				0
3207457	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_6											0				0
3221267	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_7											0				0
3235077	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_8											0				0
3248887	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_9											0				0
3262697	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_10											0				0
3276507	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_11											0				0
3290317	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_12											0				0
3304127	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	k_12_total	272	*	*	*	*	*	*	*	183	48	275	272	183	48	275
3317937	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	pk_12_total											315				315
3110788	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	pre_kindergarten											14				14
3124598	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	kindergarten											47				47
3138408	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_1											47				47
3152218	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_2											48				48
3166028	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_3											60				60
3179838	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_4											63				63
3193648	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_5											0				0
3207458	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_6											0				0
3221268	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_7											0				0
3235078	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_8											0				0
3248888	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_9											0				0
3262698	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_10											0				0
3276508	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_11											0				0
3290318	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_12											0				0
3304128	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	k_12_total	263	*	*	*	*	*	*	*	160	48	265	263	160	48	265
3317938	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	pk_12_total											279				279
3110789	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	pre_kindergarten											5				5
3124599	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	kindergarten											44				44
3138409	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_1											44				44
3152219	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_2											41				41
3166029	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_3											39				39
3179839	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_4											59				59
3193649	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_5											0				0
3207459	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_6											0				0
3221269	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_7											0				0
3235079	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_8											0				0
3248889	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_9											0				0
3262699	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_10											0				0
3276509	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_11											0				0
3290319	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_12											0				0
3304129	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	k_12_total	226	*	*	*	*	*	*	*	*	45	227	226		45	227
3317939	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	pk_12_total											232				232
3110790	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	pre_kindergarten											31				31
3124600	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	kindergarten											56				56
3138410	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_1											47				47
3152220	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_2											46				46
3166030	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_3											41				41
3179840	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_4											44				44
3193650	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_5											0				0
3207460	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_6											0				0
3221270	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_7											0				0
3235080	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_8											0				0
3248890	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_9											0				0
3262700	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_10											0				0
3276510	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_11											0				0
3290320	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_12											0				0
3304130	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	k_12_total	232	*	*	*	*	*	*	*	*	36	234	232		36	234
3317940	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	pk_12_total											265				265
3110791	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten											8				8
3124601	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	kindergarten											47				47
3138411	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_1											54				54
3152221	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_2											49				49
3166031	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_3											50				50
3179841	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_4											45				45
3193651	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_5											0				0
3207461	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_6											0				0
3221271	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_7											0				0
3235081	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_8											0				0
3248891	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_9											0				0
3262701	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_10											0				0
3276511	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_11											0				0
3290321	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_12											0				0
3304131	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	k_12_total	239	*	*	*	*	*	*	*	*	31	245	239		31	245
3317941	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	pk_12_total											253				253
3038132	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	pre_kindergarten											31				31
3040445	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	kindergarten											40				40
3042758	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	grade_1											47				47
3045071	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	grade_2											53				53
3047384	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	grade_3											51				51