enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "pk_12_total" and state = "AK" sorted by school_state_id 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
1738258 1738258 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   pk_12_total 38.0     5.0   4.0     3.0   8.0                             431 38     5   4     3   8                       431
1820577 1820577 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   pk_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1738242 1738242 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 7 1                                           7
1820561 1820561 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12 2021   pk_12_total 3.0                   1.0                             11.0 3                   1                       11
1738226 1738226 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                   3.0                             20 2                   3                       20
1820545 1820545 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   pk_12_total 1.0                   3.0                             17.0 1                   3                       17
1738210 1738210 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12.0 2020   pk_12_total 11.0   2.0     10.0     8.0   5.0                             120 11   2     10     8   5                       120
1820529 1820529 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12 2021   pk_12_total 15.0   2.0     9.0     7.0   9.0                             117.0 15   2     9     7   9                       117
1738194 1738194 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12.0 2020   pk_12_total 5.0   1.0 1.0   4.0                                       87 5   1 1   4                                 87
1820513 1820513 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12 2021   pk_12_total 6.0         2.0                                       83.0 6         2                                 83
1738178 1738178 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12.0 2020   pk_12_total 2.0         2.0                                       313 2         2                                 313
1820497 1820497 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 332.0 1                                           332
1738162 1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1737666 1737666 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12.0 2020   pk_12_total                     4.0                             204                     4                       204
1819985 1819985 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12 2021   pk_12_total   2.0                 4.0                             216.0   2                 4                       216
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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