Data source: Big Local News · About: Big Local

4,696 rows where grade = "pk_12_total" and state = "SD" sorted by black descending

View and edit SQL

year

grade

  • pk_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
2970166 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No 1 PK 05 2015   pk_12_total 193.0 99.0 79.0 68.0   8.0       1.0 49.0   261.0 236.0                       497.0 193 99 79 68   8       1 49   261 236                 497
258430 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   pk_12_total 176.0 98.0 74.0 70.0   8.0         58.0   235.0 249.0                       484.0 176 98 74 70   8         58   235 249                 484
3352751 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No 1 KG 05 2016   pk_12_total 293.0 98.0 74.0 34.0   25.0       3.0 29.0   315.0 241.0                       556.0 293 98 74 34   25       3 29   315 241                 556
258435 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   pk_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0                       1118.0 847 97 78 28   27         41   555 563                 1118
495980 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 846.0 95.0 61.0 29.0   24.0       1.0 51.0   559.0 548.0                       1107.0 846 95 61 29   24       1 51   559 548                 1107
365695 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2019   pk_12_total 849.0 93.0 80.0 30.0   22.0         54.0   565.0 563.0                       1128.0 849 93 80 30   22         54   565 563                 1128
3352725 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2016   pk_12_total 250.0 92.0 47.0 56.0   5.0       3.0 54.0   275.0 232.0                       507.0 250 92 47 56   5       3 54   275 232                 507
365691 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2019   pk_12_total 165.0 91.0 77.0 67.0   4.0       1.0 65.0   240.0 230.0                       470.0 165 91 77 67   4       1 65   240 230                 470
495961 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0                       1125.0 766 91 135 45   19       4 65   583 542                 1125
365677 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2019   pk_12_total 752.0 90.0 121.0 42.0   17.0       5.0 51.0   558.0 520.0                       1078.0 752 90 121 42   17       5 51   558 520                 1078
3014865 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2017   pk_12_total 294.0 90.0 77.0 13.0   38.0         34.0   277.0 269.0                       546.0 294 90 77 13   38         34   277 269                 546
249952 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   pk_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0                       338.0 255 9 14 21   15       1 23   179 159                 338
253951 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   pk_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0                       648.0 580 9 19 4   15         21   335 313                 648
253952 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2018   pk_12_total 365.0 9.0 10.0     1.0         12.0   193.0 204.0                       397.0 365 9 10     1         12   193 204                 397
258966 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   pk_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0                       431.0 387 9 9 7             19   226 205                 431
259257 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   pk_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0                       145.0 125 9 9 1             1   71 74                 145
260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
357195 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2019   pk_12_total 239.0 9.0 29.0 16.0   10.0       1.0 28.0   171.0 161.0                       332.0 239 9 29 16   10       1 28   171 161                 332
359618 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   pk_12_total 349.0 9.0 52.0 25.0   3.0       1.0 32.0   246.0 225.0                       471.0 349 9 52 25   3       1 32   246 225                 471
361174 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2019   pk_12_total 466.0 9.0 11.0 4.0   21.0       1.0 17.0   270.0 259.0                       529.0 466 9 11 4   21       1 17   270 259                 529
361180 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary PK 05 2019   pk_12_total 222.0 9.0 12.0     5.0         8.0   126.0 130.0                       256.0 222 9 12     5         8   126 130                 256
361726 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   pk_12_total 183.0 9.0 146.0 10.0   100.0       2.0 14.0   254.0 210.0                       464.0 183 9 146 10   100       2 14   254 210                 464
364682 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2019   pk_12_total 468.0 9.0 35.0 58.0   8.0         86.0   329.0 335.0                       664.0 468 9 35 58   8         86   329 335                 664
367788 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2019   pk_12_total 326.0 9.0 32.0 26.0   1.0         13.0   222.0 185.0                       407.0 326 9 32 26   1         13   222 185                 407
367791 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2019   pk_12_total 291.0 9.0 37.0 25.0   8.0         6.0   182.0 194.0                       376.0 291 9 37 25   8         6   182 194                 376
449050 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 311.0 9.0 9.0 10.0   9.0         19.0   190.0 177.0                       367.0 311 9 9 10   9         19   190 177                 367
451047 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School Not applicable High 09 12 2021   pk_12_total 319.0 9.0 31.0 8.0   10.0       5.0 14.0   196.0 200.0                       396.0 319 9 31 8   10       5 14   196 200                 396
453571 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 291.0 9.0 166.0 12.0   114.0       4.0 19.0   346.0 269.0                       615.0 291 9 166 12   114       4 19   346 269                 615
456578 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2021   pk_12_total 359.0 9.0 54.0 67.0   7.0         59.0   286.0 269.0                       555.0 359 9 54 67   7         59   286 269                 555
457533 SD     school 4666270 49005   Sioux Falls 49-5 466627001139 52 Bridges at Horace Mann   Regular School Not applicable Elementary KG 05 2021   pk_12_total 34.0 9.0 6.0 5.0             11.0   57.0 8.0                       65.0 34 9 6 5             11   57 8                 65
487473 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 318.0 9.0 6.0 13.0   5.0         13.0   196.0 168.0                       364.0 318 9 6 13   5         13   196 168                 364
487480 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 227.0 9.0 32.0 23.0   11.0       1.0 32.0   180.0 155.0                       335.0 227 9 32 23   11       1 32   180 155                 335
493659 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 568.0 9.0 47.0 34.0   6.0         24.0   339.0 349.0                       688.0 568 9 47 34   6         24   339 349                 688
494977 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School Not applicable High 09 12 2020   pk_12_total 148.0 9.0 25.0 104.0   1.0         37.0   181.0 143.0                       324.0 148 9 25 104   1         37   181 143                 324
494984 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 1398.0 9.0 107.0 81.0   29.0         92.0   874.0 842.0                       1716.0 1398 9 107 81   29         92   874 842                 1716
496926 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   pk_12_total 270.0 9.0 8.0 40.0   5.0         22.0   189.0 165.0                       354.0 270 9 8 40   5         22   189 165                 354
497290 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2020   pk_12_total 1044.0 9.0 44.0 45.0   7.0         31.0   599.0 581.0                       1180.0 1044 9 44 45   7         31   599 581                 1180
2964079 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   pk_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
2969018 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No 1 KG 05 2015   pk_12_total 356.0 9.0 35.0 82.0   4.0         24.0   273.0 237.0                       510.0 356 9 35 82   4         24   273 237                 510
3006377 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2017   pk_12_total 284.0 9.0 22.0 29.0   20.0         26.0   201.0 189.0                       390.0 284 9 22 29   20         26   201 189                 390
3006378 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2017   pk_12_total 334.0 9.0 16.0 28.0   8.0       3.0 19.0   225.0 192.0                       417.0 334 9 16 28   8       3 19   225 192                 417
3008352 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2017   pk_12_total 246.0 9.0 18.0 4.0   5.0         8.0   154.0 136.0                       290.0 246 9 18 4   5         8   154 136                 290
3013848 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2017   pk_12_total 476.0 9.0 34.0 77.0   7.0         41.0   330.0 314.0                       644.0 476 9 34 77   7         41   330 314                 644
3015374 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2017   pk_12_total 62.0 9.0 8.0 1.0   2.0         10.0   53.0 39.0                       92.0 62 9 8 1   2         10   53 39                 92
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
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
3353703 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2016   pk_12_total 271.0 9.0 14.0 35.0   3.0         28.0   182.0 178.0                       360.0 271 9 14 35   3         28   182 178                 360
457553 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0                       1389.0 1088 89 89 25   15       3 80   669 720                 1389
365692 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2019   pk_12_total 1089.0 83.0 70.0 23.0   28.0       2.0 62.0   655.0 702.0                       1357.0 1089 83 70 23   28       2 62   655 702                 1357
495960 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 706.0 82.0 67.0 6.0   17.0       2.0 48.0   460.0 468.0                       928.0 706 82 67 6   17       2 48   460 468                 928
258416 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   pk_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0                       1047.0 749 80 93 51   25       5 44   540 507                 1047
457568 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 279.0 80.0 51.0 15.0   10.0       3.0 33.0   273.0 198.0                       471.0 279 80 51 15   10       3 33   273 198                 471
3014872 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2017   pk_12_total 305.0 80.0 74.0 27.0   14.0       2.0 28.0   292.0 238.0                       530.0 305 80 74 27   14       2 28   292 238                 530
251942 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   pk_12_total 333.0 8.0 23.0 4.0   6.0       2.0 12.0   214.0 174.0                       388.0 333 8 23 4   6       2 12   214 174                 388
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
254498 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2018   pk_12_total 279.0 8.0 105.0 5.0   110.0       2.0 6.0   259.0 256.0                       515.0 279 8 105 5   110       2 6   259 256                 515
254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
256128 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   pk_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0                       513.0 418 8 36 36   1         14   257 256                 513
256130 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   pk_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0                       777.0 662 8 35 38   8         26   389 388                 777
257510 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 328.0 8.0 9.0 8.0   1.0             183.0 171.0                       354.0 328 8 9 8   1             183 171                 354
259399 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   pk_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0                       378.0 303 8 19 39   5       2 2   174 204                 378
259762 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   pk_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0                       1211.0 1086 8 38 45   10       1 23   619 592                 1211
260529 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   pk_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0                       392.0 334 8 23 13   2         12   207 185                 392
260532 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   pk_12_total 268.0 8.0 31.0 21.0   5.0         14.0   181.0 166.0                       347.0 268 8 31 21   5         14   181 166                 347
357188 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2019   pk_12_total 332.0 8.0 8.0 12.0   4.0         21.0   208.0 177.0                       385.0 332 8 8 12   4         21   208 177                 385
358400 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   pk_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0                       284.0 213 8 16 13   13       1 20   151 133                 284
359200 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2019   pk_12_total 331.0 8.0 37.0 2.0   20.0         26.0   219.0 205.0                       424.0 331 8 37 2   20         26   219 205                 424
363063 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2019   pk_12_total 604.0 8.0 28.0 30.0           1.0 20.0   341.0 350.0                       691.0 604 8 28 30           1 20   341 350                 691
363373 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2019   pk_12_total 692.0 8.0 38.0 30.0   11.0       3.0 19.0   410.0 391.0                       801.0 692 8 38 30   11       3 19   410 391                 801
363374 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2019   pk_12_total 578.0 8.0 41.0 28.0   4.0         15.0   344.0 330.0                       674.0 578 8 41 28   4         15   344 330                 674
365673 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No Elementary 02 05 2019   pk_12_total 141.0 8.0 5.0 1.0   9.0         11.0   87.0 88.0                       175.0 141 8 5 1   9         11   87 88                 175
366025 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2019   pk_12_total 513.0 8.0 30.0 12.0   4.0       1.0 15.0   311.0 272.0                       583.0 513 8 30 12   4       1 15   311 272                 583
367793 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2019   pk_12_total 524.0 8.0 54.0 28.0   3.0         22.0   338.0 301.0                       639.0 524 8 54 28   3         22   338 301                 639
450246 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0                       264.0 202 8 21 6   7         20   145 119                 264
453027 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 299.0 8.0 11.0 2.0   4.0         4.0   161.0 167.0                       328.0 299 8 11 2   4         4   161 167                 328
456557 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 203.0 8.0 41.0 66.0   3.0       1.0 50.0   196.0 176.0                       372.0 203 8 41 66   3       1 50   196 176                 372
458503 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2021   pk_12_total 264.0 8.0 11.0 33.0   7.0         22.0   170.0 175.0                       345.0 264 8 11 33   7         22   170 175                 345
459222 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 380.0 8.0 2.0 8.0   2.0         6.0   217.0 189.0                       406.0 380 8 2 8   2         6   217 189                 406
459703 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 521.0 8.0 57.0 29.0   3.0       1.0 21.0   321.0 319.0                       640.0 521 8 57 29   3       1 21   321 319                 640
491995 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   pk_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0                       478.0 166 8 156 11   119       2 16   253 225                 478
494969 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School Not applicable Elementary KG 05 2020   pk_12_total 288.0 8.0 35.0 61.0   7.0         24.0   240.0 183.0                       423.0 288 8 35 61   7         24   240 183                 423
496927 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School Not applicable High 09 12 2020   pk_12_total 294.0 8.0 14.0 36.0   3.0         11.0   181.0 185.0                       366.0 294 8 14 36   3         11   181 185                 366
2961753 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No 1 KG 05 2015   pk_12_total 354.0 8.0 22.0 30.0   13.0         20.0   223.0 224.0                       447.0 354 8 22 30   13         20   223 224                 447
2967820 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   pk_12_total 493.0 8.0 22.0 30.0   6.0         9.0   309.0 259.0                       568.0 493 8 22 30   6         9   309 259                 568
2970178 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Spanish Immersion Elementary   Vocational Education School No 1 KG 05 2015   pk_12_total 351.0 8.0 34.0 4.0   5.0       1.0 16.0   211.0 208.0                       419.0 351 8 34 4   5       1 16   211 208                 419
2971042 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No 2 07 08 2015   pk_12_total 109.0 8.0   1.0   1.0         4.0   63.0 60.0                       123.0 109 8   1   1         4   63 60                 123
2971183 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2015   pk_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
2972315 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No 1 KG 05 2015   pk_12_total 314.0 8.0 20.0 14.0   3.0         10.0   197.0 172.0                       369.0 314 8 20 14   3         10   197 172                 369
2972319 SD     school 4680430 63003   Yankton 63-3 468043000799 2 Yankton Middle School   Regular School No 2 06 08 2015   pk_12_total 489.0 8.0 31.0 37.0   3.0         5.0   313.0 260.0                       573.0 489 8 31 37   3         5   313 260                 573
3007304 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2017   pk_12_total 497.0 8.0 6.0 7.0   6.0       3.0 21.0   292.0 256.0                       548.0 497 8 6 7   6       3 21   292 256                 548
3010958 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2017   pk_12_total 168.0 8.0 76.0 9.0   83.0         8.0   178.0 174.0                       352.0 168 8 76 9   83         8   178 174                 352
3011888 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 433.0 8.0 44.0 4.0   3.0         20.0   250.0 262.0                       512.0 433 8 44 4   3         20   250 262                 512
3012553 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2017   pk_12_total 451.0 8.0 39.0 31.0   5.0         18.0   295.0 257.0                       552.0 451 8 39 31   5         18   295 257                 552
3012555 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   pk_12_total 665.0 8.0 33.0 35.0   8.0         23.0   406.0 366.0                       772.0 665 8 33 35   8         23   406 366                 772
3349752 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No 1 KG 05 2016   pk_12_total 442.0 8.0 38.0 3.0   3.0         17.0   247.0 264.0                       511.0 442 8 38 3   3         17   247 264                 511
3350417 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No 1 KG 05 2016   pk_12_total 454.0 8.0 28.0 28.0   6.0       1.0 14.0   291.0 248.0                       539.0 454 8 28 28   6       1 14   291 248                 539
3351712 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East Middle Sch   Regular School No 2 06 08 2016   pk_12_total 477.0 8.0 38.0 88.0   9.0         28.0   325.0 323.0                       648.0 477 8 38 88   9         28   325 323                 648
3351815 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No 1 PK 06 2016   pk_12_total 320.0 8.0 4.0 5.0   1.0             184.0 154.0                       338.0 320 8 4 5   1             184 154                 338
3352724 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No 4 06 12 2016   pk_12_total 20.0 8.0 3.0 4.0                 32.0 3.0                       35.0 20 8 3 4                 32 3                 35
3352743 SD     school 4666270 49005   Sioux Falls 49-5 466627000606 42 Renberg Elementary   Regular School No 1 KG 05 2016   pk_12_total 142.0 8.0 11.0     2.0         20.0   80.0 103.0                       183.0 142 8 11     2         20   80 103                 183

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