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 (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, rowid 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
2038928	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	25	25
2038944	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	67	67
2038994	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	44	44
2039287	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	105	105
2039407	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	46	46
2039455	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	77	77
2039463	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000976	7613020	RIVERSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	82	82
2039602	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_8	80	80
2039621	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_8	90	90
2039734	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2020	grade_8	44	44
2039742	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8	80	80
2240101	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	43	43
2240177	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	84	84
2240195	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_8	49	49
2240223	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_8	29	29
2240263	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	35	35
2240352	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	69	69
2240369	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501526	618009	WEST BOLIVAR HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	36	36
2240415	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_8	74	74
2240435	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_8	62	62
2240453	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	49	49
2240462	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_8	68	68
2240550	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	97	97
2240668	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101441	1321020	WEST POINT HIGH SCHOOL	Regular School	No	High	08	12	2021	grade_8	261	261
2240676	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	94	94
2241156	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	65	65
2242827	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000443	3400024	NORTHEAST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	161	161
2242859	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000450	3400036	SOUTH JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	229	229
2242877	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000451	3400052	WEST JONES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	294	294
2243110	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001348	3800005	CLARKDALE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	84	84
2243328	MS	school	2802520	4000	LEAKE CO SCHOOL DIST	280252000490	4000016	LEAKE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	61	61
2243533	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801518	4211020	LEFLORE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	65	65
2243676	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273000531	4400012	WEST LOWNDES HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	45	45
2243956	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282000545	4600008	EAST MARION HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	63	63
2243968	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282001247	4600014	WEST MARION HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	112	112
2244058	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000553	4700024	H. W. BYERS HIGH SCHOOL (5-12)	Regular School	No	High	05	12	2021	grade_8	54	54
2244185	MS	school	2800196	4911	WINONA-MONTGOMERY CONSOLIDATED SD	280019601485	4911006	WINONA SECONDARY SCHOOL	Regular School	No	High	07	12	2021	grade_8	106	106
2244226	MS	school	2803600	5020	PHILADELPHIA PUBLIC SCHOOL DIST	280360000692	5020008	PHILADELPHIA HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	63	63
2244244	MS	school	2803150	5100	NEWTON COUNTY SCHOOL DISTRICT	280315001135	5100012	NEWTON COUNTY HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_8	127	127
2244522	MS	school	2803870	5620	RICHTON SCHOOL DIST	280387000744	5620004	RICHTON HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	50	50
2244894	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000739	6100028	MCLAURIN ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_8	92	92
2244945	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000740	6100044	PELAHATCHIE ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_8	63	63
2244973	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001079	6100050	PISGAH HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	77	77
2244980	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000742	6100052	PUCKETT ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_8	58	58
2244998	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000743	6100056	RICHLAND HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	153	153
2245213	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000759	6500008	RALEIGH HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	78	78
2245383	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	61	61
2245408	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423000800	6900012	INDEPENDENCE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	74	74
2245415	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	36	36
2245432	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	63	63
2245775	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	106	106
2245901	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	35	35
2245949	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	108	108
2245957	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000976	7613020	RIVERSIDE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	69	69
2246091	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_8	75	75
2246110	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_8	76	76
2246225	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2021	grade_8	41	41
2246233	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	99	99
2033494	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000602	130028	MORGANTOWN MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	127	127
2033500	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000604	130036	ROBERT LEWIS MAGNET SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	119	119
2033571	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	109	109
2033588	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	122	122
2033617	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000006	220006	CORINTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	187	187
2033677	MS	school	2802340	420	KOSCIUSKO SCHOOL DISTRICT	280234000457	420004	KOSCIUSKO JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	180	180
2033749	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001475	614007	CLEVELAND CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	265	265
2033824	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501432	618008	WEST BOLIVAR DISTRICT MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	40	40
2033984	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000040	920010	HOUSTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	132	132
2034001	MS	school	2803390	921	OKOLONA SEPARATE SCHOOL DIST	280339001482	921012	OKOLONA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	48	48
2034051	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102000115	1100004	PORT GIBSON MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	*
2034063	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000977	1211002	ENTERPRISE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	*
2034084	MS	school	2803780	1212	QUITMAN SCHOOL DIST	280378000723	1212004	QUITMAN JR HIGH SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	128	128
2034193	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000119	1420008	W.A. HIGGINS MIDDLE SCHOOL ACADEMY	Regular School	No	Middle	07	08	2020	grade_8	169	169
2034241	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000167	1500004	CRYSTAL SPRINGS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_8	*
2034274	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000316	1520004	HAZLEHURST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	*
2034310	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000178	1600012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	77	77
2034353	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129001337	1600026	SEMINARY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	115	115
2034395	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000140	1700018	HERNANDO MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	321	321
2034414	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000191	1700024	HORN LAKE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	330	330
2034448	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000194	1700034	OLIVE BRANCH MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	254	254
2034498	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000933	1700048	SOUTHAVEN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	468	468
2034522	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000979	1700054	DESOTO CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	479	479
2034557	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001343	1700064	LEWISBURG MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	320	320
2034578	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001358	1700074	CENTER HILL MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	288	288
2034599	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001282	1700084	LAKE CORMORANT MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	260	260
2034693	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000980	1820030	N R BURGER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	285	285
2034740	MS	school	2803530	1821	PETAL SCHOOL DIST	280353000005	1821004	PETAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	293	293
2034773	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153001111	1900008	FRANKLIN COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	*
2034820	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000840	2000014	GEORGE COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	09	2020	grade_8	289	289
2034862	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159001134	2100004	LEAKESVILLE JR HIGH SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	92	92
2034901	MS	school	2801680	2220	GRENADA SCHOOL DIST	280168000264	2220012	GRENADA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	320	320
2034953	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001232	2300009	HANCOCK MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	343	343
2034967	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057001233	2320007	Bay Waveland Middle School	Regular School	No	Middle	06	08	2020	grade_8	170	170
2035002	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000286	2400004	DIBERVILLE MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_8	177	177
2035049	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177001469	2400030	NORTH GULFPORT MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_8	505	505
2035121	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063001107	2420006	BILOXI JUNIOR HIGH	Regular School	No	Middle	07	08	2020	grade_8	509	509
2035182	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000270	2421012	BAYOU VIEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	273	273
2035195	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000272	2421016	GULFPORT CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	224	224
2035240	MS	school	2802670	2422	LONG BEACH SCHOOL DIST	280267000519	2422012	LONG BEACH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8	*
2035282	MS	school	2803510	2423	PASS CHRISTIAN PUBLIC SCHOOL DIST	280351000685	2423016	PASS CHRISTIAN MIDDLE	Regular School	No	Middle	06	08	2020	grade_8	167	167
2035286	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000321	2500008	BYRAM MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	271	271
2035290	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000322	2500012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_8	*