enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_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
1820577 1820577 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   pk_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1820561 1820561 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12 2021   pk_12_total 3.0                   1.0                             11.0 3                   1                       11
1820545 1820545 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   pk_12_total 1.0                   3.0                             17.0 1                   3                       17
1820529 1820529 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12 2021   pk_12_total 15.0   2.0     9.0     7.0   9.0                             117.0 15   2     9     7   9                       117
1820513 1820513 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12 2021   pk_12_total 6.0         2.0                                       83.0 6         2                                 83
1820497 1820497 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 332.0 1                                           332
1820481 1820481 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   pk_12_total                     2.0                             214.0                     2                       214
1820465 1820465 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12 2021   pk_12_total   2.0                 2.0                             144.0   2                 2                       144
1820449 1820449 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   pk_12_total 4.0                                                 148.0 4                                           148
1820433 1820433 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12 2021   pk_12_total 1.0                   2.0                             30.0 1                   2                       30
1820417 1820417 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12 2021   pk_12_total 2500.0 108.0 205.0 67.0   68.0     79.0   450.0                             4035.0 2500 108 205 67   68     79   450                       4035
1820401 1820401 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12 2021   pk_12_total                                                   16.0                                             16
1820385 1820385 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12 2021   pk_12_total 2.0     2.0                                           33.0 2     2                                     33
1820369 1820369 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       42.0           1                                 42
1820353 1820353 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12 2021   pk_12_total 3.0     1.0             1.0                             48.0 3     1             1                       48
1820337 1820337 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8 2021   pk_12_total                                                   14.0                                             14
1820321 1820321 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12 2021   pk_12_total                                                   26.0                                             26
1820305 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
1820289 1820289 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12 2021   pk_12_total 2.0                                                 20.0 2                                           20
1820273 1820273 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       23.0           1                                 23
1820257 1820257 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12 2021   pk_12_total                                                   8.0                                             8
1820241 1820241 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 88.0 1                                           88
1820225 1820225 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12 2021   pk_12_total                                                   48.0                                             48
1820209 1820209 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 18.0 1                                           18
1820193 1820193 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12 2021   pk_12_total   1.0                                               10.0   1                                         10
1820177 1820177 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   pk_12_total                                                   36.0                                             36
1820161 1820161 AK     school 200840 50   Yakutat City Schools 20084000749 508010 LEAD Correspondence   Regular School No Other KG 12 2021   pk_12_total 18.0                   2.0                             25.0 18                   2                       25
1820145 1820145 AK     school 200840 50   Yakutat City Schools 20084000667 500010 Yakutat School   Regular School No Other PK 12 2021   pk_12_total 6.0   4.0     2.0         3.0                             68.0 6   4     2         3                       68
1820129 1820129 AK     school 200810 49   Wrangell City Schools 20081000728 490030 Stikine Middle School   Regular School No Middle 06 8 2021   pk_12_total 26.0     2.0   1.0         5.0                             52.0 26     2   1         5                       52
1820113 1820113 AK     school 200810 49   Wrangell City Schools 20081000576 490020 Wrangell High School   Regular School No High 09 12 2021   pk_12_total 22.0   2.0 7.0   2.0                                       57.0 22   2 7   2                                 57
1820097 1820097 AK     school 200810 49   Wrangell City Schools 20081000373 490010 Evergreen Elementary   Regular School No Elementary PK 5 2021   pk_12_total 34.0   1.0 1.0   1.0         8.0                             74.0 34   1 1   1         8                       74
1820081 1820081 AK     school 200780 48   Valdez City Schools 20078000753 488010 Valdez Home School   Regular School No Other PK 12 2021   pk_12_total 86.0   1.0     3.0         20.0                             114.0 86   1     3         20                       114
1820065 1820065 AK     school 200780 48   Valdez City Schools 20078000495 480050 Hermon Hutchens Elementary   Regular School No Elementary PK 5 2021   pk_12_total 188.0 3.0 10.0 4.0   1.0     2.0   55.0                             285.0 188 3 10 4   1     2   55                       285
1820049 1820049 AK     school 200780 48   Valdez City Schools 20078000367 480040 George H. Gilson Middle School   Regular School No Middle 06 8 2021   pk_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
1820033 1820033 AK     school 200780 48   Valdez City Schools 20078000370 480030 Valdez High School   Regular School No High 09 12 2021   pk_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
1820017 1820017 AK     school 200720 47   Unalaska City Schools 20072000661 470020 Unalaska Jr/Sr High School   Regular School No High 07 12 2021   pk_12_total 31.0   19.0 2.0   87.0     7.0                                 161.0 31   19 2   87     7                           161
1820001 1820001 AK     school 200720 47   Unalaska City Schools 20072000340 470010 Eagle's View Elementary School   Regular School No Elementary PK 6 2021   pk_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
1819985 1819985 AK     school 200680 46   Saint Mary's Schools 20068000659 460010 Saint Mary's School   Regular School No Other PK 12 2021   pk_12_total   2.0                 4.0                             216.0   2                 4                       216
1819969 1819969 AK     school 200710 45   Southwest Region Schools 20071000573 450120 Twin Hills School   Regular School No Other PK 12 2021   pk_12_total                     7.0                             28.0                     7                       28
1819953 1819953 AK     school 200710 45   Southwest Region Schools 20071000338 450110 Togiak School   Regular School No Other PK 12 2021   pk_12_total 1.0                   7.0                             227.0 1                   7                       227
1819937 1819937 AK     school 200710 45   Southwest Region Schools 20071000336 450080 Chief Ivan Blunka School   Regular School No Other PK 12 2021   pk_12_total                     7.0                             153.0                     7                       153
1819921 1819921 AK     school 200710 45   Southwest Region Schools 20071000335 450070 Manokotak School   Regular School No Other PK 12 2021   pk_12_total 1.0         1.0         3.0                             124.0 1         1         3                       124
1819905 1819905 AK     school 200710 45   Southwest Region Schools 20071000333 450050 Koliganek School   Regular School No Other PK 12 2021   pk_12_total                     2.0                             60.0                     2                       60
1819889 1819889 AK     school 200710 45   Southwest Region Schools 20071000465 450040 William "Sonny" Nelson School   Regular School No Other PK 12 2021   pk_12_total     1.0               2.0                             13.0     1               2                       13
1819873 1819873 AK     school 200710 45   Southwest Region Schools 20071000331 450030 Clarks Point School   Regular School No Other KG 12 2021   pk_12_total                                                   15.0                                             15
1819857 1819857 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12 2021   pk_12_total 1.0                   7.0                             32.0 1                   7                       32
1819841 1819841 AK     school 200700 44   Southeast Island Schools 20070000589 440270 Naukati School   Regular School No Other PK 12 2021   pk_12_total 9.0                                                 11.0 9                                           11
1819825 1819825 AK     school 200700 44   Southeast Island Schools 20070000484 440250 Hollis School   Regular School No Other PK 12 2021   pk_12_total 8.0   3.0 3.0             2.0                             19.0 8   3 3             2                       19
1819809 1819809 AK     school 200700 44   Southeast Island Schools 20070000322 440230 Port Alexander School   Regular School No Other PK 12 2021   pk_12_total 5.0                                                 9.0 5                                           9
1819793 1819793 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12 2021   pk_12_total 19.0   1.0                                             20.0 19   1                                       20
1819777 1819777 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12 2021   pk_12_total 39.0   1.0 1.0   3.0         16.0                             64.0 39   1 1   3         16                       64
1819761 1819761 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12 2021   pk_12_total 12.0                   2.0                             17.0 12                   2                       17
1819745 1819745 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12 2021   pk_12_total 10.0         2.0                                       13.0 10         2                                 13
1819729 1819729 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12 2021   pk_12_total 114.0   4.0     6.0         14.0                             144.0 114   4     6         14                       144
1819713 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
1819697 1819697 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12 2021   pk_12_total 8.0     1.0             2.0                             35.0 8     1             2                       35
1819681 1819681 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   pk_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
1819665 1819665 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12 2021   pk_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
1819649 1819649 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   pk_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
1819633 1819633 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1 2021   pk_12_total 79.0   9.0 2.0   8.0     1.0   20.0                             144.0 79   9 2   8     1   20                       144
1819617 1819617 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10 2021   pk_12_total                                                   6.0                                             6
1819601 1819601 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12 2021   pk_12_total                                                   59.0                                             59
1819585 1819585 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8 2021   pk_12_total 64.0 3.0 4.0 3.0   9.0     1.0                                 102.0 64 3 4 3   9     1                           102
1819569 1819569 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12 2021   pk_12_total 76.0 2.0 5.0 2.0   7.0     5.0                                 119.0 76 2 5 2   7     5                           119
1819553 1819553 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5 2021   pk_12_total 122.0 7.0 9.0 5.0   8.0     5.0   5.0                             209.0 122 7 9 5   8     5   5                       209
1819537 1819537 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12 2021   pk_12_total 5.0                   6.0                             11.0 5                   6                       11
1819521 1819521 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12 2021   pk_12_total 3.0                   1.0                             25.0 3                   1                       25
1819505 1819505 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12 2021   pk_12_total 1.0         1.0     1.0   10.0                             272.0 1         1     1   10                       272
1819489 1819489 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12 2021   pk_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
1819473 1819473 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12 2021   pk_12_total                                                   76.0                                             76
1819457 1819457 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12 2021   pk_12_total 1.0 1.0   3.0             10.0                             203.0 1 1   3             10                       203
1819441 1819441 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12 2021   pk_12_total                                                   154.0                                             154
1819425 1819425 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5 2021   pk_12_total 15.0 3.0 3.0     1.0     1.0   37.0                             336.0 15 3 3     1     1   37                       336
1819409 1819409 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12 2021   pk_12_total                     1.0                             48.0                     1                       48
1819393 1819393 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12 2021   pk_12_total                     3.0                             162.0                     3                       162
1819377 1819377 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12 2021   pk_12_total 2.0                   6.0                             123.0 2                   6                       123
1819361 1819361 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12 2021   pk_12_total                                                   53.0                                             53
1819345 1819345 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12 2021   pk_12_total                                                   187.0                                             187
1819329 1819329 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12 2021   pk_12_total                     2.0                             71.0                     2                       71
1819313 1819313 AK     school 200610 36   North Slope Borough Schools 20061000768 369010 Qargi Academy   Regular School Yes High 09 12 2021   pk_12_total                     1.0                             18.0                     1                       18
1819297 1819297 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12 2021   pk_12_total                 1.0   1.0                             21.0                 1   1                       21
1819281 1819281 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   pk_12_total 3.0 2.0   1.0   28.0     15.0   46.0                             269.0 3 2   1   28     15   46                       269
1819265 1819265 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12 2021   pk_12_total   1.0                 4.0                             168.0   1                 4                       168
1819249 1819249 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12 2021   pk_12_total 4.0                   1.0                             80.0 4                   1                       80
1819233 1819233 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   pk_12_total 1.0                   4.0                             117.0 1                   4                       117
1819217 1819217 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12 2021   pk_12_total 4.0 1.0                 17.0                             263.0 4 1                 17                       263
1819201 1819201 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12 2021   pk_12_total 1.0                   4.0                             169.0 1                   4                       169
1819185 1819185 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12 2021   pk_12_total                                                   62.0                                             62
1819169 1819169 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12 2021   pk_12_total 6.0 4.0   3.0   48.0     18.0   33.0                             287.0 6 4   3   48     18   33                       287
1819153 1819153 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5 2021   pk_12_total 14.0 2.0 1.0 4.0   39.0     32.0   120.0                             590.0 14 2 1 4   39     32   120                       590
1819137 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
1819121 1819121 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8 2021   pk_12_total 6.0                   22.0                             58.0 6                   22                       58
1819105 1819105 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12 2021   pk_12_total 18.0   2.0           2.0   15.0                             63.0 18   2           2   15                       63
1819089 1819089 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 06 12 2021   pk_12_total 36.0 1.0 1.0     3.0         62.0                             280.0 36 1 1     3         62                       280
1819073 1819073 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6 2021   pk_12_total 18.0   2.0 2.0   2.0     1.0   86.0                             290.0 18   2 2   2     1   86                       290
1819057 1819057 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12 2021   pk_12_total 1249.0 45.0 64.0 25.0   37.0     32.0   208.0                             1810.0 1249 45 64 25   37     32   208                       1810
1819041 1819041 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12 2021   pk_12_total 43.0 1.0       1.0         16.0                             119.0 43 1       1         16                       119
1819025 1819025 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8 2021   pk_12_total 254.0 1.0 15.0 2.0   2.0         51.0                             352.0 254 1 15 2   2         51                       352
1819009 1819009 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8 2021   pk_12_total 203.0 3.0 56.0 1.0         3.0   33.0                             310.0 203 3 56 1         3   33                       310
1818993 1818993 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12 2021   pk_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]);