ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where county = "Sully", deaths = 0 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
731476 | 731476 | 2020-11-14 | Sully | South Dakota | 46119 | 74 | 0 |
728232 | 728232 | 2020-11-13 | Sully | South Dakota | 46119 | 67 | 0 |
724988 | 724988 | 2020-11-12 | Sully | South Dakota | 46119 | 63 | 0 |
721745 | 721745 | 2020-11-11 | Sully | South Dakota | 46119 | 61 | 0 |
718502 | 718502 | 2020-11-10 | Sully | South Dakota | 46119 | 60 | 0 |
715259 | 715259 | 2020-11-09 | Sully | South Dakota | 46119 | 60 | 0 |
712015 | 712015 | 2020-11-08 | Sully | South Dakota | 46119 | 59 | 0 |
708771 | 708771 | 2020-11-07 | Sully | South Dakota | 46119 | 59 | 0 |
705528 | 705528 | 2020-11-06 | Sully | South Dakota | 46119 | 56 | 0 |
702285 | 702285 | 2020-11-05 | Sully | South Dakota | 46119 | 54 | 0 |
699041 | 699041 | 2020-11-04 | Sully | South Dakota | 46119 | 52 | 0 |
695798 | 695798 | 2020-11-03 | Sully | South Dakota | 46119 | 48 | 0 |
692556 | 692556 | 2020-11-02 | Sully | South Dakota | 46119 | 47 | 0 |
689312 | 689312 | 2020-11-01 | Sully | South Dakota | 46119 | 45 | 0 |
686067 | 686067 | 2020-10-31 | Sully | South Dakota | 46119 | 44 | 0 |
682824 | 682824 | 2020-10-30 | Sully | South Dakota | 46119 | 43 | 0 |
679581 | 679581 | 2020-10-29 | Sully | South Dakota | 46119 | 41 | 0 |
676338 | 676338 | 2020-10-28 | Sully | South Dakota | 46119 | 41 | 0 |
673095 | 673095 | 2020-10-27 | Sully | South Dakota | 46119 | 41 | 0 |
669853 | 669853 | 2020-10-26 | Sully | South Dakota | 46119 | 41 | 0 |
666609 | 666609 | 2020-10-25 | Sully | South Dakota | 46119 | 41 | 0 |
663364 | 663364 | 2020-10-24 | Sully | South Dakota | 46119 | 40 | 0 |
660120 | 660120 | 2020-10-23 | Sully | South Dakota | 46119 | 39 | 0 |
656876 | 656876 | 2020-10-22 | Sully | South Dakota | 46119 | 39 | 0 |
653631 | 653631 | 2020-10-21 | Sully | South Dakota | 46119 | 39 | 0 |
650386 | 650386 | 2020-10-20 | Sully | South Dakota | 46119 | 38 | 0 |
647142 | 647142 | 2020-10-19 | Sully | South Dakota | 46119 | 37 | 0 |
643896 | 643896 | 2020-10-18 | Sully | South Dakota | 46119 | 33 | 0 |
640648 | 640648 | 2020-10-17 | Sully | South Dakota | 46119 | 31 | 0 |
637402 | 637402 | 2020-10-16 | Sully | South Dakota | 46119 | 27 | 0 |
634156 | 634156 | 2020-10-15 | Sully | South Dakota | 46119 | 24 | 0 |
630911 | 630911 | 2020-10-14 | Sully | South Dakota | 46119 | 24 | 0 |
627667 | 627667 | 2020-10-13 | Sully | South Dakota | 46119 | 24 | 0 |
624425 | 624425 | 2020-10-12 | Sully | South Dakota | 46119 | 24 | 0 |
621182 | 621182 | 2020-10-11 | Sully | South Dakota | 46119 | 22 | 0 |
617939 | 617939 | 2020-10-10 | Sully | South Dakota | 46119 | 22 | 0 |
614697 | 614697 | 2020-10-09 | Sully | South Dakota | 46119 | 21 | 0 |
611456 | 611456 | 2020-10-08 | Sully | South Dakota | 46119 | 19 | 0 |
608214 | 608214 | 2020-10-07 | Sully | South Dakota | 46119 | 19 | 0 |
604971 | 604971 | 2020-10-06 | Sully | South Dakota | 46119 | 18 | 0 |
601729 | 601729 | 2020-10-05 | Sully | South Dakota | 46119 | 17 | 0 |
598486 | 598486 | 2020-10-04 | Sully | South Dakota | 46119 | 16 | 0 |
595243 | 595243 | 2020-10-03 | Sully | South Dakota | 46119 | 14 | 0 |
592002 | 592002 | 2020-10-02 | Sully | South Dakota | 46119 | 14 | 0 |
588761 | 588761 | 2020-10-01 | Sully | South Dakota | 46119 | 14 | 0 |
585521 | 585521 | 2020-09-30 | Sully | South Dakota | 46119 | 13 | 0 |
582281 | 582281 | 2020-09-29 | Sully | South Dakota | 46119 | 12 | 0 |
579041 | 579041 | 2020-09-28 | Sully | South Dakota | 46119 | 11 | 0 |
575800 | 575800 | 2020-09-27 | Sully | South Dakota | 46119 | 11 | 0 |
572556 | 572556 | 2020-09-26 | Sully | South Dakota | 46119 | 11 | 0 |
569314 | 569314 | 2020-09-25 | Sully | South Dakota | 46119 | 10 | 0 |
566073 | 566073 | 2020-09-24 | Sully | South Dakota | 46119 | 9 | 0 |
562832 | 562832 | 2020-09-23 | Sully | South Dakota | 46119 | 9 | 0 |
559595 | 559595 | 2020-09-22 | Sully | South Dakota | 46119 | 9 | 0 |
556358 | 556358 | 2020-09-21 | Sully | South Dakota | 46119 | 9 | 0 |
553121 | 553121 | 2020-09-20 | Sully | South Dakota | 46119 | 9 | 0 |
549882 | 549882 | 2020-09-19 | Sully | South Dakota | 46119 | 9 | 0 |
546643 | 546643 | 2020-09-18 | Sully | South Dakota | 46119 | 9 | 0 |
543406 | 543406 | 2020-09-17 | Sully | South Dakota | 46119 | 9 | 0 |
540170 | 540170 | 2020-09-16 | Sully | South Dakota | 46119 | 8 | 0 |
536933 | 536933 | 2020-09-15 | Sully | South Dakota | 46119 | 8 | 0 |
533697 | 533697 | 2020-09-14 | Sully | South Dakota | 46119 | 8 | 0 |
530462 | 530462 | 2020-09-13 | Sully | South Dakota | 46119 | 8 | 0 |
527225 | 527225 | 2020-09-12 | Sully | South Dakota | 46119 | 8 | 0 |
523989 | 523989 | 2020-09-11 | Sully | South Dakota | 46119 | 8 | 0 |
520753 | 520753 | 2020-09-10 | Sully | South Dakota | 46119 | 8 | 0 |
517517 | 517517 | 2020-09-09 | Sully | South Dakota | 46119 | 8 | 0 |
514282 | 514282 | 2020-09-08 | Sully | South Dakota | 46119 | 8 | 0 |
511049 | 511049 | 2020-09-07 | Sully | South Dakota | 46119 | 8 | 0 |
507816 | 507816 | 2020-09-06 | Sully | South Dakota | 46119 | 8 | 0 |
504584 | 504584 | 2020-09-05 | Sully | South Dakota | 46119 | 8 | 0 |
501350 | 501350 | 2020-09-04 | Sully | South Dakota | 46119 | 8 | 0 |
498116 | 498116 | 2020-09-03 | Sully | South Dakota | 46119 | 8 | 0 |
494883 | 494883 | 2020-09-02 | Sully | South Dakota | 46119 | 8 | 0 |
491649 | 491649 | 2020-09-01 | Sully | South Dakota | 46119 | 8 | 0 |
488416 | 488416 | 2020-08-31 | Sully | South Dakota | 46119 | 8 | 0 |
485183 | 485183 | 2020-08-30 | Sully | South Dakota | 46119 | 8 | 0 |
481948 | 481948 | 2020-08-29 | Sully | South Dakota | 46119 | 8 | 0 |
478714 | 478714 | 2020-08-28 | Sully | South Dakota | 46119 | 8 | 0 |
475481 | 475481 | 2020-08-27 | Sully | South Dakota | 46119 | 8 | 0 |
472247 | 472247 | 2020-08-26 | Sully | South Dakota | 46119 | 8 | 0 |
469015 | 469015 | 2020-08-25 | Sully | South Dakota | 46119 | 8 | 0 |
465787 | 465787 | 2020-08-24 | Sully | South Dakota | 46119 | 8 | 0 |
462558 | 462558 | 2020-08-23 | Sully | South Dakota | 46119 | 7 | 0 |
459330 | 459330 | 2020-08-22 | Sully | South Dakota | 46119 | 7 | 0 |
456102 | 456102 | 2020-08-21 | Sully | South Dakota | 46119 | 6 | 0 |
452874 | 452874 | 2020-08-20 | Sully | South Dakota | 46119 | 4 | 0 |
449646 | 449646 | 2020-08-19 | Sully | South Dakota | 46119 | 4 | 0 |
446418 | 446418 | 2020-08-18 | Sully | South Dakota | 46119 | 4 | 0 |
443192 | 443192 | 2020-08-17 | Sully | South Dakota | 46119 | 4 | 0 |
439965 | 439965 | 2020-08-16 | Sully | South Dakota | 46119 | 4 | 0 |
436740 | 436740 | 2020-08-15 | Sully | South Dakota | 46119 | 4 | 0 |
433513 | 433513 | 2020-08-14 | Sully | South Dakota | 46119 | 4 | 0 |
430288 | 430288 | 2020-08-13 | Sully | South Dakota | 46119 | 3 | 0 |
427061 | 427061 | 2020-08-12 | Sully | South Dakota | 46119 | 3 | 0 |
423838 | 423838 | 2020-08-11 | Sully | South Dakota | 46119 | 3 | 0 |
420616 | 420616 | 2020-08-10 | Sully | South Dakota | 46119 | 3 | 0 |
417395 | 417395 | 2020-08-09 | Sully | South Dakota | 46119 | 3 | 0 |
414174 | 414174 | 2020-08-08 | Sully | South Dakota | 46119 | 3 | 0 |
410954 | 410954 | 2020-08-07 | Sully | South Dakota | 46119 | 2 | 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);