enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
3103238 3103238 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   28                                             28
3103237 3103237 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   39                                             39
3103236 3103236 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   33                                             33
3103235 3103235 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   33                                             33
3103234 3103234 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_5                                                   47                                             47
3103233 3103233 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   48                                             48
3103232 3103232 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   35                                             35
3103231 3103231 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   44                                             44
3103230 3103230 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   42                                             42
3103229 3103229 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   pk_12_total 347.0   12.0 15.0             12.0   206.0 180.0             146     57   386 347   12 15             12   206 180         146   57   386
3103228 3103228 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   2                                             2
3103227 3103227 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   173                                             173
3103226 3103226 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2018   pk_12_total 140.0 3.0 9.0 1.0   13.0         9.0   91.0 84.0             51     12   175 140 3 9 1   13         9   91 84         51   12   175
3103225 3103225 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
3103224 3103224 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   57                                             57
3103223 3103223 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   33                                             33
3103222 3103222 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   54                                             54
3103221 3103221 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   58                                             58
3103220 3103220 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   64                                             64
3103219 3103219 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   49                                             49
3103218 3103218 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   69                                             69
3103217 3103217 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   pk_12_total 346.0 2.0 19.0 2.0   10.0         7.0   192.0 194.0             142     64   386 346 2 19 2   10         7   192 194         142   64   386
3103216 3103216 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 07 2018   grade_7                                                   357                                             357
3103215 3103215 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 07 2018   grade_6                                                   362                                             362
3103214 3103214 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 07 2018   pk_12_total 588.0 19.0 39.0 19.0   31.0         23.0   369.0 350.0             345     105   719 588 19 39 19   31         23   369 350         345   105   719
3103213 3103213 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   52                                             52
3103212 3103212 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   2                                             2
3103211 3103211 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   52                                             52
3103210 3103210 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   63                                             63
3103209 3103209 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   56                                             56
3103208 3103208 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   48                                             48
3103207 3103207 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   58                                             58
3103206 3103206 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2018   pk_12_total 290.0 4.0 13.0 6.0   10.0         8.0   161.0 170.0             141     27   331 290 4 13 6   10         8   161 170         141   27   331
3103205 3103205 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
3103204 3103204 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   kindergarten                                                   5                                             5
3103203 3103203 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   2                                             2
3103202 3103202 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   grade_5                                                   17                                             17
3103201 3103201 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   grade_4                                                   9                                             9
3103200 3103200 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   grade_3                                                   13                                             13
3103199 3103199 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   grade_2                                                   17                                             17
3103198 3103198 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   grade_1                                                   11                                             11
3103197 3103197 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2018   pk_12_total 72.0 1.0   2.0             2.0   39.0 38.0             20     14   77 72 1   2             2   39 38         20   14   77
3103196 3103196 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   kindergarten                                                   24                                             24
3103195 3103195 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   31                                             31
3103194 3103194 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   grade_5                                                   27                                             27
3103193 3103193 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   grade_4                                                   28                                             28
3103192 3103192 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   grade_3                                                   23                                             23
3103191 3103191 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   grade_2                                                   30                                             30
3103190 3103190 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   grade_1                                                   18                                             18
3103189 3103189 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2018   pk_12_total 167.0 2.0 5.0 1.0   5.0         1.0   100.0 81.0             61     13   181 167 2 5 1   5         1   100 81         61   13   181
3103188 3103188 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2018   grade_12                                                   51                                             51
3103187 3103187 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2018   grade_11                                                   28                                             28
3103186 3103186 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2018   grade_10                                                   3                                             3
3103185 3103185 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2018   pk_12_total 63.0 3.0 6.0 3.0   4.0         3.0   41.0 41.0             53     18   82 63 3 6 3   4         3   41 41         53   18   82
3103184 3103184 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
3103183 3103183 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   kindergarten                                                   50                                             50
3103182 3103182 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   kindergarten_4_year_old                                                   34                                             34
3103181 3103181 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   grade_5                                                   62                                             62
3103180 3103180 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   grade_4                                                   56                                             56
3103179 3103179 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   grade_3                                                   50                                             50
3103178 3103178 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   grade_2                                                   60                                             60
3103177 3103177 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   grade_1                                                   52                                             52
3103176 3103176 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2018   pk_12_total 278.0 8.0 26.0 10.0   20.0       2.0 23.0   180.0 187.0             250     77   367 278 8 26 10   20       2 23   180 187         250   77   367
3103175 3103175 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 10 12 2018   grade_12                                                   396                                             396
3103174 3103174 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 10 12 2018   grade_11                                                   368                                             368
3103173 3103173 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 10 12 2018   grade_10                                                   355                                             355
3103172 3103172 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002209 160 Lincoln High   Regular School No High 10 12 2018   pk_12_total 993.0 21.0 33.0 7.0   50.0         15.0   592.0 527.0             392     169   1119 993 21 33 7   50         15   592 527         392   169   1119
3103171 3103171 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   43                                             43
3103170 3103170 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   grade_5                                                   62                                             62
3103169 3103169 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   grade_4                                                   56                                             56
3103168 3103168 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   56                                             56
3103167 3103167 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   50                                             50
3103166 3103166 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   grade_1                                                   59                                             59
3103165 3103165 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2018   pk_12_total 248.0 13.0 22.0 5.0   27.0         11.0   166.0 160.0             202     53   326 248 13 22 5   27         11   166 160         202   53   326
3103164 3103164 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3103163 3103163 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   41                                             41
3103162 3103162 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   33                                             33
3103161 3103161 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   49                                             49
3103160 3103160 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   38                                             38
3103159 3103159 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   47                                             47
3103158 3103158 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   25                                             25
3103157 3103157 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   41                                             41
3103156 3103156 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   pk_12_total 204.0 1.0 31.0 1.0   26.0         12.0   143.0 132.0             164     30   275 204 1 31 1   26         12   143 132         164   30   275
3103155 3103155 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   62                                             62
3103154 3103154 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   44                                             44
3103153 3103153 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   46                                             46
3103152 3103152 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   46                                             46
3103151 3103151 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   50                                             50
3103150 3103150 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   45                                             45
3103149 3103149 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   51                                             51
3103148 3103148 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2018   pk_12_total 321.0 4.0 4.0 4.0             11.0   180.0 164.0             83     30   344 321 4 4 4             11   180 164         83   30   344
3103147 3103147 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_9                                                   353                                             353
3103146 3103146 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_8                                                   366                                             366
3103145 3103145 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   pk_12_total 612.0 13.0 36.0 6.0   31.0         21.0   363.0 356.0             310     102   719 612 13 36 6   31         21   363 356         310   102   719
3103144 3103144 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   grade_8                                                   47                                             47
3103143 3103143 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   grade_7                                                   53                                             53
3103142 3103142 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   grade_6                                                   47                                             47
3103141 3103141 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   pk_12_total 130.0 6.0 5.0     1.0         5.0   72.0 75.0             30     18   147 130 6 5     1         5   72 75         30   18   147
3103140 3103140 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000172 60 Wisconsin Heights High   Regular School No High 09 12 2018   grade_9                                                   60                                             60
3103139 3103139 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000172 60 Wisconsin Heights High   Regular School No High 09 12 2018   grade_12                                                   54                                             54

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