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 >30
- 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
- …
county >30
- 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
- …
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);