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 and (term > :p3 or (term = :p3 and rowid > :p2)) order by term, rowid 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
3117149	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	kindergarten	0	0
3117150	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2016	kindergarten	0	0
3117151	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	kindergarten	0	0
3117152	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	kindergarten	0	0
3117153	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	kindergarten	0	0
3117154	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	kindergarten	0	0
3117155	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	1	PK	06	2015	kindergarten	20	20
3117156	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2016	kindergarten	12	12
3117157	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2017	kindergarten	11	11
3117158	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2018	kindergarten	15	15
3117159	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2019	kindergarten	17	17
3117160	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2020	kindergarten	17	17
3117161	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	3	09	12	2015	kindergarten	0	0
3117162	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	3	09	12	2016	kindergarten	0	0
3117163	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2017	kindergarten	0	0
3117164	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2018	kindergarten	0	0
3117165	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2019	kindergarten	0	0
3117166	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2020	kindergarten	0	0
3117167	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	2	06	08	2015	kindergarten	0	0
3117168	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	2	06	08	2016	kindergarten	0	0
3117169	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2017	kindergarten	0	0
3117170	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2018	kindergarten	0	0
3117171	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	kindergarten	0	0
3117172	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	kindergarten	0	0
3117173	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2015	kindergarten	177	177
3117174	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2016	kindergarten	191	191
3117175	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2017	kindergarten	175	175
3117176	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2018	kindergarten	191	191
3117177	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2019	kindergarten	166	166
3117178	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2020	kindergarten	167	167
3117179	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2015	kindergarten	0	0
3117180	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2016	kindergarten	0	0
3117181	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2017	kindergarten	0	0
3117182	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2018	kindergarten	0	0
3117183	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2019	kindergarten	0	0
3117184	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2020	kindergarten	0	0
3117185	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	kindergarten	0	0
3117186	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2016	kindergarten	0	0
3117187	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	kindergarten	0	0
3117188	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	kindergarten	0	0
3117189	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	kindergarten	0	0
3117190	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	kindergarten	0	0
3117191	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2015	kindergarten	9	9
3117192	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2016	kindergarten	13	13
3117193	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2017	kindergarten	11	11
3117194	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2018	kindergarten	8	8
3117195	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2019	kindergarten	7	7
3117196	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	kindergarten	14	14
3117197	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	3	09	12	2015	kindergarten	0	0
3117198	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	3	09	12	2016	kindergarten	0	0
3117199	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2017	kindergarten	0	0
3117200	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2018	kindergarten	0	0
3117201	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2019	kindergarten	0	0
3117202	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2020	kindergarten	0	0
3117203	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	2	06	08	2015	kindergarten	0	0
3117204	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	2	06	08	2016	kindergarten	0	0
3117205	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2017	kindergarten	0	0
3117206	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2018	kindergarten	0	0
3117207	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2019	kindergarten	0	0
3117208	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2020	kindergarten	0	0
3117209	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	1	KG	05	2015	kindergarten	22	22
3117210	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	1	KG	05	2016	kindergarten	37	37
3117211	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	KG	05	2017	kindergarten	29	29
3117212	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	KG	05	2018	kindergarten	17	17
3117213	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	PK	05	2019	kindergarten	22	22
3117214	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	PK	05	2020	kindergarten	24	24
3117215	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	1	PK	08	2015	kindergarten	20	20
3117216	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	1	PK	08	2016	kindergarten	13	13
3117217	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2017	kindergarten	23	23
3117218	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2018	kindergarten	15	15
3117219	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2019	kindergarten	25	25
3117220	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2020	kindergarten	23	23
3117221	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	3	09	12	2015	kindergarten	0	0
3117222	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	3	09	12	2016	kindergarten	0	0
3117223	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2017	kindergarten	0	0
3117224	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2018	kindergarten	0	0
3117225	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2019	kindergarten	0	0
3117226	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2020	kindergarten	0	0
3117227	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	2	06	08	2015	kindergarten	0	0
3117228	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	2	06	08	2016	kindergarten	0	0
3117229	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2017	kindergarten	0	0
3117230	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2018	kindergarten	0	0
3117231	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2019	kindergarten	0	0
3117232	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2020	kindergarten	0	0
3117233	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	1	KG	05	2015	kindergarten	20	20
3117234	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	1	KG	05	2016	kindergarten	14	14
3117235	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	PK	05	2017	kindergarten	13	13
3117236	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2018	kindergarten	15	15
3117237	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2019	kindergarten	13	13
3117238	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2020	kindergarten	17	17
3117239	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	1	KG	05	2015	kindergarten	9	9
3117240	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	1	KG	05	2016	kindergarten	24	24
3117241	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	PK	05	2017	kindergarten	14	14
3117242	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2018	kindergarten	21	21
3117243	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2019	kindergarten	10	10
3117244	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2020	kindergarten	23	23
3117245	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	1	KG	05	2015	kindergarten	41	41
3117246	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	1	KG	05	2016	kindergarten	45	45
3117247	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	PK	05	2017	kindergarten	43	43
3117248	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2018	kindergarten	49	49
3117249	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2019	kindergarten	39	39