enrollments
Data source: Big Local News · About: Big Local
10,704 rows where state = "SD" and year = 2017 sorted by native_american descending
This data as json, CSV (advanced)
grade ✖
- grade_1 669
- grade_10 669
- grade_11 669
- grade_12 669
- grade_2 669
- grade_3 669
- grade_4 669
- grade_5 669
- grade_6 669
- grade_7 669
- grade_8 669
- grade_9 669
- k_12_total 669
- kindergarten 669
- pk_12_total 669
- pre_kindergarten 669
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015424 | 3015424 | SD | school | 4671880 | 20003 | Timber Lake 20-3 | 467188000664 | 2 | Timber Lake Elementary K-5 | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 80.0 | 1.0 | 5.0 | 99.0 | 2.0 | 104.0 | 83.0 | 187.0 | 80 | 1 | 5 | 99 | 2 | 104 | 83 | 187 | ||||||||||||||||||||||||||||||||||||||
3015581 | 3015581 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209001349 | 16 | Todd County Elem | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 1.0 | 2.0 | 98.0 | 0.0 | 0.0 | 2.0 | 56.0 | 47.0 | 103.0 | 1 | 2 | 98 | 0 | 0 | 2 | 56 | 47 | 103 | ||||||||||||||||||||||||||||||||||||
3014780 | 3014780 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001063 | 3 | Roosevelt High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1667.0 | 187.0 | 227.0 | 95.0 | 72.0 | 1.0 | 49.0 | 1184.0 | 1114.0 | 5.4 | 2298.0 | 1667 | 187 | 227 | 95 | 72 | 1 | 49 | 1184 | 1114 | 2298 | |||||||||||||||||||||||||||||||||
3014864 | 3014864 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001063 | 3 | Roosevelt High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1667.0 | 187.0 | 227.0 | 95.0 | 72.0 | 1.0 | 49.0 | 1184.0 | 1114.0 | 2298.0 | 1667 | 187 | 227 | 95 | 72 | 1 | 49 | 1184 | 1114 | 2298 | ||||||||||||||||||||||||||||||||||
3014762 | 3014762 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001333 | 9 | George McGovern Middle School | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 321.0 | 145.0 | 154.0 | 94.0 | 27.0 | 1.0 | 43.0 | 402.0 | 383.0 | 12.7 | 785.0 | 321 | 145 | 154 | 94 | 27 | 1 | 43 | 402 | 383 | 785 | |||||||||||||||||||||||||||||||||
3014846 | 3014846 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001333 | 9 | George McGovern Middle School | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 321.0 | 145.0 | 154.0 | 94.0 | 27.0 | 1.0 | 43.0 | 402.0 | 383.0 | 785.0 | 321 | 145 | 154 | 94 | 27 | 1 | 43 | 402 | 383 | 785 | ||||||||||||||||||||||||||||||||||
3014770 | 3014770 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1440.0 | 196.0 | 119.0 | 93.0 | 59.0 | 72.0 | 1010.0 | 969.0 | 4.6 | 1979.0 | 1440 | 196 | 119 | 93 | 59 | 72 | 1010 | 969 | 1979 | |||||||||||||||||||||||||||||||||||
3014854 | 3014854 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000600 | 2 | Lincoln High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1440.0 | 196.0 | 119.0 | 93.0 | 59.0 | 72.0 | 1010.0 | 969.0 | 1979.0 | 1440 | 196 | 119 | 93 | 59 | 72 | 1010 | 969 | 1979 | ||||||||||||||||||||||||||||||||||||
3006550 | 3006550 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | No | Elementary | PK | 06 | 2017 | k_12_total | 33.0 | 5.0 | 92.0 | 0.0 | 20.0 | 79.0 | 71.0 | 0.7 | 150.0 | 33 | 5 | 92 | 0 | 20 | 79 | 71 | 150 | |||||||||||||||||||||||||||||||||||||
3012969 | 3012969 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546000574 | 2 | Wolf Creek School | Regular School | No | Elementary | PK | 08 | 2017 | grade_3 | 1.0 | 2.0 | 92.0 | 1.0 | 44.0 | 52.0 | 96.0 | 1 | 2 | 92 | 1 | 44 | 52 | 96 | ||||||||||||||||||||||||||||||||||||||||
3013521 | 3013521 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000529 | 41 | Central Hi Sch | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 318.0 | 13.0 | 14.0 | 91.0 | 4.0 | 20.0 | 233.0 | 227.0 | 460.0 | 318 | 13 | 14 | 91 | 4 | 20 | 233 | 227 | 460 | ||||||||||||||||||||||||||||||||||||
3015418 | 3015418 | SD | school | 4671880 | 20003 | Timber Lake 20-3 | 467188000664 | 2 | Timber Lake Elementary K-5 | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 68.0 | 1.0 | 5.0 | 91.0 | 1.0 | 93.0 | 73.0 | 0.0 | 166.0 | 68 | 1 | 5 | 91 | 1 | 93 | 73 | 166 | |||||||||||||||||||||||||||||||||||||
3006530 | 3006530 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_5 | 8.0 | 0.0 | 9.0 | 0.0 | 2.0 | 7.0 | 12.0 | 19.0 | 8 | 0 | 9 | 0 | 2 | 7 | 12 | 19 | ||||||||||||||||||||||||||||||||||||||
3007519 | 3007519 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852000083 | 2 | George S Mickelson Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 208.0 | 0.0 | 11.0 | 9.0 | 8.0 | 0.0 | 12.0 | 138.0 | 110.0 | 248.0 | 208 | 0 | 11 | 9 | 8 | 0 | 12 | 138 | 110 | 248 | ||||||||||||||||||||||||||||||||||
3007536 | 3007536 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852001356 | 7 | Dakota Prairie Elementary | Regular School | No | Elementary | KG | 03 | 2017 | k_12_total | 406.0 | 11.0 | 15.0 | 9.0 | 6.0 | 26.0 | 249.0 | 224.0 | 1.7 | 473.0 | 406 | 11 | 15 | 9 | 6 | 26 | 249 | 224 | 473 | |||||||||||||||||||||||||||||||||||
3007548 | 3007548 | SD | school | 4608520 | 5001 | Brookings 05-1 | 460852001356 | 7 | Dakota Prairie Elementary | Regular School | No | Elementary | KG | 03 | 2017 | pk_12_total | 406.0 | 11.0 | 15.0 | 9.0 | 6.0 | 26.0 | 249.0 | 224.0 | 473.0 | 406 | 11 | 15 | 9 | 6 | 26 | 249 | 224 | 473 | ||||||||||||||||||||||||||||||||||||
3007595 | 3007595 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 56.0 | 1.0 | 9.0 | 26.0 | 40.0 | 0.0 | 66.0 | 56 | 1 | 9 | 26 | 40 | 66 | |||||||||||||||||||||||||||||||||||||||||
3007601 | 3007601 | SD | school | 4609512 | 26002 | Burke 26-2 | 460951200101 | 1 | Burke High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 56.0 | 1.0 | 9.0 | 26.0 | 40.0 | 66.0 | 56 | 1 | 9 | 26 | 40 | 66 | ||||||||||||||||||||||||||||||||||||||||||
3008169 | 3008169 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | Elementary | KG | 08 | 2017 | k_12_total | 2.0 | 9.0 | 4.0 | 7.0 | 0.0 | 11.0 | 2 | 9 | 4 | 7 | 11 | |||||||||||||||||||||||||||||||||||||||||||
3008177 | 3008177 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | Elementary | KG | 08 | 2017 | pk_12_total | 2.0 | 9.0 | 4.0 | 7.0 | 11.0 | 2 | 9 | 4 | 7 | 11 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
3009931 | 3009931 | SD | school | 4629880 | 26004 | Gregory 26-4 | 462988000239 | 1 | Gregory High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 94.0 | 2.0 | 9.0 | 1.0 | 2.0 | 1.0 | 62.0 | 47.0 | 0.0 | 109.0 | 94 | 2 | 9 | 1 | 2 | 1 | 62 | 47 | 109 | |||||||||||||||||||||||||||||||||||
3009937 | 3009937 | SD | school | 4629880 | 26004 | Gregory 26-4 | 462988000239 | 1 | Gregory High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 94.0 | 2.0 | 9.0 | 1.0 | 2.0 | 1.0 | 62.0 | 47.0 | 109.0 | 94 | 2 | 9 | 1 | 2 | 1 | 62 | 47 | 109 | ||||||||||||||||||||||||||||||||||||
3010389 | 3010389 | SD | school | 4631350 | 41002 | Harrisburg 41-2 | 463135000264 | 1 | Harrisburg High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 794.0 | 11.0 | 13.0 | 9.0 | 13.0 | 19.0 | 464.0 | 395.0 | 0.7 | 859.0 | 794 | 11 | 13 | 9 | 13 | 19 | 464 | 395 | 859 | |||||||||||||||||||||||||||||||||||
3010407 | 3010407 | SD | school | 4631350 | 41002 | Harrisburg 41-2 | 463135000264 | 1 | Harrisburg High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 794.0 | 11.0 | 13.0 | 9.0 | 13.0 | 19.0 | 464.0 | 395.0 | 859.0 | 794 | 11 | 13 | 9 | 13 | 19 | 464 | 395 | 859 | ||||||||||||||||||||||||||||||||||||
3010603 | 3010603 | SD | school | 4633360 | 51002 | Hill City 51-2 | 463336000280 | 1 | Hill City High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 120.0 | 23.0 | 9.0 | 1.0 | 70.0 | 83.0 | 1.3 | 153.0 | 120 | 23 | 9 | 1 | 70 | 83 | 153 | |||||||||||||||||||||||||||||||||||||||
3010609 | 3010609 | SD | school | 4633360 | 51002 | Hill City 51-2 | 463336000280 | 1 | Hill City High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 120.0 | 23.0 | 9.0 | 1.0 | 70.0 | 83.0 | 153.0 | 120 | 23 | 9 | 1 | 70 | 83 | 153 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
3010940 | 3010940 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000313 | 1 | Huron High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 414.0 | 13.0 | 122.0 | 9.0 | 178.0 | 418.0 | 318.0 | 25.0 | 736.0 | 414 | 13 | 122 | 9 | 178 | 418 | 318 | 736 | |||||||||||||||||||||||||||||||||||||
3010944 | 3010944 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548001373 | 20 | Washington 4-5 Center | Regular School | No | Elementary | 04 | 05 | 2017 | k_12_total | 168.0 | 8.0 | 76.0 | 9.0 | 83.0 | 8.0 | 178.0 | 174.0 | 17.3 | 352.0 | 168 | 8 | 76 | 9 | 83 | 8 | 178 | 174 | 352 | |||||||||||||||||||||||||||||||||||
3010954 | 3010954 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548000313 | 1 | Huron High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 414.0 | 13.0 | 122.0 | 9.0 | 178.0 | 418.0 | 318.0 | 736.0 | 414 | 13 | 122 | 9 | 178 | 418 | 318 | 736 | ||||||||||||||||||||||||||||||||||||||
3010958 | 3010958 | SD | school | 4635480 | 2002 | Huron 02-2 | 463548001373 | 20 | Washington 4-5 Center | Regular School | No | Elementary | 04 | 05 | 2017 | pk_12_total | 168.0 | 8.0 | 76.0 | 9.0 | 83.0 | 8.0 | 178.0 | 174.0 | 352.0 | 168 | 8 | 76 | 9 | 83 | 8 | 178 | 174 | 352 | ||||||||||||||||||||||||||||||||||||
3011543 | 3011543 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130000372 | 3 | Lead-Deadwood Elementary | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 267.0 | 3.0 | 13.0 | 9.0 | 4.0 | 1.0 | 13.0 | 152.0 | 158.0 | 0.7 | 310.0 | 267 | 3 | 13 | 9 | 4 | 1 | 13 | 152 | 158 | 310 | |||||||||||||||||||||||||||||||||
3011551 | 3011551 | SD | school | 4641300 | 40001 | Lead-Deadwood 40-1 | 464130000372 | 3 | Lead-Deadwood Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 267.0 | 3.0 | 13.0 | 9.0 | 4.0 | 1.0 | 13.0 | 152.0 | 158.0 | 310.0 | 267 | 3 | 13 | 9 | 4 | 1 | 13 | 152 | 158 | 310 | ||||||||||||||||||||||||||||||||||
3012218 | 3012218 | SD | school | 4669930 | 46001 | Meade 46-1 | 466993000633 | 1 | Sturgis Brown HS | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 188.0 | 0.0 | 4.0 | 9.0 | 0.0 | 1.0 | 8.0 | 111.0 | 99.0 | 210.0 | 188 | 0 | 4 | 9 | 0 | 1 | 8 | 111 | 99 | 210 | ||||||||||||||||||||||||||||||||||
3012484 | 3012484 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000441 | 5 | Longfellow Elementary | Regular School | No | Elementary | KG | 05 | 2017 | grade_2 | 52.0 | 1.0 | 5.0 | 9.0 | 0.0 | 1.0 | 28.0 | 40.0 | 68.0 | 52 | 1 | 5 | 9 | 0 | 1 | 28 | 40 | 68 | ||||||||||||||||||||||||||||||||||||
3012521 | 3012521 | SD | school | 4648390 | 17002 | Mitchell 17-2 | 464839000437 | 2 | Mitchell Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 199.0 | 2.0 | 4.0 | 9.0 | 6.0 | 2.0 | 1.0 | 116.0 | 107.0 | 223.0 | 199 | 2 | 4 | 9 | 6 | 2 | 1 | 116 | 107 | 223 | ||||||||||||||||||||||||||||||||||
3012937 | 3012937 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546000575 | 4 | Red Shirt School - 04 | Regular School | No | Elementary | PK | 08 | 2017 | grade_1 | 0.0 | 9.0 | 4.0 | 5.0 | 9.0 | 0 | 9 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
3012967 | 3012967 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546000575 | 4 | Red Shirt School - 04 | Regular School | No | Elementary | PK | 08 | 2017 | grade_3 | 0.0 | 9.0 | 5.0 | 4.0 | 9.0 | 0 | 9 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
3012989 | 3012989 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546001273 | 9 | Oglala Lakota County Alternative | Alternative School | No | Elementary | KG | 08 | 2017 | grade_7 | 9.0 | 5.0 | 4.0 | 9.0 | 9 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||
3013693 | 3013693 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | Elementary | KG | 05 | 2017 | grade_5 | 40.0 | 1.0 | 5.0 | 9.0 | 0.0 | 3.0 | 30.0 | 28.0 | 58.0 | 40 | 1 | 5 | 9 | 0 | 3 | 30 | 28 | 58 | ||||||||||||||||||||||||||||||||||||
3013830 | 3013830 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000549 | 10 | Meadowbrook Elem | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 60.0 | 1.0 | 3.0 | 9.0 | 0.0 | 1.0 | 6.0 | 41.0 | 39.0 | 80.0 | 60 | 1 | 3 | 9 | 0 | 1 | 6 | 41 | 39 | 80 | ||||||||||||||||||||||||||||||||||
3013852 | 3013852 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | Other | PK | 12 | 2017 | pk_12_total | 23.0 | 1.0 | 2.0 | 9.0 | 1.0 | 24.0 | 12.0 | 36.0 | 23 | 1 | 2 | 9 | 1 | 24 | 12 | 36 | ||||||||||||||||||||||||||||||||||||||
3013874 | 3013874 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000536 | 1 | General Beadle Elem | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 22.0 | 1.0 | 2.0 | 9.0 | 0.0 | 0.0 | 23.0 | 11.0 | 34.0 | 22 | 1 | 2 | 9 | 0 | 0 | 23 | 11 | 34 | ||||||||||||||||||||||||||||||||||||
3013877 | 3013877 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | Other | PK | 12 | 2017 | pre_kindergarten | 23.0 | 1.0 | 2.0 | 9.0 | 1.0 | 24.0 | 12.0 | 36.0 | 23 | 1 | 2 | 9 | 1 | 24 | 12 | 36 | ||||||||||||||||||||||||||||||||||||||
3014267 | 3014267 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000602 | 28 | Lowell Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_1 | 31.0 | 14.0 | 12.0 | 9.0 | 2.0 | 10.0 | 42.0 | 36.0 | 78.0 | 31 | 14 | 12 | 9 | 2 | 10 | 42 | 36 | 78 | ||||||||||||||||||||||||||||||||||||
3014453 | 3014453 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000579 | 11 | Terry Redlin Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_2 | 20.0 | 15.0 | 17.0 | 9.0 | 3.0 | 11.0 | 46.0 | 29.0 | 75.0 | 20 | 15 | 17 | 9 | 3 | 11 | 46 | 29 | 75 | ||||||||||||||||||||||||||||||||||||
3014647 | 3014647 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001070 | 4 | Memorial Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 378.0 | 19.0 | 18.0 | 9.0 | 11.0 | 15.0 | 224.0 | 226.0 | 450.0 | 378 | 19 | 18 | 9 | 11 | 15 | 224 | 226 | 450 | ||||||||||||||||||||||||||||||||||||
3014763 | 3014763 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000588 | 54 | Harvey Dunn Elementary | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 474.0 | 38.0 | 21.0 | 9.0 | 14.0 | 33.0 | 283.0 | 306.0 | 1.4 | 589.0 | 474 | 38 | 21 | 9 | 14 | 33 | 283 | 306 | 589 | |||||||||||||||||||||||||||||||||||
3014787 | 3014787 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001368 | 71 | Summit Oaks Shelter Care | Alternative School | No | Other | 05 | 12 | 2017 | k_12_total | 2.0 | 3.0 | 9.0 | 8.0 | 6.0 | 7.1 | 14.0 | 2 | 3 | 9 | 8 | 6 | 14 | |||||||||||||||||||||||||||||||||||||||||
3014831 | 3014831 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000579 | 11 | Terry Redlin Elementary | Regular School | No | Elementary | PK | 05 | 2017 | kindergarten | 25.0 | 17.0 | 24.0 | 9.0 | 2.0 | 4.0 | 43.0 | 38.0 | 81.0 | 25 | 17 | 24 | 9 | 2 | 4 | 43 | 38 | 81 | ||||||||||||||||||||||||||||||||||||
3014871 | 3014871 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001368 | 71 | Summit Oaks Shelter Care | Alternative School | No | Other | 05 | 12 | 2017 | pk_12_total | 2.0 | 3.0 | 9.0 | 8.0 | 6.0 | 14.0 | 2 | 3 | 9 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||||||||||
3014877 | 3014877 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000770 | 20 | Anne Sullivan Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 14.0 | 26.0 | 24.0 | 9.0 | 15.0 | 5.0 | 45.0 | 48.0 | 93.0 | 14 | 26 | 24 | 9 | 15 | 5 | 45 | 48 | 93 | ||||||||||||||||||||||||||||||||||||
3014887 | 3014887 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000587 | 19 | Garfield Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 18.0 | 20.0 | 7.0 | 9.0 | 0.0 | 0.0 | 4.0 | 31.0 | 27.0 | 58.0 | 18 | 20 | 7 | 9 | 0 | 0 | 4 | 31 | 27 | 58 | ||||||||||||||||||||||||||||||||||
3014915 | 3014915 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000579 | 11 | Terry Redlin Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 37.0 | 19.0 | 17.0 | 9.0 | 4.0 | 3.0 | 46.0 | 43.0 | 89.0 | 37 | 19 | 17 | 9 | 4 | 3 | 46 | 43 | 89 | ||||||||||||||||||||||||||||||||||||
3015434 | 3015434 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000509 | 14 | O'Kreek Elementary | Regular School | No | Elementary | KG | 08 | 2017 | grade_1 | 0.0 | 9.0 | 5.0 | 4.0 | 9.0 | 0 | 9 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
3015535 | 3015535 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000677 | 7 | Spring Creek Elem | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 9.0 | 0.0 | 3.0 | 6.0 | 9.0 | 9 | 0 | 3 | 6 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
3015579 | 3015579 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209000677 | 7 | Spring Creek Elem | Regular School | No | Elementary | KG | 08 | 2017 | kindergarten | 9.0 | 0.0 | 7.0 | 2.0 | 9.0 | 9 | 0 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||||||||||||
3015769 | 3015769 | SD | school | 4674370 | 13001 | Vermillion 13-1 | 467437000690 | 2 | Vermillion Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 71.0 | 3.0 | 9.0 | 9.0 | 0.0 | 6.0 | 45.0 | 53.0 | 98.0 | 71 | 3 | 9 | 9 | 0 | 6 | 45 | 53 | 98 | ||||||||||||||||||||||||||||||||||||
3016198 | 3016198 | SD | school | 4676680 | 18003 | Waubay 18-3 | 467668000945 | 3 | Waubay Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_8 | 3.0 | 2.0 | 9.0 | 8.0 | 6.0 | 14.0 | 3 | 2 | 9 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||||||||||
3016441 | 3016441 | SD | school | 4631710 | 49007 | West Central 49-7 | 463171000909 | 4 | West Central MS | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 302.0 | 3.0 | 2.0 | 9.0 | 8.0 | 178.0 | 146.0 | 0.0 | 324.0 | 302 | 3 | 2 | 9 | 8 | 178 | 146 | 324 | |||||||||||||||||||||||||||||||||||||
3016449 | 3016449 | SD | school | 4631710 | 49007 | West Central 49-7 | 463171000909 | 4 | West Central MS | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 302.0 | 3.0 | 2.0 | 9.0 | 8.0 | 178.0 | 146.0 | 324.0 | 302 | 3 | 2 | 9 | 8 | 178 | 146 | 324 | ||||||||||||||||||||||||||||||||||||||
3016530 | 3016530 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000749 | 8 | Norris Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 9.0 | 6.0 | 3.0 | 9.0 | 9 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
3013318 | 3013318 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 597.0 | 4.0 | 31.0 | 89.0 | 7.0 | 1.0 | 24.0 | 385.0 | 368.0 | 0.7 | 753.0 | 597 | 4 | 31 | 89 | 7 | 1 | 24 | 385 | 368 | 753 | |||||||||||||||||||||||||||||||||
3013328 | 3013328 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000500 | 1 | T F Riggs High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 597.0 | 4.0 | 31.0 | 89.0 | 7.0 | 1.0 | 24.0 | 385.0 | 368.0 | 753.0 | 597 | 4 | 31 | 89 | 7 | 1 | 24 | 385 | 368 | 753 | ||||||||||||||||||||||||||||||||||
3013815 | 3013815 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000525 | 42 | Stevens Hi Sch | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1356.0 | 10.0 | 82.0 | 89.0 | 20.0 | 43.0 | 815.0 | 785.0 | 1.0 | 1600.0 | 1356 | 10 | 82 | 89 | 20 | 43 | 815 | 785 | 1600 | |||||||||||||||||||||||||||||||||||
3013865 | 3013865 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000525 | 42 | Stevens Hi Sch | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1356.0 | 10.0 | 82.0 | 89.0 | 20.0 | 43.0 | 815.0 | 785.0 | 1600.0 | 1356 | 10 | 82 | 89 | 20 | 43 | 815 | 785 | 1600 | ||||||||||||||||||||||||||||||||||||
3015493 | 3015493 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209001349 | 16 | Todd County Elem | Regular School | No | Elementary | KG | 05 | 2017 | grade_3 | 0.0 | 1.0 | 89.0 | 0.0 | 1.0 | 0.0 | 39.0 | 52.0 | 91.0 | 0 | 1 | 89 | 0 | 1 | 0 | 39 | 52 | 91 | ||||||||||||||||||||||||||||||||||||
3006906 | 3006906 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000042 | 1 | Bennett County High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 43.0 | 3.0 | 88.0 | 1.0 | 25.0 | 84.0 | 76.0 | 1.3 | 160.0 | 43 | 3 | 88 | 1 | 25 | 84 | 76 | 160 | |||||||||||||||||||||||||||||||||||||
3006912 | 3006912 | SD | school | 4606240 | 3001 | Bennett County 03-1 | 460624000042 | 1 | Bennett County High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 43.0 | 3.0 | 88.0 | 1.0 | 25.0 | 84.0 | 76.0 | 160.0 | 43 | 3 | 88 | 1 | 25 | 84 | 76 | 160 | ||||||||||||||||||||||||||||||||||||||
3006351 | 3006351 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000003 | 1 | Central High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1044.0 | 40.0 | 40.0 | 87.0 | 34.0 | 7.0 | 11.0 | 652.0 | 611.0 | 2.5 | 1263.0 | 1044 | 40 | 40 | 87 | 34 | 7 | 11 | 652 | 611 | 1263 | |||||||||||||||||||||||||||||||||
3006371 | 3006371 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000003 | 1 | Central High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1044.0 | 40.0 | 40.0 | 87.0 | 34.0 | 7.0 | 11.0 | 652.0 | 611.0 | 1263.0 | 1044 | 40 | 40 | 87 | 34 | 7 | 11 | 652 | 611 | 1263 | ||||||||||||||||||||||||||||||||||
3007851 | 3007851 | SD | school | 4612000 | 7001 | Chamberlain 07-1 | 461200000119 | 1 | Chamberlain High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 127.0 | 3.0 | 11.0 | 87.0 | 3.0 | 8.0 | 113.0 | 126.0 | 0.4 | 239.0 | 127 | 3 | 11 | 87 | 3 | 8 | 113 | 126 | 239 | |||||||||||||||||||||||||||||||||||
3007857 | 3007857 | SD | school | 4612000 | 7001 | Chamberlain 07-1 | 461200000119 | 1 | Chamberlain High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 127.0 | 3.0 | 11.0 | 87.0 | 3.0 | 8.0 | 113.0 | 126.0 | 239.0 | 127 | 3 | 11 | 87 | 3 | 8 | 113 | 126 | 239 | ||||||||||||||||||||||||||||||||||||
3013845 | 3013845 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000540 | 4 | Canyon Lake Elem | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 261.0 | 12.0 | 26.0 | 87.0 | 3.0 | 2.0 | 33.0 | 223.0 | 201.0 | 424.0 | 261 | 12 | 26 | 87 | 3 | 2 | 33 | 223 | 201 | 424 | ||||||||||||||||||||||||||||||||||
3016552 | 3016552 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000754 | 1 | White River High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 16.0 | 2.0 | 87.0 | 1.0 | 1.0 | 1.0 | 57.0 | 51.0 | 2.8 | 108.0 | 16 | 2 | 87 | 1 | 1 | 1 | 57 | 51 | 108 | |||||||||||||||||||||||||||||||||||
3016560 | 3016560 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000754 | 1 | White River High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 16.0 | 2.0 | 87.0 | 1.0 | 1.0 | 1.0 | 57.0 | 51.0 | 108.0 | 16 | 2 | 87 | 1 | 1 | 1 | 57 | 51 | 108 | ||||||||||||||||||||||||||||||||||||
3013315 | 3013315 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000501 | 2 | Georgia Morse Middle School | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 442.0 | 4.0 | 19.0 | 86.0 | 2.0 | 50.0 | 312.0 | 291.0 | 0.5 | 603.0 | 442 | 4 | 19 | 86 | 2 | 50 | 312 | 291 | 603 | |||||||||||||||||||||||||||||||||||
3013325 | 3013325 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000501 | 2 | Georgia Morse Middle School | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 442.0 | 4.0 | 19.0 | 86.0 | 2.0 | 50.0 | 312.0 | 291.0 | 603.0 | 442 | 4 | 19 | 86 | 2 | 50 | 312 | 291 | 603 | ||||||||||||||||||||||||||||||||||||
3013795 | 3013795 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000540 | 4 | Canyon Lake Elem | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 249.0 | 12.0 | 25.0 | 86.0 | 2.0 | 2.0 | 31.0 | 209.0 | 198.0 | 0.5 | 407.0 | 249 | 12 | 25 | 86 | 2 | 2 | 31 | 209 | 198 | 407 | |||||||||||||||||||||||||||||||||
3016553 | 3016553 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000951 | 4 | White River Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 7.0 | 2.0 | 86.0 | 1.0 | 49.0 | 47.0 | 1.0 | 96.0 | 7 | 2 | 86 | 1 | 49 | 47 | 96 | |||||||||||||||||||||||||||||||||||||||
3016561 | 3016561 | SD | school | 4678570 | 47001 | White River 47-1 | 467857000951 | 4 | White River Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 7.0 | 2.0 | 86.0 | 1.0 | 49.0 | 47.0 | 96.0 | 7 | 2 | 86 | 1 | 49 | 47 | 96 | ||||||||||||||||||||||||||||||||||||||||
3013816 | 3013816 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000969 | 13 | Valley View Elem | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 450.0 | 12.0 | 33.0 | 84.0 | 11.0 | 1.0 | 38.0 | 326.0 | 303.0 | 1.0 | 629.0 | 450 | 12 | 33 | 84 | 11 | 1 | 38 | 326 | 303 | 629 | |||||||||||||||||||||||||||||||||
3013866 | 3013866 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000969 | 13 | Valley View Elem | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 450.0 | 12.0 | 33.0 | 84.0 | 11.0 | 1.0 | 38.0 | 326.0 | 303.0 | 629.0 | 450 | 12 | 33 | 84 | 11 | 1 | 38 | 326 | 303 | 629 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
3008827 | 3008827 | SD | school | 4619450 | 64002 | Dupree 64-2 | 461945000800 | 1 | Dupree Hi Sch | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 20.0 | 83.0 | 1.0 | 52.0 | 52.0 | 1.0 | 104.0 | 20 | 83 | 1 | 52 | 52 | 104 | |||||||||||||||||||||||||||||||||||||||||
3008833 | 3008833 | SD | school | 4619450 | 64002 | Dupree 64-2 | 461945000800 | 1 | Dupree Hi Sch | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 20.0 | 83.0 | 1.0 | 52.0 | 52.0 | 104.0 | 20 | 83 | 1 | 52 | 52 | 104 | ||||||||||||||||||||||||||||||||||||||||||
3013017 | 3013017 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546000574 | 2 | Wolf Creek School | Regular School | No | Elementary | PK | 08 | 2017 | kindergarten | 0.0 | 1.0 | 83.0 | 0.0 | 40.0 | 44.0 | 84.0 | 0 | 1 | 83 | 0 | 40 | 44 | 84 | ||||||||||||||||||||||||||||||||||||||||
3015438 | 3015438 | SD | school | 4672090 | 66001 | Todd County 66-1 | 467209001349 | 16 | Todd County Elem | Regular School | No | Elementary | KG | 05 | 2017 | grade_1 | 0.0 | 2.0 | 83.0 | 0.0 | 0.0 | 0.0 | 48.0 | 37.0 | 85.0 | 0 | 2 | 83 | 0 | 0 | 0 | 48 | 37 | 85 | ||||||||||||||||||||||||||||||||||||
3008888 | 3008888 | SD | school | 4620100 | 20001 | Eagle Butte 20-1 | 462010000897 | 2 | C-EB Primary | Regular School | No | Elementary | KG | 02 | 2017 | k_12_total | 1.0 | 82.0 | 1.0 | 45.0 | 39.0 | 0.0 | 84.0 | 1 | 82 | 1 | 45 | 39 | 84 | |||||||||||||||||||||||||||||||||||||||||
3008896 | 3008896 | SD | school | 4620100 | 20001 | Eagle Butte 20-1 | 462010000897 | 2 | C-EB Primary | Regular School | No | Elementary | KG | 02 | 2017 | pk_12_total | 1.0 | 82.0 | 1.0 | 45.0 | 39.0 | 84.0 | 1 | 82 | 1 | 45 | 39 | 84 | ||||||||||||||||||||||||||||||||||||||||||
3013021 | 3013021 | SD | school | 4665460 | 65001 | Oglala Lakota 65-1 | 466546000575 | 4 | Red Shirt School - 04 | Regular School | No | Elementary | PK | 08 | 2017 | pk_12_total | 2.0 | 82.0 | 50.0 | 34.0 | 84.0 | 2 | 82 | 50 | 34 | 84 | ||||||||||||||||||||||||||||||||||||||||||||
3013316 | 3013316 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000495 | 6 | Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 314.0 | 4.0 | 31.0 | 81.0 | 39.0 | 257.0 | 212.0 | 0.0 | 469.0 | 314 | 4 | 31 | 81 | 39 | 257 | 212 | 469 | |||||||||||||||||||||||||||||||||||||
3013326 | 3013326 | SD | school | 4655260 | 32002 | Pierre 32-2 | 465526000495 | 6 | Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 314.0 | 4.0 | 31.0 | 81.0 | 39.0 | 257.0 | 212.0 | 469.0 | 314 | 4 | 31 | 81 | 39 | 257 | 212 | 469 | ||||||||||||||||||||||||||||||||||||||
3014790 | 3014790 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1168.0 | 312.0 | 188.0 | 80.0 | 142.0 | 1.0 | 58.0 | 1026.0 | 923.0 | 11.8 | 1949.0 | 1168 | 312 | 188 | 80 | 142 | 1 | 58 | 1026 | 923 | 1949 | |||||||||||||||||||||||||||||||||
3014874 | 3014874 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000610 | 1 | Washington High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1168.0 | 312.0 | 188.0 | 80.0 | 142.0 | 1.0 | 58.0 | 1026.0 | 923.0 | 1949.0 | 1168 | 312 | 188 | 80 | 142 | 1 | 58 | 1026 | 923 | 1949 | ||||||||||||||||||||||||||||||||||
3015925 | 3015925 | SD | school | 4675420 | 11004 | Wagner Community 11-4 | 467542001278 | 4 | Wagner Primary School | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 42.0 | 5.0 | 80.0 | 11.0 | 74.0 | 64.0 | 138.0 | 42 | 5 | 80 | 11 | 74 | 64 | 138 | ||||||||||||||||||||||||||||||||||||||||
3006233 | 3006233 | SD | school | 4602070 | 6001 | Aberdeen 06-1 | 460207000007 | 8 | Lincoln Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_1 | 37.0 | 0.0 | 4.0 | 8.0 | 4.0 | 5.0 | 29.0 | 29.0 | 58.0 | 37 | 0 | 4 | 8 | 4 | 5 | 29 | 29 | 58 |
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]);