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 "year" = :p2 order by total 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
3213825	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	1	PK	06	2015	grade_7
3213831	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	3	09	12	2015	grade_7
3213843	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2015	grade_7
3213849	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2015	grade_7
3213861	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	1	KG	06	2015	grade_7
3213867	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	3	09	12	2015	grade_7
3213879	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	1	KG	05	2015	grade_7
3213891	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	3	09	12	2015	grade_7
3213903	MO	school	2927570	2097	SAVANNAH R-III	292757001688	4010	AMAZONIA ELEM.	Regular School	No	1	KG	05	2015	grade_7
3213909	MO	school	2927570	2097	SAVANNAH R-III	292757001689	4015	HELENA ELEM.	Regular School	No	1	KG	05	2015	grade_7
3213915	MO	school	2927570	2097	SAVANNAH R-III	292757001690	4020	JOHN GLENN ELEM.	Regular School	No	1	KG	05	2015	grade_7
3213921	MO	school	2927570	2097	SAVANNAH R-III	292757001692	4040	MINNIE CLINE ELEM.	Regular School	No	1	KG	05	2015	grade_7
3213927	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	grade_7
3213939	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	1	PK	06	2015	grade_7
3213951	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	1	PK	06	2015	grade_7
3213963	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	1	PK	06	2015	grade_7
3213975	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	1	PK	05	2015	grade_7
3213987	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	1	PK	06	2015	grade_7
3213993	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	3	09	12	2015	grade_7
3214005	MO	school	2920810	4110	MEXICO 59	292081001132	4020	EUGENE FIELD ELEM.	Regular School	No	1	KG	05	2015	grade_7
3214011	MO	school	2920810	4110	MEXICO 59	292081001133	4060	HAWTHORNE ELEM.	Regular School	No	1	KG	05	2015	grade_7
3214017	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214029	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214035	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	3	09	12	2015	grade_7
3214047	MO	school	2928710	5121	SOUTHWEST R-V	292871001773	4020	SOUTHWEST ELEM.	Regular School	No	1	PK	04	2015	grade_7
3214053	MO	school	2911670	5122	EXETER R-VI	291167000427	1050	EXETER HIGH	Regular School	No	3	09	12	2015	grade_7
3214065	MO	school	2908170	5123	CASSVILLE R-IV	290817000219	1050	CASSVILLE HIGH	Regular School	No	3	09	12	2015	grade_7
3214077	MO	school	2908170	5123	CASSVILLE R-IV	290817000217	4020	EUNICE THOMAS ELEM.	Regular School	No	1	PK	02	2015	grade_7
3214083	MO	school	2908170	5123	CASSVILLE R-IV	290817002718	4030	CASSVILLE INTERMEDIATE	Regular School	No	1	03	05	2015	grade_7
3214089	MO	school	2925620	5124	PURDY R-II	292562001502	1050	PURDY HIGH	Regular School	No	3	09	12	2015	grade_7
3214099	MO	school	2925620	5124	PURDY R-II	292562001501	4020	PURDY ELEM.	Regular School	No	1	PK	04	2015	grade_7
3214112	MO	school	2921120	5128	MONETT R-I	292112001162	1050	MONETT HIGH	Regular School	No	3	09	12	2015	grade_7
3214124	MO	school	2921120	5128	MONETT R-I	292112003089	4000	CENTRAL PARK ELEM.	Regular School	No	1	03	04	2015	grade_7
3214130	MO	school	2921120	5128	MONETT R-I	292112001160	4020	MONETT ELEM.	Regular School	No	1	PK	02	2015	grade_7
3214136	MO	school	2921120	5128	MONETT R-I	292112001595	4040	MONETT INTERMEDIATE	Regular School	No	2	05	06	2015	grade_7
3214142	MO	school	2918510	6101	LIBERAL R-II	291851001003	1050	LIBERAL HIGH	Regular School	No	3	09	12	2015	grade_7
3214154	MO	school	2918510	6101	LIBERAL R-II	291851001002	4020	LIBERAL ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214166	MO	school	2912930	6103	GOLDEN CITY R-III	291293000541	4020	GOLDEN CITY ELEM.	Regular School	No	1	KG	06	2015	grade_7
3214172	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	4	PK	12	2015	grade_7
3214178	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	3	09	12	2015	grade_7
3214190	MO	school	2917850	6104	LAMAR R-I	291785000953	4020	LAMAR ELEM.	Regular School	No	1	03	05	2015	grade_7
3214196	MO	school	2917850	6104	LAMAR R-I	291785002720	4040	EAST ELEM.	Regular School	No	1	KG	02	2015	grade_7
3214202	MO	school	2920820	7121	MIAMI R-I	292082001139	1050	MIAMI HIGH	Regular School	No	3	07	12	2015	grade_7
3214208	MO	school	2920820	7121	MIAMI R-I	292082001138	4020	MIAMI ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214220	MO	school	2904170	7122	BALLARD R-II	290417000041	4020	BALLARD ELEM.	Regular School	No	1	KG	06	2015	grade_7
3214232	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214244	MO	school	2926310	7124	RICH HILL R-IV	292631001545	4020	RICH HILL ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214256	MO	school	2915330	7125	HUME R-VIII	291533000698	4020	HUME ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214262	MO	school	2915240	7126	HUDSON R-IX	291524000693	4020	HUDSON ELEM.	Regular School	No	1	PK	08	2015	grade_7
3214274	MO	school	2906360	7129	BUTLER R-V	290636000157	4020	BUTLER ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214289	MO	school	2918670	8106	LINCOLN R-II	291867001015	4020	LINCOLN ELEM.	Regular School	No	1	KG	06	2015	grade_7
3214295	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	3	09	12	2015	grade_7
3214307	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	1	03	05	2015	grade_7
3214313	MO	school	2931070	8107	WARSAW R-IX	293107002154	4040	SOUTH ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214319	MO	school	2931070	8107	WARSAW R-IX	293107000834	4060	RUTH MERCER ELEM.	Regular School	No	1	KG	02	2015	grade_7
3214324	MO	school	2909900	8111	COLE CAMP R-I	290990000293	1050	COLE CAMP HIGH	Regular School	No	3	09	12	2015	grade_7
3214336	MO	school	2909900	8111	COLE CAMP R-I	290990000292	4020	COLE CAMP ELEM.	Regular School	No	1	PK	04	2015	grade_7
3214355	MO	school	2923640	9077	MEADOW HEIGHTS R-II	292364001407	4020	MEADOW HEIGHTS ELEM.	Regular School	No	1	PK	06	2015	grade_7
3214367	MO	school	2918420	9078	LEOPOLD R-III	291842000988	4020	LEOPOLD ELEM.	Regular School	No	1	KG	06	2015	grade_7
3214379	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2015	grade_7
3214385	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2015	grade_7
3214397	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2015	grade_7
3214403	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001766	1050	SOUTHERN BOONE HIGH	Regular School	No	3	09	12	2015	grade_7
3214415	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	1	PK	02	2015	grade_7
3214421	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	1	03	05	2015	grade_7
3214427	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	3	09	12	2015	grade_7
3214439	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2015	grade_7
3214445	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2015	grade_7
3214451	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	3	09	12	2015	grade_7
3214463	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2015	grade_7
3214469	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	3	09	12	2015	grade_7
3214481	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2015	grade_7
3214487	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2015	grade_7
3214493	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	3	09	12	2015	grade_7
3214505	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214511	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2015	grade_7
3214517	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative Education School	No	4	PK	12	2015	grade_7
3214523	MO	school	2901000	10093	COLUMBIA 93	290100000300	1050	DAVID H. HICKMAN HIGH	Regular School	No	3	09	12	2015	grade_7
3214529	MO	school	2901000	10093	COLUMBIA 93	290100003239	1060	MURIEL W. BATTLE HIGH SCHOOL	Regular School	No	3	09	12	2015	grade_7
3214535	MO	school	2901000	10093	COLUMBIA 93	290100000299	1075	ROCK BRIDGE SR. HIGH	Regular School	No	3	09	12	2015	grade_7
3214577	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214583	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	1	PK	05	2015	grade_7
3214589	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214595	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214601	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214607	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214618	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214624	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214630	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	ROBERT E. LEE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214636	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214642	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214648	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214654	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214664	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	1	KG	05	2015	grade_7
3214670	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214676	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214682	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214688	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214694	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	1	PK	05	2015	grade_7
3214700	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2015	grade_7
3214710	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000391	1050	EAST BUCHANAN HIGH	Regular School	No	3	09	12	2015	grade_7