ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28053 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948038 | 1948038 | 2021-11-24 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1944787 | 1944787 | 2021-11-23 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1941536 | 1941536 | 2021-11-22 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1938286 | 1938286 | 2021-11-21 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1935036 | 1935036 | 2021-11-20 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1931786 | 1931786 | 2021-11-19 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1928535 | 1928535 | 2021-11-18 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1925285 | 1925285 | 2021-11-17 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1922036 | 1922036 | 2021-11-16 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1918786 | 1918786 | 2021-11-15 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1915536 | 1915536 | 2021-11-14 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1912286 | 1912286 | 2021-11-13 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1909036 | 1909036 | 2021-11-12 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1905787 | 1905787 | 2021-11-11 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1902538 | 1902538 | 2021-11-10 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1899288 | 1899288 | 2021-11-09 | Humphreys | Mississippi | 28053 | 1306 | 39 |
1896038 | 1896038 | 2021-11-08 | Humphreys | Mississippi | 28053 | 1303 | 39 |
1892788 | 1892788 | 2021-11-07 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1889538 | 1889538 | 2021-11-06 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1886288 | 1886288 | 2021-11-05 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1883039 | 1883039 | 2021-11-04 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1879790 | 1879790 | 2021-11-03 | Humphreys | Mississippi | 28053 | 1301 | 39 |
1876541 | 1876541 | 2021-11-02 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1873292 | 1873292 | 2021-11-01 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1870043 | 1870043 | 2021-10-31 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1866794 | 1866794 | 2021-10-30 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1863545 | 1863545 | 2021-10-29 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1860296 | 1860296 | 2021-10-28 | Humphreys | Mississippi | 28053 | 1299 | 38 |
1857047 | 1857047 | 2021-10-27 | Humphreys | Mississippi | 28053 | 1299 | 38 |
1853798 | 1853798 | 2021-10-26 | Humphreys | Mississippi | 28053 | 1297 | 38 |
1850549 | 1850549 | 2021-10-25 | Humphreys | Mississippi | 28053 | 1296 | 38 |
1847299 | 1847299 | 2021-10-24 | Humphreys | Mississippi | 28053 | 1295 | 38 |
1844049 | 1844049 | 2021-10-23 | Humphreys | Mississippi | 28053 | 1295 | 38 |
1840799 | 1840799 | 2021-10-22 | Humphreys | Mississippi | 28053 | 1295 | 38 |
1837550 | 1837550 | 2021-10-21 | Humphreys | Mississippi | 28053 | 1292 | 38 |
1834301 | 1834301 | 2021-10-20 | Humphreys | Mississippi | 28053 | 1292 | 38 |
1831052 | 1831052 | 2021-10-19 | Humphreys | Mississippi | 28053 | 1291 | 38 |
1827803 | 1827803 | 2021-10-18 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1824554 | 1824554 | 2021-10-17 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1821305 | 1821305 | 2021-10-16 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1818056 | 1818056 | 2021-10-15 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1814807 | 1814807 | 2021-10-14 | Humphreys | Mississippi | 28053 | 1288 | 38 |
1811559 | 1811559 | 2021-10-13 | Humphreys | Mississippi | 28053 | 1287 | 38 |
1808310 | 1808310 | 2021-10-12 | Humphreys | Mississippi | 28053 | 1287 | 38 |
1805059 | 1805059 | 2021-10-11 | Humphreys | Mississippi | 28053 | 1285 | 38 |
1801810 | 1801810 | 2021-10-10 | Humphreys | Mississippi | 28053 | 1284 | 38 |
1798561 | 1798561 | 2021-10-09 | Humphreys | Mississippi | 28053 | 1284 | 38 |
1795312 | 1795312 | 2021-10-08 | Humphreys | Mississippi | 28053 | 1284 | 38 |
1792063 | 1792063 | 2021-10-07 | Humphreys | Mississippi | 28053 | 1284 | 38 |
1788814 | 1788814 | 2021-10-06 | Humphreys | Mississippi | 28053 | 1283 | 38 |
1785566 | 1785566 | 2021-10-05 | Humphreys | Mississippi | 28053 | 1282 | 38 |
1782317 | 1782317 | 2021-10-04 | Humphreys | Mississippi | 28053 | 1279 | 38 |
1779067 | 1779067 | 2021-10-03 | Humphreys | Mississippi | 28053 | 1275 | 38 |
1775817 | 1775817 | 2021-10-02 | Humphreys | Mississippi | 28053 | 1275 | 38 |
1772567 | 1772567 | 2021-10-01 | Humphreys | Mississippi | 28053 | 1275 | 38 |
1769318 | 1769318 | 2021-09-30 | Humphreys | Mississippi | 28053 | 1275 | 38 |
1766069 | 1766069 | 2021-09-29 | Humphreys | Mississippi | 28053 | 1274 | 38 |
1762820 | 1762820 | 2021-09-28 | Humphreys | Mississippi | 28053 | 1274 | 38 |
1759571 | 1759571 | 2021-09-27 | Humphreys | Mississippi | 28053 | 1270 | 38 |
1756323 | 1756323 | 2021-09-26 | Humphreys | Mississippi | 28053 | 1266 | 37 |
1753075 | 1753075 | 2021-09-25 | Humphreys | Mississippi | 28053 | 1266 | 37 |
1749827 | 1749827 | 2021-09-24 | Humphreys | Mississippi | 28053 | 1266 | 37 |
1746577 | 1746577 | 2021-09-23 | Humphreys | Mississippi | 28053 | 1263 | 37 |
1743328 | 1743328 | 2021-09-22 | Humphreys | Mississippi | 28053 | 1259 | 37 |
1740079 | 1740079 | 2021-09-21 | Humphreys | Mississippi | 28053 | 1257 | 37 |
1736830 | 1736830 | 2021-09-20 | Humphreys | Mississippi | 28053 | 1240 | 37 |
1733580 | 1733580 | 2021-09-19 | Humphreys | Mississippi | 28053 | 1233 | 37 |
1730330 | 1730330 | 2021-09-18 | Humphreys | Mississippi | 28053 | 1233 | 37 |
1727080 | 1727080 | 2021-09-17 | Humphreys | Mississippi | 28053 | 1233 | 37 |
1723831 | 1723831 | 2021-09-16 | Humphreys | Mississippi | 28053 | 1230 | 37 |
1720582 | 1720582 | 2021-09-15 | Humphreys | Mississippi | 28053 | 1220 | 36 |
1717334 | 1717334 | 2021-09-14 | Humphreys | Mississippi | 28053 | 1218 | 36 |
1714086 | 1714086 | 2021-09-13 | Humphreys | Mississippi | 28053 | 1216 | 36 |
1710840 | 1710840 | 2021-09-12 | Humphreys | Mississippi | 28053 | 1208 | 36 |
1707593 | 1707593 | 2021-09-11 | Humphreys | Mississippi | 28053 | 1208 | 36 |
1704346 | 1704346 | 2021-09-10 | Humphreys | Mississippi | 28053 | 1208 | 36 |
1701096 | 1701096 | 2021-09-09 | Humphreys | Mississippi | 28053 | 1199 | 36 |
1697847 | 1697847 | 2021-09-08 | Humphreys | Mississippi | 28053 | 1188 | 36 |
1694599 | 1694599 | 2021-09-07 | Humphreys | Mississippi | 28053 | 1185 | 35 |
1691350 | 1691350 | 2021-09-06 | Humphreys | Mississippi | 28053 | 1185 | 35 |
1688100 | 1688100 | 2021-09-05 | Humphreys | Mississippi | 28053 | 1179 | 35 |
1684850 | 1684850 | 2021-09-04 | Humphreys | Mississippi | 28053 | 1179 | 35 |
1681599 | 1681599 | 2021-09-03 | Humphreys | Mississippi | 28053 | 1179 | 35 |
1678351 | 1678351 | 2021-09-02 | Humphreys | Mississippi | 28053 | 1166 | 35 |
1675103 | 1675103 | 2021-09-01 | Humphreys | Mississippi | 28053 | 1159 | 34 |
1671855 | 1671855 | 2021-08-31 | Humphreys | Mississippi | 28053 | 1152 | 34 |
1668608 | 1668608 | 2021-08-30 | Humphreys | Mississippi | 28053 | 1149 | 34 |
1665361 | 1665361 | 2021-08-29 | Humphreys | Mississippi | 28053 | 1127 | 34 |
1662113 | 1662113 | 2021-08-28 | Humphreys | Mississippi | 28053 | 1127 | 34 |
1658865 | 1658865 | 2021-08-27 | Humphreys | Mississippi | 28053 | 1127 | 34 |
1655616 | 1655616 | 2021-08-26 | Humphreys | Mississippi | 28053 | 1120 | 34 |
1652369 | 1652369 | 2021-08-25 | Humphreys | Mississippi | 28053 | 1118 | 34 |
1649121 | 1649121 | 2021-08-24 | Humphreys | Mississippi | 28053 | 1116 | 34 |
1645872 | 1645872 | 2021-08-23 | Humphreys | Mississippi | 28053 | 1115 | 34 |
1642623 | 1642623 | 2021-08-22 | Humphreys | Mississippi | 28053 | 1106 | 34 |
1639373 | 1639373 | 2021-08-21 | Humphreys | Mississippi | 28053 | 1106 | 34 |
1636123 | 1636123 | 2021-08-20 | Humphreys | Mississippi | 28053 | 1106 | 34 |
1632873 | 1632873 | 2021-08-19 | Humphreys | Mississippi | 28053 | 1102 | 34 |
1629626 | 1629626 | 2021-08-18 | Humphreys | Mississippi | 28053 | 1096 | 34 |
1626379 | 1626379 | 2021-08-17 | Humphreys | Mississippi | 28053 | 1090 | 33 |
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);