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 school_state_id 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
3103696	MO	school	2917850	6104	LAMAR R-I	291785001487	1010	LOCKWOOD SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	37	37
3106797	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	130	130
3112195	MO	school	2911730	84002	FAIR PLAY R-II	291173003214	1010	EXCEPTIONAL PUPIL COOP	Special Education School	No	Other	PK	12	2019	pre_kindergarten	95	95
3115387	MO	school	2905280	104045	BLUE EYE R-V	290528002518	1010	TRI-LAKES SPECL. EDUC. COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	47	47
3115575	MO	school	2914840	107152	HOUSTON R-I	291484000686	1010	EXCEPTIONAL CHILD COOP.	Special Education School	No	Other	PK	12	2019	pre_kindergarten	57	57
3116920	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	pre_kindergarten	0	0
3104035	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	pre_kindergarten	0	0
3104706	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	pre_kindergarten	0	0
3105152	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	pre_kindergarten	0	0
3108254	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002614	1015	HILLTOP SCHOOL	Alternative School	No	High	05	12	2019	pre_kindergarten	0	0
3109627	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2019	pre_kindergarten	0	0
3113197	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	pre_kindergarten	0	0
3114834	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676002630	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	pre_kindergarten	0	0
3115261	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	pre_kindergarten	0	0
3116018	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2019	pre_kindergarten	0	0
3116066	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2019	pre_kindergarten	0	0
3104041	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	pre_kindergarten	54	54
3112611	MO	school	2918450	90078	LESTERVILLE R-IV	291845002667	1030	LESTERVILLE RANCH CAMPUS	Regular School	No	Other	KG	12	2019	pre_kindergarten	0	0
3103343	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103355	MO	school	2916740	1091	KIRKSVILLE R-III	291674000916	1050	KIRKSVILLE SR. HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103379	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103391	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103415	MO	school	2927570	2097	SAVANNAH R-III	292757001693	1050	SAVANNAH HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103457	MO	school	2929940	3031	TARKIO R-I	292994002067	1050	TARKIO HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103469	MO	school	2926790	3032	ROCK PORT R-II	292679001613	1050	ROCK PORT HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103481	MO	school	2911760	3033	FAIRFAX R-III	291176000433	1050	FAIRFAX HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103493	MO	school	2910020	4106	COMMUNITY R-VI	291002000319	1050	COMMUNITY HIGH	Regular School	No	High	06	12	2019	pre_kindergarten	0	0
3103505	MO	school	2930780	4109	VAN-FAR R-I	293078002124	1050	VAN-FAR JR./SR. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103517	MO	school	2920810	4110	MEXICO 59	292081001137	1050	MEXICO HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103547	MO	school	2931950	5120	WHEATON R-III	293195002237	1050	WHEATON HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103559	MO	school	2928710	5121	SOUTHWEST R-V	292871001774	1050	SOUTHWEST HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103577	MO	school	2911670	5122	EXETER R-VI	291167000427	1050	EXETER HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103589	MO	school	2908170	5123	CASSVILLE R-IV	290817000219	1050	CASSVILLE HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103613	MO	school	2925620	5124	PURDY R-II	292562001502	1050	PURDY HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103636	MO	school	2921120	5128	MONETT R-I	292112001162	1050	MONETT HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103666	MO	school	2918510	6101	LIBERAL R-II	291851001003	1050	LIBERAL HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103684	MO	school	2912930	6103	GOLDEN CITY R-III	291293000542	1050	GOLDEN CITY HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103702	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103726	MO	school	2920820	7121	MIAMI R-I	292082001139	1050	MIAMI HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103738	MO	school	2904170	7122	BALLARD R-II	290417000042	1050	BALLARD HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103750	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2019	pre_kindergarten	0	0
3103762	MO	school	2926310	7124	RICH HILL R-IV	292631001544	1050	RICH HILL HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103774	MO	school	2915330	7125	HUME R-VIII	291533000699	1050	HUME HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103792	MO	school	2906360	7129	BUTLER R-V	290636000158	1050	BUTLER HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103807	MO	school	2918670	8106	LINCOLN R-II	291867001016	1050	LINCOLN HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103819	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103848	MO	school	2909900	8111	COLE CAMP R-I	290990000293	1050	COLE CAMP HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103871	MO	school	2923640	9077	MEADOW HEIGHTS R-II	292364001406	1050	MEADOW HEIGHTS HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103885	MO	school	2918420	9078	LEOPOLD R-III	291842000989	1050	LEOPOLD HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103897	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3103909	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103927	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001766	1050	SOUTHERN BOONE HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103951	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103975	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3103993	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104017	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104047	MO	school	2901000	10093	COLUMBIA 93	290100000300	1050	DAVID H. HICKMAN HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	24	24
3104234	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000391	1050	EAST BUCHANAN HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104252	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000445	1050	MID-BUCHANAN SR. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104264	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000355	1050	DEKALB JR.-SR. HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104276	MO	school	2927060	11082	ST. JOSEPH	292706001644	1050	BENTON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104410	MO	school	2921750	12108	NEELYVILLE R-IV	292175001200	1050	NEELYVILLE HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104428	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001475	1050	POPLAR BLUFF HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104482	MO	school	2930520	12110	TWIN RIVERS R-X	293052002095	1050	TWIN RIVERS HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104502	MO	school	2905850	13054	BRECKENRIDGE R-I	290585000129	1050	BRECKENRIDGE HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104514	MO	school	2913590	13055	HAMILTON R-II	291359000580	1050	PENNEY HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104544	MO	school	2925410	13059	POLO R-VII	292541001465	1050	POLO HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104568	MO	school	2905820	13061	BRAYMER C-4	290582000127	1050	BRAYMER HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104586	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001254	1050	NORTH CALLAWAY HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104610	MO	school	2921875	14127	NEW BLOOMFIELD R-III	292187501219	1050	NEW BLOOMFIELD HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104622	MO	school	2912550	14129	FULTON 58	291255000524	1050	FULTON SR. HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104652	MO	school	2928430	14130	SOUTH CALLAWAY CO. R-II	292843001757	1050	SOUTH CALLAWAY HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104676	MO	school	2900020	14400	MO SCHOOL FOR THE DEAF	290002003021	1050	WHEELER HIGH	Special Education School	No	High	09	12	2019	pre_kindergarten	0	0
3104694	MO	school	2929580	15001	STOUTLAND R-II	292958002046	1050	STOUTLAND HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104712	MO	school	2906990	15002	CAMDENTON R-III	290699000175	1050	CAMDENTON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104754	MO	school	2909810	15003	CLIMAX SPRINGS R-IV	290981000284	1050	CLIMAX SPRINGS HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104766	MO	school	2919380	15004	MACKS CREEK R-V	291938001049	1050	MACKS CREEK HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104778	MO	school	2915600	16090	JACKSON R-II	291560000738	1050	JACKSON SR. HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104837	MO	school	2910620	16092	DELTA R-V	291062000358	1050	DELTA HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104849	MO	school	2923070	16094	OAK RIDGE R-VI	292307001321	1050	OAK RIDGE HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104861	MO	school	2907120	16096	CAPE GIRARDEAU 63	290712000186	1050	CENTRAL HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104915	MO	school	2913500	17121	HALE R-I	291350000574	1050	HALE HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104927	MO	school	2930300	17122	TINA-AVALON R-II	293030002071	1050	TINA-AVALON HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104939	MO	school	2905610	17124	BOSWORTH R-V	290561000107	1050	BOSWORTH HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3104951	MO	school	2907380	17125	CARROLLTON R-VII	290738000202	1050	CARROLLTON SENIOR HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3104975	MO	school	2922620	17126	NORBORNE R-VIII	292262001238	1050	NORBORNE HIGH	Regular School	No	High	06	12	2019	pre_kindergarten	0	0
3104987	MO	school	2911100	18047	EAST CARTER CO. R-II	291110000383	1050	EAST CARTER CO. R-II HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105005	MO	school	2930750	18050	VAN BUREN R-I	293075002121	1050	VAN BUREN HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3105017	MO	school	2903200	19139	ARCHIE R-V	290320000025	1050	ARCHIE HIGH	Regular School	No	High	06	12	2019	pre_kindergarten	0	0
3105035	MO	school	2923730	19142	RAYMORE-PECULIAR R-II	292373001424	1050	RAYMORE-PECULIAR SR. HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105098	MO	school	2910320	19144	SHERWOOD CASS R-VIII	291032000335	1050	SHERWOOD HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105122	MO	school	2925330	19148	PLEASANT HILL R-III	292533001461	1050	PLEASANT HILL HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105157	MO	school	2913760	19149	HARRISONVILLE R-IX	291376000605	1050	HARRISONVILLE HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105187	MO	school	2911070	19150	DREXEL R-IV	291107000379	1050	DREXEL HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3105199	MO	school	2931800	19151	MIDWAY R-I	293180002224	1050	MIDWAY HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3105211	MO	school	2904620	19152	BELTON 124	290462000055	1050	BELTON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105265	MO	school	2929520	20001	STOCKTON R-I	292952002044	1050	STOCKTON HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105285	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000398	1050	EL DORADO SPRINGS HIGH	Regular School	No	High	09	12	2019	pre_kindergarten	0	0
3105303	MO	school	2922920	21148	NORTHWESTERN R-I	292292001311	1050	NORTHWESTERN HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3105315	MO	school	2906030	21149	BRUNSWICK R-II	290603000145	1050	BRUNSWICK HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0
3105327	MO	school	2916530	21150	KEYTESVILLE R-III	291653000905	1050	KEYTESVILLE HIGH	Regular School	No	High	07	12	2019	pre_kindergarten	0	0