enrollments

Data source: Big Local News · About: Big Local

498 rows where grade = "k_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 ✖

  • k_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
1738256 1738256 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   k_12_total 38.0     5.0   4.0     3.0   8.0                             431 38     5   4     3   8                       431
1738240 1738240 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 6 1                                           6
1738224 1738224 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12.0 2020   k_12_total 2.0                   3.0                             20 2                   3                       20
1738208 1738208 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12.0 2020   k_12_total 9.0   2.0     10.0     8.0   4.0                             111 9   2     10     8   4                       111
1738192 1738192 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12.0 2020   k_12_total 5.0   1.0 1.0   3.0                                       82 5   1 1   3                                 82
1738176 1738176 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12.0 2020   k_12_total 2.0         2.0                                       302 2         2                                 302
1738160 1738160 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   k_12_total 1.0                   2.0                             213 1                   2                       213
1738144 1738144 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   k_12_total                                                   119                                             119
1738128 1738128 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   k_12_total 1.0                                                 131 1                                           131
1738112 1738112 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   k_12_total 1.0                   4.0                             33 1                   4                       33
1738096 1738096 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   k_12_total 1103.0 35.0 70.0 38.0   23.0     24.0   123.0                             1645 1103 35 70 38   23     24   123                       1645
1738080 1738080 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   k_12_total                                                   15                                             15
1738064 1738064 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   k_12_total 2.0     2.0                                           23 2     2                                     23
1738048 1738048 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12.0 2020   k_12_total 1.0     1.0   1.0                                       43 1     1   1                                 43
1738032 1738032 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12.0 2020   k_12_total 4.0                                                 43 4                                           43
1738016 1738016 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8.0 2020   k_12_total                                                   14                                             14
1738000 1738000 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   k_12_total                                                   23                                             23
1737984 1737984 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   k_12_total 2.0     3.0             2.0                             81 2     3             2                       81
1737968 1737968 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   k_12_total 2.0                                                 17 2                                           17
1737952 1737952 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 29 1                                           29
1737936 1737936 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12.0 2020   k_12_total                                                   10                                             10
1737920 1737920 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12.0 2020   k_12_total 3.0                                                 90 3                                           90
1737904 1737904 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12.0 2020   k_12_total 2.0                                                 50 2                                           50
1737888 1737888 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 15 1                                           15
1737872 1737872 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12.0 2020   k_12_total   1.0                                               11   1                                         11
1737856 1737856 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12.0 2020   k_12_total                                                   34                                             34
1737840 1737840 AK     school 200840 50   Yakutat City Schools 20084000749 508010 LEAD Correspondence   Regular School No Other KG 12.0 2020   k_12_total 18.0 1.0                                               22 18 1                                         22
1737824 1737824 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12.0 2020   k_12_total 20.0   3.0     2.0                                       79 20   3     2                                 79
1737808 1737808 AK     school 200810 49   Wrangell City Schools 20081000728 490030 Stikine Middle School   Regular School No Middle 06 8.0 2020   k_12_total 28.0   2.0 3.0   1.0         9.0                             67 28   2 3   1         9                       67
1737792 1737792 AK     school 200810 49   Wrangell City Schools 20081000576 490020 Wrangell High School   Regular School No High 09 12.0 2020   k_12_total 33.0 1.0 1.0 4.0   5.0         4.0                             84 33 1 1 4   5         4                       84
1737776 1737776 AK     school 200810 49   Wrangell City Schools 20081000373 490010 Evergreen Elementary   Regular School No Elementary PK 5.0 2020   k_12_total 67.0 1.0 1.0 7.0   2.0         4.0                             157 67 1 1 7   2         4                       157
1737760 1737760 AK     school 200780 48   Valdez City Schools 20078000753 488010 Valdez Home School   Regular School No Other PK 12.0 2020   k_12_total 26.0   1.0               2.0                             29 26   1               2                       29
1737744 1737744 AK     school 200780 48   Valdez City Schools 20078000495 480050 Hermon Hutchens Elementary   Regular School No Elementary PK 5.0 2020   k_12_total 212.0 3.0 13.0 4.0   1.0     1.0   72.0                             323 212 3 13 4   1     1   72                       323
1737728 1737728 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8.0 2020   k_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
1737712 1737712 AK     school 200780 48   Valdez City Schools 20078000370 480030 Valdez High School   Regular School No High 09 12.0 2020   k_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
1737696 1737696 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12.0 2020   k_12_total 30.0   20.0     92.0     9.0                                 174 30   20     92     9                           174
1737680 1737680 AK     school 200720 47   Unalaska City Schools 20072000340 470010 Eagle's View Elementary School   Regular School No Elementary PK 6.0 2020   k_12_total 61.0 6.0 28.0 3.0   99.0     19.0                                 238 61 6 28 3   99     19                           238
1737664 1737664 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12.0 2020   k_12_total                     4.0                             182                     4                       182
1737648 1737648 AK     school 200710 45   Southwest Region Schools 20071000573 450120 Twin Hills School   Regular School No Other PK 12.0 2020   k_12_total                     8.0                             27                     8                       27
1737632 1737632 AK     school 200710 45   Southwest Region Schools 20071000338 450110 Togiak School   Regular School No Other PK 12.0 2020   k_12_total 2.0   1.0               9.0                             209 2   1               9                       209
1737616 1737616 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12.0 2020   k_12_total                     4.0                             134                     4                       134
1737600 1737600 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12.0 2020   k_12_total 1.0         0.0         1.0                             111 1         0         1                       111
1737584 1737584 AK     school 200710 45   Southwest Region Schools 20071000333 450050 Koliganek School   Regular School No Other PK 12.0 2020   k_12_total                     2.0                             44                     2                       44
1737568 1737568 AK     school 200710 45   Southwest Region Schools 20071000465 450040 William "Sonny" Nelson School   Regular School No Other PK 12.0 2020   k_12_total     1.0               2.0                             15     1               2                       15
1737552 1737552 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12.0 2020   k_12_total                                                   13                                             13
1737536 1737536 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12.0 2020   k_12_total     1.0               3.0                             30     1               3                       30
1737520 1737520 AK     school 200700 44   Southeast Island Schools 20070000428 440340 Hyder School   Regular School No Other PK 12.0 2020   k_12_total 13.0                                                 13 13                                           13
1737504 1737504 AK     school 200700 44   Southeast Island Schools 20070000589 440270 Naukati School   Regular School No Other PK 12.0 2020   k_12_total 13.0                   2.0                             18 13                   2                       18
1737488 1737488 AK     school 200700 44   Southeast Island Schools 20070000484 440250 Hollis School   Regular School No Other PK 12.0 2020   k_12_total 7.0   7.0               3.0                             20 7   7               3                       20
1737472 1737472 AK     school 200700 44   Southeast Island Schools 20070000322 440230 Port Alexander School   Regular School No Other PK 12.0 2020   k_12_total 14.0                                                 14 14                                           14
1737456 1737456 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12.0 2020   k_12_total 15.0   1.0                                             16 15   1                                       16
1737440 1737440 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12.0 2020   k_12_total 40.0 0.0 4.0     1.0         8.0                             56 40 0 4     1         8                       56
1737424 1737424 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12.0 2020   k_12_total 11.0                   1.0                             13 11                   1                       13
1737408 1737408 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12.0 2020   k_12_total 13.0         2.0                                       17 13         2                                 17
1737392 1737392 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12.0 2020   k_12_total 95.0   4.0     8.0         14.0                             125 95   4     8         14                       125
1737376 1737376 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12.0 2020   k_12_total 31.0 1.0 1.0     3.0         2.0                             52 31 1 1     3         2                       52
1737360 1737360 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12.0 2020   k_12_total 9.0   1.0 2.0             2.0                             36 9   1 2             2                       36
1737344 1737344 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   k_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
1737328 1737328 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12.0 2020   k_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
1737312 1737312 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8.0 2020   k_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
1737296 1737296 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1.0 2020   k_12_total 90.0   7.0 3.0   13.0     2.0   16.0                             166 90   7 3   13     2   16                       166
1737280 1737280 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10.0 2020   k_12_total                                                   6                                             6
1737264 1737264 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12.0 2020   k_12_total     1.0 2.0                                           59     1 2                                     59
1737248 1737248 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8.0 2020   k_12_total 77.0 3.0 7.0     6.0     2.0   2.0                             113 77 3 7     6     2   2                       113
1737232 1737232 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12.0 2020   k_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
1737216 1737216 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5.0 2020   k_12_total 139.0 7.0 8.0 4.0   10.0     4.0   5.0                             225 139 7 8 4   10     4   5                       225
1737200 1737200 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12.0 2020   k_12_total 7.0                   5.0                             16 7                   5                       16
1737184 1737184 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12.0 2020   k_12_total       1.0             1.0                             27       1             1                       27
1737168 1737168 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12.0 2020   k_12_total                 1.0   6.0                             249                 1   6                       249
1737152 1737152 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12.0 2020   k_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
1737136 1737136 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12.0 2020   k_12_total                                                   60                                             60
1737120 1737120 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12.0 2020   k_12_total 1.0 1.0   6.0             9.0                             201 1 1   6             9                       201
1737104 1737104 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12.0 2020   k_12_total 2.0                                                 155 2                                           155
1737088 1737088 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5.0 2020   k_12_total 14.0 2.0 3.0               32.0                             316 14 2 3               32                       316
1737072 1737072 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12.0 2020   k_12_total                     1.0                             45                     1                       45
1737056 1737056 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12.0 2020   k_12_total                     3.0                             161                     3                       161
1737040 1737040 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12.0 2020   k_12_total 4.0                   4.0                             119 4                   4                       119
1737024 1737024 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12.0 2020   k_12_total                     1.0                             48                     1                       48
1737008 1737008 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12.0 2020   k_12_total     1.0                                             165     1                                       165
1736992 1736992 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12.0 2020   k_12_total                     2.0                             67                     2                       67
1736976 1736976 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12.0 2020   k_12_total 1.0     1.0         1.0   1.0                             40 1     1         1   1                       40
1736960 1736960 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8.0 2020   k_12_total 7.0 1.0   2.0   22.0     13.0   46.0                             270 7 1   2   22     13   46                       270
1736944 1736944 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12.0 2020   k_12_total   2.0                 5.0                             160   2                 5                       160
1736928 1736928 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12.0 2020   k_12_total 4.0                   0.0                             77 4                   0                       77
1736912 1736912 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12.0 2020   k_12_total                     2.0                             98                     2                       98
1736896 1736896 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12.0 2020   k_12_total 2.0 1.0       1.0         13.0                             228 2 1       1         13                       228
1736880 1736880 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12.0 2020   k_12_total                     3.0                             124                     3                       124
1736864 1736864 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12.0 2020   k_12_total 3.0                                                 52 3                                           52
1736848 1736848 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12.0 2020   k_12_total 12.0 5.0   3.0   49.0     14.0   31.0                             269 12 5   3   49     14   31                       269
1736832 1736832 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5.0 2020   k_12_total 22.0 5.0 1.0 3.0   37.0     29.0   101.0                             542 22 5 1 3   37     29   101                       542
1736816 1736816 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12.0 2020   k_12_total 3.0                   11.0                             84 3                   11                       84
1736800 1736800 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8.0 2020   k_12_total 6.0         1.0         24.0                             60 6         1         24                       60
1736784 1736784 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12.0 2020   k_12_total 10.0   1.0                                             15 10   1                                       15
1736768 1736768 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 07 12.0 2020   k_12_total 27.0 3.0 6.0     2.0     2.0   54.0                             264 27 3 6     2     2   54                       264
1736752 1736752 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6.0 2020   k_12_total 38.0 1.0 1.0 2.0         2.0   88.0                             373 38 1 1 2         2   88                       373
1736736 1736736 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12.0 2020   k_12_total 779.0 47.0 46.0 20.0   30.0     15.0   183.0                             1210 779 47 46 20   30     15   183                       1210
1736720 1736720 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12.0 2020   k_12_total 56.0 1.0 1.0     1.0         27.0                             201 56 1 1     1         27                       201
1736704 1736704 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8.0 2020   k_12_total 294.0 2.0 23.0 3.0   1.0         48.0                             397 294 2 23 3   1         48                       397
1736688 1736688 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8.0 2020   k_12_total 211.0 2.0 62.0 2.0         2.0   33.0                             327 211 2 62 2         2   33                       327
1736672 1736672 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12.0 2020   k_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]);