Data source: Big Local News · About: Big Local

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

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
1763089 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_1                         5.0 18.0                       23.0                         5 18                 23
1763090 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_10                         16.0 18.0                       34.0                         16 18                 34
1763091 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_11                         10.0 12.0                       22.0                         10 12                 22
1763092 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_12                         24.0 18.0                       42.0                         24 18                 42
1763093 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_2                         14.0 7.0                       21.0                         14 7                 21
1763094 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_3                         10.0 10.0                       20.0                         10 10                 20
1763095 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_4                         9.0 6.0                       15.0                         9 6                 15
1763096 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_5                         10.0 8.0                       18.0                         10 8                 18
1763097 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_6                         5.0 9.0                       14.0                         5 9                 14
1763098 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_7                         13.0 15.0                       28.0                         13 15                 28
1763099 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_8                         12.0 11.0                       23.0                         12 11                 23
1763100 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_9                         9.0 14.0                       23.0                         9 14                 23
1763101 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   kindergarten                         9.0 8.0                       17.0                         9 8                 17
1763102 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   pk_12_total 214.0 42.0 38.0     13.0     1.0   18.0   158.0 168.0     8.0         326.0   310.0   326.0 214 42 38     13     1   18   158 168     8     326 310   326
1763103 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1763073 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   adult                         15.0 13.0                       28.0                         15 13                 28
1763074 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_1                         4.0 2.0                       6.0                         4 2                 6
1763075 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_10                         1.0 4.0                       5.0                         1 4                 5
1763076 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_11                         8.0 6.0                       14.0                         8 6                 14
1763077 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_12                         7.0 1.0                       8.0                         7 1                 8
1763078 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_2                         7.0 0.0                       7.0                         7 0                 7
1763079 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_3                         1.0 2.0                       3.0                         1 2                 3
1763080 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_4                         5.0 2.0                       7.0                         5 2                 7
1763081 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_5                         5.0 2.0                       7.0                         5 2                 7
1763082 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_6                         3.0 3.0                       6.0                         3 3                 6
1763083 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_7                         3.0 5.0                       8.0                         3 5                 8
1763084 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_8                         10.0 2.0                       12.0                         10 2                 12
1763085 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_9                         3.0 2.0                       5.0                         3 2                 5
1763086 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   kindergarten                         1.0 3.0                       4.0                         1 3                 4
1763087 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   pk_12_total 72.0 27.0 13.0     3.0         10.0   73.0 52.0     6.0         101.0   115.0   125.0 72 27 13     3         10   73 52     6     101 115   125
1763088 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   pre_kindergarten                         0.0 5.0                       5.0                         0 5                 5
1762617 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_1                         45.0 33.0                       78.0                         45 33                 78
1762618 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_2                         48.0 41.0                       89.0                         48 41                 89
1762619 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_3                         40.0 41.0                       81.0                         40 41                 81
1762620 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_4                         41.0 50.0                       91.0                         41 50                 91
1762621 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_5                         48.0 49.0                       97.0                         48 49                 97
1762622 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         39.0 44.0                       83.0                         39 44                 83
1762623 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 502.0   5.0 1.0   1.0         27.0   270.0 266.0     0.0         181.0   84.0   536.0 502   5 1   1         27   270 266     0     181 84   536
1762624 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1762656 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_1                         15.0 22.0                       37.0                         15 22                 37
1762657 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_2                         8.0 21.0                       29.0                         8 21                 29
1762658 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_3                         22.0 26.0                       48.0                         22 26                 48
1762659 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_4                         14.0 22.0                       36.0                         14 22                 36
1762660 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_5                         21.0 18.0                       39.0                         21 18                 39
1762661 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         28.0 23.0                       51.0                         28 23                 51
1762662 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 302.0   20.0 3.0             11.0   163.0 173.0     1.0         161.0   92.0   336.0 302   20 3             11   163 173     1     161 92   336
1762663 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         55.0 41.0                       96.0                         55 41                 96
1762608 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   adult                         6.0 0.0                       6.0                         6 0                 6
1762609 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_10                         48.0 38.0                       86.0                         48 38                 86
1762610 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_11                         46.0 48.0                       94.0                         46 48                 94
1762611 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_12                         48.0 33.0                       81.0                         48 33                 81
1762612 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_6                         45.0 51.0                       96.0                         45 51                 96
1762613 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_7                         51.0 50.0                       101.0                         51 50                 101
1762614 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_8                         38.0 51.0                       89.0                         38 51                 89
1762615 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_9                         51.0 38.0                       89.0                         51 38                 89
1762616 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   pk_12_total 609.0   13.0     5.0         15.0   333.0 309.0     0.0         164.0   96.0   642.0 609   13     5         15   333 309     0     164 96   642
1756316 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_10                         56.0 41.0                       97.0                         56 41                 97
1756317 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_11                         53.0 51.0                       104.0                         53 51                 104
1756318 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_12                         61.0 56.0                       117.0                         61 56                 117
1756319 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_7                         58.0 50.0                       108.0                         58 50                 108
1756320 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_8                         49.0 58.0                       107.0                         49 58                 107
1756321 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_9                         66.0 54.0                       120.0                         66 54                 120
1756322 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   pk_12_total 606.0 6.0 28.0 1.0   8.0         4.0   343.0 310.0     8.0         250.0   126.0   653.0 606 6 28 1   8         4   343 310     8     250 126   653
1762650 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   adult                         3.0 2.0                       5.0                         3 2                 5
1762651 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   grade_10                         158.0 125.0                       283.0                         158 125                 283
1762652 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   grade_11                         137.0 143.0                       280.0                         137 143                 280
1762653 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   grade_12                         134.0 114.0                       248.0                         134 114                 248
1762654 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   grade_9                         149.0 142.0                       291.0                         149 142                 291
1762655 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2019   pk_12_total 1020.0 8.0 34.0 5.0   13.0         27.0   581.0 526.0     11.0         272.0   151.0   1107.0 1020 8 34 5   13         27   581 526     11     272 151   1107
1762643 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_1                         36.0 42.0                       78.0                         36 42                 78
1762644 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_2                         42.0 30.0                       72.0                         42 30                 72
1762645 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_3                         47.0 35.0                       82.0                         47 35                 82
1762646 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_4                         55.0 34.0                       89.0                         55 34                 89
1762647 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 46.0                       98.0                         52 46                 98
1762648 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         36.0 43.0                       79.0                         36 43                 79
1762649 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 456.0 3.0 15.0 1.0   3.0         20.0   268.0 230.0     0.0         159.0   73.0   498.0 456 3 15 1   3         20   268 230     0     159 73   498
1762639 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2019   grade_6                         158.0 134.0                       292.0                         158 134                 292
1762640 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2019   grade_7                         136.0 120.0                       256.0                         136 120                 256
1762641 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2019   grade_8                         139.0 117.0                       256.0                         139 117                 256
1762642 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2019   pk_12_total 728.0 4.0 27.0 3.0   3.0         39.0   433.0 371.0     7.0         244.0   152.0   804.0 728 4 27 3   3         39   433 371     7     244 152   804
1762632 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_1                         23.0 24.0                       47.0                         23 24                 47
1762633 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_2                         24.0 26.0                       50.0                         24 26                 50
1762634 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_3                         24.0 33.0                       57.0                         24 33                 57
1762635 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_4                         39.0 17.0                       56.0                         39 17                 56
1762636 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_5                         25.0 29.0                       54.0                         25 29                 54
1762637 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   kindergarten                         24.0 18.0                       42.0                         24 18                 42
1762638 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   pk_12_total 275.0 1.0 16.0 3.0   2.0         9.0   159.0 147.0     12.0         77.0   68.0   306.0 275 1 16 3   2         9   159 147     12     77 68   306
1762625 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_1                         37.0 44.0                       81.0                         37 44                 81
1762626 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_2                         45.0 40.0                       85.0                         45 40                 85
1762627 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_3                         49.0 48.0                       97.0                         49 48                 97
1762628 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_4                         51.0 44.0                       95.0                         51 44                 95
1762629 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_5                         47.0 54.0                       101.0                         47 54                 101
1762630 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 44.0                       99.0                         55 44                 99
1762631 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 509.0 6.0 23.0 2.0   4.0         14.0   284.0 274.0     5.0         191.0   105.0   558.0 509 6 23 2   4         14   284 274     5     191 105   558
1756308 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_1                         19.0 28.0                       47.0                         19 28                 47
1756309 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_2                         16.0 27.0                       43.0                         16 27                 43
1756310 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_3                         26.0 15.0                       41.0                         26 15                 41
1756311 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_4                         21.0 16.0                       37.0                         21 16                 37
1756312 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_5                         27.0 29.0                       56.0                         27 29                 56
1756313 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_6                         25.0 25.0                       50.0                         25 25                 50

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