ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
238 rows where county = "Hamlin", 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 |
---|---|---|---|---|---|---|---|
750920 | 750920 | 2020-11-20 | Hamlin | South Dakota | 46057 | 403 | 0 |
747674 | 747674 | 2020-11-19 | Hamlin | South Dakota | 46057 | 383 | 0 |
744428 | 744428 | 2020-11-18 | Hamlin | South Dakota | 46057 | 372 | 0 |
741181 | 741181 | 2020-11-17 | Hamlin | South Dakota | 46057 | 345 | 0 |
737935 | 737935 | 2020-11-16 | Hamlin | South Dakota | 46057 | 337 | 0 |
734691 | 734691 | 2020-11-15 | Hamlin | South Dakota | 46057 | 331 | 0 |
731445 | 731445 | 2020-11-14 | Hamlin | South Dakota | 46057 | 320 | 0 |
728201 | 728201 | 2020-11-13 | Hamlin | South Dakota | 46057 | 309 | 0 |
724957 | 724957 | 2020-11-12 | Hamlin | South Dakota | 46057 | 296 | 0 |
721714 | 721714 | 2020-11-11 | Hamlin | South Dakota | 46057 | 285 | 0 |
718471 | 718471 | 2020-11-10 | Hamlin | South Dakota | 46057 | 277 | 0 |
715228 | 715228 | 2020-11-09 | Hamlin | South Dakota | 46057 | 276 | 0 |
711984 | 711984 | 2020-11-08 | Hamlin | South Dakota | 46057 | 272 | 0 |
708740 | 708740 | 2020-11-07 | Hamlin | South Dakota | 46057 | 264 | 0 |
705497 | 705497 | 2020-11-06 | Hamlin | South Dakota | 46057 | 260 | 0 |
702254 | 702254 | 2020-11-05 | Hamlin | South Dakota | 46057 | 247 | 0 |
699010 | 699010 | 2020-11-04 | Hamlin | South Dakota | 46057 | 236 | 0 |
695767 | 695767 | 2020-11-03 | Hamlin | South Dakota | 46057 | 234 | 0 |
692525 | 692525 | 2020-11-02 | Hamlin | South Dakota | 46057 | 230 | 0 |
689281 | 689281 | 2020-11-01 | Hamlin | South Dakota | 46057 | 225 | 0 |
686036 | 686036 | 2020-10-31 | Hamlin | South Dakota | 46057 | 211 | 0 |
682793 | 682793 | 2020-10-30 | Hamlin | South Dakota | 46057 | 204 | 0 |
679550 | 679550 | 2020-10-29 | Hamlin | South Dakota | 46057 | 199 | 0 |
676307 | 676307 | 2020-10-28 | Hamlin | South Dakota | 46057 | 198 | 0 |
673064 | 673064 | 2020-10-27 | Hamlin | South Dakota | 46057 | 192 | 0 |
669822 | 669822 | 2020-10-26 | Hamlin | South Dakota | 46057 | 191 | 0 |
666578 | 666578 | 2020-10-25 | Hamlin | South Dakota | 46057 | 187 | 0 |
663333 | 663333 | 2020-10-24 | Hamlin | South Dakota | 46057 | 179 | 0 |
660089 | 660089 | 2020-10-23 | Hamlin | South Dakota | 46057 | 176 | 0 |
656845 | 656845 | 2020-10-22 | Hamlin | South Dakota | 46057 | 173 | 0 |
653600 | 653600 | 2020-10-21 | Hamlin | South Dakota | 46057 | 166 | 0 |
650355 | 650355 | 2020-10-20 | Hamlin | South Dakota | 46057 | 162 | 0 |
647111 | 647111 | 2020-10-19 | Hamlin | South Dakota | 46057 | 159 | 0 |
643865 | 643865 | 2020-10-18 | Hamlin | South Dakota | 46057 | 157 | 0 |
640617 | 640617 | 2020-10-17 | Hamlin | South Dakota | 46057 | 153 | 0 |
637371 | 637371 | 2020-10-16 | Hamlin | South Dakota | 46057 | 147 | 0 |
634125 | 634125 | 2020-10-15 | Hamlin | South Dakota | 46057 | 144 | 0 |
630880 | 630880 | 2020-10-14 | Hamlin | South Dakota | 46057 | 139 | 0 |
627636 | 627636 | 2020-10-13 | Hamlin | South Dakota | 46057 | 131 | 0 |
624394 | 624394 | 2020-10-12 | Hamlin | South Dakota | 46057 | 131 | 0 |
621151 | 621151 | 2020-10-11 | Hamlin | South Dakota | 46057 | 129 | 0 |
617908 | 617908 | 2020-10-10 | Hamlin | South Dakota | 46057 | 123 | 0 |
614666 | 614666 | 2020-10-09 | Hamlin | South Dakota | 46057 | 120 | 0 |
611425 | 611425 | 2020-10-08 | Hamlin | South Dakota | 46057 | 117 | 0 |
608183 | 608183 | 2020-10-07 | Hamlin | South Dakota | 46057 | 115 | 0 |
604940 | 604940 | 2020-10-06 | Hamlin | South Dakota | 46057 | 110 | 0 |
601698 | 601698 | 2020-10-05 | Hamlin | South Dakota | 46057 | 109 | 0 |
598455 | 598455 | 2020-10-04 | Hamlin | South Dakota | 46057 | 108 | 0 |
595212 | 595212 | 2020-10-03 | Hamlin | South Dakota | 46057 | 108 | 0 |
591971 | 591971 | 2020-10-02 | Hamlin | South Dakota | 46057 | 106 | 0 |
588730 | 588730 | 2020-10-01 | Hamlin | South Dakota | 46057 | 104 | 0 |
585490 | 585490 | 2020-09-30 | Hamlin | South Dakota | 46057 | 101 | 0 |
582250 | 582250 | 2020-09-29 | Hamlin | South Dakota | 46057 | 100 | 0 |
579010 | 579010 | 2020-09-28 | Hamlin | South Dakota | 46057 | 99 | 0 |
575769 | 575769 | 2020-09-27 | Hamlin | South Dakota | 46057 | 99 | 0 |
572525 | 572525 | 2020-09-26 | Hamlin | South Dakota | 46057 | 97 | 0 |
569283 | 569283 | 2020-09-25 | Hamlin | South Dakota | 46057 | 90 | 0 |
566042 | 566042 | 2020-09-24 | Hamlin | South Dakota | 46057 | 86 | 0 |
562801 | 562801 | 2020-09-23 | Hamlin | South Dakota | 46057 | 80 | 0 |
559564 | 559564 | 2020-09-22 | Hamlin | South Dakota | 46057 | 80 | 0 |
556327 | 556327 | 2020-09-21 | Hamlin | South Dakota | 46057 | 80 | 0 |
553090 | 553090 | 2020-09-20 | Hamlin | South Dakota | 46057 | 80 | 0 |
549851 | 549851 | 2020-09-19 | Hamlin | South Dakota | 46057 | 79 | 0 |
546612 | 546612 | 2020-09-18 | Hamlin | South Dakota | 46057 | 78 | 0 |
543375 | 543375 | 2020-09-17 | Hamlin | South Dakota | 46057 | 77 | 0 |
540139 | 540139 | 2020-09-16 | Hamlin | South Dakota | 46057 | 77 | 0 |
536902 | 536902 | 2020-09-15 | Hamlin | South Dakota | 46057 | 77 | 0 |
533666 | 533666 | 2020-09-14 | Hamlin | South Dakota | 46057 | 76 | 0 |
530431 | 530431 | 2020-09-13 | Hamlin | South Dakota | 46057 | 76 | 0 |
527194 | 527194 | 2020-09-12 | Hamlin | South Dakota | 46057 | 76 | 0 |
523958 | 523958 | 2020-09-11 | Hamlin | South Dakota | 46057 | 75 | 0 |
520722 | 520722 | 2020-09-10 | Hamlin | South Dakota | 46057 | 72 | 0 |
517486 | 517486 | 2020-09-09 | Hamlin | South Dakota | 46057 | 72 | 0 |
514251 | 514251 | 2020-09-08 | Hamlin | South Dakota | 46057 | 70 | 0 |
511018 | 511018 | 2020-09-07 | Hamlin | South Dakota | 46057 | 69 | 0 |
507785 | 507785 | 2020-09-06 | Hamlin | South Dakota | 46057 | 68 | 0 |
504553 | 504553 | 2020-09-05 | Hamlin | South Dakota | 46057 | 65 | 0 |
501319 | 501319 | 2020-09-04 | Hamlin | South Dakota | 46057 | 65 | 0 |
498085 | 498085 | 2020-09-03 | Hamlin | South Dakota | 46057 | 63 | 0 |
494852 | 494852 | 2020-09-02 | Hamlin | South Dakota | 46057 | 60 | 0 |
491618 | 491618 | 2020-09-01 | Hamlin | South Dakota | 46057 | 58 | 0 |
488385 | 488385 | 2020-08-31 | Hamlin | South Dakota | 46057 | 57 | 0 |
485152 | 485152 | 2020-08-30 | Hamlin | South Dakota | 46057 | 54 | 0 |
481917 | 481917 | 2020-08-29 | Hamlin | South Dakota | 46057 | 53 | 0 |
478683 | 478683 | 2020-08-28 | Hamlin | South Dakota | 46057 | 49 | 0 |
475450 | 475450 | 2020-08-27 | Hamlin | South Dakota | 46057 | 48 | 0 |
472216 | 472216 | 2020-08-26 | Hamlin | South Dakota | 46057 | 44 | 0 |
468984 | 468984 | 2020-08-25 | Hamlin | South Dakota | 46057 | 42 | 0 |
465756 | 465756 | 2020-08-24 | Hamlin | South Dakota | 46057 | 42 | 0 |
462527 | 462527 | 2020-08-23 | Hamlin | South Dakota | 46057 | 41 | 0 |
459299 | 459299 | 2020-08-22 | Hamlin | South Dakota | 46057 | 40 | 0 |
456071 | 456071 | 2020-08-21 | Hamlin | South Dakota | 46057 | 36 | 0 |
452843 | 452843 | 2020-08-20 | Hamlin | South Dakota | 46057 | 34 | 0 |
449615 | 449615 | 2020-08-19 | Hamlin | South Dakota | 46057 | 34 | 0 |
446387 | 446387 | 2020-08-18 | Hamlin | South Dakota | 46057 | 32 | 0 |
443161 | 443161 | 2020-08-17 | Hamlin | South Dakota | 46057 | 31 | 0 |
439934 | 439934 | 2020-08-16 | Hamlin | South Dakota | 46057 | 30 | 0 |
436709 | 436709 | 2020-08-15 | Hamlin | South Dakota | 46057 | 27 | 0 |
433482 | 433482 | 2020-08-14 | Hamlin | South Dakota | 46057 | 27 | 0 |
430257 | 430257 | 2020-08-13 | Hamlin | South Dakota | 46057 | 25 | 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);