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 > :p3 or (district = :p3 and rowid > :p2)) order by district, 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
3141925	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	1	PK	02	2016	grade_1	211	211
3141926	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2017	grade_1	207	207
3141927	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2018	grade_1	228	228
3141928	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2019	grade_1	200	200
3141929	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2020	grade_1	195	195
3141930	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2015	grade_1	0	0
3141931	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2016	grade_1	0	0
3141932	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2017	grade_1	0	0
3141933	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2018	grade_1	0	0
3141934	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2019	grade_1	0	0
3141935	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2020	grade_1	0	0
3042120	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2021	grade_1	0	0
3042121	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2021	grade_1	0	0
3042122	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_1	32	32
3134612	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2015	grade_1	0	0
3134613	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2016	grade_1	0	0
3134614	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2017	grade_1	0	0
3134615	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2018	grade_1	0	0
3134616	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2019	grade_1	0	0
3134617	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2020	grade_1	0	0
3134618	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2015	grade_1	0	0
3134619	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2016	grade_1	0	0
3134620	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2017	grade_1	0	0
3134621	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2018	grade_1	0	0
3134622	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2019	grade_1	0	0
3134623	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2020	grade_1	0	0
3134624	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2015	grade_1	36	36
3134625	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2016	grade_1	40	40
3134626	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	32	32
3134627	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	33	33
3134628	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	39	39
3134629	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	32	32
3042473	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2021	grade_1	0	0
3042474	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2021	grade_1	0	0
3042475	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2021	grade_1	23	23
3042476	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2021	grade_1	0	0
3042477	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	grade_1	0	0
3136729	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2015	grade_1	0	0
3136730	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2016	grade_1	0	0
3136731	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2017	grade_1	0	0
3136732	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2018	grade_1	0	0
3136733	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2019	grade_1	0	0
3136734	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2020	grade_1	0	0
3136735	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2019	grade_1	0	0
3136736	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2020	grade_1	0	0
3136737	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2019	grade_1	29	29
3136738	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2020	grade_1	41	41
3136739	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2015	grade_1	43	43
3136740	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2016	grade_1	40	40
3136741	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2017	grade_1	36	36
3136742	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2018	grade_1	40	40
3136743	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2019	grade_1	0	0
3136744	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2020	grade_1	0	0
3136687	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2015	grade_1	0	0
3136688	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2016	grade_1	0	0
3136689	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	High	09	12	2017	grade_1	0	0
3136693	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2015	grade_1	0	0
3136694	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2016	grade_1	0	0
3136695	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	Middle	06	08	2017	grade_1	0	0
3136699	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	02	2015	grade_1	56	56
3136700	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	03	2016	grade_1	73	73
3136701	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	Elementary	KG	04	2017	grade_1	75	75
3042923	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2021	grade_1	12	12
3139368	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2015	grade_1	7	7
3139369	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2016	grade_1	9	9
3139370	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2017	grade_1	13	13
3139371	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2018	grade_1	15	15
3139372	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2019	grade_1	11	11
3139373	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2020	grade_1	9	9
3042884	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	06	12	2021	grade_1	0	0
3042885	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	05	2021	grade_1	38	38
3139146	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2015	grade_1	0	0
3139147	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2016	grade_1	0	0
3139148	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2017	grade_1	0	0
3139149	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2018	grade_1	0	0
3139150	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2019	grade_1	0	0
3139151	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2020	grade_1	0	0
3139152	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	KG	06	2015	grade_1	46	46
3139153	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	PK	06	2016	grade_1	50	50
3139154	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	46	46
3139155	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2018	grade_1	47	47
3139156	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2019	grade_1	54	54
3139157	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	KG	06	2020	grade_1	47	47
3043161	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2021	grade_1	0	0
3043162	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	KG	05	2021	grade_1	19	19
3140759	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2015	grade_1	0	0
3140760	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2016	grade_1	0	0
3140761	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	Other	06	12	2017	grade_1	0	0
3140762	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2018	grade_1	0	0
3140763	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2019	grade_1	0	0
3140764	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2020	grade_1	0	0
3140765	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2015	grade_1	27	27
3140766	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2016	grade_1	22	22
3140767	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2017	grade_1	22	22
3140768	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2018	grade_1	22	22
3140769	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2019	grade_1	24	24
3140770	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1	29	29
3042285	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	High	09	12	2021	grade_1	0	0
3042286	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000023	3000	ARCADIA VALLEY MIDDLE	Regular School	No	Middle	05	08	2021	grade_1	0	0
3042287	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000021	4020	ARCADIA VALLEY ELEM.	Regular School	No	Elementary	PK	04	2021	grade_1	63	63
3135593	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	3	09	12	2015	grade_1	0	0