enrollments

Data source: Big Local News · About: Big Local

2,933 rows where grade = "grade_12" and state = "IN" sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 2,933 ✖
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
1166233 1166233 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_12                         7.0 1.0                       8.0                         7 1                 8
1168297 1168297 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1287635 1287635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_12                         9.0 2.0                       11.0                         9 2                 11
1299672 1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1758210 1758210 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_12                         6.0 0.0                       6.0                         6 0                 6
1794000 1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1908010 1908010 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_12                         38.0 42.0                       80.0                         38 42                 80
1908027 1908027 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_12                         113.0 93.0                       206.0                         113 93                 206
1908042 1908042 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_12                         29.0 23.0                       52.0                         29 23                 52
1913638 1913638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_12                         4.0 2.0                       6.0                         4 2                 6
1925544 1925544 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_12                         4.0 0.0                       4.0                         4 0                 4
1927189 1927189 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1927242 1927242 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1927325 1927325 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_12                         2.0 0.0                       2.0                         2 0                 2
1164271 1164271 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2015   grade_12                         82.0 66.0                       148.0                         82 66                 148
1285677 1285677 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_12                         59.0 67.0                       126.0                         59 67                 126
1297724 1297724 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No High 09 12 2017   grade_12                         65.0 61.0                       126.0                         65 61                 126
1756318 1756318 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_12                         61.0 56.0                       117.0                         61 56                 117
1792082 1792082 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 09 12 2018   grade_12                         58.0 50.0                       108.0                         58 50                 108
1911775 1911775 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_12                         51.0 53.0                       104.0                         51 53                 104
1923743 1923743 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_12                         60.0 41.0                       101.0                         60 41                 101
1165104 1165104 IN     school 1813200 4760   Whiting School City 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2015   grade_12                         45.0 45.0                       90.0                         45 45                 90
1286499 1286499 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_12                         48.0 49.0                       97.0                         48 49                 97
1298538 1298538 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2017   grade_12                         57.0 39.0                       96.0                         57 39                 96
1757066 1757066 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2019   grade_12                         68.0 48.0                       116.0                         68 48                 116
1792857 1792857 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2018   grade_12                         49.0 47.0                       96.0                         49 47                 96
1912502 1912502 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2020   grade_12                         56.0 56.0                       112.0                         56 56                 112
1924452 1924452 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2021   grade_12                         46.0 58.0                       104.0                         46 58                 104
1164293 1164293 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_12                         33.0 53.0                       86.0                         33 53                 86
1285699 1285699 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_12                         50.0 52.0                       102.0                         50 52                 102
1297746 1297746 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_12                         44.0 44.0                       88.0                         44 44                 88
1756343 1756343 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2019   grade_12                         62.0 49.0                       111.0                         62 49                 111
1792105 1792105 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2018   grade_12                         54.0 60.0                       114.0                         54 60                 114
1911800 1911800 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2020   grade_12                         44.0 39.0                       83.0                         44 39                 83
1923768 1923768 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_12                         40.0 50.0                       90.0                         40 50                 90
1162516 1162516 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   grade_12                         230.0 210.0                       440.0                         230 210                 440
1283931 1283931 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2016   grade_12                         211.0 231.0                       442.0                         211 231                 442
1295967 1295967 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2017   grade_12                         229.0 242.0                       471.0                         229 242                 471
1754577 1754577 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2019   grade_12                         261.0 269.0                       530.0                         261 269                 530
1790317 1790317 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2018   grade_12                         276.0 270.0                       546.0                         276 270                 546
1910018 1910018 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2020   grade_12                         294.0 262.0                       556.0                         294 262                 556
1921973 1921973 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2021   grade_12                         300.0 264.0                       564.0                         300 264                 564
1170399 1170399 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High Sch   Regular School No 3.0 09 12 2015   grade_12                         31.0 43.0                       74.0                         31 43                 74
1291786 1291786 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No 3.0 09 12 2016   grade_12                         42.0 42.0                       84.0                         42 42                 84
1303811 1303811 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2017   grade_12                         46.0 38.0                       84.0                         46 38                 84
1762350 1762350 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2019   grade_12                         38.0 42.0                       80.0                         38 42                 80
1798133 1798133 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2018   grade_12                         50.0 39.0                       89.0                         50 39                 89
1917769 1917769 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2020   grade_12                         46.0 34.0                       80.0                         46 34                 80
1929697 1929697 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2021   grade_12                         43.0 31.0                       74.0                         43 31                 74
1160255 1160255 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_12                         71.0 59.0                       130.0                         71 59                 130
1281649 1281649 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         71.0 73.0                       144.0                         71 73                 144
1293705 1293705 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         73.0 54.0                       127.0                         73 54                 127
1752326 1752326 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         61.0 60.0                       121.0                         61 60                 121
1788073 1788073 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         70.0 58.0                       128.0                         70 58                 128
1907763 1907763 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2020   grade_12                         78.0 49.0                       127.0                         78 49                 127
1919730 1919730 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2021   grade_12                         79.0 61.0                       140.0                         79 61                 140
1170368 1170368 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_12                         36.0 30.0                       66.0                         36 30                 66
1291755 1291755 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         41.0 37.0                       78.0                         41 37                 78
1303779 1303779 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         33.0 36.0                       69.0                         33 36                 69
1762318 1762318 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         26.0 26.0                       52.0                         26 26                 52
1798101 1798101 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         21.0 27.0                       48.0                         21 27                 48
1917737 1917737 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2020   grade_12                         31.0 39.0                       70.0                         31 39                 70
1929665 1929665 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2021   grade_12                         44.0 39.0                       83.0                         44 39                 83
1167617 1167617 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2015   grade_12                         90.0 79.0                       169.0                         90 79                 169
1289015 1289015 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2016   grade_12                         74.0 80.0                       154.0                         74 80                 154
1301044 1301044 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2017   grade_12                         75.0 83.0                       158.0                         75 83                 158
1759535 1759535 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2019   grade_12                         79.0 84.0                       163.0                         79 84                 163
1795360 1795360 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2018   grade_12                         94.0 76.0                       170.0                         94 76                 170
1914945 1914945 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2020   grade_12                         88.0 70.0                       158.0                         88 70                 158
1926822 1926822 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2021   grade_12                         62.0 81.0                       143.0                         62 81                 143
1165472 1165472 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002328 5011 Lapel Sr High School   Regular School No 3.0 09 12 2015   grade_12                         73.0 47.0                       120.0                         73 47                 120
1286868 1286868 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002328 5011 Lapel Sr High School   Regular School No 3.0 09 12 2016   grade_12                         57.0 65.0                       122.0                         57 65                 122
1298904 1298904 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2017   grade_12                         61.0 58.0                       119.0                         61 58                 119
1757433 1757433 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2019   grade_12                         65.0 52.0                       117.0                         65 52                 117
1793225 1793225 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2018   grade_12                         72.0 53.0                       125.0                         72 53                 125
1912858 1912858 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2020   grade_12                         64.0 49.0                       113.0                         64 49                 113
1924779 1924779 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2021   grade_12                         64.0 44.0                       108.0                         64 44                 108
1165456 1165456 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_12                         63.0 54.0                       117.0                         63 54                 117
1286852 1286852 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         57.0 55.0                       112.0                         57 55                 112
1298888 1298888 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         64.0 51.0                       115.0                         64 51                 115
1757417 1757417 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         71.0 61.0                       132.0                         71 61                 132
1793209 1793209 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         60.0 55.0                       115.0                         60 55                 115
1912842 1912842 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2020   grade_12                         70.0 59.0                       129.0                         70 59                 129
1924763 1924763 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2021   grade_12                         59.0 58.0                       117.0                         59 58                 117
1169579 1169579 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_12                         73.0 88.0                       161.0                         73 88                 161
1290970 1290970 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_12                         83.0 84.0                       167.0                         83 84                 167
1302998 1302998 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2017   grade_12                         85.0 89.0                       174.0                         85 89                 174
1761498 1761498 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2019   grade_12                         95.0 104.0                       199.0                         95 104                 199
1797314 1797314 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2018   grade_12                         89.0 76.0                       165.0                         89 76                 165
1916905 1916905 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2020   grade_12                         109.0 72.0                       181.0                         109 72                 181
1928836 1928836 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2021   grade_12                         80.0 89.0                       169.0                         80 89                 169
1166262 1166262 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2015   grade_12                         33.0 54.0                       87.0                         33 54                 87
1287663 1287663 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2016   grade_12                         36.0 67.0                       103.0                         36 67                 103
1299701 1299701 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_12                         38.0 76.0                       114.0                         38 76                 114
1758239 1758239 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_12                         41.0 129.0                       170.0                         41 129                 170
1794029 1794029 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2018   grade_12                         41.0 94.0                       135.0                         41 94                 135
1913667 1913667 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_12                         71.0 110.0                       181.0                         71 110                 181
1925573 1925573 IN     school 1812810 5375   MSD Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2021   grade_12                         92.0 108.0                       200.0                         92 108                 200
1166275 1166275 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2015   grade_12                         43.0 61.0                       104.0                         43 61                 104
1287676 1287676 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2016   grade_12                         43.0 60.0                       103.0                         43 60                 103

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