Data source: Big Local News · About: Big Local

673 rows where grade = "k_12_total", state = "SD" and year = 2020 sorted by asian_int

View and edit SQL

year

  • 2020 · 673

grade

  • k_12_total · 673
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
492721 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School Not applicable Elementary PK 04 2020   k_12_total 336.0 3.0 8.0 5.0   0.0         16.0   189.0 179.0       0.0               368.0 336 3 8 5   0         16   189 179                 368
487544 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 57.0   6.0 5.0   1.0         3.0   36.0 36.0       4.2               72.0 57   6 5   1         3   36 36                 72
487593 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 181.0   9.0 2.0   1.0         8.0   106.0 95.0       0.5               201.0 181   9 2   1         8   106 95                 201
487719 SD     school 4603720 38001   Arlington 38-1 460372000877 3 Arlington Junior High School   Regular School Not applicable Middle 07 08 2020   k_12_total 46.0   2.0 1.0   1.0             26.0 24.0       0.0               50.0 46   2 1   1             26 24                 50
487881 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School Not applicable Elementary PK 05 2020   k_12_total 198.0 1.0 9.0 3.0   1.0         8.0   104.0 116.0       2.7               220.0 198 1 9 3   1         8   104 116                 220
487883 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 107.0   3.0 1.0   1.0         7.0   70.0 49.0       1.7               119.0 107   3 1   1         7   70 49                 119
488009 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School Not applicable High 09 12 2020   k_12_total 31.0   9.0 98.0   1.0         28.0   91.0 76.0       0.0               167.0 31   9 98   1         28   91 76                 167
488059 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 147.0 1.0 14.0 1.0   1.0         1.0   95.0 70.0       1.8               165.0 147 1 14 1   1         1   95 70                 165
488313 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 49.0   1.0     1.0         3.0   30.0 24.0       0.0               54.0 49   1     1         3   30 24                 54
488314 SD     school 4607800 22001   Bowdle 22-1 460780000069 1 Bowdle High School   Regular School Not applicable High 09 12 2020   k_12_total 37.0         1.0             18.0 20.0       0.0               38.0 37         1             18 20                 38
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
488559 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 74.0 2.0 2.0 2.0   1.0         4.0   41.0 44.0       0.0               85.0 74 2 2 2   1         4   41 44                 85
488714 SD     school 4609512 26002   Burke 26-2 460951200101 1 Burke High School   Regular School Not applicable High 09 12 2020   k_12_total 73.0 2.0 4.0 13.0   1.0         4.0   58.0 39.0       0.0               97.0 73 2 4 13   1         4   58 39                 97
488810 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 206.0 4.0 6.0 4.0   1.0         2.0   119.0 104.0       0.0               223.0 206 4 6 4   1         2   119 104                 223
489226 SD     school 4614100 50005   Colman-Egan 50-5 461410000091 1 Colman-Egan Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 78.0 2.0 3.0 3.0   1.0             44.0 43.0       1.2               87.0 78 2 3 3   1             44 43                 87
489337 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 144.0   2.0 1.0   1.0             72.0 76.0       1.4               148.0 144   2 1   1             72 76                 148
489514 SD     school 4617850 38002   De Smet 38-2 461785000993 3 De Smet Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 59.0         1.0             37.0 23.0       0.0               60.0 59         1             37 23                 60
489634 SD     school 4678300 5006   Deubrook Area 05-6 467830000012 1 Deubrook High School   Regular School Not applicable High 09 12 2020   k_12_total 108.0 1.0 3.0 2.0   1.0             61.0 54.0       1.7               115.0 108 1 3 2   1             61 54                 115
489992 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   k_12_total 1.0     225.0   1.0       1.0     129.0 99.0       0.0               228.0 1     225   1       1     129 99                 228
490154 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School Not applicable High 09 12 2020   k_12_total 186.0 1.0 11.0     1.0         3.0   100.0 102.0       0.0               202.0 186 1 11     1         3   100 102                 202
490378 SD     school 4622560 44001   Eureka 44-1 462256000196 1 Eureka High School   Regular School Not applicable High 09 12 2020   k_12_total 43.0         1.0         1.0   21.0 24.0       0.0               45.0 43         1         1   21 24                 45
490437 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School Not applicable Elementary KG 06 2020   k_12_total 55.0   3.0 4.0   1.0             36.0 27.0       0.0               63.0 55   3 4   1             36 27                 63
490438 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School Not applicable High 09 12 2020   k_12_total 60.0   3.0 4.0   1.0             39.0 29.0       0.0               68.0 60   3 4   1             39 29                 68
490439 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School Not applicable Middle 07 08 2020   k_12_total 22.0     5.0   1.0             11.0 17.0       0.0               28.0 22     5   1             11 17                 28
490826 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School Not applicable High 09 12 2020   k_12_total 153.0   6.0 1.0   1.0         7.0   88.0 80.0       0.6               168.0 153   6 1   1         7   88 80                 168
490827 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 92.0   5.0 1.0   1.0         4.0   50.0 53.0       1.0               103.0 92   5 1   1         4   50 53                 103
490922 SD     school 4626970 53001   Gettysburg 53-1 462697000232 1 Gettysburg High School   Regular School Not applicable High 09 12 2020   k_12_total 65.0   3.0 6.0   1.0         2.0   38.0 39.0       0.0               77.0 65   3 6   1         2   38 39                 77
491018 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School Not applicable High 09 12 2020   k_12_total 171.0 1.0 3.0 1.0   1.0             95.0 82.0       0.0               177.0 171 1 3 1   1             95 82                 177
491019 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School Not applicable Middle 06 08 2020   k_12_total 125.0   1.0 1.0   1.0         2.0   68.0 62.0       0.8               130.0 125   1 1   1         2   68 62                 130
491080 SD     school 4630490 27001   Haakon 27-1 463049000247 3 Philip Junior High   Regular School Not applicable Middle 07 08 2020   k_12_total 44.0   1.0 1.0   1.0         6.0   28.0 25.0       0.0               53.0 44   1 1   1         6   28 25                 53
491131 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 178.0 1.0 9.0     1.0         3.0   110.0 82.0       3.1               192.0 178 1 9     1         3   110 82                 192
491430 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School Not applicable Middle 06 08 2020   k_12_total 399.0 6.0 18.0 1.0   1.0         16.0   222.0 219.0       0.9               441.0 399 6 18 1   1         16   222 219                 441
491497 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 73.0         1.0             31.0 43.0       0.0               74.0 73         1             31 43                 74
491498 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School Not applicable High 09 12 2020   k_12_total 46.0   1.0 1.0   1.0             22.0 27.0       0.0               49.0 46   1 1   1             22 27                 49
491643 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 84.0   17.0 4.0   1.0         5.0   53.0 58.0       1.8               111.0 84   17 4   1         5   53 58                 111
491769 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 235.0 2.0 16.0 27.0   1.0       3.0 46.0   178.0 152.0       0.6               330.0 235 2 16 27   1       3 46   178 152                 330
492078 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School Not applicable Elementary PK 05 2020   k_12_total 149.0 1.0 4.0 2.0   1.0         1.0   73.0 85.0       0.0               158.0 149 1 4 2   1         1   73 85                 158
492080 SD     school 4636060 22006   Ipswich Public 22-6 463606000914 4 Ipswich MS   Regular School Not applicable Middle 06 08 2020   k_12_total 75.0         1.0         1.0   45.0 32.0       0.0               77.0 75         1         1   45 32                 77
492724 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School Not applicable Middle 07 08 2020   k_12_total 174.0   2.0 4.0   1.0         9.0   104.0 86.0       1.1               190.0 174   2 4   1         9   104 86                 190
492725 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School Not applicable Elementary PK 04 2020   k_12_total 81.0   3.0 3.0   1.0         1.0   57.0 32.0       0.0               89.0 81   3 3   1         1   57 32                 89
492986 SD     school 4645450 60003   Marion 60-3 464545000408 1 Marion High School   Regular School Not applicable High 09 12 2020   k_12_total 44.0   4.0 2.0   1.0       1.0 1.0   33.0 20.0       0.0               53.0 44   4 2   1       1 1   33 20                 53
493098 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School Not applicable High 09 12 2020   k_12_total 27.0   1.0 22.0   1.0         3.0   33.0 21.0       1.9               54.0 27   1 22   1         3   33 21                 54
493306 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School Not applicable Elementary KG 04 2020   k_12_total 453.0 3.0 25.0 13.0   1.0         25.0   282.0 238.0       0.0               520.0 453 3 25 13   1         25   282 238                 520
493311 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School Not applicable Middle 06 08 2020   k_12_total 371.0 3.0 18.0 18.0   1.0         20.0   242.0 189.0       0.0               431.0 371 3 18 18   1         20   242 189                 431
493478 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 337.0 4.0 54.0 3.0   1.0       0.0 18.0   221.0 196.0       8.9               417.0 337 4 54 3   1       0 18   221 196                 417
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
493717 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2020   k_12_total 77.0   1.0 57.0   1.0             62.0 74.0       0.0               136.0 77   1 57   1             62 74                 136
493719 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 86.0 1.0 4.0 45.0   1.0         5.0   70.0 72.0       0.0               142.0 86 1 4 45   1         5   70 72                 142
493931 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 44.0 3.0 2.0 3.0   1.0         1.0   30.0 24.0       0.0               54.0 44 3 2 3   1         1   30 24                 54
494194 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School Not applicable High 09 12 2020   k_12_total 39.0         1.0         1.0   25.0 16.0       0.0               41.0 39         1         1   25 16                 41
494348 SD     school 4654300 33003   Parkston 33-3 465430000491 2 Parkston Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 229.0   5.0 2.0   1.0         6.0   128.0 115.0       0.0               243.0 229   5 2   1         6   128 115                 243
494435 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 296.0 1.0 25.0 82.0   1.0         39.0   213.0 231.0       0.5               444.0 296 1 25 82   1         39   213 231                 444
494517 SD     school 4655710 1001   Plankinton 01-1 465571000927 3 Plankinton Junior High   Regular School Not applicable Middle 07 08 2020   k_12_total 35.0   10.0 3.0   1.0             25.0 24.0       6.1               49.0 35   10 3   1             25 24                 49
494913 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School Not applicable Elementary KG 05 2020   k_12_total 289.0 3.0 34.0 31.0   1.0       5.0 42.0   207.0 198.0       0.7               405.0 289 3 34 31   1       5 42   207 198                 405
494923 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School Not applicable High 12 12 2020   k_12_total 20.0 1.0 5.0 3.0   1.0         2.0   21.0 11.0       0.0               32.0 20 1 5 3   1         2   21 11                 32
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
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
495064 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 122.0 4.0 8.0 2.0   1.0             80.0 57.0       0.7               137.0 122 4 8 2   1             80 57                 137
495306 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School Not applicable High 09 12 2020   k_12_total 76.0   1.0     1.0         2.0   37.0 43.0       0.0               80.0 76   1     1         2   37 43                 80
495870 SD     school 4666270 49005   Sioux Falls 49-5 466627001128 50 All City Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 136.0 5.0 2.0     1.0         2.0   80.0 66.0       4.1               146.0 136 5 2     1         2   80 66                 146
495875 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School Not applicable High 12 12 2020   k_12_total 28.0 7.0 3.0     1.0         4.0   27.0 16.0       14.0               43.0 28 7 3     1         4   27 16                 43
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
496121 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School Not applicable High 09 12 2020   k_12_total 87.0 1.0 12.0 134.0   1.0         11.0   137.0 109.0       1.2               246.0 87 1 12 134   1         11   137 109                 246
496193 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 23.0     17.0   1.0         1.0   23.0 19.0       0.0               42.0 23     17   1         1   23 19                 42
496483 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 438.0 4.0 21.0 3.0   1.0         18.0   253.0 232.0       1.2               485.0 438 4 21 3   1         18   253 232                 485
496484 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 389.0 16.0 19.0 6.0   1.0         25.0   240.0 216.0       2.6               456.0 389 16 19 6   1         25   240 216                 456
496485 SD     school 4600052 41005   Tea Area 41-5 460005201400 6 Tea Area Venture Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 318.0 4.0 12.0 11.0   1.0         16.0   197.0 165.0       0.8               362.0 318 4 12 11   1         16   197 165                 362
496694 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 5.0   3.0 14.0   1.0             12.0 11.0       4.4               23.0 5   3 14   1             12 11                 23
496703 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School Not applicable High 09 12 2020   k_12_total 7.0   3.0 495.0   1.0         1.0   257.0 250.0       2.0               507.0 7   3 495   1         1   257 250                 507
496852 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School Not applicable High 09 12 2020   k_12_total 24.0   1.0 3.0   1.0             15.0 14.0       0.0               29.0 24   1 3   1             15 14                 29
496853 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School Not applicable Middle 07 08 2020   k_12_total 16.0   1.0     1.0         1.0   9.0 10.0       0.0               19.0 16   1     1         1   9 10                 19
497047 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School Not applicable High 09 12 2020   k_12_total 65.0   4.0 93.0   1.0         15.0   81.0 97.0       0.0               178.0 65   4 93   1         15   81 97                 178
497110 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School Not applicable Elementary KG 05 2020   k_12_total 91.0 3.0 1.0 20.0   1.0         5.0   50.0 71.0       0.0               121.0 91 3 1 20   1         5   50 71                 121
497112 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 57.0     12.0   1.0         2.0   37.0 35.0       0.0               72.0 57     12   1         2   37 35                 72
497272 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School Not applicable Elementary KG 04 2020   k_12_total 191.0   7.0 10.0   1.0         11.0   111.0 109.0       0.0               220.0 191   7 10   1         11   111 109                 220
497386 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School Not applicable High 09 12 2020   k_12_total 77.0   1.0 3.0   1.0       1.0 3.0   44.0 42.0       0.0               86.0 77   1 3   1       1 3   44 42                 86
497435 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 111.0   2.0 1.0   1.0       1.0 5.0   63.0 58.0       0.0               121.0 111   2 1   1       1 5   63 58                 121
497603 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 375.0 4.0 1.0 9.0   1.0         11.0   213.0 188.0       0.0               401.0 375 4 1 9   1         11   213 188                 401
498078 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 281.0 4.0 35.0 25.0   1.0         25.0   181.0 190.0       4.6               371.0 281 4 35 25   1         25   181 190                 371
487882 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School Not applicable High 09 12 2020   k_12_total 142.0 1.0 7.0 2.0   2.0         1.0   80.0 75.0       1.3               155.0 142 1 7 2   2         1   80 75                 155
487954 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School Not applicable High 09 12 2020   k_12_total 341.0   27.0 7.0   2.0         23.0   193.0 207.0       0.5               400.0 341   27 7   2         23   193 207                 400
488137 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School Not applicable Elementary KG 06 2020   k_12_total 73.0   1.0 1.0   2.0         1.0   36.0 42.0       0.0               78.0 73   1 1   2         1   36 42                 78
488558 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School Not applicable High 09 12 2020   k_12_total 83.0 2.0 3.0 2.0   2.0             61.0 31.0       0.0               92.0 83 2 3 2   2             61 31                 92
488811 SD     school 4610560 41001   Canton 41-1 461056000108 2 Lawrence Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 377.0 2.0 7.0 3.0   2.0         10.0   201.0 200.0       0.8               401.0 377 2 7 3   2         10   201 200                 401
488970 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School Not applicable High 09 12 2020   k_12_total 143.0 1.0 10.0 86.0   2.0       1.0 4.0   118.0 129.0       0.8               247.0 143 1 10 86   2       1 4   118 129                 247
489286 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School Not applicable High 09 12 2020   k_12_total 59.0     9.0   2.0         4.0   37.0 37.0       0.0               74.0 59     9   2         4   37 37                 74
489287 SD     school 4614130 59003   Colome Consolidated 461413000893 3 Colome Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 44.0     4.0   2.0         2.0   21.0 31.0       0.0               52.0 44     4   2         2   21 31                 52
490030 SD     school 4620850 23001   Edgemont 23-1 462085000182 1 Edgemont High School   Regular School Not applicable High 09 12 2020   k_12_total 39.0     4.0   2.0         1.0   23.0 23.0       0.0               46.0 39     4   2         1   23 23                 46
490769 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School Not applicable Elementary KG 06 2020   k_12_total 131.0   18.0 2.0   2.0             74.0 79.0       7.8               153.0 131   18 2   2             74 79                 153
490971 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School Not applicable Middle 06 08 2020   k_12_total 67.0 1.0 2.0 18.0   2.0       2.0 1.0   47.0 46.0       0.0               93.0 67 1 2 18   2       2 1   47 46                 93
491079 SD     school 4630490 27001   Haakon 27-1 463049000256 1 Philip High School   Regular School Not applicable High 09 12 2020   k_12_total 79.0   1.0 6.0   2.0         3.0   49.0 42.0       0.0               91.0 79   1 6   2         3   49 42                 91
491771 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School Not applicable Middle 06 08 2020   k_12_total 133.0 2.0 11.0 15.0   2.0         23.0   101.0 85.0       0.0               186.0 133 2 11 15   2         23   101 85                 186
492079 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 101.0 1.0 3.0     2.0         4.0   55.0 56.0       0.0               111.0 101 1 3     2         4   55 56                 111
492198 SD     school 4636150 2003   Iroquois 02-3 463615000339 1 Iroquois High School   Regular School Not applicable High 09 12 2020   k_12_total 61.0   1.0 1.0   2.0             30.0 35.0       1.5               65.0 61   1 1   2             30 35                 65
492334 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School Not applicable High 09 12 2020   k_12_total 44.0   2.0 32.0   2.0             40.0 40.0       0.0               80.0 44   2 32   2             40 40                 80
492597 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School Not applicable High 09 12 2020   k_12_total 20.0 10.0 2.0 33.0   2.0       4.0 4.0   51.0 24.0       17.3               75.0 20 10 2 33   2       4 4   51 24                 75
492723 SD     school 4641550 41004   Lennox 41-4 464155001363 9 Lennox Intermediate   Regular School Not applicable Middle 05 06 2020   k_12_total 164.0   4.0 3.0   2.0         3.0   85.0 91.0       1.1               176.0 164   4 3   2         3   85 91                 176
493307 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School Not applicable Middle 05 08 2020   k_12_total 381.0 4.0 14.0 13.0   2.0       1.0 18.0   221.0 212.0       0.0               433.0 381 4 14 13   2       1 18   221 212                 433
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
493542 SD     school 4647942 29004   Miller 464794200430 1 Miller High School   Regular School Not applicable High 09 12 2020   k_12_total 93.0         2.0         1.0   41.0 55.0       0.0               96.0 93         2         1   41 55                 96

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