Data source: Big Local News · About: Big Local

7,952 rows where state = "AK" and year = 2021 sorted by total descending

View and edit SQL

year

  • 2021 · 7,952
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
1816255 AK     school 200360 23   Kake City Schools 20036000150 230010 Kake Elementary & High School   Regular School No Other PK 12 2021   k_12_total 3.0     3.0   2.0         2.0                             99.0 3     3   2         2                       99
1816257 AK     school 200360 23   Kake City Schools 20036000150 230010 Kake Elementary & High School   Regular School No Other PK 12 2021   pk_12_total 3.0     3.0   2.0         2.0                             99.0 3     3   2         2                       99
1817023 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000048 257010 Revilla Jr/Sr High School   Alternative School No High 07 12 2021   k_12_total 38.0 1.0 2.0 4.0   1.0         1.0                             99.0 38 1 2 4   1         1                       99
1817025 AK     school 200150 25   Ketchikan Gateway Borough Schools 20015000048 257010 Revilla Jr/Sr High School   Alternative School No High 07 12 2021   pk_12_total 38.0 1.0 2.0 4.0   1.0         1.0                             99.0 38 1 2 4   1         1                       99
1817665 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   pk_12_total                                                   99.0                                             99
1812687 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12 2021   k_12_total 567.0 55.0 112.0 10.0   25.0     29.0   118.0                             987.0 567 55 112 10   25     29   118                       987
1816382 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000158 240080 Homer High School   Regular School No High 09 12 2021   grade_9 74.0 0.0 5.0 2.0   1.0     2.0   12.0                             98.0 74 0 5 2   1     2   12                       98
1816388 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000537 240090 Kenai Central High School   Regular School No High 09 12 2021   grade_10 56.0   7.0 0.0   2.0     2.0   18.0                             98.0 56   7 0   2     2   18                       98
1817649 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   pk_12_total       1.0                                           98.0       1                                     98
1819044 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12 2021   grade_10 70.0 1.0 4.0 1.0   2.0     0.0   13.0                             98.0 70 1 4 1   2     0   13                       98
1815558 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000325 167010 Alternative Learning Systems   Alternative School No Other PK 12 2021   grade_12 47.0 4.0 7.0 2.0   1.0     0.0   13.0                             97.0 47 4 7 2   1     0   13                       97
1817708 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_7 11.0 1.0 2.0 0.0   2.0         0.0                             97.0 11 1 2 0   2         0                       97
1819054 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12 2021   grade_9 71.0 3.0 2.0 5.0   3.0     1.0   8.0                             97.0 71 3 2 5   3     1   8                       97
1819645 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   grade_8 49.0 1.0 5.0 1.0   9.0     3.0   6.0                             97.0 49 1 5 1   9     3   6                       97
1815617 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000587 168010 Fairbanks B.E.S.T.   Regular School No Other PK 12 2021   pk_12_total 731.0 16.0 70.0 2.0   20.0         104.0                             969.0 731 16 70 2   20         104                       969
1814863 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12 2021   k_12_total 29.0   3.0           2.0   2.0                             96.0 29   3           2   2                       96
1814865 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12 2021   pk_12_total 29.0   3.0           2.0   2.0                             96.0 29   3           2   2                       96
1816303 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000512 240030 McNeil Canyon Elementary   Regular School No Elementary KG 6 2021   k_12_total 83.0   1.0     1.0         10.0                             96.0 83   1     1         10                       96
1816305 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000512 240030 McNeil Canyon Elementary   Regular School No Elementary KG 6 2021   pk_12_total 83.0   1.0     1.0         10.0                             96.0 83   1     1         10                       96
1816791 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000397 247010 Connections   Regular School No Other KG 12 2021   grade_2 77.0 0.0 1.0 1.0   1.0     0.0   12.0                             96.0 77 0 1 1   1     0   12                       96
1817647 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   k_12_total       1.0                                           96.0       1                                     96
1819137 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   pk_12_total                     16.0                             96.0                     16                       96
1816398 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000537 240090 Kenai Central High School   Regular School No High 09 12 2021   grade_9 69.0   6.0 0.0   0.0     0.0   14.0                             95.0 69   6 0   0     0   14                       95
1819711 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12 2021   k_12_total 58.0   3.0 1.0   3.0         10.0                             95.0 58   3 1   3         10                       95
1819713 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12 2021   pk_12_total 58.0   3.0 1.0   3.0         10.0                             95.0 58   3 1   3         10                       95
1820574 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_9 14.0   1.0 1.0   1.0     0.0   2.0                             95.0 14   1 1   1     0   2                       95
1817983 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   k_12_total                                                   94.0                                             94
1817985 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   pk_12_total                                                   94.0                                             94
1818452 AK     school 200510 33   Mat-Su Borough Schools 20051000586 330250 Houston Jr./Sr. High School   Regular School No High 06 12 2021   grade_10 61.0 0.0 8.0     1.0     2.0   10.0                             94.0 61 0 8     1     2   10                       94
1819275 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   grade_6 1.0 1.0   0.0   11.0     7.0   14.0                             94.0 1 1   0   11     7   14                       94
1815615 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000587 168010 Fairbanks B.E.S.T.   Regular School No Other PK 12 2021   k_12_total 703.0 16.0 65.0 2.0   20.0         100.0                             931.0 703 16 65 2   20         100                       931
1814513 AK     school 200020 7   Bering Strait Schools 20002000013 70070 Koyuk-Malimiut School   Regular School No Other PK 12 2021   pk_12_total                                                   93.0                                             93
1817663 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   k_12_total                                                   93.0                                             93
1819276 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   grade_7 0.0 1.0   0.0   9.0     2.0   14.0                             93.0 0 1   0   9     2   14                       93
1820565 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_11 7.0   1.0 1.0   0.0     2.0   2.0                             93.0 7   1 1   0     2   2                       93
1815761 AK     school 200130 17   Galena City Schools 20013000253 178010 Interior Distance Education of Alaska (IDEA)   Regular School No Other PK 12 2021   pk_12_total 6614.0 127.0 476.0 125.0   102.0     70.0   879.0                             9249.0 6614 127 476 125   102     70   879                       9249
1816372 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000158 240080 Homer High School   Regular School No High 09 12 2021   grade_10 76.0 0.0 3.0 0.0   2.0     0.0   7.0                             92.0 76 0 3 0   2     0   7                       92
1816374 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000158 240080 Homer High School   Regular School No High 09 12 2021   grade_12 77.0 0.0 3.0 0.0   0.0     0.0   10.0                             92.0 77 0 3 0   0     0   10                       92
1818918 AK     school 200510 33   Mat-Su Borough Schools 20051000747 337070 Mat-Su Middle College School   Regular School No High 08 12 2021   grade_12 58.0 0.0 10.0 1.0   1.0     1.0   15.0                             92.0 58 0 10 1   1     1   15                       92
1815588 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000650 167030 Hutchison High School   Career and Technical School No High 09 12 2021   grade_10 58.0 3.0 7.0 0.0   2.0     1.0   16.0                             91.0 58 3 7 0   2     1   16                       91
1815590 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000650 167030 Hutchison High School   Career and Technical School No High 09 12 2021   grade_12 60.0 2.0 6.0 2.0   1.0     0.0   12.0                             91.0 60 2 6 2   1     0   12                       91
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
1812684 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12 2021   grade_7 49.0 8.0 6.0 0.0   1.0     3.0   10.0                             90.0 49 8 6 0   1     3   10                       90
1813891 AK     school 200180 5   Anchorage Schools 20018000713 50970 Bowman Elementary   Regular School No Elementary PK 6 2021   grade_1 43.0 2.0 10.0 0.0   14.0     4.0   10.0                             90.0 43 2 10 0   14     4   10                       90
1817688 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_3 14.0 0.0 2.0 0.0   0.0         1.0                             90.0 14 0 2 0   0         1                       90
1819143 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5 2021   grade_2 2.0 0.0 0.0 1.0   7.0     4.0   20.0                             90.0 2 0 0 1   7     4   20                       90
1820303 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12 2021   k_12_total 2.0     2.0                                           90.0 2     2                                     90
1812664 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12 2021   grade_3 9.0   0.0 0.0             0.0                             9.0 9   0 0             0                       9
1812666 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12 2021   grade_5 8.0   1.0 0.0             0.0                             9.0 8   1 0             0                       9
1812672 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12 2021   kindergarten 8.0   0.0 0.0             1.0                             9.0 8   0 0             1                       9
1812812 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12 2021   grade_7 9.0   0.0     0.0         0.0                             9.0 9   0     0         0                       9
1814132 AK     school 200180 5   Anchorage Schools 20018000432 57020 McLaughlin Secondary School   Alternative School No High 06 12 2021   grade_10 4.0 2.0 0.0 0.0         1.0   0.0                             9.0 4 2 0 0         1   0                       9
1814436 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12 2021   grade_10 0.0                                                 9.0 0                                           9
1814446 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12 2021   grade_9 0.0                                                 9.0 0                                           9
1814454 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12 2021   grade_12 0.0 0.0                                               9.0 0 0                                         9
1814461 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12 2021   grade_8 0.0 0.0                                               9.0 0 0                                         9
1814526 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12 2021   grade_9 0.0 0.0 0.0                                             9.0 0 0 0                                       9
1814536 AK     school 200020 7   Bering Strait Schools 20002000466 70100 Shaktoolik School   Regular School No Other PK 12 2021   grade_3 0.0                                                 9.0 0                                           9
1814565 AK     school 200020 7   Bering Strait Schools 20002000468 70120 Tukurngailnguq School   Regular School No Other PK 12 2021   grade_11 0.0 0.0                                               9.0 0 0                                         9
1814566 AK     school 200020 7   Bering Strait Schools 20002000468 70120 Tukurngailnguq School   Regular School No Other PK 12 2021   grade_12 0.0 0.0                                               9.0 0 0                                         9
1814630 AK     school 200020 7   Bering Strait Schools 20002000012 70180 Gambell School   Regular School No Other PK 12 2021   grade_12 0.0                                                 9.0 0                                           9
1814662 AK     school 200020 7   Bering Strait Schools 20002000017 70260 Unalakleet School   Regular School No Other PK 12 2021   grade_12 0.0   0.0               2.0                             9.0 0   0               2                       9
1814696 AK     school 200030 8   Bristol Bay Borough Schools 20003000626 80020 Naknek Elementary   Regular School No Elementary PK 6 2021   grade_3 2.0 0.0 1.0     1.0         1.0                             9.0 2 0 1     1         1                       9
1814745 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12 2021   grade_4 7.0 1.0                                               9.0 7 1                                         9
1814867 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12 2021   grade_1 6.0 0.0                 2.0                             9.0 6 0                 2                       9
1814895 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 9.0 1                                           9
1815434 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000279 160280 Two Rivers School   Regular School No Elementary PK 8 2021   grade_5 7.0   0.0               2.0                             9.0 7   0               2                       9
1815721 AK     school 200130 17   Galena City Schools 20013000044 170010 Sidney C. Huntington Elementary   Regular School No Elementary PK 6 2021   grade_4 1.0     0.0   0.0         0.0                             9.0 1     0   0         0                       9
1815728 AK     school 200130 17   Galena City Schools 20013000044 170010 Sidney C. Huntington Elementary   Regular School No Elementary PK 6 2021   kindergarten 0.0     0.0   0.0         0.0                             9.0 0     0   0         0                       9
1815733 AK     school 200130 17   Galena City Schools 20013000635 170020 Sidney C. Huntington Jr/Sr High School   Regular School No High 07 12 2021   grade_11 3.0     0.0                                           9.0 3     0                                     9
1815740 AK     school 200130 17   Galena City Schools 20013000635 170020 Sidney C. Huntington Jr/Sr High School   Regular School No High 07 12 2021   grade_7 2.0     0.0                                           9.0 2     0                                     9
1815816 AK     school 200270 18   Haines Borough Schools 20027000670 188010 Haines Home School   Regular School No Other KG 12 2021   grade_3 8.0   0.0               0.0                             9.0 8   0               0                       9
1815868 AK     school 200330 20   Hydaburg City Schools 20033000746 208010 Totem Correspondence School   Regular School No Other PK 12 2021   grade_7 4.0 0.0 0.0     0.0         0.0                             9.0 4 0 0     0         0                       9
1815990 AK     school 200520 21   Iditarod Area Schools 20052000327 218010 Distance Learning/Corresp. Ctr.   Regular School No Other KG 12 2021   grade_12 9.0 0.0 0.0 0.0   0.0     0.0   0.0                             9.0 9 0 0 0   0     0   0                       9
1815998 AK     school 200520 21   Iditarod Area Schools 20052000327 218010 Distance Learning/Corresp. Ctr.   Regular School No Other KG 12 2021   grade_9 7.0 0.0 0.0 0.0   0.0     0.0   0.0                             9.0 7 0 0 0   0     0   0                       9
1816247 AK     school 200360 23   Kake City Schools 20036000150 230010 Kake Elementary & High School   Regular School No Other PK 12 2021   grade_2 0.0     0.0   0.0         0.0                             9.0 0     0   0         0                       9
1816254 AK     school 200360 23   Kake City Schools 20036000150 230010 Kake Elementary & High School   Regular School No Other PK 12 2021   grade_9 0.0     0.0   0.0         0.0                             9.0 0     0   0         0                       9
1816361 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000536 240070 Razdolna School   Regular School No Other PK 12 2021   grade_4 9.0                                                 9.0 9                                           9
1816468 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000165 240150 Ninilchik School   Regular School No Other PK 12 2021   grade_10 7.0 0.0 0.0 0.0   0.0         2.0                             9.0 7 0 0 0   0         2                       9
1816469 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000165 240150 Ninilchik School   Regular School No Other PK 12 2021   grade_11 4.0 0.0 0.0 0.0   0.0         4.0                             9.0 4 0 0 0   0         4                       9
1816470 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000165 240150 Ninilchik School   Regular School No Other PK 12 2021   grade_12 3.0 0.0 1.0 0.0   1.0         1.0                             9.0 3 0 1 0   1         1                       9
1816482 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000165 240150 Ninilchik School   Regular School No Other PK 12 2021   pre_kindergarten 6.0 0.0 0.0 0.0   1.0         1.0                             9.0 6 0 0 0   1         1                       9
1816578 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000173 240230 Sterling Elementary   Regular School No Elementary PK 6 2021   pre_kindergarten 8.0 0.0 1.0 0.0   0.0     0.0   0.0                             9.0 8 0 1 0   0     0   0                       9
1816707 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000612 240380 Voznesenka School   Regular School No Other PK 12 2021   grade_1 9.0                                                 9.0 9                                           9
1816718 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000612 240380 Voznesenka School   Regular School No Other PK 12 2021   grade_9 9.0                                                 9.0 9                                           9
1817514 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500199 300090 Newhalen School   Regular School No Other PK 12 2021   grade_5 0.0     0.0             2.0                             9.0 0     0             2                       9
1817542 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500204 300110 Tanalian School   Regular School No Other PK 12 2021   grade_12 4.0 0.0   1.0             1.0                             9.0 4 0   1             1                       9
1817635 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_1       0.0                                           9.0       0                                     9
1817645 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_8       0.0                                           9.0       0                                     9
1817651 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_1                                                   9.0                                             9
1817720 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_3                                                   9.0                                             9
1817734 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_12                                                   9.0                                             9
1817738 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_5                                                   9.0                                             9
1817739 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_6                                                   9.0                                             9
1817740 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_7                                                   9.0                                             9
1817763 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   grade_1 1.0                                                 9.0 1                                           9
1817769 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   grade_4 1.0                                                 9.0 1                                           9
1817773 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   grade_8 0.0                                                 9.0 0                                           9
1817778 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   pre_kindergarten 0.0                                                 9.0 0                                           9
1817795 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12 2021   grade_1                                                   9.0                                             9

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