Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018

View and edit SQL

grade

year

  • 2018 · 11,919
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
1787387 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   kindergarten                         37.0 31.0                       68.0                         37 31                 68
1787388 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   pk_12_total 353.0 12.0 14.0     34.0         23.0   218.0 218.0     2.0         33.0   34.0   436.0 353 12 14     34         23   218 218     2     33 34   436
1787389 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_1                         60.0 70.0                       130.0                         60 70                 130
1787390 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_2                         68.0 59.0                       127.0                         68 59                 127
1787391 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_3                         76.0 64.0                       140.0                         76 64                 140
1787392 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_4                         66.0 73.0                       139.0                         66 73                 139
1787393 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_5                         60.0 77.0                       137.0                         60 77                 137
1787394 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         95.0 58.0                       153.0                         95 58                 153
1787395 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 624.0 88.0 46.0     19.0     1.0   48.0   425.0 401.0     9.0         170.0   63.0   826.0 624 88 46     19     1   48   425 401     9     170 63   826
1787396 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_1                         15.0 11.0                       26.0                         15 11                 26
1787397 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_2                         17.0 18.0                       35.0                         17 18                 35
1787398 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_3                         18.0 13.0                       31.0                         18 13                 31
1787399 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_4                         12.0 18.0                       30.0                         12 18                 30
1787400 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_5                         15.0 17.0                       32.0                         15 17                 32
1787401 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1787402 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   pk_12_total 155.0 2.0 13.0 2.0             9.0   91.0 90.0     3.0         57.0   30.0   181.0 155 2 13 2             9   91 90     3     57 30   181
1787403 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_6                         162.0 127.0                       289.0                         162 127                 289
1787404 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_7                         152.0 140.0                       292.0                         152 140                 292
1787405 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 128.0                       260.0                         132 128                 260
1787406 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   pk_12_total 715.0 14.0 40.0     38.0         34.0   446.0 395.0     4.0         130.0   96.0   841.0 715 14 40     38         34   446 395     4     130 96   841
1787407 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_1                         35.0 36.0                       71.0                         35 36                 71
1787408 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_2                         39.0 36.0                       75.0                         39 36                 75
1787409 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_3                         31.0 38.0                       69.0                         31 38                 69
1787410 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_4                         32.0 43.0                       75.0                         32 43                 75
1787411 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_5                         35.0 37.0                       72.0                         35 37                 72
1787412 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         26.0 36.0                       62.0                         26 36                 62
1787413 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 354.0 7.0 13.0 3.0   21.0         35.0   204.0 229.0     15.0         64.0   73.0   433.0 354 7 13 3   21         35   204 229     15     64 73   433
1787414 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         6.0 3.0                       9.0                         6 3                 9
1787415 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 65.0                       118.0                         53 65                 118
1787416 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_2                         56.0 39.0                       95.0                         56 39                 95
1787417 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_3                         57.0 57.0                       114.0                         57 57                 114
1787418 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_4                         56.0 57.0                       113.0                         56 57                 113
1787419 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_5                         65.0 41.0                       106.0                         65 41                 106
1787420 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         72.0 44.0                       116.0                         72 44                 116
1787421 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 555.0 10.0 39.0     25.0         33.0   359.0 303.0     18.0         217.0   113.0   662.0 555 10 39     25         33   359 303     18     217 113   662
1787422 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   grade_6                         148.0 150.0                       298.0                         148 150                 298
1787423 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   grade_7                         140.0 149.0                       289.0                         140 149                 289
1787424 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   grade_8                         178.0 136.0                       314.0                         178 136                 314
1787425 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   pk_12_total 757.0 24.0 55.0 1.0   20.0         44.0   466.0 435.0     9.0         221.0   137.0   901.0 757 24 55 1   20         44   466 435     9     221 137   901
1787426 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   grade_10                         276.0 320.0                       596.0                         276 320                 596
1787427 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   grade_11                         268.0 328.0                       596.0                         268 328                 596
1787428 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   grade_12                         291.0 265.0                       556.0                         291 265                 556
1787429 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   grade_9                         338.0 325.0                       663.0                         338 325                 663
1787430 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   pk_12_total 2079.0 57.0 92.0 6.0   90.0         87.0   1173.0 1238.0     19.0         429.0   256.0   2411.0 2079 57 92 6   90         87   1173 1238     19     429 256   2411
1787431 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_1                         48.0 33.0                       81.0                         48 33                 81
1787432 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_2                         46.0 42.0                       88.0                         46 42                 88
1787433 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_3                         44.0 47.0                       91.0                         44 47                 91
1787434 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_4                         33.0 45.0                       78.0                         33 45                 78
1787435 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_5                         47.0 46.0                       93.0                         47 46                 93
1787436 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         48.0 48.0                       96.0                         48 48                 96
1787437 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 454.0 16.0 22.0     12.0         23.0   266.0 261.0     11.0         94.0   56.0   527.0 454 16 22     12         23   266 261     11     94 56   527
1787438 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_1                         46.0 51.0                       97.0                         46 51                 97
1787439 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_2                         41.0 31.0                       72.0                         41 31                 72
1787440 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_3                         38.0 33.0                       71.0                         38 33                 71
1787441 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_4                         37.0 33.0                       70.0                         37 33                 70
1787442 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_5                         47.0 35.0                       82.0                         47 35                 82
1787443 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1787444 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 405.0 8.0 17.0     21.0         24.0   252.0 223.0     15.0         39.0   46.0   475.0 405 8 17     21         24   252 223     15     39 46   475
1787445 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_1                         35.0 50.0                       85.0                         35 50                 85
1787446 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_2                         41.0 38.0                       79.0                         41 38                 79
1787447 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_3                         51.0 42.0                       93.0                         51 42                 93
1787448 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_4                         55.0 52.0                       107.0                         55 52                 107
1787449 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_5                         57.0 53.0                       110.0                         57 53                 110
1787450 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         40.0 44.0                       84.0                         40 44                 84
1787451 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 482.0 16.0 31.0 1.0   32.0         21.0   297.0 286.0     17.0         55.0   72.0   583.0 482 16 31 1   32         21   297 286     17     55 72   583
1787452 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 7.0                       25.0                         18 7                 25
1787453 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_1                         57.0 46.0                       103.0                         57 46                 103
1787454 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_2                         38.0 33.0                       71.0                         38 33                 71
1787455 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_3                         45.0 36.0                       81.0                         45 36                 81
1787456 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_4                         48.0 53.0                       101.0                         48 53                 101
1787457 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_5                         50.0 49.0                       99.0                         50 49                 99
1787458 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         51.0 43.0                       94.0                         51 43                 94
1787459 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 451.0 10.0 23.0     15.0         50.0   289.0 260.0     29.0         122.0   72.0   549.0 451 10 23     15         50   289 260     29     122 72   549
1787460 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_10                         2.0 1.0                       3.0                         2 1                 3
1787461 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_11                         1.0 1.0                       2.0                         1 1                 2
1787462 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_8                         0.0 3.0                       3.0                         0 3                 3
1787463 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1787464 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   pk_12_total 8.0 1.0                     3.0 6.0     0.0         9.0   2.0   9.0 8 1                     3 6     0     9 2   9
1787465 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_10                         3.0 3.0                       6.0                         3 3                 6
1787466 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_11                         1.0 0.0                       1.0                         1 0                 1
1787467 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1787468 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   pk_12_total 5.0 1.0 1.0               1.0   5.0 3.0     1.0         4.0   5.0   8.0 5 1 1               1   5 3     1     4 5   8
1787469 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   grade_10                         205.0 200.0                       405.0                         205 200                 405
1787470 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   grade_11                         209.0 202.0                       411.0                         209 202                 411
1787471 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   grade_12                         222.0 203.0                       425.0                         222 203                 425
1787472 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   grade_9                         214.0 189.0                       403.0                         214 189                 403
1787473 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   pk_12_total 710.0 380.0 253.0 3.0   114.0     2.0   182.0   850.0 794.0     109.0         1237.0   348.0   1644.0 710 380 253 3   114     2   182   850 794     109     1237 348   1644
1787474 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   grade_10                         230.0 246.0                       476.0                         230 246                 476
1787475 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   grade_11                         234.0 232.0                       466.0                         234 232                 466
1787476 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   grade_12                         236.0 234.0                       470.0                         236 234                 470
1787477 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   grade_9                         245.0 238.0                       483.0                         245 238                 483
1787478 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   pk_12_total 1047.0 444.0 182.0 11.0   73.0         138.0   945.0 950.0     61.0         932.0   234.0   1895.0 1047 444 182 11   73         138   945 950     61     932 234   1895
1787479 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   grade_10                         184.0 192.0                       376.0                         184 192                 376
1787480 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   grade_11                         188.0 164.0                       352.0                         188 164                 352
1787481 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   grade_12                         162.0 153.0                       315.0                         162 153                 315
1787482 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   grade_9                         156.0 159.0                       315.0                         156 159                 315
1787483 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   pk_12_total 250.0 454.0 425.0     99.0     3.0   127.0   690.0 668.0     152.0         1106.0   229.0   1358.0 250 454 425     99     3   127   690 668     152     1106 229   1358
1787484 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_6                         156.0 126.0                       282.0                         156 126                 282
1787485 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_7                         119.0 138.0                       257.0                         119 138                 257
1787486 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_8                         142.0 130.0                       272.0                         142 130                 272

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