Data source: Big Local News · About: Big Local

14,925 rows where state = "NM" and year = 2020 sorted by hispanic descending

View and edit SQL

year

  • 2020 · 14,925
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
2554791 NM     school 3500060 1   ALBUQUERQUE 350006000106 550 SANDIA HIGH Public Regular School No High 09 12 2020   pk_12_total 546 * 997   95 66     *   80                             1835 546   997   95 66         80                       1835
2555165 NM     school 3501200 5   HAGERMAN 350120000340 55 HAGERMAN HIGH Public Regular School No High 09 12 2020   pk_12_total 29 * 99   * *     *   *                             130 29   99                                       130
2555580 NM     school 3502610 73   TRUTH OR CONS. 350261000591 16 ARREY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 99   * *     *   *                             104     99                                       104
2554766 NM     school 3500060 1   ALBUQUERQUE 350006000920 98 MOUNTAIN MAHOGANY COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 77 7 98   * *     *   14                             197 77 7 98               14                       197
2554873 NM     school   61   BERNALILLO   29 LA ESCUELITA EARLY CHILDHOOD Off-Site           2020   pk_12_total 25 * 98   15 *     *   *                             140 25   98   15                                   140
2555031 NM     school 3500900 55   ESPANOLA 350090000685 142 LOS NINOS ELEMENTARY Public Regular School No Elementary PK KG 2020   pk_12_total * * 98   * *     *   *                             104     98                                       104
2555204 NM     school 3501350 34   JAL 350135000363 60 JAL JR HIGH Public Regular School No Middle 06 08 2020   pk_12_total * * 98   * *     *   *                             126     98                                       126
2555465 NM     school 3502250 4   ROSWELL 350225000696 132 UNIVERSITY HIGH Public Alternative School No High 09 12 2020   pk_12_total 29 * 98   * *     *   *                             131 29   98                                       131
2555041 NM     school 3500930 80   ESTANCIA 350093000278 169 LOWER ELEMENTARY Public Regular School No Elementary 01 03 2020   pk_12_total 50 * 97   * *     *   *                             152 50   97                                       152
2555296 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   pk_12_total 174 * 97   6 13     *   12                             305 174   97   6 13         12                       305
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
2554809 NM     school 3500060 1   ALBUQUERQUE 350006000114 475 TRUMAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 36 12 961   20 *     *   *                             1036 36 12 961   20                                   1036
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
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
2555535 NM     school 3502430 23   SILVER CITY 350243000565 155 SIXTH STREET ELEMENTARY Public Regular School No Elementary KG KG 2020   pk_12_total 44 * 96   * *     *   *                             146 44   96                                       146
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
2555043 NM     school 3500930 80   ESTANCIA 350093000791 1 UPPER ELEMENTARY Public Regular School No Middle 04 06 2020   pk_12_total 29 * 95   * *     *   *                             129 29   95                                       129
2555050 NM     school 3500990 65   FARMINGTON 350099000280 15 ANIMAS ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 64 * 95   219 *     *   *                             408 64   95   219                                   408
2554957 NM     school 3500570 12   CLOVIS 350057000213 36 CLOVIS HIGH Public Regular School No High 09 12 2020   pk_12_total 399 82 941   * 16     *   36                             1481 399 82 941     16         36                       1481
2555273 NM     school 3501530 69   LAS VEGAS CITY 350153000863 3 LVCS EARLY CHILDHOOD Public Regular School No Elementary PK KG 2020   pk_12_total * * 94   * *     *   *                             98     94                                       98
2555591 NM     school 3502670 47   TULAROSA 350267000604 163 TULAROSA ELEMENTARY Public Regular School No Elementary PK 02 2020   pk_12_total 64 * 94   56 *     *   *                             219 64   94   56                                   219
2554812 NM     school 3500060 1   ALBUQUERQUE 350006000116 560 VALLEY HIGH Public Regular School No High 09 12 2020   pk_12_total 72 18 932   30 *     *   12                             1067 72 18 932   30           12                       1067
2555295 NM     school 3501650 41   LOS ALAMOS 350165000434 127 PINON ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 229 * 93   6 *     *   9                             343 229   93   6           9                       343
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
2555491 NM     school 3502370 71   SANTA FE 350237001120 166 EARLY COLLEGE OPPORTUNITIES Public Regular School No High 09 12 2020   pk_12_total 20 * 92   * *     *   *                             116 20   92                                       116
2555607 NM     school 3501560 68   WEST LAS VEGAS 350156000635 157 UNION ELEMENTARY Public Regular School No Middle 05 05 2020   pk_12_total * * 92   * *     *   *                             96     92                                       96
2555338 NM     school 3500109 501   MEDIA ARTS COLLABORATIVE CHARTER 350010901030 1 MEDIA ARTS COLLABORATIVE CHARTER Charter Regular School Yes High 06 12 2020   pk_12_total 105 7 90   14 *     *   6                             224 105 7 90   14           6                       224
2555606 NM     school 3501560 68   WEST LAS VEGAS 350156000412 125 TONY SERNA JR. ELEMENTARY Public Regular School No Elementary 04 04 2020   pk_12_total * * 90   * *     *   *                             94     90                                       94
2555109 NM     school 3501110 43   GALLUP 350111000732 30 CHEE DODGE ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 9   241 *     *   *                             254     9   241                                   254
2555234 NM     school   17   LAS CRUCES   49 DONA ANA HEADSTART Off-Site           2020   pk_12_total * * 9   * *     *   *                             11     9                                       11
2555235 NM     school   17   LAS CRUCES   38 DONA ANA JDC Off-Site           2020   pk_12_total * * 9   * *     *   *                             12     9                                       12
2555341 NM     school 3501830 14   MELROSE 350183000898 93 MELROSE JUNIOR Public Regular School No Middle 07 08 2020   pk_12_total 37 * 9   * *     *   *                             49 37   9                                       49
2554634 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 269 52 89   * *     12   51                             480 269 52 89           12   51                       480
2555348 NM     school 3500148 542   MISSION ACHIEVEMENT AND SUCCESS 350014801089 1 MISSION ACHIEVEMENT AND SUCCESS 1.0 Charter Regular School Yes Other PK 12 2020   pk_12_total 120 37 886   33 12     *   *                             1096 120 37 886   33 12                                 1096
2554687 NM     school 3500060 1   ALBUQUERQUE 350006000273 900 DESERT WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   pk_12_total 185 * 88   * 7     *   17                             300 185   88     7         17                       300
2554760 NM     school   1   ALBUQUERQUE   997 MISC PRIVATE Private           2020   pk_12_total 69 * 88   * *     *   *                             169 69   88                                       169
2555391 NM     school 3502040 77   PENASCO 350204000481 123 PENASCO HIGH Public Regular School No High 09 12 2020   pk_12_total * * 88   15 *     *   *                             108     88   15                                   108
2555017 NM     school 3500900 55   ESPANOLA 350090000259 5 ABIQUIU ELEMENTARY Public Regular School No Elementary KG 06 2020   pk_12_total * * 87   * *     *   *                             93     87                                       93
2555094 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   pk_12_total * * 86   * *     *   *                             90     86                                       90
2554693 NM     school 3500060 1   ALBUQUERQUE 350006000808 24 EAST MOUNTAIN HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 246 * 85   11 8     *   *                             358 246   85   11 8                                 358
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
2555076 NM     school 3501050 16   FT SUMNER 350105000296 51 FORT SUMNER ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 56 * 85   * *     *   *                             148 56   85                                       148
2554750 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public Regular School No Other PK 12 2020   pk_12_total 315 * 840   108 68     *   72                             1457 315   840   108 68         72                       1457
2555383 NM     school 3500119 509   NM SCHOOL FOR ARTS 350011901058 1 NM SCHOOL FOR THE ARTS Charter Regular School Yes High 09 12 2020   pk_12_total 120 * 84   20 12     *   *                             246 120   84   20 12                                 246
2554704 NM     school 3500060 1   ALBUQUERQUE 350006000055 596 FREEDOM HIGH Public Alternative School No High 09 12 2020   pk_12_total 28 6 83   12 *     *   *                             131 28 6 83   12                                   131
2555135 NM     school 3501110 43   GALLUP 350111030020 152 STAGECOACH ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 82   206 *     *   *                             293     82   206                                   293
2555537 NM     school 3502460 74   SOCORRO 350246000843 3 COTTONWOOD VALLEY CHARTER Charter Regular School Yes Elementary KG 08 2020   pk_12_total 77 * 82   * 6     *   *                             170 77   82     6                                 170
2554719 NM     school 3500060 1   ALBUQUERQUE 350006000063 520 HIGHLAND HIGH Public Regular School No High 09 12 2020   pk_12_total 98 100 818   86 *     *   38                             1163 98 100 818   86           38                       1163
2554764 NM     school 3500060 1   ALBUQUERQUE 350006000894 95 MONTESSORI OF THE RIO GRANDE Charter Regular School Yes Elementary KG 05 2020   pk_12_total 127 * 81   6 *     *   *                             217 127   81   6                                   217
2555281 NM     school 3501620 29   LORDSBURG 350162000422 34 CENTRAL ELEMENTARY Public Regular School No Middle 05 06 2020   pk_12_total 12 * 81   * *     *   *                             94 12   81                                       94
2554709 NM     school 3500060 1   ALBUQUERQUE 350006001040 30 GORDON BERNELL CHARTER Charter Regular School Yes High 09 12 2020   pk_12_total 16 8 80   35 *     *   *                             142 16 8 80   35                                   142
2554792 NM     school 3500060 1   ALBUQUERQUE 350006000108 597 SCHOOL ON WHEELS HIGH SCHOOL Public Alternative School No High 09 12 2020   pk_12_total * * 80   * *     *   *                             83     80                                       83
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
2555513 NM     school 3502370 71   SANTA FE 350237000552 160 TESUQUE ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 14 * 80   10 *     *   *                             105 14   80   10                                   105
2555016 NM     school 3500840 58   ELIDA 350084000256 48 ELIDA HIGH Public Regular School No High 07 12 2020   pk_12_total 60 * 8   * *     *   *                             69 60   8                                       69
2555493 NM     school 3502370 71   SANTA FE 350237000535 11 EL CAMINO REAL ACADEMY COMMUNITY Public Regular School No Elementary PK 08 2020   pk_12_total 37 * 795   * *     *   *                             836 37   795                                       836
2555069 NM     school 3500990 65   FARMINGTON 350099000740 148 ROCINANTE HIGH Public Alternative School No High 06 12 2020   pk_12_total 80 * 79   89 *     *   14                             263 80   79   89           14                       263
2555092 NM     school 3501080 19   GADSDEN 350108000631 52 GADSDEN MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 10 * 778   * *     *   *                             790 10   778                                       790
2554628 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   pk_12_total 48 * 77   * *     *   7                             141 48   77               7                       141
2555409 NM     school 3502160 79   QUESTA 350216000804 1 ALTA VISTA ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total * * 77   * *     *   *                             87     77                                       87
2554855 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public Regular School No High 09 12 2020   pk_12_total 203 14 767   21 *     *   *                             1011 203 14 767   21                                   1011
2555024 NM     school 3500900 55   ESPANOLA 350090000268 50 ESPANOLA VALLEY HIGH Public Regular School No High 09 12 2020   pk_12_total 29 * 761   73 9     *   *                             875 29   761   73 9                                 875
2554829 NM     school 3500116 511   ALMA D'ARTE CHARTER 350011600900 1 ALMA D'ARTE CHARTER Charter Regular School Yes High 09 12 2020   pk_12_total 49 6 76   * *     *   *                             132 49 6 76                                       132
2555110 NM     school 3501110 43   GALLUP 350111001027 3 CHIEF MANUELITO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 10 * 76   476 *     *   8                             575 10   76   476           8                       575
2555569 NM     school 3502550 35   TATUM 350255000585 162 TATUM ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 95 * 76   * *     *   *                             175 95   76                                       175
2555574 NM     school 3502580 13   TEXICO 350258000590 163 TEXICO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 67 * 76   * *     *   *                             149 67   76                                       149
2555583 NM     school 3502610 73   TRUTH OR CONS. 350261000435 60 SIERRA ELEMENTARY Public Regular School No Elementary 04 05 2020   pk_12_total 109 * 76   * *     *   *                             190 109   76                                       190
2554700 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   pk_12_total 776 * 753   72 47     *   102                             1779 776   753   72 47         102                       1779
2554806 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 312 27 752   39 *     *   74                             1229 312 27 752   39           74                       1229
2555051 NM     school 3500990 65   FARMINGTON 350099000281 17 APACHE ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 46 * 75   315 *     *   33                             473 46   75   315           33                       473
2555385 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported Special Education School No Other PK 12 2020   pk_12_total 33 * 75   16 *     *   *                             132 33   75   16                                   132
2554627 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   pk_12_total 21 * 74   * *     *   *                             103 21   74                                       103
2555133 NM     school 3501110 43   GALLUP 350111000312 134 RED ROCK ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 83 * 74   138 14     *   10                             321 83   74   138 14         10                       321
2555166 NM     school 3501200 5   HAGERMAN 350120000341 56 HAGERMAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 74   * *     *   *                             99     74                                       99
2555218 NM     school 3500166 560   LA ACADEMIA DOLORES HUERTA 350016600901 1 LA ACADEMIA DOLORES HUERTA Charter Regular School Yes Middle 06 08 2020   pk_12_total * * 74   * *     *   *                             76     74                                       76
2555070 NM     school 3500990 65   FARMINGTON 350099001119 180 SAN JUAN COLLEGE HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 125 * 73   62 13     *   14                             291 125   73   62 13         14                       291
2555073 NM     school 3501020 59   FLOYD 350102000294 53 FLOYD ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total 32 * 73   * *     *   *                             107 32   73                                       107
2555086 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   pk_12_total * * 73   * *     *   *                             74     73                                       74
2555327 NM     school 3501740 31   LOVINGTON 350174000796 4 NEW HOPE ALTERNATIVE HIGH Public Alternative School No High 09 12 2020   pk_12_total 31 * 73   * *     *   *                             106 31   73                                       106
2555438 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 334 31 728   60 *     *   69                             1240 334 31 728   60           69                       1240
2555342 NM     school 3501980 78   MESA VISTA 350198000474 47 EL RITO ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total * * 72   * *     *   *                             78     72                                       78
2555567 NM     school 3500127 521   TAOS INTEGRATED SCHOOL OF THE ARTS 350012701060 1 TAOS INTEGRATED SCHOOL OF ARTS Charter Regular School Yes Elementary KG 08 2020   pk_12_total 79 * 72   18 *     *   *                             173 79   72   18                                   173
2555573 NM     school 3502580 13   TEXICO 350258000589 162 TEXICO HIGH Public Regular School No High 09 12 2020   pk_12_total 88 * 72   * *     *   *                             165 88   72                                       165
2555344 NM     school 3501980 78   MESA VISTA 350198000475 119 MESA VISTA HIGH Public Regular School No High 09 12 2020   pk_12_total 12 * 71   * *     *   *                             85 12   71                                       85
2555261 NM     school 3501500 17   LAS CRUCES 350150000455 144 SIERRA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 144 22 705   10 *     *   10                             902 144 22 705   10           10                       902
2555588 NM     school 3502640 49   TUCUMCARI 350264000599 164 TUCUMCARI HIGH Public Regular School No High 09 12 2020   pk_12_total 172 8 70   * *     *   *                             254 172 8 70                                       254
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
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
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
2554928 NM     school 3500390 67   CENTRAL CONS. 350039000187 75 OJO AMARILLO ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total * * 7   351 *     *   17                             378     7   351           17                       378
2555132 NM     school 3501110 43   GALLUP 350111000662 130 RAMAH HIGH Public Regular School No High 06 12 2020   pk_12_total 28 * 7   135 *     *   *                             175 28   7   135                                   175
2555150 NM     school 3501170 88   GRANTS 350117001153 60 GCCS EARLY COLLEGE HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total * * 7   16 *     *   *                             26     7   16                                   26
2555154 NM     school 3501170 88   GRANTS 350117000330 57 LAGUNA-ACOMA HIGH Public Regular School No High 09 12 2020   pk_12_total * * 7   185 *     *   *                             196     7   185                                   196
2555532 NM     school   23   SILVER CITY   997 MISC PRIVATE Private           2020   pk_12_total 28 * 7   * *     *   *                             36 28   7                                       36
2555559 NM     school   76   TAOS   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total 15 * 7   * *     *   *                             23 15   7                                       23
2555000 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   pk_12_total 15 * 69   * *     *   *                             85 15   69                                       85
2554730 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 55 24 686   39 *     *   8                             817 55 24 686   39           8                       817
2555001 NM     school 3500690 42   DEMING 350069001023 7 RED MOUNTAIN MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 88 13 685   * 15     *   *                             805 88 13 685     15                                 805
2554906 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   pk_12_total 463 20 682   38 *     *   56                             1265 463 20 682   38           56                       1265
2555313 NM     school 3501680 86   LOS LUNAS 350168000989 17 VALENCIA HIGH Public Regular School No High 09 12 2020   pk_12_total 211 7 682   34 *     *   13                             948 211 7 682   34           13                       948

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