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 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
3068184	MO	school	2919410	61156	MACON CO. R-I	291941001053	1050	MACON SENIOR HIGH	Regular School	No	High	09	12	2021	grade_12	99	99
3283228	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	3	09	12	2015	grade_12	99	99
3287428	MO	school	2932070	46131	WILLOW SPRINGS R-IV	293207002245	1050	WILLOW SPRINGS HIGH	Regular School	No	High	09	12	2018	grade_12	99	99
3287504	MO	school	2903150	47062	ARCADIA VALLEY R-II	290315000022	1050	ARCADIA VALLEY HIGH	Regular School	No	3	09	12	2016	grade_12	99	99
3289194	MO	school	2914250	50005	DUNKLIN R-V	291425000639	1050	HERCULANEUM HIGH	Regular School	No	High	09	12	2020	grade_12	99	99
3292642	MO	school	2923160	92091	ORCHARD FARM R-V	292316001331	1050	ORCHARD FARM SR. HIGH	Regular School	No	3	09	12	2016	grade_12	99	99
3296171	MO	school	2900595	115918	GRAND CENTER ARTS ACADEMY	290059503256	1945	GRAND CENTER ARTS ACADEMY HIGH	Regular School	Yes	3	09	12	2016	grade_12	99	99
3283482	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	High	09	12	2020	grade_12	98	98
3283520	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	3	09	12	2016	grade_12	98	98
3289456	MO	school	2914490	51152	HOLDEN R-III	291449000680	1050	HOLDEN HIGH	Regular School	No	3	09	12	2015	grade_12	98	98
3294575	MO	school	2904890	100061	SCOTT CO. R-IV	290489000059	1050	THOMAS W. KELLY HIGH	Regular School	No	3	09	12	2016	grade_12	98	98
3069169	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903102	1920	CONFLUENCE PREPARATORY ACADEMY	Regular School	Yes	High	09	12	2021	grade_12	97	97
3284814	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000398	1050	EL DORADO SPRINGS HIGH	Regular School	No	High	09	12	2018	grade_12	97	97
3284995	MO	school	2909780	22092	CLEVER R-V	290978000282	1050	CLEVER HIGH	Regular School	No	High	09	12	2019	grade_12	97	97
3285803	MO	school	2910410	28102	CRAWFORD CO. R-II	291041000341	1050	CUBA HIGH	Regular School	No	3	09	12	2016	grade_12	97	97
3285804	MO	school	2910410	28102	CRAWFORD CO. R-II	291041000341	1050	CUBA HIGH	Regular School	No	High	09	12	2017	grade_12	97	97
3286480	MO	school	2914280	37039	GASCONADE CO. R-I	291428000646	1050	HERMANN HIGH	Regular School	No	3	09	12	2015	grade_12	97	97
3295251	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2015	grade_12	97	97
3296063	MO	school	2900579	115906	CONFLUENCE ACADEMIES	290057903342	1945	GRAND CENTER ARTS ACADEMY HIGH	Regular School	Yes	High	09	12	2020	grade_12	97	97
3067028	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	High	09	12	2021	grade_12	96	96
3284115	MO	school	2922740	14126	NORTH CALLAWAY CO. R-I	292274001254	1050	NORTH CALLAWAY HIGH	Regular School	No	High	09	12	2018	grade_12	96	96
3287079	MO	school	2930360	40107	TRENTON R-IX	293036002080	1050	TRENTON SR. HIGH	Regular School	No	High	09	12	2017	grade_12	96	96
3288343	MO	school	2916400	48078	KANSAS CITY 33	291640000840	1200	CENTRAL ACADEMY OF EXCELLENCE	Career and Technical School	No	High	09	12	2018	grade_12	96	96
3289976	MO	school	2932190	57004	WINFIELD R-IV	293219002257	1050	WINFIELD HIGH	Regular School	No	High	09	12	2018	grade_12	96	96
3295108	MO	school	2914840	107152	HOUSTON R-I	291484000688	1050	HOUSTON HIGH	Regular School	No	3	09	12	2016	grade_12	96	96
3295253	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	High	09	12	2017	grade_12	96	96
3295661	MO	school	2929280	115115	ST. LOUIS CITY	292928001994	1680	ROOSEVELT HIGH	Regular School	No	High	09	12	2017	grade_12	96	96
3295685	MO	school	2929280	115115	ST. LOUIS CITY	292928002013	1860	CENTRAL VISUAL/PERF. ARTS HIGH	Regular School	No	High	09	12	2017	grade_12	96	96
3285805	MO	school	2910410	28102	CRAWFORD CO. R-II	291041000341	1050	CUBA HIGH	Regular School	No	High	09	12	2018	grade_12	95	95
3286667	MO	school	2929640	39137	STRAFFORD R-VI	292964002050	1050	STRAFFORD HIGH	Regular School	No	3	09	12	2015	grade_12	95	95
3288359	MO	school	2916400	48078	KANSAS CITY 33	291640000862	1400	PASEO ACAD. OF PERFORMING ARTS	Regular School	No	3	07	12	2016	grade_12	95	95
3288600	MO	school	2900029	48902	GUADALUPE CENTERS SCHOOLS	290002902741	1925	GUADALUPE CENTERS HIGH SCHOOL	Regular School	Yes	High	09	12	2018	grade_12	95	95
3288601	MO	school	2900029	48902	GUADALUPE CENTERS SCHOOLS	290002902741	1925	GUADALUPE CENTERS HIGH SCHOOL	Regular School	Yes	High	09	12	2019	grade_12	95	95
3289189	MO	school	2914250	50005	DUNKLIN R-V	291425000639	1050	HERCULANEUM HIGH	Regular School	No	3	09	12	2015	grade_12	95	95
3290221	MO	school	2919410	61156	MACON CO. R-I	291941001053	1050	MACON SR. HIGH	Regular School	No	High	09	12	2018	grade_12	95	95
3290550	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	High	09	12	2018	grade_12	95	95
3290808	MO	school	2930420	73099	EAST NEWTON CO. R-VI	293042002084	1050	EAST NEWTON HIGH	Regular School	No	High	09	12	2018	grade_12	95	95
3291096	MO	school	2931830	76083	OSAGE CO. R-III	293183002226	1050	FATIMA HIGH	Regular School	No	High	07	12	2019	grade_12	95	95
3291097	MO	school	2931830	76083	OSAGE CO. R-III	293183002226	1050	FATIMA HIGH	Regular School	No	High	07	12	2020	grade_12	95	95
3292168	MO	school	2910920	91092	DONIPHAN R-I	291092000373	1050	DONIPHAN HIGH	Regular School	No	3	09	12	2016	grade_12	95	95
3294996	MO	school	2912240	106003	FORSYTH R-III	291224000487	1050	FORSYTH HIGH	Regular School	No	High	09	12	2018	grade_12	95	95
3294998	MO	school	2912240	106003	FORSYTH R-III	291224000487	1050	FORSYTH HIGH	Regular School	No	High	09	12	2020	grade_12	95	95
3295055	MO	school	2914550	106005	HOLLISTER R-V	291455000684	1050	HOLLISTER HIGH	Regular School	No	High	09	12	2017	grade_12	95	95
3295252	MO	school	2932310	109002	WRIGHT CITY R-II OF WARREN CO.	293231002266	1050	WRIGHT CITY HIGH	Regular School	No	3	09	12	2016	grade_12	95	95
3295554	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151001182	1050	MOUNTAIN GROVE HIGH	Regular School	No	High	09	12	2019	grade_12	95	95
3296042	MO	school	2900574	115902	LIFT FOR LIFE ACADEMY	290057403183	1935	LIFT FOR LIFE ACADEMY HIGH SCH	Regular School	Yes	High	09	12	2020	grade_12	95	95
3068118	MO	school	2904020	55110	AURORA R-VIII	290402000031	1050	AURORA HIGH	Regular School	No	High	09	12	2021	grade_12	94	94
3068284	MO	school	2930420	73099	EAST NEWTON CO. R-VI	293042002084	1050	EAST NEWTON HIGH	Regular School	No	High	09	12	2021	grade_12	94	94
3283521	MO	school	2908400	10091	CENTRALIA R-VI	290840000244	1050	CENTRALIA HIGH	Regular School	No	High	09	12	2017	grade_12	94	94
3285536	MO	school	2917970	25002	LATHROP R-II	291797000960	1050	LATHROP HIGH	Regular School	No	High	09	12	2020	grade_12	94	94
3287031	MO	school	2911700	39142	FAIR GROVE R-X	291170000429	1050	FAIR GROVE HIGH	Regular School	No	High	09	12	2017	grade_12	94	94
3289459	MO	school	2914490	51152	HOLDEN R-III	291449000680	1050	HOLDEN HIGH	Regular School	No	High	09	12	2018	grade_12	94	94
3292167	MO	school	2910920	91092	DONIPHAN R-I	291092000373	1050	DONIPHAN HIGH	Regular School	No	3	09	12	2015	grade_12	94	94
3293930	MO	school	2913620	96103	HANCOCK PLACE	291362000583	1050	HANCOCK SR. HIGH	Regular School	No	High	09	12	2018	grade_12	94	94
3295679	MO	school	2929280	115115	ST. LOUIS CITY	292928002011	1830	VASHON HIGH	Regular School	No	High	09	12	2017	grade_12	94	94
3296173	MO	school	2900595	115918	GRAND CENTER ARTS ACADEMY	290059503256	1945	GRAND CENTER ARTS ACADEMY HIGH	Regular School	Yes	High	09	12	2018	grade_12	94	94
3068495	MO	school	2918220	89080	LAWSON R-XIV	291822000962	1050	LAWSON HIGH	Regular School	No	High	09	12	2021	grade_12	93	93
3069085	MO	school	2921510	114114	MOUNTAIN GROVE R-III	292151001182	1050	MOUNTAIN GROVE HIGH	Regular School	No	High	09	12	2021	grade_12	93	93
3288360	MO	school	2916400	48078	KANSAS CITY 33	291640000862	1400	PASEO ACAD. OF PERFORMING ARTS	Regular School	No	High	07	12	2017	grade_12	93	93
3290336	MO	school	2923490	64074	PALMYRA R-I	292349001362	1050	PALMYRA HIGH	Regular School	No	High	09	12	2017	grade_12	93	93
3290548	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	3	09	12	2016	grade_12	93	93
3290552	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	High	09	12	2020	grade_12	93	93
3290716	MO	school	2930840	71092	MORGAN CO. R-II	293084002131	1050	MORGAN CO. HIGH	Regular School	No	3	09	12	2016	grade_12	93	93
3290848	MO	school	2927900	73106	SENECA R-VII	292790001719	1050	SENECA HIGH	Regular School	No	3	09	12	2016	grade_12	93	93
3292046	MO	school	2918220	89080	LAWSON R-XIV	291822000962	1050	LAWSON HIGH	Regular School	No	High	09	12	2020	grade_12	93	93
3293927	MO	school	2913620	96103	HANCOCK PLACE	291362000583	1050	HANCOCK SR. HIGH	Regular School	No	3	09	12	2015	grade_12	93	93
3067556	MO	school	2914280	37039	GASCONADE CO. R-I	291428000646	1050	HERMANN HIGH	Regular School	No	High	09	12	2021	grade_12	92	92
3069103	MO	school	2929280	115115	ST. LOUIS CITY	292928001994	1680	ROOSEVELT HIGH	Regular School	No	High	09	12	2021	grade_12	92	92
3283347	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	High	09	12	2017	grade_12	92	92
3284010	MO	school	2930520	12110	TWIN RIVERS R-X	293052002095	1050	TWIN RIVERS HIGH	Regular School	No	High	09	12	2017	grade_12	92	92
3286086	MO	school	2904050	34124	AVA R-I	290405000036	1050	AVA HIGH	Regular School	No	High	09	12	2017	grade_12	92	92
3286089	MO	school	2904050	34124	AVA R-I	290405000036	1050	AVA HIGH	Regular School	No	High	09	12	2020	grade_12	92	92
3288342	MO	school	2916400	48078	KANSAS CITY 33	291640000840	1200	CENTRAL ACADEMY OF EXCELLENCE	Career and Technical School	No	High	09	12	2017	grade_12	92	92
3290223	MO	school	2919410	61156	MACON CO. R-I	291941001053	1050	MACON SR. HIGH	Regular School	No	High	09	12	2020	grade_12	92	92
3290547	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	3	09	12	2015	grade_12	92	92
3290720	MO	school	2930840	71092	MORGAN CO. R-II	293084002131	1050	MORGAN CO. HIGH	Regular School	No	High	09	12	2020	grade_12	92	92
3290809	MO	school	2930420	73099	EAST NEWTON CO. R-VI	293042002084	1050	EAST NEWTON HIGH	Regular School	No	High	09	12	2019	grade_12	92	92
3293945	MO	school	2916290	96104	JENNINGS	291629000769	1050	JENNINGS HIGH	Regular School	No	3	09	12	2015	grade_12	92	92
3295112	MO	school	2914840	107152	HOUSTON R-I	291484000688	1050	HOUSTON HIGH	Regular School	No	High	09	12	2020	grade_12	92	92
3295686	MO	school	2929280	115115	ST. LOUIS CITY	292928002013	1860	CENTRAL VISUAL/PERF. ARTS HIGH	Regular School	No	High	09	12	2018	grade_12	92	92
3067937	MO	school	2900597	48924	EWING MARION KAUFFMAN SCHOOL	290059703277	1910	EWING MARION KAUFFMAN HIGH	Regular School	Yes	High	09	12	2021	grade_12	91	91
3069096	MO	school	2929280	115115	ST. LOUIS CITY	292928001882	1250	BEAUMONT CTE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_12	91	91
3283232	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	High	09	12	2019	grade_12	91	91
3283478	MO	school	2913560	10089	HALLSVILLE R-IV	291356000578	1050	HALLSVILLE HIGH	Regular School	No	3	09	12	2016	grade_12	91	91
3285894	MO	school	2906120	30093	DALLAS CO. R-I	290612000149	1050	BUFFALO HIGH	Regular School	No	3	09	12	2016	grade_12	91	91
3289460	MO	school	2914490	51152	HOLDEN R-III	291449000680	1050	HOLDEN HIGH	Regular School	No	High	09	12	2019	grade_12	91	91
3289868	MO	school	2918460	56017	LEWIS CO. C-1	291846000993	1050	HIGHLAND JR.-SR. HIGH	Regular School	No	3	07	12	2016	grade_12	91	91
3290549	MO	school	2906510	68070	MONITEAU CO. R-I	290651000168	1050	CALIFORNIA HIGH	Regular School	No	High	09	12	2017	grade_12	91	91
3290717	MO	school	2930840	71092	MORGAN CO. R-II	293084002131	1050	MORGAN CO. HIGH	Regular School	No	High	09	12	2017	grade_12	91	91
3292087	MO	school	2926480	89089	RICHMOND R-XVI	292648001554	1050	RICHMOND HIGH	Regular School	No	High	09	12	2019	grade_12	91	91
3292088	MO	school	2926480	89089	RICHMOND R-XVI	292648001554	1050	RICHMOND HIGH	Regular School	No	High	09	12	2020	grade_12	91	91
3296172	MO	school	2900595	115918	GRAND CENTER ARTS ACADEMY	290059503256	1945	GRAND CENTER ARTS ACADEMY HIGH	Regular School	Yes	High	09	12	2017	grade_12	91	91
3067272	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000398	1050	EL DORADO SPRINGS HIGH	Regular School	No	High	09	12	2021	grade_12	90	90
3067302	MO	school	2909780	22092	CLEVER R-V	290978000282	1050	CLEVER HIGH	Regular School	No	High	09	12	2021	grade_12	90	90
3067657	MO	school	2930360	40107	TRENTON R-IX	293036002080	1050	TRENTON SR. HIGH	Regular School	No	High	09	12	2021	grade_12	90	90
3283230	MO	school	2917850	6104	LAMAR R-I	291785000954	1050	LAMAR HIGH	Regular School	No	High	09	12	2017	grade_12	90	90
3283345	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	3	09	12	2015	grade_12	90	90
3283350	MO	school	2931070	8107	WARSAW R-IX	293107002152	1050	WARSAW HIGH	Regular School	No	High	09	12	2020	grade_12	90	90
3284811	MO	school	2911310	20002	EL DORADO SPRINGS R-II	291131000398	1050	EL DORADO SPRINGS HIGH	Regular School	No	3	09	12	2015	grade_12	90	90
3285588	MO	school	2909930	26002	BLAIR OAKS R-II	290993000295	1050	BLAIR OAKS HIGH	Regular School	No	High	09	12	2018	grade_12	90	90
3286669	MO	school	2929640	39137	STRAFFORD R-VI	292964002050	1050	STRAFFORD HIGH	Regular School	No	High	09	12	2017	grade_12	90	90