enrollments

Data source: Big Local News · About: Big Local

2,939 rows where grade = "grade_10" and state = "IN" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_10 · 2,939 ✖
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
1171005 1171005 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_10                         25.0 30.0                       55.0                         25 30                 55
1292382 1292382 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_10                         27.0 32.0                       59.0                         27 32                 59
1304415 1304415 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_10                         31.0 43.0                       74.0                         31 43                 74
1763026 1763026 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_10                         39.0 29.0                       68.0                         39 29                 68
1798756 1798756 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_10                         43.0 25.0                       68.0                         43 25                 68
1918495 1918495 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_10                         38.0 62.0                       100.0                         38 62                 100
1930490 1930490 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_10                         58.0 35.0                       93.0                         58 35                 93
1159474 1159474 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_10                         45.0 51.0                       96.0                         45 51                 96
1280864 1280864 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_10                         48.0 34.0                       82.0                         48 34                 82
1292927 1292927 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_10                         46.0 55.0                       101.0                         46 55                 101
1751559 1751559 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_10                         48.0 55.0                       103.0                         48 55                 103
1787300 1787300 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_10                         41.0 53.0                       94.0                         41 53                 94
1907000 1907000 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_10                         38.0 42.0                       80.0                         38 42                 80
1918966 1918966 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_10                         49.0 32.0                       81.0                         49 32                 81
1165520 1165520 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_10                         63.0 66.0                       129.0                         63 66                 129
1286916 1286916 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_10                         78.0 65.0                       143.0                         78 65                 143
1298951 1298951 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_10                         61.0 63.0                       124.0                         61 63                 124
1757482 1757482 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_10                         62.0 64.0                       126.0                         62 64                 126
1793273 1793273 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_10                         67.0 54.0                       121.0                         67 54                 121
1912905 1912905 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2020   grade_10                         51.0 71.0                       122.0                         51 71                 122
1924827 1924827 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2021   grade_10                         66.0 65.0                       131.0                         66 65                 131
1924843 1924843 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria Monroe Academy and Cent   Regular School No High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1165538 1165538 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2015   grade_10                         227.0 249.0                       476.0                         227 249                 476
1286933 1286933 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_10                         298.0 217.0                       515.0                         298 217                 515
1298968 1298968 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_10                         272.0 221.0                       493.0                         272 221                 493
1757499 1757499 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_10                         5.0 5.0                       10.0                         5 5                 10
1757505 1757505 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_10                         231.0 194.0                       425.0                         231 194                 425
1793295 1793295 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_10                         266.0 234.0                       500.0                         266 234                 500
1912922 1912922 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_10                         9.0 4.0                       13.0                         9 4                 13
1912927 1912927 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2020   grade_10                         224.0 208.0                       432.0                         224 208                 432
1924847 1924847 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2021   grade_10                         8.0 8.0                       16.0                         8 8                 16
1924852 1924852 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2021   grade_10                         250.0 215.0                       465.0                         250 215                 465
1171298 1171298 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_10                         35.0 36.0                       71.0                         35 36                 71
1292658 1292658 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_10                         33.0 28.0                       61.0                         33 28                 61
1304698 1304698 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_10                         43.0 26.0                       69.0                         43 26                 69
1763280 1763280 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_10                         44.0 24.0                       68.0                         44 24                 68
1799025 1799025 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_10                         29.0 36.0                       65.0                         29 36                 65
1918727 1918727 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_10                         34.0 27.0                       61.0                         34 27                 61
1930715 1930715 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_10                         30.0 33.0                       63.0                         30 33                 63
1166889 1166889 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_10                         33.0 15.0                       48.0                         33 15                 48
1288289 1288289 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_10                         19.0 30.0                       49.0                         19 30                 49
1300312 1300312 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2017   grade_10                         32.0 22.0                       54.0                         32 22                 54
1758817 1758817 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2019   grade_10                         23.0 27.0                       50.0                         23 27                 50
1794630 1794630 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2018   grade_10                         24.0 26.0                       50.0                         24 26                 50
1914233 1914233 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2020   grade_10                         33.0 28.0                       61.0                         33 28                 61
1926116 1926116 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_10                         22.0 16.0                       38.0                         22 16                 38
1161980 1161980 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000050 2053 Attica High School   Regular School No 3.0 07 12 2015   grade_10                         39.0 15.0                       54.0                         39 15                 54
1283391 1283391 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No 3.0 07 12 2016   grade_10                         22.0 29.0                       51.0                         22 29                 51
1295435 1295435 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2017   grade_10                         34.0 23.0                       57.0                         34 23                 57
1754043 1754043 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2019   grade_10                         21.0 26.0                       47.0                         21 26                 47
1789777 1789777 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2018   grade_10                         32.0 30.0                       62.0                         32 30                 62
1909469 1909469 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2020   grade_10                         19.0 24.0                       43.0                         19 24                 43
1921431 1921431 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_10                         31.0 25.0                       56.0                         31 25                 56
1163080 1163080 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2015   grade_10                         366.0 340.0                       706.0                         366 340                 706
1284486 1284486 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2016   grade_10                         363.0 355.0                       718.0                         363 355                 718
1296524 1296524 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2017   grade_10                         405.0 397.0                       802.0                         405 397                 802
1755140 1755140 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2019   grade_10                         397.0 373.0                       770.0                         397 373                 770
1790878 1790878 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2018   grade_10                         376.0 356.0                       732.0                         376 356                 732
1910585 1910585 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2020   grade_10                         418.0 413.0                       831.0                         418 413                 831
1922537 1922537 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2021   grade_10                         436.0 407.0                       843.0                         436 407                 843
1930230 1930230 IN     school 1800223 9140   BELIEVE Circle City High School 180022302708 9994 BELIEVE Circle City High School   Regular School Yes Secondary 09 10 2021   grade_10                         3.0 2.0                       5.0                         3 2                 5
1160889 1160889 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_10                         31.0 25.0                       56.0                         31 25                 56
1282291 1282291 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_10                         21.0 19.0                       40.0                         21 19                 40
1294329 1294329 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_10                         25.0 22.0                       47.0                         25 22                 47
1752946 1752946 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2019   grade_10                         26.0 35.0                       61.0                         26 35                 61
1788687 1788687 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2018   grade_10                         32.0 26.0                       58.0                         32 26                 58
1908377 1908377 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2020   grade_10                         24.0 31.0                       55.0                         24 31                 55
1920352 1920352 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2021   grade_10                         17.0 32.0                       49.0                         17 32                 49
1160154 1160154 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_10                         274.0 257.0                       531.0                         274 257                 531
1160159 1160159 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_10                         202.0 181.0                       383.0                         202 181                 383
1281548 1281548 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2016   grade_10                         277.0 246.0                       523.0                         277 246                 523
1281553 1281553 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2016   grade_10                         234.0 178.0                       412.0                         234 178                 412
1293603 1293603 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2017   grade_10                         276.0 272.0                       548.0                         276 272                 548
1293608 1293608 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2017   grade_10                         197.0 218.0                       415.0                         197 218                 415
1752224 1752224 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2019   grade_10                         273.0 262.0                       535.0                         273 262                 535
1752229 1752229 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2019   grade_10                         183.0 190.0                       373.0                         183 190                 373
1787970 1787970 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2018   grade_10                         237.0 269.0                       506.0                         237 269                 506
1787975 1787975 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2018   grade_10                         181.0 179.0                       360.0                         181 179                 360
1907662 1907662 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2020   grade_10                         267.0 279.0                       546.0                         267 279                 546
1907667 1907667 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2020   grade_10                         173.0 216.0                       389.0                         173 216                 389
1919629 1919629 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2021   grade_10                         277.0 289.0                       566.0                         277 289                 566
1919634 1919634 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No High 09 12 2021   grade_10                         180.0 226.0                       406.0                         180 226                 406
1168446 1168446 IN     school 1800390 6895   Batesville Community Sch Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2015   grade_10                         89.0 96.0                       185.0                         89 96                 185
1289841 1289841 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2016   grade_10                         94.0 88.0                       182.0                         94 88                 182
1301864 1301864 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2017   grade_10                         107.0 100.0                       207.0                         107 100                 207
1760374 1760374 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2019   grade_10                         93.0 77.0                       170.0                         93 77                 170
1796182 1796182 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2018   grade_10                         105.0 68.0                       173.0                         105 68                 173
1915785 1915785 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2020   grade_10                         110.0 74.0                       184.0                         110 74                 184
1927710 1927710 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2021   grade_10                         88.0 87.0                       175.0                         88 87                 175
1161510 1161510 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2015   grade_10                         70.0 75.0                       145.0                         70 75                 145
1282912 1282912 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2016   grade_10                         73.0 73.0                       146.0                         73 73                 146
1294949 1294949 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2017   grade_10                         92.0 65.0                       157.0                         92 65                 157
1753556 1753556 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2019   grade_10                         68.0 65.0                       133.0                         68 65                 133
1789293 1789293 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2018   grade_10                         87.0 75.0                       162.0                         87 75                 162
1908987 1908987 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2020   grade_10                         83.0 74.0                       157.0                         83 74                 157
1920957 1920957 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No High 09 12 2021   grade_10                         66.0 83.0                       149.0                         66 83                 149
1171333 1171333 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_10                         3.0 3.0                       6.0                         3 3                 6
1292693 1292693 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2016   grade_10                         3.0 2.0                       5.0                         3 2                 5
1166277 1166277 IN     school 1800450 5380   Beech Grove City Schools 180045000093 5449 Beech Grove Sr High School   Regular School No 3.0 09 12 2015   grade_10                         134.0 105.0                       239.0                         134 105                 239
1287678 1287678 IN     school 1800450 5380   Beech Grove City Schools 180045000093 5449 Beech Grove Sr High School   Regular School No 3.0 09 12 2016   grade_10                         129.0 120.0                       249.0                         129 120                 249

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