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 and "year" = :p2 order by ccd_school_low_grade 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
3151812	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2018	grade_2	0	0
3145260	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	Elementary	01	05	2018	grade_2	58	58
3145464	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2018	grade_2	0	0
3145653	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2018	grade_2	10	10
3145869	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2018	grade_2	105	105
3145881	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	03	2018	grade_2	66	66
3145893	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2018	grade_2	97	97
3145899	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2018	grade_2	120	120
3146598	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2018	grade_2	156	156
3149856	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	COMPASS ELEMENTARY	Regular School	No	Elementary	01	06	2018	grade_2	54	54
3149862	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	55	55
3149868	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	60	60
3149873	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	55	55
3149878	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	85	85
3149884	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	48	48
3149890	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	62	62
3149896	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	78	78
3150859	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2018	grade_2	191	191
3151056	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2018	grade_2	0	0
3154650	MO	school	2911910	94078	FARMINGTON R-VII	291191000442	4030	WASHINGTON-FRANKLIN ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	83	83
3154656	MO	school	2911910	94078	FARMINGTON R-VII	291191000438	4040	JEFFERSON ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	83	83
3154668	MO	school	2911910	94078	FARMINGTON R-VII	291191002847	4060	ROOSEVELT ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	125	125
3155972	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265003189	4010	BARACK OBAMA ELEMENTARY SCHOOL	Regular School	No	Elementary	01	06	2018	grade_2	72	72
3155979	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265001243	4100	JEFFERSON ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	37	37
3155985	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265002850	4145	LUCAS CROSSING ELEM. COMPLEX	Regular School	No	Elementary	01	06	2018	grade_2	146	146
3155991	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265001249	4160	WASHINGTON ELEM.	Regular School	No	Elementary	01	06	2018	grade_2	47	47
3156532	MO	school	2928260	100063	SIKESTON R-6	292826001739	4040	LEE HUNTER ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	106	106
3156538	MO	school	2928260	100063	SIKESTON R-6	292826001566	4050	MATTHEWS ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	90	90
3156544	MO	school	2928260	100063	SIKESTON R-6	292826001742	4070	SOUTHEAST ELEM.	Regular School	No	Elementary	01	04	2018	grade_2	78	78
3156926	MO	school	2905760	106004	BRANSON R-IV	290576002462	4040	CEDAR RIDGE ELEMENTARY	Regular School	No	Elementary	01	03	2018	grade_2	199	199
3145392	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2018	grade_2	115	115
3146398	MO	school	2907380	17125	CARROLLTON R-VII	290738003129	4010	CARROLLTON ELEMENTARY SCHOOL	Regular School	No	Elementary	02	04	2018	grade_2	73	73
3147945	MO	school	2927090	33090	SALEM R-80	292709001676	4040	SALEM UPPER ELEM.	Regular School	No	Elementary	02	05	2018	grade_2	92	92
3148268	MO	school	2929760	36137	SULLIVAN	292976002055	4020	SULLIVAN ELEM.	Regular School	No	Elementary	02	05	2018	grade_2	139	139
3148608	MO	school	2919170	39139	LOGAN-ROGERSVILLE R-VIII	291917003128	4030	LOGAN-ROGERSVILLE ELEMENTARY	Regular School	No	Elementary	02	03	2018	grade_2	172	172
3150225	MO	school	2915480	48077	INDEPENDENCE 30	291548003210	6130	ABRAHAM MALLINSON ELEMENTARY	Regular School	No	Elementary	02	05	2018	grade_2	97	97
3150721	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2018	grade_2	219	219
3150865	MO	school	2931500	49144	WEBB CITY R-VII	293150002182	5000	HARRY S. TRUMAN ELEM.	Regular School	No	Elementary	02	04	2018	grade_2	104	104
3151530	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2018	grade_2	298	298
3152018	MO	school	2908760	59117	CHILLICOTHE R-II	290876000262	4060	FIELD ELEM.	Regular School	No	Elementary	02	03	2018	grade_2	118	118
3154004	MO	school	2926480	89089	RICHMOND R-XVI	292648001878	4030	SUNRISE ELEM.	Regular School	No	Elementary	02	05	2018	grade_2	122	122
3156690	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2018	grade_2	0	0
3156804	MO	school	2926160	104044	REEDS SPRING R-IV	292616003034	4030	REEDS SPRING ELEM.	Regular School	No	Elementary	02	04	2018	grade_2	118	118
3156974	MO	school	2914550	106005	HOLLISTER R-V	291455000683	4020	HOLLISTER ELEM.	Regular School	No	Elementary	02	05	2018	grade_2	80	80
3157100	MO	school	2921840	108142	NEVADA R-V	292184001211	4020	BENTON ELEM.	Regular School	No	Elementary	02	02	2018	grade_2	177	177
3157166	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	Elementary	02	05	2018	grade_2	129	129
3157375	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2018	grade_2	186	186
3144802	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145036	MO	school	2908170	5123	CASSVILLE R-IV	290817002718	4030	CASSVILLE INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145077	MO	school	2921120	5128	MONETT R-I	292112003089	4000	CENTRAL PARK ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3145143	MO	school	2917850	6104	LAMAR R-I	291785000953	4020	LAMAR ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145374	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145440	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145851	MO	school	2921750	12108	NEELYVILLE R-IV	292175001202	4060	NEELYVILLE ELEM.	Regular School	No	Elementary	03	06	2018	grade_2	0	0
3146099	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843001756	4020	SOUTH CALLAWAY ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3146171	MO	school	2906990	15002	CAMDENTON R-III	290699002983	4050	HAWTHORN ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3146260	MO	school	2915600	16090	JACKSON R-II	291560000739	4160	WEST LANE ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3146569	MO	school	2925330	19148	PLEASANT HILL R-III	292533002803	4040	PLEASANT HILL ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3147064	MO	school	2928410	24087	SMITHVILLE R-II	292841002274	4040	Horizon Elementary School	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3147428	MO	school	2907020	25001	CAMERON R-I	290702003267	4040	CAMERON INTERMEDIATE SCHOOL	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3147681	MO	school	2905580	27061	BOONVILLE R-I	290558000103	4040	DAVID BARTON ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3148101	MO	school	2916500	35102	KENNETT 39	291650000902	4080	SOUTH ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3148250	MO	school	2929100	36136	ST. CLAIR R-XIII	292910001862	4040	EDGAR MURRAY ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3149144	MO	school	2909860	42124	CLINTON	290986003145	4080	CLINTON INTERMEDIATE SCHOOL	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3149671	MO	school	2923010	48070	OAK GROVE R-VI	292301001316	4020	OAK GROVE ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3150841	MO	school	2931500	49144	WEBB CITY R-VII	293150002184	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3150853	MO	school	2931500	49144	WEBB CITY R-VII	293150002188	4060	MARK TWAIN ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3151074	MO	school	2914430	50003	HILLSBORO R-III	291443000673	4020	HILLSBORO ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3151153	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623001725	4060	TELEGRAPH INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151180	MO	school	2932100	50010	WINDSOR C-1	293210002250	4020	WINDSOR INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151461	MO	school	2931020	51159	WARRENSBURG R-VI	293102002513	4050	MARTIN WARREN ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151467	MO	school	2931020	51159	WARRENSBURG R-VI	293102001729	4060	STERLING ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151596	MO	school	2923100	54041	ODESSA R-VII	292310001743	4060	ODESSA UPPER ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151710	MO	school	2921600	55108	MT. VERNON R-V	292160003088	4040	MT. VERNON INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3151734	MO	school	2904020	55110	AURORA R-VIII	290402000033	4040	ROBINSON ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3151894	MO	school	2932190	57004	WINFIELD R-IV	293219002545	4040	WINFIELD INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3152043	MO	school	2920610	60077	MCDONALD CO. R-I	292061001101	4040	NOEL ELEM.	Regular School	No	Middle	03	08	2018	grade_2	0	0
3152055	MO	school	2920610	60077	MCDONALD CO. R-I	292061001102	4060	PINEVILLE ELEM.	Regular School	No	Middle	03	08	2018	grade_2	0	0
3152187	MO	school	2912540	62072	FREDERICKTOWN R-I	291254002524	4080	FREDERICKTOWN INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3152384	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763002479	3000	OSAGE UPPER ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3152426	MO	school	2911220	67055	EAST PRAIRIE R-II	291122000385	4060	A. J. MARTIN ELEM.	Regular School	No	Elementary	03	06	2018	grade_2	0	0
3153446	MO	school	2922830	83001	NORTH PLATTE CO. R-I	292283002021	4030	NORTH PLATTE INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3153618	MO	school	2905370	84001	BOLIVAR R-I	290537001535	4040	BOLIVAR INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3153926	MO	school	2921100	88081	MOBERLY	292110002820	4020	GRATZ BROWN ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3154085	MO	school	2910920	91092	DONIPHAN R-I	291092003301	4040	DONIPHAN INTERMEDIATE	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3154151	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000234	4020	FOREST PARK ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3154157	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000236	4030	LEWIS & CLARK ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3154416	MO	school	2931650	92089	WENTZVILLE R-IV	293165002456	4030	HERITAGE INTERMEDIATE	Regular School	No	Elementary	03	06	2018	grade_2	0	0
3154700	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000096	4040	NORTH COUNTY PARKSIDE ELEM.	Regular School	No	Elementary	03	04	2018	grade_2	0	0
3154724	MO	school	2929170	94086	CENTRAL R-III	292917001871	4060	WEST ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3155743	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3155949	MO	school	2920010	96107	MAPLEWOOD-RICHMOND HEIGHTS	292001002860	4040	MRH ELEMENTARY	Regular School	No	Elementary	03	06	2018	grade_2	0	0
3156726	MO	school	2910770	103132	DEXTER R-XI	291077000361	4020	CENTRAL ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3157112	MO	school	2921840	108142	NEVADA R-V	292184001122	4080	TRUMAN ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3157232	MO	school	2931140	110014	KINGSTON K-14	293114002165	4040	KINGSTON ELEM.	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3157760	MO	school	2929280	115115	ST. LOUIS CITY	292928003193	4960	HUMBOLDT ACAD OF HIGHER LRNING	Regular School	No	Elementary	03	05	2018	grade_2	0	0
3145875	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001947	4040	POPLAR BLUFF MIDDLE SCHOOL	Regular School	No	Middle	04	06	2018	grade_2	0	0
3146604	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000604	4040	MCEOWEN ELEM.	Regular School	No	Elementary	04	05	2018	grade_2	0	0
3146834	MO	school	2922530	22089	Nixa Public Schools	292253002799	4080	SUMMIT INTERMEDIATE SCHOOL	Regular School	No	Middle	04	06	2018	grade_2	0	0
3148190	MO	school	2930570	36131	UNION R-XI	293057002096	4010	CLARK-VITT ELEM.	Regular School	No	Middle	04	06	2018	grade_2	0	0
3148552	MO	school	2903270	39135	ASH GROVE R-IV	290327000026	4040	BOIS D'ARC ELEM.	Regular School	No	Middle	04	06	2018	grade_2	0	0