enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "grade_12" and state = "AK" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 995 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1733303 1733303 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000650 167030 Hutchison High School   Career and Technical School No High 09 12.0 2020   grade_12 72.0 5.0 4.0 0.0   1.0     0.0   9.0                             98 72 5 4 0   1     0   9                       98
1738247 1738247 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   grade_12 11.0     2.0   0.0     0.0   1.0                             98 11     2   0     0   1                       98
1815558 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
1736599 1736599 AK     school 200510 33   Mat-Su Borough Schools 20051000747 337070 Mat-Su Middle College School   Regular School No High 08 12.0 2020   grade_12 65.0 3.0 6.0 2.0   1.0     0.0   16.0                             97 65 3 6 2   1     0   16                       97
1816374 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 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
1815590 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
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
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
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
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
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
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
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
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
1820230 1820230 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12 2021   grade_12 0.0                                                 9.0 0                                           9
1732199 1732199 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 9 0                                           9
1732343 1732343 AK     school 200020 7   Bering Strait Schools 20002000017 70260 Unalakleet School   Regular School No Other PK 12.0 2020   grade_12 0.0         0.0         0.0                             9 0         0         0                       9
1734151 1734151 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000164 240130 Nikolaevsk School   Regular School No Other PK 12.0 2020   grade_12 9.0   0.0 0.0             0.0                             9 9   0 0             0                       9
1734183 1734183 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000165 240150 Ninilchik School   Regular School No Other PK 12.0 2020   grade_12 5.0 0.0 0.0 1.0   0.0         2.0                             9 5 0 0 1   0         2                       9
1734567 1734567 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000735 247060 River City Academy   Regular School No High 07 12.0 2020   grade_12 8.0   0.0               1.0                             9 8   0               1                       9
1735543 1735543 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             9                     0                       9
1735815 1735815 AK     school 200003 32   Lower Yukon Schools 20000300217 320040 Emmonak School   Regular School No Other PK 12.0 2020   grade_12 1.0                   0.0                             9 1                   0                       9
1736935 1736935 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12.0 2020   grade_12   0.0                 0.0                             9   0                 0                       9
1738119 1738119 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_12 0.0                                                 9 0                                           9
1738135 1738135 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_12                                                   9                                             9
1738199 1738199 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12.0 2020   grade_12 0.0   0.0     0.0     1.0   0.0                             9 0   0     0     1   0                       9
1734087 1734087 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000158 240080 Homer High School   Regular School No High 09 12.0 2020   grade_12 72.0   2.0 1.0   1.0     1.0   6.0                             88 72   2 1   1     1   6                       88
1734103 1734103 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000537 240090 Kenai Central High School   Regular School No High 09 12.0 2020   grade_12 63.0 2.0 2.0 2.0   2.0     1.0   5.0                             87 63 2 2 2   2     1   5                       87
1816390 1816390 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000537 240090 Kenai Central High School   Regular School No High 09 12 2021   grade_12 55.0   4.0 1.0   3.0     2.0   8.0                             82.0 55   4 1   3     2   8                       82
1819654 1819654 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12 2021   grade_12 39.0 0.0 4.0 2.0   8.0     0.0   7.0                             82.0 39 0 4 2   8     0   7                       82
1814214 1814214 AK     school 200180 5   Anchorage Schools 20018000399 57220 The New Path High School   Alternative School No High 07 12 2021   grade_12 2.0 1.0 2.0 1.0                                           8.0 2 1 2 1                                     8
1814582 1814582 AK     school 200020 7   Bering Strait Schools 20002000016 70130 James C. Isabell School   Regular School No Other PK 12 2021   grade_12                                                   8.0                                             8
1814742 1814742 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12 2021   grade_12 6.0 1.0                                               8.0 6 1                                         8
1815734 1815734 AK     school 200130 17   Galena City Schools 20013000635 170020 Sidney C. Huntington Jr/Sr High School   Regular School No High 07 12 2021   grade_12 0.0     1.0                                           8.0 0     1                                     8
1817766 1817766 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   grade_12 0.0                                                 8.0 0                                           8
1817798 1817798 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12 2021   grade_12                                                   8.0                                             8
1817894 1817894 AK     school 200001 31   Lower Kuskokwim Schools 20000100440 310190 Ayaprun School   Regular School No Other PK 12 2021   grade_12                                                   8.0                                             8
1817974 1817974 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   grade_12                                                   8.0                                             8
1819254 1819254 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12 2021   grade_12   1.0                 0.0                             8.0   1                 0                       8
1819382 1819382 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12 2021   grade_12                     0.0                             8.0                     0                       8
1819510 1819510 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12 2021   grade_12 0.0                   1.0                             8.0 0                   1                       8
1819718 1819718 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12 2021   grade_12 7.0   0.0     0.0         1.0                             8.0 7   0     0         1                       8
1819910 1819910 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12 2021   grade_12 0.0         0.0         0.0                             8.0 0         0         0                       8
1819974 1819974 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12 2021   grade_12   0.0                 0.0                             8.0   0                 0                       8
1730327 1730327 AK     school 200770 2   Denali Borough Schools 20077000357 20040 Tri-Valley School   Regular School No Other PK 12.0 2020   grade_12 6.0 0.0 0.0 0.0             1.0                             8 6 0 0 0             1                       8
1733927 1733927 AK     school 200210 22   Juneau Borough Schools 20021000125 228010 HomeBRIDGE   Regular School No Other PK 12.0 2020   grade_12 3.0   0.0     1.0         3.0                             8 3   0     1         3                       8
1734055 1734055 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000157 240060 Nanwalek School   Regular School No Other PK 12.0 2020   grade_12     0.0     0.0         0.0                             8     0     0         0                       8
1734983 1734983 AK     school 200480 28   Kodiak Island Borough Schools 20048000435 288010 AKTEACH   Regular School No Other KG 12.0 2020   grade_12 2.0 1.0 1.0     1.0     0.0   0.0                             8 2 1 1     1     0   0                       8
1735015 1735015 AK     school 200760 29   Kuspuk Schools 20076000663 290011 Aniak Jr/Sr High School   Regular School No High 06 12.0 2020   grade_12 1.0                                                 8 1                                           8
1735255 1735255 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500204 300110 Tanalian School   Regular School No Other PK 12.0 2020   grade_12 2.0 2.0   0.0             2.0                             8 2 2   0             2                       8
1735447 1735447 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12.0 2020   grade_12                                                   8                                             8
1735479 1735479 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 8 0                                           8
1736663 1736663 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12.0 2020   grade_12 7.0 0.0 0.0 0.0   1.0     0.0   0.0                             8 7 0 0 0   1     0   0                       8
1736871 1736871 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             8                     0                       8
1736999 1736999 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12.0 2020   grade_12     0.0                                             8     0                                       8
1737031 1737031 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12.0 2020   grade_12 2.0                   0.0                             8 2                   0                       8
1737431 1737431 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12.0 2020   grade_12 4.0 0.0 2.0     0.0         2.0                             8 4 0 2     0         2                       8
1820566 1820566 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   grade_12 4.0   0.0 2.0   1.0     0.0   0.0                             78.0 4   0 2   1     0   0                       78
1737319 1737319 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12.0 2020   grade_12 33.0 0.0 1.0 2.0   10.0     0.0   5.0                             76 33 0 1 2   10     0   5                       76
1736135 1736135 AK     school 200510 33   Mat-Su Borough Schools 20051000586 330250 Houston Jr./Sr. High School   Regular School No High 06 12.0 2020   grade_12 42.0 1.0 7.0 1.0   1.0     4.0   4.0                             75 42 1 7 1   1     4   4                       75
1812678 1812678 AK     school 200770 2   Denali Borough Schools 20077000447 28010 Denali PEAK   Regular School No Other PK 12 2021   grade_12 39.0 2.0 13.0 0.0   2.0     3.0   10.0                             74.0 39 2 13 0   2     3   10                       74
1731783 1731783 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12.0 2020   grade_12 46.0 2.0 7.0 1.0   8.0     1.0   4.0                             72 46 2 7 1   8     1   4                       72
1736519 1736519 AK     school 200510 33   Mat-Su Borough Schools 20051000720 337010 Burchell High School   Alternative School No High 09 12.0 2020   grade_12 42.0 1.0 4.0 1.0   2.0     2.0   8.0                             72 42 1 4 1   2     2   8                       72
1736535 1736535 AK     school 200510 33   Mat-Su Borough Schools 20051000425 337020 Valley Pathways   Alternative School No High 09 12.0 2020   grade_12 50.0 2.0 4.0     0.0     1.0   4.0                             70 50 2 4     0     1   4                       70
1814550 1814550 AK     school 200020 7   Bering Strait Schools 20002000015 70110 Shishmaref School   Regular School No Other PK 12 2021   grade_12 0.0                                                 7.0 0                                           7
1814870 1814870 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12 2021   grade_12 4.0 0.0                 3.0                             7.0 4 0                 3                       7
1816246 1816246 AK     school 200360 23   Kake City Schools 20036000150 230010 Kake Elementary & High School   Regular School No Other PK 12 2021   grade_12 0.0     0.0   0.0         1.0                             7.0 0     0   0         1                       7
1816806 1816806 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000081 247020 Homer Flex School   Alternative School No High 09 12 2021   grade_12 2.0   0.0               2.0                             7.0 2   0               2                       7
1817510 1817510 AK     school 200485 30   Lake and Peninsula Borough Schools 20048500199 300090 Newhalen School   Regular School No Other PK 12 2021   grade_12 0.0     0.0             1.0                             7.0 0     0             1                       7
1818246 1818246 AK     school 200003 32   Lower Yukon Schools 20000300413 320150 Nunam Iqua School   Regular School No Other PK 12 2021   grade_12                                                   7.0                                             7
1819222 1819222 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   grade_12 0.0                   0.0                             7.0 0                   0                       7
1820166 1820166 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   grade_12                                                   7.0                                             7
1820502 1820502 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12 2021   grade_12 1.0         0.0                                       7.0 1         0                                 7
1730471 1730471 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_12 4.0   0.0     1.0         0.0                             7 4   0     1         0                       7
1732215 1732215 AK     school 200020 7   Bering Strait Schools 20002000466 70100 Shaktoolik School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 7 0                                           7
1733447 1733447 AK     school 200130 17   Galena City Schools 20013000635 170020 Sidney C. Huntington Jr/Sr High School   Regular School No High 07 12.0 2020   grade_12 3.0                                                 7 3                                           7
1735687 1735687 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 7 0                                           7
1735831 1735831 AK     school 200003 32   Lower Yukon Schools 20000300218 320050 Marshall School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             7                     0                       7
1736807 1736807 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12.0 2020   grade_12 0.0                   2.0                             7 0                   2                       7
1737527 1737527 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12.0 2020   grade_12     0.0               0.0                             7     0               0                       7
1737591 1737591 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12.0 2020   grade_12 0.0         0.0         0.0                             7 0         0         0                       7
1737655 1737655 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12.0 2020   grade_12                     0.0                             7                     0                       7
1737815 1737815 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12.0 2020   grade_12 5.0   0.0     0.0                                       7 5   0     0                                 7
1738183 1738183 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12.0 2020   grade_12 0.0   1.0 0.0   1.0                                       7 0   1 0   1                                 7
1818838 1818838 AK     school 200510 33   Mat-Su Borough Schools 20051000720 337010 Burchell High School   Alternative School No High 09 12 2021   grade_12 40.0 1.0 5.0 1.0         1.0   14.0                             69.0 40 1 5 1         1   14                       69
1815606 1815606 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000587 168010 Fairbanks B.E.S.T.   Regular School No Other PK 12 2021   grade_12 49.0 1.0 7.0 0.0   4.0         3.0                             68.0 49 1 7 0   4         3                       68
1814102 1814102 AK     school 200180 5   Anchorage Schools 20018000178 56010 Family Partnership Charter School   Regular School Yes Other KG 12 2021   grade_12 53.0 2.0 1.0 0.0   0.0     2.0   8.0                             67.0 53 2 1 0   0     2   8                       67
1814166 1814166 AK     school 200180 5   Anchorage Schools 20018000401 57110 Martin Luther King Jr. Technical High School   Career and Technical School No High 10 12 2021   grade_12 38.0 0.0 13.0     4.0         7.0                             66.0 38 0 13     4         7                       66
1818806 1818806 AK     school 200510 33   Mat-Su Borough Schools 20051000758 330540 Joe Redington Senior Jr/Sr High School   Regular School No High 06 12 2021   grade_12 44.0 0.0 2.0 1.0   0.0     1.0   9.0                             62.0 44 0 2 1   0     1   9                       62
1733351 1733351 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000462 169030 Star of the North Secondary School   Regular School Yes High 07 12.0 2020   grade_12 18.0 2.0 5.0 1.0   0.0     1.0   11.0                             60 18 2 5 1   0     1   11                       60
1814438 1814438 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12 2021   grade_12 0.0                                                 6.0 0                                           6
1814678 1814678 AK     school 200030 8   Bristol Bay Borough Schools 20003000020 80010 Bristol Bay Middle/High School   Regular School No High 07 12 2021   grade_12 2.0         0.0     0.0   1.0                             6.0 2         0     0   1                       6
1814790 1814790 AK     school 200800 10   Chugach Schools 20080000372 100020 Whittier Community School   Regular School No Other PK 12 2021   grade_12 1.0   0.0     0.0     1.0   4.0                             6.0 1   0     0     1   4                       6
1814902 1814902 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12 2021   grade_12 6.0   0.0 0.0             0.0                             6.0 6   0 0             0                       6
1815830 1815830 AK     school 200300 19   Hoonah City Schools 20030000146 190010 Hoonah City School   Regular School No Other PK 12 2021   grade_12 1.0   0.0 0.0             2.0                             6.0 1   0 0             2                       6
1816182 1816182 AK     school 200210 22   Juneau Borough Schools 20021000396 227020 Johnson Youth Center   Alternative School No High 05 12 2021   grade_12 0.0     1.0             4.0                             6.0 0     1             4                       6
1816710 1816710 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000612 240380 Voznesenka School   Regular School No Other PK 12 2021   grade_12 6.0                                                 6.0 6                                           6

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