enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,553 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
121921 121921 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   9                                             9
121922 121922 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   6                                             6
122164 122164 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   pk_12_total 214.0 1.0 8.0     2.0         4.0   121.0 108.0             151     50   229 214 1 8     2         4   121 108         151   50   229
122165 122165 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   grade_1                                                   80                                             80
122166 122166 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   70                                             70
122167 122167 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   kindergarten                                                   71                                             71
122168 122168 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   8                                             8
122777 122777 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001690 10 Red Cedar School   Regular School No 1.0 PK KG 2015   pk_12_total 12.0   1.0                   10.0 3.0             4     *   13 12   1                   10 3         4       13
122778 122778 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001690 10 Red Cedar School   Regular School No 1.0 PK KG 2015   kindergarten_4_year_old                                                   5                                             5
122779 122779 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001690 10 Red Cedar School   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   8                                             8
123288 123288 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No 1.0 PK PK 2015   pk_12_total 40.0   2.0     1.0             22.0 21.0             17     5   43 40   2     1             22 21         17   5   43
123289 123289 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   43                                             43
123549 123549 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   pk_12_total 178.0   4.0 2.0           1.0 8.0   108.0 85.0             107     23   193 178   4 2           1 8   108 85         107   23   193
123550 123550 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   grade_1                                                   48                                             48
123551 123551 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   grade_2                                                   53                                             53
123552 123552 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   kindergarten_4_year_old                                                   34                                             34
123553 123553 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   kindergarten                                                   54                                             54
123554 123554 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   4                                             4
123659 123659 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 345.0 4.0 7.0     3.0         1.0   166.0 194.0             68     39   360 345 4 7     3         1   166 194         68   39   360
123660 123660 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   50                                             50
123661 123661 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   61                                             61
123662 123662 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   47                                             47
123663 123663 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   51                                             51
123664 123664 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   43                                             43
123665 123665 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   57                                             57
123666 123666 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   51                                             51
123718 123718 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 281.0 15.0 51.0 2.0   2.0         2.0   190.0 163.0             160     67   353 281 15 51 2   2         2   190 163         160   67   353
123719 123719 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   50                                             50
123720 123720 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   49                                             49
123721 123721 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   61                                             61
123722 123722 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   43                                             43
123723 123723 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   54                                             54
123724 123724 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   34                                             34
123725 123725 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   55                                             55
123726 123726 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
123976 123976 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2015   pk_12_total 689.0 10.0 58.0 1.0   56.0       1.0 15.0   409.0 421.0             310     83   830 689 10 58 1   56       1 15   409 421         310   83   830
123977 123977 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2015   grade_7                                                   288                                             288
123978 123978 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2015   grade_8                                                   285                                             285
123979 123979 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2015   grade_9                                                   257                                             257
124161 124161 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No 3.0 09 12 2015   pk_12_total 321.0 10.0 18.0 7.0   9.0       3.0 4.0   189.0 183.0             89     39   372 321 10 18 7   9       3 4   189 183         89   39   372
124162 124162 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No 3.0 09 12 2015   grade_10                                                   100                                             100
124163 124163 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No 3.0 09 12 2015   grade_11                                                   93                                             93
124164 124164 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No 3.0 09 12 2015   grade_12                                                   86                                             86
124165 124165 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No 3.0 09 12 2015   grade_9                                                   93                                             93
124828 124828 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 201.0 7.0 7.0 28.0                 141.0 102.0             111     33   243 201 7 7 28                 141 102         111   33   243
124829 124829 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   35                                             35
124830 124830 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   30                                             30
124831 124831 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   37                                             37
124832 124832 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   33                                             33
124833 124833 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   41                                             41
124834 124834 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   29                                             29
124835 124835 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   38                                             38
124881 124881 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No 2.0 07 08 2015   pk_12_total 353.0 3.0 20.0 2.0   1.0         7.0   206.0 180.0             66     40   386 353 3 20 2   1         7   206 180         66   40   386
124882 124882 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No 2.0 07 08 2015   grade_7                                                   185                                             185
124883 124883 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No 2.0 07 08 2015   grade_8                                                   201                                             201
125221 125221 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   pk_12_total 283.0 11.0 34.0 2.0   45.0       2.0 10.0   209.0 178.0             126     83   387 283 11 34 2   45       2 10   209 178         126   83   387
125222 125222 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   kindergarten_4_year_old                                                   318                                             318
125223 125223 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   69                                             69
125702 125702 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No 2.0 07 08 2015   pk_12_total 912.0 27.0 57.0 3.0   17.0         10.0   540.0 486.0             346     141   1026 912 27 57 3   17         10   540 486         346   141   1026
125703 125703 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No 2.0 07 08 2015   grade_7                                                   524                                             524
125704 125704 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No 2.0 07 08 2015   grade_8                                                   502                                             502
112929 112929 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   pk_12_total 250.0 2.0 11.0 1.0   4.0         1.0   128.0 141.0             139     41   269 250 2 11 1   4         1   128 141         139   41   269
112930 112930 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_10                                                   38                                             38
112931 112931 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_11                                                   55                                             55
112932 112932 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_12                                                   46                                             46
112933 112933 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_7                                                   50                                             50
112934 112934 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_8                                                   47                                             47
112935 112935 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   33                                             33
118888 118888 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   pk_12_total 102.0 496.0 249.0 13.0   19.0         7.0   514.0 372.0             784     204   886 102 496 249 13   19         7   514 372         784   204   886
118889 118889 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   grade_10                                                   154                                             154
118890 118890 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   grade_11                                                   162                                             162
118891 118891 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   grade_12                                                   119                                             119
118892 118892 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   grade_8                                                   46                                             46
118893 118893 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View Middle and High   Regular School No 3.0 08 12 2015   grade_9                                                   405                                             405
118907 118907 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No 3.0 09 12 2015   pk_12_total 57.0 737.0 103.0 6.0   4.0         3.0   572.0 338.0             788     268   910 57 737 103 6   4         3   572 338         788   268   910
118908 118908 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No 3.0 09 12 2015   grade_10                                                   226                                             226
118909 118909 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No 3.0 09 12 2015   grade_11                                                   214                                             214
118910 118910 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No 3.0 09 12 2015   grade_12                                                   139                                             139
118911 118911 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No 3.0 09 12 2015   grade_9                                                   331                                             331
117777 117777 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 103.0 61.0 157.0 2.0   47.0         33.0   215.0 188.0             264     47   403 103 61 157 2   47         33   215 188         264   47   403
117778 117778 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   5                                             5
117779 117779 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   135                                             135
117780 117780 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   114                                             114
117781 117781 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   116                                             116
117782 117782 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   33                                             33
121788 121788 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No 3.0 09 12 2015   pk_12_total 274.0 3.0 37.0 1.0             5.0   157.0 163.0             82     44   320 274 3 37 1             5   157 163         82   44   320
121789 121789 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No 3.0 09 12 2015   grade_10                                                   74                                             74
121790 121790 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No 3.0 09 12 2015   grade_11                                                   86                                             86
121791 121791 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No 3.0 09 12 2015   grade_12                                                   74                                             74
121792 121792 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No 3.0 09 12 2015   grade_9                                                   86                                             86
124872 124872 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 382.0 5.0 18.0 1.0   3.0         10.0   231.0 188.0             47     76   419 382 5 18 1   3         10   231 188         47   76   419
124873 124873 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   47                                             47
124874 124874 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   49                                             49
124875 124875 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   49                                             49
124876 124876 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   50                                             50
124877 124877 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   59                                             59
124878 124878 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   77                                             77
124879 124879 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   45                                             45
124880 124880 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   43                                             43
119325 119325 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No 3.0 09 12 2015   pk_12_total 281.0 581.0 728.0 27.0   70.0         7.0   950.0 744.0             1450     417   1694 281 581 728 27   70         7   950 744         1450   417   1694

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