Data source: Big Local News · About: Big Local

672 rows where grade = "k_12_total", state = "SD" and year = 2019 sorted by asian_int

View and edit SQL

year

  • 2019 · 672

grade

  • k_12_total · 672
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
357257 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2019   k_12_total 96.0   8.0 3.0   1.0         3.0   58.0 53.0       7.2               111.0 96   8 3   1         3   58 53                 111
357308 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2019   k_12_total 177.0   8.0 0.0   1.0         7.0   96.0 97.0       0.5               193.0 177   8 0   1         7   96 97                 193
357448 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School No Elementary KG 06 2019   k_12_total 122.0 2.0 12.0     1.0             62.0 75.0       0.7               137.0 122 2 12     1             62 75                 137
357613 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2019   k_12_total 129.0   3.0 2.0   1.0         1.0   70.0 66.0       0.0               136.0 129   3 2   1         1   70 66                 136
357740 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2019   k_12_total 36.0   6.0 69.0   1.0         25.0   72.0 65.0       0.0               137.0 36   6 69   1         25   72 65                 137
357869 SD     school 4607050 52001   Bison 52-1 460705000055 1 Bison High School   Regular School No High 09 12 2019   k_12_total 36.0   1.0 2.0   1.0             22.0 18.0       0.0               40.0 36   1 2   1             22 18                 40
358045 SD     school 4607800 22001   Bowdle 22-1 460780000069 1 Bowdle High School   Regular School No High 09 12 2019   k_12_total 29.0         1.0             14.0 16.0       0.0               30.0 29         1             14 16                 30
358140 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2019   k_12_total 479.0 11.0 17.0 6.0   1.0       1.0 26.0   297.0 244.0       0.0               541.0 479 11 17 6   1       1 26   297 244                 541
358289 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2019   k_12_total 69.0 1.0 6.0 2.0   1.0         1.0   52.0 28.0       0.0               80.0 69 1 6 2   1         1   52 28                 80
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
357612 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2019   k_12_total 201.0 0.0 10.0 3.0   2.0         7.0   107.0 116.0       1.8               223.0 201 0 10 3   2         7   107 116                 223
357790 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School No Middle 06 08 2019   k_12_total 173.0   12.0     2.0         2.0   104.0 85.0       0.0               189.0 173   12     2         2   104 85                 189
358290 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Middle School   Regular School No Middle 06 08 2019   k_12_total 77.0 1.0 2.0     2.0         2.0   46.0 38.0       0.0               84.0 77 1 2     2         2   46 38                 84
358542 SD     school 4610560 41001   Canton 41-1 461056000108 2 Lawrence Elementary   Regular School No Elementary KG 05 2019   k_12_total 374.0 2.0 7.0 6.0   2.0         10.0   204.0 197.0       0.3               401.0 374 2 7 6   2         10   204 197                 401
358701 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2019   k_12_total 136.0 2.0 11.0 101.0   2.0         4.0   131.0 125.0       0.8               256.0 136 2 11 101   2         4   131 125                 256
359018 SD     school 4614130 59003   Colome Consolidated 461413000893 3 Colome Middle School   Regular School No Middle 06 08 2019   k_12_total 44.0     7.0   2.0         2.0   21.0 34.0       0.0               55.0 44     7   2         2   21 34                 55
359801 SD     school 4634440 22005   Edmunds Central 22-5 463444001066 5 Edmunds Central Elementary   Regular School No Elementary PK 05 2019   k_12_total 56.0   12.0 1.0   2.0             35.0 36.0       14.1               71.0 56   12 1   2             35 36                 71
360330 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 05 08 2019   k_12_total 114.0 2.0 21.0 74.0   2.0       4.0 4.0   110.0 111.0       3.6               221.0 114 2 21 74   2       4 4   110 111                 221
360500 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No Elementary KG 06 2019   k_12_total 123.0 2.0 15.0 1.0   2.0         1.0   66.0 78.0       7.6               144.0 123 2 15 1   2         1   66 78                 144
360558 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School No Middle 06 08 2019   k_12_total 103.0   3.0     2.0         6.0   61.0 53.0       0.0               114.0 103   3     2         6   61 53                 114
360605 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2019   k_12_total 90.0   6.0 1.0   2.0         4.0   47.0 56.0       0.0               103.0 90   6 1   2         4   47 56                 103
360700 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2019   k_12_total 156.0 1.0 5.0 18.0   2.0         5.0   91.0 96.0       0.5               187.0 156 1 5 18   2         5   91 96                 187
360701 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2019   k_12_total 84.0   1.0 13.0   2.0       1.0     55.0 46.0       0.0               101.0 84   1 13   2       1     55 46                 101
360809 SD     school 4630490 27001   Haakon 27-1 463049000255 2 Philip Elementary School   Regular School No Elementary KG 06 2019   k_12_total 140.0   2.0 1.0   2.0         10.0   79.0 76.0       0.0               155.0 140   2 1   2         10   79 76                 155
361373 SD     school 4633360 51002   Hill City 51-2 463336000280 1 Hill City High School   Regular School No High 09 12 2019   k_12_total 119.0 1.0 26.0 5.0   2.0             66.0 87.0       1.3               153.0 119 1 26 5   2             66 87                 153
361810 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2019   k_12_total 98.0 1.0 2.0     2.0         4.0   49.0 58.0       0.0               107.0 98 1 2     2         4   49 58                 107
362331 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School No Middle 06 08 2019   k_12_total 166.0 1.0 10.0 4.0   2.0         11.0   103.0 91.0       0.5               194.0 166 1 10 4   2         11   103 91                 194
362452 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2019   k_12_total 344.0 3.0 3.0 5.0   2.0         16.0   196.0 177.0       0.0               373.0 344 3 3 5   2         16   196 177                 373
362453 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2019   k_12_total 264.0 4.0 9.0 5.0   2.0         9.0   153.0 140.0       0.0               293.0 264 4 9 5   2         9   153 140                 293
363038 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School No Middle 05 08 2019   k_12_total 272.0 3.0 11.0 11.0   2.0       1.0 13.0   150.0 163.0       0.0               313.0 272 3 11 11   2       1 13   150 163                 313
363042 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School No Middle 06 08 2019   k_12_total 418.0 2.0 27.0 26.0   2.0         23.0   272.0 226.0       0.0               498.0 418 2 27 26   2         23   272 226                 498

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