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 (asian > :p3 or (asian = :p3 and rowid > :p2)) order by asian, 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
3158679	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2019	grade_3	43	43
3158680	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	KG	05	2020	grade_3	50	50
3158681	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2015	grade_3	89	89
3158682	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2016	grade_3	88	88
3158683	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3	96	96
3158684	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2018	grade_3	87	87
3158685	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_3	110	110
3158686	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	KG	05	2020	grade_3	92	92
3158687	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	grade_3	0	0
3158688	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2016	grade_3	0	0
3158689	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Elementary	PK	PK	2017	grade_3	0	0
3158690	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_3	0	0
3158691	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_3	0	0
3158692	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
3158693	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2015	grade_3	0	0
3158694	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	3	07	12	2016	grade_3	0	0
3158695	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2017	grade_3	0	0
3158696	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2018	grade_3	0	0
3158697	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2019	grade_3	0	0
3158698	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	06	12	2020	grade_3	0	0
3158699	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2015	grade_3	20	20
3158700	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2016	grade_3	27	27
3158701	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2017	grade_3	27	27
3158702	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2018	grade_3	23	23
3158703	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2019	grade_3	30	30
3158704	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	05	2020	grade_3	27	27
3158705	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2015	grade_3	0	0
3158706	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	3	07	12	2016	grade_3	0	0
3158707	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2017	grade_3	0	0
3158708	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2018	grade_3	0	0
3158709	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2019	grade_3	0	0
3158710	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2020	grade_3	0	0
3158711	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2015	grade_3	21	21
3158712	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2016	grade_3	29	29
3158713	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2017	grade_3	23	23
3158714	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2018	grade_3	26	26
3158715	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2019	grade_3	33	33
3158716	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2020	grade_3	28	28
3158717	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2015	grade_3	0	0
3158718	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	3	07	12	2016	grade_3	0	0
3158719	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2017	grade_3	0	0
3158720	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2018	grade_3	0	0
3158721	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2019	grade_3	0	0
3158722	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2020	grade_3	0	0
3158723	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2015	grade_3	7	7
3158724	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2016	grade_3	11	11
3158725	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2017	grade_3	5	5
3158726	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2018	grade_3	10	10
3158727	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2019	grade_3	13	13
3158728	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2020	grade_3	8	8
3158729	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2015	grade_3	0	0
3158730	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	4	06	12	2016	grade_3	0	0
3158731	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	Other	06	12	2017	grade_3	0	0
3158732	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2018	grade_3	0	0
3158733	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2019	grade_3	0	0
3158734	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2020	grade_3	0	0
3158735	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2015	grade_3	23	23
3158736	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2016	grade_3	19	19
3158737	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3	20	20
3158738	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2018	grade_3	26	26
3158739	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2019	grade_3	18	18
3158740	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2020	grade_3	19	19
3158741	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2015	grade_3	0	0
3158742	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	3	07	12	2016	grade_3	0	0
3158743	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2017	grade_3	0	0
3158744	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2018	grade_3	0	0
3158745	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2019	grade_3	0	0
3158746	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2020	grade_3	0	0
3158747	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2015	grade_3	49	49
3158748	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2016	grade_3	55	55
3158749	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2017	grade_3	44	44
3158750	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2018	grade_3	40	40
3158751	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2019	grade_3	42	42
3158752	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2020	grade_3	34	34
3158753	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2015	grade_3	0	0
3158754	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2016	grade_3	0	0
3158755	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2017	grade_3	0	0
3158756	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2018	grade_3	0	0
3158757	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2019	grade_3	0	0
3158758	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2020	grade_3	0	0
3158759	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2015	grade_3	0	0
3158760	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	2	06	08	2016	grade_3	0	0
3158761	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2017	grade_3	0	0
3158762	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2018	grade_3	0	0
3158763	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2019	grade_3	0	0
3158764	MO	school	2920810	4110	MEXICO 59	292081001136	2050	MEXICO MIDDLE	Regular School	No	Middle	06	08	2020	grade_3	0	0
3158765	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2015	grade_3	69	69
3158766	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2016	grade_3	79	79
3158767	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2017	grade_3	82	82
3158768	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2018	grade_3	71	71
3158769	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2019	grade_3	62	62
3158770	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	05	2020	grade_3	93	93
3158771	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2015	grade_3	66	66
3158772	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2016	grade_3	85	85
3158773	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2017	grade_3	72	72
3158774	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2018	grade_3	82	82
3158775	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_3	74	74
3158776	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	Elementary	01	05	2020	grade_3	77	77
3158777	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2015	grade_3	41	41
3158778	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2016	grade_3	38	38
3158779	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2017	grade_3	33	33