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 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
2033548	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2033564	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2033643	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_12	*
2033731	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_12	*
2033839	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501402	618010	RAY BROOKS SCHOOL	Regular School	No	Other	KG	12	2020	grade_12	*
2034100	MS	school	2803780	1212	QUITMAN SCHOOL DIST	280378000725	1212012	QUITMAN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2034252	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000168	1500008	CRYSTAL SPRINGS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2034341	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000182	1600024	SEMINARY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2034572	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001289	1700072	CENTER HILL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2034778	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153000224	1900010	FRANKLIN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2035470	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000390	2520039	JIM HILL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2035727	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000423	2520089	WINGFIELD HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2035784	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_12	*
2035798	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_12	*
2036243	MS	school	2802220	3200	JEFFERSON CO SCHOOL DIST	280222000427	3200008	JEFFERSON CO HIGH	Regular School	No	High	09	12	2020	grade_12	*
2036678	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001344	3800020	WEST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2036845	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255000494	4100008	MOOREVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2036910	MS	school	2803090	4111	NETTLETON SCHOOL DIST	280309000613	4111004	NETTLETON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2036998	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801512	4211004	AMANDA ELZY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2037380	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279001257	4500046	RIDGELAND HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2037468	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282000545	4600008	EAST MARION HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2037481	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282001247	4600014	WEST MARION HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2037740	MS	school	2803600	5020	PHILADELPHIA PUBLIC SCHOOL DIST	280360000692	5020008	PHILADELPHIA HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2037788	MS	school	2804380	5131	UNION PUBLIC SCHOOL DIST	280438000825	5131004	UNION HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2037817	MS	school	2803300	5200	NOXUBEE COUNTY SCHOOL DISTRICT	280330000642	5200012	NOXUBEE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2037990	MS	school	2803720	5530	POPLARVILLE SEPARATE SCHOOL DIST	280372000708	5530008	POPLARVILLE JR SR HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038025	MS	school	2803570	5600	PERRY CO SCHOOL DIST	280357001071	5600014	PERRY CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038069	MS	school	2803240	5711	NORTH PIKE SCHOOL DIST	280324000636	5711016	NORTH PIKE SENIOR HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038305	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001024	5921012	BOONEVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038379	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001075	6100022	FLORENCE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038461	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000740	6100044	PELAHATCHIE ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_12	*
2038635	MS	school	2801470	6220	FOREST MUNICIPAL SCHOOL DIST	280147000213	6220008	FOREST HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038657	MS	school	2803960	6312	SOUTH DELTA SCHOOL DISTRICT	280396000753	6312008	SOUTH DELTA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038674	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399000755	6400008	MAGEE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038729	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000759	6500008	RALEIGH HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2038777	MS	school	2804170	6600	STONE CO SCHOOL DIST	280417000790	6600012	STONE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038847	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701425	6711026	GENTRY HIGH SCHOOL	Regular School	No	High	10	12	2020	grade_12	*
2038862	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_12	*
2038900	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2038948	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2038964	MS	school	2803930	6920	SENATOBIA MUNICIPAL SCHOOL DIST	280393000751	6920008	SENATOBIA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2038998	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	*
2039078	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2020	grade_12	*
2039228	MS	school	2803120	7320	NEW ALBANY PUBLIC SCHOOLS	280312000615	7320008	NEW ALBANY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2039662	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471000879	7900008	WILKINSON COUNTY HIGH	Regular School	No	High	09	12	2020	grade_12	*
2039738	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2020	grade_12	*
2039762	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480000890	8200004	YAZOO COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	*
2039057	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000778	7012016	RIPLEY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	100	100
2035932	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000949	2900030	ITAWAMBA AGRICULTURAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	103	103
2037514	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000548	4700004	BYHALIA HIGH SCHOOL (9-12)	Regular School	No	High	09	12	2020	grade_12	103	103
2037499	MS	school	2801170	4620	COLUMBIA SCHOOL DISTRICT	280117000149	4620008	COLUMBIA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	104	104
2033594	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	107	107
2036020	MS	school	2803000	3020	MOSS POINT SEPARATE SCHOOL DIST	280300000587	3020004	MOSS POINT HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	107	107
2039685	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000523	8020008	LOUISVILLE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	107	107
2035859	MS	school	2802040	2700	HUMPHREYS CO SCHOOL DIST	280204001041	2700010	HUMPHREYS COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	108	108
2038100	MS	school	2804080	5712	SOUTH PIKE SCHOOL DIST	280408000773	5712028	SOUTH PIKE SENIOR HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	108	108
2037217	MS	school	2801194	4406	MS SCH FOR MATH AND SC	280119401201	4406004	MS SCHOOL FOR MATH AND SCIENCE	Regular School	No	High	11	12	2020	grade_12	110	110
2036892	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255000497	4100028	SHANNON HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	113	113
2037758	MS	school	2803150	5100	NEWTON COUNTY SCHOOL DISTRICT	280315001135	5100012	NEWTON COUNTY HIGH SCHOOL	Regular School	No	Other	01	12	2020	grade_12	113	113
2034673	MS	school	2801510	1802	FORREST COUNTY AG HIGH SCHOOL	280151000222	1802004	FORREST COUNTY AGRICULTURAL HI SCH	Regular School	No	High	09	12	2020	grade_12	114	114
2038513	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000743	6100056	RICHLAND HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	115	115
2039806	MS	school	2804770	8220	YAZOO CITY MUNICIPAL SCHOOL DIST	280477000888	8220020	YAZOO CITY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	115	115
2034972	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057000045	2320008	BAY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	116	116
2036805	MS	school	2802520	4000	LEAKE CO SCHOOL DIST	280252000487	4000004	LEAKE CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	117	117
2039139	MS	school	2804290	7200	TUNICA COUNTY SCHOOL DISTRICT	280429000808	7200008	ROSA FORT HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	117	117
2036770	MS	school	2802490	3900	LAWRENCE CO SCHOOL DIST	280249000482	3900012	LAWRENCE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	127	127
2035530	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000396	2520048	LANIER HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	128	128
2036628	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243000469	3800008	NORTHEAST LAUDERDALE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	128	128
2035275	MS	school	2803510	2423	PASS CHRISTIAN PUBLIC SCHOOL DIST	280351000684	2423012	PASS CHRISTIAN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	129	129
2037164	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273001125	4400004	CALEDONIA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	130	130
2038692	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399001086	6400014	MENDENHALL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	132	132
2034888	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000232	2100014	GREENE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	134	134
2036533	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001172	3700014	PURVIS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	138	138
2035323	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000328	2500040	RAYMOND HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	140	140
2033693	MS	school	2802340	420	KOSCIUSKO SCHOOL DISTRICT	280234000460	420016	KOSCIUSKO SENIOR HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	142	142
2034189	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000118	1420004	CLARKSDALE HIGH SCHOOL	Regular School	No	High	10	12	2020	grade_12	142	142
2037022	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801516	4211016	GREENWOOD HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	149	149
2038226	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000717	5900020	JUMPERTOWN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_12	15	15
2036553	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001173	3700018	SUMRALL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	150	150
2038133	MS	school	2802880	5720	MCCOMB SCHOOL DISTRICT	280288000556	5720012	MCCOMB HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	150	150
2037137	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000092	4320012	BROOKHAVEN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	153	153
2038197	MS	school	2803690	5820	PONTOTOC CITY SCHOOLS	280369000706	5820012	PONTOTOC HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	153	153
2033518	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000608	130044	NATCHEZ HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	155	155
2035993	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001050	3000020	VANCLEAVE HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	159	159
2039030	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000775	7012004	BLUE MOUNTAIN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_12	16	16
2036321	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000443	3400024	NORTHEAST JONES HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	161	161
2033610	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000171	220004	CORINTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	165	165
2035949	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001045	3000006	EAST CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	166	166
2035822	MS	school	2800195	2611	HOLMES CONSOLIDATE SCHOOL DIST	280019501488	2611010	HOLMES COUNTY CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	173	173
2037410	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000101	4520008	CANTON PUBLIC HIGH SCHOOL	Regular School	No	High	10	12	2020	grade_12	176	176
2036352	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000450	3400036	SOUTH JONES HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12	179	179
2034679	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000310	1820008	HATTIESBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	186	186
2037950	MS	school	2803630	5520	PICAYUNE SCHOOL DIST	280363000695	5520016	PICAYUNE MEMORIAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	186	186
2033755	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001477	614009	CLEVELAND CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	188	188
2034593	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001357	1700082	LAKE CORMORANT HIGH	Regular School	No	High	09	12	2020	grade_12	191	191
2036168	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000678	3022052	PASCAGOULA HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	192	192
2037232	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120000154	4420016	COLUMBUS HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	194	194
2039370	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000830	7500025	VICKSBURG HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	196	196
2036405	MS	school	2802460	3420	LAUREL SCHOOL DISTRICT	280246000479	3420040	LAUREL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	198	198
2039597	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000850	7700026	WAYNE COUNTY HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12	198	198
2034136	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101441	1321020	WEST POINT HIGH SCHOOL	Regular School	No	High	08	12	2020	grade_12	199	199