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 ccd_charter_school 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	total	total_int
3110379	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	pre_kindergarten	195	195
3124189	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	kindergarten	0	0
3137999	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_1	0	0
3151809	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_2	0	0
3165619	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_3	0	0
3179429	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_4	0	0
3193239	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_5	0	0
3207049	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_6	0	0
3220859	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_7	0	0
3234669	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_8	0	0
3248479	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_9	0	0
3262289	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_10	0	0
3276099	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_11	0	0
3289909	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	grade_12	0	0
3303719	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	k_12_total	0	0
3317529	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2015	pk_12_total	195	195
3110380	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	pre_kindergarten	209	209
3115062	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	pre_kindergarten	14	14
3124190	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	kindergarten	0	0
3128872	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	kindergarten	0	0
3138000	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_1	0	0
3142682	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_1	0	0
3151810	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_2	0	0
3156492	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_2	0	0
3165620	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_3	0	0
3170302	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_3	0	0
3179430	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_4	0	0
3184112	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_4	0	0
3193240	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_5	0	0
3197922	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_5	0	0
3207050	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_6	0	0
3211732	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_6	0	0
3220860	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_7	0	0
3225542	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_7	0	0
3234670	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_8	0	0
3239352	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_8	0	0
3248480	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_9	0	0
3253162	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_9	0	0
3262290	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_10	0	0
3266972	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_10	0	0
3276100	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_11	0	0
3280782	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_11	0	0
3289910	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_12	0	0
3294592	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_12	0	0
3303720	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	k_12_total	0	0
3308402	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	k_12_total	0	0
3317530	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	pk_12_total	209	209
3322212	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	pk_12_total	14	14
3110381	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	pre_kindergarten	212	212
3110591	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	pre_kindergarten	180	180
3124191	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	kindergarten	0	0
3124401	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	kindergarten	0	0
3138001	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_1	0	0
3138211	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_1	0	0
3151811	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_2	0	0
3152021	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_2	0	0
3165621	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_3	0	0
3165831	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_3	0	0
3179431	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_4	0	0
3179641	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_4	0	0
3193241	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_5	0	0
3193451	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_5	0	0
3207051	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_6	0	0
3207261	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_6	0	0
3220861	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_7	0	0
3221071	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_7	0	0
3234671	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_8	0	0
3234881	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_8	0	0
3248481	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_9	0	0
3248691	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_9	0	0
3262291	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_10	0	0
3262501	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_10	0	0
3276101	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_11	0	0
3276311	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_11	0	0
3289911	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_12	0	0
3290121	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_12	0	0
3303721	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	k_12_total	0	0
3303931	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	k_12_total	0	0
3317531	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	pk_12_total	212	212
3317741	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	pk_12_total	180	180
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
3103339	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103345	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	14	14
3103351	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103357	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103363	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2015	pre_kindergarten	181	181