enrollments

Data source: Big Local News · About: Big Local

15,920 rows where state = "AK" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
1735586 1735586 AK     school 200001 31   Lower Kuskokwim Schools 20000100409 310170 William Miller Memorial School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 91 2                                           91
1736420 1736420 AK     school 200510 33   Mat-Su Borough Schools 20051000480 330500 John Shaw Elementary   Regular School No Elementary PK 5.0 2020   grade_1 68.0 1.0 6.0 1.0   0.0     1.0   9.0                             91 68 1 6 1   0     1   9                       91
1737318 1737318 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12.0 2020   grade_11 41.0 1.0 5.0 2.0   8.0     0.0   8.0                             91 41 1 5 2   8     0   8                       91
1730736 1730736 AK     school 200180 5   Anchorage Schools 20018000069 50160 Chugiak High School   Regular School No High 09 12.0 2020   k_12_total 636.0 14.0 80.0 6.0   29.0     4.0   96.0                             905 636 14 80 6   29     4   96                       905
1730738 1730738 AK     school 200180 5   Anchorage Schools 20018000069 50160 Chugiak High School   Regular School No High 09 12.0 2020   pk_12_total 636.0 14.0 80.0 6.0   29.0     4.0   96.0                             905 636 14 80 6   29     4   96                       905
1812684 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 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 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 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 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
1730668 1730668 AK     school 200180 5   Anchorage Schools 20018000066 50120 Chinook Elementary   Regular School No Elementary PK 6.0 2020   grade_6 22.0 1.0 14.0 2.0   10.0     12.0   17.0                             90 22 1 14 2   10     12   17                       90
1731641 1731641 AK     school 200180 5   Anchorage Schools 20018000149 51020 Kincaid Elementary   Regular School No Elementary PK 6.0 2020   grade_3 52.0 1.0 7.0 1.0   4.0     5.0   13.0                             90 52 1 7 1   4     5   13                       90
1733570 1733570 AK     school 200330 20   Hydaburg City Schools 20033000148 200010 Hydaburg School   Regular School No Other PK 12.0 2020   pk_12_total 6.0               8.0   4.0                             90 6               8   4                       90
1736847 1736847 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12.0 2020   grade_9 4.0 2.0   1.0   14.0     5.0   10.0                             90 4 2   1   14     5   10                       90
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
1812664 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1817833 1817833 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_4                                                   9.0                                             9
1817863 1817863 AK     school 200001 31   Lower Kuskokwim Schools 20000100409 310170 William Miller Memorial School   Regular School No Other PK 12 2021   grade_2                                                   9.0                                             9
1817867 1817867 AK     school 200001 31   Lower Kuskokwim Schools 20000100409 310170 William Miller Memorial School   Regular School No Other PK 12 2021   grade_6                                                   9.0                                             9
1817875 1817875 AK     school 200001 31   Lower Kuskokwim Schools 20000100439 310180 Z. John Williams Memorial School   Regular School No Other PK 12 2021   grade_1 0.0                                                 9.0 0                                           9
1817880 1817880 AK     school 200001 31   Lower Kuskokwim Schools 20000100439 310180 Z. John Williams Memorial School   Regular School No Other PK 12 2021   grade_3 0.0                                                 9.0 0                                           9
1817908 1817908 AK     school 200001 31   Lower Kuskokwim Schools 20000100406 310200 Lewis Angapak Memorial School   Regular School No Other PK 12 2021   grade_10                                                   9.0                                             9
1817926 1817926 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_12                                                   9.0                                             9
1817936 1817936 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   kindergarten                                                   9.0                                             9
1817977 1817977 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   grade_4                                                   9.0                                             9
1817981 1817981 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   grade_8                                                   9.0                                             9
1818035 1818035 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_1                                                   9.0                                             9
1818037 1818037 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_11                                                   9.0                                             9
1818116 1818116 AK     school 200003 32   Lower Yukon Schools 20000300217 320040 Emmonak School   Regular School No Other PK 12 2021   grade_10 0.0                   0.0                             9.0 0                   0                       9
1818211 1818211 AK     school 200003 32   Lower Yukon Schools 20000300222 320130 Russian Mission School   Regular School No Other PK 12 2021   grade_1                     1.0                             9.0                     1                       9
1818909 1818909 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12 2021   grade_8 2.0   2.0 0.0   0.0         2.0                             9.0 2   2 0   0         2                       9
1818910 1818910 AK     school 200510 33   Mat-Su Borough Schools 20051000734 337060 Mat-Su Day School   Special Education School No Other KG 12 2021   grade_9 5.0   1.0 0.0   0.0         1.0                             9.0 5   1 0   0         1                       9
1819037 1819037 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12 2021   grade_8 5.0 0.0       1.0         0.0                             9.0 5 0       1         0                       9
1819097 1819097 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12 2021   grade_4 1.0   0.0           1.0   3.0                             9.0 1   0           1   3                       9
1819123 1819123 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   grade_1                     2.0                             9.0                     2                       9
1819131 1819131 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   grade_6                     1.0                             9.0                     1                       9
1819132 1819132 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   grade_7                     2.0                             9.0                     2                       9
1819225 1819225 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   grade_4 0.0                   0.0                             9.0 0                   0                       9
1819230 1819230 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   grade_9 0.0                   0.0                             9.0 0                   0                       9
1819363 1819363 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12 2021   grade_1 1.0                   2.0                             9.0 1                   2                       9
1819369 1819369 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12 2021   grade_4 1.0                   0.0                             9.0 1                   0                       9
1819381 1819381 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12 2021   grade_11                     0.0                             9.0                     0                       9
1819430 1819430 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12 2021   grade_12                                                   9.0                                             9
1819433 1819433 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12 2021   grade_4                                                   9.0                                             9
1819469 1819469 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12 2021   grade_8                                                   9.0                                             9
1819493 1819493 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12 2021   grade_11 0.0         0.0     0.0   0.0                             9.0 0         0     0   0                       9
1819597 1819597 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12 2021   grade_8                                                   9.0                                             9
1819774 1819774 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12 2021   grade_9 6.0   1.0 0.0   1.0         0.0                             9.0 6   1 0   1         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]);