Data source: Big Local News · About: Big Local

29,595 rows where state = "NM" sorted by rowid descending

View and edit SQL

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
2961605 NM     school 3502800 89   ZUNI 350280000678 195 ZUNI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   278 *     *   *                             279         278                                   279
2961604 NM     school 3502800 89   ZUNI 350280000676 190 ZUNI HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * *   322 *     *   *                             324         322                                   324
2961603 NM     school 3502800 89   ZUNI 350280000677 192 TWIN BUTTES CYBER ACADEMY Public - High School Regular School No High 07 12 2021   pk_12_total * * *   * *     *   *                             67                                             67
2961602 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * *   546 7     *   *                             562         546 7                                 562
2961601 NM     school   89   ZUNI   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * *   62 *     *   *                             66         62                                   66
2961600 NM     school   89   ZUNI   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             7                                             7
2961599 NM     school   89   ZUNI   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961598 NM     school 3501560 68   WEST LAS VEGAS 350156000815 3 WLV FAMILY PARTNERSHIP Public - High School Alternative School No High 07 12 2021   pk_12_total * * 32   * *     *   *                             34     32                                       34
2961597 NM     school 3501560 68   WEST LAS VEGAS 350156000419 172 WEST LAS VEGAS MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 18 * 284   * *     *   *                             306 18   284                                       306
2961596 NM     school 3501560 68   WEST LAS VEGAS 350156000418 173 WEST LAS VEGAS HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pk_12_total 34 * 375   * *     *   *                             413 34   375                                       413
2961595 NM     school   68   WEST LAS VEGAS   1 WEST LAS VEGAS HEAD START Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             2                                             2
2961594 NM     school   68   WEST LAS VEGAS   0 WEST LAS VEGAS DIST OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961593 NM     school 3501560 68   WEST LAS VEGAS 350156000416 68 VALLEY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 29   * *     *   *                             34     29                                       34
2961592 NM     school 3501560 68   WEST LAS VEGAS 350156000415 50 VALLEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 64   * *     *   *                             71     64                                       71
2961591 NM     school 3501560 68   WEST LAS VEGAS 350156000635 157 UNION ELEMENTARY Public - Elementary School Regular School No Middle 05 05 2021   pk_12_total 8 * 87   * *     *   *                             97 8   87                                       97
2961590 NM     school 3501560 68   WEST LAS VEGAS 350156000412 125 TONY SERNA JR. ELEMENTARY Public - Elementary School Regular School No Elementary 04 04 2021   pk_12_total * * 69   * *     *   *                             75     69                                       75
2961589 NM     school 3501560 68   WEST LAS VEGAS 350156000911 4 RIO GALLINAS SCHOOL Charter - Middle School Regular School Yes Elementary KG 08 2021   pk_12_total * * 63   * *     *   *                             68     63                                       68
2961588 NM     school 3501560 68   WEST LAS VEGAS 350156000408 12 LUIS E. ARMIJO ELEMENTARY Public - Elementary School Regular School No Elementary PK 01 2021   pk_12_total 21 * 179   * *     *   *                             208 21   179                                       208
2961587 NM     school 3501560 68   WEST LAS VEGAS 350156000411 112 DON CECILIO MARTINEZ ELEMENTARY Public - Elementary School Regular School No Elementary 02 03 2021   pk_12_total 6 * 202   * *     *   *                             213 6   202                                       213
2961586 NM     school   68   WEST LAS VEGAS   25 CARE Off-Site - Special Education           2021   pk_12_total * * *   * *     *   *                             4                                             4
2961585 NM     school 3500158 552   WALATOWA CHARTER HIGH 350015800883 1 WALATOWA CHARTER HIGH Charter - High School Regular School Yes High 09 12 2021   pk_12_total * * *   47 *     *   *                             54         47                                   54
2961584 NM     school 3502730 45   WAGON MOUND 350273000612 173 WAGON MOUND HIGH Public - High School Regular School No High 07 12 2021   pk_12_total * * 30   * *     *   *                             34     30                                       34
2961583 NM     school 3502730 45   WAGON MOUND 350273000611 172 WAGON MOUND ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 47   * *     *   *                             48     47                                       48
2961582 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public - High School Regular School No High 07 12 2021   pk_12_total * * 17   * *     *   *                             19     17                                       19
2961581 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 29   * *     *   *                             36     29                                       36
2961580 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   pk_12_total 17 * 19   * *     *   *                             41 17   19                                       41
2961579 NM     school 3500171 566   TURQUOISE TRAIL CHARTER SCHOOL 350017130008 1 TURQUOISE TRAIL CHARTER SCHOOL Charter - Elementary School Regular School Yes Elementary PK 08 2021   pk_12_total 137 * 516   14 9     *   10                             695 137   516   14 9         10                       695
2961578 NM     school 3502670 47   TULAROSA 350267000606 164 TULAROSA MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total 26 * 59   49 *     *   *                             136 26   59   49                                   136
2961577 NM     school 3502670 47   TULAROSA 350267000968 160 TULAROSA INTERMEDIATE Public - Elementary School Regular School No Elementary 03 06 2021   pk_12_total 66 * 111   65 *     *   *                             250 66   111   65                                   250
2961576 NM     school 3502670 47   TULAROSA 350267000605 165 TULAROSA HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 62 * 98   72 *     *   *                             236 62   98   72                                   236
2961575 NM     school 3502670 47   TULAROSA 350267000604 163 TULAROSA ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   pk_12_total 51 * 76   56 *     *   *                             190 51   76   56                                   190
2961574 NM     school   47   TULAROSA   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             3                                             3
2961573 NM     school 3502640 49   TUCUMCARI 350264000600 163 TUCUMCARI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 59 * 145   * *     *   *                             209 59   145                                       209
2961572 NM     school 3502640 49   TUCUMCARI 350264000599 164 TUCUMCARI HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 78 6 153   * *     *   *                             240 78 6 153                                       240
2961571 NM     school 3502640 49   TUCUMCARI 350264000602 53 TUCUMCARI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 110 6 305   * *     *   *                             428 110 6 305                                       428
2961570 NM     school   49   TUCUMCARI   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             3                                             3
2961569 NM     school 3502610 73   TRUTH OR CONS. 350261000595 63 T OR C MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 127 * 150   * *     *   *                             286 127   150                                       286
2961568 NM     school 3502610 73   TRUTH OR CONS. 350261000594 162 T OR C ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   pk_12_total 173 * 138   * *     *   9                             327 173   138               9                       327
2961567 NM     school   73   TRUTH OR CONS.   0 T OR C DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961566 NM     school 3502610 73   TRUTH OR CONS. 350261000435 60 SIERRA ELEMENTARY Public - Elementary School Regular School No Elementary 04 05 2021   pk_12_total 78 * 63   * *     *   *                             151 78   63                                       151
2961565 NM     school 3502610 73   TRUTH OR CONS. 350261000593 58 HOT SPRINGS HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 140 * 199   * *     *   *                             353 140   199                                       353
2961564 NM     school 3502610 73   TRUTH OR CONS. 350261000591 16 ARREY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 9 * 81   * *     *   *                             93 9   81                                       93
2961563 NM     school 3500173 565   TIERRA ENCANTADA CHARTER SCHOOL 350017300950 1 TIERRA ENCANTADA CHARTER SCHOOL Charter - High School Regular School Yes High 07 12 2021   pk_12_total 16 * 298   * *     *   *                             319 16   298                                       319
2961562 NM     school 3500124 518   TIERRA ADENTRO 350012401068 1 TIERRA ADENTRO Charter - High School Regular School Yes High 06 12 2021   pk_12_total 17 * 216   * *     *   *                             246 17   216                                       246
2961561 NM     school 3500125 519   THE MASTERS PROGRAM 350012501069 1 THE MASTERS PROGRAM Charter - High School Regular School Yes High 09 12 2021   pk_12_total 85 6 167   * *     *   *                             270 85 6 167                                       270
2961560 NM     school 3500142 536   THE GREAT ACADEMY 350014201077 1 THE GREAT ACADEMY Charter - High School Regular School Yes High 06 12 2021   pk_12_total 32 6 64   8 *     *   *                             115 32 6 64   8                                   115
2961559 NM     school   536   THE GREAT ACADEMY   993 HOSPITALIZED Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961558 NM     school 3500126 520   THE ASK ACADEMY 350012601070 1 THE ASK ACADEMY Charter - High School Regular School Yes High 06 12 2021   pk_12_total 266 13 243   * 13     *   25                             567 266 13 243     13         25                       567
2961557 NM     school 3502580 13   TEXICO 350258000590 163 TEXICO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 67 * 63   * *     *   *                             139 67   63                                       139
2961556 NM     school 3502580 13   TEXICO 350258000589 162 TEXICO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 86 * 74   * *     *   *                             163 86   74                                       163
2961555 NM     school 3502580 13   TEXICO 350258000588 161 TEXICO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 151 * 94   * *     *   *                             250 151   94                                       250
2961554 NM     school 3502550 35   TATUM 350255000587 90 TATUM JR HIGH Public - Junior High Regular School No Middle 07 08 2021   pk_12_total 26 * 32   * *     *   *                             60 26   32                                       60
2961553 NM     school 3502550 35   TATUM 350255000586 163 TATUM HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 62 * 48   * *     *   *                             114 62   48                                       114
2961552 NM     school 3502550 35   TATUM 350255000585 162 TATUM ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 83 * 71   * *     *   *                             155 83   71                                       155
2961551 NM     school 3500163 555   TAOS INTERNATIONAL SCHOOL 350016301094 1 TAOS INTERNATIONAL SCHOOL Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total 13 * 169   6 *     *   *                             190 13   169   6                                   190
2961550 NM     school 3500127 521   TAOS INTEGRATED SCHOOL OF THE ARTS 350012701060 1 TAOS INTEGRATED SCHOOL OF ARTS Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total 87 * 68   17 *     *   *                             177 87   68   17                                   177
2961549 NM     school 3500118 510   TAOS ACADEMY 350011801055 1 TAOS ACADEMY Charter - High School Regular School Yes High 05 12 2021   pk_12_total 92 * 116   * *     *   *                             218 92   116                                       218
2961548 NM     school 3502520 76   TAOS 350252001021 12 VISTA GRANDE HIGH SCHOOL Charter - High School Regular School Yes High 09 12 2021   pk_12_total 13 * 40   21 *     *   *                             76 13   40   21                                   76
2961547 NM     school 3502520 76   TAOS 350252000817 5 TAOS MUNICIPAL CHARTER Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total 85 * 122   * *     *   *                             216 85   122                                       216
2961546 NM     school 3502520 76   TAOS 350252000584 164 TAOS MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 50 * 348   28 *     *   8                             440 50   348   28           8                       440
2961545 NM     school 3502520 76   TAOS 350252000583 165 TAOS HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 156 * 531   65 *     *   13                             774 156   531   65           13                       774
2961544 NM     school 3502520 76   TAOS 350252000951 11 TAOS CYBER MAGNET Public - High School Alternative School No High 09 12 2021   pk_12_total * * 6   7 *     *   *                             18     6   7                                   18
2961543 NM     school 3502520 76   TAOS 350252000580 133 RANCHOS DE TAOS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 26 * 245   6 *     *   *                             279 26   245   6                                   279
2961542 NM     school   76   TAOS   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total 7 * 19   * *     *   *                             27 7   19                                       27
2961541 NM     school   76   TAOS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961540 NM     school 3502520 76   TAOS 350252000579 175 ENOS GARCIA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 56 * 329   23 *     *   12                             425 56   329   23           12                       425
2961539 NM     school 3502520 76   TAOS 350252000914 10 CHRYSALIS ALTERNATIVE Public - High School Alternative School No High 07 12 2021   pk_12_total * * 11   * *     *   *                             13     11                                       13
2961538 NM     school 3502520 76   TAOS 350252000790 4 ARROYO DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total 31 * 79   * *     *   6                             121 31   79               6                       121
2961537 NM     school 3502520 76   TAOS 350252000844 6 ANANSI CHARTER SCHOOL Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total 104 * 67   8 7     *   *                             190 104   67   8 7                                 190
2961536 NM     school 3500151 544   SW AERONAUTICS MATHEMATICS AND SCIENCE 350015101088 1 SW AERONAUTICS MATHEMATICS AND SCIENCE ACADEMY Charter - High School Regular School Yes High 07 12 2021   pk_12_total 165 6 49   * *     *   7                             231 165 6 49               7                       231
2961535 NM     school 3502490 10   SPRINGER 350249000576 58 WILFERTH ELEMENTARY Public - Elementary School Regular School No Elementary 03 06 2021   pk_12_total * * 31   * *     *   *                             43     31                                       43
2961534 NM     school 3502490 10   SPRINGER 350249000575 150 SPRINGER HIGH Public - High School Regular School No High 07 12 2021   pk_12_total * * 44   * *     *   *                             60     44                                       60
2961533 NM     school   10   SPRINGER   3 HIGH PLNS REC HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961532 NM     school 3502490 10   SPRINGER 350249000574 56 FORRESTER ELEMENTARY Public - Elementary School Regular School No Elementary KG 02 2021   pk_12_total * * 28   * *     *   *                             33     28                                       33
2961531 NM     school 3500137 531   SOUTHWEST SECONDARY LEARNING CENTER 350013700819 1 SOUTHWEST SECONDARY LEARNING CENTER Charter - High School Regular School Yes High 09 12 2021   pk_12_total 76 8 63   8 *     *   *                             159 76 8 63   8                                   159
2961530 NM     school 3500136 530   SOUTHWEST PREPARATORY LEARNING CENTER 350013600927 1 SOUTHWEST PREPARATORY LEARNING CENTER Charter - Elementary School Regular School Yes Middle 04 08 2021   pk_12_total 146 * 12   * *     *   *                             173 146   12                                       173
2961529 NM     school 3500121 515   SOUTH VALLEY PREP 350012101076 1 SOUTH VALLEY PREP Charter - Middle School Regular School Yes Middle 06 08 2021   pk_12_total * * 174   * *     *   *                             180     174                                       180
2961528 NM     school 3500183 576   SOLARE COLLEGIATE CHARTER SCHOOL 350018301143 1 SOLARE COLLEGIATE CHARTER SCHOOL Charter - Middle School Regular School Yes Middle 05 07 2021   pk_12_total 15 * 172   * *     *   *                             193 15   172                                       193
2961527 NM     school 3502460 74   SOCORRO 350246000571 160 SOCORRO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 79 14 388   13 6     *   *                             503 79 14 388   13 6                                 503
2961526 NM     school 3502460 74   SOCORRO 350246000569 144 SAN ANTONIO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 29 * 54   * *     *   *                             87 29   54                                       87
2961525 NM     school 3502460 74   SOCORRO 350246000572 155 R. SARRACINO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 56 * 215   12 *     *   *                             292 56   215   12                                   292
2961524 NM     school 3502460 74   SOCORRO 350246000789 1 PARKVIEW ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 64 6 316   22 9     *   *                             419 64 6 316   22 9                                 419
2961523 NM     school   74   SOCORRO   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pk_12_total * * 12   * *     *   *                             15     12                                       15
2961522 NM     school 3502460 74   SOCORRO 350246000568 79 MIDWAY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total * * 51   * *     *   *                             64     51                                       64
2961521 NM     school   74   SOCORRO   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961520 NM     school 3502460 74   SOCORRO 350246000843 3 COTTONWOOD VALLEY CHARTER Charter - Elementary School Regular School Yes Elementary KG 08 2021   pk_12_total 72 * 86   * 7     *   *                             170 72   86     7                                 170
2961519 NM     school 3500177 568   SIX DIRECTIONS INDIGENOUS SCHOOL 350017701126 1 SIX DIRECTIONS INDIGENOUS SCHOOL Charter - High School Regular School Yes Secondary 06 11 2021   pk_12_total * * *   77 *     *   *                             78         77                                   78
2961518 NM     school 3502430 23   SILVER CITY 350243000565 155 SIXTH STREET ELEMENTARY Public - Elementary School Regular School No Elementary KG KG 2021   pk_12_total 31 * 85   * *     *   *                             122 31   85                                       122
2961517 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 10 * 32   * *     *   *                             44 10   32                                       44
2961516 NM     school 3502430 23   SILVER CITY 350243000564 152 SILVER HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 155 * 414   * *     *   16                             594 155   414               16                       594
2961515 NM     school   23   SILVER CITY   0 SILVER CITY DIST OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961514 NM     school   23   SILVER CITY   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total 25 * *   * *     *   *                             30 25                                           30
2961513 NM     school 3502430 23   SILVER CITY 350243000563 145 LA PLATA MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total 81 * 256   6 *     *   7                             354 81   256   6           7                       354
2961512 NM     school 3502430 23   SILVER CITY 350243000562 115 JOSE BARRIOS ELEMENTARY Public - Elementary School Regular School No Elementary 01 06 2021   pk_12_total 82 * 143   * *     *   8                             240 82   143               8                       240
2961511 NM     school   23   SILVER CITY   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961510 NM     school 3502430 23   SILVER CITY 350243000561 157 HARRISON SCHMITT ELEMENTARY Public - Elementary School Regular School No Elementary 01 06 2021   pk_12_total 102 * 268   * *     *   *                             377 102   268                                       377
2961509 NM     school 3502430 23   SILVER CITY 350243000566 123 G.W.STOUT ELEMENTARY Public - Elementary School Regular School No Elementary 01 06 2021   pk_12_total 95 * 244   * *     *   9                             357 95   244               9                       357
2961508 NM     school 3502430 23   SILVER CITY 350243000560 34 CLIFF HIGH Public - High School Regular School No High 07 12 2021   pk_12_total 78 * 21   * *     *   *                             102 78   21                                       102
2961507 NM     school 3502430 23   SILVER CITY 350243000559 37 CLIFF ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 103 * 15   * *     *   *                             124 103   15                                       124
2961506 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   pk_12_total * * 8   * *     *   *                             12     8                                       12

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