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 district_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
3322168	MO	school	2915450	100059	SCOTT CITY R-I	291545000705	1050	SCOTT CITY HIGH	Regular School	No	High	09	12	2019	pk_12_total	253	253
3322174	MO	school	2915450	100059	SCOTT CITY R-I	291545002702	3000	SCOTT CITY MIDDLE	Regular School	No	Middle	05	08	2019	pk_12_total	258	258
3322180	MO	school	2915450	100059	SCOTT CITY R-I	291545000704	4020	SCOTT CITY ELEM.	Regular School	No	Elementary	PK	04	2019	pk_12_total	324	324
3322186	MO	school	2908460	100060	CHAFFEE R-II	290846000248	1050	CHAFFEE JR.-SR. HIGH	Regular School	No	High	07	12	2019	pk_12_total	311	311
3322192	MO	school	2908460	100060	CHAFFEE R-II	290846000247	4020	CHAFFEE ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	369	369
3322198	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	High	09	12	2019	pk_12_total	303	303
3322204	MO	school	2904890	100061	SCOTT CO. R-IV	290489002703	3000	SCOTT CO. MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	236	236
3322210	MO	school	2904890	100061	SCOTT CO. R-IV	290489000058	4020	SCOTT CO. ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	415	415
3322217	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001177	1050	SCOTT CO. CENTRAL HIGH	Regular School	No	High	07	12	2019	pk_12_total	135	135
3322223	MO	school	2921420	100062	SCOTT CO. CENTRAL	292142001176	4020	SCOTT CO. CENTRAL ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	149	149
3322229	MO	school	2928260	100063	SIKESTON R-6	292826001744	1050	SIKESTON SR. HIGH	Regular School	No	High	09	12	2019	pk_12_total	951	951
3322235	MO	school	2928260	100063	SIKESTON R-6	292826001737	2050	7TH AND 8TH GRADE CTR.	Regular School	No	Middle	07	08	2019	pk_12_total	514	514
3322241	MO	school	2928260	100063	SIKESTON R-6	292826001741	3050	5TH AND 6TH GRADE CTR.	Regular School	No	Middle	05	06	2019	pk_12_total	539	539
3322247	MO	school	2928260	100063	SIKESTON R-6	292826001738	4020	SIKESTON KINDERGARTEN CTR.	Regular School	No	Elementary	PK	KG	2019	pk_12_total	399	399
3322253	MO	school	2928260	100063	SIKESTON R-6	292826001739	4040	LEE HUNTER ELEM.	Regular School	No	Elementary	01	04	2019	pk_12_total	410	410
3322259	MO	school	2928260	100063	SIKESTON R-6	292826001566	4050	MATTHEWS ELEM.	Regular School	No	Elementary	01	04	2019	pk_12_total	326	326
3322265	MO	school	2928260	100063	SIKESTON R-6	292826001742	4070	SOUTHEAST ELEM.	Regular School	No	Elementary	01	04	2019	pk_12_total	320	320
3322271	MO	school	2916470	100064	KELSO C-7	291647000895	4020	KELSO ELEM.	Regular School	No	Elementary	PK	08	2019	pk_12_total	150	150
3322277	MO	school	2923130	100065	ORAN R-III	292313001327	1050	ORAN HIGH SCHOOL	Regular School	No	High	07	12	2019	pk_12_total	176	176
3322283	MO	school	2923130	100065	ORAN R-III	292313001326	4020	ORAN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2019	pk_12_total	165	165
3311077	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001766	1050	SOUTHERN BOONE HIGH	Regular School	No	High	09	12	2019	pk_12_total	482	482
3311083	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001596	3000	SOUTHERN BOONE MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	394	394
3311089	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856002802	4010	SOUTHERN BOONE PRIMARY	Regular School	No	Elementary	PK	02	2019	pk_12_total	462	462
3311095	MO	school	2928560	10087	SOUTHERN BOONE CO. R-I	292856001765	4020	SOUTHERN BOONE ELEM.	Regular School	No	Elementary	03	05	2019	pk_12_total	404	404
3311101	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2019	pk_12_total	389	389
3311107	MO	school	2913560	10089	HALLSVILLE R-IV	291356001597	3000	HALLSVILLE MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	337	337
3311113	MO	school	2913560	10089	HALLSVILLE R-IV	291356000577	4020	HALLSVILLE INTERMEDIATE	Regular School	No	Elementary	02	05	2019	pk_12_total	449	449
3311119	MO	school	2913560	10089	HALLSVILLE R-IV	291356002975	4040	HALLSVILLE PRIMARY	Regular School	No	Elementary	PK	01	2019	pk_12_total	251	251
3311125	MO	school	2929700	10090	STURGEON R-V	292970002053	1050	STURGEON HIGH	Regular School	No	High	09	12	2019	pk_12_total	132	132
3311131	MO	school	2929700	10090	STURGEON R-V	292970001392	3000	STURGEON MIDDLE	Regular School	No	Middle	05	08	2019	pk_12_total	126	126
3311137	MO	school	2929700	10090	STURGEON R-V	292970002052	4020	STURGEON ELEM.	Regular School	No	Elementary	PK	04	2019	pk_12_total	175	175
3311143	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2019	pk_12_total	451	451
3311149	MO	school	2908400	10091	CENTRALIA R-VI	290840000243	3000	CHESTER BOREN MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	320	320
3311155	MO	school	2908400	10091	CENTRALIA R-VI	290840000242	4020	CHANCE ELEM.	Regular School	No	Elementary	PK	02	2019	pk_12_total	312	312
3311161	MO	school	2908400	10091	CENTRALIA R-VI	290840003092	4050	CENTRALIA INTERMEDIATE	Regular School	No	Elementary	03	05	2019	pk_12_total	289	289
3311167	MO	school	2913710	10092	HARRISBURG R-VIII	291371000599	1050	HARRISBURG HIGH	Regular School	No	High	09	12	2019	pk_12_total	155	155
3311173	MO	school	2913710	10092	HARRISBURG R-VIII	291371003100	3000	HARRISBURG MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	152	152
3311179	MO	school	2913710	10092	HARRISBURG R-VIII	291371000598	4020	HARRISBURG ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	307	307
3311185	MO	school	2901000	10093	COLUMBIA 93	290100002577	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	01	12	2019	pk_12_total	14	14
3311191	MO	school	2901000	10093	COLUMBIA 93	290100002281	1020	FREDERICK DOUGLASS HIGH	Alternative School	No	Other	PK	12	2019	pk_12_total	184	184
3311197	MO	school	2901000	10093	COLUMBIA 93	290100000300	1050	DAVID H. HICKMAN HIGH	Regular School	No	High	09	12	2019	pk_12_total	1731	1731
3311203	MO	school	2901000	10093	COLUMBIA 93	290100003239	1060	MURIEL W. BATTLE HIGH SCHOOL	Regular School	No	High	09	12	2019	pk_12_total	1483	1483
3311209	MO	school	2901000	10093	COLUMBIA 93	290100000299	1075	ROCK BRIDGE SR. HIGH	Regular School	No	High	09	12	2019	pk_12_total	1999	1999
3311215	MO	school	2901000	10093	COLUMBIA 93	290100000304	2050	JEFFERSON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	pk_12_total	670	670
3311221	MO	school	2901000	10093	COLUMBIA 93	290100001402	2060	OAKLAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	pk_12_total	542	542
3311227	MO	school	2901000	10093	COLUMBIA 93	290100000317	2075	WEST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	pk_12_total	637	637
3311233	MO	school	2901000	10093	COLUMBIA 93	290100000841	3000	ANN HAWKINS GENTRY MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	927	927
3311239	MO	school	2901000	10093	COLUMBIA 93	290100001408	3040	SMITHTON MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	719	719
3311245	MO	school	2901000	10093	COLUMBIA 93	290100001946	3060	JOHN B. LANGE MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	640	640
3311251	MO	school	2901000	10093	COLUMBIA 93	290100000313	4020	THOMAS BENTON ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	244	244
3311257	MO	school	2901000	10093	COLUMBIA 93	290100003152	4030	ALPHA HART LEWIS	Regular School	No	Elementary	PK	05	2019	pk_12_total	433	433
3311263	MO	school	2901000	10093	COLUMBIA 93	290100000298	4040	BLUE RIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	441	441
3311269	MO	school	2901000	10093	COLUMBIA 93	290100002279	4050	CEDAR RIDGE ELEM.	Regular School	No	Elementary	KG	05	2019	pk_12_total	398	398
3311275	MO	school	2901000	10093	COLUMBIA 93	290100002665	4055	DERBY RIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	425	425
3311281	MO	school	2901000	10093	COLUMBIA 93	290100000303	4060	FAIRVIEW ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	514	514
3311286	MO	school	2901000	10093	COLUMBIA 93	290100003271	4070	ELIOT BATTLE ELEMENTARY	Regular School	No	Elementary	KG	05	2019	pk_12_total	450	450
3311292	MO	school	2901000	10093	COLUMBIA 93	290100000315	5000	ULYSSES S. GRANT ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	314	314
3311298	MO	school	2901000	10093	COLUMBIA 93	290100002770	5010	MARY PAXTON KEELEY ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	699	699
3311304	MO	school	2901000	10093	COLUMBIA 93	290100000308	5020	Locust St Expressive Arts Elem	Regular School	No	Elementary	PK	05	2019	pk_12_total	254	254
3311310	MO	school	2901000	10093	COLUMBIA 93	290100001142	5025	MIDWAY HEIGHTS ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	212	212
3311316	MO	school	2901000	10093	COLUMBIA 93	290100002546	5030	MILL CREEK ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	660	660
3311322	MO	school	2901000	10093	COLUMBIA 93	290100002280	5035	NEW HAVEN ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	247	247
3311328	MO	school	2901000	10093	COLUMBIA 93	290100000307	5040	PARKADE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	462	462
3311332	MO	school	2901000	10093	COLUMBIA 93	290100003292	5050	BEULAH RALPH ELEMENTARY	Regular School	No	Elementary	KG	05	2019	pk_12_total	657	657
3311338	MO	school	2901000	10093	COLUMBIA 93	290100000305	5060	JOHN RIDGEWAY ELEM.	Regular School	No	Elementary	KG	05	2019	pk_12_total	234	234
3311344	MO	school	2901000	10093	COLUMBIA 93	290100000309	5080	ROCK BRIDGE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	506	506
3311350	MO	school	2901000	10093	COLUMBIA 93	290100000310	6000	RUSSELL BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	421	421
3311356	MO	school	2901000	10093	COLUMBIA 93	290100000312	6010	SHEPARD BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	493	493
3311362	MO	school	2901000	10093	COLUMBIA 93	290100000316	6020	WEST BLVD. ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	358	358
3311368	MO	school	2901000	10093	COLUMBIA 93	290100000314	6040	TWO MILE PRAIRIE ELEM.	Regular School	No	Elementary	KG	05	2019	pk_12_total	175	175
3311374	MO	school	2901000	10093	COLUMBIA 93	290100001598	6080	Center for Gifted Education	Regular School	No	Elementary	01	05	2019	pk_12_total	48	48
3311378	MO	school	2901000	10093	COLUMBIA 93	290100003287	7500	CENTER FOR EARLY LRNING-NORTH	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	364	364
3322289	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	High	09	12	2019	pk_12_total	118	118
3322295	MO	school	2932220	101105	WINONA R-III	293222002259	4020	WINONA ELEM.	Regular School	No	Elementary	PK	08	2019	pk_12_total	321	321
3322301	MO	school	2911450	101107	EMINENCE R-I	291145000409	1050	EMINENCE HIGH	Regular School	No	High	07	12	2019	pk_12_total	139	139
3322307	MO	school	2911450	101107	EMINENCE R-I	291145000408	4020	EMINENCE ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	148	148
3322313	MO	school	2928140	102081	NORTH SHELBY	292814001731	1050	NORTH SHELBY HIGH	Regular School	No	High	07	12	2019	pk_12_total	125	125
3322319	MO	school	2928140	102081	NORTH SHELBY	292814001732	4060	NORTH SHELBY ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	170	170
3322325	MO	school	2928110	102085	SHELBY CO. R-IV	292811001728	1050	SOUTH SHELBY HIGH	Regular School	No	High	09	12	2019	pk_12_total	215	215
3322331	MO	school	2928110	102085	SHELBY CO. R-IV	292811003130	3000	SOUTH SHELBY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2019	pk_12_total	200	200
3322337	MO	school	2928110	102085	SHELBY CO. R-IV	292811001724	4020	CLARENCE ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	95	95
3322343	MO	school	2928110	102085	SHELBY CO. R-IV	292811001726	4040	SHELBINA ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	225	225
3322349	MO	school	2926400	103127	RICHLAND R-I	292640001548	1050	RICHLAND HIGH	Regular School	No	High	07	12	2019	pk_12_total	132	132
3322355	MO	school	2926400	103127	RICHLAND R-I	292640002443	4040	RICHLAND ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	170	170
3322361	MO	school	2904530	103128	BELL CITY R-II	290453000047	1050	BELL CITY HIGH	Regular School	No	High	07	12	2019	pk_12_total	111	111
3322367	MO	school	2904530	103128	BELL CITY R-II	290453000046	4020	BELL CITY ELEM.	Regular School	No	Elementary	KG	06	2019	pk_12_total	115	115
3322373	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2019	pk_12_total	205	205
3322379	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	226	226
3322381	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2019	pk_12_total	31	31
3322387	MO	school	2925650	103130	PUXICO R-VIII	292565001508	1050	PUXICO HIGH	Regular School	No	High	09	12	2019	pk_12_total	227	227
3322393	MO	school	2925650	103130	PUXICO R-VIII	292565002704	1080	MINGO PUXICO TECHNICAL HIGH	Career and Technical School	No	High	12	12	2019	pk_12_total	64	64
3322399	MO	school	2925650	103130	PUXICO R-VIII	292565002871	2050	PUXICO JR. HIGH	Regular School	No	Middle	06	08	2019	pk_12_total	169	169
3322405	MO	school	2925650	103130	PUXICO R-VIII	292565001507	4020	PUXICO ELEM.	Regular School	No	Elementary	PK	05	2019	pk_12_total	376	376
3322411	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2019	pk_12_total	7	7
3322417	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525000073	1050	BLOOMFIELD HIGH	Regular School	No	High	09	12	2019	pk_12_total	202	202
3322423	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525003104	3000	BLOOMFIELD MIDDLE	Regular School	No	Middle	05	08	2019	pk_12_total	196	196
3322429	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525000072	4020	BLOOMFIELD ELEM.	Regular School	No	Elementary	PK	04	2019	pk_12_total	266	266
3322435	MO	school	2910770	103132	DEXTER R-XI	291077000363	1050	DEXTER HIGH	Regular School	No	High	09	12	2019	pk_12_total	572	572
3322441	MO	school	2910770	103132	DEXTER R-XI	291077000362	3000	T. S. HILL MIDDLE	Regular School	No	Middle	06	08	2019	pk_12_total	501	501
3322447	MO	school	2910770	103132	DEXTER R-XI	291077000361	4020	CENTRAL ELEM.	Regular School	No	Elementary	03	05	2019	pk_12_total	454	454
3322453	MO	school	2910770	103132	DEXTER R-XI	291077000364	4040	SOUTHWEST ELEM.	Regular School	No	Elementary	PK	02	2019	pk_12_total	559	559