enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1787408 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 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 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 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 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
1787414 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 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 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 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 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 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 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
1787422 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 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 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
1787426 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 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 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 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
1787431 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 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 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 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 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 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
1787438 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 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 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 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 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 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
1787445 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 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 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 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 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 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
1787452 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 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 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 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 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 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 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
1787460 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 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 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 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
1787465 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 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 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
1787469 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 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 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 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
1787474 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 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 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 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
1787479 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 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 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 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
1787484 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 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 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
1787488 1787488 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_1                         30.0 31.0                       61.0                         30 31                 61
1787489 1787489 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_2                         43.0 33.0                       76.0                         43 33                 76
1787490 1787490 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_3                         39.0 39.0                       78.0                         39 39                 78
1787491 1787491 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_4                         30.0 35.0                       65.0                         30 35                 65
1787492 1787492 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_5                         32.0 38.0                       70.0                         32 38                 70
1787493 1787493 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_6                         46.0 40.0                       86.0                         46 40                 86
1787494 1787494 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_7                         41.0 43.0                       84.0                         41 43                 84
1787495 1787495 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_8                         39.0 38.0                       77.0                         39 38                 77
1787497 1787497 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_6                         109.0 118.0                       227.0                         109 118                 227
1787498 1787498 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_7                         141.0 117.0                       258.0                         141 117                 258
1787499 1787499 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_8                         102.0 116.0                       218.0                         102 116                 218
1787501 1787501 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2018   grade_6                         80.0 69.0                       149.0                         80 69                 149
1787502 1787502 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2018   grade_7                         110.0 86.0                       196.0                         110 86                 196
1787503 1787503 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2018   grade_8                         87.0 73.0                       160.0                         87 73                 160
1787505 1787505 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2018   grade_6                         91.0 85.0                       176.0                         91 85                 176
1787506 1787506 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2018   grade_7                         89.0 81.0                       170.0                         89 81                 170
1787507 1787507 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2018   grade_8                         92.0 61.0                       153.0                         92 61                 153
1787509 1787509 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2018   grade_6                         120.0 109.0                       229.0                         120 109                 229
1787510 1787510 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2018   grade_7                         126.0 119.0                       245.0                         126 119                 245
1787511 1787511 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2018   grade_8                         93.0 124.0                       217.0                         93 124                 217
1787513 1787513 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2018   grade_6                         108.0 102.0                       210.0                         108 102                 210
1787514 1787514 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2018   grade_7                         89.0 119.0                       208.0                         89 119                 208
1787515 1787515 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2018   grade_8                         73.0 110.0                       183.0                         73 110                 183
1787517 1787517 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2018   grade_6                         113.0 65.0                       178.0                         113 65                 178
1787518 1787518 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2018   grade_7                         100.0 99.0                       199.0                         100 99                 199
1787519 1787519 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2018   grade_8                         92.0 82.0                       174.0                         92 82                 174
1787521 1787521 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2018   grade_6                         115.0 106.0                       221.0                         115 106                 221
1787522 1787522 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2018   grade_7                         110.0 92.0                       202.0                         110 92                 202
1787523 1787523 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2018   grade_8                         106.0 101.0                       207.0                         106 101                 207
1787525 1787525 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2018   grade_6                         83.0 76.0                       159.0                         83 76                 159
1787526 1787526 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2018   grade_7                         89.0 60.0                       149.0                         89 60                 149
1787527 1787527 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2018   grade_8                         76.0 60.0                       136.0                         76 60                 136
1787529 1787529 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_1                         67.0 56.0                       123.0                         67 56                 123
1787530 1787530 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_2                         62.0 58.0                       120.0                         62 58                 120

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