Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_12" and state = "SD" sorted by multiracial descending

View and edit SQL

year

grade

  • grade_12 · 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
257966 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   grade_12 383.0 37.0 49.0 4.0   10.0       0.0 9.0   238.0 254.0                       492.0 383 37 49 4   10       0 9   238 254                 492
364107 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2019   grade_12 110.0 1.0 7.0 10.0   3.0         9.0   64.0 76.0                       140.0 110 1 7 10   3         9   64 76                 140
364424 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2019   grade_12 312.0 5.0 19.0 16.0   2.0         9.0   159.0 204.0                       363.0 312 5 19 16   2         9   159 204                 363
365237 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   grade_12 352.0 49.0 34.0 10.0   15.0       0.0 9.0   233.0 236.0                       469.0 352 49 34 10   15       0 9   233 236                 469
494392 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   grade_12 156.0 0.0 6.0 17.0   2.0         9.0   91.0 99.0                       190.0 156 0 6 17   2         9   91 99                 190
495531 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_12 255.0 73.0 48.0 11.0   33.0       0.0 9.0   228.0 201.0                       429.0 255 73 48 11   33       0 9   228 201                 429
497202 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2020   grade_12 246.0 0.0 6.0 7.0   0.0         9.0   132.0 136.0                       268.0 246 0 6 7   0         9   132 136                 268
3351435 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   grade_12 284.0 6.0 17.0 41.0   6.0         9.0   170.0 193.0                       363.0 284 6 17 41   6         9   170 193                 363
3352272 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No 3 09 12 2016   grade_12 371.0 36.0 48.0 13.0   23.0       0.0 9.0   243.0 257.0                       500.0 371 36 48 13   23       0 9   243 257                 500
3352280 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   grade_12 271.0 60.0 42.0 14.0   36.0         9.0   213.0 219.0                       432.0 271 60 42 14   36         9   213 219                 432
250470 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2018   grade_12 12.0   1.0 8.0             8.0   16.0 13.0                       29.0 12   1 8             8   16 13                 29
448941 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   grade_12 315.0 7.0 19.0 23.0   10.0       0.0 8.0   187.0 195.0                       382.0 315 7 19 23   10       0 8   187 195                 382
488347 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   grade_12 232.0 6.0 3.0 0.0   1.0         8.0   124.0 126.0                       250.0 232 6 3 0   1         8   124 126                 250
493581 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   grade_12 136.0 1.0 7.0 8.0   3.0       0.0 8.0   82.0 81.0                       163.0 136 1 7 8   3       0 8   82 81                 163
253851 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   grade_12 211.0 4.0 5.0 2.0   2.0         7.0   131.0 100.0                       231.0 211 4 5 2   2         7   131 100                 231
256053 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   grade_12 169.0 1.0 8.0 9.0   1.0         7.0   89.0 106.0                       195.0 169 1 8 9   1         7   89 106                 195
257956 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   grade_12 295.0 38.0 24.0 5.0   12.0       0.0 7.0   202.0 179.0                       381.0 295 38 24 5   12       0 7   202 179                 381
357713 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2019   grade_12 7.0   1.0 14.0   0.0         7.0   12.0 17.0                       29.0 7   1 14   0         7   12 17                 29
456295 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Regular School Not applicable High 09 12 2021   grade_12 32.0 2.0 5.0 13.0   0.0       1.0 7.0   28.0 32.0                       60.0 32 2 5 13   0       1 7   28 32                 60
494702 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School Not applicable High 09 12 2020   grade_12 39.0 2.0 3.0 15.0   0.0         7.0   36.0 30.0                       66.0 39 2 3 15   0         7   36 30                 66
2962239 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No 3 09 12 2015   grade_12 15.0   1.0 15.0   0.0         7.0   19.0 19.0                       38.0 15   1 15   0         7   19 19                 38
2968428 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2015   grade_12 158.0 0.0 1.0 13.0   3.0         7.0   81.0 101.0                       182.0 158 0 1 13   3         7   81 101                 182
3012478 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   grade_12 161.0 0.0 5.0 3.0   3.0         7.0   100.0 79.0                       179.0 161 0 5 3   3         7   100 79                 179
3350342 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No 3 09 12 2016   grade_12 182.0 0.0 7.0 4.0   2.0         7.0   92.0 110.0                       202.0 182 0 7 4   2         7   92 110                 202
361078 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   grade_12 209.0 10.0 6.0 3.0   3.0         6.0   124.0 113.0                       237.0 209 10 6 3   3         6   124 113                 237
449924 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2021   grade_12 256.0 14.0 12.0 1.0   4.0         6.0   152.0 141.0                       293.0 256 14 12 1   4         6   152 141                 293
488599 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   grade_12 182.0 4.0 6.0 3.0   7.0       0.0 6.0   98.0 110.0                       208.0 182 4 6 3   7       0 6   98 110                 208
2961638 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2015   grade_12 278.0 3.0 7.0 28.0   5.0         6.0   161.0 166.0                       327.0 278 3 7 28   5         6   161 166                 327
2968739 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_12 290.0 10.0 14.0 62.0   3.0         6.0   196.0 189.0                       385.0 290 10 14 62   3         6   196 189                 385
3006879 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2017   grade_12 10.0   1.0 20.0   1.0         6.0   20.0 18.0                       38.0 10   1 20   1         6   20 18                 38
3351137 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2016   grade_12 180.0 2.0 6.0 22.0   5.0         6.0   107.0 114.0                       221.0 180 2 6 22   5         6   107 114                 221
250397 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2018   grade_12 87.0   4.0 2.0   1.0         5.0   46.0 53.0                       99.0 87   4 2   1         5   46 53                 99
256832 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   grade_12 155.0 0.0 11.0 10.0   1.0       0.0 5.0   84.0 98.0                       182.0 155 0 11 10   1       0 5   84 98                 182
259674 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   grade_12 272.0 0.0 9.0 7.0   5.0       0.0 5.0   156.0 142.0                       298.0 272 0 9 7   5       0 5   156 142                 298
358078 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   grade_12 222.0 4.0 8.0 1.0   4.0       0.0 5.0   122.0 122.0                       244.0 222 4 8 1   4       0 5   122 122                 244
358330 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   grade_12 165.0 5.0 10.0 2.0   9.0       0.0 5.0   99.0 97.0                       196.0 165 5 10 2   9       0 5   99 97                 196
359157 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2019   grade_12 73.0 2.0 2.0 0.0   1.0         5.0   45.0 38.0                       83.0 73 2 2 0   1         5   45 38                 83
450176 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   grade_12 201.0 6.0 14.0 3.0   14.0       0.0 5.0   118.0 125.0                       243.0 201 6 14 3   14       0 5   118 125                 243
458588 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School Not applicable High 09 12 2021   grade_12 16.0   0.0 13.0   0.0         5.0   17.0 17.0                       34.0 16   0 13   0         5   17 17                 34
458783 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2021   grade_12 249.0 3.0 12.0 5.0   2.0       0.0 5.0   140.0 136.0                       276.0 249 3 12 5   2       0 5   140 136                 276
487364 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_12 246.0 11.0 17.0 24.0   11.0       0.0 5.0   158.0 156.0                       314.0 246 11 17 24   11       0 5   158 156                 314
487909 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School Not applicable High 09 12 2020   grade_12 58.0   7.0 0.0   2.0         5.0   35.0 37.0                       72.0 58   7 0   2         5   35 37                 72
496437 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School Not applicable High 09 12 2020   grade_12 107.0 5.0 3.0 2.0   1.0         5.0   67.0 56.0                       123.0 107 5 3 2   1         5   67 56                 123
2966899 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No 3 09 12 2015   grade_12 65.0 0.0 2.0 0.0   0.0         5.0   39.0 33.0                       72.0 65 0 2 0   0         5   39 33                 72
3344202 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_12 246.0 7.0 12.0 20.0   10.0       1.0 5.0   153.0 148.0                       301.0 246 7 12 20   10       1 5   153 148                 301
3344791 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No 3 09 12 2016   grade_12 8.0   0.0 11.0   0.0         5.0   9.0 15.0                       24.0 8   0 11   0         5   9 15                 24
3345768 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No 3 09 12 2016   grade_12 38.0 0.0 1.0 23.0           1.0 5.0   35.0 33.0                       68.0 38 0 1 23           1 5   35 33                 68
3352262 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2016   grade_12 272.0 32.0 24.0 10.0   14.0       1.0 5.0   191.0 167.0                       358.0 272 32 24 10   14       1 5   191 167                 358
3353787 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No 3 09 12 2016   grade_12 23.0 0.0 2.0 25.0             5.0   29.0 26.0                       55.0 23 0 2 25             5   29 26                 55
249836 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_12 293.0 8.0 9.0 25.0   13.0       2.0 4.0   186.0 168.0                       354.0 293 8 9 25   13       2 4   186 168                 354
251415 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   grade_12 32.0 1.0 4.0 14.0   1.0         4.0   21.0 35.0                       56.0 32 1 4 14   1         4   21 35                 56
253351 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2018   grade_12 24.0   0.0 0.0             4.0   14.0 14.0                       28.0 24   0 0             4   14 14                 28
255181 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2018   grade_12 58.0 1.0 0.0 0.0   0.0         4.0   37.0 26.0                       63.0 58 1 0 0   0         4   37 26                 63
357079 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   grade_12 280.0 8.0 11.0 24.0   8.0       1.0 4.0   161.0 175.0                       336.0 280 8 11 24   8       1 4   161 175                 336
361474 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2019   grade_12 51.0 1.0 1.0 6.0   0.0         4.0   30.0 33.0                       63.0 51 1 1 6   0         4   30 33                 63
362642 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No High 09 12 2019   grade_12 67.0 1.0 4.0 1.0   1.0         4.0   44.0 34.0                       78.0 67 1 4 1   1         4   44 34                 78
455158 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   grade_12 160.0 3.0 6.0 2.0   1.0       0.0 4.0   83.0 93.0                       176.0 160 3 6 2   1       0 4   83 93                 176
455259 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School Not applicable High 09 12 2021   grade_12 27.0   1.0 14.0             4.0   25.0 21.0                       46.0 27   1 14             4   25 21                 46
495497 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School Not applicable High 12 12 2020   grade_12 28.0 7.0 3.0     1.0         4.0   27.0 16.0                       43.0 28 7 3     1         4   27 16                 43
497011 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School Not applicable High 09 12 2020   grade_12 16.0   1.0 16.0   0.0         4.0   15.0 22.0                       37.0 16   1 16   0         4   15 22                 37
2963224 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative Education School No 3 09 12 2015   grade_12 18.0   2.0 3.0             4.0   14.0 13.0                       27.0 18   2 3             4   14 13                 27
2968758 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2015   grade_12 307.0 2.0 15.0 11.0   6.0         4.0   189.0 156.0                       345.0 307 2 15 11   6         4   189 156                 345
3006261 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_12 259.0 12.0 6.0 25.0   9.0       0.0 4.0   179.0 136.0                       315.0 259 12 6 25   9       0 4   179 136                 315
3012579 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School No High 09 12 2017   grade_12 29.0   2.0 19.0             4.0   28.0 26.0                       54.0 29   2 19             4   28 26                 54
3013583 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2017   grade_12 38.0 2.0 1.0 23.0   1.0         4.0   37.0 32.0                       69.0 38 2 1 23   1         4   37 32                 69
3346219 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No 3 09 12 2016   grade_12 64.0 0.0 3.0 0.0   2.0         4.0   39.0 34.0                       73.0 64 0 3 0   2         4   39 34                 73
3348217 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2016   grade_12 143.0 2.0 3.0 1.0   3.0         4.0   85.0 71.0                       156.0 143 2 3 1   3         4   85 71                 156
3351454 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2016   grade_12 275.0 5.0 9.0 21.0   1.0       0.0 4.0   147.0 168.0                       315.0 275 5 9 21   1       0 4   147 168                 315
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
456616 SD     school 4660450 56004   Redfield 56-4 466045000552 1 Redfield High School   Regular School Not applicable High 09 12 2021   grade_12 0.0 0.0 0.0 0.0             39.0   20.0 19.0                       39.0 0 0 0 0             39   20 19                 39
254071 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No High 09 12 2018   grade_12 15.0   0.0 1.0             3.0   6.0 13.0                       19.0 15   0 1             3   6 13                 19
256991 SD     school 4680438 11005   Platte-Geddes 11-5 468043801248 1 Platte-Geddes H.S   Regular School No High 09 12 2018   grade_12 25.0   1.0 1.0             3.0   15.0 15.0                       30.0 25   1 1             3   15 15                 30
259482 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   grade_12 15.0   1.0 17.0             3.0   14.0 22.0                       36.0 15   1 17             3   14 22                 36
357222 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200656 7 Sully Buttes High School   Regular School No High 09 12 2019   grade_12 13.0   0.0 1.0             3.0   10.0 7.0                       17.0 13   0 1             3   10 7                 17
363098 SD     school 4647100 33002   Menno 33-2 464710000420 1 Menno High School   Regular School No High 09 12 2019   grade_12 17.0                   3.0   8.0 12.0                       20.0 17                   3   8 12                 20
364417 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2019   grade_12 43.0 0.0 2.0 14.0             3.0   26.0 36.0                       62.0 43 0 2 14             3   26 36                 62
365809 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2019   grade_12 15.0 0.0 2.0 9.0   0.0         3.0   18.0 11.0                       29.0 15 0 2 9   0         3   18 11                 29
449486 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School Not applicable High 09 12 2021   grade_12 75.0   2.0 0.0             3.0   32.0 48.0                       80.0 75   2 0             3   32 48                 80
449559 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School Not applicable High 09 12 2021   grade_12 8.0   1.0 14.0   0.0         3.0   15.0 11.0                       26.0 8   1 14   0         3   15 11                 26
453493 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   grade_12 72.0 3.0 20.0 0.0   43.0       1.0 3.0   70.0 72.0                       142.0 72 3 20 0   43       1 3   70 72                 142
453952 SD     school 4638220 7002   Kimball 07-2 463822000355 1 Kimball High School   Regular School Not applicable High 09 12 2021   grade_12 12.0   0.0               3.0   7.0 8.0                       15.0 12   0               3   7 8                 15
455432 SD     school 4650670 51003   New Underwood 51-3 465067000464 1 New Underwood Hi Sch   Regular School Not applicable High 09 12 2021   grade_12 26.0     0.0             3.0   14.0 15.0                       29.0 26     0             3   14 15                 29
457092 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School Not applicable High 09 12 2021   grade_12 55.0 4.0 8.0 2.0   0.0       0.0 3.0   38.0 34.0                       72.0 55 4 8 2   0       0 3   38 34                 72
457671 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School Not applicable High 09 12 2021   grade_12 26.0   6.0 17.0   0.0         3.0   30.0 22.0                       52.0 26   6 17   0         3   30 22                 52
458014 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School Not applicable High 09 12 2021   grade_12 97.0 6.0 3.0 2.0   2.0         3.0   64.0 49.0                       113.0 97 6 3 2   2         3   64 49                 113
458952 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School Not applicable High 09 12 2021   grade_12 23.0   0.0 0.0           0.0 3.0   11.0 15.0                       26.0 23   0 0           0 3   11 15                 26
487982 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School Not applicable High 09 12 2020   grade_12 12.0   0.0 11.0   0.0         3.0   14.0 12.0                       26.0 12   0 11   0         3   14 12                 26
488031 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School Not applicable High 09 12 2020   grade_12 61.0 1.0 0.0 1.0             3.0   30.0 36.0                       66.0 61 1 0 1             3   30 36                 66
489426 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2020   grade_12 85.0 1.0 11.0 1.0   2.0       1.0 3.0   57.0 47.0                       104.0 85 1 11 1   2       1 3   57 47                 104
490799 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School Not applicable High 09 12 2020   grade_12 39.0   3.0 0.0   0.0         3.0   22.0 23.0                       45.0 39   3 0   0         3   22 23                 45
491743 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School Not applicable High 09 12 2020   grade_12 43.0 1.0 1.0 4.0   3.0         3.0   30.0 25.0                       55.0 43 1 1 4   3         3   30 25                 55
492677 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School Not applicable High 09 12 2020   grade_12 60.0 0.0 2.0 2.0   0.0         3.0   34.0 33.0                       67.0 60 0 2 2   0         3   34 33                 67
493200 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2020   grade_12 118.0 0.0 4.0 0.0   0.0       0.0 3.0   65.0 60.0                       125.0 118 0 4 0   0       0 3   65 60                 125
496226 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2020   grade_12 133.0 1.0 6.0 6.0   1.0       0.0 3.0   77.0 73.0                       150.0 133 1 6 6   1       0 3   77 73                 150
496883 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School Not applicable High 09 12 2020   grade_12 76.0 3.0 4.0 10.0   1.0         3.0   40.0 57.0                       97.0 76 3 4 10   1         3   40 57                 97
498027 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   grade_12 207.0 2.0 13.0 12.0   2.0         3.0   116.0 123.0                       239.0 207 2 13 12   2         3   116 123                 239
2965633 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2015   grade_12 127.0 3.0 3.0 1.0   1.0         3.0   71.0 67.0                       138.0 127 3 3 1   1         3   71 67                 138
2968751 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative Education School No 3 07 12 2015   grade_12 55.0 2.0 5.0 29.0             3.0   46.0 48.0                       94.0 55 2 5 29             3   46 48                 94
2969688 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2015   grade_12 326.0 49.0 24.0 10.0   35.0         3.0   223.0 224.0                       447.0 326 49 24 10   35         3   223 224                 447
3007228 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_12 248.0 9.0 5.0 0.0   3.0       0.0 3.0   133.0 135.0                       268.0 248 9 5 0   3       0 3   133 135                 268

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