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 order by ccd_school_low_grade desc 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
3055385	MO	school	2922980	1090	ADAIR CO. R-I	292298001314	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055388	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055394	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001250	4020	NORTH ANDREW ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055395	MO	school	2904080	2090	AVENUE CITY R-IX	290408000037	4020	AVENUE CITY ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	22	22
3055402	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055404	MO	school	2929940	3031	TARKIO R-I	292994002066	4020	TARKIO ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055406	MO	school	2926790	3032	ROCK PORT R-II	292679001612	4020	ROCK PORT ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055408	MO	school	2911760	3033	FAIRFAX R-III	291176000432	4020	FAIRFAX ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055410	MO	school	2910020	4106	COMMUNITY R-VI	291002000318	4020	COMMUNITY ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055412	MO	school	2930780	4109	VAN-FAR R-I	293078002125	4020	VAN-FAR ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055417	MO	school	2920810	4110	MEXICO 59	292081001134	4080	MCMILLAN EARLY LEARNING CENTER	Regular School	No	Elementary	PK	KG	2021	grade_7	0	0
3055419	MO	school	2931950	5120	WHEATON R-III	293195002236	4020	WHEATON ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055422	MO	school	2928710	5121	SOUTHWEST R-V	292871001773	4020	SOUTHWEST ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055424	MO	school	2911670	5122	EXETER R-VI	291167000426	4020	EXETER ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	28	28
3055427	MO	school	2908170	5123	CASSVILLE R-IV	290817000217	4020	EUNICE THOMAS ELEM.	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055430	MO	school	2925620	5124	PURDY R-II	292562001501	4020	PURDY ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055431	MO	school	2928200	5127	SHELL KNOB 78	292820001735	4020	SHELL KNOB ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	17	17
3055435	MO	school	2921120	5128	MONETT R-I	292112001160	4020	MONETT ELEM.	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055439	MO	school	2918510	6101	LIBERAL R-II	291851001002	4020	LIBERAL ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055442	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2021	grade_7	0	0
3055446	MO	school	2917850	6104	LAMAR R-I	291785002720	4040	EAST ELEM.	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055448	MO	school	2920820	7121	MIAMI R-I	292082001138	4020	MIAMI ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055452	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055454	MO	school	2926310	7124	RICH HILL R-IV	292631001545	4020	RICH HILL ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055456	MO	school	2915330	7125	HUME R-VIII	291533000698	4020	HUME ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055457	MO	school	2915240	7126	HUDSON R-IX	291524000693	4020	HUDSON ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	0	0
3055460	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055466	MO	school	2931070	8107	WARSAW R-IX	293107002154	4040	SOUTH ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055470	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055473	MO	school	2923640	9077	MEADOW HEIGHTS R-II	292364001407	4020	MEADOW HEIGHTS ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055477	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055480	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055483	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055488	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055491	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055494	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055498	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055500	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2021	grade_7	0	0
3055511	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055512	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055513	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055515	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055516	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055518	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055519	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055520	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	Locust St Expressive Arts Elem	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055521	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055522	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055523	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055524	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055527	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055528	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055529	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055530	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055532	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055537	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000443	4020	MID-BUCHANAN ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055539	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000356	4020	RUSHVILLE ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055547	MO	school	2927060	11082	ST. JOSEPH	292706001649	4040	EDISON ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055550	MO	school	2927060	11082	ST. JOSEPH	292706003255	4080	OAK GROVE ELEM	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055559	MO	school	2927060	11082	ST. JOSEPH	292706001669	4420	PICKETT ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055560	MO	school	2927060	11082	ST. JOSEPH	292706001672	4460	SKAITH ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055562	MO	school	2921750	12108	NEELYVILLE R-IV	292175001201	4040	HILLVIEW ELEM.	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055572	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055575	MO	school	2930520	12110	TWIN RIVERS R-X	293052002093	4040	FISK ELEMENTARY	Regular School	No	Elementary	PK	08	2021	grade_7	45	45
3055576	MO	school	2930520	12110	TWIN RIVERS R-X	293052002094	4060	QULIN ELEMENTARY	Regular School	No	Elementary	PK	03	2021	grade_7	0	0
3055578	MO	school	2905850	13054	BRECKENRIDGE R-I	290585000128	4020	BRECKENRIDGE ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055581	MO	school	2913590	13055	HAMILTON R-II	291359000579	4020	HAMILTON ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055583	MO	school	2910230	13058	COWGILL R-VI	291023000329	4020	COWGILL ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	0	0
3055586	MO	school	2925410	13059	POLO R-VII	292541001464	4020	POLO ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055587	MO	school	2921030	13060	MIRABILE C-1	292103001150	4020	MIRABILE ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	5	5
3055589	MO	school	2905820	13061	BRAYMER C-4	290582000126	4020	BRAYMER ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055590	MO	school	2916620	13062	KINGSTON 42	291662000908	4020	KINGSTON ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	0	0
3055593	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001253	4040	HATTON-MCCREDIE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055596	MO	school	2921875	14127	NEW BLOOMFIELD R-III	292187501218	4020	NEW BLOOMFIELD ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055601	MO	school	2912550	14129	FULTON 58	291255000522	4080	MCINTIRE ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055604	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843003120	4010	SOUTH CALLAWAY EARLY CHD PK-02	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055610	MO	school	2929580	15001	STOUTLAND R-II	292958002045	4020	STOUTLAND ELEMENTARY	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055613	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEMENTARY	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055615	MO	school	2906990	15002	CAMDENTON R-III	290699000172	4040	HURRICANE DECK ELEMENTARY	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055617	MO	school	2906990	15002	CAMDENTON R-III	290699000174	4080	OSAGE BEACH ELEMENTARY	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055619	MO	school	2909810	15003	CLIMAX SPRINGS R-IV	290981000283	4020	ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055621	MO	school	2919380	15004	MACKS CREEK R-V	291938001048	4020	MACKS CREEK ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055630	MO	school	2915600	16090	JACKSON R-II	291560003265	4140	EAST ELEMENTARY	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055633	MO	school	2910620	16092	DELTA R-V	291062000357	4020	DELTA ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055635	MO	school	2923070	16094	OAK RIDGE R-VI	292307001320	4020	OAK RIDGE ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055639	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000187	4040	FRANKLIN ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055640	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712002722	4050	BLANCHARD ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055641	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000188	4060	CLIPPARD ELEM.	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055642	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000189	4080	JEFFERSON ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055646	MO	school	2913500	17121	HALE R-I	291350000573	4020	HALE ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055648	MO	school	2930300	17122	TINA-AVALON R-II	293030002070	4020	TINA-AVALON ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055650	MO	school	2905610	17124	BOSWORTH R-V	290561000106	4020	BOSWORTH ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055653	MO	school	2907380	17125	CARROLLTON R-VII	290738003129	4010	CARROLLTON ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
3055658	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000380	4020	EAST CARTER CO. R-II ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055660	MO	school	2930750	18050	VAN BUREN R-I	293075002122	4020	VAN BUREN ELEM.	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
3055662	MO	school	2903200	19139	ARCHIE R-V	290320000024	4020	CASS CO. ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055674	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_7	0	0
3055677	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000334	4020	SHERWOOD ELEM.	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
3055678	MO	school	2911160	19147	EAST LYNNE 40	291116000384	4020	EAST LYNNE ELEM.	Regular School	No	Elementary	PK	08	2021	grade_7	12	12
3055681	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
3055689	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000091	4060	EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	KG	2021	grade_7	0	0