enrollments

Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by female_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,924 ✖
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
1754637 1754637 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2019   grade_9                         661.0 698.0                       1359.0                         661 698                 1359
1790377 1790377 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2018   grade_9                         629.0 683.0                       1312.0                         629 683                 1312
1910078 1910078 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2020   grade_9                         678.0 668.0                       1346.0                         678 668                 1346
1922033 1922033 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2021   grade_9                         695.0 641.0                       1336.0                         695 641                 1336
1296026 1296026 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2017   grade_9                         645.0 637.0                       1282.0                         645 637                 1282
1925466 1925466 IN     school 1812810 5375   MSD Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2021   grade_9                         706.0 631.0                       1337.0                         706 631                 1337
1287556 1287556 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No 4.0 09 09 2016   grade_9                         648.0 626.0                       1274.0                         648 626                 1274
1299593 1299593 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Other 09 09 2017   grade_9                         615.0 610.0                       1225.0                         615 610                 1225
1913555 1913555 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2020   grade_9                         664.0 606.0                       1270.0                         664 606                 1270
1793921 1793921 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2018   grade_9                         579.0 599.0                       1178.0                         579 599                 1178
1283991 1283991 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2016   grade_9                         690.0 598.0                       1288.0                         690 598                 1288
1162576 1162576 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   grade_9                         586.0 591.0                       1177.0                         586 591                 1177
1758131 1758131 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2019   grade_9                         672.0 591.0                       1263.0                         672 591                 1263
1166154 1166154 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No 4.0 09 09 2015   grade_9                         592.0 562.0                       1154.0                         592 562                 1154
1913549 1913549 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2020   grade_9                         488.0 509.0                       997.0                         488 509                 997
1287550 1287550 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No 3.0 09 12 2016   grade_9                         478.0 505.0                       983.0                         478 505                 983
1758125 1758125 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2019   grade_9                         474.0 499.0                       973.0                         474 499                 973
1287409 1287409 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No 3.0 09 12 2016   grade_9                         502.0 498.0                       1000.0                         502 498                 1000
1757984 1757984 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2019   grade_9                         479.0 482.0                       961.0                         479 482                 961
1166148 1166148 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No 3.0 09 12 2015   grade_9                         491.0 477.0                       968.0                         491 477                 968
1921915 1921915 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2021   grade_9                         448.0 475.0                       923.0                         448 475                 923
1754519 1754519 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2019   grade_9                         477.0 473.0                       950.0                         477 473                 950
1162463 1162463 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No 3.0 09 12 2015   grade_9                         397.0 470.0                       867.0                         397 470                 867
1299446 1299446 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2017   grade_9                         514.0 467.0                       981.0                         514 467                 981
1913336 1913336 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No High 09 12 2020   grade_9                         438.0 467.0                       905.0                         438 467                 905
1925460 1925460 IN     school 1812720 5370   MSD Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2021   grade_9                         492.0 463.0                       955.0                         492 463                 955
1165939 1165939 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No 3.0 09 12 2015   grade_9                         411.0 461.0                       872.0                         411 461                 872
1921153 1921153 IN     school 1803270 2305   Elkhart Community Schools 180327002693 1754 Elkhart High School   Regular School No High 09 12 2021   grade_9                         449.0 461.0                       910.0                         449 461                 910
1299587 1299587 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2017   grade_9                         486.0 460.0                       946.0                         486 460                 946
1925314 1925314 IN     school 1812360 5360   MSD Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2021   grade_9                         482.0 458.0                       940.0                         482 458                 940
1793773 1793773 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2018   grade_9                         509.0 452.0                       961.0                         509 452                 961
1909960 1909960 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2020   grade_9                         482.0 452.0                       934.0                         482 452                 934
1913403 1913403 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2020   grade_9                         482.0 452.0                       934.0                         482 452                 934
1168612 1168612 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   grade_9                         438.0 445.0                       883.0                         438 445                 883
1793915 1793915 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2018   grade_9                         493.0 444.0                       937.0                         493 444                 937
1909979 1909979 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2020   grade_9                         419.0 441.0                       860.0                         419 441                 860
1289999 1289999 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2016   grade_9                         430.0 438.0                       868.0                         430 438                 868
1925247 1925247 IN     school 1808910 5350   MSD Pike Township 180891001489 5353 Pike High School   Regular School No High 09 12 2021   grade_9                         482.0 436.0                       918.0                         482 436                 918
1295911 1295911 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2017   grade_9                         418.0 435.0                       853.0                         418 435                 853
1757917 1757917 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No High 09 12 2019   grade_9                         478.0 431.0                       909.0                         478 431                 909
1921935 1921935 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2021   grade_9                         428.0 431.0                       859.0                         428 431                 859
1287341 1287341 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No 3.0 09 12 2016   grade_9                         448.0 430.0                       878.0                         448 430                 878
1283876 1283876 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No 3.0 09 12 2016   grade_9                         398.0 429.0                       827.0                         398 429                 827
1166007 1166007 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No 3.0 09 12 2015   grade_9                         521.0 428.0                       949.0                         521 428                 949
1927870 1927870 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2021   grade_9                         448.0 423.0                       871.0                         448 423                 871
1760534 1760534 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2019   grade_9                         418.0 422.0                       840.0                         418 422                 840
1796342 1796342 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2018   grade_9                         428.0 421.0                       849.0                         428 421                 849
1793706 1793706 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No High 09 12 2018   grade_9                         429.0 419.0                       848.0                         429 419                 848
1285855 1285855 IN     school 1805450 4615   Lake Central School Corp 180545000984 3833 Lake Central High School   Regular School No 3.0 09 12 2016   grade_9                         406.0 418.0                       824.0                         406 418                 824
1755143 1755143 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2019   grade_9                         420.0 418.0                       838.0                         420 418                 838
1790259 1790259 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2018   grade_9                         469.0 414.0                       883.0                         469 414                 883
1295930 1295930 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2017   grade_9                         425.0 411.0                       836.0                         425 411                 836
1915945 1915945 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2020   grade_9                         458.0 408.0                       866.0                         458 408                 866
1922132 1922132 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No High 09 12 2021   grade_9                         424.0 408.0                       832.0                         424 408                 832
1164468 1164468 IN     school 1805450 4615   Lake Central School Corp 180545000984 3833 Lake Central High School   Regular School No 3.0 09 12 2015   grade_9                         412.0 405.0                       817.0                         412 405                 817
1162480 1162480 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No 3.0 09 12 2015   grade_9                         401.0 404.0                       805.0                         401 404                 805
1754736 1754736 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No High 09 12 2019   grade_9                         403.0 402.0                       805.0                         403 402                 805
1756502 1756502 IN     school 1805450 4615   Lake Central School Corporation 180545000984 3833 Lake Central High School   Regular School No High 09 12 2019   grade_9                         425.0 402.0                       827.0                         425 402                 827
1792267 1792267 IN     school 1805450 4615   Lake Central School Corporation 180545000984 3833 Lake Central High School   Regular School No High 09 12 2018   grade_9                         423.0 402.0                       825.0                         423 402                 825
1299379 1299379 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No High 09 12 2017   grade_9                         459.0 401.0                       860.0                         459 401                 860
1913049 1913049 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No High 09 12 2020   grade_9                         358.0 401.0                       759.0                         358 401                 759
1284489 1284489 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2016   grade_9                         409.0 399.0                       808.0                         409 399                 808
1910588 1910588 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2020   grade_9                         427.0 395.0                       822.0                         427 395                 822
1924974 1924974 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No High 09 12 2021   grade_9                         422.0 395.0                       817.0                         422 395                 817
1283895 1283895 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No 3.0 09 12 2016   grade_9                         391.0 389.0                       780.0                         391 389                 780
1790278 1790278 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2018   grade_9                         411.0 389.0                       800.0                         411 389                 800
1754538 1754538 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2019   grade_9                         440.0 387.0                       827.0                         440 387                 827
1756635 1756635 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 09 12 2019   grade_9                         348.0 387.0                       735.0                         348 387                 735
1296125 1296125 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No High 09 12 2017   grade_9                         399.0 386.0                       785.0                         399 386                 785
1297905 1297905 IN     school 1805450 4615   Lake Central School Corporation 180545000984 3833 Lake Central High School   Regular School No High 09 12 2017   grade_9                         410.0 385.0                       795.0                         410 385                 795
1302024 1302024 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2017   grade_9                         404.0 384.0                       788.0                         404 384                 788
1790476 1790476 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No High 09 12 2018   grade_9                         388.0 383.0                       771.0                         388 383                 771
1911951 1911951 IN     school 1805450 4615   Lake Central School Corporation 180545000984 3833 Lake Central High School   Regular School No High 09 12 2020   grade_9                         409.0 379.0                       788.0                         409 379                 788
1922540 1922540 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2021   grade_9                         432.0 377.0                       809.0                         432 377                 809
1790881 1790881 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2018   grade_9                         411.0 376.0                       787.0                         411 376                 787
1284093 1284093 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No 3.0 09 12 2016   grade_9                         387.0 372.0                       759.0                         387 372                 759
1793422 1793422 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No High 09 12 2018   grade_9                         345.0 371.0                       716.0                         345 371                 716
1913120 1913120 IN     school 1805670 5330   M S D Lawrence Township 180567001031 5276 Lawrence North High School   Regular School No High 09 12 2020   grade_9                         331.0 370.0                       701.0                         331 370                 701
1910177 1910177 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No High 09 12 2020   grade_9                         427.0 369.0                       796.0                         427 369                 796
1924045 1924045 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 09 12 2021   grade_9                         394.0 369.0                       763.0                         394 369                 763
1923356 1923356 IN     school 1801440 4205   Center Grove Community School Corp 180144000209 3437 Center Grove High School   Regular School No High 09 12 2021   grade_9                         317.0 368.0                       685.0                         317 368                 685
1296527 1296527 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No High 09 12 2017   grade_9                         368.0 367.0                       735.0                         368 367                 735
1285991 1285991 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000293 3901 Crown Point High School   Regular School No 3.0 09 12 2016   grade_9                         389.0 360.0                       749.0                         389 360                 749
1299094 1299094 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No High 09 12 2017   grade_9                         358.0 358.0                       716.0                         358 358                 716
1162682 1162682 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No 3.0 09 12 2015   grade_9                         385.0 356.0                       741.0                         385 356                 741
1757631 1757631 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No High 09 12 2019   grade_9                         403.0 356.0                       759.0                         403 356                 759
1925029 1925029 IN     school 1805670 5330   MSD Lawrence Township 180567001031 5276 Lawrence North High School   Regular School No High 09 12 2021   grade_9                         361.0 354.0                       715.0                         361 354                 715
1923918 1923918 IN     school 1805450 4615   Lake Central School Corporation 180545000984 3833 Lake Central High School   Regular School No High 09 12 2021   grade_9                         455.0 353.0                       808.0                         455 353                 808
1287062 1287062 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No 3.0 09 12 2016   grade_9                         366.0 352.0                       718.0                         366 352                 718
1298039 1298039 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 08 12 2017   grade_9                         334.0 350.0                       684.0                         334 350                 684
1755048 1755048 IN     school 1801020 3305   Brownsburg Community School Corp 180102000176 2709 Brownsburg High School   Regular School No High 09 12 2019   grade_9                         377.0 349.0                       726.0                         377 349                 726
1163083 1163083 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2015   grade_9                         358.0 346.0                       704.0                         358 346                 704
1930817 1930817 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   grade_9                         298.0 346.0                       644.0                         298 346                 644
1297352 1297352 IN     school 1801440 4205   Center Grove Community School Corp 180144000209 3437 Center Grove High School   Regular School No High 09 12 2017   grade_9                         317.0 345.0                       662.0                         317 345                 662
1790793 1790793 IN     school 1801020 3305   Brownsburg Community School Corp 180102000176 2709 Brownsburg High School   Regular School No High 09 12 2018   grade_9                         323.0 344.0                       667.0                         323 344                 667
1922444 1922444 IN     school 1801020 3305   Brownsburg Community School Corp 180102000176 2709 Brownsburg High School   Regular School No High 09 12 2021   grade_9                         385.0 343.0                       728.0                         385 343                 728
1284402 1284402 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000176 2709 Brownsburg High School   Regular School No 3.0 09 12 2016   grade_9                         343.0 342.0                       685.0                         343 342                 685
1793490 1793490 IN     school 1805670 5330   M S D Lawrence Township 180567001031 5276 Lawrence North High School   Regular School No High 09 12 2018   grade_9                         291.0 342.0                       633.0                         291 342                 633
1912076 1912076 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 09 12 2020   grade_9                         395.0 342.0                       737.0                         395 342                 737
1292820 1292820 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_9                         240.0 341.0                       581.0                         240 341                 581

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