Data source: Big Local News · About: Big Local

423 rows where grade = "grade_11", state = "IN" and year = 2019 sorted by school 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
1752344 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2019   grade_11                         250.0 242.0                       492.0                         250 242                 492
1753414 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_11                         16.0 9.0                       25.0                         16 9                 25
1753327 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2019   grade_11                         97.0 93.0                       190.0                         97 93                 190
1752074 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2019   grade_11                         76.0 73.0                       149.0                         76 73                 149
1760314 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High School   Regular School No High 09 12 2019   grade_11                         53.0 59.0                       112.0                         53 59                 112
1760138 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001205 6997 Winamac Community High School   Regular School No High 09 12 2019   grade_11                         46.0 51.0                       97.0                         46 51                 97
1752602 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No High 07 12 2019   grade_11                         28.0 24.0                       52.0                         28 24                 52
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
1761721 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000490 8311 William Henry Harrison High School   Regular School No High 09 12 2019   grade_11                         136.0 132.0                       268.0                         136 132                 268
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
1755891 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000246 3421 Whiteland Community High School   Regular School No High 09 12 2019   grade_11                         243.0 195.0                       438.0                         243 195                 438
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
1754422 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_11                         37.0 35.0                       72.0                         37 35                 72
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
1757120 IN     school 1807470 4860   M S D of New Durham Township 180747001294 4701 Westville High School   Regular School No High 07 12 2019   grade_11                         36.0 43.0                       79.0                         36 43                 79
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
1755430 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_11                         96.0 111.0                       207.0                         96 111                 207
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
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
1756769 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No High 09 12 2019   grade_11                         130.0 126.0                       256.0                         130 126                 256
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
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
1760143 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2019   grade_11                         27.0 28.0                       55.0                         27 28                 55
1753274 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High School   Regular School No High 06 12 2019   grade_11                         40.0 38.0                       78.0                         40 38                 78
1751873 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2019   grade_11                         191.0 154.0                       345.0                         191 154                 345
1756195 IN     school 1805550 4345   Wawasee Community School Corp 180555001007 3639 Wawasee High School   Regular School No High 09 12 2019   grade_11                         128.0 83.0                       211.0                         128 83                 211
1759871 IN     school 1809000 6510   East Porter County School Corp 180900002009 6849 Washington Twp Middle/High School   Regular School No High 06 12 2019   grade_11                         30.0 30.0                       60.0                         30 30                 60
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
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
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
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
1753291 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001047 1375 Wapahani High School   Regular School No High 09 12 2019   grade_11                         33.0 49.0                       82.0                         33 49                 82
1760954 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2019   grade_11                         19.0 15.0                       34.0                         19 15                 34
1754180 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No High 09 12 2019   grade_11                         24.0 25.0                       49.0                         24 25                 49
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
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
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
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
1760340 IN     school 1803180 6835   Randolph Eastern School Corp 180318000415 7161 Union City Community Jr/Sr High   Regular School No High 07 12 2019   grade_11                         34.0 31.0                       65.0                         34 31                 65
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
1760971 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2019   grade_11                         54.0 59.0                       113.0                         54 59                 113
1755031 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No High 09 12 2019   grade_11                         75.0 72.0                       147.0                         75 72                 147
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
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
1761522 IN     school 1808040 7935   Tri-Central Community Schools 180804001379 8155 Tri Central Middle-High School   Regular School No High 06 12 2019   grade_11                         33.0 19.0                       52.0                         33 19                 52
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
1758285 IN     school 1804770 5385   Indianapolis Public Schools 180477002653 109 Thrival Academy   Regular School No Secondary 11 11 2019   grade_11                         23.0 27.0                       50.0                         23 27                 50
1762665 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2019   grade_11                         35.0 37.0                       72.0                         35 37                 72
1756710 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2019   grade_11                         54.0 38.0                       92.0                         54 38                 92
1762678 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2019   grade_11                         45.0 37.0                       82.0                         45 37                 82
1762964 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_11                         56.0 50.0                       106.0                         56 50                 106
1759138 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No High 09 12 2019   grade_11                         12.0 10.0                       22.0                         12 10                 22
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
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
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
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
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
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
1763507 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_11                         30.0 39.0                       69.0                         30 39                 69
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
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
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
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
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
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
1757801 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No High 09 12 2019   grade_11                         297.0 262.0                       559.0                         297 262                 559
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
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
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
1751736 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_11                         182.0 192.0                       374.0                         182 192                 374
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
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
1753113 IN     school 1802610 1655   Decatur County Community Schools 180261000311 1263 South Decatur Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         38.0 49.0                       87.0                         38 49                 87
1753079 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2019   grade_11                         99.0 102.0                       201.0                         99 102                 201
1757230 IN     school 1802190 4940   South Central Com School Corp 180219000263 4737 South Central Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         37.0 37.0                       74.0                         37 37                 74
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
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
1763245 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_11                         8.0 0.0                       8.0                         8 0                 8
1752587 IN     school 1809370 940   West Clark Community Schools 180937001536 777 Silver Creek High School   Regular School No High 09 12 2019   grade_11                         119.0 101.0                       220.0                         119 101                 220
1762838 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2019   grade_11                         51.0 50.0                       101.0                         51 50                 101
1758307 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5492 Shortridge High School   Regular School No High 09 12 2019   grade_11                         92.0 112.0                       204.0                         92 112                 204
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
1754618 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No High 09 12 2019   grade_11                         39.0 29.0                       68.0                         39 29                 68
1755288 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No High 09 12 2019   grade_11                         54.0 44.0                       98.0                         54 44                 98
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
1762162 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         41.0 53.0                       94.0                         41 53                 94
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
1758209 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_11                         6.0 0.0                       6.0                         6 0                 6
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]);