enrollments

Data source: Big Local News · About: Big Local

15,920 rows where state = "AK" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
1730456 1730456 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 2 0                                           2
1730457 1730457 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 3 0                                           3
1730458 1730458 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 4 0                                           4
1730459 1730459 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 3 0                                           3
1730460 1730460 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 4 0                                           4
1730461 1730461 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 2 0                                           2
1730462 1730462 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 3 0                                           3
1730463 1730463 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   grade_9 1.0                                                 2 1                                           2
1730464 1730464 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 38 1                                           38
1730465 1730465 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 4 0                                           4
1730466 1730466 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 38 1                                           38
1730467 1730467 AK     school 200050 3   Alaska Gateway Schools 20005000528 30070 Tetlin School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1730468 1730468 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_1 5.0   0.0     0.0         0.0                             6 5   0     0         0                       6
1730469 1730469 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_10 2.0   0.0     1.0         0.0                             3 2   0     1         0                       3
1730470 1730470 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_11 4.0   0.0     0.0         0.0                             4 4   0     0         0                       4
1730471 1730471 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_12 4.0   0.0     1.0         0.0                             7 4   0     1         0                       7
1730472 1730472 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_2 3.0   0.0     0.0         0.0                             3 3   0     0         0                       3
1730473 1730473 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_3 3.0   1.0     0.0         0.0                             5 3   1     0         0                       5
1730474 1730474 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_4 1.0   0.0     0.0         0.0                             2 1   0     0         0                       2
1730475 1730475 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_5 4.0   0.0     2.0         0.0                             6 4   0     2         0                       6
1730476 1730476 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_6 5.0   0.0     0.0         1.0                             6 5   0     0         1                       6
1730477 1730477 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_7 1.0   0.0     1.0         0.0                             2 1   0     1         0                       2
1730478 1730478 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_8 3.0   0.0     1.0         0.0                             4 3   0     1         0                       4
1730479 1730479 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   grade_9 4.0   0.0     0.0         0.0                             5 4   0     0         0                       5
1730480 1730480 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   k_12_total 44.0   1.0     6.0         1.0                             59 44   1     6         1                       59
1730481 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
1730482 1730482 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   pk_12_total 44.0   1.0     6.0         1.0                             59 44   1     6         1                       59
1730483 1730483 AK     school 200050 3   Alaska Gateway Schools 20005000023 38010 Alaska REACH Academy   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0   0.0     0.0         0.0                             0 0   0     0         0                       0
1812691 1812691 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_1 0.0                   0.0                             1.0 0                   0                       1
1812692 1812692 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_10 1.0                   1.0                             2.0 1                   1                       2
1812693 1812693 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_11 0.0                   0.0                             0.0 0                   0                       0
1812694 1812694 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_12 0.0                   0.0                             1.0 0                   0                       1
1812695 1812695 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_2 0.0                   0.0                             0.0 0                   0                       0
1812696 1812696 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_3 0.0                   0.0                             2.0 0                   0                       2
1812697 1812697 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_4 0.0                   0.0                             1.0 0                   0                       1
1812698 1812698 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_5 0.0                   0.0                             0.0 0                   0                       0
1812699 1812699 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_6 0.0                   0.0                             0.0 0                   0                       0
1812700 1812700 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_7 0.0                   1.0                             2.0 0                   1                       2
1812701 1812701 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_8 0.0                   0.0                             0.0 0                   0                       0
1812702 1812702 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   grade_9 0.0                   1.0                             1.0 0                   1                       1
1812703 1812703 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   k_12_total 2.0                   3.0                             11.0 2                   3                       11
1812704 1812704 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   kindergarten 1.0                   0.0                             1.0 1                   0                       1
1812705 1812705 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   pk_12_total 2.0                   3.0                             11.0 2                   3                       11
1812706 1812706 AK     school 200050 3   Alaska Gateway Schools 20005000024 30010 Dot Lake School   Regular School No Other PK 12 2021   pre_kindergarten 0.0                   0.0                             0.0 0                   0                       0
1812707 1812707 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_1 0.0                   0.0                             1.0 0                   0                       1
1812708 1812708 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_10 0.0                   0.0                             1.0 0                   0                       1
1812709 1812709 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_11 1.0                   0.0                             2.0 1                   0                       2
1812710 1812710 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_12 2.0                   0.0                             2.0 2                   0                       2
1812711 1812711 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_2 1.0                   0.0                             2.0 1                   0                       2
1812712 1812712 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_3 0.0                   0.0                             0.0 0                   0                       0
1812713 1812713 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_4 1.0                   0.0                             2.0 1                   0                       2
1812714 1812714 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_5 1.0                   0.0                             1.0 1                   0                       1
1812715 1812715 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_6 2.0                   0.0                             2.0 2                   0                       2
1812716 1812716 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_7 0.0                   0.0                             0.0 0                   0                       0
1812717 1812717 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_8 1.0                   1.0                             2.0 1                   1                       2
1812718 1812718 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   grade_9 2.0                   0.0                             2.0 2                   0                       2
1812719 1812719 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   k_12_total 14.0                   1.0                             20.0 14                   1                       20
1812720 1812720 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   kindergarten 3.0                   0.0                             3.0 3                   0                       3
1812721 1812721 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   pk_12_total 14.0                   1.0                             20.0 14                   1                       20
1812722 1812722 AK     school 200050 3   Alaska Gateway Schools 20005000025 30020 Eagle Community School   Regular School No Other PK 12 2021   pre_kindergarten 0.0                   0.0                             0.0 0                   0                       0
1812723 1812723 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_1                                                   3.0                                             3
1812724 1812724 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_10                                                   4.0                                             4
1812725 1812725 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_11                                                   2.0                                             2
1812726 1812726 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_12                                                   2.0                                             2
1812727 1812727 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_2                                                   0.0                                             0
1812728 1812728 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_3                                                   3.0                                             3
1812729 1812729 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_4                                                   1.0                                             1
1812730 1812730 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_5                                                   3.0                                             3
1812731 1812731 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_6                                                   2.0                                             2
1812732 1812732 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_7                                                   3.0                                             3
1812733 1812733 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_8                                                   1.0                                             1
1812734 1812734 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   grade_9                                                   2.0                                             2
1812735 1812735 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   k_12_total                                                   29.0                                             29
1812736 1812736 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   kindergarten                                                   3.0                                             3
1812737 1812737 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   pk_12_total                                                   32.0                                             32
1812738 1812738 AK     school 200050 3   Alaska Gateway Schools 20005000026 30030 Mentasta Lake School   Regular School No Other PK 12 2021   pre_kindergarten                                                   3.0                                             3
1812739 1812739 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_1                     0.0                             3.0                     0                       3
1812740 1812740 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_10                     1.0                             6.0                     1                       6
1812741 1812741 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_11                     1.0                             2.0                     1                       2
1812742 1812742 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_12                     0.0                             3.0                     0                       3
1812743 1812743 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_2                     0.0                             5.0                     0                       5
1812744 1812744 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_3                     0.0                             2.0                     0                       2
1812745 1812745 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_4                     0.0                             6.0                     0                       6
1812746 1812746 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_5                     0.0                             5.0                     0                       5
1812747 1812747 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_6                     0.0                             3.0                     0                       3
1812748 1812748 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_7                     0.0                             6.0                     0                       6
1812749 1812749 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_8                     0.0                             5.0                     0                       5
1812750 1812750 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   grade_9                     0.0                             4.0                     0                       4
1812751 1812751 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   k_12_total                     3.0                             53.0                     3                       53
1812752 1812752 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   kindergarten                     1.0                             3.0                     1                       3
1812753 1812753 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   pk_12_total                     4.0                             54.0                     4                       54
1812754 1812754 AK     school 200050 3   Alaska Gateway Schools 20005000027 30040 Walter Northway School   Regular School No Other PK 12 2021   pre_kindergarten                     1.0                             1.0                     1                       1
1812755 1812755 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_1                     0.0                             1.0                     0                       1
1812756 1812756 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_10                     0.0                             0.0                     0                       0
1812757 1812757 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_11                     0.0                             0.0                     0                       0
1812758 1812758 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_12                     0.0                             0.0                     0                       0
1812759 1812759 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_2                     0.0                             0.0                     0                       0
1812760 1812760 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_3                     0.0                             2.0                     0                       2
1812761 1812761 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_4                     0.0                             2.0                     0                       2
1812762 1812762 AK     school 200050 3   Alaska Gateway Schools 20005000424 30050 Tanacross School   Regular School No Elementary PK 8 2021   grade_5                     0.0                             1.0                     0                       1

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