enrollments

Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 12,580 ✖
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
283740 283740 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 412.0   8.0 7.0   1.0         10.0   229.0 209.0             209     60   438 412   8 7   1         10   229 209         209   60   438
283741 283741 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   48                                             48
283742 283742 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   37                                             37
283743 283743 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_3                                                   56                                             56
283744 283744 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   51                                             51
283745 283745 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_5                                                   69                                             69
283746 283746 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   53                                             53
283747 283747 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   kindergarten_4_year_old                                                   63                                             63
283748 283748 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   kindergarten                                                   59                                             59
283749 283749 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   2                                             2
283750 283750 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2016   pk_12_total 184.0 1.0 3.0               9.0   113.0 84.0             91     27   197 184 1 3               9   113 84         91   27   197
283751 283751 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2016   grade_10                                                   46                                             46
283752 283752 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2016   grade_11                                                   52                                             52
283753 283753 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2016   grade_12                                                   58                                             58
283754 283754 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2016   grade_9                                                   41                                             41
283755 283755 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2016   pk_12_total 99.0 1.0 4.0               6.0   57.0 53.0             55     12   110 99 1 4               6   57 53         55   12   110
283756 283756 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2016   grade_7                                                   46                                             46
283757 283757 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2016   grade_8                                                   64                                             64
283758 283758 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   pk_12_total 428.0 7.0 12.0 1.0   2.0         3.0   227.0 226.0             145     89   453 428 7 12 1   2         3   227 226         145   89   453
283759 283759 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_1                                                   45                                             45
283760 283760 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_2                                                   47                                             47
283761 283761 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_3                                                   44                                             44
283762 283762 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_4                                                   43                                             43
283763 283763 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_5                                                   48                                             48
283764 283764 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   47                                             47
283765 283765 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_7                                                   35                                             35
283766 283766 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   53                                             53
283767 283767 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   kindergarten_4_year_old                                                   38                                             38
283768 283768 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   kindergarten                                                   44                                             44
283769 283769 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   9                                             9
283770 283770 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2016   pk_12_total 233.0 3.0 4.0     1.0       1.0 2.0   140.0 104.0             68     34   244 233 3 4     1       1 2   140 104         68   34   244
283771 283771 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2016   grade_10                                                   60                                             60
283772 283772 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2016   grade_11                                                   58                                             58
283773 283773 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2016   grade_12                                                   62                                             62
283774 283774 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2016   grade_9                                                   64                                             64
283775 283775 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2016   pk_12_total 500.0 47.0 150.0 11.0   7.0         13.0   406.0 322.0             310     110   728 500 47 150 11   7         13   406 322         310   110   728
283776 283776 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2016   grade_10                                                   179                                             179
283777 283777 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2016   grade_11                                                   181                                             181
283778 283778 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2016   grade_12                                                   201                                             201
283779 283779 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2016   grade_9                                                   167                                             167
283780 283780 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 06 08 2016   pk_12_total 337.0 38.0 122.0 7.0   10.0         21.0   277.0 258.0             220     84   535 337 38 122 7   10         21   277 258         220   84   535
283781 283781 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 06 08 2016   grade_6                                                   180                                             180
283782 283782 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 06 08 2016   grade_7                                                   178                                             178
283783 283783 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 06 08 2016   grade_8                                                   177                                             177
283784 283784 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 121.0 9.0 12.0     1.0         3.0   80.0 66.0             55     32   146 121 9 12     1         3   80 66         55   32   146
283785 283785 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   21                                             21
283786 283786 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   23                                             23
283787 283787 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   22                                             22
283788 283788 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   21                                             21
283789 283789 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   16                                             16
283790 283790 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   23                                             23
283791 283791 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   10                                             10
283792 283792 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   10                                             10
283793 283793 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 193.0 4.0 59.0 4.0   7.0         23.0   156.0 134.0             164     39   290 193 4 59 4   7         23   156 134         164   39   290
283794 283794 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   46                                             46
283795 283795 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   43                                             43
283796 283796 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   45                                             45
283797 283797 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   36                                             36
283798 283798 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   48                                             48
283799 283799 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   30                                             30
283800 283800 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   41                                             41
283801 283801 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283802 283802 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 204.0 16.0 69.0 1.0   2.0         17.0   164.0 145.0             146     42   309 204 16 69 1   2         17   164 145         146   42   309
283803 283803 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   48                                             48
283804 283804 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   34                                             34
283805 283805 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   60                                             60
283806 283806 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   41                                             41
283807 283807 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   50                                             50
283808 283808 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   31                                             31
283809 283809 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   45                                             45
283810 283810 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 157.0 21.0 54.0 3.0   3.0         17.0   127.0 128.0             139     27   255 157 21 54 3   3         17   127 128         139   27   255
283811 283811 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   32                                             32
283812 283812 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   41                                             41
283813 283813 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   43                                             43
283814 283814 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   45                                             45
283815 283815 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   42                                             42
283816 283816 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   16                                             16
283817 283817 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   35                                             35
283818 283818 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283819 283819 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 154.0 35.0 58.0 1.0   2.0         6.0   134.0 122.0             155     57   256 154 35 58 1   2         6   134 122         155   57   256
283820 283820 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   38                                             38
283821 283821 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   47                                             47
283822 283822 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   32                                             32
283823 283823 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   32                                             32
283824 283824 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   44                                             44
283825 283825 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   30                                             30
283826 283826 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   32                                             32
283827 283827 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283828 283828 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   pk_12_total 323.0 3.0 31.0 19.0   2.0       2.0 5.0   210.0 175.0             193     88   385 323 3 31 19   2       2 5   210 175         193   88   385
283829 283829 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   71                                             71
283830 283830 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   grade_2                                                   67                                             67
283831 283831 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   65                                             65
283832 283832 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   66                                             66
283833 283833 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   57                                             57
283834 283834 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   51                                             51
283835 283835 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   8                                             8
283836 283836 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2016   pk_12_total 243.0 2.0 13.0 8.0   1.0         1.0   135.0 133.0             121     30   268 243 2 13 8   1         1   135 133         121   30   268
283837 283837 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2016   grade_10                                                   82                                             82
283838 283838 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2016   grade_11                                                   66                                             66
283839 283839 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2016   grade_12                                                   63                                             63

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