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
3165620	MO	school		57003	TROY R-III		1000	CENTRAL OFFICE						2016	grade_3	0	0
3170302	MO	school		100062	SCOTT CO. CENTRAL		1000	CENTRAL OFFICE						2016	grade_3	0	0
3159272	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2016	grade_3	0	0
3159461	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2016	grade_3	14	14
3159677	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	1	01	04	2016	grade_3	92	92
3159689	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	1	01	04	2016	grade_3	59	59
3159701	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	1	01	04	2016	grade_3	119	119
3159707	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	1	01	04	2016	grade_3	135	135
3160406	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	1	01	03	2016	grade_3	165	165
3163664	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000651	4010	BURKE ELEM.	Regular School	No	1	01	06	2016	grade_3	84	84
3163670	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000652	4015	DOBBS ELEM.	Regular School	No	1	01	06	2016	grade_3	58	58
3163676	MO	school	2914340	48072	HICKMAN MILLS C-1	291434002595	4020	JOHNSON ELEM.	Regular School	No	1	01	06	2016	grade_3	59	59
3163681	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000662	4025	SYMINGTON ELEM.	Regular School	No	1	01	06	2016	grade_3	71	71
3163686	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000663	4030	TRUMAN ELEM.	Regular School	No	1	01	06	2016	grade_3	76	76
3163692	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000664	4035	WARFORD ELEM.	Regular School	No	1	01	06	2016	grade_3	77	77
3163698	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000659	4045	SANTA FE ELEM.	Regular School	No	1	01	06	2016	grade_3	66	66
3163704	MO	school	2914340	48072	HICKMAN MILLS C-1	291434000655	4050	INGELS ELEM.	Regular School	No	1	01	06	2016	grade_3	63	63
3164667	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	1	01	02	2016	grade_3	0	0
3164864	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative Education School	No	4	01	12	2016	grade_3	0	0
3168458	MO	school	2911910	94078	FARMINGTON R-VII	291191000442	4030	WASHINGTON-FRANKLIN ELEM.	Regular School	No	1	01	04	2016	grade_3	93	93
3168464	MO	school	2911910	94078	FARMINGTON R-VII	291191000438	4040	JEFFERSON ELEM.	Regular School	No	1	01	04	2016	grade_3	94	94
3168476	MO	school	2911910	94078	FARMINGTON R-VII	291191002847	4060	ROOSEVELT ELEM.	Regular School	No	1	01	04	2016	grade_3	132	132
3169780	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265003189	4010	BARACK OBAMA ELEMENTARY SCHOOL	Regular School	No	1	01	06	2016	grade_3	82	82
3169787	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265001243	4100	JEFFERSON ELEM.	Regular School	No	1	01	06	2016	grade_3	33	33
3169793	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265002850	4145	LUCAS CROSSING ELEM. COMPLEX	Regular School	No	1	01	06	2016	grade_3	128	128
3169799	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265001249	4160	WASHINGTON ELEM.	Regular School	No	1	01	06	2016	grade_3	55	55
3170340	MO	school	2928260	100063	SIKESTON R-6	292826001739	4040	LEE HUNTER ELEM.	Regular School	No	1	01	04	2016	grade_3	102	102
3170346	MO	school	2928260	100063	SIKESTON R-6	292826001566	4050	MATTHEWS ELEM.	Regular School	No	1	01	04	2016	grade_3	89	89
3170352	MO	school	2928260	100063	SIKESTON R-6	292826001742	4070	SOUTHEAST ELEM.	Regular School	No	1	01	04	2016	grade_3	87	87
3170734	MO	school	2905760	106004	BRANSON R-IV	290576002462	4040	CEDAR RIDGE ELEMENTARY	Regular School	No	1	01	03	2016	grade_3	191	191
3159200	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2016	grade_3	124	124
3160206	MO	school	2907380	17125	CARROLLTON R-VII	290738003129	4010	CARROLLTON ELEMENTARY SCHOOL	Regular School	No	1	02	04	2016	grade_3	73	73
3161753	MO	school	2927090	33090	SALEM R-80	292709001676	4040	SALEM UPPER ELEM.	Regular School	No	1	02	05	2016	grade_3	86	86
3162076	MO	school	2929760	36137	SULLIVAN	292976002055	4020	SULLIVAN ELEM.	Regular School	No	1	02	05	2016	grade_3	155	155
3162416	MO	school	2919170	39139	LOGAN-ROGERSVILLE R-VIII	291917003128	4030	LOGAN-ROGERSVILLE ELEMENTARY	Regular School	No	1	02	03	2016	grade_3	156	156
3164033	MO	school	2915480	48077	INDEPENDENCE 30	291548003210	6130	ABRAHAM MALLINSON ELEMENTARY	Regular School	No	1	02	05	2016	grade_3	85	85
3164376	MO	school	2900013	48912	DELLA LAMB ELEM.	290001302751	6930	DELLA LAMB @ WALLACE	Regular School	Yes	1	02	08	2016	grade_3	84	84
3164529	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	1	02	03	2016	grade_3	241	241
3164673	MO	school	2931500	49144	WEBB CITY R-VII	293150002182	5000	HARRY S. TRUMAN ELEM.	Regular School	No	1	02	04	2016	grade_3	92	92
3165338	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	1	02	03	2016	grade_3	335	335
3165826	MO	school	2908760	59117	CHILLICOTHE R-II	290876000262	4060	FIELD ELEM.	Regular School	No	1	02	03	2016	grade_3	159	159
3167812	MO	school	2926480	89089	RICHMOND R-XVI	292648001878	4030	SUNRISE ELEM.	Regular School	No	1	02	05	2016	grade_3	120	120
3169757	MO	school	2920010	96107	MAPLEWOOD-RICHMOND HEIGHTS	292001002860	4040	MRH ELEMENTARY	Regular School	No	1	02	06	2016	grade_3	109	109
3170498	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative Education School	No	4	02	12	2016	grade_3	0	0
3170612	MO	school	2926160	104044	REEDS SPRING R-IV	292616003034	4030	REEDS SPRING ELEM.	Regular School	No	1	02	04	2016	grade_3	115	115
3170782	MO	school	2914550	106005	HOLLISTER R-V	291455000683	4020	HOLLISTER ELEM.	Regular School	No	1	02	05	2016	grade_3	79	79
3170908	MO	school	2921840	108142	NEVADA R-V	292184001211	4020	BENTON ELEM.	Regular School	No	1	02	02	2016	grade_3	0	0
3170974	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002265	4020	WRIGHT CITY WEST ELEM.	Regular School	No	1	02	05	2016	grade_3	146	146
3171183	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	1	02	03	2016	grade_3	243	243
3158610	MO	school	2916740	1091	KIRKSVILLE R-III	291674000917	4050	RAY MILLER ELEM.	Regular School	No	1	03	05	2016	grade_3	212	212
3158844	MO	school	2908170	5123	CASSVILLE R-IV	290817002718	4030	CASSVILLE INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	160	160
3158885	MO	school	2921120	5128	MONETT R-I	292112003089	4000	CENTRAL PARK ELEM.	Regular School	No	1	03	04	2016	grade_3	180	180
3158951	MO	school	2917850	6104	LAMAR R-I	291785000953	4020	LAMAR ELEM.	Regular School	No	1	03	05	2016	grade_3	110	110
3159068	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	1	03	05	2016	grade_3	50	50
3159182	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	1	03	05	2016	grade_3	134	134
3159248	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	114	114
3159659	MO	school	2921750	12108	NEELYVILLE R-IV	292175001202	4060	NEELYVILLE ELEM.	Regular School	No	1	03	06	2016	grade_3	48	48
3159907	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843001756	4020	SOUTH CALLAWAY ELEM.	Regular School	No	1	03	05	2016	grade_3	57	57
3159979	MO	school	2906990	15002	CAMDENTON R-III	290699002983	4050	HAWTHORN ELEM.	Regular School	No	1	03	04	2016	grade_3	247	247
3160068	MO	school	2915600	16090	JACKSON R-II	291560000739	4160	WEST LANE ELEM.	Regular School	No	1	03	05	2016	grade_3	148	148
3160377	MO	school	2925330	19148	PLEASANT HILL R-III	292533002803	4040	PLEASANT HILL ELEM.	Regular School	No	1	03	04	2016	grade_3	156	156
3160872	MO	school	2928410	24087	SMITHVILLE R-II	292841002274	4040	SMITHVILLE UPPER ELEM.	Regular School	No	1	03	05	2016	grade_3	187	187
3161236	MO	school	2907020	25001	CAMERON R-I	290702003267	4040	CAMERON INTERMEDIATE SCHOOL	Regular School	No	1	03	05	2016	grade_3	145	145
3161489	MO	school	2905580	27061	BOONVILLE R-I	290558000103	4040	DAVID BARTON ELEM.	Regular School	No	1	03	05	2016	grade_3	113	113
3161909	MO	school	2916500	35102	KENNETT 39	291650000902	4080	SOUTH ELEM.	Regular School	No	1	03	05	2016	grade_3	139	139
3162058	MO	school	2929100	36136	ST. CLAIR R-XIII	292910001862	4040	EDGAR MURRAY ELEM.	Regular School	No	1	03	05	2016	grade_3	145	145
3162952	MO	school	2909860	42124	CLINTON	290986003145	4080	CLINTON INTERMEDIATE SCHOOL	Regular School	No	1	03	05	2016	grade_3	138	138
3163479	MO	school	2923010	48070	OAK GROVE R-VI	292301001316	4020	OAK GROVE ELEM.	Regular School	No	1	03	05	2016	grade_3	140	140
3164649	MO	school	2931500	49144	WEBB CITY R-VII	293150002184	4020	EUGENE FIELD ELEM.	Regular School	No	1	03	04	2016	grade_3	93	93
3164661	MO	school	2931500	49144	WEBB CITY R-VII	293150002188	4060	MARK TWAIN ELEM.	Regular School	No	1	03	04	2016	grade_3	92	92
3164882	MO	school	2914430	50003	HILLSBORO R-III	291443000673	4020	HILLSBORO ELEM.	Regular School	No	1	03	04	2016	grade_3	239	239
3164961	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623001725	4060	TELEGRAPH INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	67	67
3164988	MO	school	2932100	50010	WINDSOR C-1	293210002250	4020	WINDSOR INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	230	230
3165269	MO	school	2931020	51159	WARRENSBURG R-VI	293102002513	4050	MARTIN WARREN ELEM.	Regular School	No	1	03	05	2016	grade_3	130	130
3165275	MO	school	2931020	51159	WARRENSBURG R-VI	293102001729	4060	STERLING ELEM.	Regular School	No	1	03	05	2016	grade_3	121	121
3165404	MO	school	2923100	54041	ODESSA R-VII	292310001743	4060	ODESSA UPPER ELEM.	Regular School	No	1	03	05	2016	grade_3	154	154
3165518	MO	school	2921600	55108	MT. VERNON R-V	292160003088	4040	MT. VERNON INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	111	111
3165542	MO	school	2904020	55110	AURORA R-VIII	290402000033	4040	ROBINSON ELEM.	Regular School	No	1	03	04	2016	grade_3	138	138
3165702	MO	school	2932190	57004	WINFIELD R-IV	293219002545	4040	WINFIELD INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	127	127
3165851	MO	school	2920610	60077	MCDONALD CO. R-I	292061001101	4040	NOEL ELEM.	Regular School	No	1	03	08	2016	grade_3	62	62
3165863	MO	school	2920610	60077	MCDONALD CO. R-I	292061001102	4060	PINEVILLE ELEM.	Regular School	No	1	03	08	2016	grade_3	31	31
3165995	MO	school	2912540	62072	FREDERICKTOWN R-I	291254002524	4080	FREDERICKTOWN INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	171	171
3166192	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763002479	3000	OSAGE UPPER ELEM.	Regular School	No	1	03	05	2016	grade_3	137	137
3166234	MO	school	2911220	67055	EAST PRAIRIE R-II	291122000385	4060	A. J. MARTIN ELEM.	Regular School	No	1	03	06	2016	grade_3	93	93
3167284	MO	school	2925230	83003	PLATTE CO. R-III	292523001451	4010	BARRY SCH.	Regular School	No	1	03	08	2016	grade_3	123	123
3167426	MO	school	2905370	84001	BOLIVAR R-I	290537001535	4040	BOLIVAR INTERMEDIATE SCH.	Regular School	No	1	03	05	2016	grade_3	210	210
3167579	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002898	4050	FREEDOM ELEM.	Regular School	No	1	03	05	2016	grade_3	292	292
3167734	MO	school	2921100	88081	MOBERLY	292110002820	4020	GRATZ BROWN ELEM.	Regular School	No	1	03	05	2016	grade_3	171	171
3167959	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000234	4020	FOREST PARK ELEM.	Regular School	No	1	03	05	2016	grade_3	144	144
3167965	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000236	4030	LEWIS & CLARK ELEM.	Regular School	No	1	03	05	2016	grade_3	149	149
3168224	MO	school	2931650	92089	WENTZVILLE R-IV	293165002456	4030	HERITAGE INTERMEDIATE	Regular School	No	1	03	05	2016	grade_3	222	222
3168508	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000096	4040	NORTH COUNTY PARKSIDE ELEM.	Regular School	No	1	03	04	2016	grade_3	274	274
3168532	MO	school	2929170	94086	CENTRAL R-III	292917001871	4060	WEST ELEM.	Regular School	No	1	03	05	2016	grade_3	185	185
3169551	MO	school	2902910	96098	AFFTON 101	290291000005	4080	GOTSCH INTERMEDIATE SCH.	Regular School	No	1	03	05	2016	grade_3	191	191
3170534	MO	school	2910770	103132	DEXTER R-XI	291077000361	4020	CENTRAL ELEM.	Regular School	No	1	03	05	2016	grade_3	187	187
3170920	MO	school	2921840	108142	NEVADA R-V	292184001122	4080	TRUMAN ELEM.	Regular School	No	1	03	05	2016	grade_3	196	196
3171040	MO	school	2931140	110014	KINGSTON K-14	293114002165	4040	KINGSTON ELEM.	Regular School	No	1	03	05	2016	grade_3	76	76
3171085	MO	school	2930720	110031	VALLEY R-VI	293072002118	4040	CALEDONIA ELEM.	Regular School	No	1	03	06	2016	grade_3	35	35
3171568	MO	school	2929280	115115	ST. LOUIS CITY	292928003193	4960	HUMBOLDT ACAD OF HIGHER LRNING	Regular School	No	1	03	05	2016	grade_3	96	96
3160412	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000604	4040	MCEOWEN ELEM.	Regular School	No	2	04	05	2016	grade_3	0	0
3160642	MO	school	2922530	22089	Nixa Public Schools	292253002799	4080	SUMMIT INTERMEDIATE SCHOOL	Regular School	No	2	04	06	2016	grade_3	0	0