Data source: Big Local News · About: Big Local

669 rows where grade = "pk_12_total", state = "SD" and year = 2017 sorted by rowid descending

View and edit SQL

year

  • 2017 · 669

grade

  • pk_12_total · 669
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
3016927 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   pk_12_total 503.0 9.0 40.0 35.0   5.0         7.0   315.0 284.0                       599.0 503 9 40 35   5         7   315 284                 599
3016926 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   pk_12_total 788.0 18.0 47.0 31.0   7.0         10.0   464.0 437.0                       901.0 788 18 47 31   7         10   464 437                 901
3016925 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2017   pk_12_total 217.0 6.0 29.0 16.0   3.0         8.0   131.0 148.0                       279.0 217 6 29 16   3         8   131 148                 279
3016924 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2017   pk_12_total 239.0 3.0 15.0 12.0   3.0       1.0 8.0   143.0 138.0                       281.0 239 3 15 12   3       1 8   143 138                 281
3016923 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2017   pk_12_total 290.0 7.0 31.0 14.0   3.0         18.0   190.0 173.0                       363.0 290 7 31 14   3         18   190 173                 363
3016922 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2017   pk_12_total 319.0 7.0 29.0 18.0             13.0   203.0 183.0                       386.0 319 7 29 18             13   203 183                 386
3016835 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2017   pk_12_total 62.0   2.0               1.0   34.0 31.0                       65.0 62   2               1   34 31                 65
3016834 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2017   pk_12_total 145.0   9.0     2.0         7.0   82.0 81.0                       163.0 145   9     2         7   82 81                 163
3016802 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2017   pk_12_total 97.0 5.0 10.0 3.0             6.0   53.0 68.0                       121.0 97 5 10 3             6   53 68                 121
3016801 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2017   pk_12_total 90.0 5.0 5.0 2.0             1.0   69.0 34.0                       103.0 90 5 5 2             1   69 34                 103
3016800 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No Elementary PK 04 2017   pk_12_total 136.0 1.0 13.0               6.0   78.0 78.0                       156.0 136 1 13               6   78 78                 156
3016754 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2017   pk_12_total 106.0 1.0 2.0 42.0   3.0             71.0 83.0                       154.0 106 1 2 42   3             71 83                 154
3016753 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2017   pk_12_total 142.0 1.0 1.0 49.0           1.0 1.0   103.0 92.0                       195.0 142 1 1 49           1 1   103 92                 195
3016752 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School No Elementary PK 05 2017   pk_12_total 206.0 5.0 3.0 143.0   1.0             187.0 171.0                       358.0 206 5 3 143   1             187 171                 358
3016706 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2017   pk_12_total 24.0   1.0 3.0                 16.0 12.0                       28.0 24   1 3                 16 12                 28
3016705 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2017   pk_12_total 51.0   4.0 18.0             2.0   34.0 41.0                       75.0 51   4 18             2   34 41                 75
3016704 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   pk_12_total 84.0 2.0 3.0 25.0             1.0   57.0 58.0                       115.0 84 2 3 25             1   57 58                 115
3016655 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No Middle 06 08 2017   pk_12_total 37.0 1.0 4.0 2.0                 26.0 18.0                       44.0 37 1 4 2                 26 18                 44
3016654 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2017   pk_12_total 49.0   1.0                   27.0 23.0                       50.0 49   1                   27 23                 50
3016653 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2017   pk_12_total 85.0   6.0 2.0                 36.0 57.0                       93.0 85   6 2                 36 57                 93
3016652 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2017   pk_12_total 12.0                       7.0 5.0                       12.0 12                       7 5                 12
3016651 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2017   pk_12_total 16.0                       7.0 9.0                       16.0 16                       7 9                 16
3016650 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2017   pk_12_total 21.0                       11.0 10.0                       21.0 21                       11 10                 21
3016561 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 7.0 2.0   86.0             1.0   49.0 47.0                       96.0 7 2   86             1   49 47                 96
3016560 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2017   pk_12_total 16.0 2.0   87.0   1.0       1.0 1.0   57.0 51.0                       108.0 16 2   87   1       1 1   57 51                 108
3016559 SD     school 4678570 47001   White River 47-1 467857000753 2 White River Elementary   Regular School No Elementary PK 05 2017   pk_12_total 13.0     164.0             4.0   109.0 72.0                       181.0 13     164             4   109 72                 181
3016558 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No Elementary PK 05 2017   pk_12_total       53.0                 34.0 19.0                       53.0       53                 34 19                 53
3016498 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2017   pk_12_total 12.0   3.0                   8.0 7.0                       15.0 12   3                   8 7                 15
3016497 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2017   pk_12_total 34.0   2.0                   20.0 16.0                       36.0 34   2                   20 16                 36
3016496 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2017   pk_12_total 59.0 1.0 6.0             1.0     39.0 28.0                       67.0 59 1 6             1     39 28                 67
3016449 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2017   pk_12_total 302.0 3.0 2.0 9.0             8.0   178.0 146.0                       324.0 302 3 2 9             8   178 146                 324
3016448 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2017   pk_12_total 331.0 6.0 11.0 4.0   1.0         13.0   181.0 185.0                       366.0 331 6 11 4   1         13   181 185                 366
3016447 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2017   pk_12_total 386.0 3.0 3.0 3.0   1.0         6.0   193.0 209.0                       402.0 386 3 3 3   1         6   193 209                 402
3016446 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2017   pk_12_total 237.0   4.0 5.0             4.0   128.0 122.0                       250.0 237   4 5             4   128 122                 250
3016384 SD     school 4677460 36002   Wessington Springs 36-2 467746000076 4 Wessington Springs MS   Regular School No Middle 07 08 2017   pk_12_total 38.0                       25.0 13.0                       38.0 38                       25 13                 38
3016383 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Alternative School No High 09 12 2017   pk_12_total 19.0   3.0 5.0                 18.0 9.0                       27.0 19   3 5                 18 9                 27
3016382 SD     school 4677460 36002   Wessington Springs 36-2 467746000733 1 Wessington Springs Hi Sch   Regular School No High 09 12 2017   pk_12_total 64.0   2.0                   33.0 33.0                       66.0 64   2                   33 33                 66
3016381 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2017   pk_12_total 164.0   16.0               1.0   93.0 88.0                       181.0 164   16               1   93 88                 181
3016380 SD     school 4677460 36002   Wessington Springs 36-2 467746000731 5 Spring Valley Elementary   Regular School No Elementary KG 08 2017   pk_12_total 41.0                       20.0 21.0                       41.0 41                       20 21                 41
3016306 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2017   pk_12_total 116.0   1.0 1.0             2.0   57.0 63.0                       120.0 116   1 1             2   57 63                 120
3016305 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2017   pk_12_total 153.0   2.0 2.0             1.0   86.0 72.0                       158.0 153   2 2             1   86 72                 158
3016304 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 267.0   8.0 6.0   1.0       1.0 15.0   151.0 147.0                       298.0 267   8 6   1       1 15   151 147                 298
3016258 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2017   pk_12_total 51.0   1.0 3.0             3.0   31.0 27.0                       58.0 51   1 3             3   31 27                 58
3016257 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2017   pk_12_total 71.0   3.0 5.0   1.0         2.0   43.0 39.0                       82.0 71   3 5   1         2   43 39                 82
3016256 SD     school 4676740 14005   Waverly 14-5 467674000721 2 Waverly/South Shore Elementary   Regular School No Elementary PK 05 2017   pk_12_total 111.0 1.0 1.0 3.0             2.0   63.0 55.0                       118.0 111 1 1 3             2   63 55                 118
3016210 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2017   pk_12_total 7.0   2.0 27.0                 25.0 11.0                       36.0 7   2 27                 25 11                 36
3016209 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2017   pk_12_total 23.0   1.0 21.0                 22.0 23.0                       45.0 23   1 21                 22 23                 45
3016208 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School No Elementary PK 05 2017   pk_12_total 51.0     42.0             2.0   62.0 33.0                       95.0 51     42             2   62 33                 95
3016157 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2017   pk_12_total 557.0 4.0 18.0 32.0   5.0         8.0   307.0 317.0                       624.0 557 4 18 32   5         8   307 317                 624
3016156 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2017   pk_12_total 537.0 7.0 22.0 19.0   8.0         19.0   308.0 304.0                       612.0 537 7 22 19   8         19   308 304                 612
3016155 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   pk_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0                       1232.0 1114 9 45 37   9         18   644 588                 1232
3016154 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2017   pk_12_total 231.0 4.0 12.0 16.0             13.0   161.0 115.0                       276.0 231 4 12 16             13   161 115                 276
3016153 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2017   pk_12_total 198.0 1.0 3.0 6.0   1.0         8.0   97.0 120.0                       217.0 198 1 3 6   1         8   97 120                 217
3016152 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2017   pk_12_total 190.0   18.0 26.0           1.0 19.0   127.0 127.0                       254.0 190   18 26           1 19   127 127                 254
3016151 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2017   pk_12_total 351.0 4.0 9.0 5.0   4.0         9.0   193.0 189.0                       382.0 351 4 9 5   4         9   193 189                 382
3016150 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2017   pk_12_total 352.0 2.0 19.0 4.0   5.0         9.0   203.0 188.0                       391.0 352 2 19 4   5         9   203 188                 391
3016034 SD     school 4676020 6005   Warner 06-5 467602000710 3 Warner Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 72.0   3.0               2.0   44.0 33.0                       77.0 72   3               2   44 33                 77
3016033 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2017   pk_12_total 85.0 2.0 1.0 6.0   1.0         1.0   48.0 48.0                       96.0 85 2 1 6   1         1   48 48                 96
3016032 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 138.0 1.0 3.0 3.0             1.0   62.0 84.0                       146.0 138 1 3 3             1   62 84                 146
3015985 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2017   pk_12_total 41.0     8.0                 28.0 21.0                       49.0 41     8                 28 21                 49
3015984 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2017   pk_12_total 63.0     11.0             1.0   36.0 39.0                       75.0 63     11             1   36 39                 75
3015983 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 93.0 2.0   18.0   1.0         1.0   54.0 61.0                       115.0 93 2   18   1         1   54 61                 115
3015982 SD     school 4675660 51005   Wall 51-5 467566000779 8 Big White Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
3015921 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2017   pk_12_total 73.0   9.0 134.0             19.0   131.0 104.0                       235.0 73   9 134             19   131 104                 235
3015920 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2017   pk_12_total 69.0   7.0 147.0   1.0         19.0   110.0 133.0                       243.0 69   7 147   1         19   110 133                 243
3015919 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2017   pk_12_total 73.0 2.0 9.0 131.0             10.0   98.0 127.0                       225.0 73 2 9 131             10   98 127                 225
3015918 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2017   pk_12_total 69.0   12.0 169.0             34.0   149.0 135.0                       284.0 69   12 169             34   149 135                 284
3015857 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No Middle 05 08 2017   pk_12_total 95.0 3.0   1.0             2.0   62.0 39.0                       101.0 95 3   1             2   62 39                 101
3015856 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2017   pk_12_total 105.0 1.0 1.0 2.0   1.0             66.0 44.0                       110.0 105 1 1 2   1             66 44                 110
3015855 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2017   pk_12_total 126.0 2.0 5.0 1.0           1.0 5.0   72.0 68.0                       140.0 126 2 5 1           1 5   72 68                 140
3015854 SD     school 4674520 60006   Viborg-Hurley 60-6 467452001301 4 Cameron Colony   Regular School No Elementary KG 08 2017   pk_12_total 22.0   1.0                   9.0 14.0                       23.0 22   1                   9 14                 23
3015793 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2017   pk_12_total 228.0 6.0 13.0 26.0   4.0         8.0   144.0 141.0                       285.0 228 6 13 26   4         8   144 141                 285
3015792 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2017   pk_12_total 305.0 7.0 18.0 44.0   8.0       1.0 6.0   189.0 200.0                       389.0 305 7 18 44   8       1 6   189 200                 389
3015791 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2017   pk_12_total 265.0 6.0 15.0 34.0   7.0       1.0 25.0   179.0 174.0                       353.0 265 6 15 34   7       1 25   179 174                 353
3015790 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 168.0 2.0 9.0 17.0   5.0         15.0   109.0 107.0                       216.0 168 2 9 17   5         15   109 107                 216
3015728 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2017   pk_12_total 13.0     3.0                 12.0 4.0                       16.0 13     3                 12 4                 16
3015727 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School No High 09 12 2017   pk_12_total 34.0     4.0                 19.0 19.0                       38.0 34     4                 19 19                 38
3015726 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2017   pk_12_total 70.0   2.0 8.0   2.0         1.0   40.0 43.0                       83.0 70   2 8   2         1   40 43                 83
3015725 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 10.0                       5.0 5.0                       10.0 10                       5 5                 10
3015724 SD     school 4672450 33005   Tripp-Delmont 33-5 467245001091 7 Clearfield Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 10.0                       4.0 6.0                       10.0 10                       4 6                 10
3015650 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2017   pk_12_total 124.0 6.0 5.0               3.0   76.0 62.0                       138.0 124 6 5               3   76 62                 138
3015649 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2017   pk_12_total 225.0 12.0 3.0     1.0         5.0   130.0 116.0                       246.0 225 12 3     1         5   130 116                 246
3015648 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2017   pk_12_total 448.0 35.0 26.0               7.0   273.0 243.0                       516.0 448 35 26               7   273 243                 516
3015594 SD     school 4672090 66001   Todd County 66-1 467209000814 10 Todd County MS   Regular School No Middle 06 08 2017   pk_12_total 2.0     366.0   1.0             193.0 176.0                       369.0 2     366   1             193 176                 369
3015593 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2017   pk_12_total 5.0   2.0 410.0   1.0         4.0   222.0 200.0                       422.0 5   2 410   1         4   222 200                 422
3015592 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2017   pk_12_total 3.0   6.0 574.0   1.0       1.0 4.0   285.0 304.0                       589.0 3   6 574   1       1 4   285 304                 589
3015591 SD     school 4672090 66001   Todd County 66-1 467209001376 17 Todd County Achievement School   Alternative School No High 07 12 2017   pk_12_total       18.0                 9.0 9.0                       18.0       18                 9 9                 18
3015590 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2017   pk_12_total       70.0             1.0   36.0 35.0                       71.0       70             1   36 35                 71
3015589 SD     school 4672090 66001   Todd County 66-1 467209000675 4 Rosebud Elementary   Regular School No Elementary KG 05 2017   pk_12_total     4.0 258.0             2.0   138.0 126.0                       264.0     4 258             2   138 126                 264
3015588 SD     school 4672090 66001   Todd County 66-1 467209000509 14 O'Kreek Elementary   Regular School No Elementary KG 08 2017   pk_12_total 1.0     44.0                 23.0 22.0                       45.0 1     44                 23 22                 45
3015587 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2017   pk_12_total 2.0     37.0             1.0   19.0 21.0                       40.0 2     37             1   19 21                 40
3015586 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2017   pk_12_total 9.0     37.0             1.0   23.0 24.0                       47.0 9     37             1   23 24                 47
3015585 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2017   pk_12_total 7.0     15.0   1.0             8.0 15.0                       23.0 7     15   1             8 15                 23
3015584 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2017   pk_12_total     3.0 137.0             1.0   77.0 64.0                       141.0     3 137             1   77 64                 141
3015426 SD     school 4671880 20003   Timber Lake 20-3 467188000940 3 Timber Lake Middle 6-8   Regular School No Middle 06 08 2017   pk_12_total 33.0   1.0 49.0                 41.0 42.0                       83.0 33   1 49                 41 42                 83
3015425 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2017   pk_12_total 28.0   1.0 60.0                 40.0 49.0                       89.0 28   1 60                 40 49                 89
3015424 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2017   pk_12_total 80.0 1.0 5.0 99.0             2.0   104.0 83.0                       187.0 80 1 5 99             2   104 83                 187
3015377 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2017   pk_12_total 628.0 6.0 9.0 7.0   1.0         25.0   357.0 319.0                       676.0 628 6 9 7   1         25   357 319                 676
3015376 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Intermediate/Middle School   Regular School No Middle 05 08 2017   pk_12_total 423.0 12.0 12.0 8.0           1.0 21.0   274.0 203.0                       477.0 423 12 12 8           1 21   274 203                 477
3015375 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2017   pk_12_total 407.0 6.0 9.0 7.0   1.0         19.0   238.0 211.0                       449.0 407 6 9 7   1         19   238 211                 449

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