enrollments

Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,617 ✖
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
289587 289587 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   pk_12_total 28.0 454.0 184.0 4.0   8.0         6.0   358.0 326.0             581     187   684 28 454 184 4   8         6   358 326         581   187   684
289588 289588 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_6                                                   216                                             216
289589 289589 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_7                                                   230                                             230
289590 289590 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_8                                                   238                                             238
284055 284055 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 112.0 2.0 61.0               3.0   95.0 83.0             101     34   178 112 2 61               3   95 83         101   34   178
284056 284056 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   18                                             18
284057 284057 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   28                                             28
284058 284058 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   30                                             30
284059 284059 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   27                                             27
284060 284060 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   35                                             35
284061 284061 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   18                                             18
284062 284062 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   14                                             14
284063 284063 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   8                                             8
285232 285232 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   pk_12_total 295.0 187.0 24.0 6.0   28.0       1.0 16.0   287.0 270.0             180     67   557 295 187 24 6   28       1 16   287 270         180   67   557
285233 285233 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_4                                                   111                                             111
285234 285234 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_5                                                   99                                             99
285235 285235 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_6                                                   112                                             112
285236 285236 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_7                                                   118                                             118
285237 285237 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_8                                                   117                                             117
285995 285995 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   pk_12_total 334.0   7.0 1.0   45.0         11.0   207.0 191.0             106     50   398 334   7 1   45         11   207 191         106   50   398
285996 285996 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   grade_1                                                   64                                             64
285997 285997 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   grade_2                                                   59                                             59
285998 285998 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   grade_3                                                   68                                             68
285999 285999 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   64                                             64
286000 286000 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   grade_5                                                   74                                             74
286001 286001 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2016   kindergarten                                                   69                                             69
286057 286057 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   pk_12_total 465.0 2.0 45.0 4.0   5.0         13.0   267.0 267.0             71     56   534 465 2 45 4   5         13   267 267         71   56   534
286058 286058 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   112                                             112
286059 286059 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   grade_2                                                   100                                             100
286060 286060 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   116                                             116
286061 286061 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   119                                             119
286062 286062 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   87                                             87
286208 286208 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   pk_12_total 355.0 7.0 17.0 1.0   9.0         6.0   194.0 201.0             57     59   395 355 7 17 1   9         6   194 201         57   59   395
286209 286209 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   grade_1                                                   65                                             65
286210 286210 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   grade_2                                                   54                                             54
286211 286211 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   grade_3                                                   63                                             63
286212 286212 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   76                                             76
286213 286213 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   grade_5                                                   74                                             74
286214 286214 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2016   kindergarten                                                   63                                             63
288282 288282 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2016   pk_12_total 151.0   11.0     5.0         11.0   92.0 86.0             21     33   178 151   11     5         11   92 86         21   33   178
288283 288283 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2016   kindergarten                                                   164                                             164
288284 288284 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   14                                             14
290377 290377 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 344.0 5.0 33.0     1.0         6.0   207.0 182.0             179     56   389 344 5 33     1         6   207 182         179   56   389
290378 290378 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   38                                             38
290379 290379 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   43                                             43
290380 290380 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   39                                             39
290381 290381 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   42                                             42
290382 290382 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   41                                             41
290383 290383 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   146                                             146
290384 290384 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   40                                             40
290411 290411 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   pk_12_total 315.0 6.0 28.0 4.0           1.0 3.0   175.0 182.0             203     55   357 315 6 28 4           1 3   175 182         203   55   357
290412 290412 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_1                                                   36                                             36
290413 290413 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_2                                                   42                                             42
290414 290414 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_3                                                   51                                             51
290415 290415 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_4                                                   51                                             51
290416 290416 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_5                                                   51                                             51
290417 290417 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_6                                                   50                                             50
290418 290418 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   kindergarten_4_year_old                                                   32                                             32
290419 290419 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   kindergarten                                                   44                                             44
290569 290569 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   pk_12_total 685.0 4.0 33.0     3.0       1.0 8.0   367.0 367.0             100     66   734 685 4 33     3       1 8   367 367         100   66   734
290570 290570 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   grade_5                                                   189                                             189
290571 290571 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   grade_6                                                   174                                             174
290572 290572 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   grade_7                                                   208                                             208
290573 290573 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   grade_8                                                   163                                             163
290973 290973 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 318.0 1.0 15.0 1.0           1.0 6.0   175.0 167.0             104     55   342 318 1 15 1           1 6   175 167         104   55   342
290974 290974 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   60                                             60
290975 290975 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   55                                             55
290976 290976 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   47                                             47
290977 290977 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   48                                             48
290978 290978 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   57                                             57
290979 290979 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   59                                             59
290980 290980 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   16                                             16
291231 291231 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 374.0 8.0 39.0 3.0   14.0         9.0   237.0 210.0             123     41   447 374 8 39 3   14         9   237 210         123   41   447
291232 291232 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   67                                             67
291233 291233 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   78                                             78
291234 291234 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   66                                             66
291235 291235 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   84                                             84
291236 291236 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   76                                             76
291237 291237 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   76                                             76
291730 291730 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 146.0 1.0 12.0               1.0   90.0 70.0             37     16   160 146 1 12               1   90 70         37   16   160
291731 291731 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   19                                             19
291732 291732 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   22                                             22
291733 291733 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_3                                                   18                                             18
291734 291734 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   14                                             14
291735 291735 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_5                                                   32                                             32
291736 291736 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   22                                             22
291737 291737 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   kindergarten_4_year_old                                                   18                                             18
291738 291738 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   kindergarten                                                   15                                             15
291873 291873 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   pk_12_total 91.0 3.0 3.0 4.0             4.0   55.0 50.0             68     20   105 91 3 3 4             4   55 50         68   20   105
291874 291874 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_1                                                   8                                             8
291875 291875 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_2                                                   10                                             10
291876 291876 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_3                                                   6                                             6
291877 291877 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_4                                                   13                                             13
291878 291878 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_5                                                   10                                             10
291879 291879 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   5                                             5
291880 291880 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_7                                                   12                                             12
291881 291881 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   21                                             21
291882 291882 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   kindergarten_4_year_old                                                   9                                             9
291883 291883 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   kindergarten                                                   11                                             11
292125 292125 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2016   pk_12_total 251.0 1.0 3.0     4.0         8.0   138.0 129.0             151     38   267 251 1 3     4         8   138 129         151   38   267

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