enrollments
Data source: Big Local News · About: Big Local
672 rows where grade = "grade_9", state = "SD" and year = 2019 sorted by native_american
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
357306 | 357306 | SD | school | 4600028 | 61001 | Alcester-Hudson 61-1 | 460002800014 | 1 | Alcester-Hudson High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 19.0 | 0.0 | 2.0 | 11.0 | 10.0 | 21.0 | 19 | 0 | 2 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||||||||||
357307 | 357307 | SD | school | 4600028 | 61001 | Alcester-Hudson 61-1 | 460002800874 | 3 | Alcester-Hudson JH | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
357378 | 357378 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001080 | 5 | Lakeview Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
357379 | 357379 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001379 | 6 | Pease Creek Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
357444 | 357444 | SD | school | 4603720 | 38001 | Arlington 38-1 | 460372000021 | 2 | Arlington Elementary | Regular School | No | Elementary | KG | 06 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
357445 | 357445 | SD | school | 4603720 | 38001 | Arlington 38-1 | 460372000022 | 1 | Arlington High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 23.0 | 3.0 | 17.0 | 9.0 | 26.0 | 23 | 3 | 17 | 9 | 26 | ||||||||||||||||||||||||||||||||||||||||||||
357446 | 357446 | SD | school | 4603720 | 38001 | Arlington 38-1 | 460372000877 | 3 | Arlington Junior High School | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
357447 | 357447 | SD | school | 4603720 | 38001 | Arlington 38-1 | 460372001381 | 4 | Arlington PreSchool | Regular School | No | Prekindergarten | PK | PK | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
357557 | 357557 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427000029 | 1 | Avon High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 19.0 | 0.0 | 2.0 | 10.0 | 11.0 | 21.0 | 19 | 0 | 2 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||||||||||||
357559 | 357559 | SD | school | 4604270 | 4001 | Avon 04-1 | 460427001325 | 6 | Avon PK | Regular School | No | Prekindergarten | PK | PK | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
357611 | 357611 | SD | school | 4604680 | 49001 | Baltic 49-1 | 460468000986 | 3 | Baltic Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
357787 | 357787 | SD | school | 4606360 | 61002 | Beresford 61-2 | 460636000051 | 3 | Beresford Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
357823 | 357823 | SD | school | 4606960 | 25001 | Big Stone City 25-1 | 460696000352 | 3 | Big Stone MS | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
357971 | 357971 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740001393 | 20 | Dawson Colony School | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
357972 | 357972 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000060 | 18 | Hutterische Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
357975 | 357975 | SD | school | 4607400 | 4002 | Bon Homme 04-2 | 460740000064 | 4 | Tyndall Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358041 | 358041 | SD | school | 4607800 | 22001 | Bowdle 22-1 | 460780000068 | 2 | Bowdle Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358042 | 358042 | SD | school | 4607800 | 22001 | Bowdle 22-1 | 460780000069 | 1 | Bowdle High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 8.0 | 0.0 | 5.0 | 3.0 | 8.0 | 8 | 0 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||||||||||||
358043 | 358043 | SD | school | 4607800 | 22001 | Bowdle 22-1 | 460780000883 | 3 | Bowdle Jr High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358137 | 358137 | SD | school | 4607950 | 49002 | Brandon Valley 49-2 | 460795001302 | 6 | Fred Assam Elementary | Regular School | No | Elementary | KG | 04 | 2019 | 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 | ||||||||||||||||||||||||||||||||||||||
358139 | 358139 | SD | school | 4607950 | 49002 | Brandon Valley 49-2 | 460795000073 | 4 | Valley Springs Elem | Regular School | No | Elementary | KG | 04 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358201 | 358201 | SD | school | 4621420 | 30003 | Bridgewater-Emery 30-3 | 462142010071 | 2 | Bridgewater-Emery Elementary | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
358284 | 358284 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101142 | 3 | Britton-Hecla Middle School | Regular School | No | Middle | 06 | 08 | 2019 | 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 | ||||||||||||||||||||||||||||||||||||||
358285 | 358285 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101143 | 4 | Sunset Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358286 | 358286 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101364 | 6 | Sunset Colony High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 5.0 | 1.0 | 4.0 | 5.0 | 5 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||
358287 | 358287 | SD | school | 4600041 | 45004 | Britton-Hecla 45-4 | 460004101180 | 5 | Westwood Rural Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358491 | 358491 | SD | school | 4610320 | 43001 | Canistota 43-1 | 461032001016 | 3 | Canistota Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358597 | 358597 | SD | school | 4611280 | 28001 | Castlewood 28-1 | 461128000114 | 1 | Castlewood High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 22.0 | 0.0 | 15.0 | 7.0 | 22.0 | 22 | 0 | 15 | 7 | 22 | ||||||||||||||||||||||||||||||||||||||||||||
358598 | 358598 | SD | school | 4611280 | 28001 | Castlewood 28-1 | 461128000954 | 3 | Castlewood Jr High School | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358599 | 358599 | SD | school | 4611280 | 28001 | Castlewood 28-1 | 461128001126 | 4 | Claremont Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358649 | 358649 | SD | school | 4611760 | 60001 | Centerville 60-1 | 461176000115 | 2 | Centerville Elem | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
358789 | 358789 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001269 | 92 | Chester Area Cyber School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 42.0 | 34.0 | 8.0 | 42.0 | 42 | 34 | 8 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||
358790 | 358790 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000131 | 2 | Chester Area Elementary School | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
358791 | 358791 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000130 | 1 | Chester Area High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 24.0 | 1.0 | 0.0 | 15.0 | 10.0 | 25.0 | 24 | 1 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||||||||||
358792 | 358792 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230000832 | 3 | Chester Area Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358793 | 358793 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001377 | 7 | Gracevale Colony | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358795 | 358795 | SD | school | 4612300 | 39001 | Chester Area 39-1 | 461230001092 | 4 | Rustic Acres | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358890 | 358890 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000132 | 2 | Clark Elementary School | Regular School | No | Elementary | PK | 04 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
358891 | 358891 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000133 | 1 | Clark High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 24.0 | 0.0 | 2.0 | 16.0 | 10.0 | 26.0 | 24 | 0 | 2 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||||||||||
358892 | 358892 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294000890 | 3 | Clark Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
358893 | 358893 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001081 | 4 | Fordham Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358894 | 358894 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001082 | 5 | Hillcrest Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358895 | 358895 | SD | school | 4612940 | 12002 | Clark 12-2 | 461294001319 | 7 | Silver Creek Colony | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
358953 | 358953 | SD | school | 4614100 | 50005 | Colman-Egan 50-5 | 461410000093 | 3 | Colman Elem | Regular School | No | Elementary | PK | 06 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
359066 | 359066 | SD | school | 4680445 | 21003 | Corsica-Stickney 21-3 | 468044501357 | 1 | Corsica-Stickney High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 23.0 | 11.0 | 12.0 | 23.0 | 23 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||
359067 | 359067 | SD | school | 4680445 | 21003 | Corsica-Stickney 21-3 | 468044501352 | 3 | Corsica-Stickney Jr. High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359242 | 359242 | SD | school | 4617850 | 38002 | De Smet 38-2 | 461785000993 | 3 | De Smet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
359243 | 359243 | SD | school | 4617850 | 38002 | De Smet 38-2 | 461785000162 | 2 | Laura Ingalls Wilder Elem | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
359360 | 359360 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830000012 | 1 | Deubrook High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 27.0 | 1.0 | 1.0 | 18.0 | 11.0 | 29.0 | 27 | 1 | 1 | 18 | 11 | 29 | ||||||||||||||||||||||||||||||||||||||||||
359362 | 359362 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830001154 | 7 | Norfeld Colony School | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359363 | 359363 | SD | school | 4678300 | 5006 | Deubrook Area 05-6 | 467830001320 | 9 | Red Willow Colony School | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359509 | 359509 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001299 | 6 | Camrose Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359510 | 359510 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001101 | 5 | Clark Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359511 | 359511 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000170 | 3 | Doland Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
359512 | 359512 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000171 | 1 | Doland High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 5.0 | 0.0 | 2.0 | 3.0 | 5.0 | 5 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||||||
359513 | 359513 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917000895 | 2 | Doland Junior High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
359514 | 359514 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001100 | 4 | Hillside Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359515 | 359515 | SD | school | 4619170 | 56002 | Doland 56-2 | 461917001359 | 7 | Hillside Colony High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 4.0 | 1.0 | 3.0 | 4.0 | 4 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||
359601 | 359601 | SD | school | 4619410 | 51001 | Douglas 51-1 | 461941001125 | 8 | Douglas Preschool | Regular School | No | Prekindergarten | PK | PK | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
359796 | 359796 | SD | school | 4634440 | 22005 | Edmunds Central 22-5 | 463444001385 | 6 | Boulder Colony School | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359798 | 359798 | SD | school | 4634440 | 22005 | Edmunds Central 22-5 | 463444000031 | 1 | Edmunds Central Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 6.0 | 0.0 | 3.0 | 3.0 | 6.0 | 6 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||||||||||||
359838 | 359838 | SD | school | 4621300 | 16002 | Elk Mountain 16-2 | 462130000899 | 1 | Elk Mountain Elem | Regular School | No | Elementary | PK | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
359839 | 359839 | SD | school | 4621300 | 16002 | Elk Mountain 16-2 | 462130001371 | 4 | Elk Mountain High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 1.0 | 1.0 | 0.0 | 1.0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
359882 | 359882 | SD | school | 4621340 | 61007 | Elk Point-Jefferson 61-7 | 462134000186 | 1 | Elk Point Jefferson High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 44.0 | 1.0 | 3.0 | 0.0 | 0.0 | 21.0 | 27.0 | 48.0 | 44 | 1 | 3 | 0 | 0 | 21 | 27 | 48 | ||||||||||||||||||||||||||||||||||||||
359883 | 359883 | SD | school | 4621340 | 61007 | Elk Point-Jefferson 61-7 | 462134000900 | 3 | Elk Point Jefferson Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
359953 | 359953 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139000901 | 3 | Elkton Junior High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
359954 | 359954 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139001078 | 4 | Newdale Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
359955 | 359955 | SD | school | 4621390 | 5003 | Elkton 05-3 | 462139001168 | 5 | Rolland Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360009 | 360009 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241000191 | 2 | Estelline Elementary School | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
360010 | 360010 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241000192 | 1 | Estelline High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 13.0 | 2.0 | 0.0 | 6.0 | 9.0 | 15.0 | 13 | 2 | 0 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||||||||||||
360011 | 360011 | SD | school | 4622410 | 28002 | Estelline 28-2 | 462241001045 | 3 | Estelline Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
360058 | 360058 | SD | school | 4622500 | 17001 | Ethan 17-1 | 462250000194 | 1 | Ethan High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 15.0 | 1.0 | 1.0 | 9.0 | 8.0 | 17.0 | 15 | 1 | 1 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||||||||||
360105 | 360105 | SD | school | 4622560 | 44001 | Eureka 44-1 | 462256000195 | 2 | Eureka Elementary School | Regular School | No | Elementary | PK | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
360106 | 360106 | SD | school | 4622560 | 44001 | Eureka 44-1 | 462256000196 | 1 | Eureka High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 11.0 | 0.0 | 1.0 | 7.0 | 5.0 | 12.0 | 11 | 0 | 1 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||||||||||
360167 | 360167 | SD | school | 4622940 | 46002 | Faith 46-2 | 462294000412 | 4 | Maurine Elem. | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360250 | 360250 | SD | school | 4624030 | 24004 | Faulkton Area | 462403001158 | 6 | Blumengard Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360251 | 360251 | SD | school | 4624030 | 24004 | Faulkton Area | 462403001090 | 5 | Brentwood Colony School | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360253 | 360253 | SD | school | 4624030 | 24004 | Faulkton Area | 462403000203 | 1 | Faulkton Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 19.0 | 1.0 | 8.0 | 12.0 | 20.0 | 19 | 1 | 8 | 12 | 20 | ||||||||||||||||||||||||||||||||||||||||||||
360254 | 360254 | SD | school | 4624030 | 24004 | Faulkton Area | 462403000204 | 8 | Faulkton Jr Hi | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
360255 | 360255 | SD | school | 4624030 | 24004 | Faulkton Area | 462403001160 | 10 | Thunderbird Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360327 | 360327 | SD | school | 4624390 | 50003 | Flandreau 50-3 | 462439001119 | 6 | Pleasant Valley Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360425 | 360425 | SD | school | 4621400 | 6002 | Frederick Area 06-2 | 462140000189 | 2 | Frederick Elementary | Regular School | No | Elementary | KG | 06 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
360427 | 360427 | SD | school | 4621400 | 6002 | Frederick Area 06-2 | 462140000957 | 3 | Frederick Jr High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
360496 | 360496 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000220 | 1 | Freeman High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 15.0 | 0.0 | 1.0 | 1.0 | 8.0 | 9.0 | 17.0 | 15 | 0 | 1 | 1 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||||||||
360497 | 360497 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000842 | 5 | Freeman Jr High | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
360498 | 360498 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000221 | 3 | Tschetter Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360499 | 360499 | SD | school | 4625500 | 33001 | Freeman 33-1 | 462550000222 | 4 | Wolf Creek Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360555 | 360555 | SD | school | 4626370 | 49004 | Garretson 49-4 | 462637000843 | 3 | Garretson Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
360603 | 360603 | SD | school | 4626490 | 63001 | Gayville-Volin 63-1 | 462649000844 | 3 | Gayville-Volin JH | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
360747 | 360747 | SD | school | 4600045 | 6006 | Groton Area | 460004501157 | 4 | Groton Area MS | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360804 | 360804 | SD | school | 4630490 | 27001 | Haakon 27-1 | 463049000647 | 8 | Milesville Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360858 | 360858 | SD | school | 4630800 | 28003 | Hamlin 28-3 | 463080000260 | 1 | Hamlin Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 50.0 | 1.0 | 1.0 | 0.0 | 27.0 | 25.0 | 52.0 | 50 | 1 | 1 | 0 | 27 | 25 | 52 | ||||||||||||||||||||||||||||||||||||||||
360859 | 360859 | SD | school | 4630800 | 28003 | Hamlin 28-3 | 463080000259 | 2 | Hamlin Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
360938 | 360938 | SD | school | 4602640 | 30001 | Hanson 30-1 | 460264001272 | 7 | Hanson Alternative Colony High School | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360942 | 360942 | SD | school | 4602640 | 30001 | Hanson 30-1 | 460264000015 | 4 | Millbrook Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
360943 | 360943 | SD | school | 4602640 | 30001 | Hanson 30-1 | 460264000875 | 5 | Oaklane Colony | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
361023 | 361023 | SD | school | 4609300 | 31001 | Harding County 31-1 | 460930000087 | 2 | Buffalo Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
361024 | 361024 | SD | school | 4609300 | 31001 | Harding County 31-1 | 460930000701 | 8 | Camp Crook Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
361026 | 361026 | SD | school | 4609300 | 31001 | Harding County 31-1 | 460930000887 | 3 | Harding County MS | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
361027 | 361027 | SD | school | 4609300 | 31001 | Harding County 31-1 | 460930000667 | 6 | Ludlow Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_9 | 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]);