ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Tate" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850591 | 1850591 | 2021-10-25 | Tate | Mississippi | 28137 | 4592 | 111 |
1847341 | 1847341 | 2021-10-24 | Tate | Mississippi | 28137 | 4588 | 111 |
1844091 | 1844091 | 2021-10-23 | Tate | Mississippi | 28137 | 4588 | 111 |
1840841 | 1840841 | 2021-10-22 | Tate | Mississippi | 28137 | 4588 | 111 |
1837592 | 1837592 | 2021-10-21 | Tate | Mississippi | 28137 | 4584 | 110 |
1834343 | 1834343 | 2021-10-20 | Tate | Mississippi | 28137 | 4579 | 109 |
1831094 | 1831094 | 2021-10-19 | Tate | Mississippi | 28137 | 4569 | 109 |
1827845 | 1827845 | 2021-10-18 | Tate | Mississippi | 28137 | 4553 | 109 |
1824596 | 1824596 | 2021-10-17 | Tate | Mississippi | 28137 | 4546 | 109 |
1821347 | 1821347 | 2021-10-16 | Tate | Mississippi | 28137 | 4546 | 109 |
1818098 | 1818098 | 2021-10-15 | Tate | Mississippi | 28137 | 4546 | 109 |
1814849 | 1814849 | 2021-10-14 | Tate | Mississippi | 28137 | 4539 | 109 |
1811601 | 1811601 | 2021-10-13 | Tate | Mississippi | 28137 | 4534 | 108 |
1808352 | 1808352 | 2021-10-12 | Tate | Mississippi | 28137 | 4527 | 108 |
1805101 | 1805101 | 2021-10-11 | Tate | Mississippi | 28137 | 4521 | 108 |
1801852 | 1801852 | 2021-10-10 | Tate | Mississippi | 28137 | 4512 | 107 |
1798603 | 1798603 | 2021-10-09 | Tate | Mississippi | 28137 | 4512 | 107 |
1795354 | 1795354 | 2021-10-08 | Tate | Mississippi | 28137 | 4512 | 107 |
1792105 | 1792105 | 2021-10-07 | Tate | Mississippi | 28137 | 4506 | 107 |
1788856 | 1788856 | 2021-10-06 | Tate | Mississippi | 28137 | 4488 | 107 |
1785608 | 1785608 | 2021-10-05 | Tate | Mississippi | 28137 | 4484 | 106 |
1782359 | 1782359 | 2021-10-04 | Tate | Mississippi | 28137 | 4477 | 106 |
1779109 | 1779109 | 2021-10-03 | Tate | Mississippi | 28137 | 4451 | 106 |
1775859 | 1775859 | 2021-10-02 | Tate | Mississippi | 28137 | 4451 | 106 |
1772609 | 1772609 | 2021-10-01 | Tate | Mississippi | 28137 | 4451 | 106 |
1769360 | 1769360 | 2021-09-30 | Tate | Mississippi | 28137 | 4447 | 104 |
1766111 | 1766111 | 2021-09-29 | Tate | Mississippi | 28137 | 4441 | 103 |
1762862 | 1762862 | 2021-09-28 | Tate | Mississippi | 28137 | 4429 | 103 |
1759613 | 1759613 | 2021-09-27 | Tate | Mississippi | 28137 | 4420 | 103 |
1756365 | 1756365 | 2021-09-26 | Tate | Mississippi | 28137 | 4394 | 101 |
1753117 | 1753117 | 2021-09-25 | Tate | Mississippi | 28137 | 4394 | 101 |
1749869 | 1749869 | 2021-09-24 | Tate | Mississippi | 28137 | 4394 | 101 |
1746619 | 1746619 | 2021-09-23 | Tate | Mississippi | 28137 | 4351 | 101 |
1743370 | 1743370 | 2021-09-22 | Tate | Mississippi | 28137 | 4327 | 101 |
1740121 | 1740121 | 2021-09-21 | Tate | Mississippi | 28137 | 4309 | 101 |
1736872 | 1736872 | 2021-09-20 | Tate | Mississippi | 28137 | 4262 | 100 |
1733622 | 1733622 | 2021-09-19 | Tate | Mississippi | 28137 | 4234 | 100 |
1730372 | 1730372 | 2021-09-18 | Tate | Mississippi | 28137 | 4234 | 100 |
1727122 | 1727122 | 2021-09-17 | Tate | Mississippi | 28137 | 4234 | 100 |
1723873 | 1723873 | 2021-09-16 | Tate | Mississippi | 28137 | 4202 | 100 |
1720624 | 1720624 | 2021-09-15 | Tate | Mississippi | 28137 | 4189 | 99 |
1717376 | 1717376 | 2021-09-14 | Tate | Mississippi | 28137 | 4168 | 98 |
1714128 | 1714128 | 2021-09-13 | Tate | Mississippi | 28137 | 4144 | 96 |
1710882 | 1710882 | 2021-09-12 | Tate | Mississippi | 28137 | 4099 | 96 |
1707635 | 1707635 | 2021-09-11 | Tate | Mississippi | 28137 | 4099 | 96 |
1704388 | 1704388 | 2021-09-10 | Tate | Mississippi | 28137 | 4099 | 96 |
1701138 | 1701138 | 2021-09-09 | Tate | Mississippi | 28137 | 4067 | 94 |
1697889 | 1697889 | 2021-09-08 | Tate | Mississippi | 28137 | 4043 | 94 |
1694641 | 1694641 | 2021-09-07 | Tate | Mississippi | 28137 | 4030 | 93 |
1691392 | 1691392 | 2021-09-06 | Tate | Mississippi | 28137 | 4025 | 93 |
1688142 | 1688142 | 2021-09-05 | Tate | Mississippi | 28137 | 3975 | 93 |
1684892 | 1684892 | 2021-09-04 | Tate | Mississippi | 28137 | 3975 | 93 |
1681641 | 1681641 | 2021-09-03 | Tate | Mississippi | 28137 | 3975 | 93 |
1678393 | 1678393 | 2021-09-02 | Tate | Mississippi | 28137 | 3956 | 93 |
1675145 | 1675145 | 2021-09-01 | Tate | Mississippi | 28137 | 3917 | 93 |
1671897 | 1671897 | 2021-08-31 | Tate | Mississippi | 28137 | 3898 | 93 |
1668650 | 1668650 | 2021-08-30 | Tate | Mississippi | 28137 | 3889 | 90 |
1665403 | 1665403 | 2021-08-29 | Tate | Mississippi | 28137 | 3826 | 90 |
1662155 | 1662155 | 2021-08-28 | Tate | Mississippi | 28137 | 3826 | 90 |
1658907 | 1658907 | 2021-08-27 | Tate | Mississippi | 28137 | 3826 | 90 |
1655658 | 1655658 | 2021-08-26 | Tate | Mississippi | 28137 | 3792 | 90 |
1652411 | 1652411 | 2021-08-25 | Tate | Mississippi | 28137 | 3782 | 90 |
1649163 | 1649163 | 2021-08-24 | Tate | Mississippi | 28137 | 3778 | 90 |
1645914 | 1645914 | 2021-08-23 | Tate | Mississippi | 28137 | 3762 | 89 |
1642665 | 1642665 | 2021-08-22 | Tate | Mississippi | 28137 | 3731 | 89 |
1639415 | 1639415 | 2021-08-21 | Tate | Mississippi | 28137 | 3731 | 89 |
1636165 | 1636165 | 2021-08-20 | Tate | Mississippi | 28137 | 3731 | 89 |
1632915 | 1632915 | 2021-08-19 | Tate | Mississippi | 28137 | 3706 | 89 |
1629668 | 1629668 | 2021-08-18 | Tate | Mississippi | 28137 | 3681 | 89 |
1626421 | 1626421 | 2021-08-17 | Tate | Mississippi | 28137 | 3674 | 89 |
1623174 | 1623174 | 2021-08-16 | Tate | Mississippi | 28137 | 3664 | 88 |
1619927 | 1619927 | 2021-08-15 | Tate | Mississippi | 28137 | 3630 | 88 |
1616679 | 1616679 | 2021-08-14 | Tate | Mississippi | 28137 | 3630 | 88 |
1613431 | 1613431 | 2021-08-13 | Tate | Mississippi | 28137 | 3630 | 88 |
1610182 | 1610182 | 2021-08-12 | Tate | Mississippi | 28137 | 3625 | 88 |
1606934 | 1606934 | 2021-08-11 | Tate | Mississippi | 28137 | 3615 | 88 |
1603685 | 1603685 | 2021-08-10 | Tate | Mississippi | 28137 | 3610 | 88 |
1600436 | 1600436 | 2021-08-09 | Tate | Mississippi | 28137 | 3600 | 88 |
1597188 | 1597188 | 2021-08-08 | Tate | Mississippi | 28137 | 3576 | 88 |
1593939 | 1593939 | 2021-08-07 | Tate | Mississippi | 28137 | 3576 | 88 |
1590690 | 1590690 | 2021-08-06 | Tate | Mississippi | 28137 | 3576 | 88 |
1587441 | 1587441 | 2021-08-05 | Tate | Mississippi | 28137 | 3565 | 88 |
1584190 | 1584190 | 2021-08-04 | Tate | Mississippi | 28137 | 3561 | 88 |
1580941 | 1580941 | 2021-08-03 | Tate | Mississippi | 28137 | 3549 | 88 |
1577692 | 1577692 | 2021-08-02 | Tate | Mississippi | 28137 | 3546 | 88 |
1574444 | 1574444 | 2021-08-01 | Tate | Mississippi | 28137 | 3533 | 88 |
1571196 | 1571196 | 2021-07-31 | Tate | Mississippi | 28137 | 3533 | 88 |
1567948 | 1567948 | 2021-07-30 | Tate | Mississippi | 28137 | 3533 | 88 |
1564700 | 1564700 | 2021-07-29 | Tate | Mississippi | 28137 | 3528 | 88 |
1561452 | 1561452 | 2021-07-28 | Tate | Mississippi | 28137 | 3524 | 88 |
1558204 | 1558204 | 2021-07-27 | Tate | Mississippi | 28137 | 3514 | 88 |
1554957 | 1554957 | 2021-07-26 | Tate | Mississippi | 28137 | 3509 | 88 |
1551710 | 1551710 | 2021-07-25 | Tate | Mississippi | 28137 | 3495 | 88 |
1548463 | 1548463 | 2021-07-24 | Tate | Mississippi | 28137 | 3495 | 88 |
1545216 | 1545216 | 2021-07-23 | Tate | Mississippi | 28137 | 3495 | 88 |
1541968 | 1541968 | 2021-07-22 | Tate | Mississippi | 28137 | 3489 | 88 |
1538721 | 1538721 | 2021-07-21 | Tate | Mississippi | 28137 | 3481 | 88 |
1535474 | 1535474 | 2021-07-20 | Tate | Mississippi | 28137 | 3469 | 88 |
1532226 | 1532226 | 2021-07-19 | Tate | Mississippi | 28137 | 3464 | 88 |
1528979 | 1528979 | 2021-07-18 | Tate | Mississippi | 28137 | 3450 | 88 |
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);