Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 14,570
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
2960860 NM     school 3500180 87   BELEN 350018000144 66 GIL SANCHEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 42 * 224   * *     *   *                             271 42   224                                       271
2960861 NM     school 3500180 87   BELEN 350018000145 68 JARAMILLO ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   pk_12_total 37 * 207   * *     *   *                             250 37   207                                       250
2960862 NM     school 3500180 87   BELEN 350018030003 38 LA MERCED ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 96 9 283   7 *     *   *                             397 96 9 283   7                                   397
2960863 NM     school 3500180 87   BELEN 350018000849 3 LA PROMESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 44 * 139   * *     *   *                             187 44   139                                       187
2960864 NM     school 3500180 87   BELEN 350018000146 45 RIO GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 41 * 203   * *     *   *                             250 41   203                                       250
2960865 NM     school 3500180 87   BELEN 350018000867 6 THE FAMILY SCHOOL Public - Elementary School Alternative School No Elementary 01 08 2021   pk_12_total 53 * 83   * *     *   *                             143 53   83                                       143
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
2960867 NM     school 3500210 61   BERNALILLO 350021000152 136 BERNALILLO ELEMENTARY Public - Elementary School Regular School No Elementary 03 05 2021   pk_12_total 33 * 199   84 *     *   *                             325 33   199   84                                   325
2960868 NM     school 3500210 61   BERNALILLO 350021000148 27 BERNALILLO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 33 * 386   369 *     *   *                             794 33   386   369                                   794
2960869 NM     school 3500210 61   BERNALILLO 350021000149 26 BERNALILLO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 28 * 249   162 *     *   *                             450 28   249   162                                   450
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 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 NM     school   61   BERNALILLO   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960873 NM     school   61   BERNALILLO   29 LA ESCUELITA EARLY CHILDHOOD Off-Site - Prekindergarten           2021   pk_12_total 21 * 87   8 *     *   *                             119 21   87   8                                   119
2960874 NM     school   61   BERNALILLO   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960875 NM     school 3500210 61   BERNALILLO 350021000151 127 PLACITAS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 49 * 66   * *     *   *                             126 49   66                                       126
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 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
2960878 NM     school 3500210 61   BERNALILLO 350021000728 140 WD CARROLL ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   pk_12_total 30 * 190   50 *     *   *                             273 30   190   50                                   273
2960879 NM     school 3500240 66   BLOOMFIELD 350024000155 25 BLANCO ELEMENTARY Public - Elementary School Regular School No Elementary 01 06 2021   pk_12_total 58 * 101   10 *     *   *                             173 58   101   10                                   173
2960880 NM     school 3500240 66   BLOOMFIELD 350024000609 30 BLOOMFIELD EARLY CHILDHOOD CENTER Public - Elementary School Regular School No Elementary PK KG 2021   pk_12_total 55 * 84   90 *     *   *                             232 55   84   90                                   232
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 NM     school   66   BLOOMFIELD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960885 NM     school 3500240 66   BLOOMFIELD 350024000158 95 MESA ALTA JR HIGH Public - Junior High Regular School No Middle 07 08 2021   pk_12_total 110 8 116   185 *     *   *                             427 110 8 116   185                                   427
2960886 NM     school 3500240 66   BLOOMFIELD 350024000651 125 NAABA ANI ELEMENTARY Public - Elementary School Regular School No Middle 04 06 2021   pk_12_total 122 * 102   201 *     *   *                             428 122   102   201                                   428
2960887 NM     school 3500270 40   CAPITAN 350027000160 33 CAPITAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 100 * 55   * *     *   *                             162 100   55                                       162
2960888 NM     school 3500270 40   CAPITAN 350027000161 34 CAPITAN HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 95 * 49   * *     *   *                             149 95   49                                       149
2960889 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 76 * 29   * *     *   *                             111 76   29                                       111
2960890 NM     school   40   CAPITAN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960891 NM     school   40   CAPITAN   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960892 NM     school 3500300 20   CARLSBAD 350030001109 35 CARLSBAD EARLY COLLEGE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 91 * 107   * 8     *   *                             208 91   107     8                                 208
2960893 NM     school 3500300 20   CARLSBAD 350030001157 164 CARLSBAD ENRICHMENT CENTER Public - High School Alternative School No High 06 12 2021   pk_12_total 58 * 139   * *     *   *                             200 58   139                                       200
2960894 NM     school   20   CARLSBAD   4 CARLSBAD HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             7                                             7
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
2960897 NM     school 3500300 20   CARLSBAD 350030000162 18 CARLSBAD SIXTH GRADE ACADEMY Public - Middle School Regular School No Middle 06 06 2021   pk_12_total 170 7 309   6 6     *   *                             500 170 7 309   6 6                                 500
2960898 NM     school 3500300 20   CARLSBAD 350030001156 163 COTTONWOOD ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   pk_12_total 139 11 522   * *     *   *                             675 139 11 522                                       675
2960899 NM     school 3500300 20   CARLSBAD 350030001118 160 DESERT WILLOW ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   pk_12_total 165 10 416   * *     *   *                             603 165 10 416                                       603
2960900 NM     school 3500300 20   CARLSBAD 350030000166 47 EARLY CHILDHOOD EDUCATION CENTER Public - Elementary School Regular School No Elementary PK KG 2021   pk_12_total 160 9 311   * 6     *   *                             494 160 9 311     6                                 494
2960901 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 82 * 138   * *     *   *                             227 82   138                                       227
2960902 NM     school   20   CARLSBAD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             7                                             7
2960903 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter - High School Regular School Yes Other KG 12 2021   pk_12_total 121 * 121   * *     *   *                             250 121   121                                       250
2960904 NM     school 3500300 20   CARLSBAD 350030000170 100 MONTERREY ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   pk_12_total 136 * 169   * *     *   *                             319 136   169                                       319
2960905 NM     school 3500300 20   CARLSBAD 350030001123 161 OCOTILLO ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   pk_12_total 260 6 270   7 *     *   *                             552 260 6 270   7                                   552
2960907 NM     school 3500300 20   CARLSBAD 350030000175 158 SUNSET ELEMENTARY Public - Elementary School Regular School No Elementary 01 05 2021   pk_12_total 178 * 226   * *     *   *                             413 178   226                                       413
2960908 NM     school 3500330 37   CARRIZOZO 350033000176 35 CARRIZOZO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total 21 * 30   * *     *   *                             52 21   30                                       52
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
2960910 NM     school 3500330 37   CARRIZOZO 350033000178 157 CARRIZOZO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 13 * 22   * *     *   *                             37 13   22                                       37
2960911 NM     school   37   CARRIZOZO   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             5                                             5
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 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
2960916 NM     school   67   CENTRAL CONS.   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
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
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
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 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
2960928 NM     school   67   CENTRAL CONS.   8 SHIPROCK HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             4                                             4
2960931 NM     school 3500117 512   CESAR CHAVEZ COMMUNITY SCHOOL 350011700891 1 CESAR CHAVEZ COMMUNITY SCHOOL Charter - High School Regular School Yes High 09 12 2021   pk_12_total 13 13 148   27 *     *   *                             203 13 13 148   27                                   203
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 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
2960934 NM     school 3500420 53   CHAMA 350042000194 165 ESCALANTE MIDDLE/HIGH SCHOOL Public - High School Regular School No High 07 12 2021   pk_12_total 19 * 122   10 *     *   *                             153 19   122   10                                   153
2960935 NM     school 3500420 53   CHAMA 350042000195 64 TIERRA AMARILLA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 11 * 84   7 *     *   *                             103 11   84   7                                   103
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
2960937 NM     school 3500480 8   CIMARRON 350048000198 34 CIMARRON HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 22 * 43   * *     *   *                             67 22   43                                       67
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
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
2960940 NM     school 3500480 8   CIMARRON 350048000302 48 EAGLE NEST MIDDLE Public - Middle School Regular School No Middle 05 08 2021   pk_12_total 45 * 31   * *     *   *                             79 45   31                                       79
2960941 NM     school 3500480 8   CIMARRON 350048000857 3 MORENO VALLEY HIGH Charter - High School Regular School Yes High 09 12 2021   pk_12_total 37 * 21   * *     *   *                             62 37   21                                       62
2960942 NM     school 3500510 84   CLAYTON 350051000200 37 ALVIS ELEMENTARY Public - Elementary School Regular School No Elementary PK 04 2021   pk_12_total 64 * 94   * *     *   *                             162 64   94                                       162
2960943 NM     school 3500510 84   CLAYTON 350051000203 39 CLAYTON HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 47 * 68   * *     *   *                             124 47   68                                       124
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 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
2960946 NM     school 3500540 48   CLOUDCROFT 350054000206 38 CLOUDCROFT ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 103 * 35   * *     *   *                             143 103   35                                       143
2960947 NM     school 3500540 48   CLOUDCROFT 350054000207 39 CLOUDCROFT HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 113 * 15   * *     *   *                             134 113   15                                       134
2960948 NM     school 3500540 48   CLOUDCROFT 350054030005 42 CLOUDCROFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 67 * 20   * *     *   *                             89 67   20                                       89
2960949 NM     school   48   CLOUDCROFT   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960952 NM     school 3500570 12   CLOVIS 350057000211 68 CAMEO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 33 20 222   * *     *   *                             283 33 20 222                                       283
2960955 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public - High School Regular School No Other 02 12 2021   pk_12_total 33 * 66   * *     *   *                             105 33   66                                       105
2960957 NM     school   12   CLOVIS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960958 NM     school 3500570 12   CLOVIS 350057000210 66 JAMES BICKLEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 61 21 230   * *     *   *                             320 61 21 230                                       320
2960959 NM     school 3500570 12   CLOVIS 350057000215 72 LA CASITA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 11 * 234   * *     *   *                             249 11   234                                       249
2960960 NM     school 3500570 12   CLOVIS 350057000217 84 LOCKWOOD ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 35 * 271   * *     *   *                             316 35   271                                       316
2960961 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 24 * 48   * *     *   *                             83 24   48                                       83
2960969 NM     school 3500600 24   COBRE CONS. 350060000225 23 BAYARD ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 13 * 161   * *     *   *                             175 13   161                                       175
2960970 NM     school 3500600 24   COBRE CONS. 350060000226 33 CENTRAL ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 9 * 169   * *     *   *                             179 9   169                                       179
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 NM     school   24   COBRE CONS.   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             3                                             3
2960973 NM     school 3500600 24   COBRE CONS. 350060000228 59 HURLEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 16 * 99   * *     *   *                             119 16   99                                       119
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
2960975 NM     school 3500600 24   COBRE CONS. 350060000230 132 SNELL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 14 * 221   * *     *   *                             241 14   221                                       241
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 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
2960978 NM     school 3500660 62   CUBA 350066000233 37 CUBA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 7 * 57   160 *     *   *                             230 7   57   160                                   230
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 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
2960982 NM     school 3500690 42   DEMING 350069000941 5 BATAAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 49 * 403   * 7     *   *                             465 49   403     7                                 465
2960983 NM     school 3500690 42   DEMING 350069000236 24 BELL ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 26 * 202   * *     *   *                             235 26   202                                       235
2960984 NM     school 3500690 42   DEMING 350069000237 28 CHAPARRAL ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 68 * 282   * 7     *   *                             369 68   282     7                                 369
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
2960986 NM     school 3500690 42   DEMING 350069000963 6 DEMING CESAR CHAVEZ Charter - High School Regular School Yes High 09 12 2021   pk_12_total 12 * 111   * *     *   *                             129 12   111                                       129
2960988 NM     school 3500690 42   DEMING 350069000240 25 DEMING INTERMEDIATE Public - Middle School Regular School No Middle 06 06 2021   pk_12_total 42 * 359   * *     *   *                             414 42   359                                       414

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