Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by female descending

View and edit SQL

grade

year

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
2965248 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No 1 KG 06 2015   pk_12_total 167.0 2.0 2.0 30.0   1.0         5.0   108.0 99.0                       207.0 167 2 2 30   1         5   108 99                 207
2966232 SD     school 4635480 2002   Huron 02-2 463548001322 9 Huron Elem   Regular School No 1 KG 05 2015   kindergarten 96.0 2.0 65.0 2.0   40.0       0.0 7.0   113.0 99.0                       212.0 96 2 65 2   40       0 7   113 99                 212
2966936 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Middle School   Regular School No 2 06 08 2015   k_12_total 205.0   1.0 3.0             3.0   113.0 99.0                       212.0 205   1 3             3   113 99                 212
2966944 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Middle School   Regular School No 2 06 08 2015   pk_12_total 205.0   1.0 3.0             3.0   113.0 99.0                       212.0 205   1 3             3   113 99                 212
2968905 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No 2 06 08 2015   grade_7 143.0 4.0 10.0 33.0   0.0         9.0   100.0 99.0                       199.0 143 4 10 33   0         9   100 99                 199
3347875 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No 3 09 12 2016   k_12_total 169.0 5.0 1.0 2.0   2.0             80.0 99.0                       179.0 169 5 1 2   2             80 99                 179
3347881 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No 3 09 12 2016   pk_12_total 169.0 5.0 1.0 2.0   2.0             80.0 99.0                       179.0 169 5 1 2   2             80 99                 179
3354756 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2016   grade_12 202.0 4.0 16.0 3.0   4.0         4.0   134.0 99.0                       233.0 202 4 16 3   4         4   134 99                 233
3007480 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   grade_12 166.0 5.0 7.0 1.0   7.0       0.0 2.0   89.0 99.0                       188.0 166 5 7 1   7       0 2   89 99                 188
3008889 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2017   k_12_total 2.0   3.0 215.0                 121.0 99.0       2.3               220.0 2   3 215                 121 99                 220
3008897 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2017   pk_12_total 2.0   3.0 215.0                 121.0 99.0                       220.0 2   3 215                 121 99                 220
3012218 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2017   grade_9 188.0 0.0 4.0 9.0   0.0       1.0 8.0   111.0 99.0                       210.0 188 0 4 9   0       1 8   111 99                 210
3013006 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School - 01   Regular School No Elementary PK 08 2017   k_12_total 1.0     184.0             1.0   87.0 99.0       1.1               186.0 1     184             1   87 99                 186
3016913 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2017   k_12_total 135.0 4.0 23.0 14.0   1.0         4.0   82.0 99.0       2.2               181.0 135 4 23 14   1         4   82 99                 181
252290 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   grade_10 144.0 3.0 19.0 15.0   4.0       0.0 12.0   98.0 99.0                       197.0 144 3 19 15   4       0 12   98 99                 197
254151 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   pk_12_total 133.0   47.0 5.0             9.0   95.0 99.0                       194.0 133   47 5             9   95 99                 194
256096 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   grade_7 186.0 1.0 7.0 10.0   2.0       0.0 6.0   113.0 99.0                       212.0 186 1 7 10   2       0 6   113 99                 212
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
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
357137 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2019   grade_6 141.0 3.0 16.0 10.0   8.0       1.0 11.0   91.0 99.0                       190.0 141 3 16 10   8       1 11   91 99                 190
364147 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2019   grade_9 153.0 3.0 6.0 30.0   1.0         28.0   122.0 99.0                       221.0 153 3 6 30   1         28   122 99                 221
365836 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2019   k_12_total 87.0 2.0 11.0 108.0   2.0         12.0   123.0 99.0       0.9               222.0 87 2 11 108   2         12   123 99                 222
365842 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2019   pk_12_total 87.0 2.0 11.0 108.0   2.0         12.0   123.0 99.0                       222.0 87 2 11 108   2         12   123 99                 222
366005 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2019   grade_9 169.0 1.0 13.0 12.0   1.0       1.0 4.0   102.0 99.0                       201.0 169 1 13 12   1       1 4   102 99                 201
489689 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 224.0 2.0 12.0 3.0           1.0     143.0 99.0       0.8               242.0 224 2 12 3           1     143 99                 242
489992 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   k_12_total 1.0     225.0   1.0       1.0     129.0 99.0       0.0               228.0 1     225   1       1     129 99                 228
490000 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   pk_12_total 1.0     225.0   1.0       1.0     129.0 99.0                       228.0 1     225   1       1     129 99                 228
490235 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School Not applicable Elementary PK 06 2020   pk_12_total 158.0   34.0 1.0           1.0 9.0   104.0 99.0                       203.0 158   34 1           1 9   104 99                 203
494382 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   grade_10 150.0 3.0 4.0 26.0   1.0         31.0   116.0 99.0                       215.0 150 3 4 26   1         31   116 99                 215
494392 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   grade_12 156.0 0.0 6.0 17.0   2.0         9.0   91.0 99.0                       190.0 156 0 6 17   2         9   91 99                 190
494831 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School Not applicable Middle 06 08 2020   grade_6 120.0 1.0 24.0 46.0   2.0         30.0   124.0 99.0                       223.0 120 1 24 46   2         30   124 99                 223
498064 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 176.0 0.0 15.0 6.0   2.0         8.0   108.0 99.0                       207.0 176 0 15 6   2         8   108 99                 207
498080 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 134.0 2.0 21.0 12.0   2.0         17.0   89.0 99.0       3.2               188.0 134 2 21 12   2         17   89 99                 188
449019 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 143.0 1.0 18.0 12.0   7.0       1.0 8.0   91.0 99.0                       190.0 143 1 18 12   7       1 8   91 99                 190
449170 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 183.0   7.0 2.0   1.0         5.0   99.0 99.0       0.5               198.0 183   7 2   1         5   99 99                 198
451417 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School Not applicable Elementary 04 05 2021   grade_4 145.0 3.0 20.0 12.0   4.0       1.0 28.0   114.0 99.0                       213.0 145 3 20 12   4       1 28   114 99                 213
451796 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School Not applicable Elementary PK 06 2021   pk_12_total 150.0   36.0               7.0   94.0 99.0                       193.0 150   36               7   94 99                 193
454177 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 147.0 4.0 6.0 13.0   3.0         7.0   81.0 99.0       1.1               180.0 147 4 6 13   3         7   81 99                 180
454185 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 147.0 4.0 6.0 13.0   3.0         7.0   81.0 99.0                       180.0 147 4 6 13   3         7   81 99                 180
456573 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School Not applicable Elementary KG 05 2021   pk_12_total 163.0 2.0 14.0 22.0             23.0   125.0 99.0                       224.0 163 2 14 22             23   125 99                 224
458058 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 120.0 14.0 31.0 2.0   4.0         16.0   88.0 99.0       12.3               187.0 120 14 31 2   4         16   88 99                 187
458068 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 120.0 14.0 31.0 2.0   4.0         16.0   88.0 99.0                       187.0 120 14 31 2   4         16   88 99                 187
2961695 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   grade_6 160.0 2.0 4.0 10.0   2.0       0.0 1.0   81.0 98.0                       179.0 160 2 4 10   2       0 1   81 98                 179
2965242 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No 1 KG 06 2015   k_12_total 165.0 2.0 2.0 30.0   1.0         5.0   107.0 98.0                       205.0 165 2 2 30   1         5   107 98                 205
2967798 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No 3 09 12 2015   grade_9 160.0 1.0 7.0 15.0   2.0       1.0 2.0   90.0 98.0                       188.0 160 1 7 15   2       1 2   90 98                 188
2972300 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   grade_9 173.0 3.0 13.0 8.0   2.0         1.0   102.0 98.0                       200.0 173 3 13 8   2         1   102 98                 200
3346662 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 138.0 5.0 20.0 17.0   2.0       2.0 23.0   109.0 98.0                       207.0 138 5 20 17   2       2 23   109 98                 207
3352835 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No 3 09 12 2016   k_12_total 193.0   6.0 2.0   2.0             105.0 98.0                       203.0 193   6 2   2             105 98                 203
3352841 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No 3 09 12 2016   pk_12_total 193.0   6.0 2.0   2.0             105.0 98.0                       203.0 193   6 2   2             105 98                 203
3353045 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2016   grade_2 177.0 2.0 8.0 5.0   0.0       0.0 6.0   100.0 98.0                       198.0 177 2 8 5   0       0 6   100 98                 198
3016897 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   grade_7 177.0 4.0 12.0 10.0   4.0         3.0   112.0 98.0                       210.0 177 4 12 10   4         3   112 98                 210
251282 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2018   k_12_total 192.0 3.0 4.0 1.0   1.0         6.0   109.0 98.0       0.5               207.0 192 3 4 1   1         6   109 98                 207
251288 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2018   pk_12_total 192.0 3.0 4.0 1.0   1.0         6.0   109.0 98.0                       207.0 192 3 4 1   1         6   109 98                 207
253634 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No High 09 12 2018   k_12_total 199.0 1.0 3.0     1.0         1.0   107.0 98.0       0.0               205.0 199 1 3     1         1   107 98                 205
253640 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No High 09 12 2018   pk_12_total 199.0 1.0 3.0     1.0         1.0   107.0 98.0                       205.0 199 1 3     1         1   107 98                 205
254145 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   k_12_total 132.0   44.0 5.0             9.0   92.0 98.0       7.4               190.0 132   44 5             9   92 98                 190
255769 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School No Middle 06 08 2018   grade_7 169.0 0.0 12.0 8.0   1.0         10.0   102.0 98.0                       200.0 169 0 12 8   1         10   102 98                 200
256832 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   grade_12 155.0 0.0 11.0 10.0   1.0       0.0 5.0   84.0 98.0                       182.0 155 0 11 10   1       0 5   84 98                 182
257296 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2018   grade_7 138.0 2.0 21.0 46.0   0.0         11.0   120.0 98.0                       218.0 138 2 21 46   0         11   120 98                 218
257301 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   grade_7 170.0 1.0 23.0 8.0   4.0         6.0   114.0 98.0                       212.0 170 1 23 8   4         6   114 98                 212
260510 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_8 179.0 4.0 9.0 13.0   3.0         3.0   113.0 98.0                       211.0 179 4 9 13   3         3   113 98                 211
358541 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2019   k_12_total 207.0 2.0 3.0 2.0             3.0   119.0 98.0       0.0               217.0 207 2 3 2             3   119 98                 217
358547 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2019   pk_12_total 207.0 2.0 3.0 2.0             3.0   119.0 98.0                       217.0 207 2 3 2             3   119 98                 217
359583 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   grade_5 164.0 3.0 25.0 12.0   1.0       1.0 20.0   128.0 98.0                       226.0 164 3 25 12   1       1 20   128 98                 226
366745 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2019   k_12_total 57.0   6.0 101.0   1.0         16.0   83.0 98.0       0.0               181.0 57   6 101   1         16   83 98                 181
366753 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2019   pk_12_total 57.0   6.0 101.0   1.0         16.0   83.0 98.0                       181.0 57   6 101   1         16   83 98                 181
366972 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2019   k_12_total 181.0 2.0 6.0 12.0   1.0         12.0   116.0 98.0       0.9               214.0 181 2 6 12   1         12   116 98                 214
367763 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2019   grade_7 169.0 3.0 17.0 13.0   0.0         11.0   115.0 98.0                       213.0 169 3 17 13   0         11   115 98                 213
491941 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School Not applicable Elementary 04 05 2020   grade_4 96.0 3.0 72.0 6.0   55.0       1.0 6.0   141.0 98.0                       239.0 96 3 72 6   55       1 6   141 98                 239
493574 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   grade_11 163.0 3.0 7.0 7.0   1.0       0.0 4.0   87.0 98.0                       185.0 163 3 7 7   1       0 4   87 98                 185
494825 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School Not applicable Middle 06 08 2020   grade_6 35.0 1.0 23.0 97.0   1.0         28.0   87.0 98.0                       185.0 35 1 23 97   1         28   87 98                 185
494836 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School Not applicable Middle 06 08 2020   grade_6 146.0 2.0 14.0 23.0   1.0         25.0   113.0 98.0                       211.0 146 2 14 23   1         25   113 98                 211
456426 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2021   grade_6 172.0 0.0 9.0 13.0   5.0       0.0 15.0   116.0 98.0                       214.0 172 0 9 13   5       0 15   116 98                 214
459636 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   grade_12 178.0 2.0 19.0 8.0   2.0         2.0   113.0 98.0                       211.0 178 2 19 8   2         2   113 98                 211
3352667 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   k_12_total 1213.0 311.0 187.0 84.0   148.0         59.0   1031.0 971.0       11.8               2002.0 1213 311 187 84   148         59   1031 971                 2002
3352753 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   pk_12_total 1213.0 311.0 187.0 84.0   148.0         59.0   1031.0 971.0                       2002.0 1213 311 187 84   148         59   1031 971                 2002
364630 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2019   k_12_total 1188.0 33.0 120.0 366.0   26.0       1.0 153.0   916.0 971.0       1.0               1887.0 1188 33 120 366   26       1 153   916 971                 1887
364680 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2019   pk_12_total 1188.0 33.0 120.0 366.0   26.0       1.0 153.0   916.0 971.0                       1887.0 1188 33 120 366   26       1 153   916 971                 1887
3345382 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No 1 PK 06 2016   k_12_total 182.0 3.0 6.0 7.0   2.0         8.0   111.0 97.0       0.0               208.0 182 3 6 7   2         8   111 97                 208
3345394 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No 1 PK 06 2016   pk_12_total 182.0 3.0 6.0 7.0   2.0         8.0   111.0 97.0                       208.0 182 3 6 7   2         8   111 97                 208
3348751 SD     school 4635480 2002   Huron 02-2 463548001322 9 Huron Elem   Regular School No 1 KG 05 2016   grade_1 94.0 1.0 61.0 5.0   39.0       0.0 7.0   110.0 97.0                       207.0 94 1 61 5   39       0 7   110 97                 207
3348968 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No 1 PK 06 2016   pk_12_total 181.0   1.0 3.0             1.0   89.0 97.0                       186.0 181   1 3             1   89 97                 186
3350378 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2016   grade_6 179.0 1.0 3.0 5.0   6.0       1.0 1.0   99.0 97.0                       196.0 179 1 3 5   6       1 1   99 97                 196
3350398 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No 3 09 12 2016   grade_9 190.0 3.0 10.0 5.0   1.0         0.0   112.0 97.0                       209.0 190 3 10 5   1         0   112 97                 209
3013300 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2017   grade_7 151.0 4.0 6.0 27.0   1.0         25.0   117.0 97.0                       214.0 151 4 6 27   1         25   117 97                 214
3013764 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2017   grade_8 186.0 1.0 10.0 5.0   3.0         7.0   115.0 97.0                       212.0 186 1 10 5   3         7   115 97                 212
3015147 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2017   grade_3 177.0 1.0 10.0 6.0   0.0         5.0   102.0 97.0                       199.0 177 1 10 6   0         5   102 97                 199
3016854 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   grade_11 171.0 3.0 16.0 3.0   3.0         1.0   100.0 97.0                       197.0 171 3 16 3   3         1   100 97                 197
250147 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   pk_12_total 46.0   8.0 110.0             26.0   93.0 97.0                       190.0 46   8 110             26   93 97                 190
253915 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   grade_8 167.0 1.0 8.0 1.0   4.0         5.0   89.0 97.0                       186.0 167 1 8 1   4         5   89 97                 186
254429 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   grade_2 94.0 2.0 70.0 3.0   53.0         9.0   134.0 97.0                       231.0 94 2 70 3   53         9   134 97                 231
257326 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   grade_8 185.0 0.0 13.0 9.0   2.0         12.0   124.0 97.0                       221.0 185 0 13 9   2         12   124 97                 221
357308 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2019   k_12_total 177.0   8.0 0.0   1.0         7.0   96.0 97.0       0.5               193.0 177   8 0   1         7   96 97                 193
358330 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   grade_12 165.0 5.0 10.0 2.0   9.0       0.0 5.0   99.0 97.0                       196.0 165 5 10 2   9       0 5   99 97                 196
361809 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No Elementary PK 05 2019   k_12_total 157.0 1.0 6.0 2.0   1.0         3.0   73.0 97.0       0.0               170.0 157 1 6 2   1         3   73 97                 170
364576 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2019   grade_7 154.0 2.0 16.0 14.0   0.0       0.0 25.0   114.0 97.0                       211.0 154 2 16 14   0       0 25   114 97                 211
487432 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 145.0 3.0 17.0 13.0   6.0       1.0 9.0   97.0 97.0                       194.0 145 3 17 13   6       1 9   97 97                 194
489864 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 148.0 4.0 10.0 15.0   4.0       3.0 17.0   104.0 97.0                       201.0 148 4 10 15   4       3 17   104 97                 201
491966 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 100.0 3.0 45.0 3.0   48.0       1.0 5.0   108.0 97.0                       205.0 100 3 45 3   48       1 5   108 97                 205
492090 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School Not applicable Elementary PK 05 2020   pk_12_total 165.0 1.0 5.0 2.0   1.0         1.0   78.0 97.0                       175.0 165 1 5 2   1         1   78 97                 175

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