ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Marshall" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1623152 | 1623152 | 2021-08-16 | Marshall | Mississippi | 28093 | 5058 | 106 |
1619905 | 1619905 | 2021-08-15 | Marshall | Mississippi | 28093 | 4977 | 106 |
1616657 | 1616657 | 2021-08-14 | Marshall | Mississippi | 28093 | 4977 | 106 |
1613409 | 1613409 | 2021-08-13 | Marshall | Mississippi | 28093 | 4977 | 106 |
1610160 | 1610160 | 2021-08-12 | Marshall | Mississippi | 28093 | 4946 | 106 |
1606912 | 1606912 | 2021-08-11 | Marshall | Mississippi | 28093 | 4915 | 106 |
1603663 | 1603663 | 2021-08-10 | Marshall | Mississippi | 28093 | 4902 | 106 |
1600414 | 1600414 | 2021-08-09 | Marshall | Mississippi | 28093 | 4871 | 106 |
1597166 | 1597166 | 2021-08-08 | Marshall | Mississippi | 28093 | 4798 | 106 |
1593917 | 1593917 | 2021-08-07 | Marshall | Mississippi | 28093 | 4798 | 106 |
1590668 | 1590668 | 2021-08-06 | Marshall | Mississippi | 28093 | 4798 | 106 |
1587419 | 1587419 | 2021-08-05 | Marshall | Mississippi | 28093 | 4783 | 106 |
1584168 | 1584168 | 2021-08-04 | Marshall | Mississippi | 28093 | 4759 | 106 |
1580919 | 1580919 | 2021-08-03 | Marshall | Mississippi | 28093 | 4739 | 106 |
1577670 | 1577670 | 2021-08-02 | Marshall | Mississippi | 28093 | 4725 | 106 |
1574422 | 1574422 | 2021-08-01 | Marshall | Mississippi | 28093 | 4701 | 106 |
1571174 | 1571174 | 2021-07-31 | Marshall | Mississippi | 28093 | 4701 | 106 |
1567926 | 1567926 | 2021-07-30 | Marshall | Mississippi | 28093 | 4701 | 106 |
1564678 | 1564678 | 2021-07-29 | Marshall | Mississippi | 28093 | 4691 | 106 |
1561430 | 1561430 | 2021-07-28 | Marshall | Mississippi | 28093 | 4677 | 106 |
1558182 | 1558182 | 2021-07-27 | Marshall | Mississippi | 28093 | 4670 | 106 |
1554935 | 1554935 | 2021-07-26 | Marshall | Mississippi | 28093 | 4665 | 106 |
1551688 | 1551688 | 2021-07-25 | Marshall | Mississippi | 28093 | 4654 | 106 |
1548441 | 1548441 | 2021-07-24 | Marshall | Mississippi | 28093 | 4654 | 106 |
1545194 | 1545194 | 2021-07-23 | Marshall | Mississippi | 28093 | 4654 | 106 |
1541946 | 1541946 | 2021-07-22 | Marshall | Mississippi | 28093 | 4648 | 106 |
1538699 | 1538699 | 2021-07-21 | Marshall | Mississippi | 28093 | 4641 | 106 |
1535452 | 1535452 | 2021-07-20 | Marshall | Mississippi | 28093 | 4634 | 106 |
1532204 | 1532204 | 2021-07-19 | Marshall | Mississippi | 28093 | 4635 | 106 |
1528957 | 1528957 | 2021-07-18 | Marshall | Mississippi | 28093 | 4621 | 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);