Data source: Big Local News · About: Big Local

995 rows where grade = "pk_12_total", state = "NM" and year = 2020 sorted by ccd_school_type

View and edit SQL

year

  • 2020 · 895

grade

  • pk_12_total · 895
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
2555529 NM     school   23   SILVER CITY   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             6                                             6
2555532 NM     school   23   SILVER CITY   997 MISC PRIVATE Private           2020   pk_12_total 28 * 7   * *     *   *                             36 28   7                                       36
2555538 NM     school   74   SOCORRO   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2555540 NM     school   74   SOCORRO   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * 10   * *     *   *                             14     10                                       14
2555550 NM     school   10   SPRINGER   3 HIGH PLNS REC HEADSTART Off-Site           2020   pk_12_total * * *   * *     *   *                             4                                             4
2555558 NM     school   76   TAOS   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555559 NM     school   76   TAOS   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total 15 * 7   * *     *   *                             23 15   7                                       23
2555582 NM     school   73   TRUTH OR CONS.   3 MANZANO CHRISTIAN Private           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555586 NM     school   49   TUCUMCARI   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             3                                             3
2555590 NM     school   47   TULAROSA   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             9                                             9
2555601 NM     school   68   WEST LAS VEGAS   25 CARE Off-Site           2020   pk_12_total * * *   * *     *   *                             5                                             5
2555603 NM     school   68   WEST LAS VEGAS   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             1                                             1
2555610 NM     school   68   WEST LAS VEGAS   1 WEST LAS VEGAS HEAD START Off-Site           2020   pk_12_total * * *   * *     *   *                             10                                             10
2555614 NM     school   89   ZUNI   998 HOMEBOUND Off-Site           2020   pk_12_total * * *   * *     *   *                             2                                             2
2555615 NM     school   89   ZUNI   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total * * *   * *     *   *                             8                                             8
2555616 NM     school   89   ZUNI   997 MISC PRIVATE Private           2020   pk_12_total * * *   82 *     *   *                             83         82                                   83
2554628 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   pk_12_total 48 * 77   * *     *   7                             141 48   77               7                       141
2554683 NM     school 3500060 1   ALBUQUERQUE 350006001133 952 COYOTE WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   pk_12_total 142 * 65   * *     *   *                             212 142   65                                       212
2554687 NM     school 3500060 1   ALBUQUERQUE 350006000273 900 DESERT WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   pk_12_total 185 * 88   * 7     *   17                             300 185   88     7         17                       300
2554692 NM     school 3500060 1   ALBUQUERQUE 350006000916 593 EARLY COLLEGE ACADEMY Public Alternative School No High 09 12 2020   pk_12_total 61 * 110   * 14     *   7                             198 61   110     14         7                       198
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
2554771 NM     school 3500060 1   ALBUQUERQUE 350006000123 549 NEW FUTURES HIGH SCHOOL Public Alternative School No High 07 12 2020   pk_12_total 6 * 48   17 *     *   *                             77 6   48   17                                   77
2554792 NM     school 3500060 1   ALBUQUERQUE 350006000108 597 SCHOOL ON WHEELS HIGH SCHOOL Public Alternative School No High 09 12 2020   pk_12_total * * 80   * *     *   *                             83     80                                       83
2554815 NM     school 3500060 1   ALBUQUERQUE 350006000856 840 VISION QUEST ALTERNATIVE MIDDLE Public Alternative School No Middle 06 08 2020   pk_12_total * * *   * *     *   *                             7                                             7
2554854 NM     school 3500150 64   AZTEC 350015000801 2 VISTA NUEVA HIGH Public Alternative School No High 09 12 2020   pk_12_total 36 * 27   * *     *   *                             67 36   27                                       67
2554856 NM     school 3500180 87   BELEN 350018000848 1 BELEN INFINITY HIGH Public Alternative School No High 09 12 2020   pk_12_total 20 * 66   * *     *   *                             92 20   66                                       92
2554865 NM     school 3500180 87   BELEN 350018000867 6 THE FAMILY SCHOOL Public Alternative School No Elementary 01 08 2020   pk_12_total 71 * 92   * *     *   *                             174 71   92                                       174
2554883 NM     school 3500240 66   BLOOMFIELD 350024000771 1 CHARLIE Y. BROWN ALT Public Alternative School No High 09 12 2020   pk_12_total 18 * 19   48 *     *   *                             87 18   19   48                                   87
2554912 NM     school 3500390 67   CENTRAL CONS. 350039000772 25 CAREER PREP ALTERNATIVE Public Alternative School No High 09 12 2020   pk_12_total * * *   166 *     *   *                             173         166                                   173
2554938 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pk_12_total 17 * 20   * *     *   *                             41 17   20                                       41
2555069 NM     school 3500990 65   FARMINGTON 350099000740 148 ROCINANTE HIGH Public Alternative School No High 06 12 2020   pk_12_total 80 * 79   89 *     *   14                             263 80   79   89           14                       263
2555117 NM     school 3501110 43   GALLUP 350111000545 16 GALLUP CENTRAL ALTERNATIVE Public Alternative School No High 06 12 2020   pk_12_total * * 22   167 *     *   *                             193     22   167                                   193
2555215 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   pk_12_total 6 * 19   * *     *   *                             27 6   19                                       27
2555216 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   pk_12_total * * 20   * *     *   *                             30     20                                       30
2555217 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   pk_12_total 6 * 25   * *     *   *                             36 6   25                                       36
2555255 NM     school 3501500 17   LAS CRUCES 350150001078 17 MESILLA VALLEY LEADERSHIP ACADEMY Public Alternative School No Middle 06 08 2020   pk_12_total 32 * 52   * *     *   *                             93 32   52                                       93
2555260 NM     school 3501500 17   LAS CRUCES 350150000932 12 RIO GRANDE PREPARATORY INSTITUTE Public Alternative School No High 09 12 2020   pk_12_total 24 7 145   * *     *   *                             181 24 7 145                                       181
2555300 NM     school 3501680 86   LOS LUNAS 350168000807 9 CENTURY ALT HIGH Public Alternative School No High 09 12 2020   pk_12_total 30 * 128   8 *     *   *                             171 30   128   8                                   171
2555305 NM     school 3501680 86   LOS LUNAS 350168000866 18 LOS LUNAS FAMILY SCHOOL Public Alternative School No Elementary 01 08 2020   pk_12_total * * *   * *     *   *                             3                                             3
2555327 NM     school 3501740 31   LOVINGTON 350174000796 4 NEW HOPE ALTERNATIVE HIGH Public Alternative School No High 09 12 2020   pk_12_total 31 * 73   * *     *   *                             106 31   73                                       106
2555373 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             1                                             1
2555374 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             9                                             9
2555375 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             4                                             4
2555376 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             5                                             5
2555377 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   pk_12_total * * *   * *     *   *                             3                                             3
2555378 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             2                                             2
2555379 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             1                                             1
2555380 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             6                                             6
2555381 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             1                                             1
2555382 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pk_12_total * * *   * *     *   *                             1                                             1
2555428 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   pk_12_total 32 * 126   19 *     *   9                             187 32   126   19           9                       187
2555435 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   pk_12_total 81 * 59   * *     *   *                             147 81   59                                       147
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
2555480 NM     school 3502370 71   SANTA FE 350237000788 12 ACADEMY AT LARRAGOITE Public Alternative School No High 09 12 2020   pk_12_total * * 34   * *     *   *                             39     34                                       39
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
2555556 NM     school 3502520 76   TAOS 350252000914 10 CHRYSALIS ALTERNATIVE Public Alternative School No High 07 12 2020   pk_12_total * * *   * *     *   *                             6                                             6
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
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
2554626 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   pk_12_total 341 32 256   23 35     *   *                             689 341 32 256   23 35                                 689
2554627 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   pk_12_total 21 * 74   * *     *   *                             103 21   74                                       103
2554629 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   pk_12_total 655 90 545   17 33     8   63                             1411 655 90 545   17 33     8   63                       1411
2554630 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 106 10 113   * *     *   8                             242 106 10 113               8                       242
2554631 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 294 24 270   11 *     *   28                             633 294 24 270   11           28                       633
2554632 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 169 34 246   * 12     *   35                             501 169 34 246     12         35                       501
2554633 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 16 * *   * *     *   *                             26 16                                           26
2554634 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 269 52 89   * *     12   51                             480 269 52 89           12   51                       480
2554635 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 94 21 35   * 11     *   29                             194 94 21 35     11         29                       194
2554637 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 130 * 103   * *     *   *                             247 130   103                                       247
2554639 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 197 39 256   * 13     *   22                             544 197 39 256     13         22                       544
2554640 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 172 15 160   8 *     *   16                             378 172 15 160   8           16                       378
2554641 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 167 12 134   * 9     *   18                             342 167 12 134     9         18                       342
2554642 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 148 19 204   7 *     *   23                             409 148 19 204   7           23                       409
2554643 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 131 40 148   * *     *   24                             353 131 40 148               24                       353
2554644 NM     school 3500060 1   ALBUQUERQUE 350006000017 321 A. MONTOYA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 247 * 219   7 *     *   17                             496 247   219   7           17                       496
2554645 NM     school 3500060 1   ALBUQUERQUE 350006000893 90 ABQ CHARTER ACADEMY Charter Regular School Yes High 09 12 2020   pk_12_total 26 13 282   20 *     *   *                             350 26 13 282   20                                   350
2554646 NM     school 3500060 1   ALBUQUERQUE 350006001074 749 ACE LEADERSHIP HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 16 * 229   * *     *   *                             256 16   229                                       256
2554647 NM     school 3500060 1   ALBUQUERQUE 350006000020 206 ADOBE ACRES ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 14 * 406   * *     *   *                             422 14   406                                       422
2554648 NM     school 3500060 1   ALBUQUERQUE 350006000021 207 ALAMEDA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 25 * 220   6 *     *   *                             254 25   220   6                                   254
2554649 NM     school 3500060 1   ALBUQUERQUE 350006000022 210 ALAMOSA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 17 11 406   9 *     *   8                             452 17 11 406   9           8                       452
2554650 NM     school 3500060 1   ALBUQUERQUE 350006000024 590 ALBUQUERQUE HIGH Public Regular School No High 09 12 2020   pk_12_total 224 54 1394   44 *     *   50                             1786 224 54 1394   44           50                       1786
2554651 NM     school 3500060 1   ALBUQUERQUE 350006000924 116 ALICE KING COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 222 17 217   * *     *   *                             480 222 17 217                                       480
2554652 NM     school 3500060 1   ALBUQUERQUE 350006000025 213 ALVARADO ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 48 6 240   13 *     *   7                             316 48 6 240   13           7                       316
2554653 NM     school 3500060 1   ALBUQUERQUE 350006000026 214 APACHE ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 61 27 180   36 *     *   20                             325 61 27 180   36           20                       325
2554654 NM     school 3500060 1   ALBUQUERQUE 350006000027 215 ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 12 * 271   * *     *   *                             288 12   271                                       288
2554655 NM     school 3500060 1   ALBUQUERQUE 350006000028 329 ARROYO DEL OSO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 72 * 206   34 19     *   24                             367 72   206   34 19         24                       367
2554656 NM     school 3500060 1   ALBUQUERQUE 350006000029 216 ATRISCO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 12 * 270   * *     *   *                             283 12   270                                       283
2554657 NM     school 3500060 1   ALBUQUERQUE 350006001037 576 ATRISCO HERITAGE ACADEMY HS Public Regular School No High 09 12 2020   pk_12_total 102 28 2089   41 7     10   35                             2312 102 28 2089   41 7     10   35                       2312
2554658 NM     school 3500060 1   ALBUQUERQUE 350006000030 222 BANDELIER ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 231 * 220   20 16     *   27                             525 231   220   20 16         27                       525
2554659 NM     school 3500060 1   ALBUQUERQUE 350006000031 225 BARCELONA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 23 * 337   13 *     *   *                             377 23   337   13                                   377
2554660 NM     school 3500060 1   ALBUQUERQUE 350006000032 228 BEL-AIR ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 55 8 192   26 *     *   9                             294 55 8 192   26           9                       294
2554661 NM     school 3500060 1   ALBUQUERQUE 350006000033 229 BELLEHAVEN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 70 12 189   26 *     *   16                             319 70 12 189   26           16                       319
2554664 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 48 16 527   12 *     *   8                             612 48 16 527   12           8                       612
2554665 NM     school 3500060 1   ALBUQUERQUE 350006000642 295 CHAMIZA ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 122 7 220   11 *     *   11                             376 122 7 220   11           11                       376
2554666 NM     school 3500060 1   ALBUQUERQUE 350006000036 234 CHAPARRAL ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 131 14 509   42 *     *   32                             741 131 14 509   42           32                       741
2554667 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 117 14 277   69 *     *   33                             519 117 14 277   69           33                       519
2554669 NM     school 3500060 1   ALBUQUERQUE 350006000925 118 CHRISTINE DUNCAN HERITAGE ACADEMY Charter Regular School Yes Elementary PK 08 2020   pk_12_total 14 * 408   6 *     *   *                             433 14   408   6                                   433
2554670 NM     school 3500060 1   ALBUQUERQUE 350006000038 580 CIBOLA HIGH Public Regular School No High 09 12 2020   pk_12_total 519 55 1104   112 *     *   64                             1896 519 55 1104   112           64                       1896
2554671 NM     school 3500060 1   ALBUQUERQUE 350006001050 780 CIEN AGUAS INTERNATIONAL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 106 * 303   * 10     *   *                             426 106   303     10                                 426
2554672 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 114 23 387   62 *     *   35                             634 114 23 387   62           35                       634
2554673 NM     school 3500060 1   ALBUQUERQUE 350006000040 237 COCHITI ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 41 * 223   13 *     *   *                             284 41   223   13                                   284

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