enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by county descending

✎ 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
112362 112362 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 387.0 1.0 12.0 3.0             9.0   214.0 198.0             161     44   412 387 1 12 3             9   214 198         161   44   412
112363 112363 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   52                                             52
112364 112364 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   60                                             60
112365 112365 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   63                                             63
112366 112366 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   55                                             55
112367 112367 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   64                                             64
112368 112368 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   56                                             56
112369 112369 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   62                                             62
112370 112370 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   pk_12_total 424.0 2.0 7.0     2.0         5.0   214.0 226.0             151     53   440 424 2 7     2         5   214 226         151   53   440
112371 112371 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_10                                                   52                                             52
112372 112372 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_11                                                   65                                             65
112373 112373 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_12                                                   61                                             61
112374 112374 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_6                                                   71                                             71
112375 112375 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_7                                                   63                                             63
112376 112376 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_8                                                   64                                             64
112377 112377 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No 4.0 06 12 2015   grade_9                                                   64                                             64
112378 112378 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
112379 112379 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2015   grade_5                                                   1                                             1
118176 118176 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 607.0 5.0 24.0 5.0   24.0       1.0 26.0   355.0 337.0             227     65   692 607 5 24 5   24       1 26   355 337         227   65   692
118177 118177 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_1                                                   101                                             101
118178 118178 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   104                                             104
118179 118179 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_3                                                   103                                             103
118180 118180 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   101                                             101
118181 118181 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_5                                                   99                                             99
118182 118182 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_6                                                   92                                             92
118183 118183 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   kindergarten                                                   92                                             92
118184 118184 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 286.0 10.0 34.0 1.0   11.0       1.0 11.0   181.0 173.0             185     25   354 286 10 34 1   11       1 11   181 173         185   25   354
118185 118185 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_1                                                   49                                             49
118186 118186 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   50                                             50
118187 118187 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_3                                                   60                                             60
118188 118188 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   49                                             49
118189 118189 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_5                                                   48                                             48
118190 118190 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_6                                                   50                                             50
118191 118191 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   kindergarten                                                   48                                             48
118192 118192 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 316.0 4.0 23.0 1.0   4.0       1.0 8.0   181.0 176.0             167     42   357 316 4 23 1   4       1 8   181 176         167   42   357
118193 118193 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_1                                                   65                                             65
118194 118194 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   52                                             52
118195 118195 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_3                                                   51                                             51
118196 118196 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   46                                             46
118197 118197 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_5                                                   47                                             47
118198 118198 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_6                                                   49                                             49
118199 118199 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   kindergarten                                                   47                                             47
118200 118200 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No 3.0 09 12 2015   pk_12_total 1096.0 12.0 44.0 6.0   27.0       1.0 25.0   666.0 545.0             335     162   1211 1096 12 44 6   27       1 25   666 545         335   162   1211
118201 118201 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No 3.0 09 12 2015   grade_10                                                   316                                             316
118202 118202 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No 3.0 09 12 2015   grade_11                                                   286                                             286
118203 118203 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No 3.0 09 12 2015   grade_12                                                   305                                             305
118204 118204 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No 3.0 09 12 2015   grade_9                                                   304                                             304
118205 118205 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No 1.0 PK PK 2015   pk_12_total 216.0 2.0 13.0 1.0   7.0         4.0   131.0 112.0             50     26   243 216 2 13 1   7         4   131 112         50   26   243
118206 118206 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   243                                             243
118207 118207 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle School   Regular School No 2.0 07 08 2015   pk_12_total 475.0 5.0 20.0 2.0   13.0         15.0   279.0 251.0             174     60   530 475 5 20 2   13         15   279 251         174   60   530
118208 118208 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle School   Regular School No 2.0 07 08 2015   grade_7                                                   265                                             265
118209 118209 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle School   Regular School No 2.0 07 08 2015   grade_8                                                   265                                             265
118210 118210 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 275.0   14.0     1.0         2.0   149.0 143.0             77     26   292 275   14     1         2   149 143         77   26   292
118211 118211 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_1                                                   42                                             42
118212 118212 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   52                                             52
118213 118213 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_3                                                   41                                             41
118214 118214 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   29                                             29
118215 118215 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_5                                                   43                                             43
118216 118216 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_6                                                   50                                             50
118217 118217 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   kindergarten                                                   35                                             35
118218 118218 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 328.0 7.0 20.0     6.0         11.0   193.0 179.0             114     34   372 328 7 20     6         11   193 179         114   34   372
118219 118219 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   63                                             63
118220 118220 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   53                                             53
118221 118221 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   49                                             49
118222 118222 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   49                                             49
118223 118223 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   43                                             43
118224 118224 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   53                                             53
118225 118225 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   1                                             1
118226 118226 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   45                                             45
118227 118227 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   16                                             16
120780 120780 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   pk_12_total 291.0 8.0 32.0 15.0   1.0         4.0   176.0 175.0             162     56   351 291 8 32 15   1         4   176 175         162   56   351
120781 120781 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_4                                                   56                                             56
120782 120782 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_5                                                   71                                             71
120783 120783 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_6                                                   45                                             45
120784 120784 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_7                                                   80                                             80
120785 120785 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_8                                                   99                                             99
120786 120786 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   pk_12_total 50.0 4.0 11.0                   38.0 27.0             27     2   65 50 4 11                   38 27         27   2   65
120787 120787 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   grade_4                                                   10                                             10
120788 120788 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   grade_5                                                   9                                             9
120789 120789 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   grade_6                                                   27                                             27
120790 120790 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   grade_7                                                   19                                             19
120791 120791 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   pk_12_total 265.0 2.0 32.0 13.0             24.0   183.0 153.0             161     42   336 265 2 32 13             24   183 153         161   42   336
120792 120792 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   grade_1                                                   85                                             85
120793 120793 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   grade_2                                                   91                                             91
120794 120794 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   grade_3                                                   68                                             68
120795 120795 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   kindergarten                                                   92                                             92
120796 120796 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No 1.0 PK PK 2015   pk_12_total 62.0   5.0               6.0   33.0 40.0             31     4   73 62   5               6   33 40         31   4   73
120797 120797 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   73                                             73
120798 120798 WI Wood   school 5510380 3906 Public school Nekoosa 551038001360 60 Nekoosa High   Regular School No 3.0 09 12 2015   pk_12_total 366.0 7.0 27.0 14.0   3.0         2.0   224.0 195.0             159     77   419 366 7 27 14   3         2   224 195         159   77   419
120799 120799 WI Wood   school 5510380 3906 Public school Nekoosa 551038001360 60 Nekoosa High   Regular School No 3.0 09 12 2015   grade_10                                                   103                                             103
120800 120800 WI Wood   school 5510380 3906 Public school Nekoosa 551038001360 60 Nekoosa High   Regular School No 3.0 09 12 2015   grade_11                                                   104                                             104
120801 120801 WI Wood   school 5510380 3906 Public school Nekoosa 551038001360 60 Nekoosa High   Regular School No 3.0 09 12 2015   grade_12                                                   111                                             111
120802 120802 WI Wood   school 5510380 3906 Public school Nekoosa 551038001360 60 Nekoosa High   Regular School No 3.0 09 12 2015   grade_9                                                   101                                             101
120803 120803 WI Wood   school 5510380 3906 Public school Nekoosa 551038002715 200 Niikuusra Community School charter Alternative Education School Yes 2.0 04 08 2015   pk_12_total     1.0 10.0                 4.0 7.0             2     1   11     1 10                 4 7         2   1   11
120804 120804 WI Wood   school 5510380 3906 Public school Nekoosa 551038002715 200 Niikuusra Community School charter Alternative Education School Yes 2.0 04 08 2015   grade_5                                                   4                                             4
120805 120805 WI Wood   school 5510380 3906 Public school Nekoosa 551038002715 200 Niikuusra Community School charter Alternative Education School Yes 2.0 04 08 2015   grade_6                                                   4                                             4
120806 120806 WI Wood   school 5510380 3906 Public school Nekoosa 551038002715 200 Niikuusra Community School charter Alternative Education School Yes 2.0 04 08 2015   grade_7                                                   1                                             1
120807 120807 WI Wood   school 5510380 3906 Public school Nekoosa 551038002715 200 Niikuusra Community School charter Alternative Education School Yes 2.0 04 08 2015   grade_8                                                   2                                             2
121946 121946 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 383.0   5.0 1.0   1.0         2.0   198.0 194.0             134     36   392 383   5 1   1         2   198 194         134   36   392
121947 121947 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   24                                             24

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