Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by school

View and edit SQL

grade

year

  • 2019 · 11,992
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
1763025 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_1                         45.0 30.0                       75.0                         45 30                 75
1763026 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_10                         39.0 29.0                       68.0                         39 29                 68
1763027 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_11                         35.0 18.0                       53.0                         35 18                 53
1763028 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_12                         22.0 44.0                       66.0                         22 44                 66
1763029 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_2                         32.0 41.0                       73.0                         32 41                 73
1763030 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_3                         37.0 39.0                       76.0                         37 39                 76
1763031 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_4                         36.0 33.0                       69.0                         36 33                 69
1763032 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_5                         25.0 30.0                       55.0                         25 30                 55
1763033 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_6                         27.0 30.0                       57.0                         27 30                 57
1763034 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_7                         47.0 29.0                       76.0                         47 29                 76
1763035 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_8                         38.0 35.0                       73.0                         38 35                 73
1763036 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_9                         33.0 41.0                       74.0                         33 41                 74
1763037 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   kindergarten                         31.0 37.0                       68.0                         31 37                 68
1763038 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   pk_12_total   838.0 23.0               22.0   447.0 436.0     0.0         737.0   114.0   883.0   838 23               22   447 436     0     737 114   883
1763494 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_1                         15.0 19.0                       34.0                         15 19                 34
1763495 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_2                         9.0 8.0                       17.0                         9 8                 17
1763496 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_3                         6.0 8.0                       14.0                         6 8                 14
1763497 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   kindergarten                         16.0 8.0                       24.0                         16 8                 24
1763498 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   pk_12_total 10.0 61.0 7.0               11.0   46.0 43.0     5.0         70.0   10.0   89.0 10 61 7               11   46 43     5     70 10   89
1751599 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 26.0                       60.0                         34 26                 60
1751600 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_2                         44.0 40.0                       84.0                         44 40                 84
1751601 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_3                         53.0 39.0                       92.0                         53 39                 92
1751602 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 45.0                       101.0                         56 45                 101
1751603 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 49.0                       93.0                         44 49                 93
1751604 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1751605 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 402.0 6.0 19.0 1.0   27.0         24.0   261.0 218.0     1.0         72.0   16.0   479.0 402 6 19 1   27         24   261 218     1     72 16   479
1756682 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_1                         22.0 17.0                       39.0                         22 17                 39
1756683 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_2                         20.0 18.0                       38.0                         20 18                 38
1756684 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_3                         32.0 20.0                       52.0                         32 20                 52
1756685 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_4                         28.0 15.0                       43.0                         28 15                 43
1756686 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_5                         20.0 21.0                       41.0                         20 21                 41
1756687 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_6                         21.0 18.0                       39.0                         21 18                 39
1756688 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         25.0 34.0                       59.0                         25 34                 59
1756689 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   pk_12_total 3.0 239.0 66.0               3.0   168.0 143.0     23.0         284.0   66.0   311.0 3 239 66               3   168 143     23     284 66   311
1756924 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_1                         41.0 44.0                       85.0                         41 44                 85
1756925 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_2                         38.0 47.0                       85.0                         38 47                 85
1756926 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_3                         46.0 48.0                       94.0                         46 48                 94
1756927 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_4                         56.0 51.0                       107.0                         56 51                 107
1756928 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_5                         62.0 39.0                       101.0                         62 39                 101
1756929 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         41.0 42.0                       83.0                         41 42                 83
1756930 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 79.0 68.0 403.0     1.0     1.0   43.0   298.0 297.0     169.0         486.0   68.0   595.0 79 68 403     1     1   43   298 297     169     486 68   595
1756931 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         14.0 26.0                       40.0                         14 26                 40
1757847 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_1                         86.0 69.0                       155.0                         86 69                 155
1757848 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_2                         61.0 76.0                       137.0                         61 76                 137
1757849 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_3                         85.0 74.0                       159.0                         85 74                 159
1757850 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_4                         77.0 75.0                       152.0                         77 75                 152
1757851 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_5                         84.0 68.0                       152.0                         84 68                 152
1757852 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         95.0 104.0                       199.0                         95 104                 199
1757853 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 360.0 94.0 139.0 1.0   336.0         63.0   506.0 487.0     378.0         810.0   161.0   993.0 360 94 139 1   336         63   506 487     378     810 161   993
1757854 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         18.0 21.0                       39.0                         18 21                 39
1761655 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_1                         3.0 1.0                       4.0                         3 1                 4
1761656 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_10                         46.0 18.0                       64.0                         46 18                 64
1761657 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_11                         37.0 25.0                       62.0                         37 25                 62
1761658 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_12                         46.0 38.0                       84.0                         46 38                 84
1761659 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1761660 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_3                         7.0 2.0                       9.0                         7 2                 9
1761661 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_4                         7.0 0.0                       7.0                         7 0                 7
1761662 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_5                         10.0 1.0                       11.0                         10 1                 11
1761663 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_6                         7.0 0.0                       7.0                         7 0                 7
1761664 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_7                         17.0 8.0                       25.0                         17 8                 25
1761665 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_8                         36.0 16.0                       52.0                         36 16                 52
1761666 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_9                         26.0 8.0                       34.0                         26 8                 34
1761667 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   pk_12_total 159.0 129.0 11.0 2.0             66.0   249.0 118.0     2.0         320.0   139.0   367.0 159 129 11 2             66   249 118     2     320 139   367
1758237 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_10                         9.0 13.0                       22.0                         9 13                 22
1758238 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_11                         24.0 26.0                       50.0                         24 26                 50
1758239 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_12                         41.0 129.0                       170.0                         41 129                 170
1758240 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_9                         5.0 10.0                       15.0                         5 10                 15
1758241 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   pk_12_total 175.0 46.0 23.0 1.0   1.0         11.0   79.0 178.0     6.0         33.0   29.0   257.0 175 46 23 1   1         11   79 178     6     33 29   257
1757663 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_1                         31.0 48.0                       79.0                         31 48                 79
1757664 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_2                         41.0 27.0                       68.0                         41 27                 68
1757665 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_3                         38.0 33.0                       71.0                         38 33                 71
1757666 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_4                         49.0 34.0                       83.0                         49 34                 83
1757667 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 25.0                       69.0                         44 25                 69
1757668 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         35.0 30.0                       65.0                         35 30                 65
1757669 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 352.0 16.0 29.0     7.0     2.0   29.0   238.0 197.0     14.0         146.0   61.0   435.0 352 16 29     7     2   29   238 197     14     146 61   435
1751550 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_1                         64.0 62.0                       126.0                         64 62                 126
1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1751552 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 43.0                       93.0                         50 43                 93
1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1751554 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_5                         64.0 41.0                       105.0                         64 41                 105
1751555 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1751556 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 574.0 6.0 31.0 1.0   2.0         17.0   347.0 284.0     24.0         171.0   95.0   631.0 574 6 31 1   2         17   347 284     24     171 95   631
1751557 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1751558 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751559 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_10                         48.0 55.0                       103.0                         48 55                 103
1751560 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_11                         40.0 52.0                       92.0                         40 52                 92
1751561 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_12                         48.0 50.0                       98.0                         48 50                 98
1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1751563 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   pk_12_total 350.0 5.0 5.0 1.0   7.0         6.0   177.0 197.0     6.0         74.0   22.0   374.0 350 5 5 1   7         6   177 197     6     74 22   374
1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1751547 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_7                         50.0 51.0                       101.0                         50 51                 101
1751548 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 30.0                       82.0                         52 30                 82
1751549 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   pk_12_total 270.0 3.0 12.0     2.0         2.0   157.0 132.0     1.0         74.0   21.0   289.0 270 3 12     2         2   157 132     1     74 21   289
1751807 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         20.0 22.0                       42.0                         20 22                 42
1751808 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2                         23.0 23.0                       46.0                         23 23                 46
1751809 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_3                         21.0 16.0                       37.0                         21 16                 37
1751810 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4                         25.0 34.0                       59.0                         25 34                 59
1751811 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_5                         28.0 16.0                       44.0                         28 16                 44
1751812 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         14.0 30.0                       44.0                         14 30                 44
1751813 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 48.0 88.0 96.0     23.0         35.0   142.0 148.0     77.0         241.0   32.0   290.0 48 88 96     23         35   142 148     77     241 32   290

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