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,702 ✖
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
3088637 3088637 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   pk_12_total 66.0 255.0 165.0     3.0         47.0   243.0 293.0             416     57   536 66 255 165     3         47   243 293         416   57   536
3088638 3088638 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_1                                                   59                                             59
3088639 3088639 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_2                                                   52                                             52
3088640 3088640 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_3                                                   51                                             51
3088641 3088641 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_4                                                   60                                             60
3088642 3088642 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_5                                                   58                                             58
3088643 3088643 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_6                                                   60                                             60
3088644 3088644 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_7                                                   39                                             39
3088645 3088645 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   58                                             58
3088646 3088646 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   40                                             40
3088647 3088647 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   kindergarten                                                   59                                             59
3095613 3095613 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   pk_12_total 32.0 2.0 2.0     1.0         1.0   20.0 18.0             3     6   38 32 2 2     1         1   20 18         3   6   38
3095614 3095614 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
3095615 3095615 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_10                                                   3                                             3
3095616 3095616 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_11                                                   5                                             5
3095617 3095617 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_12                                                   12                                             12
3095618 3095618 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_2                                                   1                                             1
3095619 3095619 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_4                                                   1                                             1
3095620 3095620 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_5                                                   3                                             3
3095621 3095621 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_7                                                   4                                             4
3095622 3095622 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_8                                                   7                                             7
3095623 3095623 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   kindergarten                                                   1                                             1
3094010 3094010 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   pk_12_total 251.0 6.0 10.0 2.0   10.0         13.0   172.0 120.0             30     41   292 251 6 10 2   10         13   172 120         30   41   292
3094011 3094011 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   279                                             279
3094012 3094012 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   13                                             13
3090067 3090067 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2018   pk_12_total 33.0   4.0               2.0   24.0 15.0             10     5   39 33   4               2   24 15         10   5   39
3090068 3090068 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   39                                             39
3099554 3099554 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2018   pk_12_total 91.0 1.0 5.0 2.0   1.0         2.0   52.0 50.0             39     12   102 91 1 5 2   1         2   52 50         39   12   102
3099555 3099555 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   102                                             102
3095223 3095223 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2018   pk_12_total 132.0   6.0 1.0   2.0         9.0   74.0 76.0             14     14   150 132   6 1   2         9   74 76         14   14   150
3095224 3095224 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   150                                             150
3094563 3094563 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2018   pk_12_total 373.0 143.0 132.0 2.0   45.0       2.0 47.0   377.0 367.0             302     53   744 373 143 132 2   45       2 47   377 367         302   53   744
3094564 3094564 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   744                                             744
3094074 3094074 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2018   pk_12_total 33.0 2.0       4.0         2.0   18.0 23.0             19     6   41 33 2       4         2   18 23         19   6   41
3094075 3094075 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2018   grade_10                                                   13                                             13
3094076 3094076 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2018   grade_11                                                   9                                             9
3094077 3094077 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2018   grade_12                                                   10                                             10
3094078 3094078 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2018   grade_9                                                   9                                             9
3097591 3097591 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   pk_12_total 108.0   3.0 1.0   8.0         4.0   69.0 55.0             14     11   124 108   3 1   8         4   69 55         14   11   124
3097592 3097592 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_1                                                   24                                             24
3097593 3097593 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_2                                                   24                                             24
3097594 3097594 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_3                                                   14                                             14
3097595 3097595 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_4                                                   23                                             23
3097596 3097596 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_5                                                   17                                             17
3097597 3097597 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   kindergarten                                                   22                                             22
3095733 3095733 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   pk_12_total 4.0   488.0               2.0   269.0 225.0             446     91   494 4   488               2   269 225         446   91   494
3095734 3095734 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_1                                                   82                                             82
3095735 3095735 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_2                                                   74                                             74
3095736 3095736 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_3                                                   67                                             67
3095737 3095737 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_4                                                   44                                             44
3095738 3095738 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_5                                                   51                                             51
3095739 3095739 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   kindergarten_3_year_old                                                   35                                             35
3095740 3095740 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   kindergarten_4_year_old                                                   65                                             65
3095741 3095741 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   kindergarten                                                   76                                             76
3093276 3093276 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   pk_12_total 82.0 3.0 7.0               8.0   38.0 62.0             40     14   100 82 3 7               8   38 62         40   14   100
3093277 3093277 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_1                                                   4                                             4
3093278 3093278 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_10                                                   7                                             7
3093279 3093279 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_11                                                   16                                             16
3093280 3093280 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_12                                                   28                                             28
3093281 3093281 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_2                                                   1                                             1
3093282 3093282 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_3                                                   2                                             2
3093283 3093283 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_4                                                   1                                             1
3093284 3093284 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_5                                                   7                                             7
3093285 3093285 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_6                                                   9                                             9
3093286 3093286 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_7                                                   6                                             6
3093287 3093287 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_8                                                   10                                             10
3093288 3093288 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_9                                                   6                                             6
3093289 3093289 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   kindergarten                                                   3                                             3
3095779 3095779 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2018   pk_12_total   111.0 1.0               1.0   48.0 65.0             *     17   113   111 1               1   48 65             17   113
3095780 3095780 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2018   grade_10                                                   26                                             26
3095781 3095781 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2018   grade_11                                                   31                                             31
3095782 3095782 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2018   grade_12                                                   21                                             21
3095783 3095783 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2018   grade_9                                                   35                                             35
3088648 3088648 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   pk_12_total 162.0 3.0 209.0     1.0         2.0   204.0 173.0             275     51   377 162 3 209     1         2   204 173         275   51   377
3088649 3088649 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   58                                             58
3088650 3088650 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   54                                             54
3088651 3088651 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   53                                             53
3088652 3088652 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   52                                             52
3088653 3088653 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   65                                             65
3088654 3088654 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   42                                             42
3088655 3088655 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   51                                             51
3088656 3088656 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
3088657 3088657 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   pk_12_total 206.0 4.0 154.0     2.0         4.0   191.0 179.0             237     46   370 206 4 154     2         4   191 179         237   46   370
3088658 3088658 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_10                                                   44                                             44
3088659 3088659 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_11                                                   58                                             58
3088660 3088660 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_12                                                   49                                             49
3088661 3088661 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_6                                                   57                                             57
3088662 3088662 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_7                                                   58                                             58
3088663 3088663 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_8                                                   49                                             49
3088664 3088664 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_9                                                   55                                             55
3097321 3097321 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   pk_12_total 340.0 1.0 39.0     1.0         10.0   201.0 190.0             172     55   391 340 1 39     1         10   201 190         172   55   391
3097322 3097322 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
3097323 3097323 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   37                                             37
3097324 3097324 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   30                                             30
3097325 3097325 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   43                                             43
3097326 3097326 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   41                                             41
3097327 3097327 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   171                                             171
3097328 3097328 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   34                                             34
3098305 3098305 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   pk_12_total 274.0   8.0 1.0             7.0   144.0 146.0             67     28   290 274   8 1             7   144 146         67   28   290
3098306 3098306 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   38                                             38

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