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 school_nces_id desc 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	ell_int	free_and_reduced_int	disability_int	total_int
3110382	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	pre_kindergarten											224								224
3124192	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	kindergarten											0								0
3138002	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_1											0								0
3151812	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_2											0								0
3165622	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_3											0								0
3179432	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_4											0								0
3193242	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_5											0								0
3207052	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_6											0								0
3220862	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_7											0								0
3234672	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_8											0								0
3248482	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_9											0								0
3262292	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_10											0								0
3276102	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_11											0								0
3289912	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_12											0								0
3303722	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	k_12_total											0								0
3317532	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	pk_12_total											224								224
3103896	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	pre_kindergarten											0								0
3117706	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	kindergarten											0								0
3131516	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_1											0								0
3145326	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_2											0								0
3159136	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_3											0								0
3172946	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_4											0								0
3186756	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_5											0								0
3200566	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_6											0								0
3214376	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_7											20								20
3228186	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_8											19								19
3241996	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_9											23								23
3255806	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_10											23								23
3269616	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_11											19								19
3283426	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	grade_12											14								14
3297236	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	k_12_total	112	*	*	*	*	*	*	*	74	14	118	112					74	14	118
3311046	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2018	pk_12_total											118								118
3103902	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	pre_kindergarten											0								0
3117712	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	kindergarten											22								22
3131522	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_1											18								18
3145332	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_2											20								20
3159142	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_3											17								17
3172952	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_4											11								11
3186762	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_5											24								24
3200572	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_6											24								24
3214382	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_7											0								0
3228192	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_8											0								0
3242002	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_9											0								0
3255812	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_10											0								0
3269622	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_11											0								0
3283432	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	grade_12											0								0
3297242	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	k_12_total	134	*	*	*	*	*	*	*	81	19	136	134					81	19	136
3311052	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	KG	06	2018	pk_12_total											136								136
3115747	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten											41								41
3129557	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	kindergarten											0								0
3143367	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_1											0								0
3157177	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_2											0								0
3170987	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_3											0								0
3184797	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_4											0								0
3198607	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_5											0								0
3212417	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_6											0								0
3226227	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_7											0								0
3240037	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_8											0								0
3253847	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_9											0								0
3267657	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_10											0								0
3281467	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_11											0								0
3295277	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_12											0								0
3309087	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	k_12_total	*	*	*	*	*	*	*	*	*	*	0								0
3322897	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total											41								41
3115742	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	pre_kindergarten											0								0
3129552	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	kindergarten											131								131
3143362	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_1											131								131
3157172	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_2											0								0
3170982	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_3											0								0
3184792	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_4											0								0
3198602	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_5											0								0
3212412	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_6											0								0
3226222	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_7											0								0
3240032	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_8											0								0
3253842	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_9											0								0
3267652	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_10											0								0
3281462	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_11											0								0
3295272	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	grade_12											0								0
3309082	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	k_12_total	198	9	36	*	*	*	19	21	134.4	42	262	198	9	36	19	21		42	262
3322892	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2018	pk_12_total											262								262
3115730	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten											0								0
3129540	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	kindergarten											0								0
3143350	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_1											0								0
3157160	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_2											0								0
3170970	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_3											0								0
3184780	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_4											0								0
3198590	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_5											0								0
3212400	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_6											133								133
3226210	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_7											120								120
3240020	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_8											128								128
3253830	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_9											0								0
3267640	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_10											0								0
3281450	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_11											0								0
3295260	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	grade_12											0								0
3309070	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	k_12_total	295	24	37	*	*	*	22	14	177	57	381	295	24	37	22	14	177	57	381
3322880	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002576	3000	WRIGHT CITY MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total											381								381
3115724	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	pre_kindergarten											0								0
3129534	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	kindergarten											0								0
3143344	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	grade_1											0								0
3157154	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	grade_2											0								0
3170964	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2018	grade_3											0								0