enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,702 ✖
Link rowid ▼ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3088637 3088637 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   pk_12_total 66.0 255.0 165.0     3.0         47.0   243.0 293.0             416     57   536 66 255 165     3         47   243 293         416   57   536
3088638 3088638 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_1                                                   59                                             59
3088639 3088639 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_2                                                   52                                             52
3088640 3088640 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_3                                                   51                                             51
3088641 3088641 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_4                                                   60                                             60
3088642 3088642 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_5                                                   58                                             58
3088643 3088643 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_6                                                   60                                             60
3088644 3088644 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_7                                                   39                                             39
3088645 3088645 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   58                                             58
3088646 3088646 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   40                                             40
3088647 3088647 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   kindergarten                                                   59                                             59
3088648 3088648 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   pk_12_total 162.0 3.0 209.0     1.0         2.0   204.0 173.0             275     51   377 162 3 209     1         2   204 173         275   51   377
3088649 3088649 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   58                                             58
3088650 3088650 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   54                                             54
3088651 3088651 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   53                                             53
3088652 3088652 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   52                                             52
3088653 3088653 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   65                                             65
3088654 3088654 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   42                                             42
3088655 3088655 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   51                                             51
3088656 3088656 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
3088657 3088657 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   pk_12_total 206.0 4.0 154.0     2.0         4.0   191.0 179.0             237     46   370 206 4 154     2         4   191 179         237   46   370
3088658 3088658 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_10                                                   44                                             44
3088659 3088659 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_11                                                   58                                             58
3088660 3088660 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_12                                                   49                                             49
3088661 3088661 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_6                                                   57                                             57
3088662 3088662 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_7                                                   58                                             58
3088663 3088663 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_8                                                   49                                             49
3088664 3088664 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_9                                                   55                                             55
3088665 3088665 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2018   pk_12_total 3.0                       3.0               *     *   3 3                       3                   3
3088666 3088666 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2018   grade_10                                                   1                                             1
3088667 3088667 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2018   grade_6                                                   1                                             1
3088668 3088668 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2018   grade_9                                                   1                                             1
3088669 3088669 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pk_12_total 380.0 12.0 45.0 1.0   2.0         5.0   218.0 227.0             251     98   445 380 12 45 1   2         5   218 227         251   98   445
3088670 3088670 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   46                                             46
3088671 3088671 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3088672 3088672 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   56                                             56
3088673 3088673 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   74                                             74
3088674 3088674 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   79                                             79
3088675 3088675 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   60                                             60
3088676 3088676 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   53                                             53
3088677 3088677 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   14                                             14
3088678 3088678 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   pk_12_total 422.0 8.0 24.0 5.0   1.0         5.0   247.0 218.0             325     99   465 422 8 24 5   1         5   247 218         325   99   465
3088679 3088679 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_10                                                   116                                             116
3088680 3088680 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_11                                                   135                                             135
3088681 3088681 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_12                                                   101                                             101
3088682 3088682 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_9                                                   113                                             113
3088683 3088683 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   pk_12_total 297.0 3.0 23.0 4.0           2.0 2.0   170.0 161.0             208     69   331 297 3 23 4           2 2   170 161         208   69   331
3088684 3088684 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_6                                                   102                                             102
3088685 3088685 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_7                                                   106                                             106
3088686 3088686 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_8                                                   123                                             123
3088687 3088687 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   pk_12_total 123.0 5.0 18.0 2.0   1.0         6.0   92.0 63.0             96     36   155 123 5 18 2   1         6   92 63         96   36   155
3088688 3088688 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   18                                             18
3088689 3088689 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   24                                             24
3088690 3088690 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   24                                             24
3088691 3088691 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088692 3088692 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   20                                             20
3088693 3088693 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   19                                             19
3088694 3088694 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   26                                             26
3088695 3088695 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   pk_12_total 132.0   5.0 1.0                 61.0 77.0             76     27   138 132   5 1                 61 77         76   27   138
3088696 3088696 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   14                                             14
3088697 3088697 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
3088698 3088698 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   21                                             21
3088699 3088699 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   31                                             31
3088700 3088700 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   19                                             19
3088701 3088701 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   12                                             12
3088702 3088702 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   15                                             15
3088703 3088703 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   pk_12_total 70.0   6.0     1.0         2.0   43.0 36.0             31     16   79 70   6     1         2   43 36         31   16   79
3088704 3088704 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_6                                                   27                                             27
3088705 3088705 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_7                                                   22                                             22
3088706 3088706 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   30                                             30
3088707 3088707 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   pk_12_total 144.0 1.0 7.0               5.0   77.0 80.0             67     19   157 144 1 7               5   77 80         67   19   157
3088708 3088708 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   16                                             16
3088709 3088709 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
3088710 3088710 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   18                                             18
3088711 3088711 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   20                                             20
3088712 3088712 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   20                                             20
3088713 3088713 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   25                                             25
3088714 3088714 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   29                                             29
3088715 3088715 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
3088716 3088716 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   pk_12_total 92.0 1.0       2.0         1.0   41.0 55.0             26     13   96 92 1       2         1   41 55         26   13   96
3088717 3088717 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_10                                                   19                                             19
3088718 3088718 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_11                                                   24                                             24
3088719 3088719 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_12                                                   29                                             29
3088720 3088720 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2018   grade_9                                                   24                                             24
3088721 3088721 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   pk_12_total 342.0 5.0 29.0 1.0   3.0         10.0   204.0 186.0             183     74   390 342 5 29 1   3         10   204 186         183   74   390
3088722 3088722 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   47                                             47
3088723 3088723 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   56                                             56
3088724 3088724 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   47                                             47
3088725 3088725 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   58                                             58
3088726 3088726 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   51                                             51
3088727 3088727 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   47                                             47
3088728 3088728 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   36                                             36
3088729 3088729 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   43                                             43
3088730 3088730 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   5                                             5
3088731 3088731 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   pk_12_total 297.0 3.0 17.0 3.0           1.0 4.0   158.0 167.0             112     40   325 297 3 17 3           1 4   158 167         112   40   325
3088732 3088732 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_10                                                   63                                             63
3088733 3088733 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_11                                                   59                                             59
3088734 3088734 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_12                                                   61                                             61
3088735 3088735 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_7                                                   49                                             49
3088736 3088736 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_8                                                   52                                             52

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