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 (school > :p3 or (school = :p3 and rowid > :p2)) order by 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
3172399	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2019	grade_4	18	18
3172400	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2020	grade_4	15	15
3172431	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2015	grade_4	15	15
3172432	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2016	grade_4	17	17
3172433	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2017	grade_4	13	13
3172434	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2018	grade_4	14	14
3172435	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2019	grade_4	9	9
3172436	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_4	11	11
3048445	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2021	grade_4	0	0
3048451	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2021	grade_4	0	0
3172389	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	grade_4	0	0
3172390	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2016	grade_4	0	0
3172391	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	grade_4	0	0
3172392	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	grade_4	0	0
3172393	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	grade_4	0	0
3172394	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_4	0	0
3172425	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2015	grade_4	0	0
3172426	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	3	07	12	2016	grade_4	0	0
3172427	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	grade_4	0	0
3172428	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	grade_4	0	0
3172429	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	grade_4	0	0
3172430	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_4	0	0
3050612	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	Elementary	PK	06	2021	grade_4	18	18
3185260	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	1	PK	06	2015	grade_4	34	34
3185261	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	1	PK	06	2016	grade_4	46	46
3185262	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	Elementary	PK	06	2017	grade_4	40	40
3185263	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	Elementary	PK	06	2018	grade_4	40	40
3185264	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	Elementary	PK	06	2019	grade_4	21	21
3185265	MO	school	2929280	115115	ST. LOUIS CITY	292928002789	4000	ADAMS ELEM.	Regular School	No	Elementary	PK	06	2020	grade_4	36	36
3174009	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	1	PK	01	2015	grade_4	0	0
3174010	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	1	PK	01	2016	grade_4	0	0
3174011	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2017	grade_4	0	0
3174012	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2018	grade_4	0	0
3174013	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2019	grade_4	0	0
3174014	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2020	grade_4	0	0
3048513	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_4	51	51
3172802	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	1	PK	05	2015	grade_4	50	50
3172803	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	1	PK	05	2016	grade_4	52	52
3172804	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_4	53	53
3172805	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2018	grade_4	47	47
3172806	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_4	59	59
3172807	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_4	50	50
3048512	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2021	grade_4	0	0
3172796	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	4	06	12	2015	grade_4	0	0
3172797	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	4	06	12	2016	grade_4	0	0
3172798	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	Other	06	12	2017	grade_4	0	0
3172799	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2018	grade_4	0	0
3172800	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2019	grade_4	0	0
3172801	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_4	0	0
3050446	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2021	grade_4	27	27
3184275	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	1	PK	06	2015	grade_4	35	35
3184276	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	1	PK	06	2016	grade_4	44	44
3184277	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	PK	06	2017	grade_4	28	28
3184278	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	PK	06	2018	grade_4	33	33
3184279	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_4	30	30
3184280	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_4	25	25
3050445	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2021	grade_4	0	0
3184269	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	3	07	12	2015	grade_4	0	0
3184270	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	3	07	12	2016	grade_4	0	0
3184271	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2017	grade_4	0	0
3184272	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2018	grade_4	0	0
3184273	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2019	grade_4	0	0
3184274	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_4	0	0
3050447	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_4	0	0
3184281	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	grade_4	0	0
3184282	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
3050292	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	High	09	12	2021	grade_4	0	0
3183342	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	3	09	12	2015	grade_4	0	0
3183343	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	3	09	12	2016	grade_4	0	0
3183344	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	High	09	12	2017	grade_4	0	0
3183345	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	High	09	12	2018	grade_4	0	0
3183346	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	High	09	12	2019	grade_4	0	0
3183347	MO	school	2902910	96098	AFFTON 101	290291000009	1050	AFFTON HIGH	Regular School	No	High	09	12	2020	grade_4	0	0
3177890	MO	school	2916400	48078	KANSAS CITY 33	291640003097	1670	AFRICAN CENT COLLEGE PREP ACAD	Regular School	No	3	07	12	2015	grade_4	0	0
3177891	MO	school	2916400	48078	KANSAS CITY 33	291640003097	1670	AFRICAN CENT COLLEGE PREP ACAD	Regular School	No	3	07	12	2016	grade_4	0	0
3182618	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000449	4010	AIRPORT ELEM.	Regular School	No	1	KG	06	2015	grade_4	40	40
3182619	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000449	4010	AIRPORT ELEM.	Regular School	No	1	KG	06	2016	grade_4	34	34
3182620	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000449	4010	AIRPORT ELEM.	Regular School	No	Elementary	KG	05	2017	grade_4	38	38
3182621	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000449	4010	AIRPORT ELEM.	Regular School	No	Elementary	KG	05	2018	grade_4	44	44
3182622	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000449	4010	AIRPORT ELEM.	Regular School	No	Elementary	PK	05	2019	grade_4	24	24
3049059	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2021	grade_4	0	0
3176042	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2015	grade_4	0	0
3176043	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2016	grade_4	0	0
3176044	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2017	grade_4	0	0
3176045	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2018	grade_4	0	0
3176046	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2019	grade_4	0	0
3176047	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2020	grade_4	0	0
3049060	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2021	grade_4	0	0
3176048	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2015	grade_4	0	0
3176049	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2016	grade_4	0	0
3176050	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2017	grade_4	0	0
3176051	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2018	grade_4	0	0
3176052	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2019	grade_4	0	0
3176053	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2020	grade_4	0	0
3048843	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	Elementary	KG	05	2021	grade_4	57	57
3174760	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	1	KG	05	2015	grade_4	72	72
3174761	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	1	KG	05	2016	grade_4	64	64
3174762	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	Elementary	KG	05	2017	grade_4	59	59
3174763	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	Elementary	KG	05	2018	grade_4	61	61
3174764	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	Elementary	KG	05	2019	grade_4	63	63
3174765	MO	school	2918540	24090	LIBERTY 53	291854001004	4020	ALEXANDER DONIPHAN ELEM.	Regular School	No	Elementary	KG	05	2020	grade_4	66	66