Data source: Big Local News · About: Big Local

423 rows where grade = "grade_11", state = "IN" and year = 2019 sorted by district_nces_id descending

View and edit SQL

year

  • 2019 · 423

grade

  • grade_11 · 423
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
1754356 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   grade_11                         1.0 0.0                       1.0                         1 0                 1
1758209 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_11                         6.0 0.0                       6.0                         6 0                 6
1756317 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_11                         53.0 51.0                       104.0                         53 51                 104
1757065 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2019   grade_11                         59.0 55.0                       114.0                         59 55                 114
1756342 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2019   grade_11                         45.0 39.0                       84.0                         45 39                 84
1754576 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2019   grade_11                         301.0 262.0                       563.0                         301 262                 563
1762349 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No High 09 12 2019   grade_11                         39.0 31.0                       70.0                         39 31                 70
1752325 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         75.0 53.0                       128.0                         75 53                 128
1762317 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         40.0 35.0                       75.0                         40 35                 75
1759534 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2019   grade_11                         92.0 76.0                       168.0                         92 76                 168
1757416 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         62.0 59.0                       121.0                         62 59                 121
1757432 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2019   grade_11                         66.0 46.0                       112.0                         66 46                 112
1761497 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2019   grade_11                         107.0 82.0                       189.0                         107 82                 189
1758128 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No High 10 12 2019   grade_11                         567.0 533.0                       1100.0                         567 533                 1100
1758238 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_11                         24.0 26.0                       50.0                         24 26                 50
1758251 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No High 10 12 2019   grade_11                         39.0 99.0                       138.0                         39 99                 138
1758123 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No High 09 12 2019   grade_11                         437.0 435.0                       872.0                         437 435                 872
1752998 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2019   grade_11                         95.0 84.0                       179.0                         95 84                 179
1756236 IN     school 1812420 4415   Warsaw Community Schools 181242001999 3647 Warsaw Community High School   Regular School No High 09 12 2019   grade_11                         261.0 257.0                       518.0                         261 257                 518
1762206 IN     school 1812390 8130   Warrick County School Corp 181239001986 8772 Tecumseh High School   Regular School No High 09 12 2019   grade_11                         42.0 36.0                       78.0                         42 36                 78
1762239 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2019   grade_11                         139.0 95.0                       234.0                         139 95                 234
1762256 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2019   grade_11                         207.0 262.0                       469.0                         207 262                 469
1757982 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2019   grade_11                         489.0 471.0                       960.0                         489 471                 960
1753662 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No High 09 12 2019   grade_11                         124.0 121.0                       245.0                         124 121                 245
1762089 IN     school 1812180 8050   M S D Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         29.0 32.0                       61.0                         29 32                 61
1762096 IN     school 1812180 8050   M S D Wabash County Schools 181218001948 8655 Southwood Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         36.0 40.0                       76.0                         36 40                 76
1762116 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         47.0 30.0                       77.0                         47 30                 77
1762129 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2019   grade_11                         55.0 52.0                       107.0                         55 52                 107
1756136 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2019   grade_11                         90.0 66.0                       156.0                         90 66                 156
1761884 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2019   grade_11                         202.0 204.0                       406.0                         202 204                 406
1761893 IN     school 1812090 8030   Vigo County School Corp 181209001923 8453 West Vigo High School   Regular School No High 09 12 2019   grade_11                         75.0 79.0                       154.0                         75 79                 154
1761898 IN     school 1812090 8030   Vigo County School Corp 181209001918 8457 Terre Haute South Vigo High School   Regular School No High 09 12 2019   grade_11                         234.0 179.0                       413.0                         234 179                 413
1762059 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_11                         3.0 10.0                       13.0                         3 10                 13
1762064 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No High 07 12 2019   grade_11                         19.0 4.0                       23.0                         19 4                 23
1755661 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2019   grade_11                         14.0 10.0                       24.0                         14 10                 24
1759999 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2019   grade_11                         273.0 256.0                       529.0                         273 256                 529
1760867 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         57.0 43.0                       100.0                         57 43                 100
1760256 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2019   grade_11                         10.0 11.0                       21.0                         10 11                 21
1760271 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_11                         55.0 91.0                       146.0                         55 91                 146
1760277 IN     school 1811730 6795   Union School Corporation 181173002660 7142 Indiana Digital Alternative School   Regular School No High 09 12 2019   grade_11                         51.0 69.0                       120.0                         51 69                 120
1759906 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2019   grade_11                         65.0 63.0                       128.0                         65 63                 128
1761547 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001869 8193 Union County High School   Regular School No High 09 12 2019   grade_11                         52.0 44.0                       96.0                         52 44                 96
1762587 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2019   grade_11                         105.0 96.0                       201.0                         105 96                 201
1758887 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         29.0 21.0                       50.0                         29 21                 50
1756580 IN     school 1811460 4645   Tri-Creek School Corporation 181146001852 3865 Lowell Senior High School   Regular School No High 09 12 2019   grade_11                         133.0 151.0                       284.0                         133 151                 284
1762567 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2019   grade_11                         32.0 25.0                       57.0                         32 25                 57
1761542 IN     school 1811400 7945   Tipton Community School Corp 181140001843 8177 Tipton High School   Regular School No High 09 12 2019   grade_11                         61.0 53.0                       114.0                         61 53                 114
1756284 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No High 09 12 2019   grade_11                         62.0 51.0                       113.0                         62 51                 113
1761385 IN     school 1811340 7865   Tippecanoe School Corp 181134001830 8003 McCutcheon High School   Regular School No High 09 12 2019   grade_11                         242.0 219.0                       461.0                         242 219                 461
1761454 IN     school 1811340 7865   Tippecanoe School Corp 181134001835 8029 William Henry Harrison High School   Regular School No High 09 12 2019   grade_11                         243.0 229.0                       472.0                         243 229                 472
1759713 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         52.0 35.0                       87.0                         52 35                 87
1755370 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No High 09 12 2019   grade_11                         55.0 50.0                       105.0                         55 50                 105
1761305 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High School   Regular School No High 09 12 2019   grade_11                         45.0 54.0                       99.0                         45 54                 99
1753046 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001802 7213 East Central High School   Regular School No High 09 12 2019   grade_11                         161.0 150.0                       311.0                         161 150                 311
1761201 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2019   grade_11                         97.0 130.0                       227.0                         97 130                 227
1759600 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High School   Regular School No High 06 12 2019   grade_11                         41.0 33.0                       74.0                         41 33                 74
1759634 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2019   grade_11                         97.0 90.0                       187.0                         97 90                 187
1758754 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No High 09 12 2019   grade_11                         67.0 60.0                       127.0                         67 60                 127
1759665 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         37.0 37.0                       74.0                         37 37                 74
1753484 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No High 09 12 2019   grade_11                         57.0 69.0                       126.0                         57 69                 126
1761276 IN     school 1810860 7715   Southwest School Corporation 181086001773 7957 Sullivan High School   Regular School No High 09 12 2019   grade_11                         82.0 60.0                       142.0                         82 60                 142
1760988 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No High 07 12 2019   grade_11                         29.0 21.0                       50.0                         29 21                 50
1755809 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001767 3337 Southwestern High School   Regular School No High 09 12 2019   grade_11                         41.0 34.0                       75.0                         41 34                 75
1762481 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         34.0 20.0                       54.0                         34 20                 54
1760291 IN     school 1810740 6805   Randolph Southern School Corp 181074001763 7121 Randolph Southern Jr-Sr High Sch   Regular School No High 07 12 2019   grade_11                         24.0 16.0                       40.0                         24 16                 40
1754820 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001761 2565 New Palestine High School   Regular School No High 09 12 2019   grade_11                         155.0 143.0                       298.0                         155 143                 298
1752505 IN     school 1810680 815   Lewis Cass Schools 181068001755 689 Lewis Cass High School   Regular School No High 09 12 2019   grade_11                         70.0 45.0                       115.0                         70 45                 115
1754517 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No High 09 12 2019   grade_11                         427.0 435.0                       862.0                         427 435                 862
1754536 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No High 09 12 2019   grade_11                         426.0 414.0                       840.0                         426 414                 840
1753461 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         44.0 55.0                       99.0                         44 55                 99
1754086 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No High 07 12 2019   grade_11                         37.0 34.0                       71.0                         37 34                 71
1761866 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001739 8432 South Vermillion High School   Regular School No High 09 12 2019   grade_11                         72.0 58.0                       130.0                         72 58                 130
1761102 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No High 09 12 2019   grade_11                         49.0 50.0                       99.0                         49 50                 99
1760369 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2019   grade_11                         50.0 48.0                       98.0                         50 48                 98
1760178 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No High 09 12 2019   grade_11                         56.0 49.0                       105.0                         56 49                 105
1759448 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High School   Regular School No High 09 12 2019   grade_11                         28.0 27.0                       55.0                         28 27                 55
1759222 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No High 09 12 2019   grade_11                         73.0 63.0                       136.0                         73 63                 136
1757457 IN     school 1810440 5255   South Madison Com Sch Corp 181044001711 5053 Pendleton Heights High School   Regular School No High 09 12 2019   grade_11                         163.0 156.0                       319.0                         163 156                 319
1756121 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2019   grade_11                         46.0 61.0                       107.0                         46 61                 107
1755265 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No High 06 12 2019   grade_11                         28.0 26.0                       54.0                         28 26                 54
1754959 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2019   grade_11                         96.0 87.0                       183.0                         96 87                 183
1755002 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No High 06 12 2019   grade_11                         31.0 31.0                       62.0                         31 31                 62
1754226 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2019   grade_11                         74.0 81.0                       155.0                         74 81                 155
1760686 IN     school 1810290 7205   South Bend Community School Corp 181029001649 7421 Clay High School   Regular School No High 09 12 2019   grade_11                         114.0 130.0                       244.0                         114 130                 244
1760715 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2019   grade_11                         220.0 235.0                       455.0                         220 235                 455
1760728 IN     school 1810290 7205   South Bend Community School Corp 181029001660 7513 Riley High School   Regular School No High 09 12 2019   grade_11                         161.0 103.0                       264.0                         161 103                 264
1760733 IN     school 1810290 7205   South Bend Community School Corp 181029001684 7517 Washington High School   Regular School No High 09 12 2019   grade_11                         109.0 96.0                       205.0                         109 96                 205
1760745 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 09 12 2019   grade_11                         33.0 25.0                       58.0                         33 25                 58
1760860 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_11                         3.0 1.0                       4.0                         3 1                 4
1751587 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_11                         44.0 43.0                       87.0                         44 43                 87
1762610 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2019   grade_11                         46.0 48.0                       94.0                         46 48                 94
1758895 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Community High School   Regular School No High 09 12 2019   grade_11                         22.0 25.0                       47.0                         22 25                 47
1761005 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_11                         1.0 3.0                       4.0                         1 3                 4
1761017 IN     school 1810140 7365   Shelbyville Central Schools 181014001631 7717 Shelbyville Sr High School   Regular School No High 09 12 2019   grade_11                         149.0 136.0                       285.0                         149 136                 285
1754407 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         35.0 27.0                       62.0                         35 27                 62
1755605 IN     school 1810080 3675   Seymour Community Schools 181008001618 3133 Seymour Senior High School   Regular School No High 09 12 2019   grade_11                         204.0 184.0                       388.0                         204 184                 388
1760914 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2019   grade_11                         80.0 107.0                       187.0                         80 107                 187
1760882 IN     school 1809990 7230   Scott County School District 1 180999001605 7629 Austin High School   Regular School No High 09 12 2019   grade_11                         49.0 43.0                       92.0                         49 43                 92
1753340 IN     school 1809840 1940   Daleville Community Schools 180984001603 1401 Daleville Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         32.0 36.0                       68.0                         32 36                 68
1762282 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No High 09 12 2019   grade_11                         71.0 68.0                       139.0                         71 68                 139

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