schools: enrollments: 29,595 rows where where state = "NM" sorted by total descending

Data source: Big Local News · About: Big Local

29,595 rows where state = "NM" sorted by total descending

Search:

descending

Link	rowid	state	admin_level	district_nces_id	district_state_id	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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total ▲	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
2554686	2554686	NM	school	3500060	1	ALBUQUERQUE	350006000764	430	DESERT RIDGE MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	427	*	378	15	111	*	56	995	427		378	15	111		56	995
2960896	2960896	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public - Middle School	Regular School	No	Middle	07	08	2021	pk_12_total	328	22	618	*	12	6	*	995	328	22	618		12	6		995
2540991	2540991	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten								99								99
2541036	2541036	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten								99								99
2542726	2542726	NM	school	3500060	1	ALBUQUERQUE	350006000036	234	CHAPARRAL ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1								99								99
2542823	2542823	NM	school	3500060	1	ALBUQUERQUE	350006000089	312	MONTE VISTA ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								99								99
2542840	2542840	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_1								99								99
2542858	2542858	NM	school	3500060	1	ALBUQUERQUE	350006001036	393	SUNSET VIEW ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								99								99
2543501	2543501	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								99								99
2545295	2545295	NM	school	3501500	17	LAS CRUCES	350150000385	61	JORNADA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								99								99
2545516	2545516	NM	school	3502250	4	ROSWELL	350225000524	161	VALLEY VIEW ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								99								99
2545752	2545752	NM	school	3500060	1	ALBUQUERQUE	350006000726	328	GEORGIA O'KEEFFE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_4								99								99
2546348	2546348	NM	school	3501680	86	LOS LUNAS	350168000722	80	KATHERINE GALLEGOS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_4								99								99
2546791	2546791	NM	school	3500060	1	ALBUQUERQUE	350006000895	260	MANZANO MESA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								99								99
2547277	2547277	NM	school	3501500	17	LAS CRUCES	350150000688	44	EAST PICACHO ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								99								99
2547496	2547496	NM	school	3502250	4	ROSWELL	350225000517	105	MONTERREY ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								99								99
2548338	2548338	NM	school	3501680	86	LOS LUNAS	350168000722	80	KATHERINE GALLEGOS ELEMENTARY	Public	Regular School	No	Elementary	PK	06	2020	grade_6								99								99
2549168	2549168	NM	school	3501110	43	GALLUP	350111000663	155	THOREAU MIDDLE	Public	Regular School	No	Middle	06	08	2020	grade_7								99								99
2552185	2552185	NM	school	3501230	18	HATCH	350123000344	58	HATCH VALLEY HIGH	Public	Regular School	No	High	09	12	2020	grade_10								99								99
2553180	2553180	NM	school	3501230	18	HATCH	350123000344	58	HATCH VALLEY HIGH	Public	Regular School	No	High	09	12	2020	grade_11								99								99
2554921	2554921	NM	school	3500390	67	CENTRAL CONS.	350039000947	24	KIRTLAND PRE-K EARLY	Public	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	19	*	7	70	*	*	*	99	19		7	70				99
2554966	2554966	NM	school	3500570	12	CLOVIS	350057000793	3	LOS NINOS	Public	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	42	*	49	*	*	*	*	99	42		49					99
2555166	2555166	NM	school	3501200	5	HAGERMAN	350120000341	56	HAGERMAN MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	*	*	74	*	*	*	*	99			74					99
2948531	2948531	NM	school	3501500	17	LAS CRUCES	350150001062	14	MONTE VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	kindergarten_full_day								99								99
2949142	2949142	NM	school	3500210	61	BERNALILLO	350021000728	140	WD CARROLL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	02	2021	grade_1								99								99
2949866	2949866	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1								99								99
2950648	2950648	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_2								99								99
2950888	2950888	NM	school	3500060	1	ALBUQUERQUE	350006000035	339	CARLOS REY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_3								99								99
2951626	2951626	NM	school	3500010	83	RIO RANCHO	350001001034	21	CIELO AZUL ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_3								99								99
2951978	2951978	NM	school	3500060	1	ALBUQUERQUE	350006000782	275	PAINTED SKY ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								99								99
2952623	2952623	NM	school	3500010	83	RIO RANCHO	350001001039	20	SANDIA VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								99								99
2953022	2953022	NM	school	3500120	22	ARTESIA	350012000672	1	YESO ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	01	05	2021	grade_5								99								99
2954931	2954931	NM	school	3500060	1	ALBUQUERQUE	350006000809	25	SOUTH VALLEY ACADEMY	Charter - High School	Regular School	Yes	High	06	12	2021	grade_7								99								99
2961002	2961002	NM	school	3500790	60	DORA	350079000251	45	DORA HIGH	Public - High School	Regular School	No	High	07	12	2021	pk_12_total	70	*	*	*	*	*	*	99	70							99
2554894	2554894	NM	school	3500300	20	CARLSBAD	350030000169	32	CARLSBAD INTERMEDIATE SCHOOL	Public	Regular School	No	Middle	07	08	2020	pk_12_total	356	15	582	8	12	*	*	984	356	15	582	8	12			984
2555226	2555226	NM	school	3501500	17	LAS CRUCES	350150000765	2	CAMINO REAL MIDDLE	Public	Regular School	No	Middle	06	08	2020	pk_12_total	250	24	654	9	14	10	21	982	250	24	654	9	14	10	21	982
2541732	2541732	NM	school	3500060	1	ALBUQUERQUE	350006000037	236	CHELWOOD ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								98								98
2542682	2542682	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								98								98
2543235	2543235	NM	school	3501260	33	HOBBS	350126000686	30	COLLEGE LANE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								98								98
2543843	2543843	NM	school	3500060	1	ALBUQUERQUE	350006000103	360	S. Y. JACKSON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_2								98								98
2544740	2544740	NM	school	3500060	1	ALBUQUERQUE	350006000752	350	DOUBLE EAGLE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								98								98
2544849	2544849	NM	school	3500060	1	ALBUQUERQUE	350006000725	280	SUSIE RAYOS MARMON ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								98								98
2544900	2544900	NM	school	3500150	64	AZTEC	350015000139	136	LYDIA RIPPEY ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	grade_3								98								98
2545322	2545322	NM	school	3501530	69	LAS VEGAS CITY	350153000402	37	LOS NINOS ELEMENTARY	Public	Regular School	No	Elementary	KG	03	2020	grade_3								98								98
2547093	2547093	NM	school	3500990	65	FARMINGTON	350099000283	37	COUNTRY CLUB ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								98								98
2547212	2547212	NM	school	3501230	18	HATCH	350123000753	1	RIO GRANDE ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_5								98								98
2547657	2547657	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								98								98
2548538	2548538	NM	school	3502370	71	SANTA FE	350237001107	170	NINA OTERO COMMUNITY SCHOOL	Public	Regular School	No	Elementary	PK	08	2020	grade_6								98								98
2552152	2552152	NM	school	3501110	43	GALLUP	350111000316	145	THOREAU HIGH	Public	Regular School	No	High	09	12	2020	grade_10								98								98
2554960	2554960	NM	school	3500570	12	CLOVIS	350057001155	81	CMS IACADEMY AT LINCOLN JACKSON	Public	Regular School	No	Other	02	12	2020	pk_12_total	31	*	63	*	*	*	*	98	31		63					98
2555273	2555273	NM	school	3501530	69	LAS VEGAS CITY	350153000863	3	LVCS EARLY CHILDHOOD	Public	Regular School	No	Elementary	PK	KG	2020	pk_12_total	*	*	94	*	*	*	*	98			94					98
2948092	2948092	NM	school	3500060	1	ALBUQUERQUE	350006001018	389	TIERRA ANTIGUA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day								98								98
2952800	2952800	NM	school	3502800	89	ZUNI	350280001124	166	SHIWI TS'ANA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								98								98
2953220	2953220	NM	school	3500990	65	FARMINGTON	350099000283	37	COUNTRY CLUB ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5								98								98
2954444	2954444	NM	school	3501680	86	LOS LUNAS	350168000722	80	KATHERINE GALLEGOS ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	06	2021	grade_6								98								98
2954935	2954935	NM	school	3500060	1	ALBUQUERQUE	350006000112	457	TAYLOR MIDDLE	Public - Middle School	Regular School	No	Middle	06	08	2021	grade_7								98								98
2955391	2955391	NM	school	3501530	69	LAS VEGAS CITY	350153000403	31	7TH AND 8TH GRADE ACADEMY	Public - Middle School	Regular School	No	Middle	07	08	2021	grade_7								98								98
2955909	2955909	NM	school	3500060	1	ALBUQUERQUE	350006000809	25	SOUTH VALLEY ACADEMY	Charter - High School	Regular School	Yes	High	06	12	2021	grade_8								98								98
2958631	2958631	NM	school	3502610	73	TRUTH OR CONS.	350261000593	58	HOT SPRINGS HIGH	Public - High School	Regular School	No	High	09	12	2021	grade_10								98								98
2541915	2541915	NM	school	3500150	64	AZTEC	350015000139	136	LYDIA RIPPEY ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	kindergarten_full_day								97								97
2542119	2542119	NM	school	3500990	65	FARMINGTON	350099000693	38	ESPERANZA ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								97								97
2543833	2543833	NM	school	3500060	1	ALBUQUERQUE	350006000782	275	PAINTED SKY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2								97								97
2544825	2544825	NM	school	3500060	1	ALBUQUERQUE	350006000964	268	NORTH STAR ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_3								97								97
2545291	2545291	NM	school	3501500	17	LAS CRUCES	350150000689	55	HILLRISE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_3								97								97
2545735	2545735	NM	school	3500060	1	ALBUQUERQUE	350006000752	350	DOUBLE EAGLE ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4								97								97
2545825	2545825	NM	school	3500060	1	ALBUQUERQUE	350006000039	317	PETROGLYPH ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_4								97								97
2545963	2545963	NM	school	3500390	67	CENTRAL CONS.	350039001115	60	JUDY NELSON ELEMENTARY	Public	Regular School	No	Elementary	KG	06	2020	grade_4								97								97
2546689	2546689	NM	school	3500060	1	ALBUQUERQUE	350006000022	210	ALAMOSA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								97								97
2547101	2547101	NM	school	3500990	65	FARMINGTON	350099000287	73	LADERA DEL NORTE ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_5								97								97
2547227	2547227	NM	school	3501260	33	HOBBS	350126001111	177	MURRAY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_5								97								97
2548827	2548827	NM	school	3500060	1	ALBUQUERQUE	350006000809	25	SOUTH VALLEY ACADEMY	Charter	Regular School	Yes	High	06	12	2020	grade_7								97								97
2551256	2551256	NM	school	3501500	17	LAS CRUCES	350150001064	16	EARLY COLLEGE HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_9								97								97
2555539	2555539	NM	school	3502460	74	SOCORRO	350246000568	79	MIDWAY ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	pk_12_total	27	*	68	*	*	*	*	97	27		68					97
2948713	2948713	NM	school	3500010	83	RIO RANCHO	350001000864	15	VISTA GRANDE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	kindergarten_full_day								97								97
2949509	2949509	NM	school	3501500	17	LAS CRUCES	350150001062	14	MONTE VISTA ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	05	2021	grade_1								97								97
2949599	2949599	NM	school	3500148	542	MISSION ACHIEVEMENT AND SUCCESS	350014801146	2	MISSION ACHIEVEMENT AND SUCCESS 2.0	Charter - Elementary School	Regular School	Yes	Elementary	KG	06	2021	grade_1								97								97
2950294	2950294	NM	school	3500990	65	FARMINGTON	350099000287	73	LADERA DEL NORTE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_2								97								97
2950405	2950405	NM	school	3501260	33	HOBBS	350126000686	30	COLLEGE LANE ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	KG	05	2021	grade_2								97								97
2952532	2952532	NM	school	3500148	542	MISSION ACHIEVEMENT AND SUCCESS	350014801089	1	MISSION ACHIEVEMENT AND SUCCESS 1.0	Charter - High School	Regular School	Yes	Other	PK	12	2021	grade_4								97								97
2953767	2953767	NM	school	3501560	68	WEST LAS VEGAS	350156000635	157	UNION ELEMENTARY	Public - Elementary School	Regular School	No	Middle	05	05	2021	grade_5								97								97
2954640	2954640	NM	school	3502370	71	SANTA FE	350237001107	170	NINA OTERO COMMUNITY SCHOOL	Public - Middle School	Regular School	No	Elementary	PK	08	2021	grade_6								97								97
2955738	2955738	NM	school	3500187	580	21ST CENTURY PUBLIC ACADEMY	350018700811	1	21ST CENTURY PUBLIC ACADEMY	Charter - Middle School	Regular School	Yes	Middle	04	08	2021	grade_8								97								97
2959150	2959150	NM	school	3501110	43	GALLUP	350111000545	16	GALLUP CENTRAL ALTERNATIVE	Public - High School	Alternative School	No	High	06	12	2021	grade_11								97								97
2960081	2960081	NM	school	3500990	65	FARMINGTON	350099000740	148	ROCINANTE HIGH	Public - High School	Alternative School	No	High	06	12	2021	grade_12								97								97
2960939	2960939	NM	school	3500480	8	CIMARRON	350048000199	47	EAGLE NEST ELEMENTARY	Public - Elementary School	Regular School	No	Elementary	PK	04	2021	pk_12_total	54	*	38	*	*	*	*	97	54		38					97
2961591	2961591	NM	school	3501560	68	WEST LAS VEGAS	350156000635	157	UNION ELEMENTARY	Public - Elementary School	Regular School	No	Middle	05	05	2021	pk_12_total	8	*	87	*	*	*	*	97	8		87					97
2541860	2541860	NM	school	3500060	1	ALBUQUERQUE	350006000109	356	SIERRA VISTA ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day								96								96
2542128	2542128	NM	school	3500990	65	FARMINGTON	350099000289	100	MCKINLEY ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day								96								96
2542848	2542848	NM	school	3500060	1	ALBUQUERQUE	350006000103	360	S. Y. JACKSON ELEMENTARY	Public	Regular School	No	Elementary	KG	05	2020	grade_1								96								96
2542911	2542911	NM	school	3500150	64	AZTEC	350015000137	99	MCCOY AVENUE ELEMENTARY	Public	Regular School	No	Elementary	PK	03	2020	grade_1								96								96
2543854	2543854	NM	school	3500060	1	ALBUQUERQUE	350006000725	280	SUSIE RAYOS MARMON ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	grade_2								96								96
2545222	2545222	NM	school	3501230	18	HATCH	350123000753	1	RIO GRANDE ELEMENTARY	Public	Regular School	No	Elementary	03	05	2020	grade_3								96								96
2547533	2547533	NM	school	3502370	71	SANTA FE	350237000535	11	EL CAMINO REAL ACADEMY COMMUNITY	Public	Regular School	No	Elementary	PK	08	2020	grade_5								96								96
2547647	2547647	NM	school	3501560	68	WEST LAS VEGAS	350156000635	157	UNION ELEMENTARY	Public	Regular School	No	Middle	05	05	2020	grade_5								96								96
2551660	2551660	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_10								96								96
2552363	2552363	NM	school	3500148	542	MISSION ACHIEVEMENT AND SUCCESS	350014801089	1	MISSION ACHIEVEMENT AND SUCCESS 1.0	Charter	Regular School	Yes	Other	PK	12	2020	grade_10								96								96
2553621	2553621	NM	school	3501560	68	WEST LAS VEGAS	350156000418	173	WEST LAS VEGAS HIGH SCHOOL	Public	Regular School	No	High	09	12	2020	grade_11								96								96
2553650	2553650	NM	school	3500060	1	ALBUQUERQUE	350006000893	90	ABQ CHARTER ACADEMY	Charter	Regular School	Yes	High	09	12	2020	grade_12								96								96
2555145	2555145	NM	school	3501140	15	GRADY	350114000325	55	GRADY ELEMENTARY	Public	Regular School	No	Elementary	PK	05	2020	pk_12_total	70	*	25	*	*	*	*	96	70		25					96
2555607	2555607	NM	school	3501560	68	WEST LAS VEGAS	350156000635	157	UNION ELEMENTARY	Public	Regular School	No	Middle	05	05	2020	pk_12_total	*	*	92	*	*	*	*	96			92					96

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