Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by multiracial descending

View and edit SQL

grade

year

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
494917 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2020   k_12_total 443.0 10.0 45.0 72.0   6.0         94.0   348.0 322.0       0.9               670.0 443 10 45 72   6         94   348 322                 670
494967 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School Not applicable Middle 06 08 2020   pk_12_total 443.0 10.0 45.0 72.0   6.0         94.0   348.0 322.0                       670.0 443 10 45 72   6         94   348 322                 670
494934 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 1398.0 9.0 107.0 81.0   29.0         92.0   874.0 842.0       0.6               1716.0 1398 9 107 81   29         92   874 842                 1716
494984 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 1398.0 9.0 107.0 81.0   29.0         92.0   874.0 842.0                       1716.0 1398 9 107 81   29         92   874 842                 1716
2962261 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Jr High   Regular School No 2 07 08 2015   grade_8 5.0   1.0 16.0             9.0   13.0 18.0                       31.0 5   1 16             9   13 18                 31
2962842 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_5 207.0 0.0 9.0 11.0   9.0       0.0 9.0   129.0 116.0                       245.0 207 0 9 11   9       0 9   129 116                 245
2965099 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No 3 09 12 2015   k_12_total 83.0   1.0               9.0   43.0 50.0                       93.0 83   1               9   43 50                 93
2965105 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No 3 09 12 2015   pk_12_total 83.0   1.0               9.0   43.0 50.0                       93.0 83   1               9   43 50                 93
2965706 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   k_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2965722 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   pk_12_total 397.0 6.0 10.0 3.0   9.0         9.0   217.0 217.0                       434.0 397 6 10 3   9         9   217 217                 434
2967806 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   k_12_total 493.0 8.0 22.0 30.0   6.0         9.0   309.0 259.0                       568.0 493 8 22 30   6         9   309 259                 568
2967820 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   pk_12_total 493.0 8.0 22.0 30.0   6.0         9.0   309.0 259.0                       568.0 493 8 22 30   6         9   309 259                 568
2968677 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No 1 KG 05 2015   grade_1 64.0 0.0 8.0 12.0   0.0       0.0 9.0   44.0 49.0                       93.0 64 0 8 12   0       0 9   44 49                 93
2968781 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2015   grade_2 28.0 0.0 11.0 19.0             9.0   31.0 36.0                       67.0 28 0 11 19             9   31 36                 67
2968806 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No 1 KG 05 2015   grade_3 32.0 2.0 5.0 24.0             9.0   39.0 33.0                       72.0 32 2 5 24             9   39 33                 72
2968905 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No 2 06 08 2015   grade_7 143.0 4.0 10.0 33.0   0.0         9.0   100.0 99.0                       199.0 143 4 10 33   0         9   100 99                 199
2968916 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No 2 06 08 2015   grade_8 169.0 8.0 6.0 21.0   3.0         9.0   114.0 102.0                       216.0 169 8 6 21   3         9   114 102                 216
2968994 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No 1 KG 05 2015   kindergarten 21.0 1.0 6.0 23.0   2.0         9.0   27.0 35.0                       62.0 21 1 6 23   2         9   27 35                 62
2969533 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2015   grade_1 67.0 7.0 9.0 7.0   6.0       1.0 9.0   55.0 51.0                       106.0 67 7 9 7   6       1 9   55 51                 106
2969703 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   grade_2 36.0 8.0 8.0 5.0   1.0       2.0 9.0   30.0 39.0                       69.0 36 8 8 5   1       2 9   30 39                 69
2969723 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School No 1 PK 05 2015   grade_2 120.0 1.0 4.0 1.0   2.0         9.0   71.0 66.0                       137.0 120 1 4 1   2         9   71 66                 137
2969902 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2015   grade_6 303.0 24.0 14.0 10.0   8.0         9.0   174.0 194.0                       368.0 303 24 14 10   8         9   174 194                 368
2969969 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2015   grade_8 209.0 23.0 15.0 12.0   5.0         9.0   164.0 109.0                       273.0 209 23 15 12   5         9   164 109                 273
2970115 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2015   kindergarten 99.0 5.0 3.0 1.0   0.0         9.0   49.0 68.0                       117.0 99 5 3 1   0         9   49 68                 117
2970120 SD     school 4666270 49005   Sioux Falls 49-5 466627000601 27 Longfellow Elementary   Regular School No 1 KG 05 2015   kindergarten 11.0 20.0 21.0 3.0   9.0         9.0   40.0 33.0                       73.0 11 20 21 3   9         9   40 33                 73
2970198 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 27.0 16.0 4.0 4.0   2.0       0.0 9.0   38.0 24.0                       62.0 27 16 4 4   2       0 9   38 24                 62
2970202 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 70.0 5.0 31.0 9.0   1.0         9.0   74.0 51.0                       125.0 70 5 31 9   1         9   74 51                 125
2970539 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   k_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970541 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   k_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2970555 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No 3 09 12 2015   pk_12_total 502.0 7.0 30.0 14.0   9.0         9.0   298.0 273.0                       571.0 502 7 30 14   9         9   298 273                 571
2970557 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   pk_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2972186 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 05 2015   k_12_total 154.0 4.0 5.0 2.0             9.0   84.0 90.0                       174.0 154 4 5 2             9   84 90                 174
3344424 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2016   pk_12_total 193.0 1.0 7.0 2.0             9.0   104.0 108.0                       212.0 193 1 7 2             9   104 108                 212
3345207 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No 2 07 08 2016   grade_8 250.0 6.0 8.0 1.0   2.0         9.0   152.0 124.0                       276.0 250 6 8 1   2         9   152 124                 276
3345434 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   grade_2 67.0 5.0 3.0 0.0   3.0       1.0 9.0   42.0 46.0                       88.0 67 5 3 0   3       1 9   42 46                 88
3345441 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   grade_3 59.0 7.0 5.0 2.0   3.0       1.0 9.0   36.0 50.0                       86.0 59 7 5 2   3       1 9   36 50                 86
3345486 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No 1 KG 03 2016   kindergarten 120.0 5.0 3.0 1.0   1.0         9.0   78.0 61.0                       139.0 120 5 3 1   1         9   78 61                 139
3349912 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No 1 PK 06 2016   pk_12_total 62.0   4.0 33.0             9.0   48.0 60.0                       108.0 62   4 33             9   48 60                 108
3350642 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No 1 KG 06 2016   k_12_total 104.0   3.0 5.0             9.0   63.0 58.0       1.8               121.0 104   3 5             9   63 58                 121
3350648 SD     school 4650670 51003   New Underwood 51-3 465067000463 2 New Underwood Elem   Regular School No 1 KG 06 2016   pk_12_total 104.0   3.0 5.0             9.0   63.0 58.0                       121.0 104   3 5             9   63 58                 121
3351121 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No 1 KG 05 2016   grade_1 37.0 0.0 3.0 16.0   0.0         9.0   35.0 30.0                       65.0 37 0 3 16   0         9   35 30                 65
3351138 SD     school 4655260 32002   Pierre 32-2 465526000494 3 Buchanan Elementary   Regular School No 1 KG 05 2016   grade_2 50.0 0.0 2.0 9.0   2.0         9.0   30.0 42.0                       72.0 50 0 2 9   2         9   30 42                 72
3351141 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No 1 KG 05 2016   grade_2 40.0 1.0 4.0 16.0   0.0         9.0   25.0 45.0                       70.0 40 1 4 16   0         9   25 45                 70
3351435 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   grade_12 284.0 6.0 17.0 41.0   6.0         9.0   170.0 193.0                       363.0 284 6 17 41   6         9   170 193                 363
3351530 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School No 1 KG 05 2016   grade_4 86.0 3.0 7.0 15.0   2.0       0.0 9.0   60.0 62.0                       122.0 86 3 7 15   2       0 9   60 62                 122
3351603 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No 2 06 08 2016   grade_7 193.0 1.0 12.0 5.0   3.0         9.0   118.0 105.0                       223.0 193 1 12 5   3         9   118 105                 223
3351620 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No 2 06 08 2016   grade_8 56.0 4.0 10.0 80.0   2.0         9.0   98.0 63.0                       161.0 56 4 10 80   2         9   98 63                 161
3351690 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No 1 KG 05 2016   kindergarten 25.0 3.0 7.0 24.0   0.0         9.0   33.0 35.0                       68.0 25 3 7 24   0         9   33 35                 68
3352118 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No 1 KG 05 2016   grade_1 112.0 6.0 7.0 0.0   3.0         9.0   64.0 73.0                       137.0 112 6 7 0   3         9   64 73                 137
3352176 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2016   grade_10 375.0 44.0 35.0 39.0   14.0       0.0 9.0   272.0 244.0                       516.0 375 44 35 39   14       0 9   272 244                 516
3352272 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No 3 09 12 2016   grade_12 371.0 36.0 48.0 13.0   23.0       0.0 9.0   243.0 257.0                       500.0 371 36 48 13   23       0 9   243 257                 500
3352280 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   grade_12 271.0 60.0 42.0 14.0   36.0         9.0   213.0 219.0                       432.0 271 60 42 14   36         9   213 219                 432
3352283 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No 1 PK 05 2016   grade_2 38.0 25.0 12.0 3.0   8.0       0.0 9.0   48.0 47.0                       95.0 38 25 12 3   8       0 9   48 47                 95
3352299 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No 1 PK 05 2016   grade_2 71.0 8.0 29.0 15.0   2.0       0.0 9.0   70.0 64.0                       134.0 71 8 29 15   2       0 9   70 64                 134
3352304 SD     school 4666270 49005   Sioux Falls 49-5 466627000598 31 Laura Wilder Elementary   Regular School No 1 KG 05 2016   grade_2 64.0 9.0 11.0 11.0   3.0       0.0 9.0   49.0 58.0                       107.0 64 9 11 11   3       0 9   49 58                 107
3352346 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No 1 PK 05 2016   grade_3 12.0 7.0 21.0 3.0   1.0         9.0   22.0 31.0                       53.0 12 7 21 3   1         9   22 31                 53
3352349 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No 1 PK 05 2016   grade_3 26.0 17.0 14.0 9.0   2.0       0.0 9.0   37.0 40.0                       77.0 26 17 14 9   2       0 9   37 40                 77
3352353 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No 1 KG 05 2016   grade_3 85.0 7.0 10.0 4.0   0.0       2.0 9.0   55.0 62.0                       117.0 85 7 10 4   0       2 9   55 62                 117
3352430 SD     school 4666270 49005   Sioux Falls 49-5 466627000976 57 John F Kennedy Elementary   Regular School No 1 KG 05 2016   grade_5 80.0 4.0 2.0 2.0   2.0         9.0   43.0 56.0                       99.0 80 4 2 2   2         9   43 56                 99
3352483 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2016   grade_6 303.0 21.0 13.0 12.0   10.0         9.0   193.0 175.0                       368.0 303 21 13 12   10         9   193 175                 368
3352523 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No 2 06 08 2016   grade_7 356.0 20.0 14.0 2.0   8.0         9.0   213.0 196.0                       409.0 356 20 14 2   8         9   213 196                 409
3352526 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2016   grade_7 306.0 24.0 15.0 9.0   8.0         9.0   176.0 195.0                       371.0 306 24 15 9   8         9   176 195                 371
3352554 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No 2 06 08 2016   grade_8 102.0 34.0 42.0 31.0   15.0       0.0 9.0   126.0 107.0                       233.0 102 34 42 31   15       0 9   126 107                 233
3352569 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2016   grade_8 299.0 21.0 7.0 11.0   7.0         9.0   187.0 167.0                       354.0 299 21 7 11   7         9   187 167                 354
3352582 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No 2 06 08 2016   grade_8 151.0 50.0 47.0 27.0   21.0       0.0 9.0   166.0 139.0                       305.0 151 50 47 27   21       0 9   166 139                 305
3353065 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2016   grade_5 158.0   8.0 4.0   1.0         9.0   100.0 80.0                       180.0 158   8 4   1         9   100 80                 180
3353292 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No 3 09 12 2016   k_12_total 379.0 5.0 9.0 7.0   1.0         9.0   203.0 207.0       0.0               410.0 379 5 9 7   1         9   203 207                 410
3353302 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No 3 09 12 2016   pk_12_total 379.0 5.0 9.0 7.0   1.0         9.0   203.0 207.0                       410.0 379 5 9 7   1         9   203 207                 410
3353774 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2016   grade_1 13.0   2.0 60.0             9.0   45.0 39.0                       84.0 13   2 60             9   45 39                 84
3353977 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No 1 PK 06 2016   grade_3 45.0 1.0 1.0 7.0           0.0 9.0   32.0 31.0                       63.0 45 1 1 7           0 9   32 31                 63
3354036 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2016   k_12_total 1088.0 13.0 48.0 38.0   10.0         9.0   624.0 582.0       0.7               1206.0 1088 13 48 38   10         9   624 582                 1206
3354052 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2016   pk_12_total 1088.0 13.0 48.0 38.0   10.0         9.0   624.0 582.0                       1206.0 1088 13 48 38   10         9   624 582                 1206
3354690 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 06 2016   k_12_total 161.0 6.0 14.0               9.0   89.0 101.0                       190.0 161 6 14               9   89 101                 190
3006355 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2017   k_12_total 149.0 2.0 9.0 17.0   5.0       1.0 9.0   96.0 96.0       3.7               192.0 149 2 9 17   5       1 9   96 96                 192
3006375 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2017   pk_12_total 149.0 2.0 9.0 17.0   5.0       1.0 9.0   96.0 96.0                       192.0 149 2 9 17   5       1 9   96 96                 192
3006496 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2017   pk_12_total 202.0   10.0 1.0   1.0         9.0   106.0 117.0                       223.0 202   10 1   1         9   106 117                 223
3006872 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2017   grade_1 11.0   0.0 19.0             9.0   14.0 25.0                       39.0 11   0 19             9   14 25                 39
3006876 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2017   grade_11 11.0   1.0 17.0   0.0         9.0   21.0 17.0                       38.0 11   1 17   0         9   21 17                 38
3006884 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2017   grade_2 5.0   1.0 19.0             9.0   16.0 18.0                       34.0 5   1 19             9   16 18                 34
3006887 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2017   grade_3 5.0   1.0 12.0             9.0   13.0 14.0                       27.0 5   1 12             9   13 14                 27
3006896 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2017   grade_6 2.0   2.0 17.0             9.0   15.0 15.0                       30.0 2   2 17             9   15 15                 30
3007284 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_9 252.0 8.0 5.0 1.0   3.0       0.0 9.0   148.0 130.0                       278.0 252 8 5 1   3       0 9   148 130                 278
3007297 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2017   kindergarten 112.0 2.0 1.0 0.0   0.0       1.0 9.0   68.0 57.0                       125.0 112 2 1 0   0       1 9   68 57                 125
3009050 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No Elementary KG 05 2017   k_12_total 289.0   16.0 3.0   1.0         9.0   168.0 150.0       0.9               318.0 289   16 3   1         9   168 150                 318
3009056 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No Elementary KG 05 2017   pk_12_total 289.0   16.0 3.0   1.0         9.0   168.0 150.0                       318.0 289   16 3   1         9   168 150                 318
3010354 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2017   grade_6 171.0 6.0 4.0 0.0   6.0         9.0   112.0 84.0                       196.0 171 6 4 0   6         9   112 84                 196
3010392 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary PK 05 2017   k_12_total 141.0 4.0 5.0     3.0       1.0 9.0   85.0 78.0       4.9               163.0 141 4 5     3       1 9   85 78                 163
3010410 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary PK 05 2017   pk_12_total 148.0 4.0 5.0     4.0       1.0 9.0   88.0 83.0                       171.0 148 4 5     4       1 9   88 83                 171
3010602 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2017   k_12_total 147.0 2.0 46.0 13.0             9.0   99.0 118.0       6.0               217.0 147 2 46 13             9   99 118                 217
3010709 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2017   grade_3 48.0 0.0 3.0 5.0   2.0       0.0 9.0   42.0 25.0                       67.0 48 0 3 5   2       0 9   42 25                 67
3010854 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2017   grade_1 97.0 3.0 67.0 2.0   51.0       0.0 9.0   128.0 101.0                       229.0 97 3 67 2   51       0 9   128 101                 229
3013257 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2017   grade_1 40.0 0.0 2.0 16.0   0.0         9.0   32.0 35.0                       67.0 40 0 2 16   0         9   32 35                 67
3013263 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2017   grade_10 115.0 1.0 11.0 11.0   4.0       0.0 9.0   74.0 77.0                       151.0 115 1 11 11   4       0 9   74 77                 151
3013322 SD     school 4655260 32002   Pierre 32-2 465526001353 8 Kennedy Elementary School   Regular School No Elementary KG 05 2017   kindergarten 47.0 1.0 3.0 23.0   1.0         9.0   48.0 36.0                       84.0 47 1 3 23   1         9   48 36                 84
3013510 SD     school 4659820 51004   Rapid City Area 51-4 465982000541 14 Robbinsdale Elem   Regular School No Elementary PK 05 2017   grade_1 39.0 0.0 10.0 23.0   0.0       0.0 9.0   44.0 37.0                       81.0 39 0 10 23   0       0 9   44 37                 81
3013599 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2017   grade_2 16.0 0.0 8.0 50.0   0.0         9.0   42.0 41.0                       83.0 16 0 8 50   0         9   42 41                 83
3013609 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2017   grade_2 69.0 1.0 2.0 8.0           1.0 9.0   42.0 48.0                       90.0 69 1 2 8           1 9   42 48                 90
3013613 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2017   grade_2 35.0 0.0 9.0 18.0   0.0         9.0   41.0 30.0                       71.0 35 0 9 18   0         9   41 30                 71
3013619 SD     school 4659820 51004   Rapid City Area 51-4 465982000538 3 Black Hawk Elem   Regular School No Elementary KG 05 2017   grade_3 52.0   2.0 6.0             9.0   42.0 27.0                       69.0 52   2 6             9   42 27                 69
3013634 SD     school 4659820 51004   Rapid City Area 51-4 465982000823 12 Rapid Valley Elem   Regular School No Elementary PK 05 2017   grade_3 68.0 0.0 6.0 8.0           0.0 9.0   41.0 50.0                       91.0 68 0 6 8           0 9   41 50                 91

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