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 desc 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
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	*
2240509	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000345	920006	HOUSTON HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	12	12
2240520	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000040	920010	HOUSTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	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	*
2039807	MS	school	2804770	8220	YAZOO CITY MUNICIPAL SCHOOL DIST	280477000888	8220020	YAZOO CITY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2246298	MS	school	2804770	8220	YAZOO CITY MUNICIPAL SCHOOL DIST	280477000888	8220020	YAZOO CITY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	12	12
2039763	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480000890	8200004	YAZOO COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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	*
2246254	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480000890	8200004	YAZOO COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	13	13
2246259	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480001581	8200007	YAZOO COUNTY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	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	*
2246238	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
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	*
2039686	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000523	8020008	LOUISVILLE HIGH SCHOOL	Regular School	No	High	09	12	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
2039721	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000527	8020020	NOXAPATER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2246175	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000523	8020008	LOUISVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2246180	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000524	8020012	EILAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	secondary_spec_ed	*
2246196	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000526	8020016	NANIH WAIYA ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
2246212	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000527	8020020	NOXAPATER ATTENDANCE CENTER	Regular School	No	Other	KG	12	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	*
2039663	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471000879	7900008	WILKINSON COUNTY HIGH	Regular School	No	High	09	12	2020	secondary_spec_ed	*
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	*
2246152	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471000879	7900008	WILKINSON COUNTY HIGH	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2246157	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471001580	7900012	WILLIAM WINANS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	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
2246096	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2021	secondary_spec_ed	*
2246115	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2021	secondary_spec_ed	15	15
2039598	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000850	7700026	WAYNE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2246087	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000850	7700026	WAYNE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2039496	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000244	7620032	GREENVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	30	30
2245990	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000244	7620032	GREENVILLE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	22	22
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	*
2245954	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	12	12
2039427	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001472	7612008	LELAND SCHOOL PARK	Regular School	No	Middle	06	08	2020	secondary_spec_ed	*
2039433	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001059	7612012	LELAND HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2245921	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001472	7612008	LELAND SCHOOL PARK	Regular School	No	Middle	06	08	2021	secondary_spec_ed	*
2245927	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001059	7612012	LELAND HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2245906	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2039371	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000830	7500025	VICKSBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	20	20
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	*
2039381	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000842	7500028	WARREN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	19	19
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	*
2245863	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000830	7500025	VICKSBURG HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	21	21
2245867	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000831	7500026	VICKSBURG JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
2245873	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000842	7500028	WARREN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	18	18
2245877	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000843	7500030	WARREN CENTRAL JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	secondary_spec_ed	*
2039272	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000834	7400008	SALEM ATTENDANCE CENTER	Regular School	No	Other	KG	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
2245759	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000834	7400008	SALEM ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
2245780	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2039229	MS	school	2803120	7320	NEW ALBANY PUBLIC SCHOOLS	280312000615	7320008	NEW ALBANY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2245717	MS	school	2803120	7320	NEW ALBANY PUBLIC SCHOOLS	280312000615	7320008	NEW ALBANY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2039171	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000821	7300004	EAST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	secondary_spec_ed	*
2039206	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000823	7300012	MYRTLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	secondary_spec_ed	*
2039223	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000824	7300016	WEST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	secondary_spec_ed	*
2245659	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000821	7300004	EAST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	secondary_spec_ed	*
2245694	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000823	7300012	MYRTLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	secondary_spec_ed	*
2245711	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000824	7300016	WEST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	secondary_spec_ed	*
2039140	MS	school	2804290	7200	TUNICA COUNTY SCHOOL DISTRICT	280429000808	7200008	ROSA FORT HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2245627	MS	school	2804290	7200	TUNICA COUNTY SCHOOL DISTRICT	280429000808	7200008	ROSA FORT HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	15	15
2039079	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2039116	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426001227	7100024	TISHOMINGO COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	15	15
2245566	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2021	secondary_spec_ed	*
2245603	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426001227	7100024	TISHOMINGO COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2039058	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000778	7012016	RIPLEY HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2245546	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000778	7012016	RIPLEY HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	12	12
2038999	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed	*
2039014	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000640	7011012	WALNUT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*
2245486	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327001534	7011007	FALKNER ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	secondary_spec_ed	*
2245502	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000640	7011012	WALNUT ATTENDANCE CENTER	Regular School	No	Other	KG	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	*
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	*
2033922	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	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	*
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	*
2240458	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2038965	MS	school	2803930	6920	SENATOBIA MUNICIPAL SCHOOL DIST	280393000751	6920008	SENATOBIA HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2245452	MS	school	2803930	6920	SENATOBIA MUNICIPAL SCHOOL DIST	280393000751	6920008	SENATOBIA HIGH SCHOOL	Regular School	No	High	09	12	2021	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	*
2245420	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2021	secondary_spec_ed	*
2245437	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2021	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	*
2245388	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2021	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	*
2245371	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000208	6811012	CHARLESTON MIDDLE SCHOOL	Regular School	No	Middle	05	08	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	*
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	*
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	*
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	*
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	*
2038778	MS	school	2804170	6600	STONE CO SCHOOL DIST	280417000790	6600012	STONE HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed	*
2245267	MS	school	2804170	6600	STONE CO SCHOOL DIST	280417000790	6600012	STONE HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed	*
2038722	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000758	6500004	MIZE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	secondary_spec_ed	*