ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Beadle" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 478 ✖
- 21 40
- 2965 18
- 2964 14
- 2967 14
- 2969 14
- 1 9
- 2966 9
- 587 7
- 2968 7
- 4582 7
- 4584 7
- 4585 7
- 4587 7
- 4588 7
- 4593 7
- 4594 7
- 22 5
- 598 5
- 2960 5
- 3035 5
- 3448 5
- 4545 5
- 4561 5
- 4578 5
- 2980 4
- 3010 4
- 3181 4
- 3688 4
- 3721 4
- 4069 4
- 4527 4
- 4573 4
- 4 3
- 20 3
- 551 3
- 553 3
- 571 3
- 594 3
- 2927 3
- 2933 3
- 2952 3
- 2956 3
- 2995 3
- 3066 3
- 3109 3
- 3133 3
- 3169 3
- 3216 3
- 3267 3
- 3298 3
- 3344 3
- 3370 3
- 3422 3
- 3522 3
- 3573 3
- 3640 3
- 3890 3
- 4221 3
- 4384 3
- 4474 3
- 4551 3
- 4596 3
- 13 2
- 16 2
- 68 2
- 494 2
- 539 2
- 583 2
- 585 2
- 596 2
- 639 2
- 645 2
- 2205 2
- 2459 2
- 2476 2
- 2509 2
- 2556 2
- 2587 2
- 2610 2
- 2687 2
- 2825 2
- 2827 2
- 2841 2
- 2869 2
- 2870 2
- 2890 2
- 2912 2
- 2915 2
- 2932 2
- 2955 2
- 2959 2
- 3023 2
- 3179 2
- 3369 2
- 4542 2
- 4546 2
- 4565 2
- 4575 2
- 10 1
- 12 1
- 14 1
- 30 1
- 31 1
- 37 1
- 43 1
- 98 1
- 118 1
- 131 1
- 132 1
- 150 1
- 163 1
- 190 1
- 222 1
- 252 1
- 261 1
- 275 1
- 276 1
- 308 1
- 341 1
- 343 1
- 361 1
- 382 1
- 385 1
- 386 1
- 398 1
- 411 1
- 418 1
- 434 1
- 446 1
- 448 1
- 452 1
- 467 1
- 472 1
- 476 1
- 481 1
- 495 1
- 504 1
- 508 1
- 515 1
- 518 1
- 522 1
- 523 1
- 524 1
- 527 1
- 532 1
- 540 1
- 541 1
- 545 1
- 549 1
- 557 1
- 558 1
- 561 1
- 566 1
- 574 1
- 575 1
- 576 1
- 580 1
- 582 1
- 586 1
- 591 1
- 593 1
- 602 1
- 605 1
- 612 1
- 614 1
- 616 1
- 619 1
- 620 1
- 621 1
- 629 1
- 635 1
- 636 1
- 641 1
- 642 1
- 644 1
- 646 1
- 647 1
- 654 1
- 656 1
- 657 1
- 662 1
- 664 1
- 665 1
- 666 1
- 674 1
- 679 1
- 691 1
- 696 1
- 701 1
- 703 1
- 707 1
- 723 1
- 738 1
- 758 1
- 784 1
- 791 1
- 801 1
- 804 1
- 815 1
- 822 1
- 831 1
- 841 1
- 847 1
- 850 1
- 858 1
- 891 1
- 899 1
- 919 1
- 936 1
- 958 1
- 960 1
- 961 1
- 994 1
- 1016 1
- 1033 1
- 1047 1
- 1062 1
- 1075 1
- 1078 1
- 1094 1
- 1121 1
- 1150 1
- 1181 1
- 1199 1
- 1210 1
- 1212 1
- 1240 1
- 1290 1
- 1324 1
- 1349 1
- 1397 1
- 1423 1
- 1434 1
- 1479 1
- 1530 1
- 1563 1
- 1612 1
- 1667 1
- 1682 1
- 1699 1
- 1743 1
- 1802 1
- 1842 1
- 1893 1
- 1924 1
- 1943 1
- 1975 1
- 2024 1
- 2066 1
- 2093 1
- 2129 1
- 2161 1
- 2166 1
- 2178 1
- 2242 1
- 2255 1
- 2273 1
- 2278 1
- 2292 1
- 2325 1
- 2342 1
- 2351 1
- 2367 1
- 2376 1
- 2384 1
- 2386 1
- 2396 1
- 2404 1
- 2410 1
- 2421 1
- 2424 1
- 2425 1
- 2426 1
- 2438 1
- 2441 1
- 2447 1
- 2456 1
- 2461 1
- 2467 1
- 2480 1
- 2481 1
- 2486 1
- 2488 1
- 2502 1
- 2513 1
- 2519 1
- 2520 1
- 2526 1
- 2533 1
- 2536 1
- 2539 1
- 2546 1
- 2553 1
- 2563 1
- 2565 1
- 2569 1
- 2573 1
- 2576 1
- 2577 1
- 2580 1
- 2586 1
- 2592 1
- 2596 1
- 2597 1
- 2600 1
- 2602 1
- 2603 1
- 2606 1
- 2607 1
- 2609 1
- 2614 1
- 2617 1
- 2619 1
- 2621 1
- 2623 1
- 2624 1
- 2628 1
- 2634 1
- 2641 1
- 2646 1
- 2651 1
- 2654 1
- 2655 1
- 2664 1
- 2669 1
- 2674 1
- 2683 1
- 2685 1
- 2693 1
- 2704 1
- 2712 1
- 2720 1
- 2724 1
- 2730 1
- 2733 1
- 2740 1
- 2752 1
- 2772 1
- 2780 1
- 2785 1
- 2789 1
- 2791 1
- 2805 1
- 2813 1
- 2819 1
- 2820 1
- 2822 1
- 2832 1
- 2838 1
- 2840 1
- 2842 1
- 2849 1
- 2851 1
- 2852 1
- 2857 1
- 2862 1
- 2863 1
- 2864 1
- 2867 1
- 2872 1
- 2879 1
- 2882 1
- 2885 1
- 2888 1
- 2892 1
- 2896 1
- 2903 1
- 2906 1
- 2907 1
- 2916 1
- 2919 1
- 2921 1
- 2929 1
- 2935 1
- 2943 1
- 2945 1
- 2948 1
- 2953 1
- 2954 1
- 2957 1
- 2958 1
- 2962 1
- 2977 1
- 2979 1
- 2985 1
- 2987 1
- 2991 1
- 2996 1
- 3005 1
- 3008 1
- 3014 1
- 3039 1
- 3041 1
- 3053 1
- 3070 1
- 3085 1
- 3090 1
- 3097 1
- 3114 1
- 3125 1
- 3128 1
- 3130 1
- 3143 1
- 3157 1
- 3160 1
- 3166 1
- 3174 1
- 3180 1
- 3186 1
- 3203 1
- 3210 1
- 3233 1
- 3252 1
- 3258 1
- 3262 1
- 3272 1
- 3280 1
- 3287 1
- 3291 1
- 3309 1
- 3317 1
- 3327 1
- 3337 1
- 3348 1
- 3356 1
- 3375 1
- 3389 1
- 3397 1
- 3407 1
- 3430 1
- 3441 1
- 3458 1
- 3463 1
- 3501 1
- 3517 1
- 3533 1
- 3557 1
- 3569 1
- 3577 1
- 3581 1
- 3603 1
- 3610 1
- 3633 1
- 3650 1
- 3663 1
- 3682 1
- 3702 1
- 3714 1
- 3719 1
- 3725 1
- 3790 1
- 3810 1
- 3844 1
- 3917 1
- 3944 1
- 3978 1
- 4012 1
- 4100 1
- 4174 1
- 4199 1
- 4244 1
- 4303 1
- 4334 1
- 4358 1
- 4415 1
- 4455 1
- 4466 1
- 4473 1
- 4485 1
- 4505 1
- 4521 1
- 4523 1
- 4531 1
- 4554 1
- 4564 1
- 4567 1
- 4571 1
- 4577 1
state 1
- South Dakota · 795 ✖
fips 1
- 46005 795
county 1
- Beadle · 795 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502046 | 2502046 | 2022-05-13 | Beadle | South Dakota | 46005 | 4596 | 60 |
2498788 | 2498788 | 2022-05-12 | Beadle | South Dakota | 46005 | 4596 | 60 |
2495530 | 2495530 | 2022-05-11 | Beadle | South Dakota | 46005 | 4596 | 60 |
2492272 | 2492272 | 2022-05-10 | Beadle | South Dakota | 46005 | 4594 | 60 |
2489014 | 2489014 | 2022-05-09 | Beadle | South Dakota | 46005 | 4594 | 60 |
2485757 | 2485757 | 2022-05-08 | Beadle | South Dakota | 46005 | 4594 | 60 |
2482499 | 2482499 | 2022-05-07 | Beadle | South Dakota | 46005 | 4594 | 60 |
2479241 | 2479241 | 2022-05-06 | Beadle | South Dakota | 46005 | 4594 | 60 |
2475983 | 2475983 | 2022-05-05 | Beadle | South Dakota | 46005 | 4594 | 60 |
2472726 | 2472726 | 2022-05-04 | Beadle | South Dakota | 46005 | 4594 | 60 |
2469470 | 2469470 | 2022-05-03 | Beadle | South Dakota | 46005 | 4593 | 60 |
2466214 | 2466214 | 2022-05-02 | Beadle | South Dakota | 46005 | 4593 | 60 |
2462959 | 2462959 | 2022-05-01 | Beadle | South Dakota | 46005 | 4593 | 60 |
2459703 | 2459703 | 2022-04-30 | Beadle | South Dakota | 46005 | 4593 | 60 |
2456447 | 2456447 | 2022-04-29 | Beadle | South Dakota | 46005 | 4593 | 60 |
2453191 | 2453191 | 2022-04-28 | Beadle | South Dakota | 46005 | 4593 | 60 |
2449935 | 2449935 | 2022-04-27 | Beadle | South Dakota | 46005 | 4593 | 60 |
2446678 | 2446678 | 2022-04-26 | Beadle | South Dakota | 46005 | 4588 | 59 |
2443423 | 2443423 | 2022-04-25 | Beadle | South Dakota | 46005 | 4588 | 59 |
2440167 | 2440167 | 2022-04-24 | Beadle | South Dakota | 46005 | 4588 | 59 |
2436911 | 2436911 | 2022-04-23 | Beadle | South Dakota | 46005 | 4588 | 59 |
2433655 | 2433655 | 2022-04-22 | Beadle | South Dakota | 46005 | 4588 | 59 |
2430399 | 2430399 | 2022-04-21 | Beadle | South Dakota | 46005 | 4588 | 59 |
2427143 | 2427143 | 2022-04-20 | Beadle | South Dakota | 46005 | 4588 | 59 |
2423887 | 2423887 | 2022-04-19 | Beadle | South Dakota | 46005 | 4587 | 59 |
2420631 | 2420631 | 2022-04-18 | Beadle | South Dakota | 46005 | 4587 | 59 |
2417375 | 2417375 | 2022-04-17 | Beadle | South Dakota | 46005 | 4587 | 59 |
2414119 | 2414119 | 2022-04-16 | Beadle | South Dakota | 46005 | 4587 | 59 |
2410863 | 2410863 | 2022-04-15 | Beadle | South Dakota | 46005 | 4587 | 59 |
2407607 | 2407607 | 2022-04-14 | Beadle | South Dakota | 46005 | 4587 | 59 |
2404351 | 2404351 | 2022-04-13 | Beadle | South Dakota | 46005 | 4587 | 59 |
2401096 | 2401096 | 2022-04-12 | Beadle | South Dakota | 46005 | 4585 | 59 |
2397841 | 2397841 | 2022-04-11 | Beadle | South Dakota | 46005 | 4585 | 59 |
2394586 | 2394586 | 2022-04-10 | Beadle | South Dakota | 46005 | 4585 | 59 |
2391330 | 2391330 | 2022-04-09 | Beadle | South Dakota | 46005 | 4585 | 59 |
2388074 | 2388074 | 2022-04-08 | Beadle | South Dakota | 46005 | 4585 | 59 |
2384819 | 2384819 | 2022-04-07 | Beadle | South Dakota | 46005 | 4585 | 59 |
2381564 | 2381564 | 2022-04-06 | Beadle | South Dakota | 46005 | 4585 | 59 |
2378309 | 2378309 | 2022-04-05 | Beadle | South Dakota | 46005 | 4584 | 58 |
2375055 | 2375055 | 2022-04-04 | Beadle | South Dakota | 46005 | 4584 | 58 |
2371803 | 2371803 | 2022-04-03 | Beadle | South Dakota | 46005 | 4584 | 58 |
2368550 | 2368550 | 2022-04-02 | Beadle | South Dakota | 46005 | 4584 | 58 |
2365297 | 2365297 | 2022-04-01 | Beadle | South Dakota | 46005 | 4584 | 58 |
2362044 | 2362044 | 2022-03-31 | Beadle | South Dakota | 46005 | 4584 | 58 |
2358790 | 2358790 | 2022-03-30 | Beadle | South Dakota | 46005 | 4584 | 58 |
2355536 | 2355536 | 2022-03-29 | Beadle | South Dakota | 46005 | 4582 | 58 |
2352283 | 2352283 | 2022-03-28 | Beadle | South Dakota | 46005 | 4582 | 58 |
2349031 | 2349031 | 2022-03-27 | Beadle | South Dakota | 46005 | 4582 | 58 |
2345778 | 2345778 | 2022-03-26 | Beadle | South Dakota | 46005 | 4582 | 58 |
2342525 | 2342525 | 2022-03-25 | Beadle | South Dakota | 46005 | 4582 | 58 |
2339272 | 2339272 | 2022-03-24 | Beadle | South Dakota | 46005 | 4582 | 58 |
2336018 | 2336018 | 2022-03-23 | Beadle | South Dakota | 46005 | 4582 | 58 |
2332764 | 2332764 | 2022-03-22 | Beadle | South Dakota | 46005 | 4578 | 58 |
2329511 | 2329511 | 2022-03-21 | Beadle | South Dakota | 46005 | 4578 | 58 |
2326259 | 2326259 | 2022-03-20 | Beadle | South Dakota | 46005 | 4578 | 58 |
2323006 | 2323006 | 2022-03-19 | Beadle | South Dakota | 46005 | 4578 | 58 |
2319752 | 2319752 | 2022-03-18 | Beadle | South Dakota | 46005 | 4578 | 58 |
2316498 | 2316498 | 2022-03-17 | Beadle | South Dakota | 46005 | 4577 | 58 |
2313245 | 2313245 | 2022-03-16 | Beadle | South Dakota | 46005 | 4575 | 58 |
2309992 | 2309992 | 2022-03-15 | Beadle | South Dakota | 46005 | 4575 | 57 |
2306739 | 2306739 | 2022-03-14 | Beadle | South Dakota | 46005 | 4573 | 57 |
2303488 | 2303488 | 2022-03-13 | Beadle | South Dakota | 46005 | 4573 | 57 |
2300236 | 2300236 | 2022-03-12 | Beadle | South Dakota | 46005 | 4573 | 57 |
2296984 | 2296984 | 2022-03-11 | Beadle | South Dakota | 46005 | 4573 | 57 |
2293732 | 2293732 | 2022-03-10 | Beadle | South Dakota | 46005 | 4571 | 57 |
2290480 | 2290480 | 2022-03-09 | Beadle | South Dakota | 46005 | 4567 | 57 |
2287228 | 2287228 | 2022-03-08 | Beadle | South Dakota | 46005 | 4565 | 57 |
2283976 | 2283976 | 2022-03-07 | Beadle | South Dakota | 46005 | 4565 | 57 |
2280724 | 2280724 | 2022-03-06 | Beadle | South Dakota | 46005 | 4561 | 56 |
2277471 | 2277471 | 2022-03-05 | Beadle | South Dakota | 46005 | 4561 | 56 |
2274218 | 2274218 | 2022-03-04 | Beadle | South Dakota | 46005 | 4561 | 56 |
2270965 | 2270965 | 2022-03-03 | Beadle | South Dakota | 46005 | 4561 | 56 |
2267713 | 2267713 | 2022-03-02 | Beadle | South Dakota | 46005 | 4564 | 56 |
2264460 | 2264460 | 2022-03-01 | Beadle | South Dakota | 46005 | 4561 | 56 |
2261210 | 2261210 | 2022-02-28 | Beadle | South Dakota | 46005 | 4554 | 56 |
2257959 | 2257959 | 2022-02-27 | Beadle | South Dakota | 46005 | 4551 | 56 |
2254708 | 2254708 | 2022-02-26 | Beadle | South Dakota | 46005 | 4551 | 56 |
2251457 | 2251457 | 2022-02-25 | Beadle | South Dakota | 46005 | 4551 | 56 |
2248206 | 2248206 | 2022-02-24 | Beadle | South Dakota | 46005 | 4545 | 56 |
2244955 | 2244955 | 2022-02-23 | Beadle | South Dakota | 46005 | 4546 | 56 |
2241704 | 2241704 | 2022-02-22 | Beadle | South Dakota | 46005 | 4546 | 56 |
2238453 | 2238453 | 2022-02-21 | Beadle | South Dakota | 46005 | 4545 | 56 |
2235202 | 2235202 | 2022-02-20 | Beadle | South Dakota | 46005 | 4545 | 56 |
2231951 | 2231951 | 2022-02-19 | Beadle | South Dakota | 46005 | 4545 | 56 |
2228700 | 2228700 | 2022-02-18 | Beadle | South Dakota | 46005 | 4545 | 56 |
2225449 | 2225449 | 2022-02-17 | Beadle | South Dakota | 46005 | 4542 | 56 |
2222198 | 2222198 | 2022-02-16 | Beadle | South Dakota | 46005 | 4542 | 56 |
2218947 | 2218947 | 2022-02-15 | Beadle | South Dakota | 46005 | 4531 | 55 |
2215696 | 2215696 | 2022-02-14 | Beadle | South Dakota | 46005 | 4527 | 55 |
2212445 | 2212445 | 2022-02-13 | Beadle | South Dakota | 46005 | 4527 | 55 |
2209192 | 2209192 | 2022-02-12 | Beadle | South Dakota | 46005 | 4527 | 55 |
2205939 | 2205939 | 2022-02-11 | Beadle | South Dakota | 46005 | 4527 | 55 |
2202686 | 2202686 | 2022-02-10 | Beadle | South Dakota | 46005 | 4523 | 54 |
2199432 | 2199432 | 2022-02-09 | Beadle | South Dakota | 46005 | 4521 | 53 |
2196178 | 2196178 | 2022-02-08 | Beadle | South Dakota | 46005 | 4505 | 52 |
2192924 | 2192924 | 2022-02-07 | Beadle | South Dakota | 46005 | 4485 | 52 |
2189670 | 2189670 | 2022-02-06 | Beadle | South Dakota | 46005 | 4474 | 52 |
2186417 | 2186417 | 2022-02-05 | Beadle | South Dakota | 46005 | 4474 | 52 |
2183165 | 2183165 | 2022-02-04 | Beadle | South Dakota | 46005 | 4474 | 52 |
2179913 | 2179913 | 2022-02-03 | Beadle | South Dakota | 46005 | 4473 | 52 |
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);