Data source: Big Local News · About: Big Local

10,768 rows where state = "SD" and year = 2020 sorted by black 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
495489 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_11 241.0 96.0 49.0 11.0   35.0       0.0 14.0   207.0 239.0                       446.0 241 96 49 11   35       0 14   207 239                 446
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
495908 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 141.0 92.0 99.0 55.0   20.0         39.0   238.0 208.0       28.3               446.0 141 92 99 55   20         39   238 208                 446
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
487344 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 9.0 27.0 22.0   7.0       1.0 10.0   168.0 171.0                       339.0 263 9 27 22   7       1 10   168 171                 339
487453 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 318.0 9.0 6.0 13.0   5.0         13.0   196.0 168.0       0.8               364.0 318 9 6 13   5         13   196 168                 364
487460 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 227.0 9.0 32.0 23.0   11.0       1.0 32.0   180.0 155.0       7.5               335.0 227 9 32 23   11       1 32   180 155                 335
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
488638 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 189.0 9.0 16.0 5.0   8.0       0.0 20.0   119.0 128.0                       247.0 189 9 16 5   8       0 20   119 128                 247
488647 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   grade_9 228.0 9.0 14.0 9.0   8.0       1.0 23.0   143.0 149.0                       292.0 228 9 14 9   8       1 23   143 149                 292
491419 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   grade_9 276.0 9.0 10.0 0.0   6.0       0.0 11.0   157.0 155.0                       312.0 276 9 10 0   6       0 11   157 155                 312
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
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
494927 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School Not applicable High 09 12 2020   k_12_total 148.0 9.0 25.0 104.0   1.0         37.0   181.0 143.0       0.0               324.0 148 9 25 104   1         37   181 143                 324
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
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
495374 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2020   grade_1 0.0 9.0 18.0     2.0             17.0 12.0                       29.0 0 9 18     2             17 12                 29
495384 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 20.0 9.0 10.0 4.0   2.0         2.0   27.0 20.0                       47.0 20 9 10 4   2         2   27 20                 47
496014 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 20.0 9.0 21.0 5.0   2.0         3.0   30.0 30.0                       60.0 20 9 21 5   2         3   30 30                 60
496770 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School Not applicable Middle 07 08 2020   grade_7 72.0 9.0 5.0               1.0   38.0 49.0                       87.0 72 9 5               1   38 49                 87
496918 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   k_12_total 270.0 9.0 8.0 40.0   5.0         22.0   189.0 165.0       1.4               354.0 270 9 8 40   5         22   189 165                 354
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
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
495742 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School Not applicable Middle 06 08 2020   grade_6 106.0 88.0 70.0 19.0   30.0       0.0 23.0   178.0 158.0                       336.0 106 88 70 19   30       0 23   178 158                 336
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
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
487425 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School Not applicable Middle 06 08 2020   grade_7 154.0 8.0 7.0 13.0   2.0       1.0 7.0   101.0 91.0                       192.0 154 8 7 13   2       1 7   101 91                 192
488398 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School Not applicable Middle 07 08 2020   grade_8 304.0 8.0 11.0 1.0   4.0         12.0   179.0 161.0                       340.0 304 8 11 1   4         12   179 161                 340
488416 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   kindergarten 127.0 8.0 7.0 5.0   1.0       0.0 6.0   85.0 69.0                       154.0 127 8 7 5   1       0 6   85 69                 154
488618 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School Not applicable Elementary 04 05 2020   grade_4 202.0 8.0 18.0 4.0   3.0         12.0   126.0 121.0                       247.0 202 8 18 4   3         12   126 121                 247
489841 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   grade_3 155.0 8.0 18.0 15.0   4.0       1.0 29.0   120.0 110.0                       230.0 155 8 18 15   4       1 29   120 110                 230
489868 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   grade_9 184.0 8.0 26.0 26.0   4.0       2.0 19.0   140.0 129.0                       269.0 184 8 26 26   4       2 19   140 129                 269
491981 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   k_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0       44.8               478.0 166 8 156 11   119       2 16   253 225                 478
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
494919 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School Not applicable Elementary KG 05 2020   k_12_total 288.0 8.0 35.0 61.0   7.0         24.0   240.0 183.0       3.1               423.0 288 8 35 61   7         24   240 183                 423
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
495382 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School Not applicable Elementary KG 05 2020   grade_1 74.0 8.0 7.0 2.0   2.0         11.0   48.0 56.0                       104.0 74 8 7 2   2         11   48 56                 104
495387 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 33.0 8.0 17.0 9.0   0.0       0.0 10.0   39.0 38.0                       77.0 33 8 17 9   0       0 10   39 38                 77
495431 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School Not applicable High 09 12 2020   grade_10 52.0 8.0 3.0 1.0   1.0         2.0   38.0 29.0                       67.0 52 8 3 1   1         2   38 29                 67
495548 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 14.0 8.0 12.0 11.0   1.0       0.0 10.0   28.0 28.0                       56.0 14 8 12 11   1       0 10   28 28                 56
495553 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School Not applicable Elementary KG 05 2020   grade_2 43.0 8.0 8.0 13.0   0.0       1.0 9.0   44.0 38.0                       82.0 43 8 8 13   0       1 9   44 38                 82
495572 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 20.0 8.0 17.0 1.0   1.0         8.0   26.0 29.0                       55.0 20 8 17 1   1         8   26 29                 55
495589 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2020   grade_3 65.0 8.0 2.0 2.0   4.0         12.0   43.0 50.0                       93.0 65 8 2 2   4         12   43 50                 93
495590 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   grade_3 7.0 8.0 7.0 10.0   1.0       0.0 3.0   14.0 22.0                       36.0 7 8 7 10   1       0 3   14 22                 36
495668 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2020   grade_5 1.0 8.0 13.0     1.0             12.0 11.0                       23.0 1 8 13     1             12 11                 23
495669 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ Elementary   Regular School Not applicable Elementary KG 05 2020   grade_5 47.0 8.0 7.0 0.0   0.0         11.0   31.0 42.0                       73.0 47 8 7 0   0         11   31 42                 73
495687 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2020   grade_5 117.0 8.0 6.0 1.0   1.0       0.0 9.0   76.0 66.0                       142.0 117 8 6 1   1       0 9   76 66                 142
495851 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School Not applicable High 09 12 2020   grade_9 72.0 8.0 7.0 2.0   1.0         2.0   55.0 37.0                       92.0 72 8 7 2   1         2   55 37                 92
495926 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   kindergarten 16.0 8.0 8.0 13.0   0.0       1.0 8.0   24.0 30.0                       54.0 16 8 8 13   0       1 8   24 30                 54
495930 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School Not applicable Elementary PK 05 2020   kindergarten 21.0 8.0 16.0 6.0   7.0         4.0   30.0 32.0                       62.0 21 8 16 6   7         4   30 32                 62
495931 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School Not applicable Elementary KG 05 2020   kindergarten 50.0 8.0 9.0 9.0   2.0       1.0 13.0   47.0 45.0                       92.0 50 8 9 9   2       1 13   47 45                 92
495933 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2020   kindergarten 16.0 8.0 16.0 5.0   1.0       0.0 11.0   27.0 30.0                       57.0 16 8 16 5   1       0 11   27 30                 57
495941 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School Not applicable Elementary PK 05 2020   kindergarten 69.0 8.0 4.0 1.0   1.0         2.0   44.0 41.0                       85.0 69 8 4 1   1         2   44 41                 85
496759 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School Not applicable Elementary KG 06 2020   grade_4 75.0 8.0 4.0               3.0   46.0 44.0                       90.0 75 8 4               3   46 44                 90
496780 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School Not applicable Elementary KG 06 2020   kindergarten 69.0 8.0 9.0               2.0   42.0 46.0                       88.0 69 8 9               2   42 46                 88
496919 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School Not applicable High 09 12 2020   k_12_total 294.0 8.0 14.0 36.0   3.0         11.0   181.0 185.0       0.3               366.0 294 8 14 36   3         11   181 185                 366
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
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
495907 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0       19.7               509.0 280 79 81 14   19       4 32   283 226                 509
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
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
495991 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 280.0 79.0 81.0 14.0   19.0       4.0 32.0   283.0 226.0                       509.0 280 79 81 14   19       4 32   283 226                 509
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
495968 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 115.0 75.0 73.0 68.0   9.0       1.0 56.0   201.0 196.0                       397.0 115 75 73 68   9       1 56   201 196                 397
495531 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_12 255.0 73.0 48.0 11.0   33.0       0.0 9.0   228.0 201.0                       429.0 255 73 48 11   33       0 9   228 201                 429
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
487458 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 182.0 7.0 11.0 14.0   14.0       1.0 23.0   132.0 120.0       8.3               252.0 182 7 11 14   14       1 23   132 120                 252
487462 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 418.0 7.0 47.0 34.0   22.0       1.0 30.0   292.0 267.0       4.7               559.0 418 7 47 34   22       1 30   292 267                 559
487478 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 182.0 7.0 11.0 14.0   14.0       1.0 23.0   132.0 120.0                       252.0 182 7 11 14   14       1 23   132 120                 252
487482 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 418.0 7.0 47.0 34.0   22.0       1.0 30.0   292.0 267.0                       559.0 418 7 47 34   22       1 30   292 267                 559
488333 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 291.0 7.0 8.0 1.0   8.0         12.0   185.0 142.0                       327.0 291 7 8 1   8         12   185 142                 327
488353 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   grade_2 98.0 7.0 6.0 1.0   0.0       0.0 5.0   55.0 62.0                       117.0 98 7 6 1   0       0 5   55 62                 117
488367 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School Not applicable Elementary PK 04 2020   grade_4 99.0 7.0 2.0 1.0   0.0       0.0 7.0   64.0 52.0                       116.0 99 7 2 1   0       0 7   64 52                 116
488420 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2020   kindergarten 107.0 7.0 7.0     6.0       1.0 5.0   76.0 57.0                       133.0 107 7 7     6       1 5   76 57                 133
488644 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School Not applicable Middle 06 08 2020   grade_8 220.0 7.0 16.0 6.0   13.0       0.0 14.0   142.0 134.0                       276.0 220 7 16 6   13       0 14   142 134                 276
489447 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2020   grade_6 95.0 7.0 7.0 2.0   1.0       0.0 5.0   59.0 58.0                       117.0 95 7 7 2   1       0 5   59 58                 117
491318 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 71.0 7.0 9.0 1.0   2.0         4.0   47.0 47.0                       94.0 71 7 9 1   2         4   47 47                 94
491329 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   grade_10 268.0 7.0 8.0 1.0   4.0       1.0 11.0   138.0 162.0                       300.0 268 7 8 1   4       1 11   138 162                 300
491432 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 349.0 7.0 18.0 4.0   7.0         9.0   202.0 192.0       1.8               394.0 349 7 18 4   7         9   202 192                 394
491433 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 511.0 7.0 14.0 1.0   4.0         16.0   288.0 265.0       1.1               553.0 511 7 14 1   4         16   288 265                 553
491450 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 349.0 7.0 18.0 4.0   7.0         9.0   202.0 192.0                       394.0 349 7 18 4   7         9   202 192                 394
491451 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 522.0 7.0 14.0 1.0   4.0         16.0   297.0 267.0                       564.0 522 7 14 1   4         16   297 267                 564
492593 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   grade_9 4.0 7.0 2.0 15.0   1.0       2.0 0.0   19.0 12.0                       31.0 4 7 2 15   1       2 0   19 12                 31
493642 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 376.0 7.0 30.0 33.0   1.0         13.0   237.0 223.0       3.0               460.0 376 7 30 33   1         13   237 223                 460
493656 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School Not applicable Elementary KG 05 2020   pk_12_total 376.0 7.0 30.0 33.0   1.0         13.0   237.0 223.0                       460.0 376 7 30 33   1         13   237 223                 460
494665 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   grade_11 270.0 7.0 26.0 56.0   3.0       1.0 30.0   184.0 209.0                       393.0 270 7 26 56   3       1 30   184 209                 393
494916 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School Not applicable Elementary KG 05 2020   k_12_total 390.0 7.0 17.0 11.0   21.0         29.0   240.0 235.0       1.7               475.0 390 7 17 11   21         29   240 235                 475
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
494966 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School Not applicable Elementary KG 05 2020   pk_12_total 390.0 7.0 17.0 11.0   21.0         29.0   240.0 235.0                       475.0 390 7 17 11   21         29   240 235                 475
494968 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School Not applicable Elementary PK 05 2020   pk_12_total 83.0 7.0 81.0 264.0   5.0         79.0   265.0 254.0                       519.0 83 7 81 264   5         79   265 254                 519
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
495380 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 16.0 7.0 7.0 1.0   0.0       0.0 7.0   19.0 19.0                       38.0 16 7 7 1   0       0 7   19 19                 38
495383 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 91.0 7.0 0.0 3.0   2.0       0.0 2.0   45.0 60.0                       105.0 91 7 0 3   2       0 2   45 60                 105
495497 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School Not applicable High 12 12 2020   grade_12 28.0 7.0 3.0     1.0         4.0   27.0 16.0                       43.0 28 7 3     1         4   27 16                 43

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