enrollments

Data source: Big Local News · About: Big Local

12,062 rows where state = "IN" and year = 2016 sorted by district_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2016 · 12,062 ✖
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
1287632 1287632 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_1                         3.0 0.0                       3.0                         3 0                 3
1287633 1287633 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_10                         9.0 0.0                       9.0                         9 0                 9
1287634 1287634 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_11                         4.0 1.0                       5.0                         4 1                 5
1287635 1287635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_12                         9.0 2.0                       11.0                         9 2                 11
1287636 1287636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_2                         6.0 1.0                       7.0                         6 1                 7
1287637 1287637 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_3                         4.0 1.0                       5.0                         4 1                 5
1287638 1287638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_4                         1.0 1.0                       2.0                         1 1                 2
1287639 1287639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_5                         4.0 2.0                       6.0                         4 2                 6
1287640 1287640 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_6                         11.0 1.0                       12.0                         11 1                 12
1287641 1287641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_7                         5.0 1.0                       6.0                         5 1                 6
1287642 1287642 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_8                         12.0 1.0                       13.0                         12 1                 13
1287643 1287643 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_9                         8.0 0.0                       8.0                         8 0                 8
1287644 1287644 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   pk_12_total 47.0 24.0 7.0               9.0   76.0 11.0     4.0             84.0   87.0 47 24 7               9   76 11     4       84   87
1290316 1290316 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2016   pk_12_total 107.0 38.0 31.0     1.0         19.0   142.0 54.0     0.0             135.0   196.0 107 38 31     1         19   142 54     0       135   196
1290317 1290317 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2016   pre_kindergarten                         142.0 54.0                       196.0                         142 54                 196
1285656 1285656 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         19.0 33.0                       52.0                         19 33                 52
1285657 1285657 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         31.0 17.0                       48.0                         31 17                 48
1285658 1285658 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         29.0 38.0                       67.0                         29 38                 67
1285659 1285659 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         29.0 26.0                       55.0                         29 26                 55
1285660 1285660 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         22.0 35.0                       57.0                         22 35                 57
1285661 1285661 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1285662 1285662 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   pk_12_total 309.0 4.0 18.0               5.0   164.0 172.0     2.0             78.0   336.0 309 4 18               5   164 172     2       78   336
1285663 1285663 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         7.0 3.0                       10.0                         7 3                 10
1285664 1285664 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   grade_6                         81.0 58.0                       139.0                         81 58                 139
1285665 1285665 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   grade_7                         66.0 47.0                       113.0                         66 47                 113
1285666 1285666 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   grade_8                         63.0 52.0                       115.0                         63 52                 115
1285667 1285667 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   pk_12_total 349.0 3.0 7.0     2.0         6.0   210.0 157.0     0.0             70.0   367.0 349 3 7     2         6   210 157     0       70   367
1285668 1285668 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         17.0 21.0                       38.0                         17 21                 38
1285669 1285669 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         27.0 29.0                       56.0                         27 29                 56
1285670 1285670 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         23.0 30.0                       53.0                         23 30                 53
1285671 1285671 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         29.0 22.0                       51.0                         29 22                 51
1285672 1285672 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         27.0 26.0                       53.0                         27 26                 53
1285673 1285673 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         21.0 17.0                       38.0                         21 17                 38
1285674 1285674 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 274.0 5.0 4.0     3.0         3.0   144.0 145.0     5.0             42.0   289.0 274 5 4     3         3   144 145     5       42   289
1285675 1285675 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_10                         68.0 50.0                       118.0                         68 50                 118
1285676 1285676 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_11                         75.0 65.0                       140.0                         75 65                 140
1285677 1285677 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_12                         59.0 67.0                       126.0                         59 67                 126
1285678 1285678 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_9                         65.0 62.0                       127.0                         65 62                 127
1285679 1285679 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   pk_12_total 477.0 9.0 19.0 1.0   3.0         2.0   267.0 244.0     3.0             106.0   511.0 477 9 19 1   3         2   267 244     3       106   511
1286497 1286497 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_10                         49.0 47.0                       96.0                         49 47                 96
1286498 1286498 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_11                         59.0 40.0                       99.0                         59 40                 99
1286499 1286499 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_12                         48.0 49.0                       97.0                         48 49                 97
1286500 1286500 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_9                         68.0 54.0                       122.0                         68 54                 122
1286501 1286501 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   pk_12_total 140.0 9.0 251.0               14.0   224.0 190.0     19.0             33.0   414.0 140 9 251               14   224 190     19       33   414
1286502 1286502 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2016   grade_6                         42.0 33.0                       75.0                         42 33                 75
1286503 1286503 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2016   grade_7                         49.0 38.0                       87.0                         49 38                 87
1286504 1286504 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2016   grade_8                         43.0 39.0                       82.0                         43 39                 82
1286505 1286505 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2016   pk_12_total 65.0 4.0 157.0     1.0         17.0   134.0 110.0     28.0             33.0   244.0 65 4 157     1         17   134 110     28       33   244
1286506 1286506 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         22.0 37.0                       59.0                         22 37                 59
1286507 1286507 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         23.0 42.0                       65.0                         23 42                 65
1286508 1286508 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         23.0 45.0                       68.0                         23 45                 68
1286509 1286509 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         44.0 32.0                       76.0                         44 32                 76
1286510 1286510 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         31.0 51.0                       82.0                         31 51                 82
1286511 1286511 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         35.0 34.0                       69.0                         35 34                 69
1286512 1286512 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   pk_12_total 117.0 14.0 325.0     2.0         8.0   212.0 254.0     84.0             80.0   466.0 117 14 325     2         8   212 254     84       80   466
1286513 1286513 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         34.0 13.0                       47.0                         34 13                 47
1285696 1285696 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   adult                         1.0 0.0                       1.0                         1 0                 1
1285697 1285697 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_10                         53.0 59.0                       112.0                         53 59                 112
1285698 1285698 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         50.0 47.0                       97.0                         50 47                 97
1285699 1285699 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_12                         50.0 52.0                       102.0                         50 52                 102
1285700 1285700 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_6                         5.0 1.0                       6.0                         5 1                 6
1285701 1285701 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_7                         83.0 107.0                       190.0                         83 107                 190
1285702 1285702 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_8                         97.0 83.0                       180.0                         97 83                 180
1285703 1285703 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_9                         68.0 50.0                       118.0                         68 50                 118
1285704 1285704 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   pk_12_total 743.0 10.0 32.0 3.0   7.0         11.0   407.0 399.0     43.0             118.0   806.0 743 10 32 3   7         11   407 399     43       118   806
1285705 1285705 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         27.0 32.0                       59.0                         27 32                 59
1285706 1285706 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         32.0 32.0                       64.0                         32 32                 64
1285707 1285707 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         23.0 29.0                       52.0                         23 29                 52
1285708 1285708 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         26.0 46.0                       72.0                         26 46                 72
1285709 1285709 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         38.0 37.0                       75.0                         38 37                 75
1285710 1285710 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   pk_12_total 315.0   4.0     2.0         1.0   146.0 176.0     137.0             35.0   322.0 315   4     2         1   146 176     137       35   322
1285711 1285711 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No 2.0 05 06 2016   grade_5                         111.0 92.0                       203.0                         111 92                 203
1285712 1285712 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No 2.0 05 06 2016   grade_6                         97.0 95.0                       192.0                         97 95                 192
1285713 1285713 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No 2.0 05 06 2016   pk_12_total 383.0 2.0 4.0     2.0         4.0   208.0 187.0     25.0             61.0   395.0 383 2 4     2         4   208 187     25       61   395
1285714 1285714 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_1                         54.0 49.0                       103.0                         54 49                 103
1285715 1285715 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         38.0 40.0                       78.0                         38 40                 78
1285716 1285716 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_3                         39.0 31.0                       70.0                         39 31                 70
1285717 1285717 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_4                         39.0 19.0                       58.0                         39 19                 58
1285718 1285718 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1285719 1285719 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1285720 1285720 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         52.0 28.0                       80.0                         52 28                 80
1285721 1285721 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   pk_12_total 379.0 2.0 3.0     1.0     2.0   5.0   224.0 168.0     171.0             55.0   392.0 379 2 3     1     2   5   224 168     171       55   392
1285722 1285722 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_1                         27.0 37.0                       64.0                         27 37                 64
1285723 1285723 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_2                         32.0 28.0                       60.0                         32 28                 60
1285724 1285724 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_3                         43.0 37.0                       80.0                         43 37                 80
1285725 1285725 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         40.0 37.0                       77.0                         40 37                 77
1285726 1285726 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   kindergarten                         36.0 40.0                       76.0                         36 40                 76
1285727 1285727 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   pk_12_total 342.0 3.0 9.0           1.0   2.0   178.0 179.0     101.0             39.0   357.0 342 3 9           1   2   178 179     101       39   357
1283918 1283918 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   grade_6                         2.0 1.0                       3.0                         2 1                 3
1283919 1283919 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   grade_7                         275.0 267.0                       542.0                         275 267                 542
1283920 1283920 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   grade_8                         297.0 257.0                       554.0                         297 257                 554
1283921 1283921 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   pk_12_total 913.0 31.0 70.0     29.0         56.0   574.0 525.0     33.0             152.0   1099.0 913 31 70     29         56   574 525     33       152   1099
1283922 1283922 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         49.0 43.0                       92.0                         49 43                 92
1283923 1283923 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         41.0 55.0                       96.0                         41 55                 96
1283924 1283924 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         37.0 49.0                       86.0                         37 49                 86
1283925 1283925 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         64.0 61.0                       125.0                         64 61                 125
1283926 1283926 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         34.0 37.0                       71.0                         34 37                 71
1283927 1283927 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   pk_12_total 409.0 8.0 10.0 1.0   9.0     1.0   32.0   225.0 245.0     2.0             93.0   470.0 409 8 10 1   9     1   32   225 245     2       93   470
1283928 1283928 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2016   adult                         3.0 2.0                       5.0                         3 2                 5
1283929 1283929 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2016   grade_10                         296.0 275.0                       571.0                         296 275                 571

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