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

Data source: Big Local News · About: Big Local

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

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
2240050	2240050	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000602	130028	MORGANTOWN MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	100	100
2240056	2240056	MS	school	2803030	130	NATCHEZ-ADAMS SCHOOL DIST	280303000604	130036	ROBERT LEWIS MAGNET SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	109	109
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
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
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
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
2240232	2240232	MS	school	2802340	420	KOSCIUSKO SCHOOL DISTRICT	280234000457	420004	KOSCIUSKO JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	197	197
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
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
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
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
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
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
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
2240536	2240536	MS	school	2803390	921	OKOLONA SEPARATE SCHOOL DIST	280339001482	921012	OKOLONA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	52	52
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
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
2240619	2240619	MS	school	2803780	1212	QUITMAN SCHOOL DIST	280378000723	1212004	QUITMAN JR HIGH SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	153	153
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
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
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
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
2240810	2240810	MS	school	2801830	1520	HAZLEHURST CITY SCHOOL DISTRICT	280183000316	1520004	HAZLEHURST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	*
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
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
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
2241271	2241271	MS	school	2803530	1821	PETAL SCHOOL DIST	280353000005	1821004	PETAL MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	368	368
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
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
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
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	*
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
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
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
2241763	2241763	MS	school	2802670	2422	LONG BEACH SCHOOL DIST	280267000519	2422012	LONG BEACH MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	*
2241805	2241805	MS	school	2803510	2423	PASS CHRISTIAN PUBLIC SCHOOL DIST	280351000685	2423016	PASS CHRISTIAN MIDDLE	Regular School	No	Middle	06	08	2021	grade_7	*
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	*
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
2241891	2241891	MS	school	2800188	2515	REIMAGINE PREP	280018801442	2515004	REIMAGINE PREP	Regular School	Yes	Middle	05	08	2021	grade_7	177	177
2241902	2241902	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001385	2520006	BAILEY MIDDLE APAC SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	136	136
2241915	2241915	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000372	2520010	BLACKBURN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	209	209
2241928	2241928	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000375	2520014	BRINKLEY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	132	132
2241947	2241947	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000380	2520023	CHASTAIN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	185	185
2242069	2242069	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001155	2520052	NORTHWEST MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	110	110
2242083	2242083	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001365	2520055	KIRKSEY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	104	104
2242128	2242128	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000405	2520062	PEEPLES MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	122	122
2242133	2242133	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000407	2520065	POWELL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	152	152
2242217	2242217	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001370	2520085	CARDOZO MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	232	232
2242222	2242222	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000421	2520086	WHITTEN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	128	128
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
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
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
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
2242405	2242405	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000358	2900012	ITAWAMBA ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2021	grade_7	154	154
2242416	2242416	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000361	2900024	MANTACHIE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_7	96	96
2242431	2242431	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000362	2900028	TREMONT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2021	grade_7	28	28
2242452	2242452	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216000364	3000004	EAST CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	*
2242497	2242497	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216001049	3000018	VANCLEAVE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	183	183
2242516	2242516	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216000963	3000024	ST. MARTIN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	340	340
2242546	2242546	MS	school	2803000	3020	MOSS POINT SEPARATE SCHOOL DIST	280300000592	3020028	MAGNOLIA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2021	grade_7	*
2242576	2242576	MS	school	2803360	3021	OCEAN SPRINGS SCHOOL DIST	280336000934	3021022	OCEAN SPRINGS MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	474	474
2242625	2242625	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000671	3022024	WILLIAM M COLMER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	302	302
2242644	2242644	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000675	3022040	GAUTIER MIDDLE SCHOOL	Regular School	No	Middle	07	08	2021	grade_7	238	238
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

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