schools: enrollments: 273 rows where where grade = "grade_8", state = "MS" and year = 2021 sorted by total

Data source: Big Local News · About: Big Local

273 rows where grade = "grade_8", state = "MS" and year = 2021 sorted by total_int

Search:

descending

Link	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 ▼
2240233	2240233	MS	school	2802340	420	KOSCIUSKO SCHOOL DISTRICT	280234000457	420004	KOSCIUSKO JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2240728	2240728	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000119	1420008	W.A. HIGGINS MIDDLE SCHOOL ACADEMY	Regular School	No	Middle	07	08	2021	grade_8	*
2240928	2240928	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000140	1700018	HERNANDO MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2241089	2241089	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001343	1700064	LEWISBURG MIDDLE	Regular School	No	Middle	06	08	2021	grade_8	*
2241110	2241110	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001358	1700074	CENTER HILL MIDDLE	Regular School	No	Middle	06	08	2021	grade_8	*
2241131	2241131	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001282	1700084	LAKE CORMORANT MIDDLE	Regular School	No	Middle	06	08	2021	grade_8	*
2241353	2241353	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000840	2000014	GEORGE COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2241810	2241810	MS	school	2800183	2480	ROGER AMOS MCMURTRY ADM	280018301317	2480004	ROGER AMOS MCMURTRY SCHOOL	Regular School	No	Secondary	06	11	2021	grade_8	*
2242084	2242084	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001365	2520055	KIRKSEY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2242223	2242223	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000421	2520086	WHITTEN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2242293	2242293	MS	school	2801189	2560	MS SCH FOR THE BLIND AND DEAF	280118901504	2560002	MS SCHOOL FOR THE DEAF	Special Education School	No	Other	PK	12	2021	grade_8	*
2242305	2242305	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	grade_8	*
2242314	2242314	MS	school	2801191	2562	MDHS DIVISION OF YOUTH SERVICES	280119101197	2562008	WILLIAMS SCHOOL	Regular School	No	Other	04	12	2021	grade_8	*
2242645	2242645	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000675	3022040	GAUTIER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2242762	2242762	MS	school	2802220	3200	JEFFERSON CO SCHOOL DIST	280222001292	3200012	JEFFERSON CO JR HI	Regular School	No	Middle	07	08	2021	grade_8	*
2243050	2243050	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001316	3700017	SUMRALL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2243426	2243426	MS	school	2803090	4111	NETTLETON SCHOOL DIST	280309001160	4111010	NETTLETON INTERMEDIATE SCHOOL	Regular School	No	Middle	04	08	2021	grade_8	*
2243632	2243632	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000090	4320004	ALEXANDER JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2243920	2243920	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000103	4520016	NICHOLS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2244206	2244206	MS	school	2803060	5000	NESHOBA COUNTY SCHOOL DISTRICT	280306000990	5000006	NESHOBA CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2244261	2244261	MS	school	2803180	5130	NEWTON MUNICIPAL SCHOOL DISTRICT	280318001179	5130006	N H PILATE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2244613	2244613	MS	school	2802880	5720	MCCOMB SCHOOL DISTRICT	280288000972	5720010	DENMAN JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2244824	2244824	MS	school	2803810	6000	QUITMAN CO SCHOOL DIST	280381000734	6000032	QUITMAN COUNTY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_8	*
2244862	2244862	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000738	6100020	FLORENCE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2245866	2245866	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000831	7500026	VICKSBURG JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2245876	2245876	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000843	7500030	WARREN CENTRAL JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	*
2246156	2246156	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471001580	7900012	WILLIAM WINANS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2246179	2246179	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000524	8020012	EILAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	*
2245743	2245743	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000833	7400004	DEXTER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	12	12
2245308	2245308	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701430	6711012	INVERNESS SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	17	17
2241403	2241403	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000233	2100008	MC LAIN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	19	19
2243002	2243002	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240000464	3700004	BAXTERVILLE SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	19	19
2245324	2245324	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701498	6711018	MOORHEAD CENTRAL SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	21	21
2245514	2245514	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000775	7012004	BLUE MOUNTAIN HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	22	22
2240223	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
2240866	2240866	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	29	29
2245469	2245469	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000637	7011004	CHALYBEATE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	29	29
2244726	2244726	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000718	5900024	MARIETTA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	30	30
2245586	2245586	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000805	7100012	TISHOMINGO ELEMENTARY	Regular School	No	Elementary	KG	08	2021	grade_8	31	31
2244710	2244710	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000717	5900020	JUMPERTOWN HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	33	33
2245497	2245497	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000640	7011012	WALNUT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	34	34
2240263	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
2245754	2245754	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000834	7400008	SALEM ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	35	35
2245901	2245901	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	35	35
2240369	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
2240385	2240385	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501527	618015	MCEVANS SCHOOL	Regular School	No	Other	KG	12	2021	grade_8	36	36
2240537	2240537	MS	school	2803390	921	OKOLONA SEPARATE SCHOOL DIST	280339001482	921012	OKOLONA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	36	36
2241414	2241414	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000234	2100012	SAND HILL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	36	36
2245415	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
2242737	2242737	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000859	3112012	STRINGER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	39	39
2242772	2242772	MS	school	2802250	3300	JEFFERSON DAVIS CO SCHOOL DIST	280225000430	3300004	CARVER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	39	39
2241846	2241846	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000326	2500028	UTICA ELEM. / MIDDLE SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	40	40
2242432	2242432	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000362	2900028	TREMONT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	40	40
2244743	2244743	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000721	5900032	THRASHER HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	40	40
2243284	2243284	MS	school	2802490	3900	LAWRENCE CO SCHOOL DIST	280249000483	3900016	NEW HEBRON ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_8	41	41
2245481	2245481	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327001534	7011007	FALKNER ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_8	41	41
2246225	2246225	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114000146	8111006	COFFEEVILLE HIGH SCHOOL	Regular School	No	High	08	12	2021	grade_8	41	41
2240101	2240101	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	43	43
2245576	2245576	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000804	7100008	BURNSVILLE ELEMENTARY	Regular School	No	Elementary	KG	08	2021	grade_8	43	43
2240279	2240279	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	45	45
2243676	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
2244759	2244759	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000722	5900036	WHEELER HIGH SCHOOL	Regular School	No	Other	KG	12	2021	grade_8	45	45
2246044	2246044	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000898	7700012	BUCKATUNNA ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	45	45
2241199	2241199	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000221	1800036	EARL TRAVILLION ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_8	47	47
2244124	2244124	MS	school	2802940	4800	MONROE CO SCHOOL DIST	280294000582	4800020	SMITHVILLE HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	47	47
2246191	2246191	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000526	8020016	NANIH WAIYA ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	47	47
2243094	2243094	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240001507	3700025	LUMBERTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	48	48
2243294	2243294	MS	school	2802490	3900	LAWRENCE CO SCHOOL DIST	280249000485	3900024	TOPEKA TILTON ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_8	48	48
2246033	2246033	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000846	7700004	BEAT FOUR ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	48	48
2246207	2246207	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000527	8020020	NOXAPATER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	48	48
2240195	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
2240453	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
2241143	2241143	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000216	1800008	DIXIE ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_8	49	49
2243362	2243362	MS	school	2802550	4100	LEE COUNTY SCHOOL DISTRICT	280255000495	4100016	PLANTERSVILLE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_8	49	49
2244034	2244034	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000551	4700016	POTTS CAMP HIGH SCHOOL (4-12)	Regular School	No	Other	04	12	2021	grade_8	49	49
2244698	2244698	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000716	5900016	HILLS CHAPEL SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	49	49
2245298	2245298	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701403	6711011	DREW HUNTER MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	49	49
2246068	2246068	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000851	7700020	WAYNESBORO RIVERVIEW ELE SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	49	49
2241881	2241881	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000984	2500044	BOLTON-EDWARDS ELEM./MIDDLE SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_8	50	50
2244093	2244093	MS	school	2802940	4800	MONROE CO SCHOOL DIST	280294000580	4800012	HAMILTON HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	50	50
2244522	2244522	MS	school	2803870	5620	RICHTON SCHOOL DIST	280387000744	5620004	RICHTON HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_8	50	50
2245920	2245920	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001472	7612008	LELAND SCHOOL PARK	Regular School	No	Middle	06	08	2021	grade_8	50	50
2246081	2246081	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000849	7700024	WAYNE CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	50	50
2240490	2240490	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_8	51	51
2245529	2245529	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000776	7012008	PINE GROVE HIGH SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	51	51
2245706	2245706	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000824	7300016	WEST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_8	51	51
2244058	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
2245150	2245150	MS	school	2803960	6312	SOUTH DELTA SCHOOL DISTRICT	280396000383	6312010	SOUTH DELTA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	56	56
2245689	2245689	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000823	7300012	MYRTLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_8	56	56
2245195	2245195	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399000757	6400020	SIMPSON CENTRAL SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	57	57
2243800	2243800	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279000989	4500014	SHIRLEY D. SIMMONS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_8	58	58
2244980	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
2245092	2245092	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390000749	6200020	SEBASTOPOL ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_8	58	58
2245239	2245239	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000762	6500012	TAYLORSVILLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_8	58	58
2242726	2242726	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000899	3112010	BAY SPRINGS MIDDLE SCH	Regular School	No	Middle	06	08	2021	grade_8	60	60
2243574	2243574	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000512	4300004	BOGUE CHITTO SCHOOL	Regular School	No	Other	PK	12	2021	grade_8	60	60
2243588	2243588	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000513	4300008	ENTERPRISE SCHOOL	Regular School	No	Other	KG	12	2021	grade_8	60	60
2246057	2246057	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000848	7700016	CLARA ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_8	60	60
2241823	2241823	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000322	2500012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_8	61	61
2243328	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

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);