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 "grade" = :p0 and "state" = :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	total	total_int
3052725	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2021	grade_5	0	0
3052726	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2021	grade_5	59	59
3052727	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2021	grade_5	0	0
3197874	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	3	09	12	2015	grade_5	0	0
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
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
3197877	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2018	grade_5	0	0
3197878	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	grade_5	0	0
3197879	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2020	grade_5	0	0
3197880	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	2	05	08	2015	grade_5	73	73
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
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
3197883	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2018	grade_5	79	79
3197884	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	grade_5	71	71
3197885	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2020	grade_5	73	73
3197886	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	1	KG	04	2015	grade_5	0	0
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
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
3197889	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2018	grade_5	0	0
3197890	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	grade_5	0	0
3197891	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2020	grade_5	0	0
3052728	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2021	grade_5	0	0
3052729	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	KG	06	2021	grade_5	40	40
3197892	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	3	07	12	2015	grade_5	0	0
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
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
3197895	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2018	grade_5	0	0
3197896	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_5	0	0
3197897	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2020	grade_5	0	0
3197898	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2015	grade_5	45	45
3197899	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	1	PK	06	2016	grade_5	50	50
3197900	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_5	62	62
3197901	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2018	grade_5	55	55
3197902	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_5	37	37
3197903	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2020	grade_5	60	60
3052730	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2021	grade_5	0	0
3052731	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2021	grade_5	0	0
3052732	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2021	grade_5	63	63
3197904	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2015	grade_5	0	0
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
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
3197907	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2018	grade_5	0	0
3197908	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	grade_5	0	0
3197909	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2020	grade_5	0	0
3197910	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	2	06	08	2015	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
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
3197913	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2018	grade_5	0	0
3197914	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	grade_5	0	0
3197915	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2020	grade_5	0	0
3197916	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	1	PK	05	2015	grade_5	74	74
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
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
3197919	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2018	grade_5	71	71
3197920	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_5	74	74
3197921	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2020	grade_5	67	67
3052733	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2021	grade_5	0	0
3052734	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2021	grade_5	22	22
3197922	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_5	0	0
3197923	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	3	07	12	2015	grade_5	0	0
3197924	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	3	07	12	2016	grade_5	0	0
3197925	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2017	grade_5	0	0
3197926	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2018	grade_5	0	0
3197927	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2019	grade_5	0	0
3197928	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2020	grade_5	0	0
3197929	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	1	PK	06	2015	grade_5	23	23
3197930	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	1	PK	06	2016	grade_5	23	23
3197931	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2017	grade_5	30	30
3197932	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2018	grade_5	14	14
3197933	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2019	grade_5	17	17
3197934	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2020	grade_5	26	26
3052735	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2021	grade_5	0	0
3052736	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2021	grade_5	0	0
3052737	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2021	grade_5	256	256
3052738	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	Elementary	PK	KG	2021	grade_5	0	0
3052739	MO	school	2928260	100063	SIKESTON R-6	292826001739	4040	LEE HUNTER ELEM.	Regular School	No	Elementary	01	04	2021	grade_5	0	0
3052740	MO	school	2928260	100063	SIKESTON R-6	292826001566	4050	WING ELEM.	Regular School	No	Elementary	01	04	2021	grade_5	0	0
3052741	MO	school	2928260	100063	SIKESTON R-6	292826001742	4070	SOUTHEAST ELEM.	Regular School	No	Elementary	01	04	2021	grade_5	0	0
3197935	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	3	09	12	2015	grade_5	0	0
3197936	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	3	09	12	2016	grade_5	0	0
3197937	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2017	grade_5	0	0
3197938	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2018	grade_5	0	0
3197939	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2019	grade_5	0	0
3197940	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2020	grade_5	0	0
3197941	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	2	07	08	2015	grade_5	0	0
3197942	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	2	07	08	2016	grade_5	0	0
3197943	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2017	grade_5	0	0
3197944	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2018	grade_5	0	0
3197945	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2019	grade_5	0	0
3197946	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2020	grade_5	0	0
3197947	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	2	05	06	2015	grade_5	275	275
3197948	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	2	05	06	2016	grade_5	265	265
3197949	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2017	grade_5	265	265
3197950	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2018	grade_5	275	275
3197951	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2019	grade_5	277	277
3197952	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2020	grade_5	276	276
3197953	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	1	PK	KG	2015	grade_5	0	0
3197954	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	1	PK	KG	2016	grade_5	0	0
3197955	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	Elementary	PK	KG	2017	grade_5	0	0
3197956	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	Elementary	PK	KG	2018	grade_5	0	0
3197957	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	Elementary	PK	KG	2019	grade_5	0	0