enrollments
Data source: Big Local News · About: Big Local
10,800 rows where state = "SD" and year = 2021 sorted by district_nces_id
This data as json, CSV (advanced)
grade ✖
- grade_1 675
- grade_10 675
- grade_11 675
- grade_12 675
- grade_2 675
- grade_3 675
- grade_4 675
- grade_5 675
- grade_6 675
- grade_7 675
- grade_8 675
- grade_9 675
- k_12_total 675
- kindergarten 675
- pk_12_total 675
- pre_kindergarten 675
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
455006 | 455006 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_1 | 1.0 | 1.0 | 0.0 | 1.0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
455007 | 455007 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_1 | 56.0 | 0.0 | 13.0 | 0.0 | 0.0 | 0.0 | 1.0 | 42.0 | 28.0 | 70.0 | 56 | 0 | 13 | 0 | 0 | 0 | 1 | 42 | 28 | 70 | ||||||||||||||||||||||||||||||||||
455008 | 455008 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455009 | 455009 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455010 | 455010 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455011 | 455011 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455012 | 455012 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_10 | 74.0 | 0.0 | 8.0 | 1.0 | 1.0 | 39.0 | 45.0 | 84.0 | 74 | 0 | 8 | 1 | 1 | 39 | 45 | 84 | ||||||||||||||||||||||||||||||||||||||
455013 | 455013 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455014 | 455014 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455015 | 455015 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455016 | 455016 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 71.0 | 0.0 | 3.0 | 1.0 | 0.0 | 43.0 | 32.0 | 75.0 | 71 | 0 | 3 | 1 | 0 | 43 | 32 | 75 | ||||||||||||||||||||||||||||||||||||||
455017 | 455017 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455018 | 455018 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455019 | 455019 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455020 | 455020 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 76.0 | 1.0 | 5.0 | 1.0 | 0.0 | 44.0 | 39.0 | 83.0 | 76 | 1 | 5 | 1 | 0 | 44 | 39 | 83 | ||||||||||||||||||||||||||||||||||||||
455021 | 455021 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455022 | 455022 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_2 | 2.0 | 0.0 | 2.0 | 2.0 | 2 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||
455023 | 455023 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_2 | 51.0 | 0.0 | 4.0 | 0.0 | 1.0 | 0.0 | 2.0 | 25.0 | 33.0 | 58.0 | 51 | 0 | 4 | 0 | 1 | 0 | 2 | 25 | 33 | 58 | ||||||||||||||||||||||||||||||||||
455024 | 455024 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455025 | 455025 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455026 | 455026 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455027 | 455027 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_3 | 53.0 | 1.0 | 15.0 | 0.0 | 0.0 | 0.0 | 3.0 | 32.0 | 40.0 | 72.0 | 53 | 1 | 15 | 0 | 0 | 0 | 3 | 32 | 40 | 72 | ||||||||||||||||||||||||||||||||||
455028 | 455028 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455029 | 455029 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455030 | 455030 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_4 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
455031 | 455031 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_4 | 57.0 | 0.0 | 4.0 | 0.0 | 0.0 | 0.0 | 5.0 | 33.0 | 33.0 | 66.0 | 57 | 0 | 4 | 0 | 0 | 0 | 5 | 33 | 33 | 66 | ||||||||||||||||||||||||||||||||||
455032 | 455032 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455033 | 455033 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455034 | 455034 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_5 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
455035 | 455035 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_5 | 45.0 | 1.0 | 7.0 | 0.0 | 0.0 | 0.0 | 3.0 | 33.0 | 23.0 | 56.0 | 45 | 1 | 7 | 0 | 0 | 0 | 3 | 33 | 23 | 56 | ||||||||||||||||||||||||||||||||||
455036 | 455036 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455037 | 455037 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455038 | 455038 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455039 | 455039 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455040 | 455040 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455041 | 455041 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_6 | 64.0 | 2.0 | 5.0 | 0.0 | 6.0 | 48.0 | 29.0 | 77.0 | 64 | 2 | 5 | 0 | 6 | 48 | 29 | 77 | ||||||||||||||||||||||||||||||||||||||
455042 | 455042 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455043 | 455043 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455044 | 455044 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455045 | 455045 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 77.0 | 2.0 | 11.0 | 0.0 | 3.0 | 50.0 | 43.0 | 93.0 | 77 | 2 | 11 | 0 | 3 | 50 | 43 | 93 | ||||||||||||||||||||||||||||||||||||||
455046 | 455046 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_8 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
455047 | 455047 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455048 | 455048 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455049 | 455049 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_8 | 73.0 | 0.0 | 9.0 | 1.0 | 2.0 | 54.0 | 31.0 | 85.0 | 73 | 0 | 9 | 1 | 2 | 54 | 31 | 85 | ||||||||||||||||||||||||||||||||||||||
455050 | 455050 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455051 | 455051 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
455052 | 455052 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_9 | 70.0 | 0.0 | 11.0 | 0.0 | 4.0 | 38.0 | 47.0 | 85.0 | 70 | 0 | 11 | 0 | 4 | 38 | 47 | 85 | ||||||||||||||||||||||||||||||||||||||
455053 | 455053 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455054 | 455054 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | k_12_total | 7.0 | 1.0 | 6.0 | 85.7 | 7.0 | 7 | 1 | 6 | 7 | |||||||||||||||||||||||||||||||||||||||||||||
455055 | 455055 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | k_12_total | 325.0 | 2.0 | 52.0 | 1.0 | 1.0 | 1.0 | 16.0 | 208.0 | 190.0 | 10.1 | 398.0 | 325 | 2 | 52 | 1 | 1 | 1 | 16 | 208 | 190 | 398 | |||||||||||||||||||||||||||||||||
455056 | 455056 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | k_12_total | 291.0 | 1.0 | 27.0 | 3.0 | 5.0 | 164.0 | 163.0 | 2.8 | 327.0 | 291 | 1 | 27 | 3 | 5 | 164 | 163 | 327 | |||||||||||||||||||||||||||||||||||||
455057 | 455057 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | k_12_total | 214.0 | 4.0 | 25.0 | 1.0 | 11.0 | 152.0 | 103.0 | 4.3 | 255.0 | 214 | 4 | 25 | 1 | 11 | 152 | 103 | 255 | |||||||||||||||||||||||||||||||||||||
455058 | 455058 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | kindergarten | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
455059 | 455059 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | kindergarten | 63.0 | 0.0 | 9.0 | 1.0 | 0.0 | 1.0 | 2.0 | 43.0 | 33.0 | 76.0 | 63 | 0 | 9 | 1 | 0 | 1 | 2 | 43 | 33 | 76 | ||||||||||||||||||||||||||||||||||
455060 | 455060 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455061 | 455061 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455062 | 455062 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | pk_12_total | 7.0 | 1.0 | 6.0 | 7.0 | 7 | 1 | 6 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||
455063 | 455063 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | pk_12_total | 341.0 | 2.0 | 54.0 | 1.0 | 1.0 | 1.0 | 16.0 | 218.0 | 198.0 | 416.0 | 341 | 2 | 54 | 1 | 1 | 1 | 16 | 218 | 198 | 416 | ||||||||||||||||||||||||||||||||||
455064 | 455064 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | pk_12_total | 291.0 | 1.0 | 27.0 | 3.0 | 5.0 | 164.0 | 163.0 | 327.0 | 291 | 1 | 27 | 3 | 5 | 164 | 163 | 327 | ||||||||||||||||||||||||||||||||||||||
455065 | 455065 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | pk_12_total | 214.0 | 4.0 | 25.0 | 1.0 | 11.0 | 152.0 | 103.0 | 255.0 | 214 | 4 | 25 | 1 | 11 | 152 | 103 | 255 | ||||||||||||||||||||||||||||||||||||||
455066 | 455066 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000201390 | 4 | Blue Sky Colony | Regular School | Not applicable | Elementary | KG | 08 | 2021 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
455067 | 455067 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200423 | 3 | Milbank Elementary School | Regular School | Not applicable | Elementary | PK | 05 | 2021 | pre_kindergarten | 16.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 10.0 | 8.0 | 18.0 | 16 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||
455068 | 455068 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200424 | 1 | Milbank High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
455069 | 455069 | SD | school | 4600002 | 25004 | Milbank 25-4 | 460000200425 | 2 | Milbank Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459438 | 459438 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_1 | 15.0 | 0.0 | 0.0 | 5.0 | 0.0 | 12.0 | 8.0 | 20.0 | 15 | 0 | 0 | 5 | 0 | 12 | 8 | 20 | ||||||||||||||||||||||||||||||||||||||
459439 | 459439 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459440 | 459440 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459441 | 459441 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459442 | 459442 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_10 | 10.0 | 0.0 | 4.0 | 0.0 | 5.0 | 9.0 | 14.0 | 10 | 0 | 4 | 0 | 5 | 9 | 14 | ||||||||||||||||||||||||||||||||||||||||
459443 | 459443 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459444 | 459444 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459445 | 459445 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_11 | 10.0 | 1.0 | 2.0 | 1.0 | 9.0 | 5.0 | 14.0 | 10 | 1 | 2 | 1 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||||||||||
459446 | 459446 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459447 | 459447 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459448 | 459448 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_12 | 13.0 | 0.0 | 0.0 | 1.0 | 7.0 | 7.0 | 14.0 | 13 | 0 | 0 | 1 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||||||||
459449 | 459449 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459450 | 459450 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_2 | 12.0 | 1.0 | 0.0 | 1.0 | 0.0 | 10.0 | 4.0 | 14.0 | 12 | 1 | 0 | 1 | 0 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||||||||
459451 | 459451 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459452 | 459452 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459453 | 459453 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_3 | 21.0 | 0.0 | 2.0 | 4.0 | 1.0 | 13.0 | 15.0 | 28.0 | 21 | 0 | 2 | 4 | 1 | 13 | 15 | 28 | ||||||||||||||||||||||||||||||||||||||
459454 | 459454 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459455 | 459455 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459456 | 459456 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_4 | 7.0 | 1.0 | 0.0 | 4.0 | 1.0 | 7.0 | 6.0 | 13.0 | 7 | 1 | 0 | 4 | 1 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||||||
459457 | 459457 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459458 | 459458 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459459 | 459459 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_5 | 7.0 | 0.0 | 0.0 | 4.0 | 0.0 | 2.0 | 9.0 | 11.0 | 7 | 0 | 0 | 4 | 0 | 2 | 9 | 11 | ||||||||||||||||||||||||||||||||||||||
459460 | 459460 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459461 | 459461 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459462 | 459462 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459463 | 459463 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459464 | 459464 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_6 | 12.0 | 1.0 | 0.0 | 5.0 | 0.0 | 10.0 | 8.0 | 18.0 | 12 | 1 | 0 | 5 | 0 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||||||
459465 | 459465 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459466 | 459466 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459467 | 459467 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 15.0 | 0.0 | 0.0 | 2.0 | 0.0 | 9.0 | 8.0 | 17.0 | 15 | 0 | 0 | 2 | 0 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||||||
459468 | 459468 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459469 | 459469 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459470 | 459470 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_8 | 12.0 | 1.0 | 1.0 | 2.0 | 1.0 | 13.0 | 4.0 | 17.0 | 12 | 1 | 1 | 2 | 1 | 13 | 4 | 17 | ||||||||||||||||||||||||||||||||||||||
459471 | 459471 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459472 | 459472 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_9 | 9.0 | 1.0 | 12.0 | 0.0 | 14.0 | 8.0 | 22.0 | 9 | 1 | 12 | 0 | 14 | 8 | 22 | ||||||||||||||||||||||||||||||||||||||||
459473 | 459473 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300872 | 3 | Wilmot Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | 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]);