Data source: Big Local News · About: Big Local

671 rows where grade = "pk_12_total", state = "SD" and year = 2018 sorted by school descending

View and edit SQL

year

  • 2018 · 671

grade

  • pk_12_total · 671
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
260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
260442 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   pk_12_total 66.0   3.0                   35.0 34.0                       69.0 66   3                   35 34                 69
260441 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   pk_12_total 164.0 1.0 12.0     3.0         6.0   94.0 92.0                       186.0 164 1 12     3         6   94 92                 186
257427 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   pk_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0                       353.0 212 2 27 70   7       1 34   170 183                 353
251768 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   pk_12_total 5.0     8.0                 6.0 7.0                       13.0 5     8                 6 7                 13
260409 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2018   pk_12_total 96.0 4.0 13.0               7.0   51.0 69.0                       120.0 96 4 13               7   51 69                 120
260408 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2018   pk_12_total 93.0 5.0 7.0 2.0             2.0   65.0 44.0                       109.0 93 5 7 2             2   65 44                 109
260407 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2018   pk_12_total 134.0 2.0 16.0               3.0   76.0 79.0                       155.0 134 2 16               3   76 79                 155
256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684
253287 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 27.0                       13.0 14.0                       27.0 27                       13 14                 27
260361 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   pk_12_total 116.0   1.0 44.0   2.0             86.0 77.0                       163.0 116   1 44   2             86 77                 163
260360 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   pk_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0                       199.0 147 3 1 45   2       1     99 100                 199
260359 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School No Elementary KG 05 2018   pk_12_total 191.0 5.0 2.0 159.0   2.0         1.0   190.0 170.0                       360.0 191 5 2 159   2         1   190 170                 360
260313 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   pk_12_total 22.0     8.0                 16.0 14.0                       30.0 22     8                 16 14                 30
260312 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   pk_12_total 49.0   3.0 17.0             3.0   33.0 39.0                       72.0 49   3 17             3   33 39                 72
260311 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   pk_12_total 91.0 4.0 3.0 35.0             1.0   70.0 64.0                       134.0 91 4 3 35             1   70 64                 134
260262 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No Middle 06 08 2018   pk_12_total 34.0 1.0 2.0 2.0                 24.0 15.0                       39.0 34 1 2 2                 24 15                 39
260261 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2018   pk_12_total 49.0   3.0 1.0                 29.0 24.0                       53.0 49   3 1                 29 24                 53
260260 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2018   pk_12_total 98.0 1.0 5.0 3.0                 42.0 65.0                       107.0 98 1 5 3                 42 65                 107
258449 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   pk_12_total 349.0 218.0 163.0 66.0   75.0       1.0 41.0   471.0 442.0                       913.0 349 218 163 66   75       1 41   471 442                 913
255825 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   pk_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0                       97.0 85   3 4           1 4   45 52                 97
257576 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       11.0 12.0                       23.0 23                       11 12                 23
260168 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 5.0 2.0 2.0 87.0             5.0   52.0 49.0                       101.0 5 2 2 87             5   52 49                 101
260167 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   pk_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0                       103.0 14 1 2 80   1       1 4   54 49                 103
260166 SD     school 4678570 47001   White River 47-1 467857000753 2 White River Elementary   Regular School No Elementary PK 05 2018   pk_12_total 8.0   1.0 147.0             11.0   96.0 71.0                       167.0 8   1 147             11   96 71                 167
260105 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2018   pk_12_total 16.0 1.0 2.0                   10.0 9.0                       19.0 16 1 2                   10 9                 19
260104 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2018   pk_12_total 28.0   4.0                   18.0 14.0                       32.0 28   4                   18 14                 32
260103 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2018   pk_12_total 70.0 1.0 4.0             1.0     44.0 32.0                       76.0 70 1 4             1     44 32                 76
251046 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2018   pk_12_total 22.0                       13.0 9.0                       22.0 22                       13 9                 22
258585 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 119.0 1.0 43.0 252.0             65.0   240.0 240.0                       480.0 119 1 43 252             65   240 240                 480
257426 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 515.0 5.0 56.0 35.0   6.0         39.0   353.0 303.0                       656.0 515 5 56 35   6         39   353 303                 656
258804 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   pk_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0                       365.0 315 5 18 9   5         13   195 170                 365
260056 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   pk_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0                       321.0 296 4 4 9   1         7   172 149                 321
260055 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2018   pk_12_total 320.0 6.0 10.0 7.0   1.0         15.0   186.0 173.0                       359.0 320 6 10 7   1         15   186 173                 359
260054 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2018   pk_12_total 386.0 5.0 2.0 3.0             6.0   192.0 210.0                       402.0 386 5 2 3             6   192 210                 402
260053 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   pk_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0                       247.0 229 2 7 2             7   127 120                 247
259991 SD     school 4677460 36002   Wessington Springs 36-2 467746000076 4 Wessington Springs Jr. High   Regular School No Middle 07 08 2018   pk_12_total 34.0   3.0                   21.0 16.0                       37.0 34   3                   21 16                 37
259990 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   pk_12_total 22.0   1.0 2.0                 11.0 14.0                       25.0 22   1 2                 11 14                 25
259989 SD     school 4677460 36002   Wessington Springs 36-2 467746000733 1 Wessington Springs Hi Sch   Regular School No High 09 12 2018   pk_12_total 71.0   2.0                   38.0 35.0                       73.0 71   2                   38 35                 73
259988 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   pk_12_total 171.0   9.0                   101.0 79.0                       180.0 171   9                   101 79                 180
260532 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   pk_12_total 268.0 8.0 31.0 21.0   5.0         14.0   181.0 166.0                       347.0 268 8 31 21   5         14   181 166                 347
259913 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2018   pk_12_total 120.0   2.0 1.0             3.0   63.0 63.0                       126.0 120   2 1             3   63 63                 126
259912 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2018   pk_12_total 140.0   3.0 1.0             2.0   77.0 69.0                       146.0 140   3 1             2   77 69                 146
259911 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 255.0   8.0 6.0   1.0       1.0 12.0   145.0 138.0                       283.0 255   8 6   1       1 12   145 138                 283
259865 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   pk_12_total 51.0     1.0           1.0     27.0 26.0                       53.0 51     1           1     27 26                 53
259864 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2018   pk_12_total 68.0   3.0 3.0             2.0   34.0 42.0                       76.0 68   3 3             2   34 42                 76
259863 SD     school 4676740 14005   Waverly 14-5 467674000721 2 Waverly/South Shore Elementary   Regular School No Elementary PK 05 2018   pk_12_total 123.0 1.0 1.0 3.0             3.0   76.0 55.0                       131.0 123 1 1 3             3   76 55                 131
259817 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2018   pk_12_total 8.0     20.0                 19.0 9.0                       28.0 8     20                 19 9                 28
259816 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2018   pk_12_total 19.0   3.0 25.0                 25.0 22.0                       47.0 19   3 25                 25 22                 47
259815 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School No Elementary PK 05 2018   pk_12_total 61.0     45.0             2.0   65.0 43.0                       108.0 61     45             2   65 43                 108
259764 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   pk_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0                       627.0 550 5 20 32   6         14   313 314                 627
259763 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   pk_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0                       629.0 543 3 27 21   8         27   316 313                 629
259762 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   pk_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0                       1211.0 1086 8 38 45   10       1 23   619 592                 1211
258448 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   pk_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0                       1939.0 1111 333 224 66   143       1 61   997 942                 1939
254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
259641 SD     school 4676020 6005   Warner 06-5 467602000710 3 Warner Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 61.0 1.0 3.0 1.0             2.0   33.0 35.0                       68.0 61 1 3 1             2   33 35                 68
259640 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   pk_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0                       94.0 86 2 1 4   1             49 45                 94
259639 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 140.0 2.0 2.0 2.0             5.0   73.0 78.0                       151.0 140 2 2 2             5   73 78                 151
259592 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2018   pk_12_total 50.0   1.0 5.0                 33.0 23.0                       56.0 50   1 5                 33 23                 56
259591 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2018   pk_12_total 58.0     15.0                 36.0 37.0                       73.0 58     15                 36 37                 73
259590 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 103.0 2.0 1.0 14.0   1.0         1.0   57.0 65.0                       122.0 103 2 1 14   1         1   57 65                 122
258633 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No Middle 06 08 2018   pk_12_total       51.0                 28.0 23.0                       51.0       51                 28 23                 51
258632 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No High 09 12 2018   pk_12_total       58.0                 32.0 26.0                       58.0       58                 32 26                 58
258631 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No Elementary KG 05 2018   pk_12_total 2.0     85.0             4.0   48.0 43.0                       91.0 2     85             4   48 43                 91
259528 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   pk_12_total 62.0   10.0 137.0             25.0   125.0 109.0                       234.0 62   10 137             25   125 109                 234
259527 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   pk_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0                       259.0 64   9 159   1         26   128 131                 259
259526 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   pk_12_total 62.0   7.0 99.0             14.0   83.0 99.0                       182.0 62   7 99             14   83 99                 182
259525 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2018   pk_12_total 77.0   15.0 179.0             37.0   163.0 145.0                       308.0 77   15 179             37   163 145                 308
259464 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No Middle 05 08 2018   pk_12_total 82.0 2.0                 2.0   46.0 40.0                       86.0 82 2                 2   46 40                 86
259463 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2018   pk_12_total 104.0 1.0 3.0 2.0                 68.0 42.0                       110.0 104 1 3 2                 68 42                 110
259462 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2018   pk_12_total 139.0 3.0 4.0 2.0           1.0 4.0   74.0 79.0                       153.0 139 3 4 2           1 4   74 79                 153
259400 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   pk_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0                       288.0 220 4 13 31   8         12   146 142                 288
259399 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   pk_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0                       378.0 303 8 19 39   5       2 2   174 204                 378
252359 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   pk_12_total 346.0 16.0 39.0 31.0   4.0       1.0 43.0   231.0 249.0                       480.0 346 16 39 31   4       1 43   231 249                 480
257425 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2018   pk_12_total 414.0 11.0 42.0 100.0   10.0       2.0 40.0   326.0 293.0                       619.0 414 11 42 100   10       2 40   326 293                 619
250901 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No Elementary KG 04 2018   pk_12_total 101.0 1.0 3.0               2.0   52.0 55.0                       107.0 101 1 3               2   52 55                 107
257704 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No Elementary KG 08 2018   pk_12_total 25.0                       13.0 12.0                       25.0 25                       13 12                 25
250741 SD     school 4607400 4002   Bon Homme 04-2 460740000064 4 Tyndall Elementary   Regular School No Elementary KG 05 2018   pk_12_total 127.0   4.0 1.0             6.0   77.0 61.0                       138.0 127   4 1             6   77 61                 138
253286 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       15.0 8.0                       23.0 23                       15 8                 23
259335 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   pk_12_total 20.0     1.0   1.0             11.0 11.0                       22.0 20     1   1             11 11                 22
259334 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School No High 09 12 2018   pk_12_total 31.0     3.0                 18.0 16.0                       34.0 31     3                 18 16                 34
259333 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2018   pk_12_total 77.0 1.0 2.0 3.0   1.0         1.0   42.0 43.0                       85.0 77 1 2 3   1         1   42 43                 85
259257 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   pk_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0                       145.0 125 9 9 1             1   71 74                 145
259256 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2018   pk_12_total 226.0 14.0 7.0 1.0   1.0         5.0   148.0 106.0                       254.0 226 14 7 1   1         5   148 106                 254
259255 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2018   pk_12_total 442.0 40.0 24.0               11.0   278.0 239.0                       517.0 442 40 24               11   278 239                 517
259200 SD     school 4672090 66001   Todd County 66-1 467209000814 10 Todd County MS   Regular School No Middle 06 08 2018   pk_12_total 3.0   1.0 363.0                 188.0 179.0                       367.0 3   1 363                 188 179                 367
259199 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2018   pk_12_total 4.0   2.0 449.0   1.0         2.0   242.0 216.0                       458.0 4   2 449   1         2   242 216                 458
259198 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   pk_12_total 2.0   15.0 520.0             8.0   276.0 269.0                       545.0 2   15 520             8   276 269                 545
259197 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2018   pk_12_total       26.0                 14.0 12.0                       26.0       26                 14 12                 26
259196 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement High School   Alternative School No High 09 12 2018   pk_12_total       13.0                 7.0 6.0                       13.0       13                 7 6                 13
259017 SD     school 4671880 20003   Timber Lake 20-3 467188000940 3 Timber Lake Middle 6-8   Regular School No Middle 06 08 2018   pk_12_total 36.0   1.0 43.0                 47.0 33.0                       80.0 36   1 43                 47 33                 80
259016 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2018   pk_12_total 34.0   3.0 60.0                 44.0 53.0                       97.0 34   3 60                 44 53                 97
259015 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2018   pk_12_total 80.0 1.0 3.0 103.0                 99.0 88.0                       187.0 80 1 3 103                 99 88                 187
253046 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       11.0 12.0                       23.0 23                       11 12                 23
258447 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   pk_12_total 152.0 119.0 132.0 48.0   19.0         47.0   276.0 241.0                       517.0 152 119 132 48   19         47   276 241                 517
258968 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School No Middle 05 08 2018   pk_12_total 471.0 10.0 18.0 6.0             28.0   293.0 240.0                       533.0 471 10 18 6             28   293 240                 533
258967 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   pk_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0                       710.0 652 7 19 8   1         23   378 332                 710
258966 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   pk_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0                       431.0 387 9 9 7             19   226 205                 431

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