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

Data source: Big Local News · About: Big Local

1,106 rows where grade = "grade_1", 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
3073889	3073889	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_1	59	59
3074139	3074139	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_1	28	28
3074156	3074156	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	20	20
3074188	3074188	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	52	52
3074236	3074236	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	11	11
3074355	3074355	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	47	47
3074383	3074383	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	17	17
3074679	3074679	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	grade_1	14	14
3075032	3075032	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	9	9
3075293	3075293	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	131	131
3075433	3075433	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_1	6	6
3075496	3075496	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_1	17	17
3075594	3075594	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_1	46	46
3075657	3075657	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_1	5	5
3075913	3075913	WI	Columbia	school	5502820	1183	Public school	Columbus	550282002734	110	Discovery Charter School	charter	Regular School	Yes	Elementary	KG	03	2019	grade_1	21	21
3076067	3076067	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	1	1
3076175	3076175	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_1	29	29
3076401	3076401	WI	Milwaukee	school	5500039	8101	Non District Charter Schools	Downtown Montessori	550003902153	1056	Downtown Montessori	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	31	31
3076467	3076467	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_1	48	48
3076721	3076721	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2019	grade_1	11	11
3078069	3078069	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_1	10	10
3078123	3078123	WI	Iowa	school	5506420	2527	Public school	Highland	550642000698	20	Highland Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	20	20
3078493	3078493	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_1	28	28
3078530	3078530	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2019	grade_1	2	2
3078766	3078766	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002878	110	New Directions Learning Community	charter	Regular School	Yes	Elementary	PK	04	2019	grade_1	42	42
3078773	3078773	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729000795	80	Park Community Charter School	charter	Regular School	Yes	Elementary	KG	04	2019	grade_1	45	45
3078811	3078811	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001285	65	Brompton School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	22	22
3078828	3078828	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002457	130	Dimensions of Learning Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	23	23
3078946	3078946	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_1	110	110
3079124	3079124	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351002914	180	Kettle Moraine Explore	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	21	21
3079177	3079177	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000839	100	i4Learning Community School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	23	23
3079320	3079320	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	2019	grade_1	36	36
3079336	3079336	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_1	17	17
3079418	3079418	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_1	20	20
3079691	3079691	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002959	130	Flex Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	17	17
3080046	3080046	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003356	125	Nuestro Mundo	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	54	54
3080474	3080474	WI	Juneau	school	5508850	3360	Public school	Mauston	550885003030	110	Mauston Montessori Charter School	charter	Regular School	Yes	Elementary	PK	03	2019	grade_1	13	13
3080543	3080543	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_1	59	59
3080571	3080571	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002598	9100	Rural Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	39	39
3080829	3080829	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002927	800	Bridges Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	60	60
3080858	3080858	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002917	110	Maple Grove School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	16	16
3080900	3080900	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_1	1	1
3081019	3081019	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_1	81	81
3081344	3081344	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	21	21
3081569	3081569	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_1	147	147
3081637	3081637	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001847	852	Highland Community School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	46	46
3081661	3081661	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001246	334	Honey Creek Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	64	64
3081694	3081694	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_1	24	24
3081780	3081780	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001317	1121	La Causa Charter School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	79	79
3081945	3081945	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_1	51	51
3081956	3081956	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_1	52	52
3081967	3081967	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_1	52	52
3081978	3081978	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_1	51	51
3081999	3081999	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002949	118	Milwaukee Environmental Science Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	49	49
3082427	3082427	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001271	398	Whittier Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	25	25
3082466	3082466	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_1	87	87
3082486	3082486	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_1	28	28
3082497	3082497	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_1	75	75
3082780	3082780	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006003354	110	Eagleville Charter School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_1	21	21
3082881	3082881	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Alliance Charter Elementary	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	22	22
3083010	3083010	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	11	11
3083350	3083350	WI	Ozaukee	school	5504890	1945	Public school	Northern Ozaukee	550489002801	850	Wisconsin Virtual Learning	charter	Regular School	Yes	Other	PK	12	2019	grade_1	10	10
3083398	3083398	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	Elementary	PK	04	2019	grade_1	12	12
3083421	3083421	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003015	100	Northwood Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	18	18
3083879	3083879	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119002719	110	Shapiro STEM Academy	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	35	35
3084075	3084075	WI	Milwaukee	school	5500078	8138	Non District Charter Schools	Penfield Montessori Academy	550007803048	8138	Penfield Montessori Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	17	17
3084407	3084407	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_1	1	1
3084910	3084910	WI	Oneida	school	5512720	4781	Public school	Rhinelander	551272001673	20	Northwoods Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	13	13
3085065	3085065	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302002978	130	Journey	charter	Regular School	Yes	Elementary	KG	02	2019	grade_1	44	44
3085114	3085114	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_1	24	24
3085198	3085198	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_1	81	81
3085206	3085206	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	2019	grade_1	12	12
3085282	3085282	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_1	2	2
3085373	3085373	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341002663	100	Merrimac Community	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	16	16
3085399	3085399	WI	Milwaukee	school	5500043	8107	Non District Charter Schools	School for Early Development and	550004302497	1279	School for Early Development and Achievement (SEDA)	charter	Regular School	Yes	Elementary	PK	02	2019	grade_1	17	17
3085405	3085405	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_1	37	37
3085514	3085514	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002908	110	LEADS Primary Charter School	charter	Regular School	Yes	Elementary	PK	02	2019	grade_1	18	18
3085551	3085551	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002716	190	Etude Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	33	33
3085612	3085612	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002733	150	Lake Country Academy - Charter	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	49	49
3085643	3085643	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_1	4	4
3085656	3085656	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002872	105	Sheboygan Leadership Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	22	22
3085995	3085995	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003358	170	Lakeview Montessori School	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	26	26
3086124	3086124	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	2019	grade_1	41	41
3086652	3086652	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491003028	110	Tomah Area Montessori School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	8	8
3086719	3086719	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002968	100	Tomorrow River Community Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	18	18
3086728	3086728	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_1	4	4
3086817	3086817	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1	6	6
3086906	3086906	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001153	70	Core Knowledge Charter School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_1	35	35
3086936	3086936	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001186	140	New Century School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	22	22
3086966	3086966	WI	Dane	school	5515330	5901	Public school	Verona Area	551533002849	150	Verona Area International School	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	23	23
3086983	3086983	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002972	140	Viroqua Area Montessori School	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1	17	17
3087230	3087230	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003003	150	eAchieve Elementary	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	9	9
3087353	3087353	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	78	78
3087457	3087457	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_1	17	17
3087592	3087592	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002629	150	Wausau Area Montessori Charter School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_1	14	14
3087759	3087759	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002728	150	Wauwatosa STEM	charter	Regular School	Yes	Elementary	KG	05	2019	grade_1	23	23
3088481	3088481	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002781	170	Mead Elementary Charter School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_1	51	51
3088575	3088575	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1	35	35
3088586	3088586	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_1	38	38
3073900	3073900	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	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]);