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 and "year" = :p1 order by total 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	white	black	hispanic	native_american	asian	pacific_islander	multiracial	ell	free_and_reduced	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	ell_int	free_and_reduced_int	disability_int	total_int
3299438	MO	school	2916190	26006	JEFFERSON CITY	291619000495	3020	THOMAS JEFFERSON MIDDLE	Regular School	No	2	06	08	2015	k_12_total	641	191	81	5	24	*	57	25	548.1	89	999	641	191	81	5	24	57	25		89	999
3307803	MO	school	2917820	96106	LADUE	291782000944	3000	LADUE MIDDLE	Regular School	No	2	06	08	2015	k_12_total	621	168	41	*	130	*	36	13	117	114	999	621	168	41		130	36	13	117	114	999
3313248	MO	school	2916190	26006	JEFFERSON CITY	291619000495	3020	THOMAS JEFFERSON MIDDLE	Regular School	No	2	06	08	2015	pk_12_total											999										999
3321613	MO	school	2917820	96106	LADUE	291782000944	3000	LADUE MIDDLE	Regular School	No	2	06	08	2015	pk_12_total											999										999
3107559	MO	school	2930360	40107	TRENTON R-IX	293036002079	4060	RISSLER ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten											99										99
3117811	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2015	kindergarten											99										99
3123386	MO	school	2922890	50001	NORTHWEST R-I	292289001303	4060	HIGH RIDGE ELEM.	Regular School	No	1	KG	05	2015	kindergarten											99										99
3123659	MO	school	2912300	50012	FOX C-6	291230000504	4090	SECKMAN ELEM.	Regular School	No	1	KG	06	2015	kindergarten											99										99
3125172	MO	school	2921810	73108	NEOSHO R-V	292181001203	4020	BENTON ELEM.	Regular School	No	1	KG	04	2015	kindergarten											99										99
3125522	MO	school	2907470	78012	CARUTHERSVILLE 18	290747000216	4060	CARUTHERSVILLE ELEM.	Regular School	No	1	PK	05	2015	kindergarten											99										99
3127823	MO	school	2918690	96093	LINDBERGH SCHOOLS	291869002468	5070	CONCORD ELEM. SCHOOL	Regular School	No	1	KG	05	2015	kindergarten											99										99
3131621	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2015	grade_1											99										99
3133129	MO	school	2923430	22093	OZARK R-VI	292343002727	4085	NORTH ELEM.	Regular School	No	1	KG	04	2015	grade_1											99										99
3133502	MO	school	2922800	24093	NORTH KANSAS CITY 74	292280001266	4160	CRESTVIEW ELEM.	Regular School	No	1	KG	05	2015	grade_1											99										99
3135179	MO	school	2930360	40107	TRENTON R-IX	293036002079	4060	RISSLER ELEM.	Regular School	No	1	PK	04	2015	grade_1											99										99
3135792	MO	school	2905310	48068	BLUE SPRINGS R-IV	290531002836	5080	VOY SPEARS, JR. ELEM.	Regular School	No	1	PK	05	2015	grade_1											99										99
3136974	MO	school	2907460	49142	CARTHAGE R-IX	290746000204	4020	COLUMBIAN ELEM.	Regular School	No	1	KG	04	2015	grade_1											99										99
3137421	MO	school	2912300	50012	FOX C-6	291230000497	4010	ANTONIA ELEM.	Regular School	No	1	KG	05	2015	grade_1											99										99
3139090	MO	school	2920490	74201	MARYVILLE R-II	292049001093	4020	EUGENE FIELD ELEM.	Regular School	No	1	PK	04	2015	grade_1											99										99
3140837	MO	school	2911910	94078	FARMINGTON R-VII	291191000442	4030	WASHINGTON-FRANKLIN ELEM.	Regular School	No	1	01	04	2015	grade_1											99										99
3146927	MO	school	2923430	22093	OZARK R-VI	292343003001	4070	WEST ELEM.	Regular School	No	1	KG	04	2015	grade_2											99										99
3148374	MO	school	2923340	37037	GASCONADE CO. R-II	292334003008	4050	OWENSVILLE ELEM.	Regular School	No	1	PK	05	2015	grade_2											99										99
3150156	MO	school	2915480	48077	INDEPENDENCE 30	291548003107	5100	KORTE ELEM.	Regular School	No	1	PK	05	2015	grade_2											99										99
3154937	MO	school	2913830	96088	HAZELWOOD	291383002858	4340	ARROWPOINT ELEM.	Regular School	No	1	PK	05	2015	grade_2											99										99
3160292	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001427	4040	RAYMORE ELEM.	Regular School	No	1	PK	04	2015	grade_3											99										99
3160635	MO	school	2922530	22089	Nixa Public Schools	292253001651	4070	MATHEWS ELEM.	Regular School	No	1	KG	04	2015	grade_3											99										99
3160992	MO	school	2918540	24090	LIBERTY 53	291854002863	4160	LIBERTY OAKS ELEM.	Regular School	No	1	KG	05	2015	grade_3											99										99
3173252	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	1	PK	05	2015	grade_4											99										99
3183250	MO	school	2923580	96095	PARKWAY C-2	292358001380	4040	CLAYMONT ELEM.	Regular School	No	1	KG	05	2015	grade_4											99										99
3185570	MO	school	2900576	115903	PREMIER CHARTER SCHOOL	290057602831	6915	PREMIER CHARTER SCHOOL	Regular School	Yes	1	KG	08	2015	grade_4											99										99
3188921	MO	school	2909930	26002	BLAIR OAKS R-II	290993003117	3000	BLAIR OAKS MIDDLE SCHOOL	Regular School	No	2	05	08	2015	grade_5											99										99
3192703	MO	school	2912300	50012	FOX C-6	291230000503	4080	ROCKPORT HEIGHTS ELEM.	Regular School	No	1	KG	06	2015	grade_5											99										99
3192756	MO	school	2910500	50014	DESOTO 73	291050000347	4010	ATHENA ELEM.	Regular School	No	1	KG	06	2015	grade_5											99										99
3212139	MO	school	2912240	106003	FORSYTH R-III	291224000789	3000	FORSYTH MIDDLE	Regular School	No	2	05	08	2015	grade_6											99										99
3240316	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002619	3000	MOUNTAIN GROVE MIDDLE	Regular School	No	2	05	08	2015	grade_8											99										99
3244155	MO	school	2909930	26002	BLAIR OAKS R-II	290993000295	1050	BLAIR OAKS HIGH	Regular School	No	3	09	12	2015	grade_9											99										99
3272083	MO	school	2906120	30093	DALLAS CO. R-I	290612000149	1050	BUFFALO HIGH	Regular School	No	3	09	12	2015	grade_11											99										99
3274805	MO	school	2900014	48904	HOGAN PREPARATORY ACADEMY	290001402743	1935	HOGAN PREPARATORY ACADEMY	Regular School	Yes	3	09	12	2015	grade_11											99										99
3278831	MO	school	2923160	92091	ORCHARD FARM R-V	292316001331	1050	ORCHARD FARM SR. HIGH	Regular School	No	3	09	12	2015	grade_11											99										99
3283228	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	3	09	12	2015	grade_12											99										99
3299722	MO	school	2923670	31116	PATTONSBURG R-II	292367001410	1050	PATTONSBURG HIGH	Regular School	No	3	07	12	2015	k_12_total	97	*	*	*	*	*	*	*	52	16	99	97							52	16	99
3313532	MO	school	2923670	31116	PATTONSBURG R-II	292367001410	1050	PATTONSBURG HIGH	Regular School	No	3	07	12	2015	pk_12_total											99										99
3307516	MO	school	2923580	96095	PARKWAY C-2	292358001555	3080	WEST MIDDLE	Regular School	No	2	06	08	2015	k_12_total	699	103	37	*	118	*	29	*	145	195	987	699	103	37		118	29		145	195	987
3321326	MO	school	2923580	96095	PARKWAY C-2	292358001555	3080	WEST MIDDLE	Regular School	No	2	06	08	2015	pk_12_total											987										987
3306046	MO	school	2908370	92087	FT. ZUMWALT R-II	290837002427	3070	FT. ZUMWALT SOUTH MIDDLE	Regular School	No	2	06	08	2015	k_12_total	825	49	30	*	45	*	25	10	135	117	980	825	49	30		45	25	10	135	117	980
3319856	MO	school	2908370	92087	FT. ZUMWALT R-II	290837002427	3070	FT. ZUMWALT SOUTH MIDDLE	Regular School	No	2	06	08	2015	pk_12_total											980										980
3113085	MO	school	2928920	92090	ST. CHARLES R-VI	292892001852	4060	HARRIS ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten											98										98
3119568	MO	school	2918540	24090	LIBERTY 53	291854002902	4180	WARREN HILLS ELEM.	Regular School	No	1	KG	05	2015	kindergarten											98										98
3123706	MO	school	2910500	50014	DESOTO 73	291050000347	4010	ATHENA ELEM.	Regular School	No	1	KG	06	2015	kindergarten											98										98
3127874	MO	school	2920670	96094	MEHLVILLE R-IX	292067001111	4060	BIERBAUM ELEM.	Regular School	No	1	KG	05	2015	kindergarten											98										98
3131816	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	1	PK	05	2015	grade_1											98										98
3133372	MO	school	2918540	24090	LIBERTY 53	291854002863	4160	LIBERTY OAKS ELEM.	Regular School	No	1	KG	05	2015	grade_1											98										98
3139453	MO	school	2927830	80125	SEDALIA 200	292783002639	4030	PARKVIEW ELEM.	Regular School	No	1	KG	04	2015	grade_1											98										98
3144072	MO	school	2929280	115115	ST. LOUIS CITY	292928001590	5930	STIX EARLY CHILDHOOD CTR.	Regular School	No	1	PK	02	2015	grade_1											98										98
3144213	MO	school	2900591	115914	KIPP ST LOUIS	290059103245	6971	KIPP VICTORY ACADEMY	Regular School	Yes	1	KG	01	2015	grade_1											98										98
3145557	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	1	PK	05	2015	grade_2											98										98
3146915	MO	school	2923430	22093	OZARK R-VI	292343002439	4040	SOUTH ELEM.	Regular School	No	1	PK	04	2015	grade_2											98										98
3148785	MO	school	2928860	39141	SPRINGFIELD R-XII	292886002305	4330	JEFFRIES ELEM.	Regular School	No	1	PK	05	2015	grade_2											98										98
3149776	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830000523	5025	RICHARDSON ELEM.	Regular School	No	1	KG	06	2015	grade_2											98										98
3150790	MO	school	2907460	49142	CARTHAGE R-IX	290746001980	4030	STEADLEY ELEM.	Regular School	No	1	PK	04	2015	grade_2											98										98
3150796	MO	school	2907460	49142	CARTHAGE R-IX	290746000206	4060	FAIRVIEW ELEM.	Regular School	No	1	KG	04	2015	grade_2											98										98
3159247	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2015	grade_3											98										98
3162184	MO	school	2923340	37037	GASCONADE CO. R-II	292334003008	4050	OWENSVILLE ELEM.	Regular School	No	1	PK	05	2015	grade_3											98										98
3165071	MO	school	2912300	50012	FOX C-6	291230000501	4060	MERAMEC HEIGHTS ELEM.	Regular School	No	1	KG	06	2015	grade_3											98										98
3167085	MO	school	2927830	80125	SEDALIA 200	292783002640	4050	SKYLINE ELEM.	Regular School	No	1	KG	04	2015	grade_3											98										98
3167163	MO	school	2926890	81096	ROLLA 31	292689001632	4100	HARRY S. TRUMAN ELEM.	Regular School	No	1	KG	04	2015	grade_3											98										98
3169130	MO	school	2926850	96091	ROCKWOOD R-VI	292685002700	4165	WILD HORSE ELEM.	Regular School	No	1	KG	05	2015	grade_3											98										98
3171788	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903079	6932	SOUTH CITY	Regular School	Yes	1	KG	08	2015	grade_3											98										98
3173486	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	1	01	04	2015	grade_4											98										98
3174814	MO	school	2918540	24090	LIBERTY 53	291854003113	4200	KELLYBROOK ELEM SCHOOL	Regular School	No	1	KG	05	2015	grade_4											98										98
3177210	MO	school	2905310	48068	BLUE SPRINGS R-IV	290531002682	5040	CHAPEL LAKES ELEM.	Regular School	No	1	PK	05	2015	grade_4											98										98
3179750	MO	school	2919410	61156	MACON CO. R-I	291941001050	4020	MACON ELEM.	Regular School	No	1	PK	05	2015	grade_4											98										98
3180520	MO	school	2920490	74201	MARYVILLE R-II	292049001093	4020	EUGENE FIELD ELEM.	Regular School	No	1	PK	04	2015	grade_4											98										98
3180973	MO	school	2926890	81096	ROLLA 31	292689001632	4100	HARRY S. TRUMAN ELEM.	Regular School	No	1	KG	04	2015	grade_4											98										98
3182886	MO	school	2926850	96091	ROCKWOOD R-VI	292685001622	4120	GEGGIE ELEM.	Regular School	No	1	KG	05	2015	grade_4											98										98
3183832	MO	school	2931530	96114	WEBSTER GROVES	293153002190	4020	AVERY ELEM.	Regular School	No	1	KG	05	2015	grade_4											98										98
3195644	MO	school	2908370	92087	FT. ZUMWALT R-II	290837002697	4140	PHEASANT POINT ELEM.	Regular School	No	1	KG	05	2015	grade_5											98										98
3197108	MO	school	2923580	96095	PARKWAY C-2	292358002626	4190	OAK BROOK ELEM.	Regular School	No	1	PK	05	2015	grade_5											98										98
3213190	MO	school	2900576	115903	PREMIER CHARTER SCHOOL	290057602831	6915	PREMIER CHARTER SCHOOL	Regular School	Yes	1	KG	08	2015	grade_6											98										98
3225949	MO	school	2912240	106003	FORSYTH R-III	291224000789	3000	FORSYTH MIDDLE	Regular School	No	2	05	08	2015	grade_7											98										98
3259805	MO	school	2932070	46131	WILLOW SPRINGS R-IV	293207002245	1050	WILLOW SPRINGS HIGH	Regular School	No	3	09	12	2015	grade_10											98										98
3276737	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	3	09	12	2015	grade_11											98										98
3289456	MO	school	2914490	51152	HOLDEN R-III	291449000680	1050	HOLDEN HIGH	Regular School	No	3	09	12	2015	grade_12											98										98
3304405	MO	school	2915660	68074	JAMESTOWN C-1	291566000742	4020	JAMESTOWN C-I ELEM.	Regular School	No	1	PK	06	2015	k_12_total	95	*	*	*	*	*	*	*	28	14	98	95							28	14	98
3312479	MO	school	2916530	21150	KEYTESVILLE R-III	291653000904	4020	KEYTESVILLE ELEM.	Regular School	No	1	PK	06	2015	pk_12_total											98										98
3314767	MO	school	2912870	41004	GILMAN CITY R-IV	291287000537	4020	GILMAN CITY ELEM.	Regular School	No	1	PK	06	2015	pk_12_total											98										98
3303224	MO	school	2910500	50014	DESOTO 73	291050000350	1050	DESOTO SR. HIGH	Regular School	No	3	09	12	2015	k_12_total	949	18	5	*	*	*	*	*	379	158	979	949	18	5					379	158	979
3317034	MO	school	2910500	50014	DESOTO 73	291050000350	1050	DESOTO SR. HIGH	Regular School	No	3	09	12	2015	pk_12_total											979										979
3298547	MO	school	2904620	19152	BELTON 124	290462000055	1050	BELTON HIGH	Regular School	No	3	10	12	2015	k_12_total	712	130	99	*	6	*	26	10	425	119	978	712	130	99		6	26	10	425	119	978
3312357	MO	school	2904620	19152	BELTON 124	290462000055	1050	BELTON HIGH	Regular School	No	3	10	12	2015	pk_12_total											978										978
3308415	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	3	09	12	2015	k_12_total	576	357	32	*	8	*	*	*	516.3	103	975	576	357	32		8				103	975
3322225	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	3	09	12	2015	pk_12_total											975										975
3309090	MO	school	2931050	109003	WARREN CO. R-III	293105002151	1050	WARRENTON HIGH	Regular School	No	3	09	12	2015	k_12_total	874	33	33	5	*	*	25	*	441	138	974	874	33	33	5		25		441	138	974
3322900	MO	school	2931050	109003	WARREN CO. R-III	293105002151	1050	WARRENTON HIGH	Regular School	No	3	09	12	2015	pk_12_total											974										974
3301620	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002806	3050	SUMMIT LAKES MIDDLE	Regular School	No	2	07	08	2015	k_12_total	777	107	35	*	16	*	37	*	89	91	973	777	107	35		16	37		89	91	973
3302174	MO	school	2916400	48078	KANSAS CITY 33	291640000880	1580	EAST HIGH SCHOOL	Regular School	No	3	08	12	2015	k_12_total	95	290	468	*	113	*	*	457	*	107	973	95	290	468		113		457		107	973
3315430	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002806	3050	SUMMIT LAKES MIDDLE	Regular School	No	2	07	08	2015	pk_12_total											973										973
3315984	MO	school	2916400	48078	KANSAS CITY 33	291640000880	1580	EAST HIGH SCHOOL	Regular School	No	3	08	12	2015	pk_12_total											973										973
3298377	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373000088	3000	RAYMORE-PECULIAR EAST MIDDLE	Regular School	No	2	07	08	2015	k_12_total	793	96	36	*	14	*	27	*	267	87	971	793	96	36		14	27		267	87	971
3312187	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373000088	3000	RAYMORE-PECULIAR EAST MIDDLE	Regular School	No	2	07	08	2015	pk_12_total											971										971
3112179	MO	school	2905370	84001	BOLIVAR R-I	290537000090	4020	BOLIVAR PRIMARY	Regular School	No	1	PK	02	2015	pre_kindergarten											97										97