Data source: Big Local News · About: Big Local

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

View and edit SQL

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
258360 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   k_12_total 288.0 71.0 96.0 22.0   18.0       3.0 38.0   280.0 256.0       19.0               536.0 288 71 96 22   18       3 38   280 256                 536
258446 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School No Elementary KG 05 2018   pk_12_total 288.0 71.0 96.0 22.0   18.0       3.0 38.0   280.0 256.0                       536.0 288 71 96 22   18       3 38   280 256                 536
254487 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   k_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0       29.2               383.0 190 8 95 5   73         12   213 170                 383
254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
252348 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   k_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0       0.7               1000.0 696 33 93 55   7       1 115   521 479                 1000
252358 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2018   pk_12_total 696.0 33.0 93.0 55.0   7.0       1.0 115.0   521.0 479.0                       1000.0 696 33 93 55   7       1 115   521 479                 1000
258330 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   k_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0       2.5               1047.0 749 80 93 51   25       5 44   540 507                 1047
258416 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   pk_12_total 749.0 80.0 93.0 51.0   25.0       5.0 44.0   540.0 507.0                       1047.0 749 80 93 51   25       5 44   540 507                 1047
258341 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   k_12_total 110.0 56.0 92.0 14.0   12.0         30.0   157.0 157.0       28.3               314.0 110 56 92 14   12         30   157 157                 314
249836 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_12 293.0 8.0 9.0 25.0   13.0       2.0 4.0   186.0 168.0                       354.0 293 8 9 25   13       2 4   186 168                 354
249904 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2018   grade_7 137.0 3.0 9.0 6.0   8.0       1.0 3.0   77.0 90.0                       167.0 137 3 9 6   8       1 3   77 90                 167
249925 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   k_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0       2.5               403.0 343 11 9 12   7       1 20   212 191                 403
249945 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2018   pk_12_total 343.0 11.0 9.0 12.0   7.0       1.0 20.0   212.0 191.0                       403.0 343 11 9 12   7       1 20   212 191                 403
250369 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2018   k_12_total 202.0   9.0 2.0   2.0         5.0   113.0 107.0       0.5               220.0 202   9 2   2         5   113 107                 220
250855 SD     school 4607950 49002   Brandon Valley 49-2 460795001355 7 Brandon Valley Intermediate   Regular School No Middle 05 06 2018   grade_6 302.0 7.0 9.0 2.0   3.0       0.0 6.0   177.0 152.0                       329.0 302 7 9 2   3       0 6   177 152                 329
251055 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2018   grade_1 84.0 4.0 9.0 1.0   2.0         9.0   59.0 50.0                       109.0 84 4 9 1   2         9   59 50                 109
251885 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   grade_1 79.0 1.0 9.0 0.0   2.0         7.0   51.0 47.0                       98.0 79 1 9 0   2         7   51 47                 98
251890 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   grade_10 87.0 0.0 9.0 2.0   2.0       0.0 3.0   56.0 47.0                       103.0 87 0 9 2   2       0 3   56 47                 103
252693 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School No Elementary PK 06 2018   grade_6 15.0   9.0               0.0   14.0 10.0                       24.0 15   9               0   14 10                 24
252770 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2018   k_12_total 66.0   9.0     1.0         1.0   32.0 45.0       6.5               77.0 66   9     1         1   32 45                 77
252776 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2018   pk_12_total 66.0   9.0     1.0         1.0   32.0 45.0                       77.0 66   9     1         1   32 45                 77
255226 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2018   k_12_total 254.0 1.0 9.0 4.0   1.0         8.0   152.0 125.0       0.0               277.0 254 1 9 4   1         8   152 125                 277
255236 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2018   pk_12_total 254.0 1.0 9.0 4.0   1.0         8.0   152.0 125.0                       277.0 254 1 9 4   1         8   152 125                 277
255550 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School No Elementary PK 04 2018   k_12_total 123.0 1.0 9.0               6.0   82.0 57.0       3.6               139.0 123 1 9               6   82 57                 139
256039 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   grade_10 145.0 1.0 9.0 13.0   4.0         10.0   95.0 87.0                       182.0 145 1 9 13   4         10   95 87                 182
256583 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   pk_12_total 4.0   9.0 669.0             2.0   366.0 318.0                       684.0 4   9 669             2   366 318                 684
257160 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No Elementary KG 05 2018   grade_2 21.0 3.0 9.0 22.0   0.0         5.0   29.0 31.0                       60.0 21 3 9 22   0         5   29 31                 60
257187 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2018   grade_3 19.0 0.0 9.0 39.0   1.0       0.0 10.0   35.0 43.0                       78.0 19 0 9 39   1       0 10   35 43                 78
257195 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   grade_3 30.0 1.0 9.0 4.0   0.0       0.0 3.0   19.0 28.0                       47.0 30 1 9 4   0       0 3   19 28                 47
257235 SD     school 4659820 51004   Rapid City Area 51-4 465982000550 7 Horace Mann Elem   Regular School No Elementary KG 05 2018   grade_5 19.0 2.0 9.0 16.0   1.0         3.0   31.0 19.0                       50.0 19 2 9 16   1         3   31 19                 50
257356 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School No Elementary KG 05 2018   k_12_total 431.0 3.0 9.0 7.0   13.0         7.0   238.0 232.0       0.4               470.0 431 3 9 7   13         7   238 232                 470
257402 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   kindergarten 35.0 2.0 9.0 12.0   1.0       1.0 9.0   32.0 37.0                       69.0 35 2 9 12   1       1 9   32 37                 69
257406 SD     school 4659820 51004   Rapid City Area 51-4 465982000542 21 Corral Drive Elem   Regular School No Elementary KG 05 2018   pk_12_total 431.0 3.0 9.0 7.0   13.0         7.0   238.0 232.0                       470.0 431 3 9 7   13         7   238 232                 470
257433 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   pre_kindergarten 25.0 2.0 9.0 15.0   3.0       0.0 5.0   35.0 24.0                       59.0 25 2 9 15   3       0 5   35 24                 59
257510 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 328.0 8.0 9.0 8.0   1.0             183.0 171.0                       354.0 328 8 9 8   1             183 171                 354
257825 SD     school 4666270 49005   Sioux Falls 49-5 466627000597 10 Laura B. Anderson Elementary   Regular School No Elementary PK 05 2018   grade_1 23.0 8.0 9.0 1.0   2.0         4.0   31.0 16.0                       47.0 23 8 9 1   2         4   31 16                 47
258071 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   grade_4 118.0 8.0 9.0 1.0   4.0       0.0 4.0   78.0 66.0                       144.0 118 8 9 1   4       0 4   78 66                 144
258079 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School No Elementary PK 05 2018   grade_4 19.0 12.0 9.0 11.0   3.0         5.0   33.0 26.0                       59.0 19 12 9 11   3         5   33 26                 59
258112 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   grade_5 23.0 19.0 9.0 1.0   8.0       2.0 3.0   33.0 32.0                       65.0 23 19 9 1   8       2 3   33 32                 65
258114 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   grade_5 110.0 10.0 9.0 2.0   4.0       0.0 6.0   69.0 72.0                       141.0 110 10 9 2   4       0 6   69 72                 141
258133 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School No Elementary KG 05 2018   grade_5 85.0 11.0 9.0 6.0   0.0       1.0 6.0   57.0 61.0                       118.0 85 11 9 6   0       1 6   57 61                 118
258374 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School No Elementary KG 05 2018   kindergarten   15.0 9.0     2.0             11.0 15.0                       26.0   15 9     2             11 15                 26
258530 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2018   k_12_total 185.0   9.0 2.0   3.0         3.0   91.0 111.0       2.0               202.0 185   9 2   3         3   91 111                 202
258536 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2018   pk_12_total 185.0   9.0 2.0   3.0         3.0   91.0 111.0                       202.0 185   9 2   3         3   91 111                 202
258763 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No Middle 06 08 2018   grade_7 173.0 0.0 9.0 6.0   1.0       0.0 10.0   106.0 93.0                       199.0 173 0 9 6   1       0 10   106 93                 199
258958 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   k_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0       0.2               431.0 387 9 9 7             19   226 205                 431
258966 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2018   pk_12_total 387.0 9.0 9.0 7.0             19.0   226.0 205.0                       431.0 387 9 9 7             19   226 205                 431
259251 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   k_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0       1.4               145.0 125 9 9 1             1   71 74                 145
259257 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   pk_12_total 125.0 9.0 9.0 1.0             1.0   71.0 74.0                       145.0 125 9 9 1             1   71 74                 145
259519 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   k_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0       0.0               259.0 64   9 159   1         26   128 131                 259
259527 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   pk_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0                       259.0 64   9 159   1         26   128 131                 259
259674 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   grade_12 272.0 0.0 9.0 7.0   5.0       0.0 5.0   156.0 142.0                       298.0 272 0 9 7   5       0 5   156 142                 298
259978 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   k_12_total 147.0   9.0                   83.0 73.0       4.5               156.0 147   9                   83 73                 156
259988 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   pk_12_total 171.0   9.0                   101.0 79.0                       180.0 171   9                   101 79                 180
260510 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_8 179.0 4.0 9.0 13.0   3.0         3.0   113.0 98.0                       211.0 179 4 9 13   3         3   113 98                 211
258323 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   k_12_total 152.0 163.0 87.0 14.0   92.0         37.0   279.0 266.0       41.8               545.0 152 163 87 14   92         37   279 266                 545
258354 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   k_12_total 291.0 101.0 87.0 17.0   31.0         42.0   289.0 280.0       24.3               569.0 291 101 87 17   31         42   289 280                 569
258440 SD     school 4666270 49005   Sioux Falls 49-5 466627001275 15 Rosa Parks Elementary   Regular School No Elementary KG 05 2018   pk_12_total 291.0 101.0 87.0 17.0   31.0         42.0   289.0 280.0                       569.0 291 101 87 17   31         42   289 280                 569
254488 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   kindergarten 82.0 1.0 85.0 2.0   60.0       0.0 8.0   131.0 107.0                       238.0 82 1 85 2   60       0 8   131 107                 238
258420 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No Elementary PK 05 2018   pk_12_total 249.0 136.0 82.0 43.0   19.0       1.0 50.0   306.0 274.0                       580.0 249 136 82 43   19       1 50   306 274                 580
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
250147 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   pk_12_total 46.0   8.0 110.0             26.0   93.0 97.0                       190.0 46   8 110             26   93 97                 190
250423 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2018   grade_6 99.0   8.0 2.0             6.0   62.0 53.0                       115.0 99   8 2             6   62 53                 115
250545 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   k_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0       0.0               283.0 269 2 8 1   1         2   138 145                 283
250546 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   k_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0       0.0               218.0 199 2 8     4         5   106 112                 218
250551 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   pk_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0                       283.0 269 2 8 1   1         2   138 145                 283
250552 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   pk_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0                       218.0 199 2 8     4         5   106 112                 218
250863 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_7 297.0 13.0 8.0 1.0   1.0       1.0 7.0   159.0 169.0                       328.0 297 13 8 1   1       1 7   159 169                 328
250895 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   pk_12_total 523.0 11.0 8.0 6.0   2.0       3.0 21.0   317.0 257.0                       574.0 523 11 8 6   2       3 21   317 257                 574
251029 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   k_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0       0.0               214.0 191 4 8 2   1         8   103 111                 214
251041 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0                       214.0 191 4 8 2   1         8   103 111                 214
251082 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2018   grade_2 61.0 3.0 8.0 4.0   1.0         3.0   43.0 37.0                       80.0 61 3 8 4   1         3   43 37                 80
251872 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   k_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0       0.0               204.0 166   8 13           1 16   98 106                 204
251880 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   pk_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0                       204.0 166   8 13           1 16   98 106                 204
251916 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   grade_5 92.0 0.0 8.0 1.0   1.0         7.0   50.0 59.0                       109.0 92 0 8 1   1         7   50 59                 109
251930 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No High 09 12 2018   grade_9 71.0 5.0 8.0 2.0   3.0       0.0 2.0   52.0 39.0                       91.0 71 5 8 2   3       0 2   52 39                 91
251937 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   kindergarten 94.0 1.0 8.0 0.0   5.0         4.0   67.0 45.0                       112.0 94 1 8 0   5         4   67 45                 112
252115 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School No Elementary PK 06 2018   pk_12_total 163.0 1.0 8.0 2.0                 86.0 88.0                       174.0 163 1 8 2                 86 88                 174
252673 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School No Elementary PK 06 2018   grade_2 15.0   8.0               2.0   8.0 17.0                       25.0 15   8               2   8 17                 25
253069 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   grade_2 19.0 0.0 8.0 15.0   2.0       1.0 5.0   26.0 24.0                       50.0 19 0 8 15   2       1 5   26 24                 50
253103 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   k_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0       0.0               144.0 77 2 8 49   2       3 3   76 68                 144
253111 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0                       144.0 77 2 8 49   2       3 3   76 68                 144
253335 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No Elementary PK 05 2018   pk_12_total 206.0   8.0 7.0   1.0         9.0   109.0 122.0                       231.0 206   8 7   1         9   109 122                 231
253377 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 06 2018   k_12_total 134.0   8.0     0.0         3.0   78.0 67.0       0.0               145.0 134   8     0         3   78 67                 145
253633 SD     school 4630800 28003   Hamlin 28-3 463080001111 9 Hamlin Elementary   Regular School No Elementary PK 05 2018   k_12_total 373.0 3.0 8.0 2.0   1.0         3.0   219.0 171.0       1.5               390.0 373 3 8 2   1         3   219 171                 390
253915 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   grade_8 167.0 1.0 8.0 1.0   4.0         5.0   89.0 97.0                       186.0 167 1 8 1   4         5   89 97                 186
253935 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   k_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0       7.3               205.0 177 8 8     5         7   102 103                 205
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
254121 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   grade_2 25.0   8.0 1.0             1.0   19.0 16.0                       35.0 25   8 1             1   19 16                 35
255235 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2018   pk_12_total 390.0 2.0 8.0 4.0   1.0         14.0   212.0 207.0                       419.0 390 2 8 4   1         14   212 207                 419
255417 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School No Elementary KG 05 2018   grade_2 73.0 1.0 8.0 1.0   0.0         1.0   39.0 45.0                       84.0 73 1 8 1   0         1   39 45                 84
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
255921 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   grade_10 75.0 0.0 8.0 1.0           0.0 2.0   51.0 35.0                       86.0 75 0 8 1           0 2   51 35                 86
255935 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_4 61.0 2.0 8.0 0.0             3.0   44.0 30.0                       74.0 61 2 8 0             3   44 30                 74
255946 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   grade_7 72.0   8.0 2.0             0.0   43.0 39.0                       82.0 72   8 2             0   43 39                 82
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
256306 SD     school 4649650 17003   Mount Vernon 17-3 464965000455 1 Mount Vernon High School   Regular School No High 09 12 2018   k_12_total 55.0   8.0 4.0                 39.0 28.0       1.5               67.0 55   8 4                 39 28                 67
256312 SD     school 4649650 17003   Mount Vernon 17-3 464965000455 1 Mount Vernon High School   Regular School No High 09 12 2018   pk_12_total 55.0   8.0 4.0                 39.0 28.0                       67.0 55   8 4                 39 28                 67
256573 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   k_12_total 4.0   8.0 639.0             2.0   349.0 304.0       0.2               653.0 4   8 639             2   349 304                 653
256705 SD     school 4654270 60004   Parker 60-4 465427000487 2 Parker Elementary School   Regular School No Elementary PK 06 2018   k_12_total 216.0 1.0 8.0 2.0             14.0   120.0 121.0       3.3               241.0 216 1 8 2             14   120 121                 241

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