Data source: Big Local News · About: Big Local

421 rows where grade = "grade_11", state = "IN" and year = 2020 sorted by school descending

View and edit SQL

year

  • 2020 · 421

grade

  • grade_11 · 421
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
1907781 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2020   grade_11                         269.0 241.0                       510.0                         269 241                 510
1908845 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2020   grade_11                         4.0 5.0                       9.0                         4 5                 9
1908758 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2020   grade_11                         91.0 111.0                       202.0                         91 111                 202
1907514 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         58.0 65.0                       123.0                         58 65                 123
1915725 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High School   Regular School No High 09 12 2020   grade_11                         57.0 43.0                       100.0                         57 43                 100
1915546 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001205 6997 Winamac Community High School   Regular School No High 09 12 2020   grade_11                         31.0 37.0                       68.0                         31 37                 68
1908041 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_11                         35.0 20.0                       55.0                         35 20                 55
1916862 IN     school 1811340 7865   Tippecanoe School Corp 181134001835 8029 William Henry Harrison High School   Regular School No High 09 12 2020   grade_11                         266.0 235.0                       501.0                         266 235                 501
1917126 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000490 8311 William Henry Harrison High School   Regular School No High 09 12 2020   grade_11                         120.0 138.0                       258.0                         120 138                 258
1911774 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         58.0 38.0                       96.0                         58 38                 96
1912501 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2020   grade_11                         46.0 59.0                       105.0                         46 59                 105
1911334 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000246 3421 Whiteland Community High School   Regular School No High 09 12 2020   grade_11                         245.0 208.0                       453.0                         245 208                 453
1917533 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 06 12 2020   grade_11                         58.0 33.0                       91.0                         58 33                 91
1909855 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_11                         23.0 32.0                       55.0                         23 32                 55
1915315 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2020   grade_11                         66.0 56.0                       122.0                         66 56                 122
1912556 IN     school 1807470 4860   M S D of New Durham Township 180747001294 4701 Westville High School   Regular School No High 07 12 2020   grade_11                         37.0 35.0                       72.0                         37 35                 72
1911799 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2020   grade_11                         38.0 52.0                       90.0                         38 52                 90
1910017 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No High 09 12 2020   grade_11                         305.0 272.0                       577.0                         305 272                 577
1910877 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 09 12 2020   grade_11                         98.0 102.0                       200.0                         98 102                 200
1907762 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         77.0 66.0                       143.0                         77 66                 143
1917736 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         45.0 39.0                       84.0                         45 39                 84
1917299 IN     school 1812090 8030   Vigo County School Corp 181209001923 8453 West Vigo High School   Regular School No High 09 12 2020   grade_11                         78.0 65.0                       143.0                         78 65                 143
1912217 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No High 09 12 2020   grade_11                         135.0 89.0                       224.0                         135 89                 224
1914944 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2020   grade_11                         66.0 86.0                       152.0                         66 86                 152
1916904 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         84.0 89.0                       173.0                         84 89                 173
1915552 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2020   grade_11                         23.0 41.0                       64.0                         23 41                 64
1908705 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High School   Regular School No High 06 12 2020   grade_11                         25.0 25.0                       50.0                         25 25                 50
1907313 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2020   grade_11                         178.0 138.0                       316.0                         178 138                 316
1911651 IN     school 1805550 4345   Wawasee Community School Corp 180555001007 3639 Wawasee High School   Regular School No High 09 12 2020   grade_11                         108.0 108.0                       216.0                         108 108                 216
1915280 IN     school 1809000 6510   East Porter County School Corp 180900002009 6849 Washington Twp Middle/High School   Regular School No High 06 12 2020   grade_11                         38.0 32.0                       70.0                         38 32                 70
1908429 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2020   grade_11                         96.0 91.0                       187.0                         96 91                 187
1916143 IN     school 1810290 7205   South Bend Community School Corp 181029001684 7517 Washington High School   Regular School No High 09 12 2020   grade_11                         74.0 84.0                       158.0                         74 84                 158
1911692 IN     school 1812420 4415   Warsaw Community Schools 181242001999 3647 Warsaw Community High School   Regular School No High 09 12 2020   grade_11                         252.0 247.0                       499.0                         252 247                 499
1913401 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No High 09 12 2020   grade_11                         470.0 421.0                       891.0                         470 421                 891
1908722 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001047 1375 Wapahani High School   Regular School No High 09 12 2020   grade_11                         49.0 34.0                       83.0                         49 34                 83
1916363 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2020   grade_11                         28.0 23.0                       51.0                         28 23                 51
1909606 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No High 09 12 2020   grade_11                         33.0 39.0                       72.0                         33 39                 72
1917548 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2020   grade_11                         64.0 61.0                       125.0                         64 61                 125
1917321 IN     school 1812090 8030   Vigo County School Corp 181209002676 8483 Vigo Virtual School Academy   Regular School No High 06 12 2020   grade_11                         13.0 17.0                       30.0                         13 17                 30
1918520 IN     school 1800051 9575   Victory College Prep Academy 180005102165 5523 Victory College Prep Academy   Regular School Yes Other KG 12 2020   grade_11                         26.0 28.0                       54.0                         26 28                 54
1915408 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2020   grade_11                         244.0 226.0                       470.0                         244 226                 470
1915667 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2020   grade_11                         7.0 12.0                       19.0                         7 12                 19
1916953 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001869 8193 Union County High School   Regular School No High 09 12 2020   grade_11                         60.0 54.0                       114.0                         60 54                 114
1915751 IN     school 1803180 6835   Randolph Eastern School Corp 180318000415 7161 Union City Community Jr/Sr High   Regular School No High 07 12 2020   grade_11                         41.0 26.0                       67.0                         41 26                 67
1918006 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2020   grade_11                         97.0 98.0                       195.0                         97 98                 195
1914306 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         30.0 33.0                       63.0                         30 33                 63
1916380 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2020   grade_11                         65.0 77.0                       142.0                         65 77                 142
1910477 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No High 09 12 2020   grade_11                         75.0 67.0                       142.0                         75 67                 142
1917987 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 07 12 2020   grade_11                         31.0 20.0                       51.0                         31 20                 51
1910712 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No High 06 12 2020   grade_11                         35.0 28.0                       63.0                         35 28                 63
1916928 IN     school 1808040 7935   Tri-Central Community Schools 180804001379 8155 Tri Central Middle-High School   Regular School No High 06 12 2020   grade_11                         36.0 24.0                       60.0                         36 24                 60
1916948 IN     school 1811400 7945   Tipton Community School Corp 181140001843 8177 Tipton High School   Regular School No High 09 12 2020   grade_11                         62.0 71.0                       133.0                         62 71                 133
1911740 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No High 09 12 2020   grade_11                         65.0 70.0                       135.0                         65 70                 135
1918118 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2020   grade_11                         58.0 42.0                       100.0                         58 42                 100
1912150 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2020   grade_11                         64.0 36.0                       100.0                         64 36                 100
1918131 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2020   grade_11                         40.0 27.0                       67.0                         40 27                 67
1918432 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_11                         48.0 37.0                       85.0                         48 37                 85
1914553 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No High 09 12 2020   grade_11                         15.0 11.0                       26.0                         15 11                 26
1917304 IN     school 1812090 8030   Vigo County School Corp 181209001918 8457 Terre Haute South Vigo High School   Regular School No High 09 12 2020   grade_11                         214.0 176.0                       390.0                         214 176                 390
1917290 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2020   grade_11                         207.0 180.0                       387.0                         207 180                 387
1915124 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         45.0 50.0                       95.0                         45 50                 95
1917625 IN     school 1812390 8130   Warrick County School Corp 181239001986 8772 Tecumseh High School   Regular School No High 09 12 2020   grade_11                         43.0 38.0                       81.0                         43 38                 81
1910819 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No High 09 12 2020   grade_11                         43.0 43.0                       86.0                         43 43                 86
1916712 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High School   Regular School No High 09 12 2020   grade_11                         54.0 44.0                       98.0                         54 44                 98
1916684 IN     school 1810860 7715   Southwest School Corporation 181086001773 7957 Sullivan High School   Regular School No High 09 12 2020   grade_11                         70.0 72.0                       142.0                         70 72                 142
1918919 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_11                         23.0 19.0                       42.0                         23 19                 42
1915009 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High School   Regular School No High 06 12 2020   grade_11                         30.0 35.0                       65.0                         30 35                 65
1914172 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No High 09 12 2020   grade_11                         59.0 68.0                       127.0                         59 68                 127
1917513 IN     school 1812180 8050   M S D Wabash County Schools 181218001948 8655 Southwood Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         36.0 36.0                       72.0                         36 36                 72
1911252 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001767 3337 Southwestern High School   Regular School No High 09 12 2020   grade_11                         52.0 40.0                       92.0                         52 40                 92
1916397 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No High 07 12 2020   grade_11                         27.0 21.0                       48.0                         27 21                 48
1908915 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No High 09 12 2020   grade_11                         65.0 59.0                       124.0                         65 59                 124
1913220 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No High 09 12 2020   grade_11                         309.0 264.0                       573.0                         309 264                 573
1914639 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No High 09 12 2020   grade_11                         66.0 53.0                       119.0                         66 53                 119
1917901 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         35.0 32.0                       67.0                         35 32                 67
1917272 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001739 8432 South Vermillion High School   Regular School No High 09 12 2020   grade_11                         64.0 75.0                       139.0                         64 75                 139
1916510 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No High 09 12 2020   grade_11                         59.0 41.0                       100.0                         59 41                 100
1907176 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2020   grade_11                         156.0 157.0                       313.0                         156 157                 313
1915780 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2020   grade_11                         54.0 38.0                       92.0                         54 38                 92
1915587 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No High 09 12 2020   grade_11                         60.0 44.0                       104.0                         60 44                 104
1914860 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High School   Regular School No High 09 12 2020   grade_11                         34.0 30.0                       64.0                         34 30                 64
1911578 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2020   grade_11                         39.0 46.0                       85.0                         39 46                 85
1908545 IN     school 1802610 1655   Decatur County Community Schools 180261000311 1263 South Decatur Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         48.0 39.0                       87.0                         48 39                 87
1908510 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2020   grade_11                         107.0 97.0                       204.0                         107 97                 204
1912666 IN     school 1802190 4940   South Central Com School Corp 180219000263 4737 South Central Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         38.0 41.0                       79.0                         38 41                 79
1910449 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No High 07 12 2020   grade_11                         29.0 23.0                       52.0                         29 23                 52
1907028 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_11                         53.0 45.0                       98.0                         53 45                 98
1918707 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2020   grade_11                         10.0 0.0                       10.0                         10 0                 10
1908026 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_11                         113.0 119.0                       232.0                         113 119                 232
1918301 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2020   grade_11                         44.0 54.0                       98.0                         44 54                 98
1913735 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5492 Shortridge High School   Regular School No High 09 12 2020   grade_11                         141.0 126.0                       267.0                         141 126                 267
1914313 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Community High School   Regular School No High 09 12 2020   grade_11                         31.0 21.0                       52.0                         31 21                 52
1910059 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No High 09 12 2020   grade_11                         47.0 35.0                       82.0                         47 35                 82
1910735 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No High 09 12 2020   grade_11                         52.0 47.0                       99.0                         52 47                 99
1916425 IN     school 1810140 7365   Shelbyville Central Schools 181014001631 7717 Shelbyville Sr High School   Regular School No High 09 12 2020   grade_11                         162.0 141.0                       303.0                         162 141                 303
1909840 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         31.0 36.0                       67.0                         31 36                 67
1911051 IN     school 1810080 3675   Seymour Community Schools 181008001618 3133 Seymour Senior High School   Regular School No High 09 12 2020   grade_11                         201.0 159.0                       360.0                         201 159                 360
1918929 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_11                         10.0 5.0                       15.0                         10 5                 15
1917581 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         47.0 45.0                       92.0                         47 45                 92
1916323 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2020   grade_11                         126.0 91.0                       217.0                         126 91                 217

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