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

Data source: Big Local News · About: Big Local

1,471 rows where grade = "k_12_total", state = "OR" and year = 2021 sorted by black_int 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
657077	657077	OR	school	4103940	2187	David Douglas SD 40	410394001037	983	David Douglas High School	Regular School	No	High	09	12	2021	k_12_total	909	339	779	22	504	63	191	909	339	779	22	504	63	191
657917	657917	OR	school	4110520	2182	Reynolds SD 7	411052001009	957	Reynolds High School	Regular School	No	High	09	12	2021	k_12_total	779	210	1171	21	218	68	157	779	210	1171	21	218	68	157
657818	657818	OR	school	4110040	2180	Portland SD 1J	411004000964	913	Jefferson High School	Regular School	No	High	09	12	2021	k_12_total	182	204	135	2	9	6	82	182	204	135	2	9	6	82
657855	657855	OR	school	4110040	2180	Portland SD 1J	411004001821	918	Roosevelt High School	Regular School	No	High	09	12	2021	k_12_total	431	203	466	15	42	35	101	431	203	466	15	42	35	101
657802	657802	OR	school	4110040	2180	Portland SD 1J	411004000890	847	Faubion Elementary School	Regular School	No	Elementary	PK	08	2021	k_12_total	177	198	206	13	13	10	84	177	198	206	13	13	10	84
657829	657829	OR	school	4110040	2180	Portland SD 1J	411004000968	915	Madison High School	Regular School	No	High	09	12	2021	k_12_total	405	168	294	10	149	24	119	405	168	294	10	149	24	119
657729	657729	OR	school	4109480	2181	Parkrose SD 3	410948000987	931	Parkrose High School	Regular School	No	High	09	12	2021	k_12_total	261	159	298	6	157	36	93	261	159	298	6	157	36	93
657810	657810	OR	school	4110040	2180	Portland SD 1J	411004001315	894	Harriet Tubman Middle School	Regular School	No	Middle	06	08	2021	k_12_total	151	158	65	2	6	2	60	151	158	65	2	6	2	60
657913	657913	OR	school	4110520	2182	Reynolds SD 7	411052001007	954	Hauton B Lee Middle School	Regular School	No	Middle	06	08	2021	k_12_total	144	145	307	4	106	42	46	144	145	307	4	106	42	46
657785	657785	OR	school	4110040	2180	Portland SD 1J	411004000876	833	Boise-Eliot Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	73	144	52	1	8	5	46	73	144	52	1	8	5	46
657811	657811	OR	school	4110040	2180	Portland SD 1J	411004000885	842	Harrison Park School	Regular School	No	Elementary	KG	08	2021	k_12_total	123	132	100	3	155	26	57	123	132	100	3	155	26	57
657086	657086	OR	school	4103940	2187	David Douglas SD 40	410394001676	4232	Ron Russell Middle School	Regular School	No	Middle	06	08	2021	k_12_total	291	117	247	5	120	19	51	291	117	247	5	120	19	51
657783	657783	OR	school	4110040	2180	Portland SD 1J	411004000956	906	Benson Polytechnic High School	Regular School	No	High	09	12	2021	k_12_total	440	117	271	6	66	7	98	440	117	271	6	66	7	98
657730	657730	OR	school	4109480	2181	Parkrose SD 3	410948000986	930	Parkrose Middle School	Regular School	No	Middle	06	08	2021	k_12_total	227	115	207	7	91	22	72	227	115	207	7	91	22	72
657807	657807	OR	school	4110040	2180	Portland SD 1J	411004000962	912	Grant High School	Regular School	No	High	09	12	2021	k_12_total	1374	114	147	11	54	6	260	1374	114	147	11	54	6	260
657840	657840	OR	school	4110040	2180	Portland SD 1J	411004000925	878	Ockley Green Middle School	Regular School	No	Middle	06	08	2021	k_12_total	186	114	111	1	13	9	52	186	114	111	1	13	9	52
658004	658004	OR	school	4108100	2104	Santiam Canyon SD 129J	410810001680	4399	Oregon Charter Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	3451	110	655	78	138	33	246	3451	110	655	78	138	33	246
657856	657856	OR	school	4110040	2180	Portland SD 1J	411004000872	829	Rosa Parks Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	34	109	75	4	3	9	32	34	109	75	4	3	9	32
657858	657858	OR	school	4110040	2180	Portland SD 1J		1669	Rosemary Anderson High School						2021	k_12_total	55	106	82	5	1	2	37	55	106	82	5	1	2	37
656970	656970	OR	school	4102800	2185	Centennial SD 28J	410280001020	967	Centennial High School	Regular School	No	High	09	12	2021	k_12_total	646	102	538	11	248	45	100	646	102	538	11	248	45	100
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
657914	657914	OR	school	4110520	2182	Reynolds SD 7	411052001001	948	Margaret Scott Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	75	101	113	1	44	19	42	75	101	113	1	44	19	42
657799	657799	OR	school	4110040	2180	Portland SD 1J	411004000911	866	Dr. Martin Luther King Jr. School	Regular School	No	Elementary	PK	05	2021	k_12_total	89	98	68	2	18	7	37	89	98	68	2	18	7	37
657805	657805	OR	school	4110040	2180	Portland SD 1J	411004000893	849	George Middle School	Regular School	No	Middle	06	08	2021	k_12_total	80	98	178	5	13	8	49	80	98	178	5	13	8	49
656827	656827	OR	school	4101920	2243	Beaverton SD 48J	410192001239	1186	Aloha High School	Regular School	No	High	09	12	2021	k_12_total	595	97	816	7	127	24	100	595	97	816	7	127	24	100
657870	657870	OR	school	4110040	2180	Portland SD 1J	411004000944	895	Vernon Elementary School	Regular School	No	Elementary	PK	08	2021	k_12_total	333	97	75	0	3	2	60	333	97	75	0	3	2	60
657878	657878	OR	school	4110040	2180	Portland SD 1J	411004000952	902	Woodlawn Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	117	94	54	2	5	4	42	117	94	54	2	5	4	42
657085	657085	OR	school	4103940	2187	David Douglas SD 40	410394001033	977	Mill Park Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	115	92	155	7	75	11	17	115	92	155	7	75	11	17
657804	657804	OR	school	4110040	2180	Portland SD 1J	411004000960	911	Franklin High School	Regular School	No	High	09	12	2021	k_12_total	1054	88	386	10	260	19	182	1054	88	386	10	260	19	182
657074	657074	OR	school	4103940	2187	David Douglas SD 40	410394001028	980	Alice Ott Middle School	Regular School	No	Middle	06	08	2021	k_12_total	282	85	172	5	104	20	50	282	85	172	5	104	20	50
657791	657791	OR	school	4110040	2180	Portland SD 1J	411004000884	841	Cesar Chavez K-8 School	Regular School	No	Elementary	KG	08	2021	k_12_total	112	85	285	3	8	14	36	112	85	285	3	8	14	36
656883	656883	OR	school	4101920	2243	Beaverton SD 48J	410192000554	1320	Westview High School	Regular School	No	High	09	12	2021	k_12_total	953	84	482	12	652	18	165	953	84	482	12	652	18	165
657859	657859	OR	school	4110040	2180	Portland SD 1J	411004000932	885	Roseway Heights School	Regular School	No	Middle	06	08	2021	k_12_total	240	80	140	4	81	6	63	240	80	140	4	81	6	63
657600	657600	OR	school	4108820	1966	North Bend SD 13	410882001751	4690	Oregon Virtual Academy	Regular School	Yes	Other	KG	12	2021	k_12_total	2266	77	514	30	51	9	268	2266	77	514	30	51	9	268
657911	657911	OR	school	4110520	2182	Reynolds SD 7	411052000999	946	Glenfair Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	82	75	162	4	40	14	33	82	75	162	4	40	14	33
657080	657080	OR	school	4103940	2187	David Douglas SD 40	410394001027	981	Floyd Light Middle School	Regular School	No	Middle	06	08	2021	k_12_total	235	72	221	3	79	21	66	235	72	221	3	79	21	66
657831	657831	OR	school	4110040	2180	Portland SD 1J	411004000919	1278	Markham Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	222	72	43	4	23	7	45	222	72	43	4	23	7	45
657081	657081	OR	school	4103940	2187	David Douglas SD 40	410394001029	973	Gilbert Heights Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	152	71	127	2	95	20	37	152	71	127	2	95	20	37
657275	657275	OR	school	4106000	2183	Gresham-Barlow SD 10J	410600001040	986	Gresham High School	Regular School	No	High	09	12	2021	k_12_total	652	71	626	8	52	17	106	652	71	626	8	52	17	106
657919	657919	OR	school	4110520	2182	Reynolds SD 7	411052001010	1254	Reynolds Middle School	Regular School	No	Middle	06	08	2021	k_12_total	202	70	539	8	31	32	62	202	70	539	8	31	32	62
657862	657862	OR	school	4110040	2180	Portland SD 1J	411004000935	887	Scott Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	155	69	171	4	19	9	34	155	69	171	4	19	9	34
657926	657926	OR	school	4110520	2182	Reynolds SD 7	411052001006	952	Wilkes Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	81	67	155	3	61	33	29	81	67	155	3	61	33	29
657735	657735	OR	school	4109480	2181	Parkrose SD 3	410948000982	928	Shaver Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	42	65	92	2	20	10	30	42	65	92	2	20	10	30
657876	657876	OR	school	4110040	2180	Portland SD 1J	411004000975	922	Wilson High School	Regular School	No	High	09	12	2021	k_12_total	1147	64	126	5	34	8	156	1147	64	126	5	34	8	156
656971	656971	OR	school	4102800	2185	Centennial SD 28J	410280001013	960	Centennial Middle School	Regular School	No	Middle	07	08	2021	k_12_total	371	63	292	6	119	22	59	371	63	292	6	119	22	59
657909	657909	OR	school	4110520	2182	Reynolds SD 7	411052001003	949	Davis Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	86	60	198	3	30	10	32	86	60	198	3	30	10	32
656859	656859	OR	school	4101920	2243	Beaverton SD 48J	410192001220	1169	McKinley Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	204	59	228	3	64	4	43	204	59	228	3	64	4	43
657860	657860	OR	school	4110040	2180	Portland SD 1J	411004000933	886	Sabin Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	247	59	24	1	4	0	26	247	59	24	1	4	0	26
657733	657733	OR	school	4109480	2181	Parkrose SD 3	410948000980	926	Russell Elementary	Regular School	No	Elementary	KG	05	2021	k_12_total	147	57	81	0	32	4	36	147	57	81	0	32	4	36
657815	657815	OR	school	4110040	2180	Portland SD 1J	411004001365	1277	Jackson Middle School	Regular School	No	Middle	06	08	2021	k_12_total	551	57	75	3	30	6	81	551	57	75	3	30	6	81
656980	656980	OR	school	4102800	2185	Centennial SD 28J	410280001018	965	Powell Butte Elementary School	Regular School	No	Elementary	KG	06	2021	k_12_total	145	56	142	9	95	17	29	145	56	142	9	95	17	29
657908	657908	OR	school	4110520	2182	Reynolds SD 7	411052000997	943	Alder Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	59	56	232	1	35	16	28	59	56	232	1	35	16	28
657140	657140	OR	school	4104700	1930	Estacada SD 108	410470001766	4670	Summit Learning Charter	Regular School	Yes	Other	KG	12	2021	k_12_total	1149	55	114	5	59	7	45	1149	55	114	5	59	7	45
657848	657848	OR	school	4110040	2180	Portland SD 1J		2180	Portland SD 1J						2021	k_12_total	356	55	71	1	52	2	83	356	55	71	1	52	2	83
657083	657083	OR	school	4103940	2187	David Douglas SD 40	410394001031	975	Lincoln Park Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	171	54	142	2	98	9	21	171	54	142	2	98	9	21
656977	656977	OR	school	4102800	2185	Centennial SD 28J	410280001016	963	Parklane Elementary School	Regular School	No	Elementary	KG	06	2021	k_12_total	108	53	128	4	53	16	31	108	53	128	4	53	16	31
657732	657732	OR	school	4109480	2181	Parkrose SD 3	410948000979	925	Prescott Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	97	53	92	2	19	17	28	97	53	92	2	19	17	28
657082	657082	OR	school	4103940	2187	David Douglas SD 40	410394001030	974	Gilbert Park Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	241	52	95	5	41	11	33	241	52	95	5	41	11	33
657090	657090	OR	school	4103940	2187	David Douglas SD 40	410394001036	979	West Powellhurst Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	137	51	105	2	54	9	18	137	51	105	2	54	9	18
657076	657076	OR	school	4103940	2187	David Douglas SD 40	410394001025	972	Cherry Park Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	153	50	109	2	52	9	46	153	50	109	2	52	9	46
657089	657089	OR	school	4103940	2187	David Douglas SD 40	410394001035	978	Ventura Park Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	111	49	101	4	33	14	33	111	49	101	4	33	14	33
657821	657821	OR	school	4110040	2180	Portland SD 1J	411004000912	1243	Lane Middle School	Regular School	No	Middle	06	08	2021	k_12_total	157	49	92	5	73	7	28	157	49	92	5	73	7	28
656975	656975	OR	school	4102800	2185	Centennial SD 28J	410280001015	962	Oliver Elementary School	Regular School	No	Elementary	KG	06	2021	k_12_total	105	48	102	1	37	20	21	105	48	102	1	37	20	21
657912	657912	OR	school	4110520	2182	Reynolds SD 7	411052001000	947	Hartley Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	76	48	207	1	15	11	46	76	48	207	1	15	11	46
656848	656848	OR	school	4101920	2243	Beaverton SD 48J	410192001234	1181	Five Oaks Middle School	Regular School	No	Middle	06	08	2021	k_12_total	367	47	406	5	70	8	76	367	47	406	5	70	8	76
657316	657316	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2021	k_12_total	653	46	482	11	192	23	110	653	46	482	11	192	23	110
657606	657606	OR	school	4108830	1924	North Clackamas SD 12	410883000093	85	Clackamas High School	Regular School	No	High	09	12	2021	k_12_total	1378	46	318	6	443	9	195	1378	46	318	6	443	9	195
656834	656834	OR	school	4101920	2243	Beaverton SD 48J	410192001240	1187	Beaverton High School	Regular School	No	High	09	12	2021	k_12_total	650	45	689	5	76	13	89	650	45	689	5	76	13	89
657568	657568	OR	school	4180180	2148	Multnomah ESD	418018000230	1298	Helensview High School	Alternative School	No	High	06	12	2021	k_12_total	37	44	41	2	3	2	16	37	44	41	2	3	2	16
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
656876	656876	OR	school	4101920	2243	Beaverton SD 48J	410192001432	2783	Southridge High School	Regular School	No	High	09	12	2021	k_12_total	735	43	472	8	93	17	113	735	43	472	8	93	17	113
656828	656828	OR	school	4101920	2243	Beaverton SD 48J	410192001204	1153	Aloha-Huber Park School	Regular School	No	Elementary	PK	08	2021	k_12_total	187	42	493	3	50	2	45	187	42	493	3	50	2	45
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
657825	657825	OR	school	4110040	2180	Portland SD 1J	411004000915	870	Lent Elementary School	Regular School	No	Elementary	KG	08	2021	k_12_total	110	42	239	5	51	7	22	110	42	239	5	51	7	22
657915	657915	OR	school	4110520	2182	Reynolds SD 7	411052001434	3490	Multnomah Learning Academy	Regular School	Yes	Elementary	KG	08	2021	k_12_total	339	41	118	9	31	4	30	339	41	118	9	31	4	30
657268	657268	OR	school	4106000	2183	Gresham-Barlow SD 10J	410600000525	1312	Clear Creek Middle School	Regular School	No	Middle	06	08	2021	k_12_total	241	40	253	5	22	15	56	241	40	253	5	22	15	56
657794	657794	OR	school	4110040	2180	Portland SD 1J	411004000958	909	Cleveland High School	Regular School	No	High	09	12	2021	k_12_total	1065	39	142	2	142	7	185	1065	39	142	2	142	7	185
657814	657814	OR	school	4110040	2180	Portland SD 1J	411004000905	861	Irvington Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	194	39	32	0	4	1	50	194	39	32	0	4	1	50
657824	657824	OR	school	4110040	2180	Portland SD 1J	411004000914	869	Lee Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	103	39	49	2	38	1	31	103	39	49	2	38	1	31
657782	657782	OR	school	4110040	2180	Portland SD 1J	411004000874	831	Beaumont Middle School	Regular School	No	Middle	06	08	2021	k_12_total	280	38	134	0	9	2	55	280	38	134	0	9	2	55
657151	657151	OR	school	4104740	2082	Eugene SD 4J	410474000575	540	Churchill High School	Regular School	No	High	09	12	2021	k_12_total	685	37	208	14	28	13	131	685	37	208	14	28	13	131
657781	657781	OR	school	4110040	2180	Portland SD 1J	411004000873	830	Beach Elementary School	Regular School	No	Elementary	PK	05	2021	k_12_total	205	37	110	0	0	0	30	205	37	110	0	0	0	30
657832	657832	OR	school	4110040	2180	Portland SD 1J	411004000920	875	Marysville Elementary School	Regular School	No	Elementary	KG	08	2021	k_12_total	150	37	82	9	63	10	54	150	37	82	9	63	10	54
657871	657871	OR	school	4110040	2180	Portland SD 1J	411004000945	896	Vestal Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	97	37	29	0	30	5	30	97	37	29	0	30	5	30
656832	656832	OR	school	4101920	2243	Beaverton SD 48J	410192001206	1155	Beaver Acres Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	231	36	269	7	89	9	55	231	36	269	7	89	9	55
657287	657287	OR	school	4106000	2183	Gresham-Barlow SD 10J	410600001041	987	Sam Barlow High School	Regular School	No	High	09	12	2021	k_12_total	1084	36	377	12	66	11	102	1084	36	377	12	66	11	102
657866	657866	OR	school	4110040	2180	Portland SD 1J	411004000937	889	Sitton Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	97	36	145	5	8	7	41	97	36	145	5	8	7	41
657989	657989	OR	school	4110820	2142	Salem-Keizer SD 24J	411082000820	775	South Salem High School	Regular School	No	High	09	12	2021	k_12_total	1211	36	685	8	61	43	152	1211	36	685	8	61	43	152
656842	656842	OR	school	4101920	2243	Beaverton SD 48J	410192000552	1319	Conestoga Middle School	Regular School	No	Middle	06	08	2021	k_12_total	479	35	183	2	97	17	84	479	35	183	2	97	17	84
656944	656944	OR	school	4102040	2088	Bethel SD 52	410204000623	588	Willamette High School	Regular School	No	High	09	12	2021	k_12_total	946	35	349	22	41	13	111	946	35	349	22	41	13	111
657084	657084	OR	school	4103940	2187	David Douglas SD 40	410394001032	976	Menlo Park Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	140	35	115	7	41	17	50	140	35	115	7	41	17	50
657284	657284	OR	school	4106000	2183	Gresham-Barlow SD 10J	410600000992	938	North Gresham Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	221	35	164	7	26	11	42	221	35	164	7	26	11	42
657809	657809	OR	school	4110040	2180	Portland SD 1J	411004000898	854	Grout Elementary School	Regular School	No	Elementary	KG	05	2021	k_12_total	214	35	31	0	32	3	35	214	35	31	0	32	3	35
657847	657847	OR	school	4110040	2180	Portland SD 1J		2506	Portland Community College						2021	k_12_total	152	34	76	6	13	0	32	152	34	76	6	13	0	32
656978	656978	OR	school	4102800	2185	Centennial SD 28J	410280001017	964	Patrick Lynch Elementary	Regular School	No	Elementary	KG	06	2021	k_12_total	161	33	152	0	71	17	28	161	33	152	0	71	17	28
657273	657273	OR	school	4106000	2183	Gresham-Barlow SD 10J	410600000990	934	Gordon Russell Middle School	Regular School	No	Middle	06	08	2021	k_12_total	379	33	229	8	25	9	45	379	33	229	8	25	9	45
657979	657979	OR	school	4110820	2142	Salem-Keizer SD 24J	411082000818	773	North Salem High School	Regular School	No	High	09	12	2021	k_12_total	545	33	1274	15	27	73	82	545	33	1274	15	27	73	82
657990	657990	OR	school	4110820	2142	Salem-Keizer SD 24J	411082000819	774	Sprague High School	Regular School	No	High	09	12	2021	k_12_total	1160	33	314	23	62	27	113	1160	33	314	23	62	27	113
656979	656979	OR	school	4102800	2185	Centennial SD 28J	410280001019	966	Pleasant Valley Elementary School	Regular School	No	Elementary	KG	06	2021	k_12_total	190	32	56	1	48	5	28	190	32	56	1	48	5	28
657575	657575	OR	school	4180180	2148	Multnomah ESD	418018001510	3168	The Creeks	Alternative School	No	Other	KG	12	2021	k_12_total	78	32	31	5	2	2	19	78	32	31	5	2	2	19

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