Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by school

View and edit SQL

grade

year

  • 2021 · 12,002
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
1930489 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_1                         51.0 49.0                       100.0                         51 49                 100
1930490 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_10                         58.0 35.0                       93.0                         58 35                 93
1930491 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_11                         40.0 62.0                       102.0                         40 62                 102
1930492 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_12                         28.0 34.0                       62.0                         28 34                 62
1930493 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_2                         37.0 50.0                       87.0                         37 50                 87
1930494 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_3                         49.0 40.0                       89.0                         49 40                 89
1930495 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_4                         50.0 47.0                       97.0                         50 47                 97
1930496 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_5                         49.0 38.0                       87.0                         49 38                 87
1930497 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_6                         47.0 52.0                       99.0                         47 52                 99
1930498 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_7                         51.0 51.0                       102.0                         51 51                 102
1930499 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_8                         49.0 55.0                       104.0                         49 55                 104
1930500 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_9                         68.0 72.0                       140.0                         68 72                 140
1930501 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   kindergarten                         48.0 54.0                       102.0                         48 54                 102
1930502 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   pk_12_total 2.0 1185.0 48.0               29.0   625.0 639.0     2.0         1077.0   167.0   1264.0 2 1185 48               29   625 639     2     1077 167   1264
1930901 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1930902 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_2                         15.0 15.0                       30.0                         15 15                 30
1930903 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_3                         12.0 20.0                       32.0                         12 20                 32
1930904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_4                         8.0 9.0                       17.0                         8 9                 17
1930905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_5                         6.0 4.0                       10.0                         6 4                 10
1930906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   kindergarten                         18.0 10.0                       28.0                         18 10                 28
1930907 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   pk_12_total 14.0 119.0 10.0               18.0   80.0 81.0     6.0         91.0   23.0   161.0 14 119 10               18   80 81     6     91 23   161
1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1919007 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_2                         36.0 29.0                       65.0                         36 29                 65
1919008 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_3                         52.0 32.0                       84.0                         52 32                 84
1919009 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 39.0                       91.0                         52 39                 91
1919010 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 43.0                       100.0                         57 43                 100
1919011 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         22.0 20.0                       42.0                         22 20                 42
1919012 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 359.0 10.0 20.0 4.0   20.0         24.0   243.0 194.0     3.0         81.0   26.0   437.0 359 10 20 4   20         24   243 194     3     81 26   437
1924091 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_1                         25.0 27.0                       52.0                         25 27                 52
1924092 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_2                         24.0 34.0                       58.0                         24 34                 58
1924093 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_3                         25.0 17.0                       42.0                         25 17                 42
1924094 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_4                         25.0 20.0                       45.0                         25 20                 45
1924095 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_5                         31.0 20.0                       51.0                         31 20                 51
1924096 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_6                         30.0 13.0                       43.0                         30 13                 43
1924097 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         27.0 21.0                       48.0                         27 21                 48
1924098 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   pk_12_total 7.0 259.0 64.0 1.0             8.0   187.0 152.0     20.0         303.0   81.0   339.0 7 259 64 1             8   187 152     20     303 81   339
1924307 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_1                         29.0 32.0                       61.0                         29 32                 61
1924308 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_2                         42.0 43.0                       85.0                         42 43                 85
1924309 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_3                         37.0 46.0                       83.0                         37 46                 83
1924310 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_4                         38.0 47.0                       85.0                         38 47                 85
1924311 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_5                         43.0 49.0                       92.0                         43 49                 92
1924312 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         41.0 33.0                       74.0                         41 33                 74
1924313 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 65.0 76.0 341.0     2.0         22.0   242.0 264.0     115.0         439.0   65.0   506.0 65 76 341     2         22   242 264     115     439 65   506
1924314 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1925175 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_1                         84.0 76.0                       160.0                         84 76                 160
1925176 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_2                         64.0 73.0                       137.0                         64 73                 137
1925177 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_3                         77.0 66.0                       143.0                         77 66                 143
1925178 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_4                         57.0 80.0                       137.0                         57 80                 137
1925179 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_5                         90.0 75.0                       165.0                         90 75                 165
1925180 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         84.0 74.0                       158.0                         84 74                 158
1925181 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 277.0 116.0 120.0     354.0         60.0   471.0 456.0     353.0         762.0   164.0   927.0 277 116 120     354         60   471 456     353     762 164   927
1925182 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         15.0 12.0                       27.0                         15 12                 27
1928992 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_10                         56.0 18.0                       74.0                         56 18                 74
1928993 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_11                         56.0 17.0                       73.0                         56 17                 73
1928994 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_12                         49.0 41.0                       90.0                         49 41                 90
1928995 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1928996 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_3                         7.0 1.0                       8.0                         7 1                 8
1928997 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_4                         9.0 2.0                       11.0                         9 2                 11
1928998 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_5                         10.0 0.0                       10.0                         10 0                 10
1928999 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_6                         6.0 2.0                       8.0                         6 2                 8
1929000 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_7                         24.0 8.0                       32.0                         24 8                 32
1929001 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_8                         20.0 9.0                       29.0                         20 9                 29
1929002 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_9                         15.0 6.0                       21.0                         15 6                 21
1929003 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1929004 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   pk_12_total 170.0 133.0 11.0 2.0             47.0   259.0 104.0     2.0         266.0   171.0   363.0 170 133 11 2             47   259 104     2     266 171   363
1925571 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_10                         18.0 27.0                       45.0                         18 27                 45
1925572 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_11                         29.0 41.0                       70.0                         29 41                 70
1925573 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_12                         92.0 108.0                       200.0                         92 108                 200
1925574 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_9                         15.0 8.0                       23.0                         15 8                 23
1925575 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   pk_12_total 218.0 69.0 32.0     2.0         17.0   154.0 184.0     5.0         37.0   30.0   338.0 218 69 32     2         17   154 184     5     37 30   338
1924994 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   grade_1                         64.0 52.0                       116.0                         64 52                 116
1924995 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   grade_2                         75.0 72.0                       147.0                         75 72                 147
1924996 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   grade_3                         68.0 74.0                       142.0                         68 74                 142
1924997 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   kindergarten                         67.0 58.0                       125.0                         67 58                 125
1924998 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   pk_12_total 372.0 48.0 30.0 1.0   26.0     1.0   52.0   274.0 256.0     30.0         214.0   64.0   530.0 372 48 30 1   26     1   52   274 256     30     214 64   530
1918957 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 47.0                       95.0                         48 47                 95
1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1918959 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_3                         53.0 65.0                       118.0                         53 65                 118
1918960 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_4                         58.0 41.0                       99.0                         58 41                 99
1918961 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_5                         58.0 48.0                       106.0                         58 48                 106
1918962 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         46.0 37.0                       83.0                         46 37                 83
1918963 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 603.0 4.0 34.0 1.0   1.0         18.0   352.0 309.0     19.0         154.0   110.0   661.0 603 4 34 1   1         18   352 309     19     154 110   661
1918964 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         33.0 28.0                       61.0                         33 28                 61
1918965 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1918966 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_10                         49.0 32.0                       81.0                         49 32                 81
1918967 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_11                         39.0 43.0                       82.0                         39 43                 82
1918968 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_12                         50.0 54.0                       104.0                         50 54                 104
1918969 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_9                         53.0 48.0                       101.0                         53 48                 101
1918970 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   pk_12_total 351.0 2.0 13.0 1.0   1.0         2.0   192.0 178.0     4.0         79.0   23.0   370.0 351 2 13 1   1         2   192 178     4     79 23   370
1918953 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_6                         53.0 45.0                       98.0                         53 45                 98
1918954 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 43.0                       107.0                         64 43                 107
1918955 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_8                         54.0 53.0                       107.0                         54 53                 107
1918956 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   pk_12_total 288.0 2.0 11.0     3.0         8.0   171.0 141.0     3.0         81.0   33.0   312.0 288 2 11     3         8   171 141     3     81 33   312
1919213 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1919214 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2                         17.0 26.0                       43.0                         17 26                 43
1919215 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_3                         21.0 20.0                       41.0                         21 20                 41
1919216 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4                         25.0 27.0                       52.0                         25 27                 52
1919217 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_5                         19.0 23.0                       42.0                         19 23                 42
1919218 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1919219 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 43.0 80.0 119.0     13.0         30.0   138.0 147.0     86.0         245.0   35.0   285.0 43 80 119     13         30   138 147     86     245 35   285

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