enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,530 ✖
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
1171076 1171076 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_7                         15.0 14.0                       29.0                         15 14                 29
1292453 1292453 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_7                         11.0 14.0                       25.0                         11 14                 25
1304486 1304486 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_7                         4.0 10.0                       14.0                         4 10                 14
1763098 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
1798828 1798828 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_7                         11.0 9.0                       20.0                         11 9                 20
1918567 1918567 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_7                         4.0 6.0                       10.0                         4 6                 10
1930563 1930563 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_7                         11.0 11.0                       22.0                         11 11                 22
1171061 1171061 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_7                         10.0 8.0                       18.0                         10 8                 18
1292438 1292438 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_7                         0.0 3.0                       3.0                         0 3                 3
1304471 1304471 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_7                         3.0 3.0                       6.0                         3 3                 6
1763083 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
1798813 1798813 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_7                         10.0 2.0                       12.0                         10 2                 12
1918552 1918552 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_7                         3.0 0.0                       3.0                         3 0                 3
1930547 1930547 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_7                         4.0 4.0                       8.0                         4 4                 8
1930223 1930223 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_7                         38.0 32.0                       70.0                         38 32                 70
1930090 1930090 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_7                         3.0 2.0                       5.0                         3 2                 5
1930074 1930074 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_7                         31.0 45.0                       76.0                         31 45                 76
1930024 1930024 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_7                         3.0 5.0                       8.0                         3 5                 8
1930316 1930316 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_7                         3.0 1.0                       4.0                         3 1                 4
1170659 1170659 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         48.0 42.0                       90.0                         48 42                 90
1292048 1292048 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_7                         46.0 35.0                       81.0                         46 35                 81
1304071 1304071 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No Other 06 12 2017   grade_7                         58.0 37.0                       95.0                         58 37                 95
1762613 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
1798394 1798394 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2018   grade_7                         39.0 48.0                       87.0                         39 48                 87
1918032 1918032 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   grade_7                         45.0 48.0                       93.0                         45 48                 93
1929959 1929959 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   grade_7                         50.0 51.0                       101.0                         50 51                 101
1756319 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
1911776 1911776 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_7                         58.0 64.0                       122.0                         58 64                 122
1923744 1923744 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_7                         44.0 40.0                       84.0                         44 40                 84
1170686 1170686 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         130.0 151.0                       281.0                         130 151                 281
1292075 1292075 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle School   Regular School No 2.0 06 08 2016   grade_7                         143.0 122.0                       265.0                         143 122                 265
1304097 1304097 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2017   grade_7                         141.0 131.0                       272.0                         141 131                 272
1762640 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
1798421 1798421 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2018   grade_7                         135.0 117.0                       252.0                         135 117                 252
1918064 1918064 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2020   grade_7                         160.0 135.0                       295.0                         160 135                 295
1929994 1929994 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2021   grade_7                         152.0 139.0                       291.0                         152 139                 291
1170639 1170639 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         114.0 84.0                       198.0                         114 84                 198
1292028 1292028 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No 2.0 06 08 2016   grade_7                         99.0 103.0                       202.0                         99 103                 202
1304050 1304050 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 76.0                       171.0                         95 76                 171
1762592 1762592 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_7                         102.0 83.0                       185.0                         102 83                 185
1798373 1798373 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_7                         102.0 81.0                       183.0                         102 81                 183
1918011 1918011 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_7                         92.0 79.0                       171.0                         92 79                 171
1929938 1929938 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_7                         92.0 80.0                       172.0                         92 80                 172
1170617 1170617 IN     school 1811430 8535   Tri-County School Corp 181143001846 9141 Tri-County Middle-Senior High   Regular School No 3.0 07 12 2015   grade_7                         35.0 24.0                       59.0                         35 24                 59
1292006 1292006 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Middle-Senior High   Regular School No 3.0 07 12 2016   grade_7                         31.0 23.0                       54.0                         31 23                 54
1304028 1304028 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Middle-Senior High   Regular School No High 07 12 2017   grade_7                         23.0 29.0                       52.0                         23 29                 52
1762570 1762570 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2019   grade_7                         31.0 23.0                       54.0                         31 23                 54
1798351 1798351 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 07 12 2018   grade_7                         33.0 23.0                       56.0                         33 23                 56
1917989 1917989 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 07 12 2020   grade_7                         35.0 29.0                       64.0                         35 29                 64
1929915 1929915 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2021   grade_7                         33.0 27.0                       60.0                         33 27                 60
1170606 1170606 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         35.0 28.0                       63.0                         35 28                 63
1291995 1291995 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         29.0 29.0                       58.0                         29 29                 58
1304017 1304017 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         26.0 25.0                       51.0                         26 25                 51
1762557 1762557 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         19.0 31.0                       50.0                         19 31                 50
1798340 1798340 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2018   grade_7                         17.0 26.0                       43.0                         17 26                 43
1917977 1917977 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         18.0 30.0                       48.0                         18 30                 48
1929902 1929902 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         26.0 24.0                       50.0                         26 24                 50
1170590 1170590 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_7                         43.0 32.0                       75.0                         43 32                 75
1291979 1291979 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_7                         23.0 29.0                       52.0                         23 29                 52
1303997 1303997 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2017   grade_7                         33.0 28.0                       61.0                         33 28                 61
1762536 1762536 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2019   grade_7                         36.0 30.0                       66.0                         36 30                 66
1798319 1798319 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2018   grade_7                         40.0 23.0                       63.0                         40 23                 63
1917956 1917956 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2020   grade_7                         34.0 37.0                       71.0                         34 37                 71
1929882 1929882 IN     school 1808130 8515   North White School Corp 180813002522 9122 North White Middle School   Regular School No Middle 06 08 2021   grade_7                         28.0 31.0                       59.0                         28 31                 59
1762763 1762763 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2019   grade_7                         18.0 13.0                       31.0                         18 13                 31
1918222 1918222 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2020   grade_7                         19.0 17.0                       36.0                         19 17                 36
1930176 1930176 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2021   grade_7                         20.0 27.0                       47.0                         20 27                 47
1170568 1170568 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         53.0 59.0                       112.0                         53 59                 112
1291957 1291957 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2016   grade_7                         58.0 57.0                       115.0                         58 57                 115
1303980 1303980 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2017   grade_7                         75.0 64.0                       139.0                         75 64                 139
1762519 1762519 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2019   grade_7                         68.0 59.0                       127.0                         68 59                 127
1798302 1798302 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2018   grade_7                         51.0 59.0                       110.0                         51 59                 110
1917939 1917939 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2020   grade_7                         56.0 55.0                       111.0                         56 55                 111
1929865 1929865 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2021   grade_7                         70.0 50.0                       120.0                         70 50                 120
1170558 1170558 IN     school 1808220 8435   Northern Wells Com Schools 180822002159 9088 Norwell Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 89.0                       193.0                         104 89                 193
1291947 1291947 IN     school 1808220 8435   Northern Wells Com Schools 180822002159 9088 Norwell Middle School   Regular School No 2.0 06 08 2016   grade_7                         93.0 97.0                       190.0                         93 97                 190
1303970 1303970 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2017   grade_7                         105.0 88.0                       193.0                         105 88                 193
1762509 1762509 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2019   grade_7                         98.0 108.0                       206.0                         98 108                 206
1798292 1798292 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2018   grade_7                         105.0 101.0                       206.0                         105 101                 206
1917928 1917928 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2020   grade_7                         97.0 74.0                       171.0                         97 74                 171
1929855 1929855 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2021   grade_7                         86.0 109.0                       195.0                         86 109                 195
1170533 1170533 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         35.0 22.0                       57.0                         35 22                 57
1291921 1291921 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_7                         33.0 30.0                       63.0                         33 30                 63
1303944 1303944 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         31.0 37.0                       68.0                         31 37                 68
1762483 1762483 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         44.0 32.0                       76.0                         44 32                 76
1798267 1798267 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2018   grade_7                         26.0 42.0                       68.0                         26 42                 68
1917903 1917903 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         40.0 31.0                       71.0                         40 31                 71
1929830 1929830 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         36.0 35.0                       71.0                         36 35                 71
1170517 1170517 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_7                         9.0 0.0                       9.0                         9 0                 9
1291904 1291904 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_7                         6.0 1.0                       7.0                         6 1                 7
1303929 1303929 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_7                         2.0 0.0                       2.0                         2 0                 2
1762467 1762467 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_7                         14.0 5.0                       19.0                         14 5                 19
1798251 1798251 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_7                         5.0 4.0                       9.0                         5 4                 9
1917887 1917887 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_7                         7.0 5.0                       12.0                         7 5                 12
1929815 1929815 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_7                         11.0 3.0                       14.0                         11 3                 14
1170463 1170463 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2015   grade_7                         79.0 83.0                       162.0                         79 83                 162
1291850 1291850 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2016   grade_7                         83.0 82.0                       165.0                         83 82                 165
1303875 1303875 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2017   grade_7                         85.0 84.0                       169.0                         85 84                 169
1762413 1762413 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2019   grade_7                         84.0 84.0                       168.0                         84 84                 168
1798197 1798197 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2018   grade_7                         85.0 76.0                       161.0                         85 76                 161

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