Data source: Big Local News · About: Big Local

10,800 rows where state = "SD" and year = 2021 sorted by female_int descending

View and edit SQL

year

  • 2021 · 10,800
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
457477 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2021   k_12_total 1745.0 217.0 321.0 90.0   55.0       1.0 116.0   1320.0 1225.0       5.9               2545.0 1745 217 321 90   55       1 116   1320 1225                 2545
457561 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2021   pk_12_total 1745.0 217.0 321.0 90.0   55.0       1.0 116.0   1320.0 1225.0                       2545.0 1745 217 321 90   55       1 116   1320 1225                 2545
457467 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2021   k_12_total 1474.0 206.0 195.0 105.0   53.0       3.0 81.0   1060.0 1057.0       3.9               2117.0 1474 206 195 105   53       3 81   1060 1057                 2117
457551 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2021   pk_12_total 1474.0 206.0 195.0 105.0   53.0       3.0 81.0   1060.0 1057.0                       2117.0 1474 206 195 105   53       3 81   1060 1057                 2117
457486 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   k_12_total 968.0 415.0 295.0 91.0   128.0       4.0 78.0   974.0 1005.0       15.8               1979.0 968 415 295 91   128       4 78   974 1005                 1979
457570 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   pk_12_total 968.0 415.0 295.0 91.0   128.0       4.0 78.0   974.0 1005.0                       1979.0 968 415 295 91   128       4 78   974 1005                 1979
456508 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 1124.0 25.0 140.0 391.0   19.0         202.0   937.0 964.0       0.8               1901.0 1124 25 140 391   19         202   937 964                 1901
456558 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 1124.0 25.0 140.0 391.0   19.0         202.0   937.0 964.0                       1901.0 1124 25 140 391   19         202   937 964                 1901
456527 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 1396.0 11.0 117.0 64.0   29.0         120.0   896.0 841.0       0.6               1737.0 1396 11 117 64   29         120   896 841                 1737
456577 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 1396.0 11.0 117.0 64.0   29.0         120.0   896.0 841.0                       1737.0 1396 11 117 64   29         120   896 841                 1737
457469 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0       2.7               1389.0 1088 89 89 25   15       3 80   669 720                 1389
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
449031 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   k_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0       3.1               1410.0 1132 18 94 74   42       2 48   697 713                 1410
449051 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   pk_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0                       1410.0 1132 18 94 74   42       2 48   697 713                 1410
453005 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2021   k_12_total 1185.0 28.0 49.0 6.0   19.0         43.0   671.0 659.0       1.4               1330.0 1185 28 49 6   19         43   671 659                 1330
453023 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2021   pk_12_total 1185.0 28.0 49.0 6.0   19.0         43.0   671.0 659.0                       1330.0 1185 28 49 6   19         43   671 659                 1330
458864 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2021   k_12_total 1086.0 12.0 51.0 50.0   8.0       1.0 30.0   617.0 621.0       1.1               1238.0 1086 12 51 50   8       1 30   617 621                 1238
458882 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2021   pk_12_total 1086.0 12.0 51.0 50.0   8.0       1.0 30.0   617.0 621.0                       1238.0 1086 12 51 50   8       1 30   617 621                 1238
449987 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 1165.0 48.0 41.0 5.0   24.0         36.0   700.0 619.0       1.3               1319.0 1165 48 41 5   24         36   700 619                 1319
450001 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 1165.0 48.0 41.0 5.0   24.0         36.0   700.0 619.0                       1319.0 1165 48 41 5   24         36   700 619                 1319
457454 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 783.0 102.0 149.0 57.0   25.0       2.0 75.0   608.0 585.0       4.2               1193.0 783 102 149 57   25       2 75   608 585                 1193
457538 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 783.0 102.0 149.0 57.0   25.0       2.0 75.0   608.0 585.0                       1193.0 783 102 149 57   25       2 75   608 585                 1193
457473 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 809.0 101.0 72.0 28.0   17.0       2.0 78.0   546.0 561.0       4.3               1107.0 809 101 72 28   17       2 78   546 561                 1107
457557 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 809.0 101.0 72.0 28.0   17.0       2.0 78.0   546.0 561.0                       1107.0 809 101 72 28   17       2 78   546 561                 1107
450230 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 831.0 23.0 54.0 17.0   43.0       1.0 43.0   505.0 507.0       1.7               1012.0 831 23 54 17   43       1 43   505 507                 1012
450242 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 831.0 23.0 54.0 17.0   43.0       1.0 43.0   505.0 507.0                       1012.0 831 23 54 17   43       1 43   505 507                 1012
457487 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 290.0 239.0 198.0 54.0   80.0       1.0 76.0   473.0 465.0       26.4               938.0 290 239 198 54   80       1 76   473 465                 938
457571 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 290.0 239.0 198.0 54.0   80.0       1.0 76.0   473.0 465.0                       938.0 290 239 198 54   80       1 76   473 465                 938
457558 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 704.0 70.0 71.0 22.0   22.0       3.0 73.0   505.0 460.0                       965.0 704 70 71 22   22       3 73   505 460                 965
457459 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 319.0 176.0 244.0 75.0   21.0       1.0 81.0   473.0 444.0       22.0               917.0 319 176 244 75   21       1 81   473 444                 917
457543 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 319.0 176.0 244.0 75.0   21.0       1.0 81.0   473.0 444.0                       917.0 319 176 244 75   21       1 81   473 444                 917
459690 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   k_12_total 777.0 15.0 74.0 45.0   6.0         22.0   497.0 442.0       1.9               939.0 777 15 74 45   6         22   497 442                 939
459702 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   pk_12_total 777.0 15.0 74.0 45.0   6.0         22.0   497.0 442.0                       939.0 777 15 74 45   6         22   497 442                 939
451440 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   k_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0       0.8               870.0 576 16 102 54   11       1 110   447 423                 870
451448 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0                       870.0 576 16 102 54   11       1 110   447 423                 870
455221 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   k_12_total 731.0 11.0 50.0 38.0   8.0       3.0 21.0   439.0 423.0       2.2               862.0 731 11 50 38   8       3 21   439 423                 862
455235 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   pk_12_total 731.0 11.0 50.0 38.0   8.0       3.0 21.0   439.0 423.0                       862.0 731 11 50 38   8       3 21   439 423                 862
457537 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 690.0 56.0 39.0 10.0   16.0       1.0 41.0   435.0 418.0                       853.0 690 56 39 10   16       1 41   435 418                 853
450233 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 630.0 30.0 48.0 13.0   25.0       1.0 47.0   377.0 417.0       3.3               794.0 630 30 48 13   25       1 47   377 417                 794
450245 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 630.0 30.0 48.0 13.0   25.0       1.0 47.0   377.0 417.0                       794.0 630 30 48 13   25       1 47   377 417                 794
457453 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 683.0 56.0 37.0 10.0   15.0       1.0 40.0   431.0 411.0       2.4               842.0 683 56 37 10   15       1 40   431 411                 842
456030 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2021   k_12_total 593.0 4.0 31.0 109.0   4.0         74.0   407.0 408.0       0.5               815.0 593 4 31 109   4         74   407 408                 815
456040 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2021   pk_12_total 593.0 4.0 31.0 109.0   4.0         74.0   407.0 408.0                       815.0 593 4 31 109   4         74   407 408                 815
457474 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 648.0 42.0 48.0 10.0   19.0       2.0 58.0   426.0 401.0       1.9               827.0 648 42 48 10   19       2 58   426 401                 827
453006 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School Not applicable Middle 06 08 2021   k_12_total 707.0 35.0 34.0 6.0   13.0         38.0   438.0 395.0       2.6               833.0 707 35 34 6   13         38   438 395                 833
453024 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School Not applicable Middle 06 08 2021   pk_12_total 707.0 35.0 34.0 6.0   13.0         38.0   438.0 395.0                       833.0 707 35 34 6   13         38   438 395                 833
454885 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2021   k_12_total 657.0 6.0 36.0 26.0   3.0       1.0 35.0   385.0 379.0       0.0               764.0 657 6 36 26   3       1 35   385 379                 764
454909 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2021   pk_12_total 657.0 6.0 36.0 26.0   3.0       1.0 35.0   385.0 379.0                       764.0 657 6 36 26   3       1 35   385 379                 764
457435 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2021   grade_9 498.0 70.0 103.0 42.0   14.0       0.0 50.0   410.0 367.0                       777.0 498 70 103 42   14       0 50   410 367                 777
457563 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 559.0 17.0 99.0 2.0   1.0         28.0   344.0 362.0                       706.0 559 17 99 2   1         28   344 362                 706
451438 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   k_12_total 559.0 22.0 62.0 55.0   13.0       4.0 62.0   418.0 359.0       0.4               777.0 559 22 62 55   13       4 62   418 359                 777
451446 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   pk_12_total 559.0 22.0 62.0 55.0   13.0       4.0 62.0   418.0 359.0                       777.0 559 22 62 55   13       4 62   418 359                 777
455719 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2021   pk_12_total     12.0 688.0             4.0   347.0 357.0                       704.0     12 688             4   347 357                 704
453556 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   k_12_total 365.0 10.0 188.0 9.0   150.0       6.0 12.0   385.0 355.0       21.6               740.0 365 10 188 9   150       6 12   385 355                 740
453570 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   pk_12_total 365.0 10.0 188.0 9.0   150.0       6.0 12.0   385.0 355.0                       740.0 365 10 188 9   150       6 12   385 355                 740
456027 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 490.0 6.0 43.0 91.0   11.0         70.0   362.0 349.0       1.3               711.0 490 6 43 91   11         70   362 349                 711
456037 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 490.0 6.0 43.0 91.0   11.0         70.0   362.0 349.0                       711.0 490 6 43 91   11         70   362 349                 711
457479 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 538.0 17.0 94.0 2.0   1.0         25.0   328.0 349.0       0.0               677.0 538 17 94 2   1         25   328 349                 677
455707 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School Not applicable Elementary PK 08 2021   k_12_total     12.0 669.0             4.0   338.0 347.0       0.4               685.0     12 669             4   338 347                 685
457548 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 581.0 31.0 23.0 10.0   9.0         38.0   345.0 347.0                       692.0 581 31 23 10   9         38   345 347                 692
457464 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 570.0 31.0 21.0 10.0   9.0         38.0   335.0 344.0       1.0               679.0 570 31 21 10   9         38   335 344                 679
455222 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 539.0 10.0 52.0 41.0   4.0         23.0   326.0 343.0       3.3               669.0 539 10 52 41   4         23   326 343                 669
455236 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 539.0 10.0 52.0 41.0   4.0         23.0   326.0 343.0                       669.0 539 10 52 41   4         23   326 343                 669
456526 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 565.0 2.0 32.0 39.0   8.0       1.0 43.0   347.0 343.0       0.4               690.0 565 2 32 39   8       1 43   347 343                 690
456576 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2021   pk_12_total 565.0 2.0 32.0 39.0   8.0       1.0 43.0   347.0 343.0                       690.0 565 2 32 39   8       1 43   347 343                 690
457875 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2021   k_12_total 613.0 4.0 38.0 15.0   11.0       1.0 13.0   353.0 342.0       0.9               695.0 613 4 38 15   11       1 13   353 342                 695
457891 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2021   pk_12_total 613.0 4.0 38.0 15.0   11.0       1.0 13.0   353.0 342.0                       695.0 613 4 38 15   11       1 13   353 342                 695
451439 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 486.0 16.0 65.0 41.0   7.0       1.0 46.0   325.0 337.0       0.5               662.0 486 16 65 41   7       1 46   325 337                 662
451447 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 486.0 16.0 65.0 41.0   7.0       1.0 46.0   325.0 337.0                       662.0 486 16 65 41   7       1 46   325 337                 662
449988 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School Not applicable Middle 05 06 2021   k_12_total 609.0 32.0 20.0 6.0   12.0         26.0   370.0 335.0       1.7               705.0 609 32 20 6   12         26   370 335                 705
450002 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School Not applicable Middle 05 06 2021   pk_12_total 609.0 32.0 20.0 6.0   12.0         26.0   370.0 335.0                       705.0 609 32 20 6   12         26   370 335                 705
457546 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 240.0 78.0 240.0 51.0   7.0         52.0   333.0 335.0                       668.0 240 78 240 51   7         52   333 335                 668
449989 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School Not applicable Middle 07 08 2021   k_12_total 606.0 32.0 22.0 4.0   14.0       1.0 25.0   372.0 332.0       2.3               704.0 606 32 22 4   14       1 25   372 332                 704
450003 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School Not applicable Middle 07 08 2021   pk_12_total 606.0 32.0 22.0 4.0   14.0       1.0 25.0   372.0 332.0                       704.0 606 32 22 4   14       1 25   372 332                 704
456483 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2021   grade_9 327.0 6.0 53.0 200.0   5.0         75.0   342.0 324.0                       666.0 327 6 53 200   5         75   342 324                 666
457015 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2021   grade_10 451.0 63.0 103.0 17.0   12.0       0.0 29.0   353.0 322.0                       675.0 451 63 103 17   12       0 29   353 322                 675
457478 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 315.0 131.0 114.0 25.0   46.0       1.0 54.0   364.0 322.0       25.5               686.0 315 131 114 25   46       1 54   364 322                 686
457562 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 315.0 131.0 114.0 25.0   46.0       1.0 54.0   364.0 322.0                       686.0 315 131 114 25   46       1 54   364 322                 686
459691 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 521.0 8.0 57.0 29.0   3.0       1.0 21.0   321.0 319.0       2.3               640.0 521 8 57 29   3       1 21   321 319                 640
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
457544 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 488.0 67.0 41.0 18.0   12.0         59.0   370.0 315.0                       685.0 488 67 41 18   12         59   370 315                 685
458866 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School Not applicable Middle 07 08 2021   k_12_total 540.0 4.0 22.0 23.0   7.0       1.0 33.0   315.0 315.0       1.6               630.0 540 4 22 23   7       1 33   315 315                 630
458884 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School Not applicable Middle 07 08 2021   pk_12_total 540.0 4.0 22.0 23.0   7.0       1.0 33.0   315.0 315.0                       630.0 540 4 22 23   7       1 33   315 315                 630
456510 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2021   k_12_total 416.0 5.0 53.0 76.0   11.0         89.0   337.0 313.0       0.8               650.0 416 5 53 76   11         89   337 313                 650
456560 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2021   pk_12_total 416.0 5.0 53.0 76.0   11.0         89.0   337.0 313.0                       650.0 416 5 53 76   11         89   337 313                 650
457463 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 461.0 40.0 48.0 19.0   9.0         53.0   320.0 310.0       1.8               630.0 461 40 48 19   9         53   320 310                 630
457547 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 461.0 40.0 48.0 19.0   9.0         53.0   320.0 310.0                       630.0 461 40 48 19   9         53   320 310                 630
457876 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School Not applicable Middle 06 08 2021   k_12_total 550.0 3.0 27.0 15.0   7.0       1.0 13.0   312.0 304.0       1.1               616.0 550 3 27 15   7       1 13   312 304                 616
457892 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School Not applicable Middle 06 08 2021   pk_12_total 550.0 3.0 27.0 15.0   7.0       1.0 13.0   312.0 304.0                       616.0 550 3 27 15   7       1 13   312 304                 616
449991 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School Not applicable Elementary KG 04 2021   k_12_total 583.0 12.0 21.0 6.0   8.0         32.0   359.0 303.0       1.1               662.0 583 12 21 6   8         32   359 303                 662
450005 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School Not applicable Elementary KG 04 2021   pk_12_total 583.0 12.0 21.0 6.0   8.0         32.0   359.0 303.0                       662.0 583 12 21 6   8         32   359 303                 662
458865 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School Not applicable Middle 05 06 2021   k_12_total 493.0 3.0 38.0 24.0   1.0         24.0   284.0 299.0       2.6               583.0 493 3 38 24   1         24   284 299                 583
458883 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School Not applicable Middle 05 06 2021   pk_12_total 493.0 3.0 38.0 24.0   1.0         24.0   284.0 299.0                       583.0 493 3 38 24   1         24   284 299                 583
456529 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 424.0 13.0 56.0 48.0   2.0         56.0   301.0 298.0       0.5               599.0 424 13 56 48   2         56   301 298                 599
456579 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School Not applicable Middle 06 08 2021   pk_12_total 424.0 13.0 56.0 48.0   2.0         56.0   301.0 298.0                       599.0 424 13 56 48   2         56   301 298                 599
457462 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 204.0 74.0 220.0 48.0   6.0         49.0   305.0 296.0       28.8               601.0 204 74 220 48   6         49   305 296                 601
457444 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_9 248.0 139.0 93.0 42.0   41.0       2.0 29.0   300.0 294.0                       594.0 248 139 93 42   41       2 29   300 294                 594
457005 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2021   grade_10 377.0 60.0 65.0 29.0   17.0       1.0 26.0   284.0 291.0                       575.0 377 60 65 29   17       1 26   284 291                 575
457425 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2021   grade_9 394.0 59.0 69.0 44.0   11.0       1.0 24.0   313.0 289.0                       602.0 394 59 69 44   11       1 24   313 289                 602
449990 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2021   k_12_total 466.0 32.0 28.0 5.0   20.0       3.0 21.0   287.0 288.0       7.0               575.0 466 32 28 5   20       3 21   287 288                 575

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