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
2241212	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000310	1820008	HATTIESBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	42	42
2034680	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000310	1820008	HATTIESBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	37	37
2037841	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901451	5321016	STARKVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	36	36
2034474	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000196	1700042	SOUTHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	35	35
2036979	MS	school	2804320	4120	TUPELO PUBLIC SCHOOL DIST	280432000819	4120040	TUPELO HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	35	35
2244905	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001076	6100032	NORTHWEST RANKIN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	35	35
2036371	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000451	3400052	WEST JONES HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	32	32
2036524	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001171	3700010	OAK GROVE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	31	31
2034694	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000980	1820030	N R BURGER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	30	30
2039496	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000244	7620032	GREENVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	30	30
2243480	MS	school	2804320	4120	TUPELO PUBLIC SCHOOL DIST	280432000819	4120040	TUPELO HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	30	30
2035128	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063000053	2420008	BILOXI HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	29	29
2037846	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901453	5321020	ARMSTRONG MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	29	29
2038417	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001076	6100032	NORTHWEST RANKIN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	29	29
2241007	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000196	1700042	SOUTHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	29	29
2242882	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000451	3400052	WEST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	29	29
2243028	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001171	3700010	OAK GROVE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	29	29
2241971	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000384	2520031	FOREST HILL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	28	28
2244329	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901451	5321016	STARKVILLE HIGH SCHOOL	Regular School	No	High	10	12	2021	secondary_spec_ed	28	28
2035201	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000276	2421040	GULFPORT HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	27	27
2035443	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000384	2520031	FOREST HILL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	27	27
2038101	MS	school	2804080	5712	SOUTH PIKE SCHOOL DIST	280408000773	5712028	SOUTH PIKE SENIOR HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	27	27
2038344	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001074	6100008	BRANDON HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	27	27
2033519	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000608	130044	NATCHEZ HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	26	26
2034409	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000190	1700022	HORN LAKE HIGH	Regular School	No	High	09	12	2020	secondary_spec_ed	26	26
2240681	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	26	26
2241724	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000276	2421040	GULFPORT HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	26	26
2242475	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001046	3000011	ST MARTIN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	26	26
2244834	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001074	6100008	BRANDON HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	26	26
2035965	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001046	3000011	ST MARTIN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	25	25
2241652	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063000053	2420008	BILOXI HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	25	25
2034948	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001153	2300008	HANCOCK HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	24	24
2036353	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000450	3400036	SOUTH JONES HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	24	24
2036806	MS	school	2802520	4000	LEAKE CO SCHOOL DIST	280252000487	4000004	LEAKE CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	23	23
2037233	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120000154	4420016	COLUMBUS HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	23	23
2240076	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000608	130044	NATCHEZ HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	23	23
2241226	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000980	1820030	N R BURGER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	23	23
2241049	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001569	1700052	DESOTO CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	22	22
2242117	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000403	2520060	MURRAH HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	22	22
2242574	MS	school	2803360	3021	OCEAN SPRINGS SCHOOL DIST	280336000650	3021016	OCEAN SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	22	22
2245990	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000244	7620032	GREENVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	22	22
2033756	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001477	614009	CLEVELAND CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	21	21
2035933	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000949	2900030	ITAWAMBA AGRICULTURAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	21	21
2243309	MS	school	2802520	4000	LEAKE CO SCHOOL DIST	280252000487	4000004	LEAKE CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	21	21
2245863	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000830	7500025	VICKSBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	21	21
2033750	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001475	614007	CLEVELAND CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	20	20
2036069	MS	school	2803360	3021	OCEAN SPRINGS SCHOOL DIST	280336000934	3021022	OCEAN SPRINGS MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	20	20
2036322	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000443	3400024	NORTHEAST JONES HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	20	20
2039371	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000830	7500025	VICKSBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	20	20
2241126	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001357	1700082	LAKE CORMORANT HIGH	Regular School	No	High	09	12	2021	secondary_spec_ed	20	20
2241279	MS	school	2803530	1821	PETAL SCHOOL DIST	280353001068	1821006	PETAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	20	20
2242985	MS	school	2803450	3620	OXFORD SCHOOL DISTRICT	280345000663	3620012	OXFORD HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	20	20
2034552	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001288	1700062	LEWISBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	19	19
2034821	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000840	2000014	GEORGE COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	09	2020	secondary_spec_ed	19	19
2034889	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000232	2100014	GREENE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	19	19
2038403	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000955	6100026	NORTHWEST RANKIN MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	19	19
2039381	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000842	7500028	WARREN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	19	19
2240309	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001477	614009	CLEVELAND CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	19	19
2240593	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102000116	1100008	PORT GIBSON HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	19	19
2240941	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000190	1700022	HORN LAKE HIGH	Regular School	No	High	09	12	2021	secondary_spec_ed	19	19
2243129	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000469	3800008	NORTHEAST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	19	19
2244891	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000955	6100026	NORTHWEST RANKIN MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	19	19
2035407	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000377	2520018	CALLAWAY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	18	18
2035623	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000409	2520068	PROVINE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	18	18
2036703	MS	school	2802910	3820	MERIDIAN PUBLIC SCHOOL DIST	280291000567	3820036	MERIDIAN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	18	18
2038576	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001184	6200012	MORTON HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	18	18
2242143	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000409	2520068	PROVINE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	18	18
2242688	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348001161	3022062	EXCEPTIONAL SCHOOL	Regular School	No	Ungraded	UG	UG	2021	secondary_spec_ed	18	18
2242832	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000443	3400024	NORTHEAST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	18	18
2243890	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279001381	4500066	GERMANTOWN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	18	18
2244344	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901532	5321030	SOCSD/MSU PARTNERSHIP MIDDLE SCHOOL	Regular School	No	Middle	06	07	2021	secondary_spec_ed	18	18
2244620	MS	school	2802880	5720	MCCOMB SCHOOL DISTRICT	280288000556	5720012	MCCOMB HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	18	18
2245873	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000842	7500028	WARREN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	18	18
2034137	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101441	1321020	WEST POINT HIGH SCHOOL	Regular School	No	High	08	12	2020	secondary_spec_ed	17	17
2034145	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	17	17
2034594	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001357	1700082	LAKE CORMORANT HIGH	Regular School	No	High	09	12	2020	secondary_spec_ed	17	17
2035597	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000403	2520060	MURRAH HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	17	17
2036481	MS	school	2803450	3620	OXFORD SCHOOL DISTRICT	280345000663	3620012	OXFORD HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	17	17
2037398	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279001381	4500066	GERMANTOWN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	17	17
2037411	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000101	4520008	CANTON PUBLIC HIGH SCHOOL	Regular School	No	High	10	12	2020	secondary_spec_ed	17	17
2240914	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000187	1700014	HERNANDO HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	17	17
2243204	MS	school	2802910	3820	MERIDIAN PUBLIC SCHOOL DIST	280291000567	3820036	MERIDIAN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	17	17
2245065	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001184	6200012	MORTON HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	17	17
2034057	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102000116	1100008	PORT GIBSON HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	16	16
2034747	MS	school	2803530	1821	PETAL SCHOOL DIST	280353001068	1821006	PETAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	16	16
2036893	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255000497	4100028	SHANNON HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	16	16
2038514	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000743	6100056	RICHLAND HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	16	16
2039292	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	16	16
2039626	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2020	secondary_spec_ed	16	16
2241350	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000228	2000012	GEORGE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	16	16
2242578	MS	school	2803360	3021	OCEAN SPRINGS SCHOOL DIST	280336000934	3021022	OCEAN SPRINGS MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	16	16
2242676	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000678	3022052	PASCAGOULA HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	16	16
2244190	MS	school	2800196	4911	WINONA-MONTGOMERY CONSOLIDATED SD	280019601485	4911006	WINONA SECONDARY SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	16	16
2245003	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000743	6100056	RICHLAND HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	16	16
2035860	MS	school	2802040	2700	HUMPHREYS CO SCHOOL DIST	280204001041	2700010	HUMPHREYS COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2036065	MS	school	2803360	3021	OCEAN SPRINGS SCHOOL DIST	280336000650	3021016	OCEAN SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2036179	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348001161	3022062	EXCEPTIONAL SCHOOL	Regular School	No	Ungraded	UG	UG	2020	secondary_spec_ed	15	15
2036629	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000469	3800008	NORTHEAST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2037700	MS	school	2800196	4911	WINONA-MONTGOMERY CONSOLIDATED SD	280019601485	4911006	WINONA SECONDARY SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	15	15
2037722	MS	school	2803060	5000	NESHOBA COUNTY SCHOOL DISTRICT	280306000612	5000008	NESHOBA CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2038152	MS	school	2803660	5800	PONTOTOC CO SCHOOL DIST	280366000701	5800004	North Pontotoc High School	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15