schools: enrollments: 276 rows where where grade = "grade_7", state = "MS" and year = 2020 sorted by rowid descending

Data source: Big Local News · About: Big Local

276 rows where grade = "grade_7", state = "MS" and year = 2020 sorted by rowid descending

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
2039800	2039800	MS	school	2804770	8220	YAZOO CITY MUNICIPAL SCHOOL DIST	280477000887	8220016	BETTIE E WOOLFOLK MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	214	214
2039766	2039766	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480001581	8200007	YAZOO COUNTY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	138	138
2039741	2039741	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450000845	8113004	WATER VALLEY HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	99	99
2039732	2039732	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114001108	8111004	COFFEEVILLE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	07	2020	grade_7	38	38
2039715	2039715	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000527	8020020	NOXAPATER ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	43	43
2039700	2039700	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000526	8020016	NANIH WAIYA ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	46	46
2039689	2039689	MS	school	2802700	8020	LOUISVILLE MUNICIPAL SCHOOL DIST	280270000524	8020012	EILAND MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	146	146
2039666	2039666	MS	school	2804710	7900	WILKINSON CO SCHOOL DIST	280471001580	7900012	WILLIAM WINANS MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	*
2039620	2039620	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456001097	7800010	EUPORA HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_7	79	79
2039601	2039601	MS	school	2804560	7800	WEBSTER CO SCHOOL DIST	280456000852	7800004	EAST WEBSTER HIGH SCHOOL	Regular School	No	High	06	12	2020	grade_7	75	75
2039591	2039591	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000849	7700024	WAYNE CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	55	55
2039577	2039577	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000851	7700020	WAYNESBORO RIVERVIEW ELE SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	54	54
2039565	2039565	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000848	7700016	CLARA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	61	61
2039551	2039551	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000898	7700012	BUCKATUNNA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	58	58
2039539	2039539	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000846	7700004	BEAT FOUR ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	54	54
2039526	2039526	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162001361	7620068	T.L. WESTON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	182	182
2039489	2039489	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000240	7620020	COLEMAN MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	160	160
2039462	2039462	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000976	7613020	RIVERSIDE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	74	74
2039454	2039454	MS	school	2804680	7613	WESTERN LINE SCHOOL DISTRICT	280468000975	7613016	O'BANNON HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	114	114
2039425	2039425	MS	school	2802610	7612	LELAND SCHOOL DIST	280261001472	7612008	LELAND SCHOOL PARK	Regular School	No	Middle	06	08	2020	grade_7	54	54
2039406	2039406	MS	school	2801890	7611	HOLLANDALE SCHOOL DIST	280189001037	7611012	SIMMONS HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	39	39
2039383	2039383	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000843	7500030	WARREN CENTRAL JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	349	349
2039373	2039373	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000831	7500026	VICKSBURG JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	256	256
2039286	2039286	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000836	7400016	TYLERTOWN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	112	112
2039266	2039266	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000834	7400008	SALEM ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	32	32
2039255	2039255	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000833	7400004	DEXTER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2020	grade_7	14	14
2039244	2039244	MS	school	2803120	7320	NEW ALBANY PUBLIC SCHOOLS	280312000618	7320016	NEW ALBANY MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	173	173
2039217	2039217	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000824	7300016	WEST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_7	55	55
2039200	2039200	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000823	7300012	MYRTLE ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_7	54	54
2039182	2039182	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000822	7300008	INGOMAR ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_7	66	66
2039165	2039165	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000821	7300004	EAST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_7	73	73
2039144	2039144	MS	school	2804290	7200	TUNICA COUNTY SCHOOL DISTRICT	280429000809	7200012	TUNICA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	131	131
2039109	2039109	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426001226	7100020	IUKA MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	119	119
2039098	2039098	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000805	7100012	TISHOMINGO ELEMENTARY	Regular School	No	Elementary	KG	08	2020	grade_7	33	33
2039088	2039088	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000804	7100008	BURNSVILLE ELEMENTARY	Regular School	No	Elementary	KG	08	2020	grade_7	42	42
2039073	2039073	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2020	grade_7	76	76
2039063	2039063	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000779	7012020	RIPLEY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	*
2039040	2039040	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000776	7012008	PINE GROVE HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_7	55	55
2039025	2039025	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000775	7012004	BLUE MOUNTAIN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_7	25	25
2039008	2039008	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000640	7011012	WALNUT ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	31	31
2038993	2038993	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000638	7011008	FALKNER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	39	39
2038980	2038980	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000637	7011004	CHALYBEATE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	28	28
2038969	2038969	MS	school	2803930	6920	SENATOBIA MUNICIPAL SCHOOL DIST	280393001083	6920012	SENATOBIA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	*
2038943	2038943	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001295	6900024	STRAYHORN HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	72	72
2038927	2038927	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001508	6900014	COLDWATER HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	36	36
2038920	2038920	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423000800	6900012	INDEPENDENCE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	74	74
2038895	2038895	MS	school	2804650	6812	WEST TALLAHATCHIE SCHOOL DISTRICT	280465000873	6812036	WEST TALLAHATCHIE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	60	60
2038882	2038882	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000208	6811012	CHARLESTON MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	84	84
2038851	2038851	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701398	6711028	RULEVILLE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	74	74
2038835	2038835	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701498	6711018	MOORHEAD CENTRAL SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	21	21
2038821	2038821	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701421	6711014	ROBERT L MERRITT JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	09	2020	grade_7	151	151
2038818	2038818	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701430	6711012	INVERNESS SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	18	18
2038807	2038807	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701403	6711011	DREW HUNTER MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	52	52
2038782	2038782	MS	school	2804170	6600	STONE CO SCHOOL DIST	280417000791	6600016	STONE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	216	216
2038750	2038750	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000762	6500012	TAYLORSVILLE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	62	62
2038724	2038724	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000759	6500008	RALEIGH HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	85	85
2038716	2038716	MS	school	2804020	6500	SMITH CO SCHOOL DIST	280402000758	6500004	MIZE ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	74	74
2038706	2038706	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399000757	6400020	SIMPSON CENTRAL SCHOOL	Regular School	No	Elementary	KG	08	2020	grade_7	67	67
2038696	2038696	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399001087	6400016	MENDENHALL JUNIOR HIGH SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	102	102
2038679	2038679	MS	school	2803990	6400	SIMPSON CO SCHOOL DIST	280399001085	6400010	MAGEE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	147	147
2038661	2038661	MS	school	2803960	6312	SOUTH DELTA SCHOOL DISTRICT	280396000383	6312010	SOUTH DELTA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	56	56
2038641	2038641	MS	school	2801470	6220	FOREST MUNICIPAL SCHOOL DIST	280147000214	6220012	HAWKINS MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	125	125
2038602	2038602	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390000749	6200020	SEBASTOPOL ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	60	60
2038586	2038586	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390000748	6200016	SCOTT CENTRAL ATTENDANCE CENTER	Regular School	No	Other	KG	12	2020	grade_7	72	72
2038568	2038568	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001145	6200010	BETTYE MAE JACK MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	*
2038553	2038553	MS	school	2803900	6200	SCOTT CO SCHOOL DIST	280390001144	6200006	LAKE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	76	76
2038546	2038546	MS	school	2803520	6120	PEARL PUBLIC SCHOOL DIST	280352001354	6120016	PEARL JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	365	365
2038508	2038508	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000743	6100056	RICHLAND HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	164	164
2038491	2038491	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000742	6100052	PUCKETT ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_7	59	59
2038484	2038484	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383001079	6100050	PISGAH HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	77	77
2038456	2038456	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000740	6100044	PELAHATCHIE ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_7	69	69
2038405	2038405	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000739	6100028	MCLAURIN ATTENDANCE CENTER	Regular School	No	High	07	12	2020	grade_7	97	97
2038401	2038401	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000955	6100026	NORTHWEST RANKIN MIDDLE SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	478	478
2038373	2038373	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000738	6100020	FLORENCE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	*
2038357	2038357	MS	school	2803830	6100	RANKIN CO SCHOOL DIST	280383000737	6100016	BRANDON MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	442	442
2038333	2038333	MS	school	2803810	6000	QUITMAN CO SCHOOL DIST	280381000734	6000032	QUITMAN COUNTY MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	68	68
2038299	2038299	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001329	5921004	R.H. LONG BOONEVILLE MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	112	112
2038288	2038288	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000042	5920008	BALDWYN HIGH SCHOOL	Regular School	No	High	05	12	2020	grade_7	65	65
2038271	2038271	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000722	5900036	WHEELER HIGH SCHOOL	Regular School	No	Other	KG	12	2020	grade_7	43	43
2038255	2038255	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000721	5900032	THRASHER HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_7	38	38
2038238	2038238	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000718	5900024	MARIETTA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	35	35
2038221	2038221	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000717	5900020	JUMPERTOWN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_7	32	32
2038209	2038209	MS	school	2803750	5900	PRENTISS CO SCHOOL DIST	280375000716	5900016	HILLS CHAPEL SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_7	50	50
2038190	2038190	MS	school	2803690	5820	PONTOTOC CITY SCHOOLS	280369001162	5820010	PONTOTOC JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	182	182
2038168	2038168	MS	school	2803660	5800	PONTOTOC CO SCHOOL DIST	280366001011	5800007	South Pontotoc Middle School	Regular School	No	Middle	06	08	2020	grade_7	*
2038144	2038144	MS	school	2803660	5800	PONTOTOC CO SCHOOL DIST	280366001009	5800003	North Pontotoc Middle School	Regular School	No	Middle	07	08	2020	grade_7	*
2038126	2038126	MS	school	2802880	5720	MCCOMB SCHOOL DISTRICT	280288000972	5720010	DENMAN JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	195	195
2038094	2038094	MS	school	2804080	5712	SOUTH PIKE SCHOOL DIST	280408000772	5712024	SOUTH PIKE JR HIGH	Regular School	No	Middle	07	08	2020	grade_7	148	148
2038063	2038063	MS	school	2803240	5711	NORTH PIKE SCHOOL DIST	280324000635	5711012	NORTH PIKE MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	198	198
2038035	2038035	MS	school	2803870	5620	RICHTON SCHOOL DIST	280387000744	5620004	RICHTON HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7	55	55
2038019	2038019	MS	school	2803570	5600	PERRY CO SCHOOL DIST	280357000689	5600012	PERRY CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	107	107
2037995	2037995	MS	school	2803720	5530	POPLARVILLE SEPARATE SCHOOL DIST	280372000992	5530009	MIDDLE SCHOOL OF POPLARVILLE	Regular School	No	Middle	06	08	2020	grade_7	159	159
2037942	2037942	MS	school	2803630	5520	PICAYUNE SCHOOL DIST	280363000697	5520012	PICAYUNE JUNIOR HIGH SCHOOL	Regular School	No	Middle	07	08	2020	grade_7	290	290
2037917	2037917	MS	school	2803540	5500	PEARL RIVER CO SCHOOL DIST	280354001069	5500008	PEARL RIVER CENTRAL JUNIOR HIGH	Regular School	No	Middle	06	08	2020	grade_7	295	295
2037898	2037898	MS	school	2804050	5412	SOUTH PANOLA SCHOOL DISTRICT	280405000765	5412012	POPE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2020	grade_7	68	68
2037888	2037888	MS	school	2804050	5412	SOUTH PANOLA SCHOOL DISTRICT	280405000764	5412008	BATESVILLE JUNIOR HIGH SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	268	268
2037862	2037862	MS	school	2803210	5411	NORTH PANOLA SCHOOLS	280321001339	5411006	NORTH PANOLA MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	103	103
2037844	2037844	MS	school	2800189	5321	STARKVILLE- OKTIBBEHA CONS SD	280018901453	5321020	ARMSTRONG MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	376	376
2037811	2037811	MS	school	2803300	5200	NOXUBEE COUNTY SCHOOL DISTRICT	280330000643	5200010	B F LIDDELL MIDDLE SCHOOL	Regular School	No	Middle	06	08	2020	grade_7	142	142
2037781	2037781	MS	school	2804380	5131	UNION PUBLIC SCHOOL DIST	280438001327	5131003	UNION MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7	73	73

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