enrollments
Data source: Big Local News · About: Big Local
10,768 rows where state = "SD" and year = 2020 sorted by female descending
This data as json, CSV (advanced)
grade ✖
- grade_1 673
- grade_10 673
- grade_11 673
- grade_12 673
- grade_2 673
- grade_3 673
- grade_4 673
- grade_5 673
- grade_6 673
- grade_7 673
- grade_8 673
- grade_9 673
- k_12_total 673
- kindergarten 673
- pk_12_total 673
- pre_kindergarten 673
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
489689 | 489689 | SD | school | 4600036 | 19004 | Deuel 19-4 | 460003601011 | 2 | Clear Lake Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | k_12_total | 224.0 | 2.0 | 12.0 | 3.0 | 1.0 | 143.0 | 99.0 | 0.8 | 242.0 | 224 | 2 | 12 | 3 | 1 | 143 | 99 | 242 | |||||||||||||||||||||||||||||||||||||
489992 | 489992 | SD | school | 4620100 | 20001 | Eagle Butte 20-1 | 462010000605 | 3 | C-EB Upper Elementary | Regular School | Not applicable | Elementary | 03 | 06 | 2020 | k_12_total | 1.0 | 225.0 | 1.0 | 1.0 | 129.0 | 99.0 | 0.0 | 228.0 | 1 | 225 | 1 | 1 | 129 | 99 | 228 | |||||||||||||||||||||||||||||||||||||||
490000 | 490000 | SD | school | 4620100 | 20001 | Eagle Butte 20-1 | 462010000605 | 3 | C-EB Upper Elementary | Regular School | Not applicable | Elementary | 03 | 06 | 2020 | pk_12_total | 1.0 | 225.0 | 1.0 | 1.0 | 129.0 | 99.0 | 228.0 | 1 | 225 | 1 | 1 | 129 | 99 | 228 | ||||||||||||||||||||||||||||||||||||||||
490235 | 490235 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000187 | 2 | Elkton Elementary School | Regular School | Not applicable | Elementary | PK | 06 | 2020 | pk_12_total | 158.0 | 34.0 | 1.0 | 1.0 | 9.0 | 104.0 | 99.0 | 203.0 | 158 | 34 | 1 | 1 | 9 | 104 | 99 | 203 | ||||||||||||||||||||||||||||||||||||||
494382 | 494382 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 150.0 | 3.0 | 4.0 | 26.0 | 1.0 | 31.0 | 116.0 | 99.0 | 215.0 | 150 | 3 | 4 | 26 | 1 | 31 | 116 | 99 | 215 | ||||||||||||||||||||||||||||||||||||
494392 | 494392 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 156.0 | 0.0 | 6.0 | 17.0 | 2.0 | 9.0 | 91.0 | 99.0 | 190.0 | 156 | 0 | 6 | 17 | 2 | 9 | 91 | 99 | 190 | ||||||||||||||||||||||||||||||||||||
494831 | 494831 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000533 | 36 | South Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 120.0 | 1.0 | 24.0 | 46.0 | 2.0 | 30.0 | 124.0 | 99.0 | 223.0 | 120 | 1 | 24 | 46 | 2 | 30 | 124 | 99 | 223 | ||||||||||||||||||||||||||||||||||||
498064 | 498064 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 176.0 | 0.0 | 15.0 | 6.0 | 2.0 | 8.0 | 108.0 | 99.0 | 207.0 | 176 | 0 | 15 | 6 | 2 | 8 | 108 | 99 | 207 | ||||||||||||||||||||||||||||||||||||
498080 | 498080 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | k_12_total | 134.0 | 2.0 | 21.0 | 12.0 | 2.0 | 17.0 | 89.0 | 99.0 | 3.2 | 188.0 | 134 | 2 | 21 | 12 | 2 | 17 | 89 | 99 | 188 | |||||||||||||||||||||||||||||||||||
491941 | 491941 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548001373 | 20 | Washington 4-5 Center | Regular School | Not applicable | Elementary | 04 | 05 | 2020 | grade_4 | 96.0 | 3.0 | 72.0 | 6.0 | 55.0 | 1.0 | 6.0 | 141.0 | 98.0 | 239.0 | 96 | 3 | 72 | 6 | 55 | 1 | 6 | 141 | 98 | 239 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
494825 | 494825 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000532 | 35 | North Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 35.0 | 1.0 | 23.0 | 97.0 | 1.0 | 28.0 | 87.0 | 98.0 | 185.0 | 35 | 1 | 23 | 97 | 1 | 28 | 87 | 98 | 185 | ||||||||||||||||||||||||||||||||||||
494836 | 494836 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000822 | 37 | West Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 146.0 | 2.0 | 14.0 | 23.0 | 1.0 | 25.0 | 113.0 | 98.0 | 211.0 | 146 | 2 | 14 | 23 | 1 | 25 | 113 | 98 | 211 | ||||||||||||||||||||||||||||||||||||
487432 | 487432 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000011 | 3 | Simmons Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 145.0 | 3.0 | 17.0 | 13.0 | 6.0 | 1.0 | 9.0 | 97.0 | 97.0 | 194.0 | 145 | 3 | 17 | 13 | 6 | 1 | 9 | 97 | 97 | 194 | ||||||||||||||||||||||||||||||||||
489864 | 489864 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000176 | 1 | Douglas Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_8 | 148.0 | 4.0 | 10.0 | 15.0 | 4.0 | 3.0 | 17.0 | 104.0 | 97.0 | 201.0 | 148 | 4 | 10 | 15 | 4 | 3 | 17 | 104 | 97 | 201 | ||||||||||||||||||||||||||||||||||
491966 | 491966 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000314 | 2 | Huron Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_8 | 100.0 | 3.0 | 45.0 | 3.0 | 48.0 | 1.0 | 5.0 | 108.0 | 97.0 | 205.0 | 100 | 3 | 45 | 3 | 48 | 1 | 5 | 108 | 97 | 205 | ||||||||||||||||||||||||||||||||||
492090 | 492090 | SD | school | 4636060 | 22006 | Ipswich Public 22-6 | 463606000332 | 2 | Ipswich Elem | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pk_12_total | 165.0 | 1.0 | 5.0 | 2.0 | 1.0 | 1.0 | 78.0 | 97.0 | 175.0 | 165 | 1 | 5 | 2 | 1 | 1 | 78 | 97 | 175 | ||||||||||||||||||||||||||||||||||||
497047 | 497047 | SD | school | 4675420 | 11004 | Wagner Community 11-4 | 467542000695 | 1 | Wagner High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 65.0 | 4.0 | 93.0 | 1.0 | 15.0 | 81.0 | 97.0 | 0.0 | 178.0 | 65 | 4 | 93 | 1 | 15 | 81 | 97 | 178 | |||||||||||||||||||||||||||||||||||||
497055 | 497055 | SD | school | 4675420 | 11004 | Wagner Community 11-4 | 467542000695 | 1 | Wagner High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 65.0 | 4.0 | 93.0 | 1.0 | 15.0 | 81.0 | 97.0 | 178.0 | 65 | 4 | 93 | 1 | 15 | 81 | 97 | 178 | ||||||||||||||||||||||||||||||||||||||
496210 | 496210 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000623 | 1 | Spearfish High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 166.0 | 2.0 | 13.0 | 8.0 | 1.0 | 1.0 | 4.0 | 99.0 | 96.0 | 195.0 | 166 | 2 | 13 | 8 | 1 | 1 | 4 | 99 | 96 | 195 | ||||||||||||||||||||||||||||||||||
496238 | 496238 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000401 | 7 | Creekside Elem | Regular School | Not applicable | Elementary | 03 | 05 | 2020 | grade_3 | 166.0 | 1.0 | 9.0 | 3.0 | 3.0 | 0.0 | 9.0 | 95.0 | 96.0 | 191.0 | 166 | 1 | 9 | 3 | 3 | 0 | 9 | 95 | 96 | 191 | ||||||||||||||||||||||||||||||||||
498098 | 498098 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pre_kindergarten | 132.0 | 1.0 | 16.0 | 0.0 | 0.0 | 16.0 | 69.0 | 96.0 | 165.0 | 132 | 1 | 16 | 0 | 0 | 16 | 69 | 96 | 165 | ||||||||||||||||||||||||||||||||||||
495909 | 495909 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 1013.0 | 379.0 | 289.0 | 71.0 | 128.0 | 1.0 | 69.0 | 995.0 | 955.0 | 17.0 | 1950.0 | 1013 | 379 | 289 | 71 | 128 | 1 | 69 | 995 | 955 | 1950 | |||||||||||||||||||||||||||||||||
495993 | 495993 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 1013.0 | 379.0 | 289.0 | 71.0 | 128.0 | 1.0 | 69.0 | 995.0 | 955.0 | 1950.0 | 1013 | 379 | 289 | 71 | 128 | 1 | 69 | 995 | 955 | 1950 | ||||||||||||||||||||||||||||||||||
487593 | 487593 | SD | school | 4600028 | 61001 | Alcester-Hudson 61-1 | 460002800013 | 4 | Alcester-Hudson Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | k_12_total | 181.0 | 9.0 | 2.0 | 1.0 | 8.0 | 106.0 | 95.0 | 0.5 | 201.0 | 181 | 9 | 2 | 1 | 8 | 106 | 95 | 201 | |||||||||||||||||||||||||||||||||||||
488557 | 488557 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101140 | 2 | Britton-Hecla Elementary School | Regular School | Not applicable | Elementary | KG | 05 | 2020 | k_12_total | 157.0 | 1.0 | 14.0 | 7.0 | 84.0 | 95.0 | 0.0 | 179.0 | 157 | 1 | 14 | 7 | 84 | 95 | 179 | |||||||||||||||||||||||||||||||||||||||
488569 | 488569 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101140 | 2 | Britton-Hecla Elementary School | Regular School | Not applicable | Elementary | KG | 05 | 2020 | pk_12_total | 157.0 | 1.0 | 14.0 | 7.0 | 84.0 | 95.0 | 179.0 | 157 | 1 | 14 | 7 | 84 | 95 | 179 | ||||||||||||||||||||||||||||||||||||||||
489854 | 489854 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000176 | 1 | Douglas Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 153.0 | 4.0 | 26.0 | 16.0 | 0.0 | 2.0 | 16.0 | 122.0 | 95.0 | 217.0 | 153 | 4 | 26 | 16 | 0 | 2 | 16 | 122 | 95 | 217 | ||||||||||||||||||||||||||||||||||
490335 | 490335 | SD | school | 4622500 | 17001 | Ethan 17-1 | 462250000193 | 2 | Ethan Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | pk_12_total | 145.0 | 1.0 | 5.0 | 4.0 | 7.0 | 67.0 | 95.0 | 162.0 | 145 | 1 | 5 | 4 | 7 | 67 | 95 | 162 | ||||||||||||||||||||||||||||||||||||||
494886 | 494886 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000822 | 37 | West Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_8 | 153.0 | 3.0 | 16.0 | 12.0 | 0.0 | 22.0 | 111.0 | 95.0 | 206.0 | 153 | 3 | 16 | 12 | 0 | 22 | 111 | 95 | 206 | ||||||||||||||||||||||||||||||||||||
488877 | 488877 | SD | school | 4611280 | 28001 | Castlewood 28-1 | 461128000113 | 2 | Castlewood Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | pk_12_total | 158.0 | 13.0 | 4.0 | 81.0 | 94.0 | 175.0 | 158 | 13 | 4 | 81 | 94 | 175 | ||||||||||||||||||||||||||||||||||||||||||
489643 | 489643 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830000559 | 3 | Deubrook Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | pk_12_total | 183.0 | 1.0 | 4.0 | 2.0 | 2.0 | 98.0 | 94.0 | 192.0 | 183 | 1 | 4 | 2 | 2 | 98 | 94 | 192 | ||||||||||||||||||||||||||||||||||||||
491952 | 491952 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000314 | 2 | Huron Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 106.0 | 3.0 | 58.0 | 2.0 | 43.0 | 3.0 | 6.0 | 127.0 | 94.0 | 221.0 | 106 | 3 | 58 | 2 | 43 | 3 | 6 | 127 | 94 | 221 | ||||||||||||||||||||||||||||||||||
492599 | 492599 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130000374 | 1 | Lead-Deadwood High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 181.0 | 15.0 | 4.0 | 5.0 | 1.0 | 7.0 | 119.0 | 94.0 | 1.9 | 213.0 | 181 | 15 | 4 | 5 | 1 | 7 | 119 | 94 | 213 | |||||||||||||||||||||||||||||||||||
492607 | 492607 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130000374 | 1 | Lead-Deadwood High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 181.0 | 15.0 | 4.0 | 5.0 | 1.0 | 7.0 | 119.0 | 94.0 | 213.0 | 181 | 15 | 4 | 5 | 1 | 7 | 119 | 94 | 213 | ||||||||||||||||||||||||||||||||||||
498001 | 498001 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | Not applicable | Elementary | PK | 08 | 2020 | pk_12_total | 183.0 | 1.0 | 8.0 | 2.0 | 2.0 | 6.0 | 108.0 | 94.0 | 202.0 | 183 | 1 | 8 | 2 | 2 | 6 | 108 | 94 | 202 | ||||||||||||||||||||||||||||||||||||
487422 | 487422 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000011 | 3 | Simmons Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 137.0 | 3.0 | 15.0 | 15.0 | 8.0 | 0.0 | 13.0 | 98.0 | 93.0 | 191.0 | 137 | 3 | 15 | 15 | 8 | 0 | 13 | 98 | 93 | 191 | ||||||||||||||||||||||||||||||||||
491959 | 491959 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000314 | 2 | Huron Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 91.0 | 4.0 | 49.0 | 5.0 | 35.0 | 1.0 | 6.0 | 98.0 | 93.0 | 191.0 | 91 | 4 | 49 | 5 | 35 | 1 | 6 | 98 | 93 | 191 | ||||||||||||||||||||||||||||||||||
493151 | 493151 | SD | school | 4646380 | 15002 | McLaughlin 15-2 | 464638000415 | 2 | McLaughlin Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pk_12_total | 9.0 | 8.0 | 190.0 | 3.0 | 117.0 | 93.0 | 210.0 | 9 | 8 | 190 | 3 | 117 | 93 | 210 | ||||||||||||||||||||||||||||||||||||||||
497967 | 497967 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | Not applicable | Elementary | PK | 04 | 2020 | pk_12_total | 148.0 | 1.0 | 13.0 | 1.0 | 70.0 | 93.0 | 163.0 | 148 | 1 | 13 | 1 | 70 | 93 | 163 | ||||||||||||||||||||||||||||||||||||||||
488869 | 488869 | SD | school | 4611280 | 28001 | Castlewood 28-1 | 461128000113 | 2 | Castlewood Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | k_12_total | 144.0 | 13.0 | 4.0 | 69.0 | 92.0 | 2.5 | 161.0 | 144 | 13 | 4 | 69 | 92 | 161 | |||||||||||||||||||||||||||||||||||||||||
489818 | 489818 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941000174 | 3 | Douglas High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 147.0 | 4.0 | 15.0 | 14.0 | 4.0 | 3.0 | 16.0 | 111.0 | 92.0 | 203.0 | 147 | 4 | 15 | 14 | 4 | 3 | 16 | 111 | 92 | 203 | ||||||||||||||||||||||||||||||||||
496691 | 496691 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000678 | 1 | Todd County HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 2.0 | 1.0 | 188.0 | 0.0 | 0.0 | 99.0 | 92.0 | 191.0 | 2 | 1 | 188 | 0 | 0 | 99 | 92 | 191 | ||||||||||||||||||||||||||||||||||||||
487425 | 487425 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000005 | 2 | Holgate Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 154.0 | 8.0 | 7.0 | 13.0 | 2.0 | 1.0 | 7.0 | 101.0 | 91.0 | 192.0 | 154 | 8 | 7 | 13 | 2 | 1 | 7 | 101 | 91 | 192 | ||||||||||||||||||||||||||||||||||
487661 | 487661 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pk_12_total | 39.0 | 8.0 | 112.0 | 31.0 | 99.0 | 91.0 | 190.0 | 39 | 8 | 112 | 31 | 99 | 91 | 190 | ||||||||||||||||||||||||||||||||||||||||
492723 | 492723 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155001363 | 9 | Lennox Intermediate | Regular School | Not applicable | Middle | 05 | 06 | 2020 | k_12_total | 164.0 | 4.0 | 3.0 | 2.0 | 3.0 | 85.0 | 91.0 | 1.1 | 176.0 | 164 | 4 | 3 | 2 | 3 | 85 | 91 | 176 | |||||||||||||||||||||||||||||||||||||
492733 | 492733 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155001363 | 9 | Lennox Intermediate | Regular School | Not applicable | Middle | 05 | 06 | 2020 | pk_12_total | 164.0 | 4.0 | 3.0 | 2.0 | 3.0 | 85.0 | 91.0 | 176.0 | 164 | 4 | 3 | 2 | 3 | 85 | 91 | 176 | ||||||||||||||||||||||||||||||||||||||
493718 | 493718 | SD | school | 4680441 | 62006 | Mobridge-Pollock 62-6 | 468044100449 | 1 | Mobridge High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 107.0 | 1.0 | 6.0 | 65.0 | 9.0 | 97.0 | 91.0 | 0.0 | 188.0 | 107 | 1 | 6 | 65 | 9 | 97 | 91 | 188 | |||||||||||||||||||||||||||||||||||||
493726 | 493726 | SD | school | 4680441 | 62006 | Mobridge-Pollock 62-6 | 468044100449 | 1 | Mobridge High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 107.0 | 1.0 | 6.0 | 65.0 | 9.0 | 97.0 | 91.0 | 188.0 | 107 | 1 | 6 | 65 | 9 | 97 | 91 | 188 | ||||||||||||||||||||||||||||||||||||||
496246 | 496246 | SD | school | 4666930 | 40002 | Spearfish 40-2 | 466693000401 | 7 | Creekside Elem | Regular School | Not applicable | Elementary | 03 | 05 | 2020 | grade_4 | 165.0 | 4.0 | 13.0 | 4.0 | 1.0 | 1.0 | 5.0 | 102.0 | 91.0 | 193.0 | 165 | 4 | 13 | 4 | 1 | 1 | 5 | 102 | 91 | 193 | ||||||||||||||||||||||||||||||||||
491902 | 491902 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000313 | 1 | Huron High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 91.0 | 1.0 | 52.0 | 1.0 | 26.0 | 1.0 | 1.0 | 83.0 | 90.0 | 173.0 | 91 | 1 | 52 | 1 | 26 | 1 | 1 | 83 | 90 | 173 | ||||||||||||||||||||||||||||||||||
493188 | 493188 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 145.0 | 2.0 | 11.0 | 4.0 | 0.0 | 0.0 | 3.0 | 75.0 | 90.0 | 165.0 | 145 | 2 | 11 | 4 | 0 | 0 | 3 | 75 | 90 | 165 | ||||||||||||||||||||||||||||||||||
495898 | 495898 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000606 | 42 | Renberg Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2020 | k_12_total | 110.0 | 28.0 | 10.0 | 4.0 | 15.0 | 77.0 | 90.0 | 1.8 | 167.0 | 110 | 28 | 10 | 4 | 15 | 77 | 90 | 167 | |||||||||||||||||||||||||||||||||||||
495982 | 495982 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000606 | 42 | Renberg Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2020 | pk_12_total | 110.0 | 28.0 | 10.0 | 4.0 | 15.0 | 77.0 | 90.0 | 167.0 | 110 | 28 | 10 | 4 | 15 | 77 | 90 | 167 | ||||||||||||||||||||||||||||||||||||||
487494 | 487494 | SD | school | 4600042 | 58003 | Agar-Blunt-Onida 58-3 | 460004200655 | 4 | Onida Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2020 | grade_1 | 13.0 | 0.0 | 0.0 | 0.0 | 4.0 | 9.0 | 13.0 | 13 | 0 | 0 | 0 | 4 | 9 | 13 | ||||||||||||||||||||||||||||||||||||||||
487629 | 487629 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_4 | 3.0 | 0.0 | 14.0 | 4.0 | 12.0 | 9.0 | 21.0 | 3 | 0 | 14 | 4 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||
487650 | 487650 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 4.0 | 0.0 | 16.0 | 0.0 | 11.0 | 9.0 | 20.0 | 4 | 0 | 16 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
487797 | 487797 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000028 | 2 | Avon Elementary School | Regular School | Not applicable | Elementary | KG | 06 | 2020 | grade_2 | 11.0 | 1.0 | 1.0 | 0.0 | 4.0 | 9.0 | 13.0 | 11 | 1 | 1 | 0 | 4 | 9 | 13 | ||||||||||||||||||||||||||||||||||||||||
487809 | 487809 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000028 | 2 | Avon Elementary School | Regular School | Not applicable | Elementary | KG | 06 | 2020 | grade_5 | 12.0 | 0.0 | 2.0 | 2.0 | 7.0 | 9.0 | 16.0 | 12 | 0 | 2 | 2 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||||||||||
487826 | 487826 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000029 | 1 | Avon High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 19.0 | 1.0 | 0.0 | 11.0 | 9.0 | 20.0 | 19 | 1 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||||
488122 | 488122 | SD | school | 4607050 | 52001 | Bison 52-1 | 460705000054 | 2 | Bison Elementary | Regular School | Not applicable | Elementary | KG | 06 | 2020 | grade_5 | 14.0 | 0.0 | 1.0 | 0.0 | 0.0 | 6.0 | 9.0 | 15.0 | 14 | 0 | 1 | 0 | 0 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||||||||
488130 | 488130 | SD | school | 4607050 | 52001 | Bison 52-1 | 460705000879 | 4 | Bison JH | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_7 | 19.0 | 0.0 | 10.0 | 9.0 | 19.0 | 19 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||||||||||||
488210 | 488210 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000061 | 3 | Springfield Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2020 | grade_5 | 14.0 | 0.0 | 0.0 | 1.0 | 6.0 | 9.0 | 15.0 | 14 | 0 | 0 | 1 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||||||||||
488359 | 488359 | SD | school | 4607950 | 49002 | Brandon Valley 49-2 | 460795000073 | 4 | Valley Springs Elem | Regular School | Not applicable | Elementary | KG | 04 | 2020 | grade_2 | 19.0 | 2.0 | 0.0 | 0.0 | 12.0 | 9.0 | 21.0 | 19 | 2 | 0 | 0 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||
488684 | 488684 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 17.0 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 11.0 | 9.0 | 20.0 | 17 | 0 | 0 | 1 | 1 | 1 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||
488692 | 488692 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200100 | 2 | Burke Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_3 | 17.0 | 3.0 | 1.0 | 12.0 | 9.0 | 21.0 | 17 | 3 | 1 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||||
488698 | 488698 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200100 | 2 | Burke Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_5 | 16.0 | 1.0 | 0.0 | 8.0 | 9.0 | 17.0 | 16 | 1 | 0 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||||||||||
488990 | 488990 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000130 | 1 | Chester Area High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 23.0 | 0.0 | 0.0 | 14.0 | 9.0 | 23.0 | 23 | 0 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||||||||||
488995 | 488995 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001269 | 92 | Chester Area Cyber School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 20.0 | 11.0 | 9.0 | 20.0 | 20 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||
489010 | 489010 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000131 | 2 | Chester Area Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_2 | 17.0 | 0.0 | 0.0 | 1.0 | 9.0 | 9.0 | 18.0 | 17 | 0 | 0 | 1 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||||||||||
489031 | 489031 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000131 | 2 | Chester Area Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_5 | 20.0 | 0.0 | 0.0 | 1.0 | 12.0 | 9.0 | 21.0 | 20 | 0 | 0 | 1 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||
489106 | 489106 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000133 | 1 | Clark High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 16.0 | 2.0 | 2.0 | 11.0 | 9.0 | 20.0 | 16 | 2 | 2 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||||
489112 | 489112 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000133 | 1 | Clark High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 12.0 | 0.0 | 1.0 | 4.0 | 9.0 | 13.0 | 12 | 0 | 1 | 4 | 9 | 13 | ||||||||||||||||||||||||||||||||||||||||||
489137 | 489137 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000890 | 3 | Clark Middle School | Regular School | Not applicable | Middle | 05 | 08 | 2020 | grade_5 | 16.0 | 0.0 | 4.0 | 0.0 | 11.0 | 9.0 | 20.0 | 16 | 0 | 4 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
489143 | 489143 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000890 | 3 | Clark Middle School | Regular School | Not applicable | Middle | 05 | 08 | 2020 | grade_6 | 22.0 | 0.0 | 3.0 | 4.0 | 20.0 | 9.0 | 29.0 | 22 | 0 | 3 | 4 | 20 | 9 | 29 | ||||||||||||||||||||||||||||||||||||||||
489160 | 489160 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000133 | 1 | Clark High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 22.0 | 1.0 | 2.0 | 16.0 | 9.0 | 25.0 | 22 | 1 | 2 | 16 | 9 | 25 | ||||||||||||||||||||||||||||||||||||||||||
489193 | 489193 | SD | school | 4614100 | 50005 | Colman-Egan 50-5 | 461410000091 | 1 | Colman-Egan Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 18.0 | 0.0 | 0.0 | 1.0 | 0.0 | 10.0 | 9.0 | 19.0 | 18 | 0 | 0 | 1 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||||||
489279 | 489279 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000893 | 3 | Colome Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_8 | 15.0 | 1.0 | 0.0 | 0.0 | 7.0 | 9.0 | 16.0 | 15 | 1 | 0 | 0 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||||||||||
489282 | 489282 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000141 | 1 | Colome High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 15.0 | 4.0 | 0.0 | 2.0 | 12.0 | 9.0 | 21.0 | 15 | 4 | 0 | 2 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||
489335 | 489335 | SD | school | 4680445 | 21003 | Corsica-Stickney 21-3 | 468044501357 | 1 | Corsica-Stickney High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 14.0 | 5.0 | 9.0 | 14.0 | 14 | 5 | 9 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||
489479 | 489479 | SD | school | 4617850 | 38002 | De Smet 38-2 | 461785000162 | 2 | Laura Ingalls Wilder Elem | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_1 | 25.0 | 0.0 | 0.0 | 0.0 | 16.0 | 9.0 | 25.0 | 25 | 0 | 0 | 0 | 16 | 9 | 25 | ||||||||||||||||||||||||||||||||||||||||
489486 | 489486 | SD | school | 4617850 | 38002 | De Smet 38-2 | 461785000163 | 1 | De Smet High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 21.0 | 0.0 | 12.0 | 9.0 | 21.0 | 21 | 0 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||||||||
489491 | 489491 | SD | school | 4617850 | 38002 | De Smet 38-2 | 461785000162 | 2 | Laura Ingalls Wilder Elem | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_2 | 23.0 | 1.0 | 0.0 | 0.0 | 15.0 | 9.0 | 24.0 | 23 | 1 | 0 | 0 | 15 | 9 | 24 | ||||||||||||||||||||||||||||||||||||||||
489603 | 489603 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830000559 | 3 | Deubrook Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_4 | 17.0 | 1.0 | 1.0 | 1.0 | 0.0 | 11.0 | 9.0 | 20.0 | 17 | 1 | 1 | 1 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||
489648 | 489648 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830000559 | 3 | Deubrook Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2020 | pre_kindergarten | 21.0 | 0.0 | 0.0 | 0.0 | 0.0 | 12.0 | 9.0 | 21.0 | 21 | 0 | 0 | 0 | 0 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||
489788 | 489788 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000171 | 1 | Doland High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 23.0 | 14.0 | 9.0 | 0.0 | 23.0 | 23 | 14 | 9 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
489802 | 489802 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000171 | 1 | Doland High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 23.0 | 14.0 | 9.0 | 23.0 | 23 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||
490088 | 490088 | SD | school | 4634440 | 22005 | Edmunds Central 22-5 | 463444000032 | 2 | Edmunds Central Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | k_12_total | 19.0 | 4.0 | 1.0 | 15.0 | 9.0 | 8.3 | 24.0 | 19 | 4 | 1 | 15 | 9 | 24 | |||||||||||||||||||||||||||||||||||||||||
490096 | 490096 | SD | school | 4634440 | 22005 | Edmunds Central 22-5 | 463444000032 | 2 | Edmunds Central Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | pk_12_total | 19.0 | 4.0 | 1.0 | 15.0 | 9.0 | 24.0 | 19 | 4 | 1 | 15 | 9 | 24 | ||||||||||||||||||||||||||||||||||||||||||
490176 | 490176 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000188 | 1 | Elkton High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 19.0 | 0.0 | 1.0 | 1.0 | 1.0 | 13.0 | 9.0 | 22.0 | 19 | 0 | 1 | 1 | 1 | 13 | 9 | 22 | ||||||||||||||||||||||||||||||||||||||
490228 | 490228 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139001078 | 4 | Newdale Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 22.0 | 13.0 | 9.0 | 31.8 | 22.0 | 22 | 13 | 9 | 22 | |||||||||||||||||||||||||||||||||||||||||||||
490238 | 490238 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139001078 | 4 | Newdale Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | pk_12_total | 22.0 | 13.0 | 9.0 | 22.0 | 22 | 13 | 9 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||
490255 | 490255 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241000192 | 1 | Estelline High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 19.0 | 3.0 | 13.0 | 9.0 | 22.0 | 19 | 3 | 13 | 9 | 22 | ||||||||||||||||||||||||||||||||||||||||||||
490263 | 490263 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241000191 | 2 | Estelline Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_4 | 17.0 | 0.0 | 3.0 | 0.0 | 11.0 | 9.0 | 20.0 | 17 | 0 | 3 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
490351 | 490351 | SD | school | 4622560 | 44001 | Eureka 44-1 | 462256000196 | 1 | Eureka High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 10.0 | 1.0 | 0.0 | 2.0 | 9.0 | 11.0 | 10 | 1 | 0 | 2 | 9 | 11 | ||||||||||||||||||||||||||||||||||||||||||
490379 | 490379 | SD | school | 4622560 | 44001 | Eureka 44-1 | 462256000958 | 3 | Eureka Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | k_12_total | 15.0 | 1.0 | 1.0 | 8.0 | 9.0 | 0.0 | 17.0 | 15 | 1 | 1 | 8 | 9 | 17 | |||||||||||||||||||||||||||||||||||||||||
490385 | 490385 | SD | school | 4622560 | 44001 | Eureka 44-1 | 462256000958 | 3 | Eureka Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | pk_12_total | 15.0 | 1.0 | 1.0 | 8.0 | 9.0 | 17.0 | 15 | 1 | 1 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||||||||||
490431 | 490431 | SD | school | 4622940 | 46002 | Faith 46-2 | 462294000995 | 6 | Faith Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_8 | 12.0 | 2.0 | 0.0 | 5.0 | 9.0 | 14.0 | 12 | 2 | 0 | 5 | 9 | 14 | ||||||||||||||||||||||||||||||||||||||||||
490455 | 490455 | SD | school | 4624030 | 24004 | Faulkton Area | 462403000202 | 2 | Faulkton Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_1 | 19.0 | 0.0 | 0.0 | 0.0 | 10.0 | 9.0 | 19.0 | 19 | 0 | 0 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||||||||
490474 | 490474 | SD | school | 4624030 | 24004 | Faulkton Area | 462403000203 | 1 | Faulkton Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 18.0 | 0.0 | 9.0 | 9.0 | 18.0 | 18 | 0 | 9 | 9 | 18 |
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]);