enrollments

Data source: Big Local News · About: Big Local

498 rows where grade = "pk_12_total", state = "AK" and year = 2020 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 498 ✖

grade ✖

  • pk_12_total · 498 ✖
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
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
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
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
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
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
1738162 1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1737378 1737378 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12.0 2020   pk_12_total 31.0 1.0 1.0     3.0         2.0                             52 31 1 1     3         2                       52
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
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
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
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
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
1737282 1737282 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10.0 2020   pk_12_total                                                   6                                             6
1737266 1737266 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12.0 2020   pk_12_total     1.0 2.0                                           59     1 2                                     59
1737250 1737250 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 77.0 3.0 7.0     6.0     2.0   2.0                             113 77 3 7     6     2   2                       113
1737234 1737234 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12.0 2020   pk_12_total 90.0 5.0 6.0 1.0   6.0     6.0   2.0                             132 90 5 6 1   6     6   2                       132
1737218 1737218 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 139.0 7.0 9.0 4.0   10.0     4.0   5.0                             226 139 7 9 4   10     4   5                       226
1737202 1737202 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12.0 2020   pk_12_total 7.0                   5.0                             16 7                   5                       16
1737186 1737186 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12.0 2020   pk_12_total       1.0             1.0                             27       1             1                       27
1737170 1737170 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12.0 2020   pk_12_total                 1.0   10.0                             276                 1   10                       276
1737154 1737154 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12.0 2020   pk_12_total 26.0 3.0 2.0 4.0   4.0     2.0   27.0                             338 26 3 2 4   4     2   27                       338
1737138 1737138 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12.0 2020   pk_12_total                                                   66                                             66
1737122 1737122 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12.0 2020   pk_12_total 1.0 1.0   6.0             11.0                             228 1 1   6             11                       228
1737106 1737106 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 163 2                                           163
1737090 1737090 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 15.0 3.0 3.0               36.0                             356 15 3 3               36                       356
1737074 1737074 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12.0 2020   pk_12_total                     1.0                             49                     1                       49
1737058 1737058 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12.0 2020   pk_12_total                     3.0                             167                     3                       167
1737042 1737042 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12.0 2020   pk_12_total 4.0                   6.0                             125 4                   6                       125
1737026 1737026 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12.0 2020   pk_12_total                     1.0                             51                     1                       51
1737010 1737010 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12.0 2020   pk_12_total     1.0                                             181     1                                       181
1736994 1736994 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12.0 2020   pk_12_total                     2.0                             73                     2                       73
1736978 1736978 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12.0 2020   pk_12_total 1.0     1.0         1.0   1.0                             40 1     1         1   1                       40
1736962 1736962 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 7.0 1.0   2.0   22.0     13.0   46.0                             270 7 1   2   22     13   46                       270
1736946 1736946 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12.0 2020   pk_12_total   2.0                 5.0                             168   2                 5                       168
1736930 1736930 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12.0 2020   pk_12_total 4.0                   1.0                             92 4                   1                       92
1736914 1736914 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12.0 2020   pk_12_total                     4.0                             112                     4                       112
1736898 1736898 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12.0 2020   pk_12_total 4.0 1.0       1.0         15.0                             252 4 1       1         15                       252
1736882 1736882 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12.0 2020   pk_12_total                     3.0                             145                     3                       145
1736866 1736866 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12.0 2020   pk_12_total 3.0                                                 59 3                                           59
1736850 1736850 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12.0 2020   pk_12_total 12.0 5.0   3.0   49.0     14.0   31.0                             269 12 5   3   49     14   31                       269
1736834 1736834 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 26.0 5.0 1.0 3.0   43.0     34.0   137.0                             664 26 5 1 3   43     34   137                       664
1736818 1736818 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12.0 2020   pk_12_total 3.0                   14.0                             99 3                   14                       99
1736802 1736802 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8.0 2020   pk_12_total 6.0         1.0         24.0                             60 6         1         24                       60
1736786 1736786 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12.0 2020   pk_12_total 10.0   1.0                                             15 10   1                                       15
1736770 1736770 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 07 12.0 2020   pk_12_total 27.0 3.0 6.0     2.0     2.0   54.0                             264 27 3 6     2     2   54                       264
1736754 1736754 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6.0 2020   pk_12_total 38.0 1.0 1.0 2.0         2.0   88.0                             376 38 1 1 2         2   88                       376
1736738 1736738 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12.0 2020   pk_12_total 817.0 47.0 46.0 20.0   32.0     16.0   187.0                             1257 817 47 46 20   32     16   187                       1257
1736722 1736722 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12.0 2020   pk_12_total 56.0 1.0 1.0     1.0         27.0                             201 56 1 1     1         27                       201
1736706 1736706 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8.0 2020   pk_12_total 294.0 2.0 23.0 3.0   1.0         48.0                             397 294 2 23 3   1         48                       397
1736690 1736690 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8.0 2020   pk_12_total 211.0 2.0 62.0 2.0         2.0   33.0                             327 211 2 62 2         2   33                       327
1736674 1736674 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12.0 2020   pk_12_total 395.0 2.0 27.0 4.0   5.0     1.0   22.0                             471 395 2 27 4   5     1   22                       471

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