enrollments
Data source: Big Local News · About: Big Local
671 rows where grade = "grade_10", state = "SD" and year = 2018 sorted by multiracial 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
257099 | 257099 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000525 | 42 | Stevens Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 374.0 | 2.0 | 23.0 | 20.0 | 9.0 | 1.0 | 9.0 | 215.0 | 223.0 | 438.0 | 374 | 2 | 23 | 20 | 9 | 1 | 9 | 215 | 223 | 438 | ||||||||||||||||||||||||||||||||||
259658 | 259658 | SD | school | 4676620 | 14004 | Watertown 14-4 | 467662000717 | 1 | Watertown High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 252.0 | 0.0 | 8.0 | 10.0 | 0.0 | 1.0 | 9.0 | 141.0 | 139.0 | 280.0 | 252 | 0 | 8 | 10 | 0 | 1 | 9 | 141 | 139 | 280 | ||||||||||||||||||||||||||||||||||
250805 | 250805 | SD | school | 4607950 | 49002 | Brandon Valley 49-2 | 460795000071 | 1 | Brandon Valley Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 254.0 | 9.0 | 7.0 | 1.0 | 3.0 | 0.0 | 8.0 | 147.0 | 135.0 | 282.0 | 254 | 9 | 7 | 1 | 3 | 0 | 8 | 147 | 135 | 282 | ||||||||||||||||||||||||||||||||||
251059 | 251059 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852000082 | 1 | Brookings Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 192.0 | 6.0 | 6.0 | 5.0 | 6.0 | 1.0 | 8.0 | 105.0 | 119.0 | 224.0 | 192 | 6 | 6 | 5 | 6 | 1 | 8 | 105 | 119 | 224 | ||||||||||||||||||||||||||||||||||
253833 | 253833 | SD | school | 4631350 | 41002 | Harrisburg 41-2 | 463135000264 | 1 | Harrisburg High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 220.0 | 1.0 | 5.0 | 3.0 | 1.0 | 8.0 | 130.0 | 108.0 | 238.0 | 220 | 1 | 5 | 3 | 1 | 8 | 130 | 108 | 238 | ||||||||||||||||||||||||||||||||||||
250387 | 250387 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000038 | 1 | Belle Fourche HS | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 70.0 | 6.0 | 0.0 | 2.0 | 6.0 | 45.0 | 39.0 | 84.0 | 70 | 6 | 0 | 2 | 6 | 45 | 39 | 84 | ||||||||||||||||||||||||||||||||||||||
256822 | 256822 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 160.0 | 0.0 | 8.0 | 31.0 | 2.0 | 1.0 | 6.0 | 108.0 | 100.0 | 208.0 | 160 | 0 | 8 | 31 | 2 | 1 | 6 | 108 | 100 | 208 | ||||||||||||||||||||||||||||||||||
258914 | 258914 | SD | school | 4600052 | 41005 | Tea Area 41-5 | 460005201235 | 3 | Tea Area High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 117.0 | 5.0 | 3.0 | 1.0 | 6.0 | 69.0 | 63.0 | 132.0 | 117 | 5 | 3 | 1 | 6 | 69 | 63 | 132 | ||||||||||||||||||||||||||||||||||||||
254241 | 254241 | SD | school | 4634480 | 23002 | Hot Springs 23-2 | 463448000288 | 1 | Hot Springs Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 46.0 | 0.0 | 2.0 | 3.0 | 1.0 | 1.0 | 5.0 | 28.0 | 30.0 | 58.0 | 46 | 0 | 2 | 3 | 1 | 1 | 5 | 28 | 30 | 58 | ||||||||||||||||||||||||||||||||||
255678 | 255678 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 149.0 | 0.0 | 4.0 | 5.0 | 5.0 | 86.0 | 77.0 | 163.0 | 149 | 0 | 4 | 5 | 5 | 86 | 77 | 163 | ||||||||||||||||||||||||||||||||||||||
258698 | 258698 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 153.0 | 1.0 | 7.0 | 9.0 | 1.0 | 5.0 | 96.0 | 80.0 | 176.0 | 153 | 1 | 7 | 9 | 1 | 5 | 96 | 80 | 176 | ||||||||||||||||||||||||||||||||||||
249816 | 249816 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000003 | 1 | Central High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 219.0 | 14.0 | 17.0 | 22.0 | 12.0 | 0.0 | 4.0 | 140.0 | 148.0 | 288.0 | 219 | 14 | 17 | 22 | 12 | 0 | 4 | 140 | 148 | 288 | ||||||||||||||||||||||||||||||||||
255057 | 255057 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130001145 | 10 | Lead-Deadwood Career & Tech Ed | Alternative School | No | High | 09 | 12 | 2018 | grade_10 | 11.0 | 8.0 | 3.0 | 6.0 | 1.0 | 4.0 | 25.0 | 8.0 | 33.0 | 11 | 8 | 3 | 6 | 1 | 4 | 25 | 8 | 33 | ||||||||||||||||||||||||||||||||||||
257092 | 257092 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001340 | 45 | Rapid City HS | Alternative School | No | High | 09 | 12 | 2018 | grade_10 | 54.0 | 5.0 | 4.0 | 43.0 | 0.0 | 4.0 | 61.0 | 49.0 | 110.0 | 54 | 5 | 4 | 43 | 0 | 4 | 61 | 49 | 110 | ||||||||||||||||||||||||||||||||||||
259474 | 259474 | SD | school | 4675420 | 11004 | Wagner Community 11-4 | 467542000695 | 1 | Wagner High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 16.0 | 1.0 | 29.0 | 4.0 | 22.0 | 28.0 | 50.0 | 16 | 1 | 29 | 4 | 22 | 28 | 50 | ||||||||||||||||||||||||||||||||||||||||
260455 | 260455 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 190.0 | 3.0 | 12.0 | 9.0 | 1.0 | 4.0 | 112.0 | 107.0 | 219.0 | 190 | 3 | 12 | 9 | 1 | 4 | 112 | 107 | 219 | ||||||||||||||||||||||||||||||||||||
250513 | 250513 | SD | school | 4606360 | 61002 | Beresford 61-2 | 460636000048 | 1 | Beresford High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 55.0 | 1.0 | 2.0 | 1.0 | 3.0 | 31.0 | 31.0 | 62.0 | 55 | 1 | 2 | 1 | 3 | 31 | 31 | 62 | ||||||||||||||||||||||||||||||||||||||
251890 | 251890 | SD | school | 4636990 | 61008 | Dakota Valley 61-8 | 463699000345 | 1 | Dakota Valley High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 87.0 | 0.0 | 9.0 | 2.0 | 2.0 | 0.0 | 3.0 | 56.0 | 47.0 | 103.0 | 87 | 0 | 9 | 2 | 2 | 0 | 3 | 56 | 47 | 103 | ||||||||||||||||||||||||||||||||||
253297 | 253297 | SD | school | 4626370 | 49004 | Garretson 49-4 | 462637000224 | 1 | Garretson High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 40.0 | 0.0 | 3.0 | 0.0 | 0.0 | 3.0 | 22.0 | 24.0 | 46.0 | 40 | 0 | 3 | 0 | 0 | 3 | 22 | 24 | 46 | ||||||||||||||||||||||||||||||||||||
257080 | 257080 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 318.0 | 10.0 | 28.0 | 78.0 | 4.0 | 24.0 | 229.0 | 233.0 | 462.0 | 318 | 10 | 28 | 78 | 4 | 24 | 229 | 233 | 462 | ||||||||||||||||||||||||||||||||||||
257870 | 257870 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 354.0 | 58.0 | 35.0 | 28.0 | 13.0 | 0.0 | 21.0 | 251.0 | 258.0 | 509.0 | 354 | 58 | 35 | 28 | 13 | 0 | 21 | 251 | 258 | 509 | ||||||||||||||||||||||||||||||||||
250464 | 250464 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000042 | 1 | Bennett County High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 14.0 | 0.0 | 17.0 | 2.0 | 19.0 | 14.0 | 33.0 | 14 | 0 | 17 | 2 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||||||||||
251248 | 251248 | SD | school | 4610560 | 41001 | Canton 41-1 | 461056000109 | 1 | Canton High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 75.0 | 1.0 | 1.0 | 1.0 | 2.0 | 44.0 | 36.0 | 80.0 | 75 | 1 | 1 | 1 | 2 | 44 | 36 | 80 | ||||||||||||||||||||||||||||||||||||||
251826 | 251826 | SD | school | 4616950 | 16001 | Custer 16-1 | 461695000155 | 1 | Custer High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 51.0 | 2.0 | 3.0 | 2.0 | 1.0 | 2.0 | 32.0 | 29.0 | 61.0 | 51 | 2 | 3 | 2 | 1 | 2 | 32 | 29 | 61 | ||||||||||||||||||||||||||||||||||||
254945 | 254945 | SD | school | 4639990 | 38003 | Lake Preston 38-3 | 463999000368 | 1 | Lake Preston High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 20.0 | 2.0 | 11.0 | 11.0 | 22.0 | 20 | 2 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||||||||||||
255171 | 255171 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000387 | 1 | Lennox High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 65.0 | 0.0 | 2.0 | 2.0 | 0.0 | 2.0 | 36.0 | 35.0 | 71.0 | 65 | 0 | 2 | 2 | 0 | 2 | 36 | 35 | 71 | ||||||||||||||||||||||||||||||||||||
255921 | 255921 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 75.0 | 0.0 | 8.0 | 1.0 | 0.0 | 2.0 | 51.0 | 35.0 | 86.0 | 75 | 0 | 8 | 1 | 0 | 2 | 51 | 35 | 86 | ||||||||||||||||||||||||||||||||||||
257874 | 257874 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001303 | 30 | New Technology High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 70.0 | 5.0 | 8.0 | 4.0 | 0.0 | 2.0 | 48.0 | 41.0 | 89.0 | 70 | 5 | 8 | 4 | 0 | 2 | 48 | 41 | 89 | ||||||||||||||||||||||||||||||||||||
258544 | 258544 | SD | school | 4600053 | 54002 | Sisseton 54-2 | 460005301239 | 1 | Sisseton High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 19.0 | 0.0 | 4.0 | 28.0 | 0.0 | 2.0 | 29.0 | 24.0 | 53.0 | 19 | 0 | 4 | 28 | 0 | 2 | 29 | 24 | 53 | ||||||||||||||||||||||||||||||||||||
260002 | 260002 | SD | school | 4631710 | 49007 | West Central 49-7 | 463171000274 | 1 | West Central Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 88.0 | 1.0 | 0.0 | 0.0 | 2.0 | 39.0 | 52.0 | 91.0 | 88 | 1 | 0 | 0 | 2 | 39 | 52 | 91 | ||||||||||||||||||||||||||||||||||||||
260115 | 260115 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000754 | 1 | White River High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 7.0 | 0.0 | 1.0 | 11.0 | 0.0 | 1.0 | 2.0 | 14.0 | 8.0 | 22.0 | 7 | 0 | 1 | 11 | 0 | 1 | 2 | 14 | 8 | 22 | ||||||||||||||||||||||||||||||||||
257880 | 257880 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001063 | 3 | Roosevelt High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 480.0 | 36.0 | 75.0 | 28.0 | 22.0 | 0.0 | 15.0 | 354.0 | 302.0 | 656.0 | 480 | 36 | 75 | 28 | 22 | 0 | 15 | 354 | 302 | 656 | ||||||||||||||||||||||||||||||||||
257889 | 257889 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 296.0 | 91.0 | 63.0 | 24.0 | 38.0 | 0.0 | 14.0 | 289.0 | 237.0 | 526.0 | 296 | 91 | 63 | 24 | 38 | 0 | 14 | 289 | 237 | 526 | ||||||||||||||||||||||||||||||||||
252290 | 252290 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 144.0 | 3.0 | 19.0 | 15.0 | 4.0 | 0.0 | 12.0 | 98.0 | 99.0 | 197.0 | 144 | 3 | 19 | 15 | 4 | 0 | 12 | 98 | 99 | 197 | ||||||||||||||||||||||||||||||||||
256039 | 256039 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000442 | 1 | Mitchell High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 145.0 | 1.0 | 9.0 | 13.0 | 4.0 | 10.0 | 95.0 | 87.0 | 182.0 | 145 | 1 | 9 | 13 | 4 | 10 | 95 | 87 | 182 | ||||||||||||||||||||||||||||||||||||
249971 | 249971 | SD | school | 4600042 | 58003 | Agar-Blunt-Onida 58-3 | 460004200656 | 7 | Sully Buttes High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 17.0 | 0.0 | 2.0 | 0.0 | 1.0 | 8.0 | 12.0 | 20.0 | 17 | 0 | 2 | 0 | 1 | 8 | 12 | 20 | ||||||||||||||||||||||||||||||||||||||
250386 | 250386 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001277 | 9 | Belle Fourche Education Connection | Alternative School | No | High | 09 | 12 | 2018 | grade_10 | 6.0 | 0.0 | 1.0 | 1.0 | 5.0 | 3.0 | 8.0 | 6 | 0 | 1 | 1 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||||||||
251777 | 251777 | SD | school | 4680445 | 21003 | Corsica-Stickney 21-3 | 468044501357 | 1 | Corsica-Stickney High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 16.0 | 1.0 | 9.0 | 8.0 | 17.0 | 16 | 1 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||||||||||||
252001 | 252001 | SD | school | 4618120 | 49003 | Dell Rapids 49-3 | 461812000165 | 1 | Dell Rapids High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 70.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 35.0 | 36.0 | 71.0 | 70 | 0 | 0 | 0 | 0 | 1 | 35 | 36 | 71 | ||||||||||||||||||||||||||||||||||||
252659 | 252659 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000188 | 1 | Elkton High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 24.0 | 4.0 | 0.0 | 0.0 | 1.0 | 14.0 | 15.0 | 29.0 | 24 | 4 | 0 | 0 | 1 | 14 | 15 | 29 | ||||||||||||||||||||||||||||||||||||||
253058 | 253058 | SD | school | 4624390 | 50003 | Flandreau 50-3 | 462439000206 | 1 | Flandreau High Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 16.0 | 1.0 | 4.0 | 18.0 | 0.0 | 0.0 | 1.0 | 20.0 | 20.0 | 40.0 | 16 | 1 | 4 | 18 | 0 | 0 | 1 | 20 | 20 | 40 | ||||||||||||||||||||||||||||||||||
253169 | 253169 | SD | school | 4621400 | 6002 | Frederick Area 06-2 | 462140000190 | 1 | Frederick High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 15.0 | 0.0 | 1.0 | 8.0 | 8.0 | 16.0 | 15 | 0 | 1 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||||||
253345 | 253345 | SD | school | 4626490 | 63001 | Gayville-Volin 63-1 | 462649000227 | 1 | Gayville-Volin Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 24.0 | 0.0 | 0.0 | 1.0 | 10.0 | 15.0 | 25.0 | 24 | 0 | 0 | 1 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||||||||||
253393 | 253393 | SD | school | 4626970 | 53001 | Gettysburg 53-1 | 462697000232 | 1 | Gettysburg High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 14.0 | 0.0 | 1.0 | 1.0 | 1.0 | 8.0 | 9.0 | 17.0 | 14 | 0 | 1 | 1 | 1 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||||||
253601 | 253601 | SD | school | 4630800 | 28003 | Hamlin 28-3 | 463080000260 | 1 | Hamlin Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 56.0 | 0.0 | 0.0 | 0.0 | 1.0 | 25.0 | 32.0 | 57.0 | 56 | 0 | 0 | 0 | 1 | 25 | 32 | 57 | ||||||||||||||||||||||||||||||||||||||
254517 | 254517 | SD | school | 4636060 | 22006 | Ipswich Public 22-6 | 463606000333 | 1 | Ipswich Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 24.0 | 0.0 | 0.0 | 1.0 | 10.0 | 15.0 | 25.0 | 24 | 0 | 0 | 1 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||||||||||
255059 | 255059 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130000374 | 1 | Lead-Deadwood High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 48.0 | 1.0 | 1.0 | 1.0 | 2.0 | 1.0 | 29.0 | 25.0 | 54.0 | 48 | 1 | 1 | 1 | 2 | 1 | 29 | 25 | 54 | ||||||||||||||||||||||||||||||||||||
255409 | 255409 | SD | school | 4639600 | 39002 | Madison Central 39-2 | 463960000363 | 1 | Madison High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 101.0 | 2.0 | 3.0 | 1.0 | 2.0 | 1.0 | 61.0 | 49.0 | 110.0 | 101 | 2 | 3 | 1 | 2 | 1 | 61 | 49 | 110 | ||||||||||||||||||||||||||||||||||||
255617 | 255617 | SD | school | 4646380 | 15002 | McLaughlin 15-2 | 464638000416 | 1 | McLaughlin High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 0.0 | 1.0 | 33.0 | 1.0 | 22.0 | 13.0 | 35.0 | 0 | 1 | 33 | 1 | 22 | 13 | 35 | ||||||||||||||||||||||||||||||||||||||||
256146 | 256146 | SD | school | 4680441 | 62006 | Mobridge-Pollock 62-6 | 468044100449 | 1 | Mobridge High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 30.0 | 2.0 | 21.0 | 1.0 | 31.0 | 23.0 | 54.0 | 30 | 2 | 21 | 1 | 31 | 23 | 54 | ||||||||||||||||||||||||||||||||||||||||
256369 | 256369 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 22.0 | 1.0 | 1.0 | 0.0 | 0.0 | 1.0 | 16.0 | 9.0 | 25.0 | 22 | 1 | 1 | 0 | 0 | 1 | 16 | 9 | 25 | ||||||||||||||||||||||||||||||||||||
256417 | 256417 | SD | school | 4651750 | 56007 | Northwestern Area 56-7 | 465175000475 | 1 | Northwestern High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 22.0 | 0.0 | 0.0 | 1.0 | 9.0 | 14.0 | 23.0 | 22 | 0 | 0 | 1 | 9 | 14 | 23 | ||||||||||||||||||||||||||||||||||||||||
256727 | 256727 | SD | school | 4654300 | 33003 | Parkston 33-3 | 465430000492 | 1 | Parkston High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 44.0 | 0.0 | 0.0 | 1.0 | 20.0 | 25.0 | 45.0 | 44 | 0 | 0 | 1 | 20 | 25 | 45 | ||||||||||||||||||||||||||||||||||||||||
256898 | 256898 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative School | No | High | 09 | 12 | 2018 | grade_10 | 6.0 | 1.0 | 0.0 | 8.0 | 1.0 | 8.0 | 8.0 | 16.0 | 6 | 1 | 0 | 8 | 1 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||
256981 | 256981 | SD | school | 4680438 | 11005 | Platte-Geddes 11-5 | 468043801248 | 1 | Platte-Geddes H.S | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 25.0 | 1.0 | 0.0 | 1.0 | 15.0 | 12.0 | 27.0 | 25 | 1 | 0 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||||||||
257522 | 257522 | SD | school | 4663360 | 54004 | Rosholt 54-4 | 466336000557 | 1 | Rosholt High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 22.0 | 2.0 | 1.0 | 13.0 | 12.0 | 25.0 | 22 | 2 | 1 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||||||||||
257650 | 257650 | SD | school | 4603932 | 55005 | Sanborn Central 55-5 | 460393200099 | 1 | Sanborn Central High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 9.0 | 0.0 | 0.0 | 1.0 | 4.0 | 6.0 | 10.0 | 9 | 0 | 0 | 1 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||||||||
258497 | 258497 | SD | school | 4666300 | 5005 | Sioux Valley 05-5 | 466630000612 | 1 | Sioux Valley High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 48.0 | 6.0 | 0.0 | 0.0 | 1.0 | 21.0 | 34.0 | 55.0 | 48 | 6 | 0 | 0 | 1 | 21 | 34 | 55 | ||||||||||||||||||||||||||||||||||||||
258819 | 258819 | SD | school | 4624850 | 57001 | Stanley County 57-1 | 462485000217 | 1 | Stanley County High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 34.0 | 0.0 | 6.0 | 1.0 | 21.0 | 20.0 | 41.0 | 34 | 0 | 6 | 1 | 21 | 20 | 41 | ||||||||||||||||||||||||||||||||||||||||
258880 | 258880 | SD | school | 4670140 | 54006 | Summit 54-6 | 467014000663 | 1 | Summit High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 15.0 | 1.0 | 0.0 | 1.0 | 1.0 | 9.0 | 9.0 | 18.0 | 15 | 1 | 0 | 1 | 1 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||||||||
259217 | 259217 | SD | school | 4644940 | 49006 | Tri-Valley 49-6 | 464494000405 | 1 | Tri-Valley High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 48.0 | 3.0 | 0.0 | 1.0 | 0.0 | 1.0 | 28.0 | 25.0 | 53.0 | 48 | 3 | 0 | 1 | 0 | 1 | 28 | 25 | 53 | ||||||||||||||||||||||||||||||||||||
259347 | 259347 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000691 | 1 | Vermillion High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 70.0 | 3.0 | 5.0 | 8.0 | 1.0 | 0.0 | 1.0 | 38.0 | 50.0 | 88.0 | 70 | 3 | 5 | 8 | 1 | 0 | 1 | 38 | 50 | 88 | ||||||||||||||||||||||||||||||||||
249815 | 249815 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000002 | 5 | C.C. Lee Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249817 | 249817 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000005 | 2 | Holgate Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
249818 | 249818 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000007 | 8 | Lincoln Elementary | Regular School | No | Elementary | PK | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249819 | 249819 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000008 | 9 | May Overby Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249820 | 249820 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207001367 | 7 | Mike Miller Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249822 | 249822 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000009 | 11 | O.M. Tiffany Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249823 | 249823 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000010 | 10 | Simmons Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249824 | 249824 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000011 | 3 | Simmons Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
249969 | 249969 | SD | school | 4600042 | 58003 | Agar-Blunt-Onida 58-3 | 460004200855 | 3 | Blunt Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
249970 | 249970 | SD | school | 4600042 | 58003 | Agar-Blunt-Onida 58-3 | 460004200655 | 4 | Onida Elementary | Regular School | No | Elementary | KG | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
249972 | 249972 | SD | school | 4600042 | 58003 | Agar-Blunt-Onida 58-3 | 460004200939 | 6 | Sully Buttes Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
250032 | 250032 | SD | school | 4600028 | 61001 | Alcester-Hudson 61-1 | 460002800013 | 4 | Alcester-Hudson Elementary | Regular School | No | Elementary | PK | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250034 | 250034 | SD | school | 4600028 | 61001 | Alcester-Hudson 61-1 | 460002800874 | 3 | Alcester-Hudson JH | Regular School | No | Middle | 07 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
250082 | 250082 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | No | Elementary | PK | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250083 | 250083 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 1.0 | 10.0 | 0.0 | 8.0 | 3.0 | 11.0 | 1 | 10 | 0 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||||||||||||
250084 | 250084 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000850 | 4 | Andes Central Jr High | Regular School | No | Middle | 07 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250224 | 250224 | SD | school | 4603780 | 21001 | Armour 21-1 | 460378000023 | 2 | Armour Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250226 | 250226 | SD | school | 4603780 | 21001 | Armour 21-1 | 460378000878 | 3 | Armour Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250273 | 250273 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000028 | 2 | Avon Elementary School | Regular School | No | Elementary | KG | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250274 | 250274 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000029 | 1 | Avon High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 19.0 | 2.0 | 0.0 | 11.0 | 10.0 | 21.0 | 19 | 2 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||||||||||
250275 | 250275 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000829 | 5 | Avon Jr High School | Regular School | No | Middle | 07 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250276 | 250276 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427001325 | 6 | Avon PK | Regular School | No | Prekindergarten | PK | PK | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
250336 | 250336 | SD | school | 4604680 | 49001 | Baltic 49-1 | 460468000035 | 2 | Baltic Elem | Regular School | No | Elementary | PK | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250337 | 250337 | SD | school | 4604680 | 49001 | Baltic 49-1 | 460468000036 | 1 | Baltic High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 31.0 | 0.0 | 1.0 | 1.0 | 0.0 | 0.0 | 17.0 | 16.0 | 33.0 | 31 | 0 | 1 | 1 | 0 | 0 | 17 | 16 | 33 | ||||||||||||||||||||||||||||||||||||
250338 | 250338 | SD | school | 4604680 | 49001 | Baltic 49-1 | 460468000986 | 3 | Baltic Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250388 | 250388 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001117 | 7 | Belle Fourche MS | Regular School | No | Middle | 05 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250389 | 250389 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000289 | 8 | North Park Elementary | Regular School | No | Elementary | KG | KG | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250390 | 250390 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000269 | 3 | South Park Elementary | Regular School | No | Elementary | 01 | 04 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250465 | 250465 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624001015 | 6 | Bennett County Jr High | Regular School | No | Middle | 07 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250466 | 250466 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000045 | 3 | Martin Elem | Regular School | No | Elementary | PK | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250512 | 250512 | SD | school | 4606360 | 61002 | Beresford 61-2 | 460636000047 | 2 | Beresford Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
250514 | 250514 | SD | school | 4606360 | 61002 | Beresford 61-2 | 460636000051 | 3 | Beresford Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250592 | 250592 | SD | school | 4607050 | 52001 | Bison 52-1 | 460705000054 | 2 | Bison Elementary | Regular School | No | Elementary | KG | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
250644 | 250644 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000065 | 1 | Bon Homme High School | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 36.0 | 1.0 | 2.0 | 0.0 | 18.0 | 21.0 | 39.0 | 36 | 1 | 2 | 0 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||||||||
250645 | 250645 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000987 | 2 | Bon Homme Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250648 | 250648 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000061 | 3 | Springfield Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
250650 | 250650 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000064 | 4 | Tyndall Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250752 | 250752 | SD | school | 4607800 | 22001 | Bowdle 22-1 | 460780000068 | 2 | Bowdle Elementary | Regular School | No | Elementary | PK | 06 | 2018 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 |
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]);