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 district_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
3042756	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2021	grade_1	0	0
3042757	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2021	grade_1	0	0
3042758	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2021	grade_1	47	47
3138394	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2015	grade_1	0	0
3138395	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	3	09	12	2016	grade_1	0	0
3138396	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2017	grade_1	0	0
3138397	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2018	grade_1	0	0
3138398	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2019	grade_1	0	0
3138399	MO	school	2900001	63067	MARIES CO. R-II	290000100049	1050	BELLE HIGH	Regular School	No	High	09	12	2020	grade_1	0	0
3138400	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2015	grade_1	0	0
3138401	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	2	05	08	2016	grade_1	0	0
3138402	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2017	grade_1	0	0
3138403	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2018	grade_1	0	0
3138404	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2019	grade_1	0	0
3138405	MO	school	2900001	63067	MARIES CO. R-II	290000102547	3000	MARIES CO. MIDDLE	Regular School	No	Middle	05	08	2020	grade_1	0	0
3138406	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2015	grade_1	65	65
3138407	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	1	PK	04	2016	grade_1	47	47
3138408	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2017	grade_1	47	47
3138409	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2018	grade_1	44	44
3138410	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2019	grade_1	47	47
3138411	MO	school	2900001	63067	MARIES CO. R-II	290000100048	4020	BELLE ELEM.	Regular School	No	Elementary	PK	04	2020	grade_1	54	54
3042219	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2021	grade_1	0	0
3042220	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2021	grade_1	0	0
3042221	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2021	grade_1	62	62
3135197	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2015	grade_1	0	0
3135198	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	4	06	12	2016	grade_1	0	0
3135199	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2017	grade_1	0	0
3135200	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2018	grade_1	0	0
3135201	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2019	grade_1	0	0
3135202	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201642	1050	SOUTH HARRISON HIGH	Regular School	No	High	09	12	2020	grade_1	0	0
3135203	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2017	grade_1	0	0
3135204	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2018	grade_1	0	0
3135205	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2019	grade_1	0	0
3135206	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000203297	3000	SOUTH HARRISON MIDDLE	Regular School	No	Middle	05	08	2020	grade_1	0	0
3135207	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2015	grade_1	79	79
3135208	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	1	KG	05	2016	grade_1	75	75
3135209	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2017	grade_1	66	66
3135210	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2018	grade_1	57	57
3135211	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2019	grade_1	71	71
3135212	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000201641	4020	SOUTH HARRISON ELEM.	Regular School	No	Elementary	KG	04	2020	grade_1	61	61
3135213	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	grade_1	0	0
3135214	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2016	grade_1	0	0
3135215	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Elementary	PK	PK	2017	grade_1	0	0
3135216	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_1	0	0
3135217	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_1	0	0
3135218	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
3042832	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2021	grade_1	0	0
3042833	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_1	49	49
3138841	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2015	grade_1	0	0
3138842	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	4	06	12	2016	grade_1	0	0
3138843	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	Other	06	12	2017	grade_1	0	0
3138844	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2018	grade_1	0	0
3138845	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2019	grade_1	0	0
3138846	MO	school	2900003	72068	PORTAGEVILLE	290000302458	1050	PORTAGEVILLE HIGH	Regular School	No	High	06	12	2020	grade_1	0	0
3138847	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2015	grade_1	53	53
3138848	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	1	PK	05	2016	grade_1	60	60
3138849	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	52	52
3138850	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	48	48
3138851	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	52	52
3138852	MO	school	2900003	72068	PORTAGEVILLE	290000302459	4020	PORTAGEVILLE ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	59	59
3042836	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2021	grade_1	0	0
3042837	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2021	grade_1	0	0
3042838	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_1	38	38
3042839	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2021	grade_1	31	31
3042840	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2021	grade_1	42	42
3138865	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2015	grade_1	0	0
3138866	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	3	09	12	2016	grade_1	0	0
3138867	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2017	grade_1	0	0
3138868	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2018	grade_1	0	0
3138869	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2019	grade_1	0	0
3138870	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401488	1060	CENTRAL HIGH	Regular School	No	High	09	12	2020	grade_1	0	0
3138871	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2015	grade_1	0	0
3138872	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	2	06	08	2016	grade_1	0	0
3138873	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2017	grade_1	0	0
3138874	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2018	grade_1	0	0
3138875	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2019	grade_1	0	0
3138876	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401991	3000	CENTRAL MIDDLE	Regular School	No	Middle	06	08	2020	grade_1	0	0
3138877	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2015	grade_1	45	45
3138878	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	1	PK	05	2016	grade_1	45	45
3138879	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	34	34
3138880	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	42	42
3138881	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	39	39
3138882	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401482	4100	LILBOURN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	40	40
3138883	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2015	grade_1	26	26
3138884	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	1	PK	05	2016	grade_1	25	25
3138885	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	19	19
3138886	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	20	20
3138887	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	21	21
3138888	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401486	4120	MATTHEWS ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	26	26
3138889	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2015	grade_1	47	47
3138890	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	1	PK	05	2016	grade_1	34	34
3138891	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	51	51
3138892	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	38	38
3138893	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	37	37
3138894	MO	school	2900004	72074	NEW MADRID CO. R-I	290000401484	4140	NEW MADRID ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	35	35
3043792	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901178	1050	W. E. SEARS YOUTH CTR.	Regular School	No	High	05	12	2021	grade_1	0	0
3043793	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901185	1051	SIERRA-OSAGE TREATMENT CTR.	Regular School	No	High	05	12	2021	grade_1	0	0
3043794	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901192	1052	GIRARDOT CENTER FOR YOUTH	Regular School	No	High	05	12	2021	grade_1	0	0
3043795	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902172	1054	FULTON TREATMENT CTR.	Regular School	No	High	06	12	2021	grade_1	0	0
3043796	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901195	1055	HOGAN ST REGIONAL YOUTH CTR.	Regular School	No	High	06	12	2021	grade_1	0	0
3043797	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901199	1058	BISSELL HALL	Regular School	No	High	06	12	2021	grade_1	0	0