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 district_state_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
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
2034079	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000211	1211008	ENTERPRISE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	10	10
2240615	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000211	1211008	ENTERPRISE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2034101	MS	school	2803780	1212	QUITMAN SCHOOL DIST	280378000725	1212012	QUITMAN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2240637	MS	school	2803780	1212	QUITMAN SCHOOL DIST	280378000725	1212012	QUITMAN HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
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
2033522	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303001397	130045	NATCHEZ FRESHMAN ACADEMY	Regular School	No	Secondary	08	09	2020	secondary_spec_ed	*
2240052	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000602	130028	MORGANTOWN MIDDLE	Regular School	No	Middle	06	08	2021	secondary_spec_ed	*
2240058	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000604	130036	ROBERT LEWIS MAGNET SCHOOL	Regular School	No	Middle	06	08	2021	secondary_spec_ed	*
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
2240079	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303001397	130045	NATCHEZ FRESHMAN ACADEMY	Regular School	No	Secondary	08	09	2021	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	*
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
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	*
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
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
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	*
2034253	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000168	1500008	CRYSTAL SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2034269	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000169	1500012	WESSON ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2240791	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000168	1500008	CRYSTAL SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2034280	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000315	1520008	HAZLEHURST HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2240817	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000315	1520008	HAZLEHURST HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2034304	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000177	1600008	COLLINS HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	11	11
2034311	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000178	1600012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2034336	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2034342	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000182	1600024	SEMINARY HIGH SCHOOL	Regular School	No	High	09	12	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	*
2240840	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000177	1600008	COLLINS HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2240847	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000178	1600012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	secondary_spec_ed	*
2240871	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
2240889	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129001337	1600026	SEMINARY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	secondary_spec_ed	*
2034380	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000187	1700014	HERNANDO HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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
2034442	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000193	1700032	OLIVE BRANCH HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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
2034516	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001569	1700052	DESOTO CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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
2034573	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001289	1700072	CENTER HILL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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
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
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
2240974	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000193	1700032	OLIVE BRANCH HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
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
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
2241084	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001288	1700062	LEWISBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	15	15
2241105	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001289	1700072	CENTER HILL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	12	12
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
2034612	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000216	1800008	DIXIE ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2020	secondary_spec_ed	*
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
2034655	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000220	1800028	SOUTH FORREST ATTENDANCE CENTER	Regular School	No	Elementary	PK	08	2020	secondary_spec_ed	*
2034668	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000221	1800036	EARL TRAVILLION ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2020	secondary_spec_ed	*
2241144	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000216	1800008	DIXIE ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	secondary_spec_ed	*
2241161	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2241187	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000220	1800028	SOUTH FORREST ATTENDANCE CENTER	Regular School	No	Elementary	PK	08	2021	secondary_spec_ed	*
2241200	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000221	1800036	EARL TRAVILLION ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	secondary_spec_ed	*
2034674	MS	school	2801510	1802	FORREST COUNTY AG HIGH SCHOOL	280151000222	1802004	FORREST COUNTY AGRICULTURAL HI SCH	Regular School	No	High	09	12	2020	secondary_spec_ed	14	14
2241206	MS	school	2801510	1802	FORREST COUNTY AG HIGH SCHOOL	280151000222	1802004	FORREST COUNTY AGRICULTURAL HI SCH	Regular School	No	High	09	12	2021	secondary_spec_ed	*
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
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
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
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
2034741	MS	school	2803530	1821	PETAL SCHOOL DIST	280353000005	1821004	PETAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	secondary_spec_ed	*
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
2241273	MS	school	2803530	1821	PETAL SCHOOL DIST	280353000005	1821004	PETAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
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
2034779	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153000224	1900010	FRANKLIN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2241311	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153000224	1900010	FRANKLIN 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	*
2033565	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	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	*
2033595	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	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	*
2240121	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2240145	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	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	*
2034817	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000228	2000012	GEORGE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	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
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
2241354	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000840	2000014	GEORGE COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
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
2241420	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000232	2100014	GREENE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2033611	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000171	220004	CORINTH HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	12	12
2033618	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000006	220006	CORINTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed	*
2240167	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000171	220004	CORINTH HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	12	12
2240174	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000006	220006	CORINTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	secondary_spec_ed	*
2034895	MS	school	2801680	2220	GRENADA SCHOOL DIST	280168000262	2220004	GRENADA HIGH	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2241426	MS	school	2801680	2220	GRENADA SCHOOL DIST	280168000262	2220004	GRENADA HIGH	Regular School	No	High	09	12	2021	secondary_spec_ed	*
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
2034954	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001232	2300009	HANCOCK MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2241474	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001153	2300008	HANCOCK HIGH SCHOOL	Regular School	No	High	09	12	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	*