ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 28041 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811553 | 1811553 | 2021-10-13 | Greene | Mississippi | 28041 | 2148 | 48 |
1808304 | 1808304 | 2021-10-12 | Greene | Mississippi | 28041 | 2146 | 48 |
1805053 | 1805053 | 2021-10-11 | Greene | Mississippi | 28041 | 2144 | 48 |
1801804 | 1801804 | 2021-10-10 | Greene | Mississippi | 28041 | 2132 | 47 |
1798555 | 1798555 | 2021-10-09 | Greene | Mississippi | 28041 | 2132 | 47 |
1795306 | 1795306 | 2021-10-08 | Greene | Mississippi | 28041 | 2132 | 47 |
1792057 | 1792057 | 2021-10-07 | Greene | Mississippi | 28041 | 2129 | 47 |
1788808 | 1788808 | 2021-10-06 | Greene | Mississippi | 28041 | 2122 | 47 |
1785560 | 1785560 | 2021-10-05 | Greene | Mississippi | 28041 | 2122 | 47 |
1782311 | 1782311 | 2021-10-04 | Greene | Mississippi | 28041 | 2119 | 47 |
1779061 | 1779061 | 2021-10-03 | Greene | Mississippi | 28041 | 2117 | 47 |
1775811 | 1775811 | 2021-10-02 | Greene | Mississippi | 28041 | 2117 | 47 |
1772561 | 1772561 | 2021-10-01 | Greene | Mississippi | 28041 | 2117 | 47 |
1769312 | 1769312 | 2021-09-30 | Greene | Mississippi | 28041 | 2111 | 46 |
1766063 | 1766063 | 2021-09-29 | Greene | Mississippi | 28041 | 2105 | 46 |
1762814 | 1762814 | 2021-09-28 | Greene | Mississippi | 28041 | 2102 | 46 |
1759565 | 1759565 | 2021-09-27 | Greene | Mississippi | 28041 | 2099 | 45 |
1756317 | 1756317 | 2021-09-26 | Greene | Mississippi | 28041 | 2090 | 45 |
1753069 | 1753069 | 2021-09-25 | Greene | Mississippi | 28041 | 2090 | 45 |
1749821 | 1749821 | 2021-09-24 | Greene | Mississippi | 28041 | 2090 | 45 |
1746571 | 1746571 | 2021-09-23 | Greene | Mississippi | 28041 | 2078 | 45 |
1743322 | 1743322 | 2021-09-22 | Greene | Mississippi | 28041 | 2068 | 45 |
1740073 | 1740073 | 2021-09-21 | Greene | Mississippi | 28041 | 2062 | 45 |
1736824 | 1736824 | 2021-09-20 | Greene | Mississippi | 28041 | 2051 | 45 |
1733574 | 1733574 | 2021-09-19 | Greene | Mississippi | 28041 | 2040 | 45 |
1730324 | 1730324 | 2021-09-18 | Greene | Mississippi | 28041 | 2040 | 45 |
1727074 | 1727074 | 2021-09-17 | Greene | Mississippi | 28041 | 2040 | 45 |
1723825 | 1723825 | 2021-09-16 | Greene | Mississippi | 28041 | 2026 | 45 |
1720576 | 1720576 | 2021-09-15 | Greene | Mississippi | 28041 | 2020 | 45 |
1717328 | 1717328 | 2021-09-14 | Greene | Mississippi | 28041 | 2015 | 44 |
1714080 | 1714080 | 2021-09-13 | Greene | Mississippi | 28041 | 2006 | 44 |
1710834 | 1710834 | 2021-09-12 | Greene | Mississippi | 28041 | 1975 | 42 |
1707587 | 1707587 | 2021-09-11 | Greene | Mississippi | 28041 | 1975 | 42 |
1704340 | 1704340 | 2021-09-10 | Greene | Mississippi | 28041 | 1975 | 42 |
1701090 | 1701090 | 2021-09-09 | Greene | Mississippi | 28041 | 1969 | 42 |
1697841 | 1697841 | 2021-09-08 | Greene | Mississippi | 28041 | 1960 | 42 |
1694593 | 1694593 | 2021-09-07 | Greene | Mississippi | 28041 | 1951 | 41 |
1691344 | 1691344 | 2021-09-06 | Greene | Mississippi | 28041 | 1950 | 41 |
1688094 | 1688094 | 2021-09-05 | Greene | Mississippi | 28041 | 1935 | 41 |
1684844 | 1684844 | 2021-09-04 | Greene | Mississippi | 28041 | 1935 | 41 |
1681593 | 1681593 | 2021-09-03 | Greene | Mississippi | 28041 | 1935 | 41 |
1678345 | 1678345 | 2021-09-02 | Greene | Mississippi | 28041 | 1928 | 41 |
1675097 | 1675097 | 2021-09-01 | Greene | Mississippi | 28041 | 1891 | 41 |
1671849 | 1671849 | 2021-08-31 | Greene | Mississippi | 28041 | 1870 | 41 |
1668602 | 1668602 | 2021-08-30 | Greene | Mississippi | 28041 | 1865 | 40 |
1665355 | 1665355 | 2021-08-29 | Greene | Mississippi | 28041 | 1830 | 40 |
1662107 | 1662107 | 2021-08-28 | Greene | Mississippi | 28041 | 1830 | 40 |
1658859 | 1658859 | 2021-08-27 | Greene | Mississippi | 28041 | 1830 | 40 |
1655610 | 1655610 | 2021-08-26 | Greene | Mississippi | 28041 | 1817 | 39 |
1652363 | 1652363 | 2021-08-25 | Greene | Mississippi | 28041 | 1808 | 39 |
1649115 | 1649115 | 2021-08-24 | Greene | Mississippi | 28041 | 1795 | 39 |
1645866 | 1645866 | 2021-08-23 | Greene | Mississippi | 28041 | 1772 | 39 |
1642617 | 1642617 | 2021-08-22 | Greene | Mississippi | 28041 | 1737 | 39 |
1639367 | 1639367 | 2021-08-21 | Greene | Mississippi | 28041 | 1737 | 39 |
1636117 | 1636117 | 2021-08-20 | Greene | Mississippi | 28041 | 1737 | 39 |
1632867 | 1632867 | 2021-08-19 | Greene | Mississippi | 28041 | 1711 | 39 |
1629620 | 1629620 | 2021-08-18 | Greene | Mississippi | 28041 | 1681 | 39 |
1626373 | 1626373 | 2021-08-17 | Greene | Mississippi | 28041 | 1644 | 39 |
1623126 | 1623126 | 2021-08-16 | Greene | Mississippi | 28041 | 1622 | 38 |
1619879 | 1619879 | 2021-08-15 | Greene | Mississippi | 28041 | 1586 | 38 |
1616631 | 1616631 | 2021-08-14 | Greene | Mississippi | 28041 | 1586 | 38 |
1613383 | 1613383 | 2021-08-13 | Greene | Mississippi | 28041 | 1586 | 38 |
1610134 | 1610134 | 2021-08-12 | Greene | Mississippi | 28041 | 1559 | 38 |
1606886 | 1606886 | 2021-08-11 | Greene | Mississippi | 28041 | 1534 | 35 |
1603637 | 1603637 | 2021-08-10 | Greene | Mississippi | 28041 | 1524 | 35 |
1600388 | 1600388 | 2021-08-09 | Greene | Mississippi | 28041 | 1501 | 35 |
1597140 | 1597140 | 2021-08-08 | Greene | Mississippi | 28041 | 1477 | 35 |
1593891 | 1593891 | 2021-08-07 | Greene | Mississippi | 28041 | 1477 | 35 |
1590642 | 1590642 | 2021-08-06 | Greene | Mississippi | 28041 | 1477 | 35 |
1587393 | 1587393 | 2021-08-05 | Greene | Mississippi | 28041 | 1461 | 35 |
1584142 | 1584142 | 2021-08-04 | Greene | Mississippi | 28041 | 1447 | 35 |
1580893 | 1580893 | 2021-08-03 | Greene | Mississippi | 28041 | 1419 | 35 |
1577644 | 1577644 | 2021-08-02 | Greene | Mississippi | 28041 | 1418 | 35 |
1574396 | 1574396 | 2021-08-01 | Greene | Mississippi | 28041 | 1401 | 34 |
1571148 | 1571148 | 2021-07-31 | Greene | Mississippi | 28041 | 1401 | 34 |
1567900 | 1567900 | 2021-07-30 | Greene | Mississippi | 28041 | 1401 | 34 |
1564652 | 1564652 | 2021-07-29 | Greene | Mississippi | 28041 | 1397 | 34 |
1561404 | 1561404 | 2021-07-28 | Greene | Mississippi | 28041 | 1384 | 34 |
1558156 | 1558156 | 2021-07-27 | Greene | Mississippi | 28041 | 1376 | 34 |
1554909 | 1554909 | 2021-07-26 | Greene | Mississippi | 28041 | 1368 | 34 |
1551662 | 1551662 | 2021-07-25 | Greene | Mississippi | 28041 | 1357 | 34 |
1548415 | 1548415 | 2021-07-24 | Greene | Mississippi | 28041 | 1357 | 34 |
1545168 | 1545168 | 2021-07-23 | Greene | Mississippi | 28041 | 1357 | 34 |
1541920 | 1541920 | 2021-07-22 | Greene | Mississippi | 28041 | 1349 | 34 |
1538673 | 1538673 | 2021-07-21 | Greene | Mississippi | 28041 | 1343 | 34 |
1535426 | 1535426 | 2021-07-20 | Greene | Mississippi | 28041 | 1341 | 34 |
1532178 | 1532178 | 2021-07-19 | Greene | Mississippi | 28041 | 1339 | 34 |
1528931 | 1528931 | 2021-07-18 | Greene | Mississippi | 28041 | 1331 | 34 |
1525684 | 1525684 | 2021-07-17 | Greene | Mississippi | 28041 | 1331 | 34 |
1522437 | 1522437 | 2021-07-16 | Greene | Mississippi | 28041 | 1331 | 34 |
1519188 | 1519188 | 2021-07-15 | Greene | Mississippi | 28041 | 1331 | 34 |
1515941 | 1515941 | 2021-07-14 | Greene | Mississippi | 28041 | 1330 | 34 |
1512695 | 1512695 | 2021-07-13 | Greene | Mississippi | 28041 | 1327 | 34 |
1509448 | 1509448 | 2021-07-12 | Greene | Mississippi | 28041 | 1327 | 34 |
1506202 | 1506202 | 2021-07-11 | Greene | Mississippi | 28041 | 1324 | 34 |
1502956 | 1502956 | 2021-07-10 | Greene | Mississippi | 28041 | 1324 | 34 |
1499710 | 1499710 | 2021-07-09 | Greene | Mississippi | 28041 | 1324 | 34 |
1496464 | 1496464 | 2021-07-08 | Greene | Mississippi | 28041 | 1323 | 34 |
1493217 | 1493217 | 2021-07-07 | Greene | Mississippi | 28041 | 1323 | 34 |
1489970 | 1489970 | 2021-07-06 | Greene | Mississippi | 28041 | 1322 | 34 |
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);