enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
333457 333457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   pk_12_total 9.0 481.0 189.0 2.0   7.0         14.0   363.0 339.0             625     176   702 9 481 189 2   7         14   363 339         625   176   702
333458 333458 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_6                                                   216                                             216
333459 333459 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_7                                                   239                                             239
333460 333460 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_8                                                   247                                             247
333519 333519 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   pk_12_total 48.0 727.0 24.0 2.0   63.0         12.0   482.0 394.0             732     291   876 48 727 24 2   63         12   482 394         732   291   876
333520 333520 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_10                                                   181                                             181
333521 333521 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_11                                                   188                                             188
333522 333522 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_12                                                   184                                             184
333523 333523 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_9                                                   323                                             323
327979 327979 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2017   pk_12_total 113.0 11.0 153.0     4.0         3.0   151.0 133.0             216     44   284 113 11 153     4         3   151 133         216   44   284
327980 327980 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2017   grade_4                                                   139                                             139
327981 327981 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2017   grade_5                                                   145                                             145
329104 329104 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   pk_12_total 249.0 215.0 26.0 4.0   27.0       4.0 20.0   268.0 277.0             184     67   545 249 215 26 4   27       4 20   268 277         184   67   545
329105 329105 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_4                                                   107                                             107
329106 329106 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_5                                                   115                                             115
329107 329107 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_6                                                   107                                             107
329108 329108 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_7                                                   106                                             106
329109 329109 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_8                                                   110                                             110
329876 329876 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   pk_12_total 310.0 1.0 10.0 1.0   39.0         12.0   195.0 178.0             107     52   373 310 1 10 1   39         12   195 178         107   52   373
329877 329877 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_1                                                   64                                             64
329878 329878 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_2                                                   67                                             67
329879 329879 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_3                                                   61                                             61
329880 329880 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   65                                             65
329881 329881 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   63                                             63
329882 329882 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2017   kindergarten                                                   53                                             53
329938 329938 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   pk_12_total 504.0 5.0 54.0 2.0   5.0         17.0   311.0 276.0             58     82   587 504 5 54 2   5         17   311 276         58   82   587
329939 329939 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   grade_1                                                   100                                             100
329940 329940 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   grade_2                                                   121                                             121
329941 329941 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   113                                             113
329942 329942 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   127                                             127
329943 329943 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   kindergarten                                                   123                                             123
329944 329944 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   3                                             3
330086 330086 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   pk_12_total 331.0 6.0 13.0 1.0   7.0         10.0   185.0 183.0             52     61   368 331 6 13 1   7         10   185 183         52   61   368
330087 330087 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   grade_1                                                   64                                             64
330088 330088 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   grade_2                                                   65                                             65
330089 330089 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   grade_3                                                   51                                             51
330090 330090 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   64                                             64
330091 330091 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   71                                             71
330092 330092 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2017   kindergarten                                                   53                                             53
332150 332150 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2017   pk_12_total 141.0   6.0     4.0         10.0   83.0 78.0             19     28   161 141   6     4         10   83 78         19   28   161
332151 332151 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2017   kindergarten                                                   147                                             147
332152 332152 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   14                                             14
334248 334248 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   pk_12_total 341.0 6.0 32.0     2.0         7.0   201.0 187.0             173     59   388 341 6 32     2         7   201 187         173   59   388
334249 334249 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   40                                             40
334250 334250 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   36                                             36
334251 334251 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   42                                             42
334252 334252 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   40                                             40
334253 334253 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   42                                             42
334254 334254 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   149                                             149
334255 334255 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   39                                             39
334284 334284 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   pk_12_total 282.0 1.0 18.0 1.0   1.0         7.0   158.0 152.0             153     38   310 282 1 18 1   1         7   158 152         153   38   310
334285 334285 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   grade_1                                                   42                                             42
334286 334286 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   grade_2                                                   42                                             42
334287 334287 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   grade_3                                                   46                                             46
334288 334288 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   grade_4                                                   49                                             49
334289 334289 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   grade_5                                                   47                                             47
334290 334290 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   kindergarten_4_year_old                                                   39                                             39
334291 334291 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes Elementary PK 05 2017   kindergarten                                                   45                                             45
334443 334443 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   pk_12_total 686.0 6.0 42.0     7.0       1.0 13.0   376.0 379.0             80     58   755 686 6 42     7       1 13   376 379         80   58   755
334444 334444 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   grade_5                                                   182                                             182
334445 334445 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   grade_6                                                   195                                             195
334446 334446 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   grade_7                                                   174                                             174
334447 334447 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   grade_8                                                   204                                             204
334836 334836 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   pk_12_total 320.0 4.0 16.0 1.0           1.0 5.0   176.0 171.0             71     50   347 320 4 16 1           1 5   176 171         71   50   347
334837 334837 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   58                                             58
334838 334838 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   56                                             56
334839 334839 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   52                                             52
334840 334840 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   54                                             54
334841 334841 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   51                                             51
334842 334842 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   59                                             59
334843 334843 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   17                                             17
335083 335083 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   pk_12_total 337.0 9.0 54.0 3.0   13.0         12.0   233.0 195.0             99     45   428 337 9 54 3   13         12   233 195         99   45   428
335084 335084 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   70                                             70
335085 335085 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   69                                             69
335086 335086 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   74                                             74
335087 335087 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   68                                             68
335088 335088 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   85                                             85
335089 335089 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   59                                             59
335090 335090 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   3                                             3
335599 335599 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   pk_12_total 134.0 1.0 14.0     1.0         1.0   89.0 62.0             36     18   151 134 1 14     1         1   89 62         36   18   151
335600 335600 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_1                                                   14                                             14
335601 335601 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   20                                             20
335602 335602 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_3                                                   19                                             19
335603 335603 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_4                                                   19                                             19
335604 335604 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   15                                             15
335605 335605 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   31                                             31
335606 335606 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   kindergarten_4_year_old                                                   16                                             16
335607 335607 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   17                                             17
335747 335747 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   pk_12_total 79.0 1.0 2.0     1.0         4.0   43.0 44.0             52     13   87 79 1 2     1         4   43 44         52   13   87
335748 335748 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_1                                                   10                                             10
335749 335749 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_2                                                   8                                             8
335750 335750 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_3                                                   11                                             11
335751 335751 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_4                                                   5                                             5
335752 335752 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   9                                             9
335753 335753 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   10                                             10
335754 335754 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_7                                                   6                                             6
335755 335755 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   13                                             13
335756 335756 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   kindergarten_4_year_old                                                   5                                             5
335757 335757 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   kindergarten                                                   10                                             10
336004 336004 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2017   pk_12_total 214.0 1.0 3.0 1.0   3.0         5.0   125.0 102.0             138     44   227 214 1 3 1   3         5   125 102         138   44   227

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