enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
3103338 3103338 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   35                                             35
3103337 3103337 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   28                                             28
3103336 3103336 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   69                                             69
3103335 3103335 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   72                                             72
3103334 3103334 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   48                                             48
3103333 3103333 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   50                                             50
3103332 3103332 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   36                                             36
3103331 3103331 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   43                                             43
3103330 3103330 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   42                                             42
3103329 3103329 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   40                                             40
3103328 3103328 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   pk_12_total 415.0   31.0     1.0       1.0 15.0   249.0 214.0             44     48   463 415   31     1       1 15   249 214         44   48   463
3103327 3103327 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_8                                                   94                                             94
3103326 3103326 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_7                                                   96                                             96
3103325 3103325 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_6                                                   95                                             95
3103324 3103324 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_5                                                   77                                             77
3103323 3103323 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   pk_12_total 314.0   38.0 4.0           1.0 5.0   184.0 178.0             73     31   362 314   38 4           1 5   184 178         73   31   362
3103322 3103322 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2018   grade_9                                                   110                                             110
3103321 3103321 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2018   grade_12                                                   128                                             128
3103320 3103320 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2018   grade_11                                                   122                                             122
3103319 3103319 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2018   grade_10                                                   129                                             129
3103318 3103318 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2018   pk_12_total 453.0 2.0 19.0 4.0   2.0       1.0 8.0   255.0 234.0             58     41   489 453 2 19 4   2       1 8   255 234         58   41   489
3103317 3103317 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   6                                             6
3103316 3103316 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   70                                             70
3103315 3103315 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   74                                             74
3103314 3103314 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   84                                             84
3103313 3103313 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   grade_3                                                   84                                             84
3103312 3103312 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   86                                             86
3103311 3103311 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   93                                             93
3103310 3103310 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   pk_12_total 414.0 4.0 52.0 4.0   5.0       4.0 14.0   242.0 255.0             138     65   497 414 4 52 4   5       4 14   242 255         138   65   497
3103309 3103309 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   2                                             2
3103308 3103308 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   67                                             67
3103307 3103307 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   44                                             44
3103306 3103306 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   59                                             59
3103305 3103305 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   57                                             57
3103304 3103304 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   51                                             51
3103303 3103303 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   59                                             59
3103302 3103302 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   50                                             50
3103301 3103301 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   49                                             49
3103300 3103300 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   44                                             44
3103299 3103299 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   51                                             51
3103298 3103298 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   pk_12_total 429.0 4.0 22.0 44.0   4.0       4.0 26.0   265.0 268.0             237     61   533 429 4 22 44   4       4 26   265 268         237   61   533
3103297 3103297 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   kindergarten                                                   33                                             33
3103296 3103296 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   31                                             31
3103295 3103295 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_6                                                   28                                             28
3103294 3103294 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_5                                                   40                                             40
3103293 3103293 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_4                                                   38                                             38
3103292 3103292 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_3                                                   36                                             36
3103291 3103291 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_2                                                   39                                             39
3103290 3103290 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_1                                                   37                                             37
3103289 3103289 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   pk_12_total 31.0 180.0 23.0 4.0   8.0         36.0   143.0 139.0             153     29   282 31 180 23 4   8         36   143 139         153   29   282
3103288 3103288 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   kindergarten                                                   37                                             37
3103287 3103287 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   30                                             30
3103286 3103286 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   36                                             36
3103285 3103285 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_7                                                   35                                             35
3103284 3103284 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_6                                                   36                                             36
3103283 3103283 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_5                                                   33                                             33
3103282 3103282 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_4                                                   37                                             37
3103281 3103281 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_3                                                   35                                             35
3103280 3103280 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_2                                                   37                                             37
3103279 3103279 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_1                                                   35                                             35
3103278 3103278 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   pk_12_total 182.0 81.0 41.0 3.0   10.0         34.0   182.0 169.0             53     32   351 182 81 41 3   10         34   182 169         53   32   351
3103277 3103277 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2018   grade_5                                                   1                                             1
3103276 3103276 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2018   pk_12_total                     1.0   1.0               *     *   1                     1   1                   1
3103275 3103275 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_8                                                   23                                             23
3103274 3103274 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_7                                                   22                                             22
3103273 3103273 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_6                                                   33                                             33
3103272 3103272 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   pk_12_total 69.0   1.0             2.0 6.0   33.0 45.0             43     6   78 69   1             2 6   33 45         43   6   78
3103271 3103271 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2018   grade_9                                                   32                                             32
3103270 3103270 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2018   grade_12                                                   24                                             24
3103269 3103269 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2018   grade_11                                                   31                                             31
3103268 3103268 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2018   grade_10                                                   22                                             22
3103267 3103267 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2018   pk_12_total 101.0 2.0 3.0             1.0 2.0   55.0 54.0             50     19   109 101 2 3             1 2   55 54         50   19   109
3103266 3103266 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   4                                             4
3103265 3103265 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   20                                             20
3103264 3103264 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   21                                             21
3103263 3103263 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   25                                             25
3103262 3103262 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   15                                             15
3103261 3103261 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   22                                             22
3103260 3103260 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   27                                             27
3103259 3103259 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   19                                             19
3103258 3103258 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   pk_12_total 144.0 1.0 3.0             1.0 4.0   84.0 69.0             79     26   153 144 1 3             1 4   84 69         79   26   153
3103257 3103257 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2018   pk_12_total                                                   0                                             0
3103256 3103256 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2018   grade_9                                                   88                                             88
3103255 3103255 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2018   grade_12                                                   92                                             92
3103254 3103254 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2018   grade_11                                                   71                                             71
3103253 3103253 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2018   grade_10                                                   77                                             77
3103252 3103252 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2018   pk_12_total 275.0 2.0 23.0 15.0   4.0         9.0   180.0 148.0             99     41   328 275 2 23 15   4         9   180 148         99   41   328
3103251 3103251 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   8                                             8
3103250 3103250 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   40                                             40
3103249 3103249 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   47                                             47
3103248 3103248 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   50                                             50
3103247 3103247 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   46                                             46
3103246 3103246 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   44                                             44
3103245 3103245 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   45                                             45
3103244 3103244 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   43                                             43
3103243 3103243 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   42                                             42
3103242 3103242 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   39                                             39
3103241 3103241 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   46                                             46
3103240 3103240 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   pk_12_total 357.0   44.0 23.0   2.0         24.0   250.0 200.0             193     84   450 357   44 23   2         24   250 200         193   84   450
3103239 3103239 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   37                                             37

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