Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by rowid descending

View and edit SQL

year

grade

  • grade_9 · 2,824
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
1928617 IN     school 1810860 7715   Southwest School Corporation 181086001773 7957 Sullivan High School   Regular School No High 09 12 2021   grade_9                         73.0 62.0                       135.0                         73 62                 135
1928583 IN     school 1808160 7645   Northeast School Corp 180816001402 7917 North Central Jr/Sr High School   Regular School No High 07 12 2021   grade_9                         50.0 33.0                       83.0                         50 33                 83
1928543 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   grade_9                         122.0 91.0                       213.0                         122 91                 213
1928530 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 06 12 2021   grade_9                         9.0 18.0                       27.0                         9 18                 27
1928510 IN     school 1803780 7605   Fremont Community Schools 180378000601 7877 Fremont High School   Regular School No High 09 12 2021   grade_9                         30.0 36.0                       66.0                         30 36                 66
1928493 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No High 09 12 2021   grade_9                         72.0 62.0                       134.0                         72 62                 134
1928479 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 N Judson-San Pierre Jr Sr High Sch   Regular School No High 07 12 2021   grade_9                         45.0 44.0                       89.0                         45 44                 89
1928472 IN     school 1808460 7495   Oregon-Davis School Corp 180846001435 7831 Oregon-Davis Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         19.0 22.0                       41.0                         19 22                 41
1928445 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No High 09 12 2021   grade_9                         44.0 50.0                       94.0                         44 50                 94
1928421 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No High 09 12 2021   grade_9                         67.0 74.0                       141.0                         67 74                 141
1928360 IN     school 1810140 7365   Shelbyville Central Schools 181014001631 7717 Shelbyville Sr High School   Regular School No High 09 12 2021   grade_9                         160.0 141.0                       301.0                         160 141                 301
1928353 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_9                         1.0 2.0                       3.0                         1 2                 3
1928334 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No High 07 12 2021   grade_9                         22.0 25.0                       47.0                         22 25                 47
1928315 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2021   grade_9                         61.0 42.0                       103.0                         61 42                 103
1928302 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2021   grade_9                         24.0 26.0                       50.0                         24 26                 50
1928286 IN     school 1803210 7285   Shelby Eastern Schools 180321000418 7661 Morristown Jr-Sr High School   Regular School No High 06 12 2021   grade_9                         22.0 12.0                       34.0                         22 12                 34
1928259 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2021   grade_9                         103.0 99.0                       202.0                         103 99                 202
1928226 IN     school 1809990 7230   Scott County School District 1 180999001605 7629 Austin High School   Regular School No High 09 12 2021   grade_9                         43.0 45.0                       88.0                         43 45                 88
1928213 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         51.0 43.0                       94.0                         51 43                 94
1928206 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2021   grade_9                         2.0 2.0                       4.0                         2 2                 4
1928092 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 09 12 2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1928080 IN     school 1810290 7205   South Bend Community School Corp 181029001684 7517 Washington High School   Regular School No High 09 12 2021   grade_9                         134.0 118.0                       252.0                         134 118                 252
1928075 IN     school 1810290 7205   South Bend Community School Corp 181029001660 7513 Riley High School   Regular School No High 09 12 2021   grade_9                         212.0 127.0                       339.0                         212 127                 339
1928062 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2021   grade_9                         255.0 255.0                       510.0                         255 255                 510
1928033 IN     school 1810290 7205   South Bend Community School Corp 181029001649 7421 Clay High School   Regular School No High 09 12 2021   grade_9                         100.0 89.0                       189.0                         100 89                 189
1928014 IN     school 1810290 7205   South Bend Community School Corp 181029002699 7248 South Bend Virtual School   Regular School No Other 01 12 2021   grade_9                         3.0 4.0                       7.0                         3 4                 7
1927952 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 07 12 2021   grade_9                         14.0 6.0                       20.0                         14 6                 20
1927941 IN     school 1806840 7200   School City of Mishawaka 180684001183 7461 Mishawaka High School   Regular School No High 09 12 2021   grade_9                         213.0 198.0                       411.0                         213 198                 411
1927870 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2021   grade_9                         448.0 423.0                       871.0                         448 423                 871
1927810 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No High 09 12 2021   grade_9                         81.0 75.0                       156.0                         81 75                 156
1927798 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2021   grade_9                         97.0 85.0                       182.0                         97 85                 182
1927747 IN     school 1806630 6910   Milan Community Schools 180663001168 7205 Milan High School   Regular School No High 09 12 2021   grade_9                         51.0 41.0                       92.0                         51 41                 92
1927733 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480000907 7193 Jac-Cen-Del MS/HS   Regular School No High 07 12 2021   grade_9                         25.0 25.0                       50.0                         25 25                 50
1927713 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2021   grade_9                         88.0 86.0                       174.0                         88 86                 174
1927707 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2021   grade_9                         48.0 40.0                       88.0                         48 40                 88
1927681 IN     school 1803180 6835   Randolph Eastern School Corp 180318000415 7161 Union City Community Jr/Sr High   Regular School No High 07 12 2021   grade_9                         34.0 18.0                       52.0                         34 18                 52
1927653 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High School   Regular School No High 09 12 2021   grade_9                         46.0 43.0                       89.0                         46 43                 89
1927639 IN     school 1807080 6820   Monroe Central School Corp 180708001202 7151 Monroe Central Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         49.0 33.0                       82.0                         49 33                 82
1927632 IN     school 1810740 6805   Randolph Southern School Corp 181074001763 7121 Randolph Southern Jr-Sr High Sch   Regular School No High 07 12 2021   grade_9                         27.0 20.0                       47.0                         27 20                 47
1927617 IN     school 1811730 6795   Union School Corporation 181173002660 7142 Indiana Digital Alternative School   Regular School No High 09 12 2021   grade_9                         2.0 3.0                       5.0                         2 3                 5
1927612 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No High 07 12 2021   grade_9                         288.0 264.0                       552.0                         288 264                 552
1927596 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2021   grade_9                         11.0 18.0                       29.0                         11 18                 29
1927564 IN     school 1803990 6755   Greencastle Community School Corp 180399000690 7089 Greencastle Senior High School   Regular School No High 09 12 2021   grade_9                         72.0 62.0                       134.0                         72 62                 134
1927547 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No High 09 12 2021   grade_9                         28.0 42.0                       70.0                         28 42                 70
1927541 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High School   Regular School No High 09 12 2021   grade_9                         41.0 60.0                       101.0                         41 60                 101
1927517 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No High 09 12 2021   grade_9                         46.0 37.0                       83.0                         46 37                 83
1927482 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2021   grade_9                         29.0 25.0                       54.0                         29 25                 54
1927476 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001205 6997 Winamac Community High School   Regular School No High 09 12 2021   grade_9                         60.0 35.0                       95.0                         60 35                 95
1927441 IN     school 1807950 6600   MSD North Posey Co Schools 180795001366 6975 North Posey High School   Regular School No High 09 12 2021   grade_9                         57.0 49.0                       106.0                         57 49                 106
1927407 IN     school 1807290 6590   MSD Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2021   grade_9                         83.0 95.0                       178.0                         83 95                 178
1927337 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2021   grade_9                         294.0 297.0                       591.0                         294 297                 591
1927331 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927256 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No High 09 12 2021   grade_9                         300.0 283.0                       583.0                         300 283                 583
1927218 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2021   grade_9                         59.0 53.0                       112.0                         59 53                 112
1927213 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_9                         0.0 1.0                       1.0                         0 1                 1
1927199 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No High 09 12 2021   grade_9                         68.0 58.0                       126.0                         68 58                 126
1927179 IN     school 1809000 6510   East Porter County School Corp 180900002009 6849 Washington Twp Middle/High School   Regular School No High 06 12 2021   grade_9                         31.0 23.0                       54.0                         31 23                 54
1927164 IN     school 1809000 6510   East Porter County School Corp 180900001497 6833 Kouts Middle/High School   Regular School No High 06 12 2021   grade_9                         29.0 36.0                       65.0                         29 36                 65
1927149 IN     school 1809000 6510   East Porter County School Corp 180900001214 6825 Morgan Township Middle/High School   Regular School No High 06 12 2021   grade_9                         32.0 24.0                       56.0                         32 24                 56
1927117 IN     school 1802800 6470   Duneland School Corporation 180280000333 6925 Chesterton Senior High School   Regular School No High 09 12 2021   grade_9                         278.0 257.0                       535.0                         278 257                 535
1927089 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927070 IN     school 1800750 6460   MSD Boone Township 180075000153 6813 Hebron High School   Regular School No High 09 12 2021   grade_9                         51.0 52.0                       103.0                         51 52                 103
1927045 IN     school 1808900 6445   Pike County School Corp 180890001482 6763 Pike Central High School   Regular School No High 09 12 2021   grade_9                         66.0 66.0                       132.0                         66 66                 132
1927040 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011802644 6654 Parke Heritage High School   Regular School No High 09 12 2021   grade_9                         46.0 43.0                       89.0                         46 43                 89
1927005 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         44.0 57.0                       101.0                         44 57                 101
1926995 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2021   grade_9                         8.0 10.0                       18.0                         8 10                 18
1926982 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         61.0 44.0                       105.0                         61 44                 105
1926956 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         44.0 35.0                       79.0                         44 35                 79
1926923 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2021   grade_9                         100.0 83.0                       183.0                         100 83                 183
1926891 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High School   Regular School No High 06 12 2021   grade_9                         28.0 31.0                       59.0                         28 31                 59
1926875 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2021   grade_9                         58.0 48.0                       106.0                         58 48                 106
1926859 IN     school 1808490 6145   Orleans Community Schools 180849001437 6573 Orleans Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         40.0 37.0                       77.0                         40 37                 77
1926852 IN     school 1809600 6080   Rising Sun-Ohio Co Com 180960001573 6513 Rising Sun High School   Regular School No High 09 12 2021   grade_9                         36.0 30.0                       66.0                         36 30                 66
1926823 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2021   grade_9                         73.0 94.0                       167.0                         73 94                 167
1926785 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 09 12 2021   grade_9                         131.0 135.0                       266.0                         131 135                 266
1926767 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2021   grade_9                         61.0 61.0                       122.0                         61 61                 122
1926742 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High School   Regular School No High 09 12 2021   grade_9                         27.0 29.0                       56.0                         27 29                 56
1926737 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         38.0 38.0                       76.0                         38 38                 76
1926661 IN     school 1807140 5930   Mooresville Con School Corp 180714001207 6369 Mooresville High School   Regular School No High 09 12 2021   grade_9                         186.0 160.0                       346.0                         186 160                 346
1926606 IN     school 1806510 5925   MSD Martinsville Schools 180651001135 6329 Martinsville High School   Regular School No High 09 12 2021   grade_9                         142.0 150.0                       292.0                         142 150                 292
1926585 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         11.0 13.0                       24.0                         11 13                 24
1926570 IN     school 1804140 5900   Monroe-Gregg School District 180414000716 6321 Monrovia High School   Regular School No High 09 12 2021   grade_9                         57.0 58.0                       115.0                         57 58                 115
1926546 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2021   grade_9                         76.0 82.0                       158.0                         76 82                 158
1926520 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No High 09 12 2021   grade_9                         63.0 69.0                       132.0                         63 69                 132
1926507 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790001357 6271 North Montgomery High School   Regular School No High 09 12 2021   grade_9                         71.0 54.0                       125.0                         71 54                 125
1926451 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2021   grade_9                         4.0 2.0                       6.0                         4 2                 6
1926434 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No High 09 12 2021   grade_9                         13.0 12.0                       25.0                         13 12                 25
1926379 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000119 6168 Bloomington High School North   Regular School No High 09 12 2021   grade_9                         233.0 208.0                       441.0                         233 208                 441
1926373 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000120 6166 Bloomington High School South   Regular School No High 09 12 2021   grade_9                         230.0 232.0                       462.0                         230 232                 462
1926310 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2021   grade_9                         104.0 98.0                       202.0                         104 98                 202
1926287 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2021   grade_9                         95.0 69.0                       164.0                         95 69                 164
1926273 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No High 09 12 2021   grade_9                         71.0 68.0                       139.0                         71 68                 139
1926252 IN     school 1807890 5620   North Miami Community Schools 180789001351 6049 North Miami Middle/High School   Regular School No High 07 12 2021   grade_9                         39.0 30.0                       69.0                         39 30                 69
1926235 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2021   grade_9                         83.0 101.0                       184.0                         83 101                 184
1926226 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No High 09 12 2021   grade_9                         31.0 24.0                       55.0                         31 24                 55
1926197 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Community High School   Regular School No High 09 12 2021   grade_9                         38.0 27.0                       65.0                         38 27                 65
1926192 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         34.0 35.0                       69.0                         34 35                 69
1926150 IN     school 1809060 5485   Plymouth Community School Corp 180906001500 5945 Plymouth High School   Regular School No High 09 12 2021   grade_9                         146.0 156.0                       302.0                         146 156                 302
1926127 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No High 09 12 2021   grade_9                         64.0 66.0                       130.0                         64 66                 130
1926122 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_9                         20.0 28.0                       48.0                         20 28                 48

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