Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by ccd_school_type

View and edit SQL

year

grade

  • k_12_total · 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
2961726 SD     school 4602070 6001   Aberdeen 06-1 460207001230 12 Aberdeen Alternative Learning Center   Alternative Education School No 4 06 12 2015   k_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
2961732 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2015   k_12_total 3.0   1.0 4.0           1.0     4.0 5.0                       9.0 3   1 4           1     4 5                 9
2962210 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative Education School No 3 09 12 2015   k_12_total 38.0   6.0 1.0             3.0   24.0 24.0                       48.0 38   6 1             3   24 24                 48
2963278 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative Education School No 3 09 12 2015   k_12_total 37.0   2.0 3.0             4.0   21.0 25.0                       46.0 37   2 3             4   21 25                 46
2963279 SD     school 4612300 39001   Chester Area 39-1 461230001269 39 Chester Area Cyber School   Alternative Education School No 3 09 12 2015   k_12_total 207.0     1.0                 135.0 73.0       6.3               208.0 207     1                 135 73                 208
2964194 SD     school 4620100 20001   Eagle Butte 20-1 462010001233 7 C-EB EAGLE Center   Alternative Education School No 4 05 12 2015   k_12_total 1.0     3.0                 3.0 1.0                       4.0 1     3                 3 1                 4
2966822 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative Education School No 3 09 12 2015   k_12_total 40.0 14.0 7.0 27.0   18.0         5.0   76.0 35.0       4.5               111.0 40 14 7 27   18         5   76 35                 111
2968384 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2015   k_12_total 19.0   1.0 7.0                 11.0 16.0       0.0               27.0 19   1 7                 11 16                 27
2968562 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2015   k_12_total 22.0     22.0           1.0     29.0 16.0                       45.0 22     22           1     29 16                 45
2968563 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative Education School No 2 05 08 2015   k_12_total 12.0 1.0   3.0             1.0   16.0 1.0                       17.0 12 1   3             1   16 1                 17
2968976 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative Education School No 3 07 12 2015   k_12_total 236.0 5.0 22.0 154.0             21.0   247.0 191.0       0.5               438.0 236 5 22 154             21   247 191                 438
2969110 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S Mickelson Alternative   Alternative Education School No 4 02 12 2015   k_12_total 21.0 1.0   8.0                 22.0 8.0                       30.0 21 1   8                 22 8                 30
2969489 SD     school 4665460 65001   Shannon County 65-1 466546001273 9 Shannon County Alternative School   Alternative Education School No 1 KG 08 2015   k_12_total       22.0                 18.0 4.0                       22.0       22                 18 4                 22
2969490 SD     school 4665460 65001   Shannon County 65-1 466546001262 8 Shannon County Virtual High School   Alternative Education School No 3 09 12 2015   k_12_total     3.0 94.0                 43.0 54.0                       97.0     3 94                 43 54                 97
2970091 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative Education School No 4 KG 12 2015   k_12_total 22.0   2.0 10.0             1.0   8.0 27.0       5.7               35.0 22   2 10             1   8 27                 35
2970534 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Black Hills Academy at Canyon Hills Elem   Alternative Education School No 1 KG 08 2015   k_12_total 4.0     5.0                 6.0 3.0                       9.0 4     5                 6 3                 9
2970535 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Black Hills Academy at Canyon Hills H.S.   Alternative Education School No 3 09 12 2015   k_12_total 10.0   1.0 5.0                 10.0 6.0       0.0               16.0 10   1 5                 10 6                 16
2970536 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative Education School No 3 10 12 2015   k_12_total 37.0 1.0 2.0 2.0                 16.0 26.0                       42.0 37 1 2 2                 16 26                 42
3344287 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2016   k_12_total 5.0     7.0                 6.0 6.0                       12.0 5     7                 6 6                 12
3344762 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative Education School No 3 09 12 2016   k_12_total 29.0   3.0               3.0   24.0 11.0                       35.0 29   3               3   24 11                 35
3345878 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative Education School No 3 09 12 2016   k_12_total 34.0   1.0 7.0             3.0   17.0 28.0       0.0               45.0 34   1 7             3   17 28                 45
3345879 SD     school 4612300 39001   Chester Area 39-1 461230001269 39 Chester Area Cyber School   Alternative Education School No 3 09 12 2016   k_12_total 170.0                       106.0 64.0                       170.0 170                       106 64                 170
3349406 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative Education School No 3 09 12 2016   k_12_total 29.0 22.0 6.0 33.0   18.0         5.0   74.0 39.0       35.6               113.0 29 22 6 33   18         5   74 39                 113
3350871 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   k_12_total       15.0                 9.0 6.0       4.2               15.0       15                 9 6                 15
3351096 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2016   k_12_total 16.0 1.0 2.0 6.0           1.0     6.0 20.0       0.0               26.0 16 1 2 6           1     6 20                 26
3351258 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2016   k_12_total 17.0     24.0             3.0   27.0 17.0                       44.0 17     24             3   27 17                 44
3351259 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative Education School No 2 05 08 2016   k_12_total 11.0 1.0 1.0 7.0             2.0   16.0 6.0                       22.0 11 1 1 7             2   16 6                 22
3351806 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S. Mickelson Alternative HS   Alternative Education School No 3 09 12 2016   k_12_total 18.0     4.0                 15.0 7.0       0.0               22.0 18     4                 15 7                 22
3352664 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative Education School No 4 KG 12 2016   k_12_total 21.0 3.0 1.0 6.0             1.0   8.0 24.0       3.5               32.0 21 3 1 6             1   8 24                 32
3353102 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Black Hills Academy at Canyon Hills Elem   Alternative Education School No 1 KG 08 2016   k_12_total 5.0     3.0             1.0   3.0 6.0       0.0               9.0 5     3             1   3 6                 9
3353103 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Black Hills Academy at Canyon Hills H.S.   Alternative Education School No 3 09 12 2016   k_12_total 10.0 1.0   2.0                 9.0 4.0       0.0               13.0 10 1   2                 9 4                 13
3353104 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative Education School No 3 10 12 2016   k_12_total 27.0     3.0             1.0   16.0 15.0       0.0               31.0 27     3             1   16 15                 31
249931 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2018   k_12_total 4.0     3.0                 4.0 3.0       0.0               7.0 4     3                 4 3                 7
250441 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2018   k_12_total 32.0   6.0 2.0             2.0   21.0 21.0       0.0               42.0 32   6 2             2   21 21                 42
251542 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 High Plains   Alternative School No High 09 12 2018   k_12_total 60.0   1.0 2.0   1.0         1.0   24.0 41.0       1.5               65.0 60   1 2   1         1   24 41                 65
255101 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2018   k_12_total 29.0 33.0 5.0 28.0   11.0         9.0   77.0 38.0       36.5               115.0 29 33 5 28   11         9   77 38                 115
256791 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2018   k_12_total 15.0 2.0 1.0 13.0                 7.0 24.0       0.0               31.0 15 2 1 13                 7 24                 31
256953 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2018   k_12_total 18.0 5.0 3.0 15.0             4.0   25.0 20.0       2.2               45.0 18 5 3 15             4   25 20                 45
256954 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2018   k_12_total 13.0 4.0 2.0 6.0                 22.0 3.0       0.0               25.0 13 4 2 6                 22 3                 25
257367 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2018   k_12_total 186.0 11.0 22.0 144.0   2.0         15.0   224.0 156.0       0.8               380.0 186 11 22 144   2         15   224 156                 380
257501 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S. Mickelson Alternative HS   Alternative School No High 09 12 2018   k_12_total 13.0   1.0 1.0                 13.0 2.0       0.0               15.0 13   1 1                 13 2                 15
258321 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2018   k_12_total 2.0   2.0 2.0                 2.0 4.0       16.7               6.0 2   2 2                 2 4                 6
258359 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School No Other KG 12 2018   k_12_total 13.0 3.0   11.0             1.0   11.0 17.0       0.0               28.0 13 3   11             1   11 17                 28
258781 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative School No High 10 12 2018   k_12_total 21.0   1.0 1.0             2.0   17.0 8.0       0.0               25.0 21   1 1             2   17 8                 25
258784 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School No Elementary KG 08 2018   k_12_total 8.0   1.0 1.0                 7.0 3.0       0.0               10.0 8   1 1                 7 3                 10
258785 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School No High 09 12 2018   k_12_total 12.0     2.0             2.0   8.0 8.0       0.0               16.0 12     2             2   8 8                 16
259172 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School No High 09 12 2018   k_12_total       13.0                 7.0 6.0       0.0               13.0       13                 7 6                 13
259173 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2018   k_12_total       26.0                 14.0 12.0       3.9               26.0       26                 14 12                 26
357174 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   k_12_total 1.0 2.0   11.0                 5.0 9.0       14.3               14.0 1 2   11                 5 9                 14
357684 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2019   k_12_total 28.0   4.0 1.0             2.0   19.0 16.0       0.0               35.0 28   4 1             2   19 16                 35
358801 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 High Plains   Alternative School No High 09 12 2019   k_12_total 59.0   2.0 3.0             3.0   30.0 37.0       1.5               67.0 59   2 3             3   30 37                 67
362328 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2019   k_12_total 15.0 22.0 5.0 37.0   4.0         6.0   67.0 22.0       30.3               89.0 15 22 5 37   4         6   67 22                 89
364062 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2019   k_12_total 9.0 1.0 1.0 15.0                 8.0 18.0       0.0               26.0 9 1 1 15                 8 18                 26
364228 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2019   k_12_total 23.0 3.0 2.0 15.0             3.0   27.0 19.0       0.0               46.0 23 3 2 15             3   27 19                 46
364229 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2019   k_12_total 7.0 3.0 2.0 10.0             1.0   20.0 3.0       0.0               23.0 7 3 2 10             1   20 3                 23
364642 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2019   k_12_total 181.0 7.0 19.0 130.0             30.0   198.0 169.0       0.3               367.0 181 7 19 130             30   198 169                 367
364776 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S. Mickelson Alternative HS   Alternative School No High 09 12 2019   k_12_total 13.0     2.0             1.0   13.0 3.0       0.0               16.0 13     2             1   13 3                 16
365584 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School No Other KG 12 2019   k_12_total 4.0   1.0 1.0             1.0   5.0 2.0       0.0               7.0 4   1 1             1   5 2                 7
365621 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School No Other KG 12 2019   k_12_total 21.0   2.0 7.0                 8.0 22.0       0.0               30.0 21   2 7                 8 22                 30
366008 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative School No High 10 12 2019   k_12_total 26.0   4.0 1.0             3.0   22.0 12.0       0.0               34.0 26   4 1             3   22 12                 34
366011 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School No Middle 04 08 2019   k_12_total 2.0   1.0 3.0             1.0   6.0 1.0       0.0               7.0 2   1 3             1   6 1                 7
366012 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School No High 09 12 2019   k_12_total 5.0 1.0 1.0 9.0                 8.0 8.0       0.0               16.0 5 1 1 9                 8 8                 16
366399 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School No High 09 12 2019   k_12_total       11.0                 4.0 7.0       0.0               11.0       11                 4 7                 11
366400 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2019   k_12_total       7.0                 3.0 4.0       0.0               7.0       7                 3 4                 7
367300 SD     school 4631710 49007   West Central 49-7 463171001389 8 Falls Academy   Alternative School No High 08 12 2019   k_12_total 9.0 1.0   7.0           3.0 1.0   17.0 4.0       0.0               21.0 9 1   7           3 1   17 4                 21
449036 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2021   k_12_total 4.0     4.0                 2.0 6.0       0.0               8.0 4     4                 2 6                 8
449530 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School Not applicable High 09 12 2021   k_12_total 33.0   6.0               2.0   26.0 15.0       2.4               41.0 33   6               2   26 15                 41
450647 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 High Plains   Alternative School Not applicable High 09 12 2021   k_12_total 60.0   3.0               3.0   23.0 43.0       1.5               66.0 60   3               3   23 43                 66
454403 SD     school 4641640 44002   Leola 44-2 464164001397 7 Leola Alternative School   Alternative School Not applicable High 08 12 2021   k_12_total 9.0                       8.0 1.0       11.1               9.0 9                       8 1                 9
455940 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2021   k_12_total 10.0   2.0 14.0                 6.0 20.0       3.9               26.0 10   2 14                 6 20                 26
456106 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School Not applicable High 09 12 2021   k_12_total 7.0 1.0   6.0                 9.0 5.0       0.0               14.0 7 1   6                 9 5                 14
456107 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2021   k_12_total 2.0 1.0   5.0             1.0   5.0 4.0       0.0               9.0 2 1   5             1   5 4                 9
457446 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2021   k_12_total 3.0     4.0                 4.0 3.0       0.0               7.0 3     4                 4 3                 7
457471 SD     school 4666270 49005   Sioux Falls 49-5 466627001396 47 Odyssey   Alternative School Not applicable Middle 06 08 2021   k_12_total 5.0 4.0 2.0 4.0             2.0   16.0 1.0       11.8               17.0 5 4 2 4             2   16 1                 17
457482 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Alternative School Not applicable Other KG 12 2021   k_12_total 12.0   4.0 2.0                 12.0 6.0       5.6               18.0 12   4 2                 12 6                 18
457870 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative School Not applicable High 10 12 2021   k_12_total 21.0 1.0 5.0 3.0           1.0   1.0 23.0 9.0       3.1               32.0 21 1 5 3           1   1 23 9                 32
457873 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elementary   Alternative School Not applicable Middle 04 08 2021   k_12_total 4.0   1.0 3.0           1.0     3.0 6.0       0.0               9.0 4   1 3           1     3 6                 9
457874 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High School   Alternative School Not applicable High 09 12 2021   k_12_total 6.0   1.0 6.0             3.0   8.0 8.0       0.0               16.0 6   1 6             3   8 8                 16
458277 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School Not applicable High 09 12 2021   k_12_total       14.0                 4.0 10.0       0.0               14.0       14                 4 10                 14
458278 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School Not applicable Middle 06 08 2021   k_12_total       5.0                 4.0 1.0       0.0               5.0       5                 4 1                 5
459210 SD     school 4631710 49007   West Central 49-7 463171001389 8 Falls Academy   Alternative School Not applicable High 05 12 2021   k_12_total 11.0 2.0 1.0 14.0           2.0     21.0 9.0       0.0               30.0 11 2 1 14           2     21 9                 30
487459 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2020   k_12_total 2.0 1.0 1.0 5.0                 5.0 4.0       0.0               9.0 2 1 1 5                 5 4                 9
487953 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School Not applicable High 09 12 2020   k_12_total 33.0   4.0 1.0                 23.0 15.0       0.0               38.0 33   4 1                 23 15                 38
489070 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 High Plains   Alternative School Not applicable High 09 12 2020   k_12_total 70.0 1.0 2.0               3.0   24.0 52.0       2.6               76.0 70 1 2               3   24 52                 76
489989 SD     school 4620100 20001   Eagle Butte 20-1 462010001233 7 C-EB E.A.G.L.E. Center High School   Alternative School Not applicable High 09 12 2020   k_12_total 1.0     3.0                 3.0 1.0       0.0               4.0 1     3                 3 1                 4
492597 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   k_12_total 20.0 10.0 2.0 33.0   2.0       4.0 4.0   51.0 24.0       17.3               75.0 20 10 2 33   2       4 4   51 24                 75
494347 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School Not applicable High 05 12 2020   k_12_total 13.0   2.0 15.0                 8.0 22.0       0.0               30.0 13   2 15                 8 22                 30
494513 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School Not applicable High 09 12 2020   k_12_total 15.0 2.0   17.0             1.0   24.0 11.0       0.0               35.0 15 2   17             1   24 11                 35
494514 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2020   k_12_total 4.0 2.0 1.0 11.0                 16.0 2.0       0.0               18.0 4 2 1 11                 16 2                 18
494927 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School Not applicable High 09 12 2020   k_12_total 148.0 9.0 25.0 104.0   1.0         37.0   181.0 143.0       0.0               324.0 148 9 25 104   1         37   181 143                 324
495061 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S. Mickelson Alternative HS   Alternative School Not applicable High 09 12 2020   k_12_total 7.0     2.0                 7.0 2.0       0.0               9.0 7     2                 7 2                 9
495869 SD     school 4666270 49005   Sioux Falls 49-5 466627001368 71 ARISE Shelter Care   Alternative School Not applicable Other KG 12 2020   k_12_total 4.0                   1.0   4.0 1.0       0.0               5.0 4                   1   4 1                 5
495894 SD     school 4666270 49005   Sioux Falls 49-5 466627001396 47 Odyssey   Alternative School Not applicable Middle 06 08 2020   k_12_total 8.0 6.0 2.0 4.0             4.0   23.0 1.0       8.3               24.0 8 6 2 4             4   23 1                 24
495906 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School Not applicable Other KG 12 2020   k_12_total 23.0     4.0             2.0   10.0 19.0       0.0               29.0 23     4             2   10 19                 29
496293 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative School Not applicable High 10 12 2020   k_12_total 24.0   4.0 2.0             1.0   22.0 9.0       0.0               31.0 24   4 2             1   22 9                 31
496296 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School Not applicable Middle 04 08 2020   k_12_total 9.0     3.0             2.0   7.0 7.0       0.0               14.0 9     3             2   7 7                 14
496297 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Spearfish Academy at Canyon Hills High S   Alternative School Not applicable High 09 12 2020   k_12_total 3.0     6.0             4.0   5.0 8.0       0.0               13.0 3     6             4   5 8                 13
496700 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School Not applicable High 09 12 2020   k_12_total       18.0                 7.0 11.0       0.0               18.0       18                 7 11                 18
496701 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School Not applicable Middle 06 08 2020   k_12_total       5.0                 3.0 2.0       0.0               5.0       5                 3 2                 5
497601 SD     school 4631710 49007   West Central 49-7 463171001389 8 Falls Academy   Alternative School Not applicable High 05 12 2020   k_12_total 3.0 3.0 1.0 16.0           1.0 1.0   17.0 8.0       0.0               25.0 3 3 1 16           1 1   17 8                 25

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