ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811577 | 1811577 | 2021-10-13 | Madison | Mississippi | 28089 | 14507 | 278 |
1808328 | 1808328 | 2021-10-12 | Madison | Mississippi | 28089 | 14497 | 277 |
1805077 | 1805077 | 2021-10-11 | Madison | Mississippi | 28089 | 14478 | 277 |
1801828 | 1801828 | 2021-10-10 | Madison | Mississippi | 28089 | 14463 | 277 |
1798579 | 1798579 | 2021-10-09 | Madison | Mississippi | 28089 | 14463 | 277 |
1795330 | 1795330 | 2021-10-08 | Madison | Mississippi | 28089 | 14463 | 277 |
1792081 | 1792081 | 2021-10-07 | Madison | Mississippi | 28089 | 14451 | 277 |
1788832 | 1788832 | 2021-10-06 | Madison | Mississippi | 28089 | 14419 | 277 |
1785584 | 1785584 | 2021-10-05 | Madison | Mississippi | 28089 | 14407 | 277 |
1782335 | 1782335 | 2021-10-04 | Madison | Mississippi | 28089 | 14389 | 275 |
1779085 | 1779085 | 2021-10-03 | Madison | Mississippi | 28089 | 14356 | 275 |
1775835 | 1775835 | 2021-10-02 | Madison | Mississippi | 28089 | 14356 | 275 |
1772585 | 1772585 | 2021-10-01 | Madison | Mississippi | 28089 | 14356 | 275 |
1769336 | 1769336 | 2021-09-30 | Madison | Mississippi | 28089 | 14345 | 274 |
1766087 | 1766087 | 2021-09-29 | Madison | Mississippi | 28089 | 14314 | 274 |
1762838 | 1762838 | 2021-09-28 | Madison | Mississippi | 28089 | 14297 | 273 |
1759589 | 1759589 | 2021-09-27 | Madison | Mississippi | 28089 | 14206 | 272 |
1756341 | 1756341 | 2021-09-26 | Madison | Mississippi | 28089 | 14166 | 271 |
1753093 | 1753093 | 2021-09-25 | Madison | Mississippi | 28089 | 14166 | 271 |
1749845 | 1749845 | 2021-09-24 | Madison | Mississippi | 28089 | 14166 | 271 |
1746595 | 1746595 | 2021-09-23 | Madison | Mississippi | 28089 | 14145 | 271 |
1743346 | 1743346 | 2021-09-22 | Madison | Mississippi | 28089 | 14120 | 271 |
1740097 | 1740097 | 2021-09-21 | Madison | Mississippi | 28089 | 14101 | 270 |
1736848 | 1736848 | 2021-09-20 | Madison | Mississippi | 28089 | 14086 | 269 |
1733598 | 1733598 | 2021-09-19 | Madison | Mississippi | 28089 | 14043 | 265 |
1730348 | 1730348 | 2021-09-18 | Madison | Mississippi | 28089 | 14043 | 265 |
1727098 | 1727098 | 2021-09-17 | Madison | Mississippi | 28089 | 14043 | 265 |
1723849 | 1723849 | 2021-09-16 | Madison | Mississippi | 28089 | 13993 | 264 |
1720600 | 1720600 | 2021-09-15 | Madison | Mississippi | 28089 | 13961 | 263 |
1717352 | 1717352 | 2021-09-14 | Madison | Mississippi | 28089 | 13914 | 263 |
1714104 | 1714104 | 2021-09-13 | Madison | Mississippi | 28089 | 13880 | 262 |
1710858 | 1710858 | 2021-09-12 | Madison | Mississippi | 28089 | 13807 | 262 |
1707611 | 1707611 | 2021-09-11 | Madison | Mississippi | 28089 | 13807 | 262 |
1704364 | 1704364 | 2021-09-10 | Madison | Mississippi | 28089 | 13807 | 262 |
1701114 | 1701114 | 2021-09-09 | Madison | Mississippi | 28089 | 13756 | 261 |
1697865 | 1697865 | 2021-09-08 | Madison | Mississippi | 28089 | 13665 | 260 |
1694617 | 1694617 | 2021-09-07 | Madison | Mississippi | 28089 | 13625 | 259 |
1691368 | 1691368 | 2021-09-06 | Madison | Mississippi | 28089 | 13607 | 259 |
1688118 | 1688118 | 2021-09-05 | Madison | Mississippi | 28089 | 13418 | 256 |
1684868 | 1684868 | 2021-09-04 | Madison | Mississippi | 28089 | 13418 | 256 |
1681617 | 1681617 | 2021-09-03 | Madison | Mississippi | 28089 | 13418 | 256 |
1678369 | 1678369 | 2021-09-02 | Madison | Mississippi | 28089 | 13353 | 256 |
1675121 | 1675121 | 2021-09-01 | Madison | Mississippi | 28089 | 13302 | 256 |
1671873 | 1671873 | 2021-08-31 | Madison | Mississippi | 28089 | 13261 | 255 |
1668626 | 1668626 | 2021-08-30 | Madison | Mississippi | 28089 | 13239 | 252 |
1665379 | 1665379 | 2021-08-29 | Madison | Mississippi | 28089 | 12941 | 248 |
1662131 | 1662131 | 2021-08-28 | Madison | Mississippi | 28089 | 12941 | 248 |
1658883 | 1658883 | 2021-08-27 | Madison | Mississippi | 28089 | 12941 | 248 |
1655634 | 1655634 | 2021-08-26 | Madison | Mississippi | 28089 | 12887 | 246 |
1652387 | 1652387 | 2021-08-25 | Madison | Mississippi | 28089 | 12793 | 245 |
1649139 | 1649139 | 2021-08-24 | Madison | Mississippi | 28089 | 12659 | 244 |
1645890 | 1645890 | 2021-08-23 | Madison | Mississippi | 28089 | 12619 | 242 |
1642641 | 1642641 | 2021-08-22 | Madison | Mississippi | 28089 | 12520 | 241 |
1639391 | 1639391 | 2021-08-21 | Madison | Mississippi | 28089 | 12520 | 241 |
1636141 | 1636141 | 2021-08-20 | Madison | Mississippi | 28089 | 12520 | 241 |
1632891 | 1632891 | 2021-08-19 | Madison | Mississippi | 28089 | 12335 | 241 |
1629644 | 1629644 | 2021-08-18 | Madison | Mississippi | 28089 | 12165 | 240 |
1626397 | 1626397 | 2021-08-17 | Madison | Mississippi | 28089 | 12044 | 239 |
1623150 | 1623150 | 2021-08-16 | Madison | Mississippi | 28089 | 11955 | 237 |
1619903 | 1619903 | 2021-08-15 | Madison | Mississippi | 28089 | 11789 | 235 |
1616655 | 1616655 | 2021-08-14 | Madison | Mississippi | 28089 | 11789 | 235 |
1613407 | 1613407 | 2021-08-13 | Madison | Mississippi | 28089 | 11789 | 235 |
1610158 | 1610158 | 2021-08-12 | Madison | Mississippi | 28089 | 11711 | 233 |
1606910 | 1606910 | 2021-08-11 | Madison | Mississippi | 28089 | 11620 | 233 |
1603661 | 1603661 | 2021-08-10 | Madison | Mississippi | 28089 | 11559 | 233 |
1600412 | 1600412 | 2021-08-09 | Madison | Mississippi | 28089 | 11512 | 232 |
1597164 | 1597164 | 2021-08-08 | Madison | Mississippi | 28089 | 11352 | 230 |
1593915 | 1593915 | 2021-08-07 | Madison | Mississippi | 28089 | 11352 | 230 |
1590666 | 1590666 | 2021-08-06 | Madison | Mississippi | 28089 | 11352 | 230 |
1587417 | 1587417 | 2021-08-05 | Madison | Mississippi | 28089 | 11306 | 229 |
1584166 | 1584166 | 2021-08-04 | Madison | Mississippi | 28089 | 11224 | 227 |
1580917 | 1580917 | 2021-08-03 | Madison | Mississippi | 28089 | 11171 | 227 |
1577668 | 1577668 | 2021-08-02 | Madison | Mississippi | 28089 | 11114 | 227 |
1574420 | 1574420 | 2021-08-01 | Madison | Mississippi | 28089 | 10959 | 227 |
1571172 | 1571172 | 2021-07-31 | Madison | Mississippi | 28089 | 10959 | 227 |
1567924 | 1567924 | 2021-07-30 | Madison | Mississippi | 28089 | 10959 | 227 |
1564676 | 1564676 | 2021-07-29 | Madison | Mississippi | 28089 | 10917 | 227 |
1561428 | 1561428 | 2021-07-28 | Madison | Mississippi | 28089 | 10864 | 227 |
1558180 | 1558180 | 2021-07-27 | Madison | Mississippi | 28089 | 10806 | 227 |
1554933 | 1554933 | 2021-07-26 | Madison | Mississippi | 28089 | 10787 | 227 |
1551686 | 1551686 | 2021-07-25 | Madison | Mississippi | 28089 | 10692 | 227 |
1548439 | 1548439 | 2021-07-24 | Madison | Mississippi | 28089 | 10692 | 227 |
1545192 | 1545192 | 2021-07-23 | Madison | Mississippi | 28089 | 10692 | 227 |
1541944 | 1541944 | 2021-07-22 | Madison | Mississippi | 28089 | 10658 | 227 |
1538697 | 1538697 | 2021-07-21 | Madison | Mississippi | 28089 | 10616 | 227 |
1535450 | 1535450 | 2021-07-20 | Madison | Mississippi | 28089 | 10589 | 227 |
1532202 | 1532202 | 2021-07-19 | Madison | Mississippi | 28089 | 10576 | 227 |
1528955 | 1528955 | 2021-07-18 | Madison | Mississippi | 28089 | 10498 | 227 |
1525708 | 1525708 | 2021-07-17 | Madison | Mississippi | 28089 | 10498 | 227 |
1522461 | 1522461 | 2021-07-16 | Madison | Mississippi | 28089 | 10498 | 227 |
1519212 | 1519212 | 2021-07-15 | Madison | Mississippi | 28089 | 10489 | 227 |
1515965 | 1515965 | 2021-07-14 | Madison | Mississippi | 28089 | 10466 | 227 |
1512719 | 1512719 | 2021-07-13 | Madison | Mississippi | 28089 | 10440 | 227 |
1509472 | 1509472 | 2021-07-12 | Madison | Mississippi | 28089 | 10431 | 227 |
1506226 | 1506226 | 2021-07-11 | Madison | Mississippi | 28089 | 10391 | 227 |
1502980 | 1502980 | 2021-07-10 | Madison | Mississippi | 28089 | 10391 | 227 |
1499734 | 1499734 | 2021-07-09 | Madison | Mississippi | 28089 | 10391 | 227 |
1496488 | 1496488 | 2021-07-08 | Madison | Mississippi | 28089 | 10382 | 227 |
1493241 | 1493241 | 2021-07-07 | Madison | Mississippi | 28089 | 10369 | 227 |
1489994 | 1489994 | 2021-07-06 | Madison | Mississippi | 28089 | 10356 | 227 |
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);