Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_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
249945 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   pk_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0                       403.0 343 11 9 12   7       1 20   212 191                 403
249949 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   pk_12_total 280.0 7.0 35.0 20.0   13.0       1.0 33.0   199.0 190.0                       389.0 280 7 35 20   13       1 33   199 190                 389
249950 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   pk_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0                       235.0 173 5 11 23   12       1 10   120 115                 235
249952 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   pk_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0                       338.0 255 9 14 21   15       1 23   179 159                 338
250022 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   pk_12_total 88.0   4.0 3.0           1.0 4.0   52.0 48.0                       100.0 88   4 3           1 4   52 48                 100
250071 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   pk_12_total 209.0   13.0     1.0       1.0 6.0   124.0 106.0                       230.0 209   13     1       1 6   124 106                 230
250897 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   pk_12_total 594.0 22.0 19.0 8.0   10.0       1.0 10.0   351.0 313.0                       664.0 594 22 19 8   10       1 10   351 313                 664
251042 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2018   pk_12_total 84.0 2.0 3.0 3.0   1.0       1.0     58.0 36.0                       94.0 84 2 3 3   1       1     58 36                 94
251137 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   pk_12_total 793.0 19.0 35.0 12.0   39.0       1.0 24.0   460.0 463.0                       923.0 793 19 35 12   39       1 24   460 463                 923
251138 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   pk_12_total 464.0 15.0 29.0 12.0   23.0       1.0 32.0   286.0 290.0                       576.0 464 15 29 12   23       1 32   286 290                 576
251140 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   pk_12_total 644.0 18.0 38.0 17.0   34.0       1.0 44.0   408.0 388.0                       796.0 644 18 38 17   34       1 44   408 388                 796
251447 SD     school 4612000 7001   Chamberlain 07-1 461200000118 3 Chamberlain Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 268.0   21.0 192.0           1.0 36.0   264.0 254.0                       518.0 268   21 192           1 36   264 254                 518
251650 SD     school 4612940 12002   Clark 12-2 461294000133 1 Clark High School   Regular School No High 09 12 2018   pk_12_total 53.0 2.0 4.0     1.0       1.0     29.0 32.0                       61.0 53 2 4     1       1     29 32                 61
251878 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   pk_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0                       240.0 214 2 12 7           1 4   115 125                 240
251880 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   pk_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0                       204.0 166   8 13           1 16   98 106                 204
252167 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   pk_12_total 257.0 2.0 16.0 6.0           1.0     157.0 125.0                       282.0 257 2 16 6           1     157 125                 282
252169 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2018   pk_12_total 130.0   3.0             1.0     71.0 63.0                       134.0 130   3             1     71 63                 134
252358 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   pk_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0                       1000.0 696 33 93 55   7       1 115   521 479                 1000
252359 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   pk_12_total 346.0 16.0 39.0 31.0   4.0       1.0 43.0   231.0 249.0                       480.0 346 16 39 31   4       1 43   231 249                 480
252471 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2018   pk_12_total 2.0     105.0   1.0       1.0     57.0 52.0                       109.0 2     105   1       1     57 52                 109
252724 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School No High 09 12 2018   pk_12_total 95.0   7.0     1.0       1.0 2.0   60.0 46.0                       106.0 95   7     1       1 2   60 46                 106
253110 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No High 09 12 2018   pk_12_total 91.0 1.0 16.0 74.0   2.0       1.0 3.0   93.0 95.0                       188.0 91 1 16 74   2       1 3   93 95                 188
253479 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 143.0 1.0 4.0 24.0   4.0       1.0 7.0   92.0 92.0                       184.0 143 1 4 24   4       1 7   92 92                 184
253480 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2018   pk_12_total 88.0   2.0 12.0   2.0       1.0     64.0 41.0                       105.0 88   2 12   2       1     64 41                 105
253949 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2018   pk_12_total 405.0 3.0 12.0 1.0   2.0       1.0 18.0   214.0 228.0                       442.0 405 3 12 1   2       1 18   214 228                 442
254280 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2018   pk_12_total 200.0 6.0 12.0 23.0   2.0       1.0 15.0   130.0 129.0                       259.0 200 6 12 23   2       1 15   130 129                 259
254495 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   pk_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0                       478.0 177 2 162 7   111       1 18   254 224                 478
255110 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2018   pk_12_total 274.0 4.0 14.0 8.0   5.0       1.0 11.0   162.0 155.0                       317.0 274 4 14 8   5       1 11   162 155                 317
255825 SD     school 4669930 46001   Meade 46-1 466993000652 4 Whitewood Elementary   Regular School No Elementary KG 06 2018   pk_12_total 85.0   3.0 4.0           1.0 4.0   45.0 52.0                       97.0 85   3 4           1 4   45 52                 97
255960 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   pk_12_total 309.0 1.0 18.0 4.0           1.0 3.0   174.0 162.0                       336.0 309 1 18 4           1 3   174 162                 336
256361 SD     school 4650670 51003   New Underwood 51-3 465067000456 4 New Underwood Jr Hi   Regular School No Middle 07 08 2018   pk_12_total 28.0   1.0 4.0           1.0     16.0 18.0                       34.0 28   1 4           1     16 18                 34
256408 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No High 09 12 2018   pk_12_total 87.0 3.0 1.0 1.0           1.0 1.0   52.0 42.0                       94.0 87 3 1 1           1 1   52 42                 94
256456 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2018   pk_12_total 75.0     2.0           1.0 1.0   41.0 38.0                       79.0 75     2           1 1   41 38                 79
256457 SD     school 4651750 56007   Northwestern Area 56-7 465175000924 2 Northwestern Middle School   Regular School No Middle 06 08 2018   pk_12_total 60.0                 1.0 2.0   31.0 32.0                       63.0 60                 1 2   31 32                 63
256580 SD     school 4665460 65001   Oglala Lakota 65-1 466546001262 92 Oglala Lakota County Virtual High School   Regular School No High 09 12 2018   pk_12_total 1.0   1.0 103.0           1.0     45.0 61.0                       106.0 1   1 103           1     45 61                 106
256582 SD     school 4665460 65001   Oglala Lakota 65-1 466546000576 3 Rockyford School   Regular School No Elementary PK 08 2018   pk_12_total     20.0 368.0           1.0 5.0   212.0 182.0                       394.0     20 368           1 5   212 182                 394
256712 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2018   pk_12_total 120.0 1.0 6.0 1.0           1.0 3.0   73.0 59.0                       132.0 120 1 6 1           1 3   73 59                 132
256713 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No Middle 07 08 2018   pk_12_total 62.0 1.0 1.0 2.0           1.0 1.0   31.0 37.0                       68.0 62 1 1 2           1 1   31 37                 68
256887 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   pk_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0                       727.0 560 2 35 90   6       1 33   365 362                 727
257407 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2018   pk_12_total 488.0 11.0 31.0 78.0   10.0       1.0 55.0   343.0 331.0                       674.0 488 11 31 78   10       1 55   343 331                 674
257409 SD     school 4659820 51004   Rapid City Area 51-4 465982000548 6 Grandview Elem   Regular School No Elementary KG 05 2018   pk_12_total 349.0 5.0 22.0 69.0   4.0       1.0 22.0   262.0 210.0                       472.0 349 5 22 69   4       1 22   262 210                 472
257412 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2018   pk_12_total 115.0 1.0 43.0 256.0   1.0       1.0 34.0   228.0 223.0                       451.0 115 1 43 256   1       1 34   228 223                 451
257415 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 137.0 13.0 57.0 327.0   1.0       1.0 37.0   288.0 285.0                       573.0 137 13 57 327   1       1 37   288 285                 573
257419 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2018   pk_12_total 248.0 5.0 54.0 127.0   7.0       1.0 63.0   271.0 234.0                       505.0 248 5 54 127   7       1 63   271 234                 505
257420 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   pk_12_total 213.0 3.0 23.0 32.0   1.0       1.0 12.0   146.0 139.0                       285.0 213 3 23 32   1       1 12   146 139                 285
257427 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   pk_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0                       353.0 212 2 27 70   7       1 34   170 183                 353
258415 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   pk_12_total 694.0 68.0 68.0 8.0   17.0       1.0 49.0   447.0 458.0                       905.0 694 68 68 8   17       1 49   447 458                 905
258420 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   pk_12_total 249.0 136.0 82.0 43.0   19.0       1.0 50.0   306.0 274.0                       580.0 249 136 82 43   19       1 50   306 274                 580
258426 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2018   pk_12_total 584.0 28.0 28.0 11.0   15.0       1.0 22.0   347.0 342.0                       689.0 584 28 28 11   15       1 22   347 342                 689
258429 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   pk_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0                       2006.0 1419 224 145 91   54       1 72   1049 957                 2006
258434 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   pk_12_total 417.0 38.0 48.0 21.0   6.0       1.0 48.0   286.0 293.0                       579.0 417 38 48 21   6       1 48   286 293                 579
258438 SD     school 4666270 49005   Sioux Falls 49-5 466627000607 18 Robert Frost Elementary   Regular School No Elementary PK 05 2018   pk_12_total 394.0 25.0 26.0 7.0   4.0       1.0 28.0   242.0 243.0                       485.0 394 25 26 7   4       1 28   242 243                 485
258439 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   pk_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0                       2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258441 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Career and Technical School No Elementary PK 05 2018   pk_12_total 523.0 12.0 73.0 4.0   2.0       1.0 30.0   311.0 334.0                       645.0 523 12 73 4   2       1 30   311 334                 645
258448 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   pk_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0                       1939.0 1111 333 224 66   143       1 61   997 942                 1939
258449 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   pk_12_total 349.0 218.0 163.0 66.0   75.0       1.0 41.0   471.0 442.0                       913.0 349 218 163 66   75       1 41   471 442                 913
258798 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2018   pk_12_total 537.0 6.0 32.0 18.0   6.0       1.0 12.0   310.0 302.0                       612.0 537 6 32 18   6       1 12   310 302                 612
258803 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No Middle 06 08 2018   pk_12_total 503.0 2.0 36.0 25.0   3.0       1.0 17.0   302.0 285.0                       587.0 503 2 36 25   3       1 17   302 285                 587
258870 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No Elementary KG 05 2018   pk_12_total 148.0   3.0 35.0           1.0 13.0   110.0 90.0                       200.0 148   3 35           1 13   110 90                 200
259462 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000692 2 Viborg-Hurley Elementary   Regular School No Elementary PK 04 2018   pk_12_total 139.0 3.0 4.0 2.0           1.0 4.0   74.0 79.0                       153.0 139 3 4 2           1 4   74 79                 153
259761 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   pk_12_total 208.0 3.0 13.0 12.0   2.0       1.0 16.0   144.0 111.0                       255.0 208 3 13 12   2       1 16   144 111                 255
259762 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   pk_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0                       1211.0 1086 8 38 45   10       1 23   619 592                 1211
259865 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   pk_12_total 51.0     1.0           1.0     27.0 26.0                       53.0 51     1           1     27 26                 53
259911 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 255.0   8.0 6.0   1.0       1.0 12.0   145.0 138.0                       283.0 255   8 6   1       1 12   145 138                 283
260103 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2018   pk_12_total 70.0 1.0 4.0             1.0     44.0 32.0                       76.0 70 1 4             1     44 32                 76
260167 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   pk_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0                       103.0 14 1 2 80   1       1 4   54 49                 103
260360 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   pk_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0                       199.0 147 3 1 45   2       1     99 100                 199
357190 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2019   pk_12_total 442.0 11.0 21.0 27.0   12.0       1.0 26.0   272.0 268.0                       540.0 442 11 21 27   12       1 26   272 268                 540
357192 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2019   pk_12_total 281.0 11.0 44.0 28.0   10.0       1.0 32.0   209.0 198.0                       407.0 281 11 44 28   10       1 32   209 198                 407
357193 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2019   pk_12_total 182.0 5.0 10.0 18.0   15.0       1.0 16.0   123.0 124.0                       247.0 182 5 10 18   15       1 16   123 124                 247
357195 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2019   pk_12_total 239.0 9.0 29.0 16.0   10.0       1.0 28.0   171.0 161.0                       332.0 239 9 29 16   10       1 28   171 161                 332
357197 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2019   pk_12_total 410.0 10.0 34.0 24.0   23.0       1.0 23.0   266.0 259.0                       525.0 410 10 34 24   23       1 23   266 259                 525
358155 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   pk_12_total 1004.0 29.0 33.0 4.0   19.0       1.0 32.0   599.0 523.0                       1122.0 1004 29 33 4   19       1 32   599 523                 1122
358156 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2019   pk_12_total 576.0 31.0 20.0 5.0   16.0       1.0 24.0   347.0 326.0                       673.0 576 31 20 5   16       1 24   347 326                 673
358300 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 174.0 2.0 13.0 3.0           1.0 5.0   95.0 103.0                       198.0 174 2 13 3           1 5   95 103                 198
358396 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   pk_12_total 771.0 19.0 44.0 21.0   42.0       1.0 30.0   471.0 457.0                       928.0 771 19 44 21   42       1 30   471 457                 928
358397 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2019   pk_12_total 463.0 15.0 27.0 12.0   20.0       1.0 26.0   271.0 293.0                       564.0 463 15 27 12   20       1 26   271 293                 564
358399 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2019   pk_12_total 631.0 23.0 48.0 16.0   35.0       1.0 51.0   399.0 406.0                       805.0 631 23 48 16   35       1 51   399 406                 805
358400 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   pk_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0                       284.0 213 8 16 13   13       1 20   151 133                 284
359298 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2019   pk_12_total 347.0 1.0 5.0 5.0           1.0 10.0   202.0 167.0                       369.0 347 1 5 5           1 10   202 167                 369
359426 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2019   pk_12_total 250.0 3.0 15.0 10.0           1.0     161.0 118.0                       279.0 250 3 15 10           1     161 118                 279
359616 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No Prekindergarten PK PK 2019   pk_12_total 16.0                 1.0 3.0   11.0 9.0                       20.0 16                 1 3   11 9                 20
359617 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   pk_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0                       978.0 662 23 98 63   6       1 125   504 474                 978
359618 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2019   pk_12_total 349.0 9.0 52.0 25.0   3.0       1.0 32.0   246.0 225.0                       471.0 349 9 52 25   3       1 32   246 225                 471
359716 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2019   pk_12_total 2.0   1.0 242.0   1.0       1.0 1.0   125.0 123.0                       248.0 2   1 242   1       1 1   125 123                 248
359892 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No Middle 06 08 2019   pk_12_total 151.0   6.0             1.0 3.0   89.0 72.0                       161.0 151   6             1 3   89 72                 161
360337 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No High 09 12 2019   pk_12_total 83.0   23.0 60.0   5.0       1.0 3.0   95.0 80.0                       175.0 83   23 60   5       1 3   95 80                 175
360707 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2019   pk_12_total 84.0   1.0 13.0   2.0       1.0     55.0 46.0                       101.0 84   1 13   2       1     55 46                 101
360708 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School No Middle 06 08 2019   pk_12_total 59.0 1.0 1.0 16.0   3.0       1.0 4.0   43.0 42.0                       85.0 59 1 1 16   3       1 4   43 42                 85
361040 SD     school 4609300 31001   Harding County 31-1 460930000088 1 Harding County High School   Regular School No High 09 12 2019   pk_12_total 59.0 1.0 2.0 2.0           1.0     33.0 32.0                       65.0 59 1 2 2           1     33 32                 65
361174 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2019   pk_12_total 466.0 9.0 11.0 4.0   21.0       1.0 17.0   270.0 259.0                       529.0 466 9 11 4   21       1 17   270 259                 529
361176 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2019   pk_12_total 410.0 3.0 15.0 5.0           1.0 19.0   225.0 228.0                       453.0 410 3 15 5           1 19   225 228                 453
361722 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2019   pk_12_total 160.0 4.0 149.0 11.0   115.0       1.0 16.0   238.0 218.0                       456.0 160 4 149 11   115       1 16   238 218                 456
361728 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2019   pk_12_total 197.0 5.0 109.0 6.0   77.0       1.0 10.0   233.0 172.0                       405.0 197 5 109 6   77       1 10   233 172                 405
361936 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2019   pk_12_total 91.0 4.0 7.0 2.0           1.0 4.0   50.0 59.0                       109.0 91 4 7 2           1 4   50 59                 109
361937 SD     school 4636150 2003   Iroquois 02-3 463615000339 1 Iroquois High School   Regular School No High 09 12 2019   pk_12_total 53.0 2.0 1.0 1.0           1.0     31.0 27.0                       58.0 53 2 1 1           1     31 27                 58
361938 SD     school 4636150 2003   Iroquois 02-3 463615000916 2 Iroquois Middle School   Regular School No Middle 06 08 2019   pk_12_total 48.0 3.0 1.0 3.0           1.0 2.0   24.0 34.0                       58.0 48 3 1 3           1 2   24 34                 58
362337 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2019   pk_12_total 256.0 2.0 16.0 9.0   3.0       1.0 15.0   157.0 145.0                       302.0 256 2 16 9   3       1 15   157 145                 302
363062 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School No Middle 05 08 2019   pk_12_total 272.0 3.0 11.0 11.0   2.0       1.0 13.0   150.0 163.0                       313.0 272 3 11 11   2       1 13   150 163                 313
363063 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2019   pk_12_total 604.0 8.0 28.0 30.0           1.0 20.0   341.0 350.0                       691.0 604 8 28 30           1 20   341 350                 691

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