ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lyman" 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 |
---|---|---|---|---|---|---|---|
1094954 | 1094954 | 2021-03-06 | Lyman | South Dakota | 46085 | 603 | 10 |
1091708 | 1091708 | 2021-03-05 | Lyman | South Dakota | 46085 | 602 | 10 |
1088462 | 1088462 | 2021-03-04 | Lyman | South Dakota | 46085 | 602 | 10 |
1085217 | 1085217 | 2021-03-03 | Lyman | South Dakota | 46085 | 601 | 10 |
1081971 | 1081971 | 2021-03-02 | Lyman | South Dakota | 46085 | 600 | 10 |
1078725 | 1078725 | 2021-03-01 | Lyman | South Dakota | 46085 | 598 | 10 |
1075480 | 1075480 | 2021-02-28 | Lyman | South Dakota | 46085 | 598 | 10 |
1072234 | 1072234 | 2021-02-27 | Lyman | South Dakota | 46085 | 598 | 10 |
1068988 | 1068988 | 2021-02-26 | Lyman | South Dakota | 46085 | 598 | 10 |
1065743 | 1065743 | 2021-02-25 | Lyman | South Dakota | 46085 | 598 | 10 |
1062498 | 1062498 | 2021-02-24 | Lyman | South Dakota | 46085 | 597 | 10 |
1059253 | 1059253 | 2021-02-23 | Lyman | South Dakota | 46085 | 597 | 10 |
1056007 | 1056007 | 2021-02-22 | Lyman | South Dakota | 46085 | 597 | 10 |
1052761 | 1052761 | 2021-02-21 | Lyman | South Dakota | 46085 | 597 | 10 |
1049514 | 1049514 | 2021-02-20 | Lyman | South Dakota | 46085 | 597 | 10 |
1046267 | 1046267 | 2021-02-19 | Lyman | South Dakota | 46085 | 597 | 10 |
1043022 | 1043022 | 2021-02-18 | Lyman | South Dakota | 46085 | 597 | 10 |
1039777 | 1039777 | 2021-02-17 | Lyman | South Dakota | 46085 | 598 | 10 |
1036532 | 1036532 | 2021-02-16 | Lyman | South Dakota | 46085 | 598 | 10 |
1033287 | 1033287 | 2021-02-15 | Lyman | South Dakota | 46085 | 594 | 10 |
1030041 | 1030041 | 2021-02-14 | Lyman | South Dakota | 46085 | 594 | 10 |
1026794 | 1026794 | 2021-02-13 | Lyman | South Dakota | 46085 | 594 | 10 |
1023549 | 1023549 | 2021-02-12 | Lyman | South Dakota | 46085 | 593 | 10 |
1020304 | 1020304 | 2021-02-11 | Lyman | South Dakota | 46085 | 593 | 10 |
1017059 | 1017059 | 2021-02-10 | Lyman | South Dakota | 46085 | 592 | 10 |
1013814 | 1013814 | 2021-02-09 | Lyman | South Dakota | 46085 | 591 | 10 |
1010569 | 1010569 | 2021-02-08 | Lyman | South Dakota | 46085 | 591 | 10 |
1007323 | 1007323 | 2021-02-07 | Lyman | South Dakota | 46085 | 591 | 10 |
1004077 | 1004077 | 2021-02-06 | Lyman | South Dakota | 46085 | 590 | 10 |
1000831 | 1000831 | 2021-02-05 | Lyman | South Dakota | 46085 | 590 | 10 |
997585 | 997585 | 2021-02-04 | Lyman | South Dakota | 46085 | 590 | 10 |
994339 | 994339 | 2021-02-03 | Lyman | South Dakota | 46085 | 590 | 10 |
991093 | 991093 | 2021-02-02 | Lyman | South Dakota | 46085 | 590 | 10 |
987847 | 987847 | 2021-02-01 | Lyman | South Dakota | 46085 | 590 | 10 |
984600 | 984600 | 2021-01-31 | Lyman | South Dakota | 46085 | 590 | 10 |
981353 | 981353 | 2021-01-30 | Lyman | South Dakota | 46085 | 590 | 10 |
978107 | 978107 | 2021-01-29 | Lyman | South Dakota | 46085 | 588 | 10 |
974862 | 974862 | 2021-01-28 | Lyman | South Dakota | 46085 | 588 | 10 |
971617 | 971617 | 2021-01-27 | Lyman | South Dakota | 46085 | 588 | 10 |
968372 | 968372 | 2021-01-26 | Lyman | South Dakota | 46085 | 587 | 10 |
965128 | 965128 | 2021-01-25 | Lyman | South Dakota | 46085 | 587 | 10 |
961883 | 961883 | 2021-01-24 | Lyman | South Dakota | 46085 | 587 | 10 |
958638 | 958638 | 2021-01-23 | Lyman | South Dakota | 46085 | 585 | 10 |
955392 | 955392 | 2021-01-22 | Lyman | South Dakota | 46085 | 584 | 10 |
952147 | 952147 | 2021-01-21 | Lyman | South Dakota | 46085 | 584 | 10 |
948902 | 948902 | 2021-01-20 | Lyman | South Dakota | 46085 | 575 | 10 |
945656 | 945656 | 2021-01-19 | Lyman | South Dakota | 46085 | 574 | 10 |
942409 | 942409 | 2021-01-18 | Lyman | South Dakota | 46085 | 574 | 10 |
939164 | 939164 | 2021-01-17 | Lyman | South Dakota | 46085 | 573 | 9 |
935919 | 935919 | 2021-01-16 | Lyman | South Dakota | 46085 | 572 | 9 |
932674 | 932674 | 2021-01-15 | Lyman | South Dakota | 46085 | 564 | 9 |
929429 | 929429 | 2021-01-14 | Lyman | South Dakota | 46085 | 560 | 9 |
926184 | 926184 | 2021-01-13 | Lyman | South Dakota | 46085 | 557 | 9 |
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 |
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);