schools: enrollments: 673 rows where where grade = "grade_6", state = "IN" and year = 2020 sorted by school_nces

Data source: Big Local News · About: Big Local

673 rows where grade = "grade_6", state = "IN" and year = 2020 sorted by school_nces_id

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	male	female	total	male_int	female_int	total_int
1909860	1909860	IN	school	1800008	2980	White River Valley School District	180000802304	2457	White River Valley Middle School	Regular School	No	Middle	05	08	2020	grade_6	32.0	25.0	57.0	32	25	57
1918313	1918313	IN	school	1800011	9320	Community Montessori Inc	180001101737	1536	Community Montessori	Regular School	Yes	Other	PK	12	2020	grade_6	23.0	22.0	45.0	23	22	45
1918333	1918333	IN	school	1800014	9330	Irvington Community School	180001401756	1537	Irvington Community School	Regular School	Yes	Other	KG	12	2020	grade_6	38.0	45.0	83.0	38	45	83
1918376	1918376	IN	school	1800018	9380	Christel House Academy South	180001801789	5874	Christel House Academy South	Regular School	Yes	Other	KG	12	2020	grade_6	27.0	27.0	54.0	27	27	54
1918551	1918551	IN	school	1800023	9605	IN Sch for the Blind & Vis Imprd	180002302257	C460	IN Sch for the Blind & Vis Imprd	Special Education School	No	Other	PK	12	2020	grade_6	6.0	3.0	9.0	6	3	9
1918566	1918566	IN	school	1800024	9610	Indiana School For The Deaf	180002402258	C695	Indiana School For The Deaf	Special Education School	No	Other	PK	12	2020	grade_6	11.0	10.0	21.0	11	10	21
1918438	1918438	IN	school	1800025	9460	Thea Bowman Leadership Academy	180002501807	4022	Thea Bowman Leadership Academy	Regular School	Yes	Other	KG	12	2020	grade_6	41.0	41.0	82.0	41	41	82
1918295	1918295	IN	school	1800027	9310	Charter School of the Dunes	180002701815	1535	Charter School of the Dunes	Regular School	Yes	Elementary	KG	08	2020	grade_6	37.0	39.0	76.0	37	39	76
1918396	1918396	IN	school	1800028	9400	KIPP Indy College Prep Middle	180002802136	5860	KIPP Indy College Prep Middle	Regular School	Yes	Middle	06	08	2020	grade_6	27.0	34.0	61.0	27	34	61
1907071	1907071	IN	school	1800030	125	M S D Southwest Allen County Schls	180003000005	67	Woodside Middle School	Regular School	No	Middle	06	08	2020	grade_6	156.0	163.0	319.0	156	163	319
1907060	1907060	IN	school	1800030	125	M S D Southwest Allen County Schls	180003000116	63	Summit Middle School	Regular School	No	Middle	06	08	2020	grade_6	140.0	136.0	276.0	140	136	276
1918459	1918459	IN	school	1800033	9485	SE Neighborhood Sch of Excellence	180003302144	5868	SE Neighborhood Sch of Excellence	Regular School	Yes	Elementary	KG	08	2020	grade_6	38.0	37.0	75.0	38	37	75
1918469	1918469	IN	school	1800037	9495	Joshua Academy	180003702146	8203	Joshua Academy	Regular School	Yes	Elementary	KG	07	2020	grade_6	10.0	8.0	18.0	10	8	18
1918592	1918592	IN	school	1800038	9620	Burris Laboratory School	180003800185	1441	Burris Laboratory School	Regular School	No	Other	KG	12	2020	grade_6	27.0	32.0	59.0	27	32	59
1918578	1918578	IN	school	1800042	9615	Andrew J Brown Academy	180004201816	5488	Andrew J Brown Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	41.0	34.0	75.0	41	34	75
1918449	1918449	IN	school	1800043	9465	Rural Community Schools Inc	180004302138	7951	Rural Community Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	7.0	6.0	13.0	7	6	13
1918502	1918502	IN	school	1800046	9545	21st Century Charter Sch of Gary	180004602162	4164	21st Century Charter Sch of Gary	Regular School	Yes	Other	KG	12	2020	grade_6	53.0	49.0	102.0	53	49	102
1918513	1918513	IN	school	1800048	9555	East Chicago Urban Enterprise Acad	180004802163	3935	East Chicago Urban Enterprise Acad	Regular School	Yes	Elementary	KG	08	2020	grade_6	27.0	13.0	40.0	27	13	40
1918526	1918526	IN	school	1800051	9575	Victory College Prep Academy	180005102165	5523	Victory College Prep Academy	Regular School	Yes	Other	KG	12	2020	grade_6	37.0	45.0	82.0	37	45	82
1918488	1918488	IN	school	1800052	9535	Gary Lighthouse Charter School	180005202155	4130	Gary Lighthouse Charter School	Regular School	Yes	Other	KG	12	2020	grade_6	62.0	53.0	115.0	62	53	115
1918537	1918537	IN	school	1800054	9595	East Chicago Lighthouse Charter	180005402235	3971	East Chicago Lighthouse	Regular School	Yes	Elementary	KG	08	2020	grade_6	26.0	32.0	58.0	26	32	58
1918604	1918604	IN	school	1800056	9640	Options Charter School Noblesville	180005602313	2551	Options Charter School Noblesville	Regular School	Yes	High	06	12	2020	grade_6	4.0	3.0	7.0	4	3	7
1906987	1906987	IN	school	1800060	15	Adams Central Community Schools	180006000008	13	Adams Central Middle School	Regular School	No	Middle	06	08	2020	grade_6	62.0	45.0	107.0	62	45	107
1918631	1918631	IN	school	1800061	9665	Geist Montessori Academy	180006102387	2572	Geist Montessori Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	23.0	19.0	42.0	23	19	42
1918666	1918666	IN	school	1800065	9690	Renaissance Academy Charter School	180006502415	4711	Renaissance Academy Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_6	12.0	11.0	23.0	12	11	23
1918721	1918721	IN	school	1800067	9785	IN Math & Science Academy	180006702416	5837	IN Math & Science Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	34.0	28.0	62.0	34	28	62
1918656	1918656	IN	school	1800071	9685	Aspire Charter Academy	180007102443	4043	Aspire Charter Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	36.0	39.0	75.0	36	39	75
1918745	1918745	IN	school	1800072	9805	Hoosier Academy - Indianapolis	180007202422	2527	Hoosier Academy - Indianapolis	Regular School	Yes	Elementary	KG	08	2020	grade_6	11.0	8.0	19.0	11	8	19
1918734	1918734	IN	school	1800077	9790	Anderson Preparatory Academy	180007702425	5092	Anderson Preparatory Academy	Regular School	Yes	Other	KG	12	2020	grade_6	34.0	24.0	58.0	34	24	58
1918674	1918674	IN	school	1800082	9705	Hammond Academy of Science & Tech	180008202466	4486	Hammond Academy of Science & Tech	Regular School	Yes	High	06	12	2020	grade_6	49.0	42.0	91.0	49	42	91
1918755	1918755	IN	school	1800083	9835	The Bloomington Project School	180008302446	6215	The Bloomington Project School	Regular School	Yes	Elementary	KG	08	2020	grade_6	26.0	12.0	38.0	26	12	38
1918646	1918646	IN	school	1800086	9680	Paramount Brookside	180008602478	5508	Paramount Brookside	Regular School	Yes	Elementary	KG	08	2020	grade_6	51.0	44.0	95.0	51	44	95
1918772	1918772	IN	school	1800088	9870	Discovery Charter School	180008802495	6824	Discovery Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_6	29.0	25.0	54.0	29	25	54
1918808	1918808	IN	school	1800094	9895	IN Math & Science Academy - North	180009402487	5444	IN Math & Science Academy - North	Regular School	Yes	Other	KG	12	2020	grade_6	29.0	28.0	57.0	29	28	57
1918825	1918825	IN	school	1800098	9905	Indiana Connections Academy	180009802474	7944	Indiana Connections Academy	Regular School	Yes	Other	KG	12	2020	grade_6	140.0	139.0	279.0	140	139	279
1918785	1918785	IN	school	1800099	9875	Rock Creek Community Academy	180009902497	771	Rock Creek Community Academy	Regular School	Yes	Other	KG	12	2020	grade_6	25.0	33.0	58.0	25	33	58
1912572	1912572	IN	school	1800107	4915	Tri-Township Cons School Corp	180010702520	4696	Wanatah School	Regular School	No	Elementary	PK	08	2020	grade_6	10.0	18.0	28.0	10	18	28
1918844	1918844	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	01	12	2020	grade_6	9.0	1.0	10.0	9	1	10
1915154	1915154	IN	school	1800118	6375	North Central Parke Comm Schl Corp	180011802667	6652	Parke Heritage Middle School	Regular School	No	Middle	06	08	2020	grade_6	42.0	31.0	73.0	42	31	73
1912915	1912915	IN	school	1800120	5265	Alexandria Community School Corp	180012000010	5065	Alexandria-Monroe Intermediate	Regular School	No	Elementary	03	06	2020	grade_6	70.0	51.0	121.0	70	51	121
1918698	1918698	IN	school	1800123	9735	Inspire Academy - A Sch of Inquiry	180012302560	1518	Inspire Academy - A Sch of Inquiry	Regular School	Yes	Elementary	KG	08	2020	grade_6	8.0	5.0	13.0	8	5	13
1918854	1918854	IN	school	1800124	9925	Phalen Leadership Academy - IN Inc	180012402550	5496	Phalen Leadership Academy - IN Inc	Regular School	Yes	Elementary	KG	07	2020	grade_6	21.0	19.0	40.0	21	19	40
1918684	1918684	IN	school	1800129	9725	Canaan Community Academy	180012902534	3312	Canaan Community Academy	Regular School	Yes	Elementary	KG	06	2020	grade_6	11.0	2.0	13.0	11	2	13
1918711	1918711	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2020	grade_6	4.0	0.0	4.0	4	0	4
1918363	1918363	IN	school	1800137	9365	Enlace Academy	180013702551	5667	Enlace Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	34.0	41.0	75.0	34	41	75
1918412	1918412	IN	school	1800145	9425	Tindley Genesis Academy	180014502595	5621	Tindley Genesis Academy	Regular School	Yes	Elementary	KG	06	2020	grade_6	28.0	36.0	64.0	28	36	64
1918863	1918863	IN	school	1800146	9935	Vision Academy	180014602566	5899	Vision Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	28.0	21.0	49.0	28	21	49
1918420	1918420	IN	school	1800148	9430	Tindley Summit Academy	180014802563	5629	Tindley Summit Academy	Regular School	Yes	Elementary	KG	06	2020	grade_6	12.0	28.0	40.0	12	28	40
1918392	1918392	IN	school	1800149	9395	Christel House Academy West	180014902568	5871	Christel House Academy West	Regular School	Yes	Elementary	KG	07	2020	grade_6	28.0	28.0	56.0	28	28	56
1912939	1912939	IN	school	1800150	5275	Anderson Community School Corp	180015002682	4967	Anderson Intermediate School	Regular School	No	Middle	05	06	2020	grade_6	282.0	261.0	543.0	282	261	543
1918899	1918899	IN	school	1800164	9965	Career Academy Middle School	180016402593	7563	Career Academy Middle School	Regular School	Yes	Middle	06	08	2020	grade_6	91.0	52.0	143.0	91	52	143
1918876	1918876	IN	school	1800165	9950	Dugger Union Community School Corp	180016502590	7952	Dugger Union Community School Corp	Regular School	Yes	Other	KG	12	2020	grade_6	12.0	14.0	26.0	12	14	26
1918887	1918887	IN	school	1800168	9955	Mays Community Academy	180016802582	7231	Mays Community Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	17.0	19.0	36.0	17	19	36
1918914	1918914	IN	school	1800170	9975	Global Preparatory Academy	180017002610	1112	Global Preparatory Academy	Regular School	Yes	Elementary	KG	06	2020	grade_6	39.0	34.0	73.0	39	34	73
1918934	1918934	IN	school	1800176	9985	Seven Oaks Classical School	180017602603	1114	Seven Oaks Classical School	Regular School	Yes	Other	KG	11	2020	grade_6	10.0	16.0	26.0	10	16	26
1918945	1918945	IN	school	1800178	9990	Higher Institute of Arts & Tech	180017802602	1116	Higher Institute of Arts & Tech	Regular School	Yes	Elementary	KG	08	2020	grade_6	18.0	8.0	26.0	18	8	26
1914236	1914236	IN	school	1800180	5470	Argos Community Schools	180018000048	5937	Argos Comm Jr-Sr High School	Regular School	No	High	06	12	2020	grade_6	23.0	17.0	40.0	23	17	40
1918164	1918164	IN	school	1800184	9040	Avondale Meadows Middle School	180018402620	7094	Avondale Meadows Middle School	Regular School	Yes	Middle	06	08	2020	grade_6	28.0	33.0	61.0	28	33	61
1918145	1918145	IN	school	1800190	9010	Ignite Achievement Academy	180019002635	1806	Ignite Achievement Academy	Regular School	Yes	Elementary	KG	06	2020	grade_6	35.0	19.0	54.0	35	19	54
1918221	1918221	IN	school	1800192	9095	Urban ACT Academy	180019202640	9094	Urban ACT Academy	Regular School	Yes	Elementary	KG	08	2020	grade_6	19.0	22.0	41.0	19	22	41
1918197	1918197	IN	school	1800193	9080	Vanguard Collegiate of Indy	180019302639	1004	Vanguard Collegiate of Indy	Regular School	Yes	Middle	05	08	2020	grade_6	7.0	8.0	15.0	7	8	15
1918211	1918211	IN	school	1800194	9090	Matchbook Learning	180019402642	1041	Matchbook Learning	Regular School	Yes	Elementary	KG	08	2020	grade_6	37.0	28.0	65.0	37	28	65
1918283	1918283	IN	school	1800203	9195	Timothy L. Johnson Academy Middle	180020302668	1039	Timothy L. Johnson Academy Middle	Regular School	Yes	Middle	06	08	2020	grade_6	19.0	18.0	37.0	19	18	37
1918100	1918100	IN	school	1800204	8685	James & Rosemary Phalen Elementary	180020400838	5593	James & Rosemary Phalen Elementary	Regular School	Yes	Elementary	KG	06	2020	grade_6	37.0	34.0	71.0	37	34	71
1918111	1918111	IN	school	1800205	8690	Dynamic Minds Academy	180020502673	8692	Dynamic Minds Academy	Regular School	Yes	Other	KG	12	2020	grade_6	5.0	4.0	9.0	5	4	9
1918275	1918275	IN	school	1800208	9165	Paramount Englewood	180020802655	7861	Paramount Englewood	Regular School	Yes	Middle	05	08	2020	grade_6	17.0	21.0	38.0	17	21	38
1909472	1909472	IN	school	1800210	2435	Attica Consolidated School Corp	180021000050	2053	Attica High School	Regular School	No	High	06	12	2020	grade_6	31.0	20.0	51.0	31	20	51
1908519	1908519	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000051	1197	Aurora Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	30.0	58.0	88.0	30	58	88
1908486	1908486	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000053	1141	Dillsboro Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	13.0	25.0	38.0	13	25	38
1908494	1908494	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000054	1165	Manchester Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	19.0	16.0	35.0	19	16	35
1908502	1908502	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000055	1169	Moores Hill Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	10.0	7.0	17.0	10	7	17
1910553	1910553	IN	school	1800270	3315	Avon Community School Corp	180027001256	2728	Avon Intermediate School East	Regular School	No	Middle	05	06	2020	grade_6	213.0	172.0	385.0	213	172	385
1910556	1910556	IN	school	1800270	3315	Avon Community School Corp	180027002092	2729	Avon Intermediate School West	Regular School	No	Middle	05	06	2020	grade_6	218.0	158.0	376.0	218	158	376
1908380	1908380	IN	school	1800330	1315	Barr-Reeve Community Schools Inc	180033000061	1069	Barr Reeve Middle/High School	Regular School	No	High	06	12	2020	grade_6	34.0	46.0	80.0	34	46	80
1907626	1907626	IN	school	1800360	365	Bartholomew Con School Corp	180036000070	371	L F Smith Elementary	Regular School	No	Elementary	KG	06	2020	grade_6	28.0	34.0	62.0	28	34	62
1907618	1907618	IN	school	1800360	365	Bartholomew Con School Corp	180036000071	369	Lillian Schmitt Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	48.0	42.0	90.0	48	42	90
1907583	1907583	IN	school	1800360	365	Bartholomew Con School Corp	180036000075	353	Mount Healthy Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	24.0	43.0	67.0	24	43	67
1907593	1907593	IN	school	1800360	365	Bartholomew Con School Corp	180036000077	357	Parkside Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	60.0	48.0	108.0	60	48	108
1907610	1907610	IN	school	1800360	365	Bartholomew Con School Corp	180036000079	366	Rockcreek Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	33.0	24.0	57.0	33	24	57
1907655	1907655	IN	school	1800360	365	Bartholomew Con School Corp	180036000080	392	Southside Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	53.0	65.0	118.0	53	65	118
1907643	1907643	IN	school	1800360	365	Bartholomew Con School Corp	180036000081	377	Taylorsville Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	44.0	39.0	83.0	44	39	83
1907602	1907602	IN	school	1800360	365	Bartholomew Con School Corp	180036000082	363	W D Richards Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	31.0	44.0	75.0	31	44	75
1907566	1907566	IN	school	1800360	365	Bartholomew Con School Corp	180036002188	328	Clifty Creek Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	30.0	23.0	53.0	30	23	53
1907575	1907575	IN	school	1800360	365	Bartholomew Con School Corp	180036002421	346	CSA Lincoln Campus	Regular School	No	Elementary	KG	06	2020	grade_6	31.0	21.0	52.0	31	21	52
1907634	1907634	IN	school	1800360	365	Bartholomew Con School Corp	180036002492	375	CSA Fodrea Campus	Regular School	No	Elementary	PK	06	2020	grade_6	26.0	18.0	44.0	26	18	44
1915795	1915795	IN	school	1800390	6895	Batesville Community School Corp	180039000085	7219	Batesville Middle School	Regular School	No	Middle	06	08	2020	grade_6	99.0	74.0	173.0	99	74	173
1909002	1909002	IN	school	1800420	2260	Baugo Community Schools	180042002026	1707	Jimtown Intermediate School	Regular School	No	Elementary	03	06	2020	grade_6	80.0	71.0	151.0	80	71	151
1913697	1913697	IN	school	1800450	5380	Beech Grove City Schools	180045000095	5461	South Grove Intermediate School	Regular School	No	Middle	04	06	2020	grade_6	102.0	123.0	225.0	102	123	225
1907700	1907700	IN	school	1800480	395	Benton Community School Corp	180048000098	433	Boswell Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	10.0	11.0	21.0	10	11	21
1907692	1907692	IN	school	1800480	395	Benton Community School Corp	180048000100	421	Otterbein Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	28.0	18.0	46.0	28	18	46
1907716	1907716	IN	school	1800480	395	Benton Community School Corp	180048002403	446	Prairie Crossing Elementary School	Regular School	No	Elementary	KG	06	2020	grade_6	36.0	35.0	71.0	36	35	71
1907724	1907724	IN	school	1800570	515	Blackford County Schools	180057000107	485	Montpelier School	Regular School	No	Elementary	KG	06	2020	grade_6	24.0	11.0	35.0	24	11	35
1907737	1907737	IN	school	1800570	515	Blackford County Schools	180057000108	494	North Side Elementary School	Regular School	No	Elementary	03	06	2020	grade_6	44.0	48.0	92.0	44	48	92
1909795	1909795	IN	school	1800600	2920	Bloomfield School District	180060000112	2417	Bloomfield Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	30.0	27.0	57.0	30	27	57
1914519	1914519	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000117	6181	Arlington Heights Elementary Sch	Regular School	No	Elementary	PK	06	2020	grade_6	26.0	24.0	50.0	26	24	50
1914511	1914511	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000118	6173	Binford Elementary School	Regular School	No	Elementary	03	06	2020	grade_6	67.0	53.0	120.0	67	53	120
1914528	1914528	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000123	6187	Childs Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	44.0	34.0	78.0	44	34	78
1914537	1914537	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000124	6189	Clear Creek Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	31.0	27.0	58.0	31	27	58
1914546	1914546	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000127	6197	Fairview Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	31.0	18.0	49.0	31	18	49
1914470	1914470	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000128	6157	Grandview Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6	35.0	34.0	69.0	35	34	69

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