enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 14,806 ✖
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
2333126 2333126 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_12                                                   19                                             19
2333127 2333127 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_2                                                   6                                             6
2333128 2333128 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_3                                                   6                                             6
2333129 2333129 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_4                                                   5                                             5
2333130 2333130 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_5                                                   3                                             3
2333131 2333131 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_6                                                   4                                             4
2333132 2333132 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_7                                                   4                                             4
2333133 2333133 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_8                                                   12                                             12
2333134 2333134 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_9                                                   14                                             14
2333135 2333135 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   kindergarten_4_year_old                                                   2                                             2
2333136 2333136 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   kindergarten                                                   3                                             3
2333137 2333137 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   pk_12_total 111.0 4.0 12.0 2.0   2.0         11.0   71.0 71.0     4.0       106     19   142 111 4 12 2   2         11   71 71     4   106   19   142
2333138 2333138 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   31                                             31
2333139 2333139 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   35                                             35
2333140 2333140 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   25                                             25
2333141 2333141 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   kindergarten_4_year_old                                                   24                                             24
2333142 2333142 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   27                                             27
2333143 2333143 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   pk_12_total 29.0   96.0               3.0   59.0 69.0     53.0       71     6   128 29   96               3   59 69     53   71   6   128
2333144 2333144 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   grade_1                                                   23                                             23
2333145 2333145 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   grade_2                                                   21                                             21
2333146 2333146 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   grade_3                                                   22                                             22
2333147 2333147 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   grade_4                                                   17                                             17
2333148 2333148 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   grade_5                                                   20                                             20
2333149 2333149 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2021   kindergarten                                                   25                                             25
2333150 2333150 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2021   pk_12_total 469.0 24.0 70.0 4.0   77.0       1.0 42.0   348.0 339.0             290     93   687 469 24 70 4   77       1 42   348 339         290   93   687
2333151 2333151 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   687                                             687
2333152 2333152 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2021   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
2333153 2333153 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2021   grade_12                                                   1                                             1
2333154 2333154 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   pk_12_total 42.0 4.0 7.0     1.0         1.0   18.0 37.0             17     1   55 42 4 7     1         1   18 37         17   1   55
2333155 2333155 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   grade_10                                                   9                                             9
2333156 2333156 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   grade_11                                                   19                                             19
2333157 2333157 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   grade_12                                                   16                                             16
2333158 2333158 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   grade_9                                                   11                                             11
2333159 2333159 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   pk_12_total 133.0   6.0 2.0   3.0         10.0   77.0 77.0     2.0       32     8   154 133   6 2   3         10   77 77     2   32   8   154
2333160 2333160 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_1                                                   20                                             20
2333161 2333161 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_2                                                   20                                             20
2333162 2333162 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_3                                                   20                                             20
2333163 2333163 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_4                                                   20                                             20
2333164 2333164 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_5                                                   20                                             20
2333165 2333165 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   grade_6                                                   14                                             14
2333166 2333166 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   kindergarten_4_year_old                                                   20                                             20
2333167 2333167 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2021   kindergarten                                                   20                                             20
2333168 2333168 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2021   pk_12_total 56.0 1.0 8.0 1.0   1.0             67.0       2.0       25     17   67 56 1 8 1   1             67       2   25   17   67
2333169 2333169 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2021   grade_10                                                   14                                             14
2333170 2333170 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2021   grade_11                                                   19                                             19
2333171 2333171 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2021   grade_12                                                   13                                             13
2333172 2333172 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2021   grade_9                                                   21                                             21
2333173 2333173 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2021   pk_12_total 24.0 1.0 3.0     1.0         1.0   21.0 9.0             3     *   30 24 1 3     1         1   21 9         3       30
2333174 2333174 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2021   pre_kindergarten                                                   30                                             30
2333175 2333175 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   pk_12_total 156.0 18.0 51.0 3.0   47.0       7.0 33.0   164.0 151.0     66.0       182     48   315 156 18 51 3   47       7 33   164 151     66   182   48   315
2333176 2333176 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   42                                             42
2333177 2333177 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   41                                             41
2333178 2333178 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   50                                             50
2333179 2333179 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   45                                             45
2333180 2333180 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   49                                             49
2333181 2333181 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   44                                             44
2333182 2333182 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   44                                             44
2333183 2333183 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   pk_12_total 363.0 4.0 24.0 1.0   11.0         7.0   225.0 185.0     11.0       74     79   410 363 4 24 1   11         7   225 185     11   74   79   410
2333184 2333184 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   67                                             67
2333185 2333185 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   65                                             65
2333186 2333186 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   62                                             62
2333187 2333187 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   63                                             63
2333188 2333188 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   43                                             43
2333189 2333189 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   62                                             62
2333190 2333190 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   48                                             48
2333191 2333191 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   pk_12_total 331.0 11.0 22.0     90.0         13.0   233.0 234.0     15.0       97     47   467 331 11 22     90         13   233 234     15   97   47   467
2333192 2333192 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_1                                                   52                                             52
2333193 2333193 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_2                                                   52                                             52
2333194 2333194 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_3                                                   51                                             51
2333195 2333195 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_4                                                   54                                             54
2333196 2333196 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_5                                                   53                                             53
2333197 2333197 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_6                                                   54                                             54
2333198 2333198 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_7                                                   48                                             48
2333199 2333199 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   grade_8                                                   53                                             53
2333200 2333200 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2021   kindergarten                                                   50                                             50
2333201 2333201 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   pk_12_total 78.0 11.0 22.0 2.0   11.0       1.0 18.0   75.0 68.0     7.0       122     40   143 78 11 22 2   11       1 18   75 68     7   122   40   143
2333202 2333202 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   23                                             23
2333203 2333203 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   18                                             18
2333204 2333204 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   13                                             13
2333205 2333205 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   29                                             29
2333206 2333206 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   17                                             17
2333207 2333207 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   23                                             23
2333208 2333208 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   20                                             20
2333209 2333209 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2021   pk_12_total 910.0 61.0 193.0 15.0   179.0         36.0   709.0 685.0     111.0       583     266   1394 910 61 193 15   179         36   709 685     111   583   266   1394
2333210 2333210 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2021   grade_10                                                   348                                             348
2333211 2333211 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2021   grade_11                                                   346                                             346
2333212 2333212 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2021   grade_12                                                   400                                             400
2333213 2333213 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2021   grade_9                                                   300                                             300
2333214 2333214 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   pk_12_total 163.0 21.0 17.0     19.0         10.0   117.0 113.0     22.0       127     68   230 163 21 17     19         10   117 113     22   127   68   230
2333215 2333215 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   30                                             30
2333216 2333216 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   35                                             35
2333217 2333217 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   29                                             29
2333218 2333218 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   39                                             39
2333219 2333219 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   30                                             30
2333220 2333220 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   24                                             24
2333221 2333221 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   37                                             37
2333222 2333222 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   6                                             6
2333223 2333223 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000052 120 Einstein Middle   Regular School No Middle 07 08 2021   pk_12_total 397.0 20.0 42.0 2.0   44.0         8.0   272.0 241.0     29.0       144     76   513 397 20 42 2   44         8   272 241     29   144   76   513
2333224 2333224 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000052 120 Einstein Middle   Regular School No Middle 07 08 2021   grade_7                                                   237                                             237
2333225 2333225 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000052 120 Einstein Middle   Regular School No Middle 07 08 2021   grade_8                                                   276                                             276

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