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_charter_school > :p2 or (ccd_charter_school = :p2 and rowid > :p1)) order by ccd_charter_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
3103458	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	06	12	2020	pre_kindergarten	0	0
3103459	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	11	11
3103460	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	24	24
3103461	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	21	21
3103462	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	23	23
3103463	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	19	19
3103464	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	22	22
3103465	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103466	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103467	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103468	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103469	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103470	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
3103471	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	0	0
3103472	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	24	24
3103473	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	24	24
3103474	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	8	8
3103475	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	0	0
3103476	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	16	16
3103477	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103478	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103479	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103480	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103481	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103482	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
3103483	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	0	0
3103484	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	10	10
3103485	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	8	8
3103486	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	6	6
3103487	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	8	8
3103488	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	14	14
3103489	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2015	pre_kindergarten	0	0
3103490	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2016	pre_kindergarten	0	0
3103491	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	Other	06	12	2017	pre_kindergarten	0	0
3103492	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2018	pre_kindergarten	0	0
3103493	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2019	pre_kindergarten	0	0
3103494	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2020	pre_kindergarten	0	0
3103495	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	20	20
3103496	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	20	20
3103497	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	20	20
3103498	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	20	20
3103499	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	19	19
3103500	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	20	20
3103501	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103502	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103503	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103504	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103505	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103506	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
3103507	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	23	23
3103508	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	24	24
3103509	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	19	19
3103510	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	25	25
3103511	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	41	41
3103512	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	27	27
3103513	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103514	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103515	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103516	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0
3103517	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103518	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2020	pre_kindergarten	0	0
3103519	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2015	pre_kindergarten	0	0
3103520	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103521	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103522	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2018	pre_kindergarten	0	0
3103523	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2019	pre_kindergarten	0	0
3103524	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2020	pre_kindergarten	0	0
3103525	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103526	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103527	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2017	pre_kindergarten	0	0
3103528	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103529	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103530	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	05	2020	pre_kindergarten	0	0
3103531	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3103532	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3103533	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2017	pre_kindergarten	0	0
3103534	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2018	pre_kindergarten	0	0
3103535	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2019	pre_kindergarten	0	0
3103536	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	01	05	2020	pre_kindergarten	0	0
3103537	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	117	117
3103538	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	110	110
3103539	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	113	113
3103540	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	114	114
3103541	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	131	131
3103542	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN EARLY LEARNING CENTER	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	177	177
3103543	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	3	07	12	2015	pre_kindergarten	0	0
3103544	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103545	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103546	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2018	pre_kindergarten	0	0
3103547	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103548	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2020	pre_kindergarten	0	0
3103549	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	33	33
3103550	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3103551	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	39	39
3103552	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	35	35
3103553	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	35	35
3103554	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	32	32
3103555	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	3	09	12	2015	pre_kindergarten	0	0
3103556	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103557	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103558	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	High	09	12	2018	pre_kindergarten	0	0