enrollments

Data source: Big Local News · About: Big Local

14,653 rows where state = "WI" and year = 2015 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,553 ✖
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
125820 125820 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
125821 125821 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2015   grade_12                                                   1                                             1
126305 126305 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
126306 126306 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   grade_12                                                   1                                             1
112658 112658 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 183.0 3.0 13.0 1.0   2.0       1.0 10.0   118.0 95.0             41     21   213 183 3 13 1   2       1 10   118 95         41   21   213
112659 112659 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   68                                             68
112660 112660 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   67                                             67
112661 112661 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   72                                             72
112662 112662 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   6                                             6
112908 112908 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No 1.0 PK 01 2015   pk_12_total 289.0 6.0 7.0 85.0                 205.0 182.0             193     49   387 289 6 7 85                 205 182         193   49   387
112909 112909 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No 1.0 PK 01 2015   grade_1                                                   128                                             128
112910 112910 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   116                                             116
112911 112911 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No 1.0 PK 01 2015   kindergarten                                                   137                                             137
112912 112912 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   6                                             6
114250 114250 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 237.0 5.0 26.0 3.0             9.0   164.0 116.0             89     40   280 237 5 26 3             9   164 116         89   40   280
114251 114251 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   92                                             92
114252 114252 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   84                                             84
114253 114253 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   91                                             91
114254 114254 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   13                                             13
116544 116544 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 487.0 4.0 32.0 3.0   12.0         31.0   330.0 239.0             147     102   569 487 4 32 3   12         31   330 239         147   102   569
116545 116545 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   114                                             114
116546 116546 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   223                                             223
116547 116547 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   199                                             199
116548 116548 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   33                                             33
118392 118392 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 PK 01 2015   pk_12_total 48.0 3.0 62.0 1.0   2.0         4.0   65.0 55.0             79     22   120 48 3 62 1   2         4   65 55         79   22   120
118393 118393 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 PK 01 2015   grade_1                                                   33                                             33
118394 118394 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   24                                             24
118395 118395 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 PK 01 2015   kindergarten                                                   46                                             46
118396 118396 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   17                                             17
119455 119455 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   pk_12_total 127.0 7.0 36.0 2.0   5.0         6.0   101.0 82.0             54     14   183 127 7 36 2   5         6   101 82         54   14   183
119456 119456 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   grade_1                                                   41                                             41
119457 119457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   kindergarten_3_year_old                                                   40                                             40
119458 119458 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   42                                             42
119459 119459 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   kindergarten                                                   60                                             60
120403 120403 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 334.0 7.0 9.0 1.0   13.0         12.0   200.0 176.0             63     36   376 334 7 9 1   13         12   200 176         63   36   376
120404 120404 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   147                                             147
120405 120405 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   70                                             70
120406 120406 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   154                                             154
120407 120407 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   5                                             5
121469 121469 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 217.0 6.0 16.0     1.0         3.0   131.0 112.0             70     26   243 217 6 16     1         3   131 112         70   26   243
121470 121470 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   80                                             80
121471 121471 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   78                                             78
121472 121472 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   81                                             81
121473 121473 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   4                                             4
121976 121976 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   pk_12_total 295.0 20.0 7.0     7.0         8.0   196.0 141.0             139     47   337 295 20 7     7         8   196 141         139   47   337
121977 121977 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   grade_1                                                   120                                             120
121978 121978 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   99                                             99
121979 121979 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   kindergarten                                                   109                                             109
121980 121980 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   9                                             9
122124 122124 WI Columbia   school 5512060 4501 Public school Portage Community 551206002711 110 Woodridge Elementary   Regular School No 1.0 KG 01 2015   pk_12_total 139.0 6.0 9.0 1.0   2.0         11.0   89.0 79.0             86     31   168 139 6 9 1   2         11   89 79         86   31   168
122125 122125 WI Columbia   school 5512060 4501 Public school Portage Community 551206002711 110 Woodridge Elementary   Regular School No 1.0 KG 01 2015   grade_1                                                   98                                             98
122126 122126 WI Columbia   school 5512060 4501 Public school Portage Community 551206002711 110 Woodridge Elementary   Regular School No 1.0 KG 01 2015   kindergarten                                                   70                                             70
122164 122164 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   pk_12_total 214.0 1.0 8.0     2.0         4.0   121.0 108.0             151     50   229 214 1 8     2         4   121 108         151   50   229
122165 122165 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   grade_1                                                   80                                             80
122166 122166 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   70                                             70
122167 122167 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   kindergarten                                                   71                                             71
122168 122168 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   8                                             8
125193 125193 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No 1.0 PK 01 2015   pk_12_total 343.0 4.0 31.0               8.0   215.0 171.0             155     66   386 343 4 31               8   215 171         155   66   386
125194 125194 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No 1.0 PK 01 2015   grade_1                                                   118                                             118
125195 125195 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   130                                             130
125196 125196 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No 1.0 PK 01 2015   kindergarten                                                   118                                             118
125197 125197 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   20                                             20
111910 111910 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 366.0 4.0 13.0 3.0   2.0       1.0 7.0   213.0 183.0             175     42   396 366 4 13 3   2       1 7   213 183         175   42   396
111911 111911 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   83                                             83
111912 111912 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   126                                             126
111913 111913 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   kindergarten_4_year_old                                                   93                                             93
111914 111914 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   kindergarten                                                   90                                             90
111915 111915 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   4                                             4
112302 112302 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   pk_12_total 278.0 2.0 7.0 122.0             22.0   208.0 223.0             279     88   431 278 2 7 122             22   208 223         279   88   431
112303 112303 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   grade_1                                                   140                                             140
112304 112304 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   grade_2                                                   133                                             133
112305 112305 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   kindergarten                                                   132                                             132
112306 112306 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   26                                             26
112787 112787 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 302.0 10.0 25.0 1.0   3.0         22.0   184.0 179.0             170     42   363 302 10 25 1   3         22   184 179         170   42   363
112788 112788 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   86                                             86
112789 112789 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   93                                             93
112790 112790 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   kindergarten_4_year_old                                                   69                                             69
112791 112791 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   kindergarten                                                   102                                             102
112792 112792 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   13                                             13
113434 113434 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 33.0   3.0                   18.0 18.0             *     3   36 33   3                   18 18             3   36
113435 113435 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   12                                             12
113436 113436 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   12                                             12
113437 113437 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   kindergarten_4_year_old                                                   8                                             8
113438 113438 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   kindergarten                                                   4                                             4
114683 114683 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 345.0 5.0 20.0     1.0         5.0   196.0 180.0             87     38   376 345 5 20     1         5   196 180         87   38   376
114684 114684 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   95                                             95
114685 114685 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   143                                             143
114686 114686 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   kindergarten                                                   128                                             128
114687 114687 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   10                                             10
115861 115861 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2015   pk_12_total 58.0 1.0 2.0     1.0         1.0   25.0 38.0             10     5   63 58 1 2     1         1   25 38         10   5   63
115862 115862 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2015   grade_1                                                   23                                             23
115863 115863 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2015   grade_2                                                   23                                             23
115864 115864 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2015   kindergarten                                                   17                                             17
115873 115873 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 306.0   19.0 1.0   11.0       2.0 9.0   170.0 178.0             72     46   348 306   19 1   11       2 9   170 178         72   46   348
115874 115874 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   91                                             91
115875 115875 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   89                                             89
115876 115876 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   kindergarten_4_year_old                                                   87                                             87
115877 115877 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   kindergarten                                                   79                                             79
115878 115878 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   2                                             2
115917 115917 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No 1.0 PK 02 2015   pk_12_total 273.0 1.0 13.0 136.0   4.0         13.0   224.0 216.0             264     76   440 273 1 13 136   4         13   224 216         264   76   440

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