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
3169545	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	1	PK	02	2016	grade_3	0	0
3169546	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2017	grade_3	0	0
3169547	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2018	grade_3	0	0
3169548	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2019	grade_3	0	0
3169549	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2020	grade_3	0	0
3169550	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2015	grade_3	164	164
3169551	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2016	grade_3	191	191
3169552	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2017	grade_3	200	200
3169553	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2018	grade_3	205	205
3169554	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2019	grade_3	197	197
3169555	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2020	grade_3	216	216
3046746	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2021	grade_3	0	0
3046747	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2021	grade_3	0	0
3046748	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_3	36	36
3162232	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2015	grade_3	0	0
3162233	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2016	grade_3	0	0
3162234	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2017	grade_3	0	0
3162235	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2018	grade_3	0	0
3162236	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2019	grade_3	0	0
3162237	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2020	grade_3	0	0
3162238	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2015	grade_3	0	0
3162239	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2016	grade_3	0	0
3162240	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2017	grade_3	0	0
3162241	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2018	grade_3	0	0
3162242	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2019	grade_3	0	0
3162243	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2020	grade_3	0	0
3162244	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2015	grade_3	34	34
3162245	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2016	grade_3	33	33
3162246	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3	32	32
3162247	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2018	grade_3	36	36
3162248	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_3	31	31
3162249	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2020	grade_3	23	23
3047099	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2021	grade_3	0	0
3047100	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2021	grade_3	0	0
3047101	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2021	grade_3	0	0
3047102	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2021	grade_3	28	28
3047103	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	grade_3	0	0
3164349	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2015	grade_3	0	0
3164350	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2016	grade_3	0	0
3164351	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2017	grade_3	0	0
3164352	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2018	grade_3	0	0
3164353	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2019	grade_3	0	0
3164354	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2020	grade_3	0	0
3164355	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2019	grade_3	0	0
3164356	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2020	grade_3	0	0
3164357	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2019	grade_3	0	0
3164358	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2020	grade_3	0	0
3164359	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2015	grade_3	50	50
3164360	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2016	grade_3	63	63
3164361	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2017	grade_3	47	47
3164362	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2018	grade_3	46	46
3164363	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2019	grade_3	39	39
3164364	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2020	grade_3	38	38
3164307	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2015	grade_3	0	0
3164308	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2016	grade_3	0	0
3164309	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	High	09	12	2017	grade_3	0	0
3164313	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2015	grade_3	0	0
3164314	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2016	grade_3	0	0
3164315	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	Middle	06	08	2017	grade_3	0	0
3164319	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	02	2015	grade_3	0	0
3164320	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	03	2016	grade_3	77	77
3164321	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	Elementary	KG	04	2017	grade_3	69	69
3047549	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2021	grade_3	8	8
3166988	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2015	grade_3	14	14
3166989	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2016	grade_3	8	8
3166990	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2017	grade_3	5	5
3166991	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2018	grade_3	9	9
3166992	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2019	grade_3	11	11
3166993	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2020	grade_3	16	16
3047510	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	06	12	2021	grade_3	0	0
3047511	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	05	2021	grade_3	41	41
3166766	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2015	grade_3	0	0
3166767	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2016	grade_3	0	0
3166768	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2017	grade_3	0	0
3166769	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2018	grade_3	0	0
3166770	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2019	grade_3	0	0
3166771	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2020	grade_3	0	0
3166772	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	KG	06	2015	grade_3	64	64
3166773	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	PK	06	2016	grade_3	52	52
3166774	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2017	grade_3	42	42
3166775	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2018	grade_3	51	51
3166776	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2019	grade_3	54	54
3166777	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	KG	06	2020	grade_3	62	62
3047787	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2021	grade_3	0	0
3047788	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	KG	05	2021	grade_3	22	22
3168379	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2015	grade_3	0	0
3168380	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2016	grade_3	0	0
3168381	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	Other	06	12	2017	grade_3	0	0
3168382	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2018	grade_3	0	0
3168383	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2019	grade_3	0	0
3168384	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2020	grade_3	0	0
3168385	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2015	grade_3	20	20
3168386	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2016	grade_3	22	22
3168387	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3	22	22
3168388	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2018	grade_3	28	28
3168389	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2019	grade_3	26	26
3168390	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2020	grade_3	21	21
3046911	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	High	09	12	2021	grade_3	0	0
3046912	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000023	3000	ARCADIA VALLEY MIDDLE	Regular School	No	Middle	05	08	2021	grade_3	0	0
3046913	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000021	4020	ARCADIA VALLEY ELEM.	Regular School	No	Elementary	PK	04	2021	grade_3	62	62
3163213	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	3	09	12	2015	grade_3	0	0