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_high_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
3057715	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3057773	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3057783	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3057845	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3057885	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3057987	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373003316	7500	SHULL EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058014	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058015	MO	school	2929520	20001	STOCKTON R-I	292952003351	1010	EXCEPTIONAL PUPIL COOP. - ECSE	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058019	MO	school	2929520	20001	STOCKTON R-I	292952003323	7500	LITTLE TIGER PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058035	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058043	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058047	MO	school	2928740	22090	SPARTA R-III	292874003260	7500	SPARTA PK CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058067	MO	school	2916380	23101	CLARK CO. R-I	291638003254	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058076	MO	school	2916450	24086	KEARNEY R-I	291645003329	7500	KEARNEY EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058088	MO	school	2911650	24089	EXCELSIOR SPRINGS 40	291165003352	7500	EXCELSIOR SPRINGS EAR CHLD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058106	MO	school	2918540	24090	LIBERTY 53	291854002615	7500	EARLY CHILD. EDUCATION CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058140	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280002662	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058174	MO	school	2916190	26006	JEFFERSON CITY	291619003121	7500	SOUTHWEST EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058226	MO	school	2930600	32056	UNION STAR R-II	293060003376	7500	UNION STAR PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058259	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058269	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346002278	7540	DORIS HOFFMAN EARLY LEARNING C	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058299	MO	school	2931110	36139	WASHINGTON	293111002833	7500	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058330	MO	school	2926220	39134	REPUBLIC R-III	292622002733	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058339	MO	school	2929640	39137	STRAFFORD R-VI	292964003330	7500	COGDILL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058363	MO	school	2928860	39141	SPRINGFIELD R-XII	292886001785	4120	CAMPBELL ELEM.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058395	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002905	7500	SHADY DELL EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058396	MO	school	2928860	39141	SPRINGFIELD R-XII	292886003378	7520	ADAH FULBRIGHT EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058424	MO	school	2906480	42117	CALHOUN R-VIII	290648003284	7500	CALHOUN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058433	MO	school	2909860	42124	CLINTON	290986003291	7500	CLINTON EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058490	MO	school	2912290	48066	FORT OSAGE R-I	291229002310	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058517	MO	school	2913080	48069	GRAIN VALLEY R-V	291308003169	7500	GRAIN VALLEY EARLY CHILDHD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058547	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002612	7500	GREAT BEGINNINGS EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058557	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002979	7500	FREDA MARKLEY EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058573	MO	school	2926070	48073	RAYTOWN C-2	292607000945	7500	NEW TRAILS EARLY LEARNING CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058574	MO	school	2926070	48073	RAYTOWN C-2	292607003318	7510	THREE TRAILS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058580	MO	school	2913140	48074	GRANDVIEW C-4	291314000552	5000	HIGH GROVE Early Childhood	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058612	MO	school	2915480	48077	INDEPENDENCE 30	291548001485	7500	HANTHORN EARLY EDUCATION	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058613	MO	school	2915480	48077	INDEPENDENCE 30	291548003157	7510	SUNSHINE CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058653	MO	school	2908250	48080	CENTER 58	290825002755	7500	YELLOW JACKET EARLY LEARNING	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058668	MO	school	2900025	48909	ALLEN VILLAGE	290002503379	7500	ALLEN VILLAGE PRESCHOOL	Regular School	Yes	Prekindergarten	PK	PK	2021	grade_8
3058715	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058726	MO	school	2931500	49144	WEBB CITY R-VII	293150002377	7500	HERITAGE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058742	MO	school	2916350	49148	JOPLIN SCHOOLS	291635002778	7500	JOPLIN EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058752	MO	school	2922890	50001	NORTHWEST R-I	292289003192	7500	HOUSE SPRINGS EARLY CHILD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058764	MO	school	2914250	50005	DUNKLIN R-V	291425003326	7500	TAYLOR EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058773	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623003305	7500	JEFFERSON R-VII PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058797	MO	school	2912300	50012	FOX C-6	291230003028	7500	DON EARL EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058804	MO	school	2910500	50014	DESOTO 73	291050002993	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058891	MO	school	2930450	57003	TROY R-III	293045003347	7500	LINCOLN CO EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058962	MO	school	2913650	64075	HANNIBAL 60	291365003307	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3058979	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763003358	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059043	MO	school	2927900	73106	SENECA R-VII	292790003303	7500	SENECA EARLY CHILDHOOD SCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059049	MO	school	2921810	73108	NEOSHO SCHOOL DISTRICT	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059083	MO	school	2931830	76083	OSAGE CO. R-III	293183003348	7500	OSAGE CO. R-III PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059089	MO	school	2912600	77102	GAINESVILLE R-V	291260003373	7500	GAINESVILLE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059132	MO	school	2927830	80125	SEDALIA 200	292783002678	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059184	MO	school	2923550	83005	PARK HILL	292355003087	7500	GERNER FAMILY EARLY ED CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059191	MO	school	2911730	84002	FAIR PLAY R-II	291173003338	7500	LITTLE STINGERS PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059216	MO	school	2931440	85046	WAYNESVILLE R-VI	293144003332	7500	WILLIAMS EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059242	MO	school	2921100	88081	MOBERLY	292110003386	7500	EARLY CHILDHOOD LEARNING CNTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059294	MO	school	2908370	92087	FT. ZUMWALT R-II	290837003315	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059313	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895000643	7500	EARLY CHILD FAMILY EDUC. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059314	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002077	7520	EARLY CHILD. FAMILY EDUC CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059315	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002108	7530	EARLY CHILD. FAMILY EDUC. CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059335	MO	school	2931650	92089	WENTZVILLE R-IV	293165003006	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059346	MO	school	2928920	92090	ST. CHARLES R-VI	292892003334	7500	ST.CHARLES EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059351	MO	school	2923160	92091	ORCHARD FARM R-V	292316003290	7500	Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059414	MO	school	2913830	96088	HAZELWOOD	291383003218	7500	CENTRAL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059415	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059416	MO	school	2913830	96088	HAZELWOOD	291383003204	7520	WEST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059439	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002591	7500	EARLY EDUCATION CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059449	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE Early CHol	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059479	MO	school	2926850	96091	ROCKWOOD R-VI	292685002849	7500	ROCKWOOD CTR. EARLY CHILD. ED.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059488	MO	school	2916770	96092	KIRKWOOD R-VII	291677003031	7500	KIRKWOOD EARLY CHILD. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059498	MO	school	2918690	96093	LINDBERGH SCHOOLS	291869003278	7500	EARLY CHILDHOOD ED CENTER WEST	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059516	MO	school	2920670	96094	MEHLVILLE R-IX	292067002996	7500	JOHN CARY EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059555	MO	school	2905880	96101	BRENTWOOD	290588003190	7500	BRENTWOOD EARLY CHILDHD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059561	MO	school	2909720	96102	CLAYTON	290972002583	7500	FAMILY CTR.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059579	MO	school	2917820	96106	LADUE	291782003279	7500	LADUE EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059600	MO	school	2926640	96110	RITENOUR	292664003300	7500	RITENOUR EARLY CHILDHOOD CTR	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059613	MO	school	2926670	96111	RIVERVIEW GARDENS	292667002765	7530	EARLY CHILD. EDUCATION	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059620	MO	school	2930660	96112	UNIVERSITY CITY	293066001898	7500	JULIA GOLDSTEIN EARLY CHILD.	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059628	MO	school	2931530	96114	WEBSTER GROVES	293153002651	4050	WALTER AMBROSE FAMILY CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059699	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059712	MO	school	2910770	103132	DEXTER R-XI	291077003390	7500	SOUTHWEST ELEMENTARY PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059786	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3059792	MO	school	2931050	109003	WARREN CO. R-III	293105003355	7500	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	grade_8
3227737	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	grade_8
3227738	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2016	grade_8
3227739	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Elementary	PK	PK	2017	grade_8
3227740	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2018	grade_8
3227741	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2019	grade_8
3227742	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
3228090	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2018	grade_8
3228091	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2019	grade_8
3228092	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2020	grade_8
3228152	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	1	PK	PK	2016	grade_8
3228153	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Elementary	PK	PK	2017	grade_8
3228154	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	grade_8
3228155	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	grade_8
3228156	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_8