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 (asian > :p2 or (asian = :p2 and rowid > :p1)) order by asian, 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
3103942	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3103943	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3103944	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2018	pre_kindergarten	0	0
3103945	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2019	pre_kindergarten	0	0
3103946	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0	0
3103947	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103948	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103949	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103950	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103951	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103952	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103953	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103954	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103955	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103956	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103957	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3103958	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3103959	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2015	pre_kindergarten	0	0
3103960	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2016	pre_kindergarten	0	0
3103961	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2017	pre_kindergarten	0	0
3103962	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2018	pre_kindergarten	0	0
3103963	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2019	pre_kindergarten	0	0
3103964	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2020	pre_kindergarten	0	0
3103965	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2015	pre_kindergarten	32	32
3103966	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2016	pre_kindergarten	30	30
3103967	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2017	pre_kindergarten	13	13
3103968	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2018	pre_kindergarten	18	18
3103969	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2019	pre_kindergarten	21	21
3103970	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2020	pre_kindergarten	30	30
3103971	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103972	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103973	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103974	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103975	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103976	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103977	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	2	05	08	2015	pre_kindergarten	0	0
3103978	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	2	05	08	2016	pre_kindergarten	0	0
3103979	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2017	pre_kindergarten	0	0
3103980	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2018	pre_kindergarten	0	0
3103981	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2019	pre_kindergarten	0	0
3103982	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2020	pre_kindergarten	0	0
3103983	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten	32	32
3103984	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	29	29
3103985	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	KG	04	2017	pre_kindergarten	19	19
3103986	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2018	pre_kindergarten	27	27
3103987	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2019	pre_kindergarten	43	43
3103988	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	45	45
3103989	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103990	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103991	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103992	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103993	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103994	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103995	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103996	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103997	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103998	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103999	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3104000	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3104001	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2015	pre_kindergarten	0	0
3104002	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2016	pre_kindergarten	5	5
3104003	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	0	0
3104004	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2018	pre_kindergarten	7	7
3104005	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2019	pre_kindergarten	10	10
3104006	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	26	26
3104007	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2015	pre_kindergarten	0	0
3104008	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3104009	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3104010	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2018	pre_kindergarten	0	0
3104011	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2019	pre_kindergarten	0	0
3104012	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2020	pre_kindergarten	0	0
3104013	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3104014	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104015	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3104016	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3104017	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104018	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3104019	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3104020	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104021	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3104022	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3104023	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3104024	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3104025	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	40	40
3104026	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	38	38
3104027	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	42	42
3104028	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	54	54
3104029	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	67	67
3104030	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	42	42
3104031	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2015	pre_kindergarten	0	0
3104032	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2016	pre_kindergarten	0	0
3104033	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2017	pre_kindergarten	0	0
3104034	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2018	pre_kindergarten	0	0
3104035	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	pre_kindergarten	0	0
3104036	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2020	pre_kindergarten	0	0
3104037	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative Education School	No	4	PK	12	2015	pre_kindergarten	53	53
3104038	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative Education School	No	4	PK	12	2016	pre_kindergarten	58	58
3104039	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2017	pre_kindergarten	45	45
3104040	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2018	pre_kindergarten	59	59
3104041	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	pre_kindergarten	54	54
3104042	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2020	pre_kindergarten	55	55