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_high_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
3131590	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2020	grade_1	117	117
3132584	MO	school	2907380	17125	CARROLLTON R-VII	290738003131	4000	ADAMS PRIMARY SCHOOL	Regular School	No	Elementary	PK	01	2020	grade_1	80	80
3133525	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280001272	4280	GASHLAND ELEMENTARY	Regular School	No	Elementary	PK	01	2020	grade_1	118	118
3134131	MO	school	2927090	33090	SALEM R-80	292709001679	4020	WM. H. LYNCH ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	92	92
3134794	MO	school	2919170	39139	LOGAN-ROGERSVILLE R-VIII	291917002434	4020	LOGAN-ROGERSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2020	grade_1	159	159
3136393	MO	school	2915480	48077	INDEPENDENCE 30	291548003098	6080	SUGAR CREEK ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	73	73
3136907	MO	school	2907350	49132	CARL JUNCTION R-I	290735002811	4040	Carl Junction Primary K-1	Regular School	No	Elementary	PK	01	2020	grade_1	229	229
3137063	MO	school	2931500	49144	WEBB CITY R-VII	293150002991	5010	BESS TRUMAN PRIMARY CTR.	Regular School	No	Elementary	KG	01	2020	grade_1	90	90
3137714	MO	school	2918270	53113	LEBANON R-III	291827000975	4020	JOE D. ESTHER ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	299	299
3138204	MO	school	2908760	59117	CHILLICOTHE R-II	290876000261	4040	CHILLICOTHE ELEM	Regular School	No	Elementary	PK	01	2020	grade_1	126	126
3140190	MO	school	2926480	89089	RICHMOND R-XVI	292648001552	4020	DEAR ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	95	95
3142990	MO	school	2926160	104044	REEDS SPRING R-IV	292616001534	4020	REEDS SPRING PRIMARY	Regular School	No	Elementary	PK	01	2020	grade_1	118	118
3143160	MO	school	2914550	106005	HOLLISTER R-V	291455003165	4010	HOLLISTER EARLY CHILDHOOD CTR	Regular School	No	Elementary	PK	01	2020	grade_1	101	101
3143298	MO	school	2921840	108142	NEVADA R-V	292184001212	4040	BRYAN ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	165	165
3143364	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003138	4040	WRIGHT CITY EAST ELEM	Regular School	No	Elementary	KG	01	2020	grade_1	132	132
3143561	MO	school	2920430	112102	MARSHFIELD R-I	292043001089	4020	EDWIN P. HUBBLE ELEM.	Regular School	No	Elementary	PK	01	2020	grade_1	209	209
3130988	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	158	158
3131222	MO	school	2908170	5123	CASSVILLE R-IV	290817000217	4020	EUNICE THOMAS ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	123	123
3131275	MO	school	2921120	5128	MONETT R-I	292112001160	4020	MONETT ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	148	148
3131341	MO	school	2917850	6104	LAMAR R-I	291785002720	4040	EAST ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	82	82
3131560	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	166	166
3131626	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	98	98
3132037	MO	school	2921750	12108	NEELYVILLE R-IV	292175001201	4040	HILLVIEW ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	49	49
3132285	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843003120	4010	SOUTH CALLAWAY EARLY CHD PK-02	Regular School	No	Elementary	PK	02	2020	grade_1	60	60
3132345	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	184	184
3132423	MO	school	2915600	16090	JACKSON R-II	291560000733	4060	GORDONVILLE ATTENDANCE CTR	Regular School	No	Elementary	KG	02	2020	grade_1	19	19
3132755	MO	school	2925330	19148	PLEASANT HILL R-III	292533001460	4020	PLEASANT HILL PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	163	163
3133615	MO	school	2907020	25001	CAMERON R-I	290702000178	4020	PARKVIEW ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	103	103
3133867	MO	school	2905580	27061	BOONVILLE R-I	290558000102	4020	HANNAH COLE PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	102	102
3134287	MO	school	2916500	35102	KENNETT 39	291650000896	4040	H. BYRON MASTERSON ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	156	156
3134436	MO	school	2929100	36136	ST. CLAIR R-XIII	292910001865	4020	ST. CLAIR ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	169	169
3134466	MO	school	2929760	36137	SULLIVAN	292976002805	4040	SULLIVAN PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	144	144
3135330	MO	school	2909860	42124	CLINTON	290986000289	4070	HENRY ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	114	114
3135869	MO	school	2923010	48070	OAK GROVE R-VI	292301000141	4040	OAK GROVE PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	141	141
3136738	MO	school	2900025	48909	ALLEN VILLAGE	290002503327	6905	ALLEN VILLAGE PRIMARY	Regular School	Yes	Elementary	KG	02	2020	grade_1	41	41
3137051	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2020	grade_1	190	190
3137278	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_1	226	226
3137339	MO	school	2916230	50007	JEFFERSON CO. R-VII	291623000763	4020	PLATTIN PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_1	78	78
3137378	MO	school	2932100	50010	WINDSOR C-1	293210002868	4030	WINDSOR ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	115	115
3137384	MO	school	2932100	50010	WINDSOR C-1	293210002251	4040	JAMES E. FREER ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	79	79
3137647	MO	school	2931020	51159	WARRENSBURG R-VI	293102002144	4030	RIDGE VIEW ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	121	121
3137665	MO	school	2931020	51159	WARRENSBURG R-VI	293102003185	4070	MAPLE GROVE ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	134	134
3137782	MO	school	2923100	54041	ODESSA R-VII	292310001323	4040	MCQUERRY ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	133	133
3137896	MO	school	2921600	55108	MT. VERNON R-V	292160001188	4020	MT. VERNON ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	89	89
3137920	MO	school	2904020	55110	AURORA R-VIII	290402000032	4020	PATE EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	02	2020	grade_1	137	137
3138080	MO	school	2932190	57004	WINFIELD R-IV	293219002256	4020	WINFIELD ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	102	102
3138241	MO	school	2920610	60077	MCDONALD CO. R-I	292061003094	4050	NOEL PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	63	63
3138253	MO	school	2920610	60077	MCDONALD CO. R-I	292061003106	4070	PINEVILLE PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	17	17
3138373	MO	school	2912540	62072	FREDERICKTOWN R-I	291254000513	4020	FREDERICKTOWN ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	127	127
3138582	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763001696	4020	HERITAGE ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	154	154
3138612	MO	school	2911220	67055	EAST PRAIRIE R-II	291122000387	4040	R. A. DOYLE ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	86	86
3138828	MO	school	2930840	71092	MORGAN CO. R-II	293084002132	4040	MORGAN CO. SOUTH ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	21	21
3139362	MO	school	2924530	79077	PERRY CO. 32	292453003361	4040	PERRYVILLE PRIMARY CENTER	Regular School	No	Elementary	PK	02	2020	grade_1	154	154
3139632	MO	school	2922830	83001	NORTH PLATTE CO. R-I	292283001295	4020	NORTH PLATTE ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	36	36
3139804	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	188	188
3140124	MO	school	2921100	88081	MOBERLY	292110001157	4060	NORTH PARK ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	79	79
3140130	MO	school	2921100	88081	MOBERLY	292110001158	4080	SOUTH PARK ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	91	91
3140274	MO	school	2910920	91092	DONIPHAN R-I	291092000371	4020	DONIPHAN ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	117	117
3140355	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000235	4040	JOSEPH L. MUDD ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	153	153
3140367	MO	school	2908370	92087	FT. ZUMWALT R-II	290837000241	4060	ST. PETERS ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	174	174
3140602	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_1	184	184
3140880	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	195	195
3140910	MO	school	2929170	94086	CENTRAL R-III	292917001868	4020	CENTRAL ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	157	157
3141198	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000452	4020	BERMUDA ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	53	53
3141205	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000454	4040	CENTRAL ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	62	62
3141217	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000456	4080	COMMONS LANE ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	92	92
3141228	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000460	4140	DUCHESNE ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	100	100
3141246	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000468	4190	HOLMAN ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	67	67
3141264	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000473	4240	PARKER ROAD ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_1	114	114
3141281	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000477	4320	WALNUT GROVE ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	155	155
3141929	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2020	grade_1	195	195
3142147	MO	school	2920010	96107	MAPLEWOOD-RICHMOND HEIGHTS	292001001068	4080	MRH EARLY CHILDHOOD CENTER	Regular School	No	Elementary	PK	02	2020	grade_1	121	121
3142563	MO	school	2920410	97129	MARSHALL	292041001082	4020	BENTON ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	100	100
3142581	MO	school	2920410	97129	MARSHALL	292041001087	5000	SOUTHEAST ELEM.	Regular School	No	Elementary	KG	02	2020	grade_1	100	100
3142924	MO	school	2910770	103132	DEXTER R-XI	291077000364	4040	SOUTHWEST ELEM.	Regular School	No	Elementary	PK	02	2020	grade_1	176	176
3143292	MO	school	2921840	108142	NEVADA R-V	292184001211	4020	BENTON ELEM.	Regular School	No	Elementary	02	02	2020	grade_1	0	0
3143418	MO	school	2931140	110014	KINGSTON K-14	293114003105	4020	KINGSTON PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_1	54	54
3144077	MO	school	2929280	115115	ST. LOUIS CITY	292928001590	5930	STIX EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	02	2020	grade_1	117	117
3144101	MO	school	2929280	115115	ST. LOUIS CITY	292928002646	6030	WILKINSON EARLY CHILDHOOD CTR.	Regular School	No	Elementary	PK	02	2020	grade_1	51	51
3144139	MO	school	2900574	115902	LIFT FOR LIFE ACADEMY	290057403356	6905	LIFT FOR LIFE ACADEMY ELEM.	Regular School	Yes	Elementary	KG	02	2020	grade_1	36	36
3132061	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2020	grade_1	108	108
3132085	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2020	grade_1	93	93
3132091	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2020	grade_1	111	111
3132117	MO	school	2930520	12110	TWIN RIVERS R-X	293052002094	4060	QULIN ELEMENTARY	Regular School	No	Elementary	PK	03	2020	grade_1	20	20
3132429	MO	school	2915600	16090	JACKSON R-II	291560000735	4100	MILLERSVILLE ATTENDANCE CTR.	Regular School	No	Elementary	KG	03	2020	grade_1	20	20
3132790	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000602	4020	HARRISONVILLE ELEM.	Regular School	No	Elementary	01	03	2020	grade_1	151	151
3134394	MO	school	2930570	36131	UNION R-XI	293057002098	4040	CENTRAL ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	196	196
3134587	MO	school	2914280	37039	GASCONADE CO. R-I	291428000644	4060	HERMANN ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	52	52
3134738	MO	school	2903270	39135	ASH GROVE R-IV	290327000027	4020	ASH GROVE ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	43	43
3134800	MO	school	2919170	39139	LOGAN-ROGERSVILLE R-VIII	291917003128	4030	LOGAN-ROGERSVILLE ELEMENTARY	Regular School	No	Elementary	02	03	2020	grade_1	0	0
3136913	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2020	grade_1	0	0
3137315	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2020	grade_1	268	268
3137722	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2020	grade_1	0	0
3138210	MO	school	2908760	59117	CHILLICOTHE R-II	290876000262	4060	FIELD ELEM.	Regular School	No	Elementary	02	03	2020	grade_1	0	0
3138528	MO	school	2911340	66102	ELDON R-I	291134000403	4020	SOUTH ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	135	135
3138954	MO	school	2927900	73106	SENECA R-VII	292790001717	4020	SENECA ELEM.	Regular School	No	Elementary	KG	03	2020	grade_1	82	82
3139536	MO	school	2926890	81096	ROLLA 31	292689001631	4040	COL. JOHN B. WYMAN ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	100	100
3139542	MO	school	2926890	81096	ROLLA 31	292689001634	4060	MARK TWAIN ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	96	96
3139548	MO	school	2926890	81096	ROLLA 31	292689001632	4100	HARRY S. TRUMAN ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	103	103
3142052	MO	school	2916290	96104	JENNINGS	291629000766	4020	FAIRVIEW PRIMARY	Regular School	No	Elementary	PK	03	2020	grade_1	41	41
3142070	MO	school	2916290	96104	JENNINGS	291629000770	4060	WOODLAND ELEM.	Regular School	No	Elementary	PK	03	2020	grade_1	59	59