schools: enrollments: 1,471 rows where where grade = "k_12_total", state = "OR" and year = 2021 sorted by school_state

Data source: Big Local News · About: Big Local

1,471 rows where grade = "k_12_total", state = "OR" and year = 2021 sorted by school_state_id descending

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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int
657642	657642	OR	school	4100020	2143	North Santiam SD 29J	410002001891	5620	North Santiam Options Academy	Alternative School	No	Other	KG	12	2021	k_12_total	103	0	9	0	0	0	8	103	0	9	0	0	0	8
656985	656985	OR	school	4102910	2105	Central Linn SD 552	410291001890	5605	Central Linn Online Academy	Regular School	No	Other	KG	12	2021	k_12_total	63	0	7	0	0	0	3	63	0	7	0	0	0	3
656813	656813	OR	school	4101710	1894	Baker SD 5J	410171001879	5604	Baker Virtual Academy	Regular School	No	Elementary	KG	06	2021	k_12_total	74	0	0	0	0	0	9	74	0	0	0	0	0	9
657122	657122	OR	school	4104500	2043	Eagle Point SD 9	410450001885	5572	Kids Unlimited Academy White City	Regular School	Yes	Elementary	KG	KG	2021	k_12_total	13	0	14	0	0	0	2	13	0	14	0	0	0	2
657362	657362	OR	school	4100036	2200	InterMountain ESD	410003601892	5512	InterMountain Virtual Learning Academy	Regular School	No	Other	KG	12	2021	k_12_total	406	8	42	7	4	6	20	406	8	42	7	4	6	20
657523	657523	OR	school	4108040	2048	Medford SD 549C	410804001886	5510	Medford Online Academy	Regular School	No	Elementary	KG	08	2021	k_12_total	351	2	83	3	18	0	47	351	2	83	3	18	0	47
656809	656809	OR	school	4101710	1894	Baker SD 5J	410171001878	5509	Baker Early Learning Center	Regular School	No	Elementary	KG	KG	2021	k_12_total	53	0	11	0	0	0	3	53	0	11	0	0	0	3
656849	656849	OR	school	4101920	2243	Beaverton SD 48J	410192001894	5506	FLEX Online School	Regular School	No	Other	KG	12	2021	k_12_total	737	22	156	4	150	22	122	737	22	156	4	150	22	122
658154	658154	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001888	5505	Southern Oregon Success Academy	Regular School	Yes	High	06	12	2021	k_12_total	84	1	18	1	0	2	13	84	1	18	1	0	2	13
657891	657891	OR	school	4110350	1977	Redmond SD 2J	411035001884	5500	Hugh Hartman Elementary	Regular School	No	Elementary	KG	03	2021	k_12_total	116	0	108	0	2	0	10	116	0	108	0	2	0	10
657025	657025	OR	school	4103390	1964	Coquille SD 8	410339001881	5498	Winter Lakes Elementary	Alternative School	No	Elementary	KG	07	2021	k_12_total	114	0	4	1	0	0	12	114	0	4	1	0	0	12
657016	657016	OR	school	4103660	1965	Coos Bay SD 9	410366001882	5496	Marshfield Junior High	Regular School	No	Middle	07	07	2021	k_12_total	153	1	33	15	0	0	15	153	1	33	15	0	0	15
657749	657749	OR	school	4109600	1900	Philomath SD 17J	410960001880	5492	Philomath Academy	Alternative School	No	Other	KG	12	2021	k_12_total	163	0	12	2	4	0	13	163	0	12	2	4	0	13
657059	657059	OR	school	4103720	1970	Crook County SD	410372001883	5489	Steins Pillar Elementary	Regular School	No	Elementary	KG	04	2021	k_12_total	160	0	15	5	0	0	8	160	0	15	5	0	0	8
658021	658021	OR	school	4111040	2103	Scio SD 95	411104001876	5457	Willamette Connections Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	1639	28	257	16	28	12	179	1639	28	257	16	28	12	179
657443	657443	OR	school	4107230	1923	Lake Oswego SD 7J	410723001873	5455	Harmony Academy	Regular School	Yes	High	09	12	2021	k_12_total	19	1	1	0	0	0	5	19	1	1	0	0	0	5
656910	656910	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001875	5452	North Star Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	205	2	37	2	4	2	10	205	2	37	2	4	2	10
657603	657603	OR	school	4108830	1924	North Clackamas SD 12	410883001874	5451	Beatrice Morrow Cannady Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	220	7	39	0	107	0	39	220	7	39	0	107	0	39
657571	657571	OR	school	4180180	2148	Multnomah ESD		5450	Legacy 3						2021	k_12_total	6	0	1	0	0	0	0	6	0	1	0	0	0	0
657296	657296	OR	school	4103600	2015	Harney County SD 4	410360001870	5446	Oregon Family School	Regular School	Yes	Other	KG	12	2021	k_12_total	546	7	39	1	7	3	42	546	7	39	1	7	3	42
657497	657497	OR	school	4107740	2094	Marcola SD 79J	410774001872	5444	TEACH-NW	Regular School	Yes	Other	KG	12	2021	k_12_total	384	6	38	6	0	2	39	384	6	38	6	0	2	39
657936	657936	OR	school	4110680	2044	Rogue River SD 35	411068001863	5443	South Valley Academy	Regular School	No	Other	03	12	2021	k_12_total	75	0	9	3	1	0	10	75	0	9	3	1	0	10
657539	657539	OR	school	4108280	2249	Mitchell SD 55	410828001864	5441	Destinations Career Academy of Oregon	Regular School	Yes	High	09	12	2021	k_12_total	118	3	31	3	0	0	19	118	3	31	3	0	0	19
657538	657538	OR	school	4108280	2249	Mitchell SD 55	410828001869	5440	Cascade Virtual Academy	Regular School	Yes	Elementary	KG	08	2021	k_12_total	424	25	131	6	9	7	71	424	25	131	6	9	7	71
657535	657535	OR	school	4108160	2205	Milton-Freewater Unified SD 7	410816001861	5434	Gib Olinger Elementary School	Regular School	No	Elementary	KG	03	2021	k_12_total	178	2	280	1	0	0	12	178	2	280	1	0	0	12
657559	657559	OR	school	4108520	2147	Morrow SD 1	410852001865	5433	Morrow Education Center	Alternative School	No	Other	KG	12	2021	k_12_total	110	0	32	0	0	0	3	110	0	32	0	0	0	3
656922	656922	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001866	5429	Skyline High School	Regular School	No	High	09	12	2021	k_12_total	125	1	11	1	1	0	7	125	1	11	1	1	0	7
656917	656917	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001871	5428	Realms High School	Regular School	No	High	09	12	2021	k_12_total	121	0	10	1	1	0	3	121	0	10	1	1	0	3
657857	657857	OR	school	4110040	2180	Portland SD 1J	411004001868	5427	Rose City Park	Regular School	No	Elementary	KG	05	2021	k_12_total	282	12	40	0	135	4	54	282	12	40	0	135	4	54
657150	657150	OR	school	4104740	2082	Eugene SD 4J	410474001858	5408	Chinese Language Immersion School	Regular School	No	Elementary	KG	05	2021	k_12_total	55	0	3	0	13	0	17	55	0	3	0	13	0	17
657573	657573	OR	school	4180180	2148	Multnomah ESD		5399	Providence Medical Center						2021	k_12_total	0	0	0	1	0	0	0	0	0	0	1	0	0	0
657109	657109	OR	school	4110710	1991	Douglas County SD 4	411071001853	5398	Rose School	Alternative School	No	High	09	12	2021	k_12_total	29	0	7	0	0	0	2	29	0	7	0	0	0	2
657220	657220	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	456	7	77	5	8	5	31	456	7	77	5	8	5	31
658027	658027	OR	school	4111100	1935	Seaside SD 10	411110001857	5385	The Cannon Beach Academy	Regular School	Yes	Elementary	KG	05	2021	k_12_total	28	0	11	2	0	0	2	28	0	11	2	0	0	2
656894	656894	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001860	5384	Desert Sky Montessori	Regular School	Yes	Elementary	KG	06	2021	k_12_total	138	0	8	0	3	0	13	138	0	8	0	3	0	13
656871	656871	OR	school	4101920	2243	Beaverton SD 48J	410192001856	5382	Sato Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	184	25	79	6	333	5	35	184	25	79	6	333	5	35
656863	656863	OR	school	4101920	2243	Beaverton SD 48J	410192001855	5381	Mountainside High School	Regular School	No	High	09	12	2021	k_12_total	1055	42	253	4	232	8	160	1055	42	253	4	232	8	160
656964	656964	OR	school	4102780	2139	Cascade SD 5	410278001854	5380	Cascade Opportunity Center	Alternative School	No	High	09	12	2021	k_12_total	66	0	22	2	0	0	8	66	0	22	2	0	0	8
658211	658211	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001851	5377	Meridian Creek Middle School	Regular School	No	Middle	06	08	2021	k_12_total	277	7	57	2	25	3	28	277	7	57	2	25	3	28
657366	657366	OR	school	4106740	2053	Jefferson County SD 509J	410674001852	5359	Bridges High School	Alternative School	No	High	09	12	2021	k_12_total	16	2	9	45	0	0	0	16	2	9	45	0	0	0
658133	658133	OR	school	4111940	2003	Sutherlin SD 130	411194001849	5357	Sutherlin Valley Online Academy	Regular School	No	Other	03	12	2021	k_12_total	39	0	9	1	0	0	4	39	0	9	1	0	0	4
657421	657421	OR	school	4107080	2056	Klamath Falls City Schools	410708001847	5355	Klamath Learning Center	Alternative School	No	Other	KG	12	2021	k_12_total	205	5	68	17	1	0	24	205	5	68	17	1	0	24
657487	657487	OR	school	4107590	2092	Lowell SD 71	410759001846	5349	Bridge Charter Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	658	4	61	4	2	0	49	658	4	61	4	2	0	49
657896	657896	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Not reported	M	M	2021	k_12_total	-	-	-	-	-	-	-
656889	656889	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001845	5309	Bend International School	Regular School	Yes	Elementary	KG	08	2021	k_12_total	156	0	33	2	3	1	20	156	0	33	2	3	1	20
657861	657861	OR	school	4110040	2180	Portland SD 1J		5305	SAGE Youth Residential Program						2021	k_12_total	7	0	4	1	1	0	2	7	0	4	1	1	0	2
657530	657530	OR	school	4108040	2048	Medford SD 549C	410804001843	5304	The Valley School of Southern Oregon	Regular School	Yes	Middle	06	08	2021	k_12_total	99	1	13	0	2	1	4	99	1	13	0	2	1	4
657049	657049	OR	school	4103720	1970	Crook County SD	410372001840	5302	Barnes Butte Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	266	1	97	6	0	0	13	266	1	97	6	0	0	13
658008	658008	OR	school	4110980	1944	Scappoose SD 1J		5300	Oregon Outreach Inc - Scappoose SD						2021	k_12_total	19	0	5	0	0	0	1	19	0	5	0	0	0	1
657065	657065	OR	school	4103860	2190	Dallas SD 2	410386001835	5298	Dallas Community Charter	Regular School	Yes	Elementary	KG	08	2021	k_12_total	194	1	2	1	0	0	13	194	1	2	1	0	0	13
657534	657534	OR	school	4108160	2205	Milton-Freewater Unified SD 7	410816001842	5296	Ferndale Elementary School	Regular School	No	Elementary	04	05	2021	k_12_total	93	3	161	0	2	1	2	93	3	161	0	2	1	2
656920	656920	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001844	5293	Silver Rail Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	314	6	68	3	6	1	17	314	6	68	3	6	1	17
656912	656912	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001839	5292	Pacific Crest Middle School	Regular School	No	Middle	06	08	2021	k_12_total	502	7	28	1	5	2	20	502	7	28	1	5	2	20
657740	657740	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2021	k_12_total	133	1	27	18	1	0	22	133	1	27	18	1	0	22
657851	657851	OR	school	4110040	2180	Portland SD 1J		5270	Providence Pediatric Nursing Facility						2021	k_12_total	12	0	1	0	0	0	0	12	0	1	0	0	0	0
656976	656976	OR	school	4102800	2185	Centennial SD 28J		5268	Open School East						2021	k_12_total	46	18	28	0	0	0	12	46	18	28	0	0	0	12
657491	657491	OR	school	4107590	2092	Lowell SD 71	410759001834	5252	Mountain View Academy	Regular School	Yes	Elementary	KG	08	2021	k_12_total	115	0	11	0	0	0	11	115	0	11	0	0	0	11
657116	657116	OR	school	4104500	2043	Eagle Point SD 9	410450001831	5251	Crater Lake Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	279	0	37	1	1	1	12	279	0	37	1	1	1	12
657654	657654	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Riverbend Community School	Regular School	Yes	High	09	12	2021	k_12_total	21	1	5	0	0	0	2	21	1	5	0	0	0	2
657819	657819	OR	school	4110040	2180	Portland SD 1J	411004001830	5218	Kairos PDX	Regular School	Yes	Elementary	KG	05	2021	k_12_total	55	102	20	7	1	0	38	55	102	20	7	1	0	38
657518	657518	OR	school	4108040	2048	Medford SD 549C	410804001829	5205	Kids Unlimited Academy	Regular School	Yes	Elementary	KG	08	2021	k_12_total	104	2	349	3	3	3	16	104	2	349	3	3	3	16
658227	658227	OR	school	4113490	2002	Winston-Dillard SD 116	411349001828	5201	Dillard Alternative High School	Alternative School	No	High	09	12	2021	k_12_total	41	0	4	2	0	2	6	41	0	4	2	0	2	6
657005	657005	OR	school	4103260	1945	Clatskanie SD 6J		5200	Washington School for the Blind						2021	k_12_total	0	0	0	0	0	0	1	0	0	0	0	0	0	1
658078	658078	OR	school	4111610	1994	South Umpqua SD 19		5200	Washington School for the Blind						2021	k_12_total	1	0	0	0	0	0	0	1	0	0	0	0	0	0
657485	657485	OR	school		2098	Linn Benton Lincoln ESD		5160	Wake Robin School						2021	k_12_total	8	1	2	1	1	0	2	8	1	2	1	1	0	2
657286	657286	OR	school	4106000	2183	Gresham-Barlow SD 10J		5152	Rosemary Anderson High School - East (Gresham)						2021	k_12_total	31	18	57	1	4	1	7	31	18	57	1	4	1	7
657540	657540	OR	school	4108280	2249	Mitchell SD 55	410828001813	5150	Insight School of Oregon Painted Hills	Regular School	Yes	High	07	12	2021	k_12_total	251	11	90	6	1	2	38	251	11	90	6	1	2	38
657938	657938	OR	school	4110820	2142	Salem-Keizer SD 24J	411082001819	5066	Battle Creek Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	312	5	116	4	14	8	52	312	5	116	4	14	8	52
657942	657942	OR	school	4110820	2142	Salem-Keizer SD 24J	411082001826	5064	Cesar E Chavez Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	96	10	407	0	16	26	14	96	10	407	0	16	26	14
658158	658158	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001812	5063	Woodland Charter School	Regular School	Yes	Elementary	01	08	2021	k_12_total	150	2	8	0	0	0	5	150	2	8	0	0	0	5
658018	658018	OR	school	4111040	2103	Scio SD 95	411104001818	5061	Oregon Virtual Education	Regular School	No	Not reported	M	M	2021	k_12_total	-	-	-	-	-	-	-
657823	657823	OR	school	4110040	2180	Portland SD 1J	411004001814	5060	Le Monde French Immersion Public Charter School	Regular School	Yes	Elementary	KG	08	2021	k_12_total	315	14	17	3	2	0	39	315	14	17	3	2	0	39
658112	658112	OR	school	4111670	2083	Springfield SD 19	411167001815	5059	Two Rivers Dos Rios Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	217	3	110	2	1	0	19	217	3	110	2	1	0	19
657900	657900	OR	school	4110350	1977	Redmond SD 2J	411035001820	5058	Ridgeview High School	Regular School	No	High	09	12	2021	k_12_total	683	7	225	3	4	2	39	683	7	225	3	4	2	39
658216	658216	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001825	5057	Trillium Creek Primary School	Regular School	No	Elementary	PK	05	2021	k_12_total	367	4	29	1	27	3	70	367	4	29	1	27	3	70
658210	658210	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001822	5056	Lowrie Primary School	Regular School	No	Elementary	PK	05	2021	k_12_total	282	4	129	0	25	0	48	282	4	129	0	25	0	48
657325	657325	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2021	k_12_total	806	29	158	7	31	5	109	806	29	158	7	31	5	109
656854	656854	OR	school	4101920	2243	Beaverton SD 48J	410192001823	4867	Hope Chinese Charter School	Regular School	Yes	Elementary	KG	08	2021	k_12_total	75	3	22	0	132	0	102	75	3	22	0	132	0	102
657992	657992	OR	school	4110820	2142	Salem-Keizer SD 24J	411082001805	4859	Straub Middle School	Regular School	No	Middle	06	08	2021	k_12_total	401	6	130	6	19	9	50	401	6	130	6	19	9	50
657966	657966	OR	school	4110820	2142	Salem-Keizer SD 24J	411082001809	4858	Kalapuya Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	339	3	80	6	15	4	47	339	3	80	6	15	4	47
657026	657026	OR	school	4103390	1964	Coquille SD 8	410339001804	4857	Winter Lakes High	Alternative School	No	High	08	12	2021	k_12_total	260	0	20	13	0	0	27	260	0	20	13	0	0	27
657933	657933	OR	school	4110680	2044	Rogue River SD 35	411068001811	4856	Rivers Edge Academy Charter School	Regular School	Yes	Other	KG	12	2021	k_12_total	174	0	16	3	0	1	15	174	0	16	3	0	1	15
657712	657712	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2021	k_12_total	89	2	30	0	2	0	16	89	2	30	0	2	0	16
657399	657399	OR	school	4107020	2057	Klamath County SD	410702001807	4848	Falcon Heights	Alternative School	No	High	05	12	2021	k_12_total	62	2	11	16	0	0	6	62	2	11	16	0	0	6
657363	657363	OR	school	4100036	2200	InterMountain ESD		4846	Lifeways Inc						2021	k_12_total	9	0	0	0	0	0	1	9	0	0	0	0	0	1
658029	658029	OR	school	4111220	2257	Sheridan SD 48J	411122001803	4833	Sheridan AllPrep Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	141	10	19	7	1	0	11	141	10	19	7	1	0	11
657219	657219	OR	school	4105430	2245	Gaston SD 511J		4826	Victory Academy						2021	k_12_total	1	0	0	0	0	0	0	1	0	0	0	0	0	0
657872	657872	OR	school	4110040	2180	Portland SD 1J		4826	Victory Academy						2021	k_12_total	1	0	0	0	0	0	0	1	0	0	0	0	0	0
658155	658155	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001797	4823	Sunny Wolf Charter School	Regular School	Yes	Elementary	PK	06	2021	k_12_total	99	0	8	1	0	0	9	99	0	8	1	0	0	9
657921	657921	OR	school	4110520	2182	Reynolds SD 7	411052001798	4822	Rockwood Preparatory Academy	Regular School	Yes	Elementary	KG	07	2021	k_12_total	61	44	153	0	10	6	21	61	44	153	0	10	6	21
657519	657519	OR	school	4108040	2048	Medford SD 549C	410804001796	4821	Logos Public Charter School	Regular School	Yes	Other	KG	12	2021	k_12_total	885	6	99	9	6	3	53	885	6	99	9	6	3	53
657722	657722	OR	school	4110890	1926	Oregon Trail SD 46	411089001799	4820	Oregon Trail Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	234	2	24	2	3	0	27	234	2	24	2	3	0	27
657549	657549	OR	school	4108310	1925	Molalla River SD 35	410831001800	4818	Renaissance Public Academy	Regular School	Yes	Other	03	12	2021	k_12_total	67	1	12	0	0	1	3	67	1	12	0	0	1	3
657175	657175	OR	school	4104740	2082	Eugene SD 4J		4811	River Road Campus						2021	k_12_total	2	2	2	1	0	0	2	2	2	2	1	0	0	2
656829	656829	OR	school	4101920	2243	Beaverton SD 48J	410192001791	4805	Arco Iris Spanish Immersion School	Regular School	Yes	Elementary	KG	08	2021	k_12_total	183	2	196	4	5	1	47	183	2	196	4	5	1	47
657700	657700	OR	school	4109330	1928	Oregon City SD 62	410933001793	4802	Clackamas Academy of Industrial Sciences	Regular School	Yes	High	06	12	2021	k_12_total	236	1	18	2	2	0	15	236	1	18	2	2	0	15
656919	656919	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001794	4793	Rosland Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	182	0	8	3	5	0	10	182	0	8	3	5	0	10
658203	658203	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001786	4773	Arts and Technology High School	Alternative School	No	High	09	12	2021	k_12_total	53	0	19	0	3	1	9	53	0	19	0	3	1	9
657624	657624	OR	school	4108830	1924	North Clackamas SD 12	410883001379	4767	Rock Creek Middle School	Regular School	No	Middle	06	08	2021	k_12_total	495	16	156	2	108	1	64	495	16	156	2	108	1	64
657621	657621	OR	school	4108830	1924	North Clackamas SD 12	410883000008	4766	Oregon Trail Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	245	10	61	3	82	3	52	245	10	61	3	82	3	52

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