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
3321455	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	1	PK	02	2016	pk_12_total	768	768
3321456	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2017	pk_12_total	812	812
3321457	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2018	pk_12_total	842	842
3321458	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2019	pk_12_total	818	818
3321459	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2020	pk_12_total	621	621
3321460	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2015	pk_12_total	526	526
3321461	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2016	pk_12_total	543	543
3321462	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2017	pk_12_total	571	571
3321463	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2018	pk_12_total	592	592
3321464	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2019	pk_12_total	594	594
3321465	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2020	pk_12_total	794	794
3072189	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2021	pk_12_total	127	127
3072190	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2021	pk_12_total	93	93
3072191	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2021	pk_12_total	231	231
3314142	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2015	pk_12_total	127	127
3314143	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	3	09	12	2016	pk_12_total	112	112
3314144	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2017	pk_12_total	107	107
3314145	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2018	pk_12_total	114	114
3314146	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2019	pk_12_total	116	116
3314147	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2020	pk_12_total	124	124
3314148	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2015	pk_12_total	86	86
3314149	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	2	06	08	2016	pk_12_total	88	88
3314150	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2017	pk_12_total	105	105
3314151	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total	100	100
3314152	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	99	99
3314153	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2020	pk_12_total	91	91
3314154	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2015	pk_12_total	235	235
3314155	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	1	PK	05	2016	pk_12_total	231	231
3314156	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2017	pk_12_total	227	227
3314157	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2018	pk_12_total	214	214
3314158	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	231	231
3314159	MO	school	2902970	38046	ALBANY R-III	290297000011	4020	VIRGINIA E. GEORGE ELEM.	Regular School	No	Elementary	PK	05	2020	pk_12_total	227	227
3072542	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2021	pk_12_total	164	164
3072543	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2021	pk_12_total	131	131
3072544	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2021	pk_12_total	93	93
3072545	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2021	pk_12_total	101	101
3072546	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	pk_12_total	11	11
3316259	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2015	pk_12_total	145	145
3316260	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	3	09	12	2016	pk_12_total	161	161
3316261	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2017	pk_12_total	162	162
3316262	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2018	pk_12_total	186	186
3316263	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2019	pk_12_total	179	179
3316264	MO	school	2900025	48909	ALLEN VILLAGE	290002503233	1980	ALLEN VILLAGE HIGH SCHOOL	Regular School	Yes	High	09	12	2020	pk_12_total	182	182
3316265	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2019	pk_12_total	159	159
3316266	MO	school	2900025	48909	ALLEN VILLAGE	290002503325	3930	ALLEN VILLAGE JUNIOR	Regular School	Yes	Middle	06	08	2020	pk_12_total	149	149
3316267	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2019	pk_12_total	109	109
3316268	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2020	pk_12_total	94	94
3316269	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2015	pk_12_total	494	494
3316270	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	1	KG	08	2016	pk_12_total	511	511
3316271	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2017	pk_12_total	451	451
3316272	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE SCHOOL	Regular School	Yes	Elementary	KG	08	2018	pk_12_total	419	419
3316273	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2019	pk_12_total	127	127
3316274	MO	school	2900025	48909	ALLEN VILLAGE	290002502748	6915	ALLEN VILLAGE ELEMENTARY	Regular School	Yes	Elementary	03	05	2020	pk_12_total	123	123
3316217	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2015	pk_12_total	320	320
3316218	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	3	09	12	2016	pk_12_total	359	359
3316219	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002902741	1925	ALTA VISTA CHARTER SCHOOL	Regular School	Yes	High	09	12	2017	pk_12_total	370	370
3316223	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2015	pk_12_total	186	186
3316224	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	2	06	08	2016	pk_12_total	195	195
3316225	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903166	3925	ALTA VISTA MIDDLE SCHOOL	Regular School	Yes	Middle	06	08	2017	pk_12_total	202	202
3316229	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	02	2015	pk_12_total	205	205
3316230	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	1	KG	03	2016	pk_12_total	295	295
3316231	MO	school	2900029	48902	ALTA VISTA CHARTER SCH.	290002903216	6905	ALTA VISTA ELEMENTARY SCHOOL	Regular School	Yes	Elementary	KG	04	2017	pk_12_total	351	351
3072992	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2021	pk_12_total	89	89
3318898	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2015	pk_12_total	90	90
3318899	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	1	KG	08	2016	pk_12_total	97	97
3318900	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2017	pk_12_total	100	100
3318901	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2018	pk_12_total	93	93
3318902	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2019	pk_12_total	98	98
3318903	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2020	pk_12_total	98	98
3072953	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	06	12	2021	pk_12_total	322	322
3072954	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	263	263
3318676	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2015	pk_12_total	317	317
3318677	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	3	07	12	2016	pk_12_total	301	301
3318678	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2017	pk_12_total	301	301
3318679	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2018	pk_12_total	300	300
3318680	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2019	pk_12_total	315	315
3318681	MO	school	2903060	75087	ALTON R-IV	290306000016	1050	Alton High	Regular School	No	High	07	12	2020	pk_12_total	313	313
3318682	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	KG	06	2015	pk_12_total	348	348
3318683	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	1	PK	06	2016	pk_12_total	402	402
3318684	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2017	pk_12_total	381	381
3318685	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2018	pk_12_total	395	395
3318686	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	PK	06	2019	pk_12_total	408	408
3318687	MO	school	2903060	75087	ALTON R-IV	290306000015	4020	Alton Elementary	Regular School	No	Elementary	KG	06	2020	pk_12_total	368	368
3073230	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2021	pk_12_total	182	182
3073231	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	KG	05	2021	pk_12_total	147	147
3320289	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2015	pk_12_total	200	200
3320290	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	4	06	12	2016	pk_12_total	209	209
3320291	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	Other	06	12	2017	pk_12_total	196	196
3320292	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2018	pk_12_total	195	195
3320293	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2019	pk_12_total	179	179
3320294	MO	school	2903120	93120	APPLETON CITY R-II	290312000019	1050	APPLETON CITY HIGH	Regular School	No	High	06	12	2020	pk_12_total	177	177
3320295	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2015	pk_12_total	141	141
3320296	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	1	KG	05	2016	pk_12_total	127	127
3320297	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2017	pk_12_total	156	156
3320298	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2018	pk_12_total	166	166
3320299	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	159	159
3320300	MO	school	2903120	93120	APPLETON CITY R-II	290312000017	4010	APPLETON CITY ELEM.	Regular School	No	Elementary	PK	05	2020	pk_12_total	150	150
3072354	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	High	09	12	2021	pk_12_total	331	331
3072355	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000023	3000	ARCADIA VALLEY MIDDLE	Regular School	No	Middle	05	08	2021	pk_12_total	267	267
3072356	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000021	4020	ARCADIA VALLEY ELEM.	Regular School	No	Elementary	PK	04	2021	pk_12_total	356	356
3315123	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	3	09	12	2015	pk_12_total	345	345