schools: enrollments: 272 rows where where grade = "grade_7", state = "MS" and year = 2021 sorted by district_nces

Data source: Big Local News · About: Big Local

272 rows where grade = "grade_7", state = "MS" and year = 2021 sorted by district_nces_id

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
2241809	2241809	MS	school	2800183	2480	ROGER AMOS MCMURTRY ADM	280018301317	2480004	ROGER AMOS MCMURTRY SCHOOL	Regular School	No	Secondary	06	11	2021	grade_7	*
2240368	2240368	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501526	618009	WEST BOLIVAR HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	51	51
2240384	2240384	MS	school	2800185	618	WEST BOLIVAR CONS SCHOOL DISTRICT	280018501527	618015	MCEVANS SCHOOL	Regular School	No	Other	KG	12	2021	grade_7	53	53
2240351	2240351	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601411	617010	NORTHSIDE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	83	83
2245297	2245297	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701403	6711011	DREW HUNTER MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	27	27
2245307	2245307	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701430	6711012	INVERNESS SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_7	*
2245310	2245310	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701421	6711014	ROBERT L MERRITT JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	09	2021	grade_7	*
2245323	2245323	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701498	6711018	MOORHEAD CENTRAL SCHOOL	Regular School	No	Elementary	KG	08	2021	grade_7	27	27
2245339	2245339	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701398	6711028	RULEVILLE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	63	63
2241891	2241891	MS	school	2800188	2515	REIMAGINE PREP	280018801442	2515004	REIMAGINE PREP	Regular School	Yes	Middle	05	08	2021	grade_7	177	177
2244343	2244343	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901532	5321030	SOCSD/MSU PARTNERSHIP MIDDLE SCHOOL	Regular School	No	Middle	06	07	2021	grade_7	391	391
2242270	2242270	MS	school	2800190	2525	MIDTOWN PUBLIC CHARTER SCHOOL	280019001448	2525004	MIDTOWN PUBLIC CHARTER SCHOOL	Regular School	Yes	Middle	05	08	2021	grade_7	72	72
2240651	2240651	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101445	1321012	FIFTH STREET SCHOOL	Regular School	No	Middle	05	07	2021	grade_7	222	222
2242276	2242276	MS	school	2800192	2535	SMILOW PREP	280019201471	2535004	JOEL E. SMILOW PREP	Regular School	Yes	Middle	05	08	2021	grade_7	170	170
2242328	2242328	MS	school	2800195	2611	HOLMES CONSOLIDATE SCHOOL DIST	280019501491	2611006	WILLIAMS-SULLIVAN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	105	105
2242344	2242344	MS	school	2800195	2611	HOLMES CONSOLIDATE SCHOOL DIST	280019501528	2611011	S V MARSHALL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	158	158
2244184	2244184	MS	school	2800196	4911	WINONA-MONTGOMERY CONSOLIDATED SD	280019601485	4911006	WINONA SECONDARY SCHOOL	Regular School	No	High	07	12	2021	grade_7	92	92
2243504	2243504	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801513	4211005	AMANDA ELZY JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	121	121
2243532	2243532	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801518	4211020	LEFLORE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	54	54
2243560	2243560	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801522	4211032	GREENWOOD MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	214	214
2244147	2244147	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_7	95	95
2240100	2240100	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	39	39
2240126	2240126	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	100	100
2240143	2240143	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	98	98
2240176	2240176	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042000027	300008	AMITE COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	70	70
2244164	2244164	MS	school	2800450	4821	AMORY SCHOOL DIST	280045000030	4821012	AMORY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	127	127
2240194	2240194	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000036	400008	ETHEL ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_7	52	52
2240222	2240222	MS	school	2800510	400	ATTALA CO SCHOOL DIST	280051000039	400020	MCADAMS ATTENDANCE CENTER	Regular School	No	High	07	12	2021	grade_7	29	29
2244782	2244782	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000043	5920012	BALDWYN MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	52	52
2241489	2241489	MS	school	2800570	2320	BAY ST LOUIS WAVELAND SCHOOL DIST	280057001233	2320007	Bay Waveland Middle School	Regular School	No	Middle	06	08	2021	grade_7	*
2240262	2240262	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000049	500006	ASHLAND MIDDLE-HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	31	31
2240278	2240278	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000050	500008	HICKORY FLAT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_7	45	45
2241644	2241644	MS	school	2800630	2420	BILOXI PUBLIC SCHOOL DIST	280063001107	2420006	BILOXI JUNIOR HIGH	Regular School	No	Middle	07	08	2021	grade_7	507	507
2240301	2240301	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075001475	614007	CLEVELAND CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	253	253
2244789	2244789	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001329	5921004	R.H. LONG BOONEVILLE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	*
2243631	2243631	MS	school	2800840	4320	BROOKHAVEN SCHOOL DIST	280084000090	4320004	ALEXANDER JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	231	231
2240414	2240414	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000097	700006	BRUCE HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_7	81	81
2240434	2240434	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000098	700010	CALHOUN CITY HIGH SCHOOL	Regular School	No	High	05	12	2021	grade_7	69	69
2240452	2240452	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087000099	700014	VARDAMAN HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	39	39
2243919	2243919	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000103	4520016	NICHOLS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	131	131
2243924	2243924	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090001394	4520018	HUEY L. PORTER MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	131	131
2240461	2240461	MS	school	2800930	800	CARROLL COUNTY SCHOOL DIST	280093000104	800004	J Z GEORGE HIGH SCHOOL	Regular School	No	High	06	12	2021	grade_7	88	88
2240489	2240489	MS	school	2800960	900	CHICKASAW CO SCHOOL DIST	280096000108	900004	HOULKA ATTENDANCE CENTER	Regular School	No	Other	PK	12	2021	grade_7	39	39
2240549	2240549	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000111	1000008	CHOCTAW COUNTY HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	89	89
2240586	2240586	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102000115	1100004	PORT GIBSON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	106	106
2240727	2240727	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000119	1420008	W.A. HIGGINS MIDDLE SCHOOL ACADEMY	Regular School	No	Middle	07	08	2021	grade_7	209	209
2242246	2242246	MS	school	2801090	2521	CLINTON PUBLIC SCHOOL DIST	280109000132	2521008	CLINTON JR HI SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	451	451
2240675	2240675	MS	school	2801110	1400	COAHOMA COUNTY SCHOOL DISTRICT	280111000139	1400004	COAHOMA COUNTY JR/SR HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	103	103
2246223	2246223	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114001108	8111004	COFFEEVILLE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	07	2021	grade_7	42	42
2243998	2243998	MS	school	2801170	4620	COLUMBIA SCHOOL DISTRICT	280117000151	4620016	JEFFERSON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	119	119
2242292	2242292	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_7	*
2242304	2242304	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_7	*
2243732	2243732	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120001380	4420018	COLUMBUS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	279	279
2240778	2240778	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000167	1500004	CRYSTAL SPRINGS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_7	120	120
2240801	2240801	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122000169	1500012	WESSON ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_7	82	82
2240172	2240172	MS	school	2801260	220	CORINTH SCHOOL DIST	280126000006	220006	CORINTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	198	198
2240845	2240845	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000178	1600012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	63	63
2240865	2240865	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000181	1600020	MOUNT OLIVE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_7	28	28
2240887	2240887	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129001337	1600026	SEMINARY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	127	127
2240927	2240927	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000140	1700018	HERNANDO MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	365	365
2240945	2240945	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000191	1700024	HORN LAKE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	380	380
2240978	2240978	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000194	1700034	OLIVE BRANCH MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	*
2241030	2241030	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000933	1700048	SOUTHAVEN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	479	479
2241053	2241053	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132000979	1700054	DESOTO CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	472	472
2241088	2241088	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001343	1700064	LEWISBURG MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	310	310
2241109	2241109	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001358	1700074	CENTER HILL MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	276	276
2241130	2241130	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001282	1700084	LAKE CORMORANT MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	262	262
2242706	2242706	MS	school	2801380	3111	EAST JASPER CONSOLIDATED SCH DIST	280138001315	3111010	HEIDELBERG JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	79	79
2245369	2245369	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000208	6811012	CHARLESTON MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	86	86
2240598	2240598	MS	school	2801440	1211	ENTERPRISE SCHOOL DIST	280144000977	1211002	ENTERPRISE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	69	69
2245129	2245129	MS	school	2801470	6220	FOREST MUNICIPAL SCHOOL DIST	280147000214	6220012	HAWKINS MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	135	135
2241142	2241142	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000216	1800008	DIXIE ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_7	62	62
2241155	2241155	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000218	1800012	NORTH FORREST HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	71	71
2241185	2241185	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000220	1800028	SOUTH FORREST ATTENDANCE CENTER	Regular School	No	Elementary	PK	08	2021	grade_7	68	68
2241198	2241198	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000221	1800036	EARL TRAVILLION ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_7	30	30
2241304	2241304	MS	school	2801530	1900	FRANKLIN CO SCHOOL DIST	280153001111	1900008	FRANKLIN COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	*
2241352	2241352	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000840	2000014	GEORGE COUNTY MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	304	304
2241392	2241392	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159001134	2100004	LEAKESVILLE JR HIGH SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	96	96
2241402	2241402	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000233	2100008	MC LAIN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_7	20	20
2241413	2241413	MS	school	2801590	2100	GREENE COUNTY SCHOOL DISTRICT	280159000234	2100012	SAND HILL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_7	37	37
2245983	2245983	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000240	7620020	COLEMAN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	143	143
2246020	2246020	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162001361	7620068	T.L. WESTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	186	186
2241431	2241431	MS	school	2801680	2220	GRENADA SCHOOL DIST	280168000264	2220012	GRENADA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	315	315
2241704	2241704	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000270	2421012	BAYOU VIEW MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	324	324
2241717	2241717	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000272	2421016	GULFPORT CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	230	230
2241477	2241477	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174001232	2300009	HANCOCK MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	336	336
2241525	2241525	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000286	2400004	DIBERVILLE MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_7	193	193
2241572	2241572	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177001469	2400030	NORTH GULFPORT MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	569	569
2241582	2241582	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000958	2400038	NORTH WOOLMARKET ELEMENTARY AND MID	Regular School	No	Elementary	KG	08	2021	grade_7	174	174
2241628	2241628	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000959	2400051	WEST WORTHAM ELEMENTARY AND MIDDLE	Regular School	No	Elementary	KG	08	2021	grade_7	265	265
2241224	2241224	MS	school	2801800	1820	HATTIESBURG PUBLIC SCHOOL DIST	280180000980	1820030	N R BURGER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	288	288
2240810	2240810	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000316	1520004	HAZLEHURST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	*
2241818	2241818	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000321	2500008	BYRAM MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	321	321
2241822	2241822	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000322	2500012	CARVER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	*
2241845	2241845	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000326	2500028	UTICA ELEM. / MIDDLE SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_7	32	32
2241880	2241880	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000984	2500044	BOLTON-EDWARDS ELEM./MIDDLE SCHOOL	Regular School	No	Elementary	PK	08	2021	grade_7	37	37
2245900	2245900	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2021	grade_7	44	44
2244071	2244071	MS	school	2801950	4720	HOLLY SPRINGS SCHOOL DIST	280195001248	4720007	HOLLY SPRINGS JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	110	110
2240518	2240518	MS	school	2802010	920	HOUSTON SCHOOL DIST	280201000040	920010	HOUSTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	155	155
2242370	2242370	MS	school	2802040	2700	HUMPHREYS CO SCHOOL DIST	280204001039	2700006	O M MC NAIR MIDDLE SCHOOL	Regular School	No	Middle	05	08	2021	grade_7	133	133

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]);