Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by rowid descending

View and edit SQL

grade

year

  • 2015 · 12,044
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
1171505 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   pk_12_total 2.0 470.0 7.0               26.0   257.0 248.0                       505.0 2 470 7               26   257 248                 505
1171504 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   kindergarten                         39.0 50.0                       89.0                         39 50                 89
1171503 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_4                         36.0 53.0                       89.0                         36 53                 89
1171502 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_3                         63.0 47.0                       110.0                         63 47                 110
1171501 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_2                         61.0 46.0                       107.0                         61 46                 107
1171500 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_1                         58.0 52.0                       110.0                         58 52                 110
1171499 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   pk_12_total 3.0 327.0 4.0 2.0             7.0   0.0 343.0                       343.0 3 327 4 2             7   0 343                 343
1171498 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_8                         0.0 97.0                       97.0                         0 97                 97
1171497 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_7                         0.0 106.0                       106.0                         0 106                 106
1171496 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_6                         0.0 99.0                       99.0                         0 99                 99
1171495 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_5                         0.0 41.0                       41.0                         0 41                 41
1171494 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   pk_12_total 8.0 218.0 8.0 1.0             20.0   145.0 110.0                       255.0 8 218 8 1             20   145 110                 255
1171493 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   kindergarten                         30.0 23.0                       53.0                         30 23                 53
1171492 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_6                         8.0 13.0                       21.0                         8 13                 21
1171491 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         15.0 14.0                       29.0                         15 14                 29
1171490 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_4                         16.0 14.0                       30.0                         16 14                 30
1171489 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_3                         21.0 13.0                       34.0                         21 13                 34
1171488 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         23.0 23.0                       46.0                         23 23                 46
1171487 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   grade_1                         32.0 10.0                       42.0                         32 10                 42
1171486 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   pk_12_total 43.0 49.0 9.0           1.0   7.0   36.0 73.0                       109.0 43 49 9           1   7   36 73                 109
1171485 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_9                         13.0 16.0                       29.0                         13 16                 29
1171484 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_12                         11.0 17.0                       28.0                         11 17                 28
1171483 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_11                         4.0 19.0                       23.0                         4 19                 23
1171482 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_10                         8.0 21.0                       29.0                         8 21                 29
1171481 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   pk_12_total 11.0 262.0 3.0               18.0   130.0 164.0                       294.0 11 262 3               18   130 164                 294
1171480 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   kindergarten                         46.0 64.0                       110.0                         46 64                 110
1171479 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   grade_3                         11.0 20.0                       31.0                         11 20                 31
1171478 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   grade_2                         30.0 33.0                       63.0                         30 33                 63
1171477 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   grade_1                         43.0 47.0                       90.0                         43 47                 90
1171476 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   pk_12_total 113.0 37.0 4.0               9.0   130.0 33.0                       163.0 113 37 4               9   130 33                 163
1171475 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1171474 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         22.0 4.0                       26.0                         22 4                 26
1171473 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_8                         9.0 3.0                       12.0                         9 3                 12
1171472 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         12.0 1.0                       13.0                         12 1                 13
1171471 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_6                         10.0 3.0                       13.0                         10 3                 13
1171470 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_5                         6.0 0.0                       6.0                         6 0                 6
1171469 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_4                         9.0 1.0                       10.0                         9 1                 10
1171468 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_3                         6.0 0.0                       6.0                         6 0                 6
1171467 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         6.0 0.0                       6.0                         6 0                 6
1171466 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         16.0 2.0                       18.0                         16 2                 18
1171465 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         16.0 7.0                       23.0                         16 7                 23
1171464 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_10                         13.0 10.0                       23.0                         13 10                 23
1171463 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_1                         5.0 1.0                       6.0                         5 1                 6
1171462 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   pk_12_total 213.0 829.0 199.0 7.0   65.0     2.0   33.0   452.0 896.0                       1348.0 213 829 199 7   65     2   33   452 896                 1348
1171461 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_9                         73.0 117.0                       190.0                         73 117                 190
1171460 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_12                         80.0 140.0                       220.0                         80 140                 220
1171459 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_11                         118.0 250.0                       368.0                         118 250                 368
1171458 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_10                         118.0 266.0                       384.0                         118 266                 384
1171457 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   adult                         63.0 123.0                       186.0                         63 123                 186
1171456 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   pk_12_total 2822.0 166.0 200.0 6.0   49.0     3.0   166.0   1507.0 1905.0                       3412.0 2822 166 200 6   49     3   166   1507 1905                 3412
1171455 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         42.0 42.0                       84.0                         42 42                 84
1171454 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         258.0 322.0                       580.0                         258 322                 580
1171453 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_8                         153.0 195.0                       348.0                         153 195                 348
1171452 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         146.0 120.0                       266.0                         146 120                 266
1171451 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_6                         96.0 87.0                       183.0                         96 87                 183
1171450 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_5                         71.0 73.0                       144.0                         71 73                 144
1171449 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_4                         75.0 63.0                       138.0                         75 63                 138
1171448 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_3                         58.0 54.0                       112.0                         58 54                 112
1171447 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         36.0 39.0                       75.0                         36 39                 75
1171446 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         162.0 294.0                       456.0                         162 294                 456
1171445 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         168.0 272.0                       440.0                         168 272                 440
1171444 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_10                         191.0 303.0                       494.0                         191 303                 494
1171443 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_1                         51.0 41.0                       92.0                         51 41                 92
1171442 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   pk_12_total 58.0 572.0 66.0 2.0   4.0         58.0   360.0 400.0                       760.0 58 572 66 2   4         58   360 400                 760
1171441 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   kindergarten                         30.0 46.0                       76.0                         30 46                 76
1171440 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_9                         33.0 36.0                       69.0                         33 36                 69
1171439 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_8                         26.0 32.0                       58.0                         26 32                 58
1171438 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_7                         23.0 25.0                       48.0                         23 25                 48
1171437 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_6                         28.0 24.0                       52.0                         28 24                 52
1171436 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_5                         26.0 24.0                       50.0                         26 24                 50
1171435 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_4                         33.0 40.0                       73.0                         33 40                 73
1171434 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_3                         39.0 43.0                       82.0                         39 43                 82
1171433 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_2                         34.0 35.0                       69.0                         34 35                 69
1171432 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_12                         18.0 10.0                       28.0                         18 10                 28
1171431 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_11                         8.0 16.0                       24.0                         8 16                 24
1171430 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_10                         26.0 28.0                       54.0                         26 28                 54
1171429 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_1                         36.0 41.0                       77.0                         36 41                 77
1171428 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   pk_12_total 315.0 87.0 20.0               29.0   195.0 256.0                       451.0 315 87 20               29   195 256                 451
1171427 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_9                         31.0 33.0                       64.0                         31 33                 64
1171426 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_8                         22.0 18.0                       40.0                         22 18                 40
1171425 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_7                         21.0 16.0                       37.0                         21 16                 37
1171424 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_6                         10.0 8.0                       18.0                         10 8                 18
1171423 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_12                         46.0 73.0                       119.0                         46 73                 119
1171422 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_11                         31.0 68.0                       99.0                         31 68                 99
1171421 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_10                         34.0 40.0                       74.0                         34 40                 74
1171420 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   pk_12_total 5.0 181.0 5.0               7.0   87.0 111.0                       198.0 5 181 5               7   87 111                 198
1171419 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_9                         45.0 77.0                       122.0                         45 77                 122
1171418 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_12                         14.0 14.0                       28.0                         14 14                 28
1171417 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_11                         15.0 12.0                       27.0                         15 12                 27
1171416 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_10                         13.0 8.0                       21.0                         13 8                 21
1171415 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   pk_12_total 251.0 147.0 54.0 3.0   5.0         49.0   291.0 218.0                       509.0 251 147 54 3   5         49   291 218                 509
1171414 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_9                         44.0 46.0                       90.0                         44 46                 90
1171413 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_8                         35.0 25.0                       60.0                         35 25                 60
1171412 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_7                         39.0 31.0                       70.0                         39 31                 70
1171411 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_6                         23.0 23.0                       46.0                         23 23                 46
1171410 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_5                         45.0 27.0                       72.0                         45 27                 72
1171409 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_12                         19.0 22.0                       41.0                         19 22                 41
1171408 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_11                         42.0 22.0                       64.0                         42 22                 64
1171407 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_10                         44.0 22.0                       66.0                         44 22                 66
1171406 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   pk_12_total 388.0 70.0 14.0     4.0     1.0   27.0   260.0 244.0                       504.0 388 70 14     4     1   27   260 244                 504

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