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 (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, 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
3235064	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2015	grade_8	0	0
3235065	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2016	grade_8	0	0
3235066	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2017	grade_8	0	0
3235067	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2018	grade_8	0	0
3235068	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2019	grade_8	0	0
3235069	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2020	grade_8	0	0
3235070	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2015	grade_8	60	60
3235071	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2016	grade_8	63	63
3235072	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2017	grade_8	60	60
3235073	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2018	grade_8	60	60
3235074	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2019	grade_8	76	76
3235075	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2020	grade_8	59	59
3235076	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_8	0	0
3235077	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_8	0	0
3235078	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_8	0	0
3235079	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_8	0	0
3235080	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_8	0	0
3235081	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
3058410	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2021	grade_8	0	0
3058411	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2021	grade_8	67	67
3058412	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2021	grade_8	0	0
3231867	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2015	grade_8	67	67
3231868	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2016	grade_8	60	60
3231869	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2017	grade_8	0	0
3231870	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2018	grade_8	0	0
3231871	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2019	grade_8	0	0
3231872	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2020	grade_8	0	0
3231873	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2017	grade_8	66	66
3231874	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2018	grade_8	62	62
3231875	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2019	grade_8	62	62
3231876	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2020	grade_8	85	85
3231877	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2015	grade_8	0	0
3231878	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2016	grade_8	0	0
3231879	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2017	grade_8	0	0
3231880	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2018	grade_8	0	0
3231881	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2019	grade_8	0	0
3231882	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
3231883	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	grade_8	0	0
3231884	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2016	grade_8	0	0
3231885	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Elementary	PK	PK	2017	grade_8	0	0
3231886	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_8	0	0
3231887	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_8	0	0
3231888	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0	0
3059023	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2021	grade_8	55	55
3059024	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_8	0	0
3235511	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2015	grade_8	57	57
3235512	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2016	grade_8	45	45
3235513	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	Other	06	12	2017	grade_8	53	53
3235514	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2018	grade_8	49	49
3235515	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2019	grade_8	48	48
3235516	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2020	grade_8	54	54
3235517	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2015	grade_8	0	0
3235518	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2016	grade_8	0	0
3235519	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_8	0	0
3235520	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2018	grade_8	0	0
3235521	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_8	0	0
3235522	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
3059027	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2021	grade_8	0	0
3059028	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2021	grade_8	100	100
3059029	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_8	0	0
3059030	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2021	grade_8	0	0
3059031	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2021	grade_8	0	0
3235535	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2015	grade_8	0	0
3235536	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2016	grade_8	0	0
3235537	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2017	grade_8	0	0
3235538	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2018	grade_8	0	0
3235539	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2019	grade_8	0	0
3235540	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2020	grade_8	0	0
3235541	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2015	grade_8	117	117
3235542	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2016	grade_8	84	84
3235543	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2017	grade_8	92	92
3235544	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2018	grade_8	100	100
3235545	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2019	grade_8	109	109
3235546	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	111	111
3235547	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2015	grade_8	0	0
3235548	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2016	grade_8	0	0
3235549	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_8	0	0
3235550	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2018	grade_8	0	0
3235551	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_8	0	0
3235552	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
3235553	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2015	grade_8	0	0
3235554	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2016	grade_8	0	0
3235555	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2017	grade_8	0	0
3235556	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2018	grade_8	0	0
3235557	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2019	grade_8	0	0
3235558	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
3235559	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2015	grade_8	0	0
3235560	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2016	grade_8	0	0
3235561	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2017	grade_8	0	0
3235562	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2018	grade_8	0	0
3235563	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2019	grade_8	0	0
3235564	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
3059983	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901178	1050	W. E. SEARS YOUTH CTR.	Regular School	No	High	05	12	2021	grade_8	9	9
3059984	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901185	1051	SIERRA-OSAGE TREATMENT CTR.	Regular School	No	High	05	12	2021	grade_8	0	0
3059985	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901192	1052	GIRARDOT CENTER FOR YOUTH	Regular School	No	High	05	12	2021	grade_8	0	0
3059986	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902172	1054	FULTON TREATMENT CTR.	Regular School	No	High	06	12	2021	grade_8	10	10
3059987	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901195	1055	HOGAN ST REGIONAL YOUTH CTR.	Regular School	No	High	06	12	2021	grade_8	5	5
3059988	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901199	1058	BISSELL HALL	Regular School	No	High	06	12	2021	grade_8	5	5
3059989	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901215	1059	TWIN RIVERS	Regular School	No	High	06	12	2021	grade_8	0	0
3059990	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901226	1060	FORT BELLEFONTAINE CAMPUS	Regular School	No	High	06	12	2021	grade_8	0	0
3059991	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	High	06	12	2021	grade_8	0	0