Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • k_12_total · 4,696
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
254481 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   k_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0       45.8               478.0 177 2 162 7   111       1 18   254 224                 478
259389 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   k_12_total 155.0 5.0 5.0 21.0   5.0         11.0   109.0 93.0       1.5               202.0 155 5 5 21   5         11   109 93                 202
361708 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2019   k_12_total 160.0 4.0 149.0 11.0   115.0       1.0 16.0   238.0 218.0       45.2               456.0 160 4 149 11   115       1 16   238 218                 456
366616 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2019   k_12_total 180.0 6.0 6.0 26.0   6.0         8.0   120.0 112.0       1.7               232.0 180 6 6 26   6         8   120 112                 232
453554 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   k_12_total 163.0 4.0 146.0 8.0   105.0       4.0 16.0   211.0 235.0       46.6               446.0 163 4 146 8   105       4 16   211 235                 446
458494 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2021   k_12_total 162.0 5.0 11.0 15.0   7.0       1.0 21.0   107.0 115.0       0.0               222.0 162 5 11 15   7       1 21   107 115                 222
491977 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   k_12_total 170.0 5.0 153.0 9.0   106.0       5.0 16.0   228.0 236.0       46.1               464.0 170 5 153 9   106       5 16   228 236                 464
496917 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   k_12_total 164.0 6.0 10.0 27.0   6.0       2.0 9.0   99.0 125.0       0.5               224.0 164 6 10 27   6       2 9   99 125                 224
2964062 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2015   k_12_total 347.0 17.0 47.0 30.0   4.0         40.0   251.0 234.0                       485.0 347 17 47 30   4         40   251 234                 485
2971174 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2015   k_12_total 171.0 2.0 7.0 15.0   6.0       1.0 19.0   118.0 103.0                       221.0 171 2 7 15   6       1 19   118 103                 221
3008766 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No Elementary KG 01 2017   k_12_total 317.0 16.0 42.0 27.0   5.0       1.0 56.0   251.0 213.0       0.2               464.0 317 16 42 27   5       1 56   251 213                 464
3010938 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2017   k_12_total 189.0 5.0 144.0 8.0   110.0       1.0 15.0   254.0 218.0       44.9               472.0 189 5 144 8   110       1 15   254 218                 472
3015782 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2017   k_12_total 125.0 2.0 9.0 17.0   4.0         13.0   90.0 80.0       1.8               170.0 125 2 9 17   4         13   90 80                 170
3346678 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2016   k_12_total 358.0 16.0 51.0 30.0   2.0       2.0 51.0   265.0 245.0       0.2               510.0 358 16 51 30   2       2 51   265 245                 510
3353694 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2016   k_12_total 135.0 1.0 5.0 16.0   7.0       1.0 11.0   95.0 81.0       1.8               176.0 135 1 5 16   7       1 11   95 81                 176
252463 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2018   k_12_total 2.0     105.0   1.0       1.0     57.0 52.0       0.0               109.0 2     105   1       1     57 52                 109
256189 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2018   k_12_total 67.0 2.0 4.0 59.0   2.0             66.0 68.0       0.0               134.0 67 2 4 59   2             66 68                 134
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
260045 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   k_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0       0.4               247.0 229 2 7 2             7   127 120                 247
359709 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2019   k_12_total 2.0     81.0   1.0             44.0 40.0       0.0               84.0 2     81   1             44 40                 84
363432 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2019   k_12_total 71.0 1.0 1.0 54.0   1.0             57.0 71.0       0.0               128.0 71 1 1 54   1             57 71                 128
366015 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2019   k_12_total 298.0 3.0 16.0 6.0   5.0         14.0   163.0 179.0       0.6               342.0 298 3 16 6   5         14   163 179                 342
367301 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2019   k_12_total 247.0 2.0 5.0 2.0             9.0   141.0 124.0       0.0               265.0 247 2 5 2             9   141 124                 265
451552 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School Not applicable Elementary KG 02 2021   k_12_total 3.0   1.0 55.0                 30.0 29.0       0.0               59.0 3   1 55                 30 29                 59
455294 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2021   k_12_total 93.0 1.0 2.0 47.0             1.0   68.0 76.0       0.0               144.0 93 1 2 47             1   68 76                 144
457877 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2021   k_12_total 268.0 1.0 13.0 5.0   3.0         12.0   154.0 148.0       0.3               302.0 268 1 13 5   3         12   154 148                 302
459211 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School Not applicable Elementary KG 02 2021   k_12_total 267.0   3.0 2.0             4.0   148.0 128.0       0.0               276.0 267   3 2             4   148 128                 276
489991 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School Not applicable Elementary KG 02 2020   k_12_total 4.0     90.0                 47.0 47.0       0.0               94.0 4     90                 47 47                 94
493717 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2020   k_12_total 77.0   1.0 57.0   1.0             62.0 74.0       0.0               136.0 77   1 57   1             62 74                 136
496300 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   k_12_total 275.0 1.0 17.0 5.0   2.0         6.0   144.0 162.0       0.7               306.0 275 1 17 5   2         6   144 162                 306
497602 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School Not applicable Elementary KG 02 2020   k_12_total 254.0 3.0 5.0 2.0             7.0   144.0 127.0       0.0               271.0 254 3 5 2             7   144 127                 271
2964197 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No 1 KG 02 2015   k_12_total 1.0   1.0 77.0                 36.0 43.0                       79.0 1   1 77                 36 43                 79
2967878 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   k_12_total 91.0   7.0 64.0   1.0       3.0     65.0 101.0                       166.0 91   7 64   1       3     65 101                 166
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
2970774 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 KG 02 2015   k_12_total 396.0 5.0 5.0 4.0   2.0       1.0 13.0   230.0 196.0                       426.0 396 5 5 4   2       1 13   230 196                 426
2971814 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No 1 KG 02 2015   k_12_total 225.0 3.0 7.0 5.0             5.0   133.0 112.0                       245.0 225 3 7 5             5   133 112                 245
3008888 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2017   k_12_total 1.0     82.0   1.0             45.0 39.0       0.0               84.0 1     82   1             45 39                 84
3012614 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2017   k_12_total 66.0 4.0 3.0 69.0                 67.0 75.0       0.0               142.0 66 4 3 69                 67 75                 142
3015200 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2017   k_12_total 310.0 4.0 13.0 10.0   5.0       1.0 10.0   206.0 147.0       0.9               353.0 310 4 13 10   5       1 10   206 147                 353
3016438 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2017   k_12_total 237.0   4.0 5.0             4.0   128.0 122.0       0.4               250.0 237   4 5             4   128 122                 250
3346800 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No 1 KG 02 2016   k_12_total 2.0   2.0 80.0                 41.0 43.0       0.0               84.0 2   2 80                 41 43                 84
3350478 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2016   k_12_total 87.0 2.0 6.0 61.0                 69.0 87.0       0.0               156.0 87 2 6 61                 69 87                 156
3353109 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2016   k_12_total 332.0 4.0 16.0 6.0   4.0       1.0 10.0   204.0 169.0       0.9               373.0 332 4 16 6   4       1 10   204 169                 373
3353290 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 PK 02 2016   k_12_total 395.0 3.0 8.0 5.0             11.0   227.0 195.0       0.9               422.0 395 3 8 5             11   227 195                 422
3354318 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No 1 KG 02 2016   k_12_total 238.0 2.0 6.0 6.0             4.0   139.0 117.0       0.4               256.0 238 2 6 6             4   139 117                 256
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
251129 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   k_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0       7.9               277.0 214 7 14 13   11         18   146 131                 277
251130 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2018   k_12_total 270.0 23.0 31.0 10.0   18.0         18.0   191.0 179.0       16.2               370.0 270 23 31 10   18         18   191 179                 370
251933 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   k_12_total 332.0 3.0 27.0 1.0   15.0         18.0   204.0 192.0       1.0               396.0 332 3 27 1   15         18   204 192                 396
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
254485 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   k_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0       41.7               432.0 190 4 126 7   92         13   245 187                 432
358386 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2019   k_12_total 396.0 17.0 18.0 5.0   7.0         27.0   247.0 223.0       1.9               470.0 396 17 18 5   7         27   247 223                 470
358388 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   k_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0       9.2               284.0 213 8 16 13   13       1 20   151 133                 284
358389 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2019   k_12_total 256.0 16.0 31.0 10.0   13.0         19.0   184.0 161.0       15.7               345.0 256 16 31 10   13         19   184 161                 345
359192 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2019   k_12_total 331.0 8.0 37.0 2.0   20.0         26.0   219.0 205.0       1.2               424.0 331 8 37 2   20         26   219 205                 424
359607 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   k_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0       0.6               978.0 662 23 98 63   6       1 125   504 474                 978
361712 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   k_12_total 183.0 9.0 146.0 10.0   100.0       2.0 14.0   254.0 210.0       44.4               464.0 183 9 146 10   100       2 14   254 210                 464
450232 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   k_12_total 375.0 13.0 12.0 2.0   4.0         26.0   225.0 207.0       2.6               432.0 375 13 12 2   4         26   225 207                 432
450234 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   k_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0       9.9               264.0 202 8 21 6   7         20   145 119                 264
450235 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   k_12_total 244.0 16.0 37.0 9.0   10.0       1.0 16.0   178.0 155.0       14.4               333.0 244 16 37 9   10       1 16   178 155                 333
451038 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   k_12_total 303.0 7.0 36.0 7.0   13.0       1.0 33.0   203.0 197.0       0.3               400.0 303 7 36 7   13       1 33   203 197                 400
451440 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   k_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0       0.8               870.0 576 16 102 54   11       1 110   447 423                 870
453558 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   k_12_total 163.0 2.0 137.0 14.0   119.0       2.0 14.0   247.0 204.0       43.5               451.0 163 2 137 14   119       2 14   247 204                 451
488655 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2020   k_12_total 397.0 12.0 15.0 2.0   8.0         30.0   247.0 217.0       2.4               464.0 397 12 15 2   8         30   247 217                 464
488657 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2020   k_12_total 225.0 12.0 18.0 15.0   10.0       2.0 22.0   169.0 135.0       9.5               304.0 225 12 18 15   10       2 22   169 135                 304
488658 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2020   k_12_total 252.0 16.0 36.0 10.0   15.0         20.0   192.0 157.0       16.6               349.0 252 16 36 10   15         20   192 157                 349
489461 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2020   k_12_total 322.0 10.0 38.0 2.0   19.0       1.0 27.0   223.0 196.0       1.0               419.0 322 10 38 2   19       1 27   223 196                 419
489876 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   k_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0       0.5               929.0 606 22 105 68   9       3 116   473 456                 929
491981 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   k_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0       44.8               478.0 166 8 156 11   119       2 16   253 225                 478
2962713 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142000073 3 Emery Elementary   Regular School No 1 KG 03 2015   k_12_total 49.0   3.0                   29.0 23.0                       52.0 49   3                   29 23                 52
2962869 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2015   k_12_total 403.0 28.0 23.0 13.0   17.0       1.0 21.0   248.0 258.0                       506.0 403 28 23 13   17       1 21   248 258                 506
2962870 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2015   k_12_total 422.0 23.0 19.0 18.0   23.0         15.0   241.0 279.0                       520.0 422 23 19 18   23         15   241 279                 520
2964066 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2015   k_12_total 332.0 13.0 37.0 22.0   7.0       1.0 47.0   238.0 221.0                       459.0 332 13 37 22   7       1 47   238 221                 459
3007536 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2017   k_12_total 406.0 11.0 15.0 9.0   6.0         26.0   249.0 224.0       1.7               473.0 406 11 15 9   6         26   249 224                 473
3007538 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2017   k_12_total 235.0 11.0 11.0 12.0   10.0       1.0 22.0   155.0 147.0       6.0               302.0 235 11 11 12   10       1 22   155 147                 302
3007539 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2017   k_12_total 289.0 23.0 23.0 10.0   19.0         11.0   194.0 181.0       8.3               375.0 289 23 23 10   19         11   194 181                 375
3008342 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2017   k_12_total 329.0 3.0 32.0 2.0   14.0         20.0   205.0 195.0       2.8               400.0 329 3 32 2   14         20   205 195                 400
3008770 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No Elementary 02 03 2017   k_12_total 354.0 11.0 49.0 33.0   3.0         42.0   249.0 243.0       0.6               492.0 354 11 49 33   3         42   249 243                 492
3010942 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2017   k_12_total 193.0 5.0 104.0 6.0   81.0         12.0   226.0 175.0       38.7               401.0 193 5 104 6   81         12   226 175                 401
3345297 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010073 3 Emery Elementary   Regular School No 1 PK 03 2016   k_12_total 42.0   4.0                   24.0 22.0                       46.0 42   4                   24 22                 46
3345480 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No 1 KG 03 2016   k_12_total 392.0 10.0 7.0 4.0   7.0         22.0   227.0 215.0                       442.0 392 10 7 4   7         22   227 215                 442
3345482 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   k_12_total 242.0 11.0 15.0 7.0   11.0       1.0 23.0   141.0 169.0                       310.0 242 11 15 7   11       1 23   141 169                 310
3345483 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   k_12_total 286.0 25.0 23.0 8.0   22.0       1.0 18.0   176.0 207.0                       383.0 286 25 23 8   22       1 18   176 207                 383
3346682 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2016   k_12_total 354.0 12.0 34.0 24.0   6.0         40.0   230.0 240.0       0.6               470.0 354 12 34 24   6         40   230 240                 470
250445 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2018   k_12_total 357.0   28.0 5.0             18.0   224.0 184.0       1.2               408.0 357   28 5             18   224 184                 408
250881 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2018   k_12_total 492.0 10.0 7.0 5.0   2.0       2.0 19.0   292.0 245.0       0.0               537.0 492 10 7 5   2       2 19   292 245                 537
250885 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   k_12_total 391.0 41.0 17.0 2.0   11.0         22.0   239.0 245.0       5.4               484.0 391 41 17 2   11         22   239 245                 484
250886 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2018   k_12_total 493.0 6.0 6.0 5.0   1.0         6.0   279.0 238.0       0.0               517.0 493 6 6 5   1         6   279 238                 517
250887 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No Elementary KG 04 2018   k_12_total 101.0 1.0 3.0               2.0   52.0 55.0       0.0               107.0 101 1 3               2   52 55                 107
251637 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2018   k_12_total 99.0 1.0 10.0               4.0   63.0 51.0       4.4               114.0 99 1 10               4   63 51                 114
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
254001 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   k_12_total 52.0 0.0       1.0             21.0 32.0       0.0               53.0 52 0       1             21 32                 53
254753 SD     school 4619580 37003   Jones County 37-3 461958000358 2 Jones County Elem   Regular School No Elementary KG 04 2018   k_12_total 63.0   3.0 7.0             6.0   47.0 32.0       0.0               79.0 63   3 7             6   47 32                 79
254923 SD     school 4638220 7002   Kimball 07-2 463822000354 2 Kimball Elementary   Regular School No Elementary PK 04 2018   k_12_total 97.0   4.0 2.0             1.0   61.0 43.0       0.0               104.0 97   4 2             1   61 43                 104
255225 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2018   k_12_total 331.0 2.0 7.0 3.0   1.0         11.0   179.0 176.0       0.3               355.0 331 2 7 3   1         11   179 176                 355
255229 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   k_12_total 72.0   3.0 2.0                 44.0 33.0       0.0               77.0 72   3 2                 44 33                 77
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
255800 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   k_12_total 508.0 3.0 26.0 18.0   5.0         27.0   313.0 274.0       0.3               587.0 508 3 26 18   5         27   313 274                 587
258957 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2018   k_12_total 70.0 12.0 7.0 2.0   2.0         6.0   53.0 46.0       16.2               99.0 70 12 7 2   2         6   53 46                 99
258959 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   k_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0       1.4               710.0 652 7 19 8   1         23   378 332                 710

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