schools: enrollments: 497 rows where where grade = "pk_12_total", state = "AK" and year = 2021 sorted by total

Data source: Big Local News · About: Big Local

497 rows where grade = "pk_12_total", state = "AK" 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	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int ▼
1816849	1816849	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000513	247050	Marathon School	Alternative School	No	High	07	12	2021	pk_12_total	3.0						1.0	4.0	3						1	4
1817633	1817633	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500473	308010	Lakeview Home School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0			1.0				5.0	2			1				5
1818881	1818881	AK	school	200510	33	Mat-Su Borough Schools	20051000407	337030	Mat-Su Youth Facility	Alternative School	No	High	06	12	2021	pk_12_total	2.0		1.0				1.0	6.0	2		1				1	6
1819617	1819617	AK	school	200670	40	Pribilof Schools	20067000762	408010	Pribilof Correspondence School	Regular School	No	Other	KG	10	2021	pk_12_total								6.0								6
1814225	1814225	AK	school	200180	5	Anchorage Schools	20018000399	57220	The New Path High School	Alternative School	No	High	07	12	2021	pk_12_total	2.0	1.0	2.0	1.0				8.0	2	1	2	1				8
1820257	1820257	AK	school	200775	51	Yukon Flats Schools	20077500552	510140	Cruikshank School	Regular School	No	Other	PK	12	2021	pk_12_total								8.0								8
1819809	1819809	AK	school	200700	44	Southeast Island Schools	20070000322	440230	Port Alexander School	Regular School	No	Other	PK	12	2021	pk_12_total	5.0							9.0	5							9
1812833	1812833	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12	2021	pk_12_total							3.0	10.0							3	10
1814897	1814897	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							10.0	1							10
1820193	1820193	AK	school	200775	51	Yukon Flats Schools	20077500360	510040	Tsuk Taih School	Regular School	No	Other	PK	12	2021	pk_12_total		1.0						10.0		1						10
1812657	1812657	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	pk_12_total	4.0						3.0	11.0	4						3	11
1812705	1812705	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0						3.0	11.0	2						3	11
1816321	1816321	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000155	240040	Cooper Landing School	Regular School	No	Other	KG	12	2021	pk_12_total	9.0						1.0	11.0	9						1	11
1817105	1817105	AK	school	200480	28	Kodiak Island Borough Schools	20048000180	280010	Akhiok School	Regular School	No	Other	KG	12	2021	pk_12_total		1.0					1.0	11.0		1					1	11
1817969	1817969	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	pk_12_total								11.0								11
1818081	1818081	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12	2021	pk_12_total				1.0				11.0				1				11
1819537	1819537	AK	school	200630	38	Pelican City Schools	20063000304	380010	Pelican School	Regular School	No	Other	KG	12	2021	pk_12_total	5.0						6.0	11.0	5						6	11
1819841	1819841	AK	school	200700	44	Southeast Island Schools	20070000589	440270	Naukati School	Regular School	No	Other	PK	12	2021	pk_12_total	9.0							11.0	9							11
1820561	1820561	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	pk_12_total	3.0						1.0	11.0	3						1	11
1815953	1815953	AK	school	200520	21	Iditarod Area Schools	20052000245	210080	Top of the Kuskokwim School	Regular School	No	Other	PK	12	2021	pk_12_total								12.0								12
1817617	1817617	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500334	300220	Levelock School	Regular School	No	Other	PK	12	2021	pk_12_total								12.0								12
1814769	1814769	AK	school	200730	9	Chatham Schools	20073000490	90090	Klukwan School	Regular School	No	Other	KG	12	2021	pk_12_total	4.0						3.0	13.0	4						3	13
1818721	1818721	AK	school	200510	33	Mat-Su Borough Schools	20051000722	330330	Trapper Creek Elementary	Regular School	No	Elementary	PK	5	2021	pk_12_total	4.0			2.0	1.0		4.0	13.0	4			2	1		4	13
1819745	1819745	AK	school	200700	44	Southeast Island Schools	20070000314	440020	Howard Valentine Coffman Cove School	Regular School	No	Other	PK	12	2021	pk_12_total	10.0				2.0			13.0	10				2			13
1819889	1819889	AK	school	200710	45	Southwest Region Schools	20071000465	450040	William "Sonny" Nelson School	Regular School	No	Other	PK	12	2021	pk_12_total			1.0				2.0	13.0			1				2	13
1812769	1812769	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8	2021	pk_12_total							1.0	14.0							1	14
1815921	1815921	AK	school	200520	21	Iditarod Area Schools	20052000247	210050	Takotna Community School	Regular School	No	Other	PK	12	2021	pk_12_total	4.0	2.0	5.0	2.0			1.0	14.0	4	2	5	2			1	14
1817409	1817409	AK	school	200760	29	Kuspuk Schools	20076000353	290080	Gusty Michael School	Regular School	No	Other	PK	12	2021	pk_12_total								14.0								14
1817441	1817441	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500193	300010	Chignik Bay School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0			2.0			1.0	14.0	2			2			1	14
1820337	1820337	AK	school	200862	52	Yukon-Koyukuk Schools	20086200382	520060	Ella B. Vernetti School	Regular School	No	Elementary	PK	8	2021	pk_12_total								14.0								14
1812849	1812849	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	pk_12_total	1.0		5.0		1.0	4.0		15.0	1		5		1	4		15
1817249	1817249	AK	school	200480	28	Kodiak Island Borough Schools	20048000191	280120	Port Lions School	Regular School	No	Other	KG	12	2021	pk_12_total	4.0			3.0				15.0	4			3				15
1817457	1817457	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500194	300020	Chignik Lagoon School	Regular School	No	Other	PK	12	2021	pk_12_total							4.0	15.0							4	15
1819873	1819873	AK	school	200710	45	Southwest Region Schools	20071000331	450030	Clarks Point School	Regular School	No	Other	KG	12	2021	pk_12_total								15.0								15
1814817	1814817	AK	school	200800	10	Chugach Schools	20080000553	100030	Chenega School	Regular School	No	Other	PK	12	2021	pk_12_total	6.0						6.0	16.0	6						6	16
1817233	1817233	AK	school	200480	28	Kodiak Island Borough Schools	20048000192	280110	Ouzinkie School	Regular School	No	Other	KG	12	2021	pk_12_total				1.0			2.0	16.0				1			2	16
1818625	1818625	AK	school	200510	33	Mat-Su Borough Schools	20051000726	330370	Beryozova School	Regular School	No	Other	KG	12	2021	pk_12_total	9.0			6.0				16.0	9			6				16
1820401	1820401	AK	school	200862	52	Yukon-Koyukuk Schools	20086200757	520120	Rampart School	Regular School	No	Other	PK	12	2021	pk_12_total								16.0								16
1814481	1814481	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12	2021	pk_12_total								17.0								17
1816193	1816193	AK	school	200210	22	Juneau Borough Schools	20021000396	227020	Johnson Youth Center	Alternative School	No	High	05	12	2021	pk_12_total	1.0			1.0			12.0	17.0	1			1			12	17
1817585	1817585	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500203	300130	Pilot Point School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						2.0	17.0	1						2	17
1818017	1818017	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12	2021	pk_12_total								17.0								17
1819761	1819761	AK	school	200700	44	Southeast Island Schools	20070000319	440090	Barry Craig Stewart Kasaan School	Regular School	No	Other	PK	12	2021	pk_12_total	12.0						2.0	17.0	12						2	17
1820545	1820545	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						3.0	17.0	1						3	17
1814721	1814721	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12	2021	pk_12_total	6.0							18.0	6							18
1815585	1815585	AK	school	200600	16	Fairbanks North Star Borough Schools	20060000049	167020	Golden Heart Academy	Alternative School	No	High	05	12	2021	pk_12_total	4.0		1.0			1.0	5.0	18.0	4		1			1	5	18
1816433	1816433	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000163	240120	Moose Pass School	Regular School	No	Elementary	KG	8	2021	pk_12_total	16.0	1.0					1.0	18.0	16	1					1	18
1817473	1817473	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500195	300030	Chignik Lake School	Regular School	No	Other	PK	12	2021	pk_12_total								18.0								18
1819313	1819313	AK	school	200610	36	North Slope Borough Schools	20061000768	369010	Qargi Academy	Regular School	Yes	High	09	12	2021	pk_12_total							1.0	18.0							1	18
1820209	1820209	AK	school	200775	51	Yukon Flats Schools	20077500361	510050	Circle School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							18.0	1							18
1817121	1817121	AK	school	200480	28	Kodiak Island Borough Schools	20048000181	280020	Chiniak School	Regular School	No	Other	KG	12	2021	pk_12_total	10.0		1.0					19.0	10		1					19
1817393	1817393	AK	school	200760	29	Kuspuk Schools	20076000352	290070	Jack Egnaty Sr. School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0							19.0	2							19
1819825	1819825	AK	school	200700	44	Southeast Island Schools	20070000484	440250	Hollis School	Regular School	No	Other	PK	12	2021	pk_12_total	8.0		3.0	3.0			2.0	19.0	8		3	3			2	19
1812721	1812721	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	pk_12_total	14.0						1.0	20.0	14						1	20
1814785	1814785	AK	school	200800	10	Chugach Schools	20080000371	100010	Tatitlek Community School	Regular School	No	Other	PK	12	2021	pk_12_total	5.0		2.0					20.0	5		2					20
1815889	1815889	AK	school	200520	21	Iditarod Area Schools	20052000240	210010	Blackwell School	Regular School	No	Other	PK	12	2021	pk_12_total				1.0				20.0				1				20
1819793	1819793	AK	school	200700	44	Southeast Island Schools	20070000526	440190	Whale Pass School	Regular School	No	Other	PK	12	2021	pk_12_total	19.0		1.0					20.0	19		1					20
1820289	1820289	AK	school	200862	52	Yukon-Koyukuk Schools	20086200379	520030	Johnny Oldman School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0							20.0	2							20
1816449	1816449	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000164	240130	Nikolaevsk School	Regular School	No	Other	PK	12	2021	pk_12_total	19.0			1.0			1.0	21.0	19			1			1	21
1819297	1819297	AK	school	200610	36	North Slope Borough Schools	20061000470	367010	Kiita Learning Community	Alternative School	No	High	09	12	2021	pk_12_total						1.0	1.0	21.0						1	1	21
1814129	1814129	AK	school	200180	5	Anchorage Schools	20018000341	57010	Alaska State School for Deaf and Hard of Hearing	Special Education School	No	Other	PK	12	2021	pk_12_total	9.0	3.0	3.0		1.0		2.0	22.0	9	3	3		1		2	22
1817601	1817601	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500205	300140	Meshik School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0							22.0	1							22
1816625	1816625	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000153	240280	Tebughna School	Regular School	No	Other	PK	12	2021	pk_12_total			4.0				4.0	23.0			4				4	23
1816817	1816817	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000081	247020	Homer Flex School	Alternative School	No	High	09	12	2021	pk_12_total	13.0		2.0				4.0	23.0	13		2				4	23
1817489	1817489	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500197	300050	Igiugig School	Regular School	No	Other	PK	12	2021	pk_12_total							1.0	23.0							1	23
1820273	1820273	AK	school	200862	52	Yukon-Koyukuk Schools	20086200377	520010	Allakaket School	Regular School	No	Other	PK	12	2021	pk_12_total					1.0			23.0					1			23
1815905	1815905	AK	school	200520	21	Iditarod Area Schools	20052000242	210030	Jeffery A. Bader Memorial School	Regular School	No	Other	KG	12	2021	pk_12_total								24.0								24
1817329	1817329	AK	school	200760	29	Kuspuk Schools	20076000347	290020	Crow Village Sam School	Regular School	No	Other	PK	12	2021	pk_12_total								25.0								25
1817569	1817569	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500202	300120	Perryville School	Regular School	No	Other	PK	12	2021	pk_12_total								25.0								25
1819521	1819521	AK	school	200625	37	Northwest Arctic Borough Schools	20062500748	378020	NWABSD Home School	Regular School	No	Other	KG	12	2021	pk_12_total	3.0						1.0	25.0	3						1	25
1820161	1820161	AK	school	200840	50	Yakutat City Schools	20084000749	508010	LEAD Correspondence	Regular School	No	Other	KG	12	2021	pk_12_total	18.0						2.0	25.0	18						2	25
1814961	1814961	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	pk_12_total	19.0				1.0		3.0	26.0	19				1		3	26
1820321	1820321	AK	school	200862	52	Yukon-Koyukuk Schools	20086200381	520050	Kaltag School	Regular School	No	Other	PK	12	2021	pk_12_total								26.0								26
1812641	1812641	AK	school	200770	2	Denali Borough Schools	20077000354	20010	Anderson School	Regular School	No	Other	PK	12	2021	pk_12_total	22.0		1.0	2.0	1.0		1.0	27.0	22		1	2	1		1	27
1815969	1815969	AK	school	200520	21	Iditarod Area Schools	20052000246	210090	Innoko River School	Regular School	No	Other	PK	12	2021	pk_12_total							2.0	27.0							2	27
1816273	1816273	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000159	240010	Hope School	Regular School	No	Other	PK	12	2021	pk_12_total	22.0							27.0	22							27
1818065	1818065	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	pk_12_total	2.0		1.0					27.0	2		1					27
1819969	1819969	AK	school	200710	45	Southwest Region Schools	20071000573	450120	Twin Hills School	Regular School	No	Other	PK	12	2021	pk_12_total							7.0	28.0							7	28
1816753	1816753	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000718	240420	Kachemak Selo School	Regular School	No	Other	PK	12	2021	pk_12_total	29.0							29.0	29							29
1817217	1817217	AK	school	200480	28	Kodiak Island Borough Schools	20048000189	280100	Old Harbor School	Regular School	No	Other	KG	12	2021	pk_12_total	6.0		2.0					29.0	6		2					29
1817537	1817537	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500200	300100	Nondalton School	Regular School	No	Other	PK	12	2021	pk_12_total							3.0	29.0							3	29
1815073	1815073	AK	school	200100	14	Delta/Greely Schools	20010000510	140090	Gerstle River School	Regular School	No	Other	KG	12	2021	pk_12_total	30.0							30.0	30							30
1817345	1817345	AK	school	200760	29	Kuspuk Schools	20076000348	290030	Johnnie John Sr. School	Regular School	No	Other	PK	12	2021	pk_12_total								30.0								30
1820433	1820433	AK	school	200715	53	Tanana Schools	20071500488	530010	Maudrey J. Sommer School	Regular School	No	Other	KG	12	2021	pk_12_total	1.0						2.0	30.0	1						2	30
1816497	1816497	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000168	240180	Port Graham School	Regular School	No	Other	PK	12	2021	pk_12_total			1.0				9.0	31.0			1				9	31
1812737	1812737	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12	2021	pk_12_total								32.0								32
1819857	1819857	AK	school	200710	45	Southwest Region Schools	20071000330	450020	Aleknagik School	Regular School	No	Other	PK	12	2021	pk_12_total	1.0						7.0	32.0	1						7	32
1815937	1815937	AK	school	200520	21	Iditarod Area Schools	20052000244	210060	McGrath School	Regular School	No	Other	PK	12	2021	pk_12_total	3.0	1.0	2.0	1.0			4.0	33.0	3	1	2	1			4	33
1820385	1820385	AK	school	200862	52	Yukon-Koyukuk Schools	20086200386	520110	Merreline A Kangas School	Regular School	No	Other	PK	12	2021	pk_12_total	2.0			2.0				33.0	2			2				33
1818033	1818033	AK	school	200001	31	Lower Kuskokwim Schools	20000100765	310290	Mertarvik School	Regular School	No	Other	PK	12	2021	pk_12_total								35.0								35
1818305	1818305	AK	school	200510	33	Mat-Su Borough Schools	20051000225	330030	Glacier View School	Regular School	No	Other	KG	12	2021	pk_12_total	29.0		3.0				2.0	35.0	29		3				2	35
1819697	1819697	AK	school	200240	42	Sitka Borough Schools	20024000035	427010	Pacific High School	Alternative School	No	High	09	12	2021	pk_12_total	8.0			1.0			2.0	35.0	8			1			2	35
1820177	1820177	AK	school	200775	51	Yukon Flats Schools	20077500358	510010	Arctic Village School	Regular School	No	Other	PK	12	2021	pk_12_total								36.0								36
1812801	1812801	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12	2021	pk_12_total								39.0								39
1815745	1815745	AK	school	200130	17	Galena City Schools	20013000635	170020	Sidney C. Huntington Jr/Sr High School	Regular School	No	High	07	12	2021	pk_12_total	8.0			1.0				39.0	8			1				39
1816833	1816833	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000079	247030	Kenai Alternative High School	Alternative School	No	High	09	12	2021	pk_12_total	22.0		3.0				9.0	39.0	22		3				9	39
1817377	1817377	AK	school	200760	29	Kuspuk Schools	20076000350	290050	Zackar Levi Elementary	Regular School	No	Elementary	03	5	2021	pk_12_total							2.0	39.0							2	39
1815441	1815441	AK	school	200600	16	Fairbanks North Star Borough Schools	20060000279	160280	Two Rivers School	Regular School	No	Elementary	PK	8	2021	pk_12_total	27.0		3.0				10.0	41.0	27		3				10	41
1814609	1814609	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12	2021	pk_12_total					2.0			42.0					2			42
1820369	1820369	AK	school	200862	52	Yukon-Koyukuk Schools	20086200385	520090	Andrew K. Demoski School	Regular School	No	Other	PK	12	2021	pk_12_total					1.0			42.0					1			42

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