enrollments

Data source: Big Local News · About: Big Local

418 rows where grade = "grade_9", state = "IN" and year = 2016

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 418 ✖

grade ✖

  • grade_9 · 418 ✖
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
1280867 1280867 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 53.0                       100.0                         47 53                 100
1280872 1280872 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2016   grade_9                         94.0 92.0                       186.0                         94 92                 186
1280895 1280895 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_9                         46.0 49.0                       95.0                         46 49                 95
1280923 1280923 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2016   grade_9                         302.0 293.0                       595.0                         302 293                 595
1280993 1280993 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2016   grade_9                         276.0 331.0                       607.0                         276 331                 607
1281031 1281031 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_9                         1.0 0.0                       1.0                         1 0                 1
1281037 1281037 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_9                         2.0 1.0                       3.0                         2 1                 3
1281042 1281042 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2016   grade_9                         218.0 199.0                       417.0                         218 199                 417
1281047 1281047 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2016   grade_9                         234.0 246.0                       480.0                         234 246                 480
1281052 1281052 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2016   grade_9                         209.0 178.0                       387.0                         209 178                 387
1281189 1281189 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2016   grade_9                         209.0 164.0                       373.0                         209 164                 373
1281263 1281263 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No 3.0 09 12 2016   grade_9                         278.0 258.0                       536.0                         278 258                 536
1281367 1281367 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2016   grade_9                         116.0 107.0                       223.0                         116 107                 223
1281379 1281379 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_9                         84.0 79.0                       163.0                         84 79                 163
1281400 1281400 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_9                         74.0 51.0                       125.0                         74 51                 125
1281414 1281414 IN     school 1802850 255   East Allen County Schools 180285000353 297 New Haven High School   Regular School No 3.0 09 12 2016   grade_9                         150.0 113.0                       263.0                         150 113                 263
1281442 1281442 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 3.0 09 12 2016   grade_9                         33.0 53.0                       86.0                         33 53                 86
1281551 1281551 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2016   grade_9                         279.0 273.0                       552.0                         279 273                 552
1281556 1281556 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2016   grade_9                         200.0 222.0                       422.0                         200 222                 422
1281571 1281571 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         43.0 33.0                       76.0                         43 33                 76
1281594 1281594 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         72.0 71.0                       143.0                         72 71                 143
1281615 1281615 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford High School   Regular School No 3.0 09 12 2016   grade_9                         74.0 65.0                       139.0                         74 65                 139
1281652 1281652 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         64.0 70.0                       134.0                         64 70                 134
1281670 1281670 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No 3.0 09 12 2016   grade_9                         248.0 249.0                       497.0                         248 249                 497
1281717 1281717 IN     school 1805790 665   Lebanon Community School Corp 180579001041 553 Lebanon Senior High School   Regular School No 3.0 09 12 2016   grade_9                         148.0 130.0                       278.0                         148 130                 278
1281751 1281751 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2016   grade_9                         88.0 77.0                       165.0                         88 77                 165
1281780 1281780 IN     school 1801290 750   Carroll Consolidated Sch Corp 180129000203 621 Carroll Senior High School   Regular School No 3.0 09 12 2016   grade_9                         43.0 49.0                       92.0                         43 49                 92
1281800 1281800 IN     school 1802700 755   Delphi Community School Corp 180270000326 637 Delphi Community High School   Regular School No 3.0 09 12 2016   grade_9                         44.0 59.0                       103.0                         44 59                 103
1281815 1281815 IN     school 1808940 775   Pioneer Regional School Corp 180894001491 645 Pioneer Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         44.0 41.0                       85.0                         44 41                 85
1281834 1281834 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         63.0 54.0                       117.0                         63 54                 117
1281844 1281844 IN     school 1806030 875   Logansport Community Sch Corp 180603001060 701 Logansport Comm High School   Regular School No 3.0 09 12 2016   grade_9                         162.0 147.0                       309.0                         162 147                 309
1281890 1281890 IN     school 1809370 940   West Clark Community Schools 180937001531 765 Henryville Jr & Sr High School   Regular School No 3.0 07 12 2016   grade_9                         51.0 45.0                       96.0                         51 45                 96
1281904 1281904 IN     school 1809370 940   West Clark Community Schools 180937001536 777 Silver Creek High School   Regular School No 3.0 09 12 2016   grade_9                         118.0 128.0                       246.0                         118 128                 246
1281921 1281921 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No 3.0 07 12 2016   grade_9                         27.0 27.0                       54.0                         27 27                 54
1281939 1281939 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_9                         61.0 54.0                       115.0                         61 54                 115
1281999 1281999 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_9                         35.0 35.0                       70.0                         35 35                 70
1282004 1282004 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No 3.0 09 12 2016   grade_9                         98.0 77.0                       175.0                         98 77                 175
1282025 1282025 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2016   grade_9                         301.0 271.0                       572.0                         301 271                 572
1282086 1282086 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_9                         6.0 1.0                       7.0                         6 1                 7
1282094 1282094 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   grade_9                         6.0 2.0                       8.0                         6 2                 8
1282109 1282109 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         25.0 35.0                       60.0                         25 35                 60
1282139 1282139 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2016   grade_9                         147.0 139.0                       286.0                         147 139                 286
1282171 1282171 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_9                         43.0 28.0                       71.0                         43 28                 71
1282187 1282187 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         38.0 53.0                       91.0                         38 53                 91
1282201 1282201 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2016   grade_9                         133.0 134.0                       267.0                         133 134                 267
1282230 1282230 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_9                         37.0 42.0                       79.0                         37 42                 79
1282271 1282271 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_9                         57.0 55.0                       112.0                         57 55                 112
1282297 1282297 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2016   grade_9                         29.0 24.0                       53.0                         29 24                 53
1282321 1282321 IN     school 1807710 1375   North Daviess Com Schools 180771001319 1121 North Daviess Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_9                         49.0 41.0                       90.0                         49 41                 90
1282346 1282346 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2016   grade_9                         104.0 96.0                       200.0                         104 96                 200
1282395 1282395 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001802 7213 East Central High School   Regular School No 3.0 09 12 2016   grade_9                         151.0 165.0                       316.0                         151 165                 316
1282428 1282428 IN     school 1800240 1600   South Dearborn Com School Corp 180024000056 1179 South Dearborn High School   Regular School No 3.0 09 12 2016   grade_9                         121.0 121.0                       242.0                         121 121                 242
1282443 1282443 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001037 1177 Lawrenceburg High School   Regular School No 3.0 09 12 2016   grade_9                         72.0 84.0                       156.0                         72 84                 156
1282464 1282464 IN     school 1802610 1655   Decatur County Com Schools 180261000311 1263 South Decatur Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         46.0 36.0                       82.0                         46 36                 82
1282488 1282488 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         42.0 40.0                       82.0                         42 40                 82
1282493 1282493 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No 3.0 09 12 2016   grade_9                         110.0 90.0                       200.0                         110 90                 200
1282512 1282512 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_9                         52.0 54.0                       106.0                         52 54                 106
1282533 1282533 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384000605 1325 Garrett High School   Regular School No 3.0 09 12 2016   grade_9                         61.0 78.0                       139.0                         61 78                 139
1282557 1282557 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000220 1345 DeKalb High School   Regular School No 3.0 09 12 2016   grade_9                         152.0 148.0                       300.0                         152 148                 300
1282599 1282599 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No 3.0 09 12 2016   grade_9                         113.0 119.0                       232.0                         113 119                 232
1282622 1282622 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_9                         38.0 36.0                       74.0                         38 36                 74
1282634 1282634 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001047 1375 Wapahani High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 57.0                       104.0                         47 57                 104
1282660 1282660 IN     school 1807020 1900   Cowan Community School Corp 180702001200 1386 Cowan High School   Regular School No 3.0 07 12 2016   grade_9                         34.0 40.0                       74.0                         34 40                 74
1282670 1282670 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No 3.0 09 12 2016   grade_9                         109.0 108.0                       217.0                         109 108                 217
1282685 1282685 IN     school 1809840 1940   Daleville Community Schools 180984001603 1401 Daleville Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         34.0 39.0                       73.0                         34 39                 73
1282698 1282698 IN     school 1807320 1970   Muncie Community Schools 180732001242 1421 Muncie Central High School   Regular School No 3.0 09 12 2016   grade_9                         217.0 207.0                       424.0                         217 207                 424
1282780 1282780 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_9                         22.0 11.0                       33.0                         22 11                 33
1282791 1282791 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001393 1545 Northeast Dubois High School   Regular School No 3.0 09 12 2016   grade_9                         26.0 42.0                       68.0                         26 42                 68
1282825 1282825 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         50.0 35.0                       85.0                         50 35                 85
1282845 1282845 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No 3.0 09 12 2016   grade_9                         76.0 77.0                       153.0                         76 77                 153
1282870 1282870 IN     school 1803960 2120   Greater Jasper Con Schs 180396000685 1593 Jasper High School   Regular School No 3.0 09 12 2016   grade_9                         156.0 142.0                       298.0                         156 142                 298
1282886 1282886 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         67.0 79.0                       146.0                         67 79                 146
1282915 1282915 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2016   grade_9                         88.0 69.0                       157.0                         88 69                 157
1282932 1282932 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 2.0 07 09 2016   grade_9                         2.0 2.0                       4.0                         2 2                 4
1282938 1282938 IN     school 1802400 2270   Concord Community Schools 180240000269 1715 Concord Community High School   Regular School No 3.0 09 12 2016   grade_9                         231.0 228.0                       459.0                         231 228                 459
1282978 1282978 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 05 09 2016   grade_9                         0.0 1.0                       1.0                         0 1                 1
1282996 1282996 IN     school 1806600 2275   Middlebury Community Schools 180660001165 1733 Northridge High School   Regular School No 3.0 09 12 2016   grade_9                         181.0 182.0                       363.0                         181 182                 363
1283008 1283008 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_9                         1.0 0.0                       1.0                         1 0                 1
1283020 1283020 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No 3.0 09 12 2016   grade_9                         107.0 125.0                       232.0                         107 125                 232
1283083 1283083 IN     school 1803270 2305   Elkhart Community Schools 180327000429 1749 Elkhart Central High School   Regular School No 3.0 09 12 2016   grade_9                         247.0 241.0                       488.0                         247 241                 488
1283089 1283089 IN     school 1803270 2305   Elkhart Community Schools 180327000430 1750 Elkhart Memorial High School   Regular School No 3.0 09 12 2016   grade_9                         212.0 221.0                       433.0                         212 221                 433
1283102 1283102 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_9                         20.0 7.0                       27.0                         20 7                 27
1283192 1283192 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2016   grade_9                         5.0 2.0                       7.0                         5 2                 7
1283211 1283211 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No 3.0 09 12 2016   grade_9                         265.0 224.0                       489.0                         265 224                 489
1283260 1283260 IN     school 1803510 2395   Fayette County School Corp 180351000498 1889 Connersville Sr High School   Regular School No 3.0 09 12 2016   grade_9                         157.0 162.0                       319.0                         157 162                 319
1283313 1283313 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001277 1925 New Albany Senior High School   Regular School No 3.0 09 12 2016   grade_9                         235.0 249.0                       484.0                         235 249                 484
1283324 1283324 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001265 1930 Floyd Central High School   Regular School No 3.0 09 12 2016   grade_9                         243.0 214.0                       457.0                         243 214                 457
1283396 1283396 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No 3.0 07 12 2016   grade_9                         38.0 23.0                       61.0                         38 23                 61
1283410 1283410 IN     school 1802430 2440   Covington Community Sch Corp 180243000275 2005 Covington Community High School   Regular School No 3.0 09 12 2016   grade_9                         43.0 38.0                       81.0                         43 38                 81
1283437 1283437 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2016   grade_9                         55.0 42.0                       97.0                         55 42                 97
1283453 1283453 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2016   grade_9                         106.0 114.0                       220.0                         106 114                 220
1283481 1283481 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2016   grade_9                         72.0 61.0                       133.0                         72 61                 133
1283509 1283509 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         22.0 25.0                       47.0                         22 25                 47
1283534 1283534 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2016   grade_9                         49.0 33.0                       82.0                         49 33                 82
1283557 1283557 IN     school 1807770 2735   North Gibson School Corp 180777001326 2249 Princeton Comm High Sch   Regular School No 3.0 09 12 2016   grade_9                         84.0 67.0                       151.0                         84 67                 151
1283577 1283577 IN     school 1810350 2765   South Gibson School Corp 181035001688 2211 Gibson Southern High School   Regular School No 3.0 09 12 2016   grade_9                         97.0 86.0                       183.0                         97 86                 183
1283620 1283620 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303000399 2293 Eastbrook High School   Regular School No 3.0 09 12 2016   grade_9                         82.0 69.0                       151.0                         82 69                 151
1283628 1283628 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001097 2321 Madison-Grant High School   Regular School No 3.0 09 12 2016   grade_9                         51.0 55.0                       106.0                         51 55                 106
1283653 1283653 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No 3.0 09 12 2016   grade_9                         106.0 88.0                       194.0                         106 88                 194
1283674 1283674 IN     school 1806390 2865   Marion Community Schools 180639001117 2351 Marion High School   Regular School No 3.0 09 12 2016   grade_9                         138.0 125.0                       263.0                         138 125                 263

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