ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28093 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948058 | 1948058 | 2021-11-24 | Marshall | Mississippi | 28093 | 6653 | 141 |
1944807 | 1944807 | 2021-11-23 | Marshall | Mississippi | 28093 | 6650 | 141 |
1941556 | 1941556 | 2021-11-22 | Marshall | Mississippi | 28093 | 6647 | 141 |
1938306 | 1938306 | 2021-11-21 | Marshall | Mississippi | 28093 | 6614 | 141 |
1935056 | 1935056 | 2021-11-20 | Marshall | Mississippi | 28093 | 6614 | 141 |
1931806 | 1931806 | 2021-11-19 | Marshall | Mississippi | 28093 | 6614 | 141 |
1928555 | 1928555 | 2021-11-18 | Marshall | Mississippi | 28093 | 6604 | 141 |
1925305 | 1925305 | 2021-11-17 | Marshall | Mississippi | 28093 | 6595 | 139 |
1922056 | 1922056 | 2021-11-16 | Marshall | Mississippi | 28093 | 6591 | 139 |
1918806 | 1918806 | 2021-11-15 | Marshall | Mississippi | 28093 | 6586 | 139 |
1915556 | 1915556 | 2021-11-14 | Marshall | Mississippi | 28093 | 6573 | 139 |
1912306 | 1912306 | 2021-11-13 | Marshall | Mississippi | 28093 | 6573 | 139 |
1909056 | 1909056 | 2021-11-12 | Marshall | Mississippi | 28093 | 6573 | 139 |
1905807 | 1905807 | 2021-11-11 | Marshall | Mississippi | 28093 | 6552 | 139 |
1902558 | 1902558 | 2021-11-10 | Marshall | Mississippi | 28093 | 6552 | 139 |
1899308 | 1899308 | 2021-11-09 | Marshall | Mississippi | 28093 | 6550 | 139 |
1896058 | 1896058 | 2021-11-08 | Marshall | Mississippi | 28093 | 6539 | 139 |
1892808 | 1892808 | 2021-11-07 | Marshall | Mississippi | 28093 | 6530 | 139 |
1889558 | 1889558 | 2021-11-06 | Marshall | Mississippi | 28093 | 6530 | 139 |
1886308 | 1886308 | 2021-11-05 | Marshall | Mississippi | 28093 | 6530 | 139 |
1883059 | 1883059 | 2021-11-04 | Marshall | Mississippi | 28093 | 6528 | 139 |
1879810 | 1879810 | 2021-11-03 | Marshall | Mississippi | 28093 | 6521 | 139 |
1876561 | 1876561 | 2021-11-02 | Marshall | Mississippi | 28093 | 6517 | 139 |
1873312 | 1873312 | 2021-11-01 | Marshall | Mississippi | 28093 | 6514 | 137 |
1870063 | 1870063 | 2021-10-31 | Marshall | Mississippi | 28093 | 6504 | 137 |
1866814 | 1866814 | 2021-10-30 | Marshall | Mississippi | 28093 | 6504 | 137 |
1863565 | 1863565 | 2021-10-29 | Marshall | Mississippi | 28093 | 6504 | 137 |
1860316 | 1860316 | 2021-10-28 | Marshall | Mississippi | 28093 | 6503 | 136 |
1857067 | 1857067 | 2021-10-27 | Marshall | Mississippi | 28093 | 6495 | 135 |
1853818 | 1853818 | 2021-10-26 | Marshall | Mississippi | 28093 | 6494 | 135 |
1850569 | 1850569 | 2021-10-25 | Marshall | Mississippi | 28093 | 6476 | 135 |
1847319 | 1847319 | 2021-10-24 | Marshall | Mississippi | 28093 | 6467 | 134 |
1844069 | 1844069 | 2021-10-23 | Marshall | Mississippi | 28093 | 6467 | 134 |
1840819 | 1840819 | 2021-10-22 | Marshall | Mississippi | 28093 | 6467 | 134 |
1837570 | 1837570 | 2021-10-21 | Marshall | Mississippi | 28093 | 6462 | 134 |
1834321 | 1834321 | 2021-10-20 | Marshall | Mississippi | 28093 | 6460 | 134 |
1831072 | 1831072 | 2021-10-19 | Marshall | Mississippi | 28093 | 6453 | 133 |
1827823 | 1827823 | 2021-10-18 | Marshall | Mississippi | 28093 | 6398 | 132 |
1824574 | 1824574 | 2021-10-17 | Marshall | Mississippi | 28093 | 6386 | 132 |
1821325 | 1821325 | 2021-10-16 | Marshall | Mississippi | 28093 | 6386 | 132 |
1818076 | 1818076 | 2021-10-15 | Marshall | Mississippi | 28093 | 6386 | 132 |
1814827 | 1814827 | 2021-10-14 | Marshall | Mississippi | 28093 | 6378 | 132 |
1811579 | 1811579 | 2021-10-13 | Marshall | Mississippi | 28093 | 6365 | 132 |
1808330 | 1808330 | 2021-10-12 | Marshall | Mississippi | 28093 | 6352 | 131 |
1805079 | 1805079 | 2021-10-11 | Marshall | Mississippi | 28093 | 6341 | 130 |
1801830 | 1801830 | 2021-10-10 | Marshall | Mississippi | 28093 | 6311 | 130 |
1798581 | 1798581 | 2021-10-09 | Marshall | Mississippi | 28093 | 6311 | 130 |
1795332 | 1795332 | 2021-10-08 | Marshall | Mississippi | 28093 | 6311 | 130 |
1792083 | 1792083 | 2021-10-07 | Marshall | Mississippi | 28093 | 6302 | 130 |
1788834 | 1788834 | 2021-10-06 | Marshall | Mississippi | 28093 | 6271 | 130 |
1785586 | 1785586 | 2021-10-05 | Marshall | Mississippi | 28093 | 6268 | 130 |
1782337 | 1782337 | 2021-10-04 | Marshall | Mississippi | 28093 | 6259 | 128 |
1779087 | 1779087 | 2021-10-03 | Marshall | Mississippi | 28093 | 6229 | 128 |
1775837 | 1775837 | 2021-10-02 | Marshall | Mississippi | 28093 | 6229 | 128 |
1772587 | 1772587 | 2021-10-01 | Marshall | Mississippi | 28093 | 6229 | 128 |
1769338 | 1769338 | 2021-09-30 | Marshall | Mississippi | 28093 | 6215 | 128 |
1766089 | 1766089 | 2021-09-29 | Marshall | Mississippi | 28093 | 6200 | 127 |
1762840 | 1762840 | 2021-09-28 | Marshall | Mississippi | 28093 | 6186 | 126 |
1759591 | 1759591 | 2021-09-27 | Marshall | Mississippi | 28093 | 6165 | 126 |
1756343 | 1756343 | 2021-09-26 | Marshall | Mississippi | 28093 | 6126 | 123 |
1753095 | 1753095 | 2021-09-25 | Marshall | Mississippi | 28093 | 6126 | 123 |
1749847 | 1749847 | 2021-09-24 | Marshall | Mississippi | 28093 | 6126 | 123 |
1746597 | 1746597 | 2021-09-23 | Marshall | Mississippi | 28093 | 6102 | 121 |
1743348 | 1743348 | 2021-09-22 | Marshall | Mississippi | 28093 | 6068 | 121 |
1740099 | 1740099 | 2021-09-21 | Marshall | Mississippi | 28093 | 6045 | 121 |
1736850 | 1736850 | 2021-09-20 | Marshall | Mississippi | 28093 | 6016 | 118 |
1733600 | 1733600 | 2021-09-19 | Marshall | Mississippi | 28093 | 5972 | 118 |
1730350 | 1730350 | 2021-09-18 | Marshall | Mississippi | 28093 | 5972 | 118 |
1727100 | 1727100 | 2021-09-17 | Marshall | Mississippi | 28093 | 5972 | 118 |
1723851 | 1723851 | 2021-09-16 | Marshall | Mississippi | 28093 | 5948 | 116 |
1720602 | 1720602 | 2021-09-15 | Marshall | Mississippi | 28093 | 5917 | 115 |
1717354 | 1717354 | 2021-09-14 | Marshall | Mississippi | 28093 | 5883 | 115 |
1714106 | 1714106 | 2021-09-13 | Marshall | Mississippi | 28093 | 5858 | 115 |
1710860 | 1710860 | 2021-09-12 | Marshall | Mississippi | 28093 | 5779 | 115 |
1707613 | 1707613 | 2021-09-11 | Marshall | Mississippi | 28093 | 5779 | 115 |
1704366 | 1704366 | 2021-09-10 | Marshall | Mississippi | 28093 | 5779 | 115 |
1701116 | 1701116 | 2021-09-09 | Marshall | Mississippi | 28093 | 5762 | 115 |
1697867 | 1697867 | 2021-09-08 | Marshall | Mississippi | 28093 | 5731 | 115 |
1694619 | 1694619 | 2021-09-07 | Marshall | Mississippi | 28093 | 5671 | 115 |
1691370 | 1691370 | 2021-09-06 | Marshall | Mississippi | 28093 | 5665 | 115 |
1688120 | 1688120 | 2021-09-05 | Marshall | Mississippi | 28093 | 5612 | 114 |
1684870 | 1684870 | 2021-09-04 | Marshall | Mississippi | 28093 | 5612 | 114 |
1681619 | 1681619 | 2021-09-03 | Marshall | Mississippi | 28093 | 5612 | 114 |
1678371 | 1678371 | 2021-09-02 | Marshall | Mississippi | 28093 | 5574 | 114 |
1675123 | 1675123 | 2021-09-01 | Marshall | Mississippi | 28093 | 5552 | 114 |
1671875 | 1671875 | 2021-08-31 | Marshall | Mississippi | 28093 | 5528 | 113 |
1668628 | 1668628 | 2021-08-30 | Marshall | Mississippi | 28093 | 5509 | 112 |
1665381 | 1665381 | 2021-08-29 | Marshall | Mississippi | 28093 | 5394 | 111 |
1662133 | 1662133 | 2021-08-28 | Marshall | Mississippi | 28093 | 5394 | 111 |
1658885 | 1658885 | 2021-08-27 | Marshall | Mississippi | 28093 | 5394 | 111 |
1655636 | 1655636 | 2021-08-26 | Marshall | Mississippi | 28093 | 5357 | 110 |
1652389 | 1652389 | 2021-08-25 | Marshall | Mississippi | 28093 | 5317 | 108 |
1649141 | 1649141 | 2021-08-24 | Marshall | Mississippi | 28093 | 5291 | 108 |
1645892 | 1645892 | 2021-08-23 | Marshall | Mississippi | 28093 | 5243 | 108 |
1642643 | 1642643 | 2021-08-22 | Marshall | Mississippi | 28093 | 5155 | 108 |
1639393 | 1639393 | 2021-08-21 | Marshall | Mississippi | 28093 | 5155 | 108 |
1636143 | 1636143 | 2021-08-20 | Marshall | Mississippi | 28093 | 5155 | 108 |
1632893 | 1632893 | 2021-08-19 | Marshall | Mississippi | 28093 | 5129 | 107 |
1629646 | 1629646 | 2021-08-18 | Marshall | Mississippi | 28093 | 5083 | 107 |
1626399 | 1626399 | 2021-08-17 | Marshall | Mississippi | 28093 | 5063 | 106 |
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);