enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 15,006 ✖
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
2340970 2340970 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   pk_12_total 11.0 355.0 123.0 3.0   8.0       1.0 16.0   233.0 284.0     48.0       511     123   517 11 355 123 3   8       1 16   233 284     48   511   123   517
2340971 2340971 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_6                                                   154                                             154
2340972 2340972 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_7                                                   168                                             168
2340973 2340973 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_8                                                   195                                             195
2341031 2341031 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   pk_12_total 11.0 1085.0 48.0 3.0   29.0         27.0   660.0 543.0     14.0       1091     362   1203 11 1085 48 3   29         27   660 543     14   1091   362   1203
2341032 2341032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_10                                                   316                                             316
2341033 2341033 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_11                                                   297                                             297
2341034 2341034 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_12                                                   246                                             246
2341035 2341035 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_9                                                   344                                             344
2335323 2335323 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 03 04 2021   pk_12_total 88.0 3.0 133.0 1.0             9.0   106.0 128.0     86.0       168     34   234 88 3 133 1             9   106 128     86   168   34   234
2335324 2335324 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 03 04 2021   grade_3                                                   131                                             131
2335325 2335325 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 03 04 2021   grade_4                                                   103                                             103
2336501 2336501 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   pk_12_total 185.0 206.0 46.0 3.0   20.0       3.0 33.0   238.0 258.0     9.0       214     71   496 185 206 46 3   20       3 33   238 258     9   214   71   496
2336502 2336502 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_4                                                   90                                             90
2336503 2336503 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_5                                                   85                                             85
2336504 2336504 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_6                                                   108                                             108
2336505 2336505 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_7                                                   129                                             129
2336506 2336506 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_8                                                   84                                             84
2337250 2337250 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   pk_12_total 291.0 3.0 10.0     35.0         14.0   193.0 160.0     23.0       94     42   353 291 3 10     35         14   193 160     23   94   42   353
2337251 2337251 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   52                                             52
2337252 2337252 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   55                                             55
2337253 2337253 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   grade_3                                                   61                                             61
2337254 2337254 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   59                                             59
2337255 2337255 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   grade_5                                                   70                                             70
2337256 2337256 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2021   kindergarten                                                   56                                             56
2337340 2337340 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   pk_12_total 545.0 5.0 55.0 1.0   12.0         5.0   315.0 308.0     47.0       108     88   623 545 5 55 1   12         5   315 308     47   108   88   623
2337341 2337341 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   94                                             94
2337342 2337342 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   118                                             118
2337343 2337343 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   grade_3                                                   121                                             121
2337344 2337344 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   146                                             146
2337345 2337345 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   kindergarten_4_year_old                                                   1                                             1
2337346 2337346 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   kindergarten                                                   137                                             137
2337347 2337347 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   6                                             6
2337494 2337494 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   pk_12_total 264.0 9.0 12.0     5.0         10.0   162.0 138.0     4.0       53     51   300 264 9 12     5         10   162 138     4   53   51   300
2337495 2337495 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   38                                             38
2337496 2337496 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   53                                             53
2337497 2337497 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   46                                             46
2337498 2337498 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   45                                             45
2337499 2337499 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   58                                             58
2337500 2337500 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   60                                             60
2341719 2341719 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   pk_12_total 276.0 2.0 37.0     1.0         10.0   166.0 160.0     3.0       161     45   326 276 2 37     1         10   166 160     3   161   45   326
2341720 2341720 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   30                                             30
2341721 2341721 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   37                                             37
2341722 2341722 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   32                                             32
2341723 2341723 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   29                                             29
2341724 2341724 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   36                                             36
2341725 2341725 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   130                                             130
2341726 2341726 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   32                                             32
2341757 2341757 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   pk_12_total 194.0   15.0 2.0   1.0         4.0   123.0 93.0             124     47   216 194   15 2   1         4   123 93         124   47   216
2341758 2341758 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
2341759 2341759 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   grade_2                                                   30                                             30
2341760 2341760 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   grade_3                                                   31                                             31
2341761 2341761 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   grade_4                                                   43                                             43
2341762 2341762 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   grade_5                                                   42                                             42
2341763 2341763 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   9                                             9
2341764 2341764 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   kindergarten                                                   27                                             27
2341765 2341765 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   3                                             3
2341958 2341958 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   pk_12_total 607.0 4.0 50.0 4.0   7.0         13.0   357.0 328.0     2.0       97     58   685 607 4 50 4   7         13   357 328     2   97   58   685
2341959 2341959 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_5                                                   166                                             166
2341960 2341960 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_6                                                   163                                             163
2341961 2341961 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_7                                                   180                                             180
2341962 2341962 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_8                                                   176                                             176
2342328 2342328 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   pk_12_total 301.0 4.0 9.0 1.0   5.0         12.0   169.0 163.0     1.0       109     30   332 301 4 9 1   5         12   169 163     1   109   30   332
2342329 2342329 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   59                                             59
2342330 2342330 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   52                                             52
2342331 2342331 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   grade_3                                                   54                                             54
2342332 2342332 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   57                                             57
2342333 2342333 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   grade_5                                                   52                                             52
2342334 2342334 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2021   kindergarten                                                   58                                             58
2342614 2342614 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 281.0 6.0 54.0 1.0   15.0         18.0   202.0 173.0     15.0       101     41   375 281 6 54 1   15         18   202 173     15   101   41   375
2342615 2342615 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   53                                             53
2342616 2342616 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   67                                             67
2342617 2342617 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   60                                             60
2342618 2342618 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   63                                             63
2342619 2342619 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   70                                             70
2342620 2342620 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   58                                             58
2342621 2342621 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   4                                             4
2343124 2343124 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   pk_12_total 215.0 6.0 29.0 2.0   1.0         11.0   128.0 136.0     9.0       107     38   264 215 6 29 2   1         11   128 136     9   107   38   264
2343125 2343125 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   32                                             32
2343126 2343126 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   36                                             36
2343127 2343127 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   30                                             30
2343128 2343128 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   36                                             36
2343129 2343129 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   43                                             43
2343130 2343130 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   kindergarten_4_year_old                                                   43                                             43
2343131 2343131 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   41                                             41
2343132 2343132 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   3                                             3
2343273 2343273 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   pk_12_total 62.0 1.0 4.0               5.0   32.0 40.0             47     8   72 62 1 4               5   32 40         47   8   72
2343274 2343274 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_1                                                   3                                             3
2343275 2343275 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_2                                                   3                                             3
2343276 2343276 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_3                                                   7                                             7
2343277 2343277 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_4                                                   9                                             9
2343278 2343278 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_5                                                   9                                             9
2343279 2343279 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   6                                             6
2343280 2343280 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   10                                             10
2343281 2343281 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   5                                             5
2343282 2343282 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   8                                             8
2343283 2343283 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   kindergarten                                                   10                                             10
2343284 2343284 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   2                                             2
2343543 2343543 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2021   pk_12_total 173.0   4.0 1.0   1.0         12.0   94.0 97.0             116     44   191 173   4 1   1         12   94 97         116   44   191
2343544 2343544 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2021   grade_1                                                   70                                             70

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