enrollments

Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,649 ✖
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
3074390 3074390 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_5                                                   30                                             30
3074391 3074391 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_6                                                   34                                             34
3074392 3074392 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_7                                                   44                                             44
3074393 3074393 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_8                                                   62                                             62
3074394 3074394 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_9                                                   63                                             63
3074395 3074395 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   kindergarten                                                   15                                             15
3074446 3074446 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   pk_12_total 13.0   1.0 10.0                 12.0 12.0             *     6   24 13   1 10                 12 12             6   24
3074447 3074447 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_10                                                   4                                             4
3074448 3074448 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_11                                                   8                                             8
3074449 3074449 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_12                                                   2                                             2
3074450 3074450 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_9                                                   10                                             10
3074455 3074455 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   pk_12_total 48.0 1.0 2.0 12.0   2.0         7.0   32.0 40.0             46     8   72 48 1 2 12   2         7   32 40         46   8   72
3074456 3074456 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_3                                                   21                                             21
3074457 3074457 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_4                                                   14                                             14
3074458 3074458 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_5                                                   26                                             26
3074459 3074459 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_6                                                   11                                             11
3074473 3074473 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   pk_12_total 14.0     6.0             3.0   14.0 9.0             *     8   23 14     6             3   14 9             8   23
3074474 3074474 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   grade_7                                                   7                                             7
3074475 3074475 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   grade_8                                                   16                                             16
3074559 3074559 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   pk_12_total 70.0                   1.0   34.0 37.0             22     3   71 70                   1   34 37         22   3   71
3074560 3074560 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_10                                                   13                                             13
3074561 3074561 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_11                                                   15                                             15
3074562 3074562 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_12                                                   3                                             3
3074563 3074563 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_7                                                   13                                             13
3074564 3074564 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_8                                                   13                                             13
3074565 3074565 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   grade_9                                                   14                                             14
3074662 3074662 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   pk_12_total 35.0 2.0 6.0               4.0   22.0 25.0             25     6   47 35 2 6               4   22 25         25   6   47
3074663 3074663 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_10                                                   7                                             7
3074664 3074664 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_11                                                   7                                             7
3074665 3074665 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_12                                                   17                                             17
3074666 3074666 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_2                                                   1                                             1
3074667 3074667 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_4                                                   1                                             1
3074668 3074668 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_5                                                   1                                             1
3074669 3074669 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_6                                                   1                                             1
3074670 3074670 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_7                                                   1                                             1
3074671 3074671 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_8                                                   6                                             6
3074672 3074672 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_9                                                   5                                             5
3074678 3074678 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   pk_12_total 42.0 10.0 6.0 1.0             1.0   30.0 30.0             37     3   60 42 10 6 1             1   30 30         37   3   60
3074679 3074679 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   grade_1                                                   14                                             14
3074680 3074680 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   grade_2                                                   6                                             6
3074681 3074681 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   grade_3                                                   6                                             6
3074682 3074682 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   kindergarten_4_year_old                                                   15                                             15
3074683 3074683 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   kindergarten                                                   7                                             7
3074684 3074684 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   pre_kindergarten                                                   12                                             12
3074930 3074930 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   pk_12_total 30.0 5.0 3.0                   19.0 19.0             26     5   38 30 5 3                   19 19         26   5   38
3074931 3074931 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_10                                                   6                                             6
3074932 3074932 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_11                                                   8                                             8
3074933 3074933 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_12                                                   6                                             6
3074934 3074934 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_6                                                   1                                             1
3074935 3074935 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_7                                                   4                                             4
3074936 3074936 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_8                                                   6                                             6
3074937 3074937 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes High 06 12 2019   grade_9                                                   7                                             7
3075007 3075007 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   pk_12_total 8.0 1.0                 2.0   5.0 6.0             *     3   11 8 1                 2   5 6             3   11
3075008 3075008 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_10                                                   1                                             1
3075009 3075009 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_11                                                   1                                             1
3075010 3075010 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_12                                                   2                                             2
3075011 3075011 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_7                                                   3                                             3
3075012 3075012 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_8                                                   1                                             1
3075013 3075013 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2019   grade_9                                                   3                                             3
3075031 3075031 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   pk_12_total 33.0   2.0                   18.0 17.0             15     4   35 33   2                   18 17         15   4   35
3075032 3075032 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_1                                                   9                                             9
3075033 3075033 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_2                                                   3                                             3
3075034 3075034 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_3                                                   5                                             5
3075035 3075035 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_4                                                   7                                             7
3075036 3075036 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_5                                                   1                                             1
3075037 3075037 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_6                                                   2                                             2
3075038 3075038 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   kindergarten_4_year_old                                                   3                                             3
3075039 3075039 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   kindergarten                                                   5                                             5
3075040 3075040 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   pk_12_total 11.0                       5.0 6.0             *     3   11 11                       5 6             3   11
3075041 3075041 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_10                                                   1                                             1
3075042 3075042 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_11                                                   2                                             2
3075043 3075043 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_12                                                   2                                             2
3075044 3075044 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_3                                                   2                                             2
3075045 3075045 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_6                                                   1                                             1
3075046 3075046 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_7                                                   1                                             1
3075047 3075047 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   grade_9                                                   2                                             2
3075292 3075292 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   pk_12_total 23.0 2.0 1281.0     1.0         3.0   626.0 684.0             347     85   1310 23 2 1281     1         3   626 684         347   85   1310
3075293 3075293 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_1                                                   131                                             131
3075294 3075294 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_2                                                   135                                             135
3075295 3075295 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_3                                                   141                                             141
3075296 3075296 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_4                                                   140                                             140
3075297 3075297 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_5                                                   140                                             140
3075298 3075298 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_6                                                   129                                             129
3075299 3075299 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_7                                                   105                                             105
3075300 3075300 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   grade_8                                                   102                                             102
3075301 3075301 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   kindergarten_4_year_old                                                   144                                             144
3075302 3075302 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2019   kindergarten                                                   143                                             143
3075372 3075372 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3075373 3075373 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   grade_10                                                   1                                             1
3075374 3075374 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   grade_11                                                   1                                             1
3075424 3075424 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   pk_12_total 12.0                       7.0 5.0             4     3   12 12                       7 5         4   3   12
3075425 3075425 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_10                                                   2                                             2
3075426 3075426 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_7                                                   3                                             3
3075427 3075427 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_8                                                   7                                             7
3075432 3075432 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   pk_12_total 83.0   1.0               8.0   35.0 57.0             32     2   92 83   1               8   35 57         32   2   92
3075433 3075433 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_1                                                   6                                             6
3075434 3075434 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_10                                                   12                                             12
3075435 3075435 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_11                                                   9                                             9
3075436 3075436 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_12                                                   8                                             8
3075437 3075437 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_2                                                   7                                             7

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