enrollments
Data source: Big Local News · About: Big Local
10,768 rows where state = "SD" and year = 2020 sorted by district_nces_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
493429 | 493429 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_1 | 2.0 | 0.0 | 2.0 | 2.0 | 2 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||
493430 | 493430 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_1 | 51.0 | 0.0 | 5.0 | 1.0 | 1.0 | 0.0 | 2.0 | 26.0 | 34.0 | 60.0 | 51 | 0 | 5 | 1 | 1 | 0 | 2 | 26 | 34 | 60 | ||||||||||||||||||||||||||||||||||
493431 | 493431 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493432 | 493432 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493433 | 493433 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493434 | 493434 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | 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 | ||||||||||||||||||||||||||||||||||
493435 | 493435 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 67.0 | 0.0 | 3.0 | 0.0 | 0.0 | 39.0 | 31.0 | 70.0 | 67 | 0 | 3 | 0 | 0 | 39 | 31 | 70 | ||||||||||||||||||||||||||||||||||||||
493436 | 493436 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||
493437 | 493437 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493438 | 493438 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_11 | 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 | ||||||||||||||||||||||||||||||||||
493439 | 493439 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 75.0 | 1.0 | 5.0 | 1.0 | 1.0 | 43.0 | 40.0 | 83.0 | 75 | 1 | 5 | 1 | 1 | 43 | 40 | 83 | ||||||||||||||||||||||||||||||||||||||
493440 | 493440 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493441 | 493441 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493442 | 493442 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_12 | 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 | ||||||||||||||||||||||||||||||||||
493443 | 493443 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 72.0 | 0.0 | 10.0 | 0.0 | 1.0 | 45.0 | 38.0 | 83.0 | 72 | 0 | 10 | 0 | 1 | 45 | 38 | 83 | ||||||||||||||||||||||||||||||||||||||
493444 | 493444 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493445 | 493445 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493446 | 493446 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_2 | 54.0 | 1.0 | 14.0 | 0.0 | 0.0 | 0.0 | 2.0 | 29.0 | 42.0 | 71.0 | 54 | 1 | 14 | 0 | 0 | 0 | 2 | 29 | 42 | 71 | ||||||||||||||||||||||||||||||||||
493447 | 493447 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493448 | 493448 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493449 | 493449 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_3 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
493450 | 493450 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_3 | 55.0 | 0.0 | 6.0 | 0.0 | 0.0 | 0.0 | 4.0 | 33.0 | 32.0 | 65.0 | 55 | 0 | 6 | 0 | 0 | 0 | 4 | 33 | 32 | 65 | ||||||||||||||||||||||||||||||||||
493451 | 493451 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493452 | 493452 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493453 | 493453 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_4 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
493454 | 493454 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_4 | 42.0 | 1.0 | 8.0 | 1.0 | 0.0 | 0.0 | 2.0 | 32.0 | 22.0 | 54.0 | 42 | 1 | 8 | 1 | 0 | 0 | 2 | 32 | 22 | 54 | ||||||||||||||||||||||||||||||||||
493455 | 493455 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493456 | 493456 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493457 | 493457 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493458 | 493458 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_5 | 61.0 | 2.0 | 7.0 | 1.0 | 0.0 | 0.0 | 6.0 | 46.0 | 31.0 | 77.0 | 61 | 2 | 7 | 1 | 0 | 0 | 6 | 46 | 31 | 77 | ||||||||||||||||||||||||||||||||||
493459 | 493459 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493460 | 493460 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493461 | 493461 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493462 | 493462 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_6 | 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 | ||||||||||||||||||||||||||||||||||
493463 | 493463 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493464 | 493464 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_6 | 69.0 | 2.0 | 13.0 | 1.0 | 2.0 | 45.0 | 42.0 | 87.0 | 69 | 2 | 13 | 1 | 2 | 45 | 42 | 87 | ||||||||||||||||||||||||||||||||||||||
493465 | 493465 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_7 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
493466 | 493466 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_7 | 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 | ||||||||||||||||||||||||||||||||||
493467 | 493467 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493468 | 493468 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 72.0 | 0.0 | 9.0 | 1.0 | 0.0 | 52.0 | 30.0 | 82.0 | 72 | 0 | 9 | 1 | 0 | 52 | 30 | 82 | ||||||||||||||||||||||||||||||||||||||
493469 | 493469 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493470 | 493470 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_8 | 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 | ||||||||||||||||||||||||||||||||||
493471 | 493471 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493472 | 493472 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_8 | 68.0 | 0.0 | 11.0 | 0.0 | 4.0 | 37.0 | 46.0 | 83.0 | 68 | 0 | 11 | 0 | 4 | 37 | 46 | 83 | ||||||||||||||||||||||||||||||||||||||
493473 | 493473 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493474 | 493474 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | grade_9 | 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 | ||||||||||||||||||||||||||||||||||
493475 | 493475 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 72.0 | 0.0 | 12.0 | 2.0 | 0.0 | 43.0 | 43.0 | 86.0 | 72 | 0 | 12 | 2 | 0 | 43 | 43 | 86 | ||||||||||||||||||||||||||||||||||||||
493476 | 493476 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493477 | 493477 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | k_12_total | 6.0 | 1.0 | 5.0 | 100.0 | 6.0 | 6 | 1 | 5 | 6 | |||||||||||||||||||||||||||||||||||||||||||||
493478 | 493478 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | k_12_total | 337.0 | 4.0 | 54.0 | 3.0 | 1.0 | 0.0 | 18.0 | 221.0 | 196.0 | 8.9 | 417.0 | 337 | 4 | 54 | 3 | 1 | 0 | 18 | 221 | 196 | 417 | |||||||||||||||||||||||||||||||||
493479 | 493479 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | k_12_total | 286.0 | 1.0 | 30.0 | 3.0 | 2.0 | 170.0 | 152.0 | 2.8 | 322.0 | 286 | 1 | 30 | 3 | 2 | 170 | 152 | 322 | |||||||||||||||||||||||||||||||||||||
493480 | 493480 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | k_12_total | 209.0 | 2.0 | 33.0 | 2.0 | 6.0 | 134.0 | 118.0 | 6.0 | 252.0 | 209 | 2 | 33 | 2 | 6 | 134 | 118 | 252 | |||||||||||||||||||||||||||||||||||||
493481 | 493481 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | kindergarten | 1.0 | 1.0 | 0.0 | 1.0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
493482 | 493482 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | kindergarten | 74.0 | 0.0 | 14.0 | 0.0 | 0.0 | 0.0 | 2.0 | 55.0 | 35.0 | 90.0 | 74 | 0 | 14 | 0 | 0 | 0 | 2 | 55 | 35 | 90 | ||||||||||||||||||||||||||||||||||
493483 | 493483 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493484 | 493484 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493485 | 493485 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | pk_12_total | 6.0 | 1.0 | 5.0 | 6.0 | 6 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
493486 | 493486 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pk_12_total | 348.0 | 5.0 | 57.0 | 5.0 | 1.0 | 1.0 | 19.0 | 230.0 | 206.0 | 436.0 | 348 | 5 | 57 | 5 | 1 | 1 | 19 | 230 | 206 | 436 | ||||||||||||||||||||||||||||||||||
493487 | 493487 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pk_12_total | 286.0 | 1.0 | 30.0 | 3.0 | 2.0 | 170.0 | 152.0 | 322.0 | 286 | 1 | 30 | 3 | 2 | 170 | 152 | 322 | ||||||||||||||||||||||||||||||||||||||
493488 | 493488 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | pk_12_total | 209.0 | 2.0 | 33.0 | 2.0 | 6.0 | 134.0 | 118.0 | 252.0 | 209 | 2 | 33 | 2 | 6 | 134 | 118 | 252 | ||||||||||||||||||||||||||||||||||||||
493489 | 493489 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2020 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
493490 | 493490 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Koch Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2020 | pre_kindergarten | 11.0 | 1.0 | 3.0 | 2.0 | 0.0 | 1.0 | 1.0 | 9.0 | 10.0 | 19.0 | 11 | 1 | 3 | 2 | 0 | 1 | 1 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
493491 | 493491 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2020 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
493492 | 493492 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497829 | 497829 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_1 | 11.0 | 1.0 | 0.0 | 4.0 | 0.0 | 9.0 | 7.0 | 16.0 | 11 | 1 | 0 | 4 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||||||
497830 | 497830 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497831 | 497831 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497832 | 497832 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||
497833 | 497833 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_10 | 12.0 | 1.0 | 2.0 | 1.0 | 9.0 | 7.0 | 16.0 | 12 | 1 | 2 | 1 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||||||||
497834 | 497834 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||
497835 | 497835 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497836 | 497836 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_11 | 15.0 | 0.0 | 1.0 | 1.0 | 7.0 | 10.0 | 17.0 | 15 | 0 | 1 | 1 | 7 | 10 | 17 | ||||||||||||||||||||||||||||||||||||||||
497837 | 497837 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497838 | 497838 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497839 | 497839 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_12 | 7.0 | 1.0 | 4.0 | 0.0 | 4.0 | 8.0 | 12.0 | 7 | 1 | 4 | 0 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||||||||||
497840 | 497840 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497841 | 497841 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_2 | 23.0 | 0.0 | 2.0 | 6.0 | 0.0 | 16.0 | 15.0 | 31.0 | 23 | 0 | 2 | 6 | 0 | 16 | 15 | 31 | ||||||||||||||||||||||||||||||||||||||
497842 | 497842 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497843 | 497843 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497844 | 497844 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_3 | 7.0 | 1.0 | 0.0 | 6.0 | 0.0 | 8.0 | 6.0 | 14.0 | 7 | 1 | 0 | 6 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||||||
497845 | 497845 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497846 | 497846 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497847 | 497847 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_4 | 5.0 | 0.0 | 0.0 | 5.0 | 1.0 | 1.0 | 10.0 | 11.0 | 5 | 0 | 0 | 5 | 1 | 1 | 10 | 11 | ||||||||||||||||||||||||||||||||||||||
497848 | 497848 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497849 | 497849 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497850 | 497850 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_5 | 12.0 | 0.0 | 0.0 | 7.0 | 0.0 | 10.0 | 9.0 | 19.0 | 12 | 0 | 0 | 7 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||||||
497851 | 497851 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497852 | 497852 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497853 | 497853 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_6 | 14.0 | 0.0 | 0.0 | 2.0 | 0.0 | 9.0 | 7.0 | 16.0 | 14 | 0 | 0 | 2 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||||||
497854 | 497854 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497855 | 497855 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497856 | 497856 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497857 | 497857 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497858 | 497858 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_7 | 14.0 | 1.0 | 0.0 | 3.0 | 1.0 | 12.0 | 7.0 | 19.0 | 14 | 1 | 0 | 3 | 1 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||||||||
497859 | 497859 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497860 | 497860 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497861 | 497861 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_8 | 9.0 | 0.0 | 2.0 | 7.0 | 0.0 | 11.0 | 7.0 | 18.0 | 9 | 0 | 2 | 7 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||||||
497862 | 497862 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 06 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
497863 | 497863 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_9 | 11.0 | 0.0 | 9.0 | 0.0 | 7.0 | 13.0 | 20.0 | 11 | 0 | 9 | 0 | 7 | 13 | 20 | ||||||||||||||||||||||||||||||||||||||||
497864 | 497864 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Jr. High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 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]);