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
3041862	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2021	grade_1
3041878	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2021	grade_1
3041969	MO	school	2916190	26006	JEFFERSON CITY	291619003346	1060	CAPITAL CITY HIGH SCHOOL	Regular School	No	Secondary	09	11	2021	grade_1
3043229	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201003371	1080	THE INNOVATION SCHOOL AT CV	Regular School	No	Secondary	09	10	2021	grade_1
3132403	MO	school	2915600	16090	JACKSON R-II	291560000737	2050	RUSSELL HAWKINS JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_1
3133102	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_1
3133103	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2019	grade_1
3133104	MO	school	2923430	22093	OZARK R-VI	292343002438	2050	OZARK JR. HIGH	Regular School	No	Secondary	08	09	2020	grade_1
3133195	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2018	grade_1
3133196	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2019	grade_1
3133197	MO	school	2916450	24086	KEARNEY R-I	291645002531	2050	KEARNEY JR. HIGH	Regular School	No	Secondary	08	09	2020	grade_1
3133711	MO	school	2916190	26006	JEFFERSON CITY	291619003346	1060	CAPITAL CITY HIGH SCHOOL	Regular School	No	Secondary	09	10	2020	grade_1
3136035	MO	school	2914340	48072	HICKMAN MILLS C-1	291434003249	1060	HICKMAN MILLS FRESHMAN CENTER	Regular School	No	Secondary	09	09	2018	grade_1
3136036	MO	school	2914340	48072	HICKMAN MILLS C-1	291434003249	1060	HICKMAN MILLS FRESHMAN CENTER	Regular School	No	Secondary	09	09	2019	grade_1
3136850	MO	school	2900597	48924	EWING MARION KAUFFMAN SCHOOL	290059703277	1910	EWING MARION KAUFFMAN HIGH	Regular School	Yes	Secondary	09	11	2018	grade_1
3136865	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	09	09	2018	grade_1
3136866	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	07	10	2019	grade_1
3136867	MO	school	2900603	48926	CROSSROADS CHARTER SCHOOLS	290060303311	1905	CROSSROADS HIGH SCHOOL	Regular School	Yes	Secondary	07	11	2020	grade_1
3141162	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002691	1060	STEAM ACADEMY AT MSB HIGH SCHO	Regular School	No	Secondary	09	11	2020	grade_1
3141169	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201003371	1080	THE INNOVATION SCHOOL AT CV	Regular School	No	Secondary	09	09	2020	grade_1
3144204	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	09	2018	grade_1
3144205	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	10	2019	grade_1
3144206	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	11	2020	grade_1
3144274	MO	school	2900600	115920	ST. LOUIS COLLEGE PREP	290060003264	1910	St. Louis College Prep High	Regular School	Yes	Secondary	09	11	2018	grade_1
3144309	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	09	2018	grade_1
3144310	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	10	2019	grade_1
3144311	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	11	2020	grade_1
3041524	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041582	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041592	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041654	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041694	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041796	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041823	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041824	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041828	MO	school	2929520	20001	STOCKTON R-I	292952003323	7500	LITTLE TIGER PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041844	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041852	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041856	MO	school	2928740	22090	SPARTA R-III	292874003260	7500	SPARTA PK CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041876	MO	school	2916380	23101	CLARK CO. R-I	291638003254	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041885	MO	school	2916450	24086	KEARNEY R-I	291645003329	7500	KEARNEY EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041897	MO	school	2911650	24089	EXCELSIOR SPRINGS 40	291165003352	7500	EXCELSIOR SPRINGS EAR CHLD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041915	MO	school	2918540	24090	LIBERTY 53	291854002615	7500	EARLY CHILD. EDUCATION CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041949	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280002662	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3041983	MO	school	2916190	26006	JEFFERSON CITY	291619003121	7500	SOUTHWEST EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042035	MO	school	2930600	32056	UNION STAR R-II	293060003376	7500	UNION STAR PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042068	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042078	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346002278	7540	DORIS HOFFMAN EARLY LEARNING C	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042108	MO	school	2931110	36139	WASHINGTON	293111002833	7500	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042139	MO	school	2926220	39134	REPUBLIC R-III	292622002733	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042148	MO	school	2929640	39137	STRAFFORD R-VI	292964003330	7500	COGDILL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042172	MO	school	2928860	39141	SPRINGFIELD R-XII	292886001785	4120	CAMPBELL ELEM.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042204	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002905	7500	SHADY DELL EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042205	MO	school	2928860	39141	SPRINGFIELD R-XII	292886003378	7520	ADAH FULBRIGHT EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042233	MO	school	2906480	42117	CALHOUN R-VIII	290648003284	7500	CALHOUN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042242	MO	school	2909860	42124	CLINTON	290986003291	7500	CLINTON EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042299	MO	school	2912290	48066	FORT OSAGE R-I	291229002310	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042326	MO	school	2913080	48069	GRAIN VALLEY R-V	291308003169	7500	GRAIN VALLEY EARLY CHILDHD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042356	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002612	7500	GREAT BEGINNINGS EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042366	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002979	7500	FREDA MARKLEY EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042382	MO	school	2926070	48073	RAYTOWN C-2	292607000945	7500	NEW TRAILS EARLY LEARNING CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042383	MO	school	2926070	48073	RAYTOWN C-2	292607003318	7510	THREE TRAILS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042389	MO	school	2913140	48074	GRANDVIEW C-4	291314000552	5000	HIGH GROVE Early Childhood	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042421	MO	school	2915480	48077	INDEPENDENCE 30	291548001485	7500	HANTHORN EARLY EDUCATION	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042422	MO	school	2915480	48077	INDEPENDENCE 30	291548003157	7510	SUNSHINE CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042462	MO	school	2908250	48080	CENTER 58	290825002755	7500	YELLOW JACKET EARLY LEARNING	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042477	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	grade_1
3042524	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042535	MO	school	2931500	49144	WEBB CITY R-VII	293150002377	7500	HERITAGE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042551	MO	school	2916350	49148	JOPLIN SCHOOLS	291635002778	7500	JOPLIN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042561	MO	school	2922890	50001	NORTHWEST R-I	292289003192	7500	HOUSE SPRINGS EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042573	MO	school	2914250	50005	DUNKLIN R-V	291425003326	7500	TAYLOR EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042582	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623003305	7500	JEFFERSON R-VII PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042606	MO	school	2912300	50012	FOX C-6	291230003028	7500	DON EARL EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042613	MO	school	2910500	50014	DESOTO 73	291050002993	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042700	MO	school	2930450	57003	TROY R-III	293045003347	7500	LINCOLN CO EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042771	MO	school	2913650	64075	HANNIBAL 60	291365003307	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042788	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763003358	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042852	MO	school	2927900	73106	SENECA R-VII	292790003303	7500	SENECA EARLY CHILDHOOD SCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042858	MO	school	2921810	73108	NEOSHO SCHOOL DISTRICT	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042892	MO	school	2931830	76083	OSAGE CO. R-III	293183003348	7500	OSAGE CO. R-III PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042898	MO	school	2912600	77102	GAINESVILLE R-V	291260003373	7500	GAINESVILLE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042941	MO	school	2927830	80125	SEDALIA 200	292783002678	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3042993	MO	school	2923550	83005	PARK HILL	292355003087	7500	GERNER FAMILY EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043000	MO	school	2911730	84002	FAIR PLAY R-II	291173003338	7500	LITTLE STINGERS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043025	MO	school	2931440	85046	WAYNESVILLE R-VI	293144003332	7500	WILLIAMS EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043051	MO	school	2921100	88081	MOBERLY	292110003386	7500	EARLY CHILDHOOD LEARNING CNTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043103	MO	school	2908370	92087	FT. ZUMWALT R-II	290837003315	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043122	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895000643	7500	EARLY CHILD FAMILY EDUC. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043123	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002077	7520	EARLY CHILD. FAMILY EDUC CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043124	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002108	7530	EARLY CHILD. FAMILY EDUC. CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043144	MO	school	2931650	92089	WENTZVILLE R-IV	293165003006	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043155	MO	school	2928920	92090	ST. CHARLES R-VI	292892003334	7500	ST.CHARLES EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043160	MO	school	2923160	92091	ORCHARD FARM R-V	292316003290	7500	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043223	MO	school	2913830	96088	HAZELWOOD	291383003218	7500	CENTRAL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043224	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043225	MO	school	2913830	96088	HAZELWOOD	291383003204	7520	WEST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043248	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002591	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043258	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE Early CHol	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043288	MO	school	2926850	96091	ROCKWOOD R-VI	292685002849	7500	ROCKWOOD CTR. EARLY CHILD. ED.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1
3043297	MO	school	2916770	96092	KIRKWOOD R-VII	291677003031	7500	KIRKWOOD EARLY CHILD. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_1