ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 1, fips = 46009 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 |
---|---|---|---|---|---|---|---|
698986 | 698986 | 2020-11-04 | Bon Homme | South Dakota | 46009 | 1102 | 1 |
695743 | 695743 | 2020-11-03 | Bon Homme | South Dakota | 46009 | 1086 | 1 |
692501 | 692501 | 2020-11-02 | Bon Homme | South Dakota | 46009 | 1022 | 1 |
689257 | 689257 | 2020-11-01 | Bon Homme | South Dakota | 46009 | 1016 | 1 |
686012 | 686012 | 2020-10-31 | Bon Homme | South Dakota | 46009 | 994 | 1 |
682769 | 682769 | 2020-10-30 | Bon Homme | South Dakota | 46009 | 969 | 1 |
679526 | 679526 | 2020-10-29 | Bon Homme | South Dakota | 46009 | 950 | 1 |
676283 | 676283 | 2020-10-28 | Bon Homme | South Dakota | 46009 | 920 | 1 |
673040 | 673040 | 2020-10-27 | Bon Homme | South Dakota | 46009 | 882 | 1 |
669798 | 669798 | 2020-10-26 | Bon Homme | South Dakota | 46009 | 773 | 1 |
666554 | 666554 | 2020-10-25 | Bon Homme | South Dakota | 46009 | 633 | 1 |
663309 | 663309 | 2020-10-24 | Bon Homme | South Dakota | 46009 | 493 | 1 |
660065 | 660065 | 2020-10-23 | Bon Homme | South Dakota | 46009 | 485 | 1 |
656821 | 656821 | 2020-10-22 | Bon Homme | South Dakota | 46009 | 354 | 1 |
653576 | 653576 | 2020-10-21 | Bon Homme | South Dakota | 46009 | 332 | 1 |
650331 | 650331 | 2020-10-20 | Bon Homme | South Dakota | 46009 | 323 | 1 |
647087 | 647087 | 2020-10-19 | Bon Homme | South Dakota | 46009 | 317 | 1 |
643841 | 643841 | 2020-10-18 | Bon Homme | South Dakota | 46009 | 310 | 1 |
640593 | 640593 | 2020-10-17 | Bon Homme | South Dakota | 46009 | 297 | 1 |
637347 | 637347 | 2020-10-16 | Bon Homme | South Dakota | 46009 | 200 | 1 |
634101 | 634101 | 2020-10-15 | Bon Homme | South Dakota | 46009 | 191 | 1 |
630856 | 630856 | 2020-10-14 | Bon Homme | South Dakota | 46009 | 182 | 1 |
627612 | 627612 | 2020-10-13 | Bon Homme | South Dakota | 46009 | 167 | 1 |
624370 | 624370 | 2020-10-12 | Bon Homme | South Dakota | 46009 | 164 | 1 |
621127 | 621127 | 2020-10-11 | Bon Homme | South Dakota | 46009 | 156 | 1 |
617884 | 617884 | 2020-10-10 | Bon Homme | South Dakota | 46009 | 151 | 1 |
614642 | 614642 | 2020-10-09 | Bon Homme | South Dakota | 46009 | 140 | 1 |
611401 | 611401 | 2020-10-08 | Bon Homme | South Dakota | 46009 | 125 | 1 |
608159 | 608159 | 2020-10-07 | Bon Homme | South Dakota | 46009 | 123 | 1 |
604916 | 604916 | 2020-10-06 | Bon Homme | South Dakota | 46009 | 115 | 1 |
601674 | 601674 | 2020-10-05 | Bon Homme | South Dakota | 46009 | 114 | 1 |
598431 | 598431 | 2020-10-04 | Bon Homme | South Dakota | 46009 | 114 | 1 |
595188 | 595188 | 2020-10-03 | Bon Homme | South Dakota | 46009 | 108 | 1 |
591947 | 591947 | 2020-10-02 | Bon Homme | South Dakota | 46009 | 98 | 1 |
588706 | 588706 | 2020-10-01 | Bon Homme | South Dakota | 46009 | 94 | 1 |
585466 | 585466 | 2020-09-30 | Bon Homme | South Dakota | 46009 | 91 | 1 |
582226 | 582226 | 2020-09-29 | Bon Homme | South Dakota | 46009 | 85 | 1 |
578986 | 578986 | 2020-09-28 | Bon Homme | South Dakota | 46009 | 83 | 1 |
575745 | 575745 | 2020-09-27 | Bon Homme | South Dakota | 46009 | 84 | 1 |
572501 | 572501 | 2020-09-26 | Bon Homme | South Dakota | 46009 | 81 | 1 |
569259 | 569259 | 2020-09-25 | Bon Homme | South Dakota | 46009 | 81 | 1 |
566018 | 566018 | 2020-09-24 | Bon Homme | South Dakota | 46009 | 80 | 1 |
562777 | 562777 | 2020-09-23 | Bon Homme | South Dakota | 46009 | 79 | 1 |
559540 | 559540 | 2020-09-22 | Bon Homme | South Dakota | 46009 | 77 | 1 |
556303 | 556303 | 2020-09-21 | Bon Homme | South Dakota | 46009 | 76 | 1 |
553066 | 553066 | 2020-09-20 | Bon Homme | South Dakota | 46009 | 75 | 1 |
549827 | 549827 | 2020-09-19 | Bon Homme | South Dakota | 46009 | 75 | 1 |
546588 | 546588 | 2020-09-18 | Bon Homme | South Dakota | 46009 | 74 | 1 |
543351 | 543351 | 2020-09-17 | Bon Homme | South Dakota | 46009 | 72 | 1 |
540115 | 540115 | 2020-09-16 | Bon Homme | South Dakota | 46009 | 69 | 1 |
536878 | 536878 | 2020-09-15 | Bon Homme | South Dakota | 46009 | 67 | 1 |
533642 | 533642 | 2020-09-14 | Bon Homme | South Dakota | 46009 | 67 | 1 |
530407 | 530407 | 2020-09-13 | Bon Homme | South Dakota | 46009 | 65 | 1 |
527170 | 527170 | 2020-09-12 | Bon Homme | South Dakota | 46009 | 63 | 1 |
523934 | 523934 | 2020-09-11 | Bon Homme | South Dakota | 46009 | 61 | 1 |
520698 | 520698 | 2020-09-10 | Bon Homme | South Dakota | 46009 | 60 | 1 |
517462 | 517462 | 2020-09-09 | Bon Homme | South Dakota | 46009 | 59 | 1 |
514227 | 514227 | 2020-09-08 | Bon Homme | South Dakota | 46009 | 59 | 1 |
510994 | 510994 | 2020-09-07 | Bon Homme | South Dakota | 46009 | 59 | 1 |
507761 | 507761 | 2020-09-06 | Bon Homme | South Dakota | 46009 | 58 | 1 |
504529 | 504529 | 2020-09-05 | Bon Homme | South Dakota | 46009 | 57 | 1 |
501295 | 501295 | 2020-09-04 | Bon Homme | South Dakota | 46009 | 54 | 1 |
498061 | 498061 | 2020-09-03 | Bon Homme | South Dakota | 46009 | 54 | 1 |
494828 | 494828 | 2020-09-02 | Bon Homme | South Dakota | 46009 | 53 | 1 |
491594 | 491594 | 2020-09-01 | Bon Homme | South Dakota | 46009 | 52 | 1 |
488361 | 488361 | 2020-08-31 | Bon Homme | South Dakota | 46009 | 52 | 1 |
485128 | 485128 | 2020-08-30 | Bon Homme | South Dakota | 46009 | 51 | 1 |
481893 | 481893 | 2020-08-29 | Bon Homme | South Dakota | 46009 | 50 | 1 |
478659 | 478659 | 2020-08-28 | Bon Homme | South Dakota | 46009 | 49 | 1 |
475426 | 475426 | 2020-08-27 | Bon Homme | South Dakota | 46009 | 47 | 1 |
472192 | 472192 | 2020-08-26 | Bon Homme | South Dakota | 46009 | 39 | 1 |
468960 | 468960 | 2020-08-25 | Bon Homme | South Dakota | 46009 | 39 | 1 |
465732 | 465732 | 2020-08-24 | Bon Homme | South Dakota | 46009 | 39 | 1 |
462503 | 462503 | 2020-08-23 | Bon Homme | South Dakota | 46009 | 38 | 1 |
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);