enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
120453 120453 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_1                                                   43                                             43
120454 120454 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_2                                                   46                                             46
120455 120455 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_3                                                   44                                             44
120456 120456 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_4                                                   51                                             51
120457 120457 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_5                                                   50                                             50
120458 120458 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   47                                             47
120459 120459 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   41                                             41
120460 120460 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   kindergarten                                                   40                                             40
120461 120461 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   pre_kindergarten                                                   2                                             2
120608 120608 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   pk_12_total 650.0 4.0 33.0     6.0       1.0 9.0   360.0 343.0             100     50   703 650 4 33     6       1 9   360 343         100   50   703
120609 120609 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_5                                                   166                                             166
120610 120610 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_6                                                   194                                             194
120611 120611 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_7                                                   160                                             160
120612 120612 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_8                                                   183                                             183
121013 121013 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 311.0 2.0 11.0 1.0   1.0       1.0 4.0   165.0 166.0             109     53   331 311 2 11 1   1       1 4   165 166         109   53   331
121014 121014 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   62                                             62
121015 121015 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   47                                             47
121016 121016 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   50                                             50
121017 121017 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   56                                             56
121018 121018 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   44                                             44
121019 121019 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   60                                             60
121020 121020 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   12                                             12
121262 121262 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 360.0 6.0 47.0 3.0   18.0         9.0   238.0 205.0             107     52   443 360 6 47 3   18         9   238 205         107   52   443
121263 121263 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   75                                             75
121264 121264 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   68                                             68
121265 121265 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   78                                             78
121266 121266 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   79                                             79
121267 121267 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   71                                             71
121268 121268 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   65                                             65
121269 121269 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
121768 121768 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 159.0 2.0 12.0                   95.0 78.0             47     21   173 159 2 12                   95 78         47   21   173
121769 121769 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   21                                             21
121770 121770 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   19                                             19
121771 121771 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   14                                             14
121772 121772 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   30                                             30
121773 121773 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   22                                             22
121774 121774 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   21                                             21
121775 121775 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   21                                             21
121776 121776 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   24                                             24
121777 121777 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
121912 121912 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 76.0 1.0 4.0 3.0             4.0   44.0 44.0             53     12   88 76 1 4 3             4   44 44         53   12   88
121913 121913 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   11                                             11
121914 121914 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   4                                             4
121915 121915 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   9                                             9
121916 121916 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   9                                             9
121917 121917 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   2                                             2
121918 121918 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   9                                             9
121919 121919 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   17                                             17
121920 121920 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   12                                             12
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

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