enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI"

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
113773 113773 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2015   grade_12                                                   46                                             46
113774 113774 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No 3.0 09 12 2015   grade_9                                                   47                                             47
113775 113775 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2015   pk_12_total 95.0   5.0               7.0   55.0 52.0             59     15   107 95   5               7   55 52         59   15   107
113776 113776 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2015   grade_7                                                   65                                             65
113777 113777 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No 2.0 07 08 2015   grade_8                                                   42                                             42
113778 113778 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 422.0 7.0 20.0 1.0             3.0   232.0 221.0             160     89   453 422 7 20 1             3   232 221         160   89   453
113779 113779 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   49                                             49
113780 113780 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   44                                             44
113781 113781 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   44                                             44
113782 113782 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   50                                             50
113783 113783 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   47                                             47
113784 113784 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   35                                             35
113785 113785 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   51                                             51
113786 113786 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   42                                             42
113787 113787 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   36                                             36
113788 113788 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   43                                             43
113789 113789 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   12                                             12
113790 113790 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2015   pk_12_total 237.0 2.0 3.0 1.0   1.0       1.0 2.0   137.0 110.0             58     39   247 237 2 3 1   1       1 2   137 110         58   39   247
113791 113791 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2015   grade_10                                                   60                                             60
113792 113792 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2015   grade_11                                                   66                                             66
113793 113793 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2015   grade_12                                                   60                                             60
113794 113794 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No 3.0 09 12 2015   grade_9                                                   61                                             61
113795 113795 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2015   pk_12_total 509.0 47.0 144.0 11.0   8.0         11.0   413.0 317.0             333     98   730 509 47 144 11   8         11   413 317         333   98   730
113796 113796 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2015   grade_10                                                   186                                             186
113797 113797 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2015   grade_11                                                   223                                             223
113798 113798 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2015   grade_12                                                   139                                             139
113799 113799 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No 3.0 09 12 2015   grade_9                                                   182                                             182
113800 113800 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 07 08 2015   pk_12_total 234.0 22.0 83.0 2.0   2.0         12.0   186.0 169.0             138     59   355 234 22 83 2   2         12   186 169         138   59   355
113801 113801 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 07 08 2015   grade_7                                                   179                                             179
113802 113802 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No 2.0 07 08 2015   grade_8                                                   176                                             176
113803 113803 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 140.0 17.0 15.0 2.0   3.0         6.0   98.0 85.0             62     41   183 140 17 15 2   3         6   98 85         62   41   183
113804 113804 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   29                                             29
113805 113805 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   21                                             21
113806 113806 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   25                                             25
113807 113807 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   20                                             20
113808 113808 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   22                                             22
113809 113809 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   18                                             18
113810 113810 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   12                                             12
113811 113811 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   22                                             22
113812 113812 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   14                                             14
113813 113813 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 203.0 2.0 60.0 2.0   5.0         25.0   157.0 140.0             171         297 203 2 60 2   5         25   157 140         171       297
113814 113814 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   38                                             38
113815 113815 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   41                                             41
113816 113816 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   31                                             31
113817 113817 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   43                                             43
113818 113818 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   34                                             34
113819 113819 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   41                                             41
113820 113820 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   23                                             23
113821 113821 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   45                                             45
113822 113822 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
113823 113823 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 233.0 22.0 88.0 4.0   3.0         15.0   196.0 169.0             169     46   365 233 22 88 4   3         15   196 169         169   46   365
113824 113824 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   36                                             36
113825 113825 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   64                                             64
113826 113826 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   44                                             44
113827 113827 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   50                                             50
113828 113828 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   44                                             44
113829 113829 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   42                                             42
113830 113830 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   38                                             38
113831 113831 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   46                                             46
113832 113832 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
113833 113833 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 201.0 17.0 54.0 4.0   3.0         19.0   153.0 145.0             149     32   298 201 17 54 4   3         19   153 145         149   32   298
113834 113834 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   41                                             41
113835 113835 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   44                                             44
113836 113836 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   49                                             49
113837 113837 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   38                                             38
113838 113838 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   39                                             39
113839 113839 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   38                                             38
113840 113840 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   21                                             21
113841 113841 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   28                                             28
113842 113842 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 186.0 43.0 60.0 4.0   3.0         3.0   161.0 138.0             190     60   299 186 43 60 4   3         3   161 138         190   60   299
113843 113843 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   48                                             48
113844 113844 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   30                                             30
113845 113845 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   37                                             37
113846 113846 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   42                                             42
113847 113847 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   35                                             35
113848 113848 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   46                                             46
113849 113849 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   26                                             26
113850 113850 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000342 120 Park View Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   35                                             35
113851 113851 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 316.0 1.0 34.0 24.0   1.0       2.0 2.0   209.0 171.0             208     92   380 316 1 34 24   1       2 2   209 171         208   92   380
113852 113852 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   62                                             62
113853 113853 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   62                                             62
113854 113854 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   grade_3                                                   67                                             67
113855 113855 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   60                                             60
113856 113856 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   48                                             48
113857 113857 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   74                                             74
113858 113858 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   7                                             7
113859 113859 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2015   pk_12_total 245.0 2.0 14.0 11.0   1.0         3.0   148.0 128.0             130     30   276 245 2 14 11   1         3   148 128         130   30   276
113860 113860 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2015   grade_10                                                   63                                             63
113861 113861 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2015   grade_11                                                   62                                             62
113862 113862 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2015   grade_12                                                   76                                             76
113863 113863 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No 3.0 09 12 2015   grade_9                                                   75                                             75
113864 113864 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No 2.0 05 08 2015   pk_12_total 215.0 2.0 16.0 12.0   3.0         3.0   138.0 113.0             121     40   251 215 2 16 12   3         3   138 113         121   40   251
113865 113865 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No 2.0 05 08 2015   grade_5                                                   72                                             72
113866 113866 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No 2.0 05 08 2015   grade_6                                                   86                                             86
113867 113867 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No 2.0 05 08 2015   grade_7                                                   49                                             49
113868 113868 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No 2.0 05 08 2015   grade_8                                                   44                                             44
113869 113869 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   pk_12_total 40.0   2.0                   26.0 16.0             15     5   42 40   2                   26 16         15   5   42
113870 113870 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_10                                                   5                                             5
113871 113871 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_11                                                   1                                             1
113872 113872 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_12                                                   2                                             2

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