enrollments

Data source: Big Local News · About: Big Local

14,653 rows where state = "WI" and year = 2015 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,653 ✖
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
126382 126382 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   34                                             34
126381 126381 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   24                                             24
126380 126380 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   74                                             74
126379 126379 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   60                                             60
126378 126378 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   70                                             70
126377 126377 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   57                                             57
126376 126376 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   59                                             59
126375 126375 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   38                                             38
126374 126374 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   35                                             35
126373 126373 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   36                                             36
126372 126372 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 445.0 1.0 22.0     4.0         15.0   272.0 215.0             69     34   487 445 1 22     4         15   272 215         69   34   487
126371 126371 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_8                                                   108                                             108
126370 126370 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_7                                                   108                                             108
126369 126369 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_6                                                   103                                             103
126368 126368 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_5                                                   80                                             80
126367 126367 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   pk_12_total 364.0 3.0 24.0 4.0   3.0       1.0     198.0 201.0             72     30   399 364 3 24 4   3       1     198 201         72   30   399
126366 126366 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   grade_9                                                   126                                             126
126365 126365 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   grade_12                                                   106                                             106
126364 126364 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   grade_11                                                   111                                             111
126363 126363 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   grade_10                                                   114                                             114
126362 126362 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   pk_12_total 419.0 14.0 16.0 3.0   2.0         3.0   224.0 233.0             72     38   457 419 14 16 3   2         3   224 233         72   38   457
126361 126361 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   8                                             8
126360 126360 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   81                                             81
126359 126359 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   68                                             68
126358 126358 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
126357 126357 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   grade_3                                                   86                                             86
126356 126356 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   69                                             69
126355 126355 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   73                                             73
126354 126354 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 411.0 5.0 42.0 9.0   2.0       1.0 12.0   240.0 242.0             122     60   482 411 5 42 9   2       1 12   240 242         122   60   482
126353 126353 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   1                                             1
126352 126352 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   47                                             47
126351 126351 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   40                                             40
126350 126350 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   64                                             64
126349 126349 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   51                                             51
126348 126348 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   53                                             53
126347 126347 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   57                                             57
126346 126346 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   50                                             50
126345 126345 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   49                                             49
126344 126344 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   46                                             46
126343 126343 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   48                                             48
126342 126342 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 425.0 6.0 8.0 52.0   2.0       2.0 11.0   274.0 232.0             202     61   506 425 6 8 52   2       2 11   274 232         202   61   506
126341 126341 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   36                                             36
126340 126340 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   35                                             35
126339 126339 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   23                                             23
126338 126338 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   28                                             28
126337 126337 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   34                                             34
126336 126336 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   pk_12_total 27.0 87.0 27.0     3.0         12.0   83.0 73.0             72     8   156 27 87 27     3         12   83 73         72   8   156
126335 126335 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   33                                             33
126334 126334 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   33                                             33
126333 126333 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   32                                             32
126332 126332 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   35                                             35
126331 126331 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   34                                             34
126330 126330 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_5                                                   36                                             36
126329 126329 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_4                                                   34                                             34
126328 126328 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   35                                             35
126327 126327 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   37                                             37
126326 126326 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   33                                             33
126325 126325 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   pk_12_total 170.0 82.0 55.0 1.0   14.0         20.0   180.0 162.0             55     28   342 170 82 55 1   14         20   180 162         55   28   342
126324 126324 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_8                                                   28                                             28
126323 126323 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_7                                                   20                                             20
126322 126322 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_6                                                   30                                             30
126321 126321 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   pk_12_total 72.0 2.0 2.0             1.0 1.0   40.0 38.0             43     16   78 72 2 2             1 1   40 38         43   16   78
126320 126320 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No 3.0 09 12 2015   grade_9                                                   21                                             21
126319 126319 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No 3.0 09 12 2015   grade_12                                                   26                                             26
126318 126318 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No 3.0 09 12 2015   grade_11                                                   24                                             24
126317 126317 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No 3.0 09 12 2015   grade_10                                                   24                                             24
126316 126316 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002225 80 Wonewoc-Center High   Regular School No 3.0 09 12 2015   pk_12_total 93.0   1.0               1.0   46.0 49.0             48     13   95 93   1               1   46 49         48   13   95
126315 126315 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
126314 126314 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   19                                             19
126313 126313 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   21                                             21
126312 126312 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   21                                             21
126311 126311 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   21                                             21
126310 126310 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   31                                             31
126309 126309 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   28                                             28
126308 126308 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   17                                             17
126307 126307 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 154.0 2.0 1.0             2.0 6.0   79.0 86.0             93     25   165 154 2 1             2 6   79 86         93   25   165
126306 126306 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   grade_12                                                   1                                             1
126305 126305 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
126304 126304 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No 3.0 09 12 2015   grade_9                                                   88                                             88
126303 126303 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No 3.0 09 12 2015   grade_12                                                   109                                             109
126302 126302 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No 3.0 09 12 2015   grade_11                                                   70                                             70
126301 126301 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No 3.0 09 12 2015   grade_10                                                   83                                             83
126300 126300 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002222 140 Wittenberg-Birnamwood High   Regular School No 3.0 09 12 2015   pk_12_total 310.0 3.0 14.0 17.0   2.0         4.0   182.0 168.0             111     52   350 310 3 14 17   2         4   182 168         111   52   350
126299 126299 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   10                                             10
126298 126298 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   47                                             47
126297 126297 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   48                                             48
126296 126296 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   47                                             47
126295 126295 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   43                                             43
126294 126294 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   43                                             43
126293 126293 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   47                                             47
126292 126292 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   45                                             45
126291 126291 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   42                                             42
126290 126290 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   43                                             43
126289 126289 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   39                                             39
126288 126288 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 353.0 2.0 49.0 24.0   3.0       1.0 22.0   253.0 201.0             215     81   454 353 2 49 24   3       1 22   253 201         215   81   454
126287 126287 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   kindergarten                                                   34                                             34
126286 126286 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   32                                             32
126285 126285 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   28                                             28
126284 126284 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   39                                             39
126283 126283 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   42                                             42

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