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 ccd_school_low_grade 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
2037665	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000028	4821004	EAST AMORY SCHOOL	Regular School	No	Elementary	03	05	2020	secondary_spec_ed	*
2033572	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2033589	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2033618	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000006	220006	CORINTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2033883	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2020	secondary_spec_ed	*
2033904	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2020	secondary_spec_ed	*
2034116	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101445	1321012	FIFTH STREET SCHOOL	Regular School	No	Middle	05	07	2020	secondary_spec_ed	*
2034311	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000178	1600012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2034354	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129001337	1600026	SEMINARY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2036216	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000899	3112010	BAY SPRINGS MIDDLE SCH	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2036636	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000568	3800010	NORTHEAST LAUDERDALE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2036658	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001174	3800014	SOUTHEAST LAUDERDALE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2036664	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000471	3800016	WEST LAUDERDALE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2037783	MS	school	2804380	5131	UNION PUBLIC SCHOOL DIST	280438001327	5131003	UNION MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2038294	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000042	5920008	BALDWYN HIGH SCHOOL	Regular School	No	High	05	12	2020	secondary_spec_ed	*
2038555	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001144	6200006	LAKE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2038570	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001145	6200010	BETTYE MAE JACK MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	10	10
2038643	MS	school	2801470	6220	FOREST MUNICIPAL SCHOOL DIST	280147000214	6220012	HAWKINS MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2038884	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000208	6811012	CHARLESTON MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2033495	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000602	130028	MORGANTOWN MIDDLE	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2033501	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000604	130036	ROBERT LEWIS MAGNET SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2033932	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2020	secondary_spec_ed	*
2033974	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000345	920006	HOUSTON HIGH SCHOOL	Regular School	No	High	06	12	2020	secondary_spec_ed	13	13
2033985	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000040	920010	HOUSTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2034954	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001232	2300009	HANCOCK MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2035944	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216000364	3000004	EAST CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2035988	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001049	3000018	VANCLEAVE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036007	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216000963	3000024	ST. MARTIN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036039	MS	school	2803000	3020	MOSS POINT SEPARATE SCHOOL DIST	280300000592	3020028	MAGNOLIA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036454	MS	school	2802370	3600	LAFAYETTE CO SCHOOL DIST	280237000967	3600012	LAFAYETTE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036548	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001316	3700017	SUMRALL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036570	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001253	3700021	OAK GROVE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036835	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255000492	4100004	GUNTOWN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036840	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255001276	4100007	MOOREVILLE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036887	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255001325	4100027	SHANNON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2036952	MS	school	2804320	4120	TUPELO PUBLIC SCHOOL DIST	280432001003	4120023	MILAM ELEMENTARY SCHOOL	Regular School	No	Middle	06	06	2020	secondary_spec_ed	*
2037205	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273001128	4400018	NEW HOPE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2037239	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120001380	4420018	COLUMBUS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2037538	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285001291	4700013	BYHALIA MIDDLE SCHOOL (6-8)	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
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
2037919	MS	school	2803540	5500	PEARL RIVER CO SCHOOL DIST	280354001069	5500008	PEARL RIVER CENTRAL JUNIOR HIGH	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2038170	MS	school	2803660	5800	PONTOTOC CO SCHOOL DIST	280366001011	5800007	South Pontotoc Middle School	Regular School	No	Middle	06	08	2020	secondary_spec_ed	12	12
2038548	MS	school	2803520	6120	PEARL PUBLIC SCHOOL DIST	280352001354	6120016	PEARL JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2038663	MS	school	2803960	6312	SOUTH DELTA SCHOOL DISTRICT	280396000383	6312010	SOUTH DELTA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2039427	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001472	7612008	LELAND SCHOOL PARK	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2039607	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2020	secondary_spec_ed	*
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
2039668	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471001580	7900012	WILLIAM WINANS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2039691	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000524	8020012	EILAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	12	12
2039768	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480001581	8200007	YAZOO COUNTY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2033549	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2033626	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2033644	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2033672	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2033716	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
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
2033804	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2033922	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2034019	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
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
2034630	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	10	10
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
2034741	MS	school	2803530	1821	PETAL SCHOOL DIST	280353000005	1821004	PETAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
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
2035122	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063001107	2420006	BILOXI JUNIOR HIGH	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2035738	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000132	2521008	CLINTON JR HI SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	13	13
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
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
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
2036428	MS	school	2802310	3500	KEMPER CO SCHOOL DIST	280231001489	3500014	KEMPER COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2036485	MS	school	2803450	3620	OXFORD SCHOOL DISTRICT	280345000664	3620016	OXFORD MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	11	11
2036984	MS	school	2804320	4120	TUPELO PUBLIC SCHOOL DIST	280432000293	4120042	TUPELO MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2037061	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801522	4211032	GREENWOOD MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2037184	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273000531	4400012	WEST LOWNDES HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2037469	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282000545	4600008	EAST MARION HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2037482	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282001247	4600014	WEST MARION HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2037547	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000551	4700016	POTTS CAMP HIGH SCHOOL (7-12)	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2037573	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000553	4700024	H. W. BYERS HIGH SCHOOL (7-12)	Regular School	No	High	07	12	2020	secondary_spec_ed	*
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
2037741	MS	school	2803600	5020	PHILADELPHIA PUBLIC SCHOOL DIST	280360000692	5020008	PHILADELPHIA HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2037944	MS	school	2803630	5520	PICAYUNE SCHOOL DIST	280363000697	5520012	PICAYUNE JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2038128	MS	school	2802880	5720	MCCOMB SCHOOL DISTRICT	280288000972	5720010	DENMAN JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	14	14
2038146	MS	school	2803660	5800	PONTOTOC CO SCHOOL DIST	280366001009	5800003	North Pontotoc Middle School	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2038192	MS	school	2803690	5820	PONTOTOC CITY SCHOOLS	280369001162	5820010	PONTOTOC JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
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
2038411	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000739	6100028	MCLAURIN ATTENDANCE CENTER	Regular School	No	High	07	12	2020	secondary_spec_ed	11	11
2038462	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000740	6100044	PELAHATCHIE ATTENDANCE CENTER	Regular School	No	High	07	12	2020	secondary_spec_ed	*
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
2038730	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000759	6500008	RALEIGH HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2038824	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701421	6711014	ROBERT L MERRITT JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	09	2020	secondary_spec_ed	*
2038901	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2038933	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	10	10
2038949	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2038999	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
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
2039375	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000831	7500026	VICKSBURG JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2039385	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000843	7500030	WARREN CENTRAL JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2039412	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2039460	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2039747	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*