enrollments

Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,749 ✖
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
3080449 3080449 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   pk_12_total 65.0   12.0 2.0             2.0   42.0 39.0             49     11   81 65   12 2             2   42 39         49   11   81
3080450 3080450 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_10                                                   22                                             22
3080451 3080451 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_11                                                   19                                             19
3080452 3080452 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_12                                                   14                                             14
3080453 3080453 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_7                                                   7                                             7
3080454 3080454 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_8                                                   6                                             6
3080455 3080455 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_9                                                   13                                             13
3077525 3077525 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   pk_12_total 457.0 54.0 45.0 13.0   4.0         16.0   209.0 380.0             311     60   589 457 54 45 13   4         16   209 380         311   60   589
3077526 3077526 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_10                                                   110                                             110
3077527 3077527 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_11                                                   162                                             162
3077528 3077528 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_12                                                   152                                             152
3077529 3077529 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_6                                                   8                                             8
3077530 3077530 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_7                                                   35                                             35
3077531 3077531 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_8                                                   59                                             59
3077532 3077532 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_9                                                   63                                             63
3079176 3079176 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   pk_12_total 103.0   4.0               1.0   56.0 52.0             16     12   108 103   4               1   56 52         16   12   108
3079177 3079177 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   grade_1                                                   23                                             23
3079178 3079178 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   grade_2                                                   14                                             14
3079179 3079179 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   grade_3                                                   18                                             18
3079180 3079180 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   grade_4                                                   16                                             16
3079181 3079181 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   grade_5                                                   11                                             11
3079182 3079182 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   kindergarten_4_year_old                                                   12                                             12
3079183 3079183 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   kindergarten                                                   13                                             13
3079184 3079184 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3087229 3087229 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   pk_12_total 52.0 11.0 15.0               4.0   43.0 39.0             37     7   82 52 11 15               4   43 39         37   7   82
3087230 3087230 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   grade_1                                                   9                                             9
3087231 3087231 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   grade_2                                                   15                                             15
3087232 3087232 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   grade_3                                                   11                                             11
3087233 3087233 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   grade_4                                                   20                                             20
3087234 3087234 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   grade_5                                                   21                                             21
3087235 3087235 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2019   kindergarten                                                   6                                             6
3087221 3087221 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   pk_12_total 552.0 44.0 79.0 4.0   10.0       2.0 46.0   292.0 445.0             226     77   737 552 44 79 4   10       2 46   292 445         226   77   737
3087222 3087222 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_10                                                   115                                             115
3087223 3087223 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_11                                                   173                                             173
3087224 3087224 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_12                                                   201                                             201
3087225 3087225 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_6                                                   39                                             39
3087226 3087226 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_7                                                   52                                             52
3087227 3087227 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_8                                                   70                                             70
3087228 3087228 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_9                                                   87                                             87
3079253 3079253 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   pk_12_total 410.0 2.0 25.0     3.0         10.0   237.0 213.0             94     48   450 410 2 25     3         10   237 213         94   48   450
3079254 3079254 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   75                                             75
3079255 3079255 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   61                                             61
3079256 3079256 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   73                                             73
3079257 3079257 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   81                                             81
3079258 3079258 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   68                                             68
3079259 3079259 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   86                                             86
3079260 3079260 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   6                                             6
3082456 3082456 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   pk_12_total 43.0 38.0 211.0 2.0   23.0         13.0   199.0 131.0             299     92   330 43 38 211 2   23         13   199 131         299   92   330
3082457 3082457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   36                                             36
3082458 3082458 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   42                                             42
3082459 3082459 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   37                                             37
3082460 3082460 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   60                                             60
3082461 3082461 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   52                                             52
3082462 3082462 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   kindergarten_3_year_old                                                   14                                             14
3082463 3082463 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   39                                             39
3082464 3082464 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   50                                             50
3078672 3078672 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   pk_12_total 2.0 4.0                 2.0   6.0 2.0             *     *   8 2 4                 2   6 2                 8
3078673 3078673 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   grade_10                                                   2                                             2
3078674 3078674 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   grade_11                                                   2                                             2
3078675 3078675 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   grade_12                                                   3                                             3
3078676 3078676 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   grade_7                                                   1                                             1
3088626 3088626 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   pk_12_total 399.0   26.0     1.0       1.0 11.0   235.0 203.0             44     46   438 399   26     1       1 11   235 203         44   46   438
3088627 3088627 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_1                                                   33                                             33
3088628 3088628 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   42                                             42
3088629 3088629 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_3                                                   44                                             44
3088630 3088630 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_4                                                   45                                             45
3088631 3088631 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_5                                                   39                                             39
3088632 3088632 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   53                                             53
3088633 3088633 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   52                                             52
3088634 3088634 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   74                                             74
3088635 3088635 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   22                                             22
3088636 3088636 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   kindergarten                                                   34                                             34
3076210 3076210 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   pk_12_total 299.0 7.0 30.0 1.0   14.0         22.0   193.0 180.0             68     45   373 299 7 30 1   14         22   193 180         68   45   373
3076211 3076211 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   grade_1                                                   76                                             76
3076212 3076212 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   grade_2                                                   61                                             61
3076213 3076213 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   grade_3                                                   74                                             74
3076214 3076214 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   grade_4                                                   85                                             85
3076215 3076215 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2019   kindergarten                                                   77                                             77
3076635 3076635 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   pk_12_total 76.0   9.0               12.0   46.0 51.0             33     12   97 76   9               12   46 51         33   12   97
3076636 3076636 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   grade_1                                                   24                                             24
3076637 3076637 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   grade_2                                                   13                                             13
3076638 3076638 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   grade_3                                                   25                                             25
3076639 3076639 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   grade_4                                                   17                                             17
3076640 3076640 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   grade_5                                                   18                                             18
3086675 3086675 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   pk_12_total 78.0 2.0 4.0 15.0             16.0   53.0 62.0             73     19   115 78 2 4 15             16   53 62         73   19   115
3086676 3086676 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   grade_1                                                   23                                             23
3086677 3086677 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   grade_2                                                   14                                             14
3086678 3086678 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   grade_3                                                   15                                             15
3086679 3086679 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   23                                             23
3086680 3086680 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   20                                             20
3086681 3086681 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001941 240 Wyeville Elementary   Regular School No Elementary KG 05 2019   kindergarten                                                   20                                             20
3088621 3088621 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   pk_12_total 308.0 1.0 41.0 3.0   1.0       1.0 4.0   185.0 174.0             99     28   359 308 1 41 3   1       1 4   185 174         99   28   359
3088622 3088622 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_5                                                   84                                             84
3088623 3088623 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_6                                                   88                                             88
3088624 3088624 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_7                                                   95                                             95
3088625 3088625 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_8                                                   92                                             92
3088616 3088616 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2019   pk_12_total 436.0   33.0 3.0   3.0       1.0 9.0   252.0 233.0             77     50   485 436   33 3   3       1 9   252 233         77   50   485
3088617 3088617 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2019   grade_10                                                   106                                             106
3088618 3088618 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2019   grade_11                                                   127                                             127
3088619 3088619 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2019   grade_12                                                   130                                             130

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