enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,617 ✖
Link rowid ▼ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
281703 281703 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   pk_12_total 71.0 202.0 139.0     2.0         31.0   219.0 226.0             311     54   445 71 202 139     2         31   219 226         311   54   445
281704 281704 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_1                                                   50                                             50
281705 281705 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_2                                                   59                                             59
281706 281706 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_3                                                   46                                             46
281707 281707 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_4                                                   45                                             45
281708 281708 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_5                                                   40                                             40
281709 281709 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_6                                                   58                                             58
281710 281710 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   30                                             30
281711 281711 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   25                                             25
281712 281712 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   41                                             41
281713 281713 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten                                                   51                                             51
281714 281714 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 182.0 5.0 187.0 1.0   1.0         1.0   198.0 179.0             256     36   377 182 5 187 1   1         1   198 179         256   36   377
281715 281715 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
281716 281716 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   49                                             49
281717 281717 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   64                                             64
281718 281718 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   54                                             54
281719 281719 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   51                                             51
281720 281720 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   55                                             55
281721 281721 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   53                                             53
281722 281722 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281723 281723 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   pk_12_total 203.0 5.0 121.0     3.0         4.0   176.0 160.0             197     34   336 203 5 121     3         4   176 160         197   34   336
281724 281724 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_10                                                   47                                             47
281725 281725 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_11                                                   43                                             43
281726 281726 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_12                                                   51                                             51
281727 281727 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_6                                                   49                                             49
281728 281728 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_7                                                   50                                             50
281729 281729 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_8                                                   41                                             41
281730 281730 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_9                                                   55                                             55
281731 281731 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 397.0 9.0 41.0 5.0   1.0       1.0 5.0   234.0 225.0             329     77   459 397 9 41 5   1       1 5   234 225         329   77   459
281732 281732 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
281733 281733 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   75                                             75
281734 281734 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   72                                             72
281735 281735 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   67                                             67
281736 281736 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   78                                             78
281737 281737 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   53                                             53
281738 281738 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   63                                             63
281739 281739 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281740 281740 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   pk_12_total 444.0 5.0 31.0 5.0   1.0       1.0 2.0   239.0 250.0             335     94   489 444 5 31 5   1       1 2   239 250         335   94   489
281741 281741 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_10                                                   107                                             107
281742 281742 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_11                                                   130                                             130
281743 281743 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_12                                                   117                                             117
281744 281744 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_9                                                   135                                             135
281745 281745 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   pk_12_total 325.0 7.0 15.0 4.0           1.0 2.0   180.0 174.0             247     61   354 325 7 15 4           1 2   180 174         247   61   354
281746 281746 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_6                                                   128                                             128
281747 281747 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_7                                                   110                                             110
281748 281748 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_8                                                   116                                             116
281749 281749 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 132.0 5.0 13.0 1.0             2.0   95.0 58.0             121     33   153 132 5 13 1             2   95 58         121   33   153
281750 281750 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   22                                             22
281751 281751 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   26                                             26
281752 281752 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   20                                             20
281753 281753 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   21                                             21
281754 281754 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   14                                             14
281755 281755 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   20                                             20
281756 281756 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   30                                             30
281757 281757 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 111.0   1.0 1.0                 54.0 59.0             78     19   113 111   1 1                 54 59         78   19   113
281758 281758 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   20                                             20
281759 281759 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   23                                             23
281760 281760 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   16                                             16
281761 281761 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   16                                             16
281762 281762 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   11                                             11
281763 281763 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   7                                             7
281764 281764 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   20                                             20
281765 281765 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   pk_12_total 80.0   7.0     1.0         1.0   43.0 46.0             31     14   89 80   7     1         1   43 46         31   14   89
281766 281766 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_5                                                   25                                             25
281767 281767 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_6                                                   31                                             31
281768 281768 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_7                                                   15                                             15
281769 281769 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_8                                                   18                                             18
281770 281770 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   pk_12_total 116.0   5.0               3.0   62.0 62.0             42     17   124 116   5               3   62 62         42   17   124
281771 281771 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   14                                             14
281772 281772 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_2                                                   21                                             21
281773 281773 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   19                                             19
281774 281774 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   24                                             24
281775 281775 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   22                                             22
281776 281776 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   24                                             24
281777 281777 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   pk_12_total 100.0 2.0 3.0 1.0   2.0         1.0   55.0 54.0             33     14   109 100 2 3 1   2         1   55 54         33   14   109
281778 281778 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_10                                                   35                                             35
281779 281779 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_11                                                   26                                             26
281780 281780 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_12                                                   19                                             19
281781 281781 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2016   grade_9                                                   29                                             29
281782 281782 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 344.0 4.0 28.0 2.0   2.0         10.0   199.0 191.0             180     60   390 344 4 28 2   2         10   199 191         180   60   390
281783 281783 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   47                                             47
281784 281784 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   55                                             55
281785 281785 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_3                                                   44                                             44
281786 281786 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   44                                             44
281787 281787 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_5                                                   45                                             45
281788 281788 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   48                                             48
281789 281789 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   kindergarten_4_year_old                                                   42                                             42
281790 281790 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   kindergarten                                                   58                                             58
281791 281791 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   7                                             7
281792 281792 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   pk_12_total 298.0 4.0 17.0 3.0   2.0       2.0 7.0   183.0 150.0             107     43   333 298 4 17 3   2       2 7   183 150         107   43   333
281793 281793 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_10                                                   67                                             67
281794 281794 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_11                                                   69                                             69
281795 281795 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_12                                                   57                                             57
281796 281796 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_7                                                   37                                             37
281797 281797 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_8                                                   46                                             46
281798 281798 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_9                                                   57                                             57
281799 281799 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   pk_12_total 164.0   9.0 1.0   2.0         1.0   94.0 83.0             53     25   177 164   9 1   2         1   94 83         53   25   177
281800 281800 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_1                                                   24                                             24
281801 281801 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_2                                                   17                                             17
281802 281802 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_3                                                   18                                             18

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