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 and (ccd_charter_school > :p3 or (ccd_charter_school = :p3 and rowid > :p2)) order by ccd_charter_school, 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
3103747	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	4	06	12	2016	pre_kindergarten	0	0
3103753	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	42	42
3103759	MO	school	2926310	7124	RICH HILL R-IV	292631001544	1050	RICH HILL HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103765	MO	school	2926310	7124	RICH HILL R-IV	292631001545	4020	RICH HILL ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	12	12
3103771	MO	school	2915330	7125	HUME R-VIII	291533000699	1050	HUME HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103777	MO	school	2915330	7125	HUME R-VIII	291533000698	4020	HUME ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	5	5
3103783	MO	school	2915240	7126	HUDSON R-IX	291524000693	4020	HUDSON ELEM.	Regular School	No	1	PK	08	2016	pre_kindergarten	12	12
3103789	MO	school	2906360	7129	BUTLER R-V	290636000158	1050	BUTLER HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103795	MO	school	2906360	7129	BUTLER R-V	290636000157	4020	BUTLER ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	113	113
3103804	MO	school	2918670	8106	LINCOLN R-II	291867001016	1050	LINCOLN HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103810	MO	school	2918670	8106	LINCOLN R-II	291867001015	4020	LINCOLN ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3103816	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103822	MO	school	2931070	8107	WARSAW R-IX	293107002650	3000	JOHN BOISE MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103828	MO	school	2931070	8107	WARSAW R-IX	293107002153	4020	NORTH ELEM.	Regular School	No	1	03	05	2016	pre_kindergarten	58	58
3103834	MO	school	2931070	8107	WARSAW R-IX	293107002154	4040	SOUTH ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	14	14
3103840	MO	school	2931070	8107	WARSAW R-IX	293107000834	4060	RUTH MERCER ELEM.	Regular School	No	1	KG	02	2016	pre_kindergarten	0	0
3103845	MO	school	2909900	8111	COLE CAMP R-I	290990000293	1050	COLE CAMP HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103851	MO	school	2909900	8111	COLE CAMP R-I	290990001389	3000	COLE CAMP MIDDLE	Regular School	No	2	05	08	2016	pre_kindergarten	0	0
3103857	MO	school	2909900	8111	COLE CAMP R-I	290990000292	4020	COLE CAMP ELEM.	Regular School	No	1	KG	04	2016	pre_kindergarten	0	0
3103862	MO	school	2909900	8111	COLE CAMP R-I	290990003248	7500	COLE CAMP PRESCHOOL	Regular School	No	1	PK	PK	2016	pre_kindergarten	20	20
3103868	MO	school	2923640	9077	MEADOW HEIGHTS R-II	292364001406	1050	MEADOW HEIGHTS HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103876	MO	school	2923640	9077	MEADOW HEIGHTS R-II	292364001407	4020	MEADOW HEIGHTS ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	28	28
3103882	MO	school	2918420	9078	LEOPOLD R-III	291842000989	1050	LEOPOLD HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103888	MO	school	2918420	9078	LEOPOLD R-III	291842000988	4020	LEOPOLD ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3103894	MO	school	2932490	9079	ZALMA R-V	293249002270	1050	ZALMA HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3103900	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3103906	MO	school	2919350	9080	WOODLAND R-IV	291935001046	1050	WOODLAND HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103912	MO	school	2919350	9080	WOODLAND R-IV	291935002985	3000	WOODLAND MIDDLE	Regular School	No	2	05	08	2016	pre_kindergarten	0	0
3103918	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	25	25
3103924	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001766	1050	SOUTHERN BOONE HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103930	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001596	3000	SOUTHERN BOONE MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103936	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	1	PK	02	2016	pre_kindergarten	0	0
3103942	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3103948	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103954	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3103960	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2016	pre_kindergarten	0	0
3103966	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2016	pre_kindergarten	30	30
3103972	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103978	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	2	05	08	2016	pre_kindergarten	0	0
3103984	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	29	29
3103990	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3103996	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104002	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2016	pre_kindergarten	5	5
3104008	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3104014	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104020	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104026	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	38	38
3104032	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	01	12	2016	pre_kindergarten	0	0
3104038	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative Education School	No	4	PK	12	2016	pre_kindergarten	58	58
3104044	MO	school	2901000	10093	COLUMBIA 93	290100000300	1050	DAVID H. HICKMAN HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	26	26
3104050	MO	school	2901000	10093	COLUMBIA 93	290100003239	1060	MURIEL W. BATTLE HIGH SCHOOL	Regular School	No	3	09	12	2016	pre_kindergarten	15	15
3104056	MO	school	2901000	10093	COLUMBIA 93	290100000299	1075	ROCK BRIDGE SR. HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	23	23
3104062	MO	school	2901000	10093	COLUMBIA 93	290100000304	2050	JEFFERSON MIDDLE SCHOOL	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104068	MO	school	2901000	10093	COLUMBIA 93	290100001402	2060	OAKLAND MIDDLE SCHOOL	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104074	MO	school	2901000	10093	COLUMBIA 93	290100000317	2075	WEST MIDDLE SCHOOL	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104080	MO	school	2901000	10093	COLUMBIA 93	290100000841	3000	ANN HAWKINS GENTRY MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104086	MO	school	2901000	10093	COLUMBIA 93	290100001408	3040	SMITHTON MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104092	MO	school	2901000	10093	COLUMBIA 93	290100001946	3060	JOHN B. LANGE MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104098	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104104	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	1	PK	05	2016	pre_kindergarten	61	61
3104110	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	85	85
3104116	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	13	13
3104122	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	77	77
3104128	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	41	41
3104133	MO	school	2901000	10093	COLUMBIA 93	290100003271	4070	ELIOT BATTLE ELEMENTARY	Regular School	No	1	PK	05	2016	pre_kindergarten	7	7
3104139	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	33	33
3104145	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104151	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	ROBERT E. LEE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	7	7
3104157	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	9	9
3104163	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104169	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	5	5
3104175	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	74	74
3104185	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3104191	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	38	38
3104197	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	49	49
3104203	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	28	28
3104209	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	41	41
3104215	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	12	12
3104221	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2016	pre_kindergarten	0	0
3104231	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000391	1050	EAST BUCHANAN HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104237	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125002282	3000	EAST BUCHANAN MIDDLE	Regular School	No	2	06	08	2016	pre_kindergarten	0	0
3104243	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000390	4040	EAST BUCHANAN ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	0	0
3104249	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000445	1050	MID-BUCHANAN SR. HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3104255	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000443	4020	MID-BUCHANAN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	22	22
3104261	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000355	1050	DEKALB JR.-SR. HIGH	Regular School	No	3	07	12	2016	pre_kindergarten	0	0
3104267	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000356	4020	RUSHVILLE ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	19	19
3104273	MO	school	2927060	11082	ST. JOSEPH	292706001644	1050	BENTON HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104279	MO	school	2927060	11082	ST. JOSEPH	292706001648	1075	CENTRAL HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104285	MO	school	2927060	11082	ST. JOSEPH	292706001660	1080	LAFAYETTE HIGH	Regular School	No	3	09	12	2016	pre_kindergarten	0	0
3104291	MO	school	2927060	11082	ST. JOSEPH	292706001670	3000	ROBIDOUX MIDDLE	Regular School	No	2	07	08	2016	pre_kindergarten	0	0
3104297	MO	school	2927060	11082	ST. JOSEPH	292706001646	3010	BODE MIDDLE	Regular School	No	2	07	08	2016	pre_kindergarten	0	0
3104303	MO	school	2927060	11082	ST. JOSEPH	292706001673	3020	SPRING GARDEN MIDDLE	Regular School	No	2	07	08	2016	pre_kindergarten	0	0
3104309	MO	school	2927060	11082	ST. JOSEPH	292706001674	3050	TRUMAN MIDDLE	Regular School	No	2	07	08	2016	pre_kindergarten	0	0
3104315	MO	school	2927060	11082	ST. JOSEPH	292706001649	4040	EDISON ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3104321	MO	school	2927060	11082	ST. JOSEPH	292706001650	4060	ELLISON ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104327	MO	school	2927060	11082	ST. JOSEPH	292706003250	4070	CARDEN PARK ELEM	Regular School	No	1	PK	06	2016	pre_kindergarten	80	80
3104333	MO	school	2927060	11082	ST. JOSEPH	292706003255	4080	OAK GROVE ELEM	Regular School	No	1	PK	06	2016	pre_kindergarten	48	48
3104339	MO	school	2927060	11082	ST. JOSEPH	292706001652	4100	FIELD ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104345	MO	school	2927060	11082	ST. JOSEPH	292706001654	4140	COLEMAN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	34	34
3104351	MO	school	2927060	11082	ST. JOSEPH	292706001657	4180	HOSEA ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3104357	MO	school	2927060	11082	ST. JOSEPH	292706001658	4200	HUMBOLDT ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36