enrollments

Data source: Big Local News · About: Big Local

510 rows where grade = "grade_8", state = "IN" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 410 ✖

grade ✖

  • grade_8 · 410 ✖
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
1921462 1921462 IN     school 1802430 2440   Covington Community School Corp 180243000277 2013 Covington Middle School   Regular School No Middle 06 08 2021   grade_8                         30.0 42.0                       72.0                         30 42                 72
1921477 1921477 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No High 07 12 2021   grade_8                         30.0 42.0                       72.0                         30 42                 72
1921496 1921496 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Franklin County Middle School   Regular School No Middle 06 08 2021   grade_8                         84.0 104.0                       188.0                         84 104                 188
1921522 1921522 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2021   grade_8                         73.0 67.0                       140.0                         73 67                 140
1921545 1921545 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         25.0 22.0                       47.0                         25 22                 47
1921557 1921557 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No Middle 07 08 2021   grade_8                         24.0 22.0                       46.0                         24 22                 46
1921590 1921590 IN     school 1807770 2735   North Gibson School Corporation 180777001327 2225 Princeton Community Middle   Regular School No Middle 06 08 2021   grade_8                         89.0 78.0                       167.0                         89 78                 167
1921610 1921610 IN     school 1810350 2765   South Gibson School Corporation 181035001689 2205 Haubstadt Community School   Regular School No Elementary KG 08 2021   grade_8                         17.0 18.0                       35.0                         17 18                 35
1921626 1921626 IN     school 1810350 2765   South Gibson School Corporation 181035002230 2214 Fort Branch Community School   Regular School No Elementary KG 08 2021   grade_8                         40.0 44.0                       84.0                         40 44                 84
1921636 1921636 IN     school 1810350 2765   South Gibson School Corporation 181035001691 2241 Owensville Community School   Regular School No Elementary KG 08 2021   grade_8                         23.0 25.0                       48.0                         23 25                 48
1921663 1921663 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No Middle 07 08 2021   grade_8                         70.0 78.0                       148.0                         70 78                 148
1921669 1921669 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2021   grade_8                         42.0 52.0                       94.0                         42 52                 94
1921690 1921690 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No Middle 06 08 2021   grade_8                         122.0 92.0                       214.0                         122 92                 214
1921711 1921711 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No Middle 07 08 2021   grade_8                         166.0 120.0                       286.0                         166 120                 286
1921754 1921754 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         36.0 32.0                       68.0                         36 32                 68
1921772 1921772 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2021   grade_8                         57.0 40.0                       97.0                         57 40                 97
1921782 1921782 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2021   grade_8                         39.0 40.0                       79.0                         39 40                 79
1921796 1921796 IN     school 1810110 2960   MSD Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         23.0 33.0                       56.0                         23 33                 56
1921815 1921815 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_8                         23.0 37.0                       60.0                         23 37                 60
1921876 1921876 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2021   grade_8                         248.0 239.0                       487.0                         248 239                 487
1921910 1921910 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002580 2486 Fall Creek Junior High   Regular School No Middle 07 08 2021   grade_8                         250.0 283.0                       533.0                         250 283                 533
1921920 1921920 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2021   grade_8                         127.0 138.0                       265.0                         127 138                 265
1921923 1921923 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2021   grade_8                         233.0 248.0                       481.0                         233 248                 481
1921956 1921956 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 05 08 2021   grade_8                         86.0 75.0                       161.0                         86 75                 161
1921961 1921961 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_8                         334.0 307.0                       641.0                         334 307                 641
1922028 1922028 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No Middle 06 08 2021   grade_8                         42.0 33.0                       75.0                         42 33                 75
1922037 1922037 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No Middle 06 08 2021   grade_8                         240.0 218.0                       458.0                         240 218                 458
1922070 1922070 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2021   grade_8                         239.0 218.0                       457.0                         239 218                 457
1922112 1922112 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No Middle 06 08 2021   grade_8                         235.0 218.0                       453.0                         235 218                 453
1922136 1922136 IN     school 1807650 3070   Noblesville Schools 180765001310 2521 Noblesville East Middle School   Regular School No Middle 06 08 2021   grade_8                         178.0 200.0                       378.0                         178 200                 378
1922187 1922187 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2021   grade_8                         271.0 240.0                       511.0                         271 240                 511
1922220 1922220 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 New Palestine Jr High School   Regular School No Middle 07 08 2021   grade_8                         158.0 136.0                       294.0                         158 136                 294
1922233 1922233 IN     school 1804050 3125   Greenfield-Central Com Schools 180405002476 2579 Greenfield Central Junior High Sch   Regular School No Middle 07 08 2021   grade_8                         174.0 177.0                       351.0                         174 177                 351
1922274 1922274 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001222 2559 Mt Vernon Middle School   Regular School No Middle 06 08 2021   grade_8                         180.0 159.0                       339.0                         180 159                 339
1922299 1922299 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle School   Regular School No Middle 06 08 2021   grade_8                         50.0 42.0                       92.0                         50 42                 92
1922326 1922326 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No High 07 12 2021   grade_8                         28.0 33.0                       61.0                         28 33                 61
1922339 1922339 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No Middle 06 08 2021   grade_8                         73.0 74.0                       147.0                         73 74                 147
1922360 1922360 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High School   Regular School No Middle 07 08 2021   grade_8                         94.0 91.0                       185.0                         94 91                 185
1922402 1922402 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No High 07 12 2021   grade_8                         41.0 31.0                       72.0                         41 31                 72
1922407 1922407 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2021   grade_8                         95.0 87.0                       182.0                         95 87                 182
1922455 1922455 IN     school 1801020 3305   Brownsburg Community School Corp 180102000178 2713 Brownsburg West Middle School   Regular School No Middle 06 08 2021   grade_8                         165.0 147.0                       312.0                         165 147                 312
1922473 1922473 IN     school 1801020 3305   Brownsburg Community School Corp 180102002086 2720 Brownsburg East Middle School   Regular School No Middle 06 08 2021   grade_8                         220.0 218.0                       438.0                         220 218                 438
1922511 1922511 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2021   grade_8                         205.0 213.0                       418.0                         205 213                 418
1922534 1922534 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2021   grade_8                         198.0 201.0                       399.0                         198 201                 399
1922576 1922576 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_8                         99.0 95.0                       194.0                         99 95                 194
1922597 1922597 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2021   grade_8                         250.0 215.0                       465.0                         250 215                 465
1922626 1922626 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1922647 1922647 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2021   grade_8                         63.0 64.0                       127.0                         63 64                 127
1922658 1922658 IN     school 1800660 3405   Blue River Valley Schools 180066000141 2801 Blue River Valley Jr-Sr High Sch   Regular School No High 07 12 2021   grade_8                         23.0 24.0                       47.0                         23 24                 47
1922675 1922675 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No High 06 12 2021   grade_8                         34.0 25.0                       59.0                         34 25                 59
1922700 1922700 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2021   grade_8                         48.0 52.0                       100.0                         48 52                 100
1922706 1922706 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1922710 1922710 IN     school 1807440 3445   New Castle Community School Corp 180744001288 2829 New Castle Middle School   Regular School No Middle 07 08 2021   grade_8                         102.0 121.0                       223.0                         102 121                 223
1922768 1922768 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2021   grade_8                         39.0 37.0                       76.0                         39 37                 76
1922791 1922791 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2021   grade_8                         43.0 53.0                       96.0                         43 53                 96
1922815 1922815 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No Middle 07 08 2021   grade_8                         72.0 70.0                       142.0                         72 70                 142
1922826 1922826 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2021   grade_8                         66.0 65.0                       131.0                         66 65                 131
1922837 1922837 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2021   grade_8                         2.0 0.0                       2.0                         2 0                 2
1922842 1922842 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2021   grade_8                         123.0 94.0                       217.0                         123 94                 217
1922849 1922849 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1922882 1922882 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No Middle 06 08 2021   grade_8                         43.0 37.0                       80.0                         43 37                 80
1922886 1922886 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No Middle 06 08 2021   grade_8                         59.0 108.0                       167.0                         59 108                 167
1922898 1922898 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2021   grade_8                         80.0 68.0                       148.0                         80 68                 148
1922938 1922938 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2021   grade_8                         82.0 96.0                       178.0                         82 96                 178
1922956 1922956 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2021   grade_8                         120.0 101.0                       221.0                         120 101                 221
1922991 1922991 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 06 12 2021   grade_8                         4.0 5.0                       9.0                         4 5                 9
1923023 1923023 IN     school 1810080 3675   Seymour Community Schools 181008002214 3138 Seymour Middle School   Regular School No Middle 06 08 2021   grade_8                         202.0 202.0                       404.0                         202 202                 404
1923049 1923049 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2021   grade_8                         71.0 49.0                       120.0                         71 49                 120
1923069 1923069 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         19.0 11.0                       30.0                         19 11                 30
1923088 1923088 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2021   grade_8                         136.0 132.0                       268.0                         136 132                 268
1923125 1923125 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_8                         77.0 58.0                       135.0                         77 58                 135
1923132 1923132 IN     school 1804980 3945   Jay School Corporation 180498000914 3239 Jay County Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         100.0 111.0                       211.0                         100 111                 211
1923185 1923185 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 04 08 2021   grade_8                         108.0 77.0                       185.0                         108 77                 185
1923213 1923213 IN     school 1806120 3995   Madison Consolidated Schools 180612002695 3358 E.O. Muncie Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1923231 1923231 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2021   grade_8                         48.0 47.0                       95.0                         48 47                 95
1923280 1923280 IN     school 1805190 4015   Jennings County School Corporation 180519000925 3393 Jennings County Middle School   Regular School No Middle 07 08 2021   grade_8                         178.0 152.0                       330.0                         178 152                 330
1923322 1923322 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2021   grade_8                         281.0 256.0                       537.0                         281 256                 537
1923381 1923381 IN     school 1801440 4205   Center Grove Community School Corp 180144000210 3441 Center Grove Middle School Central   Regular School No Middle 06 08 2021   grade_8                         178.0 205.0                       383.0                         178 205                 383
1923385 1923385 IN     school 1801440 4205   Center Grove Community School Corp 180144001912 3443 Center Grove Middle School North   Regular School No Middle 06 08 2021   grade_8                         173.0 181.0                       354.0                         173 181                 354
1923402 1923402 IN     school 1803240 4215   Edinburgh Community School Corp 180324000213 3449 Edinburgh Comm Middle School   Regular School No Middle 06 08 2021   grade_8                         32.0 29.0                       61.0                         32 29                 61
1923430 1923430 IN     school 1803690 4225   Franklin Community School Corp 180369000580 3457 Franklin Community Middle School   Regular School No Middle 07 08 2021   grade_8                         170.0 191.0                       361.0                         170 191                 361
1923463 1923463 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000710 3475 Greenwood Middle School   Regular School No Middle 06 08 2021   grade_8                         163.0 148.0                       311.0                         163 148                 311
1923505 1923505 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No Middle 06 08 2021   grade_8                         75.0 64.0                       139.0                         75 64                 139
1923520 1923520 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         53.0 58.0                       111.0                         53 58                 111
1923540 1923540 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2021   grade_8                         54.0 51.0                       105.0                         54 51                 105
1923557 1923557 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2021   grade_8                         107.0 100.0                       207.0                         107 100                 207
1923586 1923586 IN     school 1812120 4335   Vincennes Community School Corp 181212002696 4319 Washington Learning Academy   Regular School No High 06 12 2021   grade_8                         13.0 10.0                       23.0                         13 10                 23
1923598 1923598 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No Middle 06 08 2021   grade_8                         91.0 86.0                       177.0                         91 86                 177
1923607 1923607 IN     school 1805550 4345   Wawasee Community School Corp 180555001001 3635 Milford School   Regular School No Elementary KG 08 2021   grade_8                         36.0 29.0                       65.0                         36 29                 65
1923632 1923632 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No Middle 07 08 2021   grade_8                         153.0 133.0                       286.0                         153 133                 286
1923665 1923665 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No Middle 07 08 2021   grade_8                         137.0 144.0                       281.0                         137 144                 281
1923722 1923722 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No Middle 06 08 2021   grade_8                         82.0 60.0                       142.0                         82 60                 142
1923745 1923745 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         52.0 54.0                       106.0                         52 54                 106
1923757 1923757 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2021   grade_8                         61.0 61.0                       122.0                         61 61                 122
1923771 1923771 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         95.0 87.0                       182.0                         95 87                 182
1923803 1923803 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         68.0 62.0                       130.0                         68 62                 130
1923835 1923835 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2021   grade_8                         113.0 91.0                       204.0                         113 91                 204
1923857 1923857 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2021   grade_8                         74.0 56.0                       130.0                         74 56                 130
1923872 1923872 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2021   grade_8                         235.0 230.0                       465.0                         235 230                 465
1923912 1923912 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2021   grade_8                         105.0 102.0                       207.0                         105 102                 207

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