enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,749 ✖
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
3075558 3075558 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2019   pk_12_total 1000.0 11.0 36.0 3.0   31.0         26.0   532.0 575.0             77     75   1107 1000 11 36 3   31         26   532 575         77   75   1107
3075559 3075559 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2019   grade_10                                                   256                                             256
3075560 3075560 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2019   grade_11                                                   283                                             283
3075561 3075561 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2019   grade_12                                                   274                                             274
3075562 3075562 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2019   grade_9                                                   294                                             294
3075563 3075563 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pk_12_total 8.0                       4.0 4.0                   *   8 8                       4 4                 8
3075564 3075564 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   8                                             8
3075565 3075565 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   pk_12_total 453.0 3.0 15.0 1.0   8.0       1.0 17.0   259.0 239.0             35     47   498 453 3 15 1   8       1 17   259 239         35   47   498
3075566 3075566 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   86                                             86
3075567 3075567 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   63                                             63
3075568 3075568 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   70                                             70
3075569 3075569 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   77                                             77
3075570 3075570 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   76                                             76
3075571 3075571 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   58                                             58
3075572 3075572 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   68                                             68
3075573 3075573 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   pk_12_total 482.0 7.0 13.0     7.0       1.0 11.0   264.0 257.0             24     45   521 482 7 13     7       1 11   264 257         24   45   521
3075574 3075574 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   78                                             78
3075575 3075575 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   84                                             84
3075576 3075576 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   62                                             62
3075577 3075577 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   74                                             74
3075578 3075578 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   83                                             83
3075579 3075579 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   63                                             63
3075580 3075580 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   77                                             77
3075581 3075581 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2019   pk_12_total 601.0 6.0 26.0 2.0   16.0       1.0 20.0   338.0 334.0             56     54   672 601 6 26 2   16       1 20   338 334         56   54   672
3075582 3075582 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2019   grade_6                                                   224                                             224
3075583 3075583 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2019   grade_7                                                   216                                             216
3075584 3075584 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2019   grade_8                                                   232                                             232
3075585 3075585 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   pk_12_total 278.0 9.0 12.0 1.0   11.0         5.0   160.0 156.0             49     40   316 278 9 12 1   11         5   160 156         49   40   316
3075586 3075586 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   39                                             39
3075587 3075587 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   42                                             42
3075588 3075588 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   48                                             48
3075589 3075589 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   52                                             52
3075590 3075590 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   57                                             57
3075591 3075591 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   34                                             34
3075592 3075592 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   44                                             44
3075540 3075540 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   pk_12_total 319.0 8.0 36.0     5.0         5.0   195.0 178.0             60     56   373 319 8 36     5         5   195 178         60   56   373
3075541 3075541 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   62                                             62
3075542 3075542 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   57                                             57
3075543 3075543 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   65                                             65
3075544 3075544 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   60                                             60
3075545 3075545 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   66                                             66
3075546 3075546 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   52                                             52
3075547 3075547 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   11                                             11
3075548 3075548 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2019   pk_12_total 274.0 4.0 24.0 2.0   4.0         1.0   173.0 136.0             34     25   309 274 4 24 2   4         1   173 136         34   25   309
3075549 3075549 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2019   grade_10                                                   77                                             77
3075550 3075550 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2019   grade_11                                                   76                                             76
3075551 3075551 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2019   grade_12                                                   86                                             86
3075552 3075552 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2019   grade_9                                                   70                                             70
3075553 3075553 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2019   pk_12_total 263.0 3.0 27.0     7.0       1.0 3.0   164.0 140.0             63     25   304 263 3 27     7       1 3   164 140         63   25   304
3075554 3075554 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2019   grade_5                                                   71                                             71
3075555 3075555 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2019   grade_6                                                   81                                             81
3075556 3075556 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2019   grade_7                                                   72                                             72
3075557 3075557 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2019   grade_8                                                   80                                             80
3074014 3074014 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   pk_12_total 134.0 2.0 49.0     1.0         1.0   97.0 90.0             99     38   187 134 2 49     1         1   97 90         99   38   187
3074015 3074015 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   32                                             32
3074016 3074016 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   31                                             31
3074017 3074017 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   20                                             20
3074018 3074018 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   29                                             29
3074019 3074019 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   26                                             26
3074020 3074020 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   28                                             28
3074021 3074021 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   18                                             18
3074022 3074022 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   3                                             3
3074023 3074023 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   pk_12_total 98.0   28.0                   77.0 49.0             60     16   126 98   28                   77 49         60   16   126
3074024 3074024 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_10                                                   18                                             18
3074025 3074025 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_11                                                   35                                             35
3074026 3074026 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_12                                                   31                                             31
3074027 3074027 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_9                                                   42                                             42
3074028 3074028 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   pk_12_total 60.0   25.0                   49.0 36.0             44     15   85 60   25                   49 36         44   15   85
3074029 3074029 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_6                                                   32                                             32
3074030 3074030 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_7                                                   23                                             23
3074031 3074031 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_8                                                   30                                             30
3075609 3075609 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   pk_12_total 198.0 1.0 4.0 2.0   5.0       7.0 3.0   118.0 102.0             93     31   220 198 1 4 2   5       7 3   118 102         93   31   220
3075610 3075610 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   grade_10                                                   58                                             58
3075611 3075611 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   grade_11                                                   78                                             78
3075612 3075612 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   grade_12                                                   36                                             36
3075613 3075613 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   grade_9                                                   48                                             48
3075614 3075614 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2019   pk_12_total 162.0 1.0 3.0 2.0   1.0       5.0 5.0   93.0 86.0             113     29   179 162 1 3 2   1       5 5   93 86         113   29   179
3075615 3075615 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2019   grade_6                                                   60                                             60
3075616 3075616 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2019   grade_7                                                   56                                             56
3075617 3075617 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2019   grade_8                                                   63                                             63
3075618 3075618 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   pk_12_total 26.0   1.0             3.0     18.0 12.0             23     8   30 26   1             3     18 12         23   8   30
3075619 3075619 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   grade_10                                                   6                                             6
3075620 3075620 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   grade_11                                                   4                                             4
3075621 3075621 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   grade_12                                                   10                                             10
3075622 3075622 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   grade_9                                                   10                                             10
3075623 3075623 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   pk_12_total 30.0 2.0 1.0                   21.0 12.0             24     5   33 30 2 1                   21 12         24   5   33
3075624 3075624 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   grade_1                                                   6                                             6
3075625 3075625 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   grade_2                                                   7                                             7
3075626 3075626 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   grade_3                                                   6                                             6
3075627 3075627 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   kindergarten_4_year_old                                                   7                                             7
3075628 3075628 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2019   kindergarten                                                   7                                             7
3075629 3075629 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   pk_12_total 258.0 8.0 9.0 8.0           20.0 3.0   162.0 144.0             190     57   306 258 8 9 8           20 3   162 144         190   57   306
3075630 3075630 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   41                                             41
3075631 3075631 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   33                                             33
3075632 3075632 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   40                                             40
3075633 3075633 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   50                                             50
3075634 3075634 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   59                                             59
3075635 3075635 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   40                                             40
3075636 3075636 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   40                                             40
3075637 3075637 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   3                                             3

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