enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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
1171075 1171075 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_6                         12.0 14.0                       26.0                         12 14                 26
1292452 1292452 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_6                         8.0 17.0                       25.0                         8 17                 25
1304485 1304485 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_6                         8.0 7.0                       15.0                         8 7                 15
1763097 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
1798827 1798827 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_6                         10.0 13.0                       23.0                         10 13                 23
1918566 1918566 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_6                         11.0 10.0                       21.0                         11 10                 21
1930562 1930562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_6                         8.0 8.0                       16.0                         8 8                 16
1171060 1171060 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_6                         0.0 3.0                       3.0                         0 3                 3
1292437 1292437 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_6                         4.0 4.0                       8.0                         4 4                 8
1304470 1304470 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_6                         7.0 2.0                       9.0                         7 2                 9
1763082 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
1798812 1798812 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 2018   grade_6                         2.0 4.0                       6.0                         2 4                 6
1918551 1918551 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 2020   grade_6                         6.0 3.0                       9.0                         6 3                 9
1930546 1930546 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 2021   grade_6                         3.0 3.0                       6.0                         3 3                 6
1930222 1930222 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_6                         19.0 17.0                       36.0                         19 17                 36
1930089 1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930073 1930073 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_6                         32.0 30.0                       62.0                         32 30                 62
1930023 1930023 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_6                         11.0 8.0                       19.0                         11 8                 19
1930315 1930315 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_6                         4.0 1.0                       5.0                         4 1                 5
1170658 1170658 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_6                         45.0 36.0                       81.0                         45 36                 81
1292047 1292047 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_6                         59.0 35.0                       94.0                         59 35                 94
1304070 1304070 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No Other 06 12 2017   grade_6                         45.0 49.0                       94.0                         45 49                 94
1762612 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
1798393 1798393 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2018   grade_6                         48.0 50.0                       98.0                         48 50                 98
1918031 1918031 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   grade_6                         50.0 50.0                       100.0                         50 50                 100
1929958 1929958 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         41.0 56.0                       97.0                         41 56                 97
1170685 1170685 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle Sch   Regular School No 2.0 06 08 2015   grade_6                         151.0 127.0                       278.0                         151 127                 278
1292074 1292074 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle School   Regular School No 2.0 06 08 2016   grade_6                         148.0 131.0                       279.0                         148 131                 279
1304096 1304096 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2017   grade_6                         136.0 109.0                       245.0                         136 109                 245
1762639 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
1798420 1798420 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2018   grade_6                         135.0 117.0                       252.0                         135 117                 252
1918063 1918063 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2020   grade_6                         148.0 144.0                       292.0                         148 144                 292
1929993 1929993 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2021   grade_6                         165.0 114.0                       279.0                         165 114                 279
1756313 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
1911770 1911770 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_6                         25.0 27.0                       52.0                         25 27                 52
1923738 1923738 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_6                         20.0 16.0                       36.0                         20 16                 36
1170638 1170638 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle Sch   Regular School No 2.0 06 08 2015   grade_6                         102.0 100.0                       202.0                         102 100                 202
1292027 1292027 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No 2.0 06 08 2016   grade_6                         88.0 75.0                       163.0                         88 75                 163
1304049 1304049 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_6                         94.0 80.0                       174.0                         94 80                 174
1762591 1762591 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_6                         90.0 78.0                       168.0                         90 78                 168
1798372 1798372 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_6                         105.0 84.0                       189.0                         105 84                 189
1918010 1918010 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_6                         101.0 85.0                       186.0                         101 85                 186
1929937 1929937 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_6                         99.0 84.0                       183.0                         99 84                 183
1170624 1170624 IN     school 1811430 8535   Tri-County School Corp 181143001845 9143 Tri-County Intermediate School   Regular School No 1.0 03 06 2015   grade_6                         31.0 20.0                       51.0                         31 20                 51
1292013 1292013 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No 1.0 03 06 2016   grade_6                         26.0 28.0                       54.0                         26 28                 54
1304035 1304035 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2017   grade_6                         30.0 25.0                       55.0                         30 25                 55
1762577 1762577 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2019   grade_6                         28.0 26.0                       54.0                         28 26                 54
1798358 1798358 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         27.0 21.0                       48.0                         27 21                 48
1917996 1917996 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2020   grade_6                         29.0 25.0                       54.0                         29 25                 54
1929922 1929922 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         22.0 26.0                       48.0                         22 26                 48
1762569 1762569 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2019   grade_6                         0.0 1.0                       1.0                         0 1                 1
1929914 1929914 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2021   grade_6                         2.0 0.0                       2.0                         2 0                 2
1170585 1170585 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Intermediate   Regular School No 2.0 04 06 2015   grade_6                         23.0 29.0                       52.0                         23 29                 52
1291974 1291974 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Intermediate   Regular School No 2.0 04 06 2016   grade_6                         33.0 25.0                       58.0                         33 25                 58
1303996 1303996 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2017   grade_6                         36.0 26.0                       62.0                         36 26                 62
1762535 1762535 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2019   grade_6                         36.0 36.0                       72.0                         36 36                 72
1798318 1798318 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2018   grade_6                         38.0 28.0                       66.0                         38 28                 66
1917955 1917955 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2020   grade_6                         31.0 37.0                       68.0                         31 37                 68
1929881 1929881 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2021   grade_6                         34.0 27.0                       61.0                         34 27                 61
1170599 1170599 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No 1.0 KG 06 2015   grade_6                         32.0 29.0                       61.0                         32 29                 61
1291988 1291988 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No 1.0 KG 06 2016   grade_6                         27.0 29.0                       56.0                         27 29                 56
1304010 1304010 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2017   grade_6                         18.0 24.0                       42.0                         18 24                 42
1762550 1762550 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2019   grade_6                         17.0 27.0                       44.0                         17 27                 44
1798332 1798332 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2018   grade_6                         19.0 34.0                       53.0                         19 34                 53
1917969 1917969 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2020   grade_6                         24.0 26.0                       50.0                         24 26                 50
1929895 1929895 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2021   grade_6                         28.0 18.0                       46.0                         28 18                 46
1762762 1762762 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2019   grade_6                         21.0 21.0                       42.0                         21 21                 42
1918221 1918221 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2020   grade_6                         19.0 22.0                       41.0                         19 22                 41
1930175 1930175 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2021   grade_6                         19.0 11.0                       30.0                         19 11                 30
1170567 1170567 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2015   grade_6                         54.0 59.0                       113.0                         54 59                 113
1291956 1291956 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2016   grade_6                         69.0 68.0                       137.0                         69 68                 137
1303979 1303979 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2017   grade_6                         57.0 60.0                       117.0                         57 60                 117
1762518 1762518 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2019   grade_6                         54.0 55.0                       109.0                         54 55                 109
1798301 1798301 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 64.0                       128.0                         64 64                 128
1917938 1917938 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2020   grade_6                         70.0 50.0                       120.0                         70 50                 120
1929864 1929864 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2021   grade_6                         89.0 66.0                       155.0                         89 66                 155
1170557 1170557 IN     school 1808220 8435   Northern Wells Com Schools 180822002159 9088 Norwell Middle School   Regular School No 2.0 06 08 2015   grade_6                         91.0 95.0                       186.0                         91 95                 186
1291946 1291946 IN     school 1808220 8435   Northern Wells Com Schools 180822002159 9088 Norwell Middle School   Regular School No 2.0 06 08 2016   grade_6                         101.0 84.0                       185.0                         101 84                 185
1303969 1303969 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2017   grade_6                         107.0 98.0                       205.0                         107 98                 205
1762508 1762508 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2019   grade_6                         92.0 70.0                       162.0                         92 70                 162
1798291 1798291 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2018   grade_6                         93.0 108.0                       201.0                         93 108                 201
1917927 1917927 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2020   grade_6                         84.0 109.0                       193.0                         84 109                 193
1929854 1929854 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2021   grade_6                         89.0 89.0                       178.0                         89 89                 178
1170527 1170527 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elem Sch   Regular School No 1.0 KG 06 2015   grade_6                         32.0 29.0                       61.0                         32 29                 61
1291914 1291914 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elem Sch   Regular School No 1.0 PK 06 2016   grade_6                         29.0 33.0                       62.0                         29 33                 62
1303938 1303938 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elementary School   Regular School No Elementary KG 06 2017   grade_6                         24.0 38.0                       62.0                         24 38                 62
1762477 1762477 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elementary School   Regular School No Elementary KG 06 2019   grade_6                         40.0 33.0                       73.0                         40 33                 73
1798261 1798261 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elementary School   Regular School No Elementary KG 06 2018   grade_6                         43.0 32.0                       75.0                         43 32                 75
1917897 1917897 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elementary School   Regular School No Elementary KG 06 2020   grade_6                         38.0 34.0                       72.0                         38 34                 72
1929824 1929824 IN     school 1810770 8425   Southern Wells Com Schools 181077001764 9057 Southern Wells Elementary School   Regular School No Elementary KG 06 2021   grade_6                         30.0 37.0                       67.0                         30 37                 67
1170516 1170516 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_6                         4.0 0.0                       4.0                         4 0                 4
1291903 1291903 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_6                         2.0 0.0                       2.0                         2 0                 2
1303928 1303928 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_6                         4.0 0.0                       4.0                         4 0                 4
1762466 1762466 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_6                         11.0 1.0                       12.0                         11 1                 12
1798250 1798250 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1917886 1917886 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_6                         10.0 0.0                       10.0                         10 0                 10
1929814 1929814 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_6                         10.0 1.0                       11.0                         10 1                 11
1170462 1170462 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2015   grade_6                         91.0 77.0                       168.0                         91 77                 168
1291849 1291849 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2016   grade_6                         78.0 84.0                       162.0                         78 84                 162
1303874 1303874 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2017   grade_6                         98.0 84.0                       182.0                         98 84                 182

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