enrollments

Data source: Big Local News · About: Big Local

2,960 rows where grade = "grade_11" and state = "IN" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_11 · 2,960 ✖
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
1171069 1171069 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_11                         12.0 7.0                       19.0                         12 7                 19
1292446 1292446 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_11                         21.0 12.0                       33.0                         21 12                 33
1304479 1304479 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_11                         14.0 8.0                       22.0                         14 8                 22
1763091 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
1798821 1798821 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_11                         16.0 10.0                       26.0                         16 10                 26
1918560 1918560 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_11                         16.0 18.0                       34.0                         16 18                 34
1930556 1930556 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_11                         7.0 16.0                       23.0                         7 16                 23
1171054 1171054 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_11                         6.0 6.0                       12.0                         6 6                 12
1292431 1292431 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_11                         5.0 10.0                       15.0                         5 10                 15
1304464 1304464 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_11                         10.0 5.0                       15.0                         10 5                 15
1763076 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
1798806 1798806 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_11                         7.0 1.0                       8.0                         7 1                 8
1918545 1918545 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_11                         2.0 5.0                       7.0                         2 5                 7
1930540 1930540 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_11                         7.0 3.0                       10.0                         7 3                 10
1930083 1930083 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_11                         3.0 1.0                       4.0                         3 1                 4
1930065 1930065 IN     school 1800219 8970   GEO Next Generation Academy 180021902704 9966 GEO Next Generation Academy   Regular School Yes Secondary 09 11 2021   grade_11                         9.0 11.0                       20.0                         9 11                 20
1930050 1930050 IN     school 1800215 8940   James and Rosemary Phalen Leadersh 180021502701 9961 James and Rosemary Phalen Leadersh   Regular School Yes Secondary 09 11 2021   grade_11                         41.0 25.0                       66.0                         41 25                 66
1930313 1930313 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_11                         25.0 33.0                       58.0                         25 33                 58
1170656 1170656 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_11                         62.0 48.0                       110.0                         62 48                 110
1292045 1292045 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         62.0 45.0                       107.0                         62 45                 107
1304068 1304068 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No Other 06 12 2017   grade_11                         48.0 35.0                       83.0                         48 35                 83
1762610 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
1798391 1798391 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2018   grade_11                         50.0 42.0                       92.0                         50 42                 92
1918029 1918029 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   grade_11                         51.0 38.0                       89.0                         51 38                 89
1929956 1929956 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   grade_11                         51.0 41.0                       92.0                         51 41                 92
1164270 1164270 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2015   grade_11                         60.0 65.0                       125.0                         60 65                 125
1285676 1285676 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_11                         75.0 65.0                       140.0                         75 65                 140
1297723 1297723 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_11                         67.0 47.0                       114.0                         67 47                 114
1756317 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
1792081 1792081 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 09 12 2018   grade_11                         59.0 60.0                       119.0                         59 60                 119
1911774 1911774 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         58.0 38.0                       96.0                         58 38                 96
1923742 1923742 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_11                         64.0 51.0                       115.0                         64 51                 115
1170698 1170698 IN     school 1802280 8665   Whitley Co Cons Schools 180228000267 9187 Columbia City High School   Regular School No 3.0 09 12 2015   grade_11                         129.0 131.0                       260.0                         129 131                 260
1292087 1292087 IN     school 1802280 8665   Whitley Co Cons Schools 180228000267 9187 Columbia City High School   Regular School No 3.0 09 12 2016   grade_11                         127.0 131.0                       258.0                         127 131                 258
1304109 1304109 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2017   grade_11                         130.0 115.0                       245.0                         130 115                 245
1762652 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
1798433 1798433 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2018   grade_11                         142.0 120.0                       262.0                         142 120                 262
1918076 1918076 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2020   grade_11                         147.0 128.0                       275.0                         147 128                 275
1930006 1930006 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2021   grade_11                         134.0 136.0                       270.0                         134 136                 270
1170634 1170634 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No 3.0 09 12 2015   grade_11                         80.0 87.0                       167.0                         80 87                 167
1292023 1292023 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No 3.0 09 12 2016   grade_11                         93.0 87.0                       180.0                         93 87                 180
1304045 1304045 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2017   grade_11                         90.0 99.0                       189.0                         90 99                 189
1762587 1762587 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2019   grade_11                         105.0 96.0                       201.0                         105 96                 201
1798368 1798368 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2018   grade_11                         96.0 103.0                       199.0                         96 103                 199
1918006 1918006 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2020   grade_11                         97.0 98.0                       195.0                         97 98                 195
1929933 1929933 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2021   grade_11                         92.0 67.0                       159.0                         92 67                 159
1170615 1170615 IN     school 1811430 8535   Tri-County School Corp 181143001846 9141 Tri-County Middle-Senior High   Regular School No 3.0 07 12 2015   grade_11                         32.0 20.0                       52.0                         32 20                 52
1292004 1292004 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Middle-Senior High   Regular School No 3.0 07 12 2016   grade_11                         29.0 29.0                       58.0                         29 29                 58
1304026 1304026 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Middle-Senior High   Regular School No High 07 12 2017   grade_11                         34.0 32.0                       66.0                         34 32                 66
1762567 1762567 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2019   grade_11                         32.0 25.0                       57.0                         32 25                 57
1798349 1798349 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 07 12 2018   grade_11                         29.0 28.0                       57.0                         29 28                 57
1917987 1917987 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         31.0 20.0                       51.0                         31 20                 51
1929912 1929912 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2021   grade_11                         23.0 24.0                       47.0                         23 24                 47
1170604 1170604 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         33.0 26.0                       59.0                         33 26                 59
1291993 1291993 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         28.0 28.0                       56.0                         28 28                 56
1304015 1304015 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2017   grade_11                         23.0 18.0                       41.0                         23 18                 41
1762555 1762555 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         27.0 27.0                       54.0                         27 27                 54
1798338 1798338 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2018   grade_11                         31.0 23.0                       54.0                         31 23                 54
1917975 1917975 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         23.0 21.0                       44.0                         23 21                 44
1929900 1929900 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2021   grade_11                         30.0 26.0                       56.0                         30 26                 56
1170588 1170588 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_11                         34.0 22.0                       56.0                         34 22                 56
1291977 1291977 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_11                         30.0 25.0                       55.0                         30 25                 55
1304001 1304001 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White High School   Regular School No High 09 12 2017   grade_11                         43.0 33.0                       76.0                         43 33                 76
1762541 1762541 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White High School   Regular School No High 09 12 2019   grade_11                         46.0 28.0                       74.0                         46 28                 74
1798323 1798323 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White High School   Regular School No High 09 12 2018   grade_11                         32.0 25.0                       57.0                         32 25                 57
1917960 1917960 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White High School   Regular School No High 09 12 2020   grade_11                         22.0 29.0                       51.0                         22 29                 51
1929886 1929886 IN     school 1808130 8515   North White School Corp 180813001396 9135 North White High School   Regular School No High 09 12 2021   grade_11                         29.0 30.0                       59.0                         29 30                 59
1170562 1170562 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No 3.0 09 12 2015   grade_11                         57.0 63.0                       120.0                         57 63                 120
1291951 1291951 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No 3.0 09 12 2016   grade_11                         57.0 59.0                       116.0                         57 59                 116
1303974 1303974 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2017   grade_11                         51.0 60.0                       111.0                         51 60                 111
1762513 1762513 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2019   grade_11                         62.0 53.0                       115.0                         62 53                 115
1798296 1798296 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2018   grade_11                         60.0 54.0                       114.0                         60 54                 114
1917933 1917933 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2020   grade_11                         57.0 67.0                       124.0                         57 67                 124
1929859 1929859 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2021   grade_11                         69.0 54.0                       123.0                         69 54                 123
1170553 1170553 IN     school 1808220 8435   Northern Wells Com Schools 180822001410 9087 Norwell High School   Regular School No 3.0 09 12 2015   grade_11                         113.0 108.0                       221.0                         113 108                 221
1291942 1291942 IN     school 1808220 8435   Northern Wells Com Schools 180822001410 9087 Norwell High School   Regular School No 3.0 09 12 2016   grade_11                         90.0 89.0                       179.0                         90 89                 179
1303965 1303965 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2017   grade_11                         88.0 105.0                       193.0                         88 105                 193
1762504 1762504 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2019   grade_11                         107.0 105.0                       212.0                         107 105                 212
1798287 1798287 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2018   grade_11                         104.0 101.0                       205.0                         104 101                 205
1917923 1917923 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2020   grade_11                         117.0 106.0                       223.0                         117 106                 223
1929850 1929850 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2021   grade_11                         96.0 95.0                       191.0                         96 95                 191
1170531 1170531 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_11                         40.0 31.0                       71.0                         40 31                 71
1291919 1291919 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_11                         41.0 40.0                       81.0                         41 40                 81
1303942 1303942 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2017   grade_11                         35.0 28.0                       63.0                         35 28                 63
1762481 1762481 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         34.0 20.0                       54.0                         34 20                 54
1798265 1798265 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2018   grade_11                         34.0 38.0                       72.0                         34 38                 72
1917901 1917901 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         35.0 32.0                       67.0                         35 32                 67
1929828 1929828 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2021   grade_11                         33.0 44.0                       77.0                         33 44                 77
1170510 1170510 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_11                         15.0 1.0                       16.0                         15 1                 16
1291897 1291897 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_11                         2.0 1.0                       3.0                         2 1                 3
1303922 1303922 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_11                         17.0 2.0                       19.0                         17 2                 19
1762460 1762460 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_11                         8.0 3.0                       11.0                         8 3                 11
1798244 1798244 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_11                         6.0 5.0                       11.0                         6 5                 11
1917880 1917880 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_11                         9.0 5.0                       14.0                         9 5                 14
1929808 1929808 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_11                         2.0 1.0                       3.0                         2 1                 3
1170769 1170769 IN     school 1800134 9305   The Excel Center - Richmond 180013402549 9012 The Excel Center - Richmond   Regular School Yes 3.0 09 12 2015   grade_11                         28.0 66.0                       94.0                         28 66                 94
1292151 1292151 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes 3.0 10 12 2016   grade_11                         104.0 134.0                       238.0                         104 134                 238
1304185 1304185 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2017   grade_11                         49.0 45.0                       94.0                         49 45                 94
1762824 1762824 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2019   grade_11                         31.0 44.0                       75.0                         31 44                 75
1798550 1798550 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 10 12 2018   grade_11                         52.0 67.0                       119.0                         52 67                 119

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