enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021 sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 15,006 ✖
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
2332926 2332926 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   pk_12_total 47.0 264.0 168.0               34.0   254.0 259.0     55.0       405     54   513 47 264 168               34   254 259     55   405   54   513
2332927 2332927 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_1                                                   58                                             58
2332928 2332928 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_2                                                   43                                             43
2332929 2332929 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_3                                                   56                                             56
2332930 2332930 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_4                                                   49                                             49
2332931 2332931 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_5                                                   53                                             53
2332932 2332932 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_6                                                   60                                             60
2332933 2332933 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_7                                                   60                                             60
2332934 2332934 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   53                                             53
2332935 2332935 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   kindergarten_4_year_old                                                   37                                             37
2332936 2332936 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   kindergarten                                                   44                                             44
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
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
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
2333234 2333234 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2021   pk_12_total 62.0 11.0 4.0     2.0       1.0 1.0   33.0 48.0             17     5   81 62 11 4     2       1 1   33 48         17   5   81
2333235 2333235 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2021   grade_10                                                   14                                             14
2333236 2333236 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2021   grade_11                                                   21                                             21
2333237 2333237 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2021   grade_12                                                   26                                             26
2333238 2333238 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2021   grade_9                                                   20                                             20
2333239 2333239 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   pk_12_total 65.0 4.0 3.0     4.0         7.0   50.0 33.0     2.0       18     5   83 65 4 3     4         7   50 33     2   18   5   83
2333240 2333240 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_1                                                   14                                             14
2333241 2333241 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_2                                                   9                                             9
2333242 2333242 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_3                                                   11                                             11
2333243 2333243 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_4                                                   9                                             9
2333244 2333244 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_5                                                   8                                             8
2333245 2333245 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_6                                                   5                                             5
2333246 2333246 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_7                                                   14                                             14
2333247 2333247 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_8                                                   4                                             4
2333248 2333248 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   kindergarten                                                   9                                             9
2333308 2333308 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2021   pk_12_total 360.0 41.0 71.0 2.0   38.0         26.0   260.0 278.0     55.0       237     91   538 360 41 71 2   38         26   260 278     55   237   91   538
2333309 2333309 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2021   grade_6                                                   115                                             115
2333310 2333310 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2021   grade_7                                                   238                                             238
2333311 2333311 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2021   grade_8                                                   185                                             185
2333345 2333345 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2021   pk_12_total 118.0 5.0 6.0     7.0         3.0   17.0 122.0             35     8   139 118 5 6     7         3   17 122         35   8   139
2333346 2333346 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2021   grade_10                                                   28                                             28
2333347 2333347 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2021   grade_11                                                   33                                             33
2333348 2333348 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2021   grade_12                                                   28                                             28
2333349 2333349 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2021   grade_9                                                   50                                             50
2333358 2333358 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   pk_12_total 157.0 20.0 27.0 3.0   83.0       1.0 20.0   156.0 155.0     59.0       182     51   311 157 20 27 3   83       1 20   156 155     59   182   51   311
2333359 2333359 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_1                                                   43                                             43
2333360 2333360 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_2                                                   39                                             39
2333361 2333361 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_3                                                   39                                             39
2333362 2333362 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_4                                                   56                                             56
2333363 2333363 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_5                                                   46                                             46
2333364 2333364 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   grade_6                                                   49                                             49
2333365 2333365 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2021   kindergarten                                                   39                                             39
2333366 2333366 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2021   pk_12_total 119.0 2.0 10.0 2.0   7.0         3.0   123.0 20.0     4.0       23     13   143 119 2 10 2   7         3   123 20     4   23   13   143
2333367 2333367 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2021   grade_10                                                   41                                             41
2333368 2333368 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2021   grade_11                                                   33                                             33
2333369 2333369 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2021   grade_12                                                   25                                             25
2333370 2333370 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2021   grade_9                                                   44                                             44
2333371 2333371 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   pk_12_total 61.0 1.0 1.0 1.0   1.0         2.0   29.0 38.0     2.0       17     4   67 61 1 1 1   1         2   29 38     2   17   4   67
2333372 2333372 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_10                                                   10                                             10
2333373 2333373 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_11                                                   12                                             12
2333374 2333374 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_12                                                   18                                             18
2333375 2333375 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_7                                                   8                                             8
2333376 2333376 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_8                                                   10                                             10
2333377 2333377 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_9                                                   9                                             9
2333386 2333386 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   pk_12_total 905.0 66.0 96.0 3.0   58.0       1.0 104.0   524.0 709.0     19.0       540     22   1233 905 66 96 3   58       1 104   524 709     19   540   22   1233
2333387 2333387 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   87                                             87
2333388 2333388 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_10                                                   72                                             72
2333389 2333389 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_11                                                   81                                             81
2333390 2333390 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_12                                                   90                                             90
2333391 2333391 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_2                                                   91                                             91
2333392 2333392 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_3                                                   93                                             93
2333393 2333393 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_4                                                   104                                             104
2333394 2333394 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_5                                                   114                                             114

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