enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_2" and state = "NM" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 1,973 ✖
Link rowid state county county_state_id 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 term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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
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
2543833 2543833 NM     school 3500060 1   ALBUQUERQUE 350006000782 275 PAINTED SKY ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   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
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
2543869 2543869 NM     school 3500060 1   ALBUQUERQUE 350006000897 264 VENTANA RANCH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   95                                             95
2544122 2544122 NM     school 3500990 65   FARMINGTON 350099000291 118 NORTHEAST ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_2                                                   95                                             95
2949912 2949912 NM     school 3500060 1   ALBUQUERQUE 350006000036 234 CHAPARRAL ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   95                                             95
2950057 2950057 NM     school 3500060 1   ALBUQUERQUE 350006000897 264 VENTANA RANCH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   94                                             94
2950502 2950502 NM     school 3501530 69   LAS VEGAS CITY 350153000402 37 LOS NINOS ELEMENTARY Public - Elementary School Regular School No Elementary KG 03 2021   grade_2                                                   94                                             94
2950577 2950577 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_2                                                   94                                             94
2543810 2543810 NM     school 3500060 1   ALBUQUERQUE 350006000692 250 MARYANN BINFORD ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   93                                             93
2950019 2950019 NM     school 3500060 1   ALBUQUERQUE 350006000964 268 NORTH STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   93                                             93
2950494 2950494 NM     school 3501500 17   LAS CRUCES 350150030009 145 TOMBAUGH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   93                                             93
2544501 2544501 NM     school 3502250 4   ROSWELL 350225000508 41 DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   92                                             92
2950088 2950088 NM     school 3500120 22   ARTESIA 350012000672 1 YESO ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   grade_2                                                   92                                             92
2950120 2950120 NM     school 3500210 61   BERNALILLO 350021000728 140 WD CARROLL ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   grade_2                                                   92                                             92
2950662 2950662 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   92                                             92
2543687 2543687 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   91                                             91
2543713 2543713 NM     school 3500060 1   ALBUQUERQUE 350006000030 222 BANDELIER ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   91                                             91
2543722 2543722 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   90                                             90
2544521 2544521 NM     school 3502250 4   ROSWELL 350225000524 161 VALLEY VIEW ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   90                                             90
2950031 2950031 NM     school 3500060 1   ALBUQUERQUE 350006001033 392 RUDOLFO ANAYA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   90                                             90
2950043 2950043 NM     school 3500060 1   ALBUQUERQUE 350006000725 280 SUSIE RAYOS MARMON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   90                                             90
2950149 2950149 NM     school 3500300 20   CARLSBAD 350030000175 158 SUNSET ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   grade_2                                                   90                                             90
2543682 2543682 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   grade_2                                                   9                                             9
2543876 2543876 NM     school 3500060 1   ALBUQUERQUE 350006001087 782 WILLIAM W & JOSEPHINE DORN CHARTER COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 05 2020   grade_2                                                   9                                             9
2544034 2544034 NM     school 3500600 24   COBRE CONS. 350060000229 143 SAN LORENZO ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_2                                                   9                                             9
2544058 2544058 NM     school 3500720 85   DES MOINES 350072000245 44 DES MOINES ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_2                                                   9                                             9
2544082 2544082 NM     school 3500900 55   ESPANOLA 350090000271 59 HERNANDEZ ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_2                                                   9                                             9
2544181 2544181 NM     school   43   GALLUP   997 MISC PRIVATE Private           2020   grade_2                                                   9                                             9
2544332 2544332 NM     school 3501590 51   LOGAN 350159000420 80 LOGAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   9                                             9
2544462 2544462 NM     school 3502130 3   QUEMADO 350213000492 129 QUEMADO ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_2                                                   9                                             9
2544474 2544474 NM     school 3500143 539   RED RIVER VALLEY CHARTER SCHOOL 350014300845 1 RED RIVER VALLEY CHARTER SCHOOL Charter Regular School Yes Elementary PK 08 2020   grade_2                                                   9                                             9
2544604 2544604 NM     school 3502490 10   SPRINGER 350249000574 56 FORRESTER ELEMENTARY Public Regular School No Elementary KG 02 2020   grade_2                                                   9                                             9
2950250 2950250 NM     school 3500840 58   ELIDA 350084000255 47 ELIDA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_2                                                   9                                             9
2950258 2950258 NM     school 3500900 55   ESPANOLA 350090000265 42 DIXON ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_2                                                   9                                             9
2950417 2950417 NM     school   33   HOBBS   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_2                                                   9                                             9
2950633 2950633 NM     school 3502130 3   QUEMADO 350213000492 129 QUEMADO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_2                                                   9                                             9
2950764 2950764 NM     school 3502460 74   SOCORRO 350246000568 79 MIDWAY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   9                                             9
2950768 2950768 NM     school 3502460 74   SOCORRO 350246000569 144 SAN ANTONIO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   9                                             9
2950843 2950843 NM     school   89   ZUNI   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_2                                                   9                                             9
2543899 2543899 NM     school 3500120 22   ARTESIA 350012000672 1 YESO ELEMENTARY Public Regular School No Elementary 01 05 2020   grade_2                                                   89                                             89
2543973 2543973 NM     school 3500390 67   CENTRAL CONS. 350039001115 60 JUDY NELSON ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_2                                                   89                                             89
2544230 2544230 NM     school 3501260 33   HOBBS 350126000686 30 COLLEGE LANE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   89                                             89
2544672 2544672 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   89                                             89
2950844 2950844 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   89                                             89
2543761 2543761 NM     school 3500060 1   ALBUQUERQUE 350006001114 496 GEORGE I SANCHEZ Public Regular School No Elementary PK 08 2020   grade_2                                                   88                                             88
2950621 2950621 NM     school 3502070 72   POJOAQUE 350207000482 123 PABLO ROYBAL ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   grade_2                                                   88                                             88
2543818 2543818 NM     school 3500060 1   ALBUQUERQUE 350006000089 312 MONTE VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   87                                             87
2544292 2544292 NM     school 3501500 17   LAS CRUCES 350150000688 44 EAST PICACHO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   87                                             87
2544358 2544358 NM     school 3501680 86   LOS LUNAS 350168000722 80 KATHERINE GALLEGOS ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_2                                                   87                                             87
2949929 2949929 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   86                                             86
2950299 2950299 NM     school 3500990 65   FARMINGTON 350099000291 118 NORTHEAST ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_2                                                   86                                             86
2950339 2950339 NM     school 3501080 19   GADSDEN 350108001125 25 YUCCA HEIGHTS ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_2                                                   86                                             86
2544109 2544109 NM     school 3500990 65   FARMINGTON 350099000693 38 ESPERANZA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   85                                             85
2544170 2544170 NM     school 3501110 43   GALLUP 350111001137 174 DEL NORTE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   85                                             85
2950007 2950007 NM     school 3500060 1   ALBUQUERQUE 350006000089 312 MONTE VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   85                                             85
2950092 2950092 NM     school 3500150 64   AZTEC 350015000139 136 LYDIA RIPPEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   grade_2                                                   85                                             85
2544312 2544312 NM     school 3501500 17   LAS CRUCES 350150001062 14 MONTE VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   84                                             84
2543787 2543787 NM     school 3500060 1   ALBUQUERQUE 350006000070 217 JOHN BAKER ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   83                                             83
2949934 2949934 NM     school 3500060 1   ALBUQUERQUE 350006000752 350 DOUBLE EAGLE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   83                                             83
2949951 2949951 NM     school 3500060 1   ALBUQUERQUE 350006000726 328 GEORGIA O'KEEFFE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   83                                             83
2950022 2950022 NM     school 3500060 1   ALBUQUERQUE 350006000782 275 PAINTED SKY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   83                                             83
2950032 2950032 NM     school 3500060 1   ALBUQUERQUE 350006000103 360 S. Y. JACKSON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   83                                             83
2950353 2950353 NM     school 3501110 43   GALLUP 350111000306 66 JEFFERSON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   83                                             83
2950532 2950532 NM     school 3501680 86   LOS LUNAS 350168000722 80 KATHERINE GALLEGOS ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_2                                                   83                                             83
2543704 2543704 NM     school 3500060 1   ALBUQUERQUE 350006000022 210 ALAMOSA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   82                                             82
2543835 2543835 NM     school 3500060 1   ALBUQUERQUE 350006000039 317 PETROGLYPH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   82                                             82
2950296 2950296 NM     school 3500990 65   FARMINGTON 350099000289 100 MCKINLEY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   82                                             82
2950333 2950333 NM     school 3501080 19   GADSDEN 350108000904 8 SANTA TERESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_2                                                   82                                             82
2544116 2544116 NM     school 3500990 65   FARMINGTON 350099000287 73 LADERA DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   81                                             81
2544558 2544558 NM     school 3502370 71   SANTA FE 350237001107 170 NINA OTERO COMMUNITY SCHOOL Public Regular School No Elementary PK 08 2020   grade_2                                                   81                                             81
2949910 2949910 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   81                                             81
2949999 2949999 NM     school 3500060 1   ALBUQUERQUE 350006000692 250 MARYANN BINFORD ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   81                                             81
2950042 2950042 NM     school 3500060 1   ALBUQUERQUE 350006001036 393 SUNSET VIEW ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   81                                             81
2950693 2950693 NM     school 3502250 4   ROSWELL 350225000524 161 VALLEY VIEW ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   81                                             81
2543906 2543906 NM     school 3500150 64   AZTEC 350015000137 99 MCCOY AVENUE ELEMENTARY Public Regular School No Elementary PK 03 2020   grade_2                                                   80                                             80
2543962 2543962 NM     school 3500300 20   CARLSBAD 350030000175 158 SUNSET ELEMENTARY Public Regular School No Elementary 01 05 2020   grade_2                                                   80                                             80
2544162 2544162 NM     school 3501080 19   GADSDEN 350108001125 25 YUCCA HEIGHTS ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_2                                                   80                                             80
2544548 2544548 NM     school 3502370 71   SANTA FE 350237000535 11 EL CAMINO REAL ACADEMY COMMUNITY Public Regular School No Elementary PK 08 2020   grade_2                                                   80                                             80
2950694 2950694 NM     school 3502250 4   ROSWELL 350225000525 175 WASHINGTON AVE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   80                                             80
2544268 2544268 NM     school 3501410 63   JEMEZ VALLEY 350141000800 4 SAN DIEGO RIVERSIDE Charter Regular School Yes Elementary KG 08 2020   grade_2                                                   8                                             8
2544329 2544329 NM     school 3501530 69   LAS VEGAS CITY 350153000407 150 MIKE SENA ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_2                                                   8                                             8
2950425 2950425 NM     school 3501290 39   HONDO 350129000359 59 HONDO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_2                                                   8                                             8
2950443 2950443 NM     school 3501410 63   JEMEZ VALLEY 350141000800 4 SAN DIEGO RIVERSIDE Charter - Elementary School Regular School Yes Elementary KG 08 2021   grade_2                                                   8                                             8
2950486 2950486 NM     school   17   LAS CRUCES   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_2                                                   8                                             8
2950561 2950561 NM     school 3501800 11   MAXWELL 350180000460 100 MAXWELL ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_2                                                   8                                             8
2543778 2543778 NM     school 3500060 1   ALBUQUERQUE 350006000616 221 HUBERT H HUMPHREY ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   79                                             79
2544023 2544023 NM     school 3500570 12   CLOVIS 350057030016 95 MESA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   79                                             79
2544046 2544046 NM     school 3500690 42   DEMING 350069000238 36 COLUMBUS ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   79                                             79
2544224 2544224 NM     school 3501230 18   HATCH 350123000343 57 HATCH VALLEY ELEMENTARY Public Regular School No Elementary PK 02 2020   grade_2                                                   79                                             79
2544231 2544231 NM     school 3501260 33   HOBBS 350126000346 32 CORONADO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   79                                             79
2950224 2950224 NM     school 3500690 42   DEMING 350069000941 5 BATAAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_2                                                   79                                             79
2950469 2950469 NM     school 3501500 17   LAS CRUCES 350150000383 51 FAIRACRES ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   79                                             79
2950673 2950673 NM     school 3502250 4   ROSWELL 350225000508 41 DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_2                                                   79                                             79
2544106 2544106 NM     school 3500990 65   FARMINGTON 350099000281 17 APACHE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_2                                                   78                                             78
2544300 2544300 NM     school 3501500 17   LAS CRUCES 350150000385 61 JORNADA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_2                                                   78                                             78
2544538 2544538 NM     school 3502370 71   SANTA FE 350237001061 141 AMY BIEHL COMMUNITY SCHOOL AT RANCHO VIEJO Public Regular School No Elementary KG 06 2020   grade_2                                                   78                                             78

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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