Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 671

grade

  • pk_12_total · 671
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 ▲
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
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
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
257405 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   pk_12_total 1222.0 33.0 104.0 386.0   19.0         89.0   933.0 920.0                       1853.0 1222 33 104 386   19         89   933 920                 1853
257424 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   pk_12_total 1382.0 7.0 75.0 84.0   23.0       2.0 53.0   793.0 833.0                       1626.0 1382 7 75 84   23       2 53   793 833                 1626
258432 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   pk_12_total 1112.0 71.0 67.0 22.0   32.0         60.0   678.0 686.0                       1364.0 1112 71 67 22   32         60   678 686                 1364
249946 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   pk_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0                       1344.0 1087 39 58 98   44       5 13   674 670                 1344
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
258435 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   pk_12_total 847.0 97.0 78.0 28.0   27.0         41.0   555.0 563.0                       1118.0 847 97 78 28   27         41   555 563                 1118
250896 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   pk_12_total 982.0 31.0 25.0 3.0   15.0       2.0 20.0   548.0 530.0                       1078.0 982 31 25 3   15       2 20   548 530                 1078
258416 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   pk_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0                       1047.0 749 80 93 51   25       5 44   540 507                 1047
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
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
258436 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2018   pk_12_total 775.0 42.0 57.0 17.0   17.0       3.0 59.0   492.0 478.0                       970.0 775 42 57 17   17       3 59   492 478                 970
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
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
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
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
258421 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2018   pk_12_total 339.0 137.0 158.0 100.0   18.0       2.0 56.0   435.0 375.0                       810.0 339 137 158 100   18       2 56   435 375                 810
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
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
258422 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2018   pk_12_total 551.0 58.0 40.0 15.0   25.0         56.0   389.0 356.0                       745.0 551 58 40 15   25         56   389 356                 745
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
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
258424 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   pk_12_total 314.0 61.0 201.0 66.0   20.0         61.0   385.0 338.0                       723.0 314 61 201 66   20         61   385 338                 723
254497 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   pk_12_total 375.0 14.0 145.0 6.0   176.0       3.0 2.0   395.0 326.0                       721.0 375 14 145 6   176       3 2   395 326                 721
258967 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   pk_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0                       710.0 652 7 19 8   1         23   378 332                 710
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
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
256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684
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
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
255821 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2018   pk_12_total 578.0 7.0 32.0 35.0             14.0   327.0 339.0                       666.0 578 7 32 35             14   327 339                 666
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
257423 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 554.0 5.0 35.0 31.0   15.0         20.0   329.0 331.0                       660.0 554 5 35 31   15         20   329 331                 660
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
253951 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   pk_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0                       648.0 580 9 19 4   15         21   335 313                 648
255820 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2018   pk_12_total 573.0 2.0 26.0 18.0   2.0         26.0   332.0 315.0                       647.0 573 2 26 18   2         26   332 315                 647
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
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
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
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
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
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
258409 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   pk_12_total 167.0 189.0 100.0 20.0   112.0         40.0   322.0 306.0                       628.0 167 189 100 20   112         40   322 306                 628
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
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
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
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
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
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
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
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
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
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
250895 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   pk_12_total 523.0 11.0 8.0 6.0   2.0       3.0 21.0   317.0 257.0                       574.0 523 11 8 6   2       3 21   317 257                 574
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
258440 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   pk_12_total 291.0 101.0 87.0 17.0   31.0         42.0   289.0 280.0                       569.0 291 101 87 17   31         42   289 280                 569
255824 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School No Middle 06 08 2018   pk_12_total 477.0 4.0 23.0 33.0   1.0         27.0   285.0 280.0                       565.0 477 4 23 33   1         27   285 280                 565
257418 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2018   pk_12_total 427.0 3.0 25.0 55.0   1.0       2.0 49.0   265.0 297.0                       562.0 427 3 25 55   1       2 49   265 297                 562
258413 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   pk_12_total 162.0 194.0 70.0 18.0   60.0       2.0 40.0   267.0 279.0                       546.0 162 194 70 18   60       2 40   267 279                 546
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
259198 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   pk_12_total 2.0   15.0 520.0             8.0   276.0 269.0                       545.0 2   15 520             8   276 269                 545
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
258446 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   pk_12_total 288.0 71.0 96.0 22.0   18.0       3.0 38.0   280.0 256.0                       536.0 288 71 96 22   18       3 38   280 256                 536
258968 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School No Middle 05 08 2018   pk_12_total 471.0 10.0 18.0 6.0             28.0   293.0 240.0                       533.0 471 10 18 6             28   293 240                 533
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
249947 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2018   pk_12_total 425.0 12.0 25.0 24.0   16.0         20.0   263.0 259.0                       522.0 425 12 25 24   16         20   263 259                 522
253947 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   pk_12_total 458.0 11.0 11.0 5.0   19.0         17.0   274.0 247.0                       521.0 458 11 11 5   19         17   274 247                 521
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
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
250900 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2018   pk_12_total 493.0 6.0 6.0 5.0   1.0         6.0   279.0 238.0                       517.0 493 6 6 5   1         6   279 238                 517
258447 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   pk_12_total 152.0 119.0 132.0 48.0   19.0         47.0   276.0 241.0                       517.0 152 119 132 48   19         47   276 241                 517
259255 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2018   pk_12_total 442.0 40.0 24.0               11.0   278.0 239.0                       517.0 442 40 24               11   278 239                 517
254498 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2018   pk_12_total 279.0 8.0 105.0 5.0   110.0       2.0 6.0   259.0 256.0                       515.0 279 8 105 5   110       2 6   259 256                 515
256128 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   pk_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0                       513.0 418 8 36 36   1         14   257 256                 513
249954 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   pk_12_total 415.0 7.0 30.0 26.0   16.0       3.0 14.0   256.0 255.0                       511.0 415 7 30 26   16       3 14   256 255                 511
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
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
258423 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   pk_12_total 158.0 105.0 73.0 71.0   17.0         65.0   254.0 235.0                       489.0 158 105 73 71   17         65   254 235                 489
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
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
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
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
258585 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 119.0 1.0 43.0 252.0             65.0   240.0 240.0                       480.0 119 1 43 252             65   240 240                 480
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
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
257406 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School No Elementary KG 05 2018   pk_12_total 431.0 3.0 9.0 7.0   13.0         7.0   238.0 232.0                       470.0 431 3 9 7   13         7   238 232                 470
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
259199 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2018   pk_12_total 4.0   2.0 449.0   1.0         2.0   242.0 216.0                       458.0 4   2 449   1         2   242 216                 458
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
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
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
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
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
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
250453 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2018   pk_12_total 382.0   28.0 8.0             23.0   236.0 205.0                       441.0 382   28 8             23   236 205                 441
256885 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2018   pk_12_total 287.0 3.0 28.0 82.0             40.0   244.0 196.0                       440.0 287 3 28 82             40   244 196                 440
254499 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   pk_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0                       432.0 190 4 126 7   92         13   245 187                 432
258966 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   pk_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0                       431.0 387 9 9 7             19   226 205                 431

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