ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Holmes" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278983 | 1278983 | 2021-05-02 | Holmes | Mississippi | 28051 | 1882 | 72 |
1275736 | 1275736 | 2021-05-01 | Holmes | Mississippi | 28051 | 1882 | 72 |
1272489 | 1272489 | 2021-04-30 | Holmes | Mississippi | 28051 | 1882 | 72 |
1269242 | 1269242 | 2021-04-29 | Holmes | Mississippi | 28051 | 1882 | 72 |
1265995 | 1265995 | 2021-04-28 | Holmes | Mississippi | 28051 | 1882 | 72 |
1262748 | 1262748 | 2021-04-27 | Holmes | Mississippi | 28051 | 1882 | 72 |
1259501 | 1259501 | 2021-04-26 | Holmes | Mississippi | 28051 | 1878 | 72 |
1256254 | 1256254 | 2021-04-25 | Holmes | Mississippi | 28051 | 1875 | 72 |
1253007 | 1253007 | 2021-04-24 | Holmes | Mississippi | 28051 | 1875 | 72 |
1249760 | 1249760 | 2021-04-23 | Holmes | Mississippi | 28051 | 1875 | 72 |
1246513 | 1246513 | 2021-04-22 | Holmes | Mississippi | 28051 | 1875 | 72 |
1243266 | 1243266 | 2021-04-21 | Holmes | Mississippi | 28051 | 1875 | 72 |
1240019 | 1240019 | 2021-04-20 | Holmes | Mississippi | 28051 | 1875 | 72 |
1236772 | 1236772 | 2021-04-19 | Holmes | Mississippi | 28051 | 1872 | 72 |
1233525 | 1233525 | 2021-04-18 | Holmes | Mississippi | 28051 | 1871 | 72 |
1230277 | 1230277 | 2021-04-17 | Holmes | Mississippi | 28051 | 1871 | 72 |
1227029 | 1227029 | 2021-04-16 | Holmes | Mississippi | 28051 | 1871 | 72 |
1223781 | 1223781 | 2021-04-15 | Holmes | Mississippi | 28051 | 1869 | 72 |
1220534 | 1220534 | 2021-04-14 | Holmes | Mississippi | 28051 | 1869 | 72 |
1217286 | 1217286 | 2021-04-13 | Holmes | Mississippi | 28051 | 1868 | 72 |
1214039 | 1214039 | 2021-04-12 | Holmes | Mississippi | 28051 | 1864 | 71 |
1210791 | 1210791 | 2021-04-11 | Holmes | Mississippi | 28051 | 1864 | 71 |
1207542 | 1207542 | 2021-04-10 | Holmes | Mississippi | 28051 | 1864 | 71 |
1204294 | 1204294 | 2021-04-09 | Holmes | Mississippi | 28051 | 1863 | 71 |
1201046 | 1201046 | 2021-04-08 | Holmes | Mississippi | 28051 | 1863 | 71 |
1197797 | 1197797 | 2021-04-07 | Holmes | Mississippi | 28051 | 1863 | 71 |
1194548 | 1194548 | 2021-04-06 | Holmes | Mississippi | 28051 | 1857 | 71 |
1191299 | 1191299 | 2021-04-05 | Holmes | Mississippi | 28051 | 1857 | 71 |
1188051 | 1188051 | 2021-04-04 | Holmes | Mississippi | 28051 | 1856 | 71 |
1184804 | 1184804 | 2021-04-03 | Holmes | Mississippi | 28051 | 1856 | 71 |
1181558 | 1181558 | 2021-04-02 | Holmes | Mississippi | 28051 | 1855 | 71 |
1178311 | 1178311 | 2021-04-01 | Holmes | Mississippi | 28051 | 1853 | 71 |
1175064 | 1175064 | 2021-03-31 | Holmes | Mississippi | 28051 | 1852 | 71 |
1171817 | 1171817 | 2021-03-30 | Holmes | Mississippi | 28051 | 1850 | 71 |
1168569 | 1168569 | 2021-03-29 | Holmes | Mississippi | 28051 | 1850 | 71 |
1165321 | 1165321 | 2021-03-28 | Holmes | Mississippi | 28051 | 1850 | 71 |
1162073 | 1162073 | 2021-03-27 | Holmes | Mississippi | 28051 | 1847 | 71 |
1158825 | 1158825 | 2021-03-26 | Holmes | Mississippi | 28051 | 1847 | 71 |
1155578 | 1155578 | 2021-03-25 | Holmes | Mississippi | 28051 | 1846 | 71 |
1152331 | 1152331 | 2021-03-24 | Holmes | Mississippi | 28051 | 1845 | 71 |
1149084 | 1149084 | 2021-03-23 | Holmes | Mississippi | 28051 | 1844 | 71 |
1145837 | 1145837 | 2021-03-22 | Holmes | Mississippi | 28051 | 1843 | 71 |
1142590 | 1142590 | 2021-03-21 | Holmes | Mississippi | 28051 | 1839 | 71 |
1139343 | 1139343 | 2021-03-20 | Holmes | Mississippi | 28051 | 1838 | 71 |
1136097 | 1136097 | 2021-03-19 | Holmes | Mississippi | 28051 | 1838 | 71 |
1132851 | 1132851 | 2021-03-18 | Holmes | Mississippi | 28051 | 1836 | 70 |
1129603 | 1129603 | 2021-03-17 | Holmes | Mississippi | 28051 | 1836 | 70 |
1126356 | 1126356 | 2021-03-16 | Holmes | Mississippi | 28051 | 1836 | 70 |
1123110 | 1123110 | 2021-03-15 | Holmes | Mississippi | 28051 | 1836 | 70 |
1119863 | 1119863 | 2021-03-14 | Holmes | Mississippi | 28051 | 1836 | 70 |
1116616 | 1116616 | 2021-03-13 | Holmes | Mississippi | 28051 | 1836 | 70 |
1113370 | 1113370 | 2021-03-12 | Holmes | Mississippi | 28051 | 1836 | 70 |
1110124 | 1110124 | 2021-03-11 | Holmes | Mississippi | 28051 | 1836 | 70 |
1106878 | 1106878 | 2021-03-10 | Holmes | Mississippi | 28051 | 1836 | 70 |
1103632 | 1103632 | 2021-03-09 | Holmes | Mississippi | 28051 | 1835 | 70 |
1100386 | 1100386 | 2021-03-08 | Holmes | Mississippi | 28051 | 1834 | 70 |
1097139 | 1097139 | 2021-03-07 | Holmes | Mississippi | 28051 | 1834 | 70 |
1093892 | 1093892 | 2021-03-06 | Holmes | Mississippi | 28051 | 1828 | 70 |
1090646 | 1090646 | 2021-03-05 | Holmes | Mississippi | 28051 | 1827 | 70 |
1087401 | 1087401 | 2021-03-04 | Holmes | Mississippi | 28051 | 1827 | 70 |
1084156 | 1084156 | 2021-03-03 | Holmes | Mississippi | 28051 | 1823 | 70 |
1080910 | 1080910 | 2021-03-02 | Holmes | Mississippi | 28051 | 1823 | 70 |
1077664 | 1077664 | 2021-03-01 | Holmes | Mississippi | 28051 | 1822 | 70 |
1074418 | 1074418 | 2021-02-28 | Holmes | Mississippi | 28051 | 1818 | 70 |
1071172 | 1071172 | 2021-02-27 | Holmes | Mississippi | 28051 | 1817 | 70 |
1067927 | 1067927 | 2021-02-26 | Holmes | Mississippi | 28051 | 1817 | 70 |
1064682 | 1064682 | 2021-02-25 | Holmes | Mississippi | 28051 | 1816 | 70 |
1061438 | 1061438 | 2021-02-24 | Holmes | Mississippi | 28051 | 1814 | 70 |
1058192 | 1058192 | 2021-02-23 | Holmes | Mississippi | 28051 | 1814 | 70 |
1054946 | 1054946 | 2021-02-22 | Holmes | Mississippi | 28051 | 1809 | 69 |
1051699 | 1051699 | 2021-02-21 | Holmes | Mississippi | 28051 | 1803 | 69 |
1048452 | 1048452 | 2021-02-20 | Holmes | Mississippi | 28051 | 1803 | 69 |
1045206 | 1045206 | 2021-02-19 | Holmes | Mississippi | 28051 | 1802 | 69 |
1041961 | 1041961 | 2021-02-18 | Holmes | Mississippi | 28051 | 1801 | 69 |
1038716 | 1038716 | 2021-02-17 | Holmes | Mississippi | 28051 | 1801 | 69 |
1035471 | 1035471 | 2021-02-16 | Holmes | Mississippi | 28051 | 1801 | 69 |
1032226 | 1032226 | 2021-02-15 | Holmes | Mississippi | 28051 | 1795 | 69 |
1028979 | 1028979 | 2021-02-14 | Holmes | Mississippi | 28051 | 1795 | 69 |
1025733 | 1025733 | 2021-02-13 | Holmes | Mississippi | 28051 | 1792 | 69 |
1022488 | 1022488 | 2021-02-12 | Holmes | Mississippi | 28051 | 1792 | 69 |
1019243 | 1019243 | 2021-02-11 | Holmes | Mississippi | 28051 | 1790 | 69 |
1015998 | 1015998 | 2021-02-10 | Holmes | Mississippi | 28051 | 1787 | 69 |
1012753 | 1012753 | 2021-02-09 | Holmes | Mississippi | 28051 | 1787 | 69 |
1009508 | 1009508 | 2021-02-08 | Holmes | Mississippi | 28051 | 1785 | 69 |
1006261 | 1006261 | 2021-02-07 | Holmes | Mississippi | 28051 | 1783 | 69 |
1003015 | 1003015 | 2021-02-06 | Holmes | Mississippi | 28051 | 1778 | 69 |
999770 | 999770 | 2021-02-05 | Holmes | Mississippi | 28051 | 1774 | 69 |
996524 | 996524 | 2021-02-04 | Holmes | Mississippi | 28051 | 1770 | 69 |
993278 | 993278 | 2021-02-03 | Holmes | Mississippi | 28051 | 1768 | 69 |
990032 | 990032 | 2021-02-02 | Holmes | Mississippi | 28051 | 1763 | 69 |
986785 | 986785 | 2021-02-01 | Holmes | Mississippi | 28051 | 1761 | 68 |
983538 | 983538 | 2021-01-31 | Holmes | Mississippi | 28051 | 1759 | 68 |
980292 | 980292 | 2021-01-30 | Holmes | Mississippi | 28051 | 1757 | 68 |
977046 | 977046 | 2021-01-29 | Holmes | Mississippi | 28051 | 1753 | 68 |
973801 | 973801 | 2021-01-28 | Holmes | Mississippi | 28051 | 1746 | 68 |
970556 | 970556 | 2021-01-27 | Holmes | Mississippi | 28051 | 1732 | 68 |
967311 | 967311 | 2021-01-26 | Holmes | Mississippi | 28051 | 1725 | 68 |
964067 | 964067 | 2021-01-25 | Holmes | Mississippi | 28051 | 1722 | 68 |
960822 | 960822 | 2021-01-24 | Holmes | Mississippi | 28051 | 1720 | 68 |
957576 | 957576 | 2021-01-23 | Holmes | Mississippi | 28051 | 1717 | 68 |
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);