Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_10" and state = "SD" sorted by native_american descending

View and edit SQL

year

grade

  • grade_10 · 4,696
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
2968689 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_10 338.0 6.0 25.0 93.0   9.0         23.0   250.0 244.0                       494.0 338 6 25 93   9         23   250 244                 494
3013521 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   grade_10 318.0 13.0 14.0 91.0   4.0         20.0   233.0 227.0                       460.0 318 13 14 91   4         20   233 227                 460
255346 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2018   grade_10 17.0   0.0 9.0             0.0   13.0 13.0                       26.0 17   0 9             0   13 13                 26
258698 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   grade_10 153.0 1.0 7.0 9.0   1.0         5.0   96.0 80.0                       176.0 153 1 7 9   1         5   96 80                 176
260455 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_10 190.0 3.0 12.0 9.0   1.0         4.0   112.0 107.0                       219.0 190 3 12 9   1         4   112 107                 219
361468 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2019   grade_10 40.0 2.0 2.0 9.0   1.0         2.0   29.0 27.0                       56.0 40 2 2 9   1         2   29 27                 56
459624 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   grade_10 199.0 4.0 27.0 9.0   1.0         5.0   128.0 117.0                       245.0 199 4 27 9   1         5   128 117                 245
496875 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School Not applicable High 09 12 2020   grade_10 77.0 1.0 2.0 9.0   2.0         1.0   55.0 37.0                       92.0 77 1 2 9   2         1   55 37                 92
2966010 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No 3 09 12 2015   grade_10 61.0 0.0 0.0 9.0                 43.0 27.0                       70.0 61 0 0 9                 43 27                 70
2966508 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School No 3 09 12 2015   grade_10 20.0     9.0                 13.0 16.0                       29.0 20     9                 13 16                 29
2966778 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative Education School No 3 09 12 2015   grade_10 11.0 4.0 4.0 9.0   5.0         2.0   20.0 15.0                       35.0 11 4 4 9   5         2   20 15                 35
2967382 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No 3 09 12 2015   grade_10 166.0 0.0 5.0 9.0   0.0         2.0   96.0 86.0                       182.0 166 0 5 9   0         2   96 86                 182
2968154 SD     school 4652770 23003   Oelrichs 23-3 465277000482 1 Oelrichs High School   Regular School No 3 09 12 2015   grade_10 2.0     9.0                 5.0 6.0                       11.0 2     9                 5 6                 11
2968507 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2015   grade_10 4.0     9.0           1.0     10.0 4.0                       14.0 4     9           1     10 4                 14
3349092 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School No 3 09 12 2016   grade_10 10.0     9.0                 12.0 7.0                       19.0 10     9                 12 7                 19
3349651 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No 3 09 12 2016   grade_10 16.0 0.0   9.0             0.0   17.0 8.0                       25.0 16 0   9             0   17 8                 25
3353140 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No 3 09 12 2016   grade_10 31.0   0.0 9.0             0.0   22.0 18.0                       40.0 31   0 9             0   22 18                 40
3354610 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No 3 09 12 2016   grade_10 34.0     9.0           1.0     24.0 20.0                       44.0 34     9           1     24 20                 44
494640 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 318.0 5.0 41.0 84.0   7.0       0.0 54.0   243.0 266.0                       509.0 318 5 41 84   7       0 54   243 266                 509
456233 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 296.0 8.0 40.0 83.0   6.0         64.0   263.0 234.0                       497.0 296 8 40 83   6         64   263 234                 497
364355 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2019   grade_10 306.0 7.0 31.0 80.0   2.0       0.0 43.0   231.0 238.0                       469.0 306 7 31 80   2       0 43   231 238                 469
256898 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2018   grade_10 6.0 1.0 0.0 8.0             1.0   8.0 8.0                       16.0 6 1 0 8             1   8 8                 16
259347 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   grade_10 70.0 3.0 5.0 8.0   1.0       0.0 1.0   38.0 50.0                       88.0 70 3 5 8   1       0 1   38 50                 88
362573 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2019   grade_10 17.0     8.0             1.0   11.0 15.0                       26.0 17     8             1   11 15                 26
366574 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2019   grade_10 70.0 1.0 5.0 8.0   0.0         0.0   38.0 46.0                       84.0 70 1 5 8   0         0   38 46                 84
455144 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   grade_10 170.0 2.0 11.0 8.0   1.0       2.0 2.0   99.0 97.0                       196.0 170 2 11 8   1       2 2   99 97                 196
459490 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School Not applicable High 09 12 2021   grade_10 37.0 0.0 1.0 8.0   0.0             23.0 23.0                       46.0 37 0 1 8   0             23 23                 46
492842 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School Not applicable High 09 12 2020   grade_10 17.0     8.0             1.0   14.0 12.0                       26.0 17     8             1   14 12                 26
496210 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2020   grade_10 166.0 2.0 13.0 8.0   1.0       1.0 4.0   99.0 96.0                       195.0 166 2 13 8   1       1 4   99 96                 195
2970346 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_10       8.0                 2.0 6.0                       8.0       8                 2 6                 8
3011787 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2017   grade_10 13.0     8.0             0.0   12.0 9.0                       21.0 13     8             0   12 9                 21
3012464 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   grade_10 187.0 3.0 11.0 8.0   2.0         0.0   116.0 95.0                       211.0 187 3 11 8   2         0   116 95                 211
3351203 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2016   grade_10 6.0     8.0             1.0   9.0 6.0                       15.0 6     8             1   9 6                 15
3354066 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No 3 09 12 2016   grade_10 4.0     8.0                 4.0 8.0                       12.0 4     8                 4 8                 12
257080 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   grade_10 318.0 10.0 28.0 78.0   4.0         24.0   229.0 233.0                       462.0 318 10 28 78   4         24   229 233                 462
455637 SD     school 4665460 65001   Oglala Lakota 65-1 466546001408 10 Lakota Tech High School   Career and Technical School Not applicable High 09 12 2021   grade_10 0.0   2.0 76.0             1.0   39.0 40.0                       79.0 0   2 76             1   39 40                 79
253441 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2018   grade_10 24.0   1.0 7.0   0.0       1.0     20.0 13.0                       33.0 24   1 7   0       1     20 13                 33
260273 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   grade_10 7.0   1.0 7.0             0.0   7.0 8.0                       15.0 7   1 7             0   7 8                 15
362907 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2019   grade_10 168.0 2.0 11.0 7.0           0.0 4.0   90.0 102.0                       192.0 168 2 11 7           0 4   90 102                 192
366046 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No High 09 12 2019   grade_10 16.0   2.0 7.0   1.0         1.0   18.0 9.0                       27.0 16   2 7   1         1   18 9                 27
366766 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2019   grade_10 16.0     7.0                 12.0 11.0                       23.0 16     7                 12 11                 23
366885 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2019   grade_10 261.0 2.0 14.0 7.0   2.0         6.0   147.0 145.0                       292.0 261 2 14 7   2         6   147 145                 292
488587 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 199.0 1.0 15.0 7.0   8.0       0.0 5.0   129.0 106.0                       235.0 199 1 15 7   8       0 5   129 106                 235
491737 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 48.0 2.0 2.0 7.0   0.0         6.0   30.0 35.0                       65.0 48 2 2 7   0         6   30 35                 65
494458 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School Not applicable High 09 12 2020   grade_10 11.0 1.0   7.0             0.0   13.0 6.0                       19.0 11 1   7             0   13 6                 19
2967728 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No 3 09 12 2015   grade_10 161.0 1.0 4.0 7.0   2.0       0.0 1.0   98.0 78.0                       176.0 161 1 4 7   2       0 1   98 78                 176
2969585 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No 3 09 12 2015   grade_10 67.0 2.0 9.0 7.0   1.0         0.0   58.0 28.0                       86.0 67 2 9 7   1         0   58 28                 86
3011228 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School No High 09 12 2017   grade_10 9.0     7.0                 7.0 9.0                       16.0 9     7                 7 9                 16
3016714 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2017   grade_10 35.0 0.0 0.0 7.0           0.0 0.0   21.0 21.0                       42.0 35 0 0 7           0 0   21 21                 42
3348594 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No 3 09 12 2016   grade_10 55.0 1.0 2.0 7.0   1.0         0.0   34.0 32.0                       66.0 55 1 2 7   1         0   34 32                 66
255057 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2018   grade_10 11.0 8.0 3.0 6.0   1.0         4.0   25.0 8.0                       33.0 11 8 3 6   1         4   25 8                 33
258819 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No High 09 12 2018   grade_10 34.0   0.0 6.0             1.0   21.0 20.0                       41.0 34   0 6             1   21 20                 41
259777 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2018   grade_10 5.0   1.0 6.0                 7.0 5.0                       12.0 5   1 6                 7 5                 12
361999 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School No High 09 12 2019   grade_10 11.0   1.0 6.0                 8.0 10.0                       18.0 11   1 6                 8 10                 18
364797 SD     school 4663360 54004   Rosholt 54-4 466336000557 1 Rosholt High School   Regular School No High 09 12 2019   grade_10 9.0   0.0 6.0             0.0   10.0 5.0                       15.0 9   0 6             0   10 5                 15
450819 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School Not applicable High 09 12 2021   grade_10 13.0     6.0   0.0         0.0   9.0 10.0                       19.0 13     6   0         0   9 10                 19
452514 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School Not applicable High 09 12 2021   grade_10 18.0 0.0 0.0 6.0   1.0         0.0   12.0 13.0                       25.0 18 0 0 6   1         0   12 13                 25
453314 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 49.0 0.0 3.0 6.0   0.0         5.0   28.0 35.0                       63.0 49 0 3 6   0         5   28 35                 63
453845 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School Not applicable High 09 12 2021   grade_10 13.0   1.0 6.0   1.0             12.0 9.0                       21.0 13   1 6   1             12 9                 21
454753 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2021   grade_10 155.0 0.0 9.0 6.0   1.0       0.0 13.0   87.0 97.0                       184.0 155 0 9 6   1       0 13   87 97                 184
458644 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School Not applicable High 09 12 2021   grade_10 15.0     6.0                 13.0 8.0                       21.0 15     6                 13 8                 21
489354 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School Not applicable High 09 12 2020   grade_10 66.0 2.0 1.0 6.0   0.0       1.0 4.0   41.0 39.0                       80.0 66 2 1 6   0       1 4   41 39                 80
492553 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   grade_10 7.0 2.0 0.0 6.0   1.0       0.0 1.0   11.0 6.0                       17.0 7 2 0 6   1       0 1   11 6                 17
494270 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2020   grade_10 6.0   1.0 6.0                 4.0 9.0                       13.0 6   1 6                 4 9                 13
496568 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School Not applicable High 09 12 2020   grade_10       6.0                 1.0 5.0                       6.0       6                 1 5                 6
497305 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 5.0   0.0 6.0             0.0   7.0 4.0                       11.0 5   0 6             0   7 4                 11
2965617 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2015   grade_10 187.0 1.0 0.0 6.0   2.0         4.0   108.0 92.0                       200.0 187 1 0 6   2         4   108 92                 200
2967274 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No 3 09 12 2015   grade_10 8.0     6.0                 10.0 4.0                       14.0 8     6                 10 4                 14
2970572 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No 3 09 12 2015   grade_10 24.0   1.0 6.0             2.0   22.0 11.0                       33.0 24   1 6             2   22 11                 33
2972240 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   grade_10 201.0 6.0 9.0 6.0   0.0         2.0   115.0 109.0                       224.0 201 6 9 6   0         2   115 109                 224
3013166 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_10 3.0   0.0 6.0             0.0   2.0 7.0                       9.0 3   0 6             0   2 7                 9
3014312 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2017   grade_10 73.0 9.0 4.0 6.0   3.0         1.0   45.0 51.0                       96.0 73 9 4 6   3         1   45 51                 96
3015066 SD     school 4607670 26005   South Central 26-5 460767000880 1 South Central High School   Regular School No High 09 12 2017   grade_10 3.0 0.0 0.0 6.0                 6.0 3.0                       9.0 3 0 0 6                 6 3                 9
3349362 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative Education School No 3 09 12 2016   grade_10 8.0 6.0 0.0 6.0   4.0         0.0   19.0 5.0                       24.0 8 6 0 6   4         0   19 5                 24
3349874 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No 3 09 12 2016   grade_10 9.0     6.0             0.0   5.0 10.0                       15.0 9     6             0   5 10                 15
3012058 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_10     0.0 55.0             0.0   35.0 20.0                       55.0     0 55             0   35 20                 55
362844 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2019   grade_10 0.0   0.0 53.0             0.0   24.0 29.0                       53.0 0   0 53             0   24 29                 53
251059 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   grade_10 192.0 6.0 6.0 5.0   6.0       1.0 8.0   105.0 119.0                       224.0 192 6 6 5   6       1 8   105 119                 224
255569 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2018   grade_10 6.0 1.0 1.0 5.0   1.0         0.0   6.0 8.0                       14.0 6 1 1 5   1         0   6 8                 14
255678 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2018   grade_10 149.0 0.0 4.0 5.0             5.0   86.0 77.0                       163.0 149 0 4 5             5   86 77                 163
259040 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School No High 09 12 2018   grade_10       5.0                 4.0 1.0                       5.0       5                 4 1                 5
362796 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2019   grade_10 8.0   2.0 5.0   0.0         0.0   9.0 6.0                       15.0 8   2 5   0         0   9 6                 15
363282 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2019   grade_10 153.0 3.0 6.0 5.0   2.0       0.0 5.0   80.0 94.0                       174.0 153 3 6 5   2       0 5   80 94                 174
363985 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2019   grade_10 1.0 0.0 0.0 5.0                 3.0 3.0                       6.0 1 0 0 5                 3 3                 6
454642 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School Not applicable High 09 12 2021   grade_10 4.0   1.0 5.0             3.0   8.0 5.0                       13.0 4   1 5             3   8 5                 13
493065 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School Not applicable High 09 12 2020   grade_10 7.0   0.0 5.0   0.0         0.0   5.0 7.0                       12.0 7   0 5   0         0   5 7                 12
496209 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School Not applicable High 09 12 2020   grade_10 2.0     5.0             0.0   1.0 6.0                       7.0 2     5             0   1 6                 7
496331 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School Not applicable High 09 12 2020   grade_10 24.0   2.0 5.0             0.0   20.0 11.0                       31.0 24   2 5             0   20 11                 31
2962811 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2015   grade_10 182.0 3.0 10.0 5.0   6.0       0.0 4.0   103.0 107.0                       210.0 182 3 10 5   6       0 4   103 107                 210
2972058 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2015   grade_10 12.0 0.0 1.0 5.0             0.0   11.0 7.0                       18.0 12 0 1 5             0   11 7                 18
3010698 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2017   grade_10 57.0 4.0 2.0 5.0   0.0       0.0 5.0   36.0 37.0                       73.0 57 4 2 5   0       0 5   36 37                 73
3013339 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2017   grade_10 3.0 1.0 3.0 5.0             1.0   7.0 6.0                       13.0 3 1 3 5             1   7 6                 13
3015448 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement School   Alternative School No High 07 12 2017   grade_10       5.0                 2.0 3.0                       5.0       5                 2 3                 5
3016666 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2017   grade_10 14.0   1.0 5.0             0.0   11.0 9.0                       20.0 14   1 5             0   11 9                 20
3354562 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2016   grade_10 12.0   1.0 5.0             1.0   9.0 10.0                       19.0 12   1 5             1   9 10                 19
493113 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School Not applicable High 09 12 2020   grade_10 2.0   0.0 49.0             0.0   29.0 22.0                       51.0 2   0 49             0   29 22                 51
257092 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2018   grade_10 54.0 5.0 4.0 43.0   0.0         4.0   61.0 49.0                       110.0 54 5 4 43   0         4   61 49                 110
454690 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School Not applicable High 09 12 2021   grade_10 0.0   1.0 43.0             1.0   21.0 24.0                       45.0 0   1 43             1   21 24                 45
2968701 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative Education School No 3 07 12 2015   grade_10 60.0 1.0 5.0 43.0             7.0   71.0 45.0                       116.0 60 1 5 43             7   71 45                 116
364367 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2019   grade_10 55.0 4.0 6.0 42.0             12.0   73.0 46.0                       119.0 55 4 6 42             12   73 46                 119

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);