Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • k_12_total · 4,696
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
250445 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2018   k_12_total 357.0   28.0 5.0             18.0   224.0 184.0       1.2               408.0 357   28 5             18   224 184                 408
258788 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   k_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0       0.8               365.0 315 5 18 9   5         13   195 170                 365
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
357688 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2019   k_12_total 360.0   22.0 6.0             23.0   213.0 198.0       1.2               411.0 360   22 6             23   213 198                 411
366015 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2019   k_12_total 298.0 3.0 16.0 6.0   5.0         14.0   163.0 179.0       0.6               342.0 298 3 16 6   5         14   163 179                 342
366744 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2019   k_12_total 87.0   11.0 174.0             33.0   161.0 144.0       0.0               305.0 87   11 174             33   161 144                 305
449534 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2021   k_12_total 343.0   29.0 15.0             20.0   193.0 214.0       0.3               407.0 343   29 15             20   193 214                 407
457877 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2021   k_12_total 268.0 1.0 13.0 5.0   3.0         12.0   154.0 148.0       0.3               302.0 268 1 13 5   3         12   154 148                 302
487957 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   k_12_total 344.0   25.0 12.0             22.0   196.0 207.0       0.7               403.0 344   25 12             22   196 207                 403
496300 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   k_12_total 275.0 1.0 17.0 5.0   2.0         6.0   144.0 162.0       0.7               306.0 275 1 17 5   2         6   144 162                 306
2962214 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No 1 01 04 2015   k_12_total 370.0   31.0 5.0             19.0   224.0 201.0                       425.0 370   31 5             19   224 201                 425
2970541 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   k_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2971302 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2015   k_12_total 72.0   11.0 167.0             24.0   133.0 141.0                       274.0 72   11 167             24   133 141                 274
3006854 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2017   k_12_total 355.0 1.0 23.0 6.0             18.0   222.0 181.0       1.0               403.0 355 1 23 6             18   222 181                 403
3015200 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2017   k_12_total 310.0 4.0 13.0 10.0   5.0       1.0 10.0   206.0 147.0       0.9               353.0 310 4 13 10   5       1 10   206 147                 353
3015910 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2017   k_12_total 69.0   12.0 169.0             34.0   149.0 135.0       0.7               284.0 69   12 169             34   149 135                 284
3344766 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No 1 01 04 2016   k_12_total 378.0 1.0 27.0 5.0             23.0   227.0 207.0                       434.0 378 1 27 5             23   227 207                 434
3353109 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2016   k_12_total 332.0 4.0 16.0 6.0   4.0       1.0 10.0   204.0 169.0       0.9               373.0 332 4 16 6   4       1 10   204 169                 373
3353822 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2016   k_12_total 64.0   10.0 186.0             33.0   159.0 134.0       0.7               293.0 64   10 186             33   159 134                 293
254485 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   k_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0       41.7               432.0 190 4 126 7   92         13   245 187                 432
258326 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No Elementary 02 05 2018   k_12_total 126.0 4.0 4.0 1.0   13.0         8.0   85.0 71.0       0.6               156.0 126 4 4 1   13         8   85 71                 156
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
361712 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   k_12_total 183.0 9.0 146.0 10.0   100.0       2.0 14.0   254.0 210.0       44.4               464.0 183 9 146 10   100       2 14   254 210                 464
365589 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No Elementary 02 05 2019   k_12_total 141.0 8.0 5.0 1.0   9.0         11.0   87.0 88.0       0.0               175.0 141 8 5 1   9         11   87 88                 175
366617 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2019   k_12_total 267.0 10.0 13.0 28.0   9.0         28.0   191.0 164.0       1.1               355.0 267 10 13 28   9         28   191 164                 355
453558 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   k_12_total 163.0 2.0 137.0 14.0   119.0       2.0 14.0   247.0 204.0       43.5               451.0 163 2 137 14   119       2 14   247 204                 451
457450 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2021   k_12_total 135.0 1.0 4.0 1.0   10.0         13.0   88.0 76.0       0.6               164.0 135 1 4 1   10         13   88 76                 164
458495 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2021   k_12_total 264.0 8.0 11.0 33.0   7.0         22.0   170.0 175.0       1.2               345.0 264 8 11 33   7         22   170 175                 345
491981 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   k_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0       44.8               478.0 166 8 156 11   119       2 16   253 225                 478
495873 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   k_12_total 140.0 6.0 6.0 1.0   11.0         14.0   89.0 89.0       0.0               178.0 140 6 6 1   11         14   89 89                 178
496918 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   k_12_total 270.0 9.0 8.0 40.0   5.0         22.0   189.0 165.0       1.4               354.0 270 9 8 40   5         22   189 165                 354
2964066 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2015   k_12_total 332.0 13.0 37.0 22.0   7.0       1.0 47.0   238.0 221.0                       459.0 332 13 37 22   7       1 47   238 221                 459
2969110 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S Mickelson Alternative   Alternative Education School No 4 02 12 2015   k_12_total 21.0 1.0   8.0                 22.0 8.0                       30.0 21 1   8                 22 8                 30
2971175 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2015   k_12_total 258.0 8.0 16.0 41.0   8.0         12.0   177.0 166.0                       343.0 258 8 16 41   8         12   177 166                 343
3008770 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No Elementary 02 03 2017   k_12_total 354.0 11.0 49.0 33.0   3.0         42.0   249.0 243.0       0.6               492.0 354 11 49 33   3         42   249 243                 492
3010942 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2017   k_12_total 193.0 5.0 104.0 6.0   81.0         12.0   226.0 175.0       38.7               401.0 193 5 104 6   81         12   226 175                 401
3014753 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No Elementary 02 05 2017   k_12_total 135.0 4.0 2.0 1.0   13.0         9.0   93.0 71.0       0.6               164.0 135 4 2 1   13         9   93 71                 164
3015783 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2017   k_12_total 265.0 6.0 15.0 34.0   7.0       1.0 25.0   179.0 174.0       0.9               353.0 265 6 15 34   7       1 25   179 174                 353
3346682 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2016   k_12_total 354.0 12.0 34.0 24.0   6.0         40.0   230.0 240.0       0.6               470.0 354 12 34 24   6         40   230 240                 470
3353695 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2016   k_12_total 271.0 9.0 14.0 35.0   3.0         28.0   182.0 178.0       0.9               360.0 271 9 14 35   3         28   182 178                 360
252464 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2018   k_12_total 2.0     226.0   1.0             115.0 114.0       0.0               229.0 2     226   1             115 114                 229
256192 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2018   k_12_total 89.0 3.0 6.0 45.0   1.0             66.0 78.0       0.0               144.0 89 3 6 45   1             66 78                 144
258782 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2018   k_12_total 537.0 6.0 32.0 18.0   6.0       1.0 12.0   310.0 302.0       1.1               612.0 537 6 32 18   6       1 12   310 302                 612
359710 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2019   k_12_total 2.0   1.0 242.0   1.0       1.0 1.0   125.0 123.0       0.0               248.0 2   1 242   1       1 1   125 123                 248
363435 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2019   k_12_total 75.0 3.0 7.0 57.0             1.0   68.0 75.0       0.0               143.0 75 3 7 57             1   68 75                 143
366009 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2019   k_12_total 513.0 8.0 30.0 12.0   4.0       1.0 15.0   311.0 272.0       1.4               583.0 513 8 30 12   4       1 15   311 272                 583
451553 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2021   k_12_total 1.0     248.0   2.0             124.0 127.0       0.0               251.0 1     248   2             124 127                 251
455297 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2021   k_12_total 62.0 3.0 4.0 58.0   1.0         4.0   64.0 68.0       0.0               132.0 62 3 4 58   1         4   64 68                 132
457871 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School Not applicable Elementary 03 05 2021   k_12_total 470.0 6.0 24.0 8.0   4.0       2.0 17.0   263.0 268.0       0.9               531.0 470 6 24 8   4       2 17   263 268                 531
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
493720 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   k_12_total 64.0 5.0 7.0 61.0                 70.0 67.0       0.0               137.0 64 5 7 61                 70 67                 137
496294 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School Not applicable Elementary 03 05 2020   k_12_total 496.0 7.0 29.0 11.0   8.0       2.0 19.0   306.0 266.0       0.9               572.0 496 7 29 11   8       2 19   306 266                 572
2962867 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   k_12_total 528.0 13.0 22.0 20.0   23.0       1.0 28.0   325.0 310.0                       635.0 528 13 22 20   23       1 28   325 310                 635
2964198 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   k_12_total 5.0   1.0 224.0                 125.0 105.0                       230.0 5   1 224                 125 105                 230
2967881 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   k_12_total 81.0   2.0 60.0   1.0         4.0   72.0 76.0                       148.0 81   2 60   1         4   72 76                 148
2970537 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   k_12_total 469.0 1.0 24.0 21.0   4.0       1.0 16.0   266.0 270.0                       536.0 469 1 24 21   4       1 16   266 270                 536
2970776 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   k_12_total 319.0 5.0 8.0 3.0             11.0   199.0 147.0                       346.0 319 5 8 3             11   199 147                 346
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
3012617 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No Elementary 03 05 2017   k_12_total 90.0 1.0 4.0 58.0   1.0         5.0   73.0 86.0       0.0               159.0 90 1 4 58   1         5   73 86                 159
3015196 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2017   k_12_total 526.0 2.0 31.0 17.0   3.0         13.0   293.0 299.0       0.5               592.0 526 2 31 17   3         13   293 299                 592
3346801 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2016   k_12_total 3.0   4.0 236.0                 122.0 121.0       2.3               243.0 3   4 236                 122 121                 243
3350481 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2016   k_12_total 88.0   4.0 64.0   2.0         5.0   79.0 84.0       0.0               163.0 88   4 64   2         5   79 84                 163
3353105 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2016   k_12_total 486.0   26.0 16.0   3.0         16.0   276.0 271.0       0.5               547.0 486   26 16   3         16   276 271                 547
3353293 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2016   k_12_total 327.0 2.0 4.0 5.0             13.0   198.0 153.0                       351.0 327 2 4 5             13   198 153                 351
251126 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   k_12_total 464.0 15.0 29.0 12.0   23.0       1.0 32.0   286.0 290.0       4.9               576.0 464 15 29 12   23       1 32   286 290                 576
251936 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   k_12_total 180.0 2.0 14.0 1.0   3.0         13.0   103.0 110.0       1.9               213.0 180 2 14 1   3         13   103 110                 213
252349 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   k_12_total 346.0 16.0 39.0 31.0   4.0       1.0 43.0   231.0 249.0       0.0               480.0 346 16 39 31   4       1 43   231 249                 480
254487 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   k_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0       29.2               383.0 190 8 95 5   73         12   213 170                 383
254704 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2018   k_12_total 8.0                       5.0 3.0       37.5               8.0 8                       5 3                 8
256954 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2018   k_12_total 13.0 4.0 2.0 6.0                 22.0 3.0       0.0               25.0 13 4 2 6                 22 3                 25
358385 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2019   k_12_total 463.0 15.0 27.0 12.0   20.0       1.0 26.0   271.0 293.0       5.0               564.0 463 15 27 12   20       1 26   271 293                 564
359195 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2019   k_12_total 186.0 7.0 14.0 3.0   3.0         10.0   112.0 111.0       3.1               223.0 186 7 14 3   3         10   112 111                 223
359608 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   k_12_total 349.0 9.0 52.0 25.0   3.0       1.0 32.0   246.0 225.0       0.6               471.0 349 9 52 25   3       1 32   246 225                 471
361714 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2019   k_12_total 197.0 5.0 109.0 6.0   77.0       1.0 10.0   233.0 172.0       29.9               405.0 197 5 109 6   77       1 10   233 172                 405
361931 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2019   k_12_total 10.0                       6.0 4.0       40.0               10.0 10                       6 4                 10
364229 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2019   k_12_total 7.0 3.0 2.0 10.0             1.0   20.0 3.0       0.0               23.0 7 3 2 10             1   20 3                 23
366011 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School No Middle 04 08 2019   k_12_total 2.0   1.0 3.0             1.0   6.0 1.0       0.0               7.0 2   1 3             1   6 1                 7
450231 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School Not applicable Elementary 04 05 2021   k_12_total 412.0 16.0 33.0 16.0   8.0         24.0   278.0 231.0       4.5               509.0 412 16 33 16   8         24   278 231                 509
451041 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School Not applicable Elementary 04 05 2021   k_12_total 173.0 5.0 20.0     7.0       2.0 12.0   105.0 114.0       1.8               219.0 173 5 20     7       2 12   105 114                 219
451441 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School Not applicable Elementary 04 05 2021   k_12_total 294.0 11.0 38.0 32.0   5.0       1.0 67.0   234.0 214.0       0.2               448.0 294 11 38 32   5       1 67   234 214                 448
453560 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School Not applicable Elementary 04 05 2021   k_12_total 180.0 7.0 138.0 16.0   109.0       2.0 13.0   251.0 214.0       41.9               465.0 180 7 138 16   109       2 13   251 214                 465
453777 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School Not applicable Middle 04 08 2021   k_12_total 11.0                       6.0 5.0       54.6               11.0 11                       6 5                 11
456107 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2021   k_12_total 2.0 1.0   5.0             1.0   5.0 4.0       0.0               9.0 2 1   5             1   5 4                 9
457873 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elementary   Alternative School Not applicable Middle 04 08 2021   k_12_total 4.0   1.0 3.0           1.0     3.0 6.0       0.0               9.0 4   1 3           1     3 6                 9
488654 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School Not applicable Elementary 04 05 2020   k_12_total 387.0 18.0 37.0 10.0   11.0         26.0   229.0 260.0       5.1               489.0 387 18 37 10   11         26   229 260                 489
489464 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School Not applicable Elementary 04 05 2020   k_12_total 175.0 3.0 17.0 3.0   5.0       1.0 9.0   101.0 112.0       1.4               213.0 175 3 17 3   5       1 9   101 112                 213
489877 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School Not applicable Elementary 04 05 2020   k_12_total 334.0 11.0 46.0 24.0   4.0       1.0 52.0   231.0 241.0       0.6               472.0 334 11 46 24   4       1 52   231 241                 472
491983 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School Not applicable Elementary 04 05 2020   k_12_total 188.0 6.0 137.0 10.0   92.0       1.0 10.0   262.0 182.0       36.3               444.0 188 6 137 10   92       1 10   262 182                 444
492200 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School Not applicable Middle 04 08 2020   k_12_total 11.0                       6.0 5.0       54.6               11.0 11                       6 5                 11
494514 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2020   k_12_total 4.0 2.0 1.0 11.0                 16.0 2.0       0.0               18.0 4 2 1 11                 16 2                 18
496296 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School Not applicable Middle 04 08 2020   k_12_total 9.0     3.0             2.0   7.0 7.0       0.0               14.0 9     3             2   7 7                 14
2964067 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   k_12_total 323.0 9.0 31.0 36.0   3.0       2.0 35.0   237.0 202.0                       439.0 323 9 31 36   3       2 35   237 202                 439
2966441 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   k_12_total 7.0                       4.0 3.0                       7.0 7                       4 3                 7
3007535 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2017   k_12_total 421.0 15.0 26.0 11.0   24.0         32.0   263.0 266.0       3.6               529.0 421 15 26 11   24         32   263 266                 529
3008345 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2017   k_12_total 183.0 1.0 17.0 3.0   2.0         12.0   103.0 115.0       0.5               218.0 183 1 17 3   2         12   103 115                 218
3008771 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2017   k_12_total 350.0 15.0 37.0 25.0   10.0       2.0 30.0   229.0 240.0       0.0               469.0 350 15 37 25   10       2 30   229 240                 469
3010944 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2017   k_12_total 168.0 8.0 76.0 9.0   83.0         8.0   178.0 174.0       17.3               352.0 168 8 76 9   83         8   178 174                 352
3011161 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Elementary 04 08 2017   k_12_total 9.0                       5.0 4.0       22.2               9.0 9                       5 4                 9
3013395 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Elementary 04 08 2017   k_12_total 13.0 2.0 1.0 8.0                 19.0 5.0       0.0               24.0 13 2 1 8                 19 5                 24
3345479 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 2 04 05 2016   k_12_total 446.0 17.0 20.0 7.0   26.0       1.0 29.0   266.0 280.0                       546.0 446 17 20 7   26       1 29   266 280                 546

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