Data source: Big Local News · About: Big Local

10,768 rows where state = "SD" and year = 2020 sorted by total_int descending

View and edit SQL

year

  • 2020 · 10,768
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 ▲
495900 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   k_12_total 1721.0 191.0 308.0 86.0   63.0       1.0 81.0   1279.0 1172.0       6.6               2451.0 1721 191 308 86   63       1 81   1279 1172                 2451
495984 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   pk_12_total 1721.0 191.0 308.0 86.0   63.0       1.0 81.0   1279.0 1172.0                       2451.0 1721 191 308 86   63       1 81   1279 1172                 2451
495890 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2020   k_12_total 1432.0 212.0 163.0 109.0   58.0       1.0 77.0   1021.0 1031.0       4.9               2052.0 1432 212 163 109   58       1 77   1021 1031                 2052
495974 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2020   pk_12_total 1432.0 212.0 163.0 109.0   58.0       1.0 77.0   1021.0 1031.0                       2052.0 1432 212 163 109   58       1 77   1021 1031                 2052
494915 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 1196.0 24.0 147.0 387.0   16.0       1.0 182.0   952.0 1001.0       1.0               1953.0 1196 24 147 387   16       1 182   952 1001                 1953
494965 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 1196.0 24.0 147.0 387.0   16.0       1.0 182.0   952.0 1001.0                       1953.0 1196 24 147 387   16       1 182   952 1001                 1953
495909 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   k_12_total 1013.0 379.0 289.0 71.0   128.0       1.0 69.0   995.0 955.0       17.0               1950.0 1013 379 289 71   128       1 69   995 955                 1950
495993 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   pk_12_total 1013.0 379.0 289.0 71.0   128.0       1.0 69.0   995.0 955.0                       1950.0 1013 379 289 71   128       1 69   995 955                 1950
494934 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 1398.0 9.0 107.0 81.0   29.0         92.0   874.0 842.0       0.6               1716.0 1398 9 107 81   29         92   874 842                 1716
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
495892 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 1101.0 79.0 77.0 20.0   19.0       2.0 73.0   646.0 725.0       1.9               1371.0 1101 79 77 20   19       2 73   646 725                 1371
495976 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 1101.0 79.0 77.0 20.0   19.0       2.0 73.0   646.0 725.0                       1371.0 1101 79 77 20   19       2 73   646 725                 1371
487454 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   k_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0       2.8               1349.0 1081 30 85 79   46       2 26   671 678                 1349
487474 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   pk_12_total 1081.0 30.0 85.0 79.0   46.0       2.0 26.0   671.0 678.0                       1349.0 1081 30 85 79   46       2 26   671 678                 1349
488410 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 1085.0 38.0 36.0 2.0   19.0         37.0   636.0 581.0       1.2               1217.0 1085 38 36 2   19         37   636 581                 1217
488424 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 1085.0 38.0 36.0 2.0   19.0         37.0   636.0 581.0                       1217.0 1085 38 36 2   19         37   636 581                 1217
497274 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2020   k_12_total 1044.0 9.0 44.0 45.0   7.0         31.0   599.0 581.0       0.7               1180.0 1044 9 44 45   7         31   599 581                 1180
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
495877 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 766.0 91.0 135.0 45.0   19.0       4.0 65.0   583.0 542.0       3.1               1125.0 766 91 135 45   19       4 65   583 542                 1125
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
491428 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   k_12_total 1005.0 26.0 33.0 5.0   13.0       1.0 40.0   560.0 563.0       1.3               1123.0 1005 26 33 5   13       1 40   560 563                 1123
491446 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   pk_12_total 1005.0 26.0 33.0 5.0   13.0       1.0 40.0   560.0 563.0                       1123.0 1005 26 33 5   13       1 40   560 563                 1123
495896 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 846.0 95.0 61.0 29.0   24.0       1.0 51.0   559.0 548.0       3.8               1107.0 846 95 61 29   24       1 51   559 548                 1107
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
495981 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 741.0 65.0 72.0 22.0   14.0       2.0 74.0   529.0 461.0                       990.0 741 65 72 22   14       2 74   529 461                 990
495910 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 317.0 254.0 204.0 54.0   89.0       1.0 64.0   522.0 461.0       25.8               983.0 317 254 204 54   89       1 64   522 461                 983
495994 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 317.0 254.0 204.0 54.0   89.0       1.0 64.0   522.0 461.0                       983.0 317 254 204 54   89       1 64   522 461                 983
488653 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 799.0 20.0 44.0 21.0   37.0       1.0 40.0   478.0 484.0       1.7               962.0 799 20 44 21   37       1 40   478 484                 962
488665 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 799.0 20.0 44.0 21.0   37.0       1.0 40.0   478.0 484.0                       962.0 799 20 44 21   37       1 40   478 484                 962
489876 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   k_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0       0.5               929.0 606 22 105 68   9       3 116   473 456                 929
489886 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   pk_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0                       929.0 606 22 105 68   9       3 116   473 456                 929
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
498081 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   k_12_total 782.0 13.0 57.0 40.0   7.0         14.0   483.0 430.0       1.3               913.0 782 13 57 40   7         14   483 430                 913
498093 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   pk_12_total 782.0 13.0 57.0 40.0   7.0         14.0   483.0 430.0                       913.0 782 13 57 40   7         14   483 430                 913
495876 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 694.0 82.0 65.0 6.0   16.0       2.0 47.0   448.0 464.0       10.1               912.0 694 82 65 6   16       2 47   448 464                 912
495882 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 339.0 154.0 233.0 85.0   23.0       1.0 68.0   471.0 432.0       19.9               903.0 339 154 233 85   23       1 68   471 432                 903
495966 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 339.0 154.0 233.0 85.0   23.0       1.0 68.0   471.0 432.0                       903.0 339 154 233 85   23       1 68   471 432                 903
495897 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 688.0 40.0 48.0 13.0   12.0       2.0 57.0   448.0 412.0       1.3               860.0 688 40 48 13   12       2 57   448 412                 860
488656 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 671.0 28.0 44.0 19.0   31.0       1.0 48.0   424.0 418.0       3.1               842.0 671 28 44 19   31       1 48   424 418                 842
488668 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 671.0 28.0 44.0 19.0   31.0       1.0 48.0   424.0 418.0                       842.0 671 28 44 19   31       1 48   424 418                 842
491429 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School Not applicable Middle 06 08 2020   k_12_total 696.0 25.0 28.0 7.0   20.0         30.0   431.0 375.0       2.6               806.0 696 25 28 7   20         30   431 375                 806
491447 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School Not applicable Middle 06 08 2020   pk_12_total 696.0 25.0 28.0 7.0   20.0         30.0   431.0 375.0                       806.0 696 25 28 7   20         30   431 375                 806
493644 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   k_12_total 685.0 6.0 40.0 42.0   9.0       3.0 19.0   399.0 405.0       2.1               804.0 685 6 40 42   9       3 19   399 405                 804
493658 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   pk_12_total 685.0 6.0 40.0 42.0   9.0       3.0 19.0   399.0 405.0                       804.0 685 6 40 42   9       3 19   399 405                 804
494437 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   k_12_total 606.0 3.0 25.0 93.0   5.0         67.0   403.0 396.0       0.8               799.0 606 3 25 93   5         67   403 396                 799
494447 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   pk_12_total 606.0 3.0 25.0 93.0   5.0         67.0   403.0 396.0                       799.0 606 3 25 93   5         67   403 396                 799
489873 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   k_12_total 570.0 16.0 61.0 53.0   12.0       6.0 66.0   414.0 370.0       0.6               784.0 570 16 61 53   12       6 66   414 370                 784
489883 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   pk_12_total 570.0 16.0 61.0 53.0   12.0       6.0 66.0   414.0 370.0                       784.0 570 16 61 53   12       6 66   414 370                 784
495967 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 547.0 70.0 35.0 26.0   13.0         69.0   399.0 361.0                       760.0 547 70 35 26   13         69   399 361                 760
491979 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   k_12_total 369.0 15.0 188.0 7.0   144.0       7.0 7.0   387.0 350.0       24.7               737.0 369 15 188 7   144       7 7   387 350                 737
491993 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2020   pk_12_total 369.0 15.0 188.0 7.0   144.0       7.0 7.0   387.0 350.0                       737.0 369 15 188 7   144       7 7   387 350                 737
493308 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2020   k_12_total 617.0 6.0 37.0 25.0   2.0       1.0 29.0   356.0 361.0       0.0               717.0 617 6 37 25   2       1 29   356 361                 717
493332 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2020   pk_12_total 617.0 6.0 37.0 25.0   2.0       1.0 29.0   356.0 361.0                       717.0 617 6 37 25   2       1 29   356 361                 717
494890 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   grade_9 353.0 9.0 68.0 199.0   3.0       0.0 78.0   373.0 337.0                       710.0 353 9 68 199   3       0 78   373 337                 710
495969 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 260.0 79.0 221.0 65.0   14.0         66.0   370.0 335.0                       705.0 260 79 221 65   14         66   370 335                 705
495986 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 564.0 16.0 88.0 3.0   1.0         28.0   341.0 359.0                       700.0 564 16 88 3   1         28   341 359                 700
495858 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   grade_9 442.0 65.0 115.0 38.0   12.0       0.0 27.0   369.0 330.0                       699.0 442 65 115 38   12       0 27   369 330                 699
495901 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 325.0 129.0 122.0 25.0   46.0       1.0 48.0   360.0 336.0       25.9               696.0 325 129 122 25   46       1 48   360 336                 696
495985 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 325.0 129.0 122.0 25.0   46.0       1.0 48.0   360.0 336.0                       696.0 325 129 122 25   46       1 48   360 336                 696
494933 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 576.0 1.0 37.0 33.0   10.0         37.0   322.0 372.0       0.9               694.0 576 1 37 33   10         37   322 372                 694
494983 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2020   pk_12_total 576.0 1.0 37.0 33.0   10.0         37.0   322.0 372.0                       694.0 576 1 37 33   10         37   322 372                 694
488412 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School Not applicable Middle 07 08 2020   k_12_total 602.0 23.0 23.0 6.0   13.0         26.0   354.0 339.0       1.3               693.0 602 23 23 6   13         26   354 339                 693
488426 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School Not applicable Middle 07 08 2020   pk_12_total 602.0 23.0 23.0 6.0   13.0         26.0   354.0 339.0                       693.0 602 23 23 6   13         26   354 339                 693
494434 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 477.0 6.0 36.0 103.0   8.0         60.0   344.0 346.0       0.6               690.0 477 6 36 103   8         60   344 346                 690
494444 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 477.0 6.0 36.0 103.0   8.0         60.0   344.0 346.0                       690.0 477 6 36 103   8         60   344 346                 690
493645 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 568.0 9.0 47.0 34.0   6.0         24.0   339.0 349.0       2.5               688.0 568 9 47 34   6         24   339 349                 688
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
495971 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 596.0 25.0 20.0 7.0   6.0       1.0 28.0   334.0 349.0                       683.0 596 25 20 7   6       1 28   334 349                 683
496298 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2020   k_12_total 599.0 5.0 36.0 20.0   6.0       1.0 15.0   348.0 334.0       0.6               682.0 599 5 36 20   6       1 15   348 334                 682
496314 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2020   pk_12_total 599.0 5.0 36.0 20.0   6.0       1.0 15.0   348.0 334.0                       682.0 599 5 36 20   6       1 15   348 334                 682
488411 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School Not applicable Middle 05 06 2020   k_12_total 587.0 27.0 24.0 2.0   12.0         23.0   367.0 308.0       2.7               675.0 587 27 24 2   12         23   367 308                 675
488425 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School Not applicable Middle 05 06 2020   pk_12_total 587.0 27.0 24.0 2.0   12.0         23.0   367.0 308.0                       675.0 587 27 24 2   12         23   367 308                 675
494917 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2020   k_12_total 443.0 10.0 45.0 72.0   6.0         94.0   348.0 322.0       0.9               670.0 443 10 45 72   6         94   348 322                 670
494967 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2020   pk_12_total 443.0 10.0 45.0 72.0   6.0         94.0   348.0 322.0                       670.0 443 10 45 72   6         94   348 322                 670
495902 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 539.0 15.0 84.0 3.0   1.0         25.0   328.0 339.0       0.0               667.0 539 15 84 3   1         25   328 339                 667
495887 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 582.0 25.0 19.0 7.0   5.0       1.0 27.0   324.0 342.0       1.8               666.0 582 25 19 7   5       1 27   324 342                 666
494931 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 350.0 7.0 69.0 155.0   6.0         74.0   343.0 318.0       0.6               661.0 350 7 69 155   6         74   343 318                 661
494981 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School Not applicable Middle 06 08 2020   pk_12_total 350.0 7.0 69.0 155.0   6.0         74.0   343.0 318.0                       661.0 350 7 69 155   6         74   343 318                 661
495438 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   grade_10 454.0 57.0 80.0 24.0   16.0       0.0 27.0   363.0 295.0                       658.0 454 57 80 24   16       0 27   363 295                 658
489874 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 478.0 14.0 54.0 42.0   7.0       5.0 51.0   333.0 318.0       0.0               651.0 478 14 54 42   7       5 51   333 318                 651
489884 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 478.0 14.0 54.0 42.0   7.0       5.0 51.0   333.0 318.0                       651.0 478 14 54 42   7       5 51   333 318                 651
495885 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 234.0 75.0 203.0 64.0   11.0         63.0   342.0 308.0       25.4               650.0 234 75 203 64   11         63   342 308                 650
488423 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   pk_12_total 532.0 31.0 26.0 11.0   1.0       1.0 42.0   350.0 294.0                       644.0 532 31 26 11   1       1 42   350 294                 644
494127 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2020   pk_12_total     10.0 633.0             1.0   311.0 333.0                       644.0     10 633             1   311 333                 644
498082 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 530.0 4.0 51.0 27.0   2.0         23.0   330.0 307.0       1.9               637.0 530 4 51 27   2         23   330 307                 637
498094 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 530.0 4.0 51.0 27.0   2.0         23.0   330.0 307.0                       637.0 530 4 51 27   2         23   330 307                 637
494117 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2020   k_12_total     10.0 624.0             1.0   308.0 327.0       0.5               635.0     10 624             1   308 327                 635
497276 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School Not applicable Middle 07 08 2020   k_12_total 547.0 7.0 29.0 19.0   9.0         22.0   312.0 321.0       1.3               633.0 547 7 29 19   9         22   312 321                 633
497292 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School Not applicable Middle 07 08 2020   pk_12_total 547.0 7.0 29.0 19.0   9.0         22.0   312.0 321.0                       633.0 547 7 29 19   9         22   312 321                 633
495883 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 486.0 33.0 24.0 20.0   11.0         53.0   328.0 299.0       1.6               627.0 486 33 24 20   11         53   328 299                 627
494936 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 450.0 5.0 51.0 51.0   1.0         67.0   329.0 296.0       0.3               625.0 450 5 51 51   1         67   329 296                 625
494986 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School Not applicable Middle 06 08 2020   pk_12_total 450.0 5.0 51.0 51.0   1.0         67.0   329.0 296.0                       625.0 450 5 51 51   1         67   329 296                 625
496299 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School Not applicable Middle 06 08 2020   k_12_total 558.0 2.0 33.0 17.0   4.0         9.0   314.0 309.0       0.6               623.0 558 2 33 17   4         9   314 309                 623
496315 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School Not applicable Middle 06 08 2020   pk_12_total 558.0 2.0 33.0 17.0   4.0         9.0   314.0 309.0                       623.0 558 2 33 17   4         9   314 309                 623
491980 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 297.0 10.0 152.0 10.0   126.0       5.0 17.0   333.0 284.0       22.5               617.0 297 10 152 10   126       5 17   333 284                 617
491994 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 297.0 10.0 152.0 10.0   126.0       5.0 17.0   333.0 284.0                       617.0 297 10 152 10   126       5 17   333 284                 617
495848 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2020   grade_9 384.0 63.0 67.0 53.0   18.0       1.0 31.0   309.0 308.0                       617.0 384 63 67 53   18       1 31   309 308                 617
488409 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   k_12_total 507.0 29.0 23.0 9.0   1.0       1.0 37.0   327.0 280.0       0.2               607.0 507 29 23 9   1       1 37   327 280                 607
494935 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2020   k_12_total 376.0 6.0 51.0 83.0   10.0         75.0   308.0 293.0       2.8               601.0 376 6 51 83   10         75   308 293                 601
494985 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2020   pk_12_total 376.0 6.0 51.0 83.0   10.0         75.0   308.0 293.0                       601.0 376 6 51 83   10         75   308 293                 601

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