enrollments

Data source: Big Local News · About: Big Local

420 rows where grade = "grade_11", state = "IN" and year = 2016 sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 420 ✖

grade ✖

  • grade_11 · 420 ✖
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
1281668 1281668 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No 3.0 09 12 2016   grade_11                         242.0 229.0                       471.0                         242 229                 471
1282772 1282772 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_11                         6.0 4.0                       10.0                         6 4                 10
1282668 1282668 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No 3.0 09 12 2016   grade_11                         78.0 100.0                       178.0                         78 100                 178
1281396 1281396 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_11                         77.0 53.0                       130.0                         77 53                 130
1286197 1286197 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2016   grade_11                         34.0 56.0                       90.0                         34 56                 90
1289782 1289782 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High School   Regular School No 3.0 09 12 2016   grade_11                         63.0 57.0                       120.0                         63 57                 120
1289624 1289624 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001205 6997 Winamac Community High School   Regular School No 3.0 09 12 2016   grade_11                         49.0 45.0                       94.0                         49 45                 94
1281917 1281917 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No 3.0 07 12 2016   grade_11                         30.0 29.0                       59.0                         30 29                 59
1290926 1290926 IN     school 1811340 7865   Tippecanoe School Corp 181134001835 8029 William Henry Harrison High School   Regular School No 3.0 09 12 2016   grade_11                         201.0 218.0                       419.0                         201 218                 419
1291169 1291169 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000490 8311 William Henry Harrison High School   Regular School No 3.0 09 12 2016   grade_11                         134.0 134.0                       268.0                         134 134                 268
1285676 1285676 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_11                         75.0 65.0                       140.0                         75 65                 140
1286498 1286498 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_11                         59.0 40.0                       99.0                         59 40                 99
1285259 1285259 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000246 3421 Whiteland Community High School   Regular School No 3.0 09 12 2016   grade_11                         224.0 211.0                       435.0                         224 211                 435
1291559 1291559 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         19.0 17.0                       36.0                         19 17                 36
1283771 1283771 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 2016   grade_11                         17.0 32.0                       49.0                         17 32                 49
1289394 1289394 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No 3.0 09 12 2016   grade_11                         67.0 66.0                       133.0                         67 66                 133
1286555 1286555 IN     school 1807470 4860   M S D of New Durham Township 180747001294 4701 Westville High School   Regular School No 3.0 07 12 2016   grade_11                         39.0 38.0                       77.0                         39 38                 77
1285698 1285698 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         50.0 47.0                       97.0                         50 47                 97
1283930 1283930 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2016   grade_11                         232.0 240.0                       472.0                         232 240                 472
1284778 1284778 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 3.0 08 12 2016   grade_11                         98.0 98.0                       196.0                         98 98                 196
1281648 1281648 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_11                         74.0 58.0                       132.0                         74 58                 132
1291754 1291754 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         32.0 33.0                       65.0                         32 33                 65
1291339 1291339 IN     school 1812090 8030   Vigo County School Corp 181209001923 8453 West Vigo High School   Regular School No 3.0 09 12 2016   grade_11                         77.0 59.0                       136.0                         77 59                 136
1286192 1286192 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No 3.0 09 12 2016   grade_11                         79.0 81.0                       160.0                         79 81                 160
1289014 1289014 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2016   grade_11                         84.0 81.0                       165.0                         84 81                 165
1290969 1290969 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_11                         90.0 88.0                       178.0                         90 88                 178
1289630 1289630 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No 3.0 09 12 2016   grade_11                         36.0 33.0                       69.0                         36 33                 69
1282617 1282617 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_11                         40.0 24.0                       64.0                         40 24                 64
1281187 1281187 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2016   grade_11                         160.0 120.0                       280.0                         160 120                 280
1285552 1285552 IN     school 1805550 4345   Wawasee Community School Corp 180555001007 3639 Wawasee High School   Regular School No 3.0 09 12 2016   grade_11                         110.0 138.0                       248.0                         110 138                 248
1289361 1289361 IN     school 1809000 6510   East Porter County School Corp 180900002009 6849 Washington Twp Middle/High School   Regular School No 4.0 06 12 2016   grade_11                         36.0 18.0                       54.0                         36 18                 54
1282344 1282344 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2016   grade_11                         92.0 96.0                       188.0                         92 96                 188
1290197 1290197 IN     school 1810290 7205   South Bend Community Sch Corp 181029001684 7517 Washington High School   Regular School No 3.0 09 12 2016   grade_11                         99.0 116.0                       215.0                         99 116                 215
1285594 1285594 IN     school 1812420 4415   Warsaw Community Schools 181242001999 3647 Warsaw Community High School   Regular School No 3.0 09 12 2016   grade_11                         260.0 254.0                       514.0                         260 254                 514
1287407 1287407 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No 3.0 09 12 2016   grade_11                         441.0 465.0                       906.0                         441 465                 906
1282632 1282632 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001047 1375 Wapahani High School   Regular School No 3.0 09 12 2016   grade_11                         49.0 51.0                       100.0                         49 51                 100
1290427 1290427 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         23.0 23.0                       46.0                         23 23                 46
1283532 1283532 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2016   grade_11                         43.0 46.0                       89.0                         43 46                 89
1291571 1291571 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No 3.0 09 12 2016   grade_11                         40.0 61.0                       101.0                         40 61                 101
1289487 1289487 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No 3.0 09 12 2016   grade_11                         232.0 242.0                       474.0                         232 242                 474
1289743 1289743 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No 3.0 07 12 2016   grade_11                         13.0 12.0                       25.0                         13 12                 25
1291017 1291017 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001869 8193 Union County High School   Regular School No 3.0 09 12 2016   grade_11                         67.0 51.0                       118.0                         67 51                 118
1289808 1289808 IN     school 1803180 6835   Randolph Eastern School Corp 180318000415 7161 Union City Community Jr/Sr HS   Regular School No 3.0 07 12 2016   grade_11                         34.0 38.0                       72.0                         34 38                 72
1292023 1292023 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No 3.0 09 12 2016   grade_11                         93.0 87.0                       180.0                         93 87                 180
1289231 1289231 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801858 6649 Turkey Run Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_11                         18.0 20.0                       38.0                         18 20                 38
1288358 1288358 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         35.0 27.0                       62.0                         35 27                 62
1290444 1290444 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No 3.0 09 12 2016   grade_11                         47.0 58.0                       105.0                         47 58                 105
1284385 1284385 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No 3.0 09 12 2016   grade_11                         76.0 70.0                       146.0                         76 70                 146
1292004 1292004 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Middle-Senior High   Regular School No 3.0 07 12 2016   grade_11                         29.0 29.0                       58.0                         29 29                 58
1284614 1284614 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_11                         37.0 38.0                       75.0                         37 38                 75
1290992 1290992 IN     school 1808040 7935   Tri-Central Community Schools 180804001379 8155 Tri Central Middle-High School   Regular School No 4.0 06 12 2016   grade_11                         43.0 41.0                       84.0                         43 41                 84
1291012 1291012 IN     school 1811400 7945   Tipton Community School Corp 181140001843 8177 Tipton High School   Regular School No 3.0 09 12 2016   grade_11                         73.0 70.0                       143.0                         73 70                 143
1285641 1285641 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No 3.0 09 12 2016   grade_11                         80.0 90.0                       170.0                         80 90                 170
1292100 1292100 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No 3.0 07 12 2016   grade_11                         51.0 35.0                       86.0                         51 35                 86
1286082 1286082 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         41.0 45.0                       86.0                         41 45                 86
1292113 1292113 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No 3.0 07 12 2016   grade_11                         61.0 54.0                       115.0                         61 54                 115
1292317 1292317 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         52.0 56.0                       108.0                         52 56                 108
1288609 1288609 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No 3.0 09 12 2016   grade_11                         12.0 8.0                       20.0                         12 8                 20
1291344 1291344 IN     school 1812090 8030   Vigo County School Corp 181209001918 8457 Terre Haute South Vigo High School   Regular School No 3.0 09 12 2016   grade_11                         238.0 210.0                       448.0                         238 210                 448
1291330 1291330 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No 3.0 09 12 2016   grade_11                         210.0 220.0                       430.0                         210 220                 430
1289191 1289191 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         54.0 44.0                       98.0                         54 44                 98
1291645 1291645 IN     school 1812390 8130   Warrick County School Corp 181239001986 8772 Tecumseh Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         35.0 31.0                       66.0                         35 31                 66
1284720 1284720 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No 3.0 09 12 2016   grade_11                         46.0 47.0                       93.0                         46 47                 93
1290777 1290777 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High Sch   Regular School No 3.0 09 12 2016   grade_11                         65.0 55.0                       120.0                         65 55                 120
1290748 1290748 IN     school 1810860 7715   Southwest School Corp 181086001773 7957 Sullivan High School   Regular School No 3.0 09 12 2016   grade_11                         74.0 67.0                       141.0                         74 67                 141
1289079 1289079 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High Sch   Regular School No 4.0 06 12 2016   grade_11                         28.0 23.0                       51.0                         28 23                 51
1288227 1288227 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No 3.0 09 12 2016   grade_11                         60.0 58.0                       118.0                         60 58                 118
1291536 1291536 IN     school 1812180 8050   M S D Wabash County Schools 181218001948 8655 Southwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         38.0 31.0                       69.0                         38 31                 69
1285178 1285178 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001767 3337 Southwestern High School   Regular School No 3.0 09 12 2016   grade_11                         45.0 49.0                       94.0                         45 49                 94
1290462 1290462 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No 3.0 07 12 2016   grade_11                         27.0 37.0                       64.0                         27 37                 64
1282843 1282843 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No 3.0 09 12 2016   grade_11                         73.0 51.0                       124.0                         73 51                 124
1287221 1287221 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No 3.0 09 12 2016   grade_11                         278.0 250.0                       528.0                         278 250                 528
1288691 1288691 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No 3.0 09 12 2016   grade_11                         72.0 54.0                       126.0                         72 54                 126
1291919 1291919 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_11                         41.0 40.0                       81.0                         41 40                 81
1291313 1291313 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001739 8432 South Vermillion High School   Regular School No 3.0 09 12 2016   grade_11                         63.0 67.0                       130.0                         63 67                 130
1290575 1290575 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No 3.0 09 12 2016   grade_11                         51.0 55.0                       106.0                         51 55                 106
1281050 1281050 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2016   grade_11                         180.0 185.0                       365.0                         180 185                 365
1289836 1289836 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No 3.0 09 12 2016   grade_11                         32.0 39.0                       71.0                         32 39                 71
1289664 1289664 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No 3.0 09 12 2016   grade_11                         47.0 40.0                       87.0                         47 40                 87
1288919 1288919 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High Sch   Regular School No 3.0 09 12 2016   grade_11                         24.0 19.0                       43.0                         24 19                 43
1285480 1285480 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2016   grade_11                         44.0 49.0                       93.0                         44 49                 93
1282460 1282460 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_11                         35.0 37.0                       72.0                         35 37                 72
1282426 1282426 IN     school 1800240 1600   South Dearborn Com School Corp 180024000056 1179 South Dearborn High School   Regular School No 3.0 09 12 2016   grade_11                         116.0 109.0                       225.0                         116 109                 225
1286664 1286664 IN     school 1802190 4940   South Central Com School Corp 180219000263 4737 South Central Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         39.0 42.0                       81.0                         39 42                 81
1284356 1284356 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No 4.0 06 12 2016   grade_11                         25.0 27.0                       52.0                         25 27                 52
1280893 1280893 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_11                         54.0 50.0                       104.0                         54 50                 104
1292626 1292626 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_11                         13.0 0.0                       13.0                         13 0                 13
1281902 1281902 IN     school 1809370 940   West Clark Community Schools 180937001536 777 Silver Creek High School   Regular School No 3.0 09 12 2016   grade_11                         116.0 125.0                       241.0                         116 125                 241
1292165 1292165 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2016   grade_11                         37.0 51.0                       88.0                         37 51                 88
1287733 1287733 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5485 Shortridge High School   Regular School No 3.0 09 12 2016   grade_11                         40.0 47.0                       87.0                         40 47                 87
1288365 1288365 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Comm Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         31.0 15.0                       46.0                         31 15                 46
1283972 1283972 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2016   grade_11                         42.0 31.0                       73.0                         42 31                 73
1284637 1284637 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No 3.0 09 12 2016   grade_11                         51.0 49.0                       100.0                         51 49                 100
1290491 1290491 IN     school 1810140 7365   Shelbyville Central Schools 181014001631 7717 Shelbyville Sr High School   Regular School No 3.0 09 12 2016   grade_11                         156.0 134.0                       290.0                         156 134                 290
1283756 1283756 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         31.0 37.0                       68.0                         31 37                 68
1284958 1284958 IN     school 1810080 3675   Seymour Community Schools 181008001618 3133 Seymour Senior High School   Regular School No 3.0 09 12 2016   grade_11                         176.0 139.0                       315.0                         176 139                 315
1291604 1291604 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         41.0 37.0                       78.0                         41 37                 78
1290388 1290388 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No 3.0 09 12 2016   grade_11                         103.0 90.0                       193.0                         103 90                 193
1287634 1287634 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_11                         4.0 1.0                       5.0                         4 1                 5
1291722 1291722 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No 3.0 09 12 2016   grade_11                         77.0 79.0                       156.0                         77 79                 156

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