ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,552 rows where state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 67
- 46005 795
- 46023 795
- 46035 795
- 46099 795
- 46009 794
- 46087 792
- 46013 783
- 46029 782
- 46065 782
- 46085 782
- 46103 782
- 46011 781
- 46083 780
- 46093 780
- 46049 778
- 46081 778
- 46121 778
- 46127 778
- 46039 777
- 46057 777
- 46067 777
- 46135 777
- 46025 776
- 46027 776
- 46047 776
- 46109 776
- 46125 776
- 46091 775
- 46079 772
- 46115 772
- 46102 766
- 46031 765
- 46073 765
- 46097 764
- 46111 763
- 46119 762
- 46129 762
- 46069 761
- 46101 758
- 46117 750
- 46089 749
- 46059 748
- 46043 747
- 46017 746
- 46037 745
- 46051 738
- 46137 738
- 46123 730
- 46071 720
- 46045 715
- 46077 715
- 46053 713
- 46015 710
- 46061 710
- 46033 709
- 46041 707
- 46095 700
- 46007 698
- 46021 680
- 46003 678
- 46055 677
- 46019 675
- 46075 675
- 46105 672
- 46107 660
- 46063 639
- - 5
county 67
- Beadle 795
- Charles Mix 795
- Davison 795
- Minnehaha 795
- Bon Homme 794
- McCook 792
- Brown 783
- Codington 782
- Hughes 782
- Lyman 782
- Pennington 782
- Brookings 781
- Lincoln 780
- Meade 780
- Faulk 778
- Lawrence 778
- Todd 778
- Union 778
- Deuel 777
- Hamlin 777
- Hutchinson 777
- Yankton 777
- Clark 776
- Clay 776
- Fall River 776
- Roberts 776
- Turner 776
- Marshall 775
- Lake 772
- Spink 772
- Oglala Lakota 766
- Corson 765
- Jerauld 765
- Miner 764
- Sanborn 763
- Sully 762
- Walworth 762
- Hyde 761
- Moody 758
- Stanley 750
- McPherson 749
- Hand 748
- Douglas 747
- Buffalo 746
- Day 745
- Grant 738
- Ziebach 738
- Tripp 730
- Jackson 720
- Edmunds 715
- Kingsbury 715
- Gregory 713
- Brule 710
- Hanson 710
- Custer 709
- Dewey 707
- Mellette 700
- Bennett 698
- Campbell 680
- Aurora 678
- Haakon 677
- Butte 675
- Jones 675
- Perkins 672
- Potter 660
- Harding 639
- Unknown 5
state 1
- South Dakota · 49,452 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
305260 | 305260 | 2020-07-05 | Aurora | South Dakota | 46003 | 34 | 0 |
308427 | 308427 | 2020-07-06 | Aurora | South Dakota | 46003 | 34 | 0 |
311596 | 311596 | 2020-07-07 | Aurora | South Dakota | 46003 | 34 | 0 |
314768 | 314768 | 2020-07-08 | Aurora | South Dakota | 46003 | 34 | 0 |
317941 | 317941 | 2020-07-09 | Aurora | South Dakota | 46003 | 34 | 0 |
321119 | 321119 | 2020-07-10 | Aurora | South Dakota | 46003 | 34 | 0 |
324299 | 324299 | 2020-07-11 | Aurora | South Dakota | 46003 | 34 | 0 |
327484 | 327484 | 2020-07-12 | Aurora | South Dakota | 46003 | 34 | 0 |
330670 | 330670 | 2020-07-13 | Aurora | South Dakota | 46003 | 34 | 0 |
333862 | 333862 | 2020-07-14 | Aurora | South Dakota | 46003 | 34 | 0 |
337056 | 337056 | 2020-07-15 | Aurora | South Dakota | 46003 | 34 | 0 |
340253 | 340253 | 2020-07-16 | Aurora | South Dakota | 46003 | 35 | 0 |
343451 | 343451 | 2020-07-17 | Aurora | South Dakota | 46003 | 35 | 0 |
346651 | 346651 | 2020-07-18 | Aurora | South Dakota | 46003 | 35 | 0 |
349851 | 349851 | 2020-07-19 | Aurora | South Dakota | 46003 | 35 | 0 |
353054 | 353054 | 2020-07-20 | Aurora | South Dakota | 46003 | 35 | 0 |
356257 | 356257 | 2020-07-21 | Aurora | South Dakota | 46003 | 35 | 0 |
359461 | 359461 | 2020-07-22 | Aurora | South Dakota | 46003 | 36 | 0 |
362667 | 362667 | 2020-07-23 | Aurora | South Dakota | 46003 | 36 | 0 |
365873 | 365873 | 2020-07-24 | Aurora | South Dakota | 46003 | 37 | 0 |
369082 | 369082 | 2020-07-25 | Aurora | South Dakota | 46003 | 37 | 0 |
372294 | 372294 | 2020-07-26 | Aurora | South Dakota | 46003 | 37 | 0 |
375507 | 375507 | 2020-07-27 | Aurora | South Dakota | 46003 | 37 | 0 |
378723 | 378723 | 2020-07-28 | Aurora | South Dakota | 46003 | 37 | 0 |
381940 | 381940 | 2020-07-29 | Aurora | South Dakota | 46003 | 37 | 0 |
385158 | 385158 | 2020-07-30 | Aurora | South Dakota | 46003 | 37 | 0 |
388375 | 388375 | 2020-07-31 | Aurora | South Dakota | 46003 | 37 | 0 |
391592 | 391592 | 2020-08-01 | Aurora | South Dakota | 46003 | 37 | 0 |
394808 | 394808 | 2020-08-02 | Aurora | South Dakota | 46003 | 38 | 0 |
398025 | 398025 | 2020-08-03 | Aurora | South Dakota | 46003 | 38 | 0 |
401240 | 401240 | 2020-08-04 | Aurora | South Dakota | 46003 | 37 | 0 |
404458 | 404458 | 2020-08-05 | Aurora | South Dakota | 46003 | 38 | 0 |
407678 | 407678 | 2020-08-06 | Aurora | South Dakota | 46003 | 38 | 0 |
410897 | 410897 | 2020-08-07 | Aurora | South Dakota | 46003 | 38 | 0 |
414117 | 414117 | 2020-08-08 | Aurora | South Dakota | 46003 | 38 | 0 |
417338 | 417338 | 2020-08-09 | Aurora | South Dakota | 46003 | 38 | 0 |
420559 | 420559 | 2020-08-10 | Aurora | South Dakota | 46003 | 38 | 0 |
423781 | 423781 | 2020-08-11 | Aurora | South Dakota | 46003 | 38 | 0 |
427004 | 427004 | 2020-08-12 | Aurora | South Dakota | 46003 | 38 | 0 |
430230 | 430230 | 2020-08-13 | Aurora | South Dakota | 46003 | 38 | 0 |
433455 | 433455 | 2020-08-14 | Aurora | South Dakota | 46003 | 39 | 0 |
436682 | 436682 | 2020-08-15 | Aurora | South Dakota | 46003 | 40 | 0 |
439907 | 439907 | 2020-08-16 | Aurora | South Dakota | 46003 | 40 | 0 |
443134 | 443134 | 2020-08-17 | Aurora | South Dakota | 46003 | 40 | 0 |
446360 | 446360 | 2020-08-18 | Aurora | South Dakota | 46003 | 40 | 0 |
449588 | 449588 | 2020-08-19 | Aurora | South Dakota | 46003 | 40 | 0 |
452816 | 452816 | 2020-08-20 | Aurora | South Dakota | 46003 | 40 | 0 |
456044 | 456044 | 2020-08-21 | Aurora | South Dakota | 46003 | 40 | 0 |
459272 | 459272 | 2020-08-22 | Aurora | South Dakota | 46003 | 41 | 0 |
462500 | 462500 | 2020-08-23 | Aurora | South Dakota | 46003 | 42 | 0 |
465729 | 465729 | 2020-08-24 | Aurora | South Dakota | 46003 | 42 | 0 |
468957 | 468957 | 2020-08-25 | Aurora | South Dakota | 46003 | 42 | 0 |
472189 | 472189 | 2020-08-26 | Aurora | South Dakota | 46003 | 42 | 0 |
475423 | 475423 | 2020-08-27 | Aurora | South Dakota | 46003 | 42 | 0 |
478656 | 478656 | 2020-08-28 | Aurora | South Dakota | 46003 | 42 | 0 |
481890 | 481890 | 2020-08-29 | Aurora | South Dakota | 46003 | 42 | 0 |
485125 | 485125 | 2020-08-30 | Aurora | South Dakota | 46003 | 42 | 0 |
488358 | 488358 | 2020-08-31 | Aurora | South Dakota | 46003 | 42 | 0 |
491591 | 491591 | 2020-09-01 | Aurora | South Dakota | 46003 | 42 | 0 |
494825 | 494825 | 2020-09-02 | Aurora | South Dakota | 46003 | 42 | 0 |
498058 | 498058 | 2020-09-03 | Aurora | South Dakota | 46003 | 42 | 0 |
501292 | 501292 | 2020-09-04 | Aurora | South Dakota | 46003 | 42 | 0 |
504526 | 504526 | 2020-09-05 | Aurora | South Dakota | 46003 | 42 | 0 |
507758 | 507758 | 2020-09-06 | Aurora | South Dakota | 46003 | 42 | 0 |
510991 | 510991 | 2020-09-07 | Aurora | South Dakota | 46003 | 42 | 0 |
514224 | 514224 | 2020-09-08 | Aurora | South Dakota | 46003 | 42 | 0 |
517459 | 517459 | 2020-09-09 | Aurora | South Dakota | 46003 | 42 | 0 |
520695 | 520695 | 2020-09-10 | Aurora | South Dakota | 46003 | 42 | 0 |
523931 | 523931 | 2020-09-11 | Aurora | South Dakota | 46003 | 42 | 0 |
527167 | 527167 | 2020-09-12 | Aurora | South Dakota | 46003 | 42 | 0 |
530404 | 530404 | 2020-09-13 | Aurora | South Dakota | 46003 | 42 | 0 |
533639 | 533639 | 2020-09-14 | Aurora | South Dakota | 46003 | 42 | 0 |
536875 | 536875 | 2020-09-15 | Aurora | South Dakota | 46003 | 42 | 0 |
540112 | 540112 | 2020-09-16 | Aurora | South Dakota | 46003 | 42 | 0 |
543348 | 543348 | 2020-09-17 | Aurora | South Dakota | 46003 | 42 | 0 |
546585 | 546585 | 2020-09-18 | Aurora | South Dakota | 46003 | 44 | 0 |
549824 | 549824 | 2020-09-19 | Aurora | South Dakota | 46003 | 44 | 0 |
553063 | 553063 | 2020-09-20 | Aurora | South Dakota | 46003 | 44 | 0 |
556300 | 556300 | 2020-09-21 | Aurora | South Dakota | 46003 | 44 | 0 |
559537 | 559537 | 2020-09-22 | Aurora | South Dakota | 46003 | 45 | 0 |
562774 | 562774 | 2020-09-23 | Aurora | South Dakota | 46003 | 45 | 0 |
566015 | 566015 | 2020-09-24 | Aurora | South Dakota | 46003 | 46 | 0 |
569256 | 569256 | 2020-09-25 | Aurora | South Dakota | 46003 | 48 | 0 |
572498 | 572498 | 2020-09-26 | Aurora | South Dakota | 46003 | 51 | 0 |
575742 | 575742 | 2020-09-27 | Aurora | South Dakota | 46003 | 54 | 0 |
578983 | 578983 | 2020-09-28 | Aurora | South Dakota | 46003 | 56 | 0 |
582223 | 582223 | 2020-09-29 | Aurora | South Dakota | 46003 | 58 | 0 |
585463 | 585463 | 2020-09-30 | Aurora | South Dakota | 46003 | 59 | 0 |
588703 | 588703 | 2020-10-01 | Aurora | South Dakota | 46003 | 63 | 0 |
591944 | 591944 | 2020-10-02 | Aurora | South Dakota | 46003 | 66 | 0 |
595185 | 595185 | 2020-10-03 | Aurora | South Dakota | 46003 | 68 | 0 |
598428 | 598428 | 2020-10-04 | Aurora | South Dakota | 46003 | 71 | 0 |
601671 | 601671 | 2020-10-05 | Aurora | South Dakota | 46003 | 73 | 0 |
604913 | 604913 | 2020-10-06 | Aurora | South Dakota | 46003 | 77 | 0 |
608156 | 608156 | 2020-10-07 | Aurora | South Dakota | 46003 | 113 | 0 |
611398 | 611398 | 2020-10-08 | Aurora | South Dakota | 46003 | 115 | 0 |
614639 | 614639 | 2020-10-09 | Aurora | South Dakota | 46003 | 116 | 0 |
617881 | 617881 | 2020-10-10 | Aurora | South Dakota | 46003 | 126 | 0 |
621124 | 621124 | 2020-10-11 | Aurora | South Dakota | 46003 | 134 | 0 |
624367 | 624367 | 2020-10-12 | Aurora | South Dakota | 46003 | 136 | 0 |
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);