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 and rowid > :p3 order by rowid 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
3283469	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
3283475	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2019	grade_12	0	0
3283481	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2019	grade_12	79	79
3283487	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283493	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2019	grade_12	0	0
3283499	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2019	grade_12	0	0
3283505	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2019	grade_12	41	41
3283511	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2019	grade_12	0	0
3283517	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
3283523	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2019	grade_12	103	103
3283529	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283535	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
3283541	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2019	grade_12	0	0
3283547	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2019	grade_12	41	41
3283553	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283559	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283565	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	grade_12	0	0
3283571	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	grade_12	45	45
3283577	MO	school	2901000	10093	COLUMBIA 93	290100000300	1050	DAVID H. HICKMAN HIGH	Regular School	No	High	09	12	2019	grade_12	365	365
3283583	MO	school	2901000	10093	COLUMBIA 93	290100003239	1060	MURIEL W. BATTLE HIGH SCHOOL	Regular School	No	High	09	12	2019	grade_12	332	332
3283589	MO	school	2901000	10093	COLUMBIA 93	290100000299	1075	ROCK BRIDGE SR. HIGH	Regular School	No	High	09	12	2019	grade_12	468	468
3283595	MO	school	2901000	10093	COLUMBIA 93	290100000304	2050	JEFFERSON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283601	MO	school	2901000	10093	COLUMBIA 93	290100001402	2060	OAKLAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283607	MO	school	2901000	10093	COLUMBIA 93	290100000317	2075	WEST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283613	MO	school	2901000	10093	COLUMBIA 93	290100000841	3000	ANN HAWKINS GENTRY MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283619	MO	school	2901000	10093	COLUMBIA 93	290100001408	3040	SMITHTON MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283625	MO	school	2901000	10093	COLUMBIA 93	290100001946	3060	JOHN B. LANGE MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283631	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283637	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283643	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283649	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283655	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283661	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283666	MO	school	2901000	10093	COLUMBIA 93	290100003271	4070	ELIOT BATTLE ELEMENTARY	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283672	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283678	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283684	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	Locust St Expressive Arts Elem	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283690	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283696	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283702	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283708	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283712	MO	school	2901000	10093	COLUMBIA 93	290100003292	5050	BEULAH RALPH ELEMENTARY	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283718	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283724	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283730	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283736	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283742	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283748	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283754	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2019	grade_12	0	0
3283758	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2019	grade_12	0	0
3283764	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000391	1050	EAST BUCHANAN HIGH	Regular School	No	High	09	12	2019	grade_12	57	57
3283770	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125002282	3000	EAST BUCHANAN MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283776	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000390	4040	EAST BUCHANAN ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3283782	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000445	1050	MID-BUCHANAN SR. HIGH	Regular School	No	High	07	12	2019	grade_12	62	62
3283788	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000443	4020	MID-BUCHANAN ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283794	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000355	1050	DEKALB JR.-SR. HIGH	Regular School	No	High	07	12	2019	grade_12	24	24
3283800	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000356	4020	RUSHVILLE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283806	MO	school	2927060	11082	ST. JOSEPH	292706001644	1050	BENTON HIGH	Regular School	No	High	09	12	2019	grade_12	160	160
3283812	MO	school	2927060	11082	ST. JOSEPH	292706001648	1075	CENTRAL HIGH	Regular School	No	High	09	12	2019	grade_12	366	366
3283818	MO	school	2927060	11082	ST. JOSEPH	292706001660	1080	LAFAYETTE HIGH	Regular School	No	High	09	12	2019	grade_12	150	150
3283824	MO	school	2927060	11082	ST. JOSEPH	292706001670	3000	ROBIDOUX MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283830	MO	school	2927060	11082	ST. JOSEPH	292706001646	3010	BODE MIDDLE	Regular School	No	Middle	07	08	2019	grade_12	0	0
3283836	MO	school	2927060	11082	ST. JOSEPH	292706001673	3020	SPRING GARDEN MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3283842	MO	school	2927060	11082	ST. JOSEPH	292706001674	3050	TRUMAN MIDDLE	Regular School	No	Middle	07	08	2019	grade_12	0	0
3283848	MO	school	2927060	11082	ST. JOSEPH	292706001649	4040	EDISON ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283854	MO	school	2927060	11082	ST. JOSEPH	292706001650	4060	ELLISON ELEM.	Regular School	No	Elementary	KG	06	2019	grade_12	0	0
3283860	MO	school	2927060	11082	ST. JOSEPH	292706003250	4070	CARDEN PARK ELEM	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283866	MO	school	2927060	11082	ST. JOSEPH	292706003255	4080	OAK GROVE ELEM	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283872	MO	school	2927060	11082	ST. JOSEPH	292706001652	4100	FIELD ELEM.	Regular School	No	Elementary	KG	06	2019	grade_12	0	0
3283878	MO	school	2927060	11082	ST. JOSEPH	292706001654	4140	COLEMAN ELEM.	Regular School	No	Elementary	KG	06	2019	grade_12	0	0
3283884	MO	school	2927060	11082	ST. JOSEPH	292706001657	4180	HOSEA ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283894	MO	school	2927060	11082	ST. JOSEPH	292706001659	4220	HYDE ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283904	MO	school	2927060	11082	ST. JOSEPH	292706001662	4260	LINDBERGH ELEM.	Regular School	No	Elementary	KG	05	2019	grade_12	0	0
3283910	MO	school	2927060	11082	ST. JOSEPH	292706001663	4280	MARK TWAIN ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283916	MO	school	2927060	11082	ST. JOSEPH	292706001667	4390	PARKWAY ELEM.	Regular School	No	Elementary	KG	06	2019	grade_12	0	0
3283922	MO	school	2927060	11082	ST. JOSEPH	292706001668	4400	PERSHING ELEM.	Regular School	No	Elementary	KG	06	2019	grade_12	0	0
3283928	MO	school	2927060	11082	ST. JOSEPH	292706001669	4420	PICKETT ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283934	MO	school	2927060	11082	ST. JOSEPH	292706001672	4460	SKAITH ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3283940	MO	school	2921750	12108	NEELYVILLE R-IV	292175001200	1050	NEELYVILLE HIGH	Regular School	No	High	07	12	2019	grade_12	33	33
3283946	MO	school	2921750	12108	NEELYVILLE R-IV	292175001201	4040	HILLVIEW ELEM.	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
3283952	MO	school	2921750	12108	NEELYVILLE R-IV	292175001202	4060	NEELYVILLE ELEM.	Regular School	No	Elementary	03	06	2019	grade_12	0	0
3283958	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001475	1050	POPLAR BLUFF HIGH	Regular School	No	High	09	12	2019	grade_12	294	294
3283964	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001469	2050	POPLAR BLUFF JR. HIGH	Regular School	No	Middle	07	08	2019	grade_12	0	0
3283970	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001467	4020	EUGENE FIELD ELEM.	Regular School	No	Elementary	01	03	2019	grade_12	0	0
3283976	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001947	4040	POPLAR BLUFF MIDDLE SCHOOL	Regular School	No	Middle	04	06	2019	grade_12	0	0
3283982	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001471	4080	LAKE ROAD ELEM.	Regular School	No	Elementary	01	04	2019	grade_12	0	0
3283988	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001472	5020	POPLAR BLUFF KINDERGARTEN CTR.	Regular School	No	Elementary	KG	KG	2019	grade_12	0	0
3283994	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001474	5040	OAK GROVE ELEM.	Regular School	No	Elementary	01	03	2019	grade_12	0	0
3284000	MO	school	2925450	12109	POPLAR BLUFF R-I	292545001473	5060	O'NEAL ELEM.	Regular School	No	Elementary	01	03	2019	grade_12	0	0
3284006	MO	school	2925450	12109	POPLAR BLUFF R-I	292545002769	7500	POPLAR BLUFF EARLY CHILDHOOD C	Regular School	No	Prekindergarten	PK	PK	2019	grade_12	0	0
3284012	MO	school	2930520	12110	TWIN RIVERS R-X	293052002095	1050	TWIN RIVERS HIGH	Regular School	No	High	09	12	2019	grade_12	57	57
3284014	MO	school	2930520	12110	TWIN RIVERS R-X	293052003337	3000	QULIN MIDDLE	Regular School	No	Middle	05	08	2019	grade_12	0	0
3284020	MO	school	2930520	12110	TWIN RIVERS R-X	293052002093	4040	FISK ELEMENTARY	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
3284026	MO	school	2930520	12110	TWIN RIVERS R-X	293052002094	4060	QULIN ELEMENTARY	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
3284032	MO	school	2905850	13054	BRECKENRIDGE R-I	290585000129	1050	BRECKENRIDGE HIGH	Regular School	No	High	07	12	2019	grade_12	0	0
3284038	MO	school	2905850	13054	BRECKENRIDGE R-I	290585000128	4020	BRECKENRIDGE ELEM.	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
3284044	MO	school	2913590	13055	HAMILTON R-II	291359000580	1050	PENNEY HIGH	Regular School	No	High	09	12	2019	grade_12	47	47
3284050	MO	school	2913590	13055	HAMILTON R-II	291359002663	3000	HAMILTON MIDDLE	Regular School	No	Middle	06	08	2019	grade_12	0	0
3284056	MO	school	2913590	13055	HAMILTON R-II	291359000579	4020	HAMILTON ELEM.	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
3284062	MO	school	2922110	13057	NEW YORK R-IV	292211001227	4020	NEW YORK ELEM.	Regular School	No	Elementary	KG	08	2019	grade_12	0	0
3284068	MO	school	2910230	13058	COWGILL R-VI	291023000329	4020	COWGILL ELEM.	Regular School	No	Elementary	PK	08	2019	grade_12	0	0