Data source: Big Local News · About: Big Local

10,704 rows where state = "SD" and year = 2017 sorted by total_int descending

View and edit SQL

year

  • 2017 · 10,704
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 ▲
3014780 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   k_12_total 1667.0 187.0 227.0 95.0   72.0       1.0 49.0   1184.0 1114.0       5.4               2298.0 1667 187 227 95   72       1 49   1184 1114                 2298
3014864 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   pk_12_total 1667.0 187.0 227.0 95.0   72.0       1.0 49.0   1184.0 1114.0                       2298.0 1667 187 227 95   72       1 49   1184 1114                 2298
3014770 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2017   k_12_total 1440.0 196.0 119.0 93.0   59.0         72.0   1010.0 969.0       4.6               1979.0 1440 196 119 93   59         72   1010 969                 1979
3014854 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2017   pk_12_total 1440.0 196.0 119.0 93.0   59.0         72.0   1010.0 969.0                       1979.0 1440 196 119 93   59         72   1010 969                 1979
3014790 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   k_12_total 1168.0 312.0 188.0 80.0   142.0       1.0 58.0   1026.0 923.0       11.8               1949.0 1168 312 188 80   142       1 58   1026 923                 1949
3014874 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   pk_12_total 1168.0 312.0 188.0 80.0   142.0       1.0 58.0   1026.0 923.0                       1949.0 1168 312 188 80   142       1 58   1026 923                 1949
3013796 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   k_12_total 1274.0 37.0 83.0 371.0   20.0         86.0   969.0 902.0       0.9               1871.0 1274 37 83 371   20         86   969 902                 1871
3013846 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   pk_12_total 1274.0 37.0 83.0 371.0   20.0         86.0   969.0 902.0                       1871.0 1274 37 83 371   20         86   969 902                 1871
3013815 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   k_12_total 1356.0 10.0 82.0 89.0   20.0         43.0   815.0 785.0       1.0               1600.0 1356 10 82 89   20         43   815 785                 1600
3013865 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   pk_12_total 1356.0 10.0 82.0 89.0   20.0         43.0   815.0 785.0                       1600.0 1356 10 82 89   20         43   815 785                 1600
3014773 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2017   k_12_total 1112.0 65.0 56.0 18.0   29.0         41.0   668.0 653.0       0.8               1321.0 1112 65 56 18   29         41   668 653                 1321
3014857 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2017   pk_12_total 1112.0 65.0 56.0 18.0   29.0         41.0   668.0 653.0                       1321.0 1112 65 56 18   29         41   668 653                 1321
3006351 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   k_12_total 1044.0 40.0 40.0 87.0   34.0       7.0 11.0   652.0 611.0       2.5               1263.0 1044 40 40 87   34       7 11   652 611                 1263
3006371 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   pk_12_total 1044.0 40.0 40.0 87.0   34.0       7.0 11.0   652.0 611.0                       1263.0 1044 40 40 87   34       7 11   652 611                 1263
3016139 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   k_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0       0.7               1232.0 1114 9 45 37   9         18   644 588                 1232
3016155 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   pk_12_total 1114.0 9.0 45.0 37.0   9.0         18.0   644.0 588.0                       1232.0 1114 9 45 37   9         18   644 588                 1232
3014776 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2017   k_12_total 871.0 77.0 63.0 25.0   25.0         38.0   538.0 561.0       1.5               1099.0 871 77 63 25   25         38   538 561                 1099
3014860 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2017   pk_12_total 871.0 77.0 63.0 25.0   25.0         38.0   538.0 561.0                       1099.0 871 77 63 25   25         38   538 561                 1099
3007291 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   k_12_total 980.0 30.0 21.0 2.0   15.0       2.0 17.0   536.0 531.0       0.7               1067.0 980 30 21 2   15       2 17   536 531                 1067
3007305 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   pk_12_total 980.0 30.0 21.0 2.0   15.0       2.0 17.0   536.0 531.0                       1067.0 980 30 21 2   15       2 17   536 531                 1067
3014757 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2017   k_12_total 729.0 63.0 65.0 50.0   25.0       2.0 40.0   498.0 476.0       0.8               974.0 729 63 65 50   25       2 40   498 476                 974
3014841 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2017   pk_12_total 729.0 63.0 65.0 50.0   25.0       2.0 40.0   498.0 476.0                       974.0 729 63 65 50   25       2 40   498 476                 974
3014861 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2017   pk_12_total 767.0 41.0 59.0 18.0   16.0       1.0 56.0   480.0 478.0                       958.0 767 41 59 18   16       1 56   480 478                 958
3014791 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2017   k_12_total 382.0 187.0 156.0 71.0   71.0       1.0 41.0   465.0 444.0       12.5               909.0 382 187 156 71   71       1 41   465 444                 909
3014875 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2017   pk_12_total 382.0 187.0 156.0 71.0   71.0       1.0 41.0   465.0 444.0                       909.0 382 187 156 71   71       1 41   465 444                 909
3014840 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   pk_12_total 715.0 53.0 65.0 7.0   20.0         48.0   441.0 467.0                       908.0 715 53 65 7   20         48   441 467                 908
3016914 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   k_12_total 788.0 18.0 47.0 31.0   7.0         10.0   464.0 437.0       1.4               901.0 788 18 47 31   7         10   464 437                 901
3016926 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   pk_12_total 788.0 18.0 47.0 31.0   7.0         10.0   464.0 437.0                       901.0 788 18 47 31   7         10   464 437                 901
3014756 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2017   k_12_total 704.0 53.0 63.0 7.0   19.0         48.0   434.0 460.0       6.9               894.0 704 53 63 7   19         48   434 460                 894
3007534 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   k_12_total 770.0 15.0 37.0 10.0   30.0       2.0 21.0   435.0 450.0       1.8               885.0 770 15 37 10   30       2 21   435 450                 885
3007546 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   pk_12_total 770.0 15.0 37.0 10.0   30.0       2.0 21.0   435.0 450.0                       885.0 770 15 37 10   30       2 21   435 450                 885
3010389 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2017   k_12_total 794.0 11.0 13.0 9.0   13.0         19.0   464.0 395.0       0.7               859.0 794 11 13 9   13         19   464 395                 859
3010407 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2017   pk_12_total 794.0 11.0 13.0 9.0   13.0         19.0   464.0 395.0                       859.0 794 11 13 9   13         19   464 395                 859
3014777 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No Elementary PK 05 2017   k_12_total 700.0 27.0 39.0 7.0   15.0       1.0 46.0   408.0 427.0       0.8               835.0 700 27 39 7   15       1 46   408 427                 835
3014762 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2017   k_12_total 321.0 145.0 154.0 94.0   27.0       1.0 43.0   402.0 383.0       12.7               785.0 321 145 154 94   27       1 43   402 383                 785
3014846 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2017   pk_12_total 321.0 145.0 154.0 94.0   27.0       1.0 43.0   402.0 383.0                       785.0 321 145 154 94   27       1 43   402 383                 785
3007537 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2017   k_12_total 645.0 14.0 29.0 16.0   36.0       1.0 35.0   400.0 376.0       1.8               776.0 645 14 29 16   36       1 35   400 376                 776
3007549 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2017   pk_12_total 645.0 14.0 29.0 16.0   36.0       1.0 35.0   400.0 376.0                       776.0 645 14 29 16   36       1 35   400 376                 776
3012541 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   k_12_total 665.0 8.0 33.0 35.0   8.0         23.0   406.0 366.0       0.3               772.0 665 8 33 35   8         23   406 366                 772
3012555 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   pk_12_total 665.0 8.0 33.0 35.0   8.0         23.0   406.0 366.0                       772.0 665 8 33 35   8         23   406 366                 772
3012229 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 05 2017   k_12_total 653.0 5.0 38.0 28.0   4.0         37.0   410.0 355.0       0.0               765.0 653 5 38 28   4         37   410 355                 765
3012249 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 05 2017   pk_12_total 653.0 5.0 38.0 28.0   4.0         37.0   410.0 355.0                       765.0 653 5 38 28   4         37   410 355                 765
3013318 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2017   k_12_total 597.0 4.0 31.0 89.0   7.0       1.0 24.0   385.0 368.0       0.7               753.0 597 4 31 89   7       1 24   385 368                 753
3013328 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2017   pk_12_total 597.0 4.0 31.0 89.0   7.0       1.0 24.0   385.0 368.0                       753.0 597 4 31 89   7       1 24   385 368                 753
3014847 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   pk_12_total 555.0 70.0 39.0 16.0   21.0         50.0   384.0 367.0                       751.0 555 70 39 16   21         50   384 367                 751
3010940 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2017   k_12_total 414.0 13.0 122.0 9.0   178.0             418.0 318.0       25.0               736.0 414 13 122 9   178             418 318                 736
3010954 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2017   pk_12_total 414.0 13.0 122.0 9.0   178.0             418.0 318.0                       736.0 414 13 122 9   178             418 318                 736
3014849 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   pk_12_total 332.0 54.0 190.0 66.0   21.0         58.0   373.0 348.0                       721.0 332 54 190 66   21         58   373 348                 721
3008767 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2017   k_12_total 505.0 20.0 50.0 59.0   11.0       2.0 67.0   376.0 338.0       0.1               714.0 505 20 50 59   11       2 67   376 338                 714
3008779 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2017   pk_12_total 505.0 20.0 50.0 59.0   11.0       2.0 67.0   376.0 338.0                       714.0 505 20 50 59   11       2 67   376 338                 714
3013023 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2017   pk_12_total 3.0   11.0 690.0             3.0   362.0 345.0                       707.0 3   11 690             3   362 345                 707
3014738 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   grade_9 480.0 42.0 90.0 44.0   23.0       0.0 13.0   368.0 324.0                       692.0 480 42 90 44   23       0 13   368 324                 692
3012228 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2017   k_12_total 608.0 4.0 20.0 37.0   2.0       1.0 12.0   354.0 330.0       0.0               684.0 608 4 20 37   2       1 12   354 330                 684
3012248 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2017   pk_12_total 608.0 4.0 20.0 37.0   2.0       1.0 12.0   354.0 330.0                       684.0 608 4 20 37   2       1 12   354 330                 684
3015369 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2017   k_12_total 628.0 6.0 9.0 7.0   1.0         25.0   357.0 319.0       0.9               676.0 628 6 9 7   1         25   357 319                 676
3015377 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2017   pk_12_total 628.0 6.0 9.0 7.0   1.0         25.0   357.0 319.0                       676.0 628 6 9 7   1         25   357 319                 676
3014851 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2017   pk_12_total 574.0 31.0 31.0 4.0   12.0       1.0 21.0   357.0 317.0                       674.0 574 31 31 4   12       1 21   357 317                 674
3013812 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2017   k_12_total 435.0 5.0 55.0 126.0   3.0         47.0   330.0 341.0       0.6               671.0 435 5 55 126   3         47   330 341                 671
3013862 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 435.0 5.0 55.0 126.0   3.0         47.0   330.0 341.0                       671.0 435 5 55 126   3         47   330 341                 671
3014765 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2017   k_12_total 307.0 50.0 175.0 60.0   20.0         56.0   342.0 326.0       16.6               668.0 307 50 175 60   20         56   342 326                 668
3014835 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2017   pk_12_total 199.0 184.0 106.0 31.0   100.0         47.0   341.0 326.0                       667.0 199 184 106 31   100         47   341 326                 667
3014767 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2017   k_12_total 568.0 30.0 28.0 4.0   11.0       1.0 20.0   348.0 314.0       0.8               662.0 568 30 28 4   11       1 20   348 314                 662
3013011 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2017   k_12_total 3.0   11.0 644.0             2.0   334.0 326.0       0.0               660.0 3   11 644             2   334 326                 660
3013814 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2017   k_12_total 552.0 6.0 37.0 28.0   12.0         24.0   343.0 316.0       1.2               659.0 552 6 37 28   12         24   343 316                 659
3013864 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 552.0 6.0 37.0 28.0   12.0         24.0   343.0 316.0                       659.0 552 6 37 28   12         24   343 316                 659
3007292 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2017   k_12_total 596.0 18.0 16.0 1.0   3.0       1.0 13.0   335.0 313.0       0.9               648.0 596 18 16 1   3       1 13   335 313                 648
3007306 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2017   pk_12_total 596.0 18.0 16.0 1.0   3.0       1.0 13.0   335.0 313.0                       648.0 596 18 16 1   3       1 13   335 313                 648
3013817 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2017   k_12_total 524.0 4.0 38.0 47.0   5.0         30.0   321.0 327.0       0.5               648.0 524 4 38 47   5         30   321 327                 648
3013867 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 524.0 4.0 38.0 47.0   5.0         30.0   321.0 327.0                       648.0 524 4 38 47   5         30   321 327                 648
3008768 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2017   k_12_total 453.0 19.0 50.0 56.0   8.0       4.0 55.0   338.0 307.0       0.0               645.0 453 19 50 56   8       4 55   338 307                 645
3008780 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No Middle 06 08 2017   pk_12_total 453.0 19.0 50.0 56.0   8.0       4.0 55.0   338.0 307.0                       645.0 453 19 50 56   8       4 55   338 307                 645
3013798 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2017   k_12_total 476.0 9.0 34.0 77.0   7.0         41.0   330.0 314.0       1.1               644.0 476 9 34 77   7         41   330 314                 644
3013848 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No Middle 06 08 2017   pk_12_total 476.0 9.0 34.0 77.0   7.0         41.0   330.0 314.0                       644.0 476 9 34 77   7         41   330 314                 644
3012227 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2017   k_12_total 566.0 3.0 20.0 22.0   3.0         28.0   339.0 303.0       0.0               642.0 566 3 20 22   3         28   339 303                 642
3012247 SD     school 4669930 46001   Meade 46-1 466993000644 5 Piedmont Valley Elementary   Regular School No Elementary KG 06 2017   pk_12_total 566.0 3.0 20.0 22.0   3.0         28.0   339.0 303.0                       642.0 566 3 20 22   3         28   339 303                 642
3014766 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2017   k_12_total 518.0 23.0 28.0 12.0   6.0         44.0   288.0 343.0       0.3               631.0 518 23 28 12   6         44   288 343                 631
3014850 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No Elementary KG 05 2017   pk_12_total 518.0 23.0 28.0 12.0   6.0         44.0   288.0 343.0                       631.0 518 23 28 12   6         44   288 343                 631
3013816 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2017   k_12_total 450.0 12.0 33.0 84.0   11.0       1.0 38.0   326.0 303.0       1.0               629.0 450 12 33 84   11       1 38   326 303                 629
3013866 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No Elementary KG 05 2017   pk_12_total 450.0 12.0 33.0 84.0   11.0       1.0 38.0   326.0 303.0                       629.0 450 12 33 84   11       1 38   326 303                 629
3013771 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   grade_9 383.0 10.0 32.0 162.0   5.0         32.0   337.0 287.0                       624.0 383 10 32 162   5         32   337 287                 624
3016141 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2017   k_12_total 557.0 4.0 18.0 32.0   5.0         8.0   307.0 317.0       1.0               624.0 557 4 18 32   5         8   307 317                 624
3016157 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2017   pk_12_total 557.0 4.0 18.0 32.0   5.0         8.0   307.0 317.0                       624.0 557 4 18 32   5         8   307 317                 624
3016140 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2017   k_12_total 537.0 7.0 22.0 19.0   8.0         19.0   308.0 304.0       0.3               612.0 537 7 22 19   8         19   308 304                 612
3016156 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2017   pk_12_total 537.0 7.0 22.0 19.0   8.0         19.0   308.0 304.0                       612.0 537 7 22 19   8         19   308 304                 612
3015198 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2017   k_12_total 537.0 2.0 32.0 24.0   9.0         7.0   329.0 282.0       0.2               611.0 537 2 32 24   9         7   329 282                 611
3015212 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2017   pk_12_total 537.0 2.0 32.0 24.0   9.0         7.0   329.0 282.0                       611.0 537 2 32 24   9         7   329 282                 611
3014775 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2017   k_12_total 454.0 41.0 42.0 16.0   5.0       1.0 50.0   302.0 307.0       1.0               609.0 454 41 42 16   5       1 50   302 307                 609
3014859 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2017   pk_12_total 454.0 41.0 42.0 16.0   5.0       1.0 50.0   302.0 307.0                       609.0 454 41 42 16   5       1 50   302 307                 609
3013315 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2017   k_12_total 442.0 4.0 19.0 86.0   2.0         50.0   312.0 291.0       0.5               603.0 442 4 19 86   2         50   312 291                 603
3013325 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No Middle 06 08 2017   pk_12_total 442.0 4.0 19.0 86.0   2.0         50.0   312.0 291.0                       603.0 442 4 19 86   2         50   312 291                 603
3007293 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2017   k_12_total 542.0 16.0 17.0 4.0   11.0       1.0 10.0   328.0 273.0       0.5               601.0 542 16 17 4   11       1 10   328 273                 601
3007307 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2017   pk_12_total 542.0 16.0 17.0 4.0   11.0       1.0 10.0   328.0 273.0                       601.0 542 16 17 4   11       1 10   328 273                 601
3012542 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2017   k_12_total 528.0 6.0 19.0 28.0   9.0       3.0 8.0   313.0 288.0       1.2               601.0 528 6 19 28   9       3 8   313 288                 601
3012556 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2017   pk_12_total 528.0 6.0 19.0 28.0   9.0       3.0 8.0   313.0 288.0                       601.0 528 6 19 28   9       3 8   313 288                 601
3016915 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   k_12_total 503.0 9.0 40.0 35.0   5.0         7.0   315.0 284.0       2.3               599.0 503 9 40 35   5         7   315 284                 599
3016927 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2017   pk_12_total 503.0 9.0 40.0 35.0   5.0         7.0   315.0 284.0                       599.0 503 9 40 35   5         7   315 284                 599
3015196 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2017   k_12_total 526.0 2.0 31.0 17.0   3.0         13.0   293.0 299.0       0.5               592.0 526 2 31 17   3         13   293 299                 592
3015210 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No Elementary 03 05 2017   pk_12_total 526.0 2.0 31.0 17.0   3.0         13.0   293.0 299.0                       592.0 526 2 31 17   3         13   293 299                 592
3014763 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2017   k_12_total 474.0 38.0 21.0 9.0   14.0         33.0   283.0 306.0       1.4               589.0 474 38 21 9   14         33   283 306                 589
3015570 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2017   k_12_total 3.0   6.0 574.0   1.0       1.0 4.0   285.0 304.0       0.2               589.0 3   6 574   1       1 4   285 304                 589

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