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 school_nces_id 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
2033819	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501401	618004	WEST BOLIVAR DIST HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2033840	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501402	618010	RAY BROOKS SCHOOL	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2240374	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501526	618009	WEST BOLIVAR HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2240390	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501527	618015	MCEVANS SCHOOL	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
2033804	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2240357	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2021	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	*
2245313	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701421	6711014	ROBERT L MERRITT JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	09	2021	secondary_spec_ed	*
2038863	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701422	6711032	THOMAS E. EDWARDS, SR. HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2038848	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701425	6711026	GENTRY HIGH SCHOOL	Regular School	No	High	10	12	2020	secondary_spec_ed	*
2245336	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701425	6711026	GENTRY HIGH SCHOOL	Regular School	No	High	10	12	2021	secondary_spec_ed	*
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
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
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
2244333	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901453	5321020	ARMSTRONG JUNIOR HIGH SCHOOL	Regular School	No	Secondary	08	09	2021	secondary_spec_ed	*
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
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
2240673	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101441	1321020	WEST POINT HIGH SCHOOL	Regular School	No	High	08	12	2021	secondary_spec_ed	14	14
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	*
2240652	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101445	1321012	FIFTH STREET SCHOOL	Regular School	No	Middle	05	07	2021	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
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
2036999	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801512	4211004	AMANDA ELZY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2243500	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801512	4211004	AMANDA ELZY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2037023	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801516	4211016	GREENWOOD HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	14	14
2243524	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801516	4211016	GREENWOOD HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	14	14
2037061	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801522	4211032	GREENWOOD MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2243562	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801522	4211032	GREENWOOD MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	13	13
2037652	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2244141	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2033565	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2240121	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2033595	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2240151	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2240106	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2021	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	*
2240128	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	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	*
2240145	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	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	*
2240182	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2037665	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000028	4821004	EAST AMORY SCHOOL	Regular School	No	Elementary	03	05	2020	secondary_spec_ed	*
2244154	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000028	4821004	EAST AMORY SCHOOL	Regular School	No	Elementary	03	05	2021	secondary_spec_ed	*
2037671	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000029	4821008	AMORY HIGH SCHOOL	Regular School	No	High	08	12	2020	secondary_spec_ed	*
2244160	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000029	4821008	AMORY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	11	11
2033644	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2240200	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2021	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	*
2240228	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2021	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	*
2244777	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000042	5920008	BALDWYN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2244784	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000043	5920012	BALDWYN MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	secondary_spec_ed	*
2034973	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057000045	2320008	BAY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2241496	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057000045	2320008	BAY HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2240268	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2240284	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
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
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
2035122	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063001107	2420006	BILOXI JUNIOR HIGH	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
2241646	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063001107	2420006	BILOXI JUNIOR HIGH	Regular School	No	Middle	07	08	2021	secondary_spec_ed	14	14
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
2240303	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001475	614007	CLEVELAND CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	14	14
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
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
2038306	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001024	5921012	BOONEVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2244796	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001024	5921012	BOONEVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2037138	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000092	4320012	BROOKHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2243641	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000092	4320012	BROOKHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2240420	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2021	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	*
2240440	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2021	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	*
2240458	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
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
2243903	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000101	4520008	CANTON PUBLIC HIGH SCHOOL	Regular School	No	High	10	12	2021	secondary_spec_ed	15	15
2243906	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090001465	4520009	CANTON PUBLIC 9TH GRADE SCHOOL	Regular School	No	Secondary	09	09	2021	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	*
2240467	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2021	secondary_spec_ed	*
2033960	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	secondary_spec_ed	*
2240495	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	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	*
2240555	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
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
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
2034190	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000118	1420004	CLARKSDALE HIGH SCHOOL	Regular School	No	High	10	12	2020	secondary_spec_ed	12	12
2240725	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000118	1420004	CLARKSDALE HIGH SCHOOL	Regular School	No	High	10	12	2021	secondary_spec_ed	*
2240729	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000119	1420008	W.A. HIGGINS MIDDLE SCHOOL ACADEMY	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
2035733	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000131	2521004	CLINTON HIGH SCHOOL	Regular School	No	High	10	12	2020	secondary_spec_ed	12	12
2242243	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000131	2521004	CLINTON HIGH SCHOOL	Regular School	No	High	10	12	2021	secondary_spec_ed	11	11
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
2242248	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000132	2521008	CLINTON JR HI SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
2242266	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109001029	2521018	SUMNER HILL JR HI SCHOOL	Regular School	No	Secondary	09	09	2021	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
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
2039739	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2020	secondary_spec_ed	*
2246230	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2021	secondary_spec_ed	*
2242310	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	2021	secondary_spec_ed	*
2035785	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	secondary_spec_ed	*