ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clay" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1051686 | 1051686 | 2021-02-21 | Clay | Mississippi | 28025 | 1769 | 48 |
1048439 | 1048439 | 2021-02-20 | Clay | Mississippi | 28025 | 1768 | 48 |
1045193 | 1045193 | 2021-02-19 | Clay | Mississippi | 28025 | 1765 | 48 |
1041948 | 1041948 | 2021-02-18 | Clay | Mississippi | 28025 | 1765 | 48 |
1038703 | 1038703 | 2021-02-17 | Clay | Mississippi | 28025 | 1765 | 48 |
1035458 | 1035458 | 2021-02-16 | Clay | Mississippi | 28025 | 1764 | 48 |
1032213 | 1032213 | 2021-02-15 | Clay | Mississippi | 28025 | 1763 | 46 |
1028966 | 1028966 | 2021-02-14 | Clay | Mississippi | 28025 | 1763 | 46 |
1025720 | 1025720 | 2021-02-13 | Clay | Mississippi | 28025 | 1761 | 46 |
1022475 | 1022475 | 2021-02-12 | Clay | Mississippi | 28025 | 1760 | 46 |
1019230 | 1019230 | 2021-02-11 | Clay | Mississippi | 28025 | 1760 | 45 |
1015985 | 1015985 | 2021-02-10 | Clay | Mississippi | 28025 | 1760 | 45 |
1012740 | 1012740 | 2021-02-09 | Clay | Mississippi | 28025 | 1757 | 45 |
1009495 | 1009495 | 2021-02-08 | Clay | Mississippi | 28025 | 1749 | 45 |
1006248 | 1006248 | 2021-02-07 | Clay | Mississippi | 28025 | 1748 | 45 |
1003002 | 1003002 | 2021-02-06 | Clay | Mississippi | 28025 | 1743 | 45 |
999757 | 999757 | 2021-02-05 | Clay | Mississippi | 28025 | 1739 | 45 |
996511 | 996511 | 2021-02-04 | Clay | Mississippi | 28025 | 1735 | 45 |
993265 | 993265 | 2021-02-03 | Clay | Mississippi | 28025 | 1733 | 45 |
990019 | 990019 | 2021-02-02 | Clay | Mississippi | 28025 | 1729 | 45 |
986772 | 986772 | 2021-02-01 | Clay | Mississippi | 28025 | 1724 | 44 |
983525 | 983525 | 2021-01-31 | Clay | Mississippi | 28025 | 1720 | 44 |
980279 | 980279 | 2021-01-30 | Clay | Mississippi | 28025 | 1717 | 44 |
977033 | 977033 | 2021-01-29 | Clay | Mississippi | 28025 | 1708 | 40 |
973788 | 973788 | 2021-01-28 | Clay | Mississippi | 28025 | 1701 | 39 |
970543 | 970543 | 2021-01-27 | Clay | Mississippi | 28025 | 1695 | 38 |
967298 | 967298 | 2021-01-26 | Clay | Mississippi | 28025 | 1686 | 37 |
964054 | 964054 | 2021-01-25 | Clay | Mississippi | 28025 | 1675 | 37 |
960809 | 960809 | 2021-01-24 | Clay | Mississippi | 28025 | 1668 | 37 |
957563 | 957563 | 2021-01-23 | Clay | Mississippi | 28025 | 1658 | 37 |
954318 | 954318 | 2021-01-22 | Clay | Mississippi | 28025 | 1642 | 37 |
951073 | 951073 | 2021-01-21 | Clay | Mississippi | 28025 | 1627 | 35 |
947827 | 947827 | 2021-01-20 | Clay | Mississippi | 28025 | 1613 | 35 |
944580 | 944580 | 2021-01-19 | Clay | Mississippi | 28025 | 1598 | 33 |
941335 | 941335 | 2021-01-18 | Clay | Mississippi | 28025 | 1594 | 33 |
938090 | 938090 | 2021-01-17 | Clay | Mississippi | 28025 | 1590 | 33 |
934845 | 934845 | 2021-01-16 | Clay | Mississippi | 28025 | 1582 | 33 |
931600 | 931600 | 2021-01-15 | Clay | Mississippi | 28025 | 1567 | 32 |
928355 | 928355 | 2021-01-14 | Clay | Mississippi | 28025 | 1556 | 32 |
925109 | 925109 | 2021-01-13 | Clay | Mississippi | 28025 | 1538 | 32 |
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 |
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);