schools: enrollments: 1,113 rows where where grade = "grade_2", state = "WI" and year = 2020 sorted by ccd_charter

Data source: Big Local News · About: Big Local

1,113 rows where grade = "grade_2", state = "WI" and year = 2020 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
2318122	2318122	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	2020	grade_2	55	55
2318349	2318349	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_2	25	25
2318367	2318367	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	20	20
2318399	2318399	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	52	52
2318447	2318447	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	10	10
2318566	2318566	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	45	45
2318597	2318597	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	16	16
2318904	2318904	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2020	grade_2	9	9
2319250	2319250	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	9	9
2319509	2319509	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	136	136
2319659	2319659	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_2	7	7
2319719	2319719	WI	Milwaukee	school	5500114	8114	Non District Charter Schools	Capitol West Academy	550011403355	100	Capitol West Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	24	24
2319818	2319818	WI	Milwaukee	school	5500041	8105	Non District Charter Schools	Central City Cyberschool	550004102171	1211	Central City Cyberschool	charter	Regular School	Yes	Other	PK	10	2020	grade_2	45	45
2319885	2319885	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2020	grade_2	3	3
2320142	2320142	WI	Columbia	school	5502820	1183	Public school	Columbus	550282002734	110	Discovery Charter School	charter	Regular School	Yes	Elementary	KG	03	2020	grade_2	20	20
2320297	2320297	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	1	1
2320400	2320400	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	2020	grade_2	26	26
2320625	2320625	WI	Milwaukee	school	5500039	8101	Non District Charter Schools	Downtown Montessori	550003902153	1056	Downtown Montessori	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	32	32
2320696	2320696	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	2020	grade_2	45	45
2320964	2320964	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2020	grade_2	12	12
2322320	2322320	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627003339	800	Hayward Ctr for Individualized Learning	charter	Regular School	Yes	Other	PK	12	2020	grade_2	13	13
2322372	2322372	WI	Iowa	school	5506420	2527	Public school	Highland	550642000698	20	Highland Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	18	18
2322745	2322745	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	2020	grade_2	25	25
2322785	2322785	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2020	grade_2	1	1
2323018	2323018	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002878	110	New Directions Learning Community	charter	Regular School	Yes	Elementary	PK	04	2020	grade_2	37	37
2323025	2323025	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729000795	80	Park Community Charter School	charter	Regular School	Yes	Elementary	KG	04	2020	grade_2	44	44
2323063	2323063	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001285	65	Brompton School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	22	22
2323080	2323080	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002457	130	Dimensions of Learning Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	25	25
2323198	2323198	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002758	190	Kenosha School of Technology Enhanced Curriculum	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	110	110
2323376	2323376	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351002914	180	Kettle Moraine Explore	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	22	22
2323429	2323429	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000839	100	i4Learning Community School	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	24	24
2323571	2323571	WI	Waukesha	school	5500073	8135	Non District Charter Schools	La Casa de Esperanza Charter School	550007303031	100	La Casa de Esperanza Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	27	27
2323588	2323588	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753001463	140	Coulee Montessori Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	23	23
2323672	2323672	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	2020	grade_2	21	21
2323799	2323799	WI	Walworth	school	5507620	2885	Public school	Lake Geneva J1	550762003107	150	Maple Park Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	1	1
2323849	2323849	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	2020	grade_2	1	1
2323964	2323964	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002959	130	Flex Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	16	16
2324324	2324324	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003356	125	Nuestro Mundo	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	54	54
2324746	2324746	WI	Juneau	school	5508850	3360	Public school	Mauston	550885003030	110	Mauston Montessori Charter School	charter	Regular School	Yes	Elementary	PK	04	2020	grade_2	13	13
2324815	2324815	WI	Dane	school	5508910	3381	Public school	McFarland	550891002973	160	Wisconsin Virtual Academy K-8 (WIVA)	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	82	82
2324846	2324846	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002598	9100	Rural Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	42	42
2325104	2325104	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002927	800	Bridges Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	69	69
2325130	2325130	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002917	110	Maple Grove School	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	16	16
2325291	2325291	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	77	77
2325603	2325603	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	19	19
2325828	2325828	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong American Peace Academy K3-12	charter	Regular School	Yes	Other	PK	12	2020	grade_2	150	150
2325893	2325893	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001847	852	Highland Community School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	44	44
2325916	2325916	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001246	334	Honey Creek Elementary	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	64	64
2325946	2325946	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002493	165	IDEAL Individualized Developmental Educational Approaches to Learning	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	27	27
2326028	2326028	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001317	1121	La Causa Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	83	83
2326192	2326192	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002537	123	Milwaukee College Preparatory School -- 36th Street Campus	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	50	50
2326203	2326203	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002853	111	Milwaukee College Preparatory School -- 38th Street	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	52	52
2326214	2326214	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002860	145	Milwaukee College Preparatory School -- Lloyd Street	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	51	51
2326225	2326225	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	2020	grade_2	48	48
2326246	2326246	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002949	118	Milwaukee Environmental Science Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	54	54
2326664	2326664	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001271	398	Whittier Elementary	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	25	25
2326705	2326705	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	2020	grade_2	95	95
2326717	2326717	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	2020	grade_2	24	24
2326728	2326728	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	2020	grade_2	73	73
2327014	2327014	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006003354	110	Eagleville Charter School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_2	18	18
2327103	2327103	WI	Juneau	school	5510230	3871	Public school	Necedah Area	551023003112	100	N-Vision Learning Center	charter	Regular School	Yes	Elementary	01	05	2020	grade_2	15	15
2327127	2327127	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Alliance Charter Elementary	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	21	21
2327259	2327259	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	17	17
2327556	2327556	WI	Fond du Lac	school	5510740	3983	Public school	North Fond du Lac	551074003125	800	Treffert Way for the Exceptional Mind	charter	Regular School	Yes	Elementary	KG	07	2020	grade_2	6	6
2327608	2327608	WI	Ozaukee	school	5504890	1945	Public school	Northern Ozaukee	550489003106	120	Riveredge Outdoor Learning Elementary	charter	Regular School	Yes	Elementary	KG	04	2020	grade_2	16	16
2327617	2327617	WI	Ozaukee	school	5504890	1945	Public school	Northern Ozaukee	550489002801	850	Wisconsin Virtual Learning	charter	Regular School	Yes	Other	PK	12	2020	grade_2	8	8
2327662	2327662	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	Elementary	PK	04	2020	grade_2	12	12
2327685	2327685	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003015	100	Northwood Elementary	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	21	21
2328140	2328140	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119002719	110	Shapiro STEM Academy	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	34	34
2328324	2328324	WI	Milwaukee	school	5500078	8138	Non District Charter Schools	Penfield Montessori Academy	550007803048	8138	Penfield Montessori Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	17	17
2328673	2328673	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	2020	grade_2	1	1
2329336	2329336	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302002978	130	Journey	charter	Regular School	Yes	Elementary	KG	02	2020	grade_2	44	44
2329347	2329347	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302003102	800	Odyssey Academy of Virtual Learning	charter	Regular School	Yes	Other	PK	12	2020	grade_2	14	14
2329396	2329396	WI	Pierce	school	5513050	4893	Public school	River Falls	551305002562	110	River Falls Public Montessori Academy	charter	Regular School	Yes	Elementary	KG	06	2020	grade_2	19	19
2329480	2329480	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	2020	grade_2	76	76
2329488	2329488	WI	Milwaukee	school	5500081	8002	Non District Charter Schools	Rocketship Education Wisconsin Inc	550008103086	8140	Rocketship Transformation Prep	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	16	16
2329580	2329580	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606002989	850	Saint Croix Virtual Academy Inc	charter	Regular School	Yes	Other	PK	12	2020	grade_2	2	2
2329651	2329651	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341002663	100	Merrimac Community	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	18	18
2329677	2329677	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	2020	grade_2	34	34
2329786	2329786	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002908	110	LEADS Primary Charter School	charter	Regular School	Yes	Elementary	PK	02	2020	grade_2	17	17
2329823	2329823	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002716	190	Etude Elementary	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	36	36
2329884	2329884	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002733	150	Lake Country Academy - Charter	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	50	50
2329915	2329915	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002712	170	Northeast Wisconsin Montessori Charter School	charter	Regular School	Yes	Elementary	01	06	2020	grade_2	4	4
2329927	2329927	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002872	105	Sheboygan Leadership Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	24	24
2330127	2330127	WI	Douglas	school	5513980	5397	Public school	Solon Springs	551398003113	100	Eagles' Wings Public Montessori Charter	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	5	5
2330280	2330280	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003358	170	Lakeview Montessori School	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	26	26
2330414	2330414	WI	Milwaukee	school	5500076	8136	Non District Charter Schools	Stellar Collegiate Charter School	550007603046	8136	Stellar Collegiate Charter School	charter	Regular School	Yes	Elementary	PK	05	2020	grade_2	41	41
2330957	2330957	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491003028	110	Tomah Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2020	grade_2	6	6
2331023	2331023	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002968	100	Tomorrow River Community Charter	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	19	19
2331032	2331032	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003063	140	Tomorrow River Virtual Charter School (TRVCS)	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	3	3
2331123	2331123	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	8	8
2331208	2331208	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001153	70	Core Knowledge Charter School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	41	41
2331237	2331237	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001186	140	New Century School	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	22	22
2331267	2331267	WI	Dane	school	5515330	5901	Public school	Verona Area	551533002849	150	Verona Area International School	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	23	23
2331288	2331288	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002972	140	Viroqua Area Montessori School	charter	Regular School	Yes	Elementary	PK	06	2020	grade_2	15	15
2331528	2331528	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003003	150	eAchieve Elementary	charter	Regular School	Yes	Elementary	KG	05	2020	grade_2	9	9
2331651	2331651	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	85	85
2331722	2331722	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584003091	180	Chain Exploration Center	charter	Regular School	Yes	Elementary	02	06	2020	grade_2	15	15
2331762	2331762	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	2020	grade_2	17	17
2331897	2331897	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002629	150	Wausau Area Montessori Charter School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_2	12	12

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