enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,428 ✖
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
1162064 1162064 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 23.0                       47.0                         24 23                 47
1162075 1162075 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_8                         73.0 62.0                       135.0                         73 62                 135
1162098 1162098 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         24.0 23.0                       47.0                         24 23                 47
1162110 1162110 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No 2.0 07 08 2015   grade_8                         42.0 35.0                       77.0                         42 35                 77
1162142 1162142 IN     school 1807770 2735   North Gibson School Corp 180777001327 2225 Princeton Community Middle   Regular School No 2.0 06 08 2015   grade_8                         85.0 66.0                       151.0                         85 66                 151
1162161 1162161 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_8                         33.0 27.0                       60.0                         33 27                 60
1162176 1162176 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 26.0                       50.0                         24 26                 50
1162186 1162186 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 20.0                       44.0                         24 20                 44
1162213 1162213 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No 2.0 07 08 2015   grade_8                         82.0 65.0                       147.0                         82 65                 147
1162221 1162221 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624002279 2328 Madison-Grant Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         50.0 59.0                       109.0                         50 59                 109
1162247 1162247 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No 2.0 06 08 2015   grade_8                         104.0 99.0                       203.0                         104 99                 203
1162267 1162267 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No 2.0 07 08 2015   grade_8                         138.0 116.0                       254.0                         138 116                 254
1162307 1162307 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         33.0 40.0                       73.0                         33 40                 73
1162325 1162325 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2015   grade_8                         60.0 48.0                       108.0                         60 48                 108
1162335 1162335 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High Sch   Regular School No 2.0 06 08 2015   grade_8                         55.0 49.0                       104.0                         55 49                 104
1162348 1162348 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         27.0 35.0                       62.0                         27 35                 62
1162364 1162364 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         27.0 39.0                       66.0                         27 39                 66
1162434 1162434 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No 2.0 07 08 2015   grade_8                         271.0 249.0                       520.0                         271 249                 520
1162466 1162466 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton Southeastern Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         291.0 320.0                       611.0                         291 320                 611
1162469 1162469 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Jr High   Regular School No 2.0 07 08 2015   grade_8                         235.0 235.0                       470.0                         235 235                 470
1162496 1162496 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         90.0 95.0                       185.0                         90 95                 185
1162505 1162505 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_8                         245.0 261.0                       506.0                         245 261                 506
1162571 1162571 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   grade_8                         47.0 40.0                       87.0                         47 40                 87
1162580 1162580 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No 2.0 06 08 2015   grade_8                         246.0 200.0                       446.0                         246 200                 446
1162614 1162614 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No 2.0 06 08 2015   grade_8                         213.0 187.0                       400.0                         213 187                 400
1162656 1162656 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No 2.0 06 08 2015   grade_8                         251.0 273.0                       524.0                         251 273                 524
1162677 1162677 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_8                         4.0 0.0                       4.0                         4 0                 4
1162686 1162686 IN     school 1807650 3070   Noblesville Schools 180765001310 2521 Noblesville East Middle School   Regular School No 2.0 06 08 2015   grade_8                         168.0 160.0                       328.0                         168 160                 328
1162736 1162736 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No 2.0 06 08 2015   grade_8                         233.0 214.0                       447.0                         233 214                 447
1162770 1162770 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 Doe Creek Middle School   Regular School No 2.0 07 08 2015   grade_8                         126.0 162.0                       288.0                         126 162                 288
1162786 1162786 IN     school 1804050 3125   Greenfield-Central Com Schools 180405002476 2579 Greenfield Central Junior High Sch   Regular School No 2.0 07 08 2015   grade_8                         201.0 178.0                       379.0                         201 178                 379
1162827 1162827 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001222 2559 Mt Vernon Middle School   Regular School No 2.0 06 08 2015   grade_8                         154.0 136.0                       290.0                         154 136                 290
1162851 1162851 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         48.0 39.0                       87.0                         48 39                 87
1162877 1162877 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_8                         25.0 25.0                       50.0                         25 25                 50
1162890 1162890 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2015   grade_8                         104.0 93.0                       197.0                         104 93                 197
1162910 1162910 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         99.0 84.0                       183.0                         99 84                 183
1162954 1162954 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_8                         28.0 20.0                       48.0                         28 20                 48
1162959 1162959 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No 2.0 06 08 2015   grade_8                         93.0 68.0                       161.0                         93 68                 161
1163008 1163008 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000178 2713 Brownsburg West Middle School   Regular School No 2.0 06 08 2015   grade_8                         148.0 150.0                       298.0                         148 150                 298
1163026 1163026 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002086 2720 Brownsburg East Middle School   Regular School No 2.0 06 08 2015   grade_8                         202.0 185.0                       387.0                         202 185                 387
1163055 1163055 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No 2.0 07 08 2015   grade_8                         191.0 193.0                       384.0                         191 193                 384
1163077 1163077 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No 2.0 07 08 2015   grade_8                         207.0 183.0                       390.0                         207 183                 390
1163121 1163121 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_8                         120.0 97.0                       217.0                         120 97                 217
1163141 1163141 IN     school 1808970 3330   Plainfield Community Sch Corp 180897002357 2750 Plainfield Com Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         235.0 216.0                       451.0                         235 216                 451
1163183 1163183 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_8                         61.0 63.0                       124.0                         61 63                 124
1163194 1163194 IN     school 1800660 3405   Blue River Valley Schools 180066000141 2801 Blue River Valley Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_8                         20.0 21.0                       41.0                         20 21                 41
1163211 1163211 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2015   grade_8                         30.0 31.0                       61.0                         30 31                 61
1163237 1163237 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2015   grade_8                         65.0 71.0                       136.0                         65 71                 136
1163245 1163245 IN     school 1807440 3445   New Castle Community Sch Corp 180744001288 2829 New Castle Middle School   Regular School No 2.0 07 08 2015   grade_8                         160.0 118.0                       278.0                         160 118                 278
1163304 1163304 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2015   grade_8                         54.0 48.0                       102.0                         54 48                 102
1163328 1163328 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No 2.0 06 08 2015   grade_8                         44.0 47.0                       91.0                         44 47                 91
1163352 1163352 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No 2.0 07 08 2015   grade_8                         75.0 67.0                       142.0                         75 67                 142
1163367 1163367 IN     school 1803150 3480   Eastern Howard School Corp 180315000413 2919 Eastern Jr & Sr High School   Regular School No 3.0 07 12 2015   grade_8                         55.0 57.0                       112.0                         55 57                 112
1163378 1163378 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
1163383 1163383 IN     school 1804470 3490   Western School Corp 180447002225 2922 Western Middle School   Regular School No 2.0 06 08 2015   grade_8                         125.0 113.0                       238.0                         125 113                 238
1163418 1163418 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         57.0 29.0                       86.0                         57 29                 86
1163422 1163422 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         71.0 81.0                       152.0                         71 81                 152
1163434 1163434 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         152.0 85.0                       237.0                         152 85                 237
1163474 1163474 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No 2.0 06 08 2015   grade_8                         125.0 92.0                       217.0                         125 92                 217
1163499 1163499 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No 2.0 06 08 2015   grade_8                         97.0 83.0                       180.0                         97 83                 180
1163534 1163534 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_8                         11.0 10.0                       21.0                         11 10                 21
1163566 1163566 IN     school 1810080 3675   Seymour Community Schools 181008002214 3138 Seymour Middle School   Regular School No 2.0 06 08 2015   grade_8                         190.0 197.0                       387.0                         190 197                 387
1163592 1163592 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         61.0 78.0                       139.0                         61 78                 139
1163612 1163612 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_8                         23.0 19.0                       42.0                         23 19                 42
1163630 1163630 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No 2.0 06 08 2015   grade_8                         144.0 130.0                       274.0                         144 130                 274
1163666 1163666 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2015   grade_8                         69.0 63.0                       132.0                         69 63                 132
1163697 1163697 IN     school 1804980 3945   Jay School Corp 180498000912 3265 East Jay County Middle School   Regular School No 2.0 06 08 2015   grade_8                         107.0 86.0                       193.0                         107 86                 193
1163715 1163715 IN     school 1804980 3945   Jay School Corp 180498000918 3285 West Jay County Middle School   Regular School No 2.0 06 08 2015   grade_8                         35.0 44.0                       79.0                         35 44                 79
1163747 1163747 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No 2.0 06 08 2015   grade_8                         129.0 113.0                       242.0                         129 113                 242
1163786 1163786 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2015   grade_8                         61.0 44.0                       105.0                         61 44                 105
1163835 1163835 IN     school 1805190 4015   Jennings County Schools 180519000925 3393 Jennings County Middle School   Regular School No 2.0 07 08 2015   grade_8                         184.0 181.0                       365.0                         184 181                 365
1163871 1163871 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         263.0 233.0                       496.0                         263 233                 496
1163919 1163919 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000210 3441 Center Grove Middle Schl Central   Regular School No 2.0 06 08 2015   grade_8                         180.0 142.0                       322.0                         180 142                 322
1163923 1163923 IN     school 1801440 4205   Center Grove Com Sch Corp 180144001912 3443 Center Grove Middle School North   Regular School No 2.0 06 08 2015   grade_8                         144.0 140.0                       284.0                         144 140                 284
1163939 1163939 IN     school 1803240 4215   Edinburgh Community Sch Corp 180324000213 3449 Edinburgh Comm Middle School   Regular School No 2.0 06 08 2015   grade_8                         32.0 45.0                       77.0                         32 45                 77
1163967 1163967 IN     school 1803690 4225   Franklin Community School Corp 180369000580 3457 Franklin Community Middle School   Regular School No 2.0 07 08 2015   grade_8                         174.0 208.0                       382.0                         174 208                 382
1163999 1163999 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000710 3475 Greenwood Middle School   Regular School No 2.0 06 08 2015   grade_8                         167.0 148.0                       315.0                         167 148                 315
1164041 1164041 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No 2.0 06 08 2015   grade_8                         96.0 67.0                       163.0                         96 67                 163
1164056 1164056 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         60.0 58.0                       118.0                         60 58                 118
1164076 1164076 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2015   grade_8                         48.0 42.0                       90.0                         48 42                 90
1164093 1164093 IN     school 1812120 4335   Vincennes Community Sch Corp 181212001928 3557 George Rogers Clark Sch   Regular School No 2.0 06 08 2015   grade_8                         114.0 86.0                       200.0                         114 86                 200
1164125 1164125 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No 2.0 06 08 2015   grade_8                         103.0 97.0                       200.0                         103 97                 200
1164134 1164134 IN     school 1805550 4345   Wawasee Community School Corp 180555001001 3635 Milford School   Regular School No 1.0 KG 08 2015   grade_8                         42.0 39.0                       81.0                         42 39                 81
1164159 1164159 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No 2.0 07 08 2015   grade_8                         163.0 145.0                       308.0                         163 145                 308
1164192 1164192 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No 2.0 07 08 2015   grade_8                         146.0 119.0                       265.0                         146 119                 265
1164247 1164247 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         75.0 89.0                       164.0                         75 89                 164
1164259 1164259 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         62.0 66.0                       128.0                         62 66                 128
1164284 1164284 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2015   grade_8                         60.0 50.0                       110.0                         60 50                 110
1164296 1164296 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_8                         123.0 91.0                       214.0                         123 91                 214
1164342 1164342 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No 2.0 06 08 2015   grade_8                         72.0 75.0                       147.0                         72 75                 147
1164362 1164362 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_8                         3.0 2.0                       5.0                         3 2                 5
1164382 1164382 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         114.0 71.0                       185.0                         114 71                 185
1164395 1164395 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_8                         47.0 75.0                       122.0                         47 75                 122
1164423 1164423 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2015   grade_8                         274.0 258.0                       532.0                         274 258                 532
1164462 1164462 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2015   grade_8                         122.0 117.0                       239.0                         122 117                 239
1164480 1164480 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2015   grade_8                         139.0 143.0                       282.0                         139 143                 282
1164498 1164498 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2015   grade_8                         139.0 142.0                       281.0                         139 142                 281
1164545 1164545 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No 2.0 05 08 2015   grade_8                         148.0 152.0                       300.0                         148 152                 300
1164574 1164574 IN     school 1805460 4650   Lake Ridge Schools 180546000992 3893 Lake Ridge Middle School   Regular School No 2.0 06 08 2015   grade_8                         71.0 75.0                       146.0                         71 75                 146
1164578 1164578 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000297 3761 Robert Taft Middle School   Regular School No 2.0 06 08 2015   grade_8                         169.0 154.0                       323.0                         169 154                 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]);