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 "state" = :p0 and (ccd_school_low_grade < :p2 or ccd_school_low_grade is null or (ccd_school_low_grade = :p2 and rowid > :p1)) order by ccd_school_low_grade desc, 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
3104996	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	17	17
3104997	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	10	10
3104998	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	14	14
3104999	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	11	11
3105000	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	15	15
3105007	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	40	40
3105008	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	34	34
3105009	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	39	39
3105010	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	46	46
3105011	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	42	42
3105012	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	39	39
3105019	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	5	5
3105020	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	8	8
3105021	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	5	5
3105022	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	6	6
3105023	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	8	8
3105024	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	7	7
3105030	MO	school	2929670	19140	STRASBURG C-3	292967002051	4020	STRASBURG ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	0	0
3105052	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001427	4040	RAYMORE ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten	149	149
3105053	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001427	4040	RAYMORE ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	160	160
3105054	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001427	4040	RAYMORE ELEM.	Regular School	No	Elementary	PK	04	2017	pre_kindergarten	176	176
3105091	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	169	169
3105092	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	163	163
3105093	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	173	173
3105106	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	30	30
3105107	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	40	40
3105108	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	40	40
3105109	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	45	45
3105110	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	41	41
3105111	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	41	41
3105112	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	1	PK	08	2015	pre_kindergarten	21	21
3105113	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	1	PK	08	2016	pre_kindergarten	18	18
3105114	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2017	pre_kindergarten	17	17
3105115	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2018	pre_kindergarten	10	10
3105116	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2019	pre_kindergarten	13	13
3105117	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	0	0
3105130	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	1	PK	02	2015	pre_kindergarten	169	169
3105131	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	1	PK	02	2016	pre_kindergarten	40	40
3105132	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	216	216
3105133	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2018	pre_kindergarten	44	44
3105134	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2019	pre_kindergarten	45	45
3105135	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	44	44
3105177	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	KG	2015	pre_kindergarten	152	152
3105178	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	KG	2016	pre_kindergarten	135	135
3105179	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2017	pre_kindergarten	137	137
3105180	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2018	pre_kindergarten	140	140
3105181	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2019	pre_kindergarten	133	133
3105182	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	89	89
3105189	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	10	10
3105190	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	20	20
3105191	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	9	9
3105192	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	30	30
3105193	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	10	10
3105194	MO	school	2911070	19150	DREXEL R-IV	291107000378	4020	DREXEL ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	6	6
3105254	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	283	283
3105255	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	1	PK	PK	2016	pre_kindergarten	263	263
3105256	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	335	335
3105257	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	306	306
3105258	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	298	298
3105259	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	303	303
3105260	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	73	73
3105273	MO	school	2929520	20001	STOCKTON R-I	292952002043	4020	STOCKTON ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten	18	18
3105275	MO	school	2929520	20001	STOCKTON R-I	292952002043	4020	STOCKTON ELEM.	Regular School	No	Elementary	PK	04	2017	pre_kindergarten	34	34
3105276	MO	school	2929520	20001	STOCKTON R-I	292952002043	4020	STOCKTON ELEM.	Regular School	No	Elementary	PK	04	2018	pre_kindergarten	38	38
3105279	MO	school	2929520	20001	STOCKTON R-I	292952003323	7500	LITTLE TIGER PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	42	42
3105280	MO	school	2929520	20001	STOCKTON R-I	292952003323	7500	LITTLE TIGER PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	33	33
3105293	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	24	24
3105294	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	23	23
3105295	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	33	33
3105296	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	43	43
3105297	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	47	47
3105298	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000400	4040	EL DORADO SPRINGS ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	45	45
3105305	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	13	13
3105306	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	15	15
3105307	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	12	12
3105308	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	16	16
3105309	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	31	31
3105310	MO	school	2922920	21148	NORTHWESTERN R-I	292292001310	4020	NORTHWESTERN ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	25	25
3105317	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	35	35
3105318	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	34	34
3105319	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	43	43
3105320	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	41	41
3105321	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	31	31
3105322	MO	school	2906030	21149	BRUNSWICK R-II	290603000144	4020	BRUNSWICK ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	32	32
3105329	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	9	9
3105330	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	15	15
3105331	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	15	15
3105332	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	14	14
3105333	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	13	13
3105334	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	14	14
3105344	MO	school	2927520	21151	SALISBURY R-IV	292752001683	4040	SALISBURY ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	5	5
3105345	MO	school	2927520	21151	SALISBURY R-IV	292752001683	4040	SALISBURY ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	0	0
3105346	MO	school	2927520	21151	SALISBURY R-IV	292752001683	4040	SALISBURY ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	0	0
3105353	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	1	PK	06	2015	pre_kindergarten	18	18
3105354	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	1	PK	06	2016	pre_kindergarten	17	17
3105355	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	30	30
3105356	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	33	33
3105357	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	36	36
3105358	MO	school	2908430	22088	CHADWICK R-I	290843000245	4020	CHADWICK ELEMENTARY	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	34	34
3105371	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	164	164
3105372	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2016	pre_kindergarten	176	176