Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • k_12_total · 4,696
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
256572 SD     school 4665460 65001   Oglala Lakota 65-1 466546000576 3 Rockyford School   Regular School No Elementary PK 08 2018   k_12_total     17.0 333.0           0.0 4.0   191.0 163.0       1.1               354.0     17 333           0 4   191 163                 354
359606 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No Prekindergarten PK PK 2019   k_12_total 0.0                 0.0 0.0   0.0 0.0                       0.0 0                 0 0   0 0                 0
361928 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2019   k_12_total 81.0 4.0 7.0 2.0           0.0 3.0   43.0 54.0       2.1               97.0 81 4 7 2           0 3   43 54                 97
365597 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2019   k_12_total 174.0 110.0 73.0 47.0   13.0       0.0 42.0   233.0 226.0       22.7               459.0 174 110 73 47   13       0 42   233 226                 459
365600 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2019   k_12_total 90.0 63.0 62.0 60.0   11.0       0.0 38.0   165.0 159.0       19.1               324.0 90 63 62 60   11       0 38   165 159                 324
457448 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 90.0 185.0 81.0 18.0   102.0       0.0 35.0   258.0 253.0       50.5               511.0 90 185 81 18   102       0 35   258 253                 511
490225 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School Not applicable Elementary PK 06 2020   k_12_total 141.0   28.0 1.0           0.0 8.0   90.0 88.0       9.0               178.0 141   28 1           0 8   90 88                 178
493478 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 337.0 4.0 54.0 3.0   1.0       0.0 18.0   221.0 196.0       8.9               417.0 337 4 54 3   1       0 18   221 196                 417
496123 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School Not applicable Elementary PK 05 2020   k_12_total 108.0 4.0 39.0 249.0           0.0 84.0   259.0 225.0       3.5               484.0 108 4 39 249           0 84   259 225                 484
2971239 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No 1 PK 04 2015   k_12_total 119.0 2.0 2.0     0.0       0.0 2.0   68.0 57.0                       125.0 119 2 2     0       0 2   68 57                 125
3006550 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2017   k_12_total 33.0   5.0 92.0           0.0 20.0   79.0 71.0       0.7               150.0 33   5 92           0 20   79 71                 150
3015098 SD     school 4607670 26005   South Central 26-5 460767000882 3 South Central Elementary   Regular School No Elementary PK 05 2017   k_12_total 26.0     18.0           0.0 2.0   25.0 21.0       0.0               46.0 26     18           0 2   25 21                 46
3015847 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2017   k_12_total 107.0 2.0 3.0 1.0           0.0 4.0   62.0 55.0       0.9               117.0 107 2 3 1           0 4   62 55                 117
3352627 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2016   k_12_total 215.0 168.0 78.0 20.0   62.0       0.0 40.0   297.0 286.0       33.8               583.0 215 168 78 20   62       0 40   297 286                 583
3354370 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No 1 PK 06 2016   k_12_total 52.0 1.0 6.0 1.0           0.0     31.0 29.0                       60.0 52 1 6 1           0     31 29                 60
249925 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   k_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0       2.5               403.0 343 11 9 12   7       1 20   212 191                 403
249929 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   k_12_total 280.0 7.0 35.0 20.0   13.0       1.0 33.0   199.0 190.0       4.9               389.0 280 7 35 20   13       1 33   199 190                 389
249930 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   k_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0       6.8               235.0 173 5 11 23   12       1 10   120 115                 235
249932 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   k_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0       4.1               338.0 255 9 14 21   15       1 23   179 159                 338
250014 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   k_12_total 88.0   4.0 3.0           1.0 4.0   52.0 48.0       4.0               100.0 88   4 3           1 4   52 48                 100
250065 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   k_12_total 158.0   10.0     1.0       1.0 5.0   89.0 86.0       1.1               175.0 158   10     1       1 5   89 86                 175
250883 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   k_12_total 594.0 22.0 19.0 8.0   10.0       1.0 10.0   351.0 313.0       0.9               664.0 594 22 19 8   10       1 10   351 313                 664
251030 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2018   k_12_total 84.0 2.0 3.0 3.0   1.0       1.0     58.0 36.0       0.0               94.0 84 2 3 3   1       1     58 36                 94
251125 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   k_12_total 793.0 19.0 35.0 12.0   39.0       1.0 24.0   460.0 463.0       1.4               923.0 793 19 35 12   39       1 24   460 463                 923
251126 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   k_12_total 464.0 15.0 29.0 12.0   23.0       1.0 32.0   286.0 290.0       4.9               576.0 464 15 29 12   23       1 32   286 290                 576
251128 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   k_12_total 644.0 18.0 38.0 17.0   34.0       1.0 44.0   408.0 388.0       2.0               796.0 644 18 38 17   34       1 44   408 388                 796
251441 SD     school 4612000 7001   Chamberlain 07-1 461200000118 3 Chamberlain Elementary School   Regular School No Elementary KG 06 2018   k_12_total 268.0   21.0 192.0           1.0 36.0   264.0 254.0       0.0               518.0 268   21 192           1 36   264 254                 518
251638 SD     school 4612940 12002   Clark 12-2 461294000133 1 Clark High School   Regular School No High 09 12 2018   k_12_total 53.0 2.0 4.0     1.0       1.0     29.0 32.0       1.6               61.0 53 2 4     1       1     29 32                 61
251870 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   k_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0       0.8               240.0 214 2 12 7           1 4   115 125                 240
251872 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   k_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0       0.0               204.0 166   8 13           1 16   98 106                 204
252161 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   k_12_total 220.0 2.0 16.0 5.0           1.0     134.0 110.0       1.2               244.0 220 2 16 5           1     134 110                 244
252163 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2018   k_12_total 130.0   3.0             1.0     71.0 63.0       0.8               134.0 130   3             1     71 63                 134
252348 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   k_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0       0.7               1000.0 696 33 93 55   7       1 115   521 479                 1000
252349 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   k_12_total 346.0 16.0 39.0 31.0   4.0       1.0 43.0   231.0 249.0       0.0               480.0 346 16 39 31   4       1 43   231 249                 480
252463 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2018   k_12_total 2.0     105.0   1.0       1.0     57.0 52.0       0.0               109.0 2     105   1       1     57 52                 109
252714 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School No High 09 12 2018   k_12_total 95.0   7.0     1.0       1.0 2.0   60.0 46.0       2.8               106.0 95   7     1       1 2   60 46                 106
253102 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No High 09 12 2018   k_12_total 91.0 1.0 16.0 74.0   2.0       1.0 3.0   93.0 95.0       2.1               188.0 91 1 16 74   2       1 3   93 95                 188
253473 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2018   k_12_total 143.0 1.0 4.0 24.0   4.0       1.0 7.0   92.0 92.0       0.0               184.0 143 1 4 24   4       1 7   92 92                 184
253474 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2018   k_12_total 88.0   2.0 12.0   2.0       1.0     64.0 41.0       0.0               105.0 88   2 12   2       1     64 41                 105
253931 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2018   k_12_total 405.0 3.0 12.0 1.0   2.0       1.0 18.0   214.0 228.0       1.6               442.0 405 3 12 1   2       1 18   214 228                 442
254273 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2018   k_12_total 228.0 1.0 13.0 27.0   5.0       1.0 53.0   174.0 154.0       0.3               328.0 228 1 13 27   5       1 53   174 154                 328
254274 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2018   k_12_total 200.0 6.0 12.0 23.0   2.0       1.0 15.0   130.0 129.0       0.4               259.0 200 6 12 23   2       1 15   130 129                 259
254481 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   k_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0       45.8               478.0 177 2 162 7   111       1 18   254 224                 478
255102 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2018   k_12_total 274.0 4.0 14.0 8.0   5.0       1.0 11.0   162.0 155.0       0.3               317.0 274 4 14 8   5       1 11   162 155                 317
255803 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   k_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0       0.0               97.0 85   3 4           1 4   45 52                 97
255954 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   k_12_total 309.0 1.0 18.0 4.0           1.0 3.0   174.0 162.0       0.9               336.0 309 1 18 4           1 3   174 162                 336
256355 SD     school 4650670 51003   New Underwood 51-3 465067000456 4 New Underwood Jr Hi   Regular School No Middle 07 08 2018   k_12_total 28.0   1.0 4.0           1.0     16.0 18.0       0.0               34.0 28   1 4           1     16 18                 34
256402 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2018   k_12_total 87.0 3.0 1.0 1.0           1.0 1.0   52.0 42.0       0.0               94.0 87 3 1 1           1 1   52 42                 94
256450 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2018   k_12_total 75.0     2.0           1.0 1.0   41.0 38.0       0.0               79.0 75     2           1 1   41 38                 79
256451 SD     school 4651750 56007   Northwestern Area 56-7 465175000924 2 Northwestern Middle School   Regular School No Middle 06 08 2018   k_12_total 60.0                 1.0 2.0   31.0 32.0       0.0               63.0 60                 1 2   31 32                 63
256570 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2018   k_12_total 1.0   1.0 103.0           1.0     45.0 61.0       2.8               106.0 1   1 103           1     45 61                 106
256706 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2018   k_12_total 120.0 1.0 6.0 1.0           1.0 3.0   73.0 59.0       3.0               132.0 120 1 6 1           1 3   73 59                 132
256707 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No Middle 07 08 2018   k_12_total 62.0 1.0 1.0 2.0           1.0 1.0   31.0 37.0       0.0               68.0 62 1 1 2           1 1   31 37                 68
256877 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   k_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0       0.8               727.0 560 2 35 90   6       1 33   365 362                 727
257357 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2018   k_12_total 488.0 11.0 31.0 78.0   10.0       1.0 55.0   343.0 331.0       0.7               674.0 488 11 31 78   10       1 55   343 331                 674
257359 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No Elementary KG 05 2018   k_12_total 349.0 5.0 22.0 69.0   4.0       1.0 22.0   262.0 210.0       0.4               472.0 349 5 22 69   4       1 22   262 210                 472
257362 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2018   k_12_total 115.0 1.0 43.0 256.0   1.0       1.0 34.0   228.0 223.0       0.0               451.0 115 1 43 256   1       1 34   228 223                 451
257365 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2018   k_12_total 137.0 13.0 57.0 327.0   1.0       1.0 37.0   288.0 285.0       0.4               573.0 137 13 57 327   1       1 37   288 285                 573
257369 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2018   k_12_total 239.0 5.0 52.0 124.0   7.0       1.0 62.0   262.0 228.0       0.8               490.0 239 5 52 124   7       1 62   262 228                 490
257370 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   k_12_total 213.0 3.0 23.0 32.0   1.0       1.0 12.0   146.0 139.0       0.4               285.0 213 3 23 32   1       1 12   146 139                 285
257377 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   k_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0       0.9               353.0 212 2 27 70   7       1 34   170 183                 353
258329 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   k_12_total 685.0 67.0 65.0 8.0   16.0       1.0 48.0   438.0 452.0       9.1               890.0 685 67 65 8   16       1 48   438 452                 890
258334 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   k_12_total 226.0 111.0 79.0 41.0   16.0       1.0 43.0   268.0 249.0       19.7               517.0 226 111 79 41   16       1 43   268 249                 517
258340 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2018   k_12_total 572.0 27.0 27.0 11.0   14.0       1.0 22.0   337.0 337.0       1.3               674.0 572 27 27 11   14       1 22   337 337                 674
258343 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   k_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0       5.5               2006.0 1419 224 145 91   54       1 72   1049 957                 2006
258348 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   k_12_total 417.0 38.0 48.0 21.0   6.0       1.0 48.0   286.0 293.0       1.0               579.0 417 38 48 21   6       1 48   286 293                 579
258352 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2018   k_12_total 384.0 18.0 19.0 4.0   2.0       1.0 26.0   226.0 228.0       1.3               454.0 384 18 19 4   2       1 26   226 228                 454
258353 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   k_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0       5.9               2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258355 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   k_12_total 500.0 11.0 66.0 4.0   2.0       1.0 28.0   294.0 318.0       0.2               612.0 500 11 66 4   2       1 28   294 318                 612
258362 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   k_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0       14.7               1939.0 1111 333 224 66   143       1 61   997 942                 1939
258363 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   k_12_total 349.0 218.0 163.0 66.0   75.0       1.0 41.0   471.0 442.0       14.6               913.0 349 218 163 66   75       1 41   471 442                 913
258782 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2018   k_12_total 537.0 6.0 32.0 18.0   6.0       1.0 12.0   310.0 302.0       1.1               612.0 537 6 32 18   6       1 12   310 302                 612
258787 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No Middle 06 08 2018   k_12_total 503.0 2.0 36.0 25.0   3.0       1.0 17.0   302.0 285.0       0.3               587.0 503 2 36 25   3       1 17   302 285                 587
258862 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No Elementary KG 05 2018   k_12_total 148.0   3.0 35.0           1.0 13.0   110.0 90.0       0.0               200.0 148   3 35           1 13   110 90                 200
259454 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2018   k_12_total 114.0 3.0 4.0 2.0           1.0 3.0   58.0 69.0       1.6               127.0 114 3 4 2           1 3   58 69                 127
259745 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   k_12_total 181.0 3.0 8.0 12.0   1.0       1.0 15.0   126.0 95.0       1.4               221.0 181 3 8 12   1       1 15   126 95                 221
259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259859 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   k_12_total 51.0     1.0           1.0     27.0 26.0       0.0               53.0 51     1           1     27 26                 53
259905 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 233.0   8.0 6.0   1.0       1.0 12.0   130.0 131.0       0.4               261.0 233   8 6   1       1 12   130 131                 261
260097 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2018   k_12_total 58.0 1.0 4.0             1.0     38.0 26.0       0.0               64.0 58 1 4             1     38 26                 64
260159 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   k_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0       0.0               103.0 14 1 2 80   1       1 4   54 49                 103
260354 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   k_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0       0.5               199.0 147 3 1 45   2       1     99 100                 199
357170 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2019   k_12_total 442.0 11.0 21.0 27.0   12.0       1.0 26.0   272.0 268.0       1.7               540.0 442 11 21 27   12       1 26   272 268                 540
357172 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2019   k_12_total 281.0 11.0 44.0 28.0   10.0       1.0 32.0   209.0 198.0       6.1               407.0 281 11 44 28   10       1 32   209 198                 407
357173 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2019   k_12_total 182.0 5.0 10.0 18.0   15.0       1.0 16.0   123.0 124.0       6.9               247.0 182 5 10 18   15       1 16   123 124                 247
357175 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2019   k_12_total 239.0 9.0 29.0 16.0   10.0       1.0 28.0   171.0 161.0       6.3               332.0 239 9 29 16   10       1 28   171 161                 332
357177 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2019   k_12_total 410.0 10.0 34.0 24.0   23.0       1.0 23.0   266.0 259.0       3.4               525.0 410 10 34 24   23       1 23   266 259                 525
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
358141 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   k_12_total 1004.0 29.0 33.0 4.0   19.0       1.0 32.0   599.0 523.0       1.4               1122.0 1004 29 33 4   19       1 32   599 523                 1122
358142 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2019   k_12_total 576.0 31.0 20.0 5.0   16.0       1.0 24.0   347.0 326.0       2.2               673.0 576 31 20 5   16       1 24   347 326                 673
358288 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 05 2019   k_12_total 174.0 2.0 13.0 3.0           1.0 5.0   95.0 103.0       1.0               198.0 174 2 13 3           1 5   95 103                 198
358384 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   k_12_total 771.0 19.0 44.0 21.0   42.0       1.0 30.0   471.0 457.0       1.6               928.0 771 19 44 21   42       1 30   471 457                 928
358385 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2019   k_12_total 463.0 15.0 27.0 12.0   20.0       1.0 26.0   271.0 293.0       5.0               564.0 463 15 27 12   20       1 26   271 293                 564
358387 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2019   k_12_total 631.0 23.0 48.0 16.0   35.0       1.0 51.0   399.0 406.0       3.0               805.0 631 23 48 16   35       1 51   399 406                 805
358388 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   k_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0       9.2               284.0 213 8 16 13   13       1 20   151 133                 284
359292 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2019   k_12_total 347.0 1.0 5.0 5.0           1.0 10.0   202.0 167.0       0.3               369.0 347 1 5 5           1 10   202 167                 369
359420 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2019   k_12_total 226.0 2.0 14.0 10.0           1.0     144.0 109.0       1.2               253.0 226 2 14 10           1     144 109                 253
359607 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   k_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0       0.6               978.0 662 23 98 63   6       1 125   504 474                 978
359608 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   k_12_total 349.0 9.0 52.0 25.0   3.0       1.0 32.0   246.0 225.0       0.6               471.0 349 9 52 25   3       1 32   246 225                 471
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

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