enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,602 ✖
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
3088737 3088737 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_9                                                   41                                             41
3088738 3088738 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   pk_12_total 158.0   11.0     1.0         2.0   85.0 87.0             58     25   172 158   11     1         2   85 87         58   25   172
3088739 3088739 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   15                                             15
3088740 3088740 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   16                                             16
3088741 3088741 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   21                                             21
3088742 3088742 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   19                                             19
3088743 3088743 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   18                                             18
3088744 3088744 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   13                                             13
3088745 3088745 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   17                                             17
3088746 3088746 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   22                                             22
3088747 3088747 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   12                                             12
3088748 3088748 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   18                                             18
3088749 3088749 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3088750 3088750 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   pk_12_total 65.0   1.0     2.0         2.0   41.0 29.0             18     18   70 65   1     2         2   41 29         18   18   70
3088751 3088751 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_10                                                   19                                             19
3088752 3088752 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_11                                                   21                                             21
3088753 3088753 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_12                                                   14                                             14
3088754 3088754 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_9                                                   16                                             16
3088755 3088755 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   pk_12_total 292.0 2.0 47.0 5.0           1.0 5.0   182.0 170.0             198     56   352 292 2 47 5           1 5   182 170         198   56   352
3088756 3088756 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   45                                             45
3088757 3088757 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   49                                             49
3088758 3088758 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   41                                             41
3088759 3088759 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   37                                             37
3088760 3088760 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   49                                             49
3088761 3088761 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   53                                             53
3088762 3088762 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   33                                             33
3088763 3088763 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   42                                             42
3088764 3088764 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   3                                             3
3088765 3088765 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   pk_12_total 142.0 1.0 26.0 4.0   1.0       1.0     92.0 83.0             82     20   175 142 1 26 4   1       1     92 83         82   20   175
3088766 3088766 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_10                                                   40                                             40
3088767 3088767 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_11                                                   39                                             39
3088768 3088768 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_12                                                   47                                             47
3088769 3088769 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_9                                                   49                                             49
3088770 3088770 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   pk_12_total 63.0   12.0 2.0           1.0 3.0   39.0 42.0             41     15   81 63   12 2           1 3   39 42         41   15   81
3088771 3088771 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   grade_7                                                   43                                             43
3088772 3088772 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   grade_8                                                   38                                             38
3088773 3088773 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pk_12_total 143.0 2.0 47.0 1.0                 102.0 91.0             88     38   193 143 2 47 1                 102 91         88   38   193
3088774 3088774 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
3088775 3088775 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   21                                             21
3088776 3088776 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   31                                             31
3088777 3088777 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088778 3088778 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   31                                             31
3088779 3088779 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   22                                             22
3088780 3088780 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   28                                             28
3088781 3088781 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088782 3088782 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   pk_12_total 87.0   25.0 1.0                 66.0 47.0             60     12   113 87   25 1                 66 47         60   12   113
3088783 3088783 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_10                                                   38                                             38
3088784 3088784 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_11                                                   31                                             31
3088785 3088785 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_12                                                   27                                             27
3088786 3088786 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_9                                                   17                                             17
3088787 3088787 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   pk_12_total 72.0   18.0               1.0   53.0 38.0             39     19   91 72   18               1   53 38         39   19   91
3088788 3088788 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_6                                                   23                                             23
3088789 3088789 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_7                                                   28                                             28
3088790 3088790 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_8                                                   40                                             40
3088791 3088791 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   pk_12_total 497.0 8.0 37.0     14.0         45.0   329.0 272.0             231     87   601 497 8 37     14         45   329 272         231   87   601
3088792 3088792 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_1                                                   118                                             118
3088793 3088793 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_2                                                   108                                             108
3088794 3088794 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_3                                                   134                                             134
3088795 3088795 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   kindergarten_4_year_old                                                   104                                             104
3088796 3088796 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   kindergarten                                                   126                                             126
3088797 3088797 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   11                                             11
3088798 3088798 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   pk_12_total 355.0 10.0 21.0 4.0   7.0       1.0 15.0   233.0 180.0             135     55   413 355 10 21 4   7       1 15   233 180         135   55   413
3088799 3088799 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_10                                                   108                                             108
3088800 3088800 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_11                                                   102                                             102
3088801 3088801 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_12                                                   97                                             97
3088802 3088802 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_9                                                   106                                             106
3088803 3088803 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2018   pk_12_total 208.0 4.0 11.0     6.0         18.0   122.0 125.0             107     28   247 208 4 11     6         18   122 125         107   28   247
3088804 3088804 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2018   grade_4                                                   129                                             129
3088805 3088805 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2018   grade_5                                                   118                                             118
3088806 3088806 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   pk_12_total 298.0 3.0 18.0 1.0   7.0       1.0 33.0   193.0 168.0             147     44   361 298 3 18 1   7       1 33   193 168         147   44   361
3088807 3088807 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_6                                                   113                                             113
3088808 3088808 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_7                                                   126                                             126
3088809 3088809 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_8                                                   122                                             122
3088810 3088810 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   pk_12_total 422.0 3.0 20.0 3.0   4.0         10.0   233.0 229.0             118     54   462 422 3 20 3   4         10   233 229         118   54   462
3088811 3088811 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_10                                                   116                                             116
3088812 3088812 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_11                                                   126                                             126
3088813 3088813 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_12                                                   105                                             105
3088814 3088814 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_9                                                   115                                             115
3088815 3088815 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   pk_12_total 285.0 6.0 8.0 2.0   2.0         9.0   171.0 141.0             115     44   312 285 6 8 2   2         9   171 141         115   44   312
3088816 3088816 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_3                                                   99                                             99
3088817 3088817 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   84                                             84
3088818 3088818 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_5                                                   129                                             129
3088819 3088819 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   pk_12_total 330.0 3.0 8.0     1.0         11.0   187.0 166.0             135     51   353 330 3 8     1         11   187 166         135   51   353
3088820 3088820 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_6                                                   115                                             115
3088821 3088821 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_7                                                   119                                             119
3088822 3088822 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_8                                                   119                                             119
3088823 3088823 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   pk_12_total 361.0 6.0 17.0 1.0   3.0         11.0   210.0 189.0             144     45   399 361 6 17 1   3         11   210 189         144   45   399
3088824 3088824 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_1                                                   99                                             99
3088825 3088825 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_2                                                   100                                             100
3088826 3088826 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   88                                             88
3088827 3088827 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   kindergarten                                                   106                                             106
3088828 3088828 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   6                                             6
3088829 3088829 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   pk_12_total 700.0 7.0 32.0 11.0   5.0         20.0   417.0 358.0             277     110   775 700 7 32 11   5         20   417 358         277   110   775
3088830 3088830 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_10                                                   209                                             209
3088831 3088831 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_11                                                   171                                             171
3088832 3088832 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_12                                                   210                                             210
3088833 3088833 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_9                                                   185                                             185
3088834 3088834 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   pk_12_total 434.0 4.0 34.0 3.0   2.0         22.0   251.0 248.0             271     82   499 434 4 34 3   2         22   251 248         271   82   499
3088835 3088835 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_6                                                   147                                             147
3088836 3088836 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_7                                                   175                                             175

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