Data source: Big Local News · About: Big Local

671 rows where grade = "k_12_total", state = "SD" and year = 2018 sorted by rowid descending

View and edit SQL

year

  • 2018 · 671

grade

  • k_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
260522 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   k_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0       1.6               635.0 529 9 42 36   4         15   335 300                 635
260521 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   k_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0       1.6               867.0 745 10 60 38   9         5   453 414                 867
260520 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   k_12_total 139.0 3.0 21.0 18.0   2.0         5.0   99.0 89.0       3.2               188.0 139 3 21 18   2         5   99 89                 188
260519 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   k_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0       1.5               273.0 228 5 19 9   6         6   137 136                 273
260518 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2018   k_12_total 298.0 4.0 25.0 18.0   2.0         13.0   179.0 181.0       3.3               360.0 298 4 25 18   2         13   179 181                 360
260517 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   k_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0       2.3               392.0 334 8 23 13   2         12   207 185                 392
260438 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   k_12_total 66.0   3.0                   35.0 34.0       0.0               69.0 66   3                   35 34                 69
260437 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   k_12_total 144.0 1.0 10.0     3.0         5.0   81.0 82.0       1.8               163.0 144 1 10     3         5   81 82                 163
260403 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2018   k_12_total 96.0 4.0 13.0               7.0   51.0 69.0       3.3               120.0 96 4 13               7   51 69                 120
260402 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2018   k_12_total 93.0 5.0 7.0 2.0             2.0   65.0 44.0       0.9               109.0 93 5 7 2             2   65 44                 109
260401 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2018   k_12_total 115.0 2.0 13.0               3.0   67.0 66.0       2.3               133.0 115 2 13               3   67 66                 133
260355 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   k_12_total 116.0   1.0 44.0   2.0             86.0 77.0       0.6               163.0 116   1 44   2             86 77                 163
260354 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   k_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0       0.5               199.0 147 3 1 45   2       1     99 100                 199
260353 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School No Elementary KG 05 2018   k_12_total 191.0 5.0 2.0 159.0   2.0         1.0   190.0 170.0       0.0               360.0 191 5 2 159   2         1   190 170                 360
260307 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   k_12_total 22.0     8.0                 16.0 14.0       0.0               30.0 22     8                 16 14                 30
260306 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 17.0             3.0   33.0 39.0       0.0               72.0 49   3 17             3   33 39                 72
260305 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   k_12_total 78.0 2.0 3.0 34.0             1.0   61.0 57.0       0.0               118.0 78 2 3 34             1   61 57                 118
260250 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No Middle 06 08 2018   k_12_total 34.0 1.0 2.0 2.0                 24.0 15.0       0.0               39.0 34 1 2 2                 24 15                 39
260249 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 1.0                 29.0 24.0       0.0               53.0 49   3 1                 29 24                 53
260248 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2018   k_12_total 86.0 0.0 5.0 3.0                 37.0 57.0       2.1               94.0 86 0 5 3                 37 57                 94
260247 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2018   k_12_total 13.0                       6.0 7.0       53.9               13.0 13                       6 7                 13
260246 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 16.0                       6.0 10.0       50.0               16.0 16                       6 10                 16
260245 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 22.0                       12.0 10.0       54.6               22.0 22                       12 10                 22
260160 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   k_12_total 5.0 2.0 2.0 87.0             5.0   52.0 49.0       2.0               101.0 5 2 2 87             5   52 49                 101
260159 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   k_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0       0.0               103.0 14 1 2 80   1       1 4   54 49                 103
260158 SD     school 4678570 47001   White River 47-1 467857000753 2 White River Elementary   Regular School No Elementary PK 05 2018   k_12_total 6.0   1.0 135.0             8.0   84.0 66.0       0.0               150.0 6   1 135             8   84 66                 150
260157 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No Elementary PK 05 2018   k_12_total       47.0                 29.0 18.0       0.0               47.0       47                 29 18                 47
260099 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2018   k_12_total 16.0 1.0 2.0                   10.0 9.0       0.0               19.0 16 1 2                   10 9                 19
260098 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2018   k_12_total 28.0   4.0                   18.0 14.0       0.0               32.0 28   4                   18 14                 32
260097 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2018   k_12_total 58.0 1.0 4.0             1.0     38.0 26.0       0.0               64.0 58 1 4             1     38 26                 64
260048 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   k_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0       0.3               321.0 296 4 4 9   1         7   172 149                 321
260047 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2018   k_12_total 320.0 6.0 10.0 7.0   1.0         15.0   186.0 173.0       1.4               359.0 320 6 10 7   1         15   186 173                 359
260046 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2018   k_12_total 386.0 5.0 2.0 3.0             6.0   192.0 210.0       0.5               402.0 386 5 2 3             6   192 210                 402
260045 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   k_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0       0.4               247.0 229 2 7 2             7   127 120                 247
259981 SD     school 4677460 36002   Wessington Springs 36-2 467746000076 4 Wessington Springs Jr. High   Regular School No Middle 07 08 2018   k_12_total 34.0   3.0                   21.0 16.0       2.7               37.0 34   3                   21 16                 37
259980 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   k_12_total 22.0   1.0 2.0                 11.0 14.0       0.0               25.0 22   1 2                 11 14                 25
259979 SD     school 4677460 36002   Wessington Springs 36-2 467746000733 1 Wessington Springs Hi Sch   Regular School No High 09 12 2018   k_12_total 71.0   2.0                   38.0 35.0       0.0               73.0 71   2                   38 35                 73
259978 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   k_12_total 147.0   9.0                   83.0 73.0       4.5               156.0 147   9                   83 73                 156
259977 SD     school 4677460 36002   Wessington Springs 36-2 467746000731 5 Spring Valley Elementary   Regular School No Elementary KG 08 2018   k_12_total 40.0                       19.0 21.0       50.0               40.0 40                       19 21                 40
259907 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2018   k_12_total 120.0   2.0 1.0             3.0   63.0 63.0       0.0               126.0 120   2 1             3   63 63                 126
259906 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2018   k_12_total 140.0   3.0 1.0             2.0   77.0 69.0       0.0               146.0 140   3 1             2   77 69                 146
259905 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 233.0   8.0 6.0   1.0       1.0 12.0   130.0 131.0       0.4               261.0 233   8 6   1       1 12   130 131                 261
259859 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   k_12_total 51.0     1.0           1.0     27.0 26.0       0.0               53.0 51     1           1     27 26                 53
259858 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2018   k_12_total 68.0   3.0 3.0             2.0   34.0 42.0       0.0               76.0 68   3 3             2   34 42                 76
259857 SD     school 4676740 14005   Waverly 14-5 467674000721 2 Waverly/South Shore Elementary   Regular School No Elementary PK 05 2018   k_12_total 109.0 1.0 1.0 3.0             2.0   70.0 46.0       0.0               116.0 109 1 1 3             2   70 46                 116
259811 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2018   k_12_total 8.0     20.0                 19.0 9.0       0.0               28.0 8     20                 19 9                 28
259810 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2018   k_12_total 19.0   3.0 25.0                 25.0 22.0       2.1               47.0 19   3 25                 25 22                 47
259809 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School No Elementary PK 05 2018   k_12_total 51.0     41.0             1.0   60.0 33.0       0.0               93.0 51     41             1   60 33                 93
259748 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   k_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0       0.3               627.0 550 5 20 32   6         14   313 314                 627
259747 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   k_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0       0.8               629.0 543 3 27 21   8         27   316 313                 629
259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259745 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   k_12_total 181.0 3.0 8.0 12.0   1.0       1.0 15.0   126.0 95.0       1.4               221.0 181 3 8 12   1       1 15   126 95                 221
259744 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2018   k_12_total 212.0 1.0 3.0 14.0   1.0         7.0   117.0 121.0       0.4               238.0 212 1 3 14   1         7   117 121                 238
259743 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2018   k_12_total 168.0   17.0 22.0             14.0   107.0 114.0       0.0               221.0 168   17 22             14   107 114                 221
259742 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2018   k_12_total 355.0 2.0 11.0 5.0   7.0         6.0   199.0 187.0       2.3               386.0 355 2 11 5   7         6   199 187                 386
259741 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2018   k_12_total 341.0 1.0 17.0 6.0   4.0         11.0   195.0 185.0       1.3               380.0 341 1 17 6   4         11   195 185                 380
259635 SD     school 4676020 6005   Warner 06-5 467602000710 3 Warner Middle Sch   Regular School No Middle 06 08 2018   k_12_total 61.0 1.0 3.0 1.0             2.0   33.0 35.0       0.0               68.0 61 1 3 1             2   33 35                 68
259634 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   k_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0       1.1               94.0 86 2 1 4   1             49 45                 94
259633 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2018   k_12_total 140.0 2.0 2.0 2.0             5.0   73.0 78.0       0.0               151.0 140 2 2 2             5   73 78                 151
259584 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2018   k_12_total 50.0   1.0 5.0                 33.0 23.0       0.0               56.0 50   1 5                 33 23                 56
259583 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2018   k_12_total 58.0     15.0                 36.0 37.0       0.0               73.0 58     15                 36 37                 73
259582 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2018   k_12_total 103.0 2.0 1.0 14.0   1.0         1.0   57.0 65.0       0.0               122.0 103 2 1 14   1         1   57 65                 122
259581 SD     school 4675660 51005   Wall 51-5 467566000779 8 Big White Elementary School   Regular School No Elementary KG 06 2018   k_12_total 6.0                       1.0 5.0       0.0               6.0 6                       1 5                 6
259520 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   k_12_total 26.0   5.0 58.0             9.0   54.0 44.0       0.0               98.0 26   5 58             9   54 44                 98
259519 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   k_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0       0.0               259.0 64   9 159   1         26   128 131                 259
259518 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   k_12_total 62.0   7.0 99.0             14.0   83.0 99.0       0.0               182.0 62   7 99             14   83 99                 182
259517 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2018   k_12_total 77.0   15.0 179.0             37.0   163.0 145.0       0.3               308.0 77   15 179             37   163 145                 308
259456 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No Middle 05 08 2018   k_12_total 82.0 2.0                 2.0   46.0 40.0       0.0               86.0 82 2                 2   46 40                 86
259455 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2018   k_12_total 104.0 1.0 3.0 2.0                 68.0 42.0       1.8               110.0 104 1 3 2                 68 42                 110
259454 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2018   k_12_total 114.0 3.0 4.0 2.0           1.0 3.0   58.0 69.0       1.6               127.0 114 3 4 2           1 3   58 69                 127
259453 SD     school 4674520 60006   Viborg-Hurley 60-6 467452001301 4 Cameron Colony   Regular School No Elementary KG 08 2018   k_12_total 18.0   1.0                   7.0 12.0       57.9               19.0 18   1                   7 12                 19
259392 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   k_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0       1.0               288.0 220 4 13 31   8         12   146 142                 288
259391 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   k_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0       0.3               378.0 303 8 19 39   5       2 2   174 204                 378
259390 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   k_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0       1.2               348.0 257 5 12 39   7       3 25   182 166                 348
259389 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   k_12_total 155.0 5.0 5.0 21.0   5.0         11.0   109.0 93.0       1.5               202.0 155 5 5 21   5         11   109 93                 202
259325 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   k_12_total 20.0     1.0   1.0             11.0 11.0       0.0               22.0 20     1   1             11 11                 22
259324 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School No High 09 12 2018   k_12_total 31.0     3.0                 18.0 16.0       0.0               34.0 31     3                 18 16                 34
259323 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2018   k_12_total 68.0 1.0 2.0 3.0   1.0         1.0   37.0 39.0       0.0               76.0 68 1 2 3   1         1   37 39                 76
259322 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 9.0                       4.0 5.0       44.4               9.0 9                       4 5                 9
259321 SD     school 4672450 33005   Tripp-Delmont 33-5 467245001091 7 Clearfield Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 10.0                       3.0 7.0       50.0               10.0 10                       3 7                 10
259251 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   k_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0       1.4               145.0 125 9 9 1             1   71 74                 145
259250 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2018   k_12_total 226.0 14.0 7.0 1.0   1.0         5.0   148.0 106.0       3.2               254.0 226 14 7 1   1         5   148 106                 254
259249 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2018   k_12_total 442.0 40.0 24.0               11.0   278.0 239.0       7.2               517.0 442 40 24               11   278 239                 517
259176 SD     school 4672090 66001   Todd County 66-1 467209000814 10 Todd County MS   Regular School No Middle 06 08 2018   k_12_total 3.0   1.0 363.0                 188.0 179.0       0.8               367.0 3   1 363                 188 179                 367
259175 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2018   k_12_total 4.0   2.0 449.0   1.0         2.0   242.0 216.0       2.2               458.0 4   2 449   1         2   242 216                 458
259174 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   k_12_total 2.0   15.0 520.0             8.0   276.0 269.0       0.6               545.0 2   15 520             8   276 269                 545
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
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
259171 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2018   k_12_total 1.0     71.0                 30.0 42.0       1.4               72.0 1     71                 30 42                 72
259170 SD     school 4672090 66001   Todd County 66-1 467209000675 4 Rosebud Elementary   Regular School No Elementary KG 05 2018   k_12_total     4.0 271.0             1.0   141.0 135.0       0.7               276.0     4 271             1   141 135                 276
259169 SD     school 4672090 66001   Todd County 66-1 467209000509 14 O'Kreek Elementary   Regular School No Elementary KG 08 2018   k_12_total 1.0     36.0                 20.0 17.0       0.0               37.0 1     36                 20 17                 37
259168 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2018   k_12_total 2.0     33.0                 19.0 16.0       0.0               35.0 2     33                 19 16                 35
259167 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2018   k_12_total 11.0     35.0                 27.0 19.0       2.2               46.0 11     35                 27 19                 46
259166 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2018   k_12_total 5.0   2.0 15.0   1.0             11.0 12.0       4.4               23.0 5   2 15   1             11 12                 23
259165 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2018   k_12_total     2.0 136.0             1.0   71.0 68.0       2.2               139.0     2 136             1   71 68                 139
259011 SD     school 4671880 20003   Timber Lake 20-3 467188000940 3 Timber Lake Middle 6-8   Regular School No Middle 06 08 2018   k_12_total 36.0   1.0 43.0                 47.0 33.0       1.3               80.0 36   1 43                 47 33                 80
259010 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2018   k_12_total 34.0   3.0 60.0                 44.0 53.0       0.0               97.0 34   3 60                 44 53                 97
259009 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2018   k_12_total 75.0 1.0 3.0 96.0                 94.0 81.0       0.0               175.0 75 1 3 96                 94 81                 175
258960 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School No Middle 05 08 2018   k_12_total 471.0 10.0 18.0 6.0             28.0   293.0 240.0       2.1               533.0 471 10 18 6             28   293 240                 533
258959 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   k_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0       1.4               710.0 652 7 19 8   1         23   378 332                 710

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