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 "state" = :p0 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	total	total_int
3103447	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	17	17
3104472	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	1	PK	PK	2015	pre_kindergarten	239	239
3105254	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	283	283
3105371	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	164	164
3105419	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	49	49
3105443	MO	school	2928740	22090	SPARTA R-III	292874003260	7500	SPARTA PK CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	52	52
3105560	MO	school	2916380	23101	CLARK CO. R-I	291638003254	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	73	73
3105776	MO	school	2918540	24090	LIBERTY 53	291854002615	7500	EARLY CHILD. EDUCATION CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	253	253
3105972	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280002662	7500	PLEASANT VALLEY EARLY CHILD.	Regular School	No	1	PK	PK	2015	pre_kindergarten	226	226
3106170	MO	school	2916190	26006	JEFFERSON CITY	291619003121	7500	SOUTHWEST EARLY CHILDHOOD CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	211	211
3106674	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	133	133
3106734	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346000881	7520	MERAMEC VALLEY EARLY CHILD.	Regular School	No	1	PK	PK	2015	pre_kindergarten	75	75
3106739	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346002278	7540	MERAMEC VALLEY COMMUNITY SCH.	Regular School	No	1	PK	PK	2015	pre_kindergarten	47	47
3106920	MO	school	2931110	36139	WASHINGTON	293111002833	7500	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	144	144
3107101	MO	school	2926220	39134	REPUBLIC R-III	292622002733	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	130	130
3107493	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002905	7500	SHADY DELL EARLY CHILDHOOD CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	547	547
3107593	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	76	76
3108057	MO	school	2912290	48066	FORT OSAGE R-I	291229002310	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	111	111
3108220	MO	school	2913080	48069	GRAIN VALLEY R-V	291308003169	7500	GRAIN VALLEY EARLY CHILDHD CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	68	68
3108400	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002612	7500	GREAT BEGINNINGS EARLY ED CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	259	259
3108475	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002979	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	266	266
3108572	MO	school	2926070	48073	RAYTOWN C-2	292607000945	7500	NEW TRAILS EARLY LEARNING CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	257	257
3108798	MO	school	2915480	48077	INDEPENDENCE 30	291548001485	7500	HANTHORN EARLY EDUCATION	Regular School	No	1	PK	PK	2015	pre_kindergarten	308	308
3108804	MO	school	2915480	48077	INDEPENDENCE 30	291548003157	7510	SUNSHINE CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	204	204
3109043	MO	school	2908250	48080	CENTER 58	290825002755	7500	EARLY CHILDHOOD EDUC. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	201	201
3109384	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	72	72
3109600	MO	school	2922890	50001	NORTHWEST R-I	292289003192	7500	HOUSE SPRINGS EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	pre_kindergarten	194	194
3109867	MO	school	2912300	50012	FOX C-6	291230003028	7500	DON EARL EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	176	176
3109908	MO	school	2910500	50014	DESOTO 73	291050002993	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	167	167
3110575	MO	school	2908760	59117	CHILLICOTHE R-II	290876000260	4030	GARRISON ELEM.	Regular School	No	1	PK	PK	2015	pre_kindergarten	95	95
3111374	MO	school	2921810	73108	NEOSHO R-V	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	178	178
3111743	MO	school	2924530	79077	PERRY CO. 32	292453000278	7500	EARLY CHILD. SPECIAL ED. CTR.	Special Education School	No	1	PK	PK	2015	pre_kindergarten	28	28
3111857	MO	school	2927830	80125	SEDALIA 200	292783002678	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	144	144
3112161	MO	school	2923550	83005	PARK HILL	292355003087	7500	GERNER FAMILY EARLY ED CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	208	208
3112923	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895000643	7500	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	261	261
3112929	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002077	7520	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	321	321
3112935	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002108	7530	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	290	290
3113043	MO	school	2931650	92089	WENTZVILLE R-IV	293165003006	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	332	332
3113241	MO	school	2911910	94078	FARMINGTON R-VII	291191001890	7500	W. L. JOHNS EARLY CHILDHOOD	Regular School	No	1	PK	PK	2015	pre_kindergarten	138	138
3113513	MO	school	2913830	96088	HAZELWOOD	291383003218	7500	CENTRAL EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	175	175
3113519	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	113	113
3113525	MO	school	2913830	96088	HAZELWOOD	291383003204	7520	WEST EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	150	150
3113668	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002591	7500	EARLY EDUCATION CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	432	432
3113728	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE PRE-SCHOOL	Regular School	No	1	PK	PK	2015	pre_kindergarten	85	85
3113908	MO	school	2926850	96091	ROCKWOOD R-VI	292685002849	7500	ROCKWOOD CTR. EARLY CHILD. ED.	Regular School	No	1	PK	PK	2015	pre_kindergarten	784	784
3113962	MO	school	2916770	96092	KIRKWOOD R-VII	291677003031	7500	KIRKWOOD EARLY CHILD. CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	325	325
3114121	MO	school	2920670	96094	MEHLVILLE R-IX	292067002996	7500	JOHN CARY EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	305	305
3114391	MO	school	2909720	96102	CLAYTON	290972002583	7500	FAMILY CTR.	Regular School	No	1	PK	PK	2015	pre_kindergarten	103	103
3114564	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265002114	4180	EARLY CHILD./KDG. COMPLEX	Regular School	No	1	PK	PK	2015	pre_kindergarten	95	95
3114704	MO	school	2926670	96111	RIVERVIEW GARDENS	292667002765	7530	EARLY CHILD. EDUCATION	Regular School	No	1	PK	PK	2015	pre_kindergarten	137	137
3114746	MO	school	2930660	96112	UNIVERSITY CITY	293066001898	7500	JULIA GOLDSTEIN EARLY CHILD.	Regular School	No	1	PK	PK	2015	pre_kindergarten	117	117
3114794	MO	school	2931530	96114	WEBSTER GROVES	293153002651	4050	WALTER AMBROSE FAMILY CENTER	Regular School	No	1	PK	PK	2015	pre_kindergarten	140	140
3117257	MO	school	2927570	2097	SAVANNAH R-III	292757003186	7500	EARLY CHILDHOOD LEARNING CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3118282	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119064	MO	school	2904620	19152	BELTON 124	290462002725	7500	GRACE EARLY CHILD. & ED. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119181	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119229	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119253	MO	school	2928740	22090	SPARTA R-III	292874003260	7500	SPARTA PK CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119370	MO	school	2916380	23101	CLARK CO. R-I	291638003254	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119586	MO	school	2918540	24090	LIBERTY 53	291854002615	7500	EARLY CHILD. EDUCATION CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119782	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280002662	7500	PLEASANT VALLEY EARLY CHILD.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3119980	MO	school	2916190	26006	JEFFERSON CITY	291619003121	7500	SOUTHWEST EARLY CHILDHOOD CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3120484	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3120544	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346000881	7520	MERAMEC VALLEY EARLY CHILD.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3120549	MO	school	2923460	36126	MERAMEC VALLEY R-III	292346002278	7540	MERAMEC VALLEY COMMUNITY SCH.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3120730	MO	school	2931110	36139	WASHINGTON	293111002833	7500	EARLY LEARNING CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3120911	MO	school	2926220	39134	REPUBLIC R-III	292622002733	7500	EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3121303	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002905	7500	SHADY DELL EARLY CHILDHOOD CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3121403	MO	school	2900002	41002	SOUTH HARRISON CO. R-II	290000200922	4030	SOUTH HARRISON EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3121867	MO	school	2912290	48066	FORT OSAGE R-I	291229002310	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122030	MO	school	2913080	48069	GRAIN VALLEY R-V	291308003169	7500	GRAIN VALLEY EARLY CHILDHD CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122210	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002612	7500	GREAT BEGINNINGS EARLY ED CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122285	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002979	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122382	MO	school	2926070	48073	RAYTOWN C-2	292607000945	7500	NEW TRAILS EARLY LEARNING CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122608	MO	school	2915480	48077	INDEPENDENCE 30	291548001485	7500	HANTHORN EARLY EDUCATION	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122614	MO	school	2915480	48077	INDEPENDENCE 30	291548003157	7510	SUNSHINE CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3122853	MO	school	2908250	48080	CENTER 58	290825002755	7500	EARLY CHILDHOOD EDUC. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3123194	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3123410	MO	school	2922890	50001	NORTHWEST R-I	292289003192	7500	HOUSE SPRINGS EARLY CHILD CTR	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3123677	MO	school	2912300	50012	FOX C-6	291230003028	7500	DON EARL EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3123718	MO	school	2910500	50014	DESOTO 73	291050002993	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3124385	MO	school	2908760	59117	CHILLICOTHE R-II	290876000260	4030	GARRISON ELEM.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3125184	MO	school	2921810	73108	NEOSHO R-V	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3125553	MO	school	2924530	79077	PERRY CO. 32	292453000278	7500	EARLY CHILD. SPECIAL ED. CTR.	Special Education School	No	1	PK	PK	2015	kindergarten	0	0
3125667	MO	school	2927830	80125	SEDALIA 200	292783002678	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3125971	MO	school	2923550	83005	PARK HILL	292355003087	7500	GERNER FAMILY EARLY ED CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3126733	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895000643	7500	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3126739	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002077	7520	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3126745	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895002108	7530	EARLY CHILD. FAMILY EDUC. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3126853	MO	school	2931650	92089	WENTZVILLE R-IV	293165003006	7500	EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127051	MO	school	2911910	94078	FARMINGTON R-VII	291191001890	7500	W. L. JOHNS EARLY CHILDHOOD	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127323	MO	school	2913830	96088	HAZELWOOD	291383003218	7500	CENTRAL EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127329	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127335	MO	school	2913830	96088	HAZELWOOD	291383003204	7520	WEST EARLY CHILDHOOD CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127478	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201002591	7500	EARLY EDUCATION CENTER	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127538	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE PRE-SCHOOL	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127718	MO	school	2926850	96091	ROCKWOOD R-VI	292685002849	7500	ROCKWOOD CTR. EARLY CHILD. ED.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127772	MO	school	2916770	96092	KIRKWOOD R-VII	291677003031	7500	KIRKWOOD EARLY CHILD. CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3127931	MO	school	2920670	96094	MEHLVILLE R-IX	292067002996	7500	JOHN CARY EARLY CHILDHOOD CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3128201	MO	school	2909720	96102	CLAYTON	290972002583	7500	FAMILY CTR.	Regular School	No	1	PK	PK	2015	kindergarten	0	0
3128374	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265002114	4180	EARLY CHILD./KDG. COMPLEX	Regular School	No	1	PK	PK	2015	kindergarten	0	0