Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • kindergarten · 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
1734993 AK     school 200480 28   Kodiak Island Borough Schools 20048000435 288010 AKTEACH   Regular School No Other KG 12.0 2020   kindergarten 1.0 0.0 0.0     1.0     0.0   1.0                             3 1 0 0     1     0   1                       3
1817280 AK     school 200480 28   Kodiak Island Borough Schools 20048000435 288010 AKTEACH   Regular School No Other KG 12 2021   kindergarten 22.0   2.0     2.0         0.0                             31.0 22   2     2         0                       31
1731585 AK     school 200180 5   Anchorage Schools 20018000714 50980 AVAIL School   Alternative 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
1730529 AK     school 200180 5   Anchorage Schools 20018000053 50010 Abbott Loop Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 12.0 0.0 1.0     3.0     10.0   7.0                             35 12 0 1     3     10   7                       35
1812864 AK     school 200180 5   Anchorage Schools 20018000053 50010 Abbott Loop Elementary   Regular School No Elementary PK 6 2021   kindergarten 6.0 1.0 4.0     6.0     2.0   10.0                             33.0 6 1 4     6     2   10                       33
1736641 AK     school 200510 33   Mat-Su Borough Schools 20051000311 339010 Academy Charter School   Regular School Yes Elementary KG 8.0 2020   kindergarten 22.0   1.0 0.0   1.0     0.0   2.0                             26 22   1 0   1     0   2                       26
1818960 AK     school 200510 33   Mat-Su Borough Schools 20051000311 339010 Academy Charter School   Regular School Yes Elementary KG 8 2021   kindergarten 22.0   1.0     1.0     0.0   2.0                             26.0 22   1     1     0   2                       26
1730513 AK     school 200010 4   Aleutian Region Schools 20001000080 40080 Adak School   Regular School No Other PK 12.0 2020   kindergarten 0.0   0.0     0.0     1.0                                 1 0   0     0     1                           1
1812848 AK     school 200010 4   Aleutian Region Schools 20001000080 40080 Adak School   Regular School No Other KG 12 2021   kindergarten 1.0   0.0     0.0     0.0                                 1.0 1   0     0     0                           1
1730545 AK     school 200180 5   Anchorage Schools 20018000054 50020 Airport Heights Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 4.0 0.0 5.0 0.0   7.0     5.0   13.0                             39 4 0 5 0   7     5   13                       39
1812880 AK     school 200180 5   Anchorage Schools 20018000054 50020 Airport Heights Elementary   Regular School No Elementary PK 6 2021   kindergarten 3.0 3.0 7.0     7.0     3.0   6.0                             33.0 3 3 7     7     3   6                       33
1734817 AK     school 200480 28   Kodiak Island Borough Schools 20048000180 280010 Akhiok School   Regular School No Other KG 12.0 2020   kindergarten   0.0                 0.0                             2   0                 0                       2
1817104 AK     school 200480 28   Kodiak Island Borough Schools 20048000180 280010 Akhiok School   Regular School No Other KG 12 2021   kindergarten   0.0                 0.0                             0.0   0                 0                       0
1738161 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   kindergarten 0.0                   1.0                             27 0                   1                       27
1820480 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   kindergarten                     0.0                             16.0                     0                       16
1738129 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   kindergarten 1.0                                                 18 1                                           18
1820448 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   kindergarten 0.0                                                 16.0 0                                           16
1735697 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 11 0                                           11
1817984 AK     school 200001 31   Lower Kuskokwim Schools 20000100619 310240 Akiuk Memorial School   Regular School No Other PK 12 2021   kindergarten                                                   7.0                                             7
1735489 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 9 0                                           9
1817776 AK     school 200001 31   Lower Kuskokwim Schools 20000100391 310110 Akula Elitnaurvik School   Regular School No Other PK 12 2021   kindergarten 0.0                                                 5.0 0                                           5
1738225 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   1.0                             3 0                   1                       3
1820544 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   kindergarten 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
1735809 AK     school 200003 32   Lower Yukon Schools 20000300216 320010 Alakanuk School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 20 0                                           20
1818112 AK     school 200003 32   Lower Yukon Schools 20000300216 320010 Alakanuk School   Regular School No Other PK 12 2021   kindergarten 0.0                   1.0                             18.0 0                   1                       18
1732801 AK     school 200100 14   Delta/Greely Schools 20010000599 148010 Alaska Homeschool   Regular School No Other KG 12.0 2020   kindergarten 6.0   0.0               0.0                             6 6   0               0                       6
1815104 AK     school 200100 14   Delta/Greely Schools 20010000599 148010 Alaska Homeschool   Regular School No Other PK 12 2021   kindergarten 18.0 0.0 2.0 0.0             1.0                             21.0 18 0 2 0             1                       21
1731921 AK     school 200180 5   Anchorage Schools 20018000763 57230 Alaska Middle College School   Regular School No High 11 12.0 2020   kindergarten 0.0 0.0 0.0     0.0     0.0   0.0                             0 0 0 0     0     0   0                       0
1814240 AK     school 200180 5   Anchorage Schools 20018000763 57230 Alaska Middle College School   Regular School No High 11 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
1732033 AK     school 200180 5   Anchorage Schools 20018000736 59100 Alaska Native Cultural Charter School   Regular School Yes Elementary PK 8.0 2020   kindergarten 2.0 0.0 6.0 1.0   0.0         11.0                             35 2 0 6 1   0         11                       35
1814352 AK     school 200180 5   Anchorage Schools 20018000736 59100 Alaska Native Cultural Charter School   Regular School Yes Elementary PK 8 2021   kindergarten 0.0 0.0 3.0 0.0   1.0     0.0   8.0                             29.0 0 0 3 0   1     0   8                       29
1730481 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   kindergarten 5.0   0.0     0.0         0.0                             6 5   0     0         0                       6
1812816 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12 2021   kindergarten 5.0   0.0     0.0         1.0                             7.0 5   0     0         1                       7
1731809 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12.0 2020   kindergarten 3.0 1.0 0.0     0.0         0.0                             4 3 1 0     0         0                       4
1814128 AK     school 200180 5   Anchorage Schools 20018000341 57010 Alaska State School for Deaf and Hard of Hearing   Special Education School No Other PK 12 2021   kindergarten 0.0 0.0 0.0     0.0         0.0                             0.0 0 0 0     0         0                       0
1737537 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12.0 2020   kindergarten     0.0               0.0                             4     0               0                       4
1819856 AK     school 200710 45   Southwest Region Schools 20071000330 450020 Aleknagik School   Regular School No Other PK 12 2021   kindergarten 0.0                   1.0                             5.0 0                   1                       5
1737953 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 1 0                                           1
1820272 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   kindergarten           0.0                                       2.0           0                                 2
1731617 AK     school 200180 5   Anchorage Schools 20018000104 51000 Alpenglow Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 45.0 3.0 6.0 0.0   0.0         9.0                             66 45 3 6 0   0         9                       66
1813936 AK     school 200180 5   Anchorage Schools 20018000104 51000 Alpenglow Elementary   Regular School No Elementary PK 6 2021   kindergarten 19.0 0.0 9.0 1.0   0.0         2.0                             31.0 19 0 9 1   0         2                       31
1733281 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000325 167010 Alternative Learning Systems   Alternative School No Other PK 12.0 2020   kindergarten 0.0 0.0 0.0     0.0         0.0                             0 0 0 0     0         0                       0
1815568 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000325 167010 Alternative Learning Systems   Alternative School No Other PK 12 2021   kindergarten 1.0 0.0 0.0 0.0   0.0     0.0   0.0                             1.0 1 0 0 0   0     0   0                       1
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
1736577 AK     school 200510 33   Mat-Su Borough Schools 20051000452 337050 American Charter Academy   Regular School Yes Other KG 12.0 2020   kindergarten 17.0 0.0 0.0 1.0   1.0     0.0   1.0                             20 17 0 0 1   1     0   1                       20
1818896 AK     school 200510 33   Mat-Su Borough Schools 20051000452 337050 American Charter Academy   Regular School Yes Other KG 12 2021   kindergarten 14.0 0.0 1.0 0.0   0.0     0.0   0.0                             15.0 14 0 1 0   0     0   0                       15
1732065 AK     school 200180 5   Anchorage Schools 20018000760 59120 Anchorage STrEaM Academy   Regular School Yes 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
1814384 AK     school 200180 5   Anchorage Schools 20018000760 59120 Anchorage STrEaM Academy   Regular School Yes 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
1732929 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000256 160080 Anderson Elementary   Regular School No Elementary PK 2.0 2020   kindergarten 52.0 1.0 16.0 0.0   0.0     0.0   7.0                             76 52 1 16 0   0     0   7                       76
1815232 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000256 160080 Anderson Elementary   Regular School No Elementary PK 2 2021   kindergarten 46.0 7.0 6.0 0.0   1.0     0.0   7.0                             67.0 46 7 6 0   1     0   7                       67
1730305 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other KG 12.0 2020   kindergarten 4.0 0.0 0.0 1.0                                           5 4 0 0 1                                     5
1812640 AK     school 200770 2   Denali Borough Schools 20077000354 20010 Anderson School   Regular School No Other PK 12 2021   kindergarten 3.0   0.0 0.0   0.0         1.0                             4.0 3   0 0   0         1                       4
1738049 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12.0 2020   kindergarten 0.0     0.0   0.0                                       4 0     0   0                                 4
1820368 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   kindergarten           0.0                                       3.0           0                                 3
1732417 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   kindergarten 0.0                   0.0                             4 0                   0                       4
1814736 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   kindergarten 0.0                   0.0                             6.0 0                   0                       6
1735025 AK     school 200760 29   Kuspuk Schools 20076000663 290011 Aniak Jr/Sr High School   Regular School No High 06 12.0 2020   kindergarten 0.0                                                 0 0                                           0
1817312 AK     school 200760 29   Kuspuk Schools 20076000663 290011 Aniak Jr/Sr High School   Regular School No High 06 12 2021   kindergarten 0.0                                                 0.0 0                                           0
1732145 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12.0 2020   kindergarten 0.0 0.0                                               11 0 0                                         11
1814464 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12 2021   kindergarten 0.0 0.0                                               10.0 0 0                                         10
1735649 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 15 0                                           15
1817936 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   kindergarten                                                   9.0                                             9
1733233 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 20.0 5.0 6.0 0.0   1.0         13.0                             54 20 5 6 0   1         13                       54
1815536 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000114 160380 Anne Wien Elementary   Regular School No Elementary PK 6 2021   kindergarten 9.0 1.0 6.0     0.0         12.0                             39.0 9 1 6     0         12                       39
1732209 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12.0 2020   kindergarten 1.0                                                 11 1                                           11
1814528 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12 2021   kindergarten 1.0 0.0 0.0                                             15.0 1 0 0                                       15
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
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
1731937 AK     school 200180 5   Anchorage Schools 20018000172 59010 Aquarian Charter School   Regular School Yes Elementary PK 6.0 2020   kindergarten 43.0 1.0 3.0     1.0     0.0   10.0                             60 43 1 3     1     0   10                       60
1814256 AK     school 200180 5   Anchorage Schools 20018000172 59010 Aquarian Charter School   Regular School Yes Elementary KG 6 2021   kindergarten 45.0 0.0 5.0     3.0     0.0   5.0                             60.0 45 0 5     3     0   5                       60
1733217 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8.0 2020   kindergarten 30.0 8.0 21.0 0.0   0.0     0.0   7.0                             68 30 8 21 0   0     0   7                       68
1815520 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000055 160360 Arctic Light Elementary   Regular School No Elementary PK 8 2021   kindergarten 31.0 9.0 15.0 1.0   0.0     4.0   6.0                             67.0 31 9 15 1   0     4   6                       67
1737857 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12.0 2020   kindergarten                                                   4                                             4
1820176 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   kindergarten                                                   1.0                                             1
1735681 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12.0 2020   kindergarten   0.0                 0.0                             2   0                 0                       2
1817968 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   kindergarten                                                   0.0                                             0
1733729 AK     school 200210 22   Juneau Borough Schools 20021000127 220010 Auke Bay Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 35.0   4.0 0.0   1.0         12.0                             57 35   4 0   1         12                       57
1816016 AK     school 200210 22   Juneau Borough Schools 20021000127 220010 Auke Bay Elementary   Regular School No Elementary PK 5 2021   kindergarten 20.0 0.0 1.0 0.0   0.0     1.0   3.0                             25.0 20 0 1 0   0     1   3                       25
1735009 AK     school 200760 29   Kuspuk Schools 20076000346 290010 Auntie Mary Nicoli Elementary   Regular School No Elementary PK 5.0 2020   kindergarten 0.0         0.0                                       13 0         0                                 13
1817296 AK     school 200760 29   Kuspuk Schools 20076000346 290010 Auntie Mary Nicoli Elementary   Regular School No Elementary PK 5 2021   kindergarten 0.0         0.0                                       4.0 0         0                                 4
1734593 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000274 249010 Aurora Borealis Charter School   Regular School Yes Elementary KG 8.0 2020   kindergarten 19.0   0.0 0.0   1.0     1.0   2.0                             24 19   0 0   1     1   2                       24
1816880 AK     school 200390 24   Kenai Peninsula Borough Schools 20039000274 249010 Aurora Borealis Charter School   Regular School Yes Elementary KG 8 2021   kindergarten 16.0   0.0 1.0   0.0         6.0                             24.0 16   0 1   0         6                       24
1730833 AK     school 200180 5   Anchorage Schools 20018000056 50240 Aurora Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 36.0 7.0 6.0 0.0   0.0     0.0   5.0                             55 36 7 6 0   0     0   5                       55
1813168 AK     school 200180 5   Anchorage Schools 20018000056 50240 Aurora Elementary   Regular School No Elementary PK 6 2021   kindergarten 20.0 5.0 9.0 0.0   3.0     0.0   4.0                             42.0 20 5 9 0   3     0   4                       42
1735521 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12.0 2020   kindergarten                                                   8                                             8
1817808 AK     school 200001 31   Lower Kuskokwim Schools 20000100211 310130 Ayagina'ar Elitnaurvik   Regular School No Other PK 12 2021   kindergarten                                                   14.0                                             14
1735793 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6.0 2020   kindergarten 1.0                                                 37 1                                           37
1818096 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   kindergarten 1.0                                                 26.0 1                                           26
1735617 AK     school 200001 31   Lower Kuskokwim Schools 20000100440 310190 Ayaprun School   Regular School No Other PK 12.0 2020   kindergarten                                                   8                                             8
1817904 AK     school 200001 31   Lower Kuskokwim Schools 20000100440 310190 Ayaprun School   Regular School No Other PK 12 2021   kindergarten                                                   3.0                                             3
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
1732865 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8.0 2020   kindergarten 27.0 1.0 5.0 0.0   1.0     0.0   7.0                             44 27 1 5 0   1     0   7                       44
1815168 AK     school 200600 16   Fairbanks North Star Borough Schools 20060000259 160020 Barnette Magnet School   Regular School No Elementary PK 8 2021   kindergarten 27.0 0.0 1.0 0.0   0.0     0.0   10.0                             38.0 27 0 1 0   0     0   10                       38
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

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