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 (ccd_charter_school > :p2 or (ccd_charter_school = :p2 and rowid > :p1)) order by ccd_charter_school, 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
3103358	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103359	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103360	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103361	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3103362	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	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
3103364	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2016	pre_kindergarten	170	170
3103365	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	163	163
3103366	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2018	pre_kindergarten	177	177
3103367	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2019	pre_kindergarten	169	169
3103368	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	190	190
3103369	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2015	pre_kindergarten	0	0
3103370	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3103371	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3103372	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2018	pre_kindergarten	0	0
3103373	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2019	pre_kindergarten	0	0
3103374	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0	0
3103375	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103376	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103377	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103378	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103379	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103380	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
3103381	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2015	pre_kindergarten	0	0
3103382	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3103383	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2017	pre_kindergarten	0	0
3103384	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2018	pre_kindergarten	0	0
3103385	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2019	pre_kindergarten	0	0
3103386	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	pre_kindergarten	0	0
3103387	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103388	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103389	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103390	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103391	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103392	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103393	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103394	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103395	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103396	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103397	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3103398	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3103399	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103400	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103401	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	KG	05	2017	pre_kindergarten	0	0
3103402	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103403	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	9	9
3103404	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	17	17
3103405	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	1	PK	08	2015	pre_kindergarten	26	26
3103406	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	1	PK	08	2016	pre_kindergarten	27	27
3103407	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2017	pre_kindergarten	24	24
3103408	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2018	pre_kindergarten	28	28
3103409	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2019	pre_kindergarten	20	20
3103410	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	24	24
3103411	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103412	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103413	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103414	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103415	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103416	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103417	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103418	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103419	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103420	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103421	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3103422	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3103423	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103424	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103425	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	0	0
3103426	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103427	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103428	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3103429	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103430	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103431	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	10	10
3103432	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103433	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103434	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3103435	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103436	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103437	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	14	14
3103438	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103439	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103440	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3103441	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103442	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103443	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	58	58
3103444	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103445	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103446	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2020	pre_kindergarten	0	0
3103447	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	17	17
3103448	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2016	pre_kindergarten	18	18
3103449	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	84	84
3103450	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	17	17
3103451	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	48	48
3103452	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	42	42
3103453	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103454	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103455	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103456	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103457	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103458	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	06	12	2020	pre_kindergarten	0	0