ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clay" and fips = 28025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921864 | 921864 | 2021-01-12 | Clay | Mississippi | 28025 | 1524 | 31 |
918619 | 918619 | 2021-01-11 | Clay | Mississippi | 28025 | 1507 | 31 |
915374 | 915374 | 2021-01-10 | Clay | Mississippi | 28025 | 1496 | 31 |
912129 | 912129 | 2021-01-09 | Clay | Mississippi | 28025 | 1480 | 31 |
908884 | 908884 | 2021-01-08 | Clay | Mississippi | 28025 | 1468 | 30 |
905638 | 905638 | 2021-01-07 | Clay | Mississippi | 28025 | 1458 | 30 |
902393 | 902393 | 2021-01-06 | Clay | Mississippi | 28025 | 1430 | 30 |
899148 | 899148 | 2021-01-05 | Clay | Mississippi | 28025 | 1410 | 30 |
895903 | 895903 | 2021-01-04 | Clay | Mississippi | 28025 | 1393 | 30 |
892656 | 892656 | 2021-01-03 | Clay | Mississippi | 28025 | 1374 | 30 |
889410 | 889410 | 2021-01-02 | Clay | Mississippi | 28025 | 1366 | 30 |
886164 | 886164 | 2021-01-01 | Clay | Mississippi | 28025 | 1349 | 30 |
882919 | 882919 | 2020-12-31 | Clay | Mississippi | 28025 | 1329 | 30 |
879674 | 879674 | 2020-12-30 | Clay | Mississippi | 28025 | 1311 | 30 |
876429 | 876429 | 2020-12-29 | Clay | Mississippi | 28025 | 1290 | 30 |
873184 | 873184 | 2020-12-28 | Clay | Mississippi | 28025 | 1280 | 30 |
869939 | 869939 | 2020-12-27 | Clay | Mississippi | 28025 | 1268 | 30 |
866694 | 866694 | 2020-12-26 | Clay | Mississippi | 28025 | 1254 | 30 |
863449 | 863449 | 2020-12-25 | Clay | Mississippi | 28025 | 1242 | 30 |
860204 | 860204 | 2020-12-24 | Clay | Mississippi | 28025 | 1235 | 30 |
856959 | 856959 | 2020-12-23 | Clay | Mississippi | 28025 | 1220 | 30 |
853714 | 853714 | 2020-12-22 | Clay | Mississippi | 28025 | 1200 | 30 |
850469 | 850469 | 2020-12-21 | Clay | Mississippi | 28025 | 1188 | 30 |
847224 | 847224 | 2020-12-20 | Clay | Mississippi | 28025 | 1183 | 30 |
843978 | 843978 | 2020-12-19 | Clay | Mississippi | 28025 | 1174 | 29 |
840733 | 840733 | 2020-12-18 | Clay | Mississippi | 28025 | 1158 | 29 |
837488 | 837488 | 2020-12-17 | Clay | Mississippi | 28025 | 1145 | 28 |
834242 | 834242 | 2020-12-16 | Clay | Mississippi | 28025 | 1130 | 28 |
830995 | 830995 | 2020-12-15 | Clay | Mississippi | 28025 | 1110 | 28 |
827749 | 827749 | 2020-12-14 | Clay | Mississippi | 28025 | 1094 | 28 |
824502 | 824502 | 2020-12-13 | Clay | Mississippi | 28025 | 1084 | 28 |
821256 | 821256 | 2020-12-12 | Clay | Mississippi | 28025 | 1076 | 28 |
818010 | 818010 | 2020-12-11 | Clay | Mississippi | 28025 | 1059 | 27 |
814764 | 814764 | 2020-12-10 | Clay | Mississippi | 28025 | 1043 | 27 |
811519 | 811519 | 2020-12-09 | Clay | Mississippi | 28025 | 1023 | 27 |
808274 | 808274 | 2020-12-08 | Clay | Mississippi | 28025 | 1014 | 27 |
805029 | 805029 | 2020-12-07 | Clay | Mississippi | 28025 | 1007 | 27 |
801784 | 801784 | 2020-12-06 | Clay | Mississippi | 28025 | 999 | 27 |
798539 | 798539 | 2020-12-05 | Clay | Mississippi | 28025 | 996 | 27 |
795294 | 795294 | 2020-12-04 | Clay | Mississippi | 28025 | 985 | 27 |
792049 | 792049 | 2020-12-03 | Clay | Mississippi | 28025 | 971 | 27 |
788804 | 788804 | 2020-12-02 | Clay | Mississippi | 28025 | 961 | 27 |
785559 | 785559 | 2020-12-01 | Clay | Mississippi | 28025 | 947 | 27 |
782315 | 782315 | 2020-11-30 | Clay | Mississippi | 28025 | 934 | 27 |
779069 | 779069 | 2020-11-29 | Clay | Mississippi | 28025 | 923 | 27 |
775824 | 775824 | 2020-11-28 | Clay | Mississippi | 28025 | 913 | 27 |
772579 | 772579 | 2020-11-27 | Clay | Mississippi | 28025 | 903 | 27 |
769334 | 769334 | 2020-11-26 | Clay | Mississippi | 28025 | 899 | 27 |
766088 | 766088 | 2020-11-25 | Clay | Mississippi | 28025 | 871 | 27 |
762843 | 762843 | 2020-11-24 | Clay | Mississippi | 28025 | 870 | 27 |
759598 | 759598 | 2020-11-23 | Clay | Mississippi | 28025 | 867 | 26 |
756351 | 756351 | 2020-11-22 | Clay | Mississippi | 28025 | 862 | 26 |
753105 | 753105 | 2020-11-21 | Clay | Mississippi | 28025 | 855 | 26 |
749859 | 749859 | 2020-11-20 | Clay | Mississippi | 28025 | 843 | 26 |
746613 | 746613 | 2020-11-19 | Clay | Mississippi | 28025 | 827 | 26 |
743366 | 743366 | 2020-11-18 | Clay | Mississippi | 28025 | 824 | 26 |
740119 | 740119 | 2020-11-17 | Clay | Mississippi | 28025 | 817 | 26 |
736875 | 736875 | 2020-11-16 | Clay | Mississippi | 28025 | 809 | 26 |
733629 | 733629 | 2020-11-15 | Clay | Mississippi | 28025 | 806 | 26 |
730384 | 730384 | 2020-11-14 | Clay | Mississippi | 28025 | 802 | 26 |
727141 | 727141 | 2020-11-13 | Clay | Mississippi | 28025 | 797 | 25 |
723898 | 723898 | 2020-11-12 | Clay | Mississippi | 28025 | 793 | 25 |
720655 | 720655 | 2020-11-11 | Clay | Mississippi | 28025 | 782 | 25 |
717412 | 717412 | 2020-11-10 | Clay | Mississippi | 28025 | 776 | 25 |
714168 | 714168 | 2020-11-09 | Clay | Mississippi | 28025 | 774 | 25 |
710924 | 710924 | 2020-11-08 | Clay | Mississippi | 28025 | 772 | 25 |
707680 | 707680 | 2020-11-07 | Clay | Mississippi | 28025 | 756 | 25 |
704437 | 704437 | 2020-11-06 | Clay | Mississippi | 28025 | 754 | 23 |
701195 | 701195 | 2020-11-05 | Clay | Mississippi | 28025 | 748 | 23 |
697951 | 697951 | 2020-11-04 | Clay | Mississippi | 28025 | 741 | 23 |
694708 | 694708 | 2020-11-03 | Clay | Mississippi | 28025 | 735 | 22 |
691466 | 691466 | 2020-11-02 | Clay | Mississippi | 28025 | 725 | 22 |
688221 | 688221 | 2020-11-01 | Clay | Mississippi | 28025 | 723 | 22 |
684977 | 684977 | 2020-10-31 | Clay | Mississippi | 28025 | 722 | 22 |
681734 | 681734 | 2020-10-30 | Clay | Mississippi | 28025 | 718 | 22 |
678490 | 678490 | 2020-10-29 | Clay | Mississippi | 28025 | 715 | 22 |
675248 | 675248 | 2020-10-28 | Clay | Mississippi | 28025 | 710 | 22 |
672005 | 672005 | 2020-10-27 | Clay | Mississippi | 28025 | 705 | 22 |
668763 | 668763 | 2020-10-26 | Clay | Mississippi | 28025 | 700 | 21 |
665519 | 665519 | 2020-10-25 | Clay | Mississippi | 28025 | 693 | 21 |
662274 | 662274 | 2020-10-24 | Clay | Mississippi | 28025 | 693 | 21 |
659030 | 659030 | 2020-10-23 | Clay | Mississippi | 28025 | 684 | 21 |
655785 | 655785 | 2020-10-22 | Clay | Mississippi | 28025 | 683 | 21 |
652540 | 652540 | 2020-10-21 | Clay | Mississippi | 28025 | 684 | 21 |
649295 | 649295 | 2020-10-20 | Clay | Mississippi | 28025 | 676 | 21 |
646051 | 646051 | 2020-10-19 | Clay | Mississippi | 28025 | 672 | 21 |
642804 | 642804 | 2020-10-18 | Clay | Mississippi | 28025 | 666 | 21 |
639557 | 639557 | 2020-10-17 | Clay | Mississippi | 28025 | 666 | 21 |
636311 | 636311 | 2020-10-16 | Clay | Mississippi | 28025 | 663 | 21 |
633065 | 633065 | 2020-10-15 | Clay | Mississippi | 28025 | 660 | 21 |
629820 | 629820 | 2020-10-14 | Clay | Mississippi | 28025 | 651 | 21 |
626576 | 626576 | 2020-10-13 | Clay | Mississippi | 28025 | 642 | 20 |
623334 | 623334 | 2020-10-12 | Clay | Mississippi | 28025 | 639 | 20 |
620091 | 620091 | 2020-10-11 | Clay | Mississippi | 28025 | 635 | 20 |
616849 | 616849 | 2020-10-10 | Clay | Mississippi | 28025 | 631 | 20 |
613608 | 613608 | 2020-10-09 | Clay | Mississippi | 28025 | 628 | 20 |
610366 | 610366 | 2020-10-08 | Clay | Mississippi | 28025 | 626 | 20 |
607124 | 607124 | 2020-10-07 | Clay | Mississippi | 28025 | 624 | 20 |
603881 | 603881 | 2020-10-06 | Clay | Mississippi | 28025 | 623 | 20 |
600639 | 600639 | 2020-10-05 | Clay | Mississippi | 28025 | 613 | 20 |
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);