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 total 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
3311855	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2018	pk_12_total	0	0
3312301	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2018	pk_12_total	0	0
3322410	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2018	pk_12_total	0	0
3324298	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703225	4020	MOVIP ELEM. SCHOOL	Alternative School	No	Elementary	KG	05	2018	pk_12_total	0	0
3311831	MO	school	2900020	14400	MO SCHOOL FOR THE DEAF	290002003022	3000	WHEELER MIDDLE	Special Education School	No	Middle	06	08	2018	pk_12_total	10	10
3316776	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2018	pk_12_total	10	10
3323973	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203060	9030	SKYVIEW SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	10	10
3324003	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203066	9045	BRIARWOOD SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	10	10
3324039	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203072	9061	OZARK HILLS SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	10	10
3324045	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203073	9066	CEDAR RIDGE SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	10	10
3324145	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	High	06	12	2018	pk_12_total	10	10
3324181	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901271	1070	BABLER LODGE	Regular School	No	High	06	12	2018	pk_12_total	10	10
3310726	MO	school	2911670	5122	EXETER R-VI	291167000427	1050	EXETER HIGH	Regular School	No	High	09	12	2018	pk_12_total	100	100
3313635	MO	school	2929490	32058	STEWARTSVILLE C-2	292949002042	1050	STEWARTSVILLE HIGH	Regular School	No	High	07	12	2018	pk_12_total	100	100
3314151	MO	school	2902970	38046	ALBANY R-III	290297001478	3000	ALBANY MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total	100	100
3319375	MO	school	2915300	84004	HUMANSVILLE R-IV	291530000697	1050	HUMANSVILLE HIGH	Regular School	No	High	09	12	2018	pk_12_total	100	100
3312082	MO	school	2930300	17122	TINA-AVALON R-II	293030002070	4020	TINA-AVALON ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	101	101
3313535	MO	school	2923670	31116	PATTONSBURG R-II	292367001410	1050	PATTONSBURG HIGH	Regular School	No	High	06	12	2018	pk_12_total	101	101
3317698	MO	school	2928680	59113	SOUTHWEST LIVINGSTON CO. R-I	292868001771	4020	SOUTHWEST LIVINGSTON CO R-1 EL	Regular School	No	Elementary	PK	06	2018	pk_12_total	101	101
3318551	MO	school	2922560	74187	NODAWAY-HOLT R-VII	292256001234	1050	NODAWAY-HOLT JR.-SR. HIGH	Regular School	No	High	07	12	2018	pk_12_total	101	101
3321717	MO	school	2922650	96109	NORMANDY SCHOOLS COLLABORATIVE	292265002114	4180	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	101	101
3313791	MO	school	2928620	35099	SOUTHLAND C-9	292862001770	1050	SOUTHLAND HIGH	Regular School	No	High	07	12	2018	pk_12_total	102	102
3314822	MO	school	2918330	42118	LEESVILLE R-IX	291833000985	4020	LEESVILLE ELEM.	Regular School	No	Elementary	KG	08	2018	pk_12_total	102	102
3318667	MO	school	2916860	75086	OREGON-HOWELL R-III	291686000935	1050	KOSHKONONG HIGH	Regular School	No	High	09	12	2018	pk_12_total	102	102
3319694	MO	school	2913680	89088	HARDIN-CENTRAL C-2	291368000597	1050	HARDIN-CENTRAL HIGH	Regular School	No	High	07	12	2018	pk_12_total	102	102
3319766	MO	school	2918450	90078	LESTERVILLE R-IV	291845000991	1050	LESTERVILLE HIGH	Regular School	No	High	07	12	2018	pk_12_total	102	102
3314868	MO	school	2909860	42124	CLINTON	290986003291	7500	CLINTON EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	103	103
3317781	MO	school	2920610	60077	MCDONALD CO. R-I	292061003106	4070	PINEVILLE PRIMARY	Regular School	No	Elementary	PK	02	2018	pk_12_total	103	103
3317945	MO	school	2920280	64072	MARION CO. R-II	292028001075	1050	MARION CO. HIGH	Regular School	No	High	07	12	2018	pk_12_total	103	103
3318212	MO	school	2915660	68074	JAMESTOWN C-1	291566000743	1050	JAMESTOWN C-I HIGH	Regular School	No	High	07	12	2018	pk_12_total	103	103
3318260	MO	school	2919840	69108	MADISON C-3	291984001055	1050	MADISON HIGH	Regular School	No	High	07	12	2018	pk_12_total	103	103
3318697	MO	school	2908490	76081	OSAGE CO. R-I	290849000249	4020	OSAGE CO. ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	103	103
3322360	MO	school	2904530	103128	BELL CITY R-II	290453000047	1050	BELL CITY HIGH	Regular School	No	High	07	12	2018	pk_12_total	103	103
3315072	MO	school	2931680	46134	WEST PLAINS R-VII	293168002215	1050	WEST PLAINS SR. HIGH	Regular School	No	High	09	12	2018	pk_12_total	1038	1038
3318575	MO	school	2921660	74194	NORTHEAST NODAWAY CO. R-V	292166001191	1050	NORTHEAST NODAWAY HIGH	Regular School	No	High	07	12	2018	pk_12_total	104	104
3322604	MO	school	2905700	106001	BRADLEYVILLE R-I	290570000117	4020	BRADLEYVILLE ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	104	104
3317236	MO	school	2918270	53113	LEBANON R-III	291827000971	2050	LEBANON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2018	pk_12_total	1041	1041
3315969	MO	school	2916400	48078	KANSAS CITY 33	291640000844	1220	LINCOLN COLLEGE PREP.	Regular School	No	High	06	12	2018	pk_12_total	1043	1043
3319859	MO	school	2908370	92087	FT. ZUMWALT R-II	290837002427	3070	FT. ZUMWALT SOUTH MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total	1048	1048
3317811	MO	school	2903480	61150	ATLANTA C-3	290348000029	4020	ATLANTA ELEM.	Regular School	No	Elementary	KG	06	2018	pk_12_total	105	105
3318789	MO	school	2923760	78001	NORTH PEMISCOT CO. R-I	292376001429	4020	ROSS ELEM.	Regular School	No	Elementary	KG	05	2018	pk_12_total	105	105
3320672	MO	school	2913830	96088	HAZELWOOD	291383003208	7510	EAST EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	105	105
3313701	MO	school	2911040	34122	PLAINVIEW R-VIII	291104000377	4020	PLAINVIEW ELEM.	Regular School	No	Elementary	PK	08	2018	pk_12_total	106	106
3314752	MO	school	2922770	41003	NORTH HARRISON R-III	292277001257	1050	NORTH HARRISON HIGH	Regular School	No	High	07	12	2018	pk_12_total	106	106
3318563	MO	school	2930900	74190	WEST NODAWAY CO. R-I	293090002136	1050	WEST NODAWAY HIGH	Regular School	No	High	06	12	2018	pk_12_total	106	106
3318605	MO	school	2921690	74197	NORTH NODAWAY CO. R-VI	292169001196	4020	NORTH NODAWAY ELEM.	Regular School	No	Elementary	PK	05	2018	pk_12_total	106	106
3318847	MO	school	2905730	78009	DELTA C-7	290573000119	4020	DELTA C-7 ELEM.	Regular School	No	Elementary	KG	06	2018	pk_12_total	106	106
3322336	MO	school	2928110	102085	SHELBY CO. R-IV	292811001724	4020	CLARENCE ELEM.	Regular School	No	Elementary	PK	05	2018	pk_12_total	106	106
3314958	MO	school	2921480	44083	MOUND CITY R-II	292148001179	4020	MOUND CITY ELEM.	Regular School	No	Elementary	PK	04	2018	pk_12_total	107	107
3317951	MO	school	2920280	64072	MARION CO. R-II	292028001074	4020	MARION CO. ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	107	107
3318218	MO	school	2915660	68074	JAMESTOWN C-1	291566000742	4020	JAMESTOWN C-I ELEM.	Regular School	No	Elementary	KG	06	2018	pk_12_total	107	107
3318368	MO	school	2926610	72066	RISCO R-II	292661001563	4020	RISCO ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	107	107
3319772	MO	school	2918450	90078	LESTERVILLE R-IV	291845000990	4020	LESTERVILLE ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	107	107
3313251	MO	school	2916190	26006	JEFFERSON CITY	291619000495	3020	THOMAS JEFFERSON MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total	1071	1071
3323227	MO	school	2929280	115115	ST. LOUIS CITY	292928000434	1220	GATEWAY HIGH	Regular School	No	High	09	12	2018	pk_12_total	1075	1075
3313593	MO	school	2930390	31122	TRI-COUNTY R-VII	293039002081	4020	TRI-COUNTY ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	108	108
3318841	MO	school	2905730	78009	DELTA C-7	290573000120	1050	DELTA C-7 HIGH	Regular School	No	High	07	12	2018	pk_12_total	108	108
3320881	MO	school	2923700	96090	PATTONVILLE R-III	292370000656	7500	PATTONVILLE PRE-SCHOOL	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	108	108
3321995	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676003168	1069	SOUTHVIEW HIGH	Regular School	No	High	09	12	2018	pk_12_total	108	108
3321329	MO	school	2923580	96095	PARKWAY C-2	292358001555	3080	WEST MIDDLE	Regular School	No	Middle	06	08	2018	pk_12_total	1082	1082
3320684	MO	school	2912010	96089	FERGUSON-FLORISSANT R-II	291201000472	1050	MCCLUER HIGH	Regular School	No	High	09	12	2018	pk_12_total	1086	1086
3313827	MO	school	2916500	35102	KENNETT 39	291650002656	7500	EARLY CHILDHOOD CTR.	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	109	109
3317145	MO	school	2918360	51156	LEETON R-X	291836000987	1050	LEETON HIGH	Regular School	No	High	09	12	2018	pk_12_total	109	109
3321169	MO	school	2918690	96093	LINDBERGH SCHOOLS	291869003278	7500	EARLY CHILDHOOD ED CENTER WEST	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	109	109
3322718	MO	school	2929730	107151	SUCCESS R-VI	292973002054	4020	SUCCESS ELEM.	Regular School	No	Elementary	PK	08	2018	pk_12_total	109	109
3314352	MO	school	2928860	39141	SPRINGFIELD R-XII	292886001800	1080	HILLCREST HIGH	Regular School	No	High	09	12	2018	pk_12_total	1090	1090
3323215	MO	school	2929280	115115	ST. LOUIS CITY	292928003252	1015	GRISCOM JUVENILE DETENTION CTR	Alternative School	No	High	05	12	2018	pk_12_total	11	11
3324033	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203071	9060	CURRENT RIVER SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	11	11
3324057	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203075	9071	ROLLING MEADOW SCHOOL	Special Education School	No	Other	KG	12	2018	pk_12_total	11	11
3324111	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902179	1056	CORNERSTONE	Regular School	No	High	06	12	2018	pk_12_total	11	11
3324169	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902710	1068	NEW MADRID BEND YOUTH CTR.	Regular School	No	High	06	12	2018	pk_12_total	11	11
3324269	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901352	1095	COMMUNITY LEARNING CTR.	Regular School	No	High	06	12	2018	pk_12_total	11	11
3324281	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901364	1097	EXCEL SCHOOL	Regular School	No	High	06	12	2018	pk_12_total	11	11
3318080	MO	school	2929130	66104	ST. ELIZABETH R-IV	292913001867	1050	ST. ELIZABETH HIGH	Regular School	No	High	07	12	2018	pk_12_total	110	110
3322288	MO	school	2932220	101105	WINONA R-III	293222002260	1050	WINONA HIGH	Regular School	No	High	09	12	2018	pk_12_total	110	110
3320040	MO	school	2928950	92088	FRANCIS HOWELL R-III	292895001859	4070	FAIRMOUNT ELEM.	Regular School	No	Elementary	KG	05	2018	pk_12_total	1107	1107
3317644	MO	school	2920640	58108	MEADVILLE R-IV	292064001108	1050	MEADVILLE HIGH	Regular School	No	High	07	12	2018	pk_12_total	111	111
3318386	MO	school	2912780	72073	GIDEON 37	291278000535	1050	GIDEON HIGH	Regular School	No	High	07	12	2018	pk_12_total	111	111
3319610	MO	school	2914370	88075	HIGBEE R-VIII	291437000666	4020	HIGBEE ELEM.	Regular School	No	Elementary	KG	06	2018	pk_12_total	111	111
3322856	MO	school	2928170	108144	SHELDON R-VIII	292817001733	4020	SHELDON ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	111	111
3323734	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	09	2018	pk_12_total	111	111
3316782	MO	school	2914430	50003	HILLSBORO R-III	291443000675	1050	HILLSBORO HIGH	Regular School	No	High	09	12	2018	pk_12_total	1112	1112
3317745	MO	school	2920610	60077	MCDONALD CO. R-I	292061001104	1050	MCDONALD COUNTY HIGH	Regular School	No	High	09	12	2018	pk_12_total	1119	1119
3310492	MO	school	2922980	1090	ADAIR CO. R-I	292298001315	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2018	pk_12_total	112	112
3313329	MO	school	2905190	27055	BLACKWATER R-II	290519000069	4020	BLACKWATER ELEM.	Regular School	No	Elementary	PK	08	2018	pk_12_total	112	112
3323830	MO	school	2900605	115923	EAGLE COLLEGE PREP ENDEAVOR	290060503304	6998	EAGLE GRAVOIS PARK	Regular School	Yes	Elementary	KG	04	2018	pk_12_total	112	112
3315433	MO	school	2918300	48071	LEE'S SUMMIT R-VII	291830002806	3050	SUMMIT LAKES MIDDLE	Regular School	No	Middle	07	08	2018	pk_12_total	1120	1120
3318968	MO	school	2927830	80125	SEDALIA 200	292783003143	2000	SMITH COTTON JUNIOR HIGH SCHL	Regular School	No	Middle	06	08	2018	pk_12_total	1125	1125
3311699	MO	school	2925410	13059	POLO R-VII	292541000227	3000	POLO MIDDLE	Regular School	No	Middle	05	08	2018	pk_12_total	113	113
3312464	MO	school	2906030	21149	BRUNSWICK R-II	290603000145	1050	BRUNSWICK HIGH	Regular School	No	High	07	12	2018	pk_12_total	113	113
3316363	MO	school	2900590	48922	FRONTIER SCHOOLS	290059003180	3940	FRONTIER SCHL OF EXCELLENCE-M	Regular School	Yes	Middle	06	08	2018	pk_12_total	113	113
3322025	MO	school	2926760	96119	SPECL. SCH. DST. ST. LOUIS CO.	292676001599	4069	LITZSINGER	Regular School	No	Elementary	KG	08	2018	pk_12_total	113	113
3322706	MO	school	2916710	106006	KIRBYVILLE R-VI	291671000911	4020	KIRBYVILLE ELEM.	Regular School	No	Elementary	KG	03	2018	pk_12_total	113	113
3321286	MO	school	2923580	96095	PARKWAY C-2	292358001393	1075	NORTH HIGH	Regular School	No	High	09	12	2018	pk_12_total	1130	1130
3311927	MO	school	2915600	16090	JACKSON R-II	291560000738	1050	JACKSON SR. HIGH	Regular School	No	High	10	12	2018	pk_12_total	1139	1139
3310540	MO	school	2922710	2089	NORTH ANDREW CO. R-VI	292271001251	1050	NORTH ANDREW HIGH	Regular School	No	High	09	12	2018	pk_12_total	114	114
3314145	MO	school	2902970	38046	ALBANY R-III	290297000010	1050	ALBANY HIGH	Regular School	No	High	09	12	2018	pk_12_total	114	114
3314964	MO	school	2923190	44084	SOUTH HOLT CO. R-I	292319001334	1050	SOUTH HOLT HIGH	Regular School	No	High	07	12	2018	pk_12_total	114	114
3316392	MO	school	2900601	48925	HOPE LEADERSHIP ACADEMY	290060103194	6985	HOPE LEADERSHIP ACADEMY	Regular School	Yes	Elementary	KG	04	2018	pk_12_total	114	114
3318026	MO	school	2920750	65096	NORTH MERCER CO. R-III	292075001128	4020	NORTH MERCER ELEM.	Regular School	No	Elementary	PK	06	2018	pk_12_total	114	114
3321544	MO	school	2909720	96102	CLAYTON	290972002583	7500	FAMILY CTR.	Regular School	No	Prekindergarten	PK	PK	2018	pk_12_total	114	114