ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Leake" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948051 | 1948051 | 2021-11-24 | Leake | Mississippi | 28079 | 4137 | 90 |
1944800 | 1944800 | 2021-11-23 | Leake | Mississippi | 28079 | 4134 | 90 |
1941549 | 1941549 | 2021-11-22 | Leake | Mississippi | 28079 | 4133 | 90 |
1938299 | 1938299 | 2021-11-21 | Leake | Mississippi | 28079 | 4129 | 90 |
1935049 | 1935049 | 2021-11-20 | Leake | Mississippi | 28079 | 4129 | 90 |
1931799 | 1931799 | 2021-11-19 | Leake | Mississippi | 28079 | 4129 | 90 |
1928548 | 1928548 | 2021-11-18 | Leake | Mississippi | 28079 | 4127 | 90 |
1925298 | 1925298 | 2021-11-17 | Leake | Mississippi | 28079 | 4124 | 90 |
1922049 | 1922049 | 2021-11-16 | Leake | Mississippi | 28079 | 4124 | 90 |
1918799 | 1918799 | 2021-11-15 | Leake | Mississippi | 28079 | 4119 | 90 |
1915549 | 1915549 | 2021-11-14 | Leake | Mississippi | 28079 | 4113 | 89 |
1912299 | 1912299 | 2021-11-13 | Leake | Mississippi | 28079 | 4113 | 89 |
1909049 | 1909049 | 2021-11-12 | Leake | Mississippi | 28079 | 4113 | 89 |
1905800 | 1905800 | 2021-11-11 | Leake | Mississippi | 28079 | 4107 | 89 |
1902551 | 1902551 | 2021-11-10 | Leake | Mississippi | 28079 | 4107 | 89 |
1899301 | 1899301 | 2021-11-09 | Leake | Mississippi | 28079 | 4107 | 89 |
1896051 | 1896051 | 2021-11-08 | Leake | Mississippi | 28079 | 4107 | 89 |
1892801 | 1892801 | 2021-11-07 | Leake | Mississippi | 28079 | 4107 | 89 |
1889551 | 1889551 | 2021-11-06 | Leake | Mississippi | 28079 | 4107 | 89 |
1886301 | 1886301 | 2021-11-05 | Leake | Mississippi | 28079 | 4107 | 89 |
1883052 | 1883052 | 2021-11-04 | Leake | Mississippi | 28079 | 4104 | 89 |
1879803 | 1879803 | 2021-11-03 | Leake | Mississippi | 28079 | 4104 | 89 |
1876554 | 1876554 | 2021-11-02 | Leake | Mississippi | 28079 | 4104 | 89 |
1873305 | 1873305 | 2021-11-01 | Leake | Mississippi | 28079 | 4102 | 89 |
1870056 | 1870056 | 2021-10-31 | Leake | Mississippi | 28079 | 4100 | 88 |
1866807 | 1866807 | 2021-10-30 | Leake | Mississippi | 28079 | 4100 | 88 |
1863558 | 1863558 | 2021-10-29 | Leake | Mississippi | 28079 | 4100 | 88 |
1860309 | 1860309 | 2021-10-28 | Leake | Mississippi | 28079 | 4100 | 88 |
1857060 | 1857060 | 2021-10-27 | Leake | Mississippi | 28079 | 4100 | 88 |
1853811 | 1853811 | 2021-10-26 | Leake | Mississippi | 28079 | 4098 | 88 |
1850562 | 1850562 | 2021-10-25 | Leake | Mississippi | 28079 | 4086 | 88 |
1847312 | 1847312 | 2021-10-24 | Leake | Mississippi | 28079 | 4082 | 88 |
1844062 | 1844062 | 2021-10-23 | Leake | Mississippi | 28079 | 4082 | 88 |
1840812 | 1840812 | 2021-10-22 | Leake | Mississippi | 28079 | 4082 | 88 |
1837563 | 1837563 | 2021-10-21 | Leake | Mississippi | 28079 | 4082 | 88 |
1834314 | 1834314 | 2021-10-20 | Leake | Mississippi | 28079 | 4080 | 88 |
1831065 | 1831065 | 2021-10-19 | Leake | Mississippi | 28079 | 4080 | 87 |
1827816 | 1827816 | 2021-10-18 | Leake | Mississippi | 28079 | 4076 | 87 |
1824567 | 1824567 | 2021-10-17 | Leake | Mississippi | 28079 | 4077 | 87 |
1821318 | 1821318 | 2021-10-16 | Leake | Mississippi | 28079 | 4077 | 87 |
1818069 | 1818069 | 2021-10-15 | Leake | Mississippi | 28079 | 4077 | 87 |
1814820 | 1814820 | 2021-10-14 | Leake | Mississippi | 28079 | 4072 | 87 |
1811572 | 1811572 | 2021-10-13 | Leake | Mississippi | 28079 | 4072 | 87 |
1808323 | 1808323 | 2021-10-12 | Leake | Mississippi | 28079 | 4068 | 87 |
1805072 | 1805072 | 2021-10-11 | Leake | Mississippi | 28079 | 4064 | 87 |
1801823 | 1801823 | 2021-10-10 | Leake | Mississippi | 28079 | 4059 | 87 |
1798574 | 1798574 | 2021-10-09 | Leake | Mississippi | 28079 | 4059 | 87 |
1795325 | 1795325 | 2021-10-08 | Leake | Mississippi | 28079 | 4059 | 87 |
1792076 | 1792076 | 2021-10-07 | Leake | Mississippi | 28079 | 4057 | 87 |
1788827 | 1788827 | 2021-10-06 | Leake | Mississippi | 28079 | 4050 | 87 |
1785579 | 1785579 | 2021-10-05 | Leake | Mississippi | 28079 | 4036 | 87 |
1782330 | 1782330 | 2021-10-04 | Leake | Mississippi | 28079 | 4032 | 87 |
1779080 | 1779080 | 2021-10-03 | Leake | Mississippi | 28079 | 4021 | 87 |
1775830 | 1775830 | 2021-10-02 | Leake | Mississippi | 28079 | 4021 | 87 |
1772580 | 1772580 | 2021-10-01 | Leake | Mississippi | 28079 | 4021 | 87 |
1769331 | 1769331 | 2021-09-30 | Leake | Mississippi | 28079 | 4012 | 86 |
1766082 | 1766082 | 2021-09-29 | Leake | Mississippi | 28079 | 4006 | 86 |
1762833 | 1762833 | 2021-09-28 | Leake | Mississippi | 28079 | 3998 | 86 |
1759584 | 1759584 | 2021-09-27 | Leake | Mississippi | 28079 | 3982 | 86 |
1756336 | 1756336 | 2021-09-26 | Leake | Mississippi | 28079 | 3975 | 86 |
1753088 | 1753088 | 2021-09-25 | Leake | Mississippi | 28079 | 3975 | 86 |
1749840 | 1749840 | 2021-09-24 | Leake | Mississippi | 28079 | 3975 | 86 |
1746590 | 1746590 | 2021-09-23 | Leake | Mississippi | 28079 | 3971 | 86 |
1743341 | 1743341 | 2021-09-22 | Leake | Mississippi | 28079 | 3954 | 86 |
1740092 | 1740092 | 2021-09-21 | Leake | Mississippi | 28079 | 3950 | 85 |
1736843 | 1736843 | 2021-09-20 | Leake | Mississippi | 28079 | 3944 | 85 |
1733593 | 1733593 | 2021-09-19 | Leake | Mississippi | 28079 | 3931 | 85 |
1730343 | 1730343 | 2021-09-18 | Leake | Mississippi | 28079 | 3931 | 85 |
1727093 | 1727093 | 2021-09-17 | Leake | Mississippi | 28079 | 3931 | 85 |
1723844 | 1723844 | 2021-09-16 | Leake | Mississippi | 28079 | 3904 | 85 |
1720595 | 1720595 | 2021-09-15 | Leake | Mississippi | 28079 | 3897 | 84 |
1717347 | 1717347 | 2021-09-14 | Leake | Mississippi | 28079 | 3882 | 83 |
1714099 | 1714099 | 2021-09-13 | Leake | Mississippi | 28079 | 3860 | 81 |
1710853 | 1710853 | 2021-09-12 | Leake | Mississippi | 28079 | 3832 | 81 |
1707606 | 1707606 | 2021-09-11 | Leake | Mississippi | 28079 | 3832 | 81 |
1704359 | 1704359 | 2021-09-10 | Leake | Mississippi | 28079 | 3832 | 81 |
1701109 | 1701109 | 2021-09-09 | Leake | Mississippi | 28079 | 3815 | 81 |
1697860 | 1697860 | 2021-09-08 | Leake | Mississippi | 28079 | 3806 | 81 |
1694612 | 1694612 | 2021-09-07 | Leake | Mississippi | 28079 | 3793 | 80 |
1691363 | 1691363 | 2021-09-06 | Leake | Mississippi | 28079 | 3789 | 80 |
1688113 | 1688113 | 2021-09-05 | Leake | Mississippi | 28079 | 3731 | 80 |
1684863 | 1684863 | 2021-09-04 | Leake | Mississippi | 28079 | 3731 | 80 |
1681612 | 1681612 | 2021-09-03 | Leake | Mississippi | 28079 | 3731 | 80 |
1678364 | 1678364 | 2021-09-02 | Leake | Mississippi | 28079 | 3706 | 80 |
1675116 | 1675116 | 2021-09-01 | Leake | Mississippi | 28079 | 3657 | 80 |
1671868 | 1671868 | 2021-08-31 | Leake | Mississippi | 28079 | 3637 | 80 |
1668621 | 1668621 | 2021-08-30 | Leake | Mississippi | 28079 | 3626 | 80 |
1665374 | 1665374 | 2021-08-29 | Leake | Mississippi | 28079 | 3596 | 80 |
1662126 | 1662126 | 2021-08-28 | Leake | Mississippi | 28079 | 3596 | 80 |
1658878 | 1658878 | 2021-08-27 | Leake | Mississippi | 28079 | 3596 | 80 |
1655629 | 1655629 | 2021-08-26 | Leake | Mississippi | 28079 | 3562 | 79 |
1652382 | 1652382 | 2021-08-25 | Leake | Mississippi | 28079 | 3540 | 77 |
1649134 | 1649134 | 2021-08-24 | Leake | Mississippi | 28079 | 3521 | 77 |
1645885 | 1645885 | 2021-08-23 | Leake | Mississippi | 28079 | 3476 | 77 |
1642636 | 1642636 | 2021-08-22 | Leake | Mississippi | 28079 | 3409 | 77 |
1639386 | 1639386 | 2021-08-21 | Leake | Mississippi | 28079 | 3409 | 77 |
1636136 | 1636136 | 2021-08-20 | Leake | Mississippi | 28079 | 3409 | 77 |
1632886 | 1632886 | 2021-08-19 | Leake | Mississippi | 28079 | 3372 | 77 |
1629639 | 1629639 | 2021-08-18 | Leake | Mississippi | 28079 | 3347 | 77 |
1626392 | 1626392 | 2021-08-17 | Leake | Mississippi | 28079 | 3311 | 77 |
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);