enrollments

Data source: Big Local News · About: Big Local

2,960 rows where grade = "grade_11" and state = "IN" sorted by district_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
1304970 1304970 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes Other 11 11 2017   grade_11                         31.0 53.0                       84.0                         31 53                 84
1763535 1763535 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_11                         39.0 57.0                       96.0                         39 57                 96
1799303 1799303 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_11                         28.0 50.0                       78.0                         28 50                 78
1918950 1918950 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 11 12 2020   grade_11                         54.0 92.0                       146.0                         54 92                 146
1930952 1930952 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   grade_11                         37.0 61.0                       98.0                         37 61                 98
1918929 1918929 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_11                         10.0 5.0                       15.0                         10 5                 15
1930929 1930929 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_11                         3.0 9.0                       12.0                         3 9                 12
1763507 1763507 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_11                         30.0 39.0                       69.0                         30 39                 69
1918919 1918919 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_11                         23.0 19.0                       42.0                         23 19                 42
1930918 1930918 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_11                         32.0 30.0                       62.0                         32 30                 62
1292883 1292883 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_11                         15.0 14.0                       29.0                         15 14                 29
1304912 1304912 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_11                         22.0 18.0                       40.0                         22 18                 40
1763462 1763462 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_11                         14.0 23.0                       37.0                         14 23                 37
1799238 1799238 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_11                         17.0 30.0                       47.0                         17 30                 47
1918870 1918870 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_11                         20.0 13.0                       33.0                         20 13                 33
1930860 1930860 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_11                         18.0 24.0                       42.0                         18 24                 42
1171483 1171483 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_11                         4.0 19.0                       23.0                         4 19                 23
1292857 1292857 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2016   grade_11                         12.0 26.0                       38.0                         12 26                 38
1304885 1304885 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2017   grade_11                         14.0 30.0                       44.0                         14 30                 44
1799211 1799211 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_11                         4.0 2.0                       6.0                         4 2                 6
1171465 1171465 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         16.0 7.0                       23.0                         16 7                 23
1292838 1292838 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         15.0 11.0                       26.0                         15 11                 26
1304865 1304865 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_11                         18.0 4.0                       22.0                         18 4                 22
1763419 1763419 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   grade_11                         17.0 7.0                       24.0                         17 7                 24
1799190 1799190 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_11                         27.0 5.0                       32.0                         27 5                 32
1918838 1918838 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_11                         28.0 5.0                       33.0                         28 5                 33
1930826 1930826 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   grade_11                         17.0 3.0                       20.0                         17 3                 20
1292830 1292830 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes 3.0 07 12 2016   grade_11                         24.0 7.0                       31.0                         24 7                 31
1304856 1304856 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes Other 06 12 2017   grade_11                         20.0 12.0                       32.0                         20 12                 32
1763410 1763410 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2019   grade_11                         34.0 11.0                       45.0                         34 11                 45
1799181 1799181 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2018   grade_11                         48.0 18.0                       66.0                         48 18                 66
1171459 1171459 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_11                         118.0 250.0                       368.0                         118 250                 368
1292825 1292825 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2016   grade_11                         329.0 519.0                       848.0                         329 519                 848
1304852 1304852 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 11 12 2017   grade_11                         146.0 266.0                       412.0                         146 266                 412
1763406 1763406 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 10 12 2019   grade_11                         234.0 473.0                       707.0                         234 473                 707
1799177 1799177 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 10 12 2018   grade_11                         160.0 303.0                       463.0                         160 303                 463
1918832 1918832 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 10 12 2020   grade_11                         360.0 773.0                       1133.0                         360 773                 1133
1930821 1930821 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 10 12 2021   grade_11                         153.0 446.0                       599.0                         153 446                 599
1171445 1171445 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         168.0 272.0                       440.0                         168 272                 440
1292811 1292811 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         210.0 338.0                       548.0                         210 338                 548
1304839 1304839 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2017   grade_11                         259.0 411.0                       670.0                         259 411                 670
1763393 1763393 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_11                         299.0 468.0                       767.0                         299 468                 767
1799164 1799164 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2018   grade_11                         303.0 478.0                       781.0                         303 478                 781
1918819 1918819 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2020   grade_11                         315.0 515.0                       830.0                         315 515                 830
1930808 1930808 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_11                         341.0 485.0                       826.0                         341 485                 826
1292807 1292807 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes 4.0 11 11 2016   grade_11                         59.0 195.0                       254.0                         59 195                 254
1304834 1304834 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 09 12 2017   grade_11                         53.0 140.0                       193.0                         53 140                 193
1763388 1763388 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2019   grade_11                         50.0 131.0                       181.0                         50 131                 181
1799159 1799159 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2018   grade_11                         33.0 61.0                       94.0                         33 61                 94
1918814 1918814 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2020   grade_11                         54.0 103.0                       157.0                         54 103                 157
1930803 1930803 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2021   grade_11                         52.0 146.0                       198.0                         52 146                 198
1171431 1171431 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_11                         8.0 16.0                       24.0                         8 16                 24
1292795 1292795 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   grade_11                         10.0 22.0                       32.0                         10 22                 32
1304821 1304821 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2017   grade_11                         24.0 18.0                       42.0                         24 18                 42
1763376 1763376 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2019   grade_11                         37.0 13.0                       50.0                         37 13                 50
1799147 1799147 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2018   grade_11                         21.0 22.0                       43.0                         21 22                 43
1918802 1918802 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2020   grade_11                         21.0 21.0                       42.0                         21 21                 42
1930791 1930791 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2021   grade_11                         29.0 29.0                       58.0                         29 29                 58
1171422 1171422 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_11                         31.0 68.0                       99.0                         31 68                 99
1292786 1292786 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2016   grade_11                         101.0 158.0                       259.0                         101 158                 259
1304812 1304812 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes Other 06 12 2017   grade_11                         215.0 366.0                       581.0                         215 366                 581
1763367 1763367 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2019   grade_11                         32.0 52.0                       84.0                         32 52                 84
1799138 1799138 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2018   grade_11                         277.0 450.0                       727.0                         277 450                 727
1171417 1171417 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_11                         15.0 12.0                       27.0                         15 12                 27
1292781 1292781 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_11                         20.0 32.0                       52.0                         20 32                 52
1304807 1304807 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2017   grade_11                         28.0 45.0                       73.0                         28 45                 73
1763361 1763361 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2019   grade_11                         19.0 29.0                       48.0                         19 29                 48
1799133 1799133 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2018   grade_11                         36.0 46.0                       82.0                         36 46                 82
1918797 1918797 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 10 12 2020   grade_11                         24.0 31.0                       55.0                         24 31                 55
1930785 1930785 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2021   grade_11                         18.0 33.0                       51.0                         18 33                 51
1171408 1171408 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_11                         42.0 22.0                       64.0                         42 22                 64
1292776 1292776 IN     school 1800101 9880   Career Academy High School 180010102521 7564 Career Academy High School   Regular School Yes 3.0 09 12 2016   grade_11                         38.0 24.0                       62.0                         38 24                 62
1304802 1304802 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2017   grade_11                         31.0 36.0                       67.0                         31 36                 67
1763356 1763356 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2019   grade_11                         47.0 37.0                       84.0                         47 37                 84
1799128 1799128 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2018   grade_11                         33.0 28.0                       61.0                         33 28                 61
1918792 1918792 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2020   grade_11                         34.0 34.0                       68.0                         34 34                 68
1930780 1930780 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2021   grade_11                         56.0 41.0                       97.0                         56 41                 97
1171395 1171395 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         11.0 7.0                       18.0                         11 7                 18
1292762 1292762 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         23.0 19.0                       42.0                         23 19                 42
1304788 1304788 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   grade_11                         19.0 10.0                       29.0                         19 10                 29
1763343 1763343 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2019   grade_11                         14.0 5.0                       19.0                         14 5                 19
1799115 1799115 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2018   grade_11                         17.0 13.0                       30.0                         17 13                 30
1918779 1918779 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2020   grade_11                         21.0 14.0                       35.0                         21 14                 35
1930767 1930767 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2021   grade_11                         14.0 21.0                       35.0                         14 21                 35
1171371 1171371 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_11                         132.0 226.0                       358.0                         132 226                 358
1292738 1292738 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   grade_11                         224.0 358.0                       582.0                         224 358                 582
1304764 1304764 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_11                         141.0 245.0                       386.0                         141 245                 386
1799091 1799091 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_11                         81.0 125.0                       206.0                         81 125                 206
1292733 1292733 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes 4.0 11 11 2016   grade_11                         55.0 82.0                       137.0                         55 82                 137
1304758 1304758 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 09 12 2017   grade_11                         42.0 65.0                       107.0                         42 65                 107
1763328 1763328 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 11 12 2019   grade_11                         49.0 70.0                       119.0                         49 70                 119
1799085 1799085 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2018   grade_11                         34.0 42.0                       76.0                         34 42                 76
1918764 1918764 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2020   grade_11                         80.0 105.0                       185.0                         80 105                 185
1930752 1930752 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2021   grade_11                         20.0 26.0                       46.0                         20 26                 46
1292710 1292710 IN     school 1800159 9840   Excel Center - Univ Heights 180015902592 5749 Excel Center - Univ Heights   Regular School Yes 3.0 10 12 2016   grade_11                         90.0 206.0                       296.0                         90 206                 296
1304744 1304744 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 11 12 2017   grade_11                         72.0 133.0                       205.0                         72 133                 205
1763325 1763325 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 11 12 2019   grade_11                         61.0 97.0                       158.0                         61 97                 158
1799070 1799070 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 09 12 2018   grade_11                         44.0 88.0                       132.0                         44 88                 132
1918760 1918760 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 11 12 2020   grade_11                         125.0 227.0                       352.0                         125 227                 352
1930748 1930748 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 11 12 2021   grade_11                         45.0 143.0                       188.0                         45 143                 188

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