Data source: Big Local News · About: Big Local

1,973 rows where grade = "pk_12_total" and state = "NM" sorted by total

View and edit SQL

year

grade

  • pk_12_total · 1,873
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
2961025 NM     school   55   ESPANOLA   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * 7   * *     *   *                             11     7                                       11
2555167 NM     school 3501230 18   HATCH 350123000342 53 GARFIELD ELEMENTARY Public Regular School No Elementary PK 02 2020   pk_12_total * * 110   * *     *   *                             111     110                                       111
2960630 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter - High School Regular School Yes Other KG 12 2021   pk_12_total 30 * 71   * *     *   *                             111 30   71                                       111
2960889 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 76 * 29   * *     *   *                             111 76   29                                       111
2554985 NM     school 3500660 62   CUBA 350066000235 75 CUBA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 37   68 *     *   *                             112     37   68                                   112
2555277 NM     school 3501590 51   LOGAN 350159000420 80 LOGAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 82 * 27   * *     *   *                             112 82   27                                       112
2555372 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter Regular School Yes Other 04 12 2020   pk_12_total 382 26 610   57 *     *   38                             1127 382 26 610   57           38                       1127
2555210 NM     school 3501410 63   JEMEZ VALLEY 350141000372 145 JEMEZ VALLEY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 46   52 *     *   *                             113     46   52                                   113
2961074 NM     school 3501080 19   GADSDEN 350108000935 3 CHAPARRAL HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 31 9 1090   * *     *   *                             1134 31 9 1090                                       1134
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
2961435 NM     school 3502250 4   ROSWELL 350225000513 130 GODDARD HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 400 23 698   * 19     *   *                             1145 400 23 698     19                                 1145
2960721 NM     school 3500060 1   ALBUQUERQUE 350006000063 520 HIGHLAND HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 102 87 802   93 *     *   44                             1147 102 87 802   93           44                       1147
2555450 NM     school 3502250 4   ROSWELL 350225000513 130 GODDARD HIGH Public Regular School No High 09 12 2020   pk_12_total 434 24 669   * 16     *   *                             1149 434 24 669     16                                 1149
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
2961424 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 304 30 705   49 *     *   56                             1159 304 30 705   49           56                       1159
2555012 NM     school 3500810 54   DULCE 350081000716 50 DULCE MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * *   110 *     *   *                             116         110                                   116
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
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
2960706 NM     school 3500060 1   ALBUQUERQUE 350006000055 596 FREEDOM HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 23 * 71   15 *     *   *                             117 23   71   15                                   117
2961503 NM     school 3502400 25   SANTA ROSA 350240000558 150 SANTA ROSA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 112   * *     *   *                             117     112                                       117
2961334 NM     school 3500148 542   MISSION ACHIEVEMENT AND SUCCESS 350014801089 1 MISSION ACHIEVEMENT AND SUCCESS 1.0 Charter - High School Regular School Yes Other PK 12 2021   pk_12_total 88 48 993   27 14     *   *                             1175 88 48 993   27 14                                 1175
2960805 NM     school 3500060 1   ALBUQUERQUE 350006001026 16 THE ALB TALENT DEVELOPMENT CHARTER Charter - High School Regular School Yes High 09 12 2021   pk_12_total 6 * 105   * *     *   *                             118 6   105                                       118
2960708 NM     school 3500060 1   ALBUQUERQUE 350006001114 496 GEORGE I SANCHEZ Public - Elementary School Regular School No Elementary PK 08 2021   pk_12_total 83 16 1046   20 *     *   12                             1182 83 16 1046   20           12                       1182
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
2960873 NM     school   61   BERNALILLO   29 LA ESCUELITA EARLY CHILDHOOD Off-Site - Prekindergarten           2021   pk_12_total 21 * 87   8 *     *   *                             119 21   87   8                                   119
2960973 NM     school 3500600 24   COBRE CONS. 350060000228 59 HURLEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 16 * 99   * *     *   *                             119 16   99                                       119
2961001 NM     school 3500790 60   DORA 350079000250 44 DORA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 76 * 36   * *     *   *                             119 76   36                                       119
2961115 NM     school   43   GALLUP   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total 10 * 17   85 *     *   *                             119 10   17   85                                   119
2554892 NM     school   20   CARLSBAD   4 CARLSBAD HEADSTART Off-Site           2020   pk_12_total * * 10   * *     *   *                             12     10                                       12
2555235 NM     school   17   LAS CRUCES   38 DONA ANA JDC Off-Site           2020   pk_12_total * * 9   * *     *   *                             12     9                                       12
2961233 NM     school   17   LAS CRUCES   993 HOSPITALIZED Off-Site - Central Office           2021   pk_12_total * * 8   * *     *   *                             12     8                                       12
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
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
2555347 NM     school 3500186 578   MIDDLE COLLEGE HIGH SCHOOL CHARTER - GALLUP 350018600860 1 MIDDLE COLLEGE HIGH SCHOOL CHARTER - GALLUP Charter Regular School Yes High 09 12 2020   pk_12_total 20 * 17   73 9     *   *                             120 20   17   73 9                                 120
2961153 NM     school 3501200 5   HAGERMAN 350120000340 55 HAGERMAN HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 91   * *     *   *                             120     91                                       120
2555127 NM     school 3501110 43   GALLUP 350111000768 73 MIYAMURA HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 81 * 314   771 26     *   12                             1207 81   314   771 26         12                       1207
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
2961066 NM     school 3501050 16   FT SUMNER 350105000296 51 FORT SUMNER ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 46 * 67   * *     *   *                             121 46   67                                       121
2961271 NM     school 3501620 29   LORDSBURG 350162000424 82 LORDSBURG HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 19 * 101   * *     *   *                             121 19   101                                       121
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
2960980 NM     school 3500660 62   CUBA 350066000235 75 CUBA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 28   87 *     *   *                             122     28   87                                   122
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
2961116 NM     school 3501110 43   GALLUP 350111000768 73 MIYAMURA HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pk_12_total 82 * 309   789 27     *   10                             1222 82   309   789 27         10                       1222
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
2555356 NM     school 3501860 44   MORA 350186000638 105 MORA HIGH Public Regular School No High 09 12 2020   pk_12_total * * 111   * *     *   *                             124     111                                       124
2960943 NM     school 3500510 84   CLAYTON 350051000203 39 CLAYTON HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 47 * 68   * *     *   *                             124 47   68                                       124
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
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
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
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
2961287 NM     school 3501680 86   LOS LUNAS 350168000807 9 CENTURY ALT HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 19 * 94   9 *     *   *                             125 19   94   9                                   125
2555129 NM     school 3501110 43   GALLUP 350111000861 100 NAVAJO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total * * *   121 *     *   *                             126         121                                   126
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
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
2960875 NM     school 3500210 61   BERNALILLO 350021000151 127 PLACITAS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 49 * 66   * *     *   *                             126 49   66                                       126
2961005 NM     school 3500810 54   DULCE 350081000716 50 DULCE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 7   117 *     *   *                             126     7   117                                   126
2961071 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total * * 125   * *     *   *                             126     125                                       126
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
2960987 NM     school 3500690 42   DEMING 350069000239 44 DEMING HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 137 18 1094   * 15     *   6                             1274 137 18 1094     15         6                       1274
2555102 NM     school 3501080 19   GADSDEN 350108000323 200 SANTA TERESA HIGH Public Regular School No High 09 12 2020   pk_12_total 35 * 1236   * *     *   *                             1278 35   1236                                       1278
2960645 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 72 6 44   * *     *   *                             128 72 6 44                                       128
2961374 NM     school 3502010 70   PECOS 350201000706 150 PECOS MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 9 * 118   * *     *   *                             128 9   118                                       128
2961358 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter - High School Regular School Yes Other 04 12 2021   pk_12_total 419 35 703   55 *     *   57                             1289 419 35 703   55           57                       1289
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
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
2960986 NM     school 3500690 42   DEMING 350069000963 6 DEMING CESAR CHAVEZ Charter - High School Regular School Yes High 09 12 2021   pk_12_total 12 * 111   * *     *   *                             129 12   111                                       129
2961342 NM     school 3501860 44   MORA 350186000638 105 MORA HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 121   * *     *   *                             129     121                                       129
2554874 NM     school   61   BERNALILLO   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   11 *     *   *                             13         11                                   13
2960835 NM     school   22   ARTESIA   0 ARTESIA DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * 8   * *     *   *                             13     8                                       13
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
2555089 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public Regular School No Prekindergarten PK PK 2020   pk_12_total * * 126   * *     *   *                             130     126                                       130
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
2961198 NM     school 3501410 63   JEMEZ VALLEY 350141000372 145 JEMEZ VALLEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 15 * 49   65 *     *   *                             130 15   49   65                                   130
2961316 NM     school 3501770 75   MAGDALENA 350177000453 133 MAGDALENA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 21 * 57   51 *     *   *                             130 21   57   51                                   130
2961092 NM     school 3501080 19   GADSDEN 350108000323 200 SANTA TERESA HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 36 * 1259   * *     *   *                             1304 36   1259                                       1304
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
2555283 NM     school 3501620 29   LORDSBURG 350162000424 82 LORDSBURG HIGH Public Regular School No High 09 12 2020   pk_12_total 22 * 107   * *     *   *                             131 22   107                                       131
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
2960693 NM     school 3500060 1   ALBUQUERQUE 350006000047 249 DURANES ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 7 8 106   * *     *   *                             131 7 8 106                                       131
2960826 NM     school 3500181 574   ALBUQUERQUE COLLEGIATE CHARTER SCHOOL 350018101134 1 ALBUQUERQUE COLLEGIATE CHARTER SCHOOL Charter - Elementary School Regular School Yes Elementary KG 03 2021   pk_12_total 9 * 111   * *     *   *                             131 9   111                                       131
2960989 NM     school 3500690 42   DEMING 350069001144 10 EARLY COLLEGE HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pk_12_total 28 * 96   * *     *   *                             131 28   96                                       131
2961161 NM     school 3501260 33   HOBBS 350126000357 172 BOOKER T. WASHINGTON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 7 20 101   * *     *   *                             131 7 20 101                                       131
2554994 NM     school 3500690 42   DEMING 350069000239 44 DEMING HIGH Public Regular School No High 09 12 2020   pk_12_total 153 15 1137   * *     *   *                             1318 153 15 1137                                       1318
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
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
2960741 NM     school 3500060 1   ALBUQUERQUE 350006000074 282 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total * * 120   6 *     *   *                             132     120   6                                   132
2960912 NM     school 3500390 67   CENTRAL CONS. 350039000772 25 CAREER PREP ALTERNATIVE Public - High School Alternative School No High 09 12 2021   pk_12_total * * *   123 *     *   *                             132         123                                   132
2960747 NM     school 3500060 1   ALBUQUERQUE 350006000852 17 LOS PUENTES CHARTER Charter - High School Regular School Yes High 07 12 2021   pk_12_total 10 8 104   10 *     *   *                             133 10 8 104   10                                   133
2555008 NM     school 3500790 60   DORA 350079000250 44 DORA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 92 * 33   * *     *   *                             134 92   33                                       134
2960947 NM     school 3500540 48   CLOUDCROFT 350054000207 39 CLOUDCROFT HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 113 * 15   * *     *   *                             134 113   15                                       134
2960829 NM     school 3500116 511   ALMA D'ARTE CHARTER 350011600900 1 ALMA D'ARTE CHARTER Charter - High School Regular School Yes High 09 12 2021   pk_12_total 34 7 93   * *     *   *                             135 34 7 93                                       135
2961033 NM     school 3500930 80   ESTANCIA 350093000278 169 LOWER ELEMENTARY Public - Elementary School Regular School No Elementary 01 03 2021   pk_12_total 32 * 100   * *     *   *                             135 32   100                                       135
2961487 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 18 * 115   * *     *   *                             136 18   115                                       136
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
2554794 NM     school 3500060 1   ALBUQUERQUE 350006001117 750 SIEMBRA LEADERSHIP HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 10 9 108   7 *     *   *                             137 10 9 108   7                                   137
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
2555130 NM     school 3501110 43   GALLUP 350111000310 75 NAVAJO PINE HIGH Public Regular School No High 09 12 2020   pk_12_total * * *   135 *     *   *                             137         135                                   137
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
2961034 NM     school 3500930 80   ESTANCIA 350093000791 1 UPPER ELEMENTARY Public - Elementary School Regular School No Middle 04 06 2021   pk_12_total 34 * 98   * *     *   *                             137 34   98                                       137
2961118 NM     school 3501110 43   GALLUP 350111000861 100 NAVAJO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * *   133 *     *   *                             137         133                                   137

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