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 total_int 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
3151527	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	1	02	03	2015	grade_2	351	351
3151528	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	1	02	03	2016	grade_2	344	344
3151529	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2017	grade_2	337	337
3153763	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002168	4040	WAYNESVILLE EAST ELEM.	Regular School	No	1	PK	02	2016	grade_2	327	327
3151531	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2019	grade_2	313	313
3153764	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002168	4040	WAYNESVILLE EAST ELEM.	Regular School	No	Elementary	PK	02	2017	grade_2	309	309
3151532	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2020	grade_2	299	299
3151530	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2018	grade_2	298	298
3153762	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002168	4040	WAYNESVILLE EAST ELEM.	Regular School	No	1	PK	02	2015	grade_2	292	292
3044957	MO	school	2918270	53113	LEBANON R-III	291827000973	4060	MAPLECREST ELEM.	Regular School	No	Elementary	02	03	2021	grade_2	277	277
3151085	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2017	grade_2	271	271
3150723	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2020	grade_2	267	267
3146150	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEM.	Regular School	No	1	PK	02	2015	grade_2	263	263
3154685	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	1	PK	02	2015	grade_2	262	262
3154686	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	1	PK	02	2016	grade_2	257	257
3150719	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	1	02	03	2016	grade_2	256	256
3044889	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2021	grade_2	255	255
3157373	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	1	02	03	2016	grade_2	249	249
3151088	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_2	248	248
3151123	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2018	grade_2	246	246
3157372	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	1	02	03	2015	grade_2	246	246
3151122	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2017	grade_2	245	245
3151120	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	1	KG	03	2015	grade_2	243	243
3151083	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	1	KG	02	2015	grade_2	241	241
3151084	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	1	KG	02	2016	grade_2	241	241
3044820	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2021	grade_2	237	237
3157377	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2020	grade_2	237	237
3150718	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	1	02	03	2015	grade_2	236	236
3154687	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	Elementary	PK	02	2017	grade_2	235	235
3151086	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2018	grade_2	234	234
3151121	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	1	KG	03	2016	grade_2	234	234
3044882	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2021	grade_2	231	231
3150722	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2019	grade_2	231	231
3157376	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2019	grade_2	227	227
3150720	MO	school	2907350	49132	CARL JUNCTION R-I	290735000197	4050	Carl Junction Primary 2-3	Regular School	No	Elementary	02	03	2017	grade_2	226	226
3151087	MO	school	2914430	50003	HILLSBORO R-III	291443002598	4080	HILLSBORO PRIMARY	Regular School	No	Elementary	KG	02	2019	grade_2	225	225
3155738	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2019	grade_2	225	225
3146151	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEM.	Regular School	No	1	PK	02	2016	grade_2	223	223
3151125	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2020	grade_2	223	223
3146153	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEM.	Regular School	No	Elementary	PK	02	2018	grade_2	222	222
3151124	MO	school	2912030	50006	FESTUS R-VI	291203000479	4020	FESTUS ELEM.	Regular School	No	Elementary	KG	03	2019	grade_2	220	220
3154409	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	Elementary	KG	02	2017	grade_2	220	220
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
3154408	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	1	KG	02	2016	grade_2	219	219
3146152	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEM.	Regular School	No	Elementary	PK	02	2017	grade_2	218	218
3148199	MO	school	2930570	36131	UNION R-XI	293057002098	4040	CENTRAL ELEM.	Regular School	No	1	PK	03	2015	grade_2	218	218
3157374	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2017	grade_2	216	216
3154321	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895001859	4070	FAIRMOUNT ELEM.	Regular School	No	Elementary	KG	05	2019	grade_2	211	211
3155739	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2020	grade_2	210	210
3156924	MO	school	2905760	106004	BRANSON R-IV	290576002462	4040	CEDAR RIDGE ELEMENTARY	Regular School	No	1	01	03	2016	grade_2	210	210
3144793	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2015	grade_2	208	208
3153166	MO	school	2924530	79077	PERRY CO. 32	292453002386	4020	PERRYVILLE ELEM.	Regular School	No	1	KG	04	2015	grade_2	208	208
3154407	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	1	KG	02	2015	grade_2	205	205
3154411	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	Elementary	KG	02	2019	grade_2	205	205
3155737	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2018	grade_2	205	205
3153766	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002168	4040	WAYNESVILLE EAST ELEM.	Regular School	No	Elementary	KG	05	2019	grade_2	203	203
3155736	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	PK	02	2017	grade_2	202	202
3150858	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2017	grade_2	200	200
3150861	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2020	grade_2	200	200
3153611	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	Elementary	PK	02	2017	grade_2	200	200
3153609	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	1	PK	02	2015	grade_2	199	199
3153614	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_2	199	199
3156926	MO	school	2905760	106004	BRANSON R-IV	290576002462	4040	CEDAR RIDGE ELEMENTARY	Regular School	No	Elementary	01	03	2018	grade_2	199	199
3150857	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	1	01	02	2016	grade_2	198	198
3154463	MO	school	2931650	92089	WENTZVILLE R-IV	293165003155	4110	DISCOVERY RIDGE ELEMENTARY	Regular School	No	Elementary	KG	05	2017	grade_2	198	198
3156729	MO	school	2910770	103132	DEXTER R-XI	291077000364	4040	SOUTHWEST ELEM.	Regular School	No	1	PK	02	2015	grade_2	198	198
3156925	MO	school	2905760	106004	BRANSON R-IV	290576002462	4040	CEDAR RIDGE ELEMENTARY	Regular School	No	Elementary	01	03	2017	grade_2	198	198
3144796	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	Elementary	PK	02	2018	grade_2	197	197
3153610	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	1	PK	02	2016	grade_2	197	197
3154688	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	Elementary	PK	02	2018	grade_2	197	197
3155735	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	1	PK	02	2016	grade_2	197	197
3157253	MO	school	2925500	110029	POTOSI R-III	292550001493	4080	POTOSI ELEM.	Regular School	No	1	PK	03	2015	grade_2	197	197
3045429	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895001859	4070	FAIRMOUNT ELEM.	Regular School	No	Elementary	KG	05	2021	grade_2	196	196
3146155	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_2	196	196
3154690	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_2	196	196
3045942	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2021	grade_2	195	195
3154320	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895001859	4070	FAIRMOUNT ELEM.	Regular School	No	Elementary	KG	05	2018	grade_2	192	192
3044844	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2021	grade_2	191	191
3146154	MO	school	2906990	15002	CAMDENTON R-III	290699000171	4020	DOGWOOD ELEM.	Regular School	No	Elementary	PK	02	2019	grade_2	191	191
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
3154716	MO	school	2929170	94086	CENTRAL R-III	292917001868	4020	CENTRAL ELEM.	Regular School	No	1	PK	02	2016	grade_2	188	188
3155734	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	1	PK	02	2015	grade_2	187	187
3153485	MO	school	2925230	83003	PLATTE CO. R-III	292523002024	4030	DONALD D. SIEGRIST ELEM.	Regular School	No	1	PK	03	2015	grade_2	186	186
3153613	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	Elementary	PK	02	2019	grade_2	186	186
3154412	MO	school	2931650	92089	WENTZVILLE R-IV	293165002207	4020	HERITAGE PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_2	186	186
3154426	MO	school	2931650	92089	WENTZVILLE R-IV	293165002652	4050	BOONE TRAIL ELEM.	Regular School	No	1	KG	05	2016	grade_2	186	186
3157375	MO	school	2920430	112102	MARSHFIELD R-I	292043002470	4040	DANIEL WEBSTER ELEM.	Regular School	No	Elementary	02	03	2018	grade_2	186	186
3150856	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	1	01	02	2015	grade_2	185	185
3154715	MO	school	2929170	94086	CENTRAL R-III	292917001868	4020	CENTRAL ELEM.	Regular School	No	1	PK	02	2015	grade_2	185	185
3156386	MO	school	2920410	97129	MARSHALL	292041001087	5000	SOUTHEAST ELEM.	Regular School	No	1	KG	02	2015	grade_2	185	185
3147055	MO	school	2928410	24087	SMITHVILLE R-II	292841001753	4020	SMITHVILLE ELEM.	Regular School	No	Elementary	PK	02	2017	grade_2	184	184
3150860	MO	school	2931500	49144	WEBB CITY R-VII	293150002189	4080	WEBSTER PRIMARY CTR.	Regular School	No	Elementary	01	02	2019	grade_2	184	184
3153772	MO	school	2931440	85046	WAYNESVILLE R-VI	293144002898	4050	FREEDOM ELEM.	Regular School	No	Elementary	KG	05	2019	grade_2	184	184
3154689	MO	school	2905430	94083	NORTH ST. FRANCOIS CO. R-I	290543000099	4020	NORTH COUNTY PRIMARY	Regular School	No	Elementary	PK	02	2019	grade_2	184	184
3045668	MO	school	2902910	96098	AFFTON 101	290291000007	4040	MESNIER PRIMARY SCH.	Regular School	No	Elementary	KG	02	2021	grade_2	183	183
3144794	MO	school	2916740	1091	KIRKSVILLE R-III	291674002219	4030	KIRKSVILLE PRIMARY	Regular School	No	1	PK	02	2016	grade_2	182	182
3147054	MO	school	2928410	24087	SMITHVILLE R-II	292841001753	4020	SMITHVILLE ELEM.	Regular School	No	1	PK	02	2016	grade_2	182	182
3157098	MO	school	2921840	108142	NEVADA R-V	292184001211	4020	BENTON ELEM.	Regular School	No	1	02	02	2016	grade_2	182	182
3148200	MO	school	2930570	36131	UNION R-XI	293057002098	4040	CENTRAL ELEM.	Regular School	No	1	PK	03	2016	grade_2	181	181
3154322	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895001859	4070	FAIRMOUNT ELEM.	Regular School	No	Elementary	KG	05	2020	grade_2	181	181
3154717	MO	school	2929170	94086	CENTRAL R-III	292917001868	4020	CENTRAL ELEM.	Regular School	No	Elementary	PK	02	2017	grade_2	181	181