enrollments

Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by rowid 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3088620 3088620 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2019   grade_9                                                   122                                             122
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
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
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
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
3088615 3088615 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   4                                             4
3088614 3088614 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   87                                             87
3088613 3088613 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   74                                             74
3088612 3088612 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   87                                             87
3088611 3088611 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   92                                             92
3088610 3088610 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   103                                             103
3088609 3088609 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   76                                             76
3088608 3088608 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   pk_12_total 443.0 3.0 54.0 3.0   5.0       4.0 11.0   268.0 255.0             143     74   523 443 3 54 3   5       4 11   268 255         143   74   523
3088607 3088607 WI Vilas   school   6720 Public Schools-Multidistrict Charters Woodruff J1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2019   pk_12_total                                                   0                                             0
3088606 3088606 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten                                                   4                                             4
3088605 3088605 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   kindergarten                                                   49                                             49
3088604 3088604 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   46                                             46
3088603 3088603 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   58                                             58
3088602 3088602 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   54                                             54
3088601 3088601 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   59                                             59
3088600 3088600 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_5                                                   53                                             53
3088599 3088599 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_4                                                   56                                             56
3088598 3088598 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_3                                                   47                                             47
3088597 3088597 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   53                                             53
3088596 3088596 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_1                                                   66                                             66
3088595 3088595 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   pk_12_total 439.0 4.0 23.0 42.0   3.0       2.0 32.0   273.0 272.0             280     61   545 439 4 23 42   3       2 32   273 272         280   61   545
3088594 3088594 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   kindergarten                                                   38                                             38
3088593 3088593 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   kindergarten_4_year_old                                                   28                                             28
3088592 3088592 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_7                                                   26                                             26
3088591 3088591 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_6                                                   38                                             38
3088590 3088590 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_5                                                   36                                             36
3088589 3088589 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_4                                                   37                                             37
3088588 3088588 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_3                                                   37                                             37
3088587 3088587 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_2                                                   34                                             34
3088586 3088586 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_1                                                   38                                             38
3088585 3088585 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   pk_12_total 39.0 185.0 33.0 3.0   8.0         44.0   167.0 145.0             185     33   312 39 185 33 3   8         44   167 145         185   33   312
3088584 3088584 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   kindergarten                                                   36                                             36
3088583 3088583 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   kindergarten_4_year_old                                                   30                                             30
3088582 3088582 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_8                                                   35                                             35
3088581 3088581 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_7                                                   36                                             36
3088580 3088580 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_6                                                   34                                             34
3088579 3088579 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_5                                                   37                                             37
3088578 3088578 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_4                                                   34                                             34
3088577 3088577 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_3                                                   38                                             38
3088576 3088576 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_2                                                   37                                             37
3088575 3088575 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_1                                                   35                                             35
3088574 3088574 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   pk_12_total 175.0 81.0 44.0 3.0   13.0         36.0   175.0 177.0             76     32   352 175 81 44 3   13         36   175 177         76   32   352
3088573 3088573 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2019   grade_5                                                   1                                             1
3088572 3088572 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2019   grade_11                                                   1                                             1
3088571 3088571 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2019   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
3088570 3088570 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_8                                                   18                                             18
3088569 3088569 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_7                                                   36                                             36
3088568 3088568 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_6                                                   27                                             27
3088567 3088567 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   pk_12_total 75.0   1.0             1.0 4.0   39.0 42.0             40     7   81 75   1             1 4   39 42         40   7   81
3088566 3088566 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2019   grade_9                                                   25                                             25
3088565 3088565 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2019   grade_12                                                   31                                             31
3088564 3088564 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2019   grade_11                                                   22                                             22
3088563 3088563 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2019   grade_10                                                   35                                             35
3088562 3088562 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No High 09 12 2019   pk_12_total 98.0 2.0 6.0             2.0 5.0   57.0 56.0             61     17   113 98 2 6             2 5   57 56         61   17   113
3088561 3088561 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   5                                             5
3088560 3088560 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   20                                             20
3088559 3088559 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   17                                             17
3088558 3088558 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   17                                             17
3088557 3088557 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   24                                             24
3088556 3088556 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   24                                             24
3088555 3088555 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   23                                             23
3088554 3088554 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   19                                             19
3088553 3088553 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   pk_12_total 138.0 1.0 4.0             1.0 5.0   80.0 69.0             82     22   149 138 1 4             1 5   80 69         82   22   149
3088552 3088552 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2019   pk_12_total                                                   0                                             0
3088551 3088551 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2019   grade_9                                                   89                                             89
3088550 3088550 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2019   grade_12                                                   78                                             78
3088549 3088549 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2019   grade_11                                                   81                                             81
3088548 3088548 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2019   grade_10                                                   88                                             88
3088547 3088547 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No High 09 12 2019   pk_12_total 284.0 2.0 20.0 15.0   5.0         10.0   190.0 146.0             111     49   336 284 2 20 15   5         10   190 146         111   49   336
3088546 3088546 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten                                                   11                                             11
3088545 3088545 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   kindergarten                                                   44                                             44
3088544 3088544 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   46                                             46
3088543 3088543 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   45                                             45
3088542 3088542 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   45                                             45
3088541 3088541 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   49                                             49
3088540 3088540 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_5                                                   44                                             44
3088539 3088539 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_4                                                   45                                             45
3088538 3088538 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_3                                                   39                                             39
3088537 3088537 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   45                                             45

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