enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,564 ✖
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
326093 326093 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_7                                                   9                                             9
326094 326094 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_8                                                   14                                             14
326095 326095 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_9                                                   10                                             10
326104 326104 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   pk_12_total 442.0 40.0 30.0 7.0   18.0         31.0   245.0 323.0             181     8   568 442 40 30 7   18         31   245 323         181   8   568
326105 326105 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_1                                                   26                                             26
326106 326106 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_10                                                   65                                             65
326107 326107 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_11                                                   74                                             74
326108 326108 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_12                                                   56                                             56
326109 326109 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_2                                                   22                                             22
326110 326110 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_3                                                   23                                             23
326111 326111 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_4                                                   25                                             25
326112 326112 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_5                                                   32                                             32
326113 326113 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_6                                                   53                                             53
326114 326114 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_7                                                   49                                             49
326115 326115 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_8                                                   62                                             62
326116 326116 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_9                                                   58                                             58
326117 326117 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   kindergarten                                                   23                                             23
326158 326158 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   pk_12_total 20.0     4.0                 13.0 11.0             10     4   24 20     4                 13 11         10   4   24
326159 326159 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_10                                                   2                                             2
326160 326160 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_11                                                   4                                             4
326161 326161 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_12                                                   3                                             3
326162 326162 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_9                                                   15                                             15
326163 326163 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   pk_12_total 58.0   2.0 8.0   1.0         3.0   33.0 39.0             34     7   72 58   2 8   1         3   33 39         34   7   72
326164 326164 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_3                                                   23                                             23
326165 326165 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_4                                                   26                                             26
326166 326166 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_5                                                   23                                             23
326192 326192 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   pk_12_total 48.0   1.0 6.0             2.0   36.0 21.0             31     8   57 48   1 6             2   36 21         31   8   57
326193 326193 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_6                                                   21                                             21
326194 326194 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_7                                                   20                                             20
326195 326195 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_8                                                   16                                             16
326280 326280 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   pk_12_total 69.0                   1.0   29.0 41.0             13     3   70 69                   1   29 41         13   3   70
326281 326281 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_10                                                   8                                             8
326282 326282 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_11                                                   11                                             11
326283 326283 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_12                                                   9                                             9
326284 326284 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_7                                                   13                                             13
326285 326285 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_8                                                   13                                             13
326286 326286 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2017   grade_9                                                   16                                             16
326382 326382 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   pk_12_total 42.0   14.0             1.0 1.0   29.0 29.0             30     2   58 42   14             1 1   29 29         30   2   58
326383 326383 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_1                                                   1                                             1
326384 326384 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_10                                                   8                                             8
326385 326385 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_11                                                   7                                             7
326386 326386 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_12                                                   11                                             11
326387 326387 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
326388 326388 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_3                                                   1                                             1
326389 326389 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_4                                                   3                                             3
326390 326390 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_5                                                   1                                             1
326391 326391 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_6                                                   3                                             3
326392 326392 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_7                                                   4                                             4
326393 326393 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_8                                                   7                                             7
326394 326394 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_9                                                   9                                             9
326395 326395 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   kindergarten                                                   2                                             2
326404 326404 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   pk_12_total 51.0 5.0   1.0             4.0   32.0 29.0             28     4   61 51 5   1             4   32 29         28   4   61
326405 326405 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   grade_1                                                   11                                             11
326406 326406 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   grade_2                                                   10                                             10
326407 326407 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   grade_3                                                   3                                             3
326408 326408 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   kindergarten_4_year_old                                                   25                                             25
326409 326409 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2017   kindergarten                                                   12                                             12
326653 326653 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   pk_12_total 19.0 8.0 5.0               1.0   14.0 19.0             23     1   33 19 8 5               1   14 19         23   1   33
326654 326654 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_10                                                   10                                             10
326655 326655 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_11                                                   3                                             3
326656 326656 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_12                                                   4                                             4
326657 326657 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_6                                                   5                                             5
326658 326658 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_7                                                   1                                             1
326659 326659 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_8                                                   7                                             7
326660 326660 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes Other 06 12 2017   grade_9                                                   3                                             3
326729 326729 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   pk_12_total 7.0 2.0                 2.0   5.0 6.0             *     4   11 7 2                 2   5 6             4   11
326730 326730 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_10                                                   3                                             3
326731 326731 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_11                                                   2                                             2
326732 326732 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_12                                                   1                                             1
326733 326733 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_7                                                   1                                             1
326734 326734 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_8                                                   3                                             3
326735 326735 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_9                                                   1                                             1
326754 326754 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   pk_12_total 42.0   4.0               1.0   25.0 22.0             36     5   47 42   4               1   25 22         36   5   47
326755 326755 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_1                                                   9                                             9
326756 326756 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_2                                                   8                                             8
326757 326757 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_3                                                   1                                             1
326758 326758 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_4                                                   4                                             4
326759 326759 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_5                                                   5                                             5
326760 326760 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_6                                                   3                                             3
326761 326761 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   kindergarten_4_year_old                                                   9                                             9
326762 326762 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2017   kindergarten                                                   8                                             8
326817 326817 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   pk_12_total 57.0                       34.0 23.0             14     4   57 57                       34 23         14   4   57
326818 326818 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_1                                                   9                                             9
326819 326819 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_2                                                   6                                             6
326820 326820 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_3                                                   9                                             9
326821 326821 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_4                                                   12                                             12
326822 326822 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_5                                                   10                                             10
326823 326823 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_6                                                   11                                             11
327004 327004 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   pk_12_total 23.0 1.0 1209.0     1.0         1.0   600.0 635.0             1     91   1235 23 1 1209     1         1   600 635         1   91   1235
327005 327005 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_1                                                   137                                             137
327006 327006 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_2                                                   136                                             136
327007 327007 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_3                                                   135                                             135
327008 327008 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_4                                                   112                                             112
327009 327009 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_5                                                   112                                             112
327010 327010 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_6                                                   107                                             107
327011 327011 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_7                                                   108                                             108
327012 327012 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_8                                                   100                                             100
327013 327013 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   144                                             144
327014 327014 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   kindergarten                                                   144                                             144
327127 327127 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   pk_12_total 61.0 1.0                     27.0 35.0             5     2   62 61 1                     27 35         5   2   62

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