ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where county = "Hand", deaths = 1 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 |
---|---|---|---|---|---|---|---|
822317 | 822317 | 2020-12-12 | Hand | South Dakota | 46059 | 299 | 1 |
819071 | 819071 | 2020-12-11 | Hand | South Dakota | 46059 | 299 | 1 |
815825 | 815825 | 2020-12-10 | Hand | South Dakota | 46059 | 298 | 1 |
812579 | 812579 | 2020-12-09 | Hand | South Dakota | 46059 | 297 | 1 |
809335 | 809335 | 2020-12-08 | Hand | South Dakota | 46059 | 296 | 1 |
806090 | 806090 | 2020-12-07 | Hand | South Dakota | 46059 | 295 | 1 |
802845 | 802845 | 2020-12-06 | Hand | South Dakota | 46059 | 294 | 1 |
799600 | 799600 | 2020-12-05 | Hand | South Dakota | 46059 | 294 | 1 |
796355 | 796355 | 2020-12-04 | Hand | South Dakota | 46059 | 291 | 1 |
793110 | 793110 | 2020-12-03 | Hand | South Dakota | 46059 | 290 | 1 |
789865 | 789865 | 2020-12-02 | Hand | South Dakota | 46059 | 290 | 1 |
786620 | 786620 | 2020-12-01 | Hand | South Dakota | 46059 | 283 | 1 |
783376 | 783376 | 2020-11-30 | Hand | South Dakota | 46059 | 283 | 1 |
780131 | 780131 | 2020-11-29 | Hand | South Dakota | 46059 | 282 | 1 |
776885 | 776885 | 2020-11-28 | Hand | South Dakota | 46059 | 281 | 1 |
773640 | 773640 | 2020-11-27 | Hand | South Dakota | 46059 | 280 | 1 |
770395 | 770395 | 2020-11-26 | Hand | South Dakota | 46059 | 277 | 1 |
767149 | 767149 | 2020-11-25 | Hand | South Dakota | 46059 | 277 | 1 |
763904 | 763904 | 2020-11-24 | Hand | South Dakota | 46059 | 274 | 1 |
760659 | 760659 | 2020-11-23 | Hand | South Dakota | 46059 | 272 | 1 |
757414 | 757414 | 2020-11-22 | Hand | South Dakota | 46059 | 271 | 1 |
754167 | 754167 | 2020-11-21 | Hand | South Dakota | 46059 | 264 | 1 |
750921 | 750921 | 2020-11-20 | Hand | South Dakota | 46059 | 261 | 1 |
747675 | 747675 | 2020-11-19 | Hand | South Dakota | 46059 | 256 | 1 |
744429 | 744429 | 2020-11-18 | Hand | South Dakota | 46059 | 254 | 1 |
741182 | 741182 | 2020-11-17 | Hand | South Dakota | 46059 | 252 | 1 |
737936 | 737936 | 2020-11-16 | Hand | South Dakota | 46059 | 243 | 1 |
734692 | 734692 | 2020-11-15 | Hand | South Dakota | 46059 | 237 | 1 |
731446 | 731446 | 2020-11-14 | Hand | South Dakota | 46059 | 231 | 1 |
728202 | 728202 | 2020-11-13 | Hand | South Dakota | 46059 | 221 | 1 |
724958 | 724958 | 2020-11-12 | Hand | South Dakota | 46059 | 214 | 1 |
721715 | 721715 | 2020-11-11 | Hand | South Dakota | 46059 | 209 | 1 |
718472 | 718472 | 2020-11-10 | Hand | South Dakota | 46059 | 206 | 1 |
715229 | 715229 | 2020-11-09 | Hand | South Dakota | 46059 | 202 | 1 |
711985 | 711985 | 2020-11-08 | Hand | South Dakota | 46059 | 200 | 1 |
708741 | 708741 | 2020-11-07 | Hand | South Dakota | 46059 | 192 | 1 |
705498 | 705498 | 2020-11-06 | Hand | South Dakota | 46059 | 186 | 1 |
702255 | 702255 | 2020-11-05 | Hand | South Dakota | 46059 | 176 | 1 |
699011 | 699011 | 2020-11-04 | Hand | South Dakota | 46059 | 163 | 1 |
695768 | 695768 | 2020-11-03 | Hand | South Dakota | 46059 | 158 | 1 |
692526 | 692526 | 2020-11-02 | Hand | South Dakota | 46059 | 155 | 1 |
689282 | 689282 | 2020-11-01 | Hand | South Dakota | 46059 | 150 | 1 |
686037 | 686037 | 2020-10-31 | Hand | South Dakota | 46059 | 146 | 1 |
682794 | 682794 | 2020-10-30 | Hand | South Dakota | 46059 | 137 | 1 |
679551 | 679551 | 2020-10-29 | Hand | South Dakota | 46059 | 131 | 1 |
676308 | 676308 | 2020-10-28 | Hand | South Dakota | 46059 | 121 | 1 |
673065 | 673065 | 2020-10-27 | Hand | South Dakota | 46059 | 119 | 1 |
669823 | 669823 | 2020-10-26 | Hand | South Dakota | 46059 | 118 | 1 |
666579 | 666579 | 2020-10-25 | Hand | South Dakota | 46059 | 113 | 1 |
663334 | 663334 | 2020-10-24 | Hand | South Dakota | 46059 | 108 | 1 |
660090 | 660090 | 2020-10-23 | Hand | South Dakota | 46059 | 103 | 1 |
656846 | 656846 | 2020-10-22 | Hand | South Dakota | 46059 | 95 | 1 |
653601 | 653601 | 2020-10-21 | Hand | South Dakota | 46059 | 93 | 1 |
650356 | 650356 | 2020-10-20 | Hand | South Dakota | 46059 | 90 | 1 |
647112 | 647112 | 2020-10-19 | Hand | South Dakota | 46059 | 89 | 1 |
643866 | 643866 | 2020-10-18 | Hand | South Dakota | 46059 | 89 | 1 |
640618 | 640618 | 2020-10-17 | Hand | South Dakota | 46059 | 87 | 1 |
637372 | 637372 | 2020-10-16 | Hand | South Dakota | 46059 | 84 | 1 |
634126 | 634126 | 2020-10-15 | Hand | South Dakota | 46059 | 81 | 1 |
630881 | 630881 | 2020-10-14 | Hand | South Dakota | 46059 | 80 | 1 |
627637 | 627637 | 2020-10-13 | Hand | South Dakota | 46059 | 78 | 1 |
624395 | 624395 | 2020-10-12 | Hand | South Dakota | 46059 | 78 | 1 |
621152 | 621152 | 2020-10-11 | Hand | South Dakota | 46059 | 75 | 1 |
617909 | 617909 | 2020-10-10 | Hand | South Dakota | 46059 | 74 | 1 |
614667 | 614667 | 2020-10-09 | Hand | South Dakota | 46059 | 72 | 1 |
611426 | 611426 | 2020-10-08 | Hand | South Dakota | 46059 | 68 | 1 |
608184 | 608184 | 2020-10-07 | Hand | South Dakota | 46059 | 62 | 1 |
604941 | 604941 | 2020-10-06 | Hand | South Dakota | 46059 | 61 | 1 |
601699 | 601699 | 2020-10-05 | Hand | South Dakota | 46059 | 60 | 1 |
598456 | 598456 | 2020-10-04 | Hand | South Dakota | 46059 | 58 | 1 |
595213 | 595213 | 2020-10-03 | Hand | South Dakota | 46059 | 56 | 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);