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 school_nces_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
3045071	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	grade_2	53	53
3152216	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_2	63	63
3152217	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_2	61	61
3152218	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_2	48	48
3152219	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_2	41	41
3152220	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_2	46	46
3152221	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_2	49	49
3045069	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2021	grade_2	0	0
3152204	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2015	grade_2	0	0
3152205	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2016	grade_2	0	0
3152206	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2017	grade_2	0	0
3152207	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2018	grade_2	0	0
3152208	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2019	grade_2	0	0
3152209	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2020	grade_2	0	0
3045070	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2021	grade_2	0	0
3152210	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2015	grade_2	0	0
3152211	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2016	grade_2	0	0
3152212	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2017	grade_2	0	0
3152213	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2018	grade_2	0	0
3152214	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2019	grade_2	0	0
3152215	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2020	grade_2	0	0
3149023	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	grade_2	0	0
3149024	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2016	grade_2	0	0
3149025	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Elementary	PK	PK	2017	grade_2	0	0
3149026	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_2	0	0
3149027	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_2	0	0
3149028	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
3044534	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2021	grade_2	62	62
3149017	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2015	grade_2	71	71
3149018	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2016	grade_2	81	81
3149019	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2017	grade_2	75	75
3149020	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2018	grade_2	66	66
3149021	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2019	grade_2	54	54
3149022	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2020	grade_2	68	68
3044532	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2021	grade_2	0	0
3149007	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2015	grade_2	0	0
3149008	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2016	grade_2	0	0
3149009	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2017	grade_2	0	0
3149010	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2018	grade_2	0	0
3149011	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2019	grade_2	0	0
3149012	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2020	grade_2	0	0
3044533	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2021	grade_2	0	0
3149013	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2017	grade_2	0	0
3149014	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2018	grade_2	0	0
3149015	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2019	grade_2	0	0
3149016	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2020	grade_2	0	0
3045145	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2021	grade_2	0	0
3152651	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2015	grade_2	0	0
3152652	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2016	grade_2	0	0
3152653	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	Other	06	12	2017	grade_2	0	0
3152654	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2018	grade_2	0	0
3152655	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2019	grade_2	0	0
3152656	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2020	grade_2	0	0
3045146	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_2	60	60
3152657	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2015	grade_2	61	61
3152658	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2016	grade_2	50	50
3152659	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_2	58	58
3152660	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2018	grade_2	56	56
3152661	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_2	42	42
3152662	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2020	grade_2	48	48
3045151	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_2	35	35
3152687	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2015	grade_2	49	49
3152688	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2016	grade_2	43	43
3152689	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_2	45	45
3152690	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2018	grade_2	37	37
3152691	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_2	40	40
3152692	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_2	37	37
3045153	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2021	grade_2	38	38
3152699	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2015	grade_2	54	54
3152700	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2016	grade_2	43	43
3152701	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2017	grade_2	34	34
3152702	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2018	grade_2	43	43
3152703	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2019	grade_2	40	40
3152704	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2020	grade_2	43	43
3045152	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2021	grade_2	29	29
3152693	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2015	grade_2	23	23
3152694	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2016	grade_2	28	28
3152695	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2017	grade_2	20	20
3152696	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2018	grade_2	19	19
3152697	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2019	grade_2	22	22
3152698	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2020	grade_2	19	19
3045149	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2021	grade_2	0	0
3152675	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2015	grade_2	0	0
3152676	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2016	grade_2	0	0
3152677	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2017	grade_2	0	0
3152678	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2018	grade_2	0	0
3152679	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2019	grade_2	0	0
3152680	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2020	grade_2	0	0
3045150	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2021	grade_2	0	0
3152681	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2015	grade_2	0	0
3152682	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2016	grade_2	0	0
3152683	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2017	grade_2	0	0
3152684	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2018	grade_2	0	0
3152685	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2019	grade_2	0	0
3152686	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2020	grade_2	0	0
3158346	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2015	grade_2	0	0
3158347	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	4	06	12	2016	grade_2	0	0
3158348	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	Other	06	12	2017	grade_2	0	0
3158349	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2018	grade_2	0	0
3158350	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	grade_2	0	0
3158351	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2020	grade_2	0	0