enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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 ▲
1925135 1925135 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No Middle 06 06 2021   grade_6                         339.0 329.0                       668.0                         339 329                 668
1925133 1925133 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No Middle 06 06 2021   grade_6                         321.0 339.0                       660.0                         321 339                 660
1922004 1922004 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2021   grade_6                         347.0 312.0                       659.0                         347 312                 659
1793594 1793594 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No Middle 06 06 2018   grade_6                         338.0 308.0                       646.0                         338 308                 646
1913226 1913226 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No Middle 06 06 2020   grade_6                         320.0 324.0                       644.0                         320 324                 644
1910049 1910049 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2020   grade_6                         327.0 309.0                       636.0                         327 309                 636
1757807 1757807 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No Middle 06 06 2019   grade_6                         345.0 280.0                       625.0                         345 280                 625
1761329 1761329 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2019   grade_6                         325.0 298.0                       623.0                         325 298                 623
1754608 1754608 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2019   grade_6                         319.0 300.0                       619.0                         319 300                 619
1283962 1283962 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         319.0 296.0                       615.0                         319 296                 615
1911354 1911354 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2020   grade_6                         330.0 285.0                       615.0                         330 285                 615
1162458 1162458 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate Sch   Regular School No 2.0 05 06 2015   grade_6                         317.0 296.0                       613.0                         317 296                 613
1790348 1790348 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2018   grade_6                         311.0 292.0                       603.0                         311 292                 603
1757805 1757805 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No Middle 06 06 2019   grade_6                         325.0 275.0                       600.0                         325 275                 600
1287227 1287227 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No 2.0 06 06 2016   grade_6                         291.0 307.0                       598.0                         291 307                 598
1916736 1916736 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2020   grade_6                         330.0 264.0                       594.0                         330 264                 594
1797145 1797145 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2018   grade_6                         312.0 275.0                       587.0                         312 275                 587
1913224 1913224 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No Middle 06 06 2020   grade_6                         319.0 263.0                       582.0                         319 263                 582
1299266 1299266 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No Middle 06 06 2017   grade_6                         313.0 265.0                       578.0                         313 265                 578
1165830 1165830 IN     school 1808820 5340   Perry Township Schools 180882002119 5312 Perry Meridian 6th Grade Academy   Regular School No 2.0 06 06 2015   grade_6                         288.0 281.0                       569.0                         288 281                 569
1793592 1793592 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No Middle 06 06 2018   grade_6                         303.0 258.0                       561.0                         303 258                 561
1928667 1928667 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2021   grade_6                         295.0 265.0                       560.0                         295 265                 560
1287225 1287225 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No 2.0 06 06 2016   grade_6                         296.0 262.0                       558.0                         296 262                 558
1912680 1912680 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Intermediate School   Regular School No Middle 05 06 2020   grade_6                         283.0 275.0                       558.0                         283 275                 558
1290801 1290801 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No 2.0 05 06 2016   grade_6                         295.0 260.0                       555.0                         295 260                 555
1923320 1923320 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2021   grade_6                         289.0 266.0                       555.0                         289 266                 555
1285813 1285813 IN     school 1809690 4600   Merrillville Community School 180969001581 3813 Merrillville Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         286.0 265.0                       551.0                         286 265                 551
1757533 1757533 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   grade_6                         287.0 262.0                       549.0                         287 262                 549
1295230 1295230 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Other 06 11 2017   grade_6                         276.0 270.0                       546.0                         276 270                 546
1165828 1165828 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No 2.0 06 06 2015   grade_6                         301.0 244.0                       545.0                         301 244                 545
1911906 1911906 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2020   grade_6                         272.0 273.0                       545.0                         272 273                 545
1295997 1295997 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2017   grade_6                         282.0 261.0                       543.0                         282 261                 543
1912939 1912939 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2020   grade_6                         282.0 261.0                       543.0                         282 261                 543
1162654 1162654 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No 2.0 06 08 2015   grade_6                         259.0 282.0                       541.0                         259 282                 541
1299264 1299264 IN     school 1808820 5340   Perry Township Schools 180882002115 5310 Southport 6th Grade Academy   Regular School No Middle 06 06 2017   grade_6                         277.0 264.0                       541.0                         277 264                 541
1162547 1162547 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         271.0 268.0                       539.0                         271 268                 539
1753836 1753836 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_6                         268.0 271.0                       539.0                         268 271                 539
1755911 1755911 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2019   grade_6                         274.0 262.0                       536.0                         274 262                 536
1791673 1791673 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2018   grade_6                         264.0 267.0                       531.0                         264 267                 531
1921237 1921237 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2021   grade_6                         278.0 252.0                       530.0                         278 252                 530
1162437 1162437 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         275.0 251.0                       526.0                         275 251                 526
1909265 1909265 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2020   grade_6                         258.0 266.0                       524.0                         258 266                 524
1283847 1283847 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         282.0 240.0                       522.0                         282 240                 522
1789574 1789574 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_6                         264.0 253.0                       517.0                         264 253                 517
1297316 1297316 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2017   grade_6                         264.0 249.0                       513.0                         264 249                 513
1924864 1924864 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_6                         276.0 235.0                       511.0                         276 235                 511
1283898 1283898 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         262.0 248.0                       510.0                         262 248                 510
1793323 1793323 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   grade_6                         258.0 252.0                       510.0                         258 252                 510
1302829 1302829 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2017   grade_6                         259.0 250.0                       509.0                         259 250                 509
1913058 1913058 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Township Middle Schl East   Regular School No Middle 06 08 2020   grade_6                         265.0 244.0                       509.0                         265 244                 509
1295882 1295882 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2017   grade_6                         266.0 237.0                       503.0                         266 237                 503
1754790 1754790 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2019   grade_6                         263.0 239.0                       502.0                         263 239                 502
1910231 1910231 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2020   grade_6                         254.0 246.0                       500.0                         254 246                 500
1285264 1285264 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         271.0 227.0                       498.0                         271 227                 498
1298996 1298996 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   grade_6                         268.0 227.0                       495.0                         268 227                 495
1163858 1163858 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate Sch   Regular School No 2.0 05 06 2015   grade_6                         248.0 244.0                       492.0                         248 244                 492
1909982 1909982 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2020   grade_6                         260.0 232.0                       492.0                         260 232                 492
1164426 1164426 IN     school 1809690 4600   Merrillville Community School 180969001581 3813 Merrillville Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         253.0 238.0                       491.0                         253 238                 491
1169416 1169416 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No 2.0 05 06 2015   grade_6                         255.0 236.0                       491.0                         255 236                 491
1754490 1754490 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2019   grade_6                         258.0 232.0                       490.0                         258 232                 490
1930814 1930814 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_6                         258.0 232.0                       490.0                         258 232                 490
1162483 1162483 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         261.0 228.0                       489.0                         261 228                 489
1295933 1295933 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2017   grade_6                         246.0 242.0                       488.0                         246 242                 488
1921879 1921879 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2021   grade_6                         264.0 223.0                       487.0                         264 223                 487
1283189 1283189 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2016   grade_6                         241.0 245.0                       486.0                         241 245                 486
1790229 1790229 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2018   grade_6                         253.0 233.0                       486.0                         253 233                 486
1757641 1757641 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Township Middle Schl East   Regular School No Middle 06 08 2019   grade_6                         251.0 234.0                       485.0                         251 234                 485
1754511 1754511 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2019   grade_6                         227.0 257.0                       484.0                         227 257                 484
1161778 1161778 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_6                         261.0 222.0                       483.0                         261 222                 483
1909925 1909925 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2020   grade_6                         257.0 225.0                       482.0                         257 225                 482
1792223 1792223 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2018   grade_6                         257.0 222.0                       479.0                         257 222                 479
1284027 1284027 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No 2.0 06 08 2016   grade_6                         241.0 236.0                       477.0                         241 236                 477
1921938 1921938 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2021   grade_6                         237.0 240.0                       477.0                         237 240                 477
1756459 1756459 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2019   grade_6                         234.0 240.0                       474.0                         234 240                 474
1790281 1790281 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2018   grade_6                         235.0 235.0                       470.0                         235 235                 470
1755197 1755197 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2019   grade_6                         244.0 224.0                       468.0                         244 224                 468
1296028 1296028 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No Middle 06 08 2017   grade_6                         243.0 223.0                       466.0                         243 223                 466
1790412 1790412 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2018   grade_6                         243.0 222.0                       465.0                         243 222                 465
1922595 1922595 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2021   grade_6                         243.0 220.0                       463.0                         243 220                 463
1297862 1297862 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2017   grade_6                         236.0 226.0                       462.0                         236 226                 462
1921907 1921907 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2021   grade_6                         219.0 241.0                       460.0                         219 241                 460
1923875 1923875 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2021   grade_6                         228.0 230.0                       458.0                         228 230                 458
1754541 1754541 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2019   grade_6                         227.0 230.0                       457.0                         227 230                 457
1924630 1924630 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Intermediate School   Regular School No Middle 05 06 2021   grade_6                         248.0 208.0                       456.0                         248 208                 456
1754639 1754639 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No Middle 06 08 2019   grade_6                         233.0 222.0                       455.0                         233 222                 455
1922185 1922185 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2021   grade_6                         230.0 225.0                       455.0                         230 225                 455
1909952 1909952 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2020   grade_6                         248.0 206.0                       454.0                         248 206                 454
1927603 1927603 IN     school 1811730 6795   Union School Corporation 181173002654 7122 Indiana Digital Elementary   Regular School No Elementary KG 06 2021   grade_6                         235.0 218.0                       453.0                         235 218                 453
1284144 1284144 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No 2.0 06 08 2016   grade_6                         224.0 228.0                       452.0                         224 228                 452
1296582 1296582 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2017   grade_6                         220.0 229.0                       449.0                         220 229                 449
1165566 1165566 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_6                         234.0 214.0                       448.0                         234 214                 448
1754672 1754672 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2019   grade_6                         234.0 213.0                       447.0                         234 213                 447
1909015 1909015 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 05 07 2020   grade_6                         226.0 220.0                       446.0                         226 220                 446
1922471 1922471 IN     school 1801020 3305   Brownsburg Community School Corp 180102002086 2720 Brownsburg East Middle School   Regular School No Middle 06 08 2021   grade_6                         212.0 234.0                       446.0                         212 234                 446
1909403 1909403 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2020   grade_6                         217.0 226.0                       443.0                         217 226                 443
1910521 1910521 IN     school 1801020 3305   Brownsburg Community School Corp 180102002086 2720 Brownsburg East Middle School   Regular School No Middle 06 08 2020   grade_6                         243.0 200.0                       443.0                         243 200                 443
1283993 1283993 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No 2.0 06 08 2016   grade_6                         217.0 225.0                       442.0                         217 225                 442
1296178 1296178 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2017   grade_6                         243.0 197.0                       440.0                         243 197                 440
1753585 1753585 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 06 2019   grade_6                         239.0 201.0                       440.0                         239 201                 440
1286961 1286961 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_6                         228.0 211.0                       439.0                         228 211                 439

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