enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 14,906 ✖
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
2333026 2333026 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   40                                             40
2333027 2333027 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   39                                             39
2333028 2333028 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   42                                             42
2333029 2333029 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   48                                             48
2333030 2333030 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   45                                             45
2333031 2333031 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   kindergarten_4_year_old                                                   43                                             43
2333032 2333032 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   44                                             44
2333033 2333033 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2333034 2333034 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   pk_12_total 208.0 1.0 36.0 3.0   1.0       3.0 6.0   126.0 132.0     7.0       163     36   258 208 1 36 3   1       3 6   126 132     7   163   36   258
2333035 2333035 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_10                                                   40                                             40
2333036 2333036 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_11                                                   31                                             31
2333037 2333037 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_12                                                   42                                             42
2333038 2333038 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_7                                                   45                                             45
2333039 2333039 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_8                                                   53                                             53
2333040 2333040 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln Jr/Sr High School   Regular School No High 07 12 2021   grade_9                                                   47                                             47
2333041 2333041 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   pk_12_total 128.0 3.0 42.0               6.0   90.0 89.0     18.0       106     31   179 128 3 42               6   90 89     18   106   31   179
2333042 2333042 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   25                                             25
2333043 2333043 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   19                                             19
2333044 2333044 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   32                                             32
2333045 2333045 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   29                                             29
2333046 2333046 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   21                                             21
2333047 2333047 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   31                                             31
2333048 2333048 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   21                                             21
2333049 2333049 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2333050 2333050 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2021   pk_12_total 86.0   25.0                   66.0 45.0     17.0       55     15   111 86   25                   66 45     17   55   15   111
2333051 2333051 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2021   grade_10                                                   27                                             27
2333052 2333052 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2021   grade_11                                                   39                                             39
2333053 2333053 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2021   grade_12                                                   20                                             20
2333054 2333054 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2021   grade_9                                                   25                                             25
2333055 2333055 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2021   pk_12_total 59.0   26.0                   47.0 38.0     17.0       45     14   85 59   26                   47 38     17   45   14   85
2333056 2333056 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2021   grade_6                                                   27                                             27
2333057 2333057 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2021   grade_7                                                   24                                             24
2333058 2333058 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2021   grade_8                                                   34                                             34
2333059 2333059 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   pk_12_total 533.0 8.0 33.0     12.0       2.0 42.0   326.0 304.0     17.0       258     111   630 533 8 33     12       2 42   326 304     17   258   111   630
2333060 2333060 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   141                                             141
2333061 2333061 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   135                                             135
2333062 2333062 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   128                                             128
2333063 2333063 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   kindergarten_4_year_old                                                   70                                             70
2333064 2333064 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   147                                             147
2333065 2333065 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   9                                             9
2333066 2333066 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2021   pk_12_total 414.0 12.0 17.0 2.0   5.0       2.0 38.0   258.0 232.0     7.0       183     76   490 414 12 17 2   5       2 38   258 232     7   183   76   490
2333067 2333067 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2021   grade_10                                                   132                                             132
2333068 2333068 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2021   grade_11                                                   125                                             125
2333069 2333069 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2021   grade_12                                                   118                                             118
2333070 2333070 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2021   grade_9                                                   115                                             115
2333071 2333071 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2021   pk_12_total 197.0 5.0 16.0     10.0         18.0   130.0 116.0     7.0       110     49   246 197 5 16     10         18   130 116     7   110   49   246
2333072 2333072 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2021   grade_4                                                   126                                             126
2333073 2333073 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2021   grade_5                                                   120                                             120
2333074 2333074 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2021   pk_12_total 352.0 6.0 16.0     11.0         32.0   200.0 217.0     6.0       182     58   417 352 6 16     11         32   200 217     6   182   58   417
2333075 2333075 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2021   grade_6                                                   148                                             148
2333076 2333076 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2021   grade_7                                                   145                                             145
2333077 2333077 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2021   grade_8                                                   124                                             124
2333078 2333078 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2021   pk_12_total 436.0 4.0 12.0 4.0   2.0         12.0   244.0 226.0     6.0       175     69   470 436 4 12 4   2         12   244 226     6   175   69   470
2333079 2333079 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2021   grade_10                                                   121                                             121
2333080 2333080 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2021   grade_11                                                   120                                             120
2333081 2333081 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2021   grade_12                                                   114                                             114
2333082 2333082 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2021   grade_9                                                   115                                             115
2333083 2333083 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2021   pk_12_total 255.0 2.0 10.0 1.0   1.0         10.0   152.0 127.0     4.0       124     47   279 255 2 10 1   1         10   152 127     4   124   47   279
2333084 2333084 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2021   grade_3                                                   88                                             88
2333085 2333085 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2021   grade_4                                                   93                                             93
2333086 2333086 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2021   grade_5                                                   98                                             98
2333087 2333087 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2021   pk_12_total 293.0 5.0 9.0 3.0   4.0         9.0   173.0 150.0     4.0       144     54   323 293 5 9 3   4         9   173 150     4   144   54   323
2333088 2333088 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2021   grade_6                                                   106                                             106
2333089 2333089 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2021   grade_7                                                   87                                             87
2333090 2333090 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2021   grade_8                                                   130                                             130
2333091 2333091 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   pk_12_total 339.0 4.0 18.0     3.0         11.0   181.0 194.0     6.0       188     40   375 339 4 18     3         11   181 194     6   188   40   375
2333092 2333092 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   115                                             115
2333093 2333093 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   78                                             78
2333094 2333094 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   21                                             21
2333095 2333095 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   kindergarten_4_year_old                                                   75                                             75
2333096 2333096 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   82                                             82
2333097 2333097 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   4                                             4
2333098 2333098 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   pk_12_total 726.0 11.0 58.0 9.0   3.0         37.0   453.0 391.0     18.0       453     130   844 726 11 58 9   3         37   453 391     18   453   130   844
2333099 2333099 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   grade_10                                                   182                                             182
2333100 2333100 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   grade_11                                                   170                                             170
2333101 2333101 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   grade_12                                                   175                                             175
2333102 2333102 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   grade_8                                                   154                                             154
2333103 2333103 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 08 12 2021   grade_9                                                   163                                             163
2333104 2333104 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2021   pk_12_total 423.0 5.0 35.0 6.0   1.0         26.0   282.0 214.0     10.0       336     93   496 423 5 35 6   1         26   282 214     10   336   93   496
2333105 2333105 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2021   grade_4                                                   114                                             114
2333106 2333106 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2021   grade_5                                                   124                                             124
2333107 2333107 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2021   grade_6                                                   131                                             131
2333108 2333108 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2021   grade_7                                                   127                                             127
2333109 2333109 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   pk_12_total 176.0   9.0 3.0   1.0         8.0   97.0 100.0     1.0       96     38   197 176   9 3   1         8   97 100     1   96   38   197
2333110 2333110 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   33                                             33
2333111 2333111 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   28                                             28
2333112 2333112 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   32                                             32
2333113 2333113 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   kindergarten_4_year_old                                                   69                                             69
2333114 2333114 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   26                                             26
2333115 2333115 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   9                                             9
2333116 2333116 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   pk_12_total 175.0 3.0 12.0 7.0             12.0   106.0 103.0     1.0       157     41   209 175 3 12 7             12   106 103     1   157   41   209
2333117 2333117 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   47                                             47
2333118 2333118 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   62                                             62
2333119 2333119 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   42                                             42
2333120 2333120 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   kindergarten_4_year_old                                                   16                                             16
2333121 2333121 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   42                                             42
2333122 2333122 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   pk_12_total 101.0   5.0                   39.0 67.0             58     11   106 101   5                   39 67         58   11   106
2333123 2333123 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_1                                                   3                                             3
2333124 2333124 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_10                                                   14                                             14
2333125 2333125 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_11                                                   11                                             11

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