Data source: Big Local News · About: Big Local

995 rows where grade = "kindergarten" and state = "AK" sorted by school_state_id descending

View and edit SQL

year

grade

  • kindergarten · 895
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
1819792 AK     school 200700 44   Southeast Island Schools 20070000526 440190 Whale Pass School   Regular School No Other PK 12 2021   kindergarten 1.0   0.0                                             1.0 1   0                                       1
1737441 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12.0 2020   kindergarten 1.0 0.0 0.0     0.0         0.0                             1 1 0 0     0         0                       1
1819776 AK     school 200700 44   Southeast Island Schools 20070000326 440160 Thorne Bay School   Regular School No Other PK 12 2021   kindergarten 7.0   0.0 1.0   0.0         3.0                             12.0 7   0 1   0         3                       12
1737425 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   0.0                             0 0                   0                       0
1819760 AK     school 200700 44   Southeast Island Schools 20070000319 440090 Barry Craig Stewart Kasaan School   Regular School No Other PK 12 2021   kindergarten 3.0                   0.0                             4.0 3                   0                       4
1737409 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12.0 2020   kindergarten 1.0         0.0                                       1 1         0                                 1
1819744 AK     school 200700 44   Southeast Island Schools 20070000314 440020 Howard Valentine Coffman Cove School   Regular School No Other PK 12 2021   kindergarten 1.0         0.0                                       1.0 1         0                                 1
1737393 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12.0 2020   kindergarten 6.0   0.0     1.0         1.0                             8 6   0     1         1                       8
1819728 AK     school 200690 43   Skagway Schools 20069000310 430010 Skagway School   Regular School No Other PK 12 2021   kindergarten 10.0   0.0     0.0         0.0                             12.0 10   0     0         0                       12
1737377 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12.0 2020   kindergarten 4.0 0.0 0.0     0.0         0.0                             5 4 0 0     0         0                       5
1819712 AK     school 200240 42   Sitka Borough Schools 20024000142 428010 Sitka REACH   Regular School No Other KG 12 2021   kindergarten 5.0   1.0 0.0   0.0         4.0                             10.0 5   1 0   0         4                       10
1737361 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12.0 2020   kindergarten 0.0   0.0 0.0             0.0                             0 0   0 0             0                       0
1819696 AK     school 200240 42   Sitka Borough Schools 20024000035 427010 Pacific High School   Alternative School No High 09 12 2021   kindergarten 0.0     0.0             0.0                             0.0 0     0             0                       0
1737345 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819680 AK     school 200240 42   Sitka Borough Schools 20024000638 420170 Keet Gooshi Heen Elementary   Regular School No Elementary 02 5 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1737329 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819664 AK     school 200240 42   Sitka Borough Schools 20024000143 420130 Sitka High School   Regular School No High 09 12 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1737313 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819648 AK     school 200240 42   Sitka Borough Schools 20024000136 420020 Blatchley Middle School   Regular School No Middle 06 8 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1737297 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1.0 2020   kindergarten 46.0   2.0 0.0   7.0     1.0   8.0                             83 46   2 0   7     1   8                       83
1819632 AK     school 200240 42   Sitka Borough Schools 20024000135 420010 Baranof Elementary   Regular School No Elementary PK 1 2021   kindergarten 37.0   6.0 1.0   0.0     0.0   11.0                             62.0 37   6 1   0     0   11                       62
1737281 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10.0 2020   kindergarten                                                   1                                             1
1819616 AK     school 200670 40   Pribilof Schools 20067000762 408010 Pribilof Correspondence School   Regular School No Other KG 10 2021   kindergarten                                                   0.0                                             0
1737265 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12.0 2020   kindergarten     0.0 0.0                                           8     0 0                                     8
1819600 AK     school 200670 40   Pribilof Schools 20067000308 400020 St Paul School   Regular School No Other PK 12 2021   kindergarten                                                   5.0                                             5
1737249 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8.0 2020   kindergarten 0.0 0.0 0.0     0.0     0.0   0.0                             0 0 0 0     0     0   0                       0
1819584 AK     school 200660 39   Petersburg Borough Schools 20066000604 390030 Mitkof Middle School   Regular School No Middle 06 8 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0                                 0.0 0 0 0 0   0     0                           0
1737233 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819568 AK     school 200660 39   Petersburg Borough Schools 20066000570 390020 Petersburg High School   Regular School No High 09 12 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0                                 0.0 0 0 0 0   0     0                           0
1737217 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 25.0 1.0 2.0 1.0   0.0     1.0   0.0                             45 25 1 2 1   0     1   0                       45
1819552 AK     school 200660 39   Petersburg Borough Schools 20066000305 390010 Rae C. Stedman Elementary   Regular School No Elementary PK 5 2021   kindergarten 26.0 1.0 0.0 1.0   1.0     1.0   2.0                             37.0 26 1 0 1   1     1   2                       37
1737201 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12.0 2020   kindergarten 0.0                   1.0                             2 0                   1                       2
1819536 AK     school 200630 38   Pelican City Schools 20063000304 380010 Pelican School   Regular School No Other KG 12 2021   kindergarten 1.0                   0.0                             1.0 1                   0                       1
1737185 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12.0 2020   kindergarten       0.0             0.0                             0       0             0                       0
1819520 AK     school 200625 37   Northwest Arctic Borough Schools 20062500748 378020 NWABSD Home School   Regular School No Other KG 12 2021   kindergarten 0.0                   0.0                             1.0 0                   0                       1
1737169 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12.0 2020   kindergarten                 1.0   0.0                             17                 1   0                       17
1819504 AK     school 200625 37   Northwest Arctic Borough Schools 20062500394 370210 Davis-Ramoth School   Regular School No Other PK 12 2021   kindergarten 0.0         0.0     0.0   4.0                             26.0 0         0     0   4                       26
1737153 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12.0 2020   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0 0 0 0 0   0     0   0                       0
1819488 AK     school 200625 37   Northwest Arctic Borough Schools 20062500569 370150 Kotzebue Middle/High School   Regular School No High 06 12 2021   kindergarten 0.0 0.0 0.0 0.0   0.0     0.0   0.0                             0.0 0 0 0 0   0     0   0                       0
1737137 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12.0 2020   kindergarten                                                   4                                             4
1819472 AK     school 200625 37   Northwest Arctic Borough Schools 20062500303 370110 Shungnak School   Regular School No Other PK 12 2021   kindergarten                                                   6.0                                             6
1737121 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12.0 2020   kindergarten 0.0 0.0   0.0             2.0                             15 0 0   0             2                       15
1819456 AK     school 200625 37   Northwest Arctic Borough Schools 20062500302 370100 Aqqaluk High/Noorvik Elementary   Regular School No Other PK 12 2021   kindergarten 0.0 0.0   0.0             3.0                             17.0 0 0   0             3                       17
1737105 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12.0 2020   kindergarten 1.0                                                 13 1                                           13
1819440 AK     school 200625 37   Northwest Arctic Borough Schools 20062500301 370090 Napaaqtugmiut School   Regular School No Other PK 12 2021   kindergarten                                                   8.0                                             8
1737089 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 1.0 0.0 0.0               6.0                             46 1 0 0               6                       46
1819424 AK     school 200625 37   Northwest Arctic Borough Schools 20062500298 370080 June Nelson Elementary   Regular School No Elementary PK 5 2021   kindergarten 3.0 0.0 1.0     0.0     0.0   3.0                             38.0 3 0 1     0     0   3                       38
1737073 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12.0 2020   kindergarten                     1.0                             5                     1                       5
1819408 AK     school 200625 37   Northwest Arctic Borough Schools 20062500297 370070 Kobuk School   Regular School No Other PK 12 2021   kindergarten                     0.0                             5.0                     0                       5
1737057 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12.0 2020   kindergarten                     1.0                             18                     1                       18
1819392 AK     school 200625 37   Northwest Arctic Borough Schools 20062500300 370060 McQueen School   Regular School No Other PK 12 2021   kindergarten                     0.0                             8.0                     0                       8
1737041 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12.0 2020   kindergarten 1.0                   2.0                             10 1                   2                       10
1819376 AK     school 200625 37   Northwest Arctic Borough Schools 20062500295 370040 Kiana School   Regular School No Other PK 12 2021   kindergarten 0.0                   1.0                             7.0 0                   1                       7
1737025 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12.0 2020   kindergarten                     0.0                             8                     0                       8
1819360 AK     school 200625 37   Northwest Arctic Borough Schools 20062500294 370030 Deering School   Regular School No Other PK 12 2021   kindergarten                                                   2.0                                             2
1737009 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12.0 2020   kindergarten     0.0                                             14     0                                       14
1819344 AK     school 200625 37   Northwest Arctic Borough Schools 20062500293 370020 Buckland School   Regular School No Other PK 12 2021   kindergarten                                                   16.0                                             16
1736993 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12.0 2020   kindergarten                     1.0                             6                     1                       6
1819328 AK     school 200625 37   Northwest Arctic Borough Schools 20062500292 370010 Ambler School   Regular School No Other PK 12 2021   kindergarten                     0.0                             5.0                     0                       5
1819312 AK     school 200610 36   North Slope Borough Schools 20061000768 369010 Qargi Academy   Regular School Yes High 09 12 2021   kindergarten                     0.0                             0.0                     0                       0
1736977 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12.0 2020   kindergarten 0.0     0.0         0.0   0.0                             0 0     0         0   0                       0
1819296 AK     school 200610 36   North Slope Borough Schools 20061000470 367010 Kiita Learning Community   Alternative School No High 09 12 2021   kindergarten                 0.0   0.0                             0.0                 0   0                       0
1736961 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8.0 2020   kindergarten 0.0 0.0   0.0   0.0     0.0   0.0                             0 0 0   0   0     0   0                       0
1819280 AK     school 200610 36   North Slope Borough Schools 20061000139 360120 Eben Hopson Middle School   Regular School No Middle 06 8 2021   kindergarten 0.0 0.0   0.0   0.0     0.0   0.0                             0.0 0 0   0   0     0   0                       0
1736945 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12.0 2020   kindergarten   0.0                 0.0                             9   0                 0                       9
1819264 AK     school 200610 36   North Slope Borough Schools 20061000291 360100 Alak School   Regular School No Other PK 12 2021   kindergarten   0.0                 1.0                             6.0   0                 1                       6
1736929 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12.0 2020   kindergarten 1.0                   0.0                             7 1                   0                       7
1819248 AK     school 200610 36   North Slope Borough Schools 20061000284 360090 Meade River School   Regular School No Other PK 12 2021   kindergarten 0.0                   1.0                             7.0 0                   1                       7
1736913 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12.0 2020   kindergarten                     1.0                             11                     1                       11
1819232 AK     school 200610 36   North Slope Borough Schools 20061000290 360070 Kali School   Regular School No Other PK 12 2021   kindergarten 0.0                   2.0                             8.0 0                   2                       8
1736897 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12.0 2020   kindergarten 0.0 0.0       0.0         2.0                             21 0 0       0         2                       21
1819216 AK     school 200610 36   North Slope Borough Schools 20061000289 360060 Tikigaq School   Regular School No Other PK 12 2021   kindergarten 1.0 0.0                 1.0                             13.0 1 0                 1                       13
1736881 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12.0 2020   kindergarten                     0.0                             11                     0                       11
1819200 AK     school 200610 36   North Slope Borough Schools 20061000288 360050 Nuiqsut Trapper School   Regular School No Other PK 12 2021   kindergarten 0.0                   0.0                             16.0 0                   0                       16
1736865 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 8 0                                           8
1819184 AK     school 200610 36   North Slope Borough Schools 20061000287 360040 Harold Kaveolook School   Regular School No Other PK 12 2021   kindergarten                                                   7.0                                             7
1736849 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12.0 2020   kindergarten 0.0 0.0   0.0   0.0     0.0   0.0                             0 0 0   0   0     0   0                       0
1819168 AK     school 200610 36   North Slope Borough Schools 20061000286 360030 Barrow High School   Regular School No High 09 12 2021   kindergarten 0.0 0.0   0.0   0.0     0.0   0.0                             0.0 0 0   0   0     0   0                       0
1736833 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 5.0 1.0 1.0 1.0   2.0     5.0   21.0                             87 5 1 1 1   2     5   21                       87
1819152 AK     school 200610 36   North Slope Borough Schools 20061000285 360020 Fred Ipalook Elementary   Regular School No Elementary PK 5 2021   kindergarten 1.0 0.0 0.0 0.0   4.0     6.0   18.0                             70.0 1 0 0 0   4     6   18                       70
1736817 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   2.0                             8 0                   2                       8
1819136 AK     school 200610 36   North Slope Borough Schools 20061000283 360010 Nunamiut School   Regular School No Other PK 12 2021   kindergarten                     2.0                             7.0                     2                       7
1736801 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8.0 2020   kindergarten 0.0         0.0         0.0                             0 0         0         0                       0
1819120 AK     school 200570 35   Nome Public Schools 20057000323 359010 Anvil City Science Academy   Regular School Yes Middle 05 8 2021   kindergarten 0.0                   0.0                             0.0 0                   0                       0
1736785 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12.0 2020   kindergarten 0.0   0.0                                             0 0   0                                       0
1819104 AK     school 200570 35   Nome Public Schools 20057000426 358010 Extensions Correspondence   Regular School No Other KG 12 2021   kindergarten 1.0   1.0           0.0   2.0                             7.0 1   1           0   2                       7
1736769 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 07 12.0 2020   kindergarten 0.0 0.0 0.0     0.0     0.0   0.0                             0 0 0 0     0     0   0                       0
1819088 AK     school 200570 35   Nome Public Schools 20057000568 350020 Nome-Beltz Middle/High   Regular School No High 06 12 2021   kindergarten 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1736753 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 6.0 1.0 0.0 0.0         0.0   22.0                             60 6 1 0 0         0   22                       60
1819072 AK     school 200570 35   Nome Public Schools 20057000254 350010 Nome Elementary   Regular School No Elementary PK 6 2021   kindergarten 5.0   1.0 0.0   1.0     0.0   27.0                             62.0 5   1 0   1     0   27                       62
1736737 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12.0 2020   kindergarten 84.0 1.0 2.0 0.0   1.0     1.0   8.0                             102 84 1 2 0   1     1   8                       102
1819056 AK     school 200540 34   Nenana City Schools 20054000321 348010 CyberLynx Correspondence Program   Regular School No Other PK 12 2021   kindergarten 100.0 1.0 3.0 1.0   3.0     3.0   11.0                             130.0 100 1 3 1   3     3   11                       130
1736721 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12.0 2020   kindergarten 5.0 0.0 0.0     0.0         0.0                             6 5 0 0     0         0                       6
1819040 AK     school 200540 34   Nenana City Schools 20054000251 340010 Nenana City School   Regular School No Other KG 12 2021   kindergarten 3.0 0.0       0.0         0.0                             4.0 3 0       0         0                       4
1736705 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8.0 2020   kindergarten 47.0 0.0 3.0 1.0   0.0         7.0                             61 47 0 3 1   0         7                       61
1819024 AK     school 200510 33   Mat-Su Borough Schools 20051000744 339050 Birchtree Charter School   Regular School Yes Elementary KG 8 2021   kindergarten 44.0 0.0 2.0 0.0   1.0         6.0                             57.0 44 0 2 0   1         6                       57
1736689 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8.0 2020   kindergarten 27.0 0.0 11.0 0.0         0.0   3.0                             44 27 0 11 0         0   3                       44
1819008 AK     school 200510 33   Mat-Su Borough Schools 20051000740 339040 Fronteras Charter School   Regular School Yes Elementary KG 8 2021   kindergarten 34.0 0.0 7.0 0.0         1.0   2.0                             44.0 34 0 7 0         1   2                       44
1736673 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12.0 2020   kindergarten 37.0 0.0 4.0 0.0   0.0     0.0   1.0                             42 37 0 4 0   0     0   1                       42
1818992 AK     school 200510 33   Mat-Su Borough Schools 20051000469 339030 Twindly Bridge Charter School   Regular School Yes Other KG 12 2021   kindergarten 51.0 0.0 4.0 0.0   0.0     0.0   5.0                             62.0 51 0 4 0   0     0   5                       62

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