ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46057 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922924 | 922924 | 2021-01-12 | Hamlin | South Dakota | 46057 | 635 | 37 |
919679 | 919679 | 2021-01-11 | Hamlin | South Dakota | 46057 | 631 | 37 |
916434 | 916434 | 2021-01-10 | Hamlin | South Dakota | 46057 | 631 | 37 |
913189 | 913189 | 2021-01-09 | Hamlin | South Dakota | 46057 | 629 | 36 |
909944 | 909944 | 2021-01-08 | Hamlin | South Dakota | 46057 | 627 | 36 |
906699 | 906699 | 2021-01-07 | Hamlin | South Dakota | 46057 | 624 | 36 |
903453 | 903453 | 2021-01-06 | Hamlin | South Dakota | 46057 | 619 | 36 |
900208 | 900208 | 2021-01-05 | Hamlin | South Dakota | 46057 | 614 | 36 |
896963 | 896963 | 2021-01-04 | Hamlin | South Dakota | 46057 | 609 | 36 |
893717 | 893717 | 2021-01-03 | Hamlin | South Dakota | 46057 | 609 | 36 |
890471 | 890471 | 2021-01-02 | Hamlin | South Dakota | 46057 | 608 | 36 |
887224 | 887224 | 2021-01-01 | Hamlin | South Dakota | 46057 | 606 | 34 |
883979 | 883979 | 2020-12-31 | Hamlin | South Dakota | 46057 | 606 | 34 |
880734 | 880734 | 2020-12-30 | Hamlin | South Dakota | 46057 | 603 | 34 |
877489 | 877489 | 2020-12-29 | Hamlin | South Dakota | 46057 | 601 | 32 |
874244 | 874244 | 2020-12-28 | Hamlin | South Dakota | 46057 | 599 | 32 |
870999 | 870999 | 2020-12-27 | Hamlin | South Dakota | 46057 | 597 | 32 |
867754 | 867754 | 2020-12-26 | Hamlin | South Dakota | 46057 | 593 | 32 |
864509 | 864509 | 2020-12-25 | Hamlin | South Dakota | 46057 | 589 | 32 |
861264 | 861264 | 2020-12-24 | Hamlin | South Dakota | 46057 | 589 | 32 |
858019 | 858019 | 2020-12-23 | Hamlin | South Dakota | 46057 | 583 | 32 |
854774 | 854774 | 2020-12-22 | Hamlin | South Dakota | 46057 | 580 | 32 |
851529 | 851529 | 2020-12-21 | Hamlin | South Dakota | 46057 | 577 | 32 |
848284 | 848284 | 2020-12-20 | Hamlin | South Dakota | 46057 | 575 | 32 |
845039 | 845039 | 2020-12-19 | Hamlin | South Dakota | 46057 | 574 | 32 |
841793 | 841793 | 2020-12-18 | Hamlin | South Dakota | 46057 | 570 | 32 |
838548 | 838548 | 2020-12-17 | Hamlin | South Dakota | 46057 | 567 | 30 |
835302 | 835302 | 2020-12-16 | Hamlin | South Dakota | 46057 | 564 | 29 |
832056 | 832056 | 2020-12-15 | Hamlin | South Dakota | 46057 | 559 | 28 |
828809 | 828809 | 2020-12-14 | Hamlin | South Dakota | 46057 | 553 | 28 |
825563 | 825563 | 2020-12-13 | Hamlin | South Dakota | 46057 | 552 | 28 |
822316 | 822316 | 2020-12-12 | Hamlin | South Dakota | 46057 | 550 | 27 |
819070 | 819070 | 2020-12-11 | Hamlin | South Dakota | 46057 | 547 | 27 |
815824 | 815824 | 2020-12-10 | Hamlin | South Dakota | 46057 | 541 | 26 |
812578 | 812578 | 2020-12-09 | Hamlin | South Dakota | 46057 | 533 | 21 |
809334 | 809334 | 2020-12-08 | Hamlin | South Dakota | 46057 | 530 | 19 |
806089 | 806089 | 2020-12-07 | Hamlin | South Dakota | 46057 | 527 | 19 |
802844 | 802844 | 2020-12-06 | Hamlin | South Dakota | 46057 | 525 | 19 |
799599 | 799599 | 2020-12-05 | Hamlin | South Dakota | 46057 | 518 | 17 |
796354 | 796354 | 2020-12-04 | Hamlin | South Dakota | 46057 | 510 | 17 |
793109 | 793109 | 2020-12-03 | Hamlin | South Dakota | 46057 | 503 | 17 |
789864 | 789864 | 2020-12-02 | Hamlin | South Dakota | 46057 | 491 | 9 |
786619 | 786619 | 2020-12-01 | Hamlin | South Dakota | 46057 | 484 | 4 |
783375 | 783375 | 2020-11-30 | Hamlin | South Dakota | 46057 | 481 | 4 |
780130 | 780130 | 2020-11-29 | Hamlin | South Dakota | 46057 | 479 | 4 |
776884 | 776884 | 2020-11-28 | Hamlin | South Dakota | 46057 | 476 | 4 |
773639 | 773639 | 2020-11-27 | Hamlin | South Dakota | 46057 | 458 | 3 |
770394 | 770394 | 2020-11-26 | Hamlin | South Dakota | 46057 | 446 | 3 |
767148 | 767148 | 2020-11-25 | Hamlin | South Dakota | 46057 | 446 | 3 |
763903 | 763903 | 2020-11-24 | Hamlin | South Dakota | 46057 | 446 | 2 |
760658 | 760658 | 2020-11-23 | Hamlin | South Dakota | 46057 | 435 | 2 |
757413 | 757413 | 2020-11-22 | Hamlin | South Dakota | 46057 | 430 | 2 |
754166 | 754166 | 2020-11-21 | Hamlin | South Dakota | 46057 | 427 | 1 |
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 |
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);