ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Union" 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 |
---|---|---|---|---|---|---|---|
922959 | 922959 | 2021-01-12 | Union | South Dakota | 46127 | 1737 | 30 |
919714 | 919714 | 2021-01-11 | Union | South Dakota | 46127 | 1730 | 30 |
916469 | 916469 | 2021-01-10 | Union | South Dakota | 46127 | 1721 | 30 |
913224 | 913224 | 2021-01-09 | Union | South Dakota | 46127 | 1688 | 30 |
909979 | 909979 | 2021-01-08 | Union | South Dakota | 46127 | 1678 | 30 |
906734 | 906734 | 2021-01-07 | Union | South Dakota | 46127 | 1660 | 30 |
903488 | 903488 | 2021-01-06 | Union | South Dakota | 46127 | 1655 | 30 |
900243 | 900243 | 2021-01-05 | Union | South Dakota | 46127 | 1644 | 30 |
896998 | 896998 | 2021-01-04 | Union | South Dakota | 46127 | 1641 | 30 |
893752 | 893752 | 2021-01-03 | Union | South Dakota | 46127 | 1638 | 30 |
890506 | 890506 | 2021-01-02 | Union | South Dakota | 46127 | 1616 | 30 |
887259 | 887259 | 2021-01-01 | Union | South Dakota | 46127 | 1608 | 30 |
884014 | 884014 | 2020-12-31 | Union | South Dakota | 46127 | 1608 | 30 |
880769 | 880769 | 2020-12-30 | Union | South Dakota | 46127 | 1593 | 30 |
877524 | 877524 | 2020-12-29 | Union | South Dakota | 46127 | 1590 | 30 |
874279 | 874279 | 2020-12-28 | Union | South Dakota | 46127 | 1581 | 30 |
871034 | 871034 | 2020-12-27 | Union | South Dakota | 46127 | 1581 | 30 |
867789 | 867789 | 2020-12-26 | Union | South Dakota | 46127 | 1566 | 30 |
864544 | 864544 | 2020-12-25 | Union | South Dakota | 46127 | 1556 | 30 |
861299 | 861299 | 2020-12-24 | Union | South Dakota | 46127 | 1556 | 30 |
858054 | 858054 | 2020-12-23 | Union | South Dakota | 46127 | 1540 | 30 |
854809 | 854809 | 2020-12-22 | Union | South Dakota | 46127 | 1526 | 30 |
851564 | 851564 | 2020-12-21 | Union | South Dakota | 46127 | 1518 | 30 |
848319 | 848319 | 2020-12-20 | Union | South Dakota | 46127 | 1512 | 30 |
845074 | 845074 | 2020-12-19 | Union | South Dakota | 46127 | 1494 | 28 |
841828 | 841828 | 2020-12-18 | Union | South Dakota | 46127 | 1481 | 28 |
838583 | 838583 | 2020-12-17 | Union | South Dakota | 46127 | 1470 | 27 |
835337 | 835337 | 2020-12-16 | Union | South Dakota | 46127 | 1453 | 27 |
832091 | 832091 | 2020-12-15 | Union | South Dakota | 46127 | 1440 | 25 |
828844 | 828844 | 2020-12-14 | Union | South Dakota | 46127 | 1436 | 25 |
825598 | 825598 | 2020-12-13 | Union | South Dakota | 46127 | 1431 | 25 |
822351 | 822351 | 2020-12-12 | Union | South Dakota | 46127 | 1405 | 25 |
819105 | 819105 | 2020-12-11 | Union | South Dakota | 46127 | 1391 | 25 |
815859 | 815859 | 2020-12-10 | Union | South Dakota | 46127 | 1375 | 25 |
812613 | 812613 | 2020-12-09 | Union | South Dakota | 46127 | 1358 | 25 |
809369 | 809369 | 2020-12-08 | Union | South Dakota | 46127 | 1345 | 25 |
806124 | 806124 | 2020-12-07 | Union | South Dakota | 46127 | 1338 | 25 |
802879 | 802879 | 2020-12-06 | Union | South Dakota | 46127 | 1315 | 25 |
799634 | 799634 | 2020-12-05 | Union | South Dakota | 46127 | 1300 | 25 |
796389 | 796389 | 2020-12-04 | Union | South Dakota | 46127 | 1295 | 25 |
793144 | 793144 | 2020-12-03 | Union | South Dakota | 46127 | 1281 | 25 |
789899 | 789899 | 2020-12-02 | Union | South Dakota | 46127 | 1269 | 25 |
786654 | 786654 | 2020-12-01 | Union | South Dakota | 46127 | 1259 | 25 |
783410 | 783410 | 2020-11-30 | Union | South Dakota | 46127 | 1252 | 25 |
780165 | 780165 | 2020-11-29 | Union | South Dakota | 46127 | 1248 | 25 |
776919 | 776919 | 2020-11-28 | Union | South Dakota | 46127 | 1237 | 25 |
773674 | 773674 | 2020-11-27 | Union | South Dakota | 46127 | 1217 | 23 |
770429 | 770429 | 2020-11-26 | Union | South Dakota | 46127 | 1194 | 23 |
767183 | 767183 | 2020-11-25 | Union | South Dakota | 46127 | 1194 | 23 |
763938 | 763938 | 2020-11-24 | Union | South Dakota | 46127 | 1183 | 23 |
760693 | 760693 | 2020-11-23 | Union | South Dakota | 46127 | 1171 | 23 |
757448 | 757448 | 2020-11-22 | Union | South Dakota | 46127 | 1157 | 23 |
754201 | 754201 | 2020-11-21 | Union | South Dakota | 46127 | 1148 | 23 |
750955 | 750955 | 2020-11-20 | Union | South Dakota | 46127 | 1127 | 20 |
747709 | 747709 | 2020-11-19 | Union | South Dakota | 46127 | 1109 | 19 |
744463 | 744463 | 2020-11-18 | Union | South Dakota | 46127 | 1091 | 19 |
741216 | 741216 | 2020-11-17 | Union | South Dakota | 46127 | 1072 | 18 |
737970 | 737970 | 2020-11-16 | Union | South Dakota | 46127 | 1051 | 18 |
734726 | 734726 | 2020-11-15 | Union | South Dakota | 46127 | 1032 | 18 |
731480 | 731480 | 2020-11-14 | Union | South Dakota | 46127 | 1014 | 18 |
728236 | 728236 | 2020-11-13 | Union | South Dakota | 46127 | 986 | 17 |
724992 | 724992 | 2020-11-12 | Union | South Dakota | 46127 | 973 | 17 |
721749 | 721749 | 2020-11-11 | Union | South Dakota | 46127 | 940 | 17 |
718506 | 718506 | 2020-11-10 | Union | South Dakota | 46127 | 929 | 17 |
715263 | 715263 | 2020-11-09 | Union | South Dakota | 46127 | 921 | 16 |
712019 | 712019 | 2020-11-08 | Union | South Dakota | 46127 | 902 | 16 |
708775 | 708775 | 2020-11-07 | Union | South Dakota | 46127 | 887 | 16 |
705532 | 705532 | 2020-11-06 | Union | South Dakota | 46127 | 863 | 16 |
702289 | 702289 | 2020-11-05 | Union | South Dakota | 46127 | 843 | 14 |
699045 | 699045 | 2020-11-04 | Union | South Dakota | 46127 | 826 | 12 |
695802 | 695802 | 2020-11-03 | Union | South Dakota | 46127 | 820 | 12 |
692560 | 692560 | 2020-11-02 | Union | South Dakota | 46127 | 808 | 12 |
689316 | 689316 | 2020-11-01 | Union | South Dakota | 46127 | 807 | 12 |
686071 | 686071 | 2020-10-31 | Union | South Dakota | 46127 | 790 | 12 |
682828 | 682828 | 2020-10-30 | Union | South Dakota | 46127 | 773 | 11 |
679585 | 679585 | 2020-10-29 | Union | South Dakota | 46127 | 758 | 11 |
676342 | 676342 | 2020-10-28 | Union | South Dakota | 46127 | 747 | 11 |
673099 | 673099 | 2020-10-27 | Union | South Dakota | 46127 | 732 | 11 |
669857 | 669857 | 2020-10-26 | Union | South Dakota | 46127 | 725 | 11 |
666613 | 666613 | 2020-10-25 | Union | South Dakota | 46127 | 719 | 11 |
663368 | 663368 | 2020-10-24 | Union | South Dakota | 46127 | 708 | 11 |
660124 | 660124 | 2020-10-23 | Union | South Dakota | 46127 | 703 | 11 |
656880 | 656880 | 2020-10-22 | Union | South Dakota | 46127 | 686 | 10 |
653635 | 653635 | 2020-10-21 | Union | South Dakota | 46127 | 673 | 10 |
650390 | 650390 | 2020-10-20 | Union | South Dakota | 46127 | 669 | 10 |
647146 | 647146 | 2020-10-19 | Union | South Dakota | 46127 | 660 | 10 |
643900 | 643900 | 2020-10-18 | Union | South Dakota | 46127 | 656 | 10 |
640652 | 640652 | 2020-10-17 | Union | South Dakota | 46127 | 643 | 10 |
637406 | 637406 | 2020-10-16 | Union | South Dakota | 46127 | 630 | 10 |
634160 | 634160 | 2020-10-15 | Union | South Dakota | 46127 | 620 | 10 |
630915 | 630915 | 2020-10-14 | Union | South Dakota | 46127 | 599 | 10 |
627671 | 627671 | 2020-10-13 | Union | South Dakota | 46127 | 586 | 10 |
624429 | 624429 | 2020-10-12 | Union | South Dakota | 46127 | 571 | 10 |
621186 | 621186 | 2020-10-11 | Union | South Dakota | 46127 | 555 | 10 |
617943 | 617943 | 2020-10-10 | Union | South Dakota | 46127 | 539 | 10 |
614701 | 614701 | 2020-10-09 | Union | South Dakota | 46127 | 526 | 10 |
611460 | 611460 | 2020-10-08 | Union | South Dakota | 46127 | 514 | 10 |
608218 | 608218 | 2020-10-07 | Union | South Dakota | 46127 | 485 | 10 |
604975 | 604975 | 2020-10-06 | Union | South Dakota | 46127 | 462 | 9 |
601733 | 601733 | 2020-10-05 | Union | South Dakota | 46127 | 458 | 9 |
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);