ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
710 rows where fips = 46015 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 307 ✖
- 717 22
- 718 21
- 721 21
- 1413 21
- 1409 19
- 719 12
- 699 11
- 700 11
- 702 10
- 38 9
- 2 8
- 1401 8
- 722 7
- 723 7
- 724 7
- 1410 7
- 1411 7
- 1412 7
- 34 6
- 45 6
- 679 6
- 686 6
- 697 6
- 716 6
- 1407 6
- 29 5
- 40 5
- 47 5
- 50 5
- 627 5
- 680 5
- 740 5
- 791 5
- 938 5
- 15 4
- 46 4
- 76 4
- 80 4
- 625 4
- 671 4
- 701 4
- 727 4
- 751 4
- 758 4
- 798 4
- 805 4
- 813 4
- 1039 4
- 1069 4
- 1237 4
- 10 3
- 18 3
- 33 3
- 37 3
- 179 3
- 624 3
- 677 3
- 678 3
- 691 3
- 694 3
- 706 3
- 712 3
- 732 3
- 769 3
- 781 3
- 847 3
- 897 3
- 921 3
- 960 3
- 982 3
- 1012 3
- 1144 3
- 1302 3
- 1348 3
- 1371 3
- 1396 3
- 1404 3
- 1415 3
- 16 2
- 48 2
- 66 2
- 70 2
- 77 2
- 93 2
- 147 2
- 542 2
- 563 2
- 622 2
- 626 2
- 637 2
- 652 2
- 681 2
- 687 2
- 688 2
- 689 2
- 690 2
- 692 2
- 695 2
- 703 2
- 709 2
- 714 2
- 726 2
- 728 2
- 736 2
- 765 2
- 780 2
- 890 2
- 1406 2
- 1408 2
- 3 1
- 7 1
- 9 1
- 12 1
- 13 1
- 17 1
- 20 1
- 23 1
- 24 1
- 26 1
- 30 1
- 39 1
- 55 1
- 59 1
- 63 1
- 67 1
- 68 1
- 74 1
- 82 1
- 86 1
- 89 1
- 92 1
- 95 1
- 104 1
- 108 1
- 110 1
- 115 1
- 120 1
- 121 1
- 126 1
- 132 1
- 138 1
- 141 1
- 146 1
- 152 1
- 156 1
- 160 1
- 163 1
- 174 1
- 186 1
- 189 1
- 195 1
- 199 1
- 208 1
- 216 1
- 221 1
- 228 1
- 243 1
- 251 1
- 254 1
- 261 1
- 266 1
- 275 1
- 282 1
- 292 1
- 298 1
- 308 1
- 317 1
- 328 1
- 334 1
- 351 1
- 357 1
- 372 1
- 379 1
- 387 1
- 392 1
- 400 1
- 413 1
- 431 1
- 441 1
- 458 1
- 467 1
- 474 1
- 475 1
- 487 1
- 491 1
- 512 1
- 517 1
- 521 1
- 532 1
- 538 1
- 556 1
- 566 1
- 570 1
- 578 1
- 582 1
- 585 1
- 588 1
- 593 1
- 594 1
- 596 1
- 602 1
- 605 1
- 607 1
- 609 1
- 611 1
- 612 1
- 615 1
- 618 1
- 620 1
- 639 1
- 643 1
- 648 1
- 650 1
- 651 1
- 653 1
- 655 1
- 658 1
- 663 1
- 668 1
- 672 1
- 676 1
- 682 1
- 685 1
- 696 1
- 707 1
- 710 1
- 713 1
- 715 1
- 731 1
- 737 1
- 742 1
- 745 1
- 752 1
- 755 1
- 757 1
- 762 1
- 768 1
- 775 1
- 778 1
- 783 1
- 787 1
- 790 1
- 793 1
- 797 1
- 800 1
- 801 1
- 802 1
- 806 1
- 810 1
- 811 1
- 812 1
- 818 1
- 825 1
- 837 1
- 860 1
- 878 1
- 905 1
- 912 1
- 917 1
- 918 1
- 926 1
- 932 1
- 941 1
- 949 1
- 955 1
- 957 1
- 966 1
- 972 1
- 976 1
- 978 1
- 985 1
- 987 1
- 992 1
- 1003 1
- 1020 1
- 1029 1
- 1034 1
- 1044 1
- 1052 1
- 1054 1
- 1076 1
- 1090 1
- 1105 1
- 1126 1
- 1152 1
- 1184 1
- 1198 1
- 1211 1
- 1245 1
- 1281 1
- 1292 1
- 1307 1
- 1318 1
- 1332 1
- 1340 1
- 1352 1
- 1358 1
- 1361 1
- 1367 1
- 1375 1
- 1378 1
- 1388 1
- 1392 1
- 1397 1
- 1399 1
- 1400 1
- 1405 1
state 1
- South Dakota · 710 ✖
fips 1
- 46015 · 710 ✖
county 1
- Brule 710
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502051 | 2502051 | 2022-05-13 | Brule | South Dakota | 46015 | 1415 | 20 |
2498793 | 2498793 | 2022-05-12 | Brule | South Dakota | 46015 | 1415 | 20 |
2495535 | 2495535 | 2022-05-11 | Brule | South Dakota | 46015 | 1415 | 20 |
2492277 | 2492277 | 2022-05-10 | Brule | South Dakota | 46015 | 1413 | 20 |
2489019 | 2489019 | 2022-05-09 | Brule | South Dakota | 46015 | 1413 | 20 |
2485762 | 2485762 | 2022-05-08 | Brule | South Dakota | 46015 | 1413 | 20 |
2482504 | 2482504 | 2022-05-07 | Brule | South Dakota | 46015 | 1413 | 20 |
2479246 | 2479246 | 2022-05-06 | Brule | South Dakota | 46015 | 1413 | 20 |
2475988 | 2475988 | 2022-05-05 | Brule | South Dakota | 46015 | 1413 | 20 |
2472731 | 2472731 | 2022-05-04 | Brule | South Dakota | 46015 | 1413 | 20 |
2469475 | 2469475 | 2022-05-03 | Brule | South Dakota | 46015 | 1413 | 20 |
2466219 | 2466219 | 2022-05-02 | Brule | South Dakota | 46015 | 1413 | 20 |
2462964 | 2462964 | 2022-05-01 | Brule | South Dakota | 46015 | 1413 | 20 |
2459708 | 2459708 | 2022-04-30 | Brule | South Dakota | 46015 | 1413 | 20 |
2456452 | 2456452 | 2022-04-29 | Brule | South Dakota | 46015 | 1413 | 20 |
2453196 | 2453196 | 2022-04-28 | Brule | South Dakota | 46015 | 1413 | 20 |
2449940 | 2449940 | 2022-04-27 | Brule | South Dakota | 46015 | 1413 | 20 |
2446683 | 2446683 | 2022-04-26 | Brule | South Dakota | 46015 | 1413 | 20 |
2443428 | 2443428 | 2022-04-25 | Brule | South Dakota | 46015 | 1413 | 20 |
2440172 | 2440172 | 2022-04-24 | Brule | South Dakota | 46015 | 1413 | 20 |
2436916 | 2436916 | 2022-04-23 | Brule | South Dakota | 46015 | 1413 | 20 |
2433660 | 2433660 | 2022-04-22 | Brule | South Dakota | 46015 | 1413 | 20 |
2430404 | 2430404 | 2022-04-21 | Brule | South Dakota | 46015 | 1413 | 20 |
2427148 | 2427148 | 2022-04-20 | Brule | South Dakota | 46015 | 1413 | 20 |
2423892 | 2423892 | 2022-04-19 | Brule | South Dakota | 46015 | 1412 | 20 |
2420636 | 2420636 | 2022-04-18 | Brule | South Dakota | 46015 | 1412 | 20 |
2417380 | 2417380 | 2022-04-17 | Brule | South Dakota | 46015 | 1412 | 20 |
2414124 | 2414124 | 2022-04-16 | Brule | South Dakota | 46015 | 1412 | 20 |
2410868 | 2410868 | 2022-04-15 | Brule | South Dakota | 46015 | 1412 | 20 |
2407612 | 2407612 | 2022-04-14 | Brule | South Dakota | 46015 | 1412 | 20 |
2404356 | 2404356 | 2022-04-13 | Brule | South Dakota | 46015 | 1412 | 20 |
2401101 | 2401101 | 2022-04-12 | Brule | South Dakota | 46015 | 1411 | 20 |
2397846 | 2397846 | 2022-04-11 | Brule | South Dakota | 46015 | 1411 | 20 |
2394591 | 2394591 | 2022-04-10 | Brule | South Dakota | 46015 | 1411 | 20 |
2391335 | 2391335 | 2022-04-09 | Brule | South Dakota | 46015 | 1411 | 20 |
2388079 | 2388079 | 2022-04-08 | Brule | South Dakota | 46015 | 1411 | 20 |
2384824 | 2384824 | 2022-04-07 | Brule | South Dakota | 46015 | 1411 | 20 |
2381569 | 2381569 | 2022-04-06 | Brule | South Dakota | 46015 | 1411 | 20 |
2378314 | 2378314 | 2022-04-05 | Brule | South Dakota | 46015 | 1410 | 20 |
2375060 | 2375060 | 2022-04-04 | Brule | South Dakota | 46015 | 1410 | 20 |
2371808 | 2371808 | 2022-04-03 | Brule | South Dakota | 46015 | 1410 | 20 |
2368555 | 2368555 | 2022-04-02 | Brule | South Dakota | 46015 | 1410 | 20 |
2365302 | 2365302 | 2022-04-01 | Brule | South Dakota | 46015 | 1410 | 20 |
2362049 | 2362049 | 2022-03-31 | Brule | South Dakota | 46015 | 1410 | 20 |
2358795 | 2358795 | 2022-03-30 | Brule | South Dakota | 46015 | 1410 | 20 |
2355541 | 2355541 | 2022-03-29 | Brule | South Dakota | 46015 | 1409 | 20 |
2352288 | 2352288 | 2022-03-28 | Brule | South Dakota | 46015 | 1409 | 20 |
2349036 | 2349036 | 2022-03-27 | Brule | South Dakota | 46015 | 1409 | 20 |
2345783 | 2345783 | 2022-03-26 | Brule | South Dakota | 46015 | 1409 | 20 |
2342530 | 2342530 | 2022-03-25 | Brule | South Dakota | 46015 | 1409 | 20 |
2339277 | 2339277 | 2022-03-24 | Brule | South Dakota | 46015 | 1409 | 20 |
2336023 | 2336023 | 2022-03-23 | Brule | South Dakota | 46015 | 1409 | 20 |
2332769 | 2332769 | 2022-03-22 | Brule | South Dakota | 46015 | 1409 | 20 |
2329516 | 2329516 | 2022-03-21 | Brule | South Dakota | 46015 | 1409 | 20 |
2326264 | 2326264 | 2022-03-20 | Brule | South Dakota | 46015 | 1409 | 20 |
2323011 | 2323011 | 2022-03-19 | Brule | South Dakota | 46015 | 1409 | 20 |
2319757 | 2319757 | 2022-03-18 | Brule | South Dakota | 46015 | 1409 | 20 |
2316503 | 2316503 | 2022-03-17 | Brule | South Dakota | 46015 | 1409 | 20 |
2313250 | 2313250 | 2022-03-16 | Brule | South Dakota | 46015 | 1409 | 20 |
2309997 | 2309997 | 2022-03-15 | Brule | South Dakota | 46015 | 1409 | 20 |
2306744 | 2306744 | 2022-03-14 | Brule | South Dakota | 46015 | 1409 | 20 |
2303493 | 2303493 | 2022-03-13 | Brule | South Dakota | 46015 | 1409 | 20 |
2300241 | 2300241 | 2022-03-12 | Brule | South Dakota | 46015 | 1409 | 20 |
2296989 | 2296989 | 2022-03-11 | Brule | South Dakota | 46015 | 1409 | 20 |
2293737 | 2293737 | 2022-03-10 | Brule | South Dakota | 46015 | 1408 | 19 |
2290485 | 2290485 | 2022-03-09 | Brule | South Dakota | 46015 | 1408 | 19 |
2287233 | 2287233 | 2022-03-08 | Brule | South Dakota | 46015 | 1407 | 19 |
2283981 | 2283981 | 2022-03-07 | Brule | South Dakota | 46015 | 1407 | 19 |
2280729 | 2280729 | 2022-03-06 | Brule | South Dakota | 46015 | 1407 | 19 |
2277476 | 2277476 | 2022-03-05 | Brule | South Dakota | 46015 | 1407 | 19 |
2274223 | 2274223 | 2022-03-04 | Brule | South Dakota | 46015 | 1407 | 19 |
2270970 | 2270970 | 2022-03-03 | Brule | South Dakota | 46015 | 1407 | 19 |
2267718 | 2267718 | 2022-03-02 | Brule | South Dakota | 46015 | 1406 | 18 |
2264465 | 2264465 | 2022-03-01 | Brule | South Dakota | 46015 | 1406 | 18 |
2261215 | 2261215 | 2022-02-28 | Brule | South Dakota | 46015 | 1405 | 18 |
2257964 | 2257964 | 2022-02-27 | Brule | South Dakota | 46015 | 1404 | 18 |
2254713 | 2254713 | 2022-02-26 | Brule | South Dakota | 46015 | 1404 | 18 |
2251462 | 2251462 | 2022-02-25 | Brule | South Dakota | 46015 | 1404 | 18 |
2248211 | 2248211 | 2022-02-24 | Brule | South Dakota | 46015 | 1401 | 18 |
2244960 | 2244960 | 2022-02-23 | Brule | South Dakota | 46015 | 1401 | 18 |
2241709 | 2241709 | 2022-02-22 | Brule | South Dakota | 46015 | 1401 | 18 |
2238458 | 2238458 | 2022-02-21 | Brule | South Dakota | 46015 | 1401 | 18 |
2235207 | 2235207 | 2022-02-20 | Brule | South Dakota | 46015 | 1401 | 18 |
2231956 | 2231956 | 2022-02-19 | Brule | South Dakota | 46015 | 1401 | 18 |
2228705 | 2228705 | 2022-02-18 | Brule | South Dakota | 46015 | 1401 | 18 |
2225454 | 2225454 | 2022-02-17 | Brule | South Dakota | 46015 | 1401 | 18 |
2222203 | 2222203 | 2022-02-16 | Brule | South Dakota | 46015 | 1400 | 18 |
2218952 | 2218952 | 2022-02-15 | Brule | South Dakota | 46015 | 1399 | 18 |
2215701 | 2215701 | 2022-02-14 | Brule | South Dakota | 46015 | 1397 | 18 |
2212450 | 2212450 | 2022-02-13 | Brule | South Dakota | 46015 | 1396 | 18 |
2209197 | 2209197 | 2022-02-12 | Brule | South Dakota | 46015 | 1396 | 18 |
2205944 | 2205944 | 2022-02-11 | Brule | South Dakota | 46015 | 1396 | 18 |
2202691 | 2202691 | 2022-02-10 | Brule | South Dakota | 46015 | 1392 | 18 |
2199437 | 2199437 | 2022-02-09 | Brule | South Dakota | 46015 | 1388 | 18 |
2196183 | 2196183 | 2022-02-08 | Brule | South Dakota | 46015 | 1378 | 18 |
2192929 | 2192929 | 2022-02-07 | Brule | South Dakota | 46015 | 1375 | 18 |
2189675 | 2189675 | 2022-02-06 | Brule | South Dakota | 46015 | 1371 | 18 |
2186422 | 2186422 | 2022-02-05 | Brule | South Dakota | 46015 | 1371 | 18 |
2183170 | 2183170 | 2022-02-04 | Brule | South Dakota | 46015 | 1371 | 18 |
2179918 | 2179918 | 2022-02-03 | Brule | South Dakota | 46015 | 1367 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);