enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by district_state_id

✎ 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
3090308 3090308 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2018   pk_12_total 993.0 13.0 28.0 3.0   32.0         21.0   518.0 572.0             63     80   1090 993 13 28 3   32         21   518 572         63   80   1090
3090309 3090309 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2018   grade_10                                                   275                                             275
3090310 3090310 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2018   grade_11                                                   268                                             268
3090311 3090311 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2018   grade_12                                                   291                                             291
3090312 3090312 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2018   grade_9                                                   256                                             256
3090313 3090313 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   pk_12_total 14.0                       10.0 4.0             1     *   14 14                       10 4         1       14
3090314 3090314 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                                                   13                                             13
3090315 3090315 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   grade_unknown                                                   1                                             1
3090316 3090316 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   pk_12_total 438.0 1.0 21.0 1.0   4.0       1.0 12.0   248.0 230.0             29     40   478 438 1 21 1   4       1 12   248 230         29   40   478
3090317 3090317 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   60                                             60
3090318 3090318 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   65                                             65
3090319 3090319 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   76                                             76
3090320 3090320 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   73                                             73
3090321 3090321 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   72                                             72
3090322 3090322 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   52                                             52
3090323 3090323 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   80                                             80
3090324 3090324 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   pk_12_total 452.0 5.0 10.0     10.0         12.0   243.0 246.0             17     45   489 452 5 10     10         12   243 246         17   45   489
3090325 3090325 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   81                                             81
3090326 3090326 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3090327 3090327 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   67                                             67
3090328 3090328 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   81                                             81
3090329 3090329 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   74                                             74
3090330 3090330 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   54                                             54
3090331 3090331 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   69                                             69
3090332 3090332 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2018   pk_12_total 612.0 10.0 34.0 3.0   17.0       1.0 18.0   358.0 337.0             50     70   695 612 10 34 3   17       1 18   358 337         50   70   695
3090333 3090333 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2018   grade_6                                                   212                                             212
3090334 3090334 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2018   grade_7                                                   229                                             229
3090335 3090335 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2018   grade_8                                                   254                                             254
3090336 3090336 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   pk_12_total 292.0 9.0 12.0 1.0   10.0         8.0   170.0 162.0             37     36   332 292 9 12 1   10         8   170 162         37   36   332
3090337 3090337 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   41                                             41
3090338 3090338 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   48                                             48
3090339 3090339 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   49                                             49
3090340 3090340 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   54                                             54
3090341 3090341 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   63                                             63
3090342 3090342 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   37                                             37
3090343 3090343 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   40                                             40
3090290 3090290 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   pk_12_total 319.0 4.0 35.0     7.0       1.0 4.0   207.0 163.0             65     53   370 319 4 35     7       1 4   207 163         65   53   370
3090291 3090291 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   58                                             58
3090292 3090292 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   66                                             66
3090293 3090293 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   grade_3                                                   61                                             61
3090294 3090294 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   67                                             67
3090295 3090295 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   49                                             49
3090296 3090296 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   60                                             60
3090297 3090297 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   9                                             9
3090298 3090298 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2018   pk_12_total 295.0 2.0 17.0 3.0   5.0             174.0 148.0             28     23   322 295 2 17 3   5             174 148         28   23   322
3090299 3090299 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2018   grade_10                                                   76                                             76
3090300 3090300 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2018   grade_11                                                   85                                             85
3090301 3090301 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2018   grade_12                                                   85                                             85
3090302 3090302 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2018   grade_9                                                   76                                             76
3090303 3090303 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2018   pk_12_total 260.0 1.0 33.0     6.0       1.0 4.0   158.0 147.0             55     25   305 260 1 33     6       1 4   158 147         55   25   305
3090304 3090304 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2018   grade_5                                                   80                                             80
3090305 3090305 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2018   grade_6                                                   72                                             72
3090306 3090306 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2018   grade_7                                                   81                                             81
3090307 3090307 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2018   grade_8                                                   72                                             72
3088773 3088773 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pk_12_total 143.0 2.0 47.0 1.0                 102.0 91.0             88     38   193 143 2 47 1                 102 91         88   38   193
3088774 3088774 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
3088775 3088775 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   21                                             21
3088776 3088776 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   31                                             31
3088777 3088777 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088778 3088778 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   31                                             31
3088779 3088779 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   22                                             22
3088780 3088780 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   28                                             28
3088781 3088781 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088782 3088782 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   pk_12_total 87.0   25.0 1.0                 66.0 47.0             60     12   113 87   25 1                 66 47         60   12   113
3088783 3088783 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_10                                                   38                                             38
3088784 3088784 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_11                                                   31                                             31
3088785 3088785 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_12                                                   27                                             27
3088786 3088786 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_9                                                   17                                             17
3088787 3088787 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   pk_12_total 72.0   18.0               1.0   53.0 38.0             39     19   91 72   18               1   53 38         39   19   91
3088788 3088788 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_6                                                   23                                             23
3088789 3088789 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_7                                                   28                                             28
3088790 3088790 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_8                                                   40                                             40
3090360 3090360 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   pk_12_total 216.0 1.0 5.0 1.0   5.0       7.0 1.0   124.0 112.0             94     36   236 216 1 5 1   5       7 1   124 112         94   36   236
3090361 3090361 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   grade_10                                                   75                                             75
3090362 3090362 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   grade_11                                                   39                                             39
3090363 3090363 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   grade_12                                                   61                                             61
3090364 3090364 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   grade_9                                                   61                                             61
3090365 3090365 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2018   pk_12_total 158.0 1.0 3.0             8.0 5.0   96.0 79.0             81     21   175 158 1 3             8 5   96 79         81   21   175
3090366 3090366 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2018   grade_6                                                   58                                             58
3090367 3090367 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2018   grade_7                                                   62                                             62
3090368 3090368 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2018   grade_8                                                   55                                             55
3090369 3090369 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   pk_12_total 18.0   2.0             1.0     12.0 9.0             12     4   21 18   2             1     12 9         12   4   21
3090370 3090370 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   grade_10                                                   4                                             4
3090371 3090371 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   grade_11                                                   8                                             8
3090372 3090372 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   grade_12                                                   5                                             5
3090373 3090373 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   grade_9                                                   4                                             4
3090374 3090374 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   pk_12_total 26.0 1.0 2.0 2.0                 24.0 7.0             *     5   31 26 1 2 2                 24 7             5   31
3090375 3090375 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   grade_1                                                   8                                             8
3090376 3090376 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   grade_2                                                   5                                             5
3090377 3090377 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   grade_3                                                   5                                             5
3090378 3090378 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   kindergarten_4_year_old                                                   8                                             8
3090379 3090379 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2018   kindergarten                                                   5                                             5
3090380 3090380 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   pk_12_total 255.0 7.0 5.0 7.0   1.0       19.0 4.0   155.0 143.0             178     52   298 255 7 5 7   1       19 4   155 143         178   52   298
3090381 3090381 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   30                                             30
3090382 3090382 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   37                                             37
3090383 3090383 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   49                                             49
3090384 3090384 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   55                                             55
3090385 3090385 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   57                                             57
3090386 3090386 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   34                                             34
3090387 3090387 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   34                                             34

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