enrollments

Data source: Big Local News · About: Big Local

29,595 rows where state = "NM" sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2554858 2554858 NM     school 3500180 87   BELEN 350018000142 34 CENTRAL ELEMENTARY Public Regular School No Middle 04 06 2020   pk_12_total 36 * 177   * *     *   *                             222 36   177                                       222
2554859 2554859 NM     school 3500180 87   BELEN 350018000143 80 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 55 * 228   * *     *   *                             292 55   228                                       292
2554860 2554860 NM     school 3500180 87   BELEN 350018000144 66 GIL SANCHEZ ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 44 * 235   6 *     *   *                             287 44   235   6                                   287
2554861 2554861 NM     school 3500180 87   BELEN 350018000145 68 JARAMILLO ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total 55 9 223   * *     *   *                             289 55 9 223                                       289
2554862 2554862 NM     school 3500180 87   BELEN 350018030003 38 LA MERCED ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 110 7 297   10 *     *   *                             425 110 7 297   10                                   425
2554863 2554863 NM     school 3500180 87   BELEN 350018000849 3 LA PROMESA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 37 * 162   * *     *   *                             204 37   162                                       204
2554864 2554864 NM     school 3500180 87   BELEN 350018000146 45 RIO GRANDE ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 60 * 238   * *     *   *                             306 60   238                                       306
2554865 2554865 NM     school 3500180 87   BELEN 350018000867 6 THE FAMILY SCHOOL Public Alternative School No Elementary 01 08 2020   pk_12_total 71 * 92   * *     *   *                             174 71   92                                       174
2554866 2554866 NM     school 3500210 61   BERNALILLO 350021000147 16 ALGODONES ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 7   151 *     *   *                             163     7   151                                   163
2554867 2554867 NM     school 3500210 61   BERNALILLO 350021000152 136 BERNALILLO ELEMENTARY Public Regular School No Elementary 03 05 2020   pk_12_total 33 6 213   99 *     *   *                             355 33 6 213   99                                   355
2554868 2554868 NM     school 3500210 61   BERNALILLO 350021000148 27 BERNALILLO HIGH Public Regular School No High 09 12 2020   pk_12_total 51 * 369   356 *     *   *                             780 51   369   356                                   780
2554869 2554869 NM     school 3500210 61   BERNALILLO 350021000149 26 BERNALILLO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 39 * 255   176 *     *   *                             477 39   255   176                                   477
2554870 2554870 NM     school 3500210 61   BERNALILLO 350021000150 20 COCHITI ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 39   141 *     *   *                             184     39   141                                   184
2554871 2554871 NM     school 3500210 61   BERNALILLO 350021000727 24 COCHITI MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 24   49 *     *   *                             74     24   49                                   74
2554872 2554872 NM     school   61   BERNALILLO   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             2                                             2
2554873 2554873 NM     school   61   BERNALILLO   29 LA ESCUELITA EARLY CHILDHOOD Off-Site           2020   pk_12_total 25 * 98   15 *     *   *                             140 25   98   15                                   140
2554874 2554874 NM     school   61   BERNALILLO   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   11 *     *   *                             13         11                                   13
2554875 2554875 NM     school 3500210 61   BERNALILLO 350021000151 127 PLACITAS ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 58 6 68   6 *     *   *                             141 58 6 68   6                                   141
2554876 2554876 NM     school 3500210 61   BERNALILLO 350021000153 151 SANTO DOMINGO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * *   257 *     *   *                             261         257                                   261
2554877 2554877 NM     school 3500210 61   BERNALILLO 350021000154 28 SANTO DOMINGO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * *   * *     *   *                             87                                             87
2554878 2554878 NM     school 3500210 61   BERNALILLO 350021000728 140 WD CARROLL ELEMENTARY Public Regular School No Elementary PK 02 2020   pk_12_total 37 * 233   42 *     *   *                             316 37   233   42                                   316
2554879 2554879 NM     school 3500240 66   BLOOMFIELD 350024000155 25 BLANCO ELEMENTARY Public Regular School No Elementary 01 06 2020   pk_12_total 78 * 95   18 *     *   *                             197 78   95   18                                   197
2554880 2554880 NM     school 3500240 66   BLOOMFIELD 350024000609 30 BLOOMFIELD EARLY CHILDHOOD CENTER Public Regular School No Elementary PK KG 2020   pk_12_total 76 * 127   84 *     *   *                             292 76   127   84                                   292
2554883 2554883 NM     school 3500240 66   BLOOMFIELD 350024000771 1 CHARLIE Y. BROWN ALT Public Alternative School No High 09 12 2020   pk_12_total 18 * 19   48 *     *   *                             87 18   19   48                                   87
2554884 2554884 NM     school 3500240 66   BLOOMFIELD 350024000158 95 MESA ALTA JR HIGH Public Regular School No Middle 07 08 2020   pk_12_total 105 * 134   157 *     *   *                             405 105   134   157                                   405
2554885 2554885 NM     school 3500240 66   BLOOMFIELD 350024000651 125 NAABA ANI ELEMENTARY Public Regular School No Middle 04 06 2020   pk_12_total 142 7 128   241 *     *   *                             522 142 7 128   241                                   522
2554886 2554886 NM     school 3500270 40   CAPITAN 350027000160 33 CAPITAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 135 * 59   * *     *   *                             199 135   59                                       199
2554887 2554887 NM     school 3500270 40   CAPITAN 350027000161 34 CAPITAN HIGH Public Regular School No High 09 12 2020   pk_12_total 111 * 50   * *     *   *                             166 111   50                                       166
2554888 2554888 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 81 * 35   * *     *   *                             121 81   35                                       121
2554889 2554889 NM     school   40   CAPITAN   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554890 2554890 NM     school   40   CAPITAN   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             2                                             2
2554891 2554891 NM     school 3500300 20   CARLSBAD 350030001109 35 CARLSBAD EARLY COLLEGE HIGH Public Regular School No High 09 12 2020   pk_12_total 93 * 105   * 8     *   *                             214 93   105     8                                 214
2554892 2554892 NM     school   20   CARLSBAD   4 CARLSBAD HEADSTART Off-Site           2020   pk_12_total * * 10   * *     *   *                             12     10                                       12
2554893 2554893 NM     school 3500300 20   CARLSBAD 350030000163 34 CARLSBAD HIGH Public Regular School No High 09 12 2020   pk_12_total 619 38 964   10 12     *   *                             1653 619 38 964   10 12                                 1653
2554894 2554894 NM     school 3500300 20   CARLSBAD 350030000169 32 CARLSBAD INTERMEDIATE SCHOOL Public Regular School No Middle 07 08 2020   pk_12_total 356 15 582   8 12     *   *                             984 356 15 582   8 12                                 984
2554895 2554895 NM     school 3500300 20   CARLSBAD 350030000162 18 CARLSBAD SIXTH GRADE ACADEMY Public Regular School No Middle 06 06 2020   pk_12_total 180 12 345   * 6     *   *                             552 180 12 345     6                                 552
2554896 2554896 NM     school 3500300 20   CARLSBAD 350030000463 38 CRAFT ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 43 * 154   * *     *   *                             203 43   154                                       203
2554897 2554897 NM     school 3500300 20   CARLSBAD 350030001118 160 DESERT WILLOW ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 196 17 511   11 *     *   *                             743 196 17 511   11                                   743
2554898 2554898 NM     school 3500300 20   CARLSBAD 350030000166 47 EARLY CHILDHOOD EDUCATION CENTER Public Regular School No Elementary PK KG 2020   pk_12_total 196 7 377   * *     *   *                             590 196 7 377                                       590
2554899 2554899 NM     school 3500300 20   CARLSBAD 350030001154 162 EDISON ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 51 * 85   * *     *   *                             137 51   85                                       137
2554900 2554900 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public Regular School No Prekindergarten PK PK 2020   pk_12_total 128 * 197   * *     *   *                             339 128   197                                       339
2554901 2554901 NM     school   20   CARLSBAD   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             5                                             5
2554902 2554902 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter Regular School Yes Other KG 12 2020   pk_12_total 119 * 107   * 6     *   *                             238 119   107     6                                 238
2554903 2554903 NM     school 3500300 20   CARLSBAD 350030000174 144 JOE STANLEY SMITH ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 86 * 255   * *     *   *                             350 86   255                                       350
2554904 2554904 NM     school 3500300 20   CARLSBAD 350030000170 100 MONTERREY ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 166 * 171   * *     *   *                             349 166   171                                       349
2554905 2554905 NM     school 3500300 20   CARLSBAD 350030001123 161 OCOTILLO ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 326 * 298   7 *     *   *                             645 326   298   7                                   645
2554907 2554907 NM     school 3500300 20   CARLSBAD 350030000175 158 SUNSET ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 187 * 199   6 *     *   *                             398 187   199   6                                   398
2554908 2554908 NM     school 3500330 37   CARRIZOZO 350033000176 35 CARRIZOZO ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 21 * 29   * *     *   *                             51 21   29                                       51
2554909 2554909 NM     school 3500330 37   CARRIZOZO 350033000177 36 CARRIZOZO HIGH Public Regular School No High 09 12 2020   pk_12_total 15 * 36   * *     *   *                             52 15   36                                       52
2554910 2554910 NM     school 3500330 37   CARRIZOZO 350033000178 157 CARRIZOZO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 11 * 18   * *     *   *                             30 11   18                                       30
2554911 2554911 NM     school   37   CARRIZOZO   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2554912 2554912 NM     school 3500390 67   CENTRAL CONS. 350039000772 25 CAREER PREP ALTERNATIVE Public Alternative School No High 09 12 2020   pk_12_total * * *   166 *     *   *                             173         166                                   173
2554914 2554914 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter Regular School Yes Not applicable N N 2020   pk_12_total * * *   * *     *   *                             18                                             18
2554916 2554916 NM     school   67   CENTRAL CONS.   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2554917 2554917 NM     school   67   CENTRAL CONS.   993 HOSPITALIZED Off-Site           2020   pk_12_total * * *   * *     *   *                             8                                             8
2554921 2554921 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   pk_12_total 19 * 7   70 *     *   *                             99 19   7   70                                   99
2554923 2554923 NM     school 3500390 67   CENTRAL CONS. 350039000182 114 NASCHITTI ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 6   85 *     *   *                             94     6   85                                   94
2554925 2554925 NM     school 3500390 67   CENTRAL CONS. 350039000654 130 NEWCOMB HIGH Public Regular School No High 09 12 2020   pk_12_total * * *   256 *     *   *                             266         256                                   266
2554926 2554926 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 7   176 *     *   *                             188     7   176                                   188
2554929 2554929 NM     school   67   CENTRAL CONS.   8 SHIPROCK HEADSTART Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554932 2554932 NM     school 3500117 512   CESAR CHAVEZ COMMUNITY SCHOOL 350011700891 1 CESAR CHAVEZ COMMUNITY SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 18 7 157   19 *     *   *                             204 18 7 157   19                                   204
2554933 2554933 NM     school 3500420 53   CHAMA 350042000192 36 CHAMA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 10 * 80   6 *     *   *                             100 10   80   6                                   100
2554934 2554934 NM     school 3500420 53   CHAMA 350042000193 42 CHAMA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 33   * *     *   *                             41     33                                       41
2554935 2554935 NM     school 3500420 53   CHAMA 350042000194 165 ESCALANTE MIDDLE/HIGH SCHOOL Public Regular School No High 07 12 2020   pk_12_total 28 * 127   6 *     *   *                             164 28   127   6                                   164
2554936 2554936 NM     school   53   CHAMA   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554937 2554937 NM     school 3500420 53   CHAMA 350042000195 64 TIERRA AMARILLA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 15 * 96   * *     *   *                             120 15   96                                       120
2554938 2554938 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pk_12_total 17 * 20   * *     *   *                             41 17   20                                       41
2554939 2554939 NM     school 3500480 8   CIMARRON 350048000197 33 CIMARRON ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total * * 38   * *     *   *                             59     38                                       59
2554940 2554940 NM     school 3500480 8   CIMARRON 350048000198 34 CIMARRON HIGH Public Regular School No High 09 12 2020   pk_12_total 33 * 40   * *     *   *                             76 33   40                                       76
2554941 2554941 NM     school 3500480 8   CIMARRON 350048000699 36 CIMARRON MIDDLE Public Regular School No Middle 05 08 2020   pk_12_total * * 36   * *     *   *                             49     36                                       49
2554942 2554942 NM     school 3500480 8   CIMARRON 350048000199 47 EAGLE NEST ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total 50 * 33   * *     *   *                             87 50   33                                       87
2554943 2554943 NM     school 3500480 8   CIMARRON 350048000302 48 EAGLE NEST MIDDLE Public Regular School No Middle 05 08 2020   pk_12_total 51 * 40   * *     *   *                             95 51   40                                       95
2554944 2554944 NM     school 3500480 8   CIMARRON 350048000857 3 MORENO VALLEY HIGH Charter Regular School Yes High 09 12 2020   pk_12_total 44 * 18   * *     *   *                             65 44   18                                       65
2554945 2554945 NM     school 3500510 84   CLAYTON 350051000200 37 ALVIS ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total 84 * 96   * *     *   *                             183 84   96                                       183
2554946 2554946 NM     school 3500510 84   CLAYTON 350051000203 39 CLAYTON HIGH Public Regular School No High 09 12 2020   pk_12_total 51 * 68   * *     *   *                             125 51   68                                       125
2554947 2554947 NM     school 3500510 84   CLAYTON 350051000204 38 CLAYTON JUNIOR HIGH Public Regular School No Middle 07 08 2020   pk_12_total 30 * 38   * *     *   *                             71 30   38                                       71
2554948 2554948 NM     school 3500510 84   CLAYTON 350051000205 45 KISER ELEMENTARY Public Regular School No Middle 05 06 2020   pk_12_total * * 36   * *     *   *                             60     36                                       60
2554949 2554949 NM     school 3500540 48   CLOUDCROFT 350054000206 38 CLOUDCROFT ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 132 * 36   * *     *   *                             173 132   36                                       173
2554950 2554950 NM     school 3500540 48   CLOUDCROFT 350054000207 39 CLOUDCROFT HIGH Public Regular School No High 09 12 2020   pk_12_total 119 * 16   * *     *   *                             142 119   16                                       142
2554951 2554951 NM     school 3500540 48   CLOUDCROFT 350054030005 42 CLOUDCROFT MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 78 * 23   * *     *   *                             104 78   23                                       104
2554952 2554952 NM     school   48   CLOUDCROFT   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             2                                             2
2554953 2554953 NM     school   48   CLOUDCROFT   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554956 2554956 NM     school 3500570 12   CLOVIS 350057000211 68 CAMEO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 30 25 235   * *     *   *                             299 30 25 235                                       299
2554959 2554959 NM     school   12   CLOVIS   30 CLOVIS JDC Off-Site           2020   pk_12_total * * *   * *     *   *                             9                                             9
2554960 2554960 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public Regular School No Other 02 12 2020   pk_12_total 31 * 63   * *     *   *                             98 31   63                                       98
2554962 2554962 NM     school   12   CLOVIS   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554963 2554963 NM     school 3500570 12   CLOVIS 350057000210 66 JAMES BICKLEY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 72 22 271   * *     *   *                             372 72 22 271                                       372
2554964 2554964 NM     school 3500570 12   CLOVIS 350057000215 72 LA CASITA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 16 * 247   * *     *   *                             267 16   247                                       267
2554965 2554965 NM     school 3500570 12   CLOVIS 350057000217 84 LOCKWOOD ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 51 * 317   * *     *   *                             377 51   317                                       377
2554966 2554966 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public Regular School No Prekindergarten PK PK 2020   pk_12_total 42 * 49   * *     *   *                             99 42   49                                       99
2554974 2554974 NM     school 3500600 24   COBRE CONS. 350060000225 23 BAYARD ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 18 * 220   * *     *   *                             245 18   220                                       245
2554975 2554975 NM     school 3500600 24   COBRE CONS. 350060000226 33 CENTRAL ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 22 * 235   * *     *   *                             258 22   235                                       258
2554976 2554976 NM     school 3500600 24   COBRE CONS. 350060000227 36 COBRE HIGH Public Regular School No High 09 12 2020   pk_12_total 24 * 297   * *     *   *                             322 24   297                                       322
2554977 2554977 NM     school   24   COBRE CONS.   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2554978 2554978 NM     school 3500600 24   COBRE CONS. 350060000228 59 HURLEY ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 9 * 141   * *     *   *                             153 9   141                                       153
2554979 2554979 NM     school 3500600 24   COBRE CONS. 350060000229 143 SAN LORENZO ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total * * 57   * *     *   *                             83     57                                       83
2554980 2554980 NM     school 3500600 24   COBRE CONS. 350060000230 132 SNELL MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 10 * 152   * *     *   *                             165 10   152                                       165
2554981 2554981 NM     school 3500630 38   CORONA 350063000231 38 CORONA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 20 * *   * *     *   *                             32 20                                           32
2554982 2554982 NM     school 3500630 38   CORONA 350063000232 39 CORONA HIGH Public Regular School No High 07 12 2020   pk_12_total 19 * *   * *     *   *                             28 19                                           28
2554983 2554983 NM     school 3500660 62   CUBA 350066000233 37 CUBA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 7 * 54   142 *     *   *                             208 7   54   142                                   208

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