enrollments
Data source: Big Local News · About: Big Local
10,656 rows where state = "SD" and year = 2016 sorted by school descending
This data as json, CSV (advanced)
grade ✖
- grade_1 666
- grade_10 666
- grade_11 666
- grade_12 666
- grade_2 666
- grade_3 666
- grade_4 666
- grade_5 666
- grade_6 666
- grade_7 666
- grade_8 666
- grade_9 666
- k_12_total 666
- kindergarten 666
- pk_12_total 666
- pre_kindergarten 666
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3354739 | 3354739 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354745 | 3354745 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354751 | 3354751 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354757 | 3354757 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354763 | 3354763 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354769 | 3354769 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354775 | 3354775 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354781 | 3354781 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354787 | 3354787 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_6 | 169.0 | 5.0 | 9.0 | 12.0 | 3.0 | 2.0 | 105.0 | 95.0 | 200.0 | 169 | 5 | 9 | 12 | 3 | 2 | 105 | 95 | 200 | ||||||||||||||||||||||||||||||||||||
3354793 | 3354793 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 149.0 | 2.0 | 9.0 | 12.0 | 0.0 | 0.0 | 90.0 | 82.0 | 172.0 | 149 | 2 | 9 | 12 | 0 | 0 | 90 | 82 | 172 | ||||||||||||||||||||||||||||||||||||
3354799 | 3354799 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_8 | 174.0 | 4.0 | 14.0 | 8.0 | 1.0 | 8.0 | 114.0 | 95.0 | 209.0 | 174 | 4 | 14 | 8 | 1 | 8 | 114 | 95 | 209 | ||||||||||||||||||||||||||||||||||||
3354805 | 3354805 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354811 | 3354811 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 492.0 | 11.0 | 32.0 | 32.0 | 4.0 | 10.0 | 309.0 | 272.0 | 2.3 | 581.0 | 492 | 11 | 32 | 32 | 4 | 10 | 309 | 272 | 581 | |||||||||||||||||||||||||||||||||||
3354817 | 3354817 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354823 | 3354823 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | pk_12_total | 492.0 | 11.0 | 32.0 | 32.0 | 4.0 | 10.0 | 309.0 | 272.0 | 581.0 | 492 | 11 | 32 | 32 | 4 | 10 | 309 | 272 | 581 | ||||||||||||||||||||||||||||||||||||
3354829 | 3354829 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354738 | 3354738 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354744 | 3354744 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_10 | 171.0 | 3.0 | 15.0 | 4.0 | 2.0 | 1.0 | 100.0 | 96.0 | 196.0 | 171 | 3 | 15 | 4 | 2 | 1 | 100 | 96 | 196 | ||||||||||||||||||||||||||||||||||||
3354750 | 3354750 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 205.0 | 5.0 | 7.0 | 3.0 | 0.0 | 2.0 | 114.0 | 108.0 | 222.0 | 205 | 5 | 7 | 3 | 0 | 2 | 114 | 108 | 222 | ||||||||||||||||||||||||||||||||||||
3354756 | 3354756 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 202.0 | 4.0 | 16.0 | 3.0 | 4.0 | 4.0 | 134.0 | 99.0 | 233.0 | 202 | 4 | 16 | 3 | 4 | 4 | 134 | 99 | 233 | ||||||||||||||||||||||||||||||||||||
3354762 | 3354762 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354768 | 3354768 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354774 | 3354774 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354780 | 3354780 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354786 | 3354786 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354792 | 3354792 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354798 | 3354798 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3354804 | 3354804 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 205.0 | 6.0 | 10.0 | 13.0 | 3.0 | 1.0 | 127.0 | 111.0 | 238.0 | 205 | 6 | 10 | 13 | 3 | 1 | 127 | 111 | 238 | ||||||||||||||||||||||||||||||||||||
3354810 | 3354810 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 783.0 | 18.0 | 48.0 | 23.0 | 9.0 | 8.0 | 475.0 | 414.0 | 1.4 | 889.0 | 783 | 18 | 48 | 23 | 9 | 8 | 475 | 414 | 889 | |||||||||||||||||||||||||||||||||||
3354816 | 3354816 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354822 | 3354822 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | pk_12_total | 783.0 | 18.0 | 48.0 | 23.0 | 9.0 | 8.0 | 475.0 | 414.0 | 889.0 | 783 | 18 | 48 | 23 | 9 | 8 | 475 | 414 | 889 | ||||||||||||||||||||||||||||||||||||
3354828 | 3354828 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3349474 | 3349474 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_1 | 17.0 | 0.0 | 0.0 | 0.0 | 10.0 | 7.0 | 17.0 | 17 | 0 | 0 | 0 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||||||||||
3349479 | 3349479 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349484 | 3349484 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349489 | 3349489 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349494 | 3349494 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_2 | 20.0 | 0.0 | 0.0 | 1.0 | 11.0 | 10.0 | 21.0 | 20 | 0 | 0 | 1 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||||||||
3349499 | 3349499 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_3 | 15.0 | 0.0 | 1.0 | 0.0 | 8.0 | 8.0 | 16.0 | 15 | 0 | 1 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||||
3349504 | 3349504 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_4 | 19.0 | 1.0 | 0.0 | 0.0 | 11.0 | 9.0 | 20.0 | 19 | 1 | 0 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
3349509 | 3349509 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349514 | 3349514 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349519 | 3349519 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349524 | 3349524 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349529 | 3349529 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3349534 | 3349534 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | k_12_total | 87.0 | 3.0 | 1.0 | 1.0 | 47.0 | 45.0 | 0.0 | 92.0 | 87 | 3 | 1 | 1 | 47 | 45 | 92 | |||||||||||||||||||||||||||||||||||||||
3349539 | 3349539 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | kindergarten | 16.0 | 2.0 | 0.0 | 0.0 | 7.0 | 11.0 | 18.0 | 16 | 2 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||||||||||
3349544 | 3349544 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | pk_12_total | 106.0 | 3.0 | 1.0 | 1.0 | 58.0 | 53.0 | 111.0 | 106 | 3 | 1 | 1 | 58 | 53 | 111 | ||||||||||||||||||||||||||||||||||||||||
3349549 | 3349549 | SD | school | 4641550 | 41004 | Lennox 41-4 | 464155000389 | 5 | Worthing Elem | Regular School | No | 1 | PK | 04 | 2016 | pre_kindergarten | 19.0 | 0.0 | 0.0 | 0.0 | 11.0 | 8.0 | 19.0 | 19 | 0 | 0 | 0 | 11 | 8 | 19 | ||||||||||||||||||||||||||||||||||||||||
3354703 | 3354703 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354705 | 3354705 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_10 | 14.0 | 0.0 | 0.0 | 7.0 | 7.0 | 14.0 | 14 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||||||||||
3354707 | 3354707 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 14.0 | 0.0 | 1.0 | 11.0 | 4.0 | 15.0 | 14 | 0 | 1 | 11 | 4 | 15 | ||||||||||||||||||||||||||||||||||||||||||
3354709 | 3354709 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 11.0 | 1.0 | 0.0 | 9.0 | 3.0 | 12.0 | 11 | 1 | 0 | 9 | 3 | 12 | ||||||||||||||||||||||||||||||||||||||||||
3354711 | 3354711 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354713 | 3354713 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354715 | 3354715 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354717 | 3354717 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354719 | 3354719 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354721 | 3354721 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354723 | 3354723 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354725 | 3354725 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 13.0 | 0.0 | 0.0 | 7.0 | 6.0 | 13.0 | 13 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||||||||||
3354727 | 3354727 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 52.0 | 1.0 | 1.0 | 34.0 | 20.0 | 0.0 | 54.0 | 52 | 1 | 1 | 34 | 20 | 54 | |||||||||||||||||||||||||||||||||||||||||
3354729 | 3354729 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354731 | 3354731 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | pk_12_total | 52.0 | 1.0 | 1.0 | 34.0 | 20.0 | 54.0 | 52 | 1 | 1 | 34 | 20 | 54 | ||||||||||||||||||||||||||||||||||||||||||
3354733 | 3354733 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2016 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
3354702 | 3354702 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_1 | 9.0 | 1.0 | 0.0 | 1.0 | 7.0 | 4.0 | 11.0 | 9 | 1 | 0 | 1 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||||||||
3354704 | 3354704 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3354706 | 3354706 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3354708 | 3354708 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3354710 | 3354710 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_2 | 23.0 | 0.0 | 1.0 | 1.0 | 12.0 | 13.0 | 25.0 | 23 | 0 | 1 | 1 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||||||||
3354712 | 3354712 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_3 | 19.0 | 1.0 | 0.0 | 0.0 | 11.0 | 9.0 | 20.0 | 19 | 1 | 0 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||||||||
3354714 | 3354714 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_4 | 11.0 | 0.0 | 1.0 | 2.0 | 9.0 | 5.0 | 14.0 | 11 | 0 | 1 | 2 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||||||||||
3354716 | 3354716 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_5 | 13.0 | 1.0 | 0.0 | 1.0 | 7.0 | 8.0 | 15.0 | 13 | 1 | 0 | 1 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||||||||
3354718 | 3354718 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_6 | 15.0 | 0.0 | 0.0 | 0.0 | 7.0 | 8.0 | 15.0 | 15 | 0 | 0 | 0 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||||||||
3354720 | 3354720 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 15.0 | 1.0 | 0.0 | 0.0 | 8.0 | 8.0 | 16.0 | 15 | 1 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||||
3354722 | 3354722 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 20.0 | 1.0 | 0.0 | 0.0 | 8.0 | 13.0 | 21.0 | 20 | 1 | 0 | 0 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||||||||
3354724 | 3354724 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3354726 | 3354726 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | k_12_total | 137.0 | 5.0 | 2.0 | 6.0 | 75.0 | 75.0 | 1.3 | 150.0 | 137 | 5 | 2 | 6 | 75 | 75 | 150 | |||||||||||||||||||||||||||||||||||||||
3354728 | 3354728 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | kindergarten | 12.0 | 0.0 | 0.0 | 1.0 | 6.0 | 7.0 | 13.0 | 12 | 0 | 0 | 1 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||||||||
3354730 | 3354730 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | pk_12_total | 152.0 | 5.0 | 3.0 | 6.0 | 84.0 | 82.0 | 166.0 | 152 | 5 | 3 | 6 | 84 | 82 | 166 | ||||||||||||||||||||||||||||||||||||||||
3354732 | 3354732 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | pre_kindergarten | 15.0 | 0.0 | 1.0 | 0.0 | 9.0 | 7.0 | 16.0 | 15 | 0 | 1 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||||||||
3351382 | 3351382 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | grade_1 | 44.0 | 0.0 | 1.0 | 13.0 | 1.0 | 1.0 | 27.0 | 33.0 | 60.0 | 44 | 0 | 1 | 13 | 1 | 1 | 27 | 33 | 60 | ||||||||||||||||||||||||||||||||||||
3351407 | 3351407 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351432 | 3351432 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351457 | 3351457 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351482 | 3351482 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | grade_2 | 32.0 | 1.0 | 5.0 | 10.0 | 1.0 | 8.0 | 31.0 | 26.0 | 57.0 | 32 | 1 | 5 | 10 | 1 | 8 | 31 | 26 | 57 | ||||||||||||||||||||||||||||||||||||
3351507 | 3351507 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | grade_3 | 42.0 | 0.0 | 9.0 | 17.0 | 0.0 | 7.0 | 30.0 | 45.0 | 75.0 | 42 | 0 | 9 | 17 | 0 | 7 | 30 | 45 | 75 | ||||||||||||||||||||||||||||||||||||
3351532 | 3351532 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | grade_4 | 44.0 | 2.0 | 4.0 | 8.0 | 0.0 | 2.0 | 31.0 | 29.0 | 60.0 | 44 | 2 | 4 | 8 | 0 | 2 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||||||
3351557 | 3351557 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 43.0 | 1.0 | 5.0 | 5.0 | 0.0 | 4.0 | 31.0 | 27.0 | 58.0 | 43 | 1 | 5 | 5 | 0 | 4 | 31 | 27 | 58 | ||||||||||||||||||||||||||||||||||||
3351582 | 3351582 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351607 | 3351607 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351632 | 3351632 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351657 | 3351657 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||
3351682 | 3351682 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | k_12_total | 241.0 | 4.0 | 25.0 | 70.0 | 4.0 | 26.0 | 178.0 | 192.0 | 0.9 | 370.0 | 241 | 4 | 25 | 70 | 4 | 26 | 178 | 192 | 370 | |||||||||||||||||||||||||||||||||||
3351707 | 3351707 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 36.0 | 0.0 | 1.0 | 17.0 | 2.0 | 4.0 | 28.0 | 32.0 | 60.0 | 36 | 0 | 1 | 17 | 2 | 4 | 28 | 32 | 60 | ||||||||||||||||||||||||||||||||||||
3351732 | 3351732 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | pk_12_total | 241.0 | 4.0 | 25.0 | 70.0 | 4.0 | 26.0 | 178.0 | 192.0 | 370.0 | 241 | 4 | 25 | 70 | 4 | 26 | 178 | 192 | 370 | ||||||||||||||||||||||||||||||||||||
3351757 | 3351757 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982000530 | 17 | Woodrow Wilson Elem | Regular School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3346033 | 3346033 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_1 | 0.0 | 1.0 | 0.0 | 1.0 | 1.0 | 0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
3346037 | 3346037 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3346041 | 3346041 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3346045 | 3346045 | SD | school | 4614130 | 59003 | Colome Consolidated | 461413000787 | 5 | Wood Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_12 | 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]);