Data source: Big Local News · About: Big Local

671 rows where grade = "pk_12_total", state = "SD" and year = 2018 sorted by asian_int

View and edit SQL

year

  • 2018 · 571

grade

  • pk_12_total · 571
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
256884 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2018   pk_12_total 458.0 5.0 31.0 79.0   2.0         56.0   318.0 313.0                       631.0 458 5 31 79   2         56   318 313                 631
256886 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 279.0 1.0 14.0 103.0   2.0         46.0   205.0 240.0                       445.0 279 1 14 103   2         46   205 240                 445
257413 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No High 12 12 2018   pk_12_total 21.0   3.0 5.0   2.0         2.0   23.0 10.0                       33.0 21   3 5   2         2   23 10                 33
257417 SD     school 4659820 51004   Rapid City Area 51-4 465982001340 45 Rapid City HS   Alternative School No High 09 12 2018   pk_12_total 186.0 11.0 22.0 144.0   2.0         15.0   224.0 156.0                       380.0 186 11 22 144   2         15   224 156                 380
258414 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2018   pk_12_total 21.0 4.0 1.0 2.0   2.0             18.0 12.0                       30.0 21 4 1 2   2             18 12                 30
258418 SD     school 4666270 49005   Sioux Falls 49-5 466627000585 16 Eugene Field A+ Elementary   Regular School No Elementary KG 05 2018   pk_12_total 335.0 20.0 35.0 11.0   2.0         39.0   214.0 228.0                       442.0 335 20 35 11   2         39   214 228                 442
258437 SD     school 4666270 49005   Sioux Falls 49-5 466627000606 42 Renberg Elementary   Regular School No Elementary KG 05 2018   pk_12_total 137.0 19.0 11.0 2.0   2.0         21.0   103.0 89.0                       192.0 137 19 11 2   2         21   103 89                 192
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
258584 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No Middle 06 08 2018   pk_12_total 51.0 1.0 7.0 136.0   2.0         5.0   109.0 93.0                       202.0 51 1 7 136   2         5   109 93                 202
258965 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2018   pk_12_total 70.0 12.0 7.0 2.0   2.0         6.0   53.0 46.0                       99.0 70 12 7 2   2         6   53 46                 99
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
260359 SD     school 4679710 59002   Winner 59-2 467971000479 4 Winner Elementary   Regular School No Elementary KG 05 2018   pk_12_total 191.0 5.0 2.0 159.0   2.0         1.0   190.0 170.0                       360.0 191 5 2 159   2         1   190 170                 360
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
260361 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   pk_12_total 116.0   1.0 44.0   2.0             86.0 77.0                       163.0 116   1 44   2             86 77                 163
260529 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   pk_12_total 334.0 8.0 23.0 13.0   2.0         12.0   207.0 185.0                       392.0 334 8 23 13   2         12   207 185                 392
260530 SD     school 4680430 63003   Yankton 63-3 468043000793 4 Lincoln Elem   Regular School No Elementary KG 05 2018   pk_12_total 298.0 4.0 25.0 18.0   2.0         13.0   179.0 181.0                       360.0 298 4 25 18   2         13   179 181                 360
250452 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2018   pk_12_total 333.0   15.0 6.0   3.0         17.0   191.0 183.0                       374.0 333   15 6   3         17   191 183                 374
250631 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School No Elementary KG 06 2018   pk_12_total 74.0   3.0 1.0   3.0         2.0   38.0 45.0                       83.0 74   3 1   3         2   38 45                 83
250632 SD     school 4607050 52001   Bison 52-1 460705000055 1 Bison High School   Regular School No High 09 12 2018   pk_12_total 40.0   1.0     3.0             27.0 17.0                       44.0 40   1     3             27 17                 44
251448 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   pk_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0                       255.0 134 3 13 98   3         4   129 126                 255
251766 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School No High 09 12 2018   pk_12_total 61.0     10.0   3.0             36.0 38.0                       74.0 61     10   3             36 38                 74
251944 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   pk_12_total 180.0 2.0 14.0 1.0   3.0         13.0   103.0 110.0                       213.0 180 2 14 1   3         13   103 110                 213
252872 SD     school 4622560 44001   Eureka 44-1 462256000196 1 Eureka High School   Regular School No High 09 12 2018   pk_12_total 48.0   1.0     3.0             27.0 25.0                       52.0 48   1     3             27 25                 52
253955 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2018   pk_12_total 471.0 7.0 11.0 5.0   3.0         13.0   277.0 233.0                       510.0 471 7 11 5   3         13   277 233                 510
255447 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 452.0 4.0 55.0 8.0   3.0         21.0   270.0 273.0                       543.0 452 4 55 8   3         21   270 273                 543
255448 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No High 09 12 2018   pk_12_total 357.0 7.0 19.0 3.0   3.0         7.0   201.0 195.0                       396.0 357 7 19 3   3         7   201 195                 396
255449 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No Middle 06 08 2018   pk_12_total 243.0 1.0 16.0 4.0   3.0         10.0   135.0 142.0                       277.0 243 1 16 4   3         10   135 142                 277
256409 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 63.0 3.0 1.0 9.0   3.0         2.0   49.0 32.0                       81.0 63 3 1 9   3         2   49 32                 81
257414 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2018   pk_12_total 423.0 7.0 34.0 60.0   3.0         18.0   277.0 268.0                       545.0 423 7 34 60   3         18   277 268                 545
257421 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 397.0 5.0 58.0 165.0   3.0         44.0   343.0 329.0                       672.0 397 5 58 165   3         44   343 329                 672
257422 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2018   pk_12_total 117.0 1.0 36.0 110.0   3.0         36.0   161.0 142.0                       303.0 117 1 36 110   3         36   161 142                 303
258536 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2018   pk_12_total 185.0   9.0 2.0   3.0         3.0   91.0 111.0                       202.0 185   9 2   3         3   91 111                 202
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
260441 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   pk_12_total 164.0 1.0 12.0     3.0         6.0   94.0 92.0                       186.0 164 1 12     3         6   94 92                 186
250552 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   pk_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0                       218.0 199 2 8     4         5   106 112                 218
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
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
253481 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School No Middle 06 08 2018   pk_12_total 59.0 1.0 1.0 13.0   4.0         2.0   36.0 44.0                       80.0 59 1 1 13   4         2   36 44                 80
255111 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No High 09 12 2018   pk_12_total 184.0 1.0 13.0 4.0   4.0         6.0   107.0 105.0                       212.0 184 1 13 4   4         6   107 105                 212
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
258433 SD     school 4666270 49005   Sioux Falls 49-5 466627001303 30 New Technology High School   Regular School No High 09 12 2018   pk_12_total 255.0 24.0 32.0 13.0   4.0         15.0   183.0 160.0                       343.0 255 24 32 13   4         15   183 160                 343
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
259757 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2018   pk_12_total 341.0 1.0 17.0 6.0   4.0         11.0   195.0 185.0                       380.0 341 1 17 6   4         11   195 185                 380
260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
251139 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2018   pk_12_total 391.0 13.0 22.0 8.0   5.0         24.0   234.0 229.0                       463.0 391 13 22 8   5         24   234 229                 463
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
254279 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2018   pk_12_total 264.0 1.0 14.0 33.0   5.0       2.0 56.0   198.0 177.0                       375.0 264 1 14 33   5       2 56   198 177                 375
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
255822 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   pk_12_total 508.0 3.0 26.0 18.0   5.0         27.0   313.0 274.0                       587.0 508 3 26 18   5         27   313 274                 587
257404 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School No Elementary PK 05 2018   pk_12_total 248.0 7.0 39.0 84.0   5.0         31.0   217.0 197.0                       414.0 248 7 39 84   5         31   217 197                 414
258425 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2018   pk_12_total 492.0 33.0 28.0 15.0   5.0         47.0   288.0 332.0                       620.0 492 33 28 15   5         47   288 332                 620
258428 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No Elementary KG 05 2018   pk_12_total 327.0 54.0 57.0 38.0   5.0         48.0   265.0 264.0                       529.0 327 54 57 38   5         48   265 264                 529
258804 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   pk_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0                       365.0 315 5 18 9   5         13   195 170                 365
259399 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   pk_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0                       378.0 303 8 19 39   5       2 2   174 204                 378
260532 SD     school 4680430 63003   Yankton 63-3 468043001009 6 Webster Elem   Regular School No Elementary PK 05 2018   pk_12_total 268.0 8.0 31.0 21.0   5.0         14.0   181.0 166.0                       347.0 268 8 31 21   5         14   181 166                 347
251942 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   pk_12_total 333.0 8.0 23.0 4.0   6.0       2.0 12.0   214.0 174.0                       388.0 333 8 23 4   6       2 12   214 174                 388
251943 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2018   pk_12_total 256.0 6.0 18.0 6.0   6.0         11.0   150.0 153.0                       303.0 256 6 18 6   6         11   150 153                 303
253109 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   pk_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0                       315.0 136 1 44 100   6       4 24   164 151                 315
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
257408 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   pk_12_total 113.0 3.0 54.0 300.0   6.0       2.0 42.0   289.0 231.0                       520.0 113 3 54 300   6       2 42   289 231                 520
257426 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 515.0 5.0 56.0 35.0   6.0         39.0   353.0 303.0                       656.0 515 5 56 35   6         39   353 303                 656
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
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
259397 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 202.0 5.0 7.0 21.0   6.0         13.0   130.0 124.0                       254.0 202 5 7 21   6         13   130 124                 254
259764 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   pk_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0                       627.0 550 5 20 32   6         14   313 314                 627
260531 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   pk_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0                       273.0 228 5 19 9   6         6   137 136                 273
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
251287 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2018   pk_12_total 248.0   5.0 4.0   7.0         3.0   135.0 132.0                       267.0 248   5 4   7         3   135 132                 267
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
256883 SD     school 4655260 32002   Pierre 32-2 465526000494 3 Buchanan Elementary   Regular School No Elementary KG 05 2018   pk_12_total 319.0 2.0 17.0 66.0   7.0         45.0   232.0 224.0                       456.0 319 2 17 66   7         45   232 224                 456
257410 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No Elementary KG 05 2018   pk_12_total 93.0 12.0 37.0 146.0   7.0         27.0   162.0 160.0                       322.0 93 12 37 146   7         27   162 160                 322
257416 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No Elementary KG 05 2018   pk_12_total 357.0   21.0 9.0   7.0         22.0   206.0 210.0                       416.0 357   21 9   7         22   206 210                 416
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
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
259398 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   pk_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0                       348.0 257 5 12 39   7       3 25   182 166                 348
259758 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2018   pk_12_total 355.0 2.0 11.0 5.0   7.0         6.0   199.0 187.0                       386.0 355 2 11 5   7         6   199 187                 386
252355 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   pk_12_total 533.0 21.0 50.0 62.0   8.0       3.0 57.0   397.0 337.0                       734.0 533 21 50 62   8       3 57   397 337                 734
253948 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   pk_12_total 369.0 20.0 17.0 9.0   8.0         20.0   228.0 215.0                       443.0 369 20 17 9   8         20   228 215                 443
253954 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School No Elementary KG 05 2018   pk_12_total 369.0 4.0 7.0 4.0   8.0         7.0   199.0 200.0                       399.0 369 4 7 4   8         7   199 200                 399
256130 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   pk_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0                       777.0 662 8 35 38   8         26   389 388                 777
258430 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   pk_12_total 176.0 98.0 74.0 70.0   8.0         58.0   235.0 249.0                       484.0 176 98 74 70   8         58   235 249                 484
259400 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   pk_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0                       288.0 220 4 13 31   8         12   146 142                 288
259763 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   pk_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0                       629.0 543 3 27 21   8         27   316 313                 629
250898 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   pk_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0                       632.0 572 20 14 4   9       2 11   334 298                 632
256131 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   pk_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0                       638.0 549 5 22 34   9       4 15   343 295                 638
258431 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No Middle 06 08 2018   pk_12_total   40.0 27.0     9.0             36.0 40.0                       76.0   40 27     9             36 40                 76
260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
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
252356 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2018   pk_12_total 495.0 20.0 62.0 67.0   10.0       5.0 50.0   371.0 338.0                       709.0 495 20 62 67   10       5 50   371 338                 709
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
257425 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2018   pk_12_total 414.0 11.0 42.0 100.0   10.0       2.0 40.0   326.0 293.0                       619.0 414 11 42 100   10       2 40   326 293                 619
258802 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   pk_12_total 561.0 4.0 27.0 13.0   10.0         11.0   312.0 314.0                       626.0 561 4 27 13   10         11   312 314                 626
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
249953 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   pk_12_total 312.0 12.0 23.0 24.0   11.0       3.0 18.0   197.0 206.0                       403.0 312 12 23 24   11       3 18   197 206                 403
250899 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   pk_12_total 391.0 41.0 17.0 2.0   11.0         22.0   239.0 245.0                       484.0 391 41 17 2   11         22   239 245                 484
251141 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   pk_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0                       277.0 214 7 14 13   11         18   146 131                 277
253950 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   pk_12_total 900.0 16.0 21.0 9.0   11.0         29.0   524.0 462.0                       986.0 900 16 21 9   11         29   524 462                 986
255109 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2018   pk_12_total 29.0 33.0 5.0 28.0   11.0         9.0   77.0 38.0                       115.0 29 33 5 28   11         9   77 38                 115
258417 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2018   pk_12_total   73.0 26.0     11.0             51.0 59.0                       110.0   73 26     11             51 59                 110
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

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