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 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
3071651	MO	school	2906360	7129	BUTLER R-V	290636003308	7500	BUTLER EARLY CHILDHOOD	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3071875	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2021	pk_12_total	0	0
3071913	MO	school	2922530	22089	Nixa Public Schools	292253003132	4030	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3071921	MO	school	2922530	22089	Nixa Public Schools	292253003242	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3072156	MO	school	2929100	36136	ST. CLAIR R-XIII	292910002568	1010	FRANKLIN CO. SPECL. ED. COOP.	Special Education School	No	Other	PK	12	2021	pk_12_total	0	0
3072217	MO	school	2929640	39137	STRAFFORD R-VI	292964003330	7500	COGDILL EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3072593	MO	school	2907460	49142	CARTHAGE R-IX	290746003243	7500	EARLY CHILDHOOD AND PAT CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3072857	MO	school	2927630	66105	SCHOOL OF THE OSAGE	292763003358	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3072927	MO	school	2921810	73108	NEOSHO SCHOOL DISTRICT	292181001205	4060	FIELD EARLY CHILD./KDGN. CTR.	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3073582	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2021	pk_12_total	0	0
3073664	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231003273	7500	WRIGHT START PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3073670	MO	school	2931050	109003	WARREN CO. R-III	293105003355	7500	EARLY LEARNING CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	0	0
3073843	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203058	9024	CITADEL SCHOOL	Special Education School	No	Other	KG	12	2021	pk_12_total	0	0
3311853	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative Education School	No	4	05	12	2016	pk_12_total	0	0
3311854	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	Other	05	12	2017	pk_12_total	0	0
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
3311856	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CTR.	Alternative School	No	High	05	12	2019	pk_12_total	0	0
3311857	MO	school	2906990	15002	CAMDENTON R-III	290699001953	1015	JUVENILE JUSTICE CENTER	Alternative School	No	High	05	12	2020	pk_12_total	0	0
3312300	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2017	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
3312302	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative School	No	Other	KG	12	2019	pk_12_total	0	0
3315721	MO	school	2926070	48073	RAYTOWN C-2	292607002984	7010	NORTHWOOD SCH.	Regular School	No	Other	KG	12	2017	pk_12_total	0	0
3316778	MO	school	2914430	50003	HILLSBORO R-III	291443001017	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	01	12	2020	pk_12_total	0	0
3320347	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2019	pk_12_total	0	0
3320348	MO	school	2911910	94078	FARMINGTON R-VII	291191002589	1015	JUVENILE DETENTION CTR.	Alternative School	No	Other	KG	12	2020	pk_12_total	0	0
3322408	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative Education School	No	4	02	12	2016	pk_12_total	0	0
3322409	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2017	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
3322412	MO	school	2905250	103131	BLOOMFIELD R-XIV	290525002578	1015	JUVENILE CTR.	Alternative School	No	Other	02	12	2020	pk_12_total	0	0
3323164	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative Education School	No	4	KG	12	2015	pk_12_total	0	0
3323165	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative Education School	No	4	KG	12	2016	pk_12_total	0	0
3323169	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151002618	1015	OZARK REGIONAL JUVENILE DET CT	Alternative School	No	Other	KG	12	2020	pk_12_total	0	0
3323962	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203058	9024	CITADEL SCHOOL	Special Education School	No	Other	KG	12	2019	pk_12_total	0	0
3324024	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203070	9056	PRAIRIE VIEW SCHOOL	Special Education School	No	4	KG	12	2015	pk_12_total	0	0
3324025	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203070	9056	PRAIRIE VIEW SCHOOL	Special Education School	No	4	KG	12	2016	pk_12_total	0	0
3324095	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901193	1053	ECHO DAY TREATMENT CTR.	Regular School	No	High	06	12	2020	pk_12_total	0	0
3324245	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901287	1084	ALTERNATIVE RESOURCE CTR.	Alternative School	No	High	06	12	2019	pk_12_total	0	0
3324259	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901296	1090	GREEN GABLES LODGE	Regular School	No	4	06	12	2015	pk_12_total	0	0
3324262	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902793	1091	ROSA PARKS CENTER	Regular School	No	Other	06	12	2017	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
3072524	MO	school	2916400	48078	KANSAS CITY 33	291640000865	6030	CONTRACT	Regular School	No	Other	PK	12	2021	pk_12_total	10	10
3072840	MO	school	2913650	64075	HANNIBAL 60	291365003307	7500	EARLY CHILDHOOD CENTER	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	10	10
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
3311833	MO	school	2900020	14400	MO SCHOOL FOR THE DEAF	290002003022	3000	WHEELER MIDDLE	Special Education School	No	Middle	06	08	2020	pk_12_total	10	10
3312298	MO	school	2913760	19149	HARRISONVILLE R-IX	291376002594	1015	EVERETT WADE JUVENILE CTR.	Alternative Education School	No	4	KG	12	2015	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
3323654	MO	school	2900021	115414	MO SCHOOL FOR THE BLIND	290002103039	4020	MO School for the Blind - ELEM	Special Education School	No	Elementary	KG	08	2019	pk_12_total	10	10
3323923	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203052	9014	LILLIAN SCHAPER SCHOOL	Special Education School	No	4	KG	12	2016	pk_12_total	10	10
3323959	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203058	9024	CITADEL SCHOOL	Special Education School	No	4	KG	12	2016	pk_12_total	10	10
3323965	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203059	9027	CROWLEY RIDGE SCHOOL	Special Education School	No	4	KG	12	2016	pk_12_total	10	10
3323966	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203059	9027	CROWLEY RIDGE SCHOOL	Special Education School	No	Other	KG	12	2017	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
3324000	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203066	9045	BRIARWOOD SCHOOL	Special Education School	No	4	KG	12	2015	pk_12_total	10	10
3324001	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203066	9045	BRIARWOOD SCHOOL	Special Education School	No	4	KG	12	2016	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
3324018	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203069	9055	DOGWOOD HILLS SCHOOL	Special Education School	No	4	KG	12	2015	pk_12_total	10	10
3324035	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203071	9060	CURRENT RIVER SCHOOL	Special Education School	No	Other	KG	12	2020	pk_12_total	10	10
3324037	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203072	9061	OZARK HILLS SCHOOL	Special Education School	No	4	KG	12	2016	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
3324040	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203072	9061	OZARK HILLS SCHOOL	Special Education School	No	Other	KG	12	2019	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
3324054	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203075	9071	ROLLING MEADOW SCHOOL	Special Education School	No	4	KG	12	2015	pk_12_total	10	10
3324058	MO	school	2900022	201201	MO SCHLS FOR THE SEV DISABLED	290002203075	9071	ROLLING MEADOW SCHOOL	Special Education School	No	Other	KG	12	2019	pk_12_total	10	10
3324082	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901185	1051	SIERRA-OSAGE TREATMENT CTR.	Regular School	No	High	05	12	2019	pk_12_total	10	10
3324108	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902179	1056	CORNERSTONE	Regular School	No	4	06	12	2015	pk_12_total	10	10
3324112	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902179	1056	CORNERSTONE	Regular School	No	High	06	12	2019	pk_12_total	10	10
3324142	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	4	06	12	2015	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
3324146	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	High	06	12	2019	pk_12_total	10	10
3324147	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901261	1062	LEWIS AND CLARK HALL	Regular School	No	High	06	12	2020	pk_12_total	10	10
3324176	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902711	1069	SIKESTON HOPE CTR.	Regular School	No	High	06	12	2019	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
3324191	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901936	1073	DATEMA HOUSE	Regular School	No	4	05	12	2016	pk_12_total	10	10
3324195	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901936	1073	DATEMA HOUSE	Regular School	No	High	05	12	2020	pk_12_total	10	10
3324198	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000903077	1074	DISCOVERY HALL	Regular School	No	Other	06	12	2017	pk_12_total	10	10
3324206	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902713	1076	HILLSBORO TREATMENT CTR.	Regular School	No	4	06	12	2015	pk_12_total	10	10
3324260	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000902793	1091	ROSA PARKS CENTER	Regular School	No	4	06	12	2015	pk_12_total	10	10
3324267	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901352	1095	COMMUNITY LEARNING CTR.	Regular School	No	4	06	12	2016	pk_12_total	10	10
3324268	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901352	1095	COMMUNITY LEARNING CTR.	Regular School	No	Other	06	12	2017	pk_12_total	10	10
3324273	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901358	1096	WILSON CREEK GROUP HOME	Regular School	No	4	06	12	2016	pk_12_total	10	10
3324277	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000901358	1096	WILSON CREEK GROUP HOME	Regular School	No	High	06	12	2020	pk_12_total	10	10
3324286	MO	school	2900009	347347	DIVISION OF YOUTH SERVICE	290000903153	1099	MET DAY TREATMENT CENTER	Regular School	No	Other	06	12	2017	pk_12_total	10	10
3072940	MO	school	2921690	74197	NORTH NODAWAY CO. R-VI	292169001196	4020	NORTH NODAWAY ELEM.	Regular School	No	Elementary	PK	05	2021	pk_12_total	100	100
3073070	MO	school	2913530	84003	HALFWAY R-III	291353000576	1050	HALFWAY SECONDARY	Regular School	No	High	07	12	2021	pk_12_total	100	100
3073655	MO	school	2905910	108143	BRONAUGH R-VII	290591000134	4020	BRONAUGH ELEM.	Regular School	No	Elementary	PK	06	2021	pk_12_total	100	100
3310726	MO	school	2911670	5122	EXETER R-VI	291167000427	1050	EXETER HIGH	Regular School	No	High	09	12	2018	pk_12_total	100	100
3310823	MO	school	2918510	6101	LIBERAL R-II	291851002719	3000	LIBERAL MIDDLE	Regular School	No	Middle	06	08	2020	pk_12_total	100	100
3310835	MO	school	2912930	6103	GOLDEN CITY R-III	291293000542	1050	GOLDEN CITY HIGH	Regular School	No	High	07	12	2020	pk_12_total	100	100
3312466	MO	school	2906030	21149	BRUNSWICK R-II	290603000145	1050	BRUNSWICK HIGH	Regular School	No	High	07	12	2020	pk_12_total	100	100
3313486	MO	school	2910440	29002	DADEVILLE R-II	291044000344	4020	Dadeville R-II School	Regular School	No	Elementary	KG	05	2020	pk_12_total	100	100
3313534	MO	school	2923670	31116	PATTONSBURG R-II	292367001410	1050	PATTONSBURG HIGH	Regular School	No	Other	06	12	2017	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
3313793	MO	school	2928620	35099	SOUTHLAND C-9	292862001770	1050	SOUTHLAND HIGH	Regular School	No	High	07	12	2020	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
3317806	MO	school	2903480	61150	ATLANTA C-3	290348000030	1050	ATLANTA HIGH	Regular School	No	High	07	12	2019	pk_12_total	100	100
3317943	MO	school	2920280	64072	MARION CO. R-II	292028001075	1050	MARION CO. HIGH	Regular School	No	3	07	12	2016	pk_12_total	100	100
3318081	MO	school	2929130	66104	ST. ELIZABETH R-IV	292913001867	1050	ST. ELIZABETH HIGH	Regular School	No	High	07	12	2019	pk_12_total	100	100
3318215	MO	school	2915660	68074	JAMESTOWN C-1	291566000742	4020	JAMESTOWN C-I ELEM.	Regular School	No	1	PK	06	2015	pk_12_total	100	100
3318650	MO	school	2910200	75084	COUCH R-I	291020000327	4020	COUCH ELEM.	Regular School	No	Elementary	PK	06	2019	pk_12_total	100	100
3318666	MO	school	2916860	75086	OREGON-HOWELL R-III	291686000935	1050	KOSHKONONG HIGH	Regular School	No	High	09	12	2017	pk_12_total	100	100
3318900	MO	school	2903040	79078	ALTENBURG 48	290304000014	4020	ALTENBURG ELEM.	Regular School	No	Elementary	KG	08	2017	pk_12_total	100	100