enrollments

Data source: Big Local News · About: Big Local

14,670 rows where state = "NM" and year = 2021 sorted by white_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
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
2960667 2960667 NM     school   1   ALBUQUERQUE   48 BERNALILLO COUNTY JUVENILE DETENTION Off-Site - High School           2021   pk_12_total * * 16   * *     *   *                             19     16                                       19
2960741 2960741 NM     school 3500060 1   ALBUQUERQUE 350006000074 282 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total * * 120   6 *     *   *                             132     120   6                                   132
2960770 2960770 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter - High School Regular School Yes Other KG 12 2021   pk_12_total * * 83   371 *     *   39                             499     83   371           39                       499
2960772 2960772 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter - High School Regular School Yes High 09 12 2021   pk_12_total * * 202   * *     *   *                             213     202                                       213
2960794 2960794 NM     school 3500060 1   ALBUQUERQUE 350006000108 597 SCHOOL ON WHEELS HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   pk_12_total * * 63   * *     *   *                             70     63                                       70
2960821 2960821 NM     school 3500060 1   ALBUQUERQUE 350006001087 782 WILLIAM W & JOSEPHINE DORN CHARTER COMMUNITY SCHOOL Charter - Elementary School Regular School Yes Elementary KG 05 2021   pk_12_total * 7 21   * *     *   *                             36   7 21                                       36
2960825 2960825 NM     school 3500134 528   ALBUQUERQUE BILINGUAL ACADEMY 350013400923 1 ALBUQUERQUE BILINGUAL ACADEMY Charter - Elementary School Regular School Yes Elementary PK 08 2021   pk_12_total * * 392   * *     *   *                             395     392                                       395
2960835 2960835 NM     school   22   ARTESIA   0 ARTESIA DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * 8   * *     *   *                             13     8                                       13
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
2960866 2960866 NM     school 3500210 61   BERNALILLO 350021000147 16 ALGODONES ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 14   132 *     *   *                             149     14   132                                   149
2960870 2960870 NM     school 3500210 61   BERNALILLO 350021000150 20 COCHITI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 39   131 *     *   *                             171     39   131                                   171
2960871 2960871 NM     school 3500210 61   BERNALILLO 350021000727 24 COCHITI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 24   57 *     *   *                             82     24   57                                   82
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
2960883 2960883 NM     school 3500240 66   BLOOMFIELD 350024000771 1 CHARLIE Y. BROWN ALT Public - High School Alternative School No High 09 12 2021   pk_12_total * * 18   50 *     *   *                             84     18   50                                   84
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
2960909 2960909 NM     school 3500330 37   CARRIZOZO 350033000177 36 CARRIZOZO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 32   * *     *   *                             47     32                                       47
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
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
2960922 2960922 NM     school 3500390 67   CENTRAL CONS. 350039000182 114 NASCHITTI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 7   73 *     *   *                             83     7   73                                   83
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
2960924 2960924 NM     school 3500390 67   CENTRAL CONS. 350039000654 130 NEWCOMB HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 8   252 *     *   *                             267     8   252                                   267
2960925 2960925 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 6   165 *     *   *                             176     6   165                                   176
2960926 2960926 NM     school 3500390 67   CENTRAL CONS. 350039000184 152 NIZHONI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 7   262 *     *   20                             292     7   262           20                       292
2960927 2960927 NM     school 3500390 67   CENTRAL CONS. 350039000187 75 OJO AMARILLO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 7   294 *     *   19                             321     7   294           19                       321
2960928 2960928 NM     school   67   CENTRAL CONS.   8 SHIPROCK HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             4                                             4
2960929 2960929 NM     school 3500390 67   CENTRAL CONS. 350039000186 39 SHIPROCK HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 14   574 *     *   16                             606     14   574           16                       606
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
2960932 2960932 NM     school 3500420 53   CHAMA 350042000192 36 CHAMA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 75   * *     *   *                             87     75                                       87
2960933 2960933 NM     school 3500420 53   CHAMA 350042000193 42 CHAMA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 34   * *     *   *                             37     34                                       37
2960936 2960936 NM     school 3500480 8   CIMARRON 350048000197 33 CIMARRON ELEMENTARY Public - Elementary School Regular School No Elementary PK 04 2021   pk_12_total * * 33   * *     *   *                             54     33                                       54
2960938 2960938 NM     school 3500480 8   CIMARRON 350048000699 36 CIMARRON MIDDLE Public - Middle School Regular School No Middle 05 08 2021   pk_12_total * * 29   * *     *   *                             41     29                                       41
2960944 2960944 NM     school 3500510 84   CLAYTON 350051000204 38 CLAYTON JUNIOR HIGH Public - Middle School Regular School No Middle 07 08 2021   pk_12_total * * 39   * *     *   *                             67     39                                       67
2960945 2960945 NM     school 3500510 84   CLAYTON 350051000205 45 KISER ELEMENTARY Public - Elementary School Regular School No Middle 05 06 2021   pk_12_total * * 36   * *     *   *                             54     36                                       54
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
2960971 2960971 NM     school 3500600 24   COBRE CONS. 350060000227 36 COBRE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 276   * *     *   *                             299     276                                       299
2960972 2960972 NM     school   24   COBRE CONS.   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960974 2960974 NM     school 3500600 24   COBRE CONS. 350060000229 143 SAN LORENZO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 39   * *     *   *                             61     39                                       61
2960980 2960980 NM     school 3500660 62   CUBA 350066000235 75 CUBA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 28   87 *     *   *                             122     28   87                                   122
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
2960985 2960985 NM     school 3500690 42   DEMING 350069000238 36 COLUMBUS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 478   * *     *   *                             480     478                                       480
2960990 2960990 NM     school   42   DEMING   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960993 2960993 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   pk_12_total * * 32   * *     *   *                             35     32                                       35
2960998 2960998 NM     school 3500750 6   DEXTER 350075000247 43 DEXTER ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 299   * *     *   *                             344     299                                       344
2960999 2960999 NM     school 3500750 6   DEXTER 350075000248 45 DEXTER HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 223   * *     *   *                             271     223                                       271
2961000 2961000 NM     school 3500750 6   DEXTER 350075000249 48 DEXTER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 176   * *     *   *                             207     176                                       207
2961003 2961003 NM     school 3500810 54   DULCE 350081000252 44 DULCE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 20   263 *     *   *                             294     20   263                                   294
2961004 2961004 NM     school 3500810 54   DULCE 350081000253 45 DULCE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 8   161 *     *   *                             172     8   161                                   172
2961005 2961005 NM     school 3500810 54   DULCE 350081000716 50 DULCE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 7   117 *     *   *                             126     7   117                                   126
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
2961011 2961011 NM     school 3500900 55   ESPANOLA 350090000260 15 ALCALDE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 172   * *     *   *                             175     172                                       175
2961013 2961013 NM     school 3500900 55   ESPANOLA 350090000264 39 CHIMAYO ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total * * 131   * *     *   *                             142     131                                       142
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
2961020 2961020 NM     school 3500900 55   ESPANOLA 350090000271 59 HERNANDEZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total * * 67   * *     *   *                             77     67                                       77
2961021 2961021 NM     school   55   ESPANOLA   58 HOLY CROSS SCHOOL Private - Accredited Private School           2021   pk_12_total * * 24   * *     *   *                             28     24                                       28
2961022 2961022 NM     school   55   ESPANOLA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             4                                             4
2961024 2961024 NM     school 3500900 55   ESPANOLA 350090000685 142 LOS NINOS ELEMENTARY Public - Elementary School Regular School No Elementary PK KG 2021   pk_12_total * * 77   * *     *   *                             82     77                                       82
2961025 2961025 NM     school   55   ESPANOLA   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * 7   * *     *   *                             11     7                                       11
2961027 2961027 NM     school   55   ESPANOLA   10 SAN JUAN HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             6                                             6
2961029 2961029 NM     school 3500900 55   ESPANOLA 350090000277 169 VELARDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total * * 57   * *     *   *                             58     57                                       58
2961030 2961030 NM     school   55   ESPANOLA   188 VICTORY CHRISTIAN Private - Accredited Private School           2021   pk_12_total * * 38   * *     *   *                             43     38                                       43
2961035 2961035 NM     school 3500930 80   ESTANCIA 350093000613 185 VANSTONE ELEMENTARY Public - Elementary School Regular School No Elementary KG KG 2021   pk_12_total * * 19   * *     *   *                             24     19                                       24
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
2961064 2961064 NM     school 3501020 59   FLOYD 350102000295 54 FLOYD HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 34   * *     *   *                             51     34                                       51
2961065 2961065 NM     school 3501020 59   FLOYD 350102000770 1 FLOYD MIDDLE Public - Middle School Regular School No Middle 05 08 2021   pk_12_total * * 38   * *     *   *                             57     38                                       57
2961069 2961069 NM     school 3501080 19   GADSDEN 350108001104 18 ALTA VISTA EARLY COLLEGE HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pk_12_total * * 194   * *     *   *                             205     194                                       205
2961070 2961070 NM     school 3501080 19   GADSDEN 350108000625 16 ANTHONY ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 357   * *     *   *                             361     357                                       361
2961071 2961071 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total * * 125   * *     *   *                             126     125                                       126
2961072 2961072 NM     school 3501080 19   GADSDEN 350108030017 20 BERINO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 371   * *     *   *                             373     371                                       373
2961076 2961076 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total * * 153   * *     *   *                             162     153                                       162
2961078 2961078 NM     school 3501080 19   GADSDEN 350108000700 35 DESERT VIEW ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total * * 429   * *     *   *                             430     429                                       430
2961083 2961083 NM     school   19   GADSDEN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             10                                             10
2961084 2961084 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total * * 85   * *     *   *                             88     85                                       88
2961086 2961086 NM     school 3501080 19   GADSDEN 350108000656 86 LOMA LINDA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 312   * *     *   *                             318     312                                       318
2961087 2961087 NM     school 3501080 19   GADSDEN 350108000628 104 MESQUITE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 277   * *     *   *                             279     277                                       279
2961089 2961089 NM     school 3501080 19   GADSDEN 350108000719 140 RIVERSIDE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 518   * *     *   *                             520     518                                       520
2961090 2961090 NM     school   19   GADSDEN   6 RTC-RESIDENTAL TRAINING CENTER Off-Site - Special Education           2021   pk_12_total * * 11   * *     *   *                             22     11                                       22
2961094 2961094 NM     school 3501080 19   GADSDEN 350108000626 13 SUNLAND PARK ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 221   * *     *   *                             225     221                                       225
2961096 2961096 NM     school 3501080 19   GADSDEN 350108000934 1 VADO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 358   * *     *   *                             361     358                                       361
2961097 2961097 NM     school 3501080 19   GADSDEN 350108001125 25 YUCCA HEIGHTS ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total * * 560   * *     *   *                             566     560                                       566
2961098 2961098 NM     school 3501110 43   GALLUP 350111000299 34 CATHERINE A. MILLER ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 8   293 *     *   *                             302     8   293                                   302
2961099 2961099 NM     school 3501110 43   GALLUP 350111000732 30 CHEE DODGE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 6   231 *     *   *                             239     6   231                                   239

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