enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,602 ✖
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
3098307 3098307 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   37                                             37
3098308 3098308 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   44                                             44
3098309 3098309 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   42                                             42
3098310 3098310 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   47                                             47
3098311 3098311 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   44                                             44
3098312 3098312 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   37                                             37
3098313 3098313 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3095724 3095724 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   pk_12_total 222.0 55.0 155.0 6.0   165.0         22.0   310.0 315.0             430     87   625 222 55 155 6   165         22   310 315         430   87   625
3095725 3095725 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_1                                                   92                                             92
3095726 3095726 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_2                                                   95                                             95
3095727 3095727 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_3                                                   85                                             85
3095728 3095728 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_4                                                   82                                             82
3095729 3095729 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_5                                                   85                                             85
3095730 3095730 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   kindergarten_3_year_old                                                   5                                             5
3095731 3095731 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   84                                             84
3095732 3095732 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   kindergarten                                                   97                                             97
3098495 3098495 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   pk_12_total 47.0 2.0 1.0     7.0         3.0   32.0 28.0             7         60 47 2 1     7         3   32 28         7       60
3098496 3098496 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   grade_4                                                   9                                             9
3098497 3098497 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   grade_5                                                   11                                             11
3098498 3098498 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   grade_6                                                   12                                             12
3098499 3098499 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   grade_7                                                   13                                             13
3098500 3098500 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2018   grade_8                                                   15                                             15
3093267 3093267 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   pk_12_total 229.0 16.0 35.0     5.0         27.0   169.0 143.0             195     50   312 229 16 35     5         27   169 143         195   50   312
3093268 3093268 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   41                                             41
3093269 3093269 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   42                                             42
3093270 3093270 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   56                                             56
3093271 3093271 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   67                                             67
3093272 3093272 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   47                                             47
3093273 3093273 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   13                                             13
3093274 3093274 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   38                                             38
3093275 3093275 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   8                                             8
3088669 3088669 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pk_12_total 380.0 12.0 45.0 1.0   2.0         5.0   218.0 227.0             251     98   445 380 12 45 1   2         5   218 227         251   98   445
3088670 3088670 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   46                                             46
3088671 3088671 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3088672 3088672 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   56                                             56
3088673 3088673 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   74                                             74
3088674 3088674 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   79                                             79
3088675 3088675 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   60                                             60
3088676 3088676 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   53                                             53
3088677 3088677 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   14                                             14
3088678 3088678 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   pk_12_total 422.0 8.0 24.0 5.0   1.0         5.0   247.0 218.0             325     99   465 422 8 24 5   1         5   247 218         325   99   465
3088679 3088679 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_10                                                   116                                             116
3088680 3088680 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_11                                                   135                                             135
3088681 3088681 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_12                                                   101                                             101
3088682 3088682 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_9                                                   113                                             113
3088683 3088683 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   pk_12_total 297.0 3.0 23.0 4.0           2.0 2.0   170.0 161.0             208     69   331 297 3 23 4           2 2   170 161         208   69   331
3088684 3088684 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_6                                                   102                                             102
3088685 3088685 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_7                                                   106                                             106
3088686 3088686 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_8                                                   123                                             123
3100550 3100550 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   pk_12_total 439.0 9.0 19.0 2.0   2.0         7.0   239.0 239.0             32     65   478 439 9 19 2   2         7   239 239         32   65   478
3100551 3100551 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   65                                             65
3100552 3100552 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   70                                             70
3100553 3100553 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   74                                             74
3100554 3100554 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   76                                             76
3100555 3100555 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   63                                             63
3100556 3100556 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   54                                             54
3100557 3100557 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   69                                             69
3100558 3100558 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   7                                             7
3089418 3089418 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   pk_12_total 41.0   9.0               1.0   25.0 26.0             19     3   51 41   9               1   25 26         19   3   51
3089419 3089419 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
3089420 3089420 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_10                                                   7                                             7
3089421 3089421 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_11                                                   11                                             11
3089422 3089422 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_12                                                   10                                             10
3089423 3089423 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_3                                                   2                                             2
3089424 3089424 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_5                                                   3                                             3
3089425 3089425 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_6                                                   2                                             2
3089426 3089426 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_7                                                   2                                             2
3089427 3089427 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_8                                                   6                                             6
3089428 3089428 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_9                                                   7                                             7
3089356 3089356 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   pk_12_total 247.0 13.0 45.0 2.0   2.0         29.0   172.0 166.0             215     61   338 247 13 45 2   2         29   172 166         215   61   338
3089357 3089357 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   64                                             64
3089358 3089358 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   54                                             54
3089359 3089359 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   52                                             52
3089360 3089360 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   63                                             63
3089361 3089361 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   69                                             69
3089362 3089362 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   36                                             36
3088703 3088703 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   pk_12_total 70.0   6.0     1.0         2.0   43.0 36.0             31     16   79 70   6     1         2   43 36         31   16   79
3088704 3088704 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_6                                                   27                                             27
3088705 3088705 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_7                                                   22                                             22
3088706 3088706 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   30                                             30
3088707 3088707 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   pk_12_total 144.0 1.0 7.0               5.0   77.0 80.0             67     19   157 144 1 7               5   77 80         67   19   157
3088708 3088708 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   16                                             16
3088709 3088709 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
3088710 3088710 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   18                                             18
3088711 3088711 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   20                                             20
3088712 3088712 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   20                                             20
3088713 3088713 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   25                                             25
3088714 3088714 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   29                                             29
3088715 3088715 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
3088716 3088716 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   pk_12_total 92.0 1.0       2.0         1.0   41.0 55.0             26     13   96 92 1       2         1   41 55         26   13   96
3088717 3088717 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_10                                                   19                                             19
3088718 3088718 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_11                                                   24                                             24
3088719 3088719 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_12                                                   29                                             29
3088720 3088720 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_9                                                   24                                             24
3095742 3095742 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   pk_12_total 128.0 61.0 107.0 6.0   13.0         9.0   175.0 149.0             212     56   324 128 61 107 6   13         9   175 149         212   56   324
3095743 3095743 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   42                                             42
3095744 3095744 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   34                                             34
3095745 3095745 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   27                                             27
3095746 3095746 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   30                                             30
3095747 3095747 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   29                                             29

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