enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,726 ✖
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 ▲
1910048 1910048 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2020   grade_5                         349.0 316.0                       665.0                         349 316                 665
1922003 1922003 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2021   grade_5                         355.0 284.0                       639.0                         355 284                 639
1754607 1754607 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2019   grade_5                         330.0 308.0                       638.0                         330 308                 638
1797144 1797144 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2018   grade_5                         317.0 316.0                       633.0                         317 316                 633
1790347 1790347 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2018   grade_5                         328.0 295.0                       623.0                         328 295                 623
1162436 1162436 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         334.0 284.0                       618.0                         334 284                 618
1162457 1162457 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate Sch   Regular School No 2.0 05 06 2015   grade_5                         323.0 283.0                       606.0                         323 283                 606
1761328 1761328 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2019   grade_5                         331.0 273.0                       604.0                         331 273                 604
1295996 1295996 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2017   grade_5                         311.0 278.0                       589.0                         311 278                 589
1162546 1162546 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         306.0 279.0                       585.0                         306 279                 585
1916735 1916735 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2020   grade_5                         302.0 275.0                       577.0                         302 275                 577
1302828 1302828 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2017   grade_5                         301.0 274.0                       575.0                         301 274                 575
1169415 1169415 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No 2.0 05 06 2015   grade_5                         303.0 266.0                       569.0                         303 266                 569
1928666 1928666 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2021   grade_5                         284.0 284.0                       568.0                         284 284                 568
1912938 1912938 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2020   grade_5                         276.0 253.0                       529.0                         276 253                 529
1283961 1283961 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         284.0 244.0                       528.0                         284 244                 528
1290800 1290800 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No 2.0 05 06 2016   grade_5                         263.0 262.0                       525.0                         263 262                 525
1756458 1756458 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2019   grade_5                         271.0 252.0                       523.0                         271 252                 523
1164425 1164425 IN     school 1809690 4600   Merrillville Community School 180969001581 3813 Merrillville Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         272.0 243.0                       515.0                         272 243                 515
1924863 1924863 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_5                         270.0 244.0                       514.0                         270 244                 514
1163857 1163857 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate Sch   Regular School No 2.0 05 06 2015   grade_5                         275.0 236.0                       511.0                         275 236                 511
1909981 1909981 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2020   grade_5                         251.0 248.0                       499.0                         251 248                 499
1285263 1285263 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         258.0 240.0                       498.0                         258 240                 498
1283846 1283846 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         262.0 234.0                       496.0                         262 234                 496
1162482 1162482 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         256.0 239.0                       495.0                         256 239                 495
1790228 1790228 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2018   grade_5                         260.0 229.0                       489.0                         260 229                 489
1283897 1283897 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         246.0 241.0                       487.0                         246 241                 487
1790250 1790250 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2018   grade_5                         221.0 253.0                       474.0                         221 253                 474
1754489 1754489 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2019   grade_5                         249.0 223.0                       472.0                         249 223                 472
1909924 1909924 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2020   grade_5                         250.0 221.0                       471.0                         250 221                 471
1912679 1912679 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Intermediate School   Regular School No Middle 05 06 2020   grade_5                         251.0 218.0                       469.0                         251 218                 469
1295881 1295881 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2017   grade_5                         250.0 217.0                       467.0                         250 217                 467
1924629 1924629 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Intermediate School   Regular School No Middle 05 06 2021   grade_5                         247.0 220.0                       467.0                         247 220                 467
1790280 1790280 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2018   grade_5                         234.0 228.0                       462.0                         234 228                 462
1295932 1295932 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2017   grade_5                         232.0 229.0                       461.0                         232 229                 461
1921906 1921906 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2021   grade_5                         228.0 231.0                       459.0                         228 231                 459
1923874 1923874 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2021   grade_5                         204.0 253.0                       457.0                         204 253                 457
1754540 1754540 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2019   grade_5                         240.0 216.0                       456.0                         240 216                 456
1921937 1921937 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2021   grade_5                         214.0 241.0                       455.0                         214 241                 455
1297861 1297861 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2017   grade_5                         244.0 210.0                       454.0                         244 210                 454
1285812 1285812 IN     school 1809690 4600   Merrillville Community School 180969001581 3813 Merrillville Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         230.0 223.0                       453.0                         230 223                 453
1792222 1792222 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2018   grade_5                         222.0 230.0                       452.0                         222 230                 452
1909951 1909951 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2020   grade_5                         215.0 237.0                       452.0                         215 237                 452
1756017 1756017 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 04 06 2019   grade_5                         211.0 239.0                       450.0                         211 239                 450
1911905 1911905 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2020   grade_5                         215.0 225.0                       440.0                         215 225                 440
1753584 1753584 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 06 2019   grade_5                         224.0 215.0                       439.0                         224 215                 439
1927602 1927602 IN     school 1811730 6795   Union School Corporation 181173002654 7122 Indiana Digital Elementary   Regular School No Elementary KG 06 2021   grade_5                         240.0 197.0                       437.0                         240 197                 437
1294978 1294978 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Elementary 04 07 2017   grade_5                         218.0 216.0                       434.0                         218 216                 434
1753976 1753976 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2019   grade_5                         215.0 214.0                       429.0                         215 214                 429
1295902 1295902 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2017   grade_5                         218.0 201.0                       419.0                         218 201                 419
1789321 1789321 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 06 2018   grade_5                         229.0 186.0                       415.0                         229 186                 415
1295369 1295369 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2017   grade_5                         210.0 201.0                       411.0                         210 201                 411
1920984 1920984 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_5                         209.0 198.0                       407.0                         209 198                 407
1921364 1921364 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2021   grade_5                         199.0 205.0                       404.0                         199 205                 404
1789712 1789712 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2018   grade_5                         213.0 188.0                       401.0                         213 188                 401
1283867 1283867 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate Sch   Regular School No 2.0 05 06 2016   grade_5                         190.0 209.0                       399.0                         190 209                 399
1910552 1910552 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2020   grade_5                         206.0 193.0                       399.0                         206 193                 399
1282941 1282941 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No 2.0 04 07 2016   grade_5                         197.0 199.0                       396.0                         197 199                 396
1283326 1283326 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No 2.0 05 08 2016   grade_5                         200.0 196.0                       396.0                         200 196                 396
1925010 1925010 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375001677 5207 Lillie Idella Kitley Intermediate   Regular School No Middle 04 06 2021   grade_5                         213.0 183.0                       396.0                         213 183                 396
1909014 1909014 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 05 07 2020   grade_5                         207.0 187.0                       394.0                         207 187                 394
1297421 1297421 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2017   grade_5                         194.0 199.0                       393.0                         194 199                 393
1754510 1754510 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2019   grade_5                         203.0 186.0                       389.0                         203 186                 389
1790844 1790844 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2018   grade_5                         192.0 197.0                       389.0                         192 197                 389
1925014 1925014 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002437 5210 Edgewood Intermediate School   Regular School No Elementary PK 06 2021   grade_5                         199.0 186.0                       385.0                         199 186                 385
1921878 1921878 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2021   grade_5                         198.0 186.0                       384.0                         198 186                 384
1163969 1163969 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         189.0 194.0                       383.0                         189 194                 383
1922502 1922502 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2021   grade_5                         190.0 192.0                       382.0                         190 192                 382
1909402 1909402 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2020   grade_5                         193.0 188.0                       381.0                         193 188                 381
1910555 1910555 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 06 2020   grade_5                         198.0 183.0                       381.0                         198 183                 381
1163048 1163048 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2015   grade_5                         200.0 179.0                       379.0                         200 179                 379
1285375 1285375 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         194.0 184.0                       378.0                         194 184                 378
1284453 1284453 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2016   grade_5                         210.0 166.0                       376.0                         210 166                 376
1911466 1911466 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2020   grade_5                         203.0 173.0                       376.0                         203 173                 376
1923432 1923432 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2021   grade_5                         208.0 166.0                       374.0                         208 166                 374
1755110 1755110 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 04 06 2019   grade_5                         208.0 162.0                       370.0                         208 162                 370
1755106 1755106 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2019   grade_5                         209.0 158.0                       367.0                         209 158                 367
1789367 1789367 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Elementary 04 05 2018   grade_5                         204.0 162.0                       366.0                         204 162                 366
1754521 1754521 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2019   grade_5                         202.0 162.0                       364.0                         202 162                 364
1295025 1295025 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Elementary 03 05 2017   grade_5                         181.0 182.0                       363.0                         181 182                 363
1930813 1930813 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_5                         201.0 162.0                       363.0                         201 162                 363
1790847 1790847 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 06 2018   grade_5                         180.0 182.0                       362.0                         180 182                 362
1161541 1161541 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No 1.0 03 06 2015   grade_5                         190.0 171.0                       361.0                         190 171                 361
1753629 1753629 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Middle 04 06 2019   grade_5                         181.0 179.0                       360.0                         181 179                 360
1282986 1282986 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No 2.0 04 05 2016   grade_5                         187.0 170.0                       357.0                         187 170                 357
1296495 1296495 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Elementary 04 06 2017   grade_5                         198.0 159.0                       357.0                         198 159                 357
1161915 1161915 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No 2.0 05 08 2015   grade_5                         184.0 170.0                       354.0                         184 170                 354
1791777 1791777 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2018   grade_5                         168.0 185.0                       353.0                         168 185                 353
1909060 1909060 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Elementary 03 05 2020   grade_5                         180.0 173.0                       353.0                         180 173                 353
1161587 1161587 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No 1.0 03 05 2015   grade_5                         171.0 181.0                       352.0                         171 181                 352
1922505 1922505 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 07 2021   grade_5                         179.0 172.0                       351.0                         179 172                 351
1296491 1296491 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2017   grade_5                         198.0 149.0                       347.0                         198 149                 347
1163051 1163051 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 05 06 2015   grade_5                         179.0 165.0                       344.0                         179 165                 344
1284457 1284457 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 04 06 2016   grade_5                         164.0 180.0                       344.0                         164 180                 344
1759318 1759318 IN     school 1806510 5925   M S D Martinsville Schools 180651002612 6334 Bell Intermediate Academy   Regular School No Middle 05 06 2019   grade_5                         191.0 149.0                       340.0                         191 149                 340
1793846 1793846 IN     school 1812360 5360   M S D Warren Township 181236002479 5402 Raymond Park Intermediate   Regular School No Middle 05 06 2018   grade_5                         187.0 151.0                       338.0                         187 151                 338
1795134 1795134 IN     school 1806510 5925   M S D Martinsville Schools 180651002612 6334 Bell Intermediate Academy   Regular School No Middle 05 06 2018   grade_5                         167.0 166.0                       333.0                         167 166                 333
1758054 1758054 IN     school 1812360 5360   M S D Warren Township 181236002477 5401 Stonybrook Intermediate Academy   Regular School No Middle 05 06 2019   grade_5                         170.0 162.0                       332.0                         170 162                 332
1914733 1914733 IN     school 1806510 5925   M S D Martinsville Schools 180651002612 6334 Bell Intermediate Academy   Regular School No Middle 05 06 2020   grade_5                         174.0 157.0                       331.0                         174 157                 331
1295913 1295913 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2017   grade_5                         156.0 167.0                       323.0                         156 167                 323

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