ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Union" and fips = 45087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922894 | 922894 | 2021-01-12 | Union | South Carolina | 45087 | 1780 | 48 |
919649 | 919649 | 2021-01-11 | Union | South Carolina | 45087 | 1776 | 48 |
916404 | 916404 | 2021-01-10 | Union | South Carolina | 45087 | 1766 | 48 |
913159 | 913159 | 2021-01-09 | Union | South Carolina | 45087 | 1725 | 47 |
909914 | 909914 | 2021-01-08 | Union | South Carolina | 45087 | 1703 | 45 |
906669 | 906669 | 2021-01-07 | Union | South Carolina | 45087 | 1663 | 45 |
903423 | 903423 | 2021-01-06 | Union | South Carolina | 45087 | 1656 | 43 |
900178 | 900178 | 2021-01-05 | Union | South Carolina | 45087 | 1638 | 43 |
896933 | 896933 | 2021-01-04 | Union | South Carolina | 45087 | 1635 | 43 |
893687 | 893687 | 2021-01-03 | Union | South Carolina | 45087 | 1618 | 43 |
890441 | 890441 | 2021-01-02 | Union | South Carolina | 45087 | 1563 | 42 |
887194 | 887194 | 2021-01-01 | Union | South Carolina | 45087 | 1551 | 41 |
883949 | 883949 | 2020-12-31 | Union | South Carolina | 45087 | 1551 | 41 |
880704 | 880704 | 2020-12-30 | Union | South Carolina | 45087 | 1542 | 39 |
877459 | 877459 | 2020-12-29 | Union | South Carolina | 45087 | 1535 | 39 |
874214 | 874214 | 2020-12-28 | Union | South Carolina | 45087 | 1524 | 39 |
870969 | 870969 | 2020-12-27 | Union | South Carolina | 45087 | 1515 | 39 |
867724 | 867724 | 2020-12-26 | Union | South Carolina | 45087 | 1479 | 39 |
864479 | 864479 | 2020-12-25 | Union | South Carolina | 45087 | 1471 | 37 |
861234 | 861234 | 2020-12-24 | Union | South Carolina | 45087 | 1471 | 37 |
857989 | 857989 | 2020-12-23 | Union | South Carolina | 45087 | 1450 | 37 |
854744 | 854744 | 2020-12-22 | Union | South Carolina | 45087 | 1425 | 37 |
851499 | 851499 | 2020-12-21 | Union | South Carolina | 45087 | 1410 | 36 |
848254 | 848254 | 2020-12-20 | Union | South Carolina | 45087 | 1405 | 36 |
845009 | 845009 | 2020-12-19 | Union | South Carolina | 45087 | 1373 | 36 |
841763 | 841763 | 2020-12-18 | Union | South Carolina | 45087 | 1366 | 35 |
838518 | 838518 | 2020-12-17 | Union | South Carolina | 45087 | 1350 | 35 |
835272 | 835272 | 2020-12-16 | Union | South Carolina | 45087 | 1329 | 34 |
832026 | 832026 | 2020-12-15 | Union | South Carolina | 45087 | 1314 | 34 |
828779 | 828779 | 2020-12-14 | Union | South Carolina | 45087 | 1304 | 34 |
825533 | 825533 | 2020-12-13 | Union | South Carolina | 45087 | 1294 | 34 |
822286 | 822286 | 2020-12-12 | Union | South Carolina | 45087 | 1269 | 33 |
819040 | 819040 | 2020-12-11 | Union | South Carolina | 45087 | 1245 | 33 |
815794 | 815794 | 2020-12-10 | Union | South Carolina | 45087 | 1221 | 33 |
812548 | 812548 | 2020-12-09 | Union | South Carolina | 45087 | 1220 | 33 |
809304 | 809304 | 2020-12-08 | Union | South Carolina | 45087 | 1214 | 32 |
806059 | 806059 | 2020-12-07 | Union | South Carolina | 45087 | 1192 | 32 |
802814 | 802814 | 2020-12-06 | Union | South Carolina | 45087 | 1184 | 32 |
799569 | 799569 | 2020-12-05 | Union | South Carolina | 45087 | 1139 | 29 |
796324 | 796324 | 2020-12-04 | Union | South Carolina | 45087 | 1128 | 28 |
793079 | 793079 | 2020-12-03 | Union | South Carolina | 45087 | 1095 | 28 |
789834 | 789834 | 2020-12-02 | Union | South Carolina | 45087 | 1086 | 27 |
786589 | 786589 | 2020-12-01 | Union | South Carolina | 45087 | 1072 | 27 |
783345 | 783345 | 2020-11-30 | Union | South Carolina | 45087 | 1067 | 26 |
780100 | 780100 | 2020-11-29 | Union | South Carolina | 45087 | 1057 | 26 |
776854 | 776854 | 2020-11-28 | Union | South Carolina | 45087 | 1049 | 26 |
773609 | 773609 | 2020-11-27 | Union | South Carolina | 45087 | 1043 | 26 |
770364 | 770364 | 2020-11-26 | Union | South Carolina | 45087 | 1016 | 26 |
767118 | 767118 | 2020-11-25 | Union | South Carolina | 45087 | 1016 | 26 |
763873 | 763873 | 2020-11-24 | Union | South Carolina | 45087 | 1005 | 26 |
760628 | 760628 | 2020-11-23 | Union | South Carolina | 45087 | 999 | 26 |
757383 | 757383 | 2020-11-22 | Union | South Carolina | 45087 | 991 | 26 |
754136 | 754136 | 2020-11-21 | Union | South Carolina | 45087 | 984 | 26 |
750890 | 750890 | 2020-11-20 | Union | South Carolina | 45087 | 976 | 25 |
747644 | 747644 | 2020-11-19 | Union | South Carolina | 45087 | 964 | 25 |
744398 | 744398 | 2020-11-18 | Union | South Carolina | 45087 | 942 | 24 |
741151 | 741151 | 2020-11-17 | Union | South Carolina | 45087 | 933 | 24 |
737905 | 737905 | 2020-11-16 | Union | South Carolina | 45087 | 927 | 24 |
734661 | 734661 | 2020-11-15 | Union | South Carolina | 45087 | 921 | 24 |
731415 | 731415 | 2020-11-14 | Union | South Carolina | 45087 | 899 | 24 |
728171 | 728171 | 2020-11-13 | Union | South Carolina | 45087 | 891 | 24 |
724927 | 724927 | 2020-11-12 | Union | South Carolina | 45087 | 885 | 24 |
721684 | 721684 | 2020-11-11 | Union | South Carolina | 45087 | 876 | 24 |
718441 | 718441 | 2020-11-10 | Union | South Carolina | 45087 | 871 | 24 |
715198 | 715198 | 2020-11-09 | Union | South Carolina | 45087 | 855 | 23 |
711954 | 711954 | 2020-11-08 | Union | South Carolina | 45087 | 844 | 23 |
708710 | 708710 | 2020-11-07 | Union | South Carolina | 45087 | 835 | 22 |
705467 | 705467 | 2020-11-06 | Union | South Carolina | 45087 | 824 | 21 |
702224 | 702224 | 2020-11-05 | Union | South Carolina | 45087 | 815 | 21 |
698980 | 698980 | 2020-11-04 | Union | South Carolina | 45087 | 811 | 20 |
695737 | 695737 | 2020-11-03 | Union | South Carolina | 45087 | 807 | 20 |
692495 | 692495 | 2020-11-02 | Union | South Carolina | 45087 | 806 | 19 |
689251 | 689251 | 2020-11-01 | Union | South Carolina | 45087 | 796 | 18 |
686006 | 686006 | 2020-10-31 | Union | South Carolina | 45087 | 776 | 18 |
682763 | 682763 | 2020-10-30 | Union | South Carolina | 45087 | 770 | 18 |
679520 | 679520 | 2020-10-29 | Union | South Carolina | 45087 | 759 | 18 |
676277 | 676277 | 2020-10-28 | Union | South Carolina | 45087 | 752 | 17 |
673034 | 673034 | 2020-10-27 | Union | South Carolina | 45087 | 746 | 16 |
669792 | 669792 | 2020-10-26 | Union | South Carolina | 45087 | 740 | 16 |
666548 | 666548 | 2020-10-25 | Union | South Carolina | 45087 | 738 | 16 |
663303 | 663303 | 2020-10-24 | Union | South Carolina | 45087 | 724 | 16 |
660059 | 660059 | 2020-10-23 | Union | South Carolina | 45087 | 721 | 16 |
656815 | 656815 | 2020-10-22 | Union | South Carolina | 45087 | 713 | 16 |
653570 | 653570 | 2020-10-21 | Union | South Carolina | 45087 | 708 | 16 |
650325 | 650325 | 2020-10-20 | Union | South Carolina | 45087 | 698 | 16 |
647081 | 647081 | 2020-10-19 | Union | South Carolina | 45087 | 697 | 15 |
643835 | 643835 | 2020-10-18 | Union | South Carolina | 45087 | 693 | 15 |
640587 | 640587 | 2020-10-17 | Union | South Carolina | 45087 | 690 | 15 |
637341 | 637341 | 2020-10-16 | Union | South Carolina | 45087 | 677 | 15 |
634095 | 634095 | 2020-10-15 | Union | South Carolina | 45087 | 675 | 15 |
630850 | 630850 | 2020-10-14 | Union | South Carolina | 45087 | 670 | 15 |
627606 | 627606 | 2020-10-13 | Union | South Carolina | 45087 | 663 | 15 |
624364 | 624364 | 2020-10-12 | Union | South Carolina | 45087 | 656 | 15 |
621121 | 621121 | 2020-10-11 | Union | South Carolina | 45087 | 655 | 15 |
617878 | 617878 | 2020-10-10 | Union | South Carolina | 45087 | 650 | 15 |
614636 | 614636 | 2020-10-09 | Union | South Carolina | 45087 | 644 | 14 |
611395 | 611395 | 2020-10-08 | Union | South Carolina | 45087 | 634 | 14 |
608153 | 608153 | 2020-10-07 | Union | South Carolina | 45087 | 631 | 14 |
604910 | 604910 | 2020-10-06 | Union | South Carolina | 45087 | 628 | 13 |
601668 | 601668 | 2020-10-05 | Union | South Carolina | 45087 | 623 | 13 |
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);