enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN" sorted by male_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,530 ✖
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
1924981 1924981 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Central Junior High   Regular School No Middle 07 08 2021   grade_7                         433.0 410.0                       843.0                         433 410                 843
1925072 1925072 IN     school 1805670 5330   MSD Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2021   grade_7                         360.0 337.0                       697.0                         360 337                 697
1925468 1925468 IN     school 1812810 5375   MSD Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No Middle 07 08 2021   grade_7                         360.0 316.0                       676.0                         360 316                 676
1913231 1913231 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2020   grade_7                         357.0 290.0                       647.0                         357 290                 647
1758133 1758133 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_7                         354.0 295.0                       649.0                         354 295                 649
1757744 1757744 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2019   grade_7                         346.0 355.0                       701.0                         346 355                 701
1295954 1295954 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 07 08 2017   grade_7                         345.0 307.0                       652.0                         345 307                 652
1913163 1913163 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2020   grade_7                         342.0 356.0                       698.0                         342 356                 698
1299206 1299206 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 07 08 2017   grade_7                         341.0 283.0                       624.0                         341 283                 624
1913228 1913228 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2020   grade_7                         339.0 282.0                       621.0                         339 282                 621
1910005 1910005 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2020   grade_7                         338.0 307.0                       645.0                         338 307                 645
1287561 1287561 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_7                         337.0 287.0                       624.0                         337 287                 624
1913557 1913557 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_7                         332.0 326.0                       658.0                         332 326                 658
1925471 1925471 IN     school 1812810 5375   MSD Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2021   grade_7                         332.0 299.0                       631.0                         332 299                 631
1923321 1923321 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2021   grade_7                         330.0 274.0                       604.0                         330 274                 604
1299598 1299598 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2017   grade_7                         329.0 294.0                       623.0                         329 294                 623
1757812 1757812 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2019   grade_7                         327.0 300.0                       627.0                         327 300                 627
1754564 1754564 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2019   grade_7                         326.0 294.0                       620.0                         326 294                 620
1928669 1928669 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2021   grade_7                         325.0 249.0                       574.0                         325 249                 574
1758136 1758136 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2019   grade_7                         324.0 315.0                       639.0                         324 315                 639
1793534 1793534 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 06 08 2018   grade_7                         324.0 330.0                       654.0                         324 330                 654
1925140 1925140 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2021   grade_7                         324.0 325.0                       649.0                         324 325                 649
1793923 1793923 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_7                         322.0 294.0                       616.0                         322 294                 616
1921960 1921960 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_7                         322.0 317.0                       639.0                         322 317                 639
1162465 1162465 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton Southeastern Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         317.0 310.0                       627.0                         317 310                 627
1757703 1757703 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2019   grade_7                         317.0 261.0                       578.0                         317 261                 578
1793599 1793599 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2018   grade_7                         314.0 276.0                       590.0                         314 276                 590
1924937 1924937 IN     school 1802640 5300   MSD Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2021   grade_7                         313.0 255.0                       568.0                         313 255                 568
1287125 1287125 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2016   grade_7                         311.0 257.0                       568.0                         311 257                 568
1925137 1925137 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2021   grade_7                         310.0 263.0                       573.0                         310 263                 573
1165835 1165835 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2015   grade_7                         307.0 265.0                       572.0                         307 265                 572
1299268 1299268 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2017   grade_7                         305.0 271.0                       576.0                         305 271                 576
1925031 1925031 IN     school 1805670 5330   MSD Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2021   grade_7                         304.0 269.0                       573.0                         304 269                 573
1299165 1299165 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 06 08 2017   grade_7                         301.0 265.0                       566.0                         301 265                 566
1793492 1793492 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2018   grade_7                         301.0 303.0                       604.0                         301 303                 604
1916738 1916738 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2020   grade_7                         301.0 301.0                       602.0                         301 301                 602
1299595 1299595 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_7                         300.0 297.0                       597.0                         300 297                 597
1299271 1299271 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No Middle 07 08 2017   grade_7                         299.0 322.0                       621.0                         299 322                 621
1913560 1913560 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2020   grade_7                         299.0 323.0                       622.0                         299 323                 622
1930815 1930815 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_7                         298.0 269.0                       567.0                         298 269                 567
1761331 1761331 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2019   grade_7                         296.0 276.0                       572.0                         296 276                 572
1297858 1297858 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2017   grade_7                         295.0 258.0                       553.0                         295 258                 553
1793596 1793596 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2018   grade_7                         295.0 274.0                       569.0                         295 274                 569
1165729 1165729 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2015   grade_7                         294.0 270.0                       564.0                         294 270                 564
1793926 1793926 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No Middle 07 08 2018   grade_7                         294.0 267.0                       561.0                         294 267                 561
1287166 1287166 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_7                         293.0 300.0                       593.0                         293 300                 593
1287229 1287229 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2016   grade_7                         291.0 267.0                       558.0                         291 267                 558
1790304 1790304 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2018   grade_7                         291.0 263.0                       554.0                         291 263                 554
1162504 1162504 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_7                         289.0 245.0                       534.0                         289 245                 534
1927610 1927610 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No High 07 12 2021   grade_7                         289.0 288.0                       577.0                         289 288                 577
1287232 1287232 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2016   grade_7                         287.0 293.0                       580.0                         287 293                 580
1302831 1302831 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High School   Regular School No Middle 07 08 2017   grade_7                         287.0 255.0                       542.0                         287 255                 542
1757809 1757809 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No Middle 07 08 2019   grade_7                         287.0 253.0                       540.0                         287 253                 540
1913013 1913013 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2020   grade_7                         287.0 258.0                       545.0                         287 258                 545
1913122 1913122 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2020   grade_7                         286.0 257.0                       543.0                         286 257                 543
1166159 1166159 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_7                         283.0 325.0                       608.0                         283 325                 608
1162433 1162433 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No 2.0 07 08 2015   grade_7                         276.0 276.0                       552.0                         276 276                 552
1295878 1295878 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2017   grade_7                         276.0 249.0                       525.0                         276 249                 525
1911355 1911355 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2020   grade_7                         276.0 265.0                       541.0                         276 265                 541
1283919 1283919 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2016   grade_7                         275.0 267.0                       542.0                         275 267                 542
1924652 1924652 IN     school 1805580 4945   LaPorte Community School Corp 180558002680 4742 LaPorte Middle School   Regular School No Middle 07 08 2021   grade_7                         275.0 266.0                       541.0                         275 266                 541
1795659 1795659 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No Middle 07 08 2018   grade_7                         274.0 206.0                       480.0                         274 206                 480
1789575 1789575 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_7                         273.0 271.0                       544.0                         273 271                 544
1165770 1165770 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_7                         271.0 277.0                       548.0                         271 277                 548
1297317 1297317 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2017   grade_7                         270.0 237.0                       507.0                         270 237                 507
1791674 1791674 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2018   grade_7                         270.0 249.0                       519.0                         270 249                 519
1793386 1793386 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2018   grade_7                         270.0 239.0                       509.0                         270 239                 509
1163870 1163870 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         269.0 223.0                       492.0                         269 223                 492
1283883 1283883 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No 2.0 07 08 2016   grade_7                         268.0 238.0                       506.0                         268 238                 506
1912955 1912955 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2020   grade_7                         268.0 231.0                       499.0                         268 231                 499
1910232 1910232 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2020   grade_7                         267.0 240.0                       507.0                         267 240                 507
1921922 1921922 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2021   grade_7                         267.0 234.0                       501.0                         267 234                 501
1753837 1753837 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_7                         266.0 244.0                       510.0                         266 244                 510
1165628 1165628 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         265.0 229.0                       494.0                         265 229                 494
1166156 1166156 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_7                         264.0 256.0                       520.0                         264 256                 520
1909266 1909266 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2020   grade_7                         264.0 274.0                       538.0                         264 274                 538
1285276 1285276 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No 2.0 07 08 2016   grade_7                         263.0 240.0                       503.0                         263 240                 503
1285809 1285809 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2016   grade_7                         263.0 241.0                       504.0                         263 241                 504
1295918 1295918 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2017   grade_7                         263.0 250.0                       513.0                         263 250                 513
1757595 1757595 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle School   Regular School No Middle 07 08 2019   grade_7                         263.0 254.0                       517.0                         263 254                 517
1790225 1790225 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2018   grade_7                         263.0 243.0                       506.0                         263 243                 506
1162468 1162468 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Jr High   Regular School No 2.0 07 08 2015   grade_7                         262.0 227.0                       489.0                         262 227                 489
1167923 1167923 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No 2.0 07 08 2015   grade_7                         260.0 219.0                       479.0                         260 219                 479
1164422 1164422 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2015   grade_7                         259.0 279.0                       538.0                         259 279                 538
1755912 1755912 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2019   grade_7                         259.0 267.0                       526.0                         259 267                 526
1922472 1922472 IN     school 1801020 3305   Brownsburg Community School Corp 180102002086 2720 Brownsburg East Middle School   Regular School No Middle 06 08 2021   grade_7                         259.0 218.0                       477.0                         259 218                 477
1165832 1165832 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2015   grade_7                         258.0 247.0                       505.0                         258 247                 505
1756455 1756455 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2019   grade_7                         258.0 215.0                       473.0                         258 215                 473
1910644 1910644 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2020   grade_7                         258.0 220.0                       478.0                         258 220                 478
1924880 1924880 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2021   grade_7                         258.0 249.0                       507.0                         258 249                 507
1301342 1301342 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No Middle 07 08 2017   grade_7                         256.0 245.0                       501.0                         256 245                 501
1761585 1761585 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002504 8230 North Junior High School   Regular School No Middle 07 08 2019   grade_7                         256.0 274.0                       530.0                         256 274                 530
1797400 1797400 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002504 8230 North Junior High School   Regular School No Middle 07 08 2018   grade_7                         256.0 252.0                       508.0                         256 252                 508
1913059 1913059 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Township Middle Schl East   Regular School No Middle 06 08 2020   grade_7                         256.0 236.0                       492.0                         256 236                 492
1162655 1162655 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No 2.0 06 08 2015   grade_7                         255.0 259.0                       514.0                         255 259                 514
1165567 1165567 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_7                         255.0 256.0                       511.0                         255 256                 511
1283190 1283190 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2016   grade_7                         254.0 212.0                       466.0                         254 212                 466
1754673 1754673 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2019   grade_7                         253.0 229.0                       482.0                         253 229                 482
1923871 1923871 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2021   grade_7                         253.0 264.0                       517.0                         253 264                 517
1290803 1290803 IN     school 1805400 7855   Lafayette School Corporation 180540000975 8077 Lafayette Tecumseh Jr High Sch   Regular School No 2.0 07 08 2016   grade_7                         252.0 222.0                       474.0                         252 222                 474

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