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 (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, 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
3103900	MO	school	2932490	9079	ZALMA R-V	293249002269	4020	ZALMA ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3103917	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten	22	22
3103918	MO	school	2919350	9080	WOODLAND R-IV	291935001045	4040	WOODLAND ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	25	25
3103935	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	1	PK	02	2015	pre_kindergarten	56	56
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
3103941	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	1	03	05	2015	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
3103959	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	1	02	05	2015	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
3103965	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2015	pre_kindergarten	32	32
3103966	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	1	PK	01	2016	pre_kindergarten	30	30
3103983	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2015	pre_kindergarten	32	32
3103984	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	1	PK	04	2016	pre_kindergarten	29	29
3104001	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	1	PK	02	2015	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
3104007	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2015	pre_kindergarten	0	0
3104008	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	1	03	05	2016	pre_kindergarten	0	0
3104025	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	40	40
3104026	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	38	38
3104097	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	13	13
3104098	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104103	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	1	PK	05	2015	pre_kindergarten	50	50
3104104	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	1	PK	05	2016	pre_kindergarten	61	61
3104109	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	77	77
3104110	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	85	85
3104115	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	10	10
3104116	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	13	13
3104121	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	72	72
3104122	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	77	77
3104127	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	37	37
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
3104138	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	32	32
3104139	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	33	33
3104144	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	12	12
3104145	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104150	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	ROBERT E. LEE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	8	8
3104151	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	ROBERT E. LEE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	7	7
3104156	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	0	0
3104157	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	9	9
3104162	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	14	14
3104163	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	16	16
3104168	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	9	9
3104169	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	5	5
3104174	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	59	59
3104175	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	74	74
3104184	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	1	KG	05	2015	pre_kindergarten	0	0
3104185	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	1	KG	05	2016	pre_kindergarten	0	0
3104190	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	39	39
3104191	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	38	38
3104196	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	44	44
3104197	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	49	49
3104202	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	26	26
3104203	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	28	28
3104208	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	55	55
3104209	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	41	41
3104214	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	1	PK	05	2015	pre_kindergarten	10	10
3104215	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	1	PK	05	2016	pre_kindergarten	12	12
3104220	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2015	pre_kindergarten	0	0
3104221	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	CENTER FOR GIFTED EDUCATION	Regular School	No	1	01	05	2016	pre_kindergarten	0	0
3104242	MO	school	2911250	11076	EAST BUCHANAN CO. C-1	291125000390	4040	EAST BUCHANAN ELEM.	Regular School	No	1	PK	05	2015	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
3104254	MO	school	2911940	11078	MID-BUCHANAN CO. R-V	291194000443	4020	MID-BUCHANAN ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	22	22
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
3104266	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000356	4020	RUSHVILLE ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	30	30
3104267	MO	school	2910590	11079	BUCHANAN CO. R-IV	291059000356	4020	RUSHVILLE ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	19	19
3104314	MO	school	2927060	11082	ST. JOSEPH	292706001649	4040	EDISON ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	33	33
3104315	MO	school	2927060	11082	ST. JOSEPH	292706001649	4040	EDISON ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3104320	MO	school	2927060	11082	ST. JOSEPH	292706001650	4060	ELLISON ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	15	15
3104321	MO	school	2927060	11082	ST. JOSEPH	292706001650	4060	ELLISON ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104326	MO	school	2927060	11082	ST. JOSEPH	292706003250	4070	CARDEN PARK ELEM	Regular School	No	1	PK	06	2015	pre_kindergarten	75	75
3104327	MO	school	2927060	11082	ST. JOSEPH	292706003250	4070	CARDEN PARK ELEM	Regular School	No	1	PK	06	2016	pre_kindergarten	80	80
3104332	MO	school	2927060	11082	ST. JOSEPH	292706003255	4080	OAK GROVE ELEM	Regular School	No	1	PK	06	2015	pre_kindergarten	47	47
3104333	MO	school	2927060	11082	ST. JOSEPH	292706003255	4080	OAK GROVE ELEM	Regular School	No	1	PK	06	2016	pre_kindergarten	48	48
3104338	MO	school	2927060	11082	ST. JOSEPH	292706001652	4100	FIELD ELEM.	Regular School	No	1	KG	06	2015	pre_kindergarten	0	0
3104339	MO	school	2927060	11082	ST. JOSEPH	292706001652	4100	FIELD ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104344	MO	school	2927060	11082	ST. JOSEPH	292706001654	4140	COLEMAN ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	93	93
3104345	MO	school	2927060	11082	ST. JOSEPH	292706001654	4140	COLEMAN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	34	34
3104350	MO	school	2927060	11082	ST. JOSEPH	292706001657	4180	HOSEA ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	36	36
3104351	MO	school	2927060	11082	ST. JOSEPH	292706001657	4180	HOSEA ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3104356	MO	school	2927060	11082	ST. JOSEPH	292706001658	4200	HUMBOLDT ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	35	35
3104357	MO	school	2927060	11082	ST. JOSEPH	292706001658	4200	HUMBOLDT ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	36	36
3104360	MO	school	2927060	11082	ST. JOSEPH	292706001659	4220	HYDE ELEM.	Regular School	No	1	KG	06	2015	pre_kindergarten	0	0
3104361	MO	school	2927060	11082	ST. JOSEPH	292706001659	4220	HYDE ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104366	MO	school	2927060	11082	ST. JOSEPH	292706001661	4240	LAKE ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	36	36
3104367	MO	school	2927060	11082	ST. JOSEPH	292706001661	4240	LAKE ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	34	34
3104370	MO	school	2927060	11082	ST. JOSEPH	292706001662	4260	LINDBERGH ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	0	0
3104371	MO	school	2927060	11082	ST. JOSEPH	292706001662	4260	LINDBERGH ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	0	0
3104376	MO	school	2927060	11082	ST. JOSEPH	292706001663	4280	MARK TWAIN ELEM.	Regular School	No	1	KG	06	2015	pre_kindergarten	0	0
3104377	MO	school	2927060	11082	ST. JOSEPH	292706001663	4280	MARK TWAIN ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	21	21
3104382	MO	school	2927060	11082	ST. JOSEPH	292706001667	4390	PARKWAY ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	32	32
3104383	MO	school	2927060	11082	ST. JOSEPH	292706001667	4390	PARKWAY ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104388	MO	school	2927060	11082	ST. JOSEPH	292706001668	4400	PERSHING ELEM.	Regular School	No	1	KG	06	2015	pre_kindergarten	0	0
3104389	MO	school	2927060	11082	ST. JOSEPH	292706001668	4400	PERSHING ELEM.	Regular School	No	1	KG	06	2016	pre_kindergarten	0	0
3104394	MO	school	2927060	11082	ST. JOSEPH	292706001669	4420	PICKETT ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	0	0
3104395	MO	school	2927060	11082	ST. JOSEPH	292706001669	4420	PICKETT ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	85	85
3104400	MO	school	2927060	11082	ST. JOSEPH	292706001672	4460	SKAITH ELEM.	Regular School	No	1	PK	06	2015	pre_kindergarten	0	0
3104401	MO	school	2927060	11082	ST. JOSEPH	292706001672	4460	SKAITH ELEM.	Regular School	No	1	PK	06	2016	pre_kindergarten	0	0
3104412	MO	school	2921750	12108	NEELYVILLE R-IV	292175001201	4040	HILLVIEW ELEM.	Regular School	No	1	PK	02	2015	pre_kindergarten	25	25
3104413	MO	school	2921750	12108	NEELYVILLE R-IV	292175001201	4040	HILLVIEW ELEM.	Regular School	No	1	PK	02	2016	pre_kindergarten	33	33
3104418	MO	school	2921750	12108	NEELYVILLE R-IV	292175001202	4060	NEELYVILLE ELEM.	Regular School	No	1	03	06	2015	pre_kindergarten	0	0