enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,517 ✖
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
291358 291358 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 254.0   9.0 1.0             5.0   144.0 125.0             63     33   269 254   9 1             5   144 125         63   33   269
291359 291359 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   37                                             37
291360 291360 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   35                                             35
291361 291361 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   43                                             43
291362 291362 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   44                                             44
291363 291363 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   46                                             46
291364 291364 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   32                                             32
291365 291365 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   30                                             30
291366 291366 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
288782 288782 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   pk_12_total 267.0 38.0 141.0 5.0   178.0       2.0 11.0   320.0 322.0             432     90   642 267 38 141 5   178       2 11   320 322         432   90   642
288783 288783 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_1                                                   101                                             101
288784 288784 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_2                                                   89                                             89
288785 288785 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_3                                                   92                                             92
288786 288786 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_4                                                   88                                             88
288787 288787 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_5                                                   84                                             84
288788 288788 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
288789 288789 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   96                                             96
288790 288790 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   kindergarten                                                   88                                             88
291542 291542 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   pk_12_total 42.0 3.0 1.0     7.0         3.0   28.0 28.0             11         56 42 3 1     7         3   28 28         11       56
291543 291543 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   grade_4                                                   9                                             9
291544 291544 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   grade_5                                                   11                                             11
291545 291545 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   grade_6                                                   16                                             16
291546 291546 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   grade_7                                                   11                                             11
291547 291547 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2016   grade_8                                                   9                                             9
286321 286321 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 302.0 9.0 40.0 2.0   4.0       1.0 30.0   197.0 191.0             245     51   388 302 9 40 2   4       1 30   197 191         245   51   388
286322 286322 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   60                                             60
286323 286323 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   72                                             72
286324 286324 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   61                                             61
286325 286325 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   63                                             63
286326 286326 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   60                                             60
286327 286327 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   17                                             17
286328 286328 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   50                                             50
286329 286329 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   5                                             5
281731 281731 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 397.0 9.0 41.0 5.0   1.0       1.0 5.0   234.0 225.0             329     77   459 397 9 41 5   1       1 5   234 225         329   77   459
281732 281732 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
281733 281733 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   75                                             75
281734 281734 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   72                                             72
281735 281735 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   67                                             67
281736 281736 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   78                                             78
281737 281737 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   53                                             53
281738 281738 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   63                                             63
281739 281739 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281740 281740 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   pk_12_total 444.0 5.0 31.0 5.0   1.0       1.0 2.0   239.0 250.0             335     94   489 444 5 31 5   1       1 2   239 250         335   94   489
281741 281741 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_10                                                   107                                             107
281742 281742 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_11                                                   130                                             130
281743 281743 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_12                                                   117                                             117
281744 281744 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_9                                                   135                                             135
281745 281745 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   pk_12_total 325.0 7.0 15.0 4.0           1.0 2.0   180.0 174.0             247     61   354 325 7 15 4           1 2   180 174         247   61   354
281746 281746 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_6                                                   128                                             128
281747 281747 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_7                                                   110                                             110
281748 281748 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_8                                                   116                                             116
293605 293605 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 424.0 3.0 20.0     6.0         5.0   239.0 219.0             39     71   458 424 3 20     6         5   239 219         39   71   458
293606 293606 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   68                                             68
293607 293607 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   73                                             73
293608 293608 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   64                                             64
293609 293609 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   71                                             71
293610 293610 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   63                                             63
293611 293611 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   50                                             50
293612 293612 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   56                                             56
293613 293613 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   13                                             13
282483 282483 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   pk_12_total 54.0 1.0 8.0     1.0         3.0   24.0 43.0             26     1   67 54 1 8     1         3   24 43         26   1   67
282484 282484 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_1                                                   1                                             1
282485 282485 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_10                                                   6                                             6
282486 282486 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_11                                                   15                                             15
282487 282487 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_12                                                   19                                             19
282488 282488 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   1                                             1
282489 282489 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_3                                                   4                                             4
282490 282490 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_4                                                   2                                             2
282491 282491 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_5                                                   3                                             3
282492 282492 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_6                                                   3                                             3
282493 282493 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_7                                                   4                                             4
282494 282494 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_8                                                   1                                             1
282495 282495 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   6                                             6
282496 282496 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   kindergarten                                                   2                                             2
282420 282420 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 262.0 16.0 42.0 3.0   2.0         23.0   184.0 164.0             253     58   348 262 16 42 3   2         23   184 164         253   58   348
282421 282421 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   56                                             56
282422 282422 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   58                                             58
282423 282423 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   62                                             62
282424 282424 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   76                                             76
282425 282425 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   57                                             57
282426 282426 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   38                                             38
282427 282427 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281765 281765 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   pk_12_total 80.0   7.0     1.0         1.0   43.0 46.0             31     14   89 80   7     1         1   43 46         31   14   89
281766 281766 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_5                                                   25                                             25
281767 281767 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_6                                                   31                                             31
281768 281768 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_7                                                   15                                             15
281769 281769 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_8                                                   18                                             18
281770 281770 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   pk_12_total 116.0   5.0               3.0   62.0 62.0             42     17   124 116   5               3   62 62         42   17   124
281771 281771 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   14                                             14
281772 281772 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_2                                                   21                                             21
281773 281773 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   19                                             19
281774 281774 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   24                                             24
281775 281775 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   22                                             22
281776 281776 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   24                                             24
281777 281777 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   pk_12_total 100.0 2.0 3.0 1.0   2.0         1.0   55.0 54.0             33     14   109 100 2 3 1   2         1   55 54         33   14   109
281778 281778 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_10                                                   35                                             35
281779 281779 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_11                                                   26                                             26
281780 281780 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_12                                                   19                                             19
281781 281781 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_9                                                   29                                             29
288800 288800 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No 1.0 PK 08 2016   pk_12_total 178.0 57.0 92.0 7.0   17.0         5.0   177.0 179.0             234     62   356 178 57 92 7   17         5   177 179         234   62   356

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