enrollments

Data source: Big Local News · About: Big Local

978 rows where grade = "pk_12_total", state = "NM" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 978 ✖

grade ✖

  • pk_12_total · 978 ✖
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
2960842 2960842 NM     school   22   ARTESIA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960872 2960872 NM     school   61   BERNALILLO   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960884 2960884 NM     school   66   BLOOMFIELD   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960890 2960890 NM     school   40   CAPITAN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960957 2960957 NM     school   12   CLOVIS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2960990 2960990 NM     school   42   DEMING   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961141 2961141 NM     school   88   GRANTS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961171 2961171 NM     school   33   HOBBS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961206 2961206 NM     school   99   JUVENILE JUSTICE   0 JUVENILE JUSTICE DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961277 2961277 NM     school   41   LOS ALAMOS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961305 2961305 NM     school   31   LOVINGTON   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961322 2961322 NM     school   547   MCCURDY CHARTER SCHOOL   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961329 2961329 NM     school   78   MESA VISTA   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961359 2961359 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             1                                             1
2961362 2961362 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * *   * *     *   *                             1                                             1
2961511 2961511 NM     school   23   SILVER CITY   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961515 2961515 NM     school   23   SILVER CITY   0 SILVER CITY DIST OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961521 2961521 NM     school   74   SOCORRO   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961533 2961533 NM     school   10   SPRINGER   3 HIGH PLNS REC HEADSTART Off-Site - Prekindergarten           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961541 2961541 NM     school   76   TAOS   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961559 2961559 NM     school   536   THE GREAT ACADEMY   993 HOSPITALIZED Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961567 2961567 NM     school   73   TRUTH OR CONS.   0 T OR C DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961594 2961594 NM     school   68   WEST LAS VEGAS   0 WEST LAS VEGAS DIST OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2961083 2961083 NM     school   19   GADSDEN   998 HOMEBOUND Off-Site - Central Office           2021   pk_12_total * * *   * *     *   *                             10                                             10
2961361 2961361 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pk_12_total * * 6   * *     *   *                             10     6                                       10
2961215 2961215 NM     school 3501500 17   LAS CRUCES 350150000765 2 CAMINO REAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 249 23 687   6 12     10   14                             1001 249 23 687   6 12     10   14                       1001
2961154 2961154 NM     school 3501200 5   HAGERMAN 350120000341 56 HAGERMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 23 * 77   * *     *   *                             101 23   77                                       101
2961193 2961193 NM     school 3501350 34   JAL 350135000363 60 JAL JR HIGH Public - Junior High Regular School No Middle 06 08 2021   pk_12_total 18 * 82   * *     *   *                             101 18   82                                       101
2961048 2961048 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   pk_12_total 35 * 34   27 *     *   *                             102 35   34   27                                   102
2961376 2961376 NM     school 3502040 77   PENASCO 350204000481 123 PENASCO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total * * 83   15 *     *   *                             102     83   15                                   102
2961450 2961450 NM     school 3502250 4   ROSWELL 350225000696 132 UNIVERSITY HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 23 * 76   * *     *   *                             102 23   76                                       102
2961474 2961474 NM     school 3502370 71   SANTA FE 350237001120 166 EARLY COLLEGE OPPORTUNITIES Public - High School Regular School No High 09 12 2021   pk_12_total 16 * 84   * *     *   *                             102 16   84                                       102
2961508 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
2960855 2960855 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 214 13 773   24 *     *   *                             1028 214 13 773   24                                   1028
2960935 2960935 NM     school 3500420 53   CHAMA 350042000195 64 TIERRA AMARILLA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 11 * 84   7 *     *   *                             103 11   84   7                                   103
2961063 2961063 NM     school 3501020 59   FLOYD 350102000294 53 FLOYD ELEMENTARY Public - Elementary School Regular School No Elementary PK 04 2021   pk_12_total 31 * 70   * *     *   *                             104 31   70                                       104
2960856 2960856 NM     school 3500180 87   BELEN 350018000848 1 BELEN INFINITY HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 25 * 75   * *     *   *                             105 25   75                                       105
2960955 2960955 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public - High School Regular School No Other 02 12 2021   pk_12_total 33 * 66   * *     *   *                             105 33   66                                       105
2960686 2960686 NM     school 3500060 1   ALBUQUERQUE 350006000044 514 DEL NORTE HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 125 59 621   166 *     *   57                             1055 125 59 621   166           57                       1055
2961155 2961155 NM     school 3501230 18   HATCH 350123000342 53 GARFIELD ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   pk_12_total * * *   * *     *   *                             106                                             106
2960808 2960808 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 258 26 677   26 *     *   55                             1064 258 26 677   26           55                       1064
2961148 2961148 NM     school   88   GRANTS   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total 11 * 47   46 *     *   *                             107 11   47   46                                   107
2961113 2961113 NM     school 3501110 43   GALLUP 350111000308 77 LINCOLN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 233 23 574   219 *     *   35                             1094 233 23 574   219           35                       1094
2960813 2960813 NM     school 3500060 1   ALBUQUERQUE 350006000116 560 VALLEY HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 93 13 946   34 *     *   8                             1099 93 13 946   34           8                       1099
2961025 2961025 NM     school   55   ESPANOLA   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * 7   * *     *   *                             11     7                                       11
2960630 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 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
2961074 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 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 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 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
2961560 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 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
2960706 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 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 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 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 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
2960873 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 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 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 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
2961233 2961233 NM     school   17   LAS CRUCES   993 HOSPITALIZED Off-Site - Central Office           2021   pk_12_total * * 8   * *     *   *                             12     8                                       12
2961506 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
2961153 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
2961066 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 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 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 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 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 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
2960943 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 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
2961287 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
2960875 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 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 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
2960987 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
2960645 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 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 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
2960986 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 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
2960835 2960835 NM     school   22   ARTESIA   0 ARTESIA DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * 8   * *     *   *                             13     8                                       13
2961539 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
2961198 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 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 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
2960693 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 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 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 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
2960741 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 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 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
2960947 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 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 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 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 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

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