Data source: Big Local News · About: Big Local

675 rows where grade = "k_12_total", state = "SD" and year = 2021 sorted by asian_int

View and edit SQL

year

  • 2021 · 675

grade

  • k_12_total · 675
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
455506 SD     school 4650850 9002   Newell 09-2 465085000468 2 Newell Elem   Regular School Not applicable Elementary PK 05 2021   k_12_total 103.0 0.0 6.0 1.0   0.0             47.0 63.0       0.0               110.0 103 0 6 1   0             47 63                 110
456514 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School Not applicable Other PK 12 2021   k_12_total 1.0   0.0 0.0   0.0         0.0   1.0 0.0       0.0               1.0 1   0 0   0         0   1 0                 1
458858 SD     school 4676620 14004   Watertown 14-4 467662001404 14 Garfield Education Center   Regular School Not applicable Elementary PK 06 2021   k_12_total 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
449170 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 183.0   7.0 2.0   1.0         5.0   99.0 99.0       0.5               198.0 183   7 2   1         5   99 99                 198
449458 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School Not applicable Elementary PK 05 2021   k_12_total 202.0 1.0 12.0 4.0   1.0         7.0   101.0 126.0       3.1               227.0 202 1 12 4   1         7   101 126                 227
449459 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School Not applicable High 09 12 2021   k_12_total 160.0   5.0 3.0   1.0         3.0   92.0 80.0       0.6               172.0 160   5 3   1         3   92 80                 172
449460 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 105.0   3.0 3.0   1.0         8.0   64.0 56.0       1.7               120.0 105   3 3   1         8   64 56                 120
449586 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School Not applicable High 09 12 2021   k_12_total 24.0   10.0 83.0   1.0         24.0   76.0 66.0       0.7               142.0 24   10 83   1         24   76 66                 142
449714 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School Not applicable Elementary KG 06 2021   k_12_total 71.0     1.0   1.0         1.0   33.0 41.0       0.0               74.0 71     1   1         1   33 41                 74
449716 SD     school 4607050 52001   Bison 52-1 460705000879 4 Bison JH   Regular School Not applicable Middle 07 08 2021   k_12_total 28.0   1.0     1.0             14.0 16.0       0.0               30.0 28   1     1             14 16                 30
450136 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 86.0 2.0 3.0 2.0   1.0       1.0 4.0   47.0 52.0       0.0               99.0 86 2 3 2   1       1 4   47 52                 99
450338 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School Not applicable Elementary PK 05 2021   k_12_total 94.0   4.0 1.0   1.0             50.0 50.0       0.0               100.0 94   4 1   1             50 50                 100
450387 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 202.0 2.0 5.0 4.0   1.0         4.0   112.0 106.0       0.5               218.0 202 2 5 4   1         4   112 106                 218
450546 SD     school 4612000 7001   Chamberlain 07-1 461200000118 3 Chamberlain Elementary School   Regular School Not applicable Elementary KG 05 2021   k_12_total 176.0 3.0 10.0 166.0   1.0         37.0   218.0 175.0       0.0               393.0 176 3 10 166   1         37   218 175                 393
450547 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School Not applicable High 09 12 2021   k_12_total 161.0 2.0 9.0 91.0   1.0         5.0   141.0 128.0       0.0               269.0 161 2 9 91   1         5   141 128                 269
450803 SD     school 4614100 50005   Colman-Egan 50-5 461410000091 1 Colman-Egan Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 75.0 3.0 6.0 3.0   1.0         1.0   44.0 45.0       3.4               89.0 75 3 6 3   1         1   44 45                 89
450914 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 133.0   2.0 3.0   1.0         6.0   74.0 71.0       1.4               145.0 133   2 3   1         6   74 71                 145
451090 SD     school 4617850 38002   De Smet 38-2 461785000163 1 De Smet High School   Regular School Not applicable High 09 12 2021   k_12_total 72.0   2.0     1.0         2.0   49.0 28.0       0.0               77.0 72   2     1         2   49 28                 77
451211 SD     school 4678300 5006   Deubrook Area 05-6 467830000012 1 Deubrook High School   Regular School Not applicable High 09 12 2021   k_12_total 105.0 2.0 5.0 1.0   1.0         1.0   61.0 54.0       0.9               115.0 105 2 5 1   1         1   61 54                 115
451715 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School Not applicable High 09 12 2021   k_12_total 190.0 1.0 6.0 1.0   1.0         4.0   109.0 94.0       0.0               203.0 190 1 6 1   1         4   109 94                 203
451998 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School Not applicable Elementary KG 06 2021   k_12_total 51.0   1.0 2.0   1.0       1.0 1.0   30.0 27.0       0.0               57.0 51   1 2   1       1 1   30 27                 57
451999 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School Not applicable High 09 12 2021   k_12_total 67.0   4.0 5.0   1.0             43.0 34.0       0.0               77.0 67   4 5   1             43 34                 77
452000 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School Not applicable Middle 07 08 2021   k_12_total 27.0   2.0 3.0   1.0             19.0 14.0       0.0               33.0 27   2 3   1             19 14                 33
452403 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School Not applicable High 09 12 2021   k_12_total 138.0   4.0 1.0   1.0         7.0   83.0 68.0       0.0               151.0 138   4 1   1         7   83 68                 151
452404 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 96.0   4.0     1.0         5.0   50.0 56.0       0.0               106.0 96   4     1         5   50 56                 106
452548 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School Not applicable Middle 06 08 2021   k_12_total 74.0   1.0 16.0   1.0       1.0     48.0 45.0       0.0               93.0 74   1 16   1       1     48 45                 93
452594 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School Not applicable Elementary PK 05 2021   k_12_total 264.0   10.0 7.0   1.0         4.0   157.0 129.0       1.1               286.0 264   10 7   1         4   157 129                 286
452595 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School Not applicable High 09 12 2021   k_12_total 176.0   3.0 4.0   1.0             96.0 88.0       0.5               184.0 176   3 4   1             96 88                 184
452596 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School Not applicable Middle 06 08 2021   k_12_total 131.0   5.0 2.0   1.0         2.0   74.0 67.0       2.1               141.0 131   5 2   1         2   74 67                 141
452657 SD     school 4630490 27001   Haakon 27-1 463049000247 3 Philip Junior High   Regular School Not applicable Middle 07 08 2021   k_12_total 43.0   2.0 1.0   1.0         4.0   25.0 26.0       2.0               51.0 43   2 1   1         4   25 26                 51
452708 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 185.0 2.0 8.0 1.0   1.0         3.0   124.0 76.0       3.0               200.0 185 2 8 1   1         3   124 76                 200
453075 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School Not applicable High 09 12 2021   k_12_total 48.0   1.0     1.0             24.0 26.0       0.0               50.0 48   1     1             24 26                 50
453076 SD     school 4632340 14002   Henry 14-2 463234001047 3 Henry MS   Regular School Not applicable Middle 06 08 2021   k_12_total 42.0         1.0             17.0 26.0       0.0               43.0 42         1             17 26                 43
453220 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 75.0   20.0 6.0   1.0         8.0   50.0 60.0       2.7               110.0 75   20 6   1         8   50 60                 110
453346 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 224.0 2.0 10.0 28.0   1.0       1.0 45.0   157.0 154.0       0.6               311.0 224 2 10 28   1       1 45   157 154                 311
453347 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 190.0 6.0 12.0 25.0   1.0         16.0   120.0 130.0       1.2               250.0 190 6 12 25   1         16   120 130                 250
453655 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School Not applicable Elementary PK 05 2021   k_12_total 146.0 3.0 6.0 2.0   1.0         1.0   72.0 87.0       1.3               159.0 146 3 6 2   1         1   72 87                 159
453911 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School Not applicable High 09 12 2021   k_12_total 46.0   2.0 26.0   1.0             40.0 35.0       0.0               75.0 46   2 26   1             40 35                 75
454298 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School Not applicable Elementary PK 04 2021   k_12_total 303.0 1.0 5.0 5.0   1.0         16.0   170.0 161.0       0.0               331.0 303 1 5 5   1         16   170 161                 331
454300 SD     school 4641550 41004   Lennox 41-4 464155001363 9 Lennox Intermediate   Regular School Not applicable Middle 05 06 2021   k_12_total 166.0 1.0 1.0 3.0   1.0         5.0   88.0 89.0       0.0               177.0 166 1 1 3   1         5   88 89                 177
454302 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School Not applicable Elementary PK 04 2021   k_12_total 88.0   4.0 3.0   1.0             57.0 39.0       0.0               96.0 88   4 3   1             57 39                 96
454516 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 245.0 1.0 20.0 2.0   1.0         8.0   135.0 142.0       2.2               277.0 245 1 20 2   1         8   135 142                 277
454887 SD     school 4669930 46001   Meade 46-1 466993001383 6 Sturgis Intermediate School   Regular School Not applicable Middle 05 05 2021   k_12_total 109.0 2.0 5.0 3.0   1.0         3.0   64.0 59.0       0.0               123.0 109 2 5 3   1         3   64 59                 123
455055 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   k_12_total 325.0 2.0 52.0 1.0   1.0       1.0 16.0   208.0 190.0       10.1               398.0 325 2 52 1   1       1 16   208 190                 398
455219 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 362.0 2.0 41.0 31.0   1.0         9.0   226.0 220.0       4.7               446.0 362 2 41 31   1         9   226 220                 446
455296 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 89.0 3.0 5.0 48.0   1.0         3.0   66.0 83.0       0.0               149.0 89 3 5 48   1         3   66 83                 149
455297 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2021   k_12_total 62.0 3.0 4.0 58.0   1.0         4.0   64.0 68.0       0.0               132.0 62 3 4 58   1         4   64 68                 132
456029 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School Not applicable Elementary KG 05 2021   k_12_total 266.0 3.0 14.0 71.0   1.0         42.0   210.0 187.0       0.3               397.0 266 3 14 71   1         42   210 187                 397
456109 SD     school 4655710 1001   Plankinton 01-1 465571000508 1 Plankinton High School   Regular School Not applicable High 09 12 2021   k_12_total 61.0   13.0 1.0   1.0             34.0 42.0       5.3               76.0 61   13 1   1             34 42                 76
456506 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School Not applicable Elementary KG 05 2021   k_12_total 264.0 4.0 35.0 34.0   1.0       2.0 43.0   194.0 189.0       0.3               383.0 264 4 35 34   1       2 43   194 189                 383
456515 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School Not applicable Elementary KG 05 2021   k_12_total 59.0   28.0 165.0   1.0         44.0   159.0 138.0       0.0               297.0 59   28 165   1         44   159 138                 297
456516 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School Not applicable High 12 12 2021   k_12_total 16.0   3.0 4.0   1.0         2.0   15.0 11.0       0.0               26.0 16   3 4   1         2   15 11                 26
456520 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Regular School Not applicable High 09 12 2021   k_12_total 156.0 7.0 36.0 102.0   1.0       1.0 39.0   174.0 168.0       0.6               342.0 156 7 36 102   1       1 39   174 168                 342
456521 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School Not applicable Elementary PK 05 2021   k_12_total 351.0 1.0 40.0 45.0   1.0         64.0   253.0 249.0       0.0               502.0 351 1 40 45   1         64   253 249                 502
456883 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School Not applicable High 09 12 2021   k_12_total 88.0         1.0         1.0   42.0 48.0       0.0               90.0 88         1         1   42 48                 90
457447 SD     school 4666270 49005   Sioux Falls 49-5 466627001128 50 All City Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 128.0 3.0 3.0     1.0         1.0   71.0 65.0       1.5               136.0 128 3 3     1         1   71 65                 136
457452 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School Not applicable High 12 12 2021   k_12_total 33.0 10.0 4.0 1.0   1.0         1.0   31.0 19.0       16.0               50.0 33 10 4 1   1         1   31 19                 50
457466 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 243.0 49.0 43.0 31.0   1.0       2.0 55.0   200.0 224.0       2.6               424.0 243 49 43 31   1       2 55   200 224                 424
457470 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School Not applicable High 09 12 2021   k_12_total 240.0 25.0 26.0 6.0   1.0       1.0 11.0   167.0 143.0       0.3               310.0 240 25 26 6   1       1 11   167 143                 310
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
457698 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School Not applicable High 09 12 2021   k_12_total 83.0   14.0 154.0   1.0         12.0   139.0 125.0       0.8               264.0 83   14 154   1         12   139 125                 264
457770 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 17.0     12.0   1.0         1.0   18.0 13.0       0.0               31.0 17     12   1         1   18 13                 31
458061 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 440.0 12.0 18.0 8.0   1.0       1.0 20.0   260.0 240.0       1.8               500.0 440 12 18 8   1       1 20   260 240                 500
458062 SD     school 4600052 41005   Tea Area 41-5 460005201400 6 Tea Area Venture Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 322.0 5.0 14.0 10.0   1.0         21.0   208.0 165.0       2.1               373.0 322 5 14 10   1         21   208 165                 373
458271 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total     3.0 6.0   1.0         1.0   8.0 3.0       9.1               11.0     3 6   1         1   8 3                 11
458429 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School Not applicable High 09 12 2021   k_12_total 33.0     1.0   1.0         3.0   19.0 19.0       0.0               38.0 33     1   1         3   19 19                 38
458430 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School Not applicable Middle 07 08 2021   k_12_total 14.0   1.0     1.0             6.0 10.0       0.0               16.0 14   1     1             6 10                 16
458624 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School Not applicable High 09 12 2021   k_12_total 69.0   7.0 100.0   1.0         22.0   97.0 102.0       0.0               199.0 69   7 100   1         22   97 102                 199
458687 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School Not applicable Elementary KG 05 2021   k_12_total 79.0 4.0 1.0 19.0   1.0         5.0   39.0 70.0       0.0               109.0 79 4 1 19   1         5   39 70                 109
458689 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 56.0     11.0   1.0       1.0 3.0   39.0 33.0       0.0               72.0 56     11   1       1 3   39 33                 72
458862 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School Not applicable Elementary KG 04 2021   k_12_total 176.0   11.0 12.0   1.0         9.0   109.0 100.0       0.0               209.0 176   11 12   1         9   109 100                 209
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
459028 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 101.0   6.0 1.0   1.0       1.0 7.0   60.0 57.0       1.7               117.0 101   6 1   1       1 7   60 57                 117
459214 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School Not applicable Middle 06 08 2021   k_12_total 283.0 3.0 10.0 2.0   1.0         6.0   161.0 144.0       1.3               305.0 283 3 10 2   1         6   161 144                 305
459522 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 192.0 2.0 3.0 156.0   1.0         2.0   186.0 170.0       0.0               356.0 192 2 3 156   1         2   186 170                 356
459523 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School Not applicable High 09 12 2021   k_12_total 152.0 1.0 2.0 47.0   1.0             101.0 102.0       1.0               203.0 152 1 2 47   1             101 102                 203
459524 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 92.0 2.0   56.0   1.0             85.0 66.0       0.0               151.0 92 2   56   1             85 66                 151
449634 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 283.0 2.0 21.0 2.0   2.0         3.0   160.0 153.0       5.1               313.0 283 2 21 2   2         3   160 153                 313
449890 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 49.0   2.0 0.0   2.0         4.0   31.0 26.0       0.0               57.0 49   2 0   2         4   31 26                 57
450135 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School Not applicable High 09 12 2021   k_12_total 91.0 1.0 2.0 1.0   2.0         2.0   57.0 42.0       0.0               99.0 91 1 2 1   2         2   57 42                 99
450863 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School Not applicable High 09 12 2021   k_12_total 46.0     13.0   2.0         3.0   33.0 31.0       0.0               64.0 46     13   2         3   33 31                 64
450864 SD     school 4614130 59003   Colome Consolidated 461413000893 3 Colome Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 32.0   2.0 6.0   2.0         3.0   16.0 29.0       0.0               45.0 32   2 6   2         3   16 29                 45
450975 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School Not applicable High 09 12 2021   k_12_total 237.0 3.0 18.0 11.0   2.0       1.0 10.0   141.0 141.0       0.0               282.0 237 3 18 11   2       1 10   141 141                 282
451553 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2021   k_12_total 1.0     248.0   2.0             124.0 127.0       0.0               251.0 1     248   2             124 127                 251
452175 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School Not applicable High 09 12 2021   k_12_total 88.0   29.0 57.0   2.0       1.0 7.0   111.0 73.0       9.8               184.0 88   29 57   2       1 7   111 73                 184
452274 SD     school 4621400 6002   Frederick Area 06-2 462140000189 2 Frederick Elementary   Regular School Not applicable Elementary KG 06 2021   k_12_total 69.0   1.0     2.0         3.0   39.0 36.0       0.0               75.0 69   1     2         3   39 36                 75
452346 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School Not applicable Elementary KG 05 2021   k_12_total 111.0   16.0 3.0   2.0             70.0 62.0       8.3               132.0 111   16 3   2             70 62                 132
452655 SD     school 4630490 27001   Haakon 27-1 463049000255 2 Philip Elementary School   Regular School Not applicable Elementary KG 06 2021   k_12_total 132.0   4.0 3.0   2.0         9.0   75.0 75.0       0.7               150.0 132   4 3   2         9   75 75                 150
453007 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School Not applicable Middle 06 08 2021   k_12_total 410.0 7.0 21.0     2.0         20.0   232.0 228.0       2.2               460.0 410 7 21     2         20   232 228                 460
453218 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 145.0   47.0 2.0   2.0         11.0   101.0 106.0       6.3               207.0 145   47 2   2         11   101 106                 207
453348 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 114.0 1.0 11.0 10.0   2.0       1.0 28.0   103.0 64.0       0.0               167.0 114 1 11 10   2       1 28   103 64                 167
453656 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 100.0 1.0 3.0     2.0         2.0   61.0 47.0       0.9               108.0 100 1 3     2         2   61 47                 108
454176 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School Not applicable High 09 12 2021   k_12_total 179.0 2.0 20.0 7.0   2.0       1.0 11.0   125.0 97.0       0.9               222.0 179 2 20 7   2       1 11   125 97                 222
454884 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School Not applicable Middle 05 08 2021   k_12_total 400.0 4.0 16.0 17.0   2.0       1.0 27.0   235.0 232.0       0.0               467.0 400 4 16 17   2       1 27   235 232                 467
454886 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School Not applicable Elementary KG 04 2021   k_12_total 457.0 4.0 31.0 11.0   2.0         29.0   295.0 239.0       0.0               534.0 457 4 31 11   2         29   295 239                 534
454888 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School Not applicable Middle 06 08 2021   k_12_total 345.0 3.0 23.0 9.0   2.0         24.0   230.0 176.0       0.0               406.0 345 3 23 9   2         24   230 176                 406
455941 SD     school 4654300 33003   Parkston 33-3 465430000491 2 Parkston Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 244.0   4.0 5.0   2.0         7.0   138.0 124.0       0.0               262.0 244   4 5   2         7   138 124                 262
456028 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 287.0 1.0 22.0 75.0   2.0         38.0   222.0 203.0       0.7               425.0 287 1 22 75   2         38   222 203                 425
456519 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School Not applicable Elementary KG 05 2021   k_12_total 303.0 4.0 13.0 14.0   2.0         30.0   173.0 193.0       1.4               366.0 303 4 13 14   2         30   173 193                 366
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

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