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 "year" = :p1 order by ccd_charter_school 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
3110381	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	pre_kindergarten	212	212
3110591	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	pre_kindergarten	180	180
3124191	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	kindergarten	0	0
3124401	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	kindergarten	0	0
3138001	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_1	0	0
3138211	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_1	0	0
3151811	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_2	0	0
3152021	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_2	0	0
3165621	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_3	0	0
3165831	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_3	0	0
3179431	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_4	0	0
3179641	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_4	0	0
3193241	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_5	0	0
3193451	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_5	0	0
3207051	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_6	0	0
3207261	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_6	0	0
3220861	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_7	0	0
3221071	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_7	0	0
3234671	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_8	0	0
3234881	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_8	0	0
3248481	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_9	0	0
3248691	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_9	0	0
3262291	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_10	0	0
3262501	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_10	0	0
3276101	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_11	0	0
3276311	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_11	0	0
3289911	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	grade_12	0	0
3290121	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	grade_12	0	0
3303721	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	k_12_total	0	0
3303931	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	k_12_total	0	0
3317531	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2017	pk_12_total	212	212
3317741	MO	school		60077	MCDONALD CO. R-I		1000	CENTRAL OFFICE						2017	pk_12_total	180	180
3103341	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103347	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	20	20
3103353	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103359	MO	school	2916740	1091	KIRKSVILLE R-III	291674002611	3000	WILLIAM MATTHEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103365	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	163	163
3103371	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3103377	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103383	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2017	pre_kindergarten	0	0
3103389	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103395	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271000006	3000	NORTH ANDREW MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103401	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	KG	05	2017	pre_kindergarten	0	0
3103407	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2017	pre_kindergarten	24	24
3103413	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103419	MO	school	2927570	2097	SAVANNAH R-III	292757001691	3000	SAVANNAH MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103425	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	0	0
3103431	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	10	10
3103437	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	14	14
3103443	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	58	58
3103449	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	84	84
3103455	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103461	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	21	21
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
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
3103479	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103485	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	8	8
3103491	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	Other	06	12	2017	pre_kindergarten	0	0
3103497	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	20	20
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
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
3103515	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2017	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
3103527	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	KG	05	2017	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
3103539	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	113	113
3103545	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103551	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	39	39
3103557	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103563	MO	school	2928710	5121	SOUTHWEST R-V	292871002801	3000	SOUTHWEST MIDDLE	Regular School	No	Middle	05	08	2017	pre_kindergarten	0	0
3103569	MO	school	2928710	5121	SOUTHWEST R-V	292871001773	4020	SOUTHWEST ELEM.	Regular School	No	Elementary	PK	04	2017	pre_kindergarten	60	60
3103575	MO	school	2911670	5122	EXETER R-VI	291167000427	1050	EXETER HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103581	MO	school	2911670	5122	EXETER R-VI	291167000426	4020	EXETER ELEM.	Regular School	No	Elementary	KG	08	2017	pre_kindergarten	0	0
3103587	MO	school	2908170	5123	CASSVILLE R-IV	290817000219	1050	CASSVILLE HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103593	MO	school	2908170	5123	CASSVILLE R-IV	290817002425	3000	CASSVILLE MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103599	MO	school	2908170	5123	CASSVILLE R-IV	290817000217	4020	EUNICE THOMAS ELEM.	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	84	84
3103605	MO	school	2908170	5123	CASSVILLE R-IV	290817002718	4030	CASSVILLE INTERMEDIATE	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3103611	MO	school	2925620	5124	PURDY R-II	292562001502	1050	PURDY HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103617	MO	school	2925620	5124	PURDY R-II	292562002221	3000	PURDY MIDDLE	Regular School	No	Middle	05	08	2017	pre_kindergarten	0	0
3103621	MO	school	2925620	5124	PURDY R-II	292562001501	4020	PURDY ELEM.	Regular School	No	Elementary	KG	04	2017	pre_kindergarten	0	0
3103628	MO	school	2928200	5127	SHELL KNOB 78	292820001735	4020	SHELL KNOB ELEM.	Regular School	No	Elementary	PK	08	2017	pre_kindergarten	27	27
3103634	MO	school	2921120	5128	MONETT R-I	292112001162	1050	MONETT HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103640	MO	school	2921120	5128	MONETT R-I	292112000183	3000	MONETT MIDDLE	Regular School	No	Middle	07	08	2017	pre_kindergarten	0	0
3103646	MO	school	2921120	5128	MONETT R-I	292112003089	4000	CENTRAL PARK ELEM.	Regular School	No	Elementary	03	04	2017	pre_kindergarten	0	0
3103652	MO	school	2921120	5128	MONETT R-I	292112001160	4020	MONETT ELEM.	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	101	101
3103658	MO	school	2921120	5128	MONETT R-I	292112001595	4040	MONETT INTERMEDIATE	Regular School	No	Middle	05	06	2017	pre_kindergarten	0	0
3103664	MO	school	2918510	6101	LIBERAL R-II	291851001003	1050	LIBERAL HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103670	MO	school	2918510	6101	LIBERAL R-II	291851002719	3000	LIBERAL MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103676	MO	school	2918510	6101	LIBERAL R-II	291851001002	4020	LIBERAL ELEM.	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	0	0
3103682	MO	school	2912930	6103	GOLDEN CITY R-III	291293000542	1050	GOLDEN CITY HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103688	MO	school	2912930	6103	GOLDEN CITY R-III	291293000541	4020	GOLDEN CITY ELEM.	Regular School	No	Elementary	KG	06	2017	pre_kindergarten	0	0
3103694	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2017	pre_kindergarten	53	53
3103700	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	High	09	12	2017	pre_kindergarten	0	0
3103706	MO	school	2917850	6104	LAMAR R-I	291785002467	3000	LAMAR MIDDLE	Regular School	No	Middle	06	08	2017	pre_kindergarten	0	0
3103712	MO	school	2917850	6104	LAMAR R-I	291785000953	4020	LAMAR ELEM.	Regular School	No	Elementary	03	05	2017	pre_kindergarten	0	0
3103718	MO	school	2917850	6104	LAMAR R-I	291785002720	4040	EAST ELEM.	Regular School	No	Elementary	PK	02	2017	pre_kindergarten	36	36
3103724	MO	school	2920820	7121	MIAMI R-I	292082001139	1050	MIAMI HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103730	MO	school	2920820	7121	MIAMI R-I	292082001138	4020	MIAMI ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	6	6
3103736	MO	school	2904170	7122	BALLARD R-II	290417000042	1050	BALLARD HIGH	Regular School	No	High	07	12	2017	pre_kindergarten	0	0
3103742	MO	school	2904170	7122	BALLARD R-II	290417000041	4020	BALLARD ELEM.	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	0	0
3103748	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	Other	06	12	2017	pre_kindergarten	0	0