enrollments

Data source: Big Local News · About: Big Local

14,670 rows where state = "NM" and year = 2021 sorted by hispanic_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 14,670 ✖
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
2960637 2960637 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total 12 * *   * *     *   *                             21 12                                           21
2960641 2960641 NM     school   46   ALAMOGORDO   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * *   * *     *   *                             8                                             8
2960666 2960666 NM     school   1   ALBUQUERQUE   974 BERNALILLO ACADEMY Off-Site - Special Education           2021   pk_12_total * * *   * *     *   *                             7                                             7
2960776 2960776 NM     school   1   ALBUQUERQUE   983 NMSVH PRESCHOOL Off-Site - Special Education           2021   pk_12_total 40 * *   * *     *   *                             46 40                                           46
2960834 2960834 NM     school 3500090 30   ANIMAS 350009030019 20 ANIMAS MIDDLE Public - Middle School Regular School No Middle 05 06 2021   pk_12_total 18 * *   * *     *   *                             25 18                                           25
2960842 2960842 NM     school   22   ARTESIA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960843 2960843 NM     school   22   ARTESIA   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
2960844 2960844 NM     school 3500120 22   ARTESIA 350012000131 128 PENASCO ELEMENTARY Public - Elementary School Regular School No Elementary KG 08 2021   pk_12_total 16 * *   * *     *   *                             18 16                                           18
2960872 2960872 NM     school   61   BERNALILLO   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960874 2960874 NM     school   61   BERNALILLO   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960876 2960876 NM     school 3500210 61   BERNALILLO 350021000153 151 SANTO DOMINGO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   252 *     *   *                             255         252                                   255
2960877 2960877 NM     school 3500210 61   BERNALILLO 350021000154 28 SANTO DOMINGO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   * *     *   *                             94                                             94
2960884 2960884 NM     school   66   BLOOMFIELD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960890 2960890 NM     school   40   CAPITAN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960891 2960891 NM     school   40   CAPITAN   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960894 2960894 NM     school   20   CARLSBAD   4 CARLSBAD HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             7                                             7
2960902 2960902 NM     school   20   CARLSBAD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             7                                             7
2960911 2960911 NM     school   37   CARRIZOZO   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
2960912 2960912 NM     school 3500390 67   CENTRAL CONS. 350039000772 25 CAREER PREP ALTERNATIVE Public - High School Alternative School No High 09 12 2021   pk_12_total * * *   123 *     *   *                             132         123                                   132
2960914 2960914 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter - Elementary School Regular School Yes Elementary KG 05 2021   pk_12_total * * *   27 *     *   *                             28         27                                   28
2960915 2960915 NM     school 3500390 67   CENTRAL CONS. 350039000773 26 EVA B STOKELY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total * * *   215 *     *   11                             230         215           11                       230
2960916 2960916 NM     school   67   CENTRAL CONS.   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2960920 2960920 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 6 * *   36 *     *   *                             46 6       36                                   46
2960921 2960921 NM     school 3500390 67   CENTRAL CONS. 350039000181 110 MESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   245 7     *   12                             271         245 7         12                       271
2960923 2960923 NM     school 3500390 67   CENTRAL CONS. 350039000183 116 NEWCOMB ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   185 *     *   13                             209         185           13                       209
2960928 2960928 NM     school   67   CENTRAL CONS.   8 SHIPROCK HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             4                                             4
2960930 2960930 NM     school 3500390 67   CENTRAL CONS. 350039000189 160 TSE'BIT'AI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   394 6     *   7                             413         394 6         7                       413
2960949 2960949 NM     school   48   CLOUDCROFT   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960957 2960957 NM     school   12   CLOVIS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960972 2960972 NM     school   24   COBRE CONS.   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960976 2960976 NM     school 3500630 38   CORONA 350063000231 38 CORONA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 27 * *   * *     *   *                             39 27                                           39
2960977 2960977 NM     school 3500630 38   CORONA 350063000232 39 CORONA HIGH Public - High School Regular School No High 07 12 2021   pk_12_total 16 * *   * *     *   *                             24 16                                           24
2960981 2960981 NM     school 3500174 562   DEAP 350017401113 1 DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE Charter - High School Regular School Yes Secondary 06 11 2021   pk_12_total * * *   45 *     *   *                             46         45                                   46
2960990 2960990 NM     school   42   DEMING   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960997 2960997 NM     school 3500720 85   DES MOINES 350072000246 45 DES MOINES HIGH Public - High School Regular School No High 07 12 2021   pk_12_total 24 * *   * *     *   *                             37 24                                           37
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
2961006 2961006 NM     school   54   DULCE   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
2961007 2961007 NM     school   54   DULCE   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * *   40 *     *   *                             44         40                                   44
2961014 2961014 NM     school   55   ESPANOLA   9 CHIMAYO HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961015 2961015 NM     school   55   ESPANOLA   20 CONJUNTO PRESCHOOL Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
2961017 2961017 NM     school   55   ESPANOLA   7 ESPANOLA HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2961022 2961022 NM     school   55   ESPANOLA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             4                                             4
2961027 2961027 NM     school   55   ESPANOLA   10 SAN JUAN HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             6                                             6
2961051 2961051 NM     school   65   FARMINGTON   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             4                                             4
2961061 2961061 NM     school   65   FARMINGTON   8 SAN JUAN COUNTY JUVENILE SERVICE CENTER Off-Site - High School           2021   pk_12_total * * *   * *     *   *                             9                                             9
2961083 2961083 NM     school   19   GADSDEN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             10                                             10
2961102 2961102 NM     school 3501110 43   GALLUP 350111000301 39 CROWNPOINT HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * *   292 *     *   *                             300         292                                   300
2961103 2961103 NM     school 3501110 43   GALLUP 350111000881 88 CROWNPOINT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   168 *     *   *                             173         168                                   173
2961104 2961104 NM     school 3501110 43   GALLUP 350111030021 160 DAVID SKEET ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   174 *     *   *                             182         174                                   182
2961109 2961109 NM     school   43   GALLUP   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961114 2961114 NM     school   43   GALLUP   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   15 *     *   *                             18         15                                   18
2961117 2961117 NM     school 3501110 43   GALLUP 350111000309 79 NAVAJO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   261 6     *   *                             278         261 6                                 278
2961118 2961118 NM     school 3501110 43   GALLUP 350111000861 100 NAVAJO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   133 *     *   *                             137         133                                   137
2961119 2961119 NM     school 3501110 43   GALLUP 350111000310 75 NAVAJO PINE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * *   140 *     *   *                             144         140                                   144
2961121 2961121 NM     school 3501110 43   GALLUP 350111000662 130 RAMAH HIGH Public - High School Regular School No High 06 12 2021   pk_12_total 32 * *   143 *     *   7                             190 32       143           7                       190
2961128 2961128 NM     school 3501110 43   GALLUP 350111000317 164 TOHATCHI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   200 6     *   *                             209         200 6                                 209
2961129 2961129 NM     school 3501110 43   GALLUP 350111000318 64 TOHATCHI HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * *   286 *     *   *                             293         286                                   293
2961130 2961130 NM     school 3501110 43   GALLUP 350111000664 120 TOHATCHI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   204 *     *   *                             214         204                                   214
2961131 2961131 NM     school 3501110 43   GALLUP 350111000907 89 TSE'YI'GAI HIGH Public - High School Regular School No High 08 12 2021   pk_12_total * * *   64 *     *   *                             65         64                                   65
2961132 2961132 NM     school 3501110 43   GALLUP 350111000321 170 TWIN LAKES ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   185 *     *   *                             192         185                                   192
2961135 2961135 NM     school 3501140 15   GRADY 350114000899 56 GRADY MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 27 * *   * *     *   *                             47 27                                           47
2961139 2961139 NM     school   88   GRANTS   4 GRANTS HEAD START Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             9                                             9
2961141 2961141 NM     school   88   GRANTS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961143 2961143 NM     school 3501170 88   GRANTS 350117000665 58 LAGUNA-ACOMA MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total * * *   47 *     *   *                             51         47                                   51
2961147 2961147 NM     school   88   GRANTS   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             31                                             31
2961155 2961155 NM     school 3501230 18   HATCH 350123000342 53 GARFIELD ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   pk_12_total * * *   * *     *   *                             106                                             106
2961156 2961156 NM     school   18   HATCH   0 HATCH VALLEY DIST OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             3                                             3
2961170 2961170 NM     school   33   HOBBS   999 HOME SCHOOL Home School - Central Office           2021   pk_12_total * * *   * *     *   *                             6                                             6
2961171 2961171 NM     school   33   HOBBS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961181 2961181 NM     school   33   HOBBS   2 TIEUEL HEADSTART Off-Site - Prekindergarten           2021   pk_12_total 10 * *   * *     *   *                             18 10                                           18
2961186 2961186 NM     school 3501320 50   HOUSE 350132000361 59 HOUSE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 20 * *   * *     *   *                             28 20                                           28
2961187 2961187 NM     school 3501320 50   HOUSE 350132000362 60 HOUSE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 18 * *   * *     *   *                             27 18                                           27
2961188 2961188 NM     school 3501320 50   HOUSE 350132000909 58 HOUSE JUNIOR HIGH Public - Junior High Regular School No Middle 07 08 2021   pk_12_total * * *   * *     *   *                             3                                             3
2961197 2961197 NM     school 3501380 56   JEMEZ MOUNTAIN 350138000371 87 LYBROOK ELEMENTARY Public - Elementary School Regular School No Elementary PK 08 2021   pk_12_total * * *   68 *     *   *                             69         68                                   69
2961201 2961201 NM     school 3501410 63   JEMEZ VALLEY 350141000800 4 SAN DIEGO RIVERSIDE Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total * * *   78 *     *   *                             80         78                                   80
2961202 2961202 NM     school   63   JEMEZ VALLEY   5 WALATOWA HEAD START Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
2961206 2961206 NM     school   99   JUVENILE JUSTICE   0 JUVENILE JUSTICE DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961231 2961231 NM     school   17   LAS CRUCES   999 HOME SCHOOL Home School - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961265 2961265 NM     school 3501590 51   LOGAN 350159000420 80 LOGAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 67 * *   * *     *   *                             87 67                                           87
2961272 2961272 NM     school   29   LORDSBURG   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             7                                             7
2961277 2961277 NM     school   41   LOS ALAMOS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961280 2961280 NM     school   41   LOS ALAMOS   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * *   * *     *   *                             4                                             4
2961284 2961284 NM     school   86   LOS LUNAS   11 ADELINO HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961289 2961289 NM     school   86   LOS LUNAS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             5                                             5
2961305 2961305 NM     school   31   LOVINGTON   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961307 2961307 NM     school   31   LOVINGTON   1 LEA COUNTY JD CENTER Off-Site - High School           2021   pk_12_total * * *   * *     *   *                             9                                             9
2961321 2961321 NM     school 3501800 11   MAXWELL 350180000458 108 MAXWELL MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total 12 * *   * *     *   *                             23 12                                           23
2961322 2961322 NM     school   547   MCCURDY CHARTER SCHOOL   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961329 2961329 NM     school   78   MESA VISTA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961339 2961339 NM     school   44   MORA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961345 2961345 NM     school   81   MORIARTY-EDGEWOOD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961346 2961346 NM     school   81   MORIARTY-EDGEWOOD   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961352 2961352 NM     school 3501920 28   MOSQUERO 350192000470 100 MOSQUERO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 40 * *   * *     *   *                             53 40                                           53
2961359 2961359 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             1                                             1
2961360 2961360 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             3                                             3
2961362 2961362 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             1                                             1
2961363 2961363 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             2                                             2
2961364 2961364 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             2                                             2
2961365 2961365 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             4                                             4
2961366 2961366 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             4                                             4

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