enrollments
Data source: Big Local News · About: Big Local
4,696 rows where grade = "grade_12" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
496595 | 496595 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 2.0 | 2.0 | 94.0 | 1.0 | 0.0 | 51.0 | 48.0 | 99.0 | 2 | 2 | 94 | 1 | 0 | 51 | 48 | 99 | ||||||||||||||||||||||||||||||||||||||
256053 | 256053 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 169.0 | 1.0 | 8.0 | 9.0 | 1.0 | 7.0 | 89.0 | 106.0 | 195.0 | 169 | 1 | 8 | 9 | 1 | 7 | 89 | 106 | 195 | ||||||||||||||||||||||||||||||||||||
357336 | 357336 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 5.0 | 0.0 | 9.0 | 1.0 | 10.0 | 5.0 | 15.0 | 5 | 0 | 9 | 1 | 10 | 5 | 15 | ||||||||||||||||||||||||||||||||||||||||
365809 | 365809 | SD | school | 4600053 | 54002 | Sisseton 54-2 | 460005301239 | 1 | Sisseton High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 15.0 | 0.0 | 2.0 | 9.0 | 0.0 | 3.0 | 18.0 | 11.0 | 29.0 | 15 | 0 | 2 | 9 | 0 | 3 | 18 | 11 | 29 | ||||||||||||||||||||||||||||||||||||
366582 | 366582 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 81.0 | 1.0 | 5.0 | 9.0 | 2.0 | 1.0 | 51.0 | 48.0 | 99.0 | 81 | 1 | 5 | 9 | 2 | 1 | 51 | 48 | 99 | ||||||||||||||||||||||||||||||||||||
453320 | 453320 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 41.0 | 2.0 | 2.0 | 9.0 | 1.0 | 2.0 | 27.0 | 30.0 | 57.0 | 41 | 2 | 2 | 9 | 1 | 2 | 27 | 30 | 57 | ||||||||||||||||||||||||||||||||||||
457089 | 457089 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 329.0 | 43.0 | 24.0 | 9.0 | 9.0 | 0.0 | 12.0 | 219.0 | 207.0 | 426.0 | 329 | 43 | 24 | 9 | 9 | 0 | 12 | 219 | 207 | 426 | ||||||||||||||||||||||||||||||||||
457108 | 457108 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 218.0 | 83.0 | 41.0 | 9.0 | 35.0 | 1.0 | 10.0 | 179.0 | 218.0 | 397.0 | 218 | 83 | 41 | 9 | 35 | 1 | 10 | 179 | 218 | 397 | ||||||||||||||||||||||||||||||||||
459496 | 459496 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 39.0 | 1.0 | 1.0 | 9.0 | 0.0 | 20.0 | 30.0 | 50.0 | 39 | 1 | 1 | 9 | 0 | 20 | 30 | 50 | ||||||||||||||||||||||||||||||||||||||
492280 | 492280 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 11.0 | 0.0 | 9.0 | 0.0 | 9.0 | 11.0 | 20.0 | 11 | 0 | 9 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||||||||
2966016 | 2966016 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 51.0 | 0.0 | 4.0 | 9.0 | 32.0 | 32.0 | 64.0 | 51 | 0 | 4 | 9 | 32 | 32 | 64 | ||||||||||||||||||||||||||||||||||||||||
3008713 | 3008713 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 87.0 | 5.0 | 12.0 | 9.0 | 2.0 | 0.0 | 21.0 | 63.0 | 73.0 | 136.0 | 87 | 5 | 12 | 9 | 2 | 0 | 21 | 63 | 73 | 136 | ||||||||||||||||||||||||||||||||||
3009475 | 3009475 | SD | school | 4624390 | 50003 | Flandreau 50-3 | 462439000206 | 1 | Flandreau High Sch | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 21.0 | 2.0 | 9.0 | 2.0 | 21.0 | 13.0 | 34.0 | 21 | 2 | 9 | 2 | 21 | 13 | 34 | ||||||||||||||||||||||||||||||||||||||||
3010704 | 3010704 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 50.0 | 0.0 | 1.0 | 9.0 | 0.0 | 0.0 | 2.0 | 40.0 | 22.0 | 62.0 | 50 | 0 | 1 | 9 | 0 | 0 | 2 | 40 | 22 | 62 | ||||||||||||||||||||||||||||||||||
3016860 | 3016860 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 220.0 | 6.0 | 9.0 | 9.0 | 0.0 | 2.0 | 127.0 | 119.0 | 246.0 | 220 | 6 | 9 | 9 | 0 | 2 | 127 | 119 | 246 | ||||||||||||||||||||||||||||||||||||
3344443 | 3344443 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 5.0 | 0.0 | 9.0 | 1.0 | 3.0 | 12.0 | 15.0 | 5 | 0 | 9 | 1 | 3 | 12 | 15 | ||||||||||||||||||||||||||||||||||||||||
458172 | 458172 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 1.0 | 0.0 | 86.0 | 40.0 | 47.0 | 87.0 | 1 | 0 | 86 | 40 | 47 | 87 | ||||||||||||||||||||||||||||||||||||||||||
3015472 | 3015472 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 2.0 | 0.0 | 84.0 | 0.0 | 1.0 | 44.0 | 43.0 | 87.0 | 2 | 0 | 84 | 0 | 1 | 44 | 43 | 87 | ||||||||||||||||||||||||||||||||||||||
250470 | 250470 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000042 | 1 | Bennett County High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 12.0 | 1.0 | 8.0 | 8.0 | 16.0 | 13.0 | 29.0 | 12 | 1 | 8 | 8 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||||||||
456302 | 456302 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000525 | 42 | Stevens Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 293.0 | 2.0 | 19.0 | 8.0 | 4.0 | 18.0 | 163.0 | 181.0 | 344.0 | 293 | 2 | 19 | 8 | 4 | 18 | 163 | 181 | 344 | ||||||||||||||||||||||||||||||||||||
457099 | 457099 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001063 | 3 | Roosevelt High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 389.0 | 37.0 | 42.0 | 8.0 | 14.0 | 1.0 | 12.0 | 251.0 | 252.0 | 503.0 | 389 | 37 | 42 | 8 | 14 | 1 | 12 | 251 | 252 | 503 | ||||||||||||||||||||||||||||||||||
459636 | 459636 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 178.0 | 2.0 | 19.0 | 8.0 | 2.0 | 2.0 | 113.0 | 98.0 | 211.0 | 178 | 2 | 19 | 8 | 2 | 2 | 113 | 98 | 211 | ||||||||||||||||||||||||||||||||||||
492561 | 492561 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 4.0 | 0.0 | 0.0 | 8.0 | 0.0 | 2.0 | 1.0 | 13.0 | 2.0 | 15.0 | 4 | 0 | 0 | 8 | 0 | 2 | 1 | 13 | 2 | 15 | ||||||||||||||||||||||||||||||||||
493581 | 493581 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 136.0 | 1.0 | 7.0 | 8.0 | 3.0 | 0.0 | 8.0 | 82.0 | 81.0 | 163.0 | 136 | 1 | 7 | 8 | 3 | 0 | 8 | 82 | 81 | 163 | ||||||||||||||||||||||||||||||||||
496143 | 496143 | SD | school | 4675600 | 15003 | Smee 15-3 | 467560000699 | 1 | Wakpala High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 8.0 | 0.0 | 3.0 | 5.0 | 8.0 | 8 | 0 | 3 | 5 | 8 | ||||||||||||||||||||||||||||||||||||||||||||
497683 | 497683 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000754 | 1 | White River High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 7.0 | 0.0 | 8.0 | 0.0 | 9.0 | 6.0 | 15.0 | 7 | 0 | 8 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||||||||
2971460 | 2971460 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 242.0 | 2.0 | 4.0 | 8.0 | 3.0 | 1.0 | 141.0 | 119.0 | 260.0 | 242 | 2 | 4 | 8 | 3 | 1 | 141 | 119 | 260 | ||||||||||||||||||||||||||||||||||||
3006515 | 3006515 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 3.0 | 8.0 | 0.0 | 7.0 | 4.0 | 11.0 | 3 | 8 | 0 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||||||||||
3008800 | 3008800 | SD | school | 4619450 | 64002 | Dupree 64-2 | 461945000800 | 1 | Dupree Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 5.0 | 8.0 | 0.0 | 5.0 | 8.0 | 13.0 | 5 | 8 | 0 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||||||||||||
3011238 | 3011238 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 18.0 | 8.0 | 10.0 | 16.0 | 26.0 | 18 | 8 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||||||||||||
3012896 | 3012896 | SD | school | 4652770 | 23003 | Oelrichs 23-3 | 465277000482 | 1 | Oelrichs High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 2.0 | 8.0 | 5.0 | 5.0 | 10.0 | 2 | 8 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
3014392 | 3014392 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 307.0 | 28.0 | 15.0 | 8.0 | 15.0 | 18.0 | 172.0 | 219.0 | 391.0 | 307 | 28 | 15 | 8 | 15 | 18 | 172 | 219 | 391 | ||||||||||||||||||||||||||||||||||||
259067 | 259067 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 2.0 | 1.0 | 73.0 | 0.0 | 0.0 | 36.0 | 40.0 | 76.0 | 2 | 1 | 73 | 0 | 0 | 36 | 40 | 76 | ||||||||||||||||||||||||||||||||||||||
256525 | 256525 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001262 | 92 | Oglala Lakota County Virtual High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 0.0 | 0.0 | 7.0 | 0.0 | 3.0 | 4.0 | 7.0 | 0 | 0 | 7 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||||||||
258827 | 258827 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 31.0 | 0.0 | 7.0 | 0.0 | 25.0 | 13.0 | 38.0 | 31 | 0 | 7 | 0 | 25 | 13 | 38 | ||||||||||||||||||||||||||||||||||||||||
259674 | 259674 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 272.0 | 0.0 | 9.0 | 7.0 | 5.0 | 0.0 | 5.0 | 156.0 | 142.0 | 298.0 | 272 | 0 | 9 | 7 | 5 | 0 | 5 | 156 | 142 | 298 | ||||||||||||||||||||||||||||||||||
451402 | 451402 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 114.0 | 2.0 | 6.0 | 7.0 | 0.0 | 1.0 | 13.0 | 75.0 | 68.0 | 143.0 | 114 | 2 | 6 | 7 | 0 | 1 | 13 | 75 | 68 | 143 | ||||||||||||||||||||||||||||||||||
454440 | 454440 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 15.0 | 7.0 | 2.0 | 11.0 | 13.0 | 24.0 | 15 | 7 | 2 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||||||||||||
458904 | 458904 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 6.0 | 2.0 | 7.0 | 0.0 | 0.0 | 8.0 | 7.0 | 15.0 | 6 | 2 | 7 | 0 | 0 | 8 | 7 | 15 | ||||||||||||||||||||||||||||||||||||||
488687 | 488687 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 15.0 | 1.0 | 1.0 | 7.0 | 0.0 | 1.0 | 14.0 | 11.0 | 25.0 | 15 | 1 | 1 | 7 | 0 | 1 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||||
497202 | 497202 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 246.0 | 0.0 | 6.0 | 7.0 | 0.0 | 9.0 | 132.0 | 136.0 | 268.0 | 246 | 0 | 6 | 7 | 0 | 9 | 132 | 136 | 268 | ||||||||||||||||||||||||||||||||||||
2966518 | 2966518 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 7.0 | 7.0 | 10.0 | 4.0 | 14.0 | 7 | 7 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||||||||||||||
2969669 | 2969669 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 373.0 | 29.0 | 22.0 | 7.0 | 11.0 | 1.0 | 11.0 | 249.0 | 205.0 | 454.0 | 373 | 29 | 22 | 7 | 11 | 1 | 11 | 249 | 205 | 454 | ||||||||||||||||||||||||||||||||||
2971140 | 2971140 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 73.0 | 2.0 | 3.0 | 7.0 | 0.0 | 0.0 | 0.0 | 38.0 | 47.0 | 85.0 | 73 | 2 | 3 | 7 | 0 | 0 | 0 | 38 | 47 | 85 | ||||||||||||||||||||||||||||||||||
3012954 | 3012954 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001262 | 92 | Oglala Lakota County Virtual High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 0.0 | 0.0 | 7.0 | 2.0 | 5.0 | 7.0 | 0 | 0 | 7 | 2 | 5 | 7 | ||||||||||||||||||||||||||||||||||||||||||
3346625 | 3346625 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 109.0 | 7.0 | 8.0 | 7.0 | 4.0 | 0.0 | 13.0 | 85.0 | 63.0 | 148.0 | 109 | 7 | 8 | 7 | 4 | 0 | 13 | 85 | 63 | 148 | ||||||||||||||||||||||||||||||||||
3348600 | 3348600 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 53.0 | 1.0 | 2.0 | 7.0 | 0.0 | 2.0 | 34.0 | 31.0 | 65.0 | 53 | 1 | 2 | 7 | 0 | 2 | 34 | 31 | 65 | ||||||||||||||||||||||||||||||||||||
3350760 | 3350760 | SD | school | 4652770 | 23003 | Oelrichs 23-3 | 465277000482 | 1 | Oelrichs High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 3.0 | 7.0 | 5.0 | 5.0 | 10.0 | 3 | 7 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
257130 | 257130 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 264.0 | 5.0 | 16.0 | 66.0 | 7.0 | 13.0 | 188.0 | 183.0 | 371.0 | 264 | 5 | 16 | 66 | 7 | 13 | 188 | 183 | 371 | ||||||||||||||||||||||||||||||||||||
2968739 | 2968739 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 290.0 | 10.0 | 14.0 | 62.0 | 3.0 | 6.0 | 196.0 | 189.0 | 385.0 | 290 | 10 | 14 | 62 | 3 | 6 | 196 | 189 | 385 | ||||||||||||||||||||||||||||||||||||
254784 | 254784 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 11.0 | 6.0 | 12.0 | 5.0 | 17.0 | 11 | 6 | 12 | 5 | 17 | ||||||||||||||||||||||||||||||||||||||||||||
260327 | 260327 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 38.0 | 0.0 | 0.0 | 6.0 | 0.0 | 1.0 | 23.0 | 22.0 | 45.0 | 38 | 0 | 0 | 6 | 0 | 1 | 23 | 22 | 45 | ||||||||||||||||||||||||||||||||||||
260467 | 260467 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 184.0 | 3.0 | 18.0 | 6.0 | 4.0 | 1.0 | 115.0 | 101.0 | 216.0 | 184 | 3 | 18 | 6 | 4 | 1 | 115 | 101 | 216 | ||||||||||||||||||||||||||||||||||||
361474 | 361474 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 51.0 | 1.0 | 1.0 | 6.0 | 0.0 | 4.0 | 30.0 | 33.0 | 63.0 | 51 | 1 | 1 | 6 | 0 | 4 | 30 | 33 | 63 | ||||||||||||||||||||||||||||||||||||
362931 | 362931 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 112.0 | 3.0 | 7.0 | 6.0 | 0.0 | 1.0 | 62.0 | 67.0 | 129.0 | 112 | 3 | 7 | 6 | 0 | 1 | 62 | 67 | 129 | ||||||||||||||||||||||||||||||||||||
363296 | 363296 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 182.0 | 3.0 | 11.0 | 6.0 | 2.0 | 0.0 | 1.0 | 109.0 | 96.0 | 205.0 | 182 | 3 | 11 | 6 | 2 | 0 | 1 | 109 | 96 | 205 | ||||||||||||||||||||||||||||||||||
363730 | 363730 | SD | school | 4652770 | 23003 | Oelrichs 23-3 | 465277000482 | 1 | Oelrichs High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 1.0 | 6.0 | 0.0 | 0.0 | 4.0 | 3.0 | 7.0 | 1 | 6 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||||||||
363784 | 363784 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001262 | 92 | Oglala Lakota County Virtual High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 0.0 | 6.0 | 0.0 | 2.0 | 4.0 | 6.0 | 0 | 6 | 0 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||||||||||
364413 | 364413 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | High | 12 | 12 | 2019 | grade_12 | 21.0 | 3.0 | 6.0 | 1.0 | 23.0 | 8.0 | 31.0 | 21 | 3 | 6 | 1 | 23 | 8 | 31 | ||||||||||||||||||||||||||||||||||||||||
367538 | 367538 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 13.0 | 1.0 | 6.0 | 0.0 | 12.0 | 8.0 | 20.0 | 13 | 1 | 6 | 0 | 12 | 8 | 20 | ||||||||||||||||||||||||||||||||||||||||
458460 | 458460 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 74.0 | 0.0 | 1.0 | 6.0 | 0.0 | 0.0 | 33.0 | 48.0 | 81.0 | 74 | 0 | 1 | 6 | 0 | 0 | 33 | 48 | 81 | ||||||||||||||||||||||||||||||||||||
458652 | 458652 | SD | school | 4675660 | 51005 | Wall 51-5 | 467566000705 | 1 | Wall High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 14.0 | 6.0 | 11.0 | 9.0 | 20.0 | 14 | 6 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||||||
496226 | 496226 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 133.0 | 1.0 | 6.0 | 6.0 | 1.0 | 0.0 | 3.0 | 77.0 | 73.0 | 150.0 | 133 | 1 | 6 | 6 | 1 | 0 | 3 | 77 | 73 | 150 | ||||||||||||||||||||||||||||||||||
2972112 | 2972112 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 30.0 | 1.0 | 6.0 | 16.0 | 21.0 | 37.0 | 30 | 1 | 6 | 16 | 21 | 37 | ||||||||||||||||||||||||||||||||||||||||||
3011795 | 3011795 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 26.0 | 6.0 | 1.0 | 13.0 | 20.0 | 33.0 | 26 | 6 | 1 | 13 | 20 | 33 | ||||||||||||||||||||||||||||||||||||||||||
3012138 | 3012138 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 147.0 | 0.0 | 3.0 | 6.0 | 0.0 | 0.0 | 1.0 | 82.0 | 75.0 | 157.0 | 147 | 0 | 3 | 6 | 0 | 0 | 1 | 82 | 75 | 157 | ||||||||||||||||||||||||||||||||||
3353396 | 3353396 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 2.0 | 0.0 | 53.0 | 0.0 | 35.0 | 20.0 | 55.0 | 2 | 0 | 53 | 0 | 35 | 20 | 55 | ||||||||||||||||||||||||||||||||||||||||
257138 | 257138 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | High | 12 | 12 | 2018 | grade_12 | 21.0 | 3.0 | 5.0 | 2.0 | 2.0 | 23.0 | 10.0 | 33.0 | 21 | 3 | 5 | 2 | 2 | 23 | 10 | 33 | ||||||||||||||||||||||||||||||||||||||
257956 | 257956 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 295.0 | 38.0 | 24.0 | 5.0 | 12.0 | 0.0 | 7.0 | 202.0 | 179.0 | 381.0 | 295 | 38 | 24 | 5 | 12 | 0 | 7 | 202 | 179 | 381 | ||||||||||||||||||||||||||||||||||
361298 | 361298 | SD | school | 4680440 | 34002 | Highmore-Harrold | 468044000324 | 1 | Highmore-Harrold High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 15.0 | 1.0 | 5.0 | 0.0 | 11.0 | 10.0 | 21.0 | 15 | 1 | 5 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||||||||
362581 | 362581 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 12.0 | 5.0 | 0.0 | 10.0 | 7.0 | 17.0 | 12 | 5 | 0 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||||||||||||
453857 | 453857 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 10.0 | 1.0 | 5.0 | 0.0 | 6.0 | 10.0 | 16.0 | 10 | 1 | 5 | 0 | 6 | 10 | 16 | ||||||||||||||||||||||||||||||||||||||||
458783 | 458783 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 249.0 | 3.0 | 12.0 | 5.0 | 2.0 | 0.0 | 5.0 | 140.0 | 136.0 | 276.0 | 249 | 3 | 12 | 5 | 2 | 0 | 5 | 140 | 136 | 276 | ||||||||||||||||||||||||||||||||||
487618 | 487618 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 1.0 | 0.0 | 5.0 | 0.0 | 4.0 | 2.0 | 6.0 | 1 | 0 | 5 | 0 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||||||||
489828 | 489828 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 115.0 | 3.0 | 9.0 | 5.0 | 4.0 | 0.0 | 14.0 | 74.0 | 76.0 | 150.0 | 115 | 3 | 9 | 5 | 4 | 0 | 14 | 74 | 76 | 150 | ||||||||||||||||||||||||||||||||||
492850 | 492850 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 18.0 | 5.0 | 0.0 | 11.0 | 12.0 | 23.0 | 18 | 5 | 0 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||||||||||
2965216 | 2965216 | SD | school | 4629880 | 26004 | Gregory 26-4 | 462988000239 | 1 | Gregory High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 25.0 | 5.0 | 1.0 | 0.0 | 19.0 | 12.0 | 31.0 | 25 | 5 | 1 | 0 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||||||||
2967742 | 2967742 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 173.0 | 3.0 | 6.0 | 5.0 | 0.0 | 0.0 | 0.0 | 87.0 | 100.0 | 187.0 | 173 | 3 | 6 | 5 | 0 | 0 | 0 | 87 | 100 | 187 | ||||||||||||||||||||||||||||||||||
2971568 | 2971568 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 7.0 | 5.0 | 0.0 | 6.0 | 6.0 | 12.0 | 7 | 5 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||||||||||||
2972252 | 2972252 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 205.0 | 4.0 | 11.0 | 5.0 | 2.0 | 1.0 | 113.0 | 115.0 | 228.0 | 205 | 4 | 11 | 5 | 2 | 1 | 113 | 115 | 228 | ||||||||||||||||||||||||||||||||||||
3015135 | 3015135 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 112.0 | 1.0 | 10.0 | 5.0 | 2.0 | 1.0 | 77.0 | 54.0 | 131.0 | 112 | 1 | 10 | 5 | 2 | 1 | 77 | 54 | 131 | ||||||||||||||||||||||||||||||||||||
3015748 | 3015748 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 72.0 | 1.0 | 2.0 | 5.0 | 3.0 | 0.0 | 2.0 | 43.0 | 42.0 | 85.0 | 72 | 1 | 2 | 5 | 3 | 0 | 2 | 43 | 42 | 85 | ||||||||||||||||||||||||||||||||||
3016067 | 3016067 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 293.0 | 2.0 | 14.0 | 5.0 | 2.0 | 1.0 | 174.0 | 143.0 | 317.0 | 293 | 2 | 14 | 5 | 2 | 1 | 174 | 143 | 317 | ||||||||||||||||||||||||||||||||||||
3345424 | 3345424 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852000082 | 1 | Brookings Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 187.0 | 5.0 | 9.0 | 5.0 | 6.0 | 1.0 | 3.0 | 109.0 | 107.0 | 216.0 | 187 | 5 | 9 | 5 | 6 | 1 | 3 | 109 | 107 | 216 | ||||||||||||||||||||||||||||||||||
3346712 | 3346712 | SD | school | 4619450 | 64002 | Dupree 64-2 | 461945000800 | 1 | Dupree Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 3.0 | 5.0 | 4.0 | 4.0 | 8.0 | 3 | 5 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||||||||||||
3349659 | 3349659 | SD | school | 4644770 | 42001 | Lyman 42-1 | 464477000398 | 1 | Lyman High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 13.0 | 1.0 | 5.0 | 1.0 | 11.0 | 9.0 | 20.0 | 13 | 1 | 5 | 1 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
3350002 | 3350002 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 113.0 | 0.0 | 2.0 | 5.0 | 2.0 | 0.0 | 0.0 | 58.0 | 64.0 | 122.0 | 113 | 0 | 2 | 5 | 2 | 0 | 0 | 58 | 64 | 122 | ||||||||||||||||||||||||||||||||||
3353148 | 3353148 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 19.0 | 2.0 | 5.0 | 2.0 | 17.0 | 11.0 | 28.0 | 19 | 2 | 5 | 2 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||||||||||
3353660 | 3353660 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 72.0 | 2.0 | 2.0 | 5.0 | 2.0 | 0.0 | 0.0 | 42.0 | 41.0 | 83.0 | 72 | 2 | 2 | 5 | 2 | 0 | 0 | 42 | 41 | 83 | ||||||||||||||||||||||||||||||||||
3354072 | 3354072 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000720 | 1 | Waubay Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 5.0 | 5.0 | 4.0 | 6.0 | 10.0 | 5 | 5 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
3354616 | 3354616 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 36.0 | 5.0 | 0.0 | 22.0 | 19.0 | 41.0 | 36 | 5 | 0 | 22 | 19 | 41 | ||||||||||||||||||||||||||||||||||||||||||
494690 | 494690 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 255.0 | 3.0 | 12.0 | 48.0 | 3.0 | 0.0 | 20.0 | 152.0 | 189.0 | 341.0 | 255 | 3 | 12 | 48 | 3 | 0 | 20 | 152 | 189 | 341 | ||||||||||||||||||||||||||||||||||
2970876 | 2970876 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 2.0 | 0.0 | 1.0 | 47.0 | 0.0 | 0.0 | 23.0 | 27.0 | 50.0 | 2 | 0 | 1 | 47 | 0 | 0 | 23 | 27 | 50 | ||||||||||||||||||||||||||||||||||||
3013571 | 3013571 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 287.0 | 8.0 | 16.0 | 45.0 | 3.0 | 18.0 | 182.0 | 195.0 | 377.0 | 287 | 8 | 16 | 45 | 3 | 18 | 182 | 195 | 377 | ||||||||||||||||||||||||||||||||||||
456283 | 456283 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 228.0 | 8.0 | 22.0 | 42.0 | 2.0 | 23.0 | 148.0 | 177.0 | 325.0 | 228 | 8 | 22 | 42 | 2 | 23 | 148 | 177 | 325 | ||||||||||||||||||||||||||||||||||||
3351435 | 3351435 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 284.0 | 6.0 | 17.0 | 41.0 | 6.0 | 9.0 | 170.0 | 193.0 | 363.0 | 284 | 6 | 17 | 41 | 6 | 9 | 170 | 193 | 363 | ||||||||||||||||||||||||||||||||||||
252007 | 252007 | SD | school | 4618120 | 49003 | Dell Rapids 49-3 | 461812000165 | 1 | Dell Rapids High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 59.0 | 1.0 | 1.0 | 4.0 | 1.0 | 1.0 | 33.0 | 34.0 | 67.0 | 59 | 1 | 1 | 4 | 1 | 1 | 33 | 34 | 67 | ||||||||||||||||||||||||||||||||||||
257966 | 257966 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001063 | 3 | Roosevelt High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 383.0 | 37.0 | 49.0 | 4.0 | 10.0 | 0.0 | 9.0 | 238.0 | 254.0 | 492.0 | 383 | 37 | 49 | 4 | 10 | 0 | 9 | 238 | 254 | 492 | ||||||||||||||||||||||||||||||||||
358418 | 358418 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 18.0 | 0.0 | 0.0 | 4.0 | 11.0 | 11.0 | 22.0 | 18 | 0 | 0 | 4 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||||||||
362011 | 362011 | SD | school | 4680437 | 35002 | Kadoka Area 35-2 | 468043701247 | 1 | Kadoka Area HS | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 9.0 | 1.0 | 4.0 | 5.0 | 9.0 | 14.0 | 9 | 1 | 4 | 5 | 9 | 14 |
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]);