enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "pk_12_total" and state = "AK" sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 995 ✖
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
1738130 1738130 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   pk_12_total 1.0                                                 131 1                                           131
1738146 1738146 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pk_12_total                                                   119                                             119
1738162 1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
1820449 1820449 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   pk_12_total 4.0                                                 148.0 4                                           148
1820465 1820465 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12 2021   pk_12_total   2.0                 2.0                             144.0   2                 2                       144
1820481 1820481 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   pk_12_total                     2.0                             214.0                     2                       214
1737954 1737954 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 32 1                                           32
1737970 1737970 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 18 2                                           18
1737986 1737986 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   pk_12_total 2.0     3.0             2.0                             83 2     3             2                       83
1738002 1738002 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   pk_12_total                                                   24                                             24
1738018 1738018 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8.0 2020   pk_12_total                                                   15                                             15
1738034 1738034 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12.0 2020   pk_12_total 5.0                                                 48 5                                           48
1738050 1738050 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12.0 2020   pk_12_total 1.0     1.0   1.0                                       47 1     1   1                                 47
1738066 1738066 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   pk_12_total 2.0     2.0                                           25 2     2                                     25
1738082 1738082 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   pk_12_total                                                   15                                             15
1738098 1738098 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   pk_12_total 1141.0 36.0 71.0 41.0   23.0     25.0   127.0                             1695 1141 36 71 41   23     25   127                       1695
1820273 1820273 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       23.0           1                                 23
1820289 1820289 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12 2021   pk_12_total 2.0                                                 20.0 2                                           20
1820305 1820305 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12 2021   pk_12_total 2.0     2.0                                           91.0 2     2                                     91
1820321 1820321 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12 2021   pk_12_total                                                   26.0                                             26
1820337 1820337 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8 2021   pk_12_total                                                   14.0                                             14
1820353 1820353 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12 2021   pk_12_total 3.0     1.0             1.0                             48.0 3     1             1                       48
1820369 1820369 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       42.0           1                                 42
1820385 1820385 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12 2021   pk_12_total 2.0     2.0                                           33.0 2     2                                     33
1820401 1820401 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12 2021   pk_12_total                                                   16.0                                             16
1820417 1820417 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12 2021   pk_12_total 2500.0 108.0 205.0 67.0   68.0     79.0   450.0                             4035.0 2500 108 205 67   68     79   450                       4035
1737858 1737858 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12.0 2020   pk_12_total                                                   34                                             34
1737874 1737874 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12.0 2020   pk_12_total   1.0                                               11   1                                         11
1737890 1737890 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 15 1                                           15
1737906 1737906 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 50 2                                           50
1737922 1737922 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12.0 2020   pk_12_total 3.0                                                 92 3                                           92
1737938 1737938 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12.0 2020   pk_12_total                                                   10                                             10
1820177 1820177 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   pk_12_total                                                   36.0                                             36
1820193 1820193 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12 2021   pk_12_total   1.0                                               10.0   1                                         10
1820209 1820209 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 18.0 1                                           18
1820225 1820225 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12 2021   pk_12_total                                                   48.0                                             48
1820241 1820241 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 88.0 1                                           88
1820257 1820257 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12 2021   pk_12_total                                                   8.0                                             8
1737826 1737826 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12.0 2020   pk_12_total 21.0   3.0     2.0                                       81 21   3     2                                 81
1737842 1737842 AK     school 200840 50   Yakutat City Schools 20084000749 508010 LEAD Correspondence   Regular School No Other KG 12.0 2020   pk_12_total 18.0 1.0                                               22 18 1                                         22
1820145 1820145 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12 2021   pk_12_total 6.0   4.0     2.0         3.0                             68.0 6   4     2         3                       68
1820161 1820161 AK     school 200840 50   Yakutat City Schools 20084000749 508010 LEAD Correspondence   Regular School No Other KG 12 2021   pk_12_total 18.0                   2.0                             25.0 18                   2                       25
1737778 1737778 AK     school 200810 49   Wrangell City Schools 20081000373 490010 Evergreen Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 67.0 1.0 1.0 8.0   2.0         4.0                             159 67 1 1 8   2         4                       159
1737794 1737794 AK     school 200810 49   Wrangell City Schools 20081000576 490020 Wrangell High School   Regular School No High 09 12.0 2020   pk_12_total 33.0 1.0 1.0 4.0   5.0         4.0                             84 33 1 1 4   5         4                       84
1737810 1737810 AK     school 200810 49   Wrangell City Schools 20081000728 490030 Stikine Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 28.0   2.0 3.0   1.0         9.0                             67 28   2 3   1         9                       67
1820097 1820097 AK     school 200810 49   Wrangell City Schools 20081000373 490010 Evergreen Elementary   Regular School No Elementary PK 5 2021   pk_12_total 34.0   1.0 1.0   1.0         8.0                             74.0 34   1 1   1         8                       74
1820113 1820113 AK     school 200810 49   Wrangell City Schools 20081000576 490020 Wrangell High School   Regular School No High 09 12 2021   pk_12_total 22.0   2.0 7.0   2.0                                       57.0 22   2 7   2                                 57
1820129 1820129 AK     school 200810 49   Wrangell City Schools 20081000728 490030 Stikine Middle School   Regular School No Middle 06 8 2021   pk_12_total 26.0     2.0   1.0         5.0                             52.0 26     2   1         5                       52
1737714 1737714 AK     school 200780 48   Valdez City Schools 20078000370 480030 Valdez High School   Regular School No High 09 12.0 2020   pk_12_total 118.0 2.0 6.0 3.0   10.0     2.0   25.0                             183 118 2 6 3   10     2   25                       183
1737730 1737730 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 98.0 1.0 6.0 3.0   6.0     2.0   26.0                             151 98 1 6 3   6     2   26                       151
1737746 1737746 AK     school 200780 48   Valdez City Schools 20078000495 480050 Hermon Hutchens Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 243.0 4.0 14.0 4.0   1.0     2.0   77.0                             365 243 4 14 4   1     2   77                       365
1737762 1737762 AK     school 200780 48   Valdez City Schools 20078000753 488010 Valdez Home School   Regular School No Other PK 12.0 2020   pk_12_total 26.0   1.0               2.0                             29 26   1               2                       29
1820033 1820033 AK     school 200780 48   Valdez City Schools 20078000370 480030 Valdez High School   Regular School No High 09 12 2021   pk_12_total 99.0 2.0 6.0 1.0   7.0     3.0   22.0                             156.0 99 2 6 1   7     3   22                       156
1820049 1820049 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8 2021   pk_12_total 93.0 1.0 7.0 1.0   2.0     2.0   28.0                             143.0 93 1 7 1   2     2   28                       143
1820065 1820065 AK     school 200780 48   Valdez City Schools 20078000495 480050 Hermon Hutchens Elementary   Regular School No Elementary PK 5 2021   pk_12_total 188.0 3.0 10.0 4.0   1.0     2.0   55.0                             285.0 188 3 10 4   1     2   55                       285
1820081 1820081 AK     school 200780 48   Valdez City Schools 20078000753 488010 Valdez Home School   Regular School No Other PK 12 2021   pk_12_total 86.0   1.0     3.0         20.0                             114.0 86   1     3         20                       114
1737682 1737682 AK     school 200720 47   Unalaska City Schools 20072000340 470010 Eagle's View Elementary School   Regular School No Elementary PK 6.0 2020   pk_12_total 61.0 6.0 28.0 3.0   99.0     19.0                                 238 61 6 28 3   99     19                           238
1737698 1737698 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12.0 2020   pk_12_total 30.0   20.0     92.0     9.0                                 174 30   20     92     9                           174
1820001 1820001 AK     school 200720 47   Unalaska City Schools 20072000340 470010 Eagle's View Elementary School   Regular School No Elementary PK 6 2021   pk_12_total 62.0 5.0 26.0 1.0   89.0     16.0   2.0                             226.0 62 5 26 1   89     16   2                       226
1820017 1820017 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12 2021   pk_12_total 31.0   19.0 2.0   87.0     7.0                                 161.0 31   19 2   87     7                           161
1738114 1738114 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   pk_12_total 1.0                   4.0                             33 1                   4                       33
1820433 1820433 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12 2021   pk_12_total 1.0                   2.0                             30.0 1                   2                       30
1737538 1737538 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12.0 2020   pk_12_total     1.0               6.0                             37     1               6                       37
1737554 1737554 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12.0 2020   pk_12_total                                                   13                                             13
1737570 1737570 AK     school 200710 45   Southwest Region Schools 20071000465 450040 William "Sonny" Nelson School   Regular School No Other PK 12.0 2020   pk_12_total     1.0               2.0                             15     1               2                       15
1737586 1737586 AK     school 200710 45   Southwest Region Schools 20071000333 450050 Koliganek School   Regular School No Other PK 12.0 2020   pk_12_total                     2.0                             49                     2                       49
1737602 1737602 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12.0 2020   pk_12_total 1.0         1.0         2.0                             120 1         1         2                       120
1737618 1737618 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12.0 2020   pk_12_total                     6.0                             148                     6                       148
1737634 1737634 AK     school 200710 45   Southwest Region Schools 20071000338 450110 Togiak School   Regular School No Other PK 12.0 2020   pk_12_total 2.0   1.0               10.0                             222 2   1               10                       222
1737650 1737650 AK     school 200710 45   Southwest Region Schools 20071000573 450120 Twin Hills School   Regular School No Other PK 12.0 2020   pk_12_total                     9.0                             32                     9                       32
1819857 1819857 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12 2021   pk_12_total 1.0                   7.0                             32.0 1                   7                       32
1819873 1819873 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12 2021   pk_12_total                                                   15.0                                             15
1819889 1819889 AK     school 200710 45   Southwest Region Schools 20071000465 450040 William "Sonny" Nelson School   Regular School No Other PK 12 2021   pk_12_total     1.0               2.0                             13.0     1               2                       13
1819905 1819905 AK     school 200710 45   Southwest Region Schools 20071000333 450050 Koliganek School   Regular School No Other PK 12 2021   pk_12_total                     2.0                             60.0                     2                       60
1819921 1819921 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12 2021   pk_12_total 1.0         1.0         3.0                             124.0 1         1         3                       124
1819937 1819937 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12 2021   pk_12_total                     7.0                             153.0                     7                       153
1819953 1819953 AK     school 200710 45   Southwest Region Schools 20071000338 450110 Togiak School   Regular School No Other PK 12 2021   pk_12_total 1.0                   7.0                             227.0 1                   7                       227
1819969 1819969 AK     school 200710 45   Southwest Region Schools 20071000573 450120 Twin Hills School   Regular School No Other PK 12 2021   pk_12_total                     7.0                             28.0                     7                       28
1737410 1737410 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12.0 2020   pk_12_total 13.0         2.0                                       17 13         2                                 17
1737426 1737426 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12.0 2020   pk_12_total 11.0                   1.0                             13 11                   1                       13
1737442 1737442 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12.0 2020   pk_12_total 42.0 1.0 4.0     1.0         10.0                             61 42 1 4     1         10                       61
1737458 1737458 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12.0 2020   pk_12_total 16.0   2.0                                             18 16   2                                       18
1737474 1737474 AK     school 200700 44   Southeast Island Schools 20070000322 440230 Port Alexander School   Regular School No Other PK 12.0 2020   pk_12_total 14.0                                                 14 14                                           14
1737490 1737490 AK     school 200700 44   Southeast Island Schools 20070000484 440250 Hollis School   Regular School No Other PK 12.0 2020   pk_12_total 8.0   8.0               3.0                             22 8   8               3                       22
1737506 1737506 AK     school 200700 44   Southeast Island Schools 20070000589 440270 Naukati School   Regular School No Other PK 12.0 2020   pk_12_total 13.0                   2.0                             18 13                   2                       18
1737522 1737522 AK     school 200700 44   Southeast Island Schools 20070000428 440340 Hyder School   Regular School No Other PK 12.0 2020   pk_12_total 13.0                                                 13 13                                           13
1819745 1819745 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12 2021   pk_12_total 10.0         2.0                                       13.0 10         2                                 13
1819761 1819761 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12 2021   pk_12_total 12.0                   2.0                             17.0 12                   2                       17
1819777 1819777 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12 2021   pk_12_total 39.0   1.0 1.0   3.0         16.0                             64.0 39   1 1   3         16                       64
1819793 1819793 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12 2021   pk_12_total 19.0   1.0                                             20.0 19   1                                       20
1819809 1819809 AK     school 200700 44   Southeast Island Schools 20070000322 440230 Port Alexander School   Regular School No Other PK 12 2021   pk_12_total 5.0                                                 9.0 5                                           9
1819825 1819825 AK     school 200700 44   Southeast Island Schools 20070000484 440250 Hollis School   Regular School No Other PK 12 2021   pk_12_total 8.0   3.0 3.0             2.0                             19.0 8   3 3             2                       19
1819841 1819841 AK     school 200700 44   Southeast Island Schools 20070000589 440270 Naukati School   Regular School No Other PK 12 2021   pk_12_total 9.0                                                 11.0 9                                           11
1737394 1737394 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12.0 2020   pk_12_total 107.0   4.0     8.0         14.0                             140 107   4     8         14                       140
1819729 1819729 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12 2021   pk_12_total 114.0   4.0     6.0         14.0                             144.0 114   4     6         14                       144
1737298 1737298 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1.0 2020   pk_12_total 98.0   7.0 4.0   14.0     2.0   18.0                             182 98   7 4   14     2   18                       182
1737314 1737314 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 136.0 1.0 8.0 7.0   24.0     5.0   19.0                             293 136 1 8 7   24     5   19                       293
1737330 1737330 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12.0 2020   pk_12_total 150.0 2.0 15.0 8.0   34.0     3.0   23.0                             322 150 2 15 8   34     3   23                       322
1737346 1737346 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   pk_12_total 189.0 5.0 17.0 10.0   23.0     1.0   23.0                             366 189 5 17 10   23     1   23                       366
1737362 1737362 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12.0 2020   pk_12_total 9.0   1.0 2.0             2.0                             36 9   1 2             2                       36

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