enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1169726 1169726 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_10                         54.0 41.0                       95.0                         54 41                 95
1291116 1291116 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_10                         51.0 51.0                       102.0                         51 51                 102
1303145 1303145 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_10                         50.0 55.0                       105.0                         50 55                 105
1761656 1761656 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_10                         46.0 18.0                       64.0                         46 18                 64
1797461 1797461 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_10                         54.0 25.0                       79.0                         54 25                 79
1917062 1917062 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_10                         43.0 18.0                       61.0                         43 18                 61
1928992 1928992 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_10                         56.0 18.0                       74.0                         56 18                 74
1166260 1166260 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2015   grade_10                         14.0 18.0                       32.0                         14 18                 32
1287661 1287661 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2016   grade_10                         8.0 24.0                       32.0                         8 24                 32
1299699 1299699 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_10                         4.0 24.0                       28.0                         4 24                 28
1758237 1758237 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_10                         9.0 13.0                       22.0                         9 13                 22
1794027 1794027 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2018   grade_10                         10.0 23.0                       33.0                         10 23                 33
1913665 1913665 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_10                         19.0 24.0                       43.0                         19 24                 43
1925571 1925571 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_10                         18.0 27.0                       45.0                         18 27                 45
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
1168785 1168785 IN     school 1810290 7205   South Bend Community Sch Corp 181029001662 7505 Adams High School   Regular School No 3.0 09 12 2015   grade_10                         240.0 229.0                       469.0                         240 229                 469
1290176 1290176 IN     school 1810290 7205   South Bend Community Sch Corp 181029001662 7505 Adams High School   Regular School No 3.0 09 12 2016   grade_10                         236.0 243.0                       479.0                         236 243                 479
1302204 1302204 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2017   grade_10                         223.0 232.0                       455.0                         223 232                 455
1760714 1760714 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2019   grade_10                         245.0 260.0                       505.0                         245 260                 505
1796518 1796518 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2018   grade_10                         240.0 251.0                       491.0                         240 251                 491
1916124 1916124 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2020   grade_10                         263.0 272.0                       535.0                         263 272                 535
1928059 1928059 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2021   grade_10                         222.0 275.0                       497.0                         222 275                 497
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
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
1159640 1159640 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_10                         2.0 0.0                       2.0                         2 0                 2
1281033 1281033 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_10                         1.0 0.0                       1.0                         1 0                 1
1293094 1293094 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_10                         3.0 2.0                       5.0                         3 2                 5
1751719 1751719 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_10                         2.0 0.0                       2.0                         2 0                 2
1787465 1787465 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_10                         3.0 3.0                       6.0                         3 3                 6
1907160 1907160 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1919126 1919126 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1281025 1281025 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_10                         1.0 1.0                       2.0                         1 1                 2
1293087 1293087 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_10                         1.0 3.0                       4.0                         1 3                 4
1787460 1787460 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_10                         2.0 1.0                       3.0                         2 1                 3
1159634 1159634 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_10                         3.0 0.0                       3.0                         3 0                 3
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
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
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
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
1169290 1169290 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No 3.0 09 12 2015   grade_10                         93.0 97.0                       190.0                         93 97                 190
1290673 1290673 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No 3.0 09 12 2016   grade_10                         106.0 119.0                       225.0                         106 119                 225
1302700 1302700 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2017   grade_10                         129.0 107.0                       236.0                         129 107                 236
1761200 1761200 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2019   grade_10                         103.0 107.0                       210.0                         103 107                 210
1797016 1797016 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2018   grade_10                         100.0 130.0                       230.0                         100 130                 230
1916609 1916609 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2020   grade_10                         107.0 100.0                       207.0                         107 100                 207
1928540 1928540 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   grade_10                         97.0 113.0                       210.0                         97 113                 210
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
1170733 1170733 IN     school 1800114 8830   EdPower Arlington 180011400799 5465 Arlington Community High School   Regular School No 3.0 07 12 2015   grade_10                         22.0 38.0                       60.0                         22 38                 60
1287699 1287699 IN     school 1804770 5385   Indianapolis Public Schools 180477000799 5465 Arlington Community High School   Regular School No 3.0 09 12 2016   grade_10                         48.0 39.0                       87.0                         48 39                 87
1299736 1299736 IN     school 1804770 5385   Indianapolis Public Schools 180477000799 5465 Arlington Community High School   Regular School No High 09 12 2017   grade_10                         52.0 49.0                       101.0                         52 49                 101
1794065 1794065 IN     school 1804770 5385   Indianapolis Public Schools 180477000799 5465 Arlington High   Regular School No High 09 12 2018   grade_10                         132.0 86.0                       218.0                         132 86                 218
1166297 1166297 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No 3.0 09 12 2015   grade_10                         240.0 198.0                       438.0                         240 198                 438
1287708 1287708 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No 3.0 09 12 2016   grade_10                         282.0 241.0                       523.0                         282 241                 523
1299745 1299745 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No High 09 12 2017   grade_10                         300.0 255.0                       555.0                         300 255                 555
1758288 1758288 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5462 Arsenal Technical High School   Regular School No High 09 12 2019   grade_10                         415.0 301.0                       716.0                         415 301                 716
1794074 1794074 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No High 09 12 2018   grade_10                         309.0 229.0                       538.0                         309 229                 538
1913716 1913716 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5462 Arsenal Technical High School   Regular School No High 09 12 2020   grade_10                         346.0 257.0                       603.0                         346 257                 603
1925622 1925622 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5462 Arsenal Technical High School   Regular School No High 09 12 2021   grade_10                         250.0 235.0                       485.0                         250 235                 485
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

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