enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "k_12_total" and state = "AK" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • k_12_total · 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
1820575 1820575 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   k_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1820559 1820559 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12 2021   k_12_total 3.0                   0.0                             10.0 3                   0                       10
1820543 1820543 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   k_12_total 1.0                   3.0                             17.0 1                   3                       17
1820527 1820527 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12 2021   k_12_total 11.0   2.0     9.0     7.0   8.0                             104.0 11   2     9     7   8                       104
1820511 1820511 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12 2021   k_12_total 6.0         2.0                                       75.0 6         2                                 75
1820495 1820495 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 317.0 1                                           317
1820479 1820479 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   k_12_total                     2.0                             214.0                     2                       214
1820463 1820463 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12 2021   k_12_total   2.0                 2.0                             144.0   2                 2                       144
1820447 1820447 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   k_12_total 4.0                                                 148.0 4                                           148
1820431 1820431 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12 2021   k_12_total 1.0                   2.0                             30.0 1                   2                       30
1820415 1820415 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12 2021   k_12_total 2398.0 101.0 194.0 65.0   64.0     75.0   433.0                             3868.0 2398 101 194 65   64     75   433                       3868
1820399 1820399 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12 2021   k_12_total                                                   14.0                                             14
1820383 1820383 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12 2021   k_12_total 2.0     2.0                                           31.0 2     2                                     31
1820367 1820367 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   k_12_total           1.0                                       42.0           1                                 42
1820351 1820351 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12 2021   k_12_total 3.0     0.0             1.0                             43.0 3     0             1                       43
1820335 1820335 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8 2021   k_12_total                                                   14.0                                             14
1820319 1820319 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12 2021   k_12_total                                                   22.0                                             22
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
1820287 1820287 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12 2021   k_12_total 2.0                                                 17.0 2                                           17
1820271 1820271 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   k_12_total           1.0                                       19.0           1                                 19
1820255 1820255 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12 2021   k_12_total                                                   8.0                                             8
1820239 1820239 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 82.0 1                                           82
1820223 1820223 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12 2021   k_12_total                                                   48.0                                             48
1820207 1820207 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12 2021   k_12_total 1.0                                                 18.0 1                                           18
1820191 1820191 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12 2021   k_12_total   1.0                                               10.0   1                                         10
1820175 1820175 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   k_12_total                                                   36.0                                             36
1820159 1820159 AK     school 200840 50   Yakutat City Schools 20084000749 508010 LEAD Correspondence   Regular School No Other KG 12 2021   k_12_total 18.0                   2.0                             25.0 18                   2                       25
1820143 1820143 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12 2021   k_12_total 6.0   4.0     2.0         3.0                             66.0 6   4     2         3                       66
1820127 1820127 AK     school 200810 49   Wrangell City Schools 20081000728 490030 Stikine Middle School   Regular School No Middle 06 8 2021   k_12_total 26.0     2.0   1.0         5.0                             52.0 26     2   1         5                       52
1820111 1820111 AK     school 200810 49   Wrangell City Schools 20081000576 490020 Wrangell High School   Regular School No High 09 12 2021   k_12_total 22.0   2.0 7.0   2.0                                       57.0 22   2 7   2                                 57
1820095 1820095 AK     school 200810 49   Wrangell City Schools 20081000373 490010 Evergreen Elementary   Regular School No Elementary PK 5 2021   k_12_total 34.0   1.0 1.0   1.0         8.0                             73.0 34   1 1   1         8                       73
1820079 1820079 AK     school 200780 48   Valdez City Schools 20078000753 488010 Valdez Home School   Regular School No Other PK 12 2021   k_12_total 82.0   1.0     2.0         20.0                             109.0 82   1     2         20                       109
1820063 1820063 AK     school 200780 48   Valdez City Schools 20078000495 480050 Hermon Hutchens Elementary   Regular School No Elementary PK 5 2021   k_12_total 158.0 3.0 9.0 4.0   1.0     2.0   51.0                             243.0 158 3 9 4   1     2   51                       243
1820047 1820047 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8 2021   k_12_total 93.0 1.0 7.0 1.0   2.0     2.0   28.0                             143.0 93 1 7 1   2     2   28                       143
1820031 1820031 AK     school 200780 48   Valdez City Schools 20078000370 480030 Valdez High School   Regular School No High 09 12 2021   k_12_total 99.0 2.0 6.0 1.0   7.0     3.0   22.0                             156.0 99 2 6 1   7     3   22                       156
1820015 1820015 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12 2021   k_12_total 31.0   19.0 2.0   87.0     7.0                                 161.0 31   19 2   87     7                           161
1819999 1819999 AK     school 200720 47   Unalaska City Schools 20072000340 470010 Eagle's View Elementary School   Regular School No Elementary PK 6 2021   k_12_total 62.0 5.0 26.0 1.0   89.0     16.0   2.0                             226.0 62 5 26 1   89     16   2                       226
1819983 1819983 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12 2021   k_12_total   2.0                 4.0                             193.0   2                 4                       193
1819967 1819967 AK     school 200710 45   Southwest Region Schools 20071000573 450120 Twin Hills School   Regular School No Other PK 12 2021   k_12_total                     6.0                             26.0                     6                       26
1819951 1819951 AK     school 200710 45   Southwest Region Schools 20071000338 450110 Togiak School   Regular School No Other PK 12 2021   k_12_total 1.0                   6.0                             220.0 1                   6                       220
1819935 1819935 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12 2021   k_12_total                     6.0                             139.0                     6                       139
1819919 1819919 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12 2021   k_12_total 1.0         0.0         1.0                             113.0 1         0         1                       113
1819903 1819903 AK     school 200710 45   Southwest Region Schools 20071000333 450050 Koliganek School   Regular School No Other PK 12 2021   k_12_total                     2.0                             53.0                     2                       53
1819887 1819887 AK     school 200710 45   Southwest Region Schools 20071000465 450040 William "Sonny" Nelson School   Regular School No Other PK 12 2021   k_12_total     1.0               2.0                             13.0     1               2                       13
1819871 1819871 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12 2021   k_12_total                                                   15.0                                             15
1819855 1819855 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12 2021   k_12_total 1.0                   6.0                             28.0 1                   6                       28
1819839 1819839 AK     school 200700 44   Southeast Island Schools 20070000589 440270 Naukati School   Regular School No Other PK 12 2021   k_12_total 9.0                                                 11.0 9                                           11
1819823 1819823 AK     school 200700 44   Southeast Island Schools 20070000484 440250 Hollis School   Regular School No Other PK 12 2021   k_12_total 7.0   3.0 2.0             2.0                             17.0 7   3 2             2                       17
1819807 1819807 AK     school 200700 44   Southeast Island Schools 20070000322 440230 Port Alexander School   Regular School No Other PK 12 2021   k_12_total 5.0                                                 9.0 5                                           9
1819791 1819791 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12 2021   k_12_total 18.0   1.0                                             19.0 18   1                                       19
1819775 1819775 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12 2021   k_12_total 38.0   1.0 1.0   3.0         16.0                             63.0 38   1 1   3         16                       63
1819759 1819759 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12 2021   k_12_total 12.0                   2.0                             17.0 12                   2                       17
1819743 1819743 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12 2021   k_12_total 8.0         2.0                                       11.0 8         2                                 11
1819727 1819727 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12 2021   k_12_total 104.0   3.0     5.0         13.0                             131.0 104   3     5         13                       131
1819711 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
1819695 1819695 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12 2021   k_12_total 8.0     1.0             2.0                             35.0 8     1             2                       35
1819679 1819679 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   k_12_total 152.0 2.0 19.0 10.0   25.0     3.0   26.0                             306.0 152 2 19 10   25     3   26                       306
1819663 1819663 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12 2021   k_12_total 150.0 2.0 16.0 7.0   32.0     5.0   22.0                             317.0 150 2 16 7   32     5   22                       317
1819647 1819647 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   k_12_total 142.0 5.0 8.0 3.0   21.0     3.0   17.0                             282.0 142 5 8 3   21     3   17                       282
1819631 1819631 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1 2021   k_12_total 70.0   9.0 1.0   7.0     1.0   18.0                             127.0 70   9 1   7     1   18                       127
1819615 1819615 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10 2021   k_12_total                                                   6.0                                             6
1819599 1819599 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12 2021   k_12_total                                                   52.0                                             52
1819583 1819583 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8 2021   k_12_total 64.0 3.0 4.0 3.0   9.0     1.0                                 102.0 64 3 4 3   9     1                           102
1819567 1819567 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12 2021   k_12_total 76.0 2.0 5.0 2.0   7.0     5.0                                 119.0 76 2 5 2   7     5                           119
1819551 1819551 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5 2021   k_12_total 120.0 7.0 8.0 5.0   8.0     5.0   5.0                             205.0 120 7 8 5   8     5   5                       205
1819535 1819535 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12 2021   k_12_total 5.0                   6.0                             11.0 5                   6                       11
1819519 1819519 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12 2021   k_12_total 3.0                   1.0                             25.0 3                   1                       25
1819503 1819503 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12 2021   k_12_total 1.0         1.0     1.0   10.0                             260.0 1         1     1   10                       260
1819487 1819487 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12 2021   k_12_total 21.0 3.0 3.0 1.0   2.0     2.0   27.0                             340.0 21 3 3 1   2     2   27                       340
1819471 1819471 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12 2021   k_12_total                                                   70.0                                             70
1819455 1819455 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12 2021   k_12_total 1.0 1.0   3.0             10.0                             195.0 1 1   3             10                       195
1819439 1819439 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12 2021   k_12_total                                                   147.0                                             147
1819423 1819423 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5 2021   k_12_total 13.0 2.0 3.0     1.0     0.0   32.0                             299.0 13 2 3     1     0   32                       299
1819407 1819407 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12 2021   k_12_total                     1.0                             48.0                     1                       48
1819391 1819391 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12 2021   k_12_total                     3.0                             157.0                     3                       157
1819375 1819375 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12 2021   k_12_total 2.0                   6.0                             116.0 2                   6                       116
1819359 1819359 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12 2021   k_12_total                                                   48.0                                             48
1819343 1819343 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12 2021   k_12_total                                                   171.0                                             171
1819327 1819327 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12 2021   k_12_total                     2.0                             67.0                     2                       67
1819311 1819311 AK     school 200610 36   North Slope Borough Schools 20061000768 369010 Qargi Academy   Regular School Yes High 09 12 2021   k_12_total                     1.0                             18.0                     1                       18
1819295 1819295 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12 2021   k_12_total                 1.0   1.0                             21.0                 1   1                       21
1819279 1819279 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   k_12_total 3.0 2.0   1.0   28.0     15.0   46.0                             269.0 3 2   1   28     15   46                       269
1819263 1819263 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12 2021   k_12_total   1.0                 4.0                             158.0   1                 4                       158
1819247 1819247 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12 2021   k_12_total 4.0                   1.0                             70.0 4                   1                       70
1819231 1819231 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   k_12_total 1.0                   4.0                             106.0 1                   4                       106
1819215 1819215 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12 2021   k_12_total 2.0 1.0                 17.0                             243.0 2 1                 17                       243
1819199 1819199 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12 2021   k_12_total 0.0                   4.0                             156.0 0                   4                       156
1819183 1819183 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12 2021   k_12_total                                                   61.0                                             61
1819167 1819167 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12 2021   k_12_total 6.0 4.0   3.0   48.0     18.0   33.0                             287.0 6 4   3   48     18   33                       287
1819151 1819151 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5 2021   k_12_total 10.0 2.0 0.0 2.0   31.0     27.0   97.0                             478.0 10 2 0 2   31     27   97                       478
1819135 1819135 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   k_12_total                     15.0                             85.0                     15                       85
1819119 1819119 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8 2021   k_12_total 6.0                   22.0                             58.0 6                   22                       58
1819103 1819103 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12 2021   k_12_total 18.0   2.0           2.0   15.0                             63.0 18   2           2   15                       63
1819087 1819087 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 06 12 2021   k_12_total 36.0 1.0 1.0     3.0         62.0                             280.0 36 1 1     3         62                       280
1819071 1819071 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6 2021   k_12_total 18.0   2.0 2.0   2.0     1.0   86.0                             289.0 18   2 2   2     1   86                       289
1819055 1819055 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12 2021   k_12_total 1182.0 43.0 61.0 24.0   37.0     30.0   202.0                             1724.0 1182 43 61 24   37     30   202                       1724
1819039 1819039 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12 2021   k_12_total 43.0 1.0       1.0         16.0                             119.0 43 1       1         16                       119
1819023 1819023 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 254.0 1.0 15.0 2.0   2.0         51.0                             352.0 254 1 15 2   2         51                       352
1819007 1819007 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8 2021   k_12_total 203.0 3.0 56.0 1.0         3.0   33.0                             310.0 203 3 56 1         3   33                       310
1818991 1818991 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12 2021   k_12_total 473.0 1.0 29.0 2.0   4.0     1.0   39.0                             564.0 473 1 29 2   4     1   39                       564

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