ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46085 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 |
---|---|---|---|---|---|---|---|
922938 | 922938 | 2021-01-12 | Lyman | South Dakota | 46085 | 555 | 9 |
919693 | 919693 | 2021-01-11 | Lyman | South Dakota | 46085 | 553 | 9 |
916448 | 916448 | 2021-01-10 | Lyman | South Dakota | 46085 | 553 | 9 |
913203 | 913203 | 2021-01-09 | Lyman | South Dakota | 46085 | 550 | 9 |
909958 | 909958 | 2021-01-08 | Lyman | South Dakota | 46085 | 548 | 9 |
906713 | 906713 | 2021-01-07 | Lyman | South Dakota | 46085 | 541 | 9 |
903467 | 903467 | 2021-01-06 | Lyman | South Dakota | 46085 | 533 | 9 |
900222 | 900222 | 2021-01-05 | Lyman | South Dakota | 46085 | 530 | 9 |
896977 | 896977 | 2021-01-04 | Lyman | South Dakota | 46085 | 527 | 9 |
893731 | 893731 | 2021-01-03 | Lyman | South Dakota | 46085 | 527 | 9 |
890485 | 890485 | 2021-01-02 | Lyman | South Dakota | 46085 | 524 | 9 |
887238 | 887238 | 2021-01-01 | Lyman | South Dakota | 46085 | 520 | 9 |
883993 | 883993 | 2020-12-31 | Lyman | South Dakota | 46085 | 520 | 9 |
880748 | 880748 | 2020-12-30 | Lyman | South Dakota | 46085 | 517 | 9 |
877503 | 877503 | 2020-12-29 | Lyman | South Dakota | 46085 | 516 | 9 |
874258 | 874258 | 2020-12-28 | Lyman | South Dakota | 46085 | 512 | 9 |
871013 | 871013 | 2020-12-27 | Lyman | South Dakota | 46085 | 512 | 9 |
867768 | 867768 | 2020-12-26 | Lyman | South Dakota | 46085 | 511 | 9 |
864523 | 864523 | 2020-12-25 | Lyman | South Dakota | 46085 | 511 | 9 |
861278 | 861278 | 2020-12-24 | Lyman | South Dakota | 46085 | 511 | 9 |
858033 | 858033 | 2020-12-23 | Lyman | South Dakota | 46085 | 511 | 9 |
854788 | 854788 | 2020-12-22 | Lyman | South Dakota | 46085 | 509 | 9 |
851543 | 851543 | 2020-12-21 | Lyman | South Dakota | 46085 | 509 | 9 |
848298 | 848298 | 2020-12-20 | Lyman | South Dakota | 46085 | 510 | 9 |
845053 | 845053 | 2020-12-19 | Lyman | South Dakota | 46085 | 508 | 9 |
841807 | 841807 | 2020-12-18 | Lyman | South Dakota | 46085 | 507 | 9 |
838562 | 838562 | 2020-12-17 | Lyman | South Dakota | 46085 | 505 | 9 |
835316 | 835316 | 2020-12-16 | Lyman | South Dakota | 46085 | 505 | 9 |
832070 | 832070 | 2020-12-15 | Lyman | South Dakota | 46085 | 498 | 9 |
828823 | 828823 | 2020-12-14 | Lyman | South Dakota | 46085 | 498 | 9 |
825577 | 825577 | 2020-12-13 | Lyman | South Dakota | 46085 | 498 | 9 |
822330 | 822330 | 2020-12-12 | Lyman | South Dakota | 46085 | 495 | 9 |
819084 | 819084 | 2020-12-11 | Lyman | South Dakota | 46085 | 493 | 9 |
815838 | 815838 | 2020-12-10 | Lyman | South Dakota | 46085 | 487 | 9 |
812592 | 812592 | 2020-12-09 | Lyman | South Dakota | 46085 | 485 | 9 |
809348 | 809348 | 2020-12-08 | Lyman | South Dakota | 46085 | 478 | 8 |
806103 | 806103 | 2020-12-07 | Lyman | South Dakota | 46085 | 478 | 8 |
802858 | 802858 | 2020-12-06 | Lyman | South Dakota | 46085 | 477 | 8 |
799613 | 799613 | 2020-12-05 | Lyman | South Dakota | 46085 | 476 | 8 |
796368 | 796368 | 2020-12-04 | Lyman | South Dakota | 46085 | 473 | 8 |
793123 | 793123 | 2020-12-03 | Lyman | South Dakota | 46085 | 470 | 8 |
789878 | 789878 | 2020-12-02 | Lyman | South Dakota | 46085 | 461 | 8 |
786633 | 786633 | 2020-12-01 | Lyman | South Dakota | 46085 | 458 | 8 |
783389 | 783389 | 2020-11-30 | Lyman | South Dakota | 46085 | 455 | 8 |
780144 | 780144 | 2020-11-29 | Lyman | South Dakota | 46085 | 455 | 8 |
776898 | 776898 | 2020-11-28 | Lyman | South Dakota | 46085 | 452 | 8 |
773653 | 773653 | 2020-11-27 | Lyman | South Dakota | 46085 | 445 | 8 |
770408 | 770408 | 2020-11-26 | Lyman | South Dakota | 46085 | 440 | 8 |
767162 | 767162 | 2020-11-25 | Lyman | South Dakota | 46085 | 440 | 8 |
763917 | 763917 | 2020-11-24 | Lyman | South Dakota | 46085 | 433 | 8 |
760672 | 760672 | 2020-11-23 | Lyman | South Dakota | 46085 | 428 | 8 |
757427 | 757427 | 2020-11-22 | Lyman | South Dakota | 46085 | 423 | 8 |
754180 | 754180 | 2020-11-21 | Lyman | South Dakota | 46085 | 422 | 8 |
750934 | 750934 | 2020-11-20 | Lyman | South Dakota | 46085 | 412 | 8 |
747688 | 747688 | 2020-11-19 | Lyman | South Dakota | 46085 | 397 | 8 |
744442 | 744442 | 2020-11-18 | Lyman | South Dakota | 46085 | 389 | 8 |
741195 | 741195 | 2020-11-17 | Lyman | South Dakota | 46085 | 381 | 7 |
737949 | 737949 | 2020-11-16 | Lyman | South Dakota | 46085 | 373 | 7 |
734705 | 734705 | 2020-11-15 | Lyman | South Dakota | 46085 | 372 | 7 |
731459 | 731459 | 2020-11-14 | Lyman | South Dakota | 46085 | 366 | 7 |
728215 | 728215 | 2020-11-13 | Lyman | South Dakota | 46085 | 354 | 7 |
724971 | 724971 | 2020-11-12 | Lyman | South Dakota | 46085 | 349 | 7 |
721728 | 721728 | 2020-11-11 | Lyman | South Dakota | 46085 | 341 | 7 |
718485 | 718485 | 2020-11-10 | Lyman | South Dakota | 46085 | 334 | 7 |
715242 | 715242 | 2020-11-09 | Lyman | South Dakota | 46085 | 334 | 7 |
711998 | 711998 | 2020-11-08 | Lyman | South Dakota | 46085 | 332 | 7 |
708754 | 708754 | 2020-11-07 | Lyman | South Dakota | 46085 | 326 | 7 |
705511 | 705511 | 2020-11-06 | Lyman | South Dakota | 46085 | 321 | 7 |
702268 | 702268 | 2020-11-05 | Lyman | South Dakota | 46085 | 309 | 6 |
699024 | 699024 | 2020-11-04 | Lyman | South Dakota | 46085 | 300 | 6 |
695781 | 695781 | 2020-11-03 | Lyman | South Dakota | 46085 | 296 | 6 |
692539 | 692539 | 2020-11-02 | Lyman | South Dakota | 46085 | 294 | 6 |
689295 | 689295 | 2020-11-01 | Lyman | South Dakota | 46085 | 294 | 6 |
686050 | 686050 | 2020-10-31 | Lyman | South Dakota | 46085 | 286 | 6 |
682807 | 682807 | 2020-10-30 | Lyman | South Dakota | 46085 | 283 | 5 |
679564 | 679564 | 2020-10-29 | Lyman | South Dakota | 46085 | 277 | 5 |
676321 | 676321 | 2020-10-28 | Lyman | South Dakota | 46085 | 267 | 5 |
673078 | 673078 | 2020-10-27 | Lyman | South Dakota | 46085 | 257 | 5 |
669836 | 669836 | 2020-10-26 | Lyman | South Dakota | 46085 | 251 | 5 |
666592 | 666592 | 2020-10-25 | Lyman | South Dakota | 46085 | 247 | 5 |
663347 | 663347 | 2020-10-24 | Lyman | South Dakota | 46085 | 234 | 5 |
660103 | 660103 | 2020-10-23 | Lyman | South Dakota | 46085 | 231 | 5 |
656859 | 656859 | 2020-10-22 | Lyman | South Dakota | 46085 | 220 | 5 |
653614 | 653614 | 2020-10-21 | Lyman | South Dakota | 46085 | 213 | 4 |
650369 | 650369 | 2020-10-20 | Lyman | South Dakota | 46085 | 212 | 4 |
647125 | 647125 | 2020-10-19 | Lyman | South Dakota | 46085 | 210 | 4 |
643879 | 643879 | 2020-10-18 | Lyman | South Dakota | 46085 | 210 | 4 |
640631 | 640631 | 2020-10-17 | Lyman | South Dakota | 46085 | 208 | 4 |
637385 | 637385 | 2020-10-16 | Lyman | South Dakota | 46085 | 207 | 4 |
634139 | 634139 | 2020-10-15 | Lyman | South Dakota | 46085 | 205 | 4 |
630894 | 630894 | 2020-10-14 | Lyman | South Dakota | 46085 | 204 | 4 |
627650 | 627650 | 2020-10-13 | Lyman | South Dakota | 46085 | 203 | 4 |
624408 | 624408 | 2020-10-12 | Lyman | South Dakota | 46085 | 202 | 4 |
621165 | 621165 | 2020-10-11 | Lyman | South Dakota | 46085 | 202 | 4 |
617922 | 617922 | 2020-10-10 | Lyman | South Dakota | 46085 | 200 | 4 |
614680 | 614680 | 2020-10-09 | Lyman | South Dakota | 46085 | 197 | 4 |
611439 | 611439 | 2020-10-08 | Lyman | South Dakota | 46085 | 199 | 4 |
608197 | 608197 | 2020-10-07 | Lyman | South Dakota | 46085 | 193 | 3 |
604954 | 604954 | 2020-10-06 | Lyman | South Dakota | 46085 | 186 | 3 |
601712 | 601712 | 2020-10-05 | Lyman | South Dakota | 46085 | 184 | 3 |
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);