enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1171015 1171015 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2015   grade_9                         29.0 26.0                       55.0                         29 26                 55
1292392 1292392 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_9                         25.0 39.0                       64.0                         25 39                 64
1304425 1304425 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_9                         51.0 24.0                       75.0                         51 24                 75
1763036 1763036 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_9                         33.0 41.0                       74.0                         33 41                 74
1798766 1798766 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_9                         58.0 34.0                       92.0                         58 34                 92
1918505 1918505 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_9                         58.0 52.0                       110.0                         58 52                 110
1930500 1930500 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_9                         68.0 72.0                       140.0                         68 72                 140
1159477 1159477 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_9                         49.0 34.0                       83.0                         49 34                 83
1280867 1280867 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 53.0                       100.0                         47 53                 100
1292930 1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1751562 1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1787303 1787303 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_9                         49.0 53.0                       102.0                         49 53                 102
1907003 1907003 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_9                         50.0 33.0                       83.0                         50 33                 83
1918969 1918969 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_9                         53.0 48.0                       101.0                         53 48                 101
1165525 1165525 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_9                         76.0 68.0                       144.0                         76 68                 144
1286921 1286921 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_9                         60.0 66.0                       126.0                         60 66                 126
1298956 1298956 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_9                         69.0 57.0                       126.0                         69 57                 126
1757487 1757487 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_9                         50.0 67.0                       117.0                         50 67                 117
1793278 1793278 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_9                         60.0 68.0                       128.0                         60 68                 128
1912910 1912910 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2020   grade_9                         67.0 66.0                       133.0                         67 66                 133
1924832 1924832 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2021   grade_9                         91.0 59.0                       150.0                         91 59                 150
1165541 1165541 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2015   grade_9                         311.0 219.0                       530.0                         311 219                 530
1286936 1286936 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_9                         271.0 208.0                       479.0                         271 208                 479
1298971 1298971 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_9                         268.0 247.0                       515.0                         268 247                 515
1757503 1757503 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_9                         13.0 3.0                       16.0                         13 3                 16
1757508 1757508 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_9                         226.0 210.0                       436.0                         226 210                 436
1793293 1793293 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_9                         12.0 5.0                       17.0                         12 5                 17
1793298 1793298 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_9                         224.0 203.0                       427.0                         224 203                 427
1912925 1912925 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_9                         10.0 5.0                       15.0                         10 5                 15
1912930 1912930 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2020   grade_9                         245.0 224.0                       469.0                         245 224                 469
1924850 1924850 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2021   grade_9                         14.0 7.0                       21.0                         14 7                 21
1924855 1924855 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2021   grade_9                         226.0 232.0                       458.0                         226 232                 458
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
1166894 1166894 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_9                         20.0 32.0                       52.0                         20 32                 52
1288294 1288294 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         36.0 24.0                       60.0                         36 24                 60
1300317 1300317 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2017   grade_9                         26.0 25.0                       51.0                         26 25                 51
1758822 1758822 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2019   grade_9                         35.0 28.0                       63.0                         35 28                 63
1794635 1794635 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         27.0 27.0                       54.0                         27 27                 54
1914239 1914239 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2020   grade_9                         25.0 16.0                       41.0                         25 16                 41
1926122 1926122 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_9                         20.0 28.0                       48.0                         20 28                 48
1161985 1161985 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000050 2053 Attica High School   Regular School No 3.0 07 12 2015   grade_9                         23.0 30.0                       53.0                         23 30                 53
1283396 1283396 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No 3.0 07 12 2016   grade_9                         38.0 23.0                       61.0                         38 23                 61
1295440 1295440 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2017   grade_9                         34.0 29.0                       63.0                         34 29                 63
1754049 1754049 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2019   grade_9                         16.0 28.0                       44.0                         16 28                 44
1789782 1789782 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2018   grade_9                         23.0 24.0                       47.0                         23 24                 47
1909475 1909475 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2020   grade_9                         30.0 22.0                       52.0                         30 22                 52
1921437 1921437 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_9                         25.0 19.0                       44.0                         25 19                 44
1163083 1163083 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2015   grade_9                         358.0 346.0                       704.0                         358 346                 704
1284489 1284489 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2016   grade_9                         409.0 399.0                       808.0                         409 399                 808
1296527 1296527 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2017   grade_9                         368.0 367.0                       735.0                         368 367                 735
1755143 1755143 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2019   grade_9                         420.0 418.0                       838.0                         420 418                 838
1790881 1790881 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2018   grade_9                         411.0 376.0                       787.0                         411 376                 787
1910588 1910588 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2020   grade_9                         427.0 395.0                       822.0                         427 395                 822
1922540 1922540 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2021   grade_9                         432.0 377.0                       809.0                         432 377                 809
1930231 1930231 IN     school 1800223 9140   BELIEVE Circle City High School 180022302708 9994 BELIEVE Circle City High School   Regular School Yes Secondary 09 10 2021   grade_9                         20.0 29.0                       49.0                         20 29                 49
1160895 1160895 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_9                         22.0 19.0                       41.0                         22 19                 41
1282297 1282297 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2016   grade_9                         29.0 24.0                       53.0                         29 24                 53
1294335 1294335 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_9                         32.0 22.0                       54.0                         32 22                 54
1752952 1752952 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2019   grade_9                         25.0 34.0                       59.0                         25 34                 59
1788693 1788693 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2018   grade_9                         26.0 33.0                       59.0                         26 33                 59
1908383 1908383 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2020   grade_9                         17.0 38.0                       55.0                         17 38                 55
1920358 1920358 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2021   grade_9                         40.0 36.0                       76.0                         40 36                 76
1160157 1160157 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_9                         273.0 252.0                       525.0                         273 252                 525
1160162 1160162 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_9                         234.0 188.0                       422.0                         234 188                 422
1281551 1281551 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2016   grade_9                         279.0 273.0                       552.0                         279 273                 552
1281556 1281556 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2016   grade_9                         200.0 222.0                       422.0                         200 222                 422
1293606 1293606 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2017   grade_9                         244.0 271.0                       515.0                         244 271                 515
1293611 1293611 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2017   grade_9                         176.0 192.0                       368.0                         176 192                 368
1752227 1752227 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2019   grade_9                         270.0 298.0                       568.0                         270 298                 568
1752232 1752232 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2019   grade_9                         175.0 208.0                       383.0                         175 208                 383
1787973 1787973 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2018   grade_9                         266.0 259.0                       525.0                         266 259                 525
1787978 1787978 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2018   grade_9                         190.0 199.0                       389.0                         190 199                 389
1907665 1907665 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2020   grade_9                         270.0 288.0                       558.0                         270 288                 558
1907670 1907670 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2020   grade_9                         183.0 230.0                       413.0                         183 230                 413
1919632 1919632 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2021   grade_9                         258.0 274.0                       532.0                         258 274                 532
1919637 1919637 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2021   grade_9                         214.0 217.0                       431.0                         214 217                 431
1168449 1168449 IN     school 1800390 6895   Batesville Community Sch Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2015   grade_9                         100.0 88.0                       188.0                         100 88                 188
1289844 1289844 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2016   grade_9                         111.0 100.0                       211.0                         111 100                 211
1301867 1301867 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2017   grade_9                         106.0 71.0                       177.0                         106 71                 177
1760377 1760377 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2019   grade_9                         107.0 72.0                       179.0                         107 72                 179
1796185 1796185 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2018   grade_9                         98.0 83.0                       181.0                         98 83                 181
1915788 1915788 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2020   grade_9                         91.0 84.0                       175.0                         91 84                 175
1927713 1927713 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2021   grade_9                         88.0 86.0                       174.0                         88 86                 174
1161513 1161513 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2015   grade_9                         73.0 70.0                       143.0                         73 70                 143
1282915 1282915 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2016   grade_9                         88.0 69.0                       157.0                         88 69                 157
1294952 1294952 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2017   grade_9                         90.0 84.0                       174.0                         90 84                 174
1753559 1753559 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2019   grade_9                         82.0 79.0                       161.0                         82 79                 161
1789296 1789296 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2018   grade_9                         70.0 66.0                       136.0                         70 66                 136
1908990 1908990 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2020   grade_9                         72.0 89.0                       161.0                         72 89                 161
1920960 1920960 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2021   grade_9                         63.0 74.0                       137.0                         63 74                 137
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
1166280 1166280 IN     school 1800450 5380   Beech Grove City Schools 180045000093 5449 Beech Grove Sr High School   Regular School No 3.0 09 12 2015   grade_9                         141.0 136.0                       277.0                         141 136                 277
1287681 1287681 IN     school 1800450 5380   Beech Grove City Schools 180045000093 5449 Beech Grove Sr High School   Regular School No 3.0 09 12 2016   grade_9                         133.0 122.0                       255.0                         133 122                 255

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