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 |
---|---|---|---|---|---|---|---|
1278970 | 1278970 | 2021-05-02 | Clay | Mississippi | 28025 | 1843 | 54 |
1275723 | 1275723 | 2021-05-01 | Clay | Mississippi | 28025 | 1843 | 54 |
1272476 | 1272476 | 2021-04-30 | Clay | Mississippi | 28025 | 1843 | 54 |
1269229 | 1269229 | 2021-04-29 | Clay | Mississippi | 28025 | 1838 | 54 |
1265982 | 1265982 | 2021-04-28 | Clay | Mississippi | 28025 | 1837 | 54 |
1262735 | 1262735 | 2021-04-27 | Clay | Mississippi | 28025 | 1837 | 54 |
1259488 | 1259488 | 2021-04-26 | Clay | Mississippi | 28025 | 1836 | 54 |
1256241 | 1256241 | 2021-04-25 | Clay | Mississippi | 28025 | 1835 | 54 |
1252994 | 1252994 | 2021-04-24 | Clay | Mississippi | 28025 | 1835 | 54 |
1249747 | 1249747 | 2021-04-23 | Clay | Mississippi | 28025 | 1835 | 54 |
1246500 | 1246500 | 2021-04-22 | Clay | Mississippi | 28025 | 1835 | 54 |
1243253 | 1243253 | 2021-04-21 | Clay | Mississippi | 28025 | 1834 | 54 |
1240006 | 1240006 | 2021-04-20 | Clay | Mississippi | 28025 | 1834 | 54 |
1236759 | 1236759 | 2021-04-19 | Clay | Mississippi | 28025 | 1833 | 54 |
1233512 | 1233512 | 2021-04-18 | Clay | Mississippi | 28025 | 1832 | 54 |
1230264 | 1230264 | 2021-04-17 | Clay | Mississippi | 28025 | 1832 | 54 |
1227016 | 1227016 | 2021-04-16 | Clay | Mississippi | 28025 | 1832 | 54 |
1223768 | 1223768 | 2021-04-15 | Clay | Mississippi | 28025 | 1830 | 54 |
1220521 | 1220521 | 2021-04-14 | Clay | Mississippi | 28025 | 1829 | 54 |
1217273 | 1217273 | 2021-04-13 | Clay | Mississippi | 28025 | 1828 | 54 |
1214026 | 1214026 | 2021-04-12 | Clay | Mississippi | 28025 | 1824 | 54 |
1210778 | 1210778 | 2021-04-11 | Clay | Mississippi | 28025 | 1824 | 54 |
1207529 | 1207529 | 2021-04-10 | Clay | Mississippi | 28025 | 1823 | 54 |
1204281 | 1204281 | 2021-04-09 | Clay | Mississippi | 28025 | 1823 | 54 |
1201033 | 1201033 | 2021-04-08 | Clay | Mississippi | 28025 | 1823 | 54 |
1197784 | 1197784 | 2021-04-07 | Clay | Mississippi | 28025 | 1822 | 54 |
1194535 | 1194535 | 2021-04-06 | Clay | Mississippi | 28025 | 1821 | 54 |
1191286 | 1191286 | 2021-04-05 | Clay | Mississippi | 28025 | 1821 | 54 |
1188038 | 1188038 | 2021-04-04 | Clay | Mississippi | 28025 | 1821 | 54 |
1184791 | 1184791 | 2021-04-03 | Clay | Mississippi | 28025 | 1820 | 54 |
1181545 | 1181545 | 2021-04-02 | Clay | Mississippi | 28025 | 1819 | 54 |
1178298 | 1178298 | 2021-04-01 | Clay | Mississippi | 28025 | 1818 | 54 |
1175051 | 1175051 | 2021-03-31 | Clay | Mississippi | 28025 | 1817 | 54 |
1171804 | 1171804 | 2021-03-30 | Clay | Mississippi | 28025 | 1816 | 54 |
1168556 | 1168556 | 2021-03-29 | Clay | Mississippi | 28025 | 1816 | 54 |
1165308 | 1165308 | 2021-03-28 | Clay | Mississippi | 28025 | 1816 | 54 |
1162060 | 1162060 | 2021-03-27 | Clay | Mississippi | 28025 | 1816 | 54 |
1158812 | 1158812 | 2021-03-26 | Clay | Mississippi | 28025 | 1816 | 54 |
1155565 | 1155565 | 2021-03-25 | Clay | Mississippi | 28025 | 1814 | 54 |
1152318 | 1152318 | 2021-03-24 | Clay | Mississippi | 28025 | 1813 | 54 |
1149071 | 1149071 | 2021-03-23 | Clay | Mississippi | 28025 | 1813 | 54 |
1145824 | 1145824 | 2021-03-22 | Clay | Mississippi | 28025 | 1813 | 54 |
1142577 | 1142577 | 2021-03-21 | Clay | Mississippi | 28025 | 1812 | 54 |
1139330 | 1139330 | 2021-03-20 | Clay | Mississippi | 28025 | 1809 | 54 |
1136084 | 1136084 | 2021-03-19 | Clay | Mississippi | 28025 | 1809 | 54 |
1132838 | 1132838 | 2021-03-18 | Clay | Mississippi | 28025 | 1808 | 54 |
1129590 | 1129590 | 2021-03-17 | Clay | Mississippi | 28025 | 1806 | 54 |
1126343 | 1126343 | 2021-03-16 | Clay | Mississippi | 28025 | 1805 | 54 |
1123097 | 1123097 | 2021-03-15 | Clay | Mississippi | 28025 | 1801 | 53 |
1119850 | 1119850 | 2021-03-14 | Clay | Mississippi | 28025 | 1799 | 53 |
1116603 | 1116603 | 2021-03-13 | Clay | Mississippi | 28025 | 1799 | 53 |
1113357 | 1113357 | 2021-03-12 | Clay | Mississippi | 28025 | 1799 | 53 |
1110111 | 1110111 | 2021-03-11 | Clay | Mississippi | 28025 | 1795 | 53 |
1106865 | 1106865 | 2021-03-10 | Clay | Mississippi | 28025 | 1795 | 53 |
1103619 | 1103619 | 2021-03-09 | Clay | Mississippi | 28025 | 1794 | 53 |
1100373 | 1100373 | 2021-03-08 | Clay | Mississippi | 28025 | 1794 | 52 |
1097126 | 1097126 | 2021-03-07 | Clay | Mississippi | 28025 | 1794 | 52 |
1093879 | 1093879 | 2021-03-06 | Clay | Mississippi | 28025 | 1794 | 52 |
1090633 | 1090633 | 2021-03-05 | Clay | Mississippi | 28025 | 1793 | 51 |
1087388 | 1087388 | 2021-03-04 | Clay | Mississippi | 28025 | 1792 | 51 |
1084143 | 1084143 | 2021-03-03 | Clay | Mississippi | 28025 | 1792 | 51 |
1080897 | 1080897 | 2021-03-02 | Clay | Mississippi | 28025 | 1792 | 51 |
1077651 | 1077651 | 2021-03-01 | Clay | Mississippi | 28025 | 1791 | 50 |
1074405 | 1074405 | 2021-02-28 | Clay | Mississippi | 28025 | 1791 | 50 |
1071159 | 1071159 | 2021-02-27 | Clay | Mississippi | 28025 | 1785 | 50 |
1067914 | 1067914 | 2021-02-26 | Clay | Mississippi | 28025 | 1782 | 50 |
1064669 | 1064669 | 2021-02-25 | Clay | Mississippi | 28025 | 1781 | 49 |
1061425 | 1061425 | 2021-02-24 | Clay | Mississippi | 28025 | 1778 | 48 |
1058179 | 1058179 | 2021-02-23 | Clay | Mississippi | 28025 | 1773 | 48 |
1054933 | 1054933 | 2021-02-22 | Clay | Mississippi | 28025 | 1772 | 48 |
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 |
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);