enrollments

Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 10,736 ✖
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
258577 258577 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2018   k_12_total 96.0 3.0 10.0 99.0   1.0         10.0   126.0 93.0       0.9               219.0 96 3 10 99   1         10   126 93                 219
258583 258583 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2018   pk_12_total 96.0 3.0 10.0 99.0   1.0         10.0   126.0 93.0                       219.0 96 3 10 99   1         10   126 93                 219
259518 259518 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   k_12_total 62.0   7.0 99.0             14.0   83.0 99.0       0.0               182.0 62   7 99             14   83 99                 182
259526 259526 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   pk_12_total 62.0   7.0 99.0             14.0   83.0 99.0                       182.0 62   7 99             14   83 99                 182
249926 249926 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   k_12_total 1087.0 39.0 58.0 98.0   44.0       5.0 13.0   674.0 670.0       3.4               1344.0 1087 39 58 98   44       5 13   674 670                 1344
249946 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
251442 251442 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   k_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0       0.4               255.0 134 3 13 98   3         4   129 126                 255
251448 251448 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   pk_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0                       255.0 134 3 13 98   3         4   129 126                 255
259114 259114 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_5 1.0   0.0 98.0             0.0   34.0 65.0                       99.0 1   0 98             0   34 65                 99
259009 259009 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2018   k_12_total 75.0 1.0 3.0 96.0                 94.0 81.0       0.0               175.0 75 1 3 96                 94 81                 175
256533 256533 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   grade_2 1.0   1.0 94.0             0.0   55.0 41.0                       96.0 1   1 94             0   55 41                 96
259030 259030 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_1 1.0   1.0 94.0             1.0   53.0 44.0                       97.0 1   1 94             1   53 44                 97
250137 250137 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   k_12_total 34.0   8.0 93.0             21.0   72.0 84.0       0.0               156.0 34   8 93             21   72 84                 156
257315 257315 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No Middle 06 08 2018   grade_8 46.0 8.0 13.0 93.0   1.0       0.0 14.0   93.0 82.0                       175.0 46 8 13 93   1       0 14   93 82                 175
255651 255651 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   k_12_total 3.0   2.0 92.0                 51.0 46.0       2.1               97.0 3   2 92                 51 46                 97
255657 255657 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   pk_12_total 3.0   2.0 92.0                 51.0 46.0                       97.0 3   2 92                 51 46                 97
258343 258343 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   k_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0       5.5               2006.0 1419 224 145 91   54       1 72   1049 957                 2006
258429 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
256877 256877 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   k_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0       0.8               727.0 560 2 35 90   6       1 33   365 362                 727
256887 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
249887 249887 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2018   grade_6 136.0 5.0 10.0 9.0   5.0         13.0   90.0 88.0                       178.0 136 5 10 9   5         13   90 88                 178
249914 249914 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   grade_8 137.0 4.0 11.0 9.0   2.0       2.0 2.0   83.0 84.0                       167.0 137 4 11 9   2       2 2   83 84                 167
250077 250077 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   grade_1 7.0   2.0 9.0             1.0   10.0 9.0                       19.0 7   2 9             1   10 9                 19
251116 251116 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   grade_8 206.0 1.0 10.0 9.0   8.0       0.0 13.0   132.0 115.0                       247.0 206 1 10 9   8       0 13   132 115                 247
251186 251186 SD     school 4609512 26002   Burke 26-2 460951200101 1 Burke High School   Regular School No High 09 12 2018   k_12_total 59.0   1.0 9.0                 29.0 40.0       0.0               69.0 59   1 9                 29 40                 69
251192 251192 SD     school 4609512 26002   Burke 26-2 460951200101 1 Burke High School   Regular School No High 09 12 2018   pk_12_total 59.0   1.0 9.0                 29.0 40.0                       69.0 59   1 9                 29 40                 69
252033 252033 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2018   k_12_total 341.0 1.0 11.0 9.0             10.0   198.0 174.0       1.1               372.0 341 1 11 9             10   198 174                 372
252039 252039 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2018   pk_12_total 341.0 1.0 11.0 9.0             10.0   198.0 174.0                       372.0 341 1 11 9             10   198 174                 372
253930 253930 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   k_12_total 357.0 19.0 17.0 9.0   8.0         20.0   221.0 209.0       6.3               430.0 357 19 17 9   8         20   221 209                 430
253932 253932 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   k_12_total 900.0 16.0 21.0 9.0   11.0         29.0   524.0 462.0       0.6               986.0 900 16 21 9   11         29   524 462                 986
253948 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
253950 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
254832 254832 SD     school 4680437 35002   Kadoka Area 35-2 468043701247 1 Kadoka Area HS   Regular School No High 09 12 2018   grade_9 12.0     9.0                 10.0 11.0                       21.0 12     9                 10 11                 21
255346 255346 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2018   grade_10 17.0   0.0 9.0             0.0   13.0 13.0                       26.0 17   0 9             0   13 13                 26
255689 255689 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School No High 09 12 2018   grade_11 125.0 2.0 8.0 9.0             1.0   71.0 74.0                       145.0 125 2 8 9             1   71 74                 145
256053 256053 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   grade_12 169.0 1.0 8.0 9.0   1.0         7.0   89.0 106.0                       195.0 169 1 8 9   1         7   89 106                 195
256071 256071 SD     school 4648390 17002   Mitchell 17-2 464839000591 4 Gertie Belle Rogers Elem   Regular School No Elementary KG 05 2018   grade_4 57.0 0.0 2.0 9.0   1.0         3.0   36.0 36.0                       72.0 57 0 2 9   1         3   36 36                 72
256121 256121 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   kindergarten 74.0 2.0 5.0 9.0   0.0         3.0   44.0 49.0                       93.0 74 2 5 9   0         3   44 49                 93
256403 256403 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2018   k_12_total 63.0 3.0 1.0 9.0   3.0         2.0   49.0 32.0       0.0               81.0 63 3 1 9   3         2   49 32                 81
256409 256409 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 63.0 3.0 1.0 9.0   3.0         2.0   49.0 32.0                       81.0 63 3 1 9   3         2   49 32                 81
256468 256468 SD     school 4652770 23003   Oelrichs 23-3 465277000482 1 Oelrichs High School   Regular School No High 09 12 2018   grade_11 0.0     9.0                 7.0 2.0                       9.0 0     9                 7 2                 9
257064 257064 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2018   grade_1 57.0 0.0 5.0 9.0   0.0         8.0   43.0 36.0                       79.0 57 0 5 9   0         8   43 36                 79
257239 257239 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School No Elementary KG 05 2018   grade_5 90.0 2.0 10.0 9.0   1.0         1.0   49.0 64.0                       113.0 90 2 10 9   1         1   49 64                 113
257326 257326 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No Middle 06 08 2018   grade_8 185.0 0.0 13.0 9.0   2.0         12.0   124.0 97.0                       221.0 185 0 13 9   2         12   124 97                 221
257366 257366 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No Elementary KG 05 2018   k_12_total 357.0   21.0 9.0   7.0         22.0   206.0 210.0       0.5               416.0 357   21 9   7         22   206 210                 416
257416 257416 SD     school 4659820 51004   Rapid City Area 51-4 465982000547 11 Pinedale Elem   Regular School No Elementary KG 05 2018   pk_12_total 357.0   21.0 9.0   7.0         22.0   206.0 210.0                       416.0 357   21 9   7         22   206 210                 416
257845 257845 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School No Elementary PK 05 2018   grade_1 22.0 18.0 20.0 9.0   2.0         4.0   37.0 38.0                       75.0 22 18 20 9   2         4   37 38                 75
258000 258000 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   grade_2 23.0 15.0 15.0 9.0   2.0         9.0   36.0 37.0                       73.0 23 15 15 9   2         9   36 37                 73
258033 258033 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   grade_3 40.0 24.0 10.0 9.0   6.0       0.0 7.0   52.0 44.0                       96.0 40 24 10 9   6       0 7   52 44                 96
258086 258086 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   grade_4 28.0 14.0 10.0 9.0   0.0         12.0   41.0 32.0                       73.0 28 14 10 9   0         12   41 32                 73
258123 258123 SD     school 4666270 49005   Sioux Falls 49-5 466627000590 38 Hayward Elementary   Regular School No Elementary PK 05 2018   grade_5 43.0 9.0 34.0 9.0   4.0         8.0   61.0 46.0                       107.0 43 9 34 9   4         8   61 46                 107
258177 258177 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   grade_6 283.0 34.0 22.0 9.0   15.0         10.0   184.0 189.0                       373.0 283 34 22 9   15         10   184 189                 373
258387 258387 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School No Elementary PK 05 2018   kindergarten 20.0 14.0 13.0 9.0   0.0         11.0   35.0 32.0                       67.0 20 14 13 9   0         11   35 32                 67
258674 258674 SD     school 4607670 26005   South Central 26-5 460767000880 1 South Central High School   Regular School No High 09 12 2018   k_12_total 13.0 1.0   9.0             1.0   16.0 8.0       0.0               24.0 13 1   9             1   16 8                 24
258680 258680 SD     school 4607670 26005   South Central 26-5 460767000880 1 South Central High School   Regular School No High 09 12 2018   pk_12_total 13.0 1.0   9.0             1.0   16.0 8.0                       24.0 13 1   9             1   16 8                 24
258698 258698 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   grade_10 153.0 1.0 7.0 9.0   1.0         5.0   96.0 80.0                       176.0 153 1 7 9   1         5   96 80                 176
258788 258788 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   k_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0       0.8               365.0 315 5 18 9   5         13   195 170                 365
258804 258804 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2018   pk_12_total 315.0 5.0 18.0 9.0   5.0         13.0   195.0 170.0                       365.0 315 5 18 9   5         13   195 170                 365
259027 259027 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2018   grade_1 1.0     9.0                 7.0 3.0                       10.0 1     9                 7 3                 10
259147 259147 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2018   grade_8 0.0     9.0                 3.0 6.0                       9.0 0     9                 3 6                 9
259362 259362 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   grade_3 63.0 1.0 2.0 9.0   3.0       0.0 3.0   43.0 38.0                       81.0 63 1 2 9   3       0 3   43 38                 81
259387 259387 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   grade_9 70.0 2.0 2.0 9.0   0.0       1.0 0.0   37.0 47.0                       84.0 70 2 2 9   0       1 0   37 47                 84
260048 260048 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   k_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0       0.3               321.0 296 4 4 9   1         7   172 149                 321
260056 260056 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   pk_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0                       321.0 296 4 4 9   1         7   172 149                 321
260137 260137 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No Elementary PK 05 2018   grade_5       9.0                 8.0 1.0                       9.0       9                 8 1                 9
260455 260455 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_10 190.0 3.0 12.0 9.0   1.0         4.0   112.0 107.0                       219.0 190 3 12 9   1         4   112 107                 219
260519 260519 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   k_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0       1.5               273.0 228 5 19 9   6         6   137 136                 273
260531 260531 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   pk_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0                       273.0 228 5 19 9   6         6   137 136                 273
259102 259102 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_4 0.0   3.0 88.0             0.0   41.0 50.0                       91.0 0   3 88             0   41 50                 91
260160 260160 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   k_12_total 5.0 2.0 2.0 87.0             5.0   52.0 49.0       2.0               101.0 5 2 2 87             5   52 49                 101
260168 260168 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 5.0 2.0 2.0 87.0             5.0   52.0 49.0                       101.0 5 2 2 87             5   52 49                 101
256543 256543 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   grade_4 1.0   2.0 86.0             1.0   44.0 46.0                       90.0 1   2 86             1   44 46                 90
256581 256581 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2018   pk_12_total     2.0 86.0                 44.0 44.0                       88.0     2 86                 44 44                 88
259090 259090 SD     school 4672090 66001   Todd County 66-1 467209001349 16 Todd County Elem   Regular School No Elementary KG 05 2018   grade_3 0.0   3.0 86.0             2.0   44.0 47.0                       91.0 0   3 86             2   44 47                 91
258625 258625 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No Elementary KG 05 2018   k_12_total 2.0     85.0             4.0   48.0 43.0       0.0               91.0 2     85             4   48 43                 91
258631 258631 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No Elementary KG 05 2018   pk_12_total 2.0     85.0             4.0   48.0 43.0                       91.0 2     85             4   48 43                 91
257374 257374 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   k_12_total 1382.0 7.0 75.0 84.0   23.0       2.0 53.0   793.0 833.0       0.8               1626.0 1382 7 75 84   23       2 53   793 833                 1626
257404 257404 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School No Elementary PK 05 2018   pk_12_total 248.0 7.0 39.0 84.0   5.0         31.0   217.0 197.0                       414.0 248 7 39 84   5         31   217 197                 414
257424 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
258353 258353 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   k_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0       5.9               2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258439 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
256571 256571 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2018   k_12_total     2.0 82.0                 43.0 41.0       4.8               84.0     2 82                 43 41                 84
256875 256875 SD     school 4655260 32002   Pierre 32-2 465526000495 6 Jefferson Elementary   Regular School No Elementary KG 05 2018   k_12_total 287.0 3.0 28.0 82.0             40.0   244.0 196.0       0.0               440.0 287 3 28 82             40   244 196                 440
256885 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
257354 257354 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School No Elementary PK 05 2018   k_12_total 238.0 7.0 38.0 82.0   5.0         30.0   210.0 190.0       0.8               400.0 238 7 38 82   5         30   210 190                 400
260159 260159 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   k_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0       0.0               103.0 14 1 2 80   1       1 4   54 49                 103
260167 260167 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   pk_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0                       103.0 14 1 2 80   1       1 4   54 49                 103
249873 249873 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   grade_4 54.0 1.0 4.0 8.0   0.0       0.0 6.0   37.0 36.0                       73.0 54 1 4 8   0       0 6   37 36                 73
250443 250443 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2018   k_12_total 382.0   28.0 8.0             23.0   236.0 205.0       0.2               441.0 382   28 8             23   236 205                 441
250453 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
250470 250470 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2018   grade_12 12.0   1.0 8.0             8.0   16.0 13.0                       29.0 12   1 8             8   16 13                 29
250883 250883 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   k_12_total 594.0 22.0 19.0 8.0   10.0       1.0 10.0   351.0 313.0       0.9               664.0 594 22 19 8   10       1 10   351 313                 664
250897 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
251127 251127 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2018   k_12_total 391.0 13.0 22.0 8.0   5.0         24.0   234.0 229.0       1.7               463.0 391 13 22 8   5         24   234 229                 463
251139 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
251760 251760 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   k_12_total 5.0     8.0                 6.0 7.0       0.0               13.0 5     8                 6 7                 13
251768 251768 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   pk_12_total 5.0     8.0                 6.0 7.0                       13.0 5     8                 6 7                 13
254803 254803 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School No Elementary PK 05 2018   grade_4 6.0     8.0                 6.0 8.0                       14.0 6     8                 6 8                 14
254809 254809 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School No Elementary PK 05 2018   grade_5 10.0     8.0                 8.0 10.0                       18.0 10     8                 8 10                 18
255102 255102 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000372 3 Lead-Deadwood Elementary   Regular School No Elementary KG 05 2018   k_12_total 274.0 4.0 14.0 8.0   5.0       1.0 11.0   162.0 155.0       0.3               317.0 274 4 14 8   5       1 11   162 155                 317

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