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 district 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
2244139	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	100	100
2240104	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	*
2240119	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2240149	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2240180	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	64	64
2244158	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000029	4821008	AMORY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	110	110
2240198	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_11	36	36
2240226	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_11	*
2244775	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000042	5920008	BALDWYN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	49	49
2241494	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057000045	2320008	BAY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	127	127
2240266	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	*
2240282	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_11	34	34
2241650	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063000053	2420008	BILOXI HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	431	431
2244794	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001024	5921012	BOONEVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2243639	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000092	4320012	BROOKHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	195	195
2240418	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_11	55	55
2240438	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_11	57	57
2240456	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	46	46
2243901	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000101	4520008	CANTON PUBLIC HIGH SCHOOL	Regular School	No	High	10	12	2021	grade_11	204	204
2240465	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_11	59	59
2240493	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_11	29	29
2240553	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	71	71
2240591	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102000116	1100008	PORT GIBSON HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	100	100
2240723	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000118	1420004	CLARKSDALE HIGH SCHOOL	Regular School	No	High	10	12	2021	grade_11	156	156
2240307	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001477	614009	CLEVELAND CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	180	180
2242241	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000131	2521004	CLINTON HIGH SCHOOL	Regular School	No	High	10	12	2021	grade_11	369	369
2240679	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	65	65
2240719	MS	school	2801100	1402	COAHOMA EARLY COLLEGE HIGH SCHOOL	280110000137	1402004	COAHOMA EARLY COLLEGE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	30	30
2246228	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2021	grade_11	37	37
2243989	MS	school	2801170	4620	COLUMBIA SCHOOL DISTRICT	280117000149	4620008	COLUMBIA HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	129	129
2243728	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120000154	4420016	COLUMBUS HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	238	238
2240789	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000168	1500008	CRYSTAL SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	102	102
2240805	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000169	1500012	WESSON ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_11	75	75
2240165	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000171	220004	CORINTH HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	117	117
2240838	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000177	1600008	COLLINS HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	39	39
2240869	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_11	30	30
2240875	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000182	1600024	SEMINARY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	89	89
2240912	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000187	1700014	HERNANDO HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	327	327
2240939	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000190	1700022	HORN LAKE HIGH	Regular School	No	High	09	12	2021	grade_11	337	337
2240972	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000193	1700032	OLIVE BRANCH HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	295	295
2241005	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000196	1700042	SOUTHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	405	405
2241047	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001569	1700052	DESOTO CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	466	466
2241082	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001288	1700062	LEWISBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	300	300
2241103	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001289	1700072	CENTER HILL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	246	246
2241124	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001357	1700082	LAKE CORMORANT HIGH	Regular School	No	High	09	12	2021	grade_11	210	210
2242692	MS	school	2801380	3111	EAST JASPER CONSOLIDATED SCH DIST	280138000204	3111004	HEIDELBERG HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	54	54
2245363	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000207	6811008	CHARLESTON HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	64	64
2240613	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000211	1211008	ENTERPRISE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2245122	MS	school	2801470	6220	FOREST MUNICIPAL SCHOOL DIST	280147000213	6220008	FOREST HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	99	99
2241204	MS	school	2801510	1802	FORREST COUNTY AG HIGH SCHOOL	280151000222	1802004	FORREST COUNTY AGRICULTURAL HI SCH	Regular School	No	High	09	12	2021	grade_11	127	127
2241159	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	*
2241309	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153000224	1900010	FRANKLIN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	78	78
2241348	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000228	2000012	GEORGE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	258	258
2241418	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000232	2100014	GREENE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	128	128
2245988	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000244	7620032	GREENVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	234	234
2243498	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801512	4211004	AMANDA ELZY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2243522	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801516	4211016	GREENWOOD HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	150	150
2243536	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801518	4211020	LEFLORE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	37	37
2241424	MS	school	2801680	2220	GRENADA SCHOOL DIST	280168000262	2220004	GRENADA HIGH	Regular School	No	High	09	12	2021	grade_11	207	207
2241722	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000276	2421040	GULFPORT HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	408	408
2241472	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001153	2300008	HANCOCK HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2241538	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000285	2400008	DIBERVILLE SENIOR HIGH SCH	Regular School	No	High	09	12	2021	grade_11	299	299
2241548	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000288	2400016	HARRISON CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	333	333
2241641	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177001347	2400055	WEST HARRISON HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	225	225
2241210	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000310	1820008	HATTIESBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	220	220
2240815	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000315	1520008	HAZLEHURST HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	90	90
2241850	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000902	2500030	TERRY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	311	311
2241856	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000328	2500040	RAYMOND HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	113	113
2245904	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	30	30
2244067	MS	school	2801950	4720	HOLLY SPRINGS SCHOOL DIST	280195000335	4720004	HOLLY SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2242340	MS	school	2800195	2611	HOLMES CONSOLIDATE SCHOOL DIST	280019501488	2611010	HOLMES COUNTY CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	205	205
2240507	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000345	920006	HOUSTON HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	119	119
2242375	MS	school	2802040	2700	HUMPHREYS CO SCHOOL DIST	280204001041	2700010	HUMPHREYS COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	78	78
2242420	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000361	2900024	MANTACHIE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_11	64	64
2242435	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000362	2900028	TREMONT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_11	33	33
2242441	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000949	2900030	ITAWAMBA AGRICULTURAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	134	134
2242458	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001045	3000006	EAST CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	192	192
2242473	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001046	3000011	ST MARTIN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	338	338
2242503	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001050	3000020	VANCLEAVE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	179	179
2241933	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000377	2520018	CALLAWAY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	258	258
2241969	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000384	2520031	FOREST HILL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	244	244
2241992	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000390	2520039	JIM HILL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	219	219
2242049	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000396	2520048	LANIER HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	132	132
2242115	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000403	2520060	MURRAH HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	340	340
2242141	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000409	2520068	PROVINE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	219	219
2242236	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000423	2520089	WINGFIELD HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2242753	MS	school	2802220	3200	JEFFERSON CO SCHOOL DIST	280222000427	3200008	JEFFERSON CO HIGH	Regular School	No	High	09	12	2021	grade_11	70	70
2242776	MS	school	2802250	3300	JEFFERSON DAVIS CO SCHOOL DIST	280225000429	3300008	JDC HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	84	84
2242830	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000443	3400024	NORTHEAST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	164	164
2242862	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000450	3400036	SOUTH JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	181	181
2242880	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000451	3400052	WEST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	224	224
2242938	MS	school	2802310	3500	KEMPER CO SCHOOL DIST	280231001116	3500016	KEMPER COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	83	83
2240245	MS	school	2802340	420	KOSCIUSKO SCHOOL DISTRICT	280234000460	420016	KOSCIUSKO SENIOR HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	147	147
2242951	MS	school	2802370	3600	LAFAYETTE CO SCHOOL DIST	280237000463	3600008	LAFAYETTE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2243026	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001171	3700010	OAK GROVE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	414	414
2243036	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001172	3700014	PURVIS HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*
2243055	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001173	3700018	SUMRALL HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	159	159
2243098	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001484	3700026	LUMBERTON HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	40	40
2243113	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001348	3800005	CLARKDALE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_11	78	78
2243127	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000469	3800008	NORTHEAST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	137	137
2243149	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000470	3800012	SOUTHEAST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11	*