enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by male_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,528 ✖
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
1924982 1924982 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Central Junior High   Regular School No Middle 07 08 2021   grade_8                         431.0 406.0                       837.0                         431 406                 837
1913558 1913558 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2020   grade_8                         380.0 307.0                       687.0                         380 307                 687
1925141 1925141 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2021   grade_8                         356.0 284.0                       640.0                         356 284                 640
1758134 1758134 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2019   grade_8                         349.0 309.0                       658.0                         349 309                 658
1790305 1790305 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2018   grade_8                         348.0 313.0                       661.0                         348 313                 661
1925073 1925073 IN     school 1805670 5330   MSD Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2021   grade_8                         347.0 346.0                       693.0                         347 346                 693
1913164 1913164 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2020   grade_8                         344.0 357.0                       701.0                         344 357                 701
1925469 1925469 IN     school 1812810 5375   MSD Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2021   grade_8                         340.0 329.0                       669.0                         340 329                 669
1793535 1793535 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 06 08 2018   grade_8                         339.0 281.0                       620.0                         339 281                 620
1910006 1910006 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2020   grade_8                         335.0 301.0                       636.0                         335 301                 636
1921961 1921961 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_8                         334.0 307.0                       641.0                         334 307                 641
1757745 1757745 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2019   grade_8                         331.0 339.0                       670.0                         331 339                 670
1793493 1793493 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2018   grade_8                         328.0 275.0                       603.0                         328 275                 603
1925138 1925138 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2021   grade_8                         328.0 289.0                       617.0                         328 289                 617
1913123 1913123 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2020   grade_8                         326.0 277.0                       603.0                         326 277                 603
1793924 1793924 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2018   grade_8                         325.0 301.0                       626.0                         325 301                 626
1793927 1793927 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2018   grade_8                         325.0 273.0                       598.0                         325 273                 598
1299166 1299166 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 06 08 2017   grade_8                         321.0 269.0                       590.0                         321 269                 590
1166160 1166160 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No 2.0 07 08 2015   grade_8                         320.0 313.0                       633.0                         320 313                 633
1913232 1913232 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2020   grade_8                         319.0 294.0                       613.0                         319 294                 613
1165730 1165730 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2015   grade_8                         317.0 278.0                       595.0                         317 278                 595
1287233 1287233 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2016   grade_8                         317.0 264.0                       581.0                         317 264                 581
1166157 1166157 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No 2.0 07 08 2015   grade_8                         316.0 269.0                       585.0                         316 269                 585
1793600 1793600 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2018   grade_8                         316.0 324.0                       640.0                         316 324                 640
1913561 1913561 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2020   grade_8                         316.0 318.0                       634.0                         316 318                 634
1754565 1754565 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2019   grade_8                         315.0 278.0                       593.0                         315 278                 593
1757813 1757813 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2019   grade_8                         315.0 279.0                       594.0                         315 279                 594
1299269 1299269 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2017   grade_8                         310.0 265.0                       575.0                         310 265                 575
1165836 1165836 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2015   grade_8                         309.0 313.0                       622.0                         309 313                 622
1299599 1299599 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2017   grade_8                         309.0 280.0                       589.0                         309 280                 589
1930816 1930816 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_8                         308.0 358.0                       666.0                         308 358                 666
1287126 1287126 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2016   grade_8                         307.0 287.0                       594.0                         307 287                 594
1757810 1757810 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2019   grade_8                         305.0 259.0                       564.0                         305 259                 564
1165771 1165771 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         302.0 309.0                       611.0                         302 309                 611
1927611 1927611 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No High 07 12 2021   grade_8                         300.0 303.0                       603.0                         300 303                 603
1928670 1928670 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2021   grade_8                         300.0 291.0                       591.0                         300 291                 591
1913229 1913229 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2020   grade_8                         299.0 261.0                       560.0                         299 261                 560
1283920 1283920 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   grade_8                         297.0 257.0                       554.0                         297 257                 554
1916739 1916739 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2020   grade_8                         297.0 279.0                       576.0                         297 279                 576
1925032 1925032 IN     school 1805670 5330   MSD Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2021   grade_8                         297.0 262.0                       559.0                         297 262                 559
1299207 1299207 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2017   grade_8                         296.0 318.0                       614.0                         296 318                 614
1757704 1757704 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2019   grade_8                         296.0 305.0                       601.0                         296 305                 601
1287559 1287559 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No 2.0 07 08 2016   grade_8                         295.0 264.0                       559.0                         295 264                 559
1287562 1287562 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No 2.0 07 08 2016   grade_8                         294.0 328.0                       622.0                         294 328                 622
1797148 1797148 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2018   grade_8                         294.0 264.0                       558.0                         294 264                 558
1924938 1924938 IN     school 1802640 5300   MSD Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2021   grade_8                         294.0 256.0                       550.0                         294 256                 550
1758137 1758137 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2019   grade_8                         292.0 262.0                       554.0                         292 262                 554
1162466 1162466 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton Southeastern Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         291.0 320.0                       611.0                         291 320                 611
1295955 1295955 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 07 08 2017   grade_8                         290.0 272.0                       562.0                         290 272                 562
1792220 1792220 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2018   grade_8                         286.0 257.0                       543.0                         286 257                 543
1299272 1299272 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2017   grade_8                         284.0 297.0                       581.0                         284 297                 581
1793597 1793597 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2018   grade_8                         284.0 277.0                       561.0                         284 277                 561
1165568 1165568 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_8                         282.0 212.0                       494.0                         282 212                 494
1283884 1283884 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No 2.0 07 08 2016   grade_8                         282.0 233.0                       515.0                         282 233                 515
1287167 1287167 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No 2.0 07 08 2016   grade_8                         281.0 304.0                       585.0                         281 304                 585
1923322 1923322 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2021   grade_8                         281.0 256.0                       537.0                         281 256                 537
1925472 1925472 IN     school 1812810 5375   MSD Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2021   grade_8                         281.0 304.0                       585.0                         281 304                 585
1918827 1918827 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2020   grade_8                         278.0 303.0                       581.0                         278 303                 581
1913014 1913014 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2020   grade_8                         277.0 251.0                       528.0                         277 251                 528
1164423 1164423 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2015   grade_8                         274.0 258.0                       532.0                         274 258                 532
1759832 1759832 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No Middle 07 08 2019   grade_8                         274.0 214.0                       488.0                         274 214                 488
1161780 1161780 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_8                         273.0 240.0                       513.0                         273 240                 513
1287230 1287230 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2016   grade_8                         272.0 259.0                       531.0                         272 259                 531
1757596 1757596 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2019   grade_8                         272.0 240.0                       512.0                         272 240                 512
1162434 1162434 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No 2.0 07 08 2015   grade_8                         271.0 249.0                       520.0                         271 249                 520
1169419 1169419 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         271.0 267.0                       538.0                         271 267                 538
1295919 1295919 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2017   grade_8                         271.0 241.0                       512.0                         271 241                 512
1755913 1755913 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2019   grade_8                         271.0 246.0                       517.0                         271 246                 517
1922187 1922187 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2021   grade_8                         271.0 240.0                       511.0                         271 240                 511
1285810 1285810 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2016   grade_8                         270.0 285.0                       555.0                         270 285                 555
1286963 1286963 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_8                         270.0 251.0                       521.0                         270 251                 521
1289322 1289322 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No 2.0 07 08 2016   grade_8                         270.0 231.0                       501.0                         270 231                 501
1290804 1290804 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High Sch   Regular School No 2.0 07 08 2016   grade_8                         270.0 286.0                       556.0                         270 286                 556
1297318 1297318 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2017   grade_8                         270.0 241.0                       511.0                         270 241                 511
1754487 1754487 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2019   grade_8                         270.0 238.0                       508.0                         270 238                 508
1790226 1790226 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2018   grade_8                         269.0 256.0                       525.0                         269 256                 525
1909267 1909267 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2020   grade_8                         269.0 236.0                       505.0                         269 236                 505
1285277 1285277 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No 2.0 07 08 2016   grade_8                         268.0 222.0                       490.0                         268 222                 490
1916992 1916992 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002504 8230 North Junior High School   Regular School No Middle 07 08 2020   grade_8                         268.0 271.0                       539.0                         268 271                 539
1763401 1763401 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_8                         265.0 337.0                       602.0                         265 337                 602
1165833 1165833 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2015   grade_8                         264.0 265.0                       529.0                         264 265                 529
1163871 1163871 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         263.0 233.0                       496.0                         263 233                 496
1761332 1761332 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2019   grade_8                         263.0 264.0                       527.0                         263 264                 527
1790267 1790267 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2018   grade_8                         263.0 248.0                       511.0                         263 248                 511
1791675 1791675 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2018   grade_8                         263.0 244.0                       507.0                         263 244                 507
1795660 1795660 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No Middle 07 08 2018   grade_8                         263.0 243.0                       506.0                         263 243                 506
1911356 1911356 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2020   grade_8                         263.0 266.0                       529.0                         263 266                 529
1295232 1295232 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Other 06 11 2017   grade_8                         262.0 212.0                       474.0                         262 212                 474
1753838 1753838 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_8                         262.0 263.0                       525.0                         262 263                 525
1921239 1921239 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2021   grade_8                         262.0 267.0                       529.0                         262 267                 529
1754641 1754641 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No Middle 06 08 2019   grade_8                         261.0 233.0                       494.0                         261 233                 494
1910115 1910115 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2020   grade_8                         260.0 232.0                       492.0                         260 232                 492
1924881 1924881 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2021   grade_8                         260.0 236.0                       496.0                         260 236                 496
1793387 1793387 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2018   grade_8                         259.0 226.0                       485.0                         259 226                 485
1297859 1297859 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2017   grade_8                         256.0 241.0                       497.0                         256 241                 497
1299596 1299596 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2017   grade_8                         256.0 318.0                       574.0                         256 318                 574
1287025 1287025 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle Sch   Regular School No 2.0 07 08 2016   grade_8                         254.0 229.0                       483.0                         254 229                 483
1915241 1915241 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No Middle 07 08 2020   grade_8                         253.0 236.0                       489.0                         253 236                 489
1302832 1302832 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2017   grade_8                         252.0 229.0                       481.0                         252 229                 481
1754792 1754792 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2019   grade_8                         252.0 206.0                       458.0                         252 206                 458

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