enrollments

Data source: Big Local News · About: Big Local

502 rows where grade = "grade_8", state = "IN" and year = 2020 sorted by asian_pacific_islander

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 402 ✖

grade ✖

  • grade_8 · 402 ✖
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
1909515 1909515 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No High 07 12 2020   grade_8                         47.0 32.0                       79.0                         47 32                 79
1909534 1909534 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Franklin County Middle School   Regular School No Middle 06 08 2020   grade_8                         98.0 81.0                       179.0                         98 81                 179
1909560 1909560 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2020   grade_8                         69.0 63.0                       132.0                         69 63                 132
1909583 1909583 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High School   Regular School No High 06 12 2020   grade_8                         28.0 30.0                       58.0                         28 30                 58
1909595 1909595 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No Middle 07 08 2020   grade_8                         31.0 38.0                       69.0                         31 38                 69
1909628 1909628 IN     school 1807770 2735   North Gibson School Corporation 180777001327 2225 Princeton Community Middle   Regular School No Middle 06 08 2020   grade_8                         78.0 82.0                       160.0                         78 82                 160
1909647 1909647 IN     school 1810350 2765   South Gibson School Corporation 181035001689 2205 Haubstadt Community School   Regular School No Elementary KG 08 2020   grade_8                         32.0 31.0                       63.0                         32 31                 63
1909663 1909663 IN     school 1810350 2765   South Gibson School Corporation 181035002230 2214 Fort Branch Community School   Regular School No Elementary KG 08 2020   grade_8                         26.0 41.0                       67.0                         26 41                 67
1909673 1909673 IN     school 1810350 2765   South Gibson School Corporation 181035001691 2241 Owensville Community School   Regular School No Elementary KG 08 2020   grade_8                         22.0 28.0                       50.0                         22 28                 50
1909700 1909700 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No Middle 07 08 2020   grade_8                         71.0 64.0                       135.0                         71 64                 135
1909706 1909706 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2020   grade_8                         52.0 46.0                       98.0                         52 46                 98
1909734 1909734 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No Middle 06 08 2020   grade_8                         109.0 85.0                       194.0                         109 85                 194
1909755 1909755 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No Middle 07 08 2020   grade_8                         125.0 143.0                       268.0                         125 143                 268
1909788 1909788 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1909803 1909803 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         34.0 31.0                       65.0                         34 31                 65
1909821 1909821 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2020   grade_8                         39.0 46.0                       85.0                         39 46                 85
1909830 1909830 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2020   grade_8                         64.0 53.0                       117.0                         64 53                 117
1909843 1909843 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         29.0 28.0                       57.0                         29 28                 57
1909862 1909862 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_8                         29.0 29.0                       58.0                         29 29                 58
1909922 1909922 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No Middle 07 08 2020   grade_8                         236.0 249.0                       485.0                         236 249                 485
1909955 1909955 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002580 2486 Fall Creek Junior High   Regular School No Middle 07 08 2020   grade_8                         237.0 252.0                       489.0                         237 252                 489
1909965 1909965 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2020   grade_8                         151.0 158.0                       309.0                         151 158                 309
1909968 1909968 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Junior High   Regular School No Middle 07 08 2020   grade_8                         237.0 235.0                       472.0                         237 235                 472
1909995 1909995 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 06 08 2020   grade_8                         114.0 90.0                       204.0                         114 90                 204
1910006 1910006 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2020   grade_8                         335.0 301.0                       636.0                         335 301                 636
1910073 1910073 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No Middle 06 08 2020   grade_8                         46.0 33.0                       79.0                         46 33                 79
1910082 1910082 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No Middle 06 08 2020   grade_8                         228.0 205.0                       433.0                         228 205                 433
1910115 1910115 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No Middle 06 08 2020   grade_8                         260.0 232.0                       492.0                         260 232                 492
1910157 1910157 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No Middle 06 08 2020   grade_8                         224.0 209.0                       433.0                         224 209                 433
1910181 1910181 IN     school 1807650 3070   Noblesville Schools 180765001310 2521 Noblesville East Middle School   Regular School No Middle 06 08 2020   grade_8                         200.0 218.0                       418.0                         200 218                 418
1910233 1910233 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No Middle 06 08 2020   grade_8                         239.0 208.0                       447.0                         239 208                 447
1910268 1910268 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 New Palestine Jr High School   Regular School No Middle 07 08 2020   grade_8                         167.0 136.0                       303.0                         167 136                 303
1910281 1910281 IN     school 1804050 3125   Greenfield-Central Com Schools 180405002476 2579 Greenfield Central Junior High Sch   Regular School No Middle 07 08 2020   grade_8                         186.0 188.0                       374.0                         186 188                 374
1910322 1910322 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001222 2559 Mt Vernon Middle School   Regular School No Middle 06 08 2020   grade_8                         176.0 173.0                       349.0                         176 173                 349
1910347 1910347 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle School   Regular School No Middle 06 08 2020   grade_8                         55.0 48.0                       103.0                         55 48                 103
1910375 1910375 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No High 07 12 2020   grade_8                         21.0 37.0                       58.0                         21 37                 58
1910388 1910388 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No Middle 06 08 2020   grade_8                         85.0 87.0                       172.0                         85 87                 172
1910410 1910410 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High School   Regular School No Middle 07 08 2020   grade_8                         87.0 86.0                       173.0                         87 86                 173
1910452 1910452 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No High 07 12 2020   grade_8                         30.0 25.0                       55.0                         30 25                 55
1910457 1910457 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2020   grade_8                         91.0 63.0                       154.0                         91 63                 154
1910505 1910505 IN     school 1801020 3305   Brownsburg Community School Corp 180102000178 2713 Brownsburg West Middle School   Regular School No Middle 06 08 2020   grade_8                         162.0 151.0                       313.0                         162 151                 313
1910523 1910523 IN     school 1801020 3305   Brownsburg Community School Corp 180102002086 2720 Brownsburg East Middle School   Regular School No Middle 06 08 2020   grade_8                         221.0 181.0                       402.0                         221 181                 402
1910559 1910559 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 07 08 2020   grade_8                         211.0 184.0                       395.0                         211 184                 395
1910582 1910582 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2020   grade_8                         209.0 168.0                       377.0                         209 168                 377
1910624 1910624 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_8                         96.0 98.0                       194.0                         96 98                 194
1910645 1910645 IN     school 1808970 3330   Plainfield Community School Corp 180897002357 2750 Plainfield Community Middle School   Regular School No Middle 06 08 2020   grade_8                         202.0 214.0                       416.0                         202 214                 416
1910688 1910688 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2020   grade_8                         89.0 53.0                       142.0                         89 53                 142
1910699 1910699 IN     school 1800660 3405   Blue River Valley Schools 180066000141 2801 Blue River Valley Jr-Sr High Sch   Regular School No High 07 12 2020   grade_8                         29.0 30.0                       59.0                         29 30                 59
1910716 1910716 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No High 06 12 2020   grade_8                         28.0 20.0                       48.0                         28 20                 48
1910741 1910741 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2020   grade_8                         59.0 53.0                       112.0                         59 53                 112
1910747 1910747 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1910751 1910751 IN     school 1807440 3445   New Castle Community School Corp 180744001288 2829 New Castle Middle School   Regular School No Middle 07 08 2020   grade_8                         132.0 127.0                       259.0                         132 127                 259
1910809 1910809 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2020   grade_8                         54.0 27.0                       81.0                         54 27                 81
1910833 1910833 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2020   grade_8                         43.0 43.0                       86.0                         43 43                 86
1910857 1910857 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No Middle 07 08 2020   grade_8                         83.0 64.0                       147.0                         83 64                 147
1910868 1910868 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2020   grade_8                         54.0 54.0                       108.0                         54 54                 108
1910883 1910883 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2020   grade_8                         101.0 109.0                       210.0                         101 109                 210
1910890 1910890 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1910923 1910923 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No Middle 06 08 2020   grade_8                         33.0 39.0                       72.0                         33 39                 72
1910927 1910927 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No Middle 06 08 2020   grade_8                         91.0 107.0                       198.0                         91 107                 198
1910939 1910939 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2020   grade_8                         69.0 68.0                       137.0                         69 68                 137
1910979 1910979 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2020   grade_8                         105.0 105.0                       210.0                         105 105                 210
1910997 1910997 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2020   grade_8                         85.0 108.0                       193.0                         85 108                 193
1911031 1911031 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2020   grade_8                         7.0 6.0                       13.0                         7 6                 13
1911064 1911064 IN     school 1810080 3675   Seymour Community Schools 181008002214 3138 Seymour Middle School   Regular School No Middle 06 08 2020   grade_8                         203.0 176.0                       379.0                         203 176                 379
1911090 1911090 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2020   grade_8                         76.0 54.0                       130.0                         76 54                 130
1911110 1911110 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2020   grade_8                         22.0 14.0                       36.0                         22 14                 36
1911129 1911129 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2020   grade_8                         132.0 124.0                       256.0                         132 124                 256
1911167 1911167 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2020   grade_8                         62.0 54.0                       116.0                         62 54                 116
1911191 1911191 IN     school 1804980 3945   Jay School Corporation 180498000912 3265 East Jay County Middle School   Regular School No Middle 06 08 2020   grade_8                         83.0 66.0                       149.0                         83 66                 149
1911199 1911199 IN     school 1804980 3945   Jay School Corporation 180498000918 3285 West Jay County Middle School   Regular School No Middle 06 08 2020   grade_8                         40.0 33.0                       73.0                         40 33                 73
1911228 1911228 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 05 08 2020   grade_8                         113.0 98.0                       211.0                         113 98                 211
1911266 1911266 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2020   grade_8                         44.0 48.0                       92.0                         44 48                 92
1911315 1911315 IN     school 1805190 4015   Jennings County School Corporation 180519000925 3393 Jennings County Middle School   Regular School No Middle 07 08 2020   grade_8                         154.0 151.0                       305.0                         154 151                 305
1911356 1911356 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No Middle 06 08 2020   grade_8                         263.0 266.0                       529.0                         263 266                 529
1911415 1911415 IN     school 1801440 4205   Center Grove Community School Corp 180144000210 3441 Center Grove Middle School Central   Regular School No Middle 06 08 2020   grade_8                         167.0 177.0                       344.0                         167 177                 344
1911419 1911419 IN     school 1801440 4205   Center Grove Community School Corp 180144001912 3443 Center Grove Middle School North   Regular School No Middle 06 08 2020   grade_8                         144.0 186.0                       330.0                         144 186                 330
1911436 1911436 IN     school 1803240 4215   Edinburgh Community School Corp 180324000213 3449 Edinburgh Comm Middle School   Regular School No Middle 06 08 2020   grade_8                         30.0 34.0                       64.0                         30 34                 64
1911464 1911464 IN     school 1803690 4225   Franklin Community School Corp 180369000580 3457 Franklin Community Middle School   Regular School No Middle 07 08 2020   grade_8                         181.0 198.0                       379.0                         181 198                 379
1911497 1911497 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000710 3475 Greenwood Middle School   Regular School No Middle 06 08 2020   grade_8                         160.0 141.0                       301.0                         160 141                 301
1911541 1911541 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762002686 3414 Indiana Academy Online   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1911546 1911546 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No Middle 06 08 2020   grade_8                         85.0 65.0                       150.0                         85 65                 150
1911561 1911561 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         52.0 48.0                       100.0                         52 48                 100
1911581 1911581 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2020   grade_8                         45.0 51.0                       96.0                         45 51                 96
1911598 1911598 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2020   grade_8                         112.0 78.0                       190.0                         112 78                 190
1911631 1911631 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No Middle 06 08 2020   grade_8                         110.0 76.0                       186.0                         110 76                 186
1911640 1911640 IN     school 1805550 4345   Wawasee Community School Corp 180555001001 3635 Milford School   Regular School No Elementary KG 08 2020   grade_8                         43.0 33.0                       76.0                         43 33                 76
1911664 1911664 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No Middle 07 08 2020   grade_8                         144.0 117.0                       261.0                         144 117                 261
1911697 1911697 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No Middle 07 08 2020   grade_8                         166.0 140.0                       306.0                         166 140                 306
1911754 1911754 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No Middle 06 08 2020   grade_8                         70.0 69.0                       139.0                         70 69                 139
1911777 1911777 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_8                         58.0 47.0                       105.0                         58 47                 105
1911789 1911789 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2020   grade_8                         65.0 47.0                       112.0                         65 47                 112
1911803 1911803 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2020   grade_8                         100.0 93.0                       193.0                         100 93                 193
1911835 1911835 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland Jr/Sr High School   Regular School No High 07 12 2020   grade_8                         70.0 70.0                       140.0                         70 70                 140
1911867 1911867 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2020   grade_8                         86.0 88.0                       174.0                         86 88                 174
1911888 1911888 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2020   grade_8                         62.0 51.0                       113.0                         62 51                 113
1911903 1911903 IN     school 1809690 4600   Merrillville Community School Corp 180969001588 3811 Pierce Middle School   Regular School No Middle 07 08 2020   grade_8                         250.0 237.0                       487.0                         250 237                 487
1911945 1911945 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2020   grade_8                         127.0 101.0                       228.0                         127 101                 228
1911962 1911962 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2020   grade_8                         182.0 127.0                       309.0                         182 127                 309
1911981 1911981 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2020   grade_8                         137.0 121.0                       258.0                         137 121                 258

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