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 rowid desc 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
3158574	MO	school	2900607	401401	MO VIRTUAL INSTRUCTION PROGRAM	290060703228	1050	MOCAP HIGH SCHOOL	Alternative School	No	High	06	12	2019	grade_2	0	0
3158568	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000903153	1099	MET DAY TREATMENT CENTER	Regular School	No	High	06	12	2019	grade_2	0	0
3158562	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901364	1097	EXCEL SCHOOL	Regular School	No	High	06	12	2019	grade_2	0	0
3158556	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901358	1096	WILSON CREEK GROUP HOME	Regular School	No	High	06	12	2019	grade_2	0	0
3158550	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901352	1095	COMMUNITY LEARNING CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158544	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902793	1091	ROSA PARKS CENTER	Regular School	No	High	06	12	2019	grade_2	0	0
3158537	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902716	1086	MT. VERNON TREATMENT CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158531	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901289	1085	WATKINS MILL PARK CAMP	Regular School	No	High	06	12	2019	grade_2	0	0
3158525	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	grade_2	0	0
3158519	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901285	1083	LANGSFORD HOUSE	Regular School	No	High	05	12	2019	grade_2	0	0
3158513	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901283	1082	WAVERLY REGIONAL YOUTH CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158508	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901276	1080	DELMINA WOODS YOUTH FACILITY	Regular School	No	High	06	12	2019	grade_2	0	0
3158502	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902715	1079	GENTRY RESIDENTIAL TREAT. FAC.	Regular School	No	High	06	12	2019	grade_2	0	0
3158496	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902714	1078	RICH HILL YOUTH DEV. CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158490	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902713	1076	HILLSBORO TREATMENT CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158484	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901273	1075	CAMP AVERY PARK CAMP	Regular School	No	High	06	12	2019	grade_2	0	0
3158474	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901936	1073	DATEMA HOUSE	Regular School	No	High	05	12	2019	grade_2	0	0
3158468	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902712	1071	RIVERBEND TREATMENT CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158462	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901271	1070	BABLER LODGE	Regular School	No	High	06	12	2019	grade_2	0	0
3158456	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902711	1069	SIKESTON HOPE CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158450	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902710	1068	NEW MADRID BEND YOUTH CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158444	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902211	1067	GATEWAY SCHOOL	Regular School	No	High	05	12	2019	grade_2	0	0
3158438	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901270	1065	NORTHWEST REG. YOUTH CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158432	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901265	1063	NEW DAY - DAY TREATMENT	Regular School	No	High	06	12	2019	grade_2	0	0
3158426	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	High	06	12	2019	grade_2	0	0
3158416	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901226	1060	FORT BELLEFONTAINE CAMPUS	Regular School	No	High	06	12	2019	grade_2	0	0
3158410	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901215	1059	TWIN RIVERS	Regular School	No	High	06	12	2019	grade_2	0	0
3158404	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901199	1058	BISSELL HALL	Regular School	No	High	06	12	2019	grade_2	0	0
3158398	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902196	1057	QUEST DAY TREATMENT	Regular School	No	High	06	12	2019	grade_2	0	0
3158392	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902179	1056	CORNERSTONE	Regular School	No	High	06	12	2019	grade_2	0	0
3158386	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901195	1055	HOGAN ST REGIONAL YOUTH CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158380	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902172	1054	FULTON TREATMENT CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158374	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901193	1053	ECHO DAY TREATMENT CTR.	Regular School	No	High	06	12	2019	grade_2	0	0
3158368	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901192	1052	GIRARDOT CENTER FOR YOUTH	Regular School	No	High	05	12	2019	grade_2	0	0
3158362	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901185	1051	SIERRA-OSAGE TREATMENT CTR.	Regular School	No	High	05	12	2019	grade_2	0	0
3158356	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901178	1050	W. E. SEARS YOUTH CTR.	Regular School	No	High	05	12	2019	grade_2	0	0
3158350	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901145	1010	MONTGOMERY CITY TREATMENT CTR.	Special Education School	No	High	06	12	2019	grade_2	0	0
3158344	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203076	9075	DALE M THOMPSON/TRAILS WEST S	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158338	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203075	9071	ROLLING MEADOW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158332	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203074	9070	GATEWAY/HUBERT WHEELER SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158326	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203073	9066	CEDAR RIDGE SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158320	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203072	9061	OZARK HILLS SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158314	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203071	9060	CURRENT RIVER SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158308	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203070	9056	PRAIRIE VIEW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158302	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203069	9055	DOGWOOD HILLS SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158296	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203068	9049	NEW DAWN SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158290	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203067	9048	COLLEGE VIEW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158284	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203066	9045	BRIARWOOD SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158278	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203064	9040	AUTUMN HILL SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158272	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203063	9036	MISSISSIPPI VALLEY SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158266	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203062	9034	OAKVIEW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158260	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203061	9032	HELEN M DAVIS SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	5	5
3158254	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203060	9030	SKYVIEW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158248	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203059	9027	CROWLEY RIDGE SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158242	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203058	9024	CITADEL SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158236	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203057	9023	B W ROBINSON SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158230	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203056	9021	E W THOMPSON SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158224	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203055	9020	VERELLE PENISTON SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158218	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203054	9018	OZARK HORIZON SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158212	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203053	9015	SPECIAL ACRES SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158206	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203052	9014	LILLIAN SCHAPER SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158200	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203050	9011	PARKVIEW SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158194	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203049	9010	BOOTHEEL SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158188	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203048	9009	MAPLE VALLEY SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158182	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203047	9008	DELMAR A COBBLE SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158176	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203046	9007	BOONSLICK SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158170	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203045	9006	LAKEVIEW WOODS SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158164	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203044	9004	SHADY GROVE SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158158	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203043	9003	H KENNETH KIRCHNER SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	6	6
3158152	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203042	9002	MAPAVILLE SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158146	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203041	9001	GREENE VALLEY SCHOOL	Special Education School	No	Other	KG	12	2019	grade_2	0	0
3158138	MO	school	2900614	115930	THE ARCH COMMUNITY SCHOOL	290061403302	6905	THE ARCH COMMUNITY SCHOOL	Regular School	Yes	Elementary	KG	04	2019	grade_2	11	11
3158135	MO	school	2900611	115928	LA SALLE CHARTER SCHOOL	290061103281	3910	LA SALLE CHARTER SCHOOL	Regular School	Yes	Middle	05	08	2019	grade_2	0	0
3158130	MO	school	2900609	115926	THE BIOME	290060903262	6905	THE BIOME	Regular School	Yes	Elementary	KG	04	2019	grade_2	39	39
3158125	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803274	3910	HAWTHORN MIDDLE	Regular School	Yes	Middle	06	08	2019	grade_2	0	0
3158120	MO	school	2900608	115925	HAWTHORN LEADERSHIP SCHL GIRLS	290060803317	1905	Hawthorn High School	Regular School	Yes	Secondary	09	10	2019	grade_2	0	0
3158117	MO	school	2900606	115924	LAFAYETTE PREPARATORY ACADEMY	290060603223	6993	LAFAYETTE PREPARATORY ACADEMY	Regular School	Yes	Elementary	KG	07	2019	grade_2	46	46
3158111	MO	school	2900605	115923	EAGLE COLLEGE PREP ENDEAVOR	290060503304	6998	EAGLE GRAVOIS PARK	Regular School	Yes	Elementary	KG	05	2019	grade_2	23	23
3158108	MO	school	2900605	115923	EAGLE COLLEGE PREP ENDEAVOR	290060503299	6997	EAGLE TOWER GROVE EAST	Regular School	Yes	Elementary	KG	05	2019	grade_2	30	30
3158104	MO	school	2900605	115923	EAGLE COLLEGE PREP ENDEAVOR	290060503272	6996	EAGLE FOX PARK	Regular School	Yes	Elementary	KG	05	2019	grade_2	22	22
3158099	MO	school	2900605	115923	EAGLE COLLEGE PREP ENDEAVOR	290060503224	6995	EAGLE TOWER GROVE SOUTH	Regular School	Yes	Elementary	KG	08	2019	grade_2	29	29
3158090	MO	school	2900600	115920	ST. LOUIS COLLEGE PREP	290060003178	3925	St. Louis College Prep Middle	Regular School	Yes	Middle	06	08	2019	grade_2	0	0
3158085	MO	school	2900600	115920	ST. LOUIS COLLEGE PREP	290060003264	1910	St. Louis College Prep High	Regular School	Yes	High	09	12	2019	grade_2	0	0
3158068	MO	school	2900592	115916	GATEWAY SCIENCE ACAD/ST LOUIS	290059203241	6997	GATEWAY SCIENCE ACAD-SOUTH ELE	Regular School	Yes	Elementary	KG	05	2019	grade_2	76	76
3158062	MO	school	2900592	115916	GATEWAY SCIENCE ACAD/ST LOUIS	290059203174	6980	GATEWAY SCIENCE ACAD/ST LOUIS	Regular School	Yes	Elementary	KG	05	2019	grade_2	80	80
3158056	MO	school	2900592	115916	GATEWAY SCIENCE ACAD/ST LOUIS	290059203244	3935	GATEWAY SCIENCE ACADEMY MIDDLE	Regular School	Yes	Middle	06	08	2019	grade_2	0	0
3158050	MO	school	2900592	115916	GATEWAY SCIENCE ACAD/ST LOUIS	290059203205	1940	GATEWAY SCIENCE ACADEMY HIGH	Regular School	Yes	High	09	12	2019	grade_2	0	0
3158044	MO	school	2900594	115915	CARONDELET LEADERSHIP ACADEMY	290059403172	6975	CARONDELET LEADERSHIP ACADEMY	Regular School	Yes	Elementary	KG	08	2019	grade_2	44	44
3158037	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103270	6973	KIPP TRIUMPH ACADEMY	Regular School	Yes	Middle	05	08	2019	grade_2	0	0
3158032	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103266	6972	KIPP WISDOM ACADEMY	Regular School	Yes	Elementary	KG	04	2019	grade_2	113	113
3158027	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103245	6971	KIPP VICTORY ACADEMY	Regular School	Yes	Elementary	KG	04	2019	grade_2	115	115
3158021	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103122	6970	KIPP INSPIRE ACADEMY	Regular School	Yes	Middle	05	08	2019	grade_2	0	0
3158015	MO	school	2900591	115914	KIPP ST LOUIS PUBLIC SCHOOLS	290059103314	1905	KIPP ST. LOUIS HIGH	Regular School	Yes	Secondary	09	10	2019	grade_2	0	0
3158012	MO	school	2900589	115913	NORTH SIDE COMMUNITY SCHOOL	290058903344	6970	NORTH SIDE COMMUNITY-GRAND CTR	Regular School	Yes	Middle	05	06	2019	grade_2	0	0
3158010	MO	school	2900589	115913	NORTH SIDE COMMUNITY SCHOOL	290058903142	6965	NORTH SIDE COMMUNITY SCHOOL	Regular School	Yes	Elementary	PK	04	2019	grade_2	68	68
3157998	MO	school	2900586	115912	ST. LOUIS LANG IMMERSION SCH	290058603124	6961	ST LOUIS LANG IMMERSION MARINE	Regular School	Yes	Elementary	KG	08	2019	grade_2	40	40
3157993	MO	school	2900586	115912	ST. LOUIS LANG IMMERSION SCH	290058603126	6960	ST.LOUIS LANG IMMERSION PAPIN	Regular School	Yes	Elementary	KG	06	2019	grade_2	51	51
3157988	MO	school	2900585	115911	CITY GARDEN MONTESSORI	290058503101	6955	CITY GARDEN MONTESSORI SCHOOL	Regular School	Yes	Elementary	PK	08	2019	grade_2	32	32
3157982	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903079	6932	SOUTH CITY	Regular School	Yes	Elementary	PK	08	2019	grade_2	87	87
3157976	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903014	6931	ASPIRE ACADEMY	Regular School	Yes	Elementary	PK	06	2019	grade_2	46	46
3157970	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903037	6930	OLD NORTH	Regular School	Yes	Elementary	PK	06	2019	grade_2	53	53