schools: enrollments: 413 rows where where grade = "grade_2", state = "MS" and year = 2020 sorted by school

Data source: Big Local News · About: Big Local

413 rows where grade = "grade_2", state = "MS" and year = 2020 sorted by school

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
2038801	2038801	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701410	6711010	A W JAMES ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	39	39
2034043	2034043	MS	school	2801020	1100	CLAIBORNE CO SCHOOL DIST	280102001213	1100002	A. W. WATSON ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_2	92	92
2037645	2037645	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	grade_2	78	78
2034007	2034007	MS	school	2800990	1000	CHOCTAW CO SCHOOL DIST	280099000110	1000004	ACKERMAN ELEM	Regular School	No	Elementary	PK	06	2020	grade_2	55	55
2034787	2034787	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000226	2000004	AGRICOLA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	60	60
2039471	2039471	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000236	7620004	AKIN ELEMENTARY SCHOOL	Regular School	No	Elementary	01	05	2020	grade_2	83	83
2033557	2033557	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	88	88
2033632	2033632	MS	school	2800420	300	AMITE CO SCHOOL DIST	280042001375	300014	AMITE COUNTY ELEMENTARY	Regular School	No	Elementary	KG	06	2020	grade_2	68	68
2038312	2038312	MS	school	2800820	5921	BOONEVILLE SCHOOL DIST	280082001025	5921016	ANDERSON ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	101	101
2037333	2037333	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279001081	4500024	ANN SMITH ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_2	227	227
2035167	2035167	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000268	2421004	ANNISTON AVENUE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	98	98
2036082	2036082	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000666	3022004	ARLINGTON HEIGHTS ELEM SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	59	59
2039477	2039477	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000237	7620008	ARMSTRONG ELEMENTARY SCHOOL	Regular School	No	Elementary	01	05	2020	grade_2	40	40
2033703	2033703	MS	school	2800600	500	BENTON CO SCHOOL DIST	280060000048	500004	ASHLAND ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	*
2035373	2035373	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000370	2520007	BAKER ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	51	51
2038282	2038282	MS	school	2800540	5920	BALDWYN SCHOOL DISTRICT	280054000041	5920004	BALDWYN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	04	2020	grade_2	*
2036989	2036989	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801511	4211003	BANKSTON ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	51	51
2035361	2035361	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001052	2520004	BARACK H OBAMA ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	35	35
2035381	2035381	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000371	2520008	BARR ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	28	28
2035503	2035503	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219001364	2520043	BATES ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	57	57
2037881	2037881	MS	school	2804050	5412	SOUTH PANOLA SCHOOL DISTRICT	280405001089	5412006	BATESVILLE INTERMEDIATE SCHOOL	Regular School	No	Elementary	02	03	2020	grade_2	285	285
2036492	2036492	MS	school	2802400	3700	LAMAR COUNTY SCHOOL DISTRICT	280240000464	3700004	BAXTERVILLE SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	32	32
2036202	2036202	MS	school	2804590	3112	WEST JASPER CONSOLIDATED SCHOOLS	280459000858	3112004	BAY SPRINGS ELEM SCH	Regular School	No	Elementary	KG	05	2020	grade_2	*
2035175	2035175	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000269	2421008	BAYOU VIEW ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	116	116
2036088	2036088	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000667	3022008	BEACH ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	04	2020	grade_2	22	22
2039534	2039534	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000846	7700004	BEAT FOUR ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	43	43
2039318	2039318	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447001186	7500006	BEECHWOOD ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	71	71
2034987	2034987	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000283	2400002	BEL AIRE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	101	101
2033742	2033742	MS	school	2800750	614	CLEVELAND SCHOOL DIST	280075000075	614004	BELL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	47	47
2039068	2039068	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000803	7100004	BELMONT SCHOOL	Regular School	No	Other	KG	12	2020	grade_2	60	60
2034796	2034796	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000981	2000006	BENNDALE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	30	30
2039774	2039774	MS	school	2804800	8200	YAZOO CO SCHOOL DIST	280480000891	8200008	BENTONIA GIBBS SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	70	70
2033537	2033537	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_2	32	32
2039020	2039020	MS	school	2804110	7012	SOUTH TIPPAH SCHOOL DIST	280411000775	7012004	BLUE MOUNTAIN HIGH SCHOOL	Regular School	No	Other	PK	12	2020	grade_2	14	14
2037065	2037065	MS	school	2802640	4300	LINCOLN CO SCHOOL DIST	280264000512	4300004	BOGUE CHITTO SCHOOL	Regular School	No	Other	KG	12	2020	grade_2	58	58
2035341	2035341	MS	school	2801860	2500	HINDS CO SCHOOL DIST	280186000984	2500044	BOLTON-EDWARDS ELEM./MIDDLE SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	37	37
2034227	2034227	MS	school	2801050	1420	CLARKSDALE MUNICIPAL SCHOOL DIST	280105000128	1420040	BOOKER T WASHINGTON INTERN. STUDIES	Regular School	No	Elementary	PK	04	2020	grade_2	32	32
2039298	2039298	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447001332	7500002	BOVINA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	51	51
2039306	2039306	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000826	7500004	BOWMAR AVENUE SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	67	67
2035393	2035393	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000373	2520011	BOYD ELEMENTARY SCHOOL	Regular School	No	Elementary	01	05	2020	grade_2	87	87
2039483	2039483	MS	school	2801620	7620	GREENVILLE PUBLIC SCHOOLS	280162000239	7620016	BOYD ELEMENTARY SCHOOL	Regular School	No	Elementary	01	05	2020	grade_2	90	90
2033809	2033809	MS	school	2800186	617	NORTH BOLIVAR CONS SCH	280018601404	617014	BROOKS ELEM SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	52	52
2033870	2033870	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087001102	700002	BRUCE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	55	55
2039546	2039546	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000898	7700012	BUCKATUNNA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	36	36
2039083	2039083	MS	school	2804260	7100	TISHOMINGO CO SP MUN SCH DIST	280426000804	7100008	BURNSVILLE ELEMENTARY	Regular School	No	Elementary	KG	08	2020	grade_2	47	47
2037529	2037529	MS	school	2802850	4700	MARSHALL CO SCHOOL DIST	280285000550	4700012	BYHALIA ELEMENTARY SCHOOL (K-5)	Regular School	No	Elementary	KG	05	2020	grade_2	123	123
2037156	2037156	MS	school	2802730	4400	LOWNDES CO SCHOOL DIST	280273000528	4400002	CALEDONIA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	198	198
2033891	2033891	MS	school	2800870	700	CALHOUN CO SCHOOL DIST	280087001104	700008	CALHOUN CITY ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	58	58
2037300	2037300	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279000988	4500010	CAMDEN ELEMENTARY	Regular School	No	Elementary	PK	05	2020	grade_2	14	14
2037403	2037403	MS	school	2800900	4520	CANTON PUBLIC SCHOOL DIST	280090000100	4520004	CANTON ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	72	72
2036255	2036255	MS	school	2802250	3300	JEFFERSON DAVIS CO SCHOOL DIST	280225000430	3300004	CARVER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2020	grade_2	42	42
2035412	2035412	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000379	2520020	CASEY ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	67	67
2034365	2034365	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001018	1700010	CENTER HILL ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	126	126
2035187	2035187	MS	school	2801710	2421	GULFPORT SCHOOL DIST	280171000271	2421014	CENTRAL ELEM	Regular School	No	Elementary	KG	05	2020	grade_2	100	100
2034807	2034807	MS	school	2801560	2000	GEORGE CO SCHOOL DIST	280156000227	2000008	CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	107	107
2036097	2036097	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000668	3022012	CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	41	41
2038975	2038975	MS	school	2803270	7011	NORTH TIPPAH SCHOOL DIST	280327000637	7011004	CHALYBEATE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	16	16
2038870	2038870	MS	school	2801410	6811	EAST TALLAHATCHIE CONSOL SCH DIST	280141000206	6811004	CHARLESTON ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	71	71
2036103	2036103	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000669	3022016	CHEROKEE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	04	2020	grade_2	34	34
2034357	2034357	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001190	1700008	CHICKASAW ELEMENTARY SCHOOL	Regular School	No	Elementary	02	03	2020	grade_2	277	277
2034105	2034105	MS	school	2800191	1321	WEST POINT CONSOLIDATED SCHOOL DIST	280019101455	1321006	CHURCH HILL ELEMENTARY SCHOOL	Regular School	No	Elementary	01	02	2020	grade_2	197	197
2039560	2039560	MS	school	2804530	7700	WAYNE CO SCHOOL DIST	280453000848	7700016	CLARA ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	08	2020	grade_2	50	50
2036601	2036601	MS	school	2802430	3800	LAUDERDALE CO SCHOOL DIST	280243001362	3800002	CLARKDALE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	04	2020	grade_2	82	82
2034233	2034233	MS	school	2800194	1425	CLARKSDALE COLLEGIATE	280019401492	1425004	CLARKSDALE COLLEGIATE	Regular School	Yes	Elementary	KG	03	2020	grade_2	48	48
2037050	2037050	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801520	4211022	CLAUDINE F BROWN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	02	2020	grade_2	114	114
2035425	2035425	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000381	2520024	CLAUSELL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	48	48
2039727	2039727	MS	school	2801140	8111	COFFEEVILLE SCHOOL DIST	280114001108	8111004	COFFEEVILLE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	07	2020	grade_2	32	32
2038906	2038906	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423001499	6900003	COLDWATER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	37	37
2036113	2036113	MS	school	2803480	3022	PASCAGOULA GAUTIER SCHOOL DIST	280348000670	3022020	COLLEGE PARK ELEM	Regular School	No	Elementary	PK	04	2020	grade_2	44	44
2034296	2034296	MS	school	2801290	1600	COVINGTON CO SCHOOLS	280129000176	1600004	COLLINS ELEMENTARY	Regular School	No	Elementary	KG	04	2020	grade_2	61	61
2037505	2037505	MS	school	2801170	4620	COLUMBIA SCHOOL DISTRICT	280117000150	4620012	COLUMBIA PRIMARY SCHOOL	Regular School	No	Elementary	PK	02	2020	grade_2	95	95
2037859	2037859	MS	school	2803210	5411	NORTH PANOLA SCHOOLS	280321000627	5411004	COMO PRIMARY	Regular School	No	Elementary	PK	02	2020	grade_2	112	112
2037245	2037245	MS	school	2801200	4420	COLUMBUS MUNICIPAL SCHOOL DIST	280120000156	4420024	COOK ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	54	54
2033603	2033603	MS	school	2801260	220	CORINTH SCHOOL DIST	280126001368	220002	CORINTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2	242	242
2036689	2036689	MS	school	2802910	3820	MERIDIAN PUBLIC SCHOOL DIST	280291000560	3820008	CRESTWOOD ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	35	35
2035006	2035006	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177001351	2400005	CROSSROADS ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	91	91
2034246	2034246	MS	school	2801220	1500	COPIAH CO SCHOOL DIST	280122001189	1500006	CRYSTAL SPRINGS ELEMENTARY	Regular School	No	Elementary	KG	03	2020	grade_2	107	107
2039328	2039328	MS	school	2804470	7500	VICKSBURG WARREN SCHOOL DIST	280447000993	7500014	DANA ROAD ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_2	116	116
2039753	2039753	MS	school	2804500	8113	WATER VALLEY SCHOOL DISTRICT	280450001095	8113008	DAVIDSON ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	84	84
2037008	2037008	MS	school	2800198	4211	GREENWOOD-LEFLORE CONSOLIDATED SD	280019801514	4211008	DAVIS ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	58	58
2035434	2035434	MS	school	2802190	2520	JACKSON PUBLIC SCHOOL DIST	280219000382	2520027	DAWSON ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	46	46
2035258	2035258	MS	school	2803510	2423	PASS CHRISTIAN PUBLIC SCHOOL DIST	280351000682	2423004	DELISLE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	68	68
2034510	2034510	MS	school	2801320	1700	DESOTO CO SCHOOL DIST	280132001369	1700051	DESOTO CENTRAL PRIMARY	Regular School	No	Elementary	KG	02	2020	grade_2	247	247
2039250	2039250	MS	school	2804440	7400	WALTHALL CO SCHOOL DIST	280444000833	7400004	DEXTER ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	08	2020	grade_2	12	12
2034995	2034995	MS	school	2801770	2400	HARRISON CO SCHOOL DIST	280177000284	2400003	DIBERVILLE ELEM	Regular School	No	Elementary	KG	03	2020	grade_2	170	170
2034605	2034605	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000216	1800008	DIXIE ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2020	grade_2	48	48
2035866	2035866	MS	school	2802100	2900	ITAWAMBA CO SCHOOL DIST	280210000356	2900004	DORSEY ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2020	grade_2	39	39
2039151	2039151	MS	school	2804290	7200	TUNICA COUNTY SCHOOL DISTRICT	280429000974	7200014	DUNDEE ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	*
2035803	2035803	MS	school	2800195	2611	HOLMES CONSOLIDATE SCHOOL DIST	280019501495	2611004	DURANT ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	55	55
2037804	2037804	MS	school	2803300	5200	NOXUBEE COUNTY SCHOOL DISTRICT	280330000641	5200008	EARL NASH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	102	102
2034661	2034661	MS	school	2801490	1800	FORREST COUNTY SCHOOL DISTRICT	280149000221	1800036	EARL TRAVILLION ATTENDANCE CENTER	Regular School	No	Elementary	KG	08	2020	grade_2	27	27
2036001	2036001	MS	school	2802160	3000	JACKSON CO SCHOOL DIST	280216000962	3000022	EAST CENTRAL LOWER ELEMENTARY	Regular School	No	Elementary	PK	02	2020	grade_2	164	164
2037292	2037292	MS	school	2802790	4500	MADISON CO SCHOOL DIST	280279001006	4500006	EAST FLORA ELEMENTARY	Regular School	No	Elementary	PK	05	2020	grade_2	41	41
2034929	2034929	MS	school	2801740	2300	HANCOCK CO SCHOOL DIST	280174000982	2300005	EAST HANCOCK ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	05	2020	grade_2	100	100
2036310	2036310	MS	school	2802280	3400	JONES CO SCHOOL DIST	280228000985	3400022	EAST JONES ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	109	109
2036410	2036410	MS	school	2802310	3500	KEMPER CO SCHOOL DIST	280231000452	3500004	EAST KEMPER ATTENDANCE CENTER	Regular School	No	Elementary	PK	06	2020	grade_2	13	13
2037457	2037457	MS	school	2802820	4600	MARION CO SCHOOL DIST	280282001243	4600002	EAST MARION ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	06	2020	grade_2	52	52
2038793	2038793	MS	school	2800187	6711	SUNFLOWER CO CONSOLIDATE SCH DIST	280018701418	6711008	EAST SUNFLOWER SCHOOL	Regular School	No	Elementary	PK	05	2020	grade_2	22	22
2038914	2038914	MS	school	2804230	6900	TATE CO SCHOOL DIST	280423000799	6900008	EAST TATE ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	06	2020	grade_2	81	81
2039160	2039160	MS	school	2804350	7300	UNION CO SCHOOL DIST	280435000821	7300004	EAST UNION ATTENDANCE CENTER	Regular School	No	Other	PK	12	2020	grade_2	55	55

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