enrollments
Data source: Big Local News · About: Big Local
4,696 rows where grade = "grade_11" and state = "SD" sorted by native_american descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
255689 | 255689 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 125.0 | 2.0 | 8.0 | 9.0 | 1.0 | 71.0 | 74.0 | 145.0 | 125 | 2 | 8 | 9 | 1 | 71 | 74 | 145 | ||||||||||||||||||||||||||||||||||||||
256468 | 256468 | SD | school | 4652770 | 23003 | Oelrichs 23-3 | 465277000482 | 1 | Oelrichs High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 0.0 | 9.0 | 7.0 | 2.0 | 9.0 | 0 | 9 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
357710 | 357710 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000042 | 1 | Bennett County High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 12.0 | 0.0 | 9.0 | 0.0 | 2.0 | 13.0 | 10.0 | 23.0 | 12 | 0 | 9 | 0 | 2 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||||||||
363779 | 363779 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001262 | 92 | Oglala Lakota County Virtual High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 1.0 | 9.0 | 0.0 | 5.0 | 5.0 | 10.0 | 1 | 9 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||||||||||
365855 | 365855 | SD | school | 4675600 | 15003 | Smee 15-3 | 467560000699 | 1 | Wakpala High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 9.0 | 0.0 | 4.0 | 5.0 | 9.0 | 9 | 0 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
451398 | 451398 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 132.0 | 7.0 | 13.0 | 9.0 | 6.0 | 1.0 | 12.0 | 100.0 | 80.0 | 180.0 | 132 | 7 | 13 | 9 | 6 | 1 | 12 | 100 | 80 | 180 | ||||||||||||||||||||||||||||||||||
459493 | 459493 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 38.0 | 0.0 | 0.0 | 9.0 | 1.0 | 23.0 | 25.0 | 48.0 | 38 | 0 | 0 | 9 | 1 | 23 | 25 | 48 | ||||||||||||||||||||||||||||||||||||||
491740 | 491740 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 44.0 | 2.0 | 2.0 | 9.0 | 1.0 | 2.0 | 31.0 | 29.0 | 60.0 | 44 | 2 | 2 | 9 | 1 | 2 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||||||
495470 | 495470 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 335.0 | 45.0 | 25.0 | 9.0 | 12.0 | 0.0 | 11.0 | 221.0 | 216.0 | 437.0 | 335 | 45 | 25 | 9 | 12 | 0 | 11 | 221 | 216 | 437 | ||||||||||||||||||||||||||||||||||
2961887 | 2961887 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 5.0 | 0.0 | 9.0 | 1.0 | 4.0 | 11.0 | 15.0 | 5 | 0 | 9 | 1 | 4 | 11 | 15 | ||||||||||||||||||||||||||||||||||||||||
2969430 | 2969430 | SD | school | 4665460 | 65001 | Shannon County 65-1 | 466546001262 | 8 | Shannon County Virtual High School | Alternative Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 0.0 | 9.0 | 4.0 | 5.0 | 9.0 | 0 | 9 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
496583 | 496583 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 1.0 | 0.0 | 87.0 | 0.0 | 0.0 | 43.0 | 45.0 | 88.0 | 1 | 0 | 87 | 0 | 0 | 43 | 45 | 88 | ||||||||||||||||||||||||||||||||||||||
256046 | 256046 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 187.0 | 3.0 | 11.0 | 8.0 | 1.0 | 3.0 | 112.0 | 101.0 | 213.0 | 187 | 3 | 11 | 8 | 1 | 3 | 112 | 101 | 213 | ||||||||||||||||||||||||||||||||||||
256827 | 256827 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 108.0 | 1.0 | 8.0 | 8.0 | 3.0 | 0.0 | 10.0 | 61.0 | 77.0 | 138.0 | 108 | 1 | 8 | 8 | 3 | 0 | 10 | 61 | 77 | 138 | ||||||||||||||||||||||||||||||||||
362005 | 362005 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 11.0 | 0.0 | 8.0 | 7.0 | 12.0 | 19.0 | 11 | 0 | 8 | 7 | 12 | 19 | ||||||||||||||||||||||||||||||||||||||||||
366578 | 366578 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 74.0 | 3.0 | 3.0 | 8.0 | 2.0 | 2.0 | 40.0 | 52.0 | 92.0 | 74 | 3 | 3 | 8 | 2 | 2 | 40 | 52 | 92 | ||||||||||||||||||||||||||||||||||||
453851 | 453851 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 11.0 | 0.0 | 8.0 | 0.0 | 11.0 | 8.0 | 19.0 | 11 | 0 | 8 | 0 | 11 | 8 | 19 | ||||||||||||||||||||||||||||||||||||||||
454437 | 454437 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 18.0 | 8.0 | 1.0 | 15.0 | 12.0 | 27.0 | 18 | 8 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||||||||||
489823 | 489823 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 124.0 | 1.0 | 11.0 | 8.0 | 0.0 | 1.0 | 17.0 | 89.0 | 73.0 | 162.0 | 124 | 1 | 11 | 8 | 0 | 1 | 17 | 89 | 73 | 162 | ||||||||||||||||||||||||||||||||||
498021 | 498021 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 171.0 | 2.0 | 13.0 | 8.0 | 1.0 | 2.0 | 110.0 | 87.0 | 197.0 | 171 | 2 | 13 | 8 | 1 | 2 | 110 | 87 | 197 | ||||||||||||||||||||||||||||||||||||
2966013 | 2966013 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 59.0 | 1.0 | 2.0 | 8.0 | 34.0 | 36.0 | 70.0 | 59 | 1 | 2 | 8 | 34 | 36 | 70 | ||||||||||||||||||||||||||||||||||||||||
3011233 | 3011233 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 11.0 | 8.0 | 12.0 | 7.0 | 19.0 | 11 | 8 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||||||||||||||
3011791 | 3011791 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 15.0 | 8.0 | 0.0 | 14.0 | 9.0 | 23.0 | 15 | 8 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||||||||||
3015232 | 3015232 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 30.0 | 0.0 | 8.0 | 0.0 | 24.0 | 14.0 | 38.0 | 30 | 0 | 8 | 0 | 24 | 14 | 38 | ||||||||||||||||||||||||||||||||||||||||
3344439 | 3344439 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 2.0 | 0.0 | 8.0 | 0.0 | 7.0 | 3.0 | 10.0 | 2 | 0 | 8 | 0 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||||||||
3347367 | 3347367 | SD | school | 4624390 | 50003 | Flandreau 50-3 | 462439000206 | 1 | Flandreau High Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 24.0 | 3.0 | 8.0 | 2.0 | 0.0 | 26.0 | 11.0 | 37.0 | 24 | 3 | 8 | 2 | 0 | 26 | 11 | 37 | ||||||||||||||||||||||||||||||||||||||
3348597 | 3348597 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 59.0 | 0.0 | 1.0 | 8.0 | 0.0 | 0.0 | 45.0 | 23.0 | 68.0 | 59 | 0 | 1 | 8 | 0 | 0 | 45 | 23 | 68 | ||||||||||||||||||||||||||||||||||||
3349097 | 3349097 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 18.0 | 8.0 | 9.0 | 17.0 | 26.0 | 18 | 8 | 9 | 17 | 26 | ||||||||||||||||||||||||||||||||||||||||||||
2970866 | 2970866 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 3.0 | 0.0 | 0.0 | 76.0 | 0.0 | 1.0 | 47.0 | 33.0 | 80.0 | 3 | 0 | 0 | 76 | 0 | 1 | 47 | 33 | 80 | ||||||||||||||||||||||||||||||||||||
3353386 | 3353386 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 1.0 | 0.0 | 75.0 | 0.0 | 35.0 | 41.0 | 76.0 | 1 | 0 | 75 | 0 | 35 | 41 | 76 | ||||||||||||||||||||||||||||||||||||||||
3013546 | 3013546 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 286.0 | 6.0 | 21.0 | 73.0 | 8.0 | 16.0 | 217.0 | 193.0 | 410.0 | 286 | 6 | 21 | 73 | 8 | 16 | 217 | 193 | 410 | ||||||||||||||||||||||||||||||||||||
254244 | 254244 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 56.0 | 3.0 | 3.0 | 7.0 | 0.0 | 0.0 | 5.0 | 33.0 | 41.0 | 74.0 | 56 | 3 | 3 | 7 | 0 | 0 | 5 | 33 | 41 | 74 | ||||||||||||||||||||||||||||||||||
254778 | 254778 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 9.0 | 7.0 | 5.0 | 11.0 | 16.0 | 9 | 7 | 5 | 11 | 16 | ||||||||||||||||||||||||||||||||||||||||||||
255350 | 255350 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 13.0 | 0.0 | 7.0 | 0.0 | 13.0 | 7.0 | 20.0 | 13 | 0 | 7 | 0 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||||||||||
257913 | 257913 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 388.0 | 59.0 | 39.0 | 7.0 | 13.0 | 0.0 | 21.0 | 285.0 | 242.0 | 527.0 | 388 | 59 | 39 | 7 | 13 | 0 | 21 | 285 | 242 | 527 | ||||||||||||||||||||||||||||||||||
357331 | 357331 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 1.0 | 0.0 | 7.0 | 0.0 | 4.0 | 4.0 | 8.0 | 1 | 0 | 7 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||||||||
362577 | 362577 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 18.0 | 7.0 | 0.0 | 12.0 | 13.0 | 25.0 | 18 | 7 | 0 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||||||||||
365933 | 365933 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 138.0 | 1.0 | 6.0 | 7.0 | 1.0 | 0.0 | 3.0 | 84.0 | 72.0 | 156.0 | 138 | 1 | 6 | 7 | 1 | 0 | 3 | 84 | 72 | 156 | ||||||||||||||||||||||||||||||||||
366893 | 366893 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 238.0 | 0.0 | 7.0 | 7.0 | 0.0 | 8.0 | 127.0 | 133.0 | 260.0 | 238 | 0 | 7 | 7 | 0 | 8 | 127 | 133 | 260 | ||||||||||||||||||||||||||||||||||||
367720 | 367720 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 195.0 | 3.0 | 17.0 | 7.0 | 2.0 | 4.0 | 112.0 | 116.0 | 228.0 | 195 | 3 | 17 | 7 | 2 | 4 | 112 | 116 | 228 | ||||||||||||||||||||||||||||||||||||
454765 | 454765 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 153.0 | 2.0 | 5.0 | 7.0 | 0.0 | 1.0 | 6.0 | 78.0 | 96.0 | 174.0 | 153 | 2 | 5 | 7 | 0 | 1 | 6 | 78 | 96 | 174 | ||||||||||||||||||||||||||||||||||
455151 | 455151 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 191.0 | 1.0 | 9.0 | 7.0 | 4.0 | 1.0 | 2.0 | 109.0 | 106.0 | 215.0 | 191 | 1 | 9 | 7 | 4 | 1 | 2 | 109 | 106 | 215 | ||||||||||||||||||||||||||||||||||
492846 | 492846 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 16.0 | 7.0 | 1.0 | 11.0 | 13.0 | 24.0 | 16 | 7 | 1 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||||||||||||
493574 | 493574 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 163.0 | 3.0 | 7.0 | 7.0 | 1.0 | 0.0 | 4.0 | 87.0 | 98.0 | 185.0 | 163 | 3 | 7 | 7 | 1 | 0 | 4 | 87 | 98 | 185 | ||||||||||||||||||||||||||||||||||
494064 | 494064 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001262 | 92 | Oglala Lakota County Virtual High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 0.0 | 0.0 | 7.0 | 3.0 | 4.0 | 7.0 | 0 | 0 | 7 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||||||||||
496335 | 496335 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 16.0 | 2.0 | 7.0 | 1.0 | 16.0 | 10.0 | 26.0 | 16 | 2 | 7 | 1 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||||||||
497308 | 497308 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 5.0 | 2.0 | 7.0 | 0.0 | 8.0 | 6.0 | 14.0 | 5 | 2 | 7 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||||||||
2970349 | 2970349 | SD | school | 4675600 | 15003 | Smee 15-3 | 467560000699 | 1 | Wakpala High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 7.0 | 5.0 | 2.0 | 7.0 | 7 | 5 | 2 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||
2972109 | 2972109 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 34.0 | 0.0 | 7.0 | 23.0 | 18.0 | 41.0 | 34 | 0 | 7 | 23 | 18 | 41 | ||||||||||||||||||||||||||||||||||||||||||
3346619 | 3346619 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 110.0 | 6.0 | 11.0 | 7.0 | 3.0 | 0.0 | 21.0 | 73.0 | 85.0 | 158.0 | 110 | 6 | 11 | 7 | 3 | 0 | 21 | 73 | 85 | 158 | ||||||||||||||||||||||||||||||||||
3349992 | 3349992 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 162.0 | 0.0 | 5.0 | 7.0 | 0.0 | 0.0 | 2.0 | 94.0 | 82.0 | 176.0 | 162 | 0 | 5 | 7 | 0 | 0 | 2 | 94 | 82 | 176 | ||||||||||||||||||||||||||||||||||
3350335 | 3350335 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 163.0 | 0.0 | 6.0 | 7.0 | 3.0 | 7.0 | 102.0 | 84.0 | 186.0 | 163 | 0 | 6 | 7 | 3 | 7 | 102 | 84 | 186 | ||||||||||||||||||||||||||||||||||||
456258 | 456258 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 273.0 | 3.0 | 25.0 | 66.0 | 6.0 | 40.0 | 184.0 | 229.0 | 413.0 | 273 | 3 | 25 | 66 | 6 | 40 | 184 | 229 | 413 | ||||||||||||||||||||||||||||||||||||
255061 | 255061 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative School | No | High | 09 | 12 | 2018 | grade_11 | 8.0 | 2.0 | 0.0 | 6.0 | 0.0 | 4.0 | 13.0 | 7.0 | 20.0 | 8 | 2 | 0 | 6 | 0 | 4 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||||||
359554 | 359554 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 121.0 | 2.0 | 12.0 | 6.0 | 4.0 | 0.0 | 13.0 | 74.0 | 84.0 | 158.0 | 121 | 2 | 12 | 6 | 4 | 0 | 13 | 74 | 84 | 158 | ||||||||||||||||||||||||||||||||||
363289 | 363289 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 146.0 | 1.0 | 9.0 | 6.0 | 2.0 | 0.0 | 8.0 | 91.0 | 81.0 | 172.0 | 146 | 1 | 9 | 6 | 2 | 0 | 8 | 91 | 81 | 172 | ||||||||||||||||||||||||||||||||||
366050 | 366050 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 31.0 | 0.0 | 6.0 | 0.0 | 1.0 | 20.0 | 18.0 | 38.0 | 31 | 0 | 6 | 0 | 1 | 20 | 18 | 38 | ||||||||||||||||||||||||||||||||||||||
453317 | 453317 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 51.0 | 2.0 | 2.0 | 6.0 | 0.0 | 5.0 | 31.0 | 35.0 | 66.0 | 51 | 2 | 2 | 6 | 0 | 5 | 31 | 35 | 66 | ||||||||||||||||||||||||||||||||||||
457912 | 457912 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 29.0 | 2.0 | 6.0 | 0.0 | 24.0 | 13.0 | 37.0 | 29 | 2 | 6 | 0 | 24 | 13 | 37 | ||||||||||||||||||||||||||||||||||||||||
492274 | 492274 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 11.0 | 1.0 | 6.0 | 2.0 | 9.0 | 11.0 | 20.0 | 11 | 1 | 6 | 2 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||||||||
497071 | 497071 | SD | school | 4675660 | 51005 | Wall 51-5 | 467566000705 | 1 | Wall High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 15.0 | 6.0 | 0.0 | 11.0 | 10.0 | 21.0 | 15 | 6 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||||||||||
2966782 | 2966782 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 5.0 | 0.0 | 1.0 | 6.0 | 0.0 | 2.0 | 11.0 | 3.0 | 14.0 | 5 | 0 | 1 | 6 | 0 | 2 | 11 | 3 | 14 | ||||||||||||||||||||||||||||||||||||
2971136 | 2971136 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 72.0 | 2.0 | 2.0 | 6.0 | 2.0 | 0.0 | 0.0 | 40.0 | 44.0 | 84.0 | 72 | 2 | 2 | 6 | 2 | 0 | 0 | 40 | 44 | 84 | ||||||||||||||||||||||||||||||||||
2972246 | 2972246 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 193.0 | 4.0 | 12.0 | 6.0 | 5.0 | 3.0 | 127.0 | 96.0 | 223.0 | 193 | 4 | 12 | 6 | 5 | 3 | 127 | 96 | 223 | ||||||||||||||||||||||||||||||||||||
3016059 | 3016059 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 269.0 | 0.0 | 11.0 | 6.0 | 5.0 | 5.0 | 149.0 | 147.0 | 296.0 | 269 | 0 | 11 | 6 | 5 | 5 | 149 | 147 | 296 | ||||||||||||||||||||||||||||||||||||
3016717 | 3016717 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 35.0 | 0.0 | 0.0 | 6.0 | 1.0 | 0.0 | 22.0 | 20.0 | 42.0 | 35 | 0 | 0 | 6 | 1 | 0 | 22 | 20 | 42 | ||||||||||||||||||||||||||||||||||||
3349366 | 3349366 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 6.0 | 0.0 | 2.0 | 6.0 | 1.0 | 1.0 | 10.0 | 6.0 | 16.0 | 6 | 0 | 2 | 6 | 1 | 1 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||||
3349655 | 3349655 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 27.0 | 0.0 | 6.0 | 1.0 | 16.0 | 18.0 | 34.0 | 27 | 0 | 6 | 1 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||||||||||
3351208 | 3351208 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 2.0 | 6.0 | 0.0 | 3.0 | 5.0 | 8.0 | 2 | 6 | 0 | 3 | 5 | 8 | ||||||||||||||||||||||||||||||||||||||||||
3352223 | 3352223 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001303 | 30 | New Technology High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 57.0 | 1.0 | 9.0 | 6.0 | 1.0 | 0.0 | 47.0 | 27.0 | 74.0 | 57 | 1 | 9 | 6 | 1 | 0 | 47 | 27 | 74 | ||||||||||||||||||||||||||||||||||||
3352917 | 3352917 | SD | school | 4675600 | 15003 | Smee 15-3 | 467560000699 | 1 | Wakpala High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 6.0 | 2.0 | 4.0 | 6.0 | 6 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
3353956 | 3353956 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 270.0 | 4.0 | 12.0 | 6.0 | 1.0 | 2.0 | 166.0 | 129.0 | 295.0 | 270 | 4 | 12 | 6 | 1 | 2 | 166 | 129 | 295 | ||||||||||||||||||||||||||||||||||||
494665 | 494665 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 270.0 | 7.0 | 26.0 | 56.0 | 3.0 | 1.0 | 30.0 | 184.0 | 209.0 | 393.0 | 270 | 7 | 26 | 56 | 3 | 1 | 30 | 184 | 209 | 393 | ||||||||||||||||||||||||||||||||||
2968714 | 2968714 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 294.0 | 6.0 | 17.0 | 54.0 | 6.0 | 8.0 | 182.0 | 203.0 | 385.0 | 294 | 6 | 17 | 54 | 6 | 8 | 182 | 203 | 385 | ||||||||||||||||||||||||||||||||||||
3351410 | 3351410 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 295.0 | 6.0 | 17.0 | 52.0 | 6.0 | 21.0 | 196.0 | 201.0 | 397.0 | 295 | 6 | 17 | 52 | 6 | 21 | 196 | 201 | 397 | ||||||||||||||||||||||||||||||||||||
257917 | 257917 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001303 | 30 | New Technology High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 71.0 | 9.0 | 6.0 | 5.0 | 3.0 | 3.0 | 45.0 | 52.0 | 97.0 | 71 | 9 | 6 | 5 | 3 | 3 | 45 | 52 | 97 | ||||||||||||||||||||||||||||||||||||
258823 | 258823 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 32.0 | 0.0 | 5.0 | 2.0 | 22.0 | 17.0 | 39.0 | 32 | 0 | 5 | 2 | 22 | 17 | 39 | ||||||||||||||||||||||||||||||||||||||||
259780 | 259780 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 5.0 | 0.0 | 5.0 | 5.0 | 5.0 | 10.0 | 5 | 0 | 5 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||||||||||
260276 | 260276 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 14.0 | 1.0 | 5.0 | 0.0 | 11.0 | 9.0 | 20.0 | 14 | 1 | 5 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
260324 | 260324 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 36.0 | 0.0 | 0.0 | 5.0 | 0.0 | 0.0 | 19.0 | 22.0 | 41.0 | 36 | 0 | 0 | 5 | 0 | 0 | 19 | 22 | 41 | ||||||||||||||||||||||||||||||||||||
358415 | 358415 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 18.0 | 1.0 | 1.0 | 5.0 | 15.0 | 10.0 | 25.0 | 18 | 1 | 1 | 5 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||||||||
362288 | 362288 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative School | No | High | 09 | 12 | 2019 | grade_11 | 3.0 | 2.0 | 1.0 | 5.0 | 0.0 | 2.0 | 11.0 | 2.0 | 13.0 | 3 | 2 | 1 | 5 | 0 | 2 | 11 | 2 | 13 | ||||||||||||||||||||||||||||||||||||
364178 | 364178 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative School | No | High | 09 | 12 | 2019 | grade_11 | 4.0 | 1.0 | 0.0 | 5.0 | 1.0 | 5.0 | 6.0 | 11.0 | 4 | 1 | 0 | 5 | 1 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||||||
365189 | 365189 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001303 | 30 | New Technology High School | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 62.0 | 4.0 | 8.0 | 5.0 | 0.0 | 2.0 | 40.0 | 41.0 | 81.0 | 62 | 4 | 8 | 5 | 0 | 2 | 40 | 41 | 81 | ||||||||||||||||||||||||||||||||||||
367535 | 367535 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 6.0 | 0.0 | 5.0 | 0.0 | 4.0 | 7.0 | 11.0 | 6 | 0 | 5 | 0 | 4 | 7 | 11 | ||||||||||||||||||||||||||||||||||||||||
450170 | 450170 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852000082 | 1 | Brookings Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 202.0 | 1.0 | 8.0 | 5.0 | 9.0 | 0.0 | 9.0 | 134.0 | 100.0 | 234.0 | 202 | 1 | 8 | 5 | 9 | 0 | 9 | 134 | 100 | 234 | ||||||||||||||||||||||||||||||||||
457795 | 457795 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 155.0 | 2.0 | 13.0 | 5.0 | 3.0 | 0.0 | 2.0 | 86.0 | 94.0 | 180.0 | 155 | 2 | 13 | 5 | 3 | 0 | 2 | 86 | 94 | 180 | ||||||||||||||||||||||||||||||||||
458901 | 458901 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 5.0 | 0.0 | 5.0 | 0.0 | 1.0 | 7.0 | 4.0 | 11.0 | 5 | 0 | 5 | 0 | 1 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||||||
496879 | 496879 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 72.0 | 1.0 | 3.0 | 5.0 | 0.0 | 0.0 | 37.0 | 44.0 | 81.0 | 72 | 1 | 3 | 5 | 0 | 0 | 37 | 44 | 81 | ||||||||||||||||||||||||||||||||||||
497551 | 497551 | SD | school | 4631710 | 49007 | West Central 49-7 | 463171001389 | 8 | Falls Academy | Alternative School | Not applicable | High | 05 | 12 | 2020 | grade_11 | 0.0 | 1.0 | 0.0 | 5.0 | 0.0 | 0.0 | 3.0 | 3.0 | 6.0 | 0 | 1 | 0 | 5 | 0 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||||
2962816 | 2962816 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852000082 | 1 | Brookings Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 196.0 | 3.0 | 4.0 | 5.0 | 8.0 | 1.0 | 2.0 | 106.0 | 113.0 | 219.0 | 196 | 3 | 4 | 5 | 8 | 1 | 2 | 106 | 113 | 219 | ||||||||||||||||||||||||||||||||||
2963551 | 2963551 | SD | school | 4616950 | 16001 | Custer 16-1 | 461695000155 | 1 | Custer High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 52.0 | 2.0 | 1.0 | 5.0 | 2.0 | 0.0 | 1.0 | 38.0 | 25.0 | 63.0 | 52 | 2 | 1 | 5 | 2 | 0 | 1 | 38 | 25 | 63 | ||||||||||||||||||||||||||||||||||
2964093 | 2964093 | SD | school | 4619450 | 64002 | Dupree 64-2 | 461945000800 | 1 | Dupree Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 2.0 | 0.0 | 5.0 | 1.0 | 6.0 | 7.0 | 2 | 0 | 5 | 1 | 6 | 7 | ||||||||||||||||||||||||||||||||||||||||||
2967392 | 2967392 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 122.0 | 0.0 | 2.0 | 5.0 | 1.0 | 1.0 | 69.0 | 62.0 | 131.0 | 122 | 0 | 2 | 5 | 1 | 1 | 69 | 62 | 131 | ||||||||||||||||||||||||||||||||||||
2968512 | 2968512 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 6.0 | 5.0 | 0.0 | 6.0 | 5.0 | 11.0 | 6 | 5 | 0 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||||||||||
2970459 | 2970459 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 126.0 | 0.0 | 6.0 | 5.0 | 2.0 | 4.0 | 67.0 | 76.0 | 143.0 | 126 | 0 | 6 | 5 | 2 | 4 | 67 | 76 | 143 | ||||||||||||||||||||||||||||||||||||
2971565 | 2971565 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 6.0 | 5.0 | 0.0 | 5.0 | 6.0 | 11.0 | 6 | 5 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||||||||||
3016173 | 3016173 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 4.0 | 0.0 | 5.0 | 2.0 | 7.0 | 9.0 | 4 | 0 | 5 | 2 | 7 | 9 | ||||||||||||||||||||||||||||||||||||||||||
3348209 | 3348209 | SD | school | 4631350 | 41002 | Harrisburg 41-2 | 463135000264 | 1 | Harrisburg High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 168.0 | 3.0 | 2.0 | 5.0 | 2.0 | 2.0 | 100.0 | 82.0 | 182.0 | 168 | 3 | 2 | 5 | 2 | 2 | 100 | 82 | 182 | ||||||||||||||||||||||||||||||||||||
3353656 | 3353656 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 69.0 | 3.0 | 2.0 | 5.0 | 4.0 | 0.0 | 3.0 | 46.0 | 40.0 | 86.0 | 69 | 3 | 2 | 5 | 4 | 0 | 3 | 46 | 40 | 86 |
Advanced export
JSON shape: default, array, newline-delimited
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]);