Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by asian_int

View and edit SQL

year

grade

  • k_12_total · 4,596
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
358444 SD     school 4609512 26002   Burke 26-2 460951200100 2 Burke Elementary School   Regular School No Elementary PK 05 2019   k_12_total 102.0     10.0   1.0         1.0   67.0 47.0       0.0               114.0 102     10   1         1   67 47                 114
358702 SD     school 4612000 7001   Chamberlain 07-1 461200000889 2 Chamberlain Jr. High   Regular School No Middle 06 08 2019   k_12_total 123.0   7.0 66.0   1.0         10.0   104.0 103.0       0.0               207.0 123   7 66   1         10   104 103                 207
358957 SD     school 4614100 50005   Colman-Egan 50-5 461410000091 1 Colman-Egan Hi Sch   Regular School No High 09 12 2019   k_12_total 68.0 3.0   2.0   1.0             40.0 34.0       0.0               74.0 68 3   2   1             40 34                 74
359068 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No Elementary PK 06 2019   k_12_total 140.0     0.0   1.0             70.0 71.0       0.0               141.0 140     0   1             70 71                 141
359130 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2019   k_12_total 94.0 2.0 7.0 5.0   1.0         2.0   52.0 59.0       0.0               111.0 94 2 7 5   1         2   52 59                 111
359245 SD     school 4617850 38002   De Smet 38-2 461785000993 3 De Smet Middle School   Regular School No Middle 06 08 2019   k_12_total 50.0   1.0     1.0             36.0 16.0       0.0               52.0 50   1     1             36 16                 52
359366 SD     school 4678300 5006   Deubrook Area 05-6 467830000016 2 Deubrook Jr High   Regular School No Middle 07 08 2019   k_12_total 63.0   2.0 1.0   1.0             29.0 38.0       0.0               67.0 63   2 1   1             29 38                 67
359708 SD     school 4620100 20001   Eagle Butte 20-1 462010000956 1 C-EB High School   Regular School No High 09 12 2019   k_12_total 5.0     3.0   1.0             5.0 4.0       0.0               9.0 5     3   1             5 4                 9
359709 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2019   k_12_total 2.0     81.0   1.0             44.0 40.0       0.0               84.0 2     81   1             44 40                 84
359710 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2019   k_12_total 2.0   1.0 242.0   1.0       1.0 1.0   125.0 123.0       0.0               248.0 2   1 242   1       1 1   125 123                 248
359884 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No Elementary KG 05 2019   k_12_total 292.0   22.0 4.0   1.0         14.0   169.0 164.0       1.5               333.0 292   22 4   1         14   169 164                 333
360109 SD     school 4622560 44001   Eureka 44-1 462256000196 1 Eureka High School   Regular School No High 09 12 2019   k_12_total 42.0         1.0         1.0   21.0 23.0       0.0               44.0 42         1         1   21 23                 44
360168 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School No Elementary KG 06 2019   k_12_total 59.0   3.0 5.0   1.0             38.0 30.0       0.0               68.0 59   3 5   1             38 30                 68
360170 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School No Middle 07 08 2019   k_12_total 20.0   1.0 3.0   1.0             13.0 12.0       0.0               25.0 20   1 3   1             13 12                 25
360429 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School No High 09 12 2019   k_12_total 50.0     1.0   1.0         1.0   30.0 23.0       0.0               53.0 50     1   1         1   30 23                 53
360604 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 05 2019   k_12_total 113.0 1.0 6.0 1.0   1.0         3.0   71.0 54.0       0.0               125.0 113 1 6 1   1         3   71 54                 125
360748 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No Elementary PK 05 2019   k_12_total 269.0   2.0 3.0   1.0         1.0   147.0 129.0       0.4               276.0 269   2 3   1         1   147 129                 276
360749 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2019   k_12_total 168.0 4.0 3.0 2.0   1.0             83.0 95.0       0.6               178.0 168 4 3 2   1             83 95                 178
360810 SD     school 4630490 27001   Haakon 27-1 463049000256 1 Philip High School   Regular School No High 09 12 2019   k_12_total 83.0 1.0 2.0 6.0   1.0         4.0   53.0 44.0       0.0               97.0 83 1 2 6   1         4   53 44                 97
360862 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No Middle 06 08 2019   k_12_total 174.0   10.0     1.0         6.0   111.0 80.0       2.6               191.0 174   10     1         6   111 80                 191
360946 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No High 09 12 2019   k_12_total 98.0   4.0 1.0   1.0         2.0   63.0 43.0       0.0               106.0 98   4 1   1         2   63 43                 106
361161 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2019   k_12_total 368.0 6.0 10.0     1.0         15.0   190.0 210.0       0.8               400.0 368 6 10     1         15   190 210                 400
361228 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2019   k_12_total 67.0         1.0             29.0 39.0       0.0               68.0 67         1             29 39                 68
361609 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2019   k_12_total 89.0 1.0 3.0     1.0         2.0   57.0 39.0       0.0               96.0 89 1 3     1         2   57 39                 96
361809 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No Elementary PK 05 2019   k_12_total 157.0 1.0 6.0 2.0   1.0         3.0   73.0 97.0       0.0               170.0 157 1 6 2   1         3   73 97                 170
361811 SD     school 4636060 22006   Ipswich Public 22-6 463606000914 4 Ipswich MS   Regular School No Middle 06 08 2019   k_12_total 80.0   3.0     1.0         1.0   53.0 32.0       0.0               85.0 80   3     1         1   53 32                 85
362454 SD     school 4641550 41004   Lennox 41-4 464155001363 9 Lennox Intermediate   Regular School No Middle 05 06 2019   k_12_total 159.0 1.0 2.0 3.0   1.0         9.0   90.0 85.0       1.1               175.0 159 1 2 3   1         9   90 85                 175
362829 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2019   k_12_total 31.0   3.0 21.0   1.0         1.0   28.0 29.0       3.5               57.0 31   3 21   1         1   28 29                 57
363037 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 04 2019   k_12_total 426.0 2.0 19.0 14.0   1.0         23.0   264.0 221.0       0.0               485.0 426 2 19 14   1         23   264 221                 485
363041 SD     school 4669930 46001   Meade 46-1 466993001383 6 Sturgis Intermediate School   Regular School No Middle 05 05 2019   k_12_total 112.0 1.0 6.0 3.0   1.0         6.0   71.0 58.0       0.0               129.0 112 1 6 3   1         6   71 58                 129
363196 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   k_12_total 355.0 6.0 47.0 5.0   1.0         15.0   226.0 203.0       5.8               429.0 355 6 47 5   1         15   226 203                 429
363257 SD     school 4647942 29004   Miller 464794200430 1 Miller High School   Regular School No High 09 12 2019   k_12_total 105.0   2.0     1.0         2.0   47.0 63.0       0.0               110.0 105   2     1         2   47 63                 110
363258 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2019   k_12_total 62.0 1.0       1.0       1.0     34.0 31.0       0.0               65.0 62 1       1       1     34 31                 65
363432 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2019   k_12_total 71.0 1.0 1.0 54.0   1.0             57.0 71.0       0.0               128.0 71 1 1 54   1             57 71                 128
363434 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No Middle 06 08 2019   k_12_total 86.0 1.0 5.0 52.0   1.0         4.0   75.0 74.0       0.0               149.0 86 1 5 52   1         4   75 74                 149
363645 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2019   k_12_total 81.0 4.0 1.0 2.0   1.0       1.0 2.0   55.0 37.0       0.0               92.0 81 4 1 2   1       1 2   55 37                 92
363646 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2019   k_12_total 60.0 1.0 3.0 9.0   1.0         3.0   41.0 36.0       0.0               77.0 60 1 3 9   1         3   41 36                 77
363706 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2019   k_12_total 91.0     1.0   1.0         1.0   48.0 46.0       0.0               94.0 91     1   1         1   48 46                 94
363757 SD     school 4652770 23003   Oelrichs 23-3 465277000482 1 Oelrichs High School   Regular School No High 09 12 2019   k_12_total 2.0     57.0   1.0         1.0   40.0 21.0       1.6               61.0 2     57   1         1   40 21                 61
363831 SD     school 4665460 65001   Oglala Lakota 65-1 466546000576 3 Rockyford School   Regular School No Elementary PK 08 2019   k_12_total     19.0 332.0   1.0         5.0   185.0 172.0       0.8               357.0     19 332   1         5   185 172                 357
364063 SD     school 4654300 33003   Parkston 33-3 465430000491 2 Parkston Elementary   Regular School No Elementary PK 06 2019   k_12_total 228.0   10.0 1.0   1.0         6.0   128.0 118.0       0.0               246.0 228   10 1   1         6   128 118                 246
364064 SD     school 4654300 33003   Parkston 33-3 465430000492 1 Parkston High School   Regular School No High 09 12 2019   k_12_total 120.0 1.0 2.0 4.0   1.0         2.0   64.0 66.0       0.8               130.0 120 1 2 4   1         2   64 66                 130
364150 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2019   k_12_total 279.0 1.0 30.0 85.0   1.0         44.0   227.0 213.0       0.7               440.0 279 1 30 85   1         44   227 213                 440
364628 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School No Elementary KG 05 2019   k_12_total 283.0 3.0 27.0 34.0   1.0         43.0   207.0 184.0       0.5               391.0 283 3 27 34   1         43   207 184                 391
364637 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2019   k_12_total 96.0 2.0 38.0 239.0   1.0       1.0 55.0   230.0 202.0       0.0               432.0 96 2 38 239   1       1 55   230 202                 432
364647 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2019   k_12_total 131.0 1.0 39.0 112.0   1.0       1.0 41.0   170.0 156.0       0.3               326.0 131 1 39 112   1       1 41   170 156                 326
364779 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Middle School   Regular School No Middle 06 08 2019   k_12_total 122.0 4.0 4.0 2.0   1.0             77.0 56.0       0.0               133.0 122 4 4 2   1             77 56                 133
364906 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No High 09 12 2019   k_12_total 40.0   2.0 1.0   1.0         1.0   29.0 16.0       0.0               45.0 40   2 1   1         1   29 16                 45
365617 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   k_12_total 526.0 15.0 80.0 3.0   1.0         29.0   324.0 330.0       0.0               654.0 526 15 80 3   1         29   324 330                 654
366090 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No High 09 12 2019   k_12_total 105.0   4.0 19.0   1.0         4.0   81.0 52.0       0.0               133.0 105   4 19   1         4   81 52                 133
366187 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School No Middle 05 08 2019   k_12_total 500.0 20.0 23.0 6.0   1.0         29.0   313.0 266.0       2.4               579.0 500 20 23 6   1         29   313 266                 579
366393 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2019   k_12_total 6.0   2.0 14.0   1.0             12.0 11.0       4.4               23.0 6   2 14   1             12 11                 23
366401 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2019   k_12_total 2.0 1.0 20.0 528.0   1.0         9.0   292.0 269.0       0.4               561.0 2 1 20 528   1         9   292 269                 561
366402 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2019   k_12_total 5.0     483.0   1.0         3.0   258.0 234.0       2.0               492.0 5     483   1         3   258 234                 492
366476 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2019   k_12_total 458.0 44.0 33.0 2.0   1.0         13.0   288.0 263.0       9.3               551.0 458 44 33 2   1         13   288 263                 551
366477 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2019   k_12_total 236.0 16.0 11.0 1.0   1.0         5.0   144.0 126.0       4.1               270.0 236 16 11 1   1         5   144 126                 270
366550 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2019   k_12_total 57.0 1.0 1.0 1.0   1.0             29.0 32.0       0.0               61.0 57 1 1 1   1             29 32                 61
366552 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2019   k_12_total 16.0     2.0   1.0         1.0   10.0 10.0       0.0               20.0 16     2   1         1   10 10                 20
366745 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2019   k_12_total 57.0   6.0 101.0   1.0         16.0   83.0 98.0       0.0               181.0 57   6 101   1         16   83 98                 181
366809 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2019   k_12_total 98.0 3.0 1.0 14.0   1.0         1.0   53.0 65.0       0.0               118.0 98 3 1 14   1         1   53 65                 118
366811 SD     school 4675660 51005   Wall 51-5 467566001057 6 Wall Middle School   Regular School No Middle 06 08 2019   k_12_total 55.0     9.0   1.0             37.0 28.0       0.0               65.0 55     9   1             37 28                 65
366970 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2019   k_12_total 158.0 1.0 20.0 16.0   1.0         21.0   100.0 117.0       0.0               217.0 158 1 20 16   1         21   100 117                 217
366971 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2019   k_12_total 218.0   5.0 15.0   1.0         7.0   121.0 125.0       0.0               246.0 218   5 15   1         7   121 125                 246
366972 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2019   k_12_total 181.0 2.0 6.0 12.0   1.0         12.0   116.0 98.0       0.9               214.0 181 2 6 12   1         12   116 98                 214
367085 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2019   k_12_total 68.0     4.0   1.0         2.0   37.0 38.0       0.0               75.0 68     4   1         2   37 38                 75
367132 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2019   k_12_total 237.0   6.0 7.0   1.0         11.0   136.0 126.0       0.0               262.0 237   6 7   1         11   136 126                 262
367508 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2019   k_12_total 53.0   8.0 1.0   1.0             37.0 26.0       0.0               63.0 53   8 1   1             37 26                 63
367697 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2019   k_12_total 65.0   3.0     1.0         1.0   33.0 37.0       0.0               70.0 65   3     1         1   33 37                 70
367776 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2019   k_12_total 326.0 9.0 32.0 26.0   1.0         13.0   222.0 185.0       2.2               407.0 326 9 32 26   1         13   222 185                 407
367777 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2019   k_12_total 282.0 5.0 31.0 22.0   1.0         17.0   170.0 188.0       2.8               358.0 282 5 31 22   1         17   170 188                 358
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

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