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_lvl 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
3046488	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2021	grade_3
3046504	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2021	grade_3
3046595	MO	school	2916190	26006	JEFFERSON CITY	291619003346	1060	CAPITAL CITY HIGH SCHOOL	Regular School	No	Secondary	09	11	2021	grade_3
3047855	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201003371	1080	THE INNOVATION SCHOOL AT CV	Regular School	No	Secondary	09	10	2021	grade_3
3160023	MO	school	2915600	16090	JACKSON R-II	291560000737	2050	RUSSELL HAWKINS JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_3
3160722	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_3
3160723	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2019	grade_3
3160724	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2020	grade_3
3160815	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_3
3160816	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2019	grade_3
3160817	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2020	grade_3
3161331	MO	school	2916190	26006	JEFFERSON CITY	291619003346	1060	CAPITAL CITY HIGH SCHOOL	Regular School	No	Secondary	09	10	2020	grade_3
3163655	MO	school	2914340	48072	HICKMAN MILLS C-1	291434003249	1060	HICKMAN MILLS FRESHMAN CENTER	Regular School	No	Secondary	09	09	2018	grade_3
3163656	MO	school	2914340	48072	HICKMAN MILLS C-1	291434003249	1060	HICKMAN MILLS FRESHMAN CENTER	Regular School	No	Secondary	09	09	2019	grade_3
3164470	MO	school	2900597	48924	EWING MARION KAUFFMAN SCHOOL	290059703277	1910	EWING MARION KAUFFMAN HIGH	Regular School	Yes	Secondary	09	11	2018	grade_3
3164485	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	09	09	2018	grade_3
3164486	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	07	10	2019	grade_3
3164487	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	07	11	2020	grade_3
3168782	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002691	1060	STEAM ACADEMY AT MSB HIGH SCHO	Regular School	No	Secondary	09	11	2020	grade_3
3168789	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201003371	1080	THE INNOVATION SCHOOL AT CV	Regular School	No	Secondary	09	09	2020	grade_3
3171824	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	09	2018	grade_3
3171825	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	10	2019	grade_3
3171826	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	11	2020	grade_3
3171894	MO	school	2900600	115920	ST. LOUIS COLLEGE PREP	290060003264	1910	St. Louis College Prep High	Regular School	Yes	Secondary	09	11	2018	grade_3
3171929	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	09	2018	grade_3
3171930	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	10	2019	grade_3
3171931	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	11	2020	grade_3
3046150	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046208	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046218	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046280	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046320	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046422	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046449	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046450	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046454	MO	school	2929520	20001	STOCKTON R-I	292952003323	7500	LITTLE TIGER PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046470	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046478	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046482	MO	school	2928740	22090	SPARTA R-III	292874003260	7500	SPARTA PK CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046502	MO	school	2916380	23101	CLARK CO. R-I	291638003254	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046511	MO	school	2916450	24086	KEARNEY R-I	291645003329	7500	KEARNEY EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046523	MO	school	2911650	24089	EXCELSIOR SPRINGS 40	291165003352	7500	EXCELSIOR SPRINGS EAR CHLD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046541	MO	school	2918540	24090	LIBERTY 53	291854002615	7500	EARLY CHILD. EDUCATION CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046575	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280002662	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046609	MO	school	2916190	26006	JEFFERSON CITY	291619003121	7500	SOUTHWEST EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046661	MO	school	2930600	32056	UNION STAR R-II	293060003376	7500	UNION STAR PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046694	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046704	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346002278	7540	DORIS HOFFMAN EARLY LEARNING C	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046734	MO	school	2931110	36139	WASHINGTON	293111002833	7500	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046765	MO	school	2926220	39134	REPUBLIC R-III	292622002733	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046774	MO	school	2929640	39137	STRAFFORD R-VI	292964003330	7500	COGDILL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046798	MO	school	2928860	39141	SPRINGFIELD R-XII	292886001785	4120	CAMPBELL ELEM.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046830	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002905	7500	SHADY DELL EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046831	MO	school	2928860	39141	SPRINGFIELD R-XII	292886003378	7520	ADAH FULBRIGHT EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046859	MO	school	2906480	42117	CALHOUN R-VIII	290648003284	7500	CALHOUN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046868	MO	school	2909860	42124	CLINTON	290986003291	7500	CLINTON EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046925	MO	school	2912290	48066	FORT OSAGE R-I	291229002310	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046952	MO	school	2913080	48069	GRAIN VALLEY R-V	291308003169	7500	GRAIN VALLEY EARLY CHILDHD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046982	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002612	7500	GREAT BEGINNINGS EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3046992	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002979	7500	FREDA MARKLEY EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047008	MO	school	2926070	48073	RAYTOWN C-2	292607000945	7500	NEW TRAILS EARLY LEARNING CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047009	MO	school	2926070	48073	RAYTOWN C-2	292607003318	7510	THREE TRAILS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047015	MO	school	2913140	48074	GRANDVIEW C-4	291314000552	5000	HIGH GROVE Early Childhood	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047047	MO	school	2915480	48077	INDEPENDENCE 30	291548001485	7500	HANTHORN EARLY EDUCATION	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047048	MO	school	2915480	48077	INDEPENDENCE 30	291548003157	7510	SUNSHINE CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047088	MO	school	2908250	48080	CENTER 58	290825002755	7500	YELLOW JACKET EARLY LEARNING	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047103	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	grade_3
3047150	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047161	MO	school	2931500	49144	WEBB CITY R-VII	293150002377	7500	HERITAGE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047177	MO	school	2916350	49148	JOPLIN SCHOOLS	291635002778	7500	JOPLIN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047187	MO	school	2922890	50001	NORTHWEST R-I	292289003192	7500	HOUSE SPRINGS EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047199	MO	school	2914250	50005	DUNKLIN R-V	291425003326	7500	TAYLOR EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047208	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623003305	7500	JEFFERSON R-VII PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047232	MO	school	2912300	50012	FOX C-6	291230003028	7500	DON EARL EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047239	MO	school	2910500	50014	DESOTO 73	291050002993	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047326	MO	school	2930450	57003	TROY R-III	293045003347	7500	LINCOLN CO EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047397	MO	school	2913650	64075	HANNIBAL 60	291365003307	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047414	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763003358	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047478	MO	school	2927900	73106	SENECA R-VII	292790003303	7500	SENECA EARLY CHILDHOOD SCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047484	MO	school	2921810	73108	NEOSHO SCHOOL DISTRICT	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047518	MO	school	2931830	76083	OSAGE CO. R-III	293183003348	7500	OSAGE CO. R-III PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047524	MO	school	2912600	77102	GAINESVILLE R-V	291260003373	7500	GAINESVILLE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047567	MO	school	2927830	80125	SEDALIA 200	292783002678	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047619	MO	school	2923550	83005	PARK HILL	292355003087	7500	GERNER FAMILY EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047626	MO	school	2911730	84002	FAIR PLAY R-II	291173003338	7500	LITTLE STINGERS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047651	MO	school	2931440	85046	WAYNESVILLE R-VI	293144003332	7500	WILLIAMS EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047677	MO	school	2921100	88081	MOBERLY	292110003386	7500	EARLY CHILDHOOD LEARNING CNTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047729	MO	school	2908370	92087	FT. ZUMWALT R-II	290837003315	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047748	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895000643	7500	EARLY CHILD FAMILY EDUC. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047749	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002077	7520	EARLY CHILD. FAMILY EDUC CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047750	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002108	7530	EARLY CHILD. FAMILY EDUC. CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047770	MO	school	2931650	92089	WENTZVILLE R-IV	293165003006	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047781	MO	school	2928920	92090	ST. CHARLES R-VI	292892003334	7500	ST.CHARLES EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047786	MO	school	2923160	92091	ORCHARD FARM R-V	292316003290	7500	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047849	MO	school	2913830	96088	HAZELWOOD	291383003218	7500	CENTRAL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047850	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047851	MO	school	2913830	96088	HAZELWOOD	291383003204	7520	WEST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047874	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002591	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047884	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE Early CHol	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047914	MO	school	2926850	96091	ROCKWOOD R-VI	292685002849	7500	ROCKWOOD CTR. EARLY CHILD. ED.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3
3047923	MO	school	2916770	96092	KIRKWOOD R-VII	291677003031	7500	KIRKWOOD EARLY CHILD. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_3