Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_10" and state = "SD" sorted by asian 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
257099 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   grade_10 374.0 2.0 23.0 20.0   9.0       1.0 9.0   215.0 223.0                       438.0 374 2 23 20   9       1 9   215 223                 438
357059 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   grade_10 294.0 4.0 14.0 24.0   9.0       0.0 5.0   172.0 178.0                       350.0 294 4 14 24   9       0 5   172 178                 350
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
3007468 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   grade_10 187.0 5.0 12.0 2.0   9.0       0.0 7.0   112.0 110.0                       222.0 187 5 12 2   9       0 7   112 110                 222
3344184 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_10 294.0 8.0 6.0 20.0   9.0       1.0 4.0   177.0 165.0                       342.0 294 8 6 20   9       1 4   177 165                 342
3345412 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_10 208.0 5.0 7.0 3.0   9.0       0.0 1.0   105.0 128.0                       233.0 208 5 7 3   9       0 1   105 128                 233
3351385 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   grade_10 312.0 7.0 33.0 102.0   9.0         18.0   261.0 220.0                       481.0 312 7 33 102   9         18   261 220                 481
488333 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 291.0 7.0 8.0 1.0   8.0         12.0   185.0 142.0                       327.0 291 7 8 1   8         12   185 142                 327
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
494659 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 362.0 2.0 24.0 15.0   8.0         32.0   239.0 204.0                       443.0 362 2 24 15   8         32   239 204                 443
450164 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 208.0 7.0 17.0 4.0   7.0       1.0 17.0   118.0 143.0                       261.0 208 7 17 4   7       1 17   118 143                 261
487344 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 9.0 27.0 22.0   7.0       1.0 10.0   168.0 171.0                       339.0 263 9 27 22   7       1 10   168 171                 339
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
2961618 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2015   grade_10 242.0 5.0 6.0 27.0   7.0         4.0   160.0 131.0                       291.0 242 5 6 27   7         4   160 131                 291
3006241 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_10 270.0 8.0 8.0 25.0   7.0       4.0 1.0   162.0 161.0                       323.0 270 8 8 25   7       4 1   162 161                 323
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
358064 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   grade_10 273.0 11.0 14.0 1.0   6.0       0.0 9.0   167.0 147.0                       314.0 273 11 14 1   6       0 9   167 147                 314
449910 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 336.0 18.0 12.0 1.0   6.0         9.0   198.0 184.0                       382.0 336 18 12 1   6         9   198 184                 382
452906 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2021   grade_10 276.0 9.0 10.0 0.0   6.0         12.0   160.0 153.0                       313.0 276 9 10 0   6         12   160 153                 313
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
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
3345142 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_10 246.0 6.0 5.0 0.0   6.0       3.0 2.0   133.0 135.0                       268.0 246 6 5 0   6       3 2   133 135                 268
3351404 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2016   grade_10 354.0 2.0 12.0 15.0   6.0       0.0 14.0   225.0 178.0                       403.0 354 2 12 15   6       0 14   225 178                 403
3348757 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No 3 09 12 2016   grade_10 97.0 3.0 52.0 3.0   54.0             119.0 90.0                       209.0 97 3 52 3   54             119 90                 209
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
2969598 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2015   grade_10 339.0 85.0 42.0 23.0   49.0         10.0   279.0 269.0                       548.0 339 85 42 23   49         10   279 269                 548
361633 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2019   grade_10 89.0 4.0 42.0 3.0   46.0       1.0 1.0   101.0 85.0                       186.0 89 4 42 3   46       1 1   101 85                 186
3010863 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2017   grade_10 123.0 4.0 51.0 4.0   46.0             132.0 96.0                       228.0 123 4 51 4   46             132 96                 228
254406 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   grade_10 102.0 6.0 43.0 2.0   43.0       0.0 0.0   108.0 88.0                       196.0 102 6 43 2   43       0 0   108 88                 196
2966173 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No 3 09 12 2015   grade_10 121.0 2.0 27.0 4.0   43.0         2.0   113.0 86.0                       199.0 121 2 27 4   43         2   113 86                 199
365162 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2019   grade_10 275.0 109.0 67.0 20.0   42.0       0.0 17.0   272.0 258.0                       530.0 275 109 67 20   42       0 17   272 258                 530
252290 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   grade_10 144.0 3.0 19.0 15.0   4.0       0.0 12.0   98.0 99.0                       197.0 144 3 19 15   4       0 12   98 99                 197
256039 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   grade_10 145.0 1.0 9.0 13.0   4.0         10.0   95.0 87.0                       182.0 145 1 9 13   4         10   95 87                 182
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
364374 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2019   grade_10 338.0 2.0 22.0 17.0   4.0         19.0   197.0 205.0                       402.0 338 2 22 17   4         19   197 205                 402
450995 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2021   grade_10 76.0 0.0 7.0 1.0   4.0       1.0 2.0   47.0 44.0                       91.0 76 0 7 1   4       1 2   47 44                 91
489818 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   grade_10 147.0 4.0 15.0 14.0   4.0       3.0 16.0   111.0 92.0                       203.0 147 4 15 14   4       3 16   111 92                 203
491329 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   grade_10 268.0 7.0 8.0 1.0   4.0       1.0 11.0   138.0 162.0                       300.0 268 7 8 1   4       1 11   138 162                 300
493567 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   grade_10 195.0 1.0 10.0 12.0   4.0       2.0 2.0   111.0 115.0                       226.0 195 1 10 12   4       2 2   111 115                 226
2971132 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No 3 09 12 2015   grade_10 70.0 5.0 4.0 10.0   4.0       0.0 4.0   55.0 42.0                       97.0 70 5 4 10   4       0 4   55 42                 97
3013263 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2017   grade_10 115.0 1.0 11.0 11.0   4.0       0.0 9.0   74.0 77.0                       151.0 115 1 11 11   4       0 9   74 77                 151
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
3015121 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2017   grade_10 148.0 0.0 7.0 3.0   4.0         1.0   82.0 81.0                       163.0 148 0 7 3   4         1   82 81                 163
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
3353948 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2016   grade_10 282.0 0.0 11.0 11.0   4.0         3.0   162.0 149.0                       311.0 282 0 11 11   4         3   162 149                 311
257889 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   grade_10 296.0 91.0 63.0 24.0   38.0       0.0 14.0   289.0 237.0                       526.0 296 91 63 24   38       0 14   289 237                 526
3014328 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   grade_10 285.0 91.0 50.0 23.0   37.0       0.0 24.0   272.0 238.0                       510.0 285 91 50 23   37       0 24   272 238                 510
3352194 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   grade_10 361.0 83.0 52.0 22.0   37.0         12.0   295.0 272.0                       567.0 361 83 52 22   37         12   295 272                 567
453479 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   grade_10 91.0 2.0 50.0 2.0   33.0       3.0 4.0   104.0 81.0                       185.0 91 2 50 2   33       3 4   104 81                 185
495447 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 109.0 86.0 15.0   30.0       1.0 17.0   260.0 261.0                       521.0 263 109 86 15   30       1 17   260 261                 521
250805 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_10 254.0 9.0 7.0 1.0   3.0       0.0 8.0   147.0 135.0                       282.0 254 9 7 1   3       0 8   147 135                 282
358507 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2019   grade_10 47.0 0.0 1.0 0.0   3.0         0.0   30.0 21.0                       51.0 47 0 1 0   3         0   30 21                 51
359149 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2019   grade_10 72.0 7.0 8.0 2.0   3.0         2.0   54.0 40.0                       94.0 72 7 8 2   3         2   54 40                 94
365925 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2019   grade_10 135.0 1.0 7.0 1.0   3.0       0.0 1.0   65.0 83.0                       148.0 135 1 7 1   3       0 1   65 83                 148
451394 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   grade_10 148.0 7.0 21.0 15.0   3.0       1.0 16.0   118.0 93.0                       211.0 148 7 21 15   3       1 16   118 93                 211
455975 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2021   grade_10 158.0 0.0 9.0 26.0   3.0         17.0   93.0 120.0                       213.0 158 0 9 26   3         17   93 120                 213
498015 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   grade_10 200.0 5.0 8.0 12.0   3.0         5.0   126.0 107.0                       233.0 200 5 8 12   3         5   126 107                 233
2962573 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2015   grade_10 253.0 6.0 6.0 0.0   3.0       0.0 2.0   138.0 132.0                       270.0 253 6 6 0   3       0 2   138 132                 270
2968708 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2015   grade_10 345.0 3.0 24.0 25.0   3.0         13.0   219.0 194.0                       413.0 345 3 24 25   3         13   219 194                 413
2971444 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2015   grade_10 300.0 3.0 13.0 13.0   3.0         2.0   181.0 153.0                       334.0 300 3 13 13   3         2   181 153                 334
3007214 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_10 235.0 8.0 7.0 0.0   3.0       0.0 3.0   129.0 127.0                       256.0 235 8 7 0   3       0 3   129 127                 256
3010290 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2017   grade_10 202.0 4.0 5.0 2.0   3.0         4.0   113.0 107.0                       220.0 202 4 5 2   3         4   113 107                 220
3013540 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   grade_10 338.0 5.0 20.0 23.0   3.0         10.0   187.0 212.0                       399.0 338 5 20 23   3         10   187 212                 399
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
3016848 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   grade_10 201.0 5.0 10.0 12.0   3.0         1.0   124.0 108.0                       232.0 201 5 10 12   3         1   124 108                 232
3351397 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City Hi Sch   Regular School No 3 09 12 2016   grade_10 50.0 0.0 10.0 39.0   3.0         3.0   66.0 39.0                       105.0 50 0 10 39   3         3   66 39                 105
457024 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_10 258.0 101.0 96.0 30.0   26.0       0.0 22.0   280.0 253.0                       533.0 258 101 96 30   26       0 22   280 253                 533
491902 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   grade_10 91.0 1.0 52.0 1.0   26.0       1.0 1.0   83.0 90.0                       173.0 91 1 52 1   26       1 1   83 90                 173
257880 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   grade_10 480.0 36.0 75.0 28.0   22.0       0.0 15.0   354.0 302.0                       656.0 480 36 75 28   22       0 15   354 302                 656
3014318 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   grade_10 417.0 64.0 40.0 20.0   21.0       0.0 14.0   293.0 283.0                       576.0 417 64 40 20   21       0 14   293 283                 576
250387 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2018   grade_10 70.0   6.0 0.0   2.0         6.0   45.0 39.0                       84.0 70   6 0   2         6   45 39                 84
251890 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   grade_10 87.0 0.0 9.0 2.0   2.0       0.0 3.0   56.0 47.0                       103.0 87 0 9 2   2       0 3   56 47                 103
255059 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No High 09 12 2018   grade_10 48.0 1.0 1.0 1.0   2.0         1.0   29.0 25.0                       54.0 48 1 1 1   2         1   29 25                 54
255409 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No High 09 12 2018   grade_10 101.0 2.0 3.0 1.0   2.0         1.0   61.0 49.0                       110.0 101 2 3 1   2         1   61 49                 110
256822 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   grade_10 160.0 0.0 8.0 31.0   2.0       1.0 6.0   108.0 100.0                       208.0 160 0 8 31   2       1 6   108 100                 208
357756 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2019   grade_10 45.0 0.0 4.0 0.0   2.0         0.0   28.0 23.0                       51.0 45 0 4 0   2         0   28 23                 51
358973 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School No High 09 12 2019   grade_10 14.0     3.0   2.0         1.0   10.0 10.0                       20.0 14     3   2         1   10 10                 20
361060 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   grade_10 252.0 5.0 7.0 3.0   2.0         7.0   138.0 138.0                       276.0 252 5 7 3   2         7   138 138                 276
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
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
365756 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2019   grade_10 52.0   2.0     2.0         1.0   27.0 30.0                       57.0 52   2     2         1   27 30                 57
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
458765 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2021   grade_10 259.0 5.0 12.0 15.0   2.0       0.0 8.0   162.0 139.0                       301.0 259 5 12 15   2       0 8   162 139                 301
488776 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School Not applicable High 09 12 2020   grade_10 48.0 2.0 2.0 3.0   2.0         2.0   32.0 27.0                       59.0 48 2 2 3   2         2   32 27                 59
490554 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School Not applicable High 09 12 2020   grade_10 21.0   6.0 12.0   2.0       0.0 2.0   26.0 17.0                       43.0 21   6 12   2       0 2   26 17                 43
490937 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School Not applicable High 09 12 2020   grade_10 22.0     4.0   2.0       0.0     9.0 19.0                       28.0 22     4   2       0     9 19                 28
491609 SD     school 4633360 51002   Hill City 51-2 463336000280 1 Hill City High School   Regular School Not applicable High 09 12 2020   grade_10 37.0 0.0 7.0 1.0   2.0             18.0 29.0                       47.0 37 0 7 1   2             18 29                 47
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
497186 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2020   grade_10 285.0 1.0 9.0 19.0   2.0         6.0   157.0 165.0                       322.0 285 1 9 19   2         6   157 165                 322
2962282 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No 3 09 12 2015   grade_10 51.0 0.0 1.0     2.0         0.0   30.0 24.0                       54.0 51 0 1     2         0   30 24                 54
2963997 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2015   grade_10 114.0 6.0 13.0 11.0   2.0       0.0 23.0   86.0 83.0                       169.0 114 6 13 11   2       0 23   86 83                 169
2964779 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No 3 09 12 2015   grade_10 22.0   3.0 10.0   2.0             23.0 14.0                       37.0 22   3 10   2             23 14                 37
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
2966842 SD     school 4641520 52004   Lemmon 52-4 464152000382 1 Lemmon High School   Regular School No 3 09 12 2015   grade_10 21.0   0.0 0.0   2.0             11.0 12.0                       23.0 21   0 0   2             11 12                 23
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
2970451 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   grade_10 118.0 3.0 10.0 4.0   2.0         1.0   81.0 57.0                       138.0 118 3 10 4   2         1   81 57                 138
3011498 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_10 9.0 1.0 1.0 4.0   2.0       0.0 3.0   12.0 8.0                       20.0 9 1 1 4   2       0 3   12 8                 20
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
3015740 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2017   grade_10 85.0 1.0 5.0 14.0   2.0       0.0 1.0   58.0 50.0                       108.0 85 1 5 14   2       0 1   58 50                 108
3016051 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   grade_10 279.0 5.0 9.0 12.0   2.0         4.0   167.0 144.0                       311.0 279 5 9 12   2         4   167 144                 311

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