enrollments

Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,924 ✖
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
1763522 1763522 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_9                         3.0 13.0                       16.0                         3 13                 16
1799291 1799291 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_9                         6.0 2.0                       8.0                         6 2                 8
1918937 1918937 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_9                         7.0 11.0                       18.0                         7 11                 18
1930938 1930938 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_9                         6.0 10.0                       16.0                         6 10                 16
1304951 1304951 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other 07 09 2017   grade_9                         37.0 41.0                       78.0                         37 41                 78
1763510 1763510 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_9                         47.0 49.0                       96.0                         47 49                 96
1799281 1799281 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_9                         29.0 23.0                       52.0                         29 23                 52
1918924 1918924 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_9                         45.0 37.0                       82.0                         45 37                 82
1930924 1930924 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_9                         24.0 45.0                       69.0                         24 45                 69
1292892 1292892 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_9                         8.0 15.0                       23.0                         8 15                 23
1304921 1304921 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_9                         8.0 21.0                       29.0                         8 21                 29
1763471 1763471 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_9                         22.0 24.0                       46.0                         22 24                 46
1799247 1799247 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_9                         15.0 15.0                       30.0                         15 15                 30
1918879 1918879 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_9                         24.0 25.0                       49.0                         24 25                 49
1930869 1930869 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_9                         32.0 31.0                       63.0                         32 31                 63
1171485 1171485 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_9                         13.0 16.0                       29.0                         13 16                 29
1292859 1292859 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2016   grade_9                         16.0 12.0                       28.0                         16 12                 28
1304887 1304887 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2017   grade_9                         9.0 13.0                       22.0                         9 13                 22
1799213 1799213 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_9                         1.0 0.0                       1.0                         1 0                 1
1171474 1171474 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         22.0 4.0                       26.0                         22 4                 26
1292847 1292847 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_9                         12.0 5.0                       17.0                         12 5                 17
1304874 1304874 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_9                         15.0 3.0                       18.0                         15 3                 18
1763428 1763428 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   grade_9                         22.0 2.0                       24.0                         22 2                 24
1799199 1799199 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_9                         26.0 5.0                       31.0                         26 5                 31
1918847 1918847 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_9                         16.0 8.0                       24.0                         16 8                 24
1930835 1930835 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   grade_9                         22.0 13.0                       35.0                         22 13                 35
1292834 1292834 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes 3.0 07 12 2016   grade_9                         33.0 5.0                       38.0                         33 5                 38
1304861 1304861 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes Other 06 12 2017   grade_9                         18.0 13.0                       31.0                         18 13                 31
1763415 1763415 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2019   grade_9                         23.0 4.0                       27.0                         23 4                 27
1799186 1799186 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2018   grade_9                         19.0 14.0                       33.0                         19 14                 33
1171461 1171461 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_9                         73.0 117.0                       190.0                         73 117                 190
1292827 1292827 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_9                         0.0 2.0                       2.0                         0 2                 2
1171454 1171454 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         258.0 322.0                       580.0                         258 322                 580
1292820 1292820 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_9                         240.0 341.0                       581.0                         240 341                 581
1304848 1304848 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2017   grade_9                         303.0 339.0                       642.0                         303 339                 642
1763402 1763402 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_9                         190.0 220.0                       410.0                         190 220                 410
1799173 1799173 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2018   grade_9                         218.0 264.0                       482.0                         218 264                 482
1918828 1918828 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2020   grade_9                         258.0 338.0                       596.0                         258 338                 596
1930817 1930817 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_9                         298.0 346.0                       644.0                         298 346                 644
1171440 1171440 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_9                         33.0 36.0                       69.0                         33 36                 69
1292804 1292804 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_9                         26.0 35.0                       61.0                         26 35                 61
1304830 1304830 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2017   grade_9                         45.0 26.0                       71.0                         45 26                 71
1763385 1763385 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2019   grade_9                         45.0 42.0                       87.0                         45 42                 87
1799156 1799156 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2018   grade_9                         32.0 44.0                       76.0                         32 44                 76
1918811 1918811 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2020   grade_9                         38.0 37.0                       75.0                         38 37                 75
1930800 1930800 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2021   grade_9                         46.0 47.0                       93.0                         46 47                 93
1171427 1171427 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_9                         31.0 33.0                       64.0                         31 33                 64
1292791 1292791 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2016   grade_9                         73.0 81.0                       154.0                         73 81                 154
1304817 1304817 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes Other 06 12 2017   grade_9                         107.0 159.0                       266.0                         107 159                 266
1763372 1763372 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2019   grade_9                         40.0 35.0                       75.0                         40 35                 75
1799143 1799143 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2018   grade_9                         47.0 91.0                       138.0                         47 91                 138
1171419 1171419 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_9                         45.0 77.0                       122.0                         45 77                 122
1292783 1292783 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_9                         3.0 6.0                       9.0                         3 6                 9
1304809 1304809 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2017   grade_9                         2.0 0.0                       2.0                         2 0                 2
1763363 1763363 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2019   grade_9                         28.0 38.0                       66.0                         28 38                 66
1799135 1799135 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2018   grade_9                         3.0 10.0                       13.0                         3 10                 13
1930787 1930787 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2021   grade_9                         7.0 10.0                       17.0                         7 10                 17
1171414 1171414 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_9                         44.0 46.0                       90.0                         44 46                 90
1292778 1292778 IN     school 1800101 9880   Career Academy High School 180010102521 7564 Career Academy High School   Regular School Yes 3.0 09 12 2016   grade_9                         34.0 26.0                       60.0                         34 26                 60
1304804 1304804 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2017   grade_9                         45.0 40.0                       85.0                         45 40                 85
1763358 1763358 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2019   grade_9                         56.0 40.0                       96.0                         56 40                 96
1799130 1799130 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2018   grade_9                         42.0 40.0                       82.0                         42 40                 82
1918794 1918794 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2020   grade_9                         53.0 54.0                       107.0                         53 54                 107
1930782 1930782 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2021   grade_9                         58.0 41.0                       99.0                         58 41                 99
1171404 1171404 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         20.0 19.0                       39.0                         20 19                 39
1292771 1292771 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   grade_9                         15.0 17.0                       32.0                         15 17                 32
1304797 1304797 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   grade_9                         20.0 12.0                       32.0                         20 12                 32
1763352 1763352 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2019   grade_9                         17.0 22.0                       39.0                         17 22                 39
1799124 1799124 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2018   grade_9                         19.0 15.0                       34.0                         19 15                 34
1918788 1918788 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2020   grade_9                         26.0 19.0                       45.0                         26 19                 45
1930776 1930776 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2021   grade_9                         34.0 34.0                       68.0                         34 34                 68
1171380 1171380 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_9                         171.0 203.0                       374.0                         171 203                 374
1292747 1292747 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   grade_9                         187.0 263.0                       450.0                         187 263                 450
1304773 1304773 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_9                         131.0 169.0                       300.0                         131 169                 300
1799100 1799100 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_9                         78.0 78.0                       156.0                         78 78                 156
1799072 1799072 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 09 12 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1171337 1171337 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_9                         3.0 0.0                       3.0                         3 0                 3
1292697 1292697 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2016   grade_9                         4.0 3.0                       7.0                         4 3                 7
1171330 1171330 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_9                         8.0 12.0                       20.0                         8 12                 20
1292690 1292690 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_9                         13.0 11.0                       24.0                         13 11                 24
1304730 1304730 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_9                         11.0 11.0                       22.0                         11 11                 22
1763312 1763312 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2019   grade_9                         8.0 4.0                       12.0                         8 4                 12
1799057 1799057 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_9                         9.0 10.0                       19.0                         9 10                 19
1171308 1171308 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_9                         37.0 27.0                       64.0                         37 27                 64
1292668 1292668 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_9                         48.0 31.0                       79.0                         48 31                 79
1304708 1304708 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_9                         31.0 36.0                       67.0                         31 36                 67
1763290 1763290 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_9                         33.0 27.0                       60.0                         33 27                 60
1799035 1799035 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_9                         48.0 19.0                       67.0                         48 19                 67
1918737 1918737 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_9                         34.0 27.0                       61.0                         34 27                 61
1930725 1930725 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_9                         48.0 38.0                       86.0                         48 38                 86
1292639 1292639 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes 2.0 07 09 2016   grade_9                         36.0 38.0                       74.0                         36 38                 74
1304678 1304678 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Other 07 10 2017   grade_9                         38.0 36.0                       74.0                         38 36                 74
1763259 1763259 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes High 07 12 2019   grade_9                         45.0 32.0                       77.0                         45 32                 77
1799004 1799004 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_9                         53.0 44.0                       97.0                         53 44                 97
1171279 1171279 IN     school 1800115 9765   Indiana Cyber Charter Sch Inc 180011502537 4421 Indiana Cyber Charter School   Regular School Yes 4.0 KG 12 2015   grade_9                         52.0 57.0                       109.0                         52 57                 109
1171266 1171266 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_9                         7.0 0.0                       7.0                         7 0                 7
1292635 1292635 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_9                         14.0 0.0                       14.0                         14 0                 14
1304673 1304673 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_9                         10.0 0.0                       10.0                         10 0                 10
1763252 1763252 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_9                         9.0 0.0                       9.0                         9 0                 9
1798998 1798998 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_9                         12.0 0.0                       12.0                         12 0                 12

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