enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,702 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3096538 3096538 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   pk_12_total 11.0 468.0 150.0 4.0   9.0         21.0   340.0 323.0             537     171   663 11 468 150 4   9         21   340 323         537   171   663
3096539 3096539 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_6                                                   187                                             187
3096540 3096540 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_7                                                   229                                             229
3096541 3096541 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_8                                                   247                                             247
3096600 3096600 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   pk_12_total 36.0 681.0 21.0 1.0   50.0         12.0   481.0 320.0             603     272   801 36 681 21 1   50         12   481 320         603   272   801
3096601 3096601 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_10                                                   198                                             198
3096602 3096602 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_11                                                   158                                             158
3096603 3096603 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_12                                                   177                                             177
3096604 3096604 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_9                                                   268                                             268
3091043 3091043 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2018   pk_12_total 118.0 7.0 145.0     5.0         4.0   160.0 119.0             204     48   279 118 7 145     5         4   160 119         204   48   279
3091044 3091044 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2018   grade_4                                                   144                                             144
3091045 3091045 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2018   grade_5                                                   135                                             135
3092181 3092181 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   pk_12_total 237.0 220.0 28.0 3.0   27.0       4.0 29.0   277.0 271.0             182     66   548 237 220 28 3   27       4 29   277 271         182   66   548
3092182 3092182 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_4                                                   105                                             105
3092183 3092183 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_5                                                   100                                             100
3092184 3092184 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_6                                                   122                                             122
3092185 3092185 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_7                                                   114                                             114
3092186 3092186 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_8                                                   107                                             107
3092947 3092947 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   pk_12_total 308.0 1.0 4.0 1.0   37.0         13.0   189.0 175.0             89     48   364 308 1 4 1   37         13   189 175         89   48   364
3092948 3092948 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   grade_1                                                   51                                             51
3092949 3092949 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   68                                             68
3092950 3092950 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   68                                             68
3092951 3092951 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   grade_4                                                   60                                             60
3092952 3092952 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   grade_5                                                   63                                             63
3092953 3092953 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   54                                             54
3093009 3093009 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   pk_12_total 521.0 3.0 43.0 2.0   6.0         14.0   322.0 267.0             68     90   589 521 3 43 2   6         14   322 267         68   90   589
3093010 3093010 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   131                                             131
3093011 3093011 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   100                                             100
3093012 3093012 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   grade_3                                                   124                                             124
3093013 3093013 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   114                                             114
3093014 3093014 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   117                                             117
3093015 3093015 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3093158 3093158 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   pk_12_total 299.0 5.0 10.0     6.0         7.0   158.0 169.0             52     54   327 299 5 10     6         7   158 169         52   54   327
3093159 3093159 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   grade_1                                                   51                                             51
3093160 3093160 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   61                                             61
3093161 3093161 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   61                                             61
3093162 3093162 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   grade_4                                                   53                                             53
3093163 3093163 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   grade_5                                                   58                                             58
3093164 3093164 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   43                                             43
3095225 3095225 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2018   pk_12_total 161.0   10.0     3.0         14.0   95.0 93.0             19     31   188 161   10     3         14   95 93         19   31   188
3095226 3095226 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2018   kindergarten                                                   177                                             177
3095227 3095227 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   11                                             11
3097321 3097321 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   pk_12_total 340.0 1.0 39.0     1.0         10.0   201.0 190.0             172     55   391 340 1 39     1         10   201 190         172   55   391
3097322 3097322 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
3097323 3097323 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   37                                             37
3097324 3097324 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   30                                             30
3097325 3097325 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   43                                             43
3097326 3097326 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   41                                             41
3097327 3097327 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   171                                             171
3097328 3097328 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   34                                             34
3097357 3097357 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   pk_12_total 274.0 2.0 19.0 2.0   1.0         5.0   156.0 147.0             130     44   303 274 2 19 2   1         5   156 147         130   44   303
3097358 3097358 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   grade_1                                                   46                                             46
3097359 3097359 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   grade_2                                                   45                                             45
3097360 3097360 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   grade_3                                                   40                                             40
3097361 3097361 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   grade_4                                                   50                                             50
3097362 3097362 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   grade_5                                                   53                                             53
3097363 3097363 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   31                                             31
3097364 3097364 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   kindergarten                                                   34                                             34
3097365 3097365 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   4                                             4
3097521 3097521 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   pk_12_total 641.0 5.0 42.0     5.0         12.0   357.0 348.0             73     62   705 641 5 42     5         12   357 348         73   62   705
3097522 3097522 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   grade_5                                                   152                                             152
3097523 3097523 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   grade_6                                                   183                                             183
3097524 3097524 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   grade_7                                                   196                                             196
3097525 3097525 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   grade_8                                                   174                                             174
3097913 3097913 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   pk_12_total 304.0 4.0 14.0     2.0         8.0   165.0 167.0             56     34   332 304 4 14     2         8   165 167         56   34   332
3097914 3097914 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   grade_1                                                   56                                             56
3097915 3097915 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   56                                             56
3097916 3097916 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   56                                             56
3097917 3097917 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   grade_4                                                   51                                             51
3097918 3097918 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   grade_5                                                   55                                             55
3097919 3097919 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   58                                             58
3098167 3098167 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   pk_12_total 331.0 9.0 52.0 3.0   11.0       1.0 15.0   233.0 189.0             75     47   422 331 9 52 3   11       1 15   233 189         75   47   422
3098168 3098168 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   61                                             61
3098169 3098169 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   75                                             75
3098170 3098170 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   71                                             71
3098171 3098171 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   76                                             76
3098172 3098172 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   76                                             76
3098173 3098173 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   58                                             58
3098174 3098174 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   5                                             5
3098676 3098676 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   pk_12_total 132.0 1.0 15.0               4.0   80.0 72.0             40     15   152 132 1 15               4   80 72         40   15   152
3098677 3098677 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   18                                             18
3098678 3098678 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   15                                             15
3098679 3098679 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   16                                             16
3098680 3098680 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   23                                             23
3098681 3098681 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   21                                             21
3098682 3098682 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   17                                             17
3098683 3098683 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   27                                             27
3098684 3098684 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   12                                             12
3098685 3098685 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   3                                             3
3098829 3098829 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   pk_12_total 76.0 1.0 3.0     1.0         3.0   46.0 38.0             45     14   84 76 1 3     1         3   46 38         45   14   84
3098830 3098830 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   11                                             11
3098831 3098831 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   12                                             12
3098832 3098832 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   8                                             8
3098833 3098833 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   12                                             12
3098834 3098834 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   7                                             7
3098835 3098835 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   7                                             7
3098836 3098836 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   10                                             10
3098837 3098837 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   5                                             5
3098838 3098838 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   5                                             5
3098839 3098839 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   6                                             6

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