enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2555620 2555620 NM     school 3502800 89   ZUNI 350280000678 195 ZUNI MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * *   267 *     *   *                             271         267                                   271
2555619 2555619 NM     school 3502800 89   ZUNI 350280000676 190 ZUNI HIGH Public Regular School No High 09 12 2020   pk_12_total * * *   305 *     *   *                             306         305                                   306
2555618 2555618 NM     school 3502800 89   ZUNI 350280000677 192 TWIN BUTTES CYBER ACADEMY Public Regular School No High 07 12 2020   pk_12_total * * *   * *     *   *                             53                                             53
2555617 2555617 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * *   590 *     *   *                             604         590                                   604
2555616 2555616 NM     school   89   ZUNI   997 MISC PRIVATE Private           2020   pk_12_total * * *   82 *     *   *                             83         82                                   83
2555615 2555615 NM     school   89   ZUNI   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             8                                             8
2555614 2555614 NM     school   89   ZUNI   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             2                                             2
2555613 2555613 NM     school 3501560 68   WEST LAS VEGAS 350156000815 3 WLV FAMILY PARTNERSHIP Public Alternative School No High 07 12 2020   pk_12_total * * 28   * *     *   *                             34     28                                       34
2555612 2555612 NM     school 3501560 68   WEST LAS VEGAS 350156000419 172 WEST LAS VEGAS MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 28 * 277   * *     *   *                             308 28   277                                       308
2555611 2555611 NM     school 3501560 68   WEST LAS VEGAS 350156000418 173 WEST LAS VEGAS HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 54 * 344   * *     *   *                             404 54   344                                       404
2555610 2555610 NM     school   68   WEST LAS VEGAS   1 WEST LAS VEGAS HEAD START Off-Site           2020   pk_12_total * * *   * *     *   *                             10                                             10
2555609 2555609 NM     school 3501560 68   WEST LAS VEGAS 350156000416 68 VALLEY MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 24   * *     *   *                             29     24                                       29
2555608 2555608 NM     school 3501560 68   WEST LAS VEGAS 350156000415 50 VALLEY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 62   * *     *   *                             71     62                                       71
2555607 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
2555606 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
2555605 2555605 NM     school 3501560 68   WEST LAS VEGAS 350156000911 4 RIO GALLINAS SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total * * 62   * *     *   *                             73     62                                       73
2555604 2555604 NM     school 3501560 68   WEST LAS VEGAS 350156000408 12 LUIS E. ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 7 * 223   * *     *   *                             232 7   223                                       232
2555603 2555603 NM     school   68   WEST LAS VEGAS   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555602 2555602 NM     school 3501560 68   WEST LAS VEGAS 350156000411 112 DON CECILIO MARTINEZ ELEMENTARY Public Regular School No Elementary 02 03 2020   pk_12_total * * 165   * *     *   *                             171     165                                       171
2555601 2555601 NM     school   68   WEST LAS VEGAS   25 CARE Off-Site           2020   pk_12_total * * *   * *     *   *                             5                                             5
2555600 2555600 NM     school 3500158 552   WALATOWA CHARTER HIGH 350015800883 1 WALATOWA CHARTER HIGH Charter Regular School Yes High 09 12 2020   pk_12_total * * *   50 *     *   *                             55         50                                   55
2555599 2555599 NM     school 3502730 45   WAGON MOUND 350273000612 173 WAGON MOUND HIGH Public Regular School No High 07 12 2020   pk_12_total * * 21   * *     *   *                             22     21                                       22
2555598 2555598 NM     school 3502730 45   WAGON MOUND 350273000611 172 WAGON MOUND ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total * * 42   * *     *   *                             46     42                                       46
2555597 2555597 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   pk_12_total * * 24   * *     *   *                             27     24                                       27
2555596 2555596 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total * * 28   * *     *   *                             31     28                                       31
2555595 2555595 NM     school 3500171 566   TURQUOISE TRAIL CHARTER SCHOOL 350017130008 1 TURQUOISE TRAIL CHARTER SCHOOL Charter Regular School Yes Elementary PK 08 2020   pk_12_total 151 * 452   12 9     *   7                             638 151   452   12 9         7                       638
2555594 2555594 NM     school 3502670 47   TULAROSA 350267000606 164 TULAROSA MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 39 * 63   46 *     *   *                             149 39   63   46                                   149
2555593 2555593 NM     school 3502670 47   TULAROSA 350267000968 160 TULAROSA INTERMEDIATE Public Regular School No Elementary 03 06 2020   pk_12_total 70 * 115   77 *     *   *                             269 70   115   77                                   269
2555592 2555592 NM     school 3502670 47   TULAROSA 350267000605 165 TULAROSA HIGH Public Regular School No High 09 12 2020   pk_12_total 62 * 101   56 *     *   *                             222 62   101   56                                   222
2555591 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
2555590 2555590 NM     school   47   TULAROSA   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             9                                             9
2555589 2555589 NM     school 3502640 49   TUCUMCARI 350264000600 163 TUCUMCARI MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 68 6 149   * *     *   *                             229 68 6 149                                       229
2555588 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
2555587 2555587 NM     school 3502640 49   TUCUMCARI 350264000602 53 TUCUMCARI ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 156 * 301   * *     *   *                             466 156   301                                       466
2555586 2555586 NM     school   49   TUCUMCARI   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2555585 2555585 NM     school 3502610 73   TRUTH OR CONS. 350261000595 63 T OR C MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 118 * 153   * *     *   8                             282 118   153               8                       282
2555584 2555584 NM     school 3502610 73   TRUTH OR CONS. 350261000594 162 T OR C ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total 182 6 145   * *     *   *                             344 182 6 145                                       344
2555583 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
2555582 2555582 NM     school   73   TRUTH OR CONS.   3 MANZANO CHRISTIAN Private           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555581 2555581 NM     school 3502610 73   TRUTH OR CONS. 350261000593 58 HOT SPRINGS HIGH Public Regular School No High 09 12 2020   pk_12_total 167 * 186   * 6     *   *                             365 167   186     6                                 365
2555580 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
2555579 2555579 NM     school 3500173 565   TIERRA ENCANTADA CHARTER SCHOOL 350017300950 1 TIERRA ENCANTADA CHARTER SCHOOL Charter Regular School Yes High 07 12 2020   pk_12_total 20 * 289   * *     *   *                             311 20   289                                       311
2555578 2555578 NM     school 3500124 518   TIERRA ADENTRO 350012401068 1 TIERRA ADENTRO Charter Regular School Yes High 06 12 2020   pk_12_total 19 * 237   9 *     *   *                             273 19   237   9                                   273
2555577 2555577 NM     school 3500125 519   THE MASTERS PROGRAM 350012501069 1 THE MASTERS PROGRAM Charter Regular School Yes High 09 12 2020   pk_12_total 84 8 155   * 10     *   *                             263 84 8 155     10                                 263
2555576 2555576 NM     school 3500142 536   THE GREAT ACADEMY 350014201077 1 THE GREAT ACADEMY Charter Regular School Yes High 06 12 2020   pk_12_total 25 10 113   13 *     *   *                             168 25 10 113   13                                   168
2555575 2555575 NM     school 3500126 520   THE ASK ACADEMY 350012601070 1 THE ASK ACADEMY Charter Regular School Yes High 06 12 2020   pk_12_total 257 12 246   9 *     *   24                             554 257 12 246   9           24                       554
2555574 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
2555573 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
2555572 2555572 NM     school 3502580 13   TEXICO 350258000588 161 TEXICO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 138 6 121   * *     *   *                             266 138 6 121                                       266
2555571 2555571 NM     school 3502550 35   TATUM 350255000587 90 TATUM JR HIGH Public Regular School No Middle 07 08 2020   pk_12_total 27 * 26   * *     *   *                             54 27   26                                       54
2555570 2555570 NM     school 3502550 35   TATUM 350255000586 163 TATUM HIGH Public Regular School No High 09 12 2020   pk_12_total 66 * 58   * *     *   *                             126 66   58                                       126
2555569 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
2555568 2555568 NM     school 3500163 555   TAOS INTERNATIONAL SCHOOL 350016301094 1 TAOS INTERNATIONAL SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 12 * 140   * *     *   *                             158 12   140                                       158
2555567 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
2555566 2555566 NM     school 3500118 510   TAOS ACADEMY 350011801055 1 TAOS ACADEMY Charter Regular School Yes High 05 12 2020   pk_12_total 102 * 126   6 *     *   *                             241 102   126   6                                   241
2555565 2555565 NM     school 3502520 76   TAOS 350252001021 12 VISTA GRANDE HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 10 * 50   28 *     *   *                             90 10   50   28                                   90
2555564 2555564 NM     school 3502520 76   TAOS 350252000817 5 TAOS MUNICIPAL CHARTER Charter Regular School Yes Elementary KG 08 2020   pk_12_total 76 * 126   * *     *   *                             212 76   126                                       212
2555563 2555563 NM     school 3502520 76   TAOS 350252000584 164 TAOS MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 74 * 357   40 *     *   *                             482 74   357   40                                   482
2555562 2555562 NM     school 3502520 76   TAOS 350252000583 165 TAOS HIGH Public Regular School No High 09 12 2020   pk_12_total 154 * 540   55 *     *   9                             765 154   540   55           9                       765
2555561 2555561 NM     school 3502520 76   TAOS 350252000951 11 TAOS CYBER MAGNET Public Alternative School No High 09 12 2020   pk_12_total * * 6   8 *     *   *                             19     6   8                                   19
2555560 2555560 NM     school 3502520 76   TAOS 350252000580 133 RANCHOS DE TAOS ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 15 * 254   * *     *   *                             276 15   254                                       276
2555559 2555559 NM     school   76   TAOS   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total 15 * 7   * *     *   *                             23 15   7                                       23
2555558 2555558 NM     school   76   TAOS   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555557 2555557 NM     school 3502520 76   TAOS 350252000579 175 ENOS GARCIA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 76 * 357   20 *     *   10                             470 76   357   20           10                       470
2555556 2555556 NM     school 3502520 76   TAOS 350252000914 10 CHRYSALIS ALTERNATIVE Public Alternative School No High 07 12 2020   pk_12_total * * *   * *     *   *                             6                                             6
2555555 2555555 NM     school 3502520 76   TAOS 350252000790 4 ARROYO DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 38 * 68   * *     *   7                             119 38   68               7                       119
2555554 2555554 NM     school 3502520 76   TAOS 350252000844 6 ANANSI CHARTER SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 115 * 66   6 7     *   *                             196 115   66   6 7                                 196
2555553 2555553 NM     school 3500151 544   SW AERONAUTICS MATHEMATICS AND SCIENCE 350015101088 1 SW AERONAUTICS MATHEMATICS AND SCIENCE ACADEMY Charter Regular School Yes High 07 12 2020   pk_12_total 190 6 58   * *     *   *                             267 190 6 58                                       267
2555552 2555552 NM     school 3502490 10   SPRINGER 350249000576 58 WILFERTH ELEMENTARY Public Regular School No Elementary 03 06 2020   pk_12_total * * 34   * *     *   *                             51     34                                       51
2555551 2555551 NM     school 3502490 10   SPRINGER 350249000575 150 SPRINGER HIGH Public Regular School No High 07 12 2020   pk_12_total * * 44   * *     *   *                             53     44                                       53
2555550 2555550 NM     school   10   SPRINGER   3 HIGH PLNS REC HEADSTART Off-Site           2020   pk_12_total * * *   * *     *   *                             4                                             4
2555549 2555549 NM     school 3502490 10   SPRINGER 350249000574 56 FORRESTER ELEMENTARY Public Regular School No Elementary KG 02 2020   pk_12_total * * 24   * *     *   *                             30     24                                       30
2555548 2555548 NM     school 3500137 531   SOUTHWEST SECONDARY LEARNING CENTER 350013700819 1 SOUTHWEST SECONDARY LEARNING CENTER Charter Regular School Yes High 09 12 2020   pk_12_total 73 * 100   7 *     *   *                             190 73   100   7                                   190
2555547 2555547 NM     school 3500136 530   SOUTHWEST PREPARATORY LEARNING CENTER 350013600927 1 SOUTHWEST PREPARATORY LEARNING CENTER Charter Regular School Yes Middle 04 08 2020   pk_12_total 150 * 28   8 *     *   *                             195 150   28   8                                   195
2555546 2555546 NM     school 3500121 515   SOUTH VALLEY PREP 350012101076 1 SOUTH VALLEY PREP Charter Regular School Yes Middle 06 08 2020   pk_12_total * * 163   * *     *   *                             168     163                                       168
2555545 2555545 NM     school 3500183 576   SOLARE COLLEGIATE CHARTER SCHOOL 350018301143 1 SOLARE COLLEGIATE CHARTER SCHOOL Charter Regular School Yes Middle 05 06 2020   pk_12_total 10 * 123   * *     *   *                             137 10   123                                       137
2555544 2555544 NM     school 3502460 74   SOCORRO 350246000571 160 SOCORRO HIGH Public Regular School No High 09 12 2020   pk_12_total 84 16 357   9 *     *   *                             473 84 16 357   9                                   473
2555543 2555543 NM     school 3502460 74   SOCORRO 350246000569 144 SAN ANTONIO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 28 * 51   * *     *   *                             81 28   51                                       81
2555542 2555542 NM     school 3502460 74   SOCORRO 350246000572 155 R. SARRACINO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 52 7 258   11 *     *   *                             335 52 7 258   11                                   335
2555541 2555541 NM     school 3502460 74   SOCORRO 350246000789 1 PARKVIEW ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 81 6 335   23 9     *   *                             457 81 6 335   23 9                                 457
2555540 2555540 NM     school   74   SOCORRO   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * 10   * *     *   *                             14     10                                       14
2555539 2555539 NM     school 3502460 74   SOCORRO 350246000568 79 MIDWAY ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 27 * 68   * *     *   *                             97 27   68                                       97
2555538 2555538 NM     school   74   SOCORRO   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2555537 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
2555536 2555536 NM     school 3500177 568   SIX DIRECTIONS INDIGENOUS SCHOOL 350017701126 1 SIX DIRECTIONS INDIGENOUS SCHOOL Charter Regular School Yes Middle 06 10 2020   pk_12_total * * *   62 *     *   *                             66         62                                   66
2555535 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
2555534 2555534 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public Regular School No Prekindergarten PK PK 2020   pk_12_total 25 * 41   * *     *   *                             68 25   41                                       68
2555533 2555533 NM     school 3502430 23   SILVER CITY 350243000564 152 SILVER HIGH Public Regular School No High 09 12 2020   pk_12_total 161 7 431   6 *     *   13                             619 161 7 431   6           13                       619
2555532 2555532 NM     school   23   SILVER CITY   997 MISC PRIVATE Private           2020   pk_12_total 28 * 7   * *     *   *                             36 28   7                                       36
2555531 2555531 NM     school 3502430 23   SILVER CITY 350243000563 145 LA PLATA MIDDLE Public Regular School No Middle 07 09 2020   pk_12_total 81 * 253   6 *     *   8                             353 81   253   6           8                       353
2555530 2555530 NM     school 3502430 23   SILVER CITY 350243000562 115 JOSE BARRIOS ELEMENTARY Public Regular School No Elementary 01 06 2020   pk_12_total 100 * 141   * *     *   13                             261 100   141               13                       261
2555529 2555529 NM     school   23   SILVER CITY   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             6                                             6
2555528 2555528 NM     school 3502430 23   SILVER CITY 350243000561 157 HARRISON SCHMITT ELEMENTARY Public Regular School No Elementary 01 06 2020   pk_12_total 115 * 308   * *     *   7                             435 115   308               7                       435
2555527 2555527 NM     school 3502430 23   SILVER CITY 350243000566 123 G.W.STOUT ELEMENTARY Public Regular School No Elementary 01 06 2020   pk_12_total 112 6 271   * *     *   15                             409 112 6 271               15                       409
2555526 2555526 NM     school 3502430 23   SILVER CITY 350243000560 34 CLIFF HIGH Public Regular School No High 07 12 2020   pk_12_total 85 * 18   * *     *   *                             105 85   18                                       105
2555525 2555525 NM     school 3502430 23   SILVER CITY 350243000559 37 CLIFF ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 104 * 14   * *     *   *                             125 104   14                                       125
2555524 2555524 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   pk_12_total 7 * 15   * *     *   *                             25 7   15                                       25
2555523 2555523 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter Regular School Yes Other PK 12 2020   pk_12_total 180 * 273   17 *     *   *                             477 180   273   17                                   477
2555522 2555522 NM     school   505   SCHOOL OF DREAMS ACADEMY   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2555521 2555521 NM     school 3502400 25   SANTA ROSA 350240000558 150 SANTA ROSA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 126   * *     *   *                             129     126                                       129

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