enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
327251 327251 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2017   pk_12_total 1038.0 10.0 25.0 3.0   28.0         22.0   531.0 595.0             64     93   1126 1038 10 25 3   28         22   531 595         64   93   1126
327252 327252 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2017   grade_10                                                   278                                             278
327253 327253 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2017   grade_11                                                   284                                             284
327254 327254 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2017   grade_12                                                   288                                             288
327255 327255 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000270 20 Cedarburg High   Regular School No High 09 12 2017   grade_9                                                   276                                             276
327256 327256 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Elementary PK PK 2017   pk_12_total 10.0         1.0             7.0 4.0             1     *   11 10         1             7 4         1       11
327257 327257 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Elementary PK PK 2017   pre_kindergarten                                                   11                                             11
327258 327258 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   pk_12_total 423.0 1.0 17.0 2.0   9.0       1.0 9.0   241.0 221.0             44     39   462 423 1 17 2   9       1 9   241 221         44   39   462
327259 327259 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   66                                             66
327260 327260 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   75                                             75
327261 327261 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   71                                             71
327262 327262 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   75                                             75
327263 327263 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   71                                             71
327264 327264 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   46                                             46
327265 327265 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   58                                             58
327266 327266 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   pk_12_total 438.0 6.0 10.0 1.0   8.0         10.0   231.0 242.0             22     55   473 438 6 10 1   8         10   231 242         22   55   473
327267 327267 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   64                                             64
327268 327268 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   66                                             66
327269 327269 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   84                                             84
327270 327270 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   67                                             67
327271 327271 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   71                                             71
327272 327272 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   47                                             47
327273 327273 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000272 90 Thorson Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   74                                             74
327274 327274 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2017   pk_12_total 607.0 9.0 23.0 1.0   21.0       1.0 17.0   343.0 336.0             50     64   679 607 9 23 1   21       1 17   343 336         50   64   679
327275 327275 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2017   grade_6                                                   215                                             215
327276 327276 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2017   grade_7                                                   248                                             248
327277 327277 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2017   grade_8                                                   216                                             216
327278 327278 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   pk_12_total 300.0 8.0 11.0 2.0   10.0         6.0   177.0 160.0             38     39   337 300 8 11 2   10         6   177 160         38   39   337
327279 327279 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   49                                             49
327280 327280 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   56                                             56
327281 327281 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   50                                             50
327282 327282 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   59                                             59
327283 327283 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   54                                             54
327284 327284 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   32                                             32
327285 327285 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002403 75 Westlawn Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   37                                             37
327233 327233 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   pk_12_total 354.0 4.0 33.0 1.0   9.0       1.0 4.0   232.0 174.0             78     52   406 354 4 33 1   9       1 4   232 174         78   52   406
327234 327234 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   grade_1                                                   69                                             69
327235 327235 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   grade_2                                                   65                                             65
327236 327236 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   69                                             69
327237 327237 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   82                                             82
327238 327238 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   kindergarten_4_year_old                                                   54                                             54
327239 327239 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   kindergarten                                                   59                                             59
327240 327240 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   8                                             8
327241 327241 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2017   pk_12_total 327.0 1.0 17.0 3.0   3.0         1.0   182.0 170.0             41     27   352 327 1 17 3   3         1   182 170         41   27   352
327242 327242 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2017   grade_10                                                   88                                             88
327243 327243 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2017   grade_11                                                   88                                             88
327244 327244 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2017   grade_12                                                   92                                             92
327245 327245 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000267 40 Cedar Grove-Belgium High   Regular School No High 09 12 2017   grade_9                                                   84                                             84
327246 327246 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   pk_12_total 262.0 1.0 32.0 1.0   4.0       1.0 3.0   164.0 140.0             55     25   304 262 1 32 1   4       1 3   164 140         55   25   304
327247 327247 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   grade_5                                                   74                                             74
327248 327248 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   grade_6                                                   78                                             78
327249 327249 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   grade_7                                                   74                                             74
327250 327250 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   grade_8                                                   78                                             78
325734 325734 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   pk_12_total 96.0   42.0               1.0   77.0 62.0             65     23   139 96   42               1   77 62         65   23   139
325735 325735 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_1                                                   24                                             24
325736 325736 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_2                                                   34                                             34
325737 325737 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_3                                                   25                                             25
325738 325738 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_4                                                   30                                             30
325739 325739 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_5                                                   26                                             26
325740 325740 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   pk_12_total 162.0 1.0 46.0 1.0                 123.0 87.0             89     33   210 162 1 46 1                 123 87         89   33   210
325741 325741 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_10                                                   36                                             36
325742 325742 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_11                                                   27                                             27
325743 325743 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_12                                                   20                                             20
325744 325744 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_6                                                   29                                             29
325745 325745 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_7                                                   41                                             41
325746 325746 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_8                                                   19                                             19
325747 325747 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   grade_9                                                   38                                             38
325748 325748 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   pk_12_total 46.0   13.0 1.0                 32.0 28.0             22     6   60 46   13 1                 32 28         22   6   60
325749 325749 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   kindergarten_4_year_old                                                   28                                             28
325750 325750 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   kindergarten                                                   31                                             31
325751 325751 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   1                                             1
327302 327302 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   pk_12_total 207.0   7.0 2.0   6.0       5.0 1.0   116.0 112.0             82     31   228 207   7 2   6       5 1   116 112         82   31   228
327303 327303 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_10                                                   41                                             41
327304 327304 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_11                                                   59                                             59
327305 327305 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_12                                                   59                                             59
327306 327306 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_9                                                   69                                             69
327307 327307 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   pk_12_total 156.0 2.0 2.0     3.0       8.0 1.0   94.0 78.0             74     20   172 156 2 2     3       8 1   94 78         74   20   172
327308 327308 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_6                                                   59                                             59
327309 327309 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_7                                                   54                                             54
327310 327310 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_8                                                   59                                             59
327311 327311 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   pk_12_total 10.0                   1.0   5.0 6.0             5     1   11 10                   1   5 6         5   1   11
327312 327312 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_10                                                   2                                             2
327313 327313 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_11                                                   3                                             3
327314 327314 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_12                                                   4                                             4
327315 327315 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_9                                                   2                                             2
327316 327316 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   pk_12_total 35.0 1.0   2.0                 29.0 9.0             *     4   38 35 1   2                 29 9             4   38
327317 327317 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_1                                                   7                                             7
327318 327318 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_2                                                   5                                             5
327319 327319 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_3                                                   11                                             11
327320 327320 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   kindergarten_4_year_old                                                   5                                             5
327321 327321 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   kindergarten                                                   10                                             10
327322 327322 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   pk_12_total 205.0   8.0 5.0   2.0       21.0 6.0   127.0 120.0             157     42   247 205   8 5   2       21 6   127 120         157   42   247
327323 327323 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   32                                             32
327324 327324 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   35                                             35
327325 327325 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   38                                             38
327326 327326 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   43                                             43
327327 327327 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
327328 327328 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   18                                             18
327329 327329 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   30                                             30
327330 327330 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   4                                             4

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