Data source: Big Local News · About: Big Local

671 rows where grade = "pk_12_total", state = "SD" and year = 2018 sorted by rowid 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
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
260531 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   pk_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0                       273.0 228 5 19 9   6         6   137 136                 273
260530 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2018   pk_12_total 298.0 4.0 25.0 18.0   2.0         13.0   179.0 181.0                       360.0 298 4 25 18   2         13   179 181                 360
260529 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   pk_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0                       392.0 334 8 23 13   2         12   207 185                 392
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
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
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
260259 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2018   pk_12_total 13.0                       6.0 7.0                       13.0 13                       6 7                 13
260258 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 16.0                       6.0 10.0                       16.0 16                       6 10                 16
260257 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 22.0                       12.0 10.0                       22.0 22                       12 10                 22
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
260165 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No Elementary PK 05 2018   pk_12_total       47.0                 29.0 18.0                       47.0       47                 29 18                 47
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
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
259987 SD     school 4677460 36002   Wessington Springs 36-2 467746000731 5 Spring Valley Elementary   Regular School No Elementary KG 08 2018   pk_12_total 40.0                       19.0 21.0                       40.0 40                       19 21                 40
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
259761 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   pk_12_total 208.0 3.0 13.0 12.0   2.0       1.0 16.0   144.0 111.0                       255.0 208 3 13 12   2       1 16   144 111                 255
259760 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2018   pk_12_total 212.0 1.0 3.0 14.0   1.0         7.0   117.0 121.0                       238.0 212 1 3 14   1         7   117 121                 238
259759 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2018   pk_12_total 191.0   18.0 22.0             18.0   117.0 132.0                       249.0 191   18 22             18   117 132                 249
259758 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2018   pk_12_total 355.0 2.0 11.0 5.0   7.0         6.0   199.0 187.0                       386.0 355 2 11 5   7         6   199 187                 386
259757 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2018   pk_12_total 341.0 1.0 17.0 6.0   4.0         11.0   195.0 185.0                       380.0 341 1 17 6   4         11   195 185                 380
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
259589 SD     school 4675660 51005   Wall 51-5 467566000779 8 Big White Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
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
259461 SD     school 4674520 60006   Viborg-Hurley 60-6 467452001301 4 Cameron Colony   Regular School No Elementary KG 08 2018   pk_12_total 18.0   1.0                   7.0 12.0                       19.0 18   1                   7 12                 19
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
259398 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   pk_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0                       348.0 257 5 12 39   7       3 25   182 166                 348
259397 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 202.0 5.0 7.0 21.0   6.0         13.0   130.0 124.0                       254.0 202 5 7 21   6         13   130 124                 254
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
259332 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 9.0                       4.0 5.0                       9.0 9                       4 5                 9
259331 SD     school 4672450 33005   Tripp-Delmont 33-5 467245001091 7 Clearfield Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 10.0                       3.0 7.0                       10.0 10                       3 7                 10
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
259195 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2018   pk_12_total 1.0     71.0                 30.0 42.0                       72.0 1     71                 30 42                 72
259194 SD     school 4672090 66001   Todd County 66-1 467209000675 4 Rosebud Elementary   Regular School No Elementary KG 05 2018   pk_12_total     4.0 271.0             1.0   141.0 135.0                       276.0     4 271             1   141 135                 276
259193 SD     school 4672090 66001   Todd County 66-1 467209000509 14 O'Kreek Elementary   Regular School No Elementary KG 08 2018   pk_12_total 1.0     36.0                 20.0 17.0                       37.0 1     36                 20 17                 37
259192 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2018   pk_12_total 2.0     33.0                 19.0 16.0                       35.0 2     33                 19 16                 35
259191 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2018   pk_12_total 11.0     35.0                 27.0 19.0                       46.0 11     35                 27 19                 46
259190 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2018   pk_12_total 5.0   2.0 15.0   1.0             11.0 12.0                       23.0 5   2 15   1             11 12                 23
259189 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2018   pk_12_total     2.0 136.0             1.0   71.0 68.0                       139.0     2 136             1   71 68                 139
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
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

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