schools: enrollments: 1,050 rows where where grade = "grade_5", state = "WI" and year = 2019 sorted by ccd_charter

Data source: Big Local News · About: Big Local

1,050 rows where grade = "grade_5", state = "WI" and year = 2019 sorted by ccd_charter_school descending

Search:

descending

Link	rowid	state	county	admin_level	district_nces_id	district_state_id	district_state_type	district	school_nces_id	school_state_id	school	school_state_type	ccd_school_type	ccd_charter_school ▲	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
3073893	3073893	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	58	58
3074143	3074143	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_5	25	25
3074160	3074160	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	20	20
3074192	3074192	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	54	54
3074240	3074240	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	16	16
3074359	3074359	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	37	37
3074390	3074390	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	30	30
3074458	3074458	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_5	26	26
3074668	3074668	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_5	1	1
3075036	3075036	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	1	1
3075297	3075297	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	140	140
3075440	3075440	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_5	11	11
3075500	3075500	WI	Milwaukee	school	5500114	8114	Non District Charter Schools	Capitol West Academy	550011403355	100	Capitol West Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	40	40
3075598	3075598	WI	Milwaukee	school	5500041	8105	Non District Charter Schools	Central City Cyberschool	550004102171	1211	Central City Cyberschool	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	41	41
3075664	3075664	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	grade_5	2	2
3076074	3076074	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	1	1
3076179	3076179	WI	Milwaukee	school	5500047	8109	Non District Charter Schools	Darrell Lynn Hines Academy	550004702536	100	Darrell Lynn Hines Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	30	30
3076405	3076405	WI	Milwaukee	school	5500039	8101	Non District Charter Schools	Downtown Montessori	550003902153	1056	Downtown Montessori	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	25	25
3076471	3076471	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002544	111	Chippewa Valley Montessori Charter School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	40	40
3076728	3076728	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2019	grade_5	14	14
3077018	3077018	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468002862	150	Fond du Lac STEM Academy	charter	Regular School	Yes	Elementary	03	05	2019	grade_5	23	23
3078076	3078076	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627003339	800	Hayward Ctr for Individualized Learning	charter	Regular School	Yes	Other	PK	12	2019	grade_5	19	19
3078127	3078127	WI	Iowa	school	5506420	2527	Public school	Highland	550642000698	20	Highland Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	28	28
3078497	3078497	WI	Dane	school	5500082	8141	Non District Charter Schools	Isthmus Montessori Academy Public	550008203085	8141	Isthmus Montessori Academy Public	charter	Regular School	Yes	Other	PK	12	2019	grade_5	20	20
3078536	3078536	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2019	grade_5	2	2
3078815	3078815	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001285	65	Brompton School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	24	24
3078832	3078832	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002457	130	Dimensions of Learning Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	25	25
3078950	3078950	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002758	190	Kenosha School of Technology Enhanced Curriculum	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	130	130
3079128	3079128	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351002914	180	Kettle Moraine Explore	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	23	23
3079181	3079181	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000839	100	i4Learning Community School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	11	11
3079340	3079340	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753001463	140	Coulee Montessori Charter School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	14	14
3079422	3079422	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000648	360	School of Technology and Arts I	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	14	14
3079582	3079582	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2019	grade_5	1	1
3079695	3079695	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002959	130	Flex Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	9	9
3079746	3079746	WI	Columbia	school	5508190	3150	Public school	Lodi	550819002915	110	Ouisconsing School of Collaboration	charter	Regular School	Yes	Elementary	03	05	2019	grade_5	26	26
3080050	3080050	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003356	125	Nuestro Mundo	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	51	51
3080547	3080547	WI	Dane	school	5508910	3381	Public school	McFarland	550891002973	160	Wisconsin Virtual Academy K-8 (WIVA)	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	115	115
3080578	3080578	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002598	9100	Rural Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	47	47
3080836	3080836	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002927	800	Bridges Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	54	54
3080862	3080862	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002917	110	Maple Grove School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	13	13
3080904	3080904	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	Other	KG	12	2019	grade_5	1	1
3081023	3081023	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	45	45
3081348	3081348	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	19	19
3081576	3081576	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong American Peace Academy K3-12	charter	Regular School	Yes	Other	PK	12	2019	grade_5	136	136
3081641	3081641	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001847	852	Highland Community School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	31	31
3081665	3081665	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001246	334	Honey Creek Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	53	53
3081698	3081698	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002493	165	IDEAL Individualized Developmental Educational Approaches to Learning	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	26	26
3081784	3081784	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001317	1121	La Causa Charter School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	82	82
3081949	3081949	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002537	123	Milwaukee College Preparatory School -- 36th Street Campus	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	54	54
3081960	3081960	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002853	111	Milwaukee College Preparatory School -- 38th Street	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	52	52
3081971	3081971	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002860	145	Milwaukee College Preparatory School -- Lloyd Street	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	52	52
3081982	3081982	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003006	121	Milwaukee College Preparatory School: Lola Rowe North Campus	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	52	52
3082003	3082003	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002949	118	Milwaukee Environmental Science Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	44	44
3082431	3082431	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001271	398	Whittier Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	29	29
3082473	3082473	WI	Milwaukee	school	5500042	8106	Non District Charter Schools	Milwaukee Academy of Science	550004202234	1251	Milwaukee Academy of Science	charter	Regular School	Yes	Other	PK	12	2019	grade_5	85	85
3082490	3082490	WI	Milwaukee	school	5500067	8128	Non District Charter Schools	Milwaukee Math and Science Academy	550006702898	800	Milwaukee Math and Science Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	39	39
3082501	3082501	WI	Milwaukee	school	5500065	8129	Non District Charter Schools	Milwaukee Scholars Charter School	550006502894	100	Milwaukee Scholars Charter School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	73	73
3082528	3082528	WI	Oneida	school	5509690	3640	Public school	Minocqua J1	550969002873	100	Creative Minds--Minocqua School of 21st Century Creativity and Design	charter	Regular School	Yes	Elementary	03	05	2019	grade_5	14	14
3082784	3082784	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006003354	110	Eagleville Charter School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_5	16	16
3082885	3082885	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Alliance Charter Elementary	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	20	20
3083017	3083017	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	9	9
3083357	3083357	WI	Ozaukee	school	5504890	1945	Public school	Northern Ozaukee	550489002801	850	Wisconsin Virtual Learning	charter	Regular School	Yes	Other	PK	12	2019	grade_5	16	16
3083410	3083410	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386002938	250	School of Options & Applied Research Middle	charter	Regular School	Yes	Middle	05	08	2019	grade_5	16	16
3083416	3083416	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	Middle	04	08	2019	grade_5	4	4
3083425	3083425	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003015	100	Northwood Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	21	21
3083640	3083640	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092002977	200	Bayshore Community Academy	charter	Regular School	Yes	Middle	05	08	2019	grade_5	20	20
3083795	3083795	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119003364	170	Accelerated Advanced Learning Program	charter	Regular School	Yes	Middle	04	08	2019	grade_5	11	11
3083883	3083883	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119002719	110	Shapiro STEM Academy	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	44	44
3084413	3084413	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	Other	KG	12	2019	grade_5	2	2
3084914	3084914	WI	Oneida	school	5512720	4781	Public school	Rhinelander	551272001673	20	Northwoods Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	15	15
3085080	3085080	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302002839	170	Quest Charter School	charter	Regular School	Yes	Elementary	03	05	2019	grade_5	52	52
3085118	3085118	WI	Pierce	school	5513050	4893	Public school	River Falls	551305002562	110	River Falls Public Montessori Academy	charter	Regular School	Yes	Elementary	KG	06	2019	grade_5	29	29
3085202	3085202	WI	Milwaukee	school	5500081	8002	Non District Charter Schools	Rocketship Education Wisconsin Inc	550008102969	8133	Rocketship Southside Community Prep	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	59	59
3085289	3085289	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606002989	850	Saint Croix Academy of Virtual Education	charter	Regular School	Yes	Other	PK	12	2019	grade_5	5	5
3085377	3085377	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341002663	100	Merrimac Community	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	20	20
3085409	3085409	WI	Milwaukee	school	5500074	8001	Non District Charter Schools	Seeds of Health Inc	550007402692	8121	Seeds of Health Elementary Program	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	51	51
3085555	3085555	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002716	190	Etude Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	27	27
3085616	3085616	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002733	150	Lake Country Academy - Charter	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	48	48
3085647	3085647	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002712	170	Northeast Wisconsin Montessori Charter School	charter	Regular School	Yes	Elementary	01	06	2019	grade_5	1	1
3085660	3085660	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002872	105	Sheboygan Leadership Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	23	23
3085999	3085999	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003358	170	Lakeview Montessori School	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	14	14
3086723	3086723	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002968	100	Tomorrow River Community Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	21	21
3086732	3086732	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003063	140	Tomorrow River Virtual Charter School (TRVCS)	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	2	2
3086769	3086769	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2019	grade_5	1	1
3086824	3086824	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5	7	7
3086910	3086910	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001153	70	Core Knowledge Charter School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	48	48
3086940	3086940	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001186	140	New Century School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	20	20
3086970	3086970	WI	Dane	school	5515330	5901	Public school	Verona Area	551533002849	150	Verona Area International School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	17	17
3086987	3086987	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002972	140	Viroqua Area Montessori School	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	4	4
3087234	3087234	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003003	150	eAchieve Elementary	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	21	21
3087357	3087357	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	84	84
3087421	3087421	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584003091	180	Chain Exploration Center	charter	Regular School	Yes	Elementary	KG	08	2019	grade_5	18	18
3087461	3087461	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002903	150	School for Agricultural and Environmental Studies	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5	20	20
3087596	3087596	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002629	150	Wausau Area Montessori Charter School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_5	21	21
3087763	3087763	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002728	150	Wauwatosa STEM	charter	Regular School	Yes	Elementary	KG	05	2019	grade_5	22	22
3088485	3088485	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002781	170	Mead Elementary Charter School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_5	61	61
3088573	3088573	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713003059	850	Wonewoc-Center Virtual Academy	charter	Regular School	Yes	Other	KG	12	2019	grade_5	1	1
3088579	3088579	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	37	37
3088590	3088590	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School - State Street Campus	550007002942	100	Woodlands School - State Street Campus	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5	36	36
3073904	3073904	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_5	53	53

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