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 total_int 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
2033521	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303001397	130045	NATCHEZ FRESHMAN ACADEMY	Regular School	No	Secondary	08	09	2020	grade_9	*
2035782	MS	school	2801189	2560	MS SCH FOR THE BLIND AND DEAF	280118901504	2560002	MS SCHOOL FOR THE DEAF	Special Education School	No	Other	KG	12	2020	grade_9	*
2035795	MS	school	2801189	2560	MS SCH FOR THE BLIND AND DEAF	280118901194	2560004	MS SCHOOL FOR THE BLIND	Special Education School	No	Other	01	12	2020	grade_9	*
2036430	MS	school	2802310	3500	KEMPER CO SCHOOL DIST	280231001116	3500016	KEMPER COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	*
2038290	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000042	5920008	BALDWYN HIGH SCHOOL	Regular School	No	High	05	12	2020	grade_9	*
2039429	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001059	7612012	LELAND HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	*
2039603	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_9	*
2033836	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501402	618010	RAY BROOKS SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	18	18
2039027	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000775	7012004	BLUE MOUNTAIN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_9	19	19
2034332	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	20	20
2039268	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000834	7400008	SALEM ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	24	24
2038929	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	28	28
2033956	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_9	30	30
2038223	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000717	5900020	JUMPERTOWN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_9	31	31
2033668	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_9	34	34
2039408	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	34	34
2033712	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	35	35
2039219	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000824	7300016	WEST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_9	35	35
2035922	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000362	2900028	TREMONT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	36	36
2036594	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001484	3700026	LUMBERTON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	37	37
2039717	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000527	8020020	NOXAPATER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	37	37
2039735	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2020	grade_9	37	37
2038995	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	38	38
2033545	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	41	41
2033853	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501419	618018	SHAW HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	42	42
2033728	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	43	43
2037636	MS	school	2802940	4800	MONROE CO SCHOOL DIST	280294000582	4800020	SMITHVILLE HIGH SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	43	43
2039184	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000822	7300008	INGOMAR ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_9	43	43
2036826	MS	school	2802520	4000	LEAKE CO SCHOOL DIST	280252000490	4000016	LEAKE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	45	45
2038257	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000721	5900032	THRASHER HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_9	45	45
2037605	MS	school	2802940	4800	MONROE CO SCHOOL DIST	280294000580	4800012	HAMILTON HIGH SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	47	47
2039042	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000776	7012008	PINE GROVE HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_9	47	47
2033918	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	48	48
2033994	MS	school	2803390	921	OKOLONA SEPARATE SCHOOL DIST	280339000654	921008	OKOLONA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	48	48
2038654	MS	school	2803960	6312	SOUTH DELTA SCHOOL DISTRICT	280396000753	6312008	SOUTH DELTA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	48	48
2033640	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_9	49	49
2034182	MS	school	2801100	1402	COAHOMA EARLY COLLEGE HIGH SCHOOL	280110000137	1402004	COAHOMA EARLY COLLEGE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	49	49
2034626	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	49	49
2033815	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501401	618004	WEST BOLIVAR DIST HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	50	50
2037086	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000513	4300008	ENTERPRISE SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	50	50
2037101	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000515	4300016	LOYD STAR SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	50	50
2037180	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273000531	4400012	WEST LOWNDES HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	50	50
2037569	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000553	4700024	H. W. BYERS HIGH SCHOOL (7-12)	Regular School	No	High	07	12	2020	grade_9	51	51
2038037	MS	school	2803870	5620	RICHTON SCHOOL DIST	280387000744	5620004	RICHTON HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	51	51
2038897	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	51	51
2033511	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303001414	130043	NATCHEZ EARLY COLLEGE@CO-LIN	Regular School	No	High	09	12	2020	grade_9	52	52
2034141	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	52	52
2038273	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000722	5900036	WHEELER HIGH SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	52	52
2038604	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390000749	6200020	SEBASTOPOL ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	52	52
2038752	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000762	6500012	TAYLORSVILLE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	52	52
2037072	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000512	4300004	BOGUE CHITTO SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	53	53
2039622	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_9	56	56
2039702	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000526	8020016	NANIH WAIYA ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	56	56
2033900	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2020	grade_9	57	57
2037465	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282000545	4600008	EAST MARION HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	57	57
2038316	MS	school	2803810	6000	QUITMAN CO SCHOOL DIST	280381000730	6000020	M. S. PALMER HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	57	57
2038493	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000742	6100052	PUCKETT ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_9	57	57
2038616	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001389	6200024	LAKE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	57	57
2036227	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000859	3112012	STRINGER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	58	58
2037543	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000551	4700016	POTTS CAMP HIGH SCHOOL (7-12)	Regular School	No	High	07	12	2020	grade_9	58	58
2038945	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	58	58
2039202	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000823	7300012	MYRTLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_9	58	58
2039464	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000976	7613020	RIVERSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	58	58
2033879	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2020	grade_9	59	59
2036207	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000857	3112008	BAY SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	59	59
2037167	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273001460	4400005	GOLDEN TRIANGLE EARLY COLLEGE	Regular School	No	High	09	12	2020	grade_9	60	60
2037309	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279000541	4500016	VELMA JACKSON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	60	60
2037737	MS	school	2803600	5020	PHILADELPHIA PUBLIC SCHOOL DIST	280360000692	5020008	PHILADELPHIA HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	61	61
2038458	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000740	6100044	PELAHATCHIE ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_9	61	61
2033800	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	62	62
2037033	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801518	4211020	LEFLORE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	63	63
2037118	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000516	4300020	WEST LINCOLN SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	63	63
2038486	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001079	6100050	PISGAH HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	63	63
2039010	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000640	7011012	WALNUT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	63	63
2038922	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423000800	6900012	INDEPENDENCE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	64	64
2039167	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000821	7300004	EAST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_9	64	64
2039456	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	64	64
2034300	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000177	1600008	COLLINS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	66	66
2038718	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000758	6500004	MIZE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	68	68
2036181	MS	school	2801380	3111	EAST JASPER CONSOLIDATED SCH DIST	280138000204	3111004	HEIDELBERG HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	69	69
2039743	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	72	72
2034265	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000169	1500012	WESSON ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	74	74
2033928	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_9	75	75
2034775	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153000224	1900010	FRANKLIN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	75	75
2036240	MS	school	2802220	3200	JEFFERSON CO SCHOOL DIST	280222000427	3200008	JEFFERSON CO HIGH	Regular School	No	High	09	12	2020	grade_9	75	75
2039075	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2020	grade_9	75	75
2039659	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471000879	7900008	WILKINSON COUNTY HIGH	Regular School	No	High	09	12	2020	grade_9	75	75
2033622	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	76	76
2038874	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000207	6811008	CHARLESTON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	76	76
2037575	MS	school	2801950	4720	HOLLY SPRINGS SCHOOL DIST	280195000335	4720004	HOLLY SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	77	77
2039288	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	77	77
2034015	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	82	82
2038241	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000719	5900028	NEW SITE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	82	82
2038859	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701422	6711032	THOMAS E. EDWARDS, SR. HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	82	82
2037773	MS	school	2803180	5130	NEWTON MUNICIPAL SCHOOL DISTRICT	280318000626	5130008	NEWTON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	83	83
2037785	MS	school	2804380	5131	UNION PUBLIC SCHOOL DIST	280438000825	5131004	UNION HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	83	83
2034075	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000211	1211008	ENTERPRISE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	85	85
2038022	MS	school	2803570	5600	PERRY CO SCHOOL DIST	280357001071	5600014	PERRY CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	85	85
2038588	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390000748	6200016	SCOTT CENTRAL ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_9	86	86
2038726	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000759	6500008	RALEIGH HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9	86	86
2036610	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001348	3800005	CLARKDALE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9	87	87