schools: enrollments: 713 rows where where grade = "grade_6", state = "WI" and year = 2020 sorted by ccd_charter

Data source: Big Local News · About: Big Local

713 rows where grade = "grade_6", 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
2318126	2318126	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_6	58	58
2318353	2318353	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_6	15	15
2318371	2318371	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2020	grade_6	15	15
2318403	2318403	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	54	54
2318451	2318451	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	15	15
2318515	2318515	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002759	250	Kaleidoscope Academy	charter	Regular School	Yes	Middle	06	08	2020	grade_6	149	149
2318570	2318570	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2020	grade_6	37	37
2318601	2318601	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	28	28
2318674	2318674	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2020	grade_6	11	11
2318894	2318894	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2020	grade_6	1	1
2319513	2319513	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	132	132
2319663	2319663	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_6	9	9
2319723	2319723	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_6	30	30
2319822	2319822	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_6	50	50
2319889	2319889	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_6	4	4
2320300	2320300	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	1	1
2320316	2320316	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317002885	400	D C Everest Idea School	charter	Regular School	Yes	High	06	12	2020	grade_6	7	7
2320404	2320404	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_6	27	27
2320546	2320546	WI	Brown	school	5503660	1407	Public school	Denmark	550366002936	450	Denmark Community School	charter	Regular School	Yes	High	06	12	2020	grade_6	8	8
2320629	2320629	WI	Milwaukee	school	5500039	8101	Non District Charter Schools	Downtown Montessori	550003902153	1056	Downtown Montessori	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	24	24
2320720	2320720	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405003115	810	Eau Claire Virtual School	charter	Regular School	Yes	High	06	12	2020	grade_6	3	3
2320968	2320968	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2020	grade_6	14	14
2321262	2321262	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468002966	210	Fond du Lac STEM Institute	charter	Regular School	Yes	High	06	12	2020	grade_6	29	29
2321768	2321768	WI	Burnett	school	5505670	2233	Public school	Grantsburg	550567002704	400	iForward	charter	Regular School	Yes	High	06	12	2020	grade_6	27	27
2321928	2321928	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002857	445	John Dewey Academy of Learning	charter	Regular School	Yes	High	06	12	2020	grade_6	9	9
2322324	2322324	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_6	24	24
2322353	2322353	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627002867	250	Northern Waters Environmental School	charter	Regular School	Yes	High	06	12	2020	grade_6	1	1
2322385	2322385	WI	Iowa	school	5506420	2527	Public school	Highland	550642002829	250	Highland Community Middle	charter	Regular School	Yes	Middle	06	08	2020	grade_6	31	31
2322495	2322495	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002854	220	Fox West Academy	charter	Regular School	Yes	Middle	06	08	2020	grade_6	20	20
2322749	2322749	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_6	21	21
2322787	2322787	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2020	grade_6	4	4
2323067	2323067	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001285	65	Brompton School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	26	26
2323084	2323084	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002457	130	Dimensions of Learning Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	26	26
2323143	2323143	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002754	490	Harborside Academy	charter	Regular School	Yes	High	06	12	2020	grade_6	54	54
2323202	2323202	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_6	156	156
2323592	2323592	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_6	6	6
2323626	2323626	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002887	250	La Crosse Design Institute	charter	Regular School	Yes	Middle	06	08	2020	grade_6	15	15
2323678	2323678	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753001295	204	School of Technology and Arts II	charter	Regular School	Yes	Middle	06	08	2020	grade_6	10	10
2323802	2323802	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_6	2	2
2323852	2323852	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_6	2	2
2323968	2323968	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002959	130	Flex Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	7	7
2324115	2324115	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002866	200	Badger Rock Middle	charter	Regular School	Yes	Middle	06	08	2020	grade_6	35	35
2324563	2324563	WI	Marathon	school	5508670	3304	Public school	Marathon City	550867002893	210	Marathon Venture Academy	charter	Regular School	Yes	Middle	06	08	2020	grade_6	50	50
2324819	2324819	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_6	156	156
2324850	2324850	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002598	9100	Rural Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	56	56
2325108	2325108	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002927	800	Bridges Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	48	48
2325173	2325173	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	Other	KG	12	2020	grade_6	1	1
2325295	2325295	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_6	15	15
2325477	2325477	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003071	213	Carmen Middle School of Science and Technology South Campus	charter	Regular School	Yes	Middle	06	08	2020	grade_6	71	71
2325483	2325483	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002980	444	Carmen Middle/High School of Science and Technology Northwest Campus	charter	Regular School	Yes	High	06	12	2020	grade_6	81	81
2325607	2325607	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	27	27
2325788	2325788	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003111	454	Green Tree Preparatory Academy	charter	Regular School	Yes	Middle	06	09	2020	grade_6	69	69
2325832	2325832	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_6	153	153
2325897	2325897	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001847	852	Highland Community School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	30	30
2325950	2325950	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_6	33	33
2326032	2326032	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001317	1121	La Causa Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	78	78
2326196	2326196	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_6	51	51
2326207	2326207	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_6	52	52
2326218	2326218	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_6	51	51
2326229	2326229	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_6	48	48
2326250	2326250	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002949	118	Milwaukee Environmental Science Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	38	38
2326256	2326256	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003036	885	Milwaukee Excellence Charter School	charter	Regular School	Yes	Middle	06	09	2020	grade_6	107	107
2326709	2326709	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_6	88	88
2326721	2326721	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_6	26	26
2326732	2326732	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_6	68	68
2326775	2326775	WI	Oneida	school	5509690	3640	Public school	Minocqua J1	550969002840	250	Woodland Progressive School for 21st Century Citizens	charter	Regular School	Yes	Middle	06	08	2020	grade_6	18	18
2326832	2326832	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981002828	450	Monona Grove Liberal Arts Charter School for the 21st Century	charter	Regular School	Yes	High	06	12	2020	grade_6	10	10
2326919	2326919	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	KG	12	2020	grade_6	1	1
2327018	2327018	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006003354	110	Eagleville Charter School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_6	17	17
2327097	2327097	WI	Juneau	school	5510230	3871	Public school	Necedah Area	551023003116	410	N-Gage Academy	charter	Regular School	Yes	High	06	12	2020	grade_6	5	5
2327234	2327234	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002957	100	Central Wisconsin STEM Academy	charter	Regular School	Yes	Middle	05	08	2020	grade_6	8	8
2327263	2327263	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	11	11
2327503	2327503	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2020	grade_6	1	1
2327560	2327560	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_6	6	6
2327621	2327621	WI	Ozaukee	school	5504890	1945	Public school	Northern Ozaukee	550489002801	850	Wisconsin Virtual Learning	charter	Regular School	Yes	Other	PK	12	2020	grade_6	16	16
2327674	2327674	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386002938	250	School of Options & Applied Research Middle	charter	Regular School	Yes	Middle	05	08	2020	grade_6	14	14
2327680	2327680	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	Middle	04	08	2020	grade_6	4	4
2327695	2327695	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002934	410	Northwood High/Middle	charter	Regular School	Yes	High	06	12	2020	grade_6	20	20
2327903	2327903	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092002977	200	Bayshore Community Academy	charter	Regular School	Yes	Middle	05	08	2020	grade_6	20	20
2328060	2328060	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119003364	170	Accelerated Advanced Learning Program	charter	Regular School	Yes	Middle	04	08	2020	grade_6	13	13
2328677	2328677	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_6	2	2
2329292	2329292	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2020	grade_6	2	2
2329331	2329331	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302002930	200	Catalyst Charter Middle	charter	Regular School	Yes	Middle	06	08	2020	grade_6	40	40
2329351	2329351	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_6	13	13
2329400	2329400	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_6	12	12
2329584	2329584	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_6	6	6
2329681	2329681	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_6	53	53
2329834	2329834	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002899	250	Etude Middle	charter	Regular School	Yes	Middle	06	08	2020	grade_6	21	21
2329847	2329847	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002900	220	George D Warriner Middle	charter	Regular School	Yes	Middle	06	08	2020	grade_6	10	10
2329888	2329888	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002733	150	Lake Country Academy - Charter	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	43	43
2329931	2329931	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002872	105	Sheboygan Leadership Academy	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	22	22
2330131	2330131	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_6	8	8
2330275	2330275	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003001	200	Innovations STEM Academy	charter	Regular School	Yes	Middle	06	08	2020	grade_6	21	21
2330284	2330284	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003358	170	Lakeview Montessori School	charter	Regular School	Yes	Elementary	PK	06	2020	grade_6	9	9
2330497	2330497	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449003019	290	Point of Discovery School	charter	Regular School	Yes	Middle	06	09	2020	grade_6	17	17
2331030	2331030	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003119	200	Tomorrow River Community Middle (TRCMS)	charter	Regular School	Yes	Middle	05	06	2020	grade_6	23	23
2331036	2331036	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_6	1	1
2331127	2331127	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_6	8	8
2331163	2331163	WI	Milwaukee	school	5500077	8137	Non District Charter Schools	United Community Center Acosta Middle	550007703047	8137	United Community Center Acosta Middle School	charter	Regular School	Yes	Middle	06	08	2020	grade_6	66	66
2331212	2331212	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001153	70	Core Knowledge Charter School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_6	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]);