Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_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
254495 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   pk_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0                       478.0 177 2 162 7   111       1 18   254 224                 478
259397 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 202.0 5.0 7.0 21.0   6.0         13.0   130.0 124.0                       254.0 202 5 7 21   6         13   130 124                 254
361722 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2019   pk_12_total 160.0 4.0 149.0 11.0   115.0       1.0 16.0   238.0 218.0                       456.0 160 4 149 11   115       1 16   238 218                 456
366624 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2019   pk_12_total 224.0 6.0 7.0 26.0   7.0         9.0   139.0 140.0                       279.0 224 6 7 26   7         9   139 140                 279
453568 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   pk_12_total 163.0 4.0 146.0 8.0   105.0       4.0 16.0   211.0 235.0                       446.0 163 4 146 8   105       4 16   211 235                 446
458502 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2021   pk_12_total 194.0 5.0 11.0 16.0   8.0       1.0 21.0   123.0 133.0                       256.0 194 5 11 16   8       1 21   123 133                 256
491991 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2020   pk_12_total 170.0 5.0 153.0 9.0   106.0       5.0 16.0   228.0 236.0                       464.0 170 5 153 9   106       5 16   228 236                 464
496925 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   pk_12_total 209.0 7.0 10.0 28.0   6.0       2.0 10.0   120.0 152.0                       272.0 209 7 10 28   6       2 10   120 152                 272
2964074 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2015   pk_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
2971182 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2015   pk_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
3008778 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No Elementary KG 01 2017   pk_12_total 317.0 16.0 42.0 27.0   5.0       1.0 56.0   251.0 213.0                       464.0 317 16 42 27   5       1 56   251 213                 464
3010952 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2017   pk_12_total 189.0 5.0 144.0 8.0   110.0       1.0 15.0   254.0 218.0                       472.0 189 5 144 8   110       1 15   254 218                 472
3015790 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 168.0 2.0 9.0 17.0   5.0         15.0   109.0 107.0                       216.0 168 2 9 17   5         15   109 107                 216
3346690 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2016   pk_12_total 358.0 16.0 51.0 30.0   2.0       2.0 51.0   265.0 245.0                       510.0 358 16 51 30   2       2 51   265 245                 510
3353702 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2016   pk_12_total 158.0 1.0 6.0 16.0   7.0       1.0 11.0   108.0 92.0                       200.0 158 1 6 16   7       1 11   108 92                 200
252471 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2018   pk_12_total 2.0     105.0   1.0       1.0     57.0 52.0                       109.0 2     105   1       1     57 52                 109
256197 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2018   pk_12_total 67.0 2.0 4.0 59.0   2.0             66.0 68.0                       134.0 67 2 4 59   2             66 68                 134
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
260053 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   pk_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0                       247.0 229 2 7 2             7   127 120                 247
359715 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2019   pk_12_total 2.0     81.0   1.0             44.0 40.0                       84.0 2     81   1             44 40                 84
363440 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2019   pk_12_total 71.0 1.0 1.0 54.0   1.0             57.0 71.0                       128.0 71 1 1 54   1             57 71                 128
366031 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2019   pk_12_total 298.0 3.0 16.0 6.0   5.0         14.0   163.0 179.0                       342.0 298 3 16 6   5         14   163 179                 342
367311 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2019   pk_12_total 247.0 2.0 5.0 2.0             9.0   141.0 124.0                       265.0 247 2 5 2             9   141 124                 265
451560 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School Not applicable Elementary KG 02 2021   pk_12_total 3.0   1.0 55.0                 30.0 29.0                       59.0 3   1 55                 30 29                 59
455302 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2021   pk_12_total 93.0 1.0 2.0 47.0             1.0   68.0 76.0                       144.0 93 1 2 47             1   68 76                 144
457893 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2021   pk_12_total 268.0 1.0 13.0 5.0   3.0         12.0   154.0 148.0                       302.0 268 1 13 5   3         12   154 148                 302
459221 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School Not applicable Elementary KG 02 2021   pk_12_total 267.0   3.0 2.0             4.0   148.0 128.0                       276.0 267   3 2             4   148 128                 276
489999 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School Not applicable Elementary KG 02 2020   pk_12_total 4.0     90.0                 47.0 47.0                       94.0 4     90                 47 47                 94
493725 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School Not applicable Elementary KG 02 2020   pk_12_total 77.0   1.0 57.0   1.0             62.0 74.0                       136.0 77   1 57   1             62 74                 136
496316 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   pk_12_total 275.0 1.0 17.0 5.0   2.0         6.0   144.0 162.0                       306.0 275 1 17 5   2         6   144 162                 306
497612 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School Not applicable Elementary KG 02 2020   pk_12_total 254.0 3.0 5.0 2.0             7.0   144.0 127.0                       271.0 254 3 5 2             7   144 127                 271
2964207 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No 1 KG 02 2015   pk_12_total 1.0   1.0 77.0                 36.0 43.0                       79.0 1   1 77                 36 43                 79
2967886 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2015   pk_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
2970557 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   pk_12_total 351.0 2.0 17.0 11.0   1.0         9.0   195.0 196.0                       391.0 351 2 17 11   1         9   195 196                 391
2970782 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 KG 02 2015   pk_12_total 418.0 7.0 6.0 4.0   2.0       1.0 14.0   252.0 200.0                       452.0 418 7 6 4   2       1 14   252 200                 452
2971822 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No 1 KG 02 2015   pk_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
3008896 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2017   pk_12_total 1.0     82.0   1.0             45.0 39.0                       84.0 1     82   1             45 39                 84
3012622 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No Elementary KG 02 2017   pk_12_total 66.0 4.0 3.0 69.0                 67.0 75.0                       142.0 66 4 3 69                 67 75                 142
3015214 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No Elementary 01 02 2017   pk_12_total 310.0 4.0 13.0 10.0   5.0       1.0 10.0   206.0 147.0                       353.0 310 4 13 10   5       1 10   206 147                 353
3016446 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2017   pk_12_total 237.0   4.0 5.0             4.0   128.0 122.0                       250.0 237   4 5             4   128 122                 250
3346808 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No 1 KG 02 2016   pk_12_total 2.0   2.0 80.0                 41.0 43.0                       84.0 2   2 80                 41 43                 84
3350486 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100486 3 Freeman Davis Elementary   Regular School No 1 PK 02 2016   pk_12_total 87.0 2.0 6.0 61.0                 69.0 87.0                       156.0 87 2 6 61                 69 87                 156
3353125 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2016   pk_12_total 332.0 4.0 16.0 6.0   4.0       1.0 10.0   204.0 169.0                       373.0 332 4 16 6   4       1 10   204 169                 373
3353300 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Elementary School   Regular School No 1 PK 02 2016   pk_12_total 411.0 3.0 8.0 5.0             13.0   241.0 199.0                       440.0 411 3 8 5             13   241 199                 440
3354326 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No 1 KG 02 2016   pk_12_total 238.0 2.0 6.0 6.0             4.0   139.0 117.0                       256.0 238 2 6 6             4   139 117                 256
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
251141 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   pk_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0                       277.0 214 7 14 13   11         18   146 131                 277
251142 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2018   pk_12_total 270.0 23.0 31.0 10.0   18.0         18.0   191.0 179.0                       370.0 270 23 31 10   18         18   191 179                 370
251941 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   pk_12_total 332.0 3.0 27.0 1.0   15.0         18.0   204.0 192.0                       396.0 332 3 27 1   15         18   204 192                 396
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
254499 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   pk_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0                       432.0 190 4 126 7   92         13   245 187                 432
358398 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2019   pk_12_total 396.0 17.0 18.0 5.0   7.0         27.0   247.0 223.0                       470.0 396 17 18 5   7         27   247 223                 470
358400 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   pk_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0                       284.0 213 8 16 13   13       1 20   151 133                 284
358401 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2019   pk_12_total 256.0 16.0 31.0 10.0   13.0         19.0   184.0 161.0                       345.0 256 16 31 10   13         19   184 161                 345
359200 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2019   pk_12_total 331.0 8.0 37.0 2.0   20.0         26.0   219.0 205.0                       424.0 331 8 37 2   20         26   219 205                 424
359617 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School No Elementary KG 03 2019   pk_12_total 662.0 23.0 98.0 63.0   6.0       1.0 125.0   504.0 474.0                       978.0 662 23 98 63   6       1 125   504 474                 978
361726 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   pk_12_total 183.0 9.0 146.0 10.0   100.0       2.0 14.0   254.0 210.0                       464.0 183 9 146 10   100       2 14   254 210                 464
450244 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 375.0 13.0 12.0 2.0   4.0         26.0   225.0 207.0                       432.0 375 13 12 2   4         26   225 207                 432
450246 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0                       264.0 202 8 21 6   7         20   145 119                 264
450247 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   pk_12_total 244.0 16.0 37.0 9.0   10.0       1.0 16.0   178.0 155.0                       333.0 244 16 37 9   10       1 16   178 155                 333
451046 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2021   pk_12_total 303.0 7.0 36.0 7.0   13.0       1.0 33.0   203.0 197.0                       400.0 303 7 36 7   13       1 33   203 197                 400
451448 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2021   pk_12_total 576.0 16.0 102.0 54.0   11.0       1.0 110.0   447.0 423.0                       870.0 576 16 102 54   11       1 110   447 423                 870
453572 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2021   pk_12_total 163.0 2.0 137.0 14.0   119.0       2.0 14.0   247.0 204.0                       451.0 163 2 137 14   119       2 14   247 204                 451
488667 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School Not applicable Elementary KG 03 2020   pk_12_total 397.0 12.0 15.0 2.0   8.0         30.0   247.0 217.0                       464.0 397 12 15 2   8         30   247 217                 464
488669 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2020   pk_12_total 225.0 12.0 18.0 15.0   10.0       2.0 22.0   169.0 135.0                       304.0 225 12 18 15   10       2 22   169 135                 304
488670 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2020   pk_12_total 252.0 16.0 36.0 10.0   15.0         20.0   192.0 157.0                       349.0 252 16 36 10   15         20   192 157                 349
489469 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School Not applicable Elementary KG 03 2020   pk_12_total 322.0 10.0 38.0 2.0   19.0       1.0 27.0   223.0 196.0                       419.0 322 10 38 2   19       1 27   223 196                 419
489886 SD     school 4619410 51001   Douglas 51-1 461941001384 6 Patriot Elementary   Regular School Not applicable Elementary KG 03 2020   pk_12_total 606.0 22.0 105.0 68.0   9.0       3.0 116.0   473.0 456.0                       929.0 606 22 105 68   9       3 116   473 456                 929
491995 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   pk_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0                       478.0 166 8 156 11   119       2 16   253 225                 478
2962721 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142000073 3 Emery Elementary   Regular School No 1 KG 03 2015   pk_12_total 53.0   3.0                   31.0 25.0                       56.0 53   3                   31 25                 56
2962879 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2015   pk_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
2962880 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2015   pk_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
2964078 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2015   pk_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
3007548 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2017   pk_12_total 406.0 11.0 15.0 9.0   6.0         26.0   249.0 224.0                       473.0 406 11 15 9   6         26   249 224                 473
3007550 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2017   pk_12_total 235.0 11.0 11.0 12.0   10.0       1.0 22.0   155.0 147.0                       302.0 235 11 11 12   10       1 22   155 147                 302
3007551 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2017   pk_12_total 289.0 23.0 23.0 10.0   19.0         11.0   194.0 181.0                       375.0 289 23 23 10   19         11   194 181                 375
3008350 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2017   pk_12_total 329.0 3.0 32.0 2.0   14.0         20.0   205.0 195.0                       400.0 329 3 32 2   14         20   205 195                 400
3008782 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No Elementary 02 03 2017   pk_12_total 354.0 11.0 49.0 33.0   3.0         42.0   249.0 243.0                       492.0 354 11 49 33   3         42   249 243                 492
3010956 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2017   pk_12_total 193.0 5.0 104.0 6.0   81.0         12.0   226.0 175.0                       401.0 193 5 104 6   81         12   226 175                 401
3345305 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010073 3 Emery Elementary   Regular School No 1 PK 03 2016   pk_12_total 45.0   4.0                   26.0 23.0                       49.0 45   4                   26 23                 49
3345492 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No 1 KG 03 2016   pk_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
3345494 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No 1 KG 03 2016   pk_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
3345495 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No 1 KG 03 2016   pk_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
3346694 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2016   pk_12_total 354.0 12.0 34.0 24.0   6.0         40.0   230.0 240.0                       470.0 354 12 34 24   6         40   230 240                 470
250455 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2018   pk_12_total 357.0   28.0 5.0             18.0   224.0 184.0                       408.0 357   28 5             18   224 184                 408
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
250899 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   pk_12_total 391.0 41.0 17.0 2.0   11.0         22.0   239.0 245.0                       484.0 391 41 17 2   11         22   239 245                 484
250900 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2018   pk_12_total 493.0 6.0 6.0 5.0   1.0         6.0   279.0 238.0                       517.0 493 6 6 5   1         6   279 238                 517
250901 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No Elementary KG 04 2018   pk_12_total 101.0 1.0 3.0               2.0   52.0 55.0                       107.0 101 1 3               2   52 55                 107
251649 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2018   pk_12_total 126.0 2.0 10.0               4.0   79.0 63.0                       142.0 126 2 10               4   79 63                 142
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
254007 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   pk_12_total 63.0 1.0       1.0             26.0 39.0                       65.0 63 1       1             26 39                 65
254759 SD     school 4619580 37003   Jones County 37-3 461958000358 2 Jones County Elem   Regular School No Elementary KG 04 2018   pk_12_total 63.0   3.0 7.0             6.0   47.0 32.0                       79.0 63   3 7             6   47 32                 79
254933 SD     school 4638220 7002   Kimball 07-2 463822000354 2 Kimball Elementary   Regular School No Elementary PK 04 2018   pk_12_total 109.0   4.0 3.0             3.0   67.0 52.0                       119.0 109   4 3             3   67 52                 119
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
255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
255558 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School No Elementary PK 04 2018   pk_12_total 156.0 1.0 10.0               9.0   107.0 69.0                       176.0 156 1 10               9   107 69                 176
255822 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2018   pk_12_total 508.0 3.0 26.0 18.0   5.0         27.0   313.0 274.0                       587.0 508 3 26 18   5         27   313 274                 587
258965 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2018   pk_12_total 70.0 12.0 7.0 2.0   2.0         6.0   53.0 46.0                       99.0 70 12 7 2   2         6   53 46                 99
258967 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   pk_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0                       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]);